Permanent and Labor Conditions Application (H-1B, H-1B1, and E-3) Visa Programs Applications

data.cambridgema.gov | Last Updated 22 Oct 2019

Data about applications submitted by Cambridge employers requesting visas to employee foreign citizens and received by the U. S. Department of Labor through the Labor Condition Application (H1B, H-1B1, and E-3 visas) and the Permanent Labor Certification (PERM visa) programs for federal fiscal years 2014 through 2018. Each row in the data set represents a single employer application. In the LCA program this application can request one or more positions. Employers can make multiple applications during a single year.

Tags: e-3, foreign labor, visa, h1b, h1b1, foreign born, immigrant, perm visa

This dataset has the following 15 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Fiscal YearfynumberFederal fiscal year during which the application was submitted.
Visa Programvisa_programtextVisa program through which application received (LCA for Labor Conditions Application/H1B or PERM for Permanent Visa program)Type of visa (H-1B, H-1B1 or E-3 Australian visa)
StatusstatustextIndicates whether application was certified, withdrawn or denied and for certified application applications whether the application was later withdrawn or expired
SOC Codesoc_codetextOccupational code associated with the job title as classified by the Bureau of Labor Statistics via the Standard Occupational Classification system.
SOC Major Groupsoc_major_grouptextMajor occupation group as classified by the Bureau of Labor Statistics via the Standard Occupational Classification system.
SOC Minor Groupsoc_minor_grouptextMinor occupation group as classified by the Bureau of Labor Statistics via the Standard Occupational Classification system.
SOC Broad Groupsoc_broad_grouptextBroad occupation group, as designated by the SOC system.
SOC Occupationsoc_nametextDetailed occupation as classified by the Bureau of Labor Statistics via the Standard Occupational Classification system.
NAICS Codenaics_codetextIndustry code associated with the employer requesting permanent labor condition, as classified by the North American Industrial Classification System (NAICS).
NAICS Major Industrynaics_major_industrytextMajor industry group, as classified by the first two digits of the NAICS code.
NAICS Minor Industrynaics_minor_industrytextMinor industry group, as classified by the first three digits of the NAICS code.
NAICS Broad Groupnaics_broad_grouptextBroad industry group, as classified by the first two digits of the NAICS code.
Total Workers LCAtotal_workers_lcanumberThe number of employees proposed for hire through LCA application
Prevailing Wageprevailing_wagenumberPrevailing Wage for the job being requested
PW Unit of Paypw_unit_of_paytextUnit of pay for Prevailing Wage. Valid values include Daily (DAI), Hourly (HR), Bi-weekly (BI), Weekly (WK), Monthly (MTH), and Yearly (YR).