ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-01-31" 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 |
---|---|---|---|---|---|---|---|
985023 | 985023 | 2021-01-31 | Accomack | Virginia | 51001 | 2342 | 31 |
985024 | 985024 | 2021-01-31 | Albemarle | Virginia | 51003 | 3924 | 35 |
985025 | 985025 | 2021-01-31 | Alexandria city | Virginia | 51510 | 9435 | 104 |
985026 | 985026 | 2021-01-31 | Alleghany | Virginia | 51005 | 1122 | 31 |
985027 | 985027 | 2021-01-31 | Amelia | Virginia | 51007 | 640 | 10 |
985028 | 985028 | 2021-01-31 | Amherst | Virginia | 51009 | 2380 | 11 |
985029 | 985029 | 2021-01-31 | Appomattox | Virginia | 51011 | 1241 | 8 |
985030 | 985030 | 2021-01-31 | Arlington | Virginia | 51013 | 11691 | 201 |
985031 | 985031 | 2021-01-31 | Augusta | Virginia | 51015 | 4754 | 48 |
985032 | 985032 | 2021-01-31 | Bath | Virginia | 51017 | 240 | 8 |
985033 | 985033 | 2021-01-31 | Bedford | Virginia | 51019 | 5171 | 39 |
985034 | 985034 | 2021-01-31 | Bland | Virginia | 51021 | 603 | 9 |
985035 | 985035 | 2021-01-31 | Botetourt | Virginia | 51023 | 1866 | 21 |
985036 | 985036 | 2021-01-31 | Bristol city | Virginia | 51520 | 1182 | 24 |
985037 | 985037 | 2021-01-31 | Brunswick | Virginia | 51025 | 1089 | 9 |
985038 | 985038 | 2021-01-31 | Buchanan | Virginia | 51027 | 1162 | 32 |
985039 | 985039 | 2021-01-31 | Buckingham | Virginia | 51029 | 1856 | 17 |
985040 | 985040 | 2021-01-31 | Buena Vista city | Virginia | 51530 | 748 | 12 |
985041 | 985041 | 2021-01-31 | Campbell | Virginia | 51031 | 3522 | 31 |
985042 | 985042 | 2021-01-31 | Caroline | Virginia | 51033 | 1576 | 13 |
985043 | 985043 | 2021-01-31 | Carroll | Virginia | 51035 | 1978 | 56 |
985044 | 985044 | 2021-01-31 | Charles City | Virginia | 51036 | 342 | 9 |
985045 | 985045 | 2021-01-31 | Charlotte | Virginia | 51037 | 625 | 10 |
985046 | 985046 | 2021-01-31 | Charlottesville city | Virginia | 51540 | 2740 | 39 |
985047 | 985047 | 2021-01-31 | Chesapeake city | Virginia | 51550 | 15436 | 136 |
985048 | 985048 | 2021-01-31 | Chesterfield | Virginia | 51041 | 19150 | 203 |
985049 | 985049 | 2021-01-31 | Clarke | Virginia | 51043 | 674 | 8 |
985050 | 985050 | 2021-01-31 | Colonial Heights city | Virginia | 51570 | 1043 | 31 |
985051 | 985051 | 2021-01-31 | Covington city | Virginia | 51580 | 565 | 4 |
985052 | 985052 | 2021-01-31 | Craig | Virginia | 51045 | 215 | 3 |
985053 | 985053 | 2021-01-31 | Culpeper | Virginia | 51047 | 3743 | 34 |
985054 | 985054 | 2021-01-31 | Cumberland | Virginia | 51049 | 325 | 4 |
985055 | 985055 | 2021-01-31 | Danville city | Virginia | 51590 | 3655 | 66 |
985056 | 985056 | 2021-01-31 | Dickenson | Virginia | 51051 | 819 | 14 |
985057 | 985057 | 2021-01-31 | Dinwiddie | Virginia | 51053 | 1482 | 18 |
985058 | 985058 | 2021-01-31 | Emporia city | Virginia | 51595 | 559 | 32 |
985059 | 985059 | 2021-01-31 | Essex | Virginia | 51057 | 533 | 4 |
985060 | 985060 | 2021-01-31 | Fairfax | Virginia | 51059 | 59481 | 784 |
985061 | 985061 | 2021-01-31 | Fairfax city | Virginia | 51600 | 427 | 12 |
985062 | 985062 | 2021-01-31 | Falls Church city | Virginia | 51610 | 291 | 6 |
985063 | 985063 | 2021-01-31 | Fauquier | Virginia | 51061 | 3476 | 33 |
985064 | 985064 | 2021-01-31 | Floyd | Virginia | 51063 | 679 | 18 |
985065 | 985065 | 2021-01-31 | Fluvanna | Virginia | 51065 | 1150 | 13 |
985066 | 985066 | 2021-01-31 | Franklin | Virginia | 51067 | 3348 | 34 |
985067 | 985067 | 2021-01-31 | Franklin city | Virginia | 51620 | 859 | 21 |
985068 | 985068 | 2021-01-31 | Frederick | Virginia | 51069 | 6000 | 45 |
985069 | 985069 | 2021-01-31 | Fredericksburg city | Virginia | 51630 | 1522 | 14 |
985070 | 985070 | 2021-01-31 | Galax city | Virginia | 51640 | 955 | 39 |
985071 | 985071 | 2021-01-31 | Giles | Virginia | 51071 | 928 | 7 |
985072 | 985072 | 2021-01-31 | Gloucester | Virginia | 51073 | 1501 | 27 |
985073 | 985073 | 2021-01-31 | Goochland | Virginia | 51075 | 1035 | 8 |
985074 | 985074 | 2021-01-31 | Grayson | Virginia | 51077 | 1037 | 26 |
985075 | 985075 | 2021-01-31 | Greene | Virginia | 51079 | 848 | 5 |
985076 | 985076 | 2021-01-31 | Greensville | Virginia | 51081 | 1312 | 18 |
985077 | 985077 | 2021-01-31 | Halifax | Virginia | 51083 | 2005 | 52 |
985078 | 985078 | 2021-01-31 | Hampton city | Virginia | 51650 | 7174 | 66 |
985079 | 985079 | 2021-01-31 | Hanover | Virginia | 51085 | 5843 | 101 |
985080 | 985080 | 2021-01-31 | Harrisonburg city | Virginia | 51660 | 5305 | 61 |
985081 | 985081 | 2021-01-31 | Henrico | Virginia | 51087 | 18463 | 344 |
985082 | 985082 | 2021-01-31 | Henry | Virginia | 51089 | 3747 | 74 |
985083 | 985083 | 2021-01-31 | Highland | Virginia | 51091 | 81 | 0 |
985084 | 985084 | 2021-01-31 | Hopewell city | Virginia | 51670 | 1745 | 17 |
985085 | 985085 | 2021-01-31 | Isle of Wight | Virginia | 51093 | 2179 | 38 |
985086 | 985086 | 2021-01-31 | James City | Virginia | 51095 | 3454 | 39 |
985087 | 985087 | 2021-01-31 | King George | Virginia | 51099 | 1225 | 11 |
985088 | 985088 | 2021-01-31 | King William | Virginia | 51101 | 718 | 5 |
985089 | 985089 | 2021-01-31 | King and Queen | Virginia | 51097 | 251 | 3 |
985090 | 985090 | 2021-01-31 | Lancaster | Virginia | 51103 | 563 | 3 |
985091 | 985091 | 2021-01-31 | Lee | Virginia | 51105 | 2146 | 37 |
985092 | 985092 | 2021-01-31 | Lexington city | Virginia | 51678 | 809 | 18 |
985093 | 985093 | 2021-01-31 | Loudoun | Virginia | 51107 | 20384 | 181 |
985094 | 985094 | 2021-01-31 | Louisa | Virginia | 51109 | 1502 | 12 |
985095 | 985095 | 2021-01-31 | Lunenburg | Virginia | 51111 | 566 | 4 |
985096 | 985096 | 2021-01-31 | Lynchburg city | Virginia | 51680 | 6173 | 71 |
985097 | 985097 | 2021-01-31 | Madison | Virginia | 51113 | 473 | 6 |
985098 | 985098 | 2021-01-31 | Manassas Park city | Virginia | 51685 | 1070 | 8 |
985099 | 985099 | 2021-01-31 | Manassas city | Virginia | 51683 | 3696 | 33 |
985100 | 985100 | 2021-01-31 | Martinsville city | Virginia | 51690 | 1374 | 36 |
985101 | 985101 | 2021-01-31 | Mathews | Virginia | 51115 | 441 | 6 |
985102 | 985102 | 2021-01-31 | Mecklenburg | Virginia | 51117 | 1787 | 46 |
985103 | 985103 | 2021-01-31 | Middlesex | Virginia | 51119 | 410 | 16 |
985104 | 985104 | 2021-01-31 | Montgomery | Virginia | 51121 | 6323 | 64 |
985105 | 985105 | 2021-01-31 | Nelson | Virginia | 51125 | 640 | 6 |
985106 | 985106 | 2021-01-31 | New Kent | Virginia | 51127 | 1053 | 7 |
985107 | 985107 | 2021-01-31 | Newport News city | Virginia | 51700 | 9772 | 97 |
985108 | 985108 | 2021-01-31 | Norfolk city | Virginia | 51710 | 12850 | 142 |
985109 | 985109 | 2021-01-31 | Northampton | Virginia | 51131 | 632 | 33 |
985110 | 985110 | 2021-01-31 | Northumberland | Virginia | 51133 | 582 | 13 |
985111 | 985111 | 2021-01-31 | Norton city | Virginia | 51720 | 233 | 2 |
985112 | 985112 | 2021-01-31 | Nottoway | Virginia | 51135 | 1649 | 27 |
985113 | 985113 | 2021-01-31 | Orange | Virginia | 51137 | 1516 | 18 |
985114 | 985114 | 2021-01-31 | Page | Virginia | 51139 | 1655 | 40 |
985115 | 985115 | 2021-01-31 | Patrick | Virginia | 51141 | 1063 | 29 |
985116 | 985116 | 2021-01-31 | Petersburg city | Virginia | 51730 | 2634 | 37 |
985117 | 985117 | 2021-01-31 | Pittsylvania | Virginia | 51143 | 4132 | 46 |
985118 | 985118 | 2021-01-31 | Poquoson city | Virginia | 51735 | 599 | 8 |
985119 | 985119 | 2021-01-31 | Portsmouth city | Virginia | 51740 | 6547 | 97 |
985120 | 985120 | 2021-01-31 | Powhatan | Virginia | 51145 | 1330 | 7 |
985121 | 985121 | 2021-01-31 | Prince Edward | Virginia | 51147 | 1709 | 20 |
985122 | 985122 | 2021-01-31 | Prince George | Virginia | 51149 | 2544 | 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);