ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-05-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 |
---|---|---|---|---|---|---|---|
1358388 | 1358388 | 2021-05-26 | Accomack | Virginia | 51001 | 2853 | 42 |
1358389 | 1358389 | 2021-05-26 | Albemarle | Virginia | 51003 | 5787 | 83 |
1358390 | 1358390 | 2021-05-26 | Alexandria city | Virginia | 51510 | 11831 | 137 |
1358391 | 1358391 | 2021-05-26 | Alleghany | Virginia | 51005 | 1359 | 49 |
1358392 | 1358392 | 2021-05-26 | Amelia | Virginia | 51007 | 916 | 33 |
1358393 | 1358393 | 2021-05-26 | Amherst | Virginia | 51009 | 2947 | 37 |
1358394 | 1358394 | 2021-05-26 | Appomattox | Virginia | 51011 | 1611 | 25 |
1358395 | 1358395 | 2021-05-26 | Arlington | Virginia | 51013 | 15284 | 256 |
1358396 | 1358396 | 2021-05-26 | Augusta | Virginia | 51015 | 5874 | 73 |
1358397 | 1358397 | 2021-05-26 | Bath | Virginia | 51017 | 272 | 10 |
1358398 | 1358398 | 2021-05-26 | Bedford | Virginia | 51019 | 6478 | 103 |
1358399 | 1358399 | 2021-05-26 | Bland | Virginia | 51021 | 680 | 10 |
1358400 | 1358400 | 2021-05-26 | Botetourt | Virginia | 51023 | 2551 | 38 |
1358401 | 1358401 | 2021-05-26 | Bristol city | Virginia | 51520 | 1556 | 34 |
1358402 | 1358402 | 2021-05-26 | Brunswick | Virginia | 51025 | 1325 | 23 |
1358403 | 1358403 | 2021-05-26 | Buchanan | Virginia | 51027 | 1460 | 43 |
1358404 | 1358404 | 2021-05-26 | Buckingham | Virginia | 51029 | 2135 | 30 |
1358405 | 1358405 | 2021-05-26 | Buena Vista city | Virginia | 51530 | 914 | 22 |
1358406 | 1358406 | 2021-05-26 | Campbell | Virginia | 51031 | 4533 | 89 |
1358407 | 1358407 | 2021-05-26 | Caroline | Virginia | 51033 | 2632 | 38 |
1358408 | 1358408 | 2021-05-26 | Carroll | Virginia | 51035 | 2682 | 76 |
1358409 | 1358409 | 2021-05-26 | Charles City | Virginia | 51036 | 501 | 16 |
1358410 | 1358410 | 2021-05-26 | Charlotte | Virginia | 51037 | 873 | 21 |
1358411 | 1358411 | 2021-05-26 | Charlottesville city | Virginia | 51540 | 4011 | 57 |
1358412 | 1358412 | 2021-05-26 | Chesapeake city | Virginia | 51550 | 21054 | 298 |
1358413 | 1358413 | 2021-05-26 | Chesterfield | Virginia | 51041 | 27977 | 439 |
1358414 | 1358414 | 2021-05-26 | Clarke | Virginia | 51043 | 985 | 20 |
1358415 | 1358415 | 2021-05-26 | Colonial Heights city | Virginia | 51570 | 1713 | 61 |
1358416 | 1358416 | 2021-05-26 | Covington city | Virginia | 51580 | 604 | 13 |
1358417 | 1358417 | 2021-05-26 | Craig | Virginia | 51045 | 319 | 6 |
1358418 | 1358418 | 2021-05-26 | Culpeper | Virginia | 51047 | 4685 | 64 |
1358419 | 1358419 | 2021-05-26 | Cumberland | Virginia | 51049 | 498 | 9 |
1358420 | 1358420 | 2021-05-26 | Danville city | Virginia | 51590 | 4447 | 138 |
1358421 | 1358421 | 2021-05-26 | Dickenson | Virginia | 51051 | 946 | 16 |
1358422 | 1358422 | 2021-05-26 | Dinwiddie | Virginia | 51053 | 2136 | 45 |
1358423 | 1358423 | 2021-05-26 | Emporia city | Virginia | 51595 | 671 | 42 |
1358424 | 1358424 | 2021-05-26 | Essex | Virginia | 51057 | 778 | 10 |
1358425 | 1358425 | 2021-05-26 | Fairfax | Virginia | 51059 | 76877 | 1092 |
1358426 | 1358426 | 2021-05-26 | Fairfax city | Virginia | 51600 | 560 | 19 |
1358427 | 1358427 | 2021-05-26 | Falls Church city | Virginia | 51610 | 433 | 9 |
1358428 | 1358428 | 2021-05-26 | Fauquier | Virginia | 51061 | 4711 | 70 |
1358429 | 1358429 | 2021-05-26 | Floyd | Virginia | 51063 | 874 | 23 |
1358430 | 1358430 | 2021-05-26 | Fluvanna | Virginia | 51065 | 1920 | 19 |
1358431 | 1358431 | 2021-05-26 | Franklin | Virginia | 51067 | 4074 | 78 |
1358432 | 1358432 | 2021-05-26 | Franklin city | Virginia | 51620 | 1133 | 32 |
1358433 | 1358433 | 2021-05-26 | Frederick | Virginia | 51069 | 8041 | 102 |
1358434 | 1358434 | 2021-05-26 | Fredericksburg city | Virginia | 51630 | 2133 | 24 |
1358435 | 1358435 | 2021-05-26 | Galax city | Virginia | 51640 | 1169 | 53 |
1358436 | 1358436 | 2021-05-26 | Giles | Virginia | 51071 | 1292 | 22 |
1358437 | 1358437 | 2021-05-26 | Gloucester | Virginia | 51073 | 2248 | 49 |
1358438 | 1358438 | 2021-05-26 | Goochland | Virginia | 51075 | 1457 | 23 |
1358439 | 1358439 | 2021-05-26 | Grayson | Virginia | 51077 | 1489 | 35 |
1358440 | 1358440 | 2021-05-26 | Greene | Virginia | 51079 | 1281 | 18 |
1358441 | 1358441 | 2021-05-26 | Greensville | Virginia | 51081 | 1582 | 25 |
1358442 | 1358442 | 2021-05-26 | Halifax | Virginia | 51083 | 2820 | 78 |
1358443 | 1358443 | 2021-05-26 | Hampton city | Virginia | 51650 | 10588 | 178 |
1358444 | 1358444 | 2021-05-26 | Hanover | Virginia | 51085 | 8171 | 162 |
1358445 | 1358445 | 2021-05-26 | Harrisonburg city | Virginia | 51660 | 6495 | 94 |
1358446 | 1358446 | 2021-05-26 | Henrico | Virginia | 51087 | 25494 | 619 |
1358447 | 1358447 | 2021-05-26 | Henry | Virginia | 51089 | 4637 | 124 |
1358448 | 1358448 | 2021-05-26 | Highland | Virginia | 51091 | 109 | 1 |
1358449 | 1358449 | 2021-05-26 | Hopewell city | Virginia | 51670 | 2613 | 75 |
1358450 | 1358450 | 2021-05-26 | Isle of Wight | Virginia | 51093 | 3158 | 69 |
1358451 | 1358451 | 2021-05-26 | James City | Virginia | 51095 | 4632 | 72 |
1358452 | 1358452 | 2021-05-26 | King George | Virginia | 51099 | 1729 | 20 |
1358453 | 1358453 | 2021-05-26 | King William | Virginia | 51101 | 1241 | 13 |
1358454 | 1358454 | 2021-05-26 | King and Queen | Virginia | 51097 | 403 | 8 |
1358455 | 1358455 | 2021-05-26 | Lancaster | Virginia | 51103 | 716 | 16 |
1358456 | 1358456 | 2021-05-26 | Lee | Virginia | 51105 | 2431 | 48 |
1358457 | 1358457 | 2021-05-26 | Lexington city | Virginia | 51678 | 1207 | 32 |
1358458 | 1358458 | 2021-05-26 | Loudoun | Virginia | 51107 | 27889 | 278 |
1358459 | 1358459 | 2021-05-26 | Louisa | Virginia | 51109 | 1987 | 32 |
1358460 | 1358460 | 2021-05-26 | Lunenburg | Virginia | 51111 | 778 | 14 |
1358461 | 1358461 | 2021-05-26 | Lynchburg city | Virginia | 51680 | 7881 | 154 |
1358462 | 1358462 | 2021-05-26 | Madison | Virginia | 51113 | 600 | 16 |
1358463 | 1358463 | 2021-05-26 | Manassas Park city | Virginia | 51685 | 1217 | 11 |
1358464 | 1358464 | 2021-05-26 | Manassas city | Virginia | 51683 | 4307 | 47 |
1358465 | 1358465 | 2021-05-26 | Martinsville city | Virginia | 51690 | 1614 | 76 |
1358466 | 1358466 | 2021-05-26 | Mathews | Virginia | 51115 | 601 | 12 |
1358467 | 1358467 | 2021-05-26 | Mecklenburg | Virginia | 51117 | 2326 | 67 |
1358468 | 1358468 | 2021-05-26 | Middlesex | Virginia | 51119 | 576 | 20 |
1358469 | 1358469 | 2021-05-26 | Montgomery | Virginia | 51121 | 9399 | 97 |
1358470 | 1358470 | 2021-05-26 | Nelson | Virginia | 51125 | 898 | 13 |
1358471 | 1358471 | 2021-05-26 | New Kent | Virginia | 51127 | 1506 | 18 |
1358472 | 1358472 | 2021-05-26 | Newport News city | Virginia | 51700 | 14169 | 228 |
1358473 | 1358473 | 2021-05-26 | Norfolk city | Virginia | 51710 | 17835 | 261 |
1358474 | 1358474 | 2021-05-26 | Northampton | Virginia | 51131 | 808 | 36 |
1358475 | 1358475 | 2021-05-26 | Northumberland | Virginia | 51133 | 746 | 20 |
1358476 | 1358476 | 2021-05-26 | Norton city | Virginia | 51720 | 290 | 7 |
1358477 | 1358477 | 2021-05-26 | Nottoway | Virginia | 51135 | 1918 | 47 |
1358478 | 1358478 | 2021-05-26 | Orange | Virginia | 51137 | 2224 | 38 |
1358479 | 1358479 | 2021-05-26 | Page | Virginia | 51139 | 2064 | 56 |
1358480 | 1358480 | 2021-05-26 | Patrick | Virginia | 51141 | 1369 | 43 |
1358481 | 1358481 | 2021-05-26 | Petersburg city | Virginia | 51730 | 3900 | 86 |
1358482 | 1358482 | 2021-05-26 | Pittsylvania | Virginia | 51143 | 5566 | 83 |
1358483 | 1358483 | 2021-05-26 | Poquoson city | Virginia | 51735 | 886 | 16 |
1358484 | 1358484 | 2021-05-26 | Portsmouth city | Virginia | 51740 | 9110 | 199 |
1358485 | 1358485 | 2021-05-26 | Powhatan | Virginia | 51145 | 1920 | 17 |
1358486 | 1358486 | 2021-05-26 | Prince Edward | Virginia | 51147 | 2174 | 34 |
1358487 | 1358487 | 2021-05-26 | Prince George | Virginia | 51149 | 3593 | 30 |
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);