schema_version: 3 dataset: name: hh_acs_measures title: Harmonized Historical ACS Measures survey: acs5 moe_level: 90 inflation: file: CPI_2010-2024.csv base_year: 2010 source: https://www.bls.gov/cpi/research-series/r-cpi-u-rs-home.htm notes: - The 2024 annual R-CPI-U-RS value is 462.5, as reported in Census ACS comparison guidance; earlier annual values are retained from the prior input. documentation: https://www.census.gov/programs-surveys/acs/guidance/comparing-acs-data/2024.html notes: - Harmonization applies to measure definitions and year-specific ACS variable mappings; geographic boundaries are not harmonized across years. - Year is the ending year of the five-year ACS estimate, not a single-year estimate. - Output rows are the union of geography identifiers present in the required ACS source tables for each year, within the stated geographic coverage. - Identifiers are retained as published, with no boundary scaffold, crosswalk, or spatial interpolation. The primary key is geography identifier plus ACS year. - Geographic boundaries and identifiers can change between ACS years; an unchanged identifier alone does not guarantee comparable boundaries. - Suppressed or missing ACS values remain missing. A zero denominator yields a missing fraction and MOE. - Inflation-adjusted estimates and MOEs use the same CPI ratio. Revised CPI inputs can change earlier estimates in later releases. - Controlled-estimate MOEs (***** or -555555555) are treated as zero sampling error. - Source MOEs retain the published 90% confidence level. Derived MOEs use these inputs at the same confidence level. - Each measure has an accompanying _moe field in the same units. Rounding rules apply to estimates only; MOEs retain their precision. - Coverage starts in 2010 for tracts. Sequence-based Summary Files are used through 2020, and table-based Summary Files from 2021 onward. source: format: ACS five-year Summary File (sequence-based through 2020; table-based from 2021) first_supported_year: 2010 published_moe_level: 90 documentation: https://www.census.gov/programs-surveys/acs/data/summary-file.html geographies: tract: years: [2010, 2024] id: census_tract_id resource: hh_acs_measures notes: - Each ACS year retains the tract identifiers published in its Summary Files. - Connecticut planning-region identifiers are retained as published from 2022 onward. state_fips: - '01' - '02' - '04' - '05' - '06' - '08' - '09' - '10' - '11' - '12' - '13' - '15' - '16' - '17' - '18' - '19' - '20' - '21' - '22' - '23' - '24' - '25' - '26' - '27' - '28' - '29' - '30' - '31' - '32' - '33' - '34' - '35' - '36' - '37' - '38' - '39' - '40' - '41' - '42' - '44' - '45' - '46' - '47' - '48' - '49' - '50' - '51' - '53' - '54' - '55' - '56' measures: fraction_poverty: title: Fraction of People in Poverty domain: Socioeconomic definition: Fraction of people with income below the poverty level in the past 12 months, among people for whom poverty status is determined units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B17001_002 denominator: B17001_001 notes: [] n_children_lt18: title: Number of Children domain: Population definition: Number of children and adolescents < 18 years of age units: count calculation: count moe_method: Root-sum-of-squares for multiple components, retaining the largest MOE among zero-estimate components; source MOE for one component rounding: method: integer digits: 0 rules: - years: [2010, 2024] variables: - B01001_003 - B01001_004 - B01001_005 - B01001_006 - B01001_027 - B01001_028 - B01001_029 - B01001_030 notes: [] n_pop: title: Number of Total People domain: Population definition: Total population. units: count calculation: count moe_method: Root-sum-of-squares for multiple components, retaining the largest MOE among zero-estimate components; source MOE for one component rounding: method: integer digits: 0 rules: - years: [2010, 2024] variables: B01001_001 notes: [] n_household_lt18: title: Number of Households With Children domain: Population definition: Number of households with children or adolescents < 18 years of age units: count calculation: count moe_method: Root-sum-of-squares for multiple components, retaining the largest MOE among zero-estimate components; source MOE for one component rounding: method: integer digits: 0 rules: - years: [2010, 2024] variables: B11005_002 notes: [] n_household: title: Number of Households domain: Population definition: Total households. units: count calculation: count moe_method: Root-sum-of-squares for multiple components, retaining the largest MOE among zero-estimate components; source MOE for one component rounding: method: integer digits: 0 rules: - years: [2010, 2024] variables: B11005_001 notes: [] fraction_insured: title: Fraction of People Insured domain: Socioeconomic definition: People with health insurance divided by the civilian noninstitutionalized population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2012, 2024] variables: - B27001_004 - B27001_007 - B27001_010 - B27001_013 - B27001_016 - B27001_019 - B27001_022 - B27001_025 - B27001_028 - B27001_032 - B27001_035 - B27001_038 - B27001_041 - B27001_044 - B27001_047 - B27001_050 - B27001_053 - B27001_056 denominator: B27001_001 notes: - Five-year health insurance estimates are available from 2012; earlier years remain missing. fraction_snap: title: Fraction of Households Receiving Assisted Income domain: Socioeconomic definition: Fraction of households receiving public assistance income or food stamps/SNAP in the past 12 months units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B19058_002 denominator: B19058_001 notes: [] fraction_fam_nospouse: title: Fraction of family households with a single householder domain: Population definition: Family households with a male or female householder and no spouse present divided by all family households. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B11001_004 denominator: B11001_002 notes: [] fraction_employment: title: Fraction of People Employed domain: Socioeconomic definition: Fraction of people employed in civilian labor force units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2011, 2024] variables: B23025_004 denominator: B23025_003 notes: - B23025 is available from 2011; 2010 remains missing. n_housing_units: title: Number of Housing Units domain: Housing definition: Housing units are any separate living quarters (e.g., house, apartment, mobile home) either occupied or vacant units: count calculation: count moe_method: Root-sum-of-squares for multiple components, retaining the largest MOE among zero-estimate components; source MOE for one component rounding: method: integer digits: 0 rules: - years: [2010, 2024] variables: B25001_001 notes: [] median_home_value: title: Median Value of Owner-Occupied Housing Units domain: Housing definition: Median value of owner-occupied housing units, in nominal US dollars. units: USD calculation: estimate moe_method: Source MOE rounding: method: significant digits: 3 rules: - years: [2010, 2024] variables: B25077_001 notes: [] median_home_value_2010adj: title: Median Value of Owner-Occupied Housing Units (in 2010 USD) domain: Housing definition: Median value of owner-occupied housing units adjusted to 2010 US dollars using R-CPI-U-RS. units: USD_2010 calculation: inflation_adjusted moe_method: Source MOE scaled by CPI ratio rounding: method: significant digits: 3 rules: - years: [2010, 2024] source_measure: median_home_value notes: [] fraction_housing_renters: title: Fraction of Housing Units Occupied by Renters domain: Housing definition: fraction denominator is number of *occupied* housing units units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B25003_003 denominator: B25003_001 notes: [] median_rent_to_income_percentage: title: Median Rent to Income Percentage domain: Housing definition: The median of the percentage of rent to income among all renter-occupied housing units units: percent calculation: estimate moe_method: Source MOE rounding: method: significant digits: 3 rules: - years: [2010, 2024] variables: B25071_001 notes: [] fraction_high_rent: title: Fraction of Housing Units Paying at least 30% of Income on Rent domain: Housing definition: Renter-occupied housing units paying at least 30% of household income in gross rent divided by all renter-occupied housing units in B25070. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: - B25070_007 - B25070_008 - B25070_009 - B25070_010 denominator: B25070_001 notes: The denominator retains the not-computed rent-to-income category, matching the existing calculation. fraction_conditions: title: Fraction of Housing Units with Substandard Housing Conditions domain: Housing definition: 'substandard housing: incomplete plumbing or kitchens, overcrowding, 30% or more of household income spent on rent or owner costs' units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: - B25123_003 - B25123_004 - B25123_005 - B25123_006 - B25123_009 - B25123_010 - B25123_011 - B25123_012 denominator: B25123_001 notes: [] fraction_builtbf1970: title: Fraction of Housing Units Built Before 1970 domain: Housing definition: Housing units built before 1970 divided by all housing units. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2014] variables: - B25034_007 - B25034_008 - B25034_009 - B25034_010 denominator: B25034_001 - years: [2015, 2024] variables: - B25034_008 - B25034_009 - B25034_010 - B25034_011 denominator: B25034_001 note: A new construction-period category shifts the pre-1970 bins by one position. source: https://api.census.gov/data/2015/acs/acs5/groups/B25034.html notes: [] fraction_vacant: title: Fraction of Housing Units that are Vacant domain: Housing definition: Vacant housing units divided by all housing units. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B25002_003 denominator: B25002_001 notes: [] fraction_nhl: title: Fraction of People Not Hispanic/Latino domain: Population definition: Fraction of People Not Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B03002_002 denominator: B03002_001 notes: [] fraction_nhl_w: title: Fraction of People White and Not Hispanic/Latino domain: Population definition: Fraction of People White and Not Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B03002_003 denominator: B03002_001 notes: [] fraction_nhl_b: title: Fraction of People Black and Not Hispanic/Latino domain: Population definition: Fraction of People Black and Not Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B03002_004 denominator: B03002_001 notes: [] fraction_nhl_o: title: Fraction of People Not Black, Not White, and Not Hispanic/Latino domain: Population definition: Fraction of People Not Black, Not White, and Not Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: - B03002_005 - B03002_006 - B03002_007 - B03002_008 - B03002_009 denominator: B03002_001 notes: The numerator includes the other race categories and people reporting two or more races, matching the existing calculation. fraction_hl: title: Fraction of People Hispanic/Latino domain: Population definition: Fraction of People Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B03002_012 denominator: B03002_001 notes: [] fraction_hl_w: title: Fraction of People White and Hispanic/Latino domain: Population definition: Fraction of People White and Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B03002_013 denominator: B03002_001 notes: [] fraction_hl_b: title: Fraction of People Black and Hispanic/Latino domain: Population definition: Fraction of People Black and Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: B03002_014 denominator: B03002_001 notes: [] fraction_hl_o: title: Fraction of People Not Black, Not White, and Hispanic/Latino domain: Population definition: Fraction of People Not Black, Not White, and Hispanic/Latino divided by the total population. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2010, 2024] variables: - B03002_015 - B03002_016 - B03002_017 - B03002_018 - B03002_019 denominator: B03002_001 notes: The numerator includes the other race categories and people reporting two or more races, matching the existing calculation. fraction_lesh: title: Fraction of Households Speaking Limited English domain: Population definition: Limited English speaking households divided by all households in C16002. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2016, 2024] variables: - C16002_004 - C16002_007 - C16002_010 - C16002_013 denominator: C16002_001 notes: - This measure uses C16002 from 2016; earlier years remain missing. median_income: title: Median Household Income domain: Socioeconomic definition: Median household income in nominal US dollars. units: USD calculation: estimate moe_method: Source MOE rounding: method: significant digits: 3 rules: - years: [2010, 2024] variables: B19013_001 notes: [] median_income_2010adj: title: Median Household Income (in 2010 USD) domain: Socioeconomic definition: Median household income adjusted to 2010 US dollars using R-CPI-U-RS. units: USD_2010 calculation: inflation_adjusted moe_method: Source MOE scaled by CPI ratio rounding: method: significant digits: 3 rules: - years: [2010, 2024] source_measure: median_income notes: [] fraction_hs: title: Fraction of Adults with At Least High School Education domain: Socioeconomic definition: People age 25 years and older with at least a high school diploma or equivalent divided by all people age 25 years and older. units: fraction calculation: proportion moe_method: ACS subset-proportion formula; ratio fallback for negative radicands; numerator MOE divided by denominator when the proportion equals one; component MOEs combined by root-sum-of-squares with the largest MOE retained among zero-estimate components rounding: method: decimal digits: 3 rules: - years: [2012, 2024] variables: - B15003_017 - B15003_018 - B15003_019 - B15003_020 - B15003_021 - B15003_022 - B15003_023 - B15003_024 - B15003_025 denominator: B15003_001 notes: - B15003 is available from 2012; earlier years remain missing.