Icon for Socrata external plugin
Open repository in Console
Updated 2 months ago
Indexed 5 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/permanent-and-labor-conditions-application-h1b-fmbp-nphb\".\"permanent_and_labor_conditions_application_h1b\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • permanent_and_labor_conditions_application_h1b
Upstream Metadata