###
`hamilton_drivetime`

A census tract-level measure of drive time to Cincinnati Children’s Hospital Medical Center is derived using 6-minute interval drive time isochrones obtained from openroute service. Each tract-level drive time is an area-weighted average of drive times.

## Table schema:

name | type | title | description |
---|---|---|---|

census_tract_id_2010 | string | Census tract identifier | |

drive_time_avg | number | Average drivetime to CCHMC | |

year | number | Isochrones were obtained in 2022, but these rarely change over time (absent changes to major roadways) |

###
`hamilton_landcover`

Greenspace, imperviousness, treecanopy, and greenness (EVI) for all tracts in Hamilton County

## Table schema:

name | type | title | description |
---|---|---|---|

census_tract_id_2010 | string | ||

pct_green_2019 | number | Percent Greenspace 2019 | percent of pixels in each tract classified as green |

pct_impervious_2019 | number | Percent Impervious 2019 | average percent imperviousness for pixels in each tract |

pct_treecanopy_2016 | number | Percent Treecanopy 2016 | average percent tree canopy for pixels in each tract |

evi_2018 | number | Enhanced Vegetation Index 2018 | average enhanced vegetation index for pixels in each tract |

year | number | Year | The actual year is unique to each data product and denoted in the field names |

###
`hamilton_property_code_enforcement`

Number of property code enforcements per household by census tract

## Table schema:

name | type | title | description |
---|---|---|---|

census_tract_id_2010 | string | census tract identifier | |

violations_per_household | number | number of property code enforcements per household | |

year | number | Year | data year |

###
`hamilton_traffic`

Number and fraction of parcels and households near traffic by census tract

## Table schema:

name | type | title | description |
---|---|---|---|

census_tract_id_2010 | string | ||

n_parcels | integer | Number of Parcels | number of parcels in tract |

n_parcels_near_traffic | integer | Number of Parcels Near Traffic | number of parcels within 400 m of roads with non-zero average annual daily traffic |

n_parcels_near_truck_traffic | integer | Number of Parcels Near Truck Traffic | number of parcels within 400 m of roads with non-zero average annual daily truck traffic |

n_households | number | Number of Households | number of households in tract |

n_households_near_traffic | number | Number of Households Near Traffic | number of households within 400 m of roads with non-zero average annual daily traffic |

n_households_near_truck_traffic | number | Number of Households Near Truck Traffic | number of households within 400 m of roads with non-zero average annual daily truck traffic |

median_parcel_traffic | number | Median Parcel Traffic | median average annual daily traffic within 400 m of each parcel (vehicle-meters) |

median_household_traffic | number | Median Household Traffic | median average annual daily traffic within 400 m of each household (truck-meters) |

median_parcel_truck_traffic | number | Median Parcel Truck Traffic | median average annual daily truck traffic within 400 m of each parcel (vehicle-meters) |

median_household_truck_traffic | number | Median Household Truck Traffic | median average annual daily truck traffic within 400 m of each household (truck-meters) |

frac_households_near_traffic | number | Fraction of Households Near Traffic | fraction of households within 400 m of roads with non-zero average annual daily traffic |

frac_parcels_near_traffic | number | Fraction of Parcels Near Traffic | fraction of parcels within 400 m of roads with non-zero average annual daily traffic |

frac_households_near_truck_traffic | number | Fraction of Households Near Truck Traffic | fraction of households within 400 m of roads with non-zero average annual daily truck traffic |

frac_parcels_near_truck_traffic | number | Fraction of Parcels Near Truck Traffic | fraction of parcels within 400 m of roads with non-zero average annual daily truck traffic |

year | number |

###
`hh_acs_measures`

2010 - 2021 measures derived from ACS variables for census tracts in the contiguous US

## Table schema:

name | type | title | description |
---|---|---|---|

census_tract_id_2010 | string | ||

year | integer | Year | The year of the 5-year ACS estimates (e.g., the 2019 ACS covers 2015 - 2019) |

fraction_poverty | number | Fraction of Households in Poverty | Fraction of households with income below poverty level within the past 12 months |

fraction_poverty_moe | number | ||

n_children_lt18 | integer | ||

n_children_lt18_moe | integer | ||

n_pop | integer | ||

n_pop_moe | integer | ||

n_household_lt18 | integer | ||

n_household_lt18_moe | integer | ||

n_household | integer | ||

n_household_moe | integer | ||

fraction_insured | number | Fraction of People Insured | Fraction of population with health insurance (available from 2012 onwards only) |

fraction_insured_moe | number | ||

