ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-12-21" 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 |
---|---|---|---|---|---|---|---|
2037291 | 2037291 | 2021-12-21 | Accomack | Virginia | 51001 | 4365 | 83 |
2037292 | 2037292 | 2021-12-21 | Albemarle | Virginia | 51003 | 8995 | 114 |
2037293 | 2037293 | 2021-12-21 | Alexandria city | Virginia | 51510 | 16238 | 156 |
2037294 | 2037294 | 2021-12-21 | Alleghany | Virginia | 51005 | 2436 | 85 |
2037295 | 2037295 | 2021-12-21 | Amelia | Virginia | 51007 | 1656 | 43 |
2037296 | 2037296 | 2021-12-21 | Amherst | Virginia | 51009 | 4735 | 62 |
2037297 | 2037297 | 2021-12-21 | Appomattox | Virginia | 51011 | 2635 | 37 |
2037298 | 2037298 | 2021-12-21 | Arlington | Virginia | 51013 | 21755 | 276 |
2037299 | 2037299 | 2021-12-21 | Augusta | Virginia | 51015 | 11413 | 140 |
2037300 | 2037300 | 2021-12-21 | Bath | Virginia | 51017 | 547 | 15 |
2037301 | 2037301 | 2021-12-21 | Bedford | Virginia | 51019 | 10986 | 172 |
2037302 | 2037302 | 2021-12-21 | Bland | Virginia | 51021 | 1160 | 18 |
2037303 | 2037303 | 2021-12-21 | Botetourt | Virginia | 51023 | 4548 | 60 |
2037304 | 2037304 | 2021-12-21 | Bristol city | Virginia | 51520 | 2624 | 52 |
2037305 | 2037305 | 2021-12-21 | Brunswick | Virginia | 51025 | 1886 | 35 |
2037306 | 2037306 | 2021-12-21 | Buchanan | Virginia | 51027 | 3005 | 84 |
2037307 | 2037307 | 2021-12-21 | Buckingham | Virginia | 51029 | 2829 | 41 |
2037308 | 2037308 | 2021-12-21 | Buena Vista city | Virginia | 51530 | 1477 | 32 |
2037309 | 2037309 | 2021-12-21 | Campbell | Virginia | 51031 | 8040 | 154 |
2037310 | 2037310 | 2021-12-21 | Caroline | Virginia | 51033 | 4572 | 56 |
2037311 | 2037311 | 2021-12-21 | Carroll | Virginia | 51035 | 4606 | 109 |
2037312 | 2037312 | 2021-12-21 | Charles City | Virginia | 51036 | 787 | 22 |
2037313 | 2037313 | 2021-12-21 | Charlotte | Virginia | 51037 | 1470 | 29 |
2037314 | 2037314 | 2021-12-21 | Charlottesville city | Virginia | 51540 | 5808 | 62 |
2037315 | 2037315 | 2021-12-21 | Chesapeake city | Virginia | 51550 | 31102 | 375 |
2037316 | 2037316 | 2021-12-21 | Chesterfield | Virginia | 51041 | 43970 | 594 |
2037317 | 2037317 | 2021-12-21 | Clarke | Virginia | 51043 | 1677 | 33 |
2037318 | 2037318 | 2021-12-21 | Colonial Heights city | Virginia | 51570 | 2826 | 70 |
2037319 | 2037319 | 2021-12-21 | Covington city | Virginia | 51580 | 802 | 19 |
2037320 | 2037320 | 2021-12-21 | Craig | Virginia | 51045 | 713 | 11 |
2037321 | 2037321 | 2021-12-21 | Culpeper | Virginia | 51047 | 7494 | 94 |
2037322 | 2037322 | 2021-12-21 | Cumberland | Virginia | 51049 | 802 | 19 |
2037323 | 2037323 | 2021-12-21 | Danville city | Virginia | 51590 | 6749 | 205 |
2037324 | 2037324 | 2021-12-21 | Dickenson | Virginia | 51051 | 2130 | 32 |
2037325 | 2037325 | 2021-12-21 | Dinwiddie | Virginia | 51053 | 3588 | 61 |
2037326 | 2037326 | 2021-12-21 | Emporia city | Virginia | 51595 | 850 | 46 |
2037327 | 2037327 | 2021-12-21 | Essex | Virginia | 51057 | 1392 | 20 |
2037328 | 2037328 | 2021-12-21 | Fairfax | Virginia | 51059 | 101141 | 1189 |
2037329 | 2037329 | 2021-12-21 | Fairfax city | Virginia | 51600 | 1161 | 36 |
2037330 | 2037330 | 2021-12-21 | Falls Church city | Virginia | 51610 | 790 | 14 |
2037331 | 2037331 | 2021-12-21 | Fauquier | Virginia | 51061 | 8157 | 92 |
2037332 | 2037332 | 2021-12-21 | Floyd | Virginia | 51063 | 1707 | 32 |
2037333 | 2037333 | 2021-12-21 | Fluvanna | Virginia | 51065 | 3148 | 29 |
2037334 | 2037334 | 2021-12-21 | Franklin | Virginia | 51067 | 7044 | 121 |
2037335 | 2037335 | 2021-12-21 | Franklin city | Virginia | 51620 | 1723 | 43 |
2037336 | 2037336 | 2021-12-21 | Frederick | Virginia | 51069 | 13611 | 174 |
2037337 | 2037337 | 2021-12-21 | Fredericksburg city | Virginia | 51630 | 3349 | 26 |
2037338 | 2037338 | 2021-12-21 | Galax city | Virginia | 51640 | 1721 | 65 |
2037339 | 2037339 | 2021-12-21 | Giles | Virginia | 51071 | 2535 | 35 |
2037340 | 2037340 | 2021-12-21 | Gloucester | Virginia | 51073 | 4223 | 83 |
2037341 | 2037341 | 2021-12-21 | Goochland | Virginia | 51075 | 2347 | 34 |
2037342 | 2037342 | 2021-12-21 | Grayson | Virginia | 51077 | 2527 | 56 |
2037343 | 2037343 | 2021-12-21 | Greene | Virginia | 51079 | 2481 | 46 |
2037344 | 2037344 | 2021-12-21 | Greensville | Virginia | 51081 | 1998 | 27 |
2037345 | 2037345 | 2021-12-21 | Halifax | Virginia | 51083 | 4365 | 118 |
2037346 | 2037346 | 2021-12-21 | Hampton city | Virginia | 51650 | 16150 | 251 |
2037347 | 2037347 | 2021-12-21 | Hanover | Virginia | 51085 | 13401 | 205 |
2037348 | 2037348 | 2021-12-21 | Harrisonburg city | Virginia | 51660 | 8840 | 116 |
2037349 | 2037349 | 2021-12-21 | Henrico | Virginia | 51087 | 38349 | 745 |
2037350 | 2037350 | 2021-12-21 | Henry | Virginia | 51089 | 7439 | 197 |
2037351 | 2037351 | 2021-12-21 | Highland | Virginia | 51091 | 220 | 4 |
2037352 | 2037352 | 2021-12-21 | Hopewell city | Virginia | 51670 | 3893 | 95 |
2037353 | 2037353 | 2021-12-21 | Isle of Wight | Virginia | 51093 | 4825 | 93 |
2037354 | 2037354 | 2021-12-21 | James City | Virginia | 51095 | 7838 | 100 |
2037355 | 2037355 | 2021-12-21 | King George | Virginia | 51099 | 3075 | 25 |
2037356 | 2037356 | 2021-12-21 | King William | Virginia | 51101 | 2306 | 27 |
2037357 | 2037357 | 2021-12-21 | King and Queen | Virginia | 51097 | 712 | 9 |
2037358 | 2037358 | 2021-12-21 | Lancaster | Virginia | 51103 | 1135 | 24 |
2037359 | 2037359 | 2021-12-21 | Lee | Virginia | 51105 | 4047 | 62 |
2037360 | 2037360 | 2021-12-21 | Lexington city | Virginia | 51678 | 1667 | 37 |
2037361 | 2037361 | 2021-12-21 | Loudoun | Virginia | 51107 | 39045 | 307 |
2037362 | 2037362 | 2021-12-21 | Louisa | Virginia | 51109 | 3872 | 54 |
2037363 | 2037363 | 2021-12-21 | Lunenburg | Virginia | 51111 | 1257 | 23 |
2037364 | 2037364 | 2021-12-21 | Lynchburg city | Virginia | 51680 | 12525 | 207 |
2037365 | 2037365 | 2021-12-21 | Madison | Virginia | 51113 | 1241 | 24 |
2037366 | 2037366 | 2021-12-21 | Manassas Park city | Virginia | 51685 | 1296 | 15 |
2037367 | 2037367 | 2021-12-21 | Manassas city | Virginia | 51683 | 5650 | 54 |
2037368 | 2037368 | 2021-12-21 | Martinsville city | Virginia | 51690 | 2317 | 95 |
2037369 | 2037369 | 2021-12-21 | Mathews | Virginia | 51115 | 962 | 24 |
2037370 | 2037370 | 2021-12-21 | Mecklenburg | Virginia | 51117 | 3710 | 94 |
2037371 | 2037371 | 2021-12-21 | Middlesex | Virginia | 51119 | 1053 | 33 |
2037372 | 2037372 | 2021-12-21 | Montgomery | Virginia | 51121 | 12677 | 117 |
2037373 | 2037373 | 2021-12-21 | Nelson | Virginia | 51125 | 1607 | 22 |
2037374 | 2037374 | 2021-12-21 | New Kent | Virginia | 51127 | 2763 | 27 |
2037375 | 2037375 | 2021-12-21 | Newport News city | Virginia | 51700 | 21978 | 310 |
2037376 | 2037376 | 2021-12-21 | Norfolk city | Virginia | 51710 | 26061 | 365 |
2037377 | 2037377 | 2021-12-21 | Northampton | Virginia | 51131 | 1215 | 48 |
2037378 | 2037378 | 2021-12-21 | Northumberland | Virginia | 51133 | 1298 | 37 |
2037379 | 2037379 | 2021-12-21 | Norton city | Virginia | 51720 | 721 | 19 |
2037380 | 2037380 | 2021-12-21 | Nottoway | Virginia | 51135 | 2727 | 70 |
2037381 | 2037381 | 2021-12-21 | Orange | Virginia | 51137 | 4322 | 68 |
2037382 | 2037382 | 2021-12-21 | Page | Virginia | 51139 | 3948 | 90 |
2037383 | 2037383 | 2021-12-21 | Patrick | Virginia | 51141 | 2450 | 63 |
2037384 | 2037384 | 2021-12-21 | Petersburg city | Virginia | 51730 | 5318 | 107 |
2037385 | 2037385 | 2021-12-21 | Pittsylvania | Virginia | 51143 | 8855 | 135 |
2037386 | 2037386 | 2021-12-21 | Poquoson city | Virginia | 51735 | 1440 | 23 |
2037387 | 2037387 | 2021-12-21 | Portsmouth city | Virginia | 51740 | 13433 | 254 |
2037388 | 2037388 | 2021-12-21 | Powhatan | Virginia | 51145 | 3187 | 31 |
2037389 | 2037389 | 2021-12-21 | Prince Edward | Virginia | 51147 | 3109 | 54 |
2037390 | 2037390 | 2021-12-21 | Prince George | Virginia | 51149 | 5486 | 52 |
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);