Processed data for Demographics heatmaps that shows a breakdown of weekly COVID-19 cases by age group.
Processing: process-demog-data.R
Indiana Data Hub: COVID-19 CASE DEMOGRAPHICS
tidycensus R package: website, 2018 age populations for Indiana
Processed data for Demographics line charts that shows counts and trends of weekly COVID-19 deaths by age group.
Processing: process-demog-data.R
Indiana Data Hub: COVID-19 CASE DEMOGRAPHICS
Raw data for the Hospitals line charts that shows daily COVID-19 hospital admissions by age group and gender.
Collection: scrape-regenstrief-tableau.R
Regenstrief Institute: dashboard
Raw data for the Static Charts Hospitalizations, ICU Beds and Ventilator Availability that shows resource counts of ICU beds and ventilators.
Collection: build-datasets.R
Indiana Data Hub: COVID-19 BEDS AND VENTS
Processed data for the Google Maps Mobility Indices line chart that shows percent differences from a mobility baseline that was calculated during the 5-week period Jan 3 – Feb 6, 2020. These percent changes show how lengths-of-stay at different locations have changed from pre-pandemic conditions.
Miscellaneous: goog-mob-line.R
Google Mobility Reports: website
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.
Process: process-hospitals-data.R
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
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.
Process: process-hospitals-data.R
Department of Health and Human Services: COVID-19 Reported Patient Impact and Hospital Capacity by State Timeseries
Other variables: - 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
- avgCovIcuTenKList: 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 avgTotImpBeds, the average daily number of staffed total beds available over the weekly interval
|
1
n (%); Median (IQR)
|
Raw data for Demographics line charts that shows daily case and death counts by age group.
Collection: build-datasets.R
Indiana Data Hub: COVID-19 CASE DEMOGRAPHICS
Collection: build-datasets.R
The Covid Tracking Project: The COVID Racial Data Tracker
Processed data for the Demographics bubble chart that shows the number of tests, number of deaths, and median age of the cases per week.
Processing: process-demog-data.R
Indiana Data Hub: COVID-19 CASE DATA
Raw data for the Hospitals line charts that shows daily COVID-19 hospital admissions, hospital deaths, and hospital death rate.
Collection: scrape-regenstrief-tableau.R
Regenstrief Institute: dashboard
Processed data for the Indiana COVIDcast Dashboard that shows weekly positivity rate and daily cases per 100,000 residents per metropolitan statistical area.
Processing: process-hist-regional-dat.R
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
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 their positivity rates.
Other variables:
- 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
|
1
Range; n (%); Median (IQR)
|
Processed data for the Indiana COVIDcast Dashboard that shows historic daily values of Delphi Research Group’s Combined Indicator for each methropolitan statistical area.
Processing: process-dashboard-data.R
covidcast R package: website
Raw data for the Indiana COVIDcast Dashboard that shows various weekly COVID-19 county statistics for Illinois
Collection: build-regional-dat.R
Illinois Department of Public Health: website
These data are published in weekly intervals into a HTML table then scraped and collected.
There are other missing data not shown in the table below. Illinois DPH changes/improves the format of their webpage from time to time, and I haven’t been changing my scraping code to match in a timely manner. They do have a data portal which has cases, tests, and deaths for each county, but not a historical dataset with exact fields as below. Here are weekly ranges that are missing:
2021-7-18 to 2021-7-24
2021-7-25 to 2021-7-31
2021-9-12 to 2021-9-18
2021-9-5 to 2021-9-11
2021-9-26 to 2021-10-9
2021-10-10 to 2021-10-16
Other variables:
- week: int; week of the year
- 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>%”
|
1
Range; Median (IQR)
|
Raw data for the Indiana COVIDcast Dashboard that shows daily COVID-19 county test results for Indiana
Collection: build-regional-dat.R
Indiana Data Hub: COVID-19 COUNTY-WIDE TEST, CASE, AND DEATH TRENDS
Raw data for the Indiana COVIDcast Dashboard that shows daily COVID-19 county test results for Michigan
Collection: build-regional-dat.R
Michigan Department of Health and Human Services: COVID-19 Tests by County
Processed data for the OpenTable Year-Over-Year Seated Diners line charts that shows reservation data from a sample of restaurants across Indiana and other regional states. Each data point is the median daily percent difference in seated diners from 2019 to either 2020 or 2021 depending on the date.
Miscellaneous: opentab-rest-line.R
OpenTable: State of the Industry
Raw data for the Indiana COVIDcast Dashboard that shows daily COVID-19 county test results for Wisconsin
Collection: build-regional-dat.R
Wisconsin Department of Health Services: COVID-19 Historical Data by County