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-02-17 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 |
---|---|---|---|---|---|---|---|
1040200 | 1040200 | 2021-02-17 | Accomack | Virginia | 51001 | 2529 | 34 |
1040201 | 1040201 | 2021-02-17 | Albemarle | Virginia | 51003 | 4319 | 39 |
1040202 | 1040202 | 2021-02-17 | Alexandria city | Virginia | 51510 | 10056 | 104 |
1040203 | 1040203 | 2021-02-17 | Alleghany | Virginia | 51005 | 1152 | 39 |
1040204 | 1040204 | 2021-02-17 | Amelia | Virginia | 51007 | 740 | 12 |
1040205 | 1040205 | 2021-02-17 | Amherst | Virginia | 51009 | 2619 | 13 |
1040206 | 1040206 | 2021-02-17 | Appomattox | Virginia | 51011 | 1369 | 9 |
1040207 | 1040207 | 2021-02-17 | Arlington | Virginia | 51013 | 12684 | 210 |
1040208 | 1040208 | 2021-02-17 | Augusta | Virginia | 51015 | 5085 | 53 |
1040209 | 1040209 | 2021-02-17 | Bath | Virginia | 51017 | 244 | 8 |
1040210 | 1040210 | 2021-02-17 | Bedford | Virginia | 51019 | 5656 | 45 |
1040211 | 1040211 | 2021-02-17 | Bland | Virginia | 51021 | 616 | 9 |
1040212 | 1040212 | 2021-02-17 | Botetourt | Virginia | 51023 | 2036 | 21 |
1040213 | 1040213 | 2021-02-17 | Bristol city | Virginia | 51520 | 1210 | 27 |
1040214 | 1040214 | 2021-02-17 | Brunswick | Virginia | 51025 | 1162 | 11 |
1040215 | 1040215 | 2021-02-17 | Buchanan | Virginia | 51027 | 1267 | 32 |
1040216 | 1040216 | 2021-02-17 | Buckingham | Virginia | 51029 | 2016 | 20 |
1040217 | 1040217 | 2021-02-17 | Buena Vista city | Virginia | 51530 | 815 | 12 |
1040218 | 1040218 | 2021-02-17 | Campbell | Virginia | 51031 | 3889 | 33 |
1040219 | 1040219 | 2021-02-17 | Caroline | Virginia | 51033 | 1766 | 14 |
1040220 | 1040220 | 2021-02-17 | Carroll | Virginia | 51035 | 2054 | 58 |
1040221 | 1040221 | 2021-02-17 | Charles City | Virginia | 51036 | 385 | 10 |
1040222 | 1040222 | 2021-02-17 | Charlotte | Virginia | 51037 | 718 | 11 |
1040223 | 1040223 | 2021-02-17 | Charlottesville city | Virginia | 51540 | 3168 | 40 |
1040224 | 1040224 | 2021-02-17 | Chesapeake city | Virginia | 51550 | 17425 | 147 |
1040225 | 1040225 | 2021-02-17 | Chesterfield | Virginia | 51041 | 22643 | 217 |
1040226 | 1040226 | 2021-02-17 | Clarke | Virginia | 51043 | 738 | 12 |
1040227 | 1040227 | 2021-02-17 | Colonial Heights city | Virginia | 51570 | 1264 | 34 |
1040228 | 1040228 | 2021-02-17 | Covington city | Virginia | 51580 | 626 | 5 |
1040229 | 1040229 | 2021-02-17 | Craig | Virginia | 51045 | 230 | 3 |
1040230 | 1040230 | 2021-02-17 | Culpeper | Virginia | 51047 | 3987 | 39 |
1040231 | 1040231 | 2021-02-17 | Cumberland | Virginia | 51049 | 364 | 4 |
1040232 | 1040232 | 2021-02-17 | Danville city | Virginia | 51590 | 4142 | 92 |
1040233 | 1040233 | 2021-02-17 | Dickenson | Virginia | 51051 | 856 | 14 |
1040234 | 1040234 | 2021-02-17 | Dinwiddie | Virginia | 51053 | 1706 | 20 |
1040235 | 1040235 | 2021-02-17 | Emporia city | Virginia | 51595 | 610 | 35 |
1040236 | 1040236 | 2021-02-17 | Essex | Virginia | 51057 | 613 | 4 |
1040237 | 1040237 | 2021-02-17 | Fairfax | Virginia | 51059 | 64355 | 834 |
1040238 | 1040238 | 2021-02-17 | Fairfax city | Virginia | 51600 | 468 | 12 |
1040239 | 1040239 | 2021-02-17 | Falls Church city | Virginia | 51610 | 331 | 7 |
1040240 | 1040240 | 2021-02-17 | Fauquier | Virginia | 51061 | 3821 | 37 |
1040241 | 1040241 | 2021-02-17 | Floyd | Virginia | 51063 | 716 | 18 |
1040242 | 1040242 | 2021-02-17 | Fluvanna | Virginia | 51065 | 1247 | 13 |
1040243 | 1040243 | 2021-02-17 | Franklin | Virginia | 51067 | 3630 | 42 |
1040244 | 1040244 | 2021-02-17 | Franklin city | Virginia | 51620 | 937 | 23 |
1040245 | 1040245 | 2021-02-17 | Frederick | Virginia | 51069 | 6585 | 48 |
1040246 | 1040246 | 2021-02-17 | Fredericksburg city | Virginia | 51630 | 1718 | 14 |
1040247 | 1040247 | 2021-02-17 | Galax city | Virginia | 51640 | 981 | 43 |
1040248 | 1040248 | 2021-02-17 | Giles | Virginia | 51071 | 1026 | 9 |
1040249 | 1040249 | 2021-02-17 | Gloucester | Virginia | 51073 | 1781 | 29 |
1040250 | 1040250 | 2021-02-17 | Goochland | Virginia | 51075 | 1178 | 8 |
1040251 | 1040251 | 2021-02-17 | Grayson | Virginia | 51077 | 1097 | 28 |
1040252 | 1040252 | 2021-02-17 | Greene | Virginia | 51079 | 949 | 5 |
1040253 | 1040253 | 2021-02-17 | Greensville | Virginia | 51081 | 1426 | 18 |
1040254 | 1040254 | 2021-02-17 | Halifax | Virginia | 51083 | 2295 | 56 |
1040255 | 1040255 | 2021-02-17 | Hampton city | Virginia | 51650 | 8233 | 88 |
1040256 | 1040256 | 2021-02-17 | Hanover | Virginia | 51085 | 6411 | 105 |
1040257 | 1040257 | 2021-02-17 | Harrisonburg city | Virginia | 51660 | 5591 | 68 |
1040258 | 1040258 | 2021-02-17 | Henrico | Virginia | 51087 | 20599 | 358 |
1040259 | 1040259 | 2021-02-17 | Henry | Virginia | 51089 | 4085 | 83 |
1040260 | 1040260 | 2021-02-17 | Highland | Virginia | 51091 | 87 | 0 |
1040261 | 1040261 | 2021-02-17 | Hopewell city | Virginia | 51670 | 1985 | 23 |
1040262 | 1040262 | 2021-02-17 | Isle of Wight | Virginia | 51093 | 2498 | 42 |
1040263 | 1040263 | 2021-02-17 | James City | Virginia | 51095 | 3735 | 42 |
1040264 | 1040264 | 2021-02-17 | King George | Virginia | 51099 | 1378 | 12 |
1040265 | 1040265 | 2021-02-17 | King William | Virginia | 51101 | 829 | 6 |
1040266 | 1040266 | 2021-02-17 | King and Queen | Virginia | 51097 | 293 | 4 |
1040267 | 1040267 | 2021-02-17 | Lancaster | Virginia | 51103 | 630 | 4 |
1040268 | 1040268 | 2021-02-17 | Lee | Virginia | 51105 | 2250 | 38 |
1040269 | 1040269 | 2021-02-17 | Lexington city | Virginia | 51678 | 1034 | 18 |
1040270 | 1040270 | 2021-02-17 | Loudoun | Virginia | 51107 | 22351 | 195 |
1040271 | 1040271 | 2021-02-17 | Louisa | Virginia | 51109 | 1638 | 13 |
1040272 | 1040272 | 2021-02-17 | Lunenburg | Virginia | 51111 | 611 | 4 |
1040273 | 1040273 | 2021-02-17 | Lynchburg city | Virginia | 51680 | 6787 | 89 |
1040274 | 1040274 | 2021-02-17 | Madison | Virginia | 51113 | 528 | 7 |
1040275 | 1040275 | 2021-02-17 | Manassas Park city | Virginia | 51685 | 1110 | 8 |
1040276 | 1040276 | 2021-02-17 | Manassas city | Virginia | 51683 | 3930 | 33 |
1040277 | 1040277 | 2021-02-17 | Martinsville city | Virginia | 51690 | 1473 | 44 |
1040278 | 1040278 | 2021-02-17 | Mathews | Virginia | 51115 | 504 | 7 |
1040279 | 1040279 | 2021-02-17 | Mecklenburg | Virginia | 51117 | 1925 | 46 |
1040280 | 1040280 | 2021-02-17 | Middlesex | Virginia | 51119 | 473 | 16 |
1040281 | 1040281 | 2021-02-17 | Montgomery | Virginia | 51121 | 7035 | 71 |
1040282 | 1040282 | 2021-02-17 | Nelson | Virginia | 51125 | 741 | 7 |
1040283 | 1040283 | 2021-02-17 | New Kent | Virginia | 51127 | 1189 | 7 |
1040284 | 1040284 | 2021-02-17 | Newport News city | Virginia | 51700 | 10900 | 117 |
1040285 | 1040285 | 2021-02-17 | Norfolk city | Virginia | 51710 | 14233 | 153 |
1040286 | 1040286 | 2021-02-17 | Northampton | Virginia | 51131 | 681 | 32 |
1040287 | 1040287 | 2021-02-17 | Northumberland | Virginia | 51133 | 636 | 13 |
1040288 | 1040288 | 2021-02-17 | Norton city | Virginia | 51720 | 235 | 4 |
1040289 | 1040289 | 2021-02-17 | Nottoway | Virginia | 51135 | 1763 | 29 |
1040290 | 1040290 | 2021-02-17 | Orange | Virginia | 51137 | 1772 | 19 |
1040291 | 1040291 | 2021-02-17 | Page | Virginia | 51139 | 1778 | 41 |
1040292 | 1040292 | 2021-02-17 | Patrick | Virginia | 51141 | 1162 | 32 |
1040293 | 1040293 | 2021-02-17 | Petersburg city | Virginia | 51730 | 2912 | 39 |
1040294 | 1040294 | 2021-02-17 | Pittsylvania | Virginia | 51143 | 4605 | 56 |
1040295 | 1040295 | 2021-02-17 | Poquoson city | Virginia | 51735 | 682 | 10 |
1040296 | 1040296 | 2021-02-17 | Portsmouth city | Virginia | 51740 | 7353 | 123 |
1040297 | 1040297 | 2021-02-17 | Powhatan | Virginia | 51145 | 1596 | 7 |
1040298 | 1040298 | 2021-02-17 | Prince Edward | Virginia | 51147 | 1899 | 21 |
1040299 | 1040299 | 2021-02-17 | Prince George | Virginia | 51149 | 2838 | 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);