johns_hopkins_csse_daily_reports

⚠️ 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

18,608 rows where province_or_state = "Virginia" sorted by day descending

View and edit SQL

province_or_state

  • Virginia · 18,608

country_or_region

  • US 18,608
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391084 2020-08-08 US Virginia Accomack 51001 1095 16 0 1079 37.76707161 -75.63234615 2020-08-09 04:34:54 Accomack, Virginia, US
391116 2020-08-08 US Virginia Albemarle 51003 833 16 0 817 38.02080697 -78.55481085 2020-08-09 04:34:54 Albemarle, Virginia, US
391123 2020-08-08 US Virginia Alexandria 51510 2949 60 0 2889 38.814003 -77.08183073 2020-08-09 04:34:54 Alexandria, Virginia, US
391131 2020-08-08 US Virginia Alleghany 51005 62 4 0 58 37.78636074 -80.00222498 2020-08-09 04:34:54 Alleghany, Virginia, US
391142 2020-08-08 US Virginia Amelia 51007 79 2 0 77 37.34081025 -77.98584649 2020-08-09 04:34:54 Amelia, Virginia, US
391143 2020-08-08 US Virginia Amherst 51009 165 0 0 165 37.60308293 -79.14548696 2020-08-09 04:34:54 Amherst, Virginia, US
391164 2020-08-08 US Virginia Appomattox 51011 84 0 0 84 37.37569884 -78.81340003 2020-08-09 04:34:54 Appomattox, Virginia, US
391172 2020-08-08 US Virginia Arlington 51013 3062 135 0 2927 38.8767675 -77.10139853 2020-08-09 04:34:54 Arlington, Virginia, US
391197 2020-08-08 US Virginia Augusta 51015 275 4 0 271 38.16404586 -79.12461614 2020-08-09 04:34:54 Augusta, Virginia, US
391240 2020-08-08 US Virginia Bath 51017 4 0 0 4 38.05852573 -79.73912095 2020-08-09 04:34:54 Bath, Virginia, US
391260 2020-08-08 US Virginia Bedford 51019 347 7 0 340 37.3080028 -79.5281964 2020-08-09 04:34:54 Bedford, Virginia, US
391311 2020-08-08 US Virginia Bland 51021 11 0 0 11 37.13128068 -81.13599391 2020-08-09 04:34:54 Bland, Virginia, US
391335 2020-08-08 US Virginia Botetourt 51023 212 7 0 205 37.55531756 -79.80982182 2020-08-09 04:34:54 Botetourt, Virginia, US
391365 2020-08-08 US Virginia Bristol 51520 77 0 0 77 36.6163024 -82.16359122 2020-08-09 04:34:54 Bristol, Virginia, US
391386 2020-08-08 US Virginia Brunswick 51025 227 2 0 225 36.76366949 -77.8593436 2020-08-09 04:34:54 Brunswick, Virginia, US
391391 2020-08-08 US Virginia Buchanan 51027 77 0 0 77 37.26818323 -82.03749726 2020-08-09 04:34:54 Buchanan, Virginia, US
391392 2020-08-08 US Virginia Buckingham 51029 605 8 0 597 37.57242268 -78.52518834 2020-08-09 04:34:54 Buckingham, Virginia, US
391395 2020-08-08 US Virginia Buena Vista 51530 50 1 0 49 37.73484642 -79.35296097 2020-08-09 04:34:54 Buena Vista, Virginia, US
391467 2020-08-08 US Virginia Campbell 51031 206 2 0 204 37.20553386 -79.09678609 2020-08-09 04:34:54 Campbell, Virginia, US
391485 2020-08-08 US Virginia Caroline 51033 206 5 0 201 38.02679129 -77.34901405 2020-08-09 04:34:54 Caroline, Virginia, US
391498 2020-08-08 US Virginia Carroll 51035 327 13 0 314 36.73066666 -80.73455942 2020-08-09 04:34:54 Carroll, Virginia, US
391545 2020-08-08 US Virginia Charles City 51036 52 5 0 47 37.35358063 -77.05634116 2020-08-09 04:34:54 Charles City, Virginia, US
391550 2020-08-08 US Virginia Charlotte 51037 53 0 0 53 37.01909701 -78.66314092 2020-08-09 04:34:54 Charlotte, Virginia, US
391551 2020-08-08 US Virginia Charlottesville 51540 537 15 0 522 38.03527919 -78.48569588 2020-08-09 04:34:54 Charlottesville, Virginia, US
391576 2020-08-08 US Virginia Chesapeake 51550 2872 37 0 2835 36.67670048 -76.30545744 2020-08-09 04:34:54 Chesapeake, Virginia, US
391582 2020-08-08 US Virginia Chesterfield 51041 4350 80 0 4270 37.37373208 -77.58680140000001 2020-08-09 04:34:54 Chesterfield, Virginia, US
391634 2020-08-08 US Virginia Clarke 51043 71 0 0 71 39.11271747 -77.99199425 2020-08-09 04:34:54 Clarke, Virginia, US
391701 2020-08-08 US Virginia Colonial Heights 51570 197 21 0 176 37.26420587 -77.39609676 2020-08-09 04:34:54 Colonial Heights, Virginia, US
391747 2020-08-08 US Virginia Covington 51580 13 0 0 13 37.7824656 -79.98631446 2020-08-09 04:34:54 Covington, Virginia, US
391752 2020-08-08 US Virginia Craig 51045 17 0 0 17 37.48133648 -80.21072274 2020-08-09 04:34:54 Craig, Virginia, US
391783 2020-08-08 US Virginia Culpeper 51047 996 12 0 984 38.48199985 -77.95630870000002 2020-08-09 04:34:54 Culpeper, Virginia, US
391791 2020-08-08 US Virginia Cumberland 51049 76 0 0 76 37.51328851 -78.24398086 2020-08-09 04:34:54 Cumberland, Virginia, US
391816 2020-08-08 US Virginia Danville 51590 395 7 0 388 36.58022376 -79.40395668 2020-08-09 04:34:54 Danville, Virginia, US
391879 2020-08-08 US Virginia Dickenson 51051 40 1 0 39 37.12560977 -82.35124171 2020-08-09 04:34:54 Dickenson, Virginia, US
391888 2020-08-08 US Virginia Dinwiddie 51053 217 7 0 210 37.07544585 -77.63451754 2020-08-09 04:34:54 Dinwiddie, Virginia, US
391977 2020-08-08 US Virginia Emporia 51595 174 15 0 159 36.69455571 -77.53406129 2020-08-09 04:34:54 Emporia, Virginia, US
391989 2020-08-08 US Virginia Essex 51057 99 1 0 98 37.93357639 -76.94230311 2020-08-09 04:34:54 Essex, Virginia, US
391996 2020-08-08 US Virginia Fairfax 51059 16302 529 0 15773 38.83677558 -77.27565836 2020-08-09 04:34:54 Fairfax, Virginia, US
391997 2020-08-08 US Virginia Fairfax City 51600 85 7 0 78 38.85157547 -77.29779640000002 2020-08-09 04:34:54 Fairfax City, Virginia, US
392005 2020-08-08 US Virginia Falls Church 51610 60 6 0 54 38.88485255 -77.17560759 2020-08-09 04:34:54 Falls Church, Virginia, US
392011 2020-08-08 US Virginia Fauquier 51061 614 9 0 605 38.73564842 -77.80647472 2020-08-09 04:34:54 Fauquier, Virginia, US
392042 2020-08-08 US Virginia Floyd 51063 57 2 0 55 36.9302126 -80.36738849 2020-08-09 04:34:54 Floyd, Virginia, US
392043 2020-08-08 US Virginia Fluvanna 51065 188 9 0 179 37.84157909 -78.27715475 2020-08-09 04:34:54 Fluvanna, Virginia, US
392079 2020-08-08 US Virginia Franklin 51067 168 1 0 167 36.99536167 -79.88023649 2020-08-09 04:34:54 Franklin, Virginia, US
392081 2020-08-08 US Virginia Franklin City 51620 178 6 0 172 36.6831435 -76.93859681 2020-08-09 04:34:54 Franklin City, Virginia, US
392083 2020-08-08 US Virginia Frederick 51069 680 9 0 671 39.20172582 -78.25974949 2020-08-09 04:34:54 Frederick, Virginia, US
392084 2020-08-08 US Virginia Fredericksburg 51630 400 3 0 397 38.2977863 -77.4922454 2020-08-09 04:34:54 Fredericksburg, Virginia, US
392106 2020-08-08 US Virginia Galax 51640 346 24 0 322 36.66601852 -80.91703124 2020-08-09 04:34:54 Galax, Virginia, US
392140 2020-08-08 US Virginia Giles 51071 23 0 0 23 37.31234791 -80.70636931 2020-08-09 04:34:54 Giles, Virginia, US
392153 2020-08-08 US Virginia Gloucester 51073 156 2 0 154 37.40809042 -76.53524337 2020-08-09 04:34:54 Gloucester, Virginia, US
392160 2020-08-08 US Virginia Goochland 51075 161 7 0 154 37.71714806 -77.90381514 2020-08-09 04:34:54 Goochland, Virginia, US
392202 2020-08-08 US Virginia Grayson 51077 152 5 0 147 36.65677234 -81.23215889 2020-08-09 04:34:54 Grayson, Virginia, US
392222 2020-08-08 US Virginia Greene 51079 154 2 0 152 38.29545894 -78.46525378 2020-08-09 04:34:54 Greene, Virginia, US
392224 2020-08-08 US Virginia Greensville 51081 463 11 0 452 36.67878901 -77.56351439 2020-08-09 04:34:54 Greensville, Virginia, US
392258 2020-08-08 US Virginia Halifax 51083 153 1 0 152 36.76654925 -78.93512622 2020-08-09 04:34:54 Halifax, Virginia, US
392278 2020-08-08 US Virginia Hampton 51650 1210 7 0 1203 37.03513786 -76.35879121 2020-08-09 04:34:54 Hampton, Virginia, US
392290 2020-08-08 US Virginia Hanover 51085 641 32 0 609 37.7583355 -77.49464673 2020-08-09 04:34:54 Hanover, Virginia, US
392323 2020-08-08 US Virginia Harrisonburg 51660 1076 31 0 1045 38.43542574 -78.87536254 2020-08-09 04:34:54 Harrisonburg, Virginia, US
392350 2020-08-08 US Virginia Henrico 51087 3839 184 0 3655 37.53460572 -77.39326555 2020-08-09 04:34:54 Henrico, Virginia, US
392360 2020-08-08 US Virginia Henry 51089 579 7 0 572 36.68542395 -79.87634026 2020-08-09 04:34:54 Henry, Virginia, US
392371 2020-08-08 US Virginia Highland 51091 6 0 0 6 38.35799465 -79.56124594 2020-08-09 04:34:54 Highland, Virginia, US
392394 2020-08-08 US Virginia Hopewell 51670 269 5 0 264 37.29186313 -77.29754684 2020-08-09 04:34:54 Hopewell, Virginia, US
392462 2020-08-08 US Virginia Isle of Wight 51093 383 9 0 374 36.90579348 -76.70842863 2020-08-09 04:34:54 Isle of Wight, Virginia, US
392492 2020-08-08 US Virginia James City 51095 602 16 0 586 37.31156958 -76.76950618 2020-08-09 04:34:54 James City, Virginia, US
392611 2020-08-08 US Virginia King George 51099 141 4 0 137 38.26818502 -77.15852768 2020-08-09 04:34:54 King George, Virginia, US
392612 2020-08-08 US Virginia King William 51101 87 2 0 85 37.70965316 -77.09384941 2020-08-09 04:34:54 King William, Virginia, US
392613 2020-08-08 US Virginia King and Queen 51097 39 1 0 38 37.71044922 -76.88689628 2020-08-09 04:34:54 King and Queen, Virginia, US
392688 2020-08-08 US Virginia Lancaster 51103 36 0 0 36 37.71889653 -76.46400482 2020-08-09 04:34:54 Lancaster, Virginia, US
392740 2020-08-08 US Virginia Lee 51105 114 1 0 113 36.70586667 -83.12606515 2020-08-09 04:34:54 Lee, Virginia, US
392760 2020-08-08 US Virginia Lexington 51678 33 0 0 33 37.78258621 -79.44262866 2020-08-09 04:34:54 Lexington, Virginia, US
392824 2020-08-08 US Virginia Loudoun 51107 5254 115 0 5139 39.08990083 -77.63481877 2020-08-09 04:34:54 Loudoun, Virginia, US
392826 2020-08-08 US Virginia Louisa 51109 182 2 0 180 37.97850256 -77.96274807 2020-08-09 04:34:54 Louisa, Virginia, US
392839 2020-08-08 US Virginia Lunenburg 51111 62 1 0 61 36.94618528 -78.24133319 2020-08-09 04:34:54 Lunenburg, Virginia, US
392844 2020-08-08 US Virginia Lynchburg 51680 591 5 0 586 37.40021399 -79.19888138 2020-08-09 04:34:54 Lynchburg, Virginia, US
392880 2020-08-08 US Virginia Madison 51113 68 1 0 67 38.41531222 -78.28220331 2020-08-09 04:34:54 Madison, Virginia, US
392887 2020-08-08 US Virginia Manassas 51683 1643 22 0 1621 38.7464321 -77.48509905 2020-08-09 04:34:54 Manassas, Virginia, US
392888 2020-08-08 US Virginia Manassas Park 51685 513 7 0 506 38.77058531 -77.44399307 2020-08-09 04:34:54 Manassas Park, Virginia, US
392939 2020-08-08 US Virginia Martinsville 51690 202 3 0 199 36.68212094 -79.86352771 2020-08-09 04:34:54 Martinsville, Virginia, US
392949 2020-08-08 US Virginia Mathews 51115 18 0 0 18 37.44164146 -76.34098896 2020-08-09 04:34:54 Mathews, Virginia, US
392993 2020-08-08 US Virginia Mecklenburg 51117 440 32 0 408 36.67882005 -78.36131056 2020-08-09 04:34:54 Mecklenburg, Virginia, US
393029 2020-08-08 US Virginia Middlesex 51119 37 1 0 36 37.63191998 -76.55064617 2020-08-09 04:34:54 Middlesex, Virginia, US
393105 2020-08-08 US Virginia Montgomery 51121 301 3 0 298 37.17746986 -80.37868691 2020-08-09 04:34:54 Montgomery, Virginia, US
393164 2020-08-08 US Virginia Nelson 51125 45 0 0 45 37.78790447 -78.88498513 2020-08-09 04:34:54 Nelson, Virginia, US
393175 2020-08-08 US Virginia New Kent 51127 127 1 0 126 37.50694406 -76.99828634 2020-08-09 04:34:54 New Kent, Virginia, US
393182 2020-08-08 US Virginia Newport News 51700 1816 18 0 1798 37.08166899 -76.51754109 2020-08-09 04:34:54 Newport News, Virginia, US
393203 2020-08-08 US Virginia Norfolk 51710 3700 30 0 3670 36.89934014 -76.26420872 2020-08-09 04:34:54 Norfolk, Virginia, US
393208 2020-08-08 US Virginia Northampton 51131 296 29 0 267 37.34062933 -75.87751591 2020-08-09 04:34:54 Northampton, Virginia, US
393210 2020-08-08 US Virginia Northumberland 51133 71 2 0 69 37.89202088 -76.41949732 2020-08-09 04:34:54 Northumberland, Virginia, US
393213 2020-08-08 US Virginia Norton 51720 18 0 0 18 36.93357076 -82.62750411 2020-08-09 04:34:54 Norton, Virginia, US
393214 2020-08-08 US Virginia Nottoway 51135 182 13 0 169 37.1435975 -78.05065922 2020-08-09 04:34:54 Nottoway, Virginia, US
393261 2020-08-08 US Virginia Orange 51137 231 3 0 228 38.24530219 -78.01560400000002 2020-08-09 04:34:54 Orange, Virginia, US
393310 2020-08-08 US Virginia Page 51139 343 24 0 319 38.61807452 -78.48797204 2020-08-09 04:34:54 Page, Virginia, US
393327 2020-08-08 US Virginia Patrick 51141 154 4 0 150 36.6801638 -80.2865648 2020-08-09 04:34:54 Patrick, Virginia, US
393366 2020-08-08 US Virginia Petersburg 51730 507 19 0 488 37.20530399 -77.39368102 2020-08-09 04:34:54 Petersburg, Virginia, US
393405 2020-08-08 US Virginia Pittsylvania 51143 424 2 0 422 36.81980341 -79.39731264 2020-08-09 04:34:54 Pittsylvania, Virginia, US
393438 2020-08-08 US Virginia Poquoson 51735 43 0 0 43 37.14259351 -76.35798148 2020-08-09 04:34:54 Poquoson, Virginia, US
393442 2020-08-08 US Virginia Portsmouth 51740 1758 25 0 1733 36.85914825 -76.35971629 2020-08-09 04:34:54 Portsmouth, Virginia, US
393455 2020-08-08 US Virginia Powhatan 51145 144 4 0 140 37.55016038 -77.91267882 2020-08-09 04:34:54 Powhatan, Virginia, US
393465 2020-08-08 US Virginia Prince Edward 51147 411 10 0 401 37.22554789 -78.43597949 2020-08-09 04:34:54 Prince Edward, Virginia, US
393466 2020-08-08 US Virginia Prince George 51149 380 2 0 378 37.18497668 -77.22922187 2020-08-09 04:34:54 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]);
Powered by Datasette · Query took 2348.02ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette