Local Area Unemployment Statistics
The Local Area Unemployment Statistics (LAUS) program is a federal-state cooperative effort which produces monthly estimates of produces monthly and annual employment, unemployment, and labor force data for approximately 7,000 areas including Census regions and divisions, States, counties, metropolitan areas, and many cities.
This dataset includes data for all 50 states, the District of Columbia, and Puerto Rico. To only see data for Connecticut, create a filter where "State name" is equal to "Connecticut".
For more information on the LAUS program and data visit: https://www.bls.gov/lau/
For more information from the CT Department of Labor visit: 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/local-area-unemployment-statistics-8b8f-kk4q\".\"local_area_unemployment_statistics\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.