ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1043445 | 1043445 | 2021-02-18 | Accomack | Virginia | 51001 | 2538 | 35 |
1043446 | 1043446 | 2021-02-18 | Albemarle | Virginia | 51003 | 4454 | 39 |
1043447 | 1043447 | 2021-02-18 | Alexandria city | Virginia | 51510 | 10092 | 104 |
1043448 | 1043448 | 2021-02-18 | Alleghany | Virginia | 51005 | 1151 | 39 |
1043449 | 1043449 | 2021-02-18 | Amelia | Virginia | 51007 | 742 | 12 |
1043450 | 1043450 | 2021-02-18 | Amherst | Virginia | 51009 | 2629 | 13 |
1043451 | 1043451 | 2021-02-18 | Appomattox | Virginia | 51011 | 1372 | 9 |
1043452 | 1043452 | 2021-02-18 | Arlington | Virginia | 51013 | 12726 | 211 |
1043453 | 1043453 | 2021-02-18 | Augusta | Virginia | 51015 | 5102 | 53 |
1043454 | 1043454 | 2021-02-18 | Bath | Virginia | 51017 | 241 | 8 |
1043455 | 1043455 | 2021-02-18 | Bedford | Virginia | 51019 | 5675 | 45 |
1043456 | 1043456 | 2021-02-18 | Bland | Virginia | 51021 | 616 | 9 |
1043457 | 1043457 | 2021-02-18 | Botetourt | Virginia | 51023 | 2059 | 21 |
1043458 | 1043458 | 2021-02-18 | Bristol city | Virginia | 51520 | 1211 | 27 |
1043459 | 1043459 | 2021-02-18 | Brunswick | Virginia | 51025 | 1166 | 11 |
1043460 | 1043460 | 2021-02-18 | Buchanan | Virginia | 51027 | 1282 | 32 |
1043461 | 1043461 | 2021-02-18 | Buckingham | Virginia | 51029 | 2020 | 20 |
1043462 | 1043462 | 2021-02-18 | Buena Vista city | Virginia | 51530 | 817 | 12 |
1043463 | 1043463 | 2021-02-18 | Campbell | Virginia | 51031 | 3903 | 33 |
1043464 | 1043464 | 2021-02-18 | Caroline | Virginia | 51033 | 1771 | 14 |
1043465 | 1043465 | 2021-02-18 | Carroll | Virginia | 51035 | 2062 | 58 |
1043466 | 1043466 | 2021-02-18 | Charles City | Virginia | 51036 | 387 | 10 |
1043467 | 1043467 | 2021-02-18 | Charlotte | Virginia | 51037 | 720 | 11 |
1043468 | 1043468 | 2021-02-18 | Charlottesville city | Virginia | 51540 | 3267 | 40 |
1043469 | 1043469 | 2021-02-18 | Chesapeake city | Virginia | 51550 | 17539 | 147 |
1043470 | 1043470 | 2021-02-18 | Chesterfield | Virginia | 51041 | 22708 | 216 |
1043471 | 1043471 | 2021-02-18 | Clarke | Virginia | 51043 | 741 | 13 |
1043472 | 1043472 | 2021-02-18 | Colonial Heights city | Virginia | 51570 | 1267 | 34 |
1043473 | 1043473 | 2021-02-18 | Covington city | Virginia | 51580 | 630 | 5 |
1043474 | 1043474 | 2021-02-18 | Craig | Virginia | 51045 | 231 | 3 |
1043475 | 1043475 | 2021-02-18 | Culpeper | Virginia | 51047 | 3995 | 39 |
1043476 | 1043476 | 2021-02-18 | Cumberland | Virginia | 51049 | 367 | 4 |
1043477 | 1043477 | 2021-02-18 | Danville city | Virginia | 51590 | 4155 | 92 |
1043478 | 1043478 | 2021-02-18 | Dickenson | Virginia | 51051 | 858 | 14 |
1043479 | 1043479 | 2021-02-18 | Dinwiddie | Virginia | 51053 | 1717 | 20 |
1043480 | 1043480 | 2021-02-18 | Emporia city | Virginia | 51595 | 611 | 35 |
1043481 | 1043481 | 2021-02-18 | Essex | Virginia | 51057 | 615 | 4 |
1043482 | 1043482 | 2021-02-18 | Fairfax | Virginia | 51059 | 64568 | 834 |
1043483 | 1043483 | 2021-02-18 | Fairfax city | Virginia | 51600 | 473 | 12 |
1043484 | 1043484 | 2021-02-18 | Falls Church city | Virginia | 51610 | 333 | 7 |
1043485 | 1043485 | 2021-02-18 | Fauquier | Virginia | 51061 | 3824 | 37 |
1043486 | 1043486 | 2021-02-18 | Floyd | Virginia | 51063 | 719 | 18 |
1043487 | 1043487 | 2021-02-18 | Fluvanna | Virginia | 51065 | 1254 | 13 |
1043488 | 1043488 | 2021-02-18 | Franklin | Virginia | 51067 | 3641 | 42 |
1043489 | 1043489 | 2021-02-18 | Franklin city | Virginia | 51620 | 948 | 25 |
1043490 | 1043490 | 2021-02-18 | Frederick | Virginia | 51069 | 6605 | 49 |
1043491 | 1043491 | 2021-02-18 | Fredericksburg city | Virginia | 51630 | 1717 | 14 |
1043492 | 1043492 | 2021-02-18 | Galax city | Virginia | 51640 | 980 | 43 |
1043493 | 1043493 | 2021-02-18 | Giles | Virginia | 51071 | 1029 | 9 |
1043494 | 1043494 | 2021-02-18 | Gloucester | Virginia | 51073 | 1795 | 29 |
1043495 | 1043495 | 2021-02-18 | Goochland | Virginia | 51075 | 1187 | 8 |
1043496 | 1043496 | 2021-02-18 | Grayson | Virginia | 51077 | 1100 | 28 |
1043497 | 1043497 | 2021-02-18 | Greene | Virginia | 51079 | 958 | 5 |
1043498 | 1043498 | 2021-02-18 | Greensville | Virginia | 51081 | 1427 | 18 |
1043499 | 1043499 | 2021-02-18 | Halifax | Virginia | 51083 | 2309 | 56 |
1043500 | 1043500 | 2021-02-18 | Hampton city | Virginia | 51650 | 8275 | 88 |
1043501 | 1043501 | 2021-02-18 | Hanover | Virginia | 51085 | 6434 | 105 |
1043502 | 1043502 | 2021-02-18 | Harrisonburg city | Virginia | 51660 | 5603 | 68 |
1043503 | 1043503 | 2021-02-18 | Henrico | Virginia | 51087 | 20699 | 358 |
1043504 | 1043504 | 2021-02-18 | Henry | Virginia | 51089 | 4095 | 83 |
1043505 | 1043505 | 2021-02-18 | Highland | Virginia | 51091 | 87 | 0 |
1043506 | 1043506 | 2021-02-18 | Hopewell city | Virginia | 51670 | 2002 | 23 |
1043507 | 1043507 | 2021-02-18 | Isle of Wight | Virginia | 51093 | 2520 | 43 |
1043508 | 1043508 | 2021-02-18 | James City | Virginia | 51095 | 3744 | 45 |
1043509 | 1043509 | 2021-02-18 | King George | Virginia | 51099 | 1381 | 12 |
1043510 | 1043510 | 2021-02-18 | King William | Virginia | 51101 | 836 | 6 |
1043511 | 1043511 | 2021-02-18 | King and Queen | Virginia | 51097 | 296 | 4 |
1043512 | 1043512 | 2021-02-18 | Lancaster | Virginia | 51103 | 634 | 4 |
1043513 | 1043513 | 2021-02-18 | Lee | Virginia | 51105 | 2251 | 38 |
1043514 | 1043514 | 2021-02-18 | Lexington city | Virginia | 51678 | 1046 | 19 |
1043515 | 1043515 | 2021-02-18 | Loudoun | Virginia | 51107 | 22405 | 195 |
1043516 | 1043516 | 2021-02-18 | Louisa | Virginia | 51109 | 1641 | 13 |
1043517 | 1043517 | 2021-02-18 | Lunenburg | Virginia | 51111 | 613 | 4 |
1043518 | 1043518 | 2021-02-18 | Lynchburg city | Virginia | 51680 | 6819 | 90 |
1043519 | 1043519 | 2021-02-18 | Madison | Virginia | 51113 | 527 | 7 |
1043520 | 1043520 | 2021-02-18 | Manassas Park city | Virginia | 51685 | 1112 | 8 |
1043521 | 1043521 | 2021-02-18 | Manassas city | Virginia | 51683 | 3935 | 33 |
1043522 | 1043522 | 2021-02-18 | Martinsville city | Virginia | 51690 | 1474 | 44 |
1043523 | 1043523 | 2021-02-18 | Mathews | Virginia | 51115 | 510 | 7 |
1043524 | 1043524 | 2021-02-18 | Mecklenburg | Virginia | 51117 | 1936 | 46 |
1043525 | 1043525 | 2021-02-18 | Middlesex | Virginia | 51119 | 479 | 16 |
1043526 | 1043526 | 2021-02-18 | Montgomery | Virginia | 51121 | 7126 | 71 |
1043527 | 1043527 | 2021-02-18 | Nelson | Virginia | 51125 | 743 | 7 |
1043528 | 1043528 | 2021-02-18 | New Kent | Virginia | 51127 | 1197 | 7 |
1043529 | 1043529 | 2021-02-18 | Newport News city | Virginia | 51700 | 10931 | 116 |
1043530 | 1043530 | 2021-02-18 | Norfolk city | Virginia | 51710 | 14311 | 153 |
1043531 | 1043531 | 2021-02-18 | Northampton | Virginia | 51131 | 689 | 32 |
1043532 | 1043532 | 2021-02-18 | Northumberland | Virginia | 51133 | 637 | 13 |
1043533 | 1043533 | 2021-02-18 | Norton city | Virginia | 51720 | 235 | 4 |
1043534 | 1043534 | 2021-02-18 | Nottoway | Virginia | 51135 | 1767 | 29 |
1043535 | 1043535 | 2021-02-18 | Orange | Virginia | 51137 | 1779 | 19 |
1043536 | 1043536 | 2021-02-18 | Page | Virginia | 51139 | 1786 | 41 |
1043537 | 1043537 | 2021-02-18 | Patrick | Virginia | 51141 | 1163 | 32 |
1043538 | 1043538 | 2021-02-18 | Petersburg city | Virginia | 51730 | 2932 | 39 |
1043539 | 1043539 | 2021-02-18 | Pittsylvania | Virginia | 51143 | 4618 | 56 |
1043540 | 1043540 | 2021-02-18 | Poquoson city | Virginia | 51735 | 685 | 10 |
1043541 | 1043541 | 2021-02-18 | Portsmouth city | Virginia | 51740 | 7404 | 125 |
1043542 | 1043542 | 2021-02-18 | Powhatan | Virginia | 51145 | 1604 | 7 |
1043543 | 1043543 | 2021-02-18 | Prince Edward | Virginia | 51147 | 1907 | 21 |
1043544 | 1043544 | 2021-02-18 | Prince George | Virginia | 51149 | 2842 | 10 |
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);