ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
129 rows where cases = 24 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- King and Queen 24
- Wise 10
- Bath 7
- Roanoke city 5
- Alleghany 4
- Hopewell city 4
- Botetourt 3
- Falls Church city 3
- Madison 3
- Martinsville city 3
- Powhatan 3
- Warren 3
- Appomattox 2
- Bedford 2
- Charles City 2
- Craig 2
- Giles 2
- Gloucester 2
- Goochland 2
- Grayson 2
- Isle of Wight 2
- King William 2
- Lancaster 2
- Petersburg city 2
- Pittsylvania 2
- Washington 2
- Amherst 1
- Augusta 1
- Brunswick 1
- Buckingham 1
- …
state 1
- Virginia · 129 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
679994 | 679994 | 2020-10-29 | Bath | Virginia | 51017 | 24 | 0 |
676751 | 676751 | 2020-10-28 | Bath | Virginia | 51017 | 24 | 0 |
673508 | 673508 | 2020-10-27 | Bath | Virginia | 51017 | 24 | 0 |
670266 | 670266 | 2020-10-26 | Bath | Virginia | 51017 | 24 | 0 |
667023 | 667023 | 2020-10-25 | Bath | Virginia | 51017 | 24 | 0 |
663778 | 663778 | 2020-10-24 | Bath | Virginia | 51017 | 24 | 0 |
660534 | 660534 | 2020-10-23 | Bath | Virginia | 51017 | 24 | 0 |
521185 | 521185 | 2020-09-10 | Craig | Virginia | 51045 | 24 | 0 |
517948 | 517948 | 2020-09-09 | Craig | Virginia | 51045 | 24 | 0 |
469506 | 469506 | 2020-08-25 | Norton city | Virginia | 51720 | 24 | 0 |
421065 | 421065 | 2020-08-10 | Giles | Virginia | 51071 | 24 | 0 |
417844 | 417844 | 2020-08-09 | Giles | Virginia | 51071 | 24 | 0 |
395299 | 395299 | 2020-08-02 | Dickenson | Virginia | 51051 | 24 | 0 |
366397 | 366397 | 2020-07-24 | Lancaster | Virginia | 51103 | 24 | 0 |
363191 | 363191 | 2020-07-23 | Lancaster | Virginia | 51103 | 24 | 0 |
344002 | 344002 | 2020-07-17 | Poquoson city | Virginia | 51735 | 24 | 0 |
331165 | 331165 | 2020-07-13 | Floyd | Virginia | 51063 | 24 | 1 |
321694 | 321694 | 2020-07-10 | Tazewell | Virginia | 51185 | 24 | 0 |
312111 | 312111 | 2020-07-07 | King and Queen | Virginia | 51097 | 24 | 1 |
308942 | 308942 | 2020-07-06 | King and Queen | Virginia | 51097 | 24 | 1 |
305774 | 305774 | 2020-07-05 | King and Queen | Virginia | 51097 | 24 | 1 |
302610 | 302610 | 2020-07-04 | King and Queen | Virginia | 51097 | 24 | 1 |
299446 | 299446 | 2020-07-03 | King and Queen | Virginia | 51097 | 24 | 1 |
296284 | 296284 | 2020-07-02 | King and Queen | Virginia | 51097 | 24 | 1 |
274238 | 274238 | 2020-06-25 | King and Queen | Virginia | 51097 | 24 | 1 |
271098 | 271098 | 2020-06-24 | King and Queen | Virginia | 51097 | 24 | 1 |
271140 | 271140 | 2020-06-24 | Rockbridge | Virginia | 51163 | 24 | 0 |
267964 | 267964 | 2020-06-23 | King and Queen | Virginia | 51097 | 24 | 1 |
264835 | 264835 | 2020-06-22 | King and Queen | Virginia | 51097 | 24 | 1 |
261706 | 261706 | 2020-06-21 | King and Queen | Virginia | 51097 | 24 | 1 |
258579 | 258579 | 2020-06-20 | King and Queen | Virginia | 51097 | 24 | 1 |
255452 | 255452 | 2020-06-19 | King and Queen | Virginia | 51097 | 24 | 1 |
252333 | 252333 | 2020-06-18 | King and Queen | Virginia | 51097 | 24 | 1 |
249218 | 249218 | 2020-06-17 | King and Queen | Virginia | 51097 | 24 | 1 |
246106 | 246106 | 2020-06-16 | King and Queen | Virginia | 51097 | 24 | 1 |
242993 | 242993 | 2020-06-15 | King and Queen | Virginia | 51097 | 24 | 1 |
239882 | 239882 | 2020-06-14 | King and Queen | Virginia | 51097 | 24 | 1 |
236774 | 236774 | 2020-06-13 | King and Queen | Virginia | 51097 | 24 | 1 |
233667 | 233667 | 2020-06-12 | King and Queen | Virginia | 51097 | 24 | 1 |
230562 | 230562 | 2020-06-11 | King and Queen | Virginia | 51097 | 24 | 1 |
227458 | 227458 | 2020-06-10 | King and Queen | Virginia | 51097 | 24 | 1 |
221262 | 221262 | 2020-06-08 | King and Queen | Virginia | 51097 | 24 | 1 |
218170 | 218170 | 2020-06-07 | King and Queen | Virginia | 51097 | 24 | 1 |
215115 | 215115 | 2020-06-06 | Pulaski | Virginia | 51155 | 24 | 1 |
211933 | 211933 | 2020-06-05 | Alleghany | Virginia | 51005 | 24 | 2 |
208848 | 208848 | 2020-06-04 | Alleghany | Virginia | 51005 | 24 | 2 |
205766 | 205766 | 2020-06-03 | Alleghany | Virginia | 51005 | 24 | 2 |
202687 | 202687 | 2020-06-02 | Alleghany | Virginia | 51005 | 24 | 2 |
199628 | 199628 | 2020-06-01 | Charlotte | Virginia | 51037 | 24 | 0 |
193592 | 193592 | 2020-05-30 | Wise | Virginia | 51195 | 24 | 2 |
190526 | 190526 | 2020-05-29 | Wise | Virginia | 51195 | 24 | 2 |
187347 | 187347 | 2020-05-28 | Brunswick | Virginia | 51025 | 24 | 1 |
187359 | 187359 | 2020-05-28 | Clarke | Virginia | 51043 | 24 | 0 |
187421 | 187421 | 2020-05-28 | Nottoway | Virginia | 51135 | 24 | 0 |
187462 | 187462 | 2020-05-28 | Wise | Virginia | 51195 | 24 | 2 |
184405 | 184405 | 2020-05-27 | Wise | Virginia | 51195 | 24 | 2 |
181289 | 181289 | 2020-05-26 | King William | Virginia | 51101 | 24 | 0 |
181354 | 181354 | 2020-05-26 | Wise | Virginia | 51195 | 24 | 2 |
178245 | 178245 | 2020-05-25 | King William | Virginia | 51101 | 24 | 0 |
178257 | 178257 | 2020-05-25 | Martinsville city | Virginia | 51690 | 24 | 1 |
178310 | 178310 | 2020-05-25 | Wise | Virginia | 51195 | 24 | 2 |
175212 | 175212 | 2020-05-24 | Martinsville city | Virginia | 51690 | 24 | 1 |
175265 | 175265 | 2020-05-24 | Wise | Virginia | 51195 | 24 | 2 |
172143 | 172143 | 2020-05-23 | Grayson | Virginia | 51077 | 24 | 0 |
172169 | 172169 | 2020-05-23 | Martinsville city | Virginia | 51690 | 24 | 1 |
172222 | 172222 | 2020-05-23 | Wise | Virginia | 51195 | 24 | 2 |
169102 | 169102 | 2020-05-22 | Grayson | Virginia | 51077 | 24 | 0 |
169181 | 169181 | 2020-05-22 | Wise | Virginia | 51195 | 24 | 2 |
166145 | 166145 | 2020-05-21 | Wise | Virginia | 51195 | 24 | 2 |
162995 | 162995 | 2020-05-20 | Appomattox | Virginia | 51011 | 24 | 0 |
163008 | 163008 | 2020-05-20 | Charles City | Virginia | 51036 | 24 | 1 |
159967 | 159967 | 2020-05-19 | Appomattox | Virginia | 51011 | 24 | 0 |
159980 | 159980 | 2020-05-19 | Charles City | Virginia | 51036 | 24 | 1 |
157008 | 157008 | 2020-05-18 | Madison | Virginia | 51113 | 24 | 1 |
157028 | 157028 | 2020-05-18 | Pittsylvania | Virginia | 51143 | 24 | 1 |
157031 | 157031 | 2020-05-18 | Powhatan | Virginia | 51145 | 24 | 0 |
157060 | 157060 | 2020-05-18 | Waynesboro city | Virginia | 51820 | 24 | 0 |
153991 | 153991 | 2020-05-17 | Madison | Virginia | 51113 | 24 | 1 |
154011 | 154011 | 2020-05-17 | Pittsylvania | Virginia | 51143 | 24 | 1 |
154014 | 154014 | 2020-05-17 | Powhatan | Virginia | 51145 | 24 | 0 |
150914 | 150914 | 2020-05-16 | Amherst | Virginia | 51009 | 24 | 0 |
150980 | 150980 | 2020-05-16 | Madison | Virginia | 51113 | 24 | 1 |
151003 | 151003 | 2020-05-16 | Powhatan | Virginia | 51145 | 24 | 0 |
138955 | 138955 | 2020-05-12 | Halifax | Virginia | 51083 | 24 | 0 |
135946 | 135946 | 2020-05-11 | Essex | Virginia | 51057 | 24 | 0 |
123998 | 123998 | 2020-05-07 | Franklin | Virginia | 51067 | 24 | 0 |
112203 | 112203 | 2020-05-03 | Emporia city | Virginia | 51595 | 24 | 3 |
109343 | 109343 | 2020-05-02 | Gloucester | Virginia | 51073 | 24 | 1 |
106474 | 106474 | 2020-05-01 | Gloucester | Virginia | 51073 | 24 | 1 |
103622 | 103622 | 2020-04-30 | Hopewell city | Virginia | 51670 | 24 | 0 |
100767 | 100767 | 2020-04-29 | Hopewell city | Virginia | 51670 | 24 | 0 |
97917 | 97917 | 2020-04-28 | Hopewell city | Virginia | 51670 | 24 | 0 |
95060 | 95060 | 2020-04-27 | Fredericksburg city | Virginia | 51630 | 24 | 0 |
95074 | 95074 | 2020-04-27 | Hopewell city | Virginia | 51670 | 24 | 0 |
92198 | 92198 | 2020-04-26 | Bedford | Virginia | 51019 | 24 | 0 |
92269 | 92269 | 2020-04-26 | Northampton | Virginia | 51131 | 24 | 0 |
89381 | 89381 | 2020-04-25 | Bedford | Virginia | 51019 | 24 | 0 |
86592 | 86592 | 2020-04-24 | Falls Church city | Virginia | 51610 | 24 | 2 |
80997 | 80997 | 2020-04-22 | Greensville | Virginia | 51081 | 24 | 4 |
81036 | 81036 | 2020-04-22 | Petersburg city | Virginia | 51730 | 24 | 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);