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

QCEW by NAICS (2 level) and Towns

Quarterly Census of Employment and Wages (QCEW) by NAICS (2 level) and Towns.

Source: Connecticut Department of Labor Quarterly Census of Employment and Wages (QCEW). QCEW data is regularly reviewed to correct and/or update industry (NAICS) codes that no longer reflect the ongoing business activity of a firm. Because of these corrections, in some cases changes from year to year may over or understate the actual changes occurring within the industry sector. Any questions regarding this data may directed to dol.lmi@ct.gov

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" \
{"sql": "
    SELECT *
    FROM \"ct-gov/qcew-by-naics-2-level-and-towns-7zu6-8dcr\".\"qcew_by_naics_2_level_and_towns\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • qcew_by_naics_2_level_and_towns
Upstream Metadata