cambridgema-gov/permanent-and-labor-conditions-application-h1b-fmbp-nphb
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 21 days ago
Indexed 22 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 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.

 
Preview
  • permanent_and_labor_conditions_application_h1b
     
     
     
     
     
Upstream Metadata