ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-11-03" 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 |
---|---|---|---|---|---|---|---|
1881275 | 1881275 | 2021-11-03 | Accomack | Virginia | 51001 | 4102 | 79 |
1881276 | 1881276 | 2021-11-03 | Albemarle | Virginia | 51003 | 8122 | 102 |
1881277 | 1881277 | 2021-11-03 | Alexandria city | Virginia | 51510 | 14363 | 150 |
1881278 | 1881278 | 2021-11-03 | Alleghany | Virginia | 51005 | 2140 | 78 |
1881279 | 1881279 | 2021-11-03 | Amelia | Virginia | 51007 | 1445 | 40 |
1881280 | 1881280 | 2021-11-03 | Amherst | Virginia | 51009 | 4368 | 57 |
1881281 | 1881281 | 2021-11-03 | Appomattox | Virginia | 51011 | 2412 | 36 |
1881282 | 1881282 | 2021-11-03 | Arlington | Virginia | 51013 | 18722 | 272 |
1881283 | 1881283 | 2021-11-03 | Augusta | Virginia | 51015 | 10234 | 130 |
1881284 | 1881284 | 2021-11-03 | Bath | Virginia | 51017 | 491 | 15 |
1881285 | 1881285 | 2021-11-03 | Bedford | Virginia | 51019 | 10002 | 153 |
1881286 | 1881286 | 2021-11-03 | Bland | Virginia | 51021 | 1084 | 17 |
1881287 | 1881287 | 2021-11-03 | Botetourt | Virginia | 51023 | 3935 | 50 |
1881288 | 1881288 | 2021-11-03 | Bristol city | Virginia | 51520 | 2284 | 47 |
1881289 | 1881289 | 2021-11-03 | Brunswick | Virginia | 51025 | 1816 | 32 |
1881290 | 1881290 | 2021-11-03 | Buchanan | Virginia | 51027 | 2492 | 64 |
1881291 | 1881291 | 2021-11-03 | Buckingham | Virginia | 51029 | 2683 | 38 |
1881292 | 1881292 | 2021-11-03 | Buena Vista city | Virginia | 51530 | 1334 | 27 |
1881293 | 1881293 | 2021-11-03 | Campbell | Virginia | 51031 | 7249 | 139 |
1881294 | 1881294 | 2021-11-03 | Caroline | Virginia | 51033 | 3982 | 51 |
1881295 | 1881295 | 2021-11-03 | Carroll | Virginia | 51035 | 4001 | 95 |
1881296 | 1881296 | 2021-11-03 | Charles City | Virginia | 51036 | 693 | 20 |
1881297 | 1881297 | 2021-11-03 | Charlotte | Virginia | 51037 | 1293 | 27 |
1881298 | 1881298 | 2021-11-03 | Charlottesville city | Virginia | 51540 | 5358 | 59 |
1881299 | 1881299 | 2021-11-03 | Chesapeake city | Virginia | 51550 | 28919 | 360 |
1881300 | 1881300 | 2021-11-03 | Chesterfield | Virginia | 51041 | 39897 | 552 |
1881301 | 1881301 | 2021-11-03 | Clarke | Virginia | 51043 | 1364 | 25 |
1881302 | 1881302 | 2021-11-03 | Colonial Heights city | Virginia | 51570 | 2609 | 66 |
1881303 | 1881303 | 2021-11-03 | Covington city | Virginia | 51580 | 761 | 16 |
1881304 | 1881304 | 2021-11-03 | Craig | Virginia | 51045 | 555 | 8 |
1881305 | 1881305 | 2021-11-03 | Culpeper | Virginia | 51047 | 6538 | 86 |
1881306 | 1881306 | 2021-11-03 | Cumberland | Virginia | 51049 | 721 | 18 |
1881307 | 1881307 | 2021-11-03 | Danville city | Virginia | 51590 | 6273 | 194 |
1881308 | 1881308 | 2021-11-03 | Dickenson | Virginia | 51051 | 1678 | 27 |
1881309 | 1881309 | 2021-11-03 | Dinwiddie | Virginia | 51053 | 3178 | 52 |
1881310 | 1881310 | 2021-11-03 | Emporia city | Virginia | 51595 | 864 | 43 |
1881311 | 1881311 | 2021-11-03 | Essex | Virginia | 51057 | 1263 | 19 |
1881312 | 1881312 | 2021-11-03 | Fairfax | Virginia | 51059 | 92312 | 1177 |
1881313 | 1881313 | 2021-11-03 | Fairfax city | Virginia | 51600 | 730 | 25 |
1881314 | 1881314 | 2021-11-03 | Falls Church city | Virginia | 51610 | 572 | 12 |
1881315 | 1881315 | 2021-11-03 | Fauquier | Virginia | 51061 | 7055 | 86 |
1881316 | 1881316 | 2021-11-03 | Floyd | Virginia | 51063 | 1452 | 29 |
1881317 | 1881317 | 2021-11-03 | Fluvanna | Virginia | 51065 | 2713 | 24 |
1881318 | 1881318 | 2021-11-03 | Franklin | Virginia | 51067 | 6080 | 106 |
1881319 | 1881319 | 2021-11-03 | Franklin city | Virginia | 51620 | 1634 | 44 |
1881320 | 1881320 | 2021-11-03 | Frederick | Virginia | 51069 | 11677 | 150 |
1881321 | 1881321 | 2021-11-03 | Fredericksburg city | Virginia | 51630 | 3090 | 26 |
1881322 | 1881322 | 2021-11-03 | Galax city | Virginia | 51640 | 1538 | 62 |
1881323 | 1881323 | 2021-11-03 | Giles | Virginia | 51071 | 2296 | 31 |
1881324 | 1881324 | 2021-11-03 | Gloucester | Virginia | 51073 | 3872 | 76 |
1881325 | 1881325 | 2021-11-03 | Goochland | Virginia | 51075 | 2031 | 30 |
1881326 | 1881326 | 2021-11-03 | Grayson | Virginia | 51077 | 2109 | 46 |
1881327 | 1881327 | 2021-11-03 | Greene | Virginia | 51079 | 2226 | 42 |
1881328 | 1881328 | 2021-11-03 | Greensville | Virginia | 51081 | 1908 | 28 |
1881329 | 1881329 | 2021-11-03 | Halifax | Virginia | 51083 | 3939 | 107 |
1881330 | 1881330 | 2021-11-03 | Hampton city | Virginia | 51650 | 15104 | 237 |
1881331 | 1881331 | 2021-11-03 | Hanover | Virginia | 51085 | 11879 | 196 |
1881332 | 1881332 | 2021-11-03 | Harrisonburg city | Virginia | 51660 | 8284 | 107 |
1881333 | 1881333 | 2021-11-03 | Henrico | Virginia | 51087 | 34610 | 718 |
1881334 | 1881334 | 2021-11-03 | Henry | Virginia | 51089 | 6564 | 161 |
1881335 | 1881335 | 2021-11-03 | Highland | Virginia | 51091 | 182 | 4 |
1881336 | 1881336 | 2021-11-03 | Hopewell city | Virginia | 51670 | 3720 | 89 |
1881337 | 1881337 | 2021-11-03 | Isle of Wight | Virginia | 51093 | 4487 | 89 |
1881338 | 1881338 | 2021-11-03 | James City | Virginia | 51095 | 7040 | 94 |
1881339 | 1881339 | 2021-11-03 | King George | Virginia | 51099 | 2675 | 23 |
1881340 | 1881340 | 2021-11-03 | King William | Virginia | 51101 | 1943 | 24 |
1881341 | 1881341 | 2021-11-03 | King and Queen | Virginia | 51097 | 640 | 8 |
1881342 | 1881342 | 2021-11-03 | Lancaster | Virginia | 51103 | 1068 | 22 |
1881343 | 1881343 | 2021-11-03 | Lee | Virginia | 51105 | 3728 | 60 |
1881344 | 1881344 | 2021-11-03 | Lexington city | Virginia | 51678 | 1587 | 36 |
1881345 | 1881345 | 2021-11-03 | Loudoun | Virginia | 51107 | 34355 | 300 |
1881346 | 1881346 | 2021-11-03 | Louisa | Virginia | 51109 | 3257 | 48 |
1881347 | 1881347 | 2021-11-03 | Lunenburg | Virginia | 51111 | 1117 | 20 |
1881348 | 1881348 | 2021-11-03 | Lynchburg city | Virginia | 51680 | 11828 | 186 |
1881349 | 1881349 | 2021-11-03 | Madison | Virginia | 51113 | 1003 | 21 |
1881350 | 1881350 | 2021-11-03 | Manassas Park city | Virginia | 51685 | 1276 | 13 |
1881351 | 1881351 | 2021-11-03 | Manassas city | Virginia | 51683 | 5104 | 53 |
1881352 | 1881352 | 2021-11-03 | Martinsville city | Virginia | 51690 | 2084 | 90 |
1881353 | 1881353 | 2021-11-03 | Mathews | Virginia | 51115 | 895 | 22 |
1881354 | 1881354 | 2021-11-03 | Mecklenburg | Virginia | 51117 | 3440 | 84 |
1881355 | 1881355 | 2021-11-03 | Middlesex | Virginia | 51119 | 948 | 33 |
1881356 | 1881356 | 2021-11-03 | Montgomery | Virginia | 51121 | 11839 | 110 |
1881357 | 1881357 | 2021-11-03 | Nelson | Virginia | 51125 | 1380 | 18 |
1881358 | 1881358 | 2021-11-03 | New Kent | Virginia | 51127 | 2434 | 25 |
1881359 | 1881359 | 2021-11-03 | Newport News city | Virginia | 51700 | 20726 | 300 |
1881360 | 1881360 | 2021-11-03 | Norfolk city | Virginia | 51710 | 24558 | 341 |
1881361 | 1881361 | 2021-11-03 | Northampton | Virginia | 51131 | 1159 | 44 |
1881362 | 1881362 | 2021-11-03 | Northumberland | Virginia | 51133 | 1224 | 32 |
1881363 | 1881363 | 2021-11-03 | Norton city | Virginia | 51720 | 582 | 13 |
1881364 | 1881364 | 2021-11-03 | Nottoway | Virginia | 51135 | 2616 | 67 |
1881365 | 1881365 | 2021-11-03 | Orange | Virginia | 51137 | 3744 | 59 |
1881366 | 1881366 | 2021-11-03 | Page | Virginia | 51139 | 3406 | 78 |
1881367 | 1881367 | 2021-11-03 | Patrick | Virginia | 51141 | 2080 | 55 |
1881368 | 1881368 | 2021-11-03 | Petersburg city | Virginia | 51730 | 5223 | 108 |
1881369 | 1881369 | 2021-11-03 | Pittsylvania | Virginia | 51143 | 8202 | 117 |
1881370 | 1881370 | 2021-11-03 | Poquoson city | Virginia | 51735 | 1349 | 21 |
1881371 | 1881371 | 2021-11-03 | Portsmouth city | Virginia | 51740 | 12699 | 243 |
1881372 | 1881372 | 2021-11-03 | Powhatan | Virginia | 51145 | 2827 | 28 |
1881373 | 1881373 | 2021-11-03 | Prince Edward | Virginia | 51147 | 2953 | 51 |
1881374 | 1881374 | 2021-11-03 | Prince George | Virginia | 51149 | 4986 | 45 |
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);