This dataset provides inputs to the R model to equitably distribute CARES Act funding to underlying municipalities. Data is as of June 2020. For more information see: https://datacatalog.cookcountyil.gov/stories/s/yf8h-y2mv/
This dataset has the following 16 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Geographic ID | geoid | text | Place GEOID identifier, as assigned by the US Census Bureau | 1760352 1704975 1749945 1740910 1729938 view top 100 |
| Name | muni | text | Municipality Name | River Grove Maple Park Hinsdale Willow Springs Crest Hill view top 100 |
| In Cook County | in_cook | number | Binary indicator of whether municipality is taxed by Cook County (1) or not (0) | 0 1 view top 100 |
| Population | pop | number | INPUT: 2019 population estimate from Census Population Estimates Program (2019 vintage) https://www.census.gov/data/datasets/time-series/demo/popest/2010s-total-cities-and-towns.html | 91 167 220 226 256 view top 100 |
| Median Household Income | med_hh_inc | number | INPUT: Median household income in 2018 dollars, from 2014-2018 5-year ACS (reported in CMAP Community Data Snapshots) | 112143 71250 64063 33573 36080 view top 100 |
| Retail Sales | ret_sales | number | INPUT: 2019 total retail sales from IL Dept. of Revenue (reported in CMAP Community Data Snapshots) | 104523528 228885862 300940503 489345432 764178612 view top 100 |
| Total Equalized Assessed Value | tot_eav | number | INPUT: 2018 total equalized assessed value from IL Dept. of Revenue (reported in CMAP Community Data Snapshots) | 1638216 5413682 5414091 5941662 6010061 view top 100 |
| Percent EDA | pct_eda_pop | number | INPUT: Percent of population living in an EDA or disinvested area, calculated from CMAP's 2015 parcel-level population estimates and CMAP's EDA/disinvested layer | 0 1 0.6391 0.23 0.1886 view top 100 |
| COVID Deaths | covid_deaths | number | INPUT: Total COVID-19 deaths by place of residence as of 6/21/2020, per Cook County Medical Examiner | 0 1 2 4 3 view top 100 |
| Tax Base | tax_base | number | DERIVED: Total tax base (i.e. RET_SALES + TOT_EAV) | 278050559 12364735 548955156 1973819876 304746882 view top 100 |
| Tax Base Per Capita | tax_base_per_cap | number | DERIVED: Tax base per capita (i.e. TAX_BASE / POP) | 66441.07126362127 13078.257005899704 42615.78306859075 42963.215047393365 67728.44530037686 view top 100 |
| Log of Tax Base Per Capita | ln_tax_base_per_cap | number | DERIVED: Natural log of tax base per capita (i.e. LN(TAX_BASE_PER_CAP)) | 8.943601413861101 8.959033661786297 9.00648269578023 9.034349276105493 9.256021785653909 view top 100 |
| Log of Population | ln_pop | number | DERIVED: Natural log of population (i.e. LN(POP)) | 5.117993812416755 7.826443135456014 7.075808863978387 9.990078007617226 9.871635623086945 view top 100 |
| Log of Median Household Income | ln_med_hh_inc | number | DERIVED: Natural log of median household income (i.e. LN(MED_HH_INC)) | 11.627530121593772 11.173950098130897 11.067622253162455 10.421477451486137 10.49349397417656 view top 100 |
| COVID Death Rate | covid_death_rate | number | DERIVED: COVID-19 deaths per 100,000 population (i.e. COVID_DEATHS / POP * 100000) | 0 118.26408885232415 83.47245409015025 21.95178838475997 25.54558061455368 view top 100 |
| Log of COVID Death Rate | ln_covid_death_rate | number | DERIVED: Natural log of COVID-19 death rate (i.e. LN(COVID_DEATH_RATE+1), where the +1 ensures that a death rate of 0 yields 0 instead of a number error) | 0 0.518010091274967 0.8507796181730367 0.923073001878851 1.0633008831579664 view top 100 |