County employment and wages (QCEW)

Chart

Use the API

Each series and location is its own small file. The examples follow the series and location picked above. See the docs for versions, caching and errors.

# One series for one place (.json or .csv)
curl -s "https://api.economicdata.dev/v1/qcew/total-covered/usa.json"

# Every series and place in one file
curl -sO "https://api.economicdata.dev/v1/qcew/download/qcew.csv"

import polars as pl

# One series for one place
df = pl.read_csv("https://api.economicdata.dev/v1/qcew/total-covered/usa.csv")

# Every series and place, with series and location columns
everything = pl.read_parquet("https://api.economicdata.dev/v1/qcew/download/qcew.parquet")

const res = await fetch("https://api.economicdata.dev/v1/qcew/total-covered/usa.json");
if (!res.ok) throw new Error((await res.json()).detail); // errors are problem+json
const { meta, data } = await res.json();
console.log(meta.location_name, data.at(-1)); // { date, value, ... }

Downloads

The whole dataset in one file, with series and location columns. Parquet keeps the column types and is much smaller.

• qcew.csv CSV
• qcew.parquet Parquet

Schema and series

Each series file has these columns. The bulk downloads add series and location columns in front.

Series

Locations

Covers all 57 US states and equivalents (ids: us- plus the USPS code (us-ca, us-dc)); all 3,222 US counties and equivalents (ids: us-county- plus the 5-digit FIPS code); 15 more named places.

Place names come from the shared location registry; see Sources.

Source and license

Source

BLS Quarterly Census of Employment and Wages (QCEW) open-data CSV slices

Publisher

U.S. Bureau of Labor Statistics

License

US Government work (public domain in the United States) (LicenseRef-US-Government-Work)

Commercial use

Allowed

Credit the source with this exact text:

Checked every 1 day. If the source hasn't changed in 120 days, the status page flags it as stale.

Endpoints

Every URL for this dataset. To pin the current version, put it after the id: /v1/qcew@<version>. The API reference describes each response.