County health insurance / DOCUMENTED CSV
2024 County Health Insurance Coverage Reference
Compare insured and uninsured populations across counties, with readable demographic groups, published uncertainty and a ready-to-join county summary.
2024 annual estimates · Census release August 6, 2026 · fixed edition
01 / KNOW THE FIT
A useful join starts
with a clear meaning.
What you can do with it
Enrich a county service-area list for outreach research, grant preparation or market analysis. Compare the number of uninsured people and the uninsured rate, retaining uncertainty and the population definition.
What one row means
county_summary.csv selects one under-65, both-sexes, all-races, all-incomes record per county. county_detail.csv contains one row per year, county, age group, sex and income category. The summary is a documented selection from the detail, not an aggregation.
Unique keycounty_fips
How to join it
Keep county_fips as five-character text. The summary gives one match per county. Before joining detail, select one age_code, sex_code and income_code; overlapping categories otherwise multiply rows and double-count people.
Coverage, with the edges visible
All 358,416 county rows in the retained 2024 source, covering 3,144 county/equivalent identifiers with 114 combinations each. Summary estimates are usable for 3,143 counties; Kalawao County, Hawaii, is explicitly missing. Coverage is the 50 states and DC, with nine Connecticut planning regions. The 44,370 original state rows are excluded with a complete source-row audit. No Puerto Rico or other territories.
Keep in mind
- SAHIE is a model-based annual estimate for the poverty universe, not a patient list, enrollment database, or the full county population. No age-65-plus coverage or insurance-type breakdown.
- Age bands and income groups overlap; do not sum them indiscriminately. Under-19 estimates are both-sex only. County race/ethnicity breakdowns are not supplied.
- Margins of error use 90% confidence. A zero MOE means less than one person or 0.1 percentage point, not certainty. Source rounding can prevent exact reconciliation; point-estimate differences alone do not establish significance.
- The within-income percentages and all-income-denominator percentages answer different questions. Program eligibility is not inferred from these categories.
- County identifiers agree with our 2024 ACS county geography for the 50 states/DC, but SAHIE annual and ACS five-year periods and universes differ. No boundary harmonization, ZIP allocation, hospital mapping or historical series is included.
Retains exact source bytes and lossless staging; preserves FIPS text; decodes category labels; separates county summary and demographic detail; keeps values, source cells and missing statuses; retains every published margin of error. Independent acceptance compares every delivered source-derived cell and accounts for all input rows. How we prepare and version our data →
02 / TRY THE SHAPE
Real rows. Before you buy.
These are the first three rows from the delivered CSV, showing 5 of 29 fields. The free download contains the first five rows and all 29 fields; it is a format sample, not a coverage test.
| county_fips | county_name | uninsured | uninsured_pct | uninsured_pct_moe_90 |
|---|---|---|---|---|
| 01001 | Autauga County | 4094 | 8.1 | 0.9 |
| 01003 | Baldwin County | 19236 | 9.5 | 0.8 |
| 01005 | Barbour County | 1864 | 11.5 | 1.3 |
03 / NO GUESSING
Main table fields, explained.
The main table’s field dictionary from the current download. CSV has no built-in types; these are the intended import types.
| Field | Type | Meaning |
|---|---|---|
year | integer | Year of model-based annual estimate: 2024. |
county_fips | string | Five-character state+county FIPS; import as text. Connecticut uses nine planning regions. |
state_fips | string | Two-character state FIPS; import as text. |
county_name | string | Source county/equivalent name, surrounding padding removed. |
state_name | string | Source state name, surrounding padding removed. |
age_label | string | Readable reviewed Census label for agecat. |
sex_label | string | Readable reviewed Census label for sexcat. |
income_label | string | Readable reviewed Census label for iprcat. |
population | number | People in the poverty universe for this age/sex/income group; not total county population. Blank if source missing; percentages use 0–100 scale. |
population_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
population_moe_90 | number | Published 90% margin of error for population. Zero means <1 person or <0.1 percentage point, not certainty. Blank if source missing; percentages use 0–100 scale. |
population_moe_90_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
uninsured | number | Estimated uninsured people in this selected population. Blank if source missing; percentages use 0–100 scale. |
uninsured_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
uninsured_moe_90 | number | Published 90% margin of error for uninsured. Zero means <1 person or <0.1 percentage point, not certainty. Blank if source missing; percentages use 0–100 scale. |
uninsured_moe_90_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
insured | number | Estimated insured people in this selected population. Blank if source missing; percentages use 0–100 scale. |
insured_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
insured_moe_90 | number | Published 90% margin of error for insured. Zero means <1 person or <0.1 percentage point, not certainty. Blank if source missing; percentages use 0–100 scale. |
insured_moe_90_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
uninsured_pct | number | Uninsured percentage within this selected income group; denominator NIPR. Blank if source missing; percentages use 0–100 scale. |
uninsured_pct_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
uninsured_pct_moe_90 | number | Published 90% margin of error for uninsured_pct. Zero means <1 person or <0.1 percentage point, not certainty. Blank if source missing; percentages use 0–100 scale. |
uninsured_pct_moe_90_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
insured_pct | number | Insured percentage within this selected income group; denominator NIPR. Blank if source missing; percentages use 0–100 scale. |
insured_pct_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
insured_pct_moe_90 | number | Published 90% margin of error for insured_pct. Zero means <1 person or <0.1 percentage point, not certainty. Blank if source missing; percentages use 0–100 scale. |
insured_pct_moe_90_status | string | published, source_missing, or not_applicable_kalawao. Zero is retained when published. |
source_row | integer | One-based data row in the original national CSV, excluding its preamble and header. |
04 / INSIDE THE DOWNLOAD
Data, with its context.
One ZIP · 18.3 MB · 17 files. No account or subscription required.
README.mdImport guidance, method, attribution, and limitationsacceptance.jsonIndependent original-source acceptance evidenceall_tables_dictionary.jsonField definitions for all four tablescategories.csvReviewed age, sex and income code meaningschecksums.jsonSHA-256 checksums for the release filescounty_detail.csvAll 358,416 county demographic rows, decoded categories, source values, availability statuses and 90% MOEscounty_summary.csvMain prepared table · UTF-8 CSVdata_dictionary.jsonTypes and definitions for every fieldexample.pyCopyable notebook-compatible county comparisonexample_input.csvFictional territory names paired with real county FIPSexample_output.txtChecked printed outputexample_result.csvVerified county counts, rates and uncertaintymetadata.jsonSource provenance, production time, counts, and CSV checksumprovenance.jsonRetained source identifiers, URLs and file checksumsquality_report.jsonCoverage, missingness and product-specific quality checksrevision.jsonChanges and free-upgrade eligibility for this ACD revisionsource_row_status.csvOutcome for all 402,786 original source rows
05 / DATES THAT MEAN SOMETHING
Sources, versions & changes.
Source versions identify the inputs. Our processing revision describes how we prepare them. Either kind of change creates a new ACD release; the package date records when it was built.
Current source versions
- Estimate reference year
- 2024 · annual model-based estimates
- Census release date
- August 6, 2026
- Source CSV creation date
- June 23, 2026 · distinct from release date
- Geography
- 3,144 county identifiers; Connecticut planning regions; no Puerto Rico
- ACD capture
- October 17, 2026
- ACD processing revision
- 1 · summary selection and decoded county detail
- Package prepared (UTC)
- Census SAHIE original downloads and file layout
- Census interpretation, uncertainty and comparison guidance
- Census public-access policy
Source: U.S. Census Bureau, SAHIE Program, August 2026, Project P-6000007 / Approval CBDRB-FY26-0241. Original public aggregate statistics are freely available. ACD sells preparation, validation and documentation; no Census endorsement.
RELEASE HISTORY
Oct 17, 2026 · current package (UTC)
First ACD edition of the retained 2024 Census source. Includes county summary and detail, category labels, complete source-row accounting, dictionaries, provenance, independent acceptance and a checked Python example. No prior-release comparison is claimed.
2024 coverage: source and preparation recordProcessing corrections and improvements for your purchased source edition are free. Genuinely new source editions may be sold separately. See the update policy and access instructions.
Check the downloaded CSV’s integrity
The metadata file inside the ZIP records this SHA-256 checksum for county_summary.csv. A matching checksum confirms identical CSV bytes.
2247011b56246e3592f9214e7027dd3b0a9a570646569b37c514efcc0939f3aeREADY TO PUT IT TO WORK?
2024 County Health Insurance Coverage Reference
$29 USD · one time · 3,144 county identifiers