ACS5 Poverty Status in the Past 12 Months of Families by Family Type by Social Security Income by Supplemental Security Income (SSI) and Cash Public Assistance Income

US Census ACS 5-Year Poverty Status in the Past 12 Months of Families by Family Type by Social Security Income by Supplemental Security Income (SSI) and Cash Public Assistance Income. Tidy long-format table: one row per geography, year, and variable. 47 estimate variables per geo/year. Partitioned by geography level. 2009–2024.

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

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-b17015 — schema, filters, and pricing
GET /api/datasets/acs5-b17015/sample — free sample (100 rows)
GET /api/datasets/acs5-b17015/members/{col} — valid values for a filterable column
GET /api/datasets/acs5-b17015/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: 39,856
Columns: 16
Size (bytes): 219,758
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-b17015/query.

geo_id Members (JSON)
geo_level Members (JSON)
state_fips Members (JSON)
year Members (JSON)
variable Members (JSON)
node_type Members (JSON)
poverty_status Members (JSON)
family_type Members (JSON)
dim_3 Members (JSON)
dim_4 Members (JSON)
public_assistance_income 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
`poverty_status`	string	Dimension: poverty_status. Depth 1 label value. (e.g. 'Income in the past 12 months at or above poverty level', 'Income in the past 12 months below poverty level')	Yes
`family_type`	string	Dimension: family_type. Depth 2 label value. (e.g. 'Married-couple family', 'Other family')	Yes
`dim_3`	string	Depth 3 label value. (e.g. 'Female householder, no spouse present', 'Male householder, no spouse present', 'With Social Security income in the past 12 months', 'Without Social Security income in the past 12 months')	Yes
`dim_4`	string	Depth 4 label value. (e.g. 'With SSI and/or cash public assistance income in the past 12 months', 'With Social Security income in the past 12 months', 'Without SSI or cash public assistance income in the past 12 months', 'Without Social Security income in the past 12 months')	Yes
`value`	float	Estimate value (null if suppressed)	No
`moe`	float	Margin of error (null if suppressed)	No

← Back to catalog