ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-02-22" 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 |
---|---|---|---|---|---|---|---|
1056430 | 1056430 | 2021-02-22 | Accomack | Virginia | 51001 | 2565 | 35 |
1056431 | 1056431 | 2021-02-22 | Albemarle | Virginia | 51003 | 4641 | 43 |
1056432 | 1056432 | 2021-02-22 | Alexandria city | Virginia | 51510 | 10186 | 107 |
1056433 | 1056433 | 2021-02-22 | Alleghany | Virginia | 51005 | 1145 | 39 |
1056434 | 1056434 | 2021-02-22 | Amelia | Virginia | 51007 | 746 | 13 |
1056435 | 1056435 | 2021-02-22 | Amherst | Virginia | 51009 | 2642 | 17 |
1056436 | 1056436 | 2021-02-22 | Appomattox | Virginia | 51011 | 1385 | 10 |
1056437 | 1056437 | 2021-02-22 | Arlington | Virginia | 51013 | 12894 | 214 |
1056438 | 1056438 | 2021-02-22 | Augusta | Virginia | 51015 | 5130 | 54 |
1056439 | 1056439 | 2021-02-22 | Bath | Virginia | 51017 | 240 | 9 |
1056440 | 1056440 | 2021-02-22 | Bedford | Virginia | 51019 | 5704 | 49 |
1056441 | 1056441 | 2021-02-22 | Bland | Virginia | 51021 | 620 | 9 |
1056442 | 1056442 | 2021-02-22 | Botetourt | Virginia | 51023 | 2155 | 23 |
1056443 | 1056443 | 2021-02-22 | Bristol city | Virginia | 51520 | 1210 | 27 |
1056444 | 1056444 | 2021-02-22 | Brunswick | Virginia | 51025 | 1181 | 12 |
1056445 | 1056445 | 2021-02-22 | Buchanan | Virginia | 51027 | 1288 | 32 |
1056446 | 1056446 | 2021-02-22 | Buckingham | Virginia | 51029 | 2028 | 21 |
1056447 | 1056447 | 2021-02-22 | Buena Vista city | Virginia | 51530 | 827 | 12 |
1056448 | 1056448 | 2021-02-22 | Campbell | Virginia | 51031 | 3939 | 38 |
1056449 | 1056449 | 2021-02-22 | Caroline | Virginia | 51033 | 1786 | 14 |
1056450 | 1056450 | 2021-02-22 | Carroll | Virginia | 51035 | 2069 | 58 |
1056451 | 1056451 | 2021-02-22 | Charles City | Virginia | 51036 | 392 | 10 |
1056452 | 1056452 | 2021-02-22 | Charlotte | Virginia | 51037 | 731 | 10 |
1056453 | 1056453 | 2021-02-22 | Charlottesville city | Virginia | 51540 | 3519 | 40 |
1056454 | 1056454 | 2021-02-22 | Chesapeake city | Virginia | 51550 | 17819 | 156 |
1056455 | 1056455 | 2021-02-22 | Chesterfield | Virginia | 51041 | 23077 | 246 |
1056456 | 1056456 | 2021-02-22 | Clarke | Virginia | 51043 | 749 | 14 |
1056457 | 1056457 | 2021-02-22 | Colonial Heights city | Virginia | 51570 | 1303 | 39 |
1056458 | 1056458 | 2021-02-22 | Covington city | Virginia | 51580 | 630 | 7 |
1056459 | 1056459 | 2021-02-22 | Craig | Virginia | 51045 | 236 | 4 |
1056460 | 1056460 | 2021-02-22 | Culpeper | Virginia | 51047 | 4021 | 46 |
1056461 | 1056461 | 2021-02-22 | Cumberland | Virginia | 51049 | 371 | 4 |
1056462 | 1056462 | 2021-02-22 | Danville city | Virginia | 51590 | 4233 | 98 |
1056463 | 1056463 | 2021-02-22 | Dickenson | Virginia | 51051 | 868 | 14 |
1056464 | 1056464 | 2021-02-22 | Dinwiddie | Virginia | 51053 | 1750 | 22 |
1056465 | 1056465 | 2021-02-22 | Emporia city | Virginia | 51595 | 614 | 37 |
1056466 | 1056466 | 2021-02-22 | Essex | Virginia | 51057 | 621 | 5 |
1056467 | 1056467 | 2021-02-22 | Fairfax | Virginia | 51059 | 65317 | 859 |
1056468 | 1056468 | 2021-02-22 | Fairfax city | Virginia | 51600 | 479 | 13 |
1056469 | 1056469 | 2021-02-22 | Falls Church city | Virginia | 51610 | 341 | 7 |
1056470 | 1056470 | 2021-02-22 | Fauquier | Virginia | 51061 | 3879 | 45 |
1056471 | 1056471 | 2021-02-22 | Floyd | Virginia | 51063 | 724 | 18 |
1056472 | 1056472 | 2021-02-22 | Fluvanna | Virginia | 51065 | 1281 | 13 |
1056473 | 1056473 | 2021-02-22 | Franklin | Virginia | 51067 | 3656 | 44 |
1056474 | 1056474 | 2021-02-22 | Franklin city | Virginia | 51620 | 962 | 26 |
1056475 | 1056475 | 2021-02-22 | Frederick | Virginia | 51069 | 6673 | 55 |
1056476 | 1056476 | 2021-02-22 | Fredericksburg city | Virginia | 51630 | 1724 | 14 |
1056477 | 1056477 | 2021-02-22 | Galax city | Virginia | 51640 | 985 | 44 |
1056478 | 1056478 | 2021-02-22 | Giles | Virginia | 51071 | 1044 | 10 |
1056479 | 1056479 | 2021-02-22 | Gloucester | Virginia | 51073 | 1816 | 30 |
1056480 | 1056480 | 2021-02-22 | Goochland | Virginia | 51075 | 1196 | 8 |
1056481 | 1056481 | 2021-02-22 | Grayson | Virginia | 51077 | 1111 | 29 |
1056482 | 1056482 | 2021-02-22 | Greene | Virginia | 51079 | 978 | 5 |
1056483 | 1056483 | 2021-02-22 | Greensville | Virginia | 51081 | 1444 | 22 |
1056484 | 1056484 | 2021-02-22 | Halifax | Virginia | 51083 | 2358 | 57 |
1056485 | 1056485 | 2021-02-22 | Hampton city | Virginia | 51650 | 8427 | 97 |
1056486 | 1056486 | 2021-02-22 | Hanover | Virginia | 51085 | 6522 | 114 |
1056487 | 1056487 | 2021-02-22 | Harrisonburg city | Virginia | 51660 | 5642 | 68 |
1056488 | 1056488 | 2021-02-22 | Henrico | Virginia | 51087 | 20950 | 390 |
1056489 | 1056489 | 2021-02-22 | Henry | Virginia | 51089 | 4118 | 88 |
1056490 | 1056490 | 2021-02-22 | Highland | Virginia | 51091 | 90 | 0 |
1056491 | 1056491 | 2021-02-22 | Hopewell city | Virginia | 51670 | 2052 | 27 |
1056492 | 1056492 | 2021-02-22 | Isle of Wight | Virginia | 51093 | 2584 | 46 |
1056493 | 1056493 | 2021-02-22 | James City | Virginia | 51095 | 3806 | 45 |
1056494 | 1056494 | 2021-02-22 | King George | Virginia | 51099 | 1394 | 12 |
1056495 | 1056495 | 2021-02-22 | King William | Virginia | 51101 | 864 | 7 |
1056496 | 1056496 | 2021-02-22 | King and Queen | Virginia | 51097 | 298 | 6 |
1056497 | 1056497 | 2021-02-22 | Lancaster | Virginia | 51103 | 643 | 6 |
1056498 | 1056498 | 2021-02-22 | Lee | Virginia | 51105 | 2259 | 38 |
1056499 | 1056499 | 2021-02-22 | Lexington city | Virginia | 51678 | 1083 | 19 |
1056500 | 1056500 | 2021-02-22 | Loudoun | Virginia | 51107 | 22704 | 203 |
1056501 | 1056501 | 2021-02-22 | Louisa | Virginia | 51109 | 1666 | 13 |
1056502 | 1056502 | 2021-02-22 | Lunenburg | Virginia | 51111 | 626 | 4 |
1056503 | 1056503 | 2021-02-22 | Lynchburg city | Virginia | 51680 | 6859 | 96 |
1056504 | 1056504 | 2021-02-22 | Madison | Virginia | 51113 | 527 | 8 |
1056505 | 1056505 | 2021-02-22 | Manassas Park city | Virginia | 51685 | 1113 | 8 |
1056506 | 1056506 | 2021-02-22 | Manassas city | Virginia | 51683 | 3962 | 35 |
1056507 | 1056507 | 2021-02-22 | Martinsville city | Virginia | 51690 | 1485 | 46 |
1056508 | 1056508 | 2021-02-22 | Mathews | Virginia | 51115 | 535 | 8 |
1056509 | 1056509 | 2021-02-22 | Mecklenburg | Virginia | 51117 | 1941 | 50 |
1056510 | 1056510 | 2021-02-22 | Middlesex | Virginia | 51119 | 494 | 16 |
1056511 | 1056511 | 2021-02-22 | Montgomery | Virginia | 51121 | 7343 | 72 |
1056512 | 1056512 | 2021-02-22 | Nelson | Virginia | 51125 | 748 | 7 |
1056513 | 1056513 | 2021-02-22 | New Kent | Virginia | 51127 | 1220 | 7 |
1056514 | 1056514 | 2021-02-22 | Newport News city | Virginia | 51700 | 11160 | 135 |
1056515 | 1056515 | 2021-02-22 | Norfolk city | Virginia | 51710 | 14564 | 164 |
1056516 | 1056516 | 2021-02-22 | Northampton | Virginia | 51131 | 704 | 32 |
1056517 | 1056517 | 2021-02-22 | Northumberland | Virginia | 51133 | 654 | 13 |
1056518 | 1056518 | 2021-02-22 | Norton city | Virginia | 51720 | 236 | 5 |
1056519 | 1056519 | 2021-02-22 | Nottoway | Virginia | 51135 | 1780 | 31 |
1056520 | 1056520 | 2021-02-22 | Orange | Virginia | 51137 | 1789 | 21 |
1056521 | 1056521 | 2021-02-22 | Page | Virginia | 51139 | 1809 | 42 |
1056522 | 1056522 | 2021-02-22 | Patrick | Virginia | 51141 | 1172 | 34 |
1056523 | 1056523 | 2021-02-22 | Petersburg city | Virginia | 51730 | 3038 | 41 |
1056524 | 1056524 | 2021-02-22 | Pittsylvania | Virginia | 51143 | 4678 | 58 |
1056525 | 1056525 | 2021-02-22 | Poquoson city | Virginia | 51735 | 699 | 12 |
1056526 | 1056526 | 2021-02-22 | Portsmouth city | Virginia | 51740 | 7523 | 130 |
1056527 | 1056527 | 2021-02-22 | Powhatan | Virginia | 51145 | 1625 | 7 |
1056528 | 1056528 | 2021-02-22 | Prince Edward | Virginia | 51147 | 1922 | 22 |
1056529 | 1056529 | 2021-02-22 | Prince George | Virginia | 51149 | 2897 | 11 |
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);