Icon for Socrata external plugin
Open repository in Console
Updated 1 year ago
Indexed 34 minutes ago

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


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

See the Splitgraph documentation for more information.

  • jobs_created_by_county_data
Upstream Metadata