daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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

9,764 rows where province_or_state = "Virginia" sorted by day descending

View and edit SQL

province_or_state

  • Virginia · 9,764

country_or_region

  • US 9,764
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-06-03 US Virginia Accomack 51001 953 12 0 941 37.76707161 -75.63234615 2020-06-04 02:33:14 Accomack, Virginia, US
2020-06-03 US Virginia Albemarle 51003 204 8 0 196 38.02080697 -78.55481085 2020-06-04 02:33:14 Albemarle, Virginia, US
2020-06-03 US Virginia Alexandria 51510 2016 46 0 1970 38.814003 -77.08183073 2020-06-04 02:33:14 Alexandria, Virginia, US
2020-06-03 US Virginia Alleghany 51005 24 2 0 22 37.78636074 -80.00222498 2020-06-04 02:33:14 Alleghany, Virginia, US
2020-06-03 US Virginia Amelia 51007 28 1 0 27 37.34081025 -77.98584649 2020-06-04 02:33:14 Amelia, Virginia, US
2020-06-03 US Virginia Amherst 51009 27 0 0 27 37.60308293 -79.14548696 2020-06-04 02:33:14 Amherst, Virginia, US
2020-06-03 US Virginia Appomattox 51011 31 0 0 31 37.37569884 -78.81340003 2020-06-04 02:33:14 Appomattox, Virginia, US
2020-06-03 US Virginia Arlington 51013 2142 120 0 2022 38.8767675 -77.10139853 2020-06-04 02:33:14 Arlington, Virginia, US
2020-06-03 US Virginia Augusta 51015 115 2 0 113 38.16404586 -79.12461614 2020-06-04 02:33:14 Augusta, Virginia, US
2020-06-03 US Virginia Bath 51017 0 0 0 0 38.05852573 -79.73912095 2020-06-04 02:33:14 Bath, Virginia, US
2020-06-03 US Virginia Bedford 51019 62 2 0 60 37.3080028 -79.5281964 2020-06-04 02:33:14 Bedford, Virginia, US
2020-06-03 US Virginia Bland 51021 0 0 0 0 37.13128068 -81.13599391 2020-06-04 02:33:14 Bland, Virginia, US
2020-06-03 US Virginia Botetourt 51023 34 4 0 30 37.55531756 -79.80982182 2020-06-04 02:33:14 Botetourt, Virginia, US
2020-06-03 US Virginia Bristol 51520 4 0 0 4 36.6163024 -82.16359122 2020-06-04 02:33:14 Bristol, Virginia, US
2020-06-03 US Virginia Brunswick 51025 30 1 0 29 36.76366949 -77.8593436 2020-06-04 02:33:14 Brunswick, Virginia, US
2020-06-03 US Virginia Buchanan 51027 18 0 0 18 37.26818323 -82.03749726 2020-06-04 02:33:14 Buchanan, Virginia, US
2020-06-03 US Virginia Buckingham 51029 467 3 0 464 37.57242268 -78.52518834 2020-06-04 02:33:14 Buckingham, Virginia, US
2020-06-03 US Virginia Buena Vista 51530 13 0 0 13 37.73484642 -79.35296097 2020-06-04 02:33:14 Buena Vista, Virginia, US
2020-06-03 US Virginia Campbell 51031 18 1 0 17 37.20553386 -79.09678609 2020-06-04 02:33:14 Campbell, Virginia, US
2020-06-03 US Virginia Caroline 51033 76 2 0 74 38.02679129 -77.34901405 2020-06-04 02:33:14 Caroline, Virginia, US
2020-06-03 US Virginia Carroll 51035 105 1 0 104 36.73066666 -80.73455942 2020-06-04 02:33:14 Carroll, Virginia, US
2020-06-03 US Virginia Charles City 51036 27 2 0 25 37.35358063 -77.05634116 2020-06-04 02:33:14 Charles City, Virginia, US
2020-06-03 US Virginia Charlotte 51037 27 0 0 27 37.01909701 -78.66314092 2020-06-04 02:33:14 Charlotte, Virginia, US
2020-06-03 US Virginia Charlottesville 51540 128 3 0 125 38.03527919 -78.48569588 2020-06-04 02:33:14 Charlottesville, Virginia, US
2020-06-03 US Virginia Chesapeake 51550 548 15 0 533 36.67670048 -76.30545744 2020-06-04 02:33:14 Chesapeake, Virginia, US
2020-06-03 US Virginia Chesterfield 51041 1661 37 0 1624 37.37373208 -77.58680140000001 2020-06-04 02:33:14 Chesterfield, Virginia, US
2020-06-03 US Virginia Clarke 51043 29 0 0 29 39.11271747 -77.99199425 2020-06-04 02:33:14 Clarke, Virginia, US
2020-06-03 US Virginia Colonial Heights 51570 96 17 0 79 37.26420587 -77.39609676 2020-06-04 02:33:14 Colonial Heights, Virginia, US
2020-06-03 US Virginia Covington 51580 4 0 0 4 37.7824656 -79.98631446 2020-06-04 02:33:14 Covington, Virginia, US
2020-06-03 US Virginia Craig 51045 5 0 0 5 37.48133648 -80.21072274 2020-06-04 02:33:14 Craig, Virginia, US
2020-06-03 US Virginia Culpeper 51047 727 8 0 719 38.48199985 -77.95630870000002 2020-06-04 02:33:14 Culpeper, Virginia, US
2020-06-03 US Virginia Cumberland 51049 39 0 0 39 37.51328851 -78.24398086 2020-06-04 02:33:14 Cumberland, Virginia, US
2020-06-03 US Virginia Danville 51590 58 2 0 56 36.58022376 -79.40395668 2020-06-04 02:33:14 Danville, Virginia, US
2020-06-03 US Virginia Dickenson 51051 0 0 0 0 37.12560977 -82.35124171 2020-06-04 02:33:14 Dickenson, Virginia, US
2020-06-03 US Virginia Dinwiddie 51053 84 0 0 84 37.07544585 -77.63451754 2020-06-04 02:33:14 Dinwiddie, Virginia, US
2020-06-03 US Virginia Emporia 51595 86 6 0 80 36.69455571 -77.53406129 2020-06-04 02:33:14 Emporia, Virginia, US
2020-06-03 US Virginia Essex 51057 48 0 0 48 37.93357639 -76.94230311 2020-06-04 02:33:14 Essex, Virginia, US
2020-06-03 US Virginia Fairfax 51059 11596 396 0 11200 38.83677558 -77.27565836 2020-06-04 02:33:14 Fairfax, Virginia, US
2020-06-03 US Virginia Fairfax City 51600 67 6 0 61 38.85157547 -77.29779640000002 2020-06-04 02:33:14 Fairfax City, Virginia, US
2020-06-03 US Virginia Falls Church 51610 55 8 0 47 38.88485255 -77.17560759 2020-06-04 02:33:14 Falls Church, Virginia, US
2020-06-03 US Virginia Fauquier 51061 329 6 0 323 38.73564842 -77.80647472 2020-06-04 02:33:14 Fauquier, Virginia, US
2020-06-03 US Virginia Floyd 51063 7 0 0 7 36.9302126 -80.36738849 2020-06-04 02:33:14 Floyd, Virginia, US
2020-06-03 US Virginia Fluvanna 51065 92 6 0 86 37.84157909 -78.27715475 2020-06-04 02:33:14 Fluvanna, Virginia, US
2020-06-03 US Virginia Franklin 51067 36 1 0 35 36.99536167 -79.88023649 2020-06-04 02:33:14 Franklin, Virginia, US
2020-06-03 US Virginia Franklin City 51620 42 2 0 40 36.6831435 -76.93859681 2020-06-04 02:33:14 Franklin City, Virginia, US
2020-06-03 US Virginia Frederick 51069 378 4 0 374 39.20172582 -78.25974949 2020-06-04 02:33:14 Frederick, Virginia, US
2020-06-03 US Virginia Fredericksburg 51630 172 0 0 172 38.2977863 -77.4922454 2020-06-04 02:33:14 Fredericksburg, Virginia, US
2020-06-03 US Virginia Galax 51640 131 1 0 130 36.66601852 -80.91703124 2020-06-04 02:33:14 Galax, Virginia, US
2020-06-03 US Virginia Giles 51071 5 0 0 5 37.31234791 -80.70636931 2020-06-04 02:33:14 Giles, Virginia, US
2020-06-03 US Virginia Gloucester 51073 31 1 0 30 37.40809042 -76.53524337 2020-06-04 02:33:14 Gloucester, Virginia, US
2020-06-03 US Virginia Goochland 51075 103 6 0 97 37.71714806 -77.90381514 2020-06-04 02:33:14 Goochland, Virginia, US
2020-06-03 US Virginia Grayson 51077 42 0 0 42 36.65677234 -81.23215889 2020-06-04 02:33:14 Grayson, Virginia, US
2020-06-03 US Virginia Greene 51079 34 1 0 33 38.29545894 -78.46525378 2020-06-04 02:33:14 Greene, Virginia, US
2020-06-03 US Virginia Greensville 51081 150 7 0 143 36.67878901 -77.56351439 2020-06-04 02:33:14 Greensville, Virginia, US
2020-06-03 US Virginia Halifax 51083 30 1 0 29 36.76654925 -78.93512622 2020-06-04 02:33:14 Halifax, Virginia, US
2020-06-03 US Virginia Hampton 51650 212 3 0 209 37.03513786 -76.35879121 2020-06-04 02:33:14 Hampton, Virginia, US
2020-06-03 US Virginia Hanover 51085 331 24 0 307 37.7583355 -77.49464673 2020-06-04 02:33:14 Hanover, Virginia, US
2020-06-03 US Virginia Harrisonburg 51660 809 23 0 786 38.43542574 -78.87536254 2020-06-04 02:33:14 Harrisonburg, Virginia, US
2020-06-03 US Virginia Henrico 51087 1933 134 0 1799 37.53460572 -77.39326555 2020-06-04 02:33:14 Henrico, Virginia, US
2020-06-03 US Virginia Henry 51089 145 3 0 142 36.68542395 -79.87634026 2020-06-04 02:33:14 Henry, Virginia, US
2020-06-03 US Virginia Highland 51091 3 0 0 3 38.35799465 -79.56124594 2020-06-04 02:33:14 Highland, Virginia, US
2020-06-03 US Virginia Hopewell 51670 98 1 0 97 37.29186313 -77.29754684 2020-06-04 02:33:14 Hopewell, Virginia, US
2020-06-03 US Virginia Isle of Wight 51093 133 3 0 130 36.90579348 -76.70842863 2020-06-04 02:33:14 Isle of Wight, Virginia, US
2020-06-03 US Virginia James City 51095 211 15 0 196 37.31156958 -76.76950618 2020-06-04 02:33:14 James City, Virginia, US
2020-06-03 US Virginia King George 51099 70 4 0 66 38.26818502 -77.15852768 2020-06-04 02:33:14 King George, Virginia, US
2020-06-03 US Virginia King William 51101 31 0 0 31 37.70965316 -77.09384941 2020-06-04 02:33:14 King William, Virginia, US
2020-06-03 US Virginia King and Queen 51097 13 1 0 12 37.71044922 -76.88689628 2020-06-04 02:33:14 King and Queen, Virginia, US
2020-06-03 US Virginia Lancaster 51103 10 0 0 10 37.71889653 -76.46400482 2020-06-04 02:33:14 Lancaster, Virginia, US
2020-06-03 US Virginia Lee 51105 9 0 0 9 36.70586667 -83.12606515 2020-06-04 02:33:14 Lee, Virginia, US
2020-06-03 US Virginia Lexington 51678 7 0 0 7 37.78258621 -79.44262866 2020-06-04 02:33:14 Lexington, Virginia, US
2020-06-03 US Virginia Loudoun 51107 2659 67 0 2592 39.08990083 -77.63481877 2020-06-04 02:33:14 Loudoun, Virginia, US
2020-06-03 US Virginia Louisa 51109 81 1 0 80 37.97850256 -77.96274807 2020-06-04 02:33:14 Louisa, Virginia, US
2020-06-03 US Virginia Lunenburg 51111 15 0 0 15 36.94618528 -78.24133319 2020-06-04 02:33:14 Lunenburg, Virginia, US
2020-06-03 US Virginia Lynchburg 51680 80 1 0 79 37.40021399 -79.19888138 2020-06-04 02:33:14 Lynchburg, Virginia, US
2020-06-03 US Virginia Madison 51113 41 1 0 40 38.41531222 -78.28220331 2020-06-04 02:33:14 Madison, Virginia, US
2020-06-03 US Virginia Manassas 51683 1154 12 0 1142 38.7464321 -77.48509905 2020-06-04 02:33:14 Manassas, Virginia, US
2020-06-03 US Virginia Manassas Park 51685 332 6 0 326 38.77058531 -77.44399307 2020-06-04 02:33:14 Manassas Park, Virginia, US
2020-06-03 US Virginia Martinsville 51690 38 1 0 37 36.68212094 -79.86352771 2020-06-04 02:33:14 Martinsville, Virginia, US
2020-06-03 US Virginia Mathews 51115 5 0 0 5 37.44164146 -76.34098896 2020-06-04 02:33:14 Mathews, Virginia, US
2020-06-03 US Virginia Mecklenburg 51117 219 23 0 196 36.67882005 -78.36131056 2020-06-04 02:33:14 Mecklenburg, Virginia, US
2020-06-03 US Virginia Middlesex 51119 15 0 0 15 37.63191998 -76.55064617 2020-06-04 02:33:14 Middlesex, Virginia, US
2020-06-03 US Virginia Montgomery 51121 80 1 0 79 37.17746986 -80.37868691 2020-06-04 02:33:14 Montgomery, Virginia, US
2020-06-03 US Virginia Nelson 51125 17 0 0 17 37.78790447 -78.88498513 2020-06-04 02:33:14 Nelson, Virginia, US
2020-06-03 US Virginia New Kent 51127 38 1 0 37 37.50694406 -76.99828634 2020-06-04 02:33:14 New Kent, Virginia, US
2020-06-03 US Virginia Newport News 51700 292 10 0 282 37.08166899 -76.51754109 2020-06-04 02:33:14 Newport News, Virginia, US
2020-06-03 US Virginia Norfolk 51710 539 6 0 533 36.89934014 -76.26420872 2020-06-04 02:33:14 Norfolk, Virginia, US
2020-06-03 US Virginia Northampton 51131 245 23 0 222 37.34062933 -75.87751591 2020-06-04 02:33:14 Northampton, Virginia, US
2020-06-03 US Virginia Northumberland 51133 25 1 0 24 37.89202088 -76.41949732 2020-06-04 02:33:14 Northumberland, Virginia, US
2020-06-03 US Virginia Norton 51720 2 0 0 2 36.93357076 -82.62750411 2020-06-04 02:33:14 Norton, Virginia, US
2020-06-03 US Virginia Nottoway 51135 40 0 0 40 37.1435975 -78.05065922 2020-06-04 02:33:14 Nottoway, Virginia, US
2020-06-03 US Virginia Orange 51137 111 1 0 110 38.24530219 -78.01560400000002 2020-06-04 02:33:14 Orange, Virginia, US
2020-06-03 US Virginia Page 51139 231 24 0 207 38.61807452 -78.48797204 2020-06-04 02:33:14 Page, Virginia, US
2020-06-03 US Virginia Patrick 51141 21 0 0 21 36.6801638 -80.2865648 2020-06-04 02:33:14 Patrick, Virginia, US
2020-06-03 US Virginia Petersburg 51730 143 3 0 140 37.20530399 -77.39368102 2020-06-04 02:33:14 Petersburg, Virginia, US
2020-06-03 US Virginia Pittsylvania 51143 45 1 0 44 36.81980341 -79.39731264 2020-06-04 02:33:14 Pittsylvania, Virginia, US
2020-06-03 US Virginia Poquoson 51735 8 0 0 8 37.14259351 -76.35798148 2020-06-04 02:33:14 Poquoson, Virginia, US
2020-06-03 US Virginia Portsmouth 51740 322 11 0 311 36.85914825 -76.35971629 2020-06-04 02:33:14 Portsmouth, Virginia, US
2020-06-03 US Virginia Powhatan 51145 36 0 0 36 37.55016038 -77.91267882 2020-06-04 02:33:14 Powhatan, Virginia, US
2020-06-03 US Virginia Prince Edward 51147 143 2 0 141 37.22554789 -78.43597949 2020-06-04 02:33:14 Prince Edward, Virginia, US
2020-06-03 US Virginia Prince George 51149 135 0 0 135 37.18497668 -77.22922187 2020-06-04 02:33:14 Prince George, Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 2122.175ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette