Indiana COVID-19 Project Data Dictionary

Data files described in this dictionary are located in the data directory of the Indiana-COVID-19-Tracker repository and the data directory of the Indiana-COVIDcast-Dashboard repository.

Historical Weekly COVID-19 Cases by Age for Indiana

Description

Processed data for Demographics heatmaps that shows a breakdown of weekly COVID-19 cases by age group.

File name

age-cases-heat.rds

Script

Processing: process-demog-data.R

Raw Sources

Indiana Data Hub: COVID-19 CASE DEMOGRAPHICS
tidycensus R package: website, 2018 age populations for Indiana

Notes

Other variables:
- end_date: Ordered factor; date of the last day of the weekly interval
- daily_cases: Cases for the end_date; vestigial column that was used to calculate weekly_cases
- pop: 2018 age populations for Indiana that’s used to calculate prop_cases

Variable	N = 4081	Definition
age_grp		Age group
0 to 19	51 (12%)
20 to 29	51 (12%)
30 to 39	51 (12%)
40 to 49	51 (12%)
50 to 59	51 (12%)
60 to 69	51 (12%)
70 to 79	51 (12%)
80 and older	51 (12%)
weekly_cases	792 (399, 2,004)	Weekly count of COVID-19 confirmed cases by age group
prop_cases	0.97 (0.62, 2.75)	Number of cases scaled to per 1000 residents per age group
1 n (%); Median (IQR)

Historical Weekly COVID-19 Deaths by Age Group for Indiana

Description

Processed data for Demographics line charts that shows counts and trends of weekly COVID-19 deaths by age group.

File name

age-death-line.rds

Script

Processing: process-demog-data.R

Raw Sources

Indiana Data Hub: COVID-19 CASE DEMOGRAPHICS

Notes

Other variables:
- end_date: date of the last day of the weekly interval
- date_text: date label for the chart
- tooltip: pop-up text for points in chart with death counts and date

Variable	N = 2961	Definition
agegrp		Age group
0 to 19	37 (12%)
20 to 29	37 (12%)
30 to 39	37 (12%)
40 to 49	37 (12%)
50 to 59	37 (12%)
60 to 69	37 (12%)
70 to 79	37 (12%)
80 and older	37 (12%)
weekly_total	5 (1, 31)	Weekly count of COVID-19 confirmed deaths by age group
1 n (%); Median (IQR)

Historical Daily COVID-19 Hospital Admissions by Age Group for Indiana

Description

Raw data for the Hospitals line charts that shows daily COVID-19 hospital admissions by age group and gender.

File name

age-hosp-line.rds

Script

Collection: scrape-regenstrief-tableau.R

Raw Sources

Regenstrief Institute: dashboard

Notes

This dataset is incomplete with random gaps between days.

Other variables:
- date: yyyy-mm-dd format

Variable	N = 8551	Definition
ages		Age group
0-4	95 (11%)
20-29	95 (11%)
30-39	95 (11%)
40-49	95 (11%)
5-19	95 (11%)
50-59	95 (11%)
60-69	95 (11%)
70-79	95 (11%)
80+	95 (11%)
admissions_m	1,554 (376, 3,200)	Daily COVID-19 male hospital admissions by age group
admissions_f	1,570 (776, 2,936)	Daily COVID-19 female hospital admissions by age group
admissions_total	3,061 (1,216, 6,128)	Daily COVID-19 total hospital admissions by age group
1 n (%); Median (IQR)

Historical Daily ICU Beds and Ventilators for Indiana

Description

Raw data for the Static Charts Hospitalizations, ICU Beds and Ventilator Availability that shows resource counts of ICU beds and ventilators.

File name

beds-vents-complete.csv

Script

Collection: build-datasets.R

Raw Sources

Indiana Data Hub: COVID-19 BEDS AND VENTS

Notes

The source publishs daily excel spreadsheets with total resource counts, and these spreadsheets are collected and joined daily to produce a dataset with historical values.

Other variables:
- date: yyyy-mm-dd format

Variable	N = 3001	Definition
beds_icu_total	2,222 (2,163, 2,360)	Total ICU beds
beds_icu_occupied_covid_19	344 (259, 527)	Total ICU beds occupied with COVID-19 patients
beds_available_icu_beds_total	804 (615, 948)	Total available ICU beds
vents_total	2,862 (2,802, 2,896)	Total ventilators
vents_all_use_covid_19	132 (83, 232)	Total ventilators being used by COVID-19 patients
vents_non_covid_pts_on_vents	449 (418, 471)	Total ventilators being used by non-COVID-19 patients
vents_all_available_vents_not_in_use	2,276 (2,122, 2,410)	Total available ventilators
1 Median (IQR)

Historical State Hospital Staff Shortages, Hospital Mortality Rate, Hospital Admissions and Ages Skewness of Admissions for Indiana

Description

Processed data for Hospitals line charts that shows state hospital staff shortages, hospital mortality rate, hospital admissions, and age skewness of hospital admissions towards older patients.

File name

hosp-msas-line.rds

Script

Process: process-hospitals-data.R

Raw Sources

Regenstrief Institute: dashboard
Department of Health and Human Services: COVID-19 Reported Patient Impact and Hospital Capacity by State Timeseries
Department of Health and Human Services: COVID-19 Reported Patient Impact and Hospital Capacity by Facility

Notes

Other variables:
- date: Ordered factor, Month Day format

Variable	N = 891	Definition
roll_mean_staff_short_perc	0.120 (0.092, 0.168)	Percent of reporting hospitals that have reported staffing shortages for that day. That percentage is averaged over a rolling, seven day window
mean_mort_rate	0.21 (0.17, 0.41)	Ratio of deaths of hospitalized COVID-19 patients and unique COVID-19 hospital admissions. Each rate is calculated over a rolling, 14-day window
roll_mean_admiss	168 (107, 223)	Daily total of unique individuals that have tested positive for COVID-19 and been admitted to a hospital on the that day. Those daily counts are averaged over a rolling, seven day window
skewness	0.85 (0.79, 0.89)	Measurement of the age makeup of the COVID-19 hospital admissions data. It's calculated over a rolling, 14 day window
1 Median (IQR)

Local Hospital Capacity for Indiana

Description

Processed data for the Hospitals Local Hospital Capacity table that shows capacity measures and counts of COVID-19 patients for hospitals at the local level.

File name

hosp-react-tab.rds

Script

Process: process-hospitals-data.R

Raw Sources

Department of Health and Human Services: COVID-19 Reported Patient Impact and Hospital Capacity by State Timeseries

Notes

Other variables:
- end_date: date, yyyy-mm-dd format, end date of week interval
- hospital_name: char, Name of hospital
- address: char, Street address of hospital
- city_zip: char, City and zip code
- county_name: char, Name of county
- avgCovIceuTenKList: nested list, end_date and average daily number of ICU beds being used by confirmed and suspected COVID-19 patients over the weekly interval
- avgCovHospTenKList: nested list, end_date and average daily number of hospital beds being used by confirmed and suspected COVID-19 patients over the weekly interval
- avgTotImpBedsList: end_date and average daily number of staffed total beds available over the weekly interval

Variable	N = 1251	Definition
sev_day_icu_perc_occup	0.54 (0.40, 0.73)	Proportion of the seven-day average of occupied ICU beds to the seven-day average of available ICU beds.
Missing	42
sev_day_hosp_perc_occup	0.51 (0.34, 0.69)	Proportion of the seven-day average of occupied hospital beds to the seven-day average of available hospital beds.
Missing	1
1 Median (IQR)

Historical Daily Tests, Cases and Deaths by Age for Indiana

Description

Raw data for Demographics line charts that shows daily case and death counts by age group.

File name

ind-age-complete.csv

Script

Collection: build-datasets.R

Raw Sources

Indiana Data Hub: COVID-19 CASE DEMOGRAPHICS

Notes

The source publishs daily excel spreadsheets with total resource counts, and these spreadsheets are collected and joined daily to produce a dataset with historical values.
Other variables:
- date: date, yyyy-mm-dd format

Variable	N = 2,2861	Definition
agegrp		Age Group
0-19	254 (11%)
20-29	254 (11%)
30-39	254 (11%)
40-49	254 (11%)
50-59	254 (11%)
60-69	254 (11%)
70-79	254 (11%)
80+	254 (11%)
Unknown	254 (11%)
covid_count	18,563 (7,590, 53,919)	Number of cases by age group
covid_deaths	76 (9, 728)	Number of deaths by age group
covid_test	170,918 (81,370, 324,316)	Number of tests by age group
covid_count_pct	13.3 (6.6, 15.1)	Percent of daily cases
covid_deaths_pct	2 (0, 16)	Percent of daily deaths
covid_test_pct	13.3 (6.7, 14.9)	Percent of daily tests
1 n (%); Median (IQR)

Historical Daily Cases and Deaths by Race for Indiana

Description

Raw data that shows daily case and death counts by race.

File name

ind-race-complete.csv

Script

Collection: build-datasets.R

Raw Sources

The Covid Tracking Project: The COVID Racial Data Tracker

Notes

The source publishs data every 3 or 4 days.
Other variables:
- date: date, yyyy-mm-dd format

There is a latin_x column for cases and deaths, but it’s over 90% missing and only a few distinct values. A few columns have some TRUE/FALSE entries. I didn’t investigate the reason behind these odd data entries.

There are also around 30 columns completely composed of missing values.

Variable	N = 4,1601
cases_total	64,299 (37,397, 125,146)
cases_white	30,602 (16,462, 68,399)
cases_black	7,359 (4,941, 11,801)
Missing	1
cases_asian	836 (567, 1,423)
cases_other	10,704 (6,774, 17,915)
Missing	1
cases_unknown	15,811 (8,669, 25,451)
cases_ethnicity_hispanic	6,960 (4,386, 10,680)
cases_ethnicity_non_hispanic	22,116 (12,530, 46,643)
cases_ethnicity_unknown	38,365 (21,857, 69,220)
Missing	189
deaths_total	2,932 (2,121, 3,674)
Missing	45
deaths_white	1,822 (1,435, 2,311)
Missing	189
deaths_black	393 (339, 453)
Missing	189
deaths_asian	15 (10, 19)
Missing	189
deaths_other	374 (291, 472)
Missing	189
deaths_unknown	406 (165, 474)
Missing	189
deaths_ethnicity_hispanic	57 (43, 83)
Missing	189
deaths_ethnicity_non_hispanic	1,452 (1,217, 1,757)
Missing	189
deaths_ethnicity_unknown	1,296 (980, 1,887)
Missing	189
1 Median (IQR)

Historical Weekly Median Age of Cases, Weekly Tests and Deaths for Indiana

Description

Processed data for the Demographics bubble chart that shows the number of tests, number of deaths, and median age of the cases per week.

File name

median-age-bubble.rds

Script

Processing: process-demog-data.R

Raw Sources

Indiana Data Hub: COVID-19 CASE DATA

Notes

Other variables:
- end_date: ordered factor, Month Day format; end date of weekly interval

Variable	N = 511	Definition
median_age	41.0 (38.5, 43.2)	Median age of cases for that week
weekly_tests	144,713 (62,858, 236,390)	Number of tests for that week
weekly_deaths	156 (85, 310)	Number of deaths for that week
1 Median (IQR)

Historical Daily Hospital Admissions and Deaths for Indiana

Description

Raw data for the Hospitals line charts that shows daily COVID-19 hospital admissions, hospital deaths, and hospital death rate.

File name

mort-hosp-line.rds

Script

Collection: scrape-regenstrief-tableau.R

Raw Sources

Regenstrief Institute: dashboard

Notes

This dataset is incomplete with random gaps between days.

Other variables:
- date: yyyy-mm-dd format

Variable	N = 821	Definition
deaths_total	6,104 (4,826, 6,930)	Number of individuals hospitalized for COVID-19 who died while in the hospital
hosp_total	38,938 (32,825, 41,499)	Number of unique individuals who have been hospitalized and tested positive for COVID-19
death_rate	0.157 (0.147, 0.167)	Percent of individuals hospitalized for COVID-19 who died while in the hospital
1 Median (IQR)

Historical Weekly Positivity Rates and Daily Cases per 100,000 Indiana Residents

Description

Processed data for the Indiana COVIDcast Dashboard that shows weekly positivity rate and daily cases per 100,000 residents per metropolitan statistical area.

File name

msa-cases100-posrate-historic.csv

Scripts

Processing: process-hist-regional-dat.R

Raw Sources

covidcast R package: website
Michigan Disease Surveillance System: website
Wisconsin Department of Health Services: website
Illinois Department of Public Health: website
Indiana Data Hub: website

Notes

The missing values for pos_rate are partly because this dataset has a row for every day and the positivity rate is calculated every week. The other missing values are for Cincinnati, Louisville, and Evansville. At the time this dashboard was created, those states with counties included in those areas didn’t publicly release the necessary data to calcuate the positivity rates for those areas.

Other variables:
- date: yyyy-mm-dd format; date for daily cases_100k
- geo_value: FIPS codes for msa
- start_date: Start date of the weekly interval for pos_rate
- data_date: Date when data was last updated

Variable	N = 5,0801	Definition
msa		Metropolitan Statistical Area
Bloomington	339 (6.7%)
Chicago-Naperville-Elgin	338 (6.7%)
Cincinnati	338 (6.7%)
Columbus	339 (6.7%)
Elkhart-Goshen	339 (6.7%)
Evansville	338 (6.7%)
Fort Wayne	339 (6.7%)
Indianapolis-Carmel-Anderson	339 (6.7%)
Kokomo	339 (6.7%)
Lafayette-West Lafayette	339 (6.7%)
Louisville/Jefferson County	338 (6.7%)
Michigan City-La Porte	339 (6.7%)
Muncie	339 (6.7%)
South Bend-Mishawaka	338 (6.7%)
Terre Haute	339 (6.7%)
cases_100k	16 (7, 43)	Daily cases per 100,000 residents per MSA
Missing	10
pos_rate	0.06 (0.04, 0.11)	Weekly positivity rate per MSA
Missing	4,506
1 n (%); Median (IQR)

Historical Daily Values of Delphi Research Groups Combined Indicator for Indiana

Description

Processed data for the Indiana COVIDcast Dashboard that shows historic daily values of Delphi Research Group’s Combined Indicator for each methropolitan statistical area.

File name

dash-ci-line.rds

Scripts

Processing: process-dashboard-data.R

Raw Sources

covidcast R package: website

Notes

Other variables:
- time_value: yyyy-mm-dd format; Daily

Variable	N = 4,3651	Definition
name		Metropolitan Statistical Area
Bloomington	291 (6.7%)
Chicago-Naperville-Elgin	291 (6.7%)
Cincinnati	291 (6.7%)
Columbus	291 (6.7%)
Elkhart-Goshen	291 (6.7%)
Evansville	291 (6.7%)
Fort Wayne	291 (6.7%)
Indianapolis-Carmel-Anderson	291 (6.7%)
Kokomo	291 (6.7%)
Lafayette-West Lafayette	291 (6.7%)
Louisville/Jefferson County	291 (6.7%)
Michigan City-La Porte	291 (6.7%)
Muncie	291 (6.7%)
South Bend-Mishawaka	291 (6.7%)
Terre Haute	291 (6.7%)
value	0.84 (0.65, 1.11)	Delphi Research Group's “Combined” indicator
1 n (%); Median (IQR)

Historical Weekly COVID-19 Statistics and Counts for Illinois Counties

Description

Raw data for the Indiana COVIDcast Dashboard that shows various weekly COVID-19 county statistics for Illinois

File name

illinois-tests-complete.csv

Scripts

Collection: build-regional-dat.R

Raw Sources

Illinois Department of Public Health: website

Notes

These data are published in weekly intervals into a HTML table then scraped and collected.

Other variables:
- week: int; week of the year
- start_date: yyyy-mm-dd format; First day of the weekly interval
- end_date: yyyy-mm-dd formate; Last day of the weekly interval
- County: char; Illinois county name
- New Cases per 100,000: string; format: “<int> cases” or “<int> per 100k” or “<int> per 100kwarning”
- Test Positivity %: string; format: “<float>%\r\n New Tests: <int>”
- (%) CLI ED Visits, Adults: string; format: “<int>%”
- ICU (%) Available: string; format: “<float>%”

Variable	N = 3,3991	Definition
Number of Deaths	1.0 (0.0, 3.0)	Number of COVID-19 deaths per week per county
Missing	11
1 Median (IQR)

Historical Daily COVID-19 Test Results for Indiana Counties

Description

Raw data for the Indiana COVIDcast Dashboard that shows daily COVID-19 county test results for Indiana

File name

ind-tests-complete.csv

Scripts

Collection: build-regional-dat.R

Raw Sources

Indiana Data Hub: COVID-19 COUNTY-WIDE TEST, CASE, AND DEATH TRENDS

Notes

Other variables:
- date: yyyy-mm-dd format; Daily
- county: County name

Variable	N = 34,7761	Definition
positives	4 (1, 16)	Number of COVID-19 cases per day per county
num_tests	60 (16, 191)	Number of COVID-19 tests per day per county
1 Median (IQR)

Historical Daily COVID-19 Test Results for Michigan Counties

Description

Raw data for the Indiana COVIDcast Dashboard that shows daily COVID-19 county test results for Michigan

File name

mich-tests-complete.csv

Scripts

Collection: build-regional-dat.R

Raw Sources

Michigan Department of Health and Human Services: COVID-19 Tests by County

Notes

Other variables:
- date: yyyy-mm-dd format; Daily
- county: County name

Variable	N = 30,3521	Definition
positive	3 (0, 15)	Number of COVID-19 positive tests per day per county
negative	73 (21, 252)	Number of COVID-19 negative tests per day per county
total	77 (22, 268)	Total number of COVID-19 tests per day per county
1 Median (IQR)

Historical Daily COVID-19 Test Results for Wisconsin Counties

Description

Raw data for the Indiana COVIDcast Dashboard that shows daily COVID-19 county test results for Wisconsin

File name

wisc-tests-complete.csv

Scripts

Collection: build-regional-dat.R

Raw Sources

Wisconsin Department of Health Services: COVID-19 Historical Data by County

Notes

Other variables:
- date: yyyy-mm-dd format; Daily
- county: County name

Variable	N = 25,9921	Definition
positive	476 (39, 2,404)	Number of COVID-19 positive tests per day per county
negative	6,313 (2,027, 16,655)	Number of COVID-19 negative tests per day per county
Missing	1,080
1 Median (IQR)