bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / Franklin College

Franklin College H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Franklin College
FRANKLIN COLLEGE
1891FY2017 to FY2025
Latest decision 2025-04-04
11Assistant Professor of Chemistry
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings18
Certified LCAs18
Denied LCAs0
Role titles9
Worksites1
Latest decision2025-04-04
USCIS approvals11
USCIS denials0

Aliases and source names

AliasesSource NamesSources
FRANKLIN COLLEGEFranklin College, FRANKLIN COLLEGEdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Assistant Professor of Chemistry25-1052.00
Chemistry Teachers, Postsecondary
2$47,000$60,400
Assistant Professor of Economics25-1063.00
Economics Teachers, Postsecondary
2$59,030$64,030
Assistant Professor of Economics and Business25-1063.00
Economics Teachers, Postsecondary
2$59,030$64,030
Asst. Director of Admissions for International Recruitment21-1012.00
Educational, Guidance, School, and Vocational Counselors
2$42,000$52,000
Lecturer of Psychology25-1066.00
Psychology Teachers, Postsecondary
2$48,500$53,500
Visiting Assistant Professor of Philosophy25-1126.00
Philosophy and Religion Teachers, Postsecondary
2$52,160$57,160
ASSISTANT PROFESSOR OF CHEMISTRY25-10521$47,000$57,000
ASSISTANT PROFESSOR OF PHYSICS25-10541$56,100$58,100
ASSISTANT PROFESSOR OF SOCIOLOGY25-10671$51,740$54,740
Assistant Professor of Sociology25-1067.00
Sociology Teachers, Postsecondary
1$58,330$60,330

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
FranklinIN4613118942,00074,7222,0172,025

Full company payload

Company IDcompany:franklin college
NameFranklin College
Normalized Namefranklin college
Source Company Idscompany_dol_oflc_lca_franklin_college, company_uscis_h1b_datahub_franklin_college_tax_8086
Source NamesFranklin College, FRANKLIN COLLEGE
AliasesFRANKLIN COLLEGE
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Franklin College",
    "FRANKLIN COLLEGE"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Franklin College",
      "filing_count": 15,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "FRANKLIN COLLEGE",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "FRANKLIN COLLEGE",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8086",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 18,
  "case_count": 18,
  "role_title_count": 9,
  "worksite_count": 1,
  "total_workers": 18,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-02-22",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-04-04",
  "certified_count": 18,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 12,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 3,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 18,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 18,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 11,
  "total_denial": 0,
  "fiscal_years": [
    "2009",
    "2013",
    "2014",
    "2017",
    "2018",
    "2020",
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_033354"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_027184"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_027019"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_020394"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_022150"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_018652"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_020455"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Franklin"
      ],
      "states": [
        "IN"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "46131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_franklin_college_tax_8086_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_020376"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "FRANKLIN IN 46131",
      "city": "Franklin",
      "state": "IN",
      "postal_code": "46131",
      "filing_count": 13,
      "case_count": 13,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-04-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FRANKLIN  46131",
      "city": "Franklin",
      "postal_code": "46131",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-06-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "FRANKLIN IN 46131",
      "city": "Franklin",
      "county": "Johnson",
      "state": "IN",
      "postal_code": "46131",
      "filing_count": 18,
      "case_count": 18,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-04-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 1,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}
Geography
{
  "states": [
    "IN"
  ],
  "cities": [
    "Franklin"
  ],
  "postal_codes": [
    "46131"
  ],
  "top_markets": [
    {
      "city": "Franklin",
      "state": "IN",
      "postal_code": "46131",
      "lca_count": 18,
      "role_title_count": 9,
      "wage_low_min": 42000,
      "wage_high_max": 74722,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025
    }
  ]
}
Industry
{
  "naics_codes": [
    "611310",
    "61"
  ],
  "naics_breakdown": [
    {
      "value": "611310",
      "filing_count": 18,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 42000,
  "annualized_high_max": 74722,
  "annualized_low_avg": 53651.7777777778
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 51740,
    "wage_high_max": 58100,
    "wage_low_avg": 53920
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 47000,
    "wage_high_max": 57000,
    "wage_low_avg": 47000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 58330,
    "wage_high_max": 60330,
    "wage_low_avg": 58330
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 47000,
    "wage_high_max": 57000,
    "wage_low_avg": 47000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 42000,
    "wage_high_max": 52000,
    "wage_low_avg": 42000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 42000,
    "wage_high_max": 69000,
    "wage_low_avg": 50500
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 55400,
    "wage_high_max": 60400,
    "wage_low_avg": 55400
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 48500,
    "wage_high_max": 57160,
    "wage_low_avg": 50330
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 48500,
    "wage_high_max": 64030,
    "wage_low_avg": 56924
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 69722,
    "wage_high_max": 74722,
    "wage_low_avg": 69722
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 52160,
    "wage_high_max": 57160,
    "wage_low_avg": 52160
  }
]
Links
{
  "roles": "/v1/roles?company=Franklin%20College",
  "wages": "/v1/wages?company=Franklin%20College",
  "trends": "/v1/trends?company=Franklin%20College"
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=franklin+college&limit=5JSON