COVID-19 NE Dataset

COVID-19 Dataset for Correlation Between Early Government Interventions in the Northeastern United States and Peak COVID-19 Disease Burden by Joel Mintz.
File Type: Excel
Contents: Tab 1 ("Raw")=Raw Data as Downloaded directly from COVID Tracking Project, sorted by date
Tab 2-14 ("State Name') = Data Sorted by State
Tab 2-14 Headers: Column 1: Population per state, as recorded by latest American Community Survey, maximum (peak) COVID-19 outcome, with date on which outcome occurred.
Column 2: Date on which numbers were recorded*
Column 3: State Name*
Column 4: Number of reported positive COVID-19 tests*
Column 5: Number of reported negative COVID-19 tests*
Column 6: Pending COVID-19 tests*
Column 7: Currently Hospitalized*
Column 8: Cumulatively Hospitalized*
Column 9: Currently in ICU*
Column 10: Cumulatively in ICU*
Column 11: Currently on Ventilator Support*
Column 12: Cumulatively on Ventilator Support*
Column 13: Total Recovered*
Column 14: Cumulative Mortality*
*Provided in Original Raw Data
Column 15: Total Tests Administered (Column 4+Column 5)
Column 16: Placeholder
Column 17: % of total population tested
Column 18: New Cases Per day
Column 19: Change in new cases per day
Column 20: Positive cases per day per capita in number per/ hundreds of thousands: (Column 18/total population*100000)
Column 21: Change in Positive cases per day per capita in number per/ hundreds of thousands: (Column 19/total population*100000)
Column 22: Hospitalizations per day per capita in number per/ hundreds of thousands
Column 23: Change in Hospitalizations per day per capita in number per/ hundreds of thousands
Column 24: Deaths per day per capita in number per/ hundreds of thousands
Column 25: Change in Deaths per day per capita in number per/ hundreds of thousands
Column 26-31: Columns 20-25 with an applied 5 day moving average filter
Column 32: Adjusted hospitalization: (Subtract number of hospitalizations from the initial number of hospitalzations where reporting bean)
Column 33: Adjusted hospitalizations per day per capita
Column 34: Adjusted hospitalizations per day per capita, with applied 5 day moving average filter