ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2020-08-24" 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 |
---|---|---|---|---|---|---|---|
466189 | 466189 | 2020-08-24 | Accomack | Virginia | 51001 | 1135 | 18 |
466190 | 466190 | 2020-08-24 | Albemarle | Virginia | 51003 | 963 | 16 |
466191 | 466191 | 2020-08-24 | Alexandria city | Virginia | 51510 | 3270 | 61 |
466192 | 466192 | 2020-08-24 | Alleghany | Virginia | 51005 | 61 | 4 |
466193 | 466193 | 2020-08-24 | Amelia | Virginia | 51007 | 92 | 2 |
466194 | 466194 | 2020-08-24 | Amherst | Virginia | 51009 | 262 | 1 |
466195 | 466195 | 2020-08-24 | Appomattox | Virginia | 51011 | 136 | 1 |
466196 | 466196 | 2020-08-24 | Arlington | Virginia | 51013 | 3400 | 137 |
466197 | 466197 | 2020-08-24 | Augusta | Virginia | 51015 | 346 | 4 |
466198 | 466198 | 2020-08-24 | Bath | Virginia | 51017 | 4 | 0 |
466199 | 466199 | 2020-08-24 | Bedford | Virginia | 51019 | 487 | 8 |
466200 | 466200 | 2020-08-24 | Bland | Virginia | 51021 | 38 | 0 |
466201 | 466201 | 2020-08-24 | Botetourt | Virginia | 51023 | 230 | 8 |
466202 | 466202 | 2020-08-24 | Bristol city | Virginia | 51520 | 105 | 2 |
466203 | 466203 | 2020-08-24 | Brunswick | Virginia | 51025 | 269 | 2 |
466204 | 466204 | 2020-08-24 | Buchanan | Virginia | 51027 | 93 | 1 |
466205 | 466205 | 2020-08-24 | Buckingham | Virginia | 51029 | 634 | 8 |
466206 | 466206 | 2020-08-24 | Buena Vista city | Virginia | 51530 | 70 | 1 |
466207 | 466207 | 2020-08-24 | Campbell | Virginia | 51031 | 298 | 3 |
466208 | 466208 | 2020-08-24 | Caroline | Virginia | 51033 | 252 | 5 |
466209 | 466209 | 2020-08-24 | Carroll | Virginia | 51035 | 378 | 16 |
466210 | 466210 | 2020-08-24 | Charles City | Virginia | 51036 | 66 | 5 |
466211 | 466211 | 2020-08-24 | Charlotte | Virginia | 51037 | 59 | 0 |
466212 | 466212 | 2020-08-24 | Charlottesville city | Virginia | 51540 | 589 | 16 |
466213 | 466213 | 2020-08-24 | Chesapeake city | Virginia | 51550 | 3564 | 43 |
466214 | 466214 | 2020-08-24 | Chesterfield | Virginia | 51041 | 4867 | 76 |
466215 | 466215 | 2020-08-24 | Clarke | Virginia | 51043 | 76 | 0 |
466216 | 466216 | 2020-08-24 | Colonial Heights city | Virginia | 51570 | 214 | 22 |
466217 | 466217 | 2020-08-24 | Covington city | Virginia | 51580 | 19 | 0 |
466218 | 466218 | 2020-08-24 | Craig | Virginia | 51045 | 22 | 0 |
466219 | 466219 | 2020-08-24 | Culpeper | Virginia | 51047 | 1073 | 13 |
466220 | 466220 | 2020-08-24 | Cumberland | Virginia | 51049 | 92 | 0 |
466221 | 466221 | 2020-08-24 | Danville city | Virginia | 51590 | 544 | 12 |
466222 | 466222 | 2020-08-24 | Dickenson | Virginia | 51051 | 55 | 1 |
466223 | 466223 | 2020-08-24 | Dinwiddie | Virginia | 51053 | 264 | 8 |
466224 | 466224 | 2020-08-24 | Emporia city | Virginia | 51595 | 214 | 15 |
466225 | 466225 | 2020-08-24 | Essex | Virginia | 51057 | 113 | 2 |
466226 | 466226 | 2020-08-24 | Fairfax | Virginia | 51059 | 17729 | 543 |
466227 | 466227 | 2020-08-24 | Fairfax city | Virginia | 51600 | 106 | 7 |
466228 | 466228 | 2020-08-24 | Falls Church city | Virginia | 51610 | 64 | 7 |
466229 | 466229 | 2020-08-24 | Fauquier | Virginia | 51061 | 720 | 9 |
466230 | 466230 | 2020-08-24 | Floyd | Virginia | 51063 | 124 | 2 |
466231 | 466231 | 2020-08-24 | Fluvanna | Virginia | 51065 | 210 | 9 |
466232 | 466232 | 2020-08-24 | Franklin | Virginia | 51067 | 201 | 1 |
466233 | 466233 | 2020-08-24 | Franklin city | Virginia | 51620 | 264 | 6 |
466234 | 466234 | 2020-08-24 | Frederick | Virginia | 51069 | 744 | 10 |
466235 | 466235 | 2020-08-24 | Fredericksburg city | Virginia | 51630 | 453 | 4 |
466236 | 466236 | 2020-08-24 | Galax city | Virginia | 51640 | 394 | 28 |
466237 | 466237 | 2020-08-24 | Giles | Virginia | 51071 | 35 | 0 |
466238 | 466238 | 2020-08-24 | Gloucester | Virginia | 51073 | 188 | 2 |
466239 | 466239 | 2020-08-24 | Goochland | Virginia | 51075 | 180 | 7 |
466240 | 466240 | 2020-08-24 | Grayson | Virginia | 51077 | 174 | 5 |
466241 | 466241 | 2020-08-24 | Greene | Virginia | 51079 | 192 | 2 |
466242 | 466242 | 2020-08-24 | Greensville | Virginia | 51081 | 657 | 11 |
466243 | 466243 | 2020-08-24 | Halifax | Virginia | 51083 | 186 | 2 |
466244 | 466244 | 2020-08-24 | Hampton city | Virginia | 51650 | 1463 | 11 |
466245 | 466245 | 2020-08-24 | Hanover | Virginia | 51085 | 743 | 34 |
466246 | 466246 | 2020-08-24 | Harrisonburg city | Virginia | 51660 | 1143 | 31 |
466247 | 466247 | 2020-08-24 | Henrico | Virginia | 51087 | 4359 | 189 |
466248 | 466248 | 2020-08-24 | Henry | Virginia | 51089 | 750 | 14 |
466249 | 466249 | 2020-08-24 | Highland | Virginia | 51091 | 6 | 0 |
466250 | 466250 | 2020-08-24 | Hopewell city | Virginia | 51670 | 318 | 4 |
466251 | 466251 | 2020-08-24 | Isle of Wight | Virginia | 51093 | 485 | 10 |
466252 | 466252 | 2020-08-24 | James City | Virginia | 51095 | 712 | 17 |
466253 | 466253 | 2020-08-24 | King George | Virginia | 51099 | 193 | 4 |
466254 | 466254 | 2020-08-24 | King William | Virginia | 51101 | 106 | 2 |
466255 | 466255 | 2020-08-24 | King and Queen | Virginia | 51097 | 47 | 1 |
466256 | 466256 | 2020-08-24 | Lancaster | Virginia | 51103 | 60 | 0 |
466257 | 466257 | 2020-08-24 | Lee | Virginia | 51105 | 161 | 2 |
466258 | 466258 | 2020-08-24 | Lexington city | Virginia | 51678 | 42 | 0 |
466259 | 466259 | 2020-08-24 | Loudoun | Virginia | 51107 | 5735 | 115 |
466260 | 466260 | 2020-08-24 | Louisa | Virginia | 51109 | 233 | 2 |
466261 | 466261 | 2020-08-24 | Lunenburg | Virginia | 51111 | 81 | 1 |
466262 | 466262 | 2020-08-24 | Lynchburg city | Virginia | 51680 | 839 | 5 |
466263 | 466263 | 2020-08-24 | Madison | Virginia | 51113 | 85 | 2 |
466264 | 466264 | 2020-08-24 | Manassas Park city | Virginia | 51685 | 552 | 7 |
466265 | 466265 | 2020-08-24 | Manassas city | Virginia | 51683 | 1758 | 23 |
466266 | 466266 | 2020-08-24 | Martinsville city | Virginia | 51690 | 280 | 3 |
466267 | 466267 | 2020-08-24 | Mathews | Virginia | 51115 | 23 | 0 |
466268 | 466268 | 2020-08-24 | Mecklenburg | Virginia | 51117 | 482 | 33 |
466269 | 466269 | 2020-08-24 | Middlesex | Virginia | 51119 | 54 | 1 |
466270 | 466270 | 2020-08-24 | Montgomery | Virginia | 51121 | 387 | 3 |
466271 | 466271 | 2020-08-24 | Nelson | Virginia | 51125 | 82 | 0 |
466272 | 466272 | 2020-08-24 | New Kent | Virginia | 51127 | 142 | 1 |
466273 | 466273 | 2020-08-24 | Newport News city | Virginia | 51700 | 2145 | 20 |
466274 | 466274 | 2020-08-24 | Norfolk city | Virginia | 51710 | 4164 | 43 |
466275 | 466275 | 2020-08-24 | Northampton | Virginia | 51131 | 303 | 29 |
466276 | 466276 | 2020-08-24 | Northumberland | Virginia | 51133 | 85 | 3 |
466277 | 466277 | 2020-08-24 | Norton city | Virginia | 51720 | 22 | 0 |
466278 | 466278 | 2020-08-24 | Nottoway | Virginia | 51135 | 184 | 14 |
466279 | 466279 | 2020-08-24 | Orange | Virginia | 51137 | 244 | 3 |
466280 | 466280 | 2020-08-24 | Page | Virginia | 51139 | 358 | 25 |
466281 | 466281 | 2020-08-24 | Patrick | Virginia | 51141 | 199 | 10 |
466282 | 466282 | 2020-08-24 | Petersburg city | Virginia | 51730 | 587 | 20 |
466283 | 466283 | 2020-08-24 | Pittsylvania | Virginia | 51143 | 644 | 4 |
466284 | 466284 | 2020-08-24 | Poquoson city | Virginia | 51735 | 57 | 0 |
466285 | 466285 | 2020-08-24 | Portsmouth city | Virginia | 51740 | 2086 | 31 |
466286 | 466286 | 2020-08-24 | Powhatan | Virginia | 51145 | 179 | 4 |
466287 | 466287 | 2020-08-24 | Prince Edward | Virginia | 51147 | 466 | 11 |
466288 | 466288 | 2020-08-24 | Prince George | Virginia | 51149 | 491 | 2 |
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);