ACS5 Median Earnings in the Past 12 Months (in 2022 Inflation-Adjusted Dollars) by Sex by Work Experience in the Past 12 Months for the Population 16 Years and Over With Earnings in the Past 12 Months (American Indian and Alaska Native Alone)

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

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

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-b20017c — schema, filters, and pricing
GET /api/datasets/acs5-b20017c/sample — free sample (100 rows)
GET /api/datasets/acs5-b20017c/members/{col} — valid values for a filterable column
GET /api/datasets/acs5-b20017c/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: 5,936
Columns: 13
Size (bytes): 38,177
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-b20017c/query.

geo_id Members (JSON)
geo_level Members (JSON)
state_fips Members (JSON)
year Members (JSON)
variable Members (JSON)
node_type Members (JSON)
dim_3 Members (JSON)
dim_5 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
`dim_3`	string	Depth 3 label value. (e.g. 'Female --', 'Male --')	Yes
`value`	float	Estimate value (null if suppressed)	No
`moe`	float	Margin of error (null if suppressed)	No

← Back to catalog