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.