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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Rank - COVID-19 Incidence Rate | rank_covid_19_incidence_rate | rank_covid_19_incidence_rate | Number | Cumulative incidence rate Jan 1 - Dec 31 2020. |
| Boundaries - ZIP Codes | :@computed_region_rpca_8um6 | :@computed_region_rpca_8um6 | Number | This 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. |
| Community Areas | :@computed_region_vrxf_vc4k | :@computed_region_vrxf_vc4k | Number | This 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. |
| Zip Codes | :@computed_region_6mkv_f3dw | :@computed_region_6mkv_f3dw | Number | This 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. |
| Census Tracts | :@computed_region_bdys_3d7i | :@computed_region_bdys_3d7i | Number | This 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. |
| Wards | :@computed_region_43wa_7qmu | :@computed_region_43wa_7qmu | Number | This 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. |
| Community Area or ZIP Code | community_area_or_zip | community_area_or_zip | Number | The Community Area or ZIP Code |
| Location | location | location | Point | A point within the Community Area or ZIP Code to allow for geographic analysis. The precise point shown has no other meaning. |
| Geography Type | geography_type | geography_type | Text | Whether the record is for a Community Area or a ZIP Code |
| Community Area Name | community_area_name | community_area_name | Text | Blank if the record is for a ZIP Code. |
| CCVI Score | ccvi_score | ccvi_score | Number | |
| Rank - Socioeconomic Status | rank_socioeconomic_status | rank_socioeconomic_status | Number | |
| Rank - Household Composition and Disability | rank_household_composition | rank_household_composition | Number | |
| CCVI Category | ccvi_category | ccvi_category | Text | |
| Rank - Adults with no PCP | rank_adults_no_pcp | rank_adults_no_pcp | Number | Adults aged 18-64 years with no primary care provider. |
| Rank - Cumulative Mobility Ratio | rank_cumulative_mobility_ratio | rank_cumulative_mobility_ratio | Number | Ratio of mobility in 2020 compared to 2019. |
| Rank - Frontline Essential Workers | rank_frontline_essential_workers | rank_frontline_essential_workers | Number | Percentage of the CA population that work as frontline essential workers. |
| Rank - Age 65+ | rank_age_65_plus | rank_age_65_plus | Number | Percentage of the CA population that are adults aged 65+. |
| Rank - Comorbid Conditions | rank_comorbid_conditions | rank_comorbid_conditions | Number | Percentage of the CA population that are adults aged 18-64 years with one or more comorbid conditions. |
| Rank - COVID-19 Hospital Admission Rate | rank_covid_19_hospital_admission_rate | rank_covid_19_hospital_admission_rate | Number | Cumulative hospital admission rate Jan 1 - Dec 31 2020. |
| Rank - COVID-19 Crude Mortality Rate | rank_covid_19_crude_mortality_rate | rank_covid_19_crude_mortality_rate | Number | Cumulative non-congregate living situation deaths that occurred from Jan 1 - Dec 31 2020. |