{"slug":"acs5-b20017f","name":"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 (Some Other Race Alone)","domain":"economics","scope":"country","geo":"usa","path":"economics/country/usa/acs5-b20017f","description":"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 (Some Other Race Alone). Tidy long-format table: one row per geography, year, and variable. 7 estimate variables per geo/year. Partitioned by geography level. 2009–2024.","tags":["census","acs","acs5","tidy","b-tables","usa","annual","economy","race_ethnicity"],"formats":["parquet","csv"],"size":{"rows":5936,"cols":13,"bytes":37729},"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","dim_3","dim_5"],"urls":{"detail":"/api/datasets/acs5-b20017f","sample":"/api/datasets/acs5-b20017f/sample","query":"/api/datasets/acs5-b20017f/query","checkout":"/api/checkout/x402"},"schema":[{"name":"geo_id","type":"string","filterable":true,"description":"Standard Census GEOID (FIPS code)","members_url":"/api/datasets/acs5-b20017f/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-b20017f/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-b20017f/members/state_fips"},{"name":"year","type":"integer","filterable":true,"description":"ACS 5-Year survey ending year","members_url":"/api/datasets/acs5-b20017f/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-b20017f/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-b20017f/members/node_type"},{"name":"dim_3","type":"string","filterable":true,"description":"Depth 3 label value. (e.g. 'Female --', 'Male --')","members_url":"/api/datasets/acs5-b20017f/members/dim_3"},{"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"}}