cityofchicago/chicago-covid19-community-vulnerability-index-ccvi-xhc6-88s9

 
External

Chicago COVID-19 Community Vulnerability Index (CCVI)

  • community area
  • covid-19
  • health
  • public health
  • zip code

Chicago COVID-19 Community Vulnerability Index (CCVI)

The Chicago CCVI identifies communities that have been disproportionately affected by COVID-19 and are vulnerable to barriers to COVID-19 vaccine uptake​. Vulnerability is defined as a combination of sociodemographic factors, epidemiological factors​, occupational factors​, and cumulative COVID-19 burden.

The 10 components of the index include COVID-19 specific risk factors and outcomes and social factors known to be associated with social vulnerability in the context of emergency preparedness. The CCVI is derived from ranking values of the components by Chicago Community Area, then synthesizing them into a single composite weighted score. The higher the score, the more vulnerable the geographic area.

ZIP Code CCVI is included to enable comparison with other COVID-19 data available on the Chicago Data Portal. Some elements of the CCVI are not available by ZIP Code. To create ZIP Code CCVI, the proportion of the ZIP Code population contributed by each Community Areas was determined. The apportioned populations were then weighted by the Community Area CCVI score and averaged to determine a ZIP Code CCVI score.

The COVID-19 Community Vulnerability Index (CCVI) is adapted and modified from a Surgo Ventures collaboration (https://precisionforcovid.org/ccvi) and the CDC Social Vulnerability Index​. ZIP Codes are based on ZIP Code Tabulation Areas (ZCTAs) developed by the U.S. Census Bureau. For full documentation see: https://www.chicago.gov/content/dam/city/sites/covid/reports/012521/Community_Vulnerability_Index_012521.pdf

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
LocationlocationlocationPointA point within the Community Area or ZIP Code to allow for geographic analysis. The precise point shown has no other meaning.
Geography Typegeography_typegeography_typeTextWhether the record is for a Community Area or a ZIP Code
CCVI Categoryccvi_categoryccvi_categoryText
Rank - Cumulative Mobility Ratiorank_cumulative_mobility_ratiorank_cumulative_mobility_ratioNumberRatio of mobility in 2020 compared to 2019.
Community Area Namecommunity_area_namecommunity_area_nameTextBlank if the record is for a ZIP Code.
CCVI Scoreccvi_scoreccvi_scoreNumber
Rank - Socioeconomic Statusrank_socioeconomic_statusrank_socioeconomic_statusNumber
Rank - Frontline Essential Workersrank_frontline_essential_workersrank_frontline_essential_workersNumberPercentage of the CA population that work as frontline essential workers.
Rank - Age 65+rank_age_65_plusrank_age_65_plusNumberPercentage of the CA population that are adults aged 65+.
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumberThis column was automatically created in order to record in what polygon from the dataset 'Census Tracts' (bdys-3d7i) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Rank - Comorbid Conditionsrank_comorbid_conditionsrank_comorbid_conditionsNumberPercentage of the CA population that are adults aged 18-64 years with one or more comorbid conditions.
Rank - COVID-19 Hospital Admission Raterank_covid_19_hospital_admission_raterank_covid_19_hospital_admission_rateNumberCumulative hospital admission rate Jan 1 - Dec 31 2020.
Rank - COVID-19 Crude Mortality Raterank_covid_19_crude_mortality_raterank_covid_19_crude_mortality_rateNumberCumulative non-congregate living situation deaths that occurred from Jan 1 - Dec 31 2020.
Community Area or ZIP Codecommunity_area_or_zipcommunity_area_or_zipNumberThe Community Area or ZIP Code
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumberThis column was automatically created in order to record in what polygon from the dataset 'Wards' (43wa-7qmu) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumberThis column was automatically created in order to record in what polygon from the dataset 'Zip Codes' (6mkv-f3dw) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumberThis column was automatically created in order to record in what polygon from the dataset 'Community Areas' (vrxf-vc4k) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Boundaries - ZIP Codes:@computed_region_rpca_8um6:@computed_region_rpca_8um6NumberThis column was automatically created in order to record in what polygon from the dataset 'Boundaries - ZIP Codes' (rpca-8um6) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Rank - COVID-19 Incidence Raterank_covid_19_incidence_raterank_covid_19_incidence_rateNumberCumulative incidence rate Jan 1 - Dec 31 2020.
Rank - Household Composition and Disabilityrank_household_compositionrank_household_compositionNumber
Rank - Adults with no PCPrank_adults_no_pcprank_adults_no_pcpNumberAdults aged 18-64 years with no primary care provider.

Upstream Metadata