johns_hopkins_csse_daily_reports

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

77,702 rows where province_or_state = "Virginia" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state

  • Virginia · 77,702 ✖

country_or_region

  • US 77,702
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
35578 35578 2021-10-23 US Virginia Accomack 51001 4038 75 0   37.76707161 -75.63234615 2021-10-24 04:21:22 Accomack, Virginia, US
35579 35579 2021-10-23 US Virginia Albemarle 51003 7955 98 0   38.02080697 -78.55481085 2021-10-24 04:21:22 Albemarle, Virginia, US
35580 35580 2021-10-23 US Virginia Alexandria 51510 14148 148 0   38.814003 -77.08183073 2021-10-24 04:21:22 Alexandria, Virginia, US
35581 35581 2021-10-23 US Virginia Alleghany 51005 2094 74 0   37.78636074 -80.00222498 2021-10-24 04:21:22 Alleghany, Virginia, US
35582 35582 2021-10-23 US Virginia Amelia 51007 1400 40 0   37.34081025 -77.98584649 2021-10-24 04:21:22 Amelia, Virginia, US
35583 35583 2021-10-23 US Virginia Amherst 51009 4298 56 0   37.60308293 -79.14548696 2021-10-24 04:21:22 Amherst, Virginia, US
35584 35584 2021-10-23 US Virginia Appomattox 51011 2361 36 0   37.37569884 -78.81340003 2021-10-24 04:21:22 Appomattox, Virginia, US
35585 35585 2021-10-23 US Virginia Arlington 51013 18449 269 0   38.8767675 -77.10139853 2021-10-24 04:21:22 Arlington, Virginia, US
35586 35586 2021-10-23 US Virginia Augusta 51015 10070 121 0   38.16404586 -79.12461614 2021-10-24 04:21:22 Augusta, Virginia, US
35587 35587 2021-10-23 US Virginia Bath 51017 475 14 0   38.05852573 -79.73912095 2021-10-24 04:21:22 Bath, Virginia, US
35588 35588 2021-10-23 US Virginia Bedford 51019 9801 148 0   37.3080028 -79.5281964 2021-10-24 04:21:22 Bedford, Virginia, US
35589 35589 2021-10-23 US Virginia Bland 51021 1054 16 0   37.13128068 -81.13599391 2021-10-24 04:21:22 Bland, Virginia, US
35590 35590 2021-10-23 US Virginia Botetourt 51023 3799 46 0   37.55531756 -79.80982182 2021-10-24 04:21:22 Botetourt, Virginia, US
35591 35591 2021-10-23 US Virginia Bristol 51520 2247 47 0   36.616302399999995 -82.16359122 2021-10-24 04:21:22 Bristol, Virginia, US
35592 35592 2021-10-23 US Virginia Brunswick 51025 1788 32 0   36.76366949 -77.8593436 2021-10-24 04:21:22 Brunswick, Virginia, US
35593 35593 2021-10-23 US Virginia Buchanan 51027 2367 59 0   37.26818323 -82.03749726 2021-10-24 04:21:22 Buchanan, Virginia, US
35594 35594 2021-10-23 US Virginia Buckingham 51029 2642 37 0   37.57242268 -78.52518834 2021-10-24 04:21:22 Buckingham, Virginia, US
35595 35595 2021-10-23 US Virginia Buena Vista 51530 1282 24 0   37.73484642 -79.35296097 2021-10-24 04:21:22 Buena Vista, Virginia, US
35596 35596 2021-10-23 US Virginia Campbell 51031 7084 135 0   37.20553386 -79.09678609 2021-10-24 04:21:22 Campbell, Virginia, US
35597 35597 2021-10-23 US Virginia Caroline 51033 3864 51 0   38.02679129 -77.34901405 2021-10-24 04:21:22 Caroline, Virginia, US
35598 35598 2021-10-23 US Virginia Carroll 51035 3884 92 0   36.73066666 -80.73455942 2021-10-24 04:21:22 Carroll, Virginia, US
35599 35599 2021-10-23 US Virginia Charles City 51036 674 19 0   37.35358063 -77.05634116 2021-10-24 04:21:22 Charles City, Virginia, US
35600 35600 2021-10-23 US Virginia Charlotte 51037 1263 26 0   37.01909701 -78.66314092 2021-10-24 04:21:22 Charlotte, Virginia, US
35601 35601 2021-10-23 US Virginia Charlottesville 51540 5308 60 0   38.03527919 -78.48569588 2021-10-24 04:21:22 Charlottesville, Virginia, US
35602 35602 2021-10-23 US Virginia Chesapeake 51550 28558 354 0   36.67670048 -76.30545744 2021-10-24 04:21:22 Chesapeake, Virginia, US
35603 35603 2021-10-23 US Virginia Chesterfield 51041 39201 539 0   37.37373208 -77.58680140000001 2021-10-24 04:21:22 Chesterfield, Virginia, US
35604 35604 2021-10-23 US Virginia Clarke 51043 1339 24 0   39.11271747 -77.99199425 2021-10-24 04:21:22 Clarke, Virginia, US
35605 35605 2021-10-23 US Virginia Colonial Heights 51570 2568 65 0   37.26420587 -77.39609676 2021-10-24 04:21:22 Colonial Heights, Virginia, US
35606 35606 2021-10-23 US Virginia Covington 51580 754 16 0   37.7824656 -79.98631446 2021-10-24 04:21:22 Covington, Virginia, US
35607 35607 2021-10-23 US Virginia Craig 51045 539 6 0   37.48133648 -80.21072274 2021-10-24 04:21:22 Craig, Virginia, US
35608 35608 2021-10-23 US Virginia Culpeper 51047 6407 83 0   38.48199985 -77.95630870000002 2021-10-24 04:21:22 Culpeper, Virginia, US
35609 35609 2021-10-23 US Virginia Cumberland 51049 712 17 0   37.51328851 -78.24398086 2021-10-24 04:21:22 Cumberland, Virginia, US
35610 35610 2021-10-23 US Virginia Danville 51590 6173 184 0   36.58022376 -79.40395668 2021-10-24 04:21:22 Danville, Virginia, US
35611 35611 2021-10-23 US Virginia Dickenson 51051 1606 26 0   37.12560977 -82.35124171 2021-10-24 04:21:22 Dickenson, Virginia, US
35612 35612 2021-10-23 US Virginia Dinwiddie 51053 3107 52 0   37.07544585 -77.63451754 2021-10-24 04:21:22 Dinwiddie, Virginia, US
35613 35613 2021-10-23 US Virginia Emporia 51595 864 43 0   36.69455571 -77.53406129 2021-10-24 04:21:22 Emporia, Virginia, US
35614 35614 2021-10-23 US Virginia Essex 51057 1234 17 0   37.93357639 -76.94230311 2021-10-24 04:21:22 Essex, Virginia, US
35615 35615 2021-10-23 US Virginia Fairfax 51059 91314 1178 0   38.83677558 -77.27565836 2021-10-24 04:21:22 Fairfax, Virginia, US
35616 35616 2021-10-23 US Virginia Fairfax City 51600 649 20 0   38.85157547 -77.29779640000002 2021-10-24 04:21:22 Fairfax City, Virginia, US
35617 35617 2021-10-23 US Virginia Falls Church 51610 543 8 0   38.88485255 -77.17560759 2021-10-24 04:21:22 Falls Church, Virginia, US
35618 35618 2021-10-23 US Virginia Fauquier 51061 6883 85 0   38.73564842 -77.80647472 2021-10-24 04:21:22 Fauquier, Virginia, US
35619 35619 2021-10-23 US Virginia Floyd 51063 1404 29 0   36.9302126 -80.36738849 2021-10-24 04:21:22 Floyd, Virginia, US
35620 35620 2021-10-23 US Virginia Fluvanna 51065 2597 22 0   37.84157909 -78.27715475 2021-10-24 04:21:22 Fluvanna, Virginia, US
35621 35621 2021-10-23 US Virginia Franklin 51067 5971 100 0   36.99536167 -79.88023649 2021-10-24 04:21:22 Franklin, Virginia, US
35622 35622 2021-10-23 US Virginia Franklin City 51620 1605 42 0   36.6831435 -76.93859681 2021-10-24 04:21:22 Franklin City, Virginia, US
35623 35623 2021-10-23 US Virginia Frederick 51069 11457 146 0   39.20172582 -78.25974949 2021-10-24 04:21:22 Frederick, Virginia, US
35624 35624 2021-10-23 US Virginia Fredericksburg 51630 3039 25 0   38.2977863 -77.4922454 2021-10-24 04:21:22 Fredericksburg, Virginia, US
35625 35625 2021-10-23 US Virginia Galax 51640 1500 62 0   36.66601852 -80.91703124 2021-10-24 04:21:22 Galax, Virginia, US
35626 35626 2021-10-23 US Virginia Giles 51071 2240 30 0   37.31234791 -80.70636931 2021-10-24 04:21:22 Giles, Virginia, US
35627 35627 2021-10-23 US Virginia Gloucester 51073 3826 75 0   37.40809042 -76.53524337 2021-10-24 04:21:22 Gloucester, Virginia, US
35628 35628 2021-10-23 US Virginia Goochland 51075 1981 30 0   37.71714806 -77.90381514 2021-10-24 04:21:22 Goochland, Virginia, US
35629 35629 2021-10-23 US Virginia Grayson 51077 2052 45 0   36.65677234 -81.23215889 2021-10-24 04:21:22 Grayson, Virginia, US
35630 35630 2021-10-23 US Virginia Greene 51079 2196 35 0   38.29545894 -78.46525378 2021-10-24 04:21:22 Greene, Virginia, US
35631 35631 2021-10-23 US Virginia Greensville 51081 1879 28 0   36.67878901 -77.56351439 2021-10-24 04:21:22 Greensville, Virginia, US
35632 35632 2021-10-23 US Virginia Halifax 51083 3842 103 0   36.76654925 -78.93512622 2021-10-24 04:21:22 Halifax, Virginia, US
35633 35633 2021-10-23 US Virginia Hampton 51650 14890 237 0   37.03513786 -76.35879121 2021-10-24 04:21:22 Hampton, Virginia, US
35634 35634 2021-10-23 US Virginia Hanover 51085 11640 193 0   37.7583355 -77.49464673 2021-10-24 04:21:22 Hanover, Virginia, US
35635 35635 2021-10-23 US Virginia Harrisonburg 51660 8192 103 0   38.43542574 -78.87536254 2021-10-24 04:21:22 Harrisonburg, Virginia, US
35636 35636 2021-10-23 US Virginia Henrico 51087 34096 708 0   37.53460572 -77.39326555 2021-10-24 04:21:22 Henrico, Virginia, US
35637 35637 2021-10-23 US Virginia Henry 51089 6361 151 0   36.68542395 -79.87634026 2021-10-24 04:21:22 Henry, Virginia, US
35638 35638 2021-10-23 US Virginia Highland 51091 176 3 0   38.35799465 -79.56124594 2021-10-24 04:21:22 Highland, Virginia, US
35639 35639 2021-10-23 US Virginia Hopewell 51670 3675 86 0   37.29186313 -77.29754684 2021-10-24 04:21:22 Hopewell, Virginia, US
35640 35640 2021-10-23 US Virginia Isle of Wight 51093 4408 85 0   36.90579348 -76.70842863 2021-10-24 04:21:22 Isle of Wight, Virginia, US
35641 35641 2021-10-23 US Virginia James City 51095 6964 95 0   37.31156958 -76.76950618 2021-10-24 04:21:22 James City, Virginia, US
35642 35642 2021-10-23 US Virginia King George 51099 2587 22 0   38.26818502 -77.15852768 2021-10-24 04:21:22 King George, Virginia, US
35643 35643 2021-10-23 US Virginia King William 51101 1896 24 0   37.70965316 -77.09384941 2021-10-24 04:21:22 King William, Virginia, US
35644 35644 2021-10-23 US Virginia King and Queen 51097 624 8 0   37.71044922 -76.88689628 2021-10-24 04:21:22 King and Queen, Virginia, US
35645 35645 2021-10-23 US Virginia Lancaster 51103 1053 21 0   37.71889653 -76.46400482 2021-10-24 04:21:22 Lancaster, Virginia, US
35646 35646 2021-10-23 US Virginia Lee 51105 3684 59 0   36.70586667 -83.12606515 2021-10-24 04:21:22 Lee, Virginia, US
35647 35647 2021-10-23 US Virginia Lexington 51678 1554 35 0   37.78258621 -79.44262866 2021-10-24 04:21:22 Lexington, Virginia, US
35648 35648 2021-10-23 US Virginia Loudoun 51107 33870 295 0   39.08990083 -77.63481877 2021-10-24 04:21:22 Loudoun, Virginia, US
35649 35649 2021-10-23 US Virginia Louisa 51109 3170 44 0   37.97850256 -77.96274807 2021-10-24 04:21:22 Louisa, Virginia, US
35650 35650 2021-10-23 US Virginia Lunenburg 51111 1085 20 0   36.94618528 -78.24133319 2021-10-24 04:21:22 Lunenburg, Virginia, US
35651 35651 2021-10-23 US Virginia Lynchburg 51680 11711 185 0   37.40021399 -79.19888138 2021-10-24 04:21:22 Lynchburg, Virginia, US
35652 35652 2021-10-23 US Virginia Madison 51113 980 21 0   38.41531222 -78.28220331 2021-10-24 04:21:22 Madison, Virginia, US
35653 35653 2021-10-23 US Virginia Manassas 51683 5051 52 0   38.7464321 -77.48509905 2021-10-24 04:21:22 Manassas, Virginia, US
35654 35654 2021-10-23 US Virginia Manassas Park 51685 1266 12 0   38.77058531 -77.44399307 2021-10-24 04:21:22 Manassas Park, Virginia, US
35655 35655 2021-10-23 US Virginia Martinsville 51690 2025 88 0   36.68212094 -79.86352771 2021-10-24 04:21:22 Martinsville, Virginia, US
35656 35656 2021-10-23 US Virginia Mathews 51115 881 21 0   37.44164146 -76.34098896 2021-10-24 04:21:22 Mathews, Virginia, US
35657 35657 2021-10-23 US Virginia Mecklenburg 51117 3378 82 0   36.67882005 -78.36131056 2021-10-24 04:21:22 Mecklenburg, Virginia, US
35658 35658 2021-10-23 US Virginia Middlesex 51119 938 29 0   37.63191998 -76.55064617 2021-10-24 04:21:22 Middlesex, Virginia, US
35659 35659 2021-10-23 US Virginia Montgomery 51121 11683 105 0   37.17746986 -80.37868691 2021-10-24 04:21:22 Montgomery, Virginia, US
35660 35660 2021-10-23 US Virginia Nelson 51125 1338 16 0   37.78790447 -78.88498513 2021-10-24 04:21:22 Nelson, Virginia, US
35661 35661 2021-10-23 US Virginia New Kent 51127 2376 22 0   37.50694406 -76.99828634 2021-10-24 04:21:22 New Kent, Virginia, US
35662 35662 2021-10-23 US Virginia Newport News 51700 20391 291 0   37.08166899 -76.51754109 2021-10-24 04:21:22 Newport News, Virginia, US
35663 35663 2021-10-23 US Virginia Norfolk 51710 24211 335 0   36.89934014 -76.26420872 2021-10-24 04:21:22 Norfolk, Virginia, US
35664 35664 2021-10-23 US Virginia Northampton 51131 1148 44 0   37.34062933 -75.87751591 2021-10-24 04:21:22 Northampton, Virginia, US
35665 35665 2021-10-23 US Virginia Northumberland 51133 1206 30 0   37.89202088 -76.41949732 2021-10-24 04:21:22 Northumberland, Virginia, US
35666 35666 2021-10-23 US Virginia Norton 51720 560 13 0   36.93357076 -82.62750411 2021-10-24 04:21:22 Norton, Virginia, US
35667 35667 2021-10-23 US Virginia Nottoway 51135 2577 65 0   37.1435975 -78.05065922 2021-10-24 04:21:22 Nottoway, Virginia, US
35668 35668 2021-10-23 US Virginia Orange 51137 3644 54 0   38.24530219 -78.01560400000002 2021-10-24 04:21:22 Orange, Virginia, US
35669 35669 2021-10-23 US Virginia Page 51139 3326 76 0   38.61807452 -78.48797204 2021-10-24 04:21:22 Page, Virginia, US
35670 35670 2021-10-23 US Virginia Patrick 51141 2000 55 0   36.680163799999995 -80.2865648 2021-10-24 04:21:22 Patrick, Virginia, US
35671 35671 2021-10-23 US Virginia Petersburg 51730 5208 108 0   37.20530399 -77.39368102 2021-10-24 04:21:22 Petersburg, Virginia, US
35672 35672 2021-10-23 US Virginia Pittsylvania 51143 8055 111 0   36.81980341 -79.39731264 2021-10-24 04:21:22 Pittsylvania, Virginia, US
35673 35673 2021-10-23 US Virginia Poquoson 51735 1322 19 0   37.14259351 -76.35798148 2021-10-24 04:21:22 Poquoson, Virginia, US
35674 35674 2021-10-23 US Virginia Portsmouth 51740 12517 238 0   36.85914825 -76.35971629 2021-10-24 04:21:22 Portsmouth, Virginia, US
35675 35675 2021-10-23 US Virginia Powhatan 51145 2767 27 0   37.55016038 -77.91267882 2021-10-24 04:21:22 Powhatan, Virginia, US
35676 35676 2021-10-23 US Virginia Prince Edward 51147 2919 50 0   37.22554789 -78.43597949 2021-10-24 04:21:22 Prince Edward, Virginia, US
35677 35677 2021-10-23 US Virginia Prince George 51149 4919 41 0   37.18497668 -77.22922187 2021-10-24 04:21:22 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]);