Permanent and Labor Conditions Application (H-1B, H-1B1, and E-3) Visa Programs Applications
Data about applications submitted by Cambridge employers requesting visas to employ 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 2022.
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.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"cambridgema-gov/permanent-and-labor-conditions-application-h1b-fmbp-nphb\".\"permanent_and_labor_conditions_application_h1b\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.