CT Department of Labor, Office of Research - LAUS Substate March 2023

The Local Area Unemployment Statistics (LAUS) program produces monthly employment, unemployment, and labor force data for Census regions and divisions, States, counties, metropolitan areas, and many cities, by place of residence. The LAUS program is a federal-state cooperative endeavor in which states develop state and sub-state data using concepts, definitions, and technical procedures prescribed by the Bureau of Labor Statistics (BLS). A major source of labor force data estimates, the Current Population Survey (CPS) includes a sample of over 1,600 Connecticut households each month regarding the labor force status of their occupants

Further information from the CT Department of Labor is available here: https://www1.ctdol.state.ct.us/lmi/LAUS/default.asp

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 \"ct-gov/ct-department-of-labor-office-of-research-laus-nfe2-aprv\".\"ct_department_of_labor_office_of_research_laus\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.