Virginia COVID-19 Data Timeline

0PENalbert1979 - July 10, 2020July 10, 2020

After coming across this spread sheet documenting the UK government’s COVID-19 data responses, I immediately began one covering Virginia’s responses, as well as the federal government’s responses regarding data for Virginia: Timeline: Virginia Government, Virginia Locality, and Federal Government Coronavirus and Data. The Google Sheet can also be viewed below:

Date	Note
2020-04-20	VDH says they are integrating VADOC data – VDH data does not match VADOC data
2020-04-21	VDH site updates: UPDATE: 4/21/20 Starting this week, VDH will begin reporting: Cases, hospitalizations, and fatalities at the locality level Cases, hospitalizations, and fatalities by demographics at the district level Ability to differentiate between confirmed and probable cases Rates per 100,000 population
2020-04-21	VDH updates data sets, starts offering Cases, hospitalizations, and fatalities at the locality level VDH COVID-19-PublicUseDataset-Cases Ability to differentiate between confirmed and probable cases VDH-COVID-19-PublicUseDataset-Cases_By-Confirmation Cases, hospitalizations, and fatalities by demographics at the district level VDH-COVID-19-PublicUseDataset-Cases_By-District-Death-Hospitalization VDH COVID-19-PublicUseDataset-Cases_By Sex VDH COVID-19-PublicUseDataset-Cases_By Race VDH COVID-19-PublicUseDataset-Cases_By Age Group
2020-04-21	VDH updated the Weekly COVID-19 Activity Report.
2020-04-21	VHHA data is missing information in one box
2020-04-22	VHHA data is missing information in one box
2020-04-22	VDH data not released until after 5pm; headers changed, did not inform public via Twitter. need to look for rss feed/maybe they posted something
2020-04-23	VHHA data is missing information in one box
2020-04-23	VDH updates data sets now includes historical data of cumulative counts by date
2020-04-23	VDH Rolls out Testing Sites Info: http://www.vdh.virginia.gov/coronavirus/covid-19-testing-sites
2020-04-23	VADOC updates info page with Virginia Department of Corrections COVID-19 Early Release Plan: https://vadoc.virginia.gov/media/1506/vadoc-covid19-early-release-plan.pdf
2020-04-24	VDH public use dataset changes order again
2020-04-26	VADOC changes table layout/headers
2020-04-27	VDH rolls out HTTPS
2020-04-28	Weekly report that was supposed to issue on Mondays, but was doing on Tuesdays, is not released: https://www.vdh.virginia.gov/coronavirus/weekly-report/
2020-04-30	VDH posts this regarding weekly reporting: VDH is improving and reformatting the way we present COVID-19 epidemiologic data. Please check back on Friday, May 1st for the latest information. The Weekly COVID-19 Activity Report will be rebranded as COVID-19 Data Insights, which will complement the daily COVID-19 Cases in Virginia report with more in-depth analyses. VDH will update the COVID-19 Data Insights as new analyses become available. We will continue to use the subscription service to distribute these Insights updates.
2020-05-01	VDH rolls out new dataset, deviating from previous versions. VDH also rolls out some new data in-sight dashboard in tableau.
2020-05-02	VADOC no update as of 1552 2020-05-02. VDH: UPDATE: 05/02/20 – A new data set with daily counts by event date has been added; VDH UPDATE: 05/02/20 – A new data set with counts by ethnicity has been added;
2020-05-02	VDH post regarding 2020-05-01 data changes: https://www.vdh.virginia.gov/coronavirus/2020/05/02/data-improvements/
2020-05-04	VDH removes “COVID Like Illness” tab from Data Insights blog: http://web.archive.org/web/20200502194122/https://www.vdh.virginia.gov/coronavirus/covid-19-data-insights/
2020-05-05	VDH rolls out key measures. as of 1410hrs 2020-05-05, key measures page is blank. UPDATE: probably just caught them as they were updating it…
2020-05-05	VDH rolls out key measures datasets: Virginia’s Key Measures of COVID-19 UPDATE: 05/05/20 – New data sets have been added: VDH-COVID-19-PublicUseDataset-KeyMeasures-Hospitals VDH-COVID-19-PublicUseDataset-KeyMeasures-Labs
2020-05-05	VA site back up after being down for “ux fixes”; changed data format/output and even naming conventions for VA sites, also removed lat lon locations after i reported them being incorrect: https://www.accesstocare.va.gov/Healthcare/COVID19NationalSummary
2020-05-05	VHHA adds new data field “Beds Added Under Executive Order 52”
2020-05-06	VDH releases no data; “Important Update: The overnight process to compile all of the investigation and laboratory report data experienced a technical error that has resulted in information being unavailable for reporting. VDH is working to resolve the error, and will update information as soon as possible.”
2020-05-07	VDH releases zip code dataset; adds “How is VDH Calculating the Number of People Tested?” post; adds “COVID-19 Case and Testing Data by ZIP Code” tab to data insights; creates “Key Measures” https://www.vdh.virginia.gov/coronavirus/key-measures/
2020-05-07	VDH zip code dataset values include commas in number values.
2020-05-08	VDH removes dates/update notices on datasets…
2020-05-12	VDH Key Measures Hospital data moves date column
2020-05-13	VDH Key Measures Hospital data moves data column back
2020-05-14	VDH Key Measures Hospital data moves date column
2020-05-14	VDH publishes testing data press release, doesn’t include it in covid-19 landing page, or data insights blog….: https://www.vdh.virginia.gov/news/2020-news-releases/virginia-department-of-health-releases-disaggregated-testing-data-no-differences-in-trends/
2020-05-15	VDH changes URI of public use cases dataset; drops key measures labs dataset, adds a new dataset test by lab report date
2020-05-16	VDH Key Measures Hospital data moves data column back again
2020-05-17	VDH Key Measures Hospital data moves data column back again
2020-05-18	VDH zip codes dataset removes commas from four digit numbers
2020-05-21	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate dataset reports earliest COVID-19 case in Virginia was in 1978.
2020-05-22	VDH VDH-COVID-19-PublicUseDataset-EventDate dataset changes headers. From “Event Date,Case Status,Number of Cases,Number of Hospitalizations,Number of Deaths” to “Event Date,Health Planning Region,Case Status,Number of Cases,Number of Hospitalizations,Number of Deaths”
2020-05-23	VVA DOC not updating data table because of system maintenance; VDH rolls out Northern Virginia Key Measures and statewide key measures; cant tell what was there before because tableau sucks https://www.vdh.virginia.gov/coronavirus/key-measures/
2020-05-24	VDH rolls out Multisystem Inflammatory Syndrome in Children (MIS-C) Data VDH-COVID-19-PublicUseDataset-MIS-C dataset”
2020-05-25	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate dataset reports earliest COVID-19 case in Virginia was in 1978 and second earliest 2019.
2020-05-26	VVBSO starts reporting data again after taking the weekend off + memorial day off
2020-05-27	VHHA number of total nursing homes changes from 287 to 286; VDH adds COVID-Like Illness Visits Tableau deck to data insights: https://www.vdh.virginia.gov/coronavirus/covid-19-data-insights/
2020-05-29	VA State Support dataset switches reporting details, no not listing where personnel are, new listings… https://www.va.gov/health/coronavirus/statesupport.asp
2020-05-29	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate dataset now reporting first three dates detected, 1978, 1987, 2019
2020-05-30	VDH revises data policies: https://www.vdh.virginia.gov/news/2020-news-releases/virginia-department-of-health-revises-method-of-reporting-test-data-updated-information-available-beginning-may-30/
2020-05-30	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate datasets earliest five reporting dates are now 1978, 1987, 2002, 2002, and 2019. (2019-05-28,2002-05-27, 2002-05-20, 1987-07-25, 1978-08-15)
2020-06-01	VICE changes format, layout, reporting
2020-06-11	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate dataset reports earliest dates change; earliest now is 2020-01-26
2020-06-12	VDH reports: June 10th: 4 outbreaks in independent living communities were previously classified as long term care facility outbreaks. We have re-classified these cases as “congregate living” outbreaks, which is more accurate given the nature of the residential, non-assisted communities in which they occured. As a result, outbreaks in long term care facilities decreased by 4, and outbreaks in congregate settings increased by 4. This change is in addition to 4 newly reported outbreaks in a congregate setting and 0 newly reported outbreaks in a long term care facility setting.
2020-06-15	VDH New Dataset: VDH-COVID-19-PublicUseDataset-Cases_By-Race-Ethnicity
2020-06-16	VDH releases new NH directory: https://www.vdh.virginia.gov/licensure-and-certification/the-division-of-long-term-care/ltc-directory/ previous version (linked to in a virginia mercury post) now 404s: https://www.vdh.virginia.gov/licensure-and-certification/the-division-of-long-term-care/directory-of-long-term-care-facilities/
2020-06-16	VDH launches COVID Check or something: https://www.vdh.virginia.gov/coronavirus/covidcheck/
2020-06-16	VDH releases data insight blog posts at 7pm via rss. hours after new dataset release: Race and Ethnicity Reporting Update June 16, 2020 https://www.vdh.virginia.gov/coronavirus/2020/06/16/race-and-ethnicity-reporting-update/ COVID-19 Like Emergency Department Visits by Race & Ethnicity – Updated June 16, 2020 https://www.vdh.virginia.gov/coronavirus/2020/06/16/cli_ed_race_eth/
2020-06-17	VDH update, eliminates race/ethnicity datasets: Update 06/17/2020: The individual Race and Ethnicity data sets downloads are now combined into a single data set to align with the recent guidance of “VDH has combined race and ethnicity information into one category and expanded the number of racial identities from three to seven, the new categories are aligned with race and ethnicity standards used by various state and federal agencies.”
2020-06-17	DVS ends almost two month silence about cases with new case here: https://www.dvs.virginia.gov/news-room/covid-19-case-at-virginia-veterans-care-center
2020-06-19	VDH releases LTCF dataset in friday data dump, buried in executive order post. Furthermore, dataset is not machine readable, only available in tableau, doesn’t offer data download, and is not placed with the rest of the datasets on the Coronavirus landing page of VDH.
2020-06-23	VHHA Nursing Homes number of total nursing homes changed from 286 to 285
2020-06-24	LTCF tableau deck finally offers export other than ppt, image, pdf; csv download is not valid
2020-06-27	VDH Test Key Lab Report Date dataset reverses order in date column
2020-06-28	VDH Test Key Lab Report Date dateset date column now reporting in international standard. No other datasets using this date format.
2020-06-29	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate reverts back to original date order in date column, no longer applying international format to dates
2020-06-29	VDH media room markup is broken.
2020-06-30	VDH LTCF Tableau Dashboard reverts to not allowing data downloads
2020-07-01	VDH VDH-COVID-19-PublicUseDataset-Cases_By-Race-Ethnicity dataset rearranges column order and starts publishing data value as date published; previous datasets published date value was 1 day behind date published
2020-07-01	VDH VDH-COVID-19-PublicUseDataset-EventDate dataset was produced with the date column not in descending order as per usual, but a general order of nothing matters….
2020-07-01	VDH VDH-COVID-19-PublicUseDataset-EventDate dataset also is lost 15 records between the two days.
2020-07-01	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate dataset was produced with the date columm in international format.
2020-07-01	VDH VDH-COVID-19-PublicUseDataset-Tests_by-LabReportDate dataset date column was not in descending order as per usual, but a general order of nothing matters….
2020-07-01	VDH VDH-COVID-19-PublicUseDataset-Outbreaks_By-Date dataset date column was not in descending order as per usual, but a general order of nothing matters…
2020-07-01	VDH VDH-COVID-19-PublicUseDataset-Cases_By-Race-Ethnicity dataset rearranges column order and starts publishing data value as date published; previous datasets published date value was 1 day behind date published
2020-07-02	VDH VDH-COVID-19-PublicUseDataset-EventDate dataset data column now in decending order
2020-07-02	VDH LTCF Tableau Dashboard reverts back to allowing data downloads
2020-07-03	VDH LTCF Tableau Dashboard reverts back to not allowing data downloads
2020-07-03	VDH VDH-COVID-19-PublicUseDataset-EventDate dataset back to having date column not in descending order as per usual, but a general order of nothing matters….
2020-07-03	VDH Test Key Lab Report Date dataset drops Not Reported data/rows
2020-07-04	VDH finally publishes VDH-COVID-19-PublicUseDataset-LTCF-Outbreaks as machine-readable CSV like the rest of its datasets.
2020-07-07	VDH Test Key Lab Report Date dataset adds Not Reported data/rows back
2020-07-09	VDH LTCF machine-readable CSV is not the same as the LTCF data being published in the Tableau dashboards.

Leave a Comment Cancel reply