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

Data about applications submitted by employers requesting visas to employ foreign citizens in Cambridge, MA and received by the U.S. Department of Labor through the Labor Condition Application (LCA) and the Permanent Labor Certification (PERM) programs. The LCA program covers H-1B, H-1B1 and E-3 visas.

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-perm-and-labor-condition-application-h1b-fmbp-nphb\".\"permanent_perm_and_labor_condition_application_h1b\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.