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

Home / Companies / WARREN COUNTY PUBLIC SCHOOLS

WARREN COUNTY PUBLIC 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
WARREN COUNTY PUBLIC SCHOOLS
WARREN COUNTY PUBLIC SCHOOLS, Warren County Public Schools
624FY2019 to FY2020
Latest decision 2020-04-09
2EMERGENCY SUBSTITUTE TEACHER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings6
Certified LCAs6
Denied LCAs0
Role titles2
Worksites4
Latest decision2020-04-09
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
WARREN COUNTY PUBLIC SCHOOLS, Warren County Public SchoolsWARREN COUNTY PUBLIC SCHOOLS, Warren County Public Schoolsdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
EMERGENCY SUBSTITUTE TEACHER25-3098
SUBSTITUTE TEACHERS
4$22,880$22,880
EMERGENCY SUBSTITUTE TEACHER25-3099.00
Teachers and Instructors, All Other
1$29,120$29,120
EMERGENCY SUBSTITUTE TEACHER25-3099.00
Teachers and Instructors, All Other
1$29,120$29,120

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Bowling GreenKY421032122,88022,8802,0192,019
Bowling GreenKY421042122,88022,8802,0192,019
AlvatonKY421221129,12029,1202,0202,020
Bowling GreenKY421031129,12029,1202,0202,020

Full company payload

Company IDcompany:warren county public schools
NameWARREN COUNTY PUBLIC SCHOOLS
Normalized Namewarren county public schools
Source Company Idscompany_dol_oflc_lca_warren_county_board_of_education, company_dol_oflc_lca_warren_county_public_schools, company_uscis_h1b_datahub_warren_county_public_schools_tax_1663
Source NamesWARREN COUNTY PUBLIC SCHOOLS, Warren County Public Schools
AliasesWARREN COUNTY PUBLIC SCHOOLS, Warren County Public Schools
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "WARREN COUNTY PUBLIC SCHOOLS",
    "Warren County Public Schools"
  ],
  "dba_names": [
    "WARREN COUNTY PUBLIC SCHOOLS",
    "Warren County Public Schools"
  ],
  "name_variants": [
    {
      "value": "WARREN COUNTY PUBLIC SCHOOLS",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Warren County Public Schools",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Warren County Public Schools",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WARREN COUNTY PUBLIC SCHOOLS",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1663",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 6,
  "case_count": 6,
  "role_title_count": 2,
  "worksite_count": 4,
  "total_workers": 6,
  "first_fiscal_year": 2019,
  "first_received_date": "2019-03-28",
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2020-04-09",
  "certified_count": 6,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "E-3 Australian",
      "filing_count": 5,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "N",
      "filing_count": 5,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2010",
    "2011"
  ],
  "year_metrics": [
    {
      "cities": [
        "Front Royal"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22630"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_warren_county_public_schools_tax_1663_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_037036"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Front Royal"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22630"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_warren_county_public_schools_tax_1663_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_042832"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "BOWLING GREEN KY 42102",
      "city": "Bowling Green",
      "state": "KY",
      "postal_code": "42102",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "BOWLING GREEN KY 42102",
      "city": "Bowling Green",
      "state": "KY",
      "postal_code": "42102",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ALVATON KY 42122",
      "city": "Alvaton",
      "county": "Warren",
      "state": "KY",
      "postal_code": "42122",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BOWLING GREEN KY 42103",
      "city": "Bowling Green",
      "county": "Warren",
      "state": "KY",
      "postal_code": "42103",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BOWLING GREEN KY 42103",
      "city": "Bowling Green",
      "county": "Warren",
      "state": "KY",
      "postal_code": "42103",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-05-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BOWLING GREEN KY 42104",
      "city": "Bowling Green",
      "county": "Warren",
      "state": "KY",
      "postal_code": "42104",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-05-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 4,
    "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",
    "VA"
  ],
  "cities": [
    "Bowling Green",
    "Alvaton",
    "Front Royal"
  ],
  "postal_codes": [
    "42103",
    "42104",
    "42122",
    "22630"
  ],
  "top_markets": [
    {
      "city": "Bowling Green",
      "state": "KY",
      "postal_code": "42103",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 22880,
      "wage_high_max": 22880,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Bowling Green",
      "state": "KY",
      "postal_code": "42104",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 22880,
      "wage_high_max": 22880,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Alvaton",
      "state": "KY",
      "postal_code": "42122",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 29120,
      "wage_high_max": 29120,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Bowling Green",
      "state": "KY",
      "postal_code": "42103",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 29120,
      "wage_high_max": 29120,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    }
  ]
}
Industry
{
  "naics_codes": [
    "611110",
    "61"
  ],
  "naics_breakdown": [
    {
      "value": "611110",
      "filing_count": 5,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "611110",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 22880,
  "annualized_high_max": 29120,
  "annualized_low_avg": 26624
}
Trend
[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 22880,
    "wage_high_max": 22880,
    "wage_low_avg": 22880
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 29120,
    "wage_high_max": 29120,
    "wage_low_avg": 29120
  }
]
Links
{
  "roles": "/v1/roles?company=WARREN%20COUNTY%20PUBLIC%20SCHOOLS",
  "wages": "/v1/wages?company=WARREN%20COUNTY%20PUBLIC%20SCHOOLS",
  "trends": "/v1/trends?company=WARREN%20COUNTY%20PUBLIC%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=warren+county+public+schools&limit=5JSON