ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where "date" is on date 2021-01-21 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
952570 | 952570 | 2021-01-21 | Accomack | Virginia | 51001 | 2198 | 31 |
952571 | 952571 | 2021-01-21 | Albemarle | Virginia | 51003 | 3638 | 35 |
952572 | 952572 | 2021-01-21 | Alexandria city | Virginia | 51510 | 8917 | 97 |
952573 | 952573 | 2021-01-21 | Alleghany | Virginia | 51005 | 1035 | 29 |
952574 | 952574 | 2021-01-21 | Amelia | Virginia | 51007 | 566 | 8 |
952575 | 952575 | 2021-01-21 | Amherst | Virginia | 51009 | 2127 | 10 |
952576 | 952576 | 2021-01-21 | Appomattox | Virginia | 51011 | 1114 | 7 |
952577 | 952577 | 2021-01-21 | Arlington | Virginia | 51013 | 10954 | 195 |
952578 | 952578 | 2021-01-21 | Augusta | Virginia | 51015 | 4476 | 43 |
952579 | 952579 | 2021-01-21 | Bath | Virginia | 51017 | 236 | 0 |
952580 | 952580 | 2021-01-21 | Bedford | Virginia | 51019 | 4626 | 34 |
952581 | 952581 | 2021-01-21 | Bland | Virginia | 51021 | 587 | 7 |
952582 | 952582 | 2021-01-21 | Botetourt | Virginia | 51023 | 1716 | 19 |
952583 | 952583 | 2021-01-21 | Bristol city | Virginia | 51520 | 1138 | 22 |
952584 | 952584 | 2021-01-21 | Brunswick | Virginia | 51025 | 997 | 8 |
952585 | 952585 | 2021-01-21 | Buchanan | Virginia | 51027 | 1011 | 26 |
952586 | 952586 | 2021-01-21 | Buckingham | Virginia | 51029 | 1670 | 15 |
952587 | 952587 | 2021-01-21 | Buena Vista city | Virginia | 51530 | 663 | 9 |
952588 | 952588 | 2021-01-21 | Campbell | Virginia | 51031 | 3200 | 28 |
952589 | 952589 | 2021-01-21 | Caroline | Virginia | 51033 | 1403 | 12 |
952590 | 952590 | 2021-01-21 | Carroll | Virginia | 51035 | 1881 | 55 |
952591 | 952591 | 2021-01-21 | Charles City | Virginia | 51036 | 313 | 9 |
952592 | 952592 | 2021-01-21 | Charlotte | Virginia | 51037 | 547 | 10 |
952593 | 952593 | 2021-01-21 | Charlottesville city | Virginia | 51540 | 2621 | 37 |
952594 | 952594 | 2021-01-21 | Chesapeake city | Virginia | 51550 | 13771 | 117 |
952595 | 952595 | 2021-01-21 | Chesterfield | Virginia | 51041 | 17254 | 194 |
952596 | 952596 | 2021-01-21 | Clarke | Virginia | 51043 | 561 | 8 |
952597 | 952597 | 2021-01-21 | Colonial Heights city | Virginia | 51570 | 913 | 30 |
952598 | 952598 | 2021-01-21 | Covington city | Virginia | 51580 | 540 | 4 |
952599 | 952599 | 2021-01-21 | Craig | Virginia | 51045 | 194 | 3 |
952600 | 952600 | 2021-01-21 | Culpeper | Virginia | 51047 | 3546 | 32 |
952601 | 952601 | 2021-01-21 | Cumberland | Virginia | 51049 | 284 | 4 |
952602 | 952602 | 2021-01-21 | Danville city | Virginia | 51590 | 3209 | 63 |
952603 | 952603 | 2021-01-21 | Dickenson | Virginia | 51051 | 795 | 13 |
952604 | 952604 | 2021-01-21 | Dinwiddie | Virginia | 51053 | 1296 | 18 |
952605 | 952605 | 2021-01-21 | Emporia city | Virginia | 51595 | 532 | 31 |
952606 | 952606 | 2021-01-21 | Essex | Virginia | 51057 | 494 | 3 |
952607 | 952607 | 2021-01-21 | Fairfax | Virginia | 51059 | 55595 | 742 |
952608 | 952608 | 2021-01-21 | Fairfax city | Virginia | 51600 | 380 | 10 |
952609 | 952609 | 2021-01-21 | Falls Church city | Virginia | 51610 | 247 | 6 |
952610 | 952610 | 2021-01-21 | Fauquier | Virginia | 51061 | 3178 | 30 |
952611 | 952611 | 2021-01-21 | Floyd | Virginia | 51063 | 648 | 18 |
952612 | 952612 | 2021-01-21 | Fluvanna | Virginia | 51065 | 1030 | 11 |
952613 | 952613 | 2021-01-21 | Franklin | Virginia | 51067 | 3079 | 29 |
952614 | 952614 | 2021-01-21 | Franklin city | Virginia | 51620 | 781 | 20 |
952615 | 952615 | 2021-01-21 | Frederick | Virginia | 51069 | 5077 | 39 |
952616 | 952616 | 2021-01-21 | Fredericksburg city | Virginia | 51630 | 1351 | 14 |
952617 | 952617 | 2021-01-21 | Galax city | Virginia | 51640 | 945 | 38 |
952618 | 952618 | 2021-01-21 | Giles | Virginia | 51071 | 871 | 6 |
952619 | 952619 | 2021-01-21 | Gloucester | Virginia | 51073 | 1305 | 19 |
952620 | 952620 | 2021-01-21 | Goochland | Virginia | 51075 | 917 | 7 |
952621 | 952621 | 2021-01-21 | Grayson | Virginia | 51077 | 990 | 26 |
952622 | 952622 | 2021-01-21 | Greene | Virginia | 51079 | 752 | 4 |
952623 | 952623 | 2021-01-21 | Greensville | Virginia | 51081 | 1153 | 17 |
952624 | 952624 | 2021-01-21 | Halifax | Virginia | 51083 | 1794 | 47 |
952625 | 952625 | 2021-01-21 | Hampton city | Virginia | 51650 | 6368 | 57 |
952626 | 952626 | 2021-01-21 | Hanover | Virginia | 51085 | 5299 | 91 |
952627 | 952627 | 2021-01-21 | Harrisonburg city | Virginia | 51660 | 5104 | 57 |
952628 | 952628 | 2021-01-21 | Henrico | Virginia | 51087 | 16705 | 326 |
952629 | 952629 | 2021-01-21 | Henry | Virginia | 51089 | 3458 | 65 |
952630 | 952630 | 2021-01-21 | Highland | Virginia | 51091 | 71 | 0 |
952631 | 952631 | 2021-01-21 | Hopewell city | Virginia | 51670 | 1420 | 12 |
952632 | 952632 | 2021-01-21 | Isle of Wight | Virginia | 51093 | 1963 | 35 |
952633 | 952633 | 2021-01-21 | James City | Virginia | 51095 | 2960 | 36 |
952634 | 952634 | 2021-01-21 | King George | Virginia | 51099 | 1028 | 11 |
952635 | 952635 | 2021-01-21 | King William | Virginia | 51101 | 640 | 5 |
952636 | 952636 | 2021-01-21 | King and Queen | Virginia | 51097 | 228 | 3 |
952637 | 952637 | 2021-01-21 | Lancaster | Virginia | 51103 | 492 | 3 |
952638 | 952638 | 2021-01-21 | Lee | Virginia | 51105 | 1978 | 33 |
952639 | 952639 | 2021-01-21 | Lexington city | Virginia | 51678 | 760 | 15 |
952640 | 952640 | 2021-01-21 | Loudoun | Virginia | 51107 | 17571 | 171 |
952641 | 952641 | 2021-01-21 | Louisa | Virginia | 51109 | 1329 | 11 |
952642 | 952642 | 2021-01-21 | Lunenburg | Virginia | 51111 | 519 | 3 |
952643 | 952643 | 2021-01-21 | Lynchburg city | Virginia | 51680 | 5606 | 66 |
952644 | 952644 | 2021-01-21 | Madison | Virginia | 51113 | 413 | 5 |
952645 | 952645 | 2021-01-21 | Manassas Park city | Virginia | 51685 | 1045 | 8 |
952646 | 952646 | 2021-01-21 | Manassas city | Virginia | 51683 | 3475 | 30 |
952647 | 952647 | 2021-01-21 | Martinsville city | Virginia | 51690 | 1273 | 29 |
952648 | 952648 | 2021-01-21 | Mathews | Virginia | 51115 | 395 | 6 |
952649 | 952649 | 2021-01-21 | Mecklenburg | Virginia | 51117 | 1602 | 43 |
952650 | 952650 | 2021-01-21 | Middlesex | Virginia | 51119 | 369 | 15 |
952651 | 952651 | 2021-01-21 | Montgomery | Virginia | 51121 | 5977 | 54 |
952652 | 952652 | 2021-01-21 | Nelson | Virginia | 51125 | 554 | 5 |
952653 | 952653 | 2021-01-21 | New Kent | Virginia | 51127 | 946 | 7 |
952654 | 952654 | 2021-01-21 | Newport News city | Virginia | 51700 | 8412 | 79 |
952655 | 952655 | 2021-01-21 | Norfolk city | Virginia | 51710 | 11615 | 127 |
952656 | 952656 | 2021-01-21 | Northampton | Virginia | 51131 | 580 | 32 |
952657 | 952657 | 2021-01-21 | Northumberland | Virginia | 51133 | 535 | 12 |
952658 | 952658 | 2021-01-21 | Norton city | Virginia | 51720 | 225 | 3 |
952659 | 952659 | 2021-01-21 | Nottoway | Virginia | 51135 | 1555 | 25 |
952660 | 952660 | 2021-01-21 | Orange | Virginia | 51137 | 1379 | 16 |
952661 | 952661 | 2021-01-21 | Page | Virginia | 51139 | 1426 | 38 |
952662 | 952662 | 2021-01-21 | Patrick | Virginia | 51141 | 962 | 28 |
952663 | 952663 | 2021-01-21 | Petersburg city | Virginia | 51730 | 2211 | 36 |
952664 | 952664 | 2021-01-21 | Pittsylvania | Virginia | 51143 | 3735 | 42 |
952665 | 952665 | 2021-01-21 | Poquoson city | Virginia | 51735 | 505 | 7 |
952666 | 952666 | 2021-01-21 | Portsmouth city | Virginia | 51740 | 5996 | 96 |
952667 | 952667 | 2021-01-21 | Powhatan | Virginia | 51145 | 1175 | 7 |
952668 | 952668 | 2021-01-21 | Prince Edward | Virginia | 51147 | 1481 | 19 |
952669 | 952669 | 2021-01-21 | Prince George | Virginia | 51149 | 2253 | 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);