ACS5 Sex by Work Status in the Past 12 Months by Usual Hours Worked per Week in the Past 12 Months by Weeks Worked in the Past 12 Months for the Population 16 to 64 Years

US Census ACS 5-Year Sex by Work Status in the Past 12 Months by Usual Hours Worked per Week in the Past 12 Months by Weeks Worked in the Past 12 Months for the Population 16 to 64 Years. Tidy long-format table: one row per geography, year, and variable. 49 estimate variables per geo/year. Partitioned by geography level. 2009–2024.

economics country/usa economics/country/usa/acs5-b23022 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-b23022 — schema, filters, and pricing
GET /api/datasets/acs5-b23022/sample — free sample (100 rows)
GET /api/datasets/acs5-b23022/members/{col} — valid values for a filterable column
GET /api/datasets/acs5-b23022/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: 41,552
Columns: 16
Size (bytes): 231,158
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-b23022/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)
dim_4 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. 'Did not work in the past 12 months', 'Worked in the past 12 months')	Yes
`dim_3`	string	Depth 3 label value. (e.g. 'Usually worked 1 to 14 hours per week', 'Usually worked 15 to 34 hours per week', 'Usually worked 35 or more hours per week')	Yes
`dim_4`	string	Depth 4 label value. (e.g. '1 to 13 weeks', '14 to 26 weeks', '27 to 39 weeks', '40 to 47 weeks')	Yes
`value`	float	Estimate value (null if suppressed)	No
`moe`	float	Margin of error (null if suppressed)	No

← Back to catalog