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

Home / Companies / Mercer County Schools

Mercer County Schools 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
Mercer County Schools
Mercer County Schools, MERCER COUNTY SCHOOLS
652FY2017 to FY2025
Latest decision 2024-11-04
8Secondary Science Teacher
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings6
Certified LCAs6
Denied LCAs0
Role titles5
Worksites2
Latest decision2024-11-04
USCIS approvals8
USCIS denials0

Aliases and source names

AliasesSource NamesSources
Mercer County Schools, MERCER COUNTY SCHOOLSMercer County Schools, MERCER COUNTY SCHOOLSdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Secondary Science Teacher25-2031.00
Secondary School Teachers, Except Special and Career/Technical Education
2$59,468$64,205
HIGH SCHOOL BIOLOGY TEACHER25-20311$56,345$0
High School Math Teacher25-2031.00
Secondary School Teachers, Except Special and Career/Technical Education
1$55,248$55,248
HIGH SCHOOL MATHEMATICS TEACHER25-20311$53,162$0
MUSIC TEACHER25-2021.00
Elementary School Teachers, Except Special Education
1$47,082$47,082

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
HarrodsburgKY403305453,16264,2052,0172,023
BluefieldWV247011147,08247,0822,0252,025

Full company payload

Company IDcompany:mercer county schools
NameMercer County Schools
Normalized Namemercer county schools
Source Company Idscompany_dol_oflc_lca_mercer_county_schools, company_dol_oflc_lca_mercer_county_board_of_education, company_uscis_h1b_datahub_mercer_county_schools_tax_1291
Source NamesMercer County Schools, MERCER COUNTY SCHOOLS
AliasesMercer County Schools, MERCER COUNTY SCHOOLS
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Mercer County Schools",
    "MERCER COUNTY SCHOOLS"
  ],
  "dba_names": [
    "Mercer County Schools"
  ],
  "name_variants": [
    {
      "value": "Mercer County Schools",
      "filing_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MERCER COUNTY SCHOOLS",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Mercer County Schools",
      "filing_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MERCER COUNTY SCHOOLS",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1291",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 6,
  "case_count": 6,
  "role_title_count": 5,
  "worksite_count": 2,
  "total_workers": 6,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-02",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2024-11-04",
  "certified_count": 6,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 8,
  "total_denial": 0,
  "fiscal_years": [
    "2012",
    "2014",
    "2015",
    "2017",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Harrodsburg"
      ],
      "states": [
        "KY"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "40330"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mercer_county_schools_tax_1291_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_042408"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Harrodsburg"
      ],
      "states": [
        "KY"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "40330"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mercer_county_schools_tax_1291_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_043580"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Harrodsburg"
      ],
      "states": [
        "KY"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "40330"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mercer_county_schools_tax_1291_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_037955"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Harrodsburg"
      ],
      "states": [
        "KY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "40330"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mercer_county_schools_tax_1291_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_038249"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Harrodsburg"
      ],
      "states": [
        "KY"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "40330"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mercer_county_schools_tax_1291_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_031016"
      ],
      "continuing_approval": 2
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "PRINCETON WV 24740",
      "city": "Princeton",
      "state": "WV",
      "postal_code": "24740",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-11-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "HARRODSBURG KY 40330",
      "city": "Harrodsburg",
      "state": "KY",
      "postal_code": "40330",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "BLUEFIELD WV 24701",
      "city": "Bluefield",
      "county": "Mercer",
      "state": "WV",
      "postal_code": "24701",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-11-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HARRODSBURG KY 40330",
      "city": "Harrodsburg",
      "county": "Mercer",
      "state": "KY",
      "postal_code": "40330",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 2,
    "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": [
    "KY",
    "WV"
  ],
  "cities": [
    "Harrodsburg",
    "Bluefield"
  ],
  "postal_codes": [
    "40330",
    "24701"
  ],
  "top_markets": [
    {
      "city": "Harrodsburg",
      "state": "KY",
      "postal_code": "40330",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 53162,
      "wage_high_max": 64205,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Bluefield",
      "state": "WV",
      "postal_code": "24701",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 47082,
      "wage_high_max": 47082,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    }
  ]
}
Industry
{
  "naics_codes": [
    "611110",
    "61"
  ],
  "naics_breakdown": [
    {
      "value": "611110",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "611110",
      "filing_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 47082,
  "annualized_high_max": 64205,
  "annualized_low_avg": 52383.8
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 53162,
    "wage_high_max": 0,
    "wage_low_avg": 54753.5
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 55248,
    "wage_high_max": 59468,
    "wage_low_avg": 57358
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 64205,
    "wage_high_max": 64205,
    "wage_low_avg": 64205
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 47082,
    "wage_high_max": 47082,
    "wage_low_avg": 47082
  }
]
Links
{
  "roles": "/v1/roles?company=Mercer%20County%20Schools",
  "wages": "/v1/wages?company=Mercer%20County%20Schools",
  "trends": "/v1/trends?company=Mercer%20County%20Schools"
}
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=mercer+county+schools&limit=5JSON