ACS5 Family Type by Presence and Age of Related Children Under 18 Years

US Census ACS 5-Year Family Type by Presence and Age of Related Children Under 18 Years. Tidy long-format table: one row per geography, year, and variable. 20 estimate variables per geo/year. Partitioned by geography level. 2009–2024.

social country/usa social/country/usa/acs5-b11004 census acs acs5 tidy b-tables usa annual 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-b11004 — schema, filters, and pricing
GET /api/datasets/acs5-b11004/sample — free sample (100 rows)
GET /api/datasets/acs5-b11004/members/{col} — valid values for a filterable column
GET /api/datasets/acs5-b11004/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: 16,960
Columns: 16
Size (bytes): 99,898
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-b11004/query.

geo_id Members (JSON)
geo_level Members (JSON)
state_fips Members (JSON)
year Members (JSON)
variable Members (JSON)
node_type Members (JSON)
family_type 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
`family_type`	string	Dimension: family_type. Depth 1 label value. (e.g. 'Married-couple family', 'Other family')	Yes
`dim_2`	string	Depth 2 label value. (e.g. 'Female householder, no spouse present', 'Male householder, no spouse present', 'No related children of the householder under 18 years', 'With related children of the householder under 18 years')	Yes
`dim_3`	string	Depth 3 label value. (e.g. '6 to 17 years only', 'No related children of the householder under 18 years', 'Under 6 years and 6 to 17 years', 'Under 6 years only')	Yes
`dim_4`	string	Depth 4 label value. (e.g. '6 to 17 years only', 'Under 6 years and 6 to 17 years', 'Under 6 years only')	Yes
`value`	float	Estimate value (null if suppressed)	No
`moe`	float	Margin of error (null if suppressed)	No

← Back to catalog