{"main_topic":"census","sub_topic":"sahie","topic":"uninsured","key":"census/sahie/uninsured","version":"1.0.0","year_min":2008,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"census/uninsured/year={year}/{detail}.parquet","grain":["year","county_fips","district_code","tract_geoid","demographic","sex","age_bracket","income_to_poverty"],"title":"Uninsured Rate Under 65 (Census SAHIE)","summary":"Share of Georgians under 65 without health insurance, statewide and for every county, yearly 2008-2024 - Census model-based estimates (SAHIE).","description":"Health insurance coverage of people under 65 from the U.S. Census Bureau's Small Area Health Insurance Estimates (SAHIE), for Georgia and each of its 159 counties, 2008-2024: the share of people without health insurance (the headline uninsured rate), the number uninsured and insured, and the group's size, each with a 90 percent margin of error, by sex, age band and family income relative to the poverty line, and - for the state only - by race/ethnicity. SAHIE estimates are model-based: they combine the American Community Survey with administrative records and population estimates, and are the only single-year uninsured estimates for every county.","explorer":true,"search_aliases":{"en":["uninsured","uninsured rate","insurance","no health insurance","without health insurance","uninsured by income","uninsured by race","uninsured children","health coverage","SAHIE"],"es":["sin seguro","sin seguro médico","no asegurados","asegurados","seguro","seguro de salud","cobertura de salud","falta de seguro","personas sin seguro","niños sin seguro"]},"source":"U.S. Census Bureau, Small Area Health Insurance Estimates (SAHIE)","source_url":"https://api.census.gov/data/timeseries/healthins/sahie","endpoint":"/api/v1/census/uninsured","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Estimate year: the calendar year SAHIE models, from that year's single-year American Community Survey responses combined with administrative records and population estimates (2024 = 2024). An annual series: each year is its own estimate, not a pooled period. Served 2008-2024, the ACS-based SAHIE series; the 2006-2007 estimates (an earlier method based on the Current Population Survey, not comparable) are excluded.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit county FIPS code (state 13 + county). Populated only on county-level rows; NULL on the state rows.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","description":"Always NULL: SAHIE publishes no school-district geography. Kept for the census domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"Always NULL: SAHIE publishes no census-tract geography. Kept for the census domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"Race/ethnicity (state rows only); 'all' is everyone under 65.","description":"Race/ethnicity (FK to the demographics dimension), published by SAHIE for the STATE only: county rows are always 'all'. Mutually exclusive groups: 'hispanic' is Hispanic or Latino of any race; 'white', 'black', 'native_american' (American Indian and Alaska Native), 'asian', 'pacific_islander' (Native Hawaiian and Other Pacific Islander) and 'multiracial' (two or more races) are the not-Hispanic groups; 'all' is everyone. They split Hispanic origin the same way as census/acs/population_by_race but follow the Census Bureau population estimates' race categories, which have no 'some other race' group (those people are counted in a specific race), so they are close to, but not identical with, population_by_race's groups (which include 'other'): do not mix counts from the two topics. 2008-2020 publish only white, black and hispanic (they do not sum to 'all'); from 2021 all seven are published and sum exactly to 'all'. Never published for age_bracket 'under_19'. Sex is on the sex column, not here.","valid_values":["all","white","black","hispanic","native_american","asian","pacific_islander","multiracial"],"example":"hispanic","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"sex","type":"string","role":"categorical","nullable":false,"label":"Sex","short_description":"Sex: all, male or female.","description":"Sex: 'male', 'female', or 'all' (both sexes). A partition: male + female = all for every count (exactly from 2013; within 1 person in 2008-2012 by rounding). Published at state and county level, but not for age_bracket 'under_19' (both sexes only).","valid_values":["all","male","female"],"example":"female","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"age_bracket","type":"string","role":"categorical","nullable":false,"label":"Age Bracket","short_description":"Age band; 'all' is everyone under 65. Bands overlap - never add them.","description":"Age band. 'all' is everyone SAHIE covers: people UNDER 65 (SAHIE publishes nothing for 65 and older). The other bands nest and overlap rather than partition: under_19 (ages 0-18), 18_64, 21_64 (from 2014), 21_29 (from 2024), 40_64, and 50_64 (county rows from 2010; state rows from 2008). 18_64 contains 21_64, 40_64, 50_64 and 21_29, and under_19 and 18_64 both include 18-year-olds, so counts must never be added across bands. under_19 is published for both sexes and all races only.","valid_values":["all","under_19","18_64","21_64","21_29","40_64","50_64"],"example":"18_64","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"income_to_poverty","type":"string","role":"categorical","nullable":false,"label":"Income to Poverty","short_description":"Family income as a percent of the poverty line; 'all' is every income. Ranges overlap - never add them.","description":"Family income as a percent of the federal poverty threshold (the income-to-poverty ratio). 'all' is every income. The others are cumulative or overlapping ranges, not a partition: at_or_below_138_pct, at_or_below_200_pct, at_or_below_250_pct, at_or_below_400_pct, and 138_to_400_pct (above 138% up to 400%, from 2012). Each 'at or below' range contains the lower ones, so counts must never be added across ranges. 138% of poverty is the Affordable Care Act's Medicaid-expansion income limit.","valid_values":["all","at_or_below_138_pct","at_or_below_200_pct","at_or_below_250_pct","at_or_below_400_pct","138_to_400_pct"],"example":"at_or_below_138_pct","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"uninsured_rate","type":"number","role":"metric","nullable":true,"label":"Uninsured Rate (Under 65)","short_description":"Share of people under 65 without health insurance (model-based estimate).","description":"Share of the group without health insurance coverage (0-1): SAHIE's published percent uninsured divided by 100, served as published and never recomputed. A model-based estimate for people under 65. From 2013 it equals num_uninsured / num_population within rounding (0.0005); in 2008-2012 the published percent can differ from the counts' ratio by up to 0.0086 (0.86 points), a property of the source.","valid_values":null,"example":0.14,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"uninsured_rate_moe","type":"number","role":"metric","nullable":true,"label":"Uninsured Rate Margin of Error","short_description":"","description":"90 percent margin of error for uninsured_rate (0-1 scale; the published percent margin / 100): the 90 percent confidence interval is uninsured_rate plus or minus this value (the source's published bounds equal exactly that and are not served). Always positive. Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_uninsured","type":"integer","role":"metric","nullable":true,"label":"Number Uninsured","short_description":"","description":"People in the group without health insurance coverage, as published (model-based estimate) - the rate's numerator.","valid_values":null,"example":1270400,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"num_uninsured_moe","type":"integer","role":"metric","nullable":true,"label":"Number Uninsured Moe","short_description":"","description":"90 percent margin of error for num_uninsured, as published. Always positive.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_population","type":"integer","role":"metric","nullable":true,"label":"Number in Group (Under 65)","short_description":"","description":"People in the group (the age x sex x race group within the income range), as published - the universe and the rate's denominator. On income_to_poverty 'all' rows it is the Census Bureau's population estimate for the group; on income-range rows it is itself a model-based estimate.","valid_values":null,"example":9088938,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_population_moe","type":"integer","role":"metric","nullable":true,"label":"Number Population Moe","short_description":"","description":"90 percent margin of error for num_population, as published. 0 on every income_to_poverty 'all' row: there the group size is a population estimate SAHIE treats as fixed (a control), so the source publishes no model error for it. That 0 does not mean the count is exact, and it does not mean the rate has no uncertainty (uninsured_rate_moe carries that). Positive on every income-range row.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_insured","type":"integer","role":"metric","nullable":true,"label":"Number Insured","short_description":"","description":"People in the group with health insurance coverage, as published (model-based estimate). num_uninsured + num_insured = num_population within 1 person (independent rounding).","valid_values":null,"example":7818538,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_insured_moe","type":"integer","role":"metric","nullable":true,"label":"Number Insured Moe","short_description":"","description":"90 percent margin of error for num_insured, as published. Equal to num_uninsured_moe on income_to_poverty 'all' rows, where the group size is fixed; generally different on income-range rows. Always positive.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"uninsured_rate","numeric_filter_columns":["uninsured_rate","uninsured_rate_moe","num_uninsured","num_uninsured_moe","num_population","num_population_moe","num_insured","num_insured_moe"],"usage":"Star-schema fact table at state and county grain. Join the counties dimension on county_fips (NULL on the state row) and the demographics dimension on demographic; district_code and tract_geoid are always NULL. For the headline under-65 uninsured rate pin demographic, sex, age_bracket and income_to_poverty to 'all', then vary one axis at a time. The rate for several counties together is SUM(num_uninsured) / SUM(num_population) over them, never an average of county rates; never sum across age_bracket or income_to_poverty values. These are model-based estimates: compare places, groups or years against the margins of error. Read directly with DuckDB over Parquet.","limitations":"People UNDER 65 only: SAHIE publishes nothing for ages 65 and older, so uninsured_rate is the under-65 rate (age_bracket 'all' means under 65), not an all-ages rate. Every figure is a Census Bureau model-based estimate, not a direct count. age_bracket and income_to_poverty values overlap: never add across them. Race/ethnicity (demographic) is state-only, never for under_19; native_american, asian, pacific_islander and multiracial start in 2021. Before 2021 only white, black and hispanic are published, so the groups do not sum to 'all' until 2021. The model combines American Community Survey responses with administrative records and population estimates. Not comparable with census/acs/health_insurance_by_citizenship, which covers all ages over a pooled multi-year survey period. year is a single estimate year, an annual series rather than a pooled period: year-to-year change can be read, but judge it against both years' 90 percent margins of error (the *_moe columns). 2008-2024 are served; the 2006-2007 estimates, made with an earlier method based on the Current Population Survey, are not comparable and are excluded. Coverage grows: county 50_64 from 2010, 138_to_400_pct from 2012, 21_64 from 2014, 21_29 from 2024. uninsured_rate is the Census's published percent / 100, never recomputed: from 2013 it equals num_uninsured / num_population within rounding, but in 2008-2012 the published percent can differ from the counts' ratio by up to 0.86 points. County estimates are controlled to the state's, so the 159 counties sum to the state row (exactly from 2013, within 16 people before) and male + female = all. num_population_moe is 0 on every all-incomes row because the group size there is a population estimate SAHIE treats as fixed; that is not a claim the count is exact, and the rate keeps its own margin. SAHIE publishes every cell: there is no suppression and no NULL. The published percent insured (exactly 1 - uninsured_rate, same margin) and the 90 percent confidence bounds (estimate plus or minus the margin) are not served. State and county geography only; there is no school-district or tract geography.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"1d8825bcb02efb02f19cbff7ac9ac8250d3d1e4e3bd0d06c39aa430899ffeb3f","tags":["census","u.s. census bureau, small area health insurance estimates","uninsured"],"granularity_description":"One row per year, county_fips, district_code, tract_geoid, demographic, sex, age_bracket, income_to_poverty (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM uninsured WHERE year = 2024 LIMIT 100"},{"description":"Filter by sex = female","query":"SELECT * FROM uninsured WHERE sex = 'female' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"},{"column":"demographic","target_object":"demographics","target_columns":["demographic"],"attribute_columns_added":["demographic_label","demographic_category"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties","states"],"default":"counties"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["all","white","black","hispanic","native_american","asian","pacific_islander","multiracial"]},{"param":"sex","kind":"categorical","column":"sex","type":"string","multi_value":true,"enum_enforced":true,"values":["all","male","female"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"age_bracket","kind":"categorical","column":"age_bracket","type":"string","multi_value":true,"enum_enforced":true,"values":["all","under_19","18_64","21_64","21_29","40_64","50_64"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"income_to_poverty","kind":"categorical","column":"income_to_poverty","type":"string","multi_value":true,"enum_enforced":true,"values":["all","at_or_below_138_pct","at_or_below_200_pct","at_or_below_250_pct","at_or_below_400_pct","138_to_400_pct"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]},{"param":"demographic_category","kind":"dimension_attribute","dimension":"demographics","column":"demographic_category","type":"string","multi_value":true,"enum_enforced":true,"values":["aggregate","disability","economic_status","esol","foster_care","gender","grade","homeless_status","migrant_status","military","race","sped"]}],"filter_hints":[{"primary":"age_bracket","dependent":"sex","note":"sex 'male' and 'female' do not exist for age_bracket 'under_19': SAHIE publishes under-19 estimates for both sexes only."},{"primary":"age_bracket","dependent":"demographic","note":"race/ethnicity values other than 'all' do not exist for age_bracket 'under_19', and exist only on the state row (SAHIE publishes no county race estimates)."}],"non_additive":[{"column":"age_bracket","reason":"The age bands nest and overlap: 18_64 contains 21_64, 40_64, 50_64 and 21_29, and under_19 and 18_64 both include 18-year-olds, so counts summed across age bands count people more than once. 'all' (everyone under 65) is the total."},{"column":"income_to_poverty","reason":"The income ranges are cumulative and overlap: at_or_below_138_pct is inside at_or_below_200_pct, which is inside at_or_below_250_pct and at_or_below_400_pct, and 138_to_400_pct is inside at_or_below_400_pct, so counts summed across ranges count people more than once. 'all' (every income) is the total."}],"partitions":[],"value_implications":[],"year_meaning":null,"pooled_rates":[],"series_breaks":[],"year_window":null,"pooled_min_count":null,"values_endpoint":"/api/v1/census/uninsured/values"}