⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

46,480 rows where province_or_state = "Virginia" sorted by day descending

View and edit SQL

province_or_state

  • Virginia · 46,480

country_or_region

  • US 46,480
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
903969 2021-03-04 US Virginia Accomack 51001 2609 35 0 2574 37.76707161 -75.63234615 2021-03-05 05:26:29 Accomack, Virginia, US
903970 2021-03-04 US Virginia Albemarle 51003 4925 70 0 4855 38.02080697 -78.55481085 2021-03-05 05:26:29 Albemarle, Virginia, US
903971 2021-03-04 US Virginia Alexandria 51510 10389 123 0 10266 38.814003 -77.08183073 2021-03-05 05:26:29 Alexandria, Virginia, US
903972 2021-03-04 US Virginia Alleghany 51005 1252 47 0 1205 37.78636074 -80.00222498 2021-03-05 05:26:29 Alleghany, Virginia, US
903973 2021-03-04 US Virginia Amelia 51007 774 21 0 753 37.34081025 -77.98584649 2021-03-05 05:26:29 Amelia, Virginia, US
903974 2021-03-04 US Virginia Amherst 51009 2685 31 0 2654 37.60308293 -79.14548696 2021-03-05 05:26:29 Amherst, Virginia, US
903975 2021-03-04 US Virginia Appomattox 51011 1423 19 0 1404 37.37569884 -78.81340003 2021-03-05 05:26:29 Appomattox, Virginia, US
903976 2021-03-04 US Virginia Arlington 51013 13294 235 0 13059 38.8767675 -77.10139853 2021-03-05 05:26:29 Arlington, Virginia, US
903977 2021-03-04 US Virginia Augusta 51015 5216 66 0 5150 38.16404586 -79.12461614 2021-03-05 05:26:29 Augusta, Virginia, US
903978 2021-03-04 US Virginia Bath 51017 245 10 0 235 38.05852573 -79.73912095 2021-03-05 05:26:29 Bath, Virginia, US
903979 2021-03-04 US Virginia Bedford 51019 5816 73 0 5743 37.3080028 -79.5281964 2021-03-05 05:26:29 Bedford, Virginia, US
903980 2021-03-04 US Virginia Bland 51021 620 9 0 611 37.13128068 -81.13599391 2021-03-05 05:26:29 Bland, Virginia, US
903981 2021-03-04 US Virginia Botetourt 51023 2246 29 0 2217 37.55531756 -79.80982182 2021-03-05 05:26:29 Botetourt, Virginia, US
903982 2021-03-04 US Virginia Bristol 51520 1229 30 0 1199 36.6163024 -82.16359122 2021-03-05 05:26:29 Bristol, Virginia, US
903983 2021-03-04 US Virginia Brunswick 51025 1210 17 0 1193 36.76366949 -77.8593436 2021-03-05 05:26:29 Brunswick, Virginia, US
903984 2021-03-04 US Virginia Buchanan 51027 1299 35 0 1264 37.26818323 -82.03749726 2021-03-05 05:26:29 Buchanan, Virginia, US
903985 2021-03-04 US Virginia Buckingham 51029 2047 28 0 2019 37.57242268 -78.52518834 2021-03-05 05:26:29 Buckingham, Virginia, US
903986 2021-03-04 US Virginia Buena Vista 51530 843 18 0 825 37.73484642 -79.35296097 2021-03-05 05:26:29 Buena Vista, Virginia, US
903987 2021-03-04 US Virginia Campbell 51031 4030 63 0 3967 37.20553386 -79.09678609 2021-03-05 05:26:29 Campbell, Virginia, US
903988 2021-03-04 US Virginia Caroline 51033 1853 27 0 1826 38.02679129 -77.34901405 2021-03-05 05:26:29 Caroline, Virginia, US
903989 2021-03-04 US Virginia Carroll 51035 2127 64 0 2063 36.73066666 -80.73455942 2021-03-05 05:26:29 Carroll, Virginia, US
903990 2021-03-04 US Virginia Charles City 51036 408 12 0 396 37.35358063 -77.05634116 2021-03-05 05:26:29 Charles City, Virginia, US
903991 2021-03-04 US Virginia Charlotte 51037 751 14 0 737 37.01909701 -78.66314092 2021-03-05 05:26:29 Charlotte, Virginia, US
903992 2021-03-04 US Virginia Charlottesville 51540 3660 46 0 3614 38.03527919 -78.48569588 2021-03-05 05:26:29 Charlottesville, Virginia, US
903993 2021-03-04 US Virginia Chesapeake 51550 18395 222 0 18173 36.67670048 -76.30545744 2021-03-05 05:26:29 Chesapeake, Virginia, US
903994 2021-03-04 US Virginia Chesterfield 51041 23757 353 0 23404 37.37373208 -77.58680140000001 2021-03-05 05:26:29 Chesterfield, Virginia, US
903995 2021-03-04 US Virginia Clarke 51043 772 19 0 753 39.11271747 -77.99199425 2021-03-05 05:26:29 Clarke, Virginia, US
903996 2021-03-04 US Virginia Colonial Heights 51570 1381 45 0 1336 37.26420587 -77.39609676 2021-03-05 05:26:29 Colonial Heights, Virginia, US
903997 2021-03-04 US Virginia Covington 51580 551 11 0 540 37.7824656 -79.98631446 2021-03-05 05:26:29 Covington, Virginia, US
903998 2021-03-04 US Virginia Craig 51045 241 5 0 236 37.48133648 -80.21072274 2021-03-05 05:26:29 Craig, Virginia, US
903999 2021-03-04 US Virginia Culpeper 51047 4109 55 0 4054 38.48199985 -77.95630870000002 2021-03-05 05:26:29 Culpeper, Virginia, US
904000 2021-03-04 US Virginia Cumberland 51049 391 6 0 385 37.51328851 -78.24398086 2021-03-05 05:26:29 Cumberland, Virginia, US
904001 2021-03-04 US Virginia Danville 51590 4340 112 0 4228 36.58022376 -79.40395668 2021-03-05 05:26:29 Danville, Virginia, US
904002 2021-03-04 US Virginia Dickenson 51051 876 14 0 862 37.12560977 -82.35124171 2021-03-05 05:26:29 Dickenson, Virginia, US
904003 2021-03-04 US Virginia Dinwiddie 51053 1823 33 0 1790 37.07544585 -77.63451754 2021-03-05 05:26:29 Dinwiddie, Virginia, US
904004 2021-03-04 US Virginia Emporia 51595 619 40 0 579 36.69455571 -77.53406129 2021-03-05 05:26:29 Emporia, Virginia, US
904005 2021-03-04 US Virginia Essex 51057 644 7 0 637 37.93357639 -76.94230311 2021-03-05 05:26:29 Essex, Virginia, US
904006 2021-03-04 US Virginia Fairfax 51059 67192 985 0 66207 38.83677558 -77.27565836 2021-03-05 05:26:29 Fairfax, Virginia, US
904007 2021-03-04 US Virginia Fairfax City 51600 495 13 0 482 38.85157547 -77.29779640000002 2021-03-05 05:26:29 Fairfax City, Virginia, US
904008 2021-03-04 US Virginia Falls Church 51610 355 8 0 347 38.88485255 -77.17560759 2021-03-05 05:26:29 Falls Church, Virginia, US
904009 2021-03-04 US Virginia Fauquier 51061 3981 53 0 3928 38.73564842 -77.80647472 2021-03-05 05:26:29 Fauquier, Virginia, US
904010 2021-03-04 US Virginia Floyd 51063 740 18 0 722 36.9302126 -80.36738849 2021-03-05 05:26:29 Floyd, Virginia, US
904011 2021-03-04 US Virginia Fluvanna 51065 1300 16 0 1284 37.84157909 -78.27715475 2021-03-05 05:26:29 Fluvanna, Virginia, US
904012 2021-03-04 US Virginia Franklin 51067 3729 57 0 3672 36.99536167 -79.88023649 2021-03-05 05:26:29 Franklin, Virginia, US
904013 2021-03-04 US Virginia Franklin City 51620 999 27 0 972 36.6831435 -76.93859681 2021-03-05 05:26:29 Franklin City, Virginia, US
904014 2021-03-04 US Virginia Frederick 51069 6796 85 0 6711 39.20172582 -78.25974949 2021-03-05 05:26:29 Frederick, Virginia, US
904015 2021-03-04 US Virginia Fredericksburg 51630 1788 22 0 1766 38.2977863 -77.4922454 2021-03-05 05:26:29 Fredericksburg, Virginia, US
904016 2021-03-04 US Virginia Galax 51640 1000 49 0 951 36.66601852 -80.91703124 2021-03-05 05:26:29 Galax, Virginia, US
904017 2021-03-04 US Virginia Giles 51071 1087 15 0 1072 37.31234791 -80.70636931 2021-03-05 05:26:29 Giles, Virginia, US
904018 2021-03-04 US Virginia Gloucester 51073 1895 43 0 1852 37.40809042 -76.53524337 2021-03-05 05:26:29 Gloucester, Virginia, US
904019 2021-03-04 US Virginia Goochland 51075 1219 17 0 1202 37.71714806 -77.90381514 2021-03-05 05:26:29 Goochland, Virginia, US
904020 2021-03-04 US Virginia Grayson 51077 1133 34 0 1099 36.65677234 -81.23215889 2021-03-05 05:26:29 Grayson, Virginia, US
904021 2021-03-04 US Virginia Greene 51079 1012 9 0 1003 38.29545894 -78.46525378 2021-03-05 05:26:29 Greene, Virginia, US
904022 2021-03-04 US Virginia Greensville 51081 1464 25 0 1439 36.67878901 -77.56351439 2021-03-05 05:26:29 Greensville, Virginia, US
904023 2021-03-04 US Virginia Halifax 51083 2459 64 0 2395 36.76654925 -78.93512622 2021-03-05 05:26:29 Halifax, Virginia, US
904024 2021-03-04 US Virginia Hampton 51650 8738 127 0 8611 37.03513786 -76.35879121 2021-03-05 05:26:29 Hampton, Virginia, US
904025 2021-03-04 US Virginia Hanover 51085 6755 137 0 6618 37.7583355 -77.49464673 2021-03-05 05:26:29 Hanover, Virginia, US
904026 2021-03-04 US Virginia Harrisonburg 51660 5761 88 0 5673 38.43542574 -78.87536254 2021-03-05 05:26:29 Harrisonburg, Virginia, US
904027 2021-03-04 US Virginia Henrico 51087 21571 531 0 21040 37.53460572 -77.39326555 2021-03-05 05:26:29 Henrico, Virginia, US
904028 2021-03-04 US Virginia Henry 51089 4223 115 0 4108 36.68542395 -79.87634026 2021-03-05 05:26:29 Henry, Virginia, US
904029 2021-03-04 US Virginia Highland 51091 97 1 0 96 38.35799465 -79.56124594 2021-03-05 05:26:29 Highland, Virginia, US
904030 2021-03-04 US Virginia Hopewell 51670 2131 54 0 2077 37.29186313 -77.29754684 2021-03-05 05:26:29 Hopewell, Virginia, US
904031 2021-03-04 US Virginia Isle of Wight 51093 2672 55 0 2617 36.90579348 -76.70842863 2021-03-05 05:26:29 Isle of Wight, Virginia, US
904032 2021-03-04 US Virginia James City 51095 3886 63 0 3823 37.31156958 -76.76950618 2021-03-05 05:26:29 James City, Virginia, US
904033 2021-03-04 US Virginia King George 51099 1428 16 0 1412 38.26818502 -77.15852768 2021-03-05 05:26:29 King George, Virginia, US
904034 2021-03-04 US Virginia King William 51101 926 10 0 916 37.70965316 -77.09384941 2021-03-05 05:26:29 King William, Virginia, US
904035 2021-03-04 US Virginia King and Queen 51097 316 6 0 310 37.71044922 -76.88689628 2021-03-05 05:26:29 King and Queen, Virginia, US
904036 2021-03-04 US Virginia Lancaster 51103 670 13 0 657 37.71889653 -76.46400482 2021-03-05 05:26:29 Lancaster, Virginia, US
904037 2021-03-04 US Virginia Lee 51105 2300 42 0 2258 36.70586667 -83.12606515 2021-03-05 05:26:29 Lee, Virginia, US
904038 2021-03-04 US Virginia Lexington 51678 1122 26 0 1096 37.78258621 -79.44262866 2021-03-05 05:26:29 Lexington, Virginia, US
904039 2021-03-04 US Virginia Loudoun 51107 23272 250 0 23022 39.08990083 -77.63481877 2021-03-05 05:26:29 Loudoun, Virginia, US
904040 2021-03-04 US Virginia Louisa 51109 1693 24 0 1669 37.97850256 -77.96274807 2021-03-05 05:26:29 Louisa, Virginia, US
904041 2021-03-04 US Virginia Lunenburg 51111 656 6 0 650 36.94618528 -78.24133319 2021-03-05 05:26:29 Lunenburg, Virginia, US
904042 2021-03-04 US Virginia Lynchburg 51680 6932 133 0 6799 37.40021399 -79.19888138 2021-03-05 05:26:29 Lynchburg, Virginia, US
904043 2021-03-04 US Virginia Madison 51113 535 13 0 522 38.41531222 -78.28220331 2021-03-05 05:26:29 Madison, Virginia, US
904044 2021-03-04 US Virginia Manassas 51683 4018 41 0 3977 38.7464321 -77.48509905 2021-03-05 05:26:29 Manassas, Virginia, US
904045 2021-03-04 US Virginia Manassas Park 51685 1127 11 0 1116 38.77058531 -77.44399307 2021-03-05 05:26:29 Manassas Park, Virginia, US
904046 2021-03-04 US Virginia Martinsville 51690 1508 64 0 1444 36.68212094 -79.86352771 2021-03-05 05:26:29 Martinsville, Virginia, US
904047 2021-03-04 US Virginia Mathews 51115 555 11 0 544 37.44164146 -76.34098896 2021-03-05 05:26:29 Mathews, Virginia, US
904048 2021-03-04 US Virginia Mecklenburg 51117 2002 58 0 1944 36.67882005 -78.36131056 2021-03-05 05:26:29 Mecklenburg, Virginia, US
904049 2021-03-04 US Virginia Middlesex 51119 526 18 0 508 37.63191998 -76.55064617 2021-03-05 05:26:29 Middlesex, Virginia, US
904050 2021-03-04 US Virginia Montgomery 51121 7916 86 0 7830 37.17746986 -80.37868691 2021-03-05 05:26:29 Montgomery, Virginia, US
904051 2021-03-04 US Virginia Nelson 51125 778 9 0 769 37.78790447 -78.88498513 2021-03-05 05:26:29 Nelson, Virginia, US
904052 2021-03-04 US Virginia New Kent 51127 1255 12 0 1243 37.50694406 -76.99828634 2021-03-05 05:26:29 New Kent, Virginia, US
904053 2021-03-04 US Virginia Newport News 51700 11619 190 0 11429 37.08166899 -76.51754109 2021-03-05 05:26:29 Newport News, Virginia, US
904054 2021-03-04 US Virginia Norfolk 51710 15049 205 0 14844 36.89934014 -76.26420872 2021-03-05 05:26:29 Norfolk, Virginia, US
904055 2021-03-04 US Virginia Northampton 51131 724 34 0 690 37.34062933 -75.87751591 2021-03-05 05:26:29 Northampton, Virginia, US
904056 2021-03-04 US Virginia Northumberland 51133 669 19 0 650 37.89202088 -76.41949732 2021-03-05 05:26:29 Northumberland, Virginia, US
904057 2021-03-04 US Virginia Norton 51720 240 6 0 234 36.93357076 -82.62750411 2021-03-05 05:26:29 Norton, Virginia, US
904058 2021-03-04 US Virginia Nottoway 51135 1814 41 0 1773 37.1435975 -78.05065922 2021-03-05 05:26:29 Nottoway, Virginia, US
904059 2021-03-04 US Virginia Orange 51137 1867 30 0 1837 38.24530219 -78.01560400000002 2021-03-05 05:26:29 Orange, Virginia, US
904060 2021-03-04 US Virginia Page 51139 1836 53 0 1783 38.61807452 -78.48797204 2021-03-05 05:26:29 Page, Virginia, US
904061 2021-03-04 US Virginia Patrick 51141 1210 36 0 1174 36.6801638 -80.2865648 2021-03-05 05:26:29 Patrick, Virginia, US
904062 2021-03-04 US Virginia Petersburg 51730 3200 63 0 3137 37.20530399 -77.39368102 2021-03-05 05:26:29 Petersburg, Virginia, US
904063 2021-03-04 US Virginia Pittsylvania 51143 4784 69 0 4715 36.81980341 -79.39731264 2021-03-05 05:26:29 Pittsylvania, Virginia, US
904064 2021-03-04 US Virginia Poquoson 51735 726 15 0 711 37.14259351 -76.35798148 2021-03-05 05:26:29 Poquoson, Virginia, US
904065 2021-03-04 US Virginia Portsmouth 51740 7767 148 0 7619 36.85914825 -76.35971629 2021-03-05 05:26:29 Portsmouth, Virginia, US
904066 2021-03-04 US Virginia Powhatan 51145 1655 10 0 1645 37.55016038 -77.91267882 2021-03-05 05:26:29 Powhatan, Virginia, US
904067 2021-03-04 US Virginia Prince Edward 51147 1964 28 0 1936 37.22554789 -78.43597949 2021-03-05 05:26:29 Prince Edward, Virginia, US
904068 2021-03-04 US Virginia Prince George 51149 3017 16 0 3001 37.18497668 -77.22922187 2021-03-05 05:26:29 Prince George, Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);