Chicago COVID-19 Community Vulnerability Index (CCVI)
data.cityofchicago.org | Last Updated 3 Feb 2022The 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
This dataset has the following 16 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Geography Type | geography_type | text | Whether the record is for a Community Area or a ZIP Code | CA ZIP view top 100 |
| Community Area or ZIP Code | community_area_or_zip | number | The Community Area or ZIP Code | 29 3 14 60631 74 view top 100 |
| Community Area Name | community_area_name | text | Blank if the record is for a ZIP Code. | Rogers Park Washington Park Archer Heights Jefferson Park Belmont Cragin view top 100 |
| CCVI Score | ccvi_score | number | 8.3 27.7 36.0 52.4 52.9 view top 100 | |
| CCVI Category | ccvi_category | text | LOW MEDIUM HIGH view top 100 | |
| Rank - Socioeconomic Status | rank_socioeconomic_status | number | 67 48 59 72 54 view top 100 | |
| Rank - Household Composition and Disability | rank_household_composition | number | 39 13 63 66 22 view top 100 | |
| Rank - Adults with no PCP | rank_adults_no_pcp | number | Adults aged 18-64 years with no primary care provider. | 41 53 63 19 23 view top 100 |
| Rank - Cumulative Mobility Ratio | rank_cumulative_mobility_ratio | number | Ratio of mobility in 2020 compared to 2019. | 60 70 33 19 55 view top 100 |
| Rank - Frontline Essential Workers | rank_frontline_essential_workers | number | Percentage of the CA population that work as frontline essential workers. | 11 53 66 43 35 view top 100 |
| Rank - Age 65+ | rank_age_65_plus | number | Percentage of the CA population that are adults aged 65+. | 15 52 37 33 21 view top 100 |
| 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. | 52 6 18 33 57 view top 100 |
| Rank - COVID-19 Incidence Rate | rank_covid_19_incidence_rate | number | Cumulative incidence rate Jan 1 - Dec 31 2020. | 8 33 70 19 55 view top 100 |
| Rank - COVID-19 Hospital Admission Rate | rank_covid_19_hospital_admission_rate | number | Cumulative hospital admission rate Jan 1 - Dec 31 2020. | 8 70 33 55 19 view top 100 |
| 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. | 2 50 36 55 19 view top 100 |
| 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. | {"coordinates":[-87.711251,41.810038],"type":"Point"} {"coordinates":[-87.5964755956,41.728182061],"type":"Point"} {"coordinates":[-87.551428197,41.7412427285],"type":"Point"} {"coordinates":[-87.701101,41.921058],"type":"Point"} {"coordinates":[-87.7263633246,41.8108790078],"type":"Point"} view top 100 |