ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where "date" is on date 2020-07-21 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Accomack 1
- Albemarle 1
- Alexandria city 1
- Alleghany 1
- Amelia 1
- Amherst 1
- Appomattox 1
- Arlington 1
- Augusta 1
- Bath 1
- Bedford 1
- Bland 1
- Botetourt 1
- Bristol city 1
- Brunswick 1
- Buchanan 1
- Buckingham 1
- Buena Vista city 1
- Campbell 1
- Caroline 1
- Carroll 1
- Charles City 1
- Charlotte 1
- Charlottesville city 1
- Chesapeake city 1
- Chesterfield 1
- Clarke 1
- Colonial Heights city 1
- Covington city 1
- Craig 1
- …
state 1
- Virginia · 133 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
356713 | 356713 | 2020-07-21 | Accomack | Virginia | 51001 | 1057 | 15 |
356714 | 356714 | 2020-07-21 | Albemarle | Virginia | 51003 | 638 | 10 |
356715 | 356715 | 2020-07-21 | Alexandria city | Virginia | 51510 | 2582 | 56 |
356716 | 356716 | 2020-07-21 | Alleghany | Virginia | 51005 | 55 | 2 |
356717 | 356717 | 2020-07-21 | Amelia | Virginia | 51007 | 60 | 1 |
356718 | 356718 | 2020-07-21 | Amherst | Virginia | 51009 | 61 | 0 |
356719 | 356719 | 2020-07-21 | Appomattox | Virginia | 51011 | 54 | 0 |
356720 | 356720 | 2020-07-21 | Arlington | Virginia | 51013 | 2750 | 135 |
356721 | 356721 | 2020-07-21 | Augusta | Virginia | 51015 | 227 | 2 |
356722 | 356722 | 2020-07-21 | Bath | Virginia | 51017 | 2 | 0 |
356723 | 356723 | 2020-07-21 | Bedford | Virginia | 51019 | 201 | 4 |
356724 | 356724 | 2020-07-21 | Bland | Virginia | 51021 | 7 | 0 |
356725 | 356725 | 2020-07-21 | Botetourt | Virginia | 51023 | 166 | 4 |
356726 | 356726 | 2020-07-21 | Bristol city | Virginia | 51520 | 25 | 0 |
356727 | 356727 | 2020-07-21 | Brunswick | Virginia | 51025 | 161 | 1 |
356728 | 356728 | 2020-07-21 | Buchanan | Virginia | 51027 | 54 | 0 |
356729 | 356729 | 2020-07-21 | Buckingham | Virginia | 51029 | 587 | 6 |
356730 | 356730 | 2020-07-21 | Buena Vista city | Virginia | 51530 | 31 | 0 |
356731 | 356731 | 2020-07-21 | Campbell | Virginia | 51031 | 84 | 1 |
356732 | 356732 | 2020-07-21 | Caroline | Virginia | 51033 | 161 | 4 |
356733 | 356733 | 2020-07-21 | Carroll | Virginia | 51035 | 280 | 10 |
356734 | 356734 | 2020-07-21 | Charles City | Virginia | 51036 | 45 | 3 |
356735 | 356735 | 2020-07-21 | Charlotte | Virginia | 51037 | 40 | 0 |
356736 | 356736 | 2020-07-21 | Charlottesville city | Virginia | 51540 | 367 | 8 |
356737 | 356737 | 2020-07-21 | Chesapeake city | Virginia | 51550 | 1790 | 24 |
356738 | 356738 | 2020-07-21 | Chesterfield | Virginia | 51041 | 3538 | 65 |
356739 | 356739 | 2020-07-21 | Clarke | Virginia | 51043 | 64 | 0 |
356740 | 356740 | 2020-07-21 | Colonial Heights city | Virginia | 51570 | 167 | 20 |
356741 | 356741 | 2020-07-21 | Covington city | Virginia | 51580 | 7 | 0 |
356742 | 356742 | 2020-07-21 | Craig | Virginia | 51045 | 11 | 0 |
356743 | 356743 | 2020-07-21 | Culpeper | Virginia | 51047 | 909 | 12 |
356744 | 356744 | 2020-07-21 | Cumberland | Virginia | 51049 | 60 | 0 |
356745 | 356745 | 2020-07-21 | Danville city | Virginia | 51590 | 196 | 3 |
356746 | 356746 | 2020-07-21 | Dickenson | Virginia | 51051 | 10 | 0 |
356747 | 356747 | 2020-07-21 | Dinwiddie | Virginia | 51053 | 169 | 2 |
356748 | 356748 | 2020-07-21 | Emporia city | Virginia | 51595 | 152 | 15 |
356749 | 356749 | 2020-07-21 | Essex | Virginia | 51057 | 71 | 0 |
356750 | 356750 | 2020-07-21 | Fairfax | Virginia | 51059 | 14994 | 510 |
356751 | 356751 | 2020-07-21 | Fairfax city | Virginia | 51600 | 73 | 7 |
356752 | 356752 | 2020-07-21 | Falls Church city | Virginia | 51610 | 54 | 6 |
356753 | 356753 | 2020-07-21 | Fauquier | Virginia | 51061 | 536 | 8 |
356754 | 356754 | 2020-07-21 | Floyd | Virginia | 51063 | 28 | 1 |
356755 | 356755 | 2020-07-21 | Fluvanna | Virginia | 51065 | 151 | 8 |
356756 | 356756 | 2020-07-21 | Franklin | Virginia | 51067 | 125 | 1 |
356757 | 356757 | 2020-07-21 | Franklin city | Virginia | 51620 | 96 | 4 |
356758 | 356758 | 2020-07-21 | Frederick | Virginia | 51069 | 597 | 7 |
356759 | 356759 | 2020-07-21 | Fredericksburg city | Virginia | 51630 | 300 | 0 |
356760 | 356760 | 2020-07-21 | Galax city | Virginia | 51640 | 305 | 16 |
356761 | 356761 | 2020-07-21 | Giles | Virginia | 51071 | 18 | 0 |
356762 | 356762 | 2020-07-21 | Gloucester | Virginia | 51073 | 109 | 1 |
356763 | 356763 | 2020-07-21 | Goochland | Virginia | 51075 | 141 | 6 |
356764 | 356764 | 2020-07-21 | Grayson | Virginia | 51077 | 107 | 4 |
356765 | 356765 | 2020-07-21 | Greene | Virginia | 51079 | 100 | 2 |
356766 | 356766 | 2020-07-21 | Greensville | Virginia | 51081 | 389 | 9 |
356767 | 356767 | 2020-07-21 | Halifax | Virginia | 51083 | 108 | 1 |
356768 | 356768 | 2020-07-21 | Hampton city | Virginia | 51650 | 751 | 4 |
356769 | 356769 | 2020-07-21 | Hanover | Virginia | 51085 | 532 | 30 |
356770 | 356770 | 2020-07-21 | Harrisonburg city | Virginia | 51660 | 1010 | 29 |
356771 | 356771 | 2020-07-21 | Henrico | Virginia | 51087 | 3097 | 177 |
356772 | 356772 | 2020-07-21 | Henry | Virginia | 51089 | 410 | 5 |
356773 | 356773 | 2020-07-21 | Highland | Virginia | 51091 | 3 | 0 |
356774 | 356774 | 2020-07-21 | Hopewell city | Virginia | 51670 | 234 | 5 |
356775 | 356775 | 2020-07-21 | Isle of Wight | Virginia | 51093 | 283 | 9 |
356776 | 356776 | 2020-07-21 | James City | Virginia | 51095 | 456 | 16 |
356777 | 356777 | 2020-07-21 | King George | Virginia | 51099 | 108 | 4 |
356778 | 356778 | 2020-07-21 | King William | Virginia | 51101 | 66 | 2 |
356779 | 356779 | 2020-07-21 | King and Queen | Virginia | 51097 | 32 | 1 |
356780 | 356780 | 2020-07-21 | Lancaster | Virginia | 51103 | 23 | 0 |
356781 | 356781 | 2020-07-21 | Lee | Virginia | 51105 | 44 | 0 |
356782 | 356782 | 2020-07-21 | Lexington city | Virginia | 51678 | 23 | 0 |
356783 | 356783 | 2020-07-21 | Loudoun | Virginia | 51107 | 4695 | 106 |
356784 | 356784 | 2020-07-21 | Louisa | Virginia | 51109 | 155 | 2 |
356785 | 356785 | 2020-07-21 | Lunenburg | Virginia | 51111 | 44 | 0 |
356786 | 356786 | 2020-07-21 | Lynchburg city | Virginia | 51680 | 270 | 1 |
356787 | 356787 | 2020-07-21 | Madison | Virginia | 51113 | 51 | 1 |
356788 | 356788 | 2020-07-21 | Manassas Park city | Virginia | 51685 | 477 | 7 |
356789 | 356789 | 2020-07-21 | Manassas city | Virginia | 51683 | 1531 | 20 |
356790 | 356790 | 2020-07-21 | Martinsville city | Virginia | 51690 | 143 | 1 |
356791 | 356791 | 2020-07-21 | Mathews | Virginia | 51115 | 9 | 0 |
356792 | 356792 | 2020-07-21 | Mecklenburg | Virginia | 51117 | 281 | 30 |
356793 | 356793 | 2020-07-21 | Middlesex | Virginia | 51119 | 20 | 1 |
356794 | 356794 | 2020-07-21 | Montgomery | Virginia | 51121 | 220 | 3 |
356795 | 356795 | 2020-07-21 | Nelson | Virginia | 51125 | 29 | 0 |
356796 | 356796 | 2020-07-21 | New Kent | Virginia | 51127 | 94 | 1 |
356797 | 356797 | 2020-07-21 | Newport News city | Virginia | 51700 | 1237 | 14 |
356798 | 356798 | 2020-07-21 | Norfolk city | Virginia | 51710 | 2329 | 21 |
356799 | 356799 | 2020-07-21 | Northampton | Virginia | 51131 | 281 | 28 |
356800 | 356800 | 2020-07-21 | Northumberland | Virginia | 51133 | 55 | 1 |
356801 | 356801 | 2020-07-21 | Norton city | Virginia | 51720 | 5 | 0 |
356802 | 356802 | 2020-07-21 | Nottoway | Virginia | 51135 | 152 | 6 |
356803 | 356803 | 2020-07-21 | Orange | Virginia | 51137 | 185 | 3 |
356804 | 356804 | 2020-07-21 | Page | Virginia | 51139 | 317 | 23 |
356805 | 356805 | 2020-07-21 | Patrick | Virginia | 51141 | 57 | 2 |
356806 | 356806 | 2020-07-21 | Petersburg city | Virginia | 51730 | 371 | 9 |
356807 | 356807 | 2020-07-21 | Pittsylvania | Virginia | 51143 | 232 | 2 |
356808 | 356808 | 2020-07-21 | Poquoson city | Virginia | 51735 | 28 | 0 |
356809 | 356809 | 2020-07-21 | Portsmouth city | Virginia | 51740 | 1046 | 21 |
356810 | 356810 | 2020-07-21 | Powhatan | Virginia | 51145 | 105 | 3 |
356811 | 356811 | 2020-07-21 | Prince Edward | Virginia | 51147 | 242 | 6 |
356812 | 356812 | 2020-07-21 | Prince George | Virginia | 51149 | 293 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);