Icon for Socrata external plugin
Open repository in Console
Updated 24 days ago
Indexed 2 hours ago

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

Prior Dataset for 2016 - 2018 Annual available - <a href=“"> 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 \
    -H "Content-Type: application/json" \
{"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 

See the Splitgraph documentation for more information.

  • quarterly_census_of_employment_and_wages_qcew_2019
Upstream Metadata