{"slug":"acs5-b05009","name":"ACS5 Age and Nativity of Own Children Under 18 Years in Families and Subfamilies by Number and Nativity of Parents","domain":"social","scope":"country","geo":"usa","path":"social/country/usa/acs5-b05009","description":"US Census ACS 5-Year Age and Nativity of Own Children Under 18 Years in Families and Subfamilies by Number and Nativity of Parents. Tidy long-format table: one row per geography, year, and variable. 37 estimate variables per geo/year. Partitioned by geography level. 2009–2024.","tags":["census","acs","acs5","tidy","b-tables","usa","annual","family","migration"],"formats":["parquet","csv"],"size":{"rows":29415,"cols":16,"bytes":165602},"pricing":{"per_query_usd":0.01,"max_rows_per_query":1000,"free":false,"sample_free":true},"temporal_coverage":{"end":"2024","start":"2009","frequency":"annual"},"geographic_coverage":{"level":"multi","coding":"GEOID","region":"United States (national_state, county)"},"query_filters":["geo_id","geo_level","state_fips","year","variable","node_type","age","dim_2","dim_3","dim_4"],"urls":{"detail":"/api/datasets/acs5-b05009","sample":"/api/datasets/acs5-b05009/sample","query":"/api/datasets/acs5-b05009/query","checkout":"/api/checkout/x402"},"schema":[{"name":"geo_id","type":"string","filterable":true,"description":"Standard Census GEOID (FIPS code)","members_url":"/api/datasets/acs5-b05009/members/geo_id"},{"name":"geo_name","type":"string","filterable":false,"description":"Human-readable geography name (e.g. \"Georgia\", \"Fannin County, GA\")"},{"name":"geo_level","type":"string","filterable":true,"description":"Geography type: \"national\" | \"state\" | \"county\"","members_url":"/api/datasets/acs5-b05009/members/geo_level"},{"name":"state_fips","type":"string","filterable":true,"description":"2-digit state FIPS code; null for national and zcta rows","members_url":"/api/datasets/acs5-b05009/members/state_fips"},{"name":"year","type":"integer","filterable":true,"description":"ACS 5-Year survey ending year","members_url":"/api/datasets/acs5-b05009/members/year"},{"name":"survey","type":"string","filterable":false,"description":"ACS product: \"acs5\""},{"name":"variable","type":"string","filterable":true,"description":"Census variable code (e.g. \"B01001_005E\")","members_url":"/api/datasets/acs5-b05009/members/variable"},{"name":"concept","type":"string","filterable":false,"description":"Table concept — same for all rows in this dataset"},{"name":"label","type":"string","filterable":false,"description":"Human-readable label (e.g. \"Male: 5 to 9 years\")"},{"name":"node_type","type":"string","filterable":true,"description":"\"total\" | \"subtotal\" | \"leaf\" — position in label hierarchy","members_url":"/api/datasets/acs5-b05009/members/node_type"},{"name":"age","type":"string","filterable":true,"description":"Dimension: age. Depth 1 label value. (e.g. '6 to 17 years', 'Under 6 years')","members_url":"/api/datasets/acs5-b05009/members/age"},{"name":"dim_2","type":"string","filterable":true,"description":"Depth 2 label value. (e.g. 'Living with one parent', 'Living with two parents')","members_url":"/api/datasets/acs5-b05009/members/dim_2"},{"name":"dim_3","type":"string","filterable":true,"description":"Depth 3 label value. (e.g. 'Both parents foreign born', 'Both parents native', 'Child is foreign born', 'Child is native')","members_url":"/api/datasets/acs5-b05009/members/dim_3"},{"name":"dim_4","type":"string","filterable":true,"description":"Depth 4 label value. (e.g. 'Child is foreign born', 'Child is native')","members_url":"/api/datasets/acs5-b05009/members/dim_4"},{"name":"value","type":"float","filterable":false,"description":"Estimate value (null if suppressed)"},{"name":"moe","type":"float","filterable":false,"description":"Margin of error (null if suppressed)"}],"source":{"url":"https://www.census.gov/programs-surveys/acs","name":"US Census Bureau — American Community Survey","license":"Public Domain"}}