ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103,128 rows where state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 51059 422
- 51810 420
- 51107 419
- 51013 418
- 51085 417
- 51095 417
- 51147 417
- 51153 417
- 51510 417
- 51660 416
- 51041 415
- 51177 415
- 51179 413
- 51199 413
- 51075 412
- 51087 412
- 51540 412
- 51830 412
- 51036 411
- 51760 411
- 51001 409
- 51073 409
- 51700 409
- 51710 409
- 51740 409
- 51003 408
- 51023 408
- 51067 408
- 51093 408
- 51117 408
- …
county >30
- Fairfax 422
- Virginia Beach city 420
- Loudoun 419
- Arlington 418
- Alexandria city 417
- Hanover 417
- James City 417
- Prince Edward 417
- Prince William 417
- Harrisonburg city 416
- Chesterfield 415
- Spotsylvania 415
- Stafford 413
- York 413
- Charlottesville city 412
- Goochland 412
- Henrico 412
- Williamsburg city 412
- Charles City 411
- Richmond city 411
- Accomack 409
- Gloucester 409
- Newport News city 409
- Norfolk city 409
- Portsmouth city 409
- Albemarle 408
- Botetourt 408
- Franklin 408
- Isle of Wight 408
- Mecklenburg 408
- …
state 1
- Virginia · 53,112 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280469 | 1280469 | 2021-05-02 | Accomack | Virginia | 51001 | 2812 | 41 |
1280470 | 1280470 | 2021-05-02 | Albemarle | Virginia | 51003 | 5708 | 83 |
1280471 | 1280471 | 2021-05-02 | Alexandria city | Virginia | 51510 | 11671 | 133 |
1280472 | 1280472 | 2021-05-02 | Alleghany | Virginia | 51005 | 1326 | 48 |
1280473 | 1280473 | 2021-05-02 | Amelia | Virginia | 51007 | 881 | 31 |
1280474 | 1280474 | 2021-05-02 | Amherst | Virginia | 51009 | 2907 | 35 |
1280475 | 1280475 | 2021-05-02 | Appomattox | Virginia | 51011 | 1583 | 24 |
1280476 | 1280476 | 2021-05-02 | Arlington | Virginia | 51013 | 15121 | 252 |
1280477 | 1280477 | 2021-05-02 | Augusta | Virginia | 51015 | 5726 | 70 |
1280478 | 1280478 | 2021-05-02 | Bath | Virginia | 51017 | 270 | 10 |
1280479 | 1280479 | 2021-05-02 | Bedford | Virginia | 51019 | 6275 | 99 |
1280480 | 1280480 | 2021-05-02 | Bland | Virginia | 51021 | 669 | 10 |
1280481 | 1280481 | 2021-05-02 | Botetourt | Virginia | 51023 | 2504 | 36 |
1280482 | 1280482 | 2021-05-02 | Bristol city | Virginia | 51520 | 1465 | 33 |
1280483 | 1280483 | 2021-05-02 | Brunswick | Virginia | 51025 | 1298 | 21 |
1280484 | 1280484 | 2021-05-02 | Buchanan | Virginia | 51027 | 1410 | 38 |
1280485 | 1280485 | 2021-05-02 | Buckingham | Virginia | 51029 | 2119 | 30 |
1280486 | 1280486 | 2021-05-02 | Buena Vista city | Virginia | 51530 | 897 | 19 |
1280487 | 1280487 | 2021-05-02 | Campbell | Virginia | 51031 | 4407 | 84 |
1280488 | 1280488 | 2021-05-02 | Caroline | Virginia | 51033 | 2555 | 35 |
1280489 | 1280489 | 2021-05-02 | Carroll | Virginia | 51035 | 2603 | 69 |
1280490 | 1280490 | 2021-05-02 | Charles City | Virginia | 51036 | 498 | 15 |
1280491 | 1280491 | 2021-05-02 | Charlotte | Virginia | 51037 | 843 | 18 |
1280492 | 1280492 | 2021-05-02 | Charlottesville city | Virginia | 51540 | 4017 | 55 |
1280493 | 1280493 | 2021-05-02 | Chesapeake city | Virginia | 51550 | 20674 | 289 |
1280494 | 1280494 | 2021-05-02 | Chesterfield | Virginia | 51041 | 27290 | 423 |
1280495 | 1280495 | 2021-05-02 | Clarke | Virginia | 51043 | 967 | 19 |
1280496 | 1280496 | 2021-05-02 | Colonial Heights city | Virginia | 51570 | 1682 | 61 |
1280497 | 1280497 | 2021-05-02 | Covington city | Virginia | 51580 | 591 | 13 |
1280498 | 1280498 | 2021-05-02 | Craig | Virginia | 51045 | 309 | 5 |
1280499 | 1280499 | 2021-05-02 | Culpeper | Virginia | 51047 | 4550 | 61 |
1280500 | 1280500 | 2021-05-02 | Cumberland | Virginia | 51049 | 473 | 9 |
1280501 | 1280501 | 2021-05-02 | Danville city | Virginia | 51590 | 4348 | 134 |
1280502 | 1280502 | 2021-05-02 | Dickenson | Virginia | 51051 | 921 | 15 |
1280503 | 1280503 | 2021-05-02 | Dinwiddie | Virginia | 51053 | 2099 | 42 |
1280504 | 1280504 | 2021-05-02 | Emporia city | Virginia | 51595 | 669 | 42 |
1280505 | 1280505 | 2021-05-02 | Essex | Virginia | 51057 | 753 | 9 |
1280506 | 1280506 | 2021-05-02 | Fairfax | Virginia | 51059 | 75942 | 1073 |
1280507 | 1280507 | 2021-05-02 | Fairfax city | Virginia | 51600 | 550 | 19 |
1280508 | 1280508 | 2021-05-02 | Falls Church city | Virginia | 51610 | 423 | 9 |
1280509 | 1280509 | 2021-05-02 | Fauquier | Virginia | 51061 | 4631 | 64 |
1280510 | 1280510 | 2021-05-02 | Floyd | Virginia | 51063 | 845 | 21 |
1280511 | 1280511 | 2021-05-02 | Fluvanna | Virginia | 51065 | 1904 | 17 |
1280512 | 1280512 | 2021-05-02 | Franklin | Virginia | 51067 | 3997 | 74 |
1280513 | 1280513 | 2021-05-02 | Franklin city | Virginia | 51620 | 1132 | 32 |
1280514 | 1280514 | 2021-05-02 | Frederick | Virginia | 51069 | 7847 | 100 |
1280515 | 1280515 | 2021-05-02 | Fredericksburg city | Virginia | 51630 | 2093 | 23 |
1280516 | 1280516 | 2021-05-02 | Galax city | Virginia | 51640 | 1154 | 51 |
1280517 | 1280517 | 2021-05-02 | Giles | Virginia | 51071 | 1257 | 21 |
1280518 | 1280518 | 2021-05-02 | Gloucester | Virginia | 51073 | 2180 | 48 |
1280519 | 1280519 | 2021-05-02 | Goochland | Virginia | 51075 | 1434 | 23 |
1280520 | 1280520 | 2021-05-02 | Grayson | Virginia | 51077 | 1444 | 34 |
1280521 | 1280521 | 2021-05-02 | Greene | Virginia | 51079 | 1243 | 17 |
1280522 | 1280522 | 2021-05-02 | Greensville | Virginia | 51081 | 1568 | 25 |
1280523 | 1280523 | 2021-05-02 | Halifax | Virginia | 51083 | 2782 | 77 |
1280524 | 1280524 | 2021-05-02 | Hampton city | Virginia | 51650 | 10275 | 172 |
1280525 | 1280525 | 2021-05-02 | Hanover | Virginia | 51085 | 8000 | 154 |
1280526 | 1280526 | 2021-05-02 | Harrisonburg city | Virginia | 51660 | 6458 | 95 |
1280527 | 1280527 | 2021-05-02 | Henrico | Virginia | 51087 | 25038 | 602 |
1280528 | 1280528 | 2021-05-02 | Henry | Virginia | 51089 | 4498 | 121 |
1280529 | 1280529 | 2021-05-02 | Highland | Virginia | 51091 | 108 | 1 |
1280530 | 1280530 | 2021-05-02 | Hopewell city | Virginia | 51670 | 2559 | 71 |
1280531 | 1280531 | 2021-05-02 | Isle of Wight | Virginia | 51093 | 3114 | 66 |
1280532 | 1280532 | 2021-05-02 | James City | Virginia | 51095 | 4556 | 72 |
1280533 | 1280533 | 2021-05-02 | King George | Virginia | 51099 | 1662 | 19 |
1280534 | 1280534 | 2021-05-02 | King William | Virginia | 51101 | 1197 | 11 |
1280535 | 1280535 | 2021-05-02 | King and Queen | Virginia | 51097 | 388 | 8 |
1280536 | 1280536 | 2021-05-02 | Lancaster | Virginia | 51103 | 710 | 16 |
1280537 | 1280537 | 2021-05-02 | Lee | Virginia | 51105 | 2413 | 46 |
1280538 | 1280538 | 2021-05-02 | Lexington city | Virginia | 51678 | 1171 | 32 |
1280539 | 1280539 | 2021-05-02 | Loudoun | Virginia | 51107 | 27391 | 274 |
1280540 | 1280540 | 2021-05-02 | Louisa | Virginia | 51109 | 1954 | 32 |
1280541 | 1280541 | 2021-05-02 | Lunenburg | Virginia | 51111 | 761 | 13 |
1280542 | 1280542 | 2021-05-02 | Lynchburg city | Virginia | 51680 | 7625 | 146 |
1280543 | 1280543 | 2021-05-02 | Madison | Virginia | 51113 | 608 | 16 |
1280544 | 1280544 | 2021-05-02 | Manassas Park city | Virginia | 51685 | 1214 | 12 |
1280545 | 1280545 | 2021-05-02 | Manassas city | Virginia | 51683 | 4301 | 47 |
1280546 | 1280546 | 2021-05-02 | Martinsville city | Virginia | 51690 | 1583 | 76 |
1280547 | 1280547 | 2021-05-02 | Mathews | Virginia | 51115 | 595 | 12 |
1280548 | 1280548 | 2021-05-02 | Mecklenburg | Virginia | 51117 | 2270 | 66 |
1280549 | 1280549 | 2021-05-02 | Middlesex | Virginia | 51119 | 569 | 20 |
1280550 | 1280550 | 2021-05-02 | Montgomery | Virginia | 51121 | 9292 | 91 |
1280551 | 1280551 | 2021-05-02 | Nelson | Virginia | 51125 | 887 | 12 |
1280552 | 1280552 | 2021-05-02 | New Kent | Virginia | 51127 | 1480 | 16 |
1280553 | 1280553 | 2021-05-02 | Newport News city | Virginia | 51700 | 13794 | 224 |
1280554 | 1280554 | 2021-05-02 | Norfolk city | Virginia | 51710 | 17401 | 254 |
1280555 | 1280555 | 2021-05-02 | Northampton | Virginia | 51131 | 797 | 36 |
1280556 | 1280556 | 2021-05-02 | Northumberland | Virginia | 51133 | 741 | 20 |
1280557 | 1280557 | 2021-05-02 | Norton city | Virginia | 51720 | 281 | 7 |
1280558 | 1280558 | 2021-05-02 | Nottoway | Virginia | 51135 | 1900 | 48 |
1280559 | 1280559 | 2021-05-02 | Orange | Virginia | 51137 | 2165 | 39 |
1280560 | 1280560 | 2021-05-02 | Page | Virginia | 51139 | 2011 | 57 |
1280561 | 1280561 | 2021-05-02 | Patrick | Virginia | 51141 | 1339 | 43 |
1280562 | 1280562 | 2021-05-02 | Petersburg city | Virginia | 51730 | 3812 | 84 |
1280563 | 1280563 | 2021-05-02 | Pittsylvania | Virginia | 51143 | 5493 | 78 |
1280564 | 1280564 | 2021-05-02 | Poquoson city | Virginia | 51735 | 871 | 16 |
1280565 | 1280565 | 2021-05-02 | Portsmouth city | Virginia | 51740 | 8926 | 188 |
1280566 | 1280566 | 2021-05-02 | Powhatan | Virginia | 51145 | 1891 | 16 |
1280567 | 1280567 | 2021-05-02 | Prince Edward | Virginia | 51147 | 2125 | 34 |
1280568 | 1280568 | 2021-05-02 | Prince George | Virginia | 51149 | 3489 | 27 |
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);