Community-level data are available as CoDEC tables
(see as_codec_tbl()) included with the codec package for R
(see codec_read()).
American Community Survey Measures
About
Select population, socioeconomic, and housing measures derived from the 2023 5-yr U.S. Census American Community Survey (ACS) and were selected to cover three domains:
- Population: number of kids, number of households (with kids), single-parent households, racial and ethnic composition, limited English speaking households
- Socioeconomic: education, income, poverty, employment, health insurance, public income assistance
- Housing: vacancy, age, value, tenure, rent to income ratio
Data
Types of ACS measures
Measures and their definitions are contained in make.R.
Generally, each of the derived ACS measures are expressed in one of
three ways:
measures starting with
n_represent a number of something, such asn_householdmeasures starting with
prop_represent a proportion of some total, such asprop_povertymeasures starting with
median_represent a median of a number in a population, such asmedian_income
Missing Data
Additionally, data summaries may be suppressed by the census bureau.
Metadata
This CoDEC table has 226 rows and 24 columns
| column name | class | example |
|---|---|---|
| n_households | integer | 1300 |
| census_tract_id_2020 | character | 39061022102 |
| n_households_children | integer | 370 |
| n_housing_units | integer | 2761 |
| prop_poverty | numeric | 0.0797 |
| prop_recieved_public_assistance_income | numeric | 0.2163 |
| prop_family_households_with_single_householder | numeric | 0.3858 |
| prop_employment_among_civilian_workforce | numeric | 0.7402 |
| prop_housing_units_occupied_by_renters | numeric | 0.2478 |
| prop_median_rent_to_income_ratio_among_renters | numeric | 21.3 |
| prop_housing_units_vacant | numeric | 0 |
| prop_white_and_not_hispanic_or_latino | numeric | 0.6638 |
| prop_black_and_not_hispanic_or_latino | numeric | 0.7576 |
| prop_white_and_hispanic_or_latino | numeric | 0.0036 |
| prop_black_and_hispanic_or_latino | numeric | 0 |
| n_persons_under_18 | integer | 847 |
| prop_health_insurance | numeric | 0.8344 |
| prop_rent_burdened | numeric | 0.4316 |
| prop_housing_conditions | numeric | 0.2313 |
| prop_built_prior_1980 | numeric | 0.4409 |
| prop_limited_english_speaking | numeric | 0 |
| prop_adults_hs_edu | numeric | 0.9769 |
| year | integer | 2023 |
| median_home_value | integer | 285700 |
Crime
About
Census tract-level measures of crime incidents (including property crimes, violent crimes, other crimes, gunshots, and reported shootings) in Hamilton County, Ohio.
Tract-level measures are derived from the data packages stored in the
xx_address
repository, including crime_incidents-v0.1.2,
shotspotter-v0.1.2,
and reported_shootings-v0.1.0.
View the metadata for each of these data packages for more information
about their sources.
Data
Jittered (within the same block) latitude and longitude corresponding
to the location of each reported crime are available from each data
source. Crimes are aggregated to the tract level by summing the number
of crimes for each tract. For higher resolution crime data, see the xx_address
repository.
Because of how the data is available, values will be missing
(NA) if either (1) there were zero instances in a
tract-year-month or (2) it is outside the spatial or temporal
extent for the respective data source. In some cases, it may be
appropriate to impute zero instances in place of missing counts; for
example, if it is clear that the tract was measured the month before and
after in the same year. More specifically:
-
crime_incidentsandreported_shootingsare geographically limited to the City of Cincinnati -
shotspotteris limited to specific time periods for different target neighborhoods
Metadata
This CoDEC table has 21,696 rows and 8 columns
| column name | class | example |
|---|---|---|
| census_tract_id_2020 | character | 39061020811 |
| year | integer | 2017 |
| month | integer | 7 |
| n_crime_incidents_property | integer | 7 |
| n_crime_incidents_violent | integer | 1 |
| n_crime_incidents_other | integer | 2 |
| n_shots_fired | integer | 10 |
| n_reported_shootings | integer | 1 |
Average Drive Time to Cincinnati Children’s
About
A census tract-level measure of drive time to Cincinnati Children’s Hospital Medical Center derived using 6-minute interval drive time isochrones obtained from openroute service.
Data
Each tract-level drive time is an area-weighted average of intersecting 6-minute interval drive time isochrones.
Environmental Justice Index
About
The Environmental Justice Index uses data from the U.S. Census Bureau, the U.S. Environmental Protection Agency, the U.S. Mine Safety and Health Administration, and the U.S. Centers for Disease Control and Prevention to rank the cumulative impacts of environmental injustice on health for every census tract. … The EJI ranks each tract on 36 environmental, social, and health factors and groups them into three overarching modules and ten different domains.
The ATSDR’s Environmental
Justice Index (EJI) was most recently released in 2022, but utilizes
data from several older sources. Note that although the EJI data has a
year of 2022 in the CoDEC data package, fields in the EJI
are from different sources that are each actually older. Find the full
documentation of the EJI in PDF form here: https://eji.cdc.gov/Documents/Data/2022/EJI_2022_Data_Dictionary_508.pdf
Data
- Data download from https://www.atsdr.cdc.gov/placeandhealth/eji/eji-data-download.html as a geodatabase
- Data fields representing “estimates” (i.e., not “percentile” or “summed ranks”) selected if not avilable elsewhere (e.g., not American Community Survey estimates)
- Field names were renamed to be longer and more descriptive
- Although this is the 2022 release, 2010 vintage census tract geographies and identifers are used in the EJI data
Metadata
This CoDEC table has 222 rows and 15 columns
| column name | class | example |
|---|---|---|
| census_tract_id_2010 | character | 39061021501 |
| prcnt_area_within_1mi_epa_npl_site | numeric | 0 |
| prcnt_area_within_1mi_epa_tri_site | numeric | 83.51 |
| prcnt_area_within_1m_epa_tsd_site | numeric | 0 |
| prcnt_area_within_1mi_epa_rmp_site | numeric | 0 |
| prcnt_area_within_1mi_coal_mine | integer | 0 |
| prcnt_area_within_1mi_lead_mine | integer | 0 |
| prcnt_area_within_1_mi_greenspace | numeric | 95.78 |
| prcnt_homes_built_before_1980 | numeric | 62.37 |
| walkability_index_epa | numeric | 11.42 |
| prcnt_area_within_1mi_railroad | numeric | 100 |
| prcnt_area_within_1mi_high_volume_road | numeric | 100 |
| prcnt_area_within_1mi_airport | numeric | 0 |
| prcnt_area_huc12_watershed | numeric | 82.02 |
| year | integer | 2022 |
Landcover, Built Environment, and Greenness
About
Taken from https://github.com/geomarker-io/hamilton_landcover. Census tract-level measures of greenness, imperviousness, and treecanopy are derived from the National Land Cover Database (NLCD) and NASA MODIS satellite data.
Although year=2019 for this product, it is a compilation
of other annual products with unique years denoted in the field
names.
Data
See https://github.com/geomarker-io/hamilton_landcover for data source scripts.
Defining greenspace using NLCD land cover classifications
A grid cell is considered greenspace if its NLCD land cover classification is in any category except water, ice/snow, developed medium intensity, developed high intensity, rock/sand/clay.
Enhanced Vegetation Index (EVI)
The Enhanced Vegetation Index (EVI) is a measure of greenness that ranges from -0.2 to 1, with higher values corresponding to more vegetation. A cloud-free composite EVI raster at a resolution of 250 × 250 m was created by assembling individual images collected via remote sensing between June 10 and June 25, 2018.
Parcel Characteristics
About
Census tract-level measures of parcel characteristics for all
residential parcles in Hamilton County, Ohio. Tract-level measures are
derived from the data packages stored in the parcel
repository. Version 0.1.0 of the parcel CoDEC data resource
harmonizes cagis_parcels-v1.1.1
and auditor_online_parcels-v0.2.1.
View the metadata for each of these data packages for more information
about their sources.
Data
Parcel-level measures were aggregated to the tract level:
- median:
market_total_value,acreage,year_built, and number of rooms - fraction of parcels: by land use type, by homestead flag
Parcel land use types were grouped into more general categories:
- apartments:
apartment, 4-19 units,apartment, 20-39 units,apartment, 40+ units,office / apartment over - assisted housing:
metropolitan housing authority,lihtc res - condominiums:
condominium unit,condo or pud garage - single family homes:
single family dwelling - two to three family homes:
two family dwelling,three family dwelling - other
Metadata
This CoDEC table has 222 rows and 17 columns
| column name | class | example |
|---|---|---|
| census_tract_id_2010 | character | 39061004000 |
| fraction_apartment | numeric | 0.03 |
| fraction_assisted_housing | numeric | 0 |
| market_total_value | integer | 28660 |
| acreage | numeric | 0.474 |
| year_built | numeric | 1948 |
| n_total_rooms | integer | 6 |
| n_bedrooms | numeric | 3 |
| n_full_bathrooms | integer | 1 |
| n_half_bathrooms | integer | 0 |
| online_market_total_value | integer | 100780 |
| year | integer | 2024 |
| fraction_condominium | numeric | 0.81 |
| fraction_single_family_dwelling | numeric | 0.85 |
| fraction_two_to_three_family_dwelling | numeric | 0 |
| fraction_homestead | numeric | 0.18 |
| fraction_other | numeric | 0 |
Property Code Enforcements
About
Tract-level measures are derived from the property_code_enforcements-v1.0.1
data package stored in the parcel
repository.
Data
The census tract-level number of property code enforcements
(n_property_code_enforcements) is calculated by
intersecting the jittered coordinates of the enforcements with the 2020
census tract boundaries and totaling them per year (2017 - present).
Average Annual Vehicle-Meters Driven
About
AADT stands for Average Anual
Daily Traffic. Aggregated at the
census tract-level, AADT is measured in vehicle-meter counts
(aadtm) and grouped by class (passenger,
trucks_buses, tractor_trailer).
Data is downloaded from the 2020 Highway Performance Monitoring System (HPMS) geodatabase hosted by ESRI using the {appc} package for R. For more details about the HPMS, see:
Data
Only roads with F_SYSTEM classification of 1
(“interstate”) or 2 (“principal arterial - other freeways and
expressways”) are used. Passenger vehicles (FHWA 1-3) are calculated as
the total minus FHWA class 4-7 (single unit) and 8-13 (combo).
For each 2020 census tract geography, sum the class-specific AADT for all intersecting roads, weighted by their intersecting lengths.