ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2020-09-26" 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 |
---|---|---|---|---|---|---|---|
572960 | 572960 | 2020-09-26 | Accomack | Virginia | 51001 | 1175 | 19 |
572961 | 572961 | 2020-09-26 | Albemarle | Virginia | 51003 | 1253 | 21 |
572962 | 572962 | 2020-09-26 | Alexandria city | Virginia | 51510 | 3804 | 69 |
572963 | 572963 | 2020-09-26 | Alleghany | Virginia | 51005 | 78 | 4 |
572964 | 572964 | 2020-09-26 | Amelia | Virginia | 51007 | 124 | 5 |
572965 | 572965 | 2020-09-26 | Amherst | Virginia | 51009 | 395 | 4 |
572966 | 572966 | 2020-09-26 | Appomattox | Virginia | 51011 | 215 | 3 |
572967 | 572967 | 2020-09-26 | Arlington | Virginia | 51013 | 3935 | 149 |
572968 | 572968 | 2020-09-26 | Augusta | Virginia | 51015 | 494 | 7 |
572969 | 572969 | 2020-09-26 | Bath | Virginia | 51017 | 7 | 0 |
572970 | 572970 | 2020-09-26 | Bedford | Virginia | 51019 | 753 | 13 |
572971 | 572971 | 2020-09-26 | Bland | Virginia | 51021 | 64 | 5 |
572972 | 572972 | 2020-09-26 | Botetourt | Virginia | 51023 | 302 | 10 |
572973 | 572973 | 2020-09-26 | Bristol city | Virginia | 51520 | 182 | 5 |
572974 | 572974 | 2020-09-26 | Brunswick | Virginia | 51025 | 355 | 5 |
572975 | 572975 | 2020-09-26 | Buchanan | Virginia | 51027 | 140 | 2 |
572976 | 572976 | 2020-09-26 | Buckingham | Virginia | 51029 | 679 | 9 |
572977 | 572977 | 2020-09-26 | Buena Vista city | Virginia | 51530 | 80 | 1 |
572978 | 572978 | 2020-09-26 | Campbell | Virginia | 51031 | 447 | 4 |
572979 | 572979 | 2020-09-26 | Caroline | Virginia | 51033 | 350 | 5 |
572980 | 572980 | 2020-09-26 | Carroll | Virginia | 51035 | 499 | 24 |
572981 | 572981 | 2020-09-26 | Charles City | Virginia | 51036 | 84 | 5 |
572982 | 572982 | 2020-09-26 | Charlotte | Virginia | 51037 | 106 | 0 |
572983 | 572983 | 2020-09-26 | Charlottesville city | Virginia | 51540 | 1186 | 28 |
572984 | 572984 | 2020-09-26 | Chesapeake city | Virginia | 51550 | 4296 | 71 |
572985 | 572985 | 2020-09-26 | Chesterfield | Virginia | 51041 | 5945 | 94 |
572986 | 572986 | 2020-09-26 | Clarke | Virginia | 51043 | 94 | 0 |
572987 | 572987 | 2020-09-26 | Colonial Heights city | Virginia | 51570 | 256 | 25 |
572988 | 572988 | 2020-09-26 | Covington city | Virginia | 51580 | 32 | 0 |
572989 | 572989 | 2020-09-26 | Craig | Virginia | 51045 | 29 | 0 |
572990 | 572990 | 2020-09-26 | Culpeper | Virginia | 51047 | 1195 | 17 |
572991 | 572991 | 2020-09-26 | Cumberland | Virginia | 51049 | 105 | 2 |
572992 | 572992 | 2020-09-26 | Danville city | Virginia | 51590 | 868 | 27 |
572993 | 572993 | 2020-09-26 | Dickenson | Virginia | 51051 | 101 | 1 |
572994 | 572994 | 2020-09-26 | Dinwiddie | Virginia | 51053 | 377 | 11 |
572995 | 572995 | 2020-09-26 | Emporia city | Virginia | 51595 | 255 | 26 |
572996 | 572996 | 2020-09-26 | Essex | Virginia | 51057 | 178 | 2 |
572997 | 572997 | 2020-09-26 | Fairfax | Virginia | 51059 | 20687 | 586 |
572998 | 572998 | 2020-09-26 | Fairfax city | Virginia | 51600 | 136 | 8 |
572999 | 572999 | 2020-09-26 | Falls Church city | Virginia | 51610 | 70 | 7 |
573000 | 573000 | 2020-09-26 | Fauquier | Virginia | 51061 | 931 | 25 |
573001 | 573001 | 2020-09-26 | Floyd | Virginia | 51063 | 203 | 9 |
573002 | 573002 | 2020-09-26 | Fluvanna | Virginia | 51065 | 375 | 9 |
573003 | 573003 | 2020-09-26 | Franklin | Virginia | 51067 | 335 | 3 |
573004 | 573004 | 2020-09-26 | Franklin city | Virginia | 51620 | 415 | 9 |
573005 | 573005 | 2020-09-26 | Frederick | Virginia | 51069 | 881 | 13 |
573006 | 573006 | 2020-09-26 | Fredericksburg city | Virginia | 51630 | 539 | 5 |
573007 | 573007 | 2020-09-26 | Galax city | Virginia | 51640 | 415 | 30 |
573008 | 573008 | 2020-09-26 | Giles | Virginia | 51071 | 89 | 0 |
573009 | 573009 | 2020-09-26 | Gloucester | Virginia | 51073 | 242 | 2 |
573010 | 573010 | 2020-09-26 | Goochland | Virginia | 51075 | 269 | 7 |
573011 | 573011 | 2020-09-26 | Grayson | Virginia | 51077 | 312 | 12 |
573012 | 573012 | 2020-09-26 | Greene | Virginia | 51079 | 216 | 3 |
573013 | 573013 | 2020-09-26 | Greensville | Virginia | 51081 | 781 | 11 |
573014 | 573014 | 2020-09-26 | Halifax | Virginia | 51083 | 348 | 6 |
573015 | 573015 | 2020-09-26 | Hampton city | Virginia | 51650 | 1809 | 24 |
573016 | 573016 | 2020-09-26 | Hanover | Virginia | 51085 | 1288 | 37 |
573017 | 573017 | 2020-09-26 | Harrisonburg city | Virginia | 51660 | 2608 | 34 |
573018 | 573018 | 2020-09-26 | Henrico | Virginia | 51087 | 5434 | 211 |
573019 | 573019 | 2020-09-26 | Henry | Virginia | 51089 | 1046 | 21 |
573020 | 573020 | 2020-09-26 | Highland | Virginia | 51091 | 7 | 0 |
573021 | 573021 | 2020-09-26 | Hopewell city | Virginia | 51670 | 390 | 7 |
573022 | 573022 | 2020-09-26 | Isle of Wight | Virginia | 51093 | 733 | 19 |
573023 | 573023 | 2020-09-26 | James City | Virginia | 51095 | 848 | 20 |
573024 | 573024 | 2020-09-26 | King George | Virginia | 51099 | 228 | 4 |
573025 | 573025 | 2020-09-26 | King William | Virginia | 51101 | 160 | 2 |
573026 | 573026 | 2020-09-26 | King and Queen | Virginia | 51097 | 72 | 1 |
573027 | 573027 | 2020-09-26 | Lancaster | Virginia | 51103 | 144 | 0 |
573028 | 573028 | 2020-09-26 | Lee | Virginia | 51105 | 267 | 7 |
573029 | 573029 | 2020-09-26 | Lexington city | Virginia | 51678 | 77 | 1 |
573030 | 573030 | 2020-09-26 | Loudoun | Virginia | 51107 | 6792 | 124 |
573031 | 573031 | 2020-09-26 | Louisa | Virginia | 51109 | 289 | 6 |
573032 | 573032 | 2020-09-26 | Lunenburg | Virginia | 51111 | 118 | 3 |
573033 | 573033 | 2020-09-26 | Lynchburg city | Virginia | 51680 | 1391 | 13 |
573034 | 573034 | 2020-09-26 | Madison | Virginia | 51113 | 106 | 3 |
573035 | 573035 | 2020-09-26 | Manassas Park city | Virginia | 51685 | 610 | 8 |
573036 | 573036 | 2020-09-26 | Manassas city | Virginia | 51683 | 1918 | 25 |
573037 | 573037 | 2020-09-26 | Martinsville city | Virginia | 51690 | 382 | 16 |
573038 | 573038 | 2020-09-26 | Mathews | Virginia | 51115 | 72 | 0 |
573039 | 573039 | 2020-09-26 | Mecklenburg | Virginia | 51117 | 717 | 33 |
573040 | 573040 | 2020-09-26 | Middlesex | Virginia | 51119 | 115 | 10 |
573041 | 573041 | 2020-09-26 | Montgomery | Virginia | 51121 | 1909 | 4 |
573042 | 573042 | 2020-09-26 | Nelson | Virginia | 51125 | 100 | 2 |
573043 | 573043 | 2020-09-26 | New Kent | Virginia | 51127 | 189 | 3 |
573044 | 573044 | 2020-09-26 | Newport News city | Virginia | 51700 | 2721 | 38 |
573045 | 573045 | 2020-09-26 | Norfolk city | Virginia | 51710 | 4822 | 78 |
573046 | 573046 | 2020-09-26 | Northampton | Virginia | 51131 | 305 | 31 |
573047 | 573047 | 2020-09-26 | Northumberland | Virginia | 51133 | 157 | 6 |
573048 | 573048 | 2020-09-26 | Norton city | Virginia | 51720 | 33 | 0 |
573049 | 573049 | 2020-09-26 | Nottoway | Virginia | 51135 | 265 | 18 |
573050 | 573050 | 2020-09-26 | Orange | Virginia | 51137 | 322 | 4 |
573051 | 573051 | 2020-09-26 | Page | Virginia | 51139 | 393 | 29 |
573052 | 573052 | 2020-09-26 | Patrick | Virginia | 51141 | 277 | 25 |
573053 | 573053 | 2020-09-26 | Petersburg city | Virginia | 51730 | 734 | 29 |
573054 | 573054 | 2020-09-26 | Pittsylvania | Virginia | 51143 | 994 | 9 |
573055 | 573055 | 2020-09-26 | Poquoson city | Virginia | 51735 | 74 | 2 |
573056 | 573056 | 2020-09-26 | Portsmouth city | Virginia | 51740 | 2555 | 59 |
573057 | 573057 | 2020-09-26 | Powhatan | Virginia | 51145 | 221 | 5 |
573058 | 573058 | 2020-09-26 | Prince Edward | Virginia | 51147 | 581 | 12 |
573059 | 573059 | 2020-09-26 | Prince George | Virginia | 51149 | 796 | 5 |
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);