ACS5 Sex by Work Experience in the Past 12 Months by Earnings in the Past 12 Months (in 2022 Inflation-Adjusted Dollars) for the Population 16 Years and Over

US Census ACS 5-Year Sex by Work Experience in the Past 12 Months by Earnings in the Past 12 Months (in 2022 Inflation-Adjusted Dollars) for the Population 16 Years and Over. Tidy long-format table: one row per geography, year, and variable. 95 estimate variables per geo/year. Partitioned by geography level. 2009–2024.

economics country/usa economics/country/usa/acs5-b20005 census acs acs5 tidy b-tables usa annual economy

Catalog

Browse and search all available datasets.

Catalog — browse all datasets
GET /api/catalog — catalog in JSON
GET /api/catalog?q=… — search the catalog

Dataset API

Endpoints for this dataset — schema, filter values, preview, and querying.

GET /api/datasets/acs5-b20005 — schema, filters, and pricing
GET /api/datasets/acs5-b20005/sample — free sample (100 rows)
GET /api/datasets/acs5-b20005/members/{col} — valid values for a filterable column
GET /api/datasets/acs5-b20005/query — query with filters (API key required)

Purchase

Add balance or buy access to start querying.

POST /api/checkout/x402 — agents: add balance via x402 (USDC)
Sign in at /account — humans: add balance via Stripe (card, Apple Pay, bank transfer)
POST /api/ap2/intent → /api/ap2/purchase — agents: AP2 mandate-based payment

Source

Name: US Census Bureau — American Community Survey
URL: https://www.census.gov/programs-surveys/acs
License: Public Domain

Size and Format

Rows: 80,560
Columns: 16
Size (bytes): 430,315
Formats: parquet, csv

Pricing

Per query (USD): 0.0100 USD
Max rows per query: 1000
Free: No
Free sample: Yes

Temporal Coverage

end: 2024
start: 2009
frequency: annual

Geographic Coverage

level: multi
coding: GEOID
region: United States (national_state, county)

Query Filters

Columns you can use as query params in GET /api/datasets/acs5-b20005/query.

geo_id Members (JSON)
geo_level Members (JSON)
state_fips Members (JSON)
year Members (JSON)
variable Members (JSON)
node_type Members (JSON)
sex Members (JSON)
dim_2 Members (JSON)
dim_3 Members (JSON)
income_bracket Members (JSON)

Schema (Columns)

Column	Type	Description	Filterable
`geo_id`	string	Standard Census GEOID (FIPS code)	Yes
`geo_name`	string	Human-readable geography name (e.g. "Georgia", "Fannin County, GA")	No
`geo_level`	string	Geography type: "national" \| "state" \| "county"	Yes
`state_fips`	string	2-digit state FIPS code; null for national and zcta rows	Yes
`year`	integer	ACS 5-Year survey ending year	Yes
`survey`	string	ACS product: "acs5"	No
`variable`	string	Census variable code (e.g. "B01001_005E")	Yes
`concept`	string	Table concept — same for all rows in this dataset	No
`label`	string	Human-readable label (e.g. "Male: 5 to 9 years")	No
`node_type`	string	"total" \| "subtotal" \| "leaf" — position in label hierarchy	Yes
`sex`	string	Dimension: sex. Depth 1 label value. (e.g. 'Female', 'Male')	Yes
`dim_2`	string	Depth 2 label value. (e.g. 'Other', 'Worked full-time, year-round in the past 12 months')	Yes
`dim_3`	string	Depth 3 label value. (e.g. 'No earnings', 'With earnings')	Yes
`income_bracket`	string	Dimension: income_bracket. Depth 4 label value. (e.g. '$1 to $2,499 or loss', '$10,000 to $12,499', '$100,000 or more', '$12,500 to $14,999')	Yes
`value`	float	Estimate value (null if suppressed)	No
`moe`	float	Margin of error (null if suppressed)	No

← Back to catalog