ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2020-10-20" 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 |
---|---|---|---|---|---|---|---|
650791 | 650791 | 2020-10-20 | Accomack | Virginia | 51001 | 1202 | 19 |
650792 | 650792 | 2020-10-20 | Albemarle | Virginia | 51003 | 1495 | 23 |
650793 | 650793 | 2020-10-20 | Alexandria city | Virginia | 51510 | 4133 | 75 |
650794 | 650794 | 2020-10-20 | Alleghany | Virginia | 51005 | 89 | 4 |
650795 | 650795 | 2020-10-20 | Amelia | Virginia | 51007 | 139 | 6 |
650796 | 650796 | 2020-10-20 | Amherst | Virginia | 51009 | 540 | 4 |
650797 | 650797 | 2020-10-20 | Appomattox | Virginia | 51011 | 269 | 5 |
650798 | 650798 | 2020-10-20 | Arlington | Virginia | 51013 | 4399 | 152 |
650799 | 650799 | 2020-10-20 | Augusta | Virginia | 51015 | 622 | 8 |
650800 | 650800 | 2020-10-20 | Bath | Virginia | 51017 | 22 | 0 |
650801 | 650801 | 2020-10-20 | Bedford | Virginia | 51019 | 1086 | 16 |
650802 | 650802 | 2020-10-20 | Bland | Virginia | 51021 | 64 | 5 |
650803 | 650803 | 2020-10-20 | Botetourt | Virginia | 51023 | 357 | 12 |
650804 | 650804 | 2020-10-20 | Bristol city | Virginia | 51520 | 236 | 7 |
650805 | 650805 | 2020-10-20 | Brunswick | Virginia | 51025 | 412 | 5 |
650806 | 650806 | 2020-10-20 | Buchanan | Virginia | 51027 | 239 | 2 |
650807 | 650807 | 2020-10-20 | Buckingham | Virginia | 51029 | 725 | 9 |
650808 | 650808 | 2020-10-20 | Buena Vista city | Virginia | 51530 | 121 | 1 |
650809 | 650809 | 2020-10-20 | Campbell | Virginia | 51031 | 643 | 7 |
650810 | 650810 | 2020-10-20 | Caroline | Virginia | 51033 | 402 | 5 |
650811 | 650811 | 2020-10-20 | Carroll | Virginia | 51035 | 568 | 27 |
650812 | 650812 | 2020-10-20 | Charles City | Virginia | 51036 | 96 | 5 |
650813 | 650813 | 2020-10-20 | Charlotte | Virginia | 51037 | 201 | 1 |
650814 | 650814 | 2020-10-20 | Charlottesville city | Virginia | 51540 | 1515 | 32 |
650815 | 650815 | 2020-10-20 | Chesapeake city | Virginia | 51550 | 4763 | 79 |
650816 | 650816 | 2020-10-20 | Chesterfield | Virginia | 51041 | 6737 | 100 |
650817 | 650817 | 2020-10-20 | Clarke | Virginia | 51043 | 115 | 1 |
650818 | 650818 | 2020-10-20 | Colonial Heights city | Virginia | 51570 | 287 | 26 |
650819 | 650819 | 2020-10-20 | Covington city | Virginia | 51580 | 35 | 0 |
650820 | 650820 | 2020-10-20 | Craig | Virginia | 51045 | 42 | 0 |
650821 | 650821 | 2020-10-20 | Culpeper | Virginia | 51047 | 1321 | 18 |
650822 | 650822 | 2020-10-20 | Cumberland | Virginia | 51049 | 113 | 2 |
650823 | 650823 | 2020-10-20 | Danville city | Virginia | 51590 | 1130 | 39 |
650824 | 650824 | 2020-10-20 | Dickenson | Virginia | 51051 | 121 | 1 |
650825 | 650825 | 2020-10-20 | Dinwiddie | Virginia | 51053 | 485 | 12 |
650826 | 650826 | 2020-10-20 | Emporia city | Virginia | 51595 | 278 | 27 |
650827 | 650827 | 2020-10-20 | Essex | Virginia | 51057 | 188 | 2 |
650828 | 650828 | 2020-10-20 | Fairfax | Virginia | 51059 | 22769 | 602 |
650829 | 650829 | 2020-10-20 | Fairfax city | Virginia | 51600 | 155 | 8 |
650830 | 650830 | 2020-10-20 | Falls Church city | Virginia | 51610 | 75 | 7 |
650831 | 650831 | 2020-10-20 | Fauquier | Virginia | 51061 | 1049 | 26 |
650832 | 650832 | 2020-10-20 | Floyd | Virginia | 51063 | 233 | 16 |
650833 | 650833 | 2020-10-20 | Fluvanna | Virginia | 51065 | 410 | 9 |
650834 | 650834 | 2020-10-20 | Franklin | Virginia | 51067 | 678 | 4 |
650835 | 650835 | 2020-10-20 | Franklin city | Virginia | 51620 | 477 | 12 |
650836 | 650836 | 2020-10-20 | Frederick | Virginia | 51069 | 1107 | 13 |
650837 | 650837 | 2020-10-20 | Fredericksburg city | Virginia | 51630 | 573 | 5 |
650838 | 650838 | 2020-10-20 | Galax city | Virginia | 51640 | 433 | 30 |
650839 | 650839 | 2020-10-20 | Giles | Virginia | 51071 | 114 | 0 |
650840 | 650840 | 2020-10-20 | Gloucester | Virginia | 51073 | 333 | 3 |
650841 | 650841 | 2020-10-20 | Goochland | Virginia | 51075 | 312 | 7 |
650842 | 650842 | 2020-10-20 | Grayson | Virginia | 51077 | 365 | 18 |
650843 | 650843 | 2020-10-20 | Greene | Virginia | 51079 | 269 | 3 |
650844 | 650844 | 2020-10-20 | Greensville | Virginia | 51081 | 887 | 13 |
650845 | 650845 | 2020-10-20 | Halifax | Virginia | 51083 | 459 | 7 |
650846 | 650846 | 2020-10-20 | Hampton city | Virginia | 51650 | 2058 | 32 |
650847 | 650847 | 2020-10-20 | Hanover | Virginia | 51085 | 1545 | 41 |
650848 | 650848 | 2020-10-20 | Harrisonburg city | Virginia | 51660 | 2934 | 35 |
650849 | 650849 | 2020-10-20 | Henrico | Virginia | 51087 | 6006 | 227 |
650850 | 650850 | 2020-10-20 | Henry | Virginia | 51089 | 1250 | 31 |
650851 | 650851 | 2020-10-20 | Highland | Virginia | 51091 | 9 | 0 |
650852 | 650852 | 2020-10-20 | Hopewell city | Virginia | 51670 | 487 | 7 |
650853 | 650853 | 2020-10-20 | Isle of Wight | Virginia | 51093 | 831 | 24 |
650854 | 650854 | 2020-10-20 | James City | Virginia | 51095 | 927 | 22 |
650855 | 650855 | 2020-10-20 | King George | Virginia | 51099 | 265 | 4 |
650856 | 650856 | 2020-10-20 | King William | Virginia | 51101 | 191 | 2 |
650857 | 650857 | 2020-10-20 | King and Queen | Virginia | 51097 | 86 | 1 |
650858 | 650858 | 2020-10-20 | Lancaster | Virginia | 51103 | 175 | 1 |
650859 | 650859 | 2020-10-20 | Lee | Virginia | 51105 | 400 | 9 |
650860 | 650860 | 2020-10-20 | Lexington city | Virginia | 51678 | 208 | 1 |
650861 | 650861 | 2020-10-20 | Loudoun | Virginia | 51107 | 7599 | 130 |
650862 | 650862 | 2020-10-20 | Louisa | Virginia | 51109 | 375 | 7 |
650863 | 650863 | 2020-10-20 | Lunenburg | Virginia | 51111 | 145 | 3 |
650864 | 650864 | 2020-10-20 | Lynchburg city | Virginia | 51680 | 1844 | 24 |
650865 | 650865 | 2020-10-20 | Madison | Virginia | 51113 | 123 | 3 |
650866 | 650866 | 2020-10-20 | Manassas Park city | Virginia | 51685 | 632 | 8 |
650867 | 650867 | 2020-10-20 | Manassas city | Virginia | 51683 | 2013 | 27 |
650868 | 650868 | 2020-10-20 | Martinsville city | Virginia | 51690 | 460 | 23 |
650869 | 650869 | 2020-10-20 | Mathews | Virginia | 51115 | 126 | 0 |
650870 | 650870 | 2020-10-20 | Mecklenburg | Virginia | 51117 | 850 | 34 |
650871 | 650871 | 2020-10-20 | Middlesex | Virginia | 51119 | 140 | 11 |
650872 | 650872 | 2020-10-20 | Montgomery | Virginia | 51121 | 2549 | 5 |
650873 | 650873 | 2020-10-20 | Nelson | Virginia | 51125 | 126 | 2 |
650874 | 650874 | 2020-10-20 | New Kent | Virginia | 51127 | 268 | 3 |
650875 | 650875 | 2020-10-20 | Newport News city | Virginia | 51700 | 3071 | 50 |
650876 | 650876 | 2020-10-20 | Norfolk city | Virginia | 51710 | 5209 | 84 |
650877 | 650877 | 2020-10-20 | Northampton | Virginia | 51131 | 314 | 31 |
650878 | 650878 | 2020-10-20 | Northumberland | Virginia | 51133 | 208 | 7 |
650879 | 650879 | 2020-10-20 | Norton city | Virginia | 51720 | 45 | 0 |
650880 | 650880 | 2020-10-20 | Nottoway | Virginia | 51135 | 334 | 20 |
650881 | 650881 | 2020-10-20 | Orange | Virginia | 51137 | 376 | 5 |
650882 | 650882 | 2020-10-20 | Page | Virginia | 51139 | 459 | 30 |
650883 | 650883 | 2020-10-20 | Patrick | Virginia | 51141 | 306 | 26 |
650884 | 650884 | 2020-10-20 | Petersburg city | Virginia | 51730 | 885 | 29 |
650885 | 650885 | 2020-10-20 | Pittsylvania | Virginia | 51143 | 1227 | 17 |
650886 | 650886 | 2020-10-20 | Poquoson city | Virginia | 51735 | 89 | 2 |
650887 | 650887 | 2020-10-20 | Portsmouth city | Virginia | 51740 | 2730 | 65 |
650888 | 650888 | 2020-10-20 | Powhatan | Virginia | 51145 | 283 | 5 |
650889 | 650889 | 2020-10-20 | Prince Edward | Virginia | 51147 | 725 | 13 |
650890 | 650890 | 2020-10-20 | Prince George | Virginia | 51149 | 1054 | 6 |
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);