fraction_snap | number | Fraction of Households Receiving Assisted Income | Fraction of households receiving public assistance income or food stamps/SNAP in the past 12 months |

fraction_snap_moe | number | ||

fraction_fam_nospouse | number | Fraction of family households with a single householder | Single householder is male or female household, with no spouse present |

fraction_fam_nospouse_moe | number | ||

fraction_employment | number | Fraction of People Employed | Fraction of people employed in civilian labor force |

fraction_employment_moe | number | ||

n_housing_units | integer | ||

n_housing_units_moe | integer | ||

median_home_value | number | Median Value of Owner-Occupied Housing Units | |

median_home_value_moe | number | ||

median_home_value_2010adj | number | Median Value of Owner-Occupied Housing Units (in 2010 USD) | |

fraction_housing_renters | number | Fraction of Housing Units Occupied by Renters | fraction denominator is number of occupied
housing units |

fraction_housing_renters_moe | number | ||

median_rent_to_income_percentage | number | Median Rent to Income Percentage | The median of the percentage of rent to income among all renter-occupied housing units |

median_rent_to_income_percentage_moe | number | ||

fraction_high_rent | number | Fraction of Housing Units Paying at least 30% of Income on Rent | |

fraction_high_rent_moe | number | ||

fraction_conditions | number | Fraction of Housing Units with Substandard Housing Conditions | substandard housing: incomplete plumbing or kitchens, overcrowding, 30% or more of household income spent on rent or owner costs |

fraction_conditions_moe | number | ||

fraction_builtbf1970 | number | Fraction of Housing Units Built Before 1970 | |

fraction_builtbf1970_moe | number | ||

fraction_vacant | number | Fraction of Housing Units that are Vacant | |

fraction_vacant_moe | number | ||

fraction_nhl | number | Fraction of People Not Hispanic/Latino | |

fraction_nhl_moe | number | ||

fraction_nhl_w | number | Fraction of People White and Not Hispanic/Latino | |

fraction_nhl_w_moe | number | ||

fraction_nhl_b | number | Fraction of People Black and Not Hispanic/Latino | |

fraction_nhl_b_moe | number | ||

fraction_nhl_o | number | Fraction of People Not Black, Not White, and Not Hispanic/Latino | |

fraction_nhl_o_moe | number | ||

fraction_hl | number | Fraction of People Hispanic/Latino | |

fraction_hl_moe | number | ||

fraction_hl_w | number | Fraction of People White and Hispanic/Latino | |

fraction_hl_w_moe | number | ||

fraction_hl_b | number | Fraction of People Black and Hispanic/Latino | |

fraction_hl_b_moe | number | ||

fraction_hl_o | number | Fraction of People Not Black, Not White, and Hispanic/Latino | |

fraction_hl_o_moe | number | ||

fraction_lesh | number | Fraction of Households Speaking Limited English | Available from 2016 onwards |

fraction_lesh_moe | number | ||

median_income | number | Median Household Income | |

median_income_moe | number | ||

median_income_2010adj | number | Median Household Income (in 2010 USD) | |

fraction_hs | number | Fraction of Adults with At Least High School Education | Available from 2012 onwards |

fraction_hs_moe | number |

###
`tract_indices`

A collection of census-derived indices for all census tracts in the U.S.

## Table schema:

name | type | title | description |
---|---|---|---|

census_tract_id_2010 | string | ||

adi | number | Neighborhood Atlas Area Deprivation Index | national percentile ranking at block group level from 1 to 100 averaged for each tract; higher adi indicates higher disadvantage (2019) |

coi_education | number | Child Opportunity Index Education Domain | weighted average of education domain component indicator z-scores, nationally normed (2015) |

coi_health_env | number | Child Opportunity Index Health and Environment Domain | weighted average of health and environment domain component indicator z-scores, nationally normed (2015) |

coi_social_econ | number | Child Opportunity Index Social and Economic Domain | weighted average of social and economic domain component indicator z-scores, nationally normed (2015) |

coi | number | Child Opportunity Index | weighted average of three domain averaged z-scores, nationally normed (2015) |

dep_index_fraction_assisted_income | number | Fraction Assisted Income | fraction of households receiving public assistance income or food stamps or SNAP in the past 12 months (2018) |

dep_index_fraction_high_school_edu | number | Fraction High School Education | fraction of population 25 and older with educational attainment of at least high school graduation (includes GED equivalency) (2018) |

dep_index_median_income | number | Median Household Income | median household income in the past 12 months in 2018 inflation-adjusted dollars (2018) |

dep_index_fraction_no_health_ins | number | Fraction No Health Insurance | fraction of poulation with no health insurance coverage (2018) |

dep_index_fraction_poverty | number | Fraction Poverty | fraction of population with income in past 12 months below poverty level (2018) |

dep_index_fraction_vacant_housing | number | Fraction Vacant Housing | fraction of houses that are vacant (2018) |

dep_index | number | Material Deprivation Index | composite index of 6 variables above characterizing community material deprivation; range 0 to 1, with higher values indicating higher deprivation (2018) |

lead_paint | number | Lead Paint Indicator | percent of housing units built pre-1960 (2019) |

diesel_pm | number | Diesel PM Concentration | concentration of diesel particulate matter in air (ug/m3) (2017) |

cancer_risk | number | Cancer Risk | lifetime cancer risk from inhalation of air toxics (2017) |

resp_hazard_ind | number | Respiratory Hazard Index | air toxics respiratory hazard index; ratio of exposure concentration to health-based reference concentration (2017) |

traffic_proximity | number | Traffic Proximity and Volume | Count of vehicles (AADT, avg. annual daily traffic) at major roads within 500 meters, divided by distance in meters (2019) |

major_discharger_water | number | Major Direct Dischargers to Water Indicator | RSEI modeled toxic concentrations at stream segments within 500 m divided by distance in km (2021) |

nat_priority_proximity | number | Proximity to NPL Sites | count of proposed or listed National Priority List (a.k.a. superfund) sites within 5 km (or nearest one beyond 5 km) (2021) |

risk_management_proximity | number | Proximity to RMP Facilities | count of Risk Management Plan (potential chemical accident management plan) facilities within 5 km (or nearest one beyond 5 km), each divided by distance in km (2021) |

disposal_proximity | number | Proximity to TSDF Facilities | count of hazardous waste facilities (Treatment Storage and Disposal Facilities and LQGs) within 5 km (or nearest beyond 5 km), each divided by distance in km (2021) |

ozone_conc | number | Ozone Cocentration | ozone seasonal average of daily maximum 8-hour concentration (ppb) (2018) |

pm_conc | number | PM Concentration | annual average PM2.5 level in air (ug/m3) (2018) |

low_food_access_flag | boolean | Low Food Access Flag | TRUE if tract has at least 500 people or at least 33% of the tract population living more than 1 mile from nearest food store in urban areas, or more than 10 miles in rural areas (2019) |

low_food_access_pct | number | Low Food Access Percentage | percent of tract population living more than 1 mile from nearest food store in urban areas, or more than 10 miles in rural areas (2019) |

food_insecurity_pct | number | Food Insecurity Percentage | estimated percentage of population in food insecure households (2019) |

hpsa_mh | boolean | Mental Health Professional Shortage Area | |

hpsa_pc | boolean | Primary Care Professional Shortage Area | |

ice | number | Racial Economic Index of Concentration at the Extremes | high income white non-Hispanic households versus low income people of color (not white non-Hispanic) households; -1 to 1 where 1 indicates all high income white households and -1 indicates all low income people of color households (2019) |

pct_crowding | number | Percent Crowding | percent of households with greater than 1 person per room (2019) |

mrfei | number | Modified Retail Food Environment Index | percentage of healthy food retailers (2011) |

mua | boolean | Medically Underserved Area | |

pct_1or2_risk_factors | number | Percent 1 or 2 Community Resilience Risk Factors | Rate of individuals with one to two community resilience risk factors (2019) |

pct_3ormore_risk_factors | number | Percent 3 or More Community Resilience Risk Factors | Rate of individuals with three or more community resilience risk factors (2019) |

sdi | number | Social Deprivation Index | Social Deprivation Index Score 1-100 (2015) |

svi_socioeconomic | number | Social Vulnerability Index Socioeconomic Theme | percentile ranking 0 to 1 for socioeconomic theme (2018) |

svi_household_comp | number | Social Vulnerability Index Household Composition Theme | percentile ranking 0 to 1 for household composition theme (2018) |

svi_minority | number | Social Vulnerability Index Minority Theme | percentile ranking 0 to 1 for minority status/language theme (2018) |

svi_housing_transportation | number | Social Vulnerability Index Housing and Transportation Theme | percentile ranking 0 to 1 for housing type/transportation theme (2018) |

svi | number | Social Vulnerability Index | overall social vulnerability percentile ranking 0 to 1 (2018) |

walkability_index | number | Walkability Index | national percentile rankings at the block group level from 1 to 20 averaged for each tract; 1 is least walkable, 20 is most walkable; accounts for intersection density, proximity to transit stops, employment mix, and employment/household mix (2021) |

year | number |