Quarterly Census of Employment and Wages (QCEW) 2019 - Current County Labor and Industry

Prior Dataset for 2016 - 2018 Annual available - <a href=“https://data.pa.gov/Workforce-Development/Quarterly-Census-of-Employment-and-Wages-QCEW-2016/342b-rkgt"> Quarterly Census of Employment and Wages (QCEW) 2016 - 2018 County Labor and Industry</a>

The Quarterly Census of Employment and Wages (QCEW) dataset provides information about the number of establishments within a geographic area by industry as well as the average number of employees and average weekly wages paid. QCEW is the universe of employment covered under Pennsylvania’s unemployment insurance laws. QCEW employment is based on the location of the position not where the person resides.

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 \"pa-gov/quarterly-census-of-employment-and-wages-qcew-2019-bm6e-y9xf\".\"quarterly_census_of_employment_and_wages_qcew_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.