Jobs Created by County Data

Dataset showing job creation and job destruction. A negative number indicates jobs destroyed (positions eliminated due to businesses closing or contracting). Job creation is employment resulting from new businesses starting up or existing businesses expanding their payrolls with new positions. The source data for the data is the Longitudinal Employer-Household Dynamics (LEHD) linked employer employee microdata. A wide variety of record sources contribute to the construction of the Quarterly Workforce Indicators (QWI), including the administrative records

on employment collected by the states, Social Security data, Federal tax records, and other census and survey

data.

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 \"ramseycounty-us/jobs-created-by-county-data-ceb9-fb78\".\"jobs_created_by_county_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.