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-12-28 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
874681 | 874681 | 2020-12-28 | Accomack | Virginia | 51001 | 1665 | 25 |
874682 | 874682 | 2020-12-28 | Albemarle | Virginia | 51003 | 2704 | 31 |
874683 | 874683 | 2020-12-28 | Alexandria city | Virginia | 51510 | 7107 | 86 |
874684 | 874684 | 2020-12-28 | Alleghany | Virginia | 51005 | 713 | 22 |
874685 | 874685 | 2020-12-28 | Amelia | Virginia | 51007 | 343 | 7 |
874686 | 874686 | 2020-12-28 | Amherst | Virginia | 51009 | 1371 | 9 |
874687 | 874687 | 2020-12-28 | Appomattox | Virginia | 51011 | 673 | 7 |
874688 | 874688 | 2020-12-28 | Arlington | Virginia | 51013 | 8631 | 177 |
874689 | 874689 | 2020-12-28 | Augusta | Virginia | 51015 | 3098 | 24 |
874690 | 874690 | 2020-12-28 | Bath | Virginia | 51017 | 138 | 0 |
874691 | 874691 | 2020-12-28 | Bedford | Virginia | 51019 | 2925 | 30 |
874692 | 874692 | 2020-12-28 | Bland | Virginia | 51021 | 448 | 6 |
874693 | 874693 | 2020-12-28 | Botetourt | Virginia | 51023 | 1243 | 16 |
874694 | 874694 | 2020-12-28 | Bristol city | Virginia | 51520 | 883 | 8 |
874695 | 874695 | 2020-12-28 | Brunswick | Virginia | 51025 | 599 | 7 |
874696 | 874696 | 2020-12-28 | Buchanan | Virginia | 51027 | 736 | 24 |
874697 | 874697 | 2020-12-28 | Buckingham | Virginia | 51029 | 1276 | 11 |
874698 | 874698 | 2020-12-28 | Buena Vista city | Virginia | 51530 | 478 | 4 |
874699 | 874699 | 2020-12-28 | Campbell | Virginia | 51031 | 1936 | 19 |
874700 | 874700 | 2020-12-28 | Caroline | Virginia | 51033 | 981 | 9 |
874701 | 874701 | 2020-12-28 | Carroll | Virginia | 51035 | 1457 | 36 |
874702 | 874702 | 2020-12-28 | Charles City | Virginia | 51036 | 186 | 8 |
874703 | 874703 | 2020-12-28 | Charlotte | Virginia | 51037 | 357 | 6 |
874704 | 874704 | 2020-12-28 | Charlottesville city | Virginia | 51540 | 2159 | 34 |
874705 | 874705 | 2020-12-28 | Chesapeake city | Virginia | 51550 | 9043 | 97 |
874706 | 874706 | 2020-12-28 | Chesterfield | Virginia | 51041 | 12552 | 163 |
874707 | 874707 | 2020-12-28 | Clarke | Virginia | 51043 | 360 | 5 |
874708 | 874708 | 2020-12-28 | Colonial Heights city | Virginia | 51570 | 582 | 28 |
874709 | 874709 | 2020-12-28 | Covington city | Virginia | 51580 | 357 | 4 |
874710 | 874710 | 2020-12-28 | Craig | Virginia | 51045 | 143 | 1 |
874711 | 874711 | 2020-12-28 | Culpeper | Virginia | 51047 | 2894 | 18 |
874712 | 874712 | 2020-12-28 | Cumberland | Virginia | 51049 | 187 | 4 |
874713 | 874713 | 2020-12-28 | Danville city | Virginia | 51590 | 2286 | 60 |
874714 | 874714 | 2020-12-28 | Dickenson | Virginia | 51051 | 600 | 4 |
874715 | 874715 | 2020-12-28 | Dinwiddie | Virginia | 51053 | 863 | 14 |
874716 | 874716 | 2020-12-28 | Emporia city | Virginia | 51595 | 392 | 30 |
874717 | 874717 | 2020-12-28 | Essex | Virginia | 51057 | 332 | 2 |
874718 | 874718 | 2020-12-28 | Fairfax | Virginia | 51059 | 42786 | 671 |
874719 | 874719 | 2020-12-28 | Fairfax city | Virginia | 51600 | 295 | 10 |
874720 | 874720 | 2020-12-28 | Falls Church city | Virginia | 51610 | 170 | 6 |
874721 | 874721 | 2020-12-28 | Fauquier | Virginia | 51061 | 2257 | 28 |
874722 | 874722 | 2020-12-28 | Floyd | Virginia | 51063 | 489 | 17 |
874723 | 874723 | 2020-12-28 | Fluvanna | Virginia | 51065 | 727 | 9 |
874724 | 874724 | 2020-12-28 | Franklin | Virginia | 51067 | 2273 | 22 |
874725 | 874725 | 2020-12-28 | Franklin city | Virginia | 51620 | 665 | 17 |
874726 | 874726 | 2020-12-28 | Frederick | Virginia | 51069 | 3568 | 25 |
874727 | 874727 | 2020-12-28 | Fredericksburg city | Virginia | 51630 | 988 | 8 |
874728 | 874728 | 2020-12-28 | Galax city | Virginia | 51640 | 799 | 34 |
874729 | 874729 | 2020-12-28 | Giles | Virginia | 51071 | 547 | 2 |
874730 | 874730 | 2020-12-28 | Gloucester | Virginia | 51073 | 806 | 7 |
874731 | 874731 | 2020-12-28 | Goochland | Virginia | 51075 | 603 | 7 |
874732 | 874732 | 2020-12-28 | Grayson | Virginia | 51077 | 766 | 24 |
874733 | 874733 | 2020-12-28 | Greene | Virginia | 51079 | 519 | 4 |
874734 | 874734 | 2020-12-28 | Greensville | Virginia | 51081 | 1004 | 16 |
874735 | 874735 | 2020-12-28 | Halifax | Virginia | 51083 | 1104 | 35 |
874736 | 874736 | 2020-12-28 | Hampton city | Virginia | 51650 | 4156 | 43 |
874737 | 874737 | 2020-12-28 | Hanover | Virginia | 51085 | 3655 | 69 |
874738 | 874738 | 2020-12-28 | Harrisonburg city | Virginia | 51660 | 4284 | 40 |
874739 | 874739 | 2020-12-28 | Henrico | Virginia | 51087 | 11844 | 288 |
874740 | 874740 | 2020-12-28 | Henry | Virginia | 51089 | 2514 | 52 |
874741 | 874741 | 2020-12-28 | Highland | Virginia | 51091 | 57 | 0 |
874742 | 874742 | 2020-12-28 | Hopewell city | Virginia | 51670 | 838 | 10 |
874743 | 874743 | 2020-12-28 | Isle of Wight | Virginia | 51093 | 1471 | 29 |
874744 | 874744 | 2020-12-28 | James City | Virginia | 51095 | 1742 | 27 |
874745 | 874745 | 2020-12-28 | King George | Virginia | 51099 | 650 | 9 |
874746 | 874746 | 2020-12-28 | King William | Virginia | 51101 | 432 | 5 |
874747 | 874747 | 2020-12-28 | King and Queen | Virginia | 51097 | 170 | 2 |
874748 | 874748 | 2020-12-28 | Lancaster | Virginia | 51103 | 319 | 2 |
874749 | 874749 | 2020-12-28 | Lee | Virginia | 51105 | 1413 | 29 |
874750 | 874750 | 2020-12-28 | Lexington city | Virginia | 51678 | 577 | 3 |
874751 | 874751 | 2020-12-28 | Loudoun | Virginia | 51107 | 13683 | 154 |
874752 | 874752 | 2020-12-28 | Louisa | Virginia | 51109 | 857 | 9 |
874753 | 874753 | 2020-12-28 | Lunenburg | Virginia | 51111 | 333 | 3 |
874754 | 874754 | 2020-12-28 | Lynchburg city | Virginia | 51680 | 4047 | 48 |
874755 | 874755 | 2020-12-28 | Madison | Virginia | 51113 | 285 | 4 |
874756 | 874756 | 2020-12-28 | Manassas Park city | Virginia | 51685 | 915 | 8 |
874757 | 874757 | 2020-12-28 | Manassas city | Virginia | 51683 | 2834 | 30 |
874758 | 874758 | 2020-12-28 | Martinsville city | Virginia | 51690 | 963 | 27 |
874759 | 874759 | 2020-12-28 | Mathews | Virginia | 51115 | 298 | 3 |
874760 | 874760 | 2020-12-28 | Mecklenburg | Virginia | 51117 | 1258 | 38 |
874761 | 874761 | 2020-12-28 | Middlesex | Virginia | 51119 | 265 | 11 |
874762 | 874762 | 2020-12-28 | Montgomery | Virginia | 51121 | 5060 | 36 |
874763 | 874763 | 2020-12-28 | Nelson | Virginia | 51125 | 331 | 4 |
874764 | 874764 | 2020-12-28 | New Kent | Virginia | 51127 | 616 | 5 |
874765 | 874765 | 2020-12-28 | Newport News city | Virginia | 51700 | 5673 | 66 |
874766 | 874766 | 2020-12-28 | Norfolk city | Virginia | 51710 | 8448 | 105 |
874767 | 874767 | 2020-12-28 | Northampton | Virginia | 51131 | 437 | 31 |
874768 | 874768 | 2020-12-28 | Northumberland | Virginia | 51133 | 409 | 10 |
874769 | 874769 | 2020-12-28 | Norton city | Virginia | 51720 | 162 | 1 |
874770 | 874770 | 2020-12-28 | Nottoway | Virginia | 51135 | 1047 | 24 |
874771 | 874771 | 2020-12-28 | Orange | Virginia | 51137 | 892 | 13 |
874772 | 874772 | 2020-12-28 | Page | Virginia | 51139 | 996 | 33 |
874773 | 874773 | 2020-12-28 | Patrick | Virginia | 51141 | 723 | 28 |
874774 | 874774 | 2020-12-28 | Petersburg city | Virginia | 51730 | 1354 | 33 |
874775 | 874775 | 2020-12-28 | Pittsylvania | Virginia | 51143 | 2550 | 37 |
874776 | 874776 | 2020-12-28 | Poquoson city | Virginia | 51735 | 304 | 3 |
874777 | 874777 | 2020-12-28 | Portsmouth city | Virginia | 51740 | 4337 | 77 |
874778 | 874778 | 2020-12-28 | Powhatan | Virginia | 51145 | 772 | 6 |
874779 | 874779 | 2020-12-28 | Prince Edward | Virginia | 51147 | 1065 | 16 |
874780 | 874780 | 2020-12-28 | Prince George | Virginia | 51149 | 1770 | 7 |
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);