Virginia Covid-19 Numbers

5/9 update: I’ve added an Excel template you can use to take the downloaded file and get the daily numbers – it’s through today, all you need to do is copy/paste the download file from the VDH site on tab 2 and then on tab 1, copy the formulas from 5/9 to the next row.

Template for Daily Data

Hey – I won’t be updating this page anymore because I found the historical daily data you can download straight from the VDH website!  

If you go to the VDH website, and scroll down to the Data Download section, there are various datasets you can get that go back to the start of all this.  They are still cumulative numbers for each day, but it goes back to the start – when you open the files they do look like they may just be for the latest date, but if you scroll down, you’ll see how far they go back.

Screen Shot 2020-05-08 at 5.49.58 PM

 

I had mentioned on Twitter that I had been keeping day to day numbers on the Covid-19 cases in Virginia, and a couple folks were interested in it, so I’ve added it here, and will attempt to update it daily.  All the data has come from the Virginia Department of Health website.

The formatting on screen is a little janky, and I don’t seem to be able to get wordpress to put in visible vertical lines between the columns, but you can copy and paste it to excel and the columns/rows should stay intact. If you can’t see all nine columns on your screen, there should be a scrollbar at the bottom of the table.

Obviously, this shouldn’t be a substitute for listening to your personal physician and Virginia public health officials.

Updated 5/8/20

DateAll TestsAll Pos.All Hosp.All DeathsDaily TestsDaily Pos.Daily Hosp.Daily Deaths
3/14/20*39541 1    
3/15/2040845 1134 0
3/16/2048951 2816 1
3/17/20*102867 253916 0
3/18/20127877 225010 0
3/19/20*19239419264517 0
3/20/2023251141924022000
3/21/2027901522524653860
3/22/2033372193235476771
3/23/2036972543863603563
3/24/2044702904577733671
3/25/205370391599900101142
3/26/20618946065138196964
3/27/20733760483141148144181
3/28/20916673999171829135163
3/29/2010609890112221443151135
3/30/20120381020136251429130243
3/31/20134011250165271363230292
4/1/20153441484208341943234437
4/2/20175891706246412245222387
4/3/20190052012312461416306665
4/4/20215522407390522547395786
4/5/20*23671263743151211923041-1
4/6/2024521287849754850241663
4/7/20286453333563634124455669
4/8/203064536456157520003125212
4/9/2033026404268510923813977034
4/10/2035459450977212124334678712
4/11/203799950778371302540568659
4/12/2039985527487214119861973511
4/13/204140157479031491416473318
4/14/204276361719781541362424755
4/15/20441696500104819514063297041
4/16/20464446889111420822753896613
4/17/204899774911221231255360210723
4/18/20519318093129625829346027527
4/19/205473385371422277280244412619
4/20/20567358990150030020024537823
4/21/20583549630158132416196408124
4/22/206077810266165934924246367825
4/23/206451810998175337237407329423
4/24/20 69015115941837 4104497596 84 38 
4/25/2072178123661942436316377210526
4/26/20 76118 12970 2014 448 3940 604 72 12
4/27/20 80180 13535 2066 458 4062 565 52 10
4/28/20 82753 14339 2165 492 2573 804 99 34
4/29/20 85307 14961 2259 522 2554 622 94 30
4/30/20 90843 15846 2322 552 5536 885 63 30
5/1/20* 105648 16901 2416 581 14805 1055 94 29
5/2/20*112450177312519616680283010335
5/3/20 11906518671 2627 660 6615 940 108 44 
5/4/20 122788 19492 2700 684 3723 821 7324
5/5/20 127938 20256 2773 713 5150 764 73 29
5/6/20*No data       
5/7/20* 136558 21570 2955 769 8620 1314 182 56
5/8/20 143220 22342 3059 812 6662 772 10443
         

 

*3/14/20 – This is when I started daily tracking. Virginia’s first case was on 3/7/20.
*3/17/20 – I believe this is when they started getting data from commercial labs on negative tests, hence the big spike in testing.
*3/19/20 – This is when they started reporting hospitalizations
*4/5/20 – RE: Deaths, not sure if this was a retroactive correction on the site or if I wrote the cumulative number down wrong
*4/21/20 – Positives, Hospitalizations, & Deaths are Confirmed & Probable combined.
*5/1/20 – Methodology change on total tests – had been 1 = 1 person, regardless of how many times they were tested, now it is all tests.
*5/2/20 – VDH is now reporting Total People Tested & Total Unique People Tested. These numbers are Total People Tested from 5/1 forward.
*5/6-7 – No data for 5/6, the “daily” numbers for 5/7 are the 5/7 cumulatives less the 5/5 cumulatives.