ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
268 rows where cases = 8 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Russell 32
- Lexington city 13
- Buena Vista city 11
- Charlotte 10
- Highland 9
- Scott 9
- Cumberland 7
- Giles 7
- Poquoson city 7
- Henry 6
- Madison 6
- Westmoreland 6
- Floyd 5
- Northumberland 5
- Nottoway 5
- Pulaski 5
- Sussex 5
- Greene 4
- Lee 4
- Nelson 4
- Rockbridge 4
- Salem city 4
- Craig 3
- Culpeper 3
- Dinwiddie 3
- Gloucester 3
- Powhatan 3
- Radford city 3
- Waynesboro city 3
- Wise 3
- …
state 1
- Virginia · 268 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
621646 | 621646 | 2020-10-11 | Highland | Virginia | 51091 | 8 | 0 |
618403 | 618403 | 2020-10-10 | Highland | Virginia | 51091 | 8 | 0 |
615161 | 615161 | 2020-10-09 | Highland | Virginia | 51091 | 8 | 0 |
611920 | 611920 | 2020-10-08 | Highland | Virginia | 51091 | 8 | 0 |
608678 | 608678 | 2020-10-07 | Highland | Virginia | 51091 | 8 | 0 |
605435 | 605435 | 2020-10-06 | Highland | Virginia | 51091 | 8 | 0 |
602193 | 602193 | 2020-10-05 | Highland | Virginia | 51091 | 8 | 0 |
598950 | 598950 | 2020-10-04 | Highland | Virginia | 51091 | 8 | 0 |
595707 | 595707 | 2020-10-03 | Highland | Virginia | 51091 | 8 | 0 |
404927 | 404927 | 2020-08-05 | Bland | Virginia | 51021 | 8 | 0 |
369567 | 369567 | 2020-07-25 | Covington city | Virginia | 51580 | 8 | 0 |
366358 | 366358 | 2020-07-24 | Covington city | Virginia | 51580 | 8 | 0 |
363212 | 363212 | 2020-07-23 | Norton city | Virginia | 51720 | 8 | 0 |
350386 | 350386 | 2020-07-19 | Mathews | Virginia | 51115 | 8 | 0 |
340741 | 340741 | 2020-07-16 | Dickenson | Virginia | 51051 | 8 | 0 |
318406 | 318406 | 2020-07-09 | Bristol city | Virginia | 51520 | 8 | 0 |
308905 | 308905 | 2020-07-06 | Craig | Virginia | 51045 | 8 | 0 |
305737 | 305737 | 2020-07-05 | Craig | Virginia | 51045 | 8 | 0 |
302573 | 302573 | 2020-07-04 | Craig | Virginia | 51045 | 8 | 0 |
280516 | 280516 | 2020-06-27 | Giles | Virginia | 51071 | 8 | 0 |
277368 | 277368 | 2020-06-26 | Giles | Virginia | 51071 | 8 | 0 |
274220 | 274220 | 2020-06-25 | Giles | Virginia | 51071 | 8 | 0 |
264881 | 264881 | 2020-06-22 | Scott | Virginia | 51169 | 8 | 2 |
261752 | 261752 | 2020-06-21 | Scott | Virginia | 51169 | 8 | 2 |
258625 | 258625 | 2020-06-20 | Scott | Virginia | 51169 | 8 | 2 |
255455 | 255455 | 2020-06-19 | Lexington city | Virginia | 51678 | 8 | 0 |
255498 | 255498 | 2020-06-19 | Scott | Virginia | 51169 | 8 | 2 |
252336 | 252336 | 2020-06-18 | Lexington city | Virginia | 51678 | 8 | 0 |
252379 | 252379 | 2020-06-18 | Scott | Virginia | 51169 | 8 | 2 |
249221 | 249221 | 2020-06-17 | Lexington city | Virginia | 51678 | 8 | 0 |
249264 | 249264 | 2020-06-17 | Scott | Virginia | 51169 | 8 | 2 |
246109 | 246109 | 2020-06-16 | Lexington city | Virginia | 51678 | 8 | 0 |
246150 | 246150 | 2020-06-16 | Russell | Virginia | 51167 | 8 | 0 |
246152 | 246152 | 2020-06-16 | Scott | Virginia | 51169 | 8 | 2 |
242996 | 242996 | 2020-06-15 | Lexington city | Virginia | 51678 | 8 | 0 |
243029 | 243029 | 2020-06-15 | Radford city | Virginia | 51750 | 8 | 0 |
243037 | 243037 | 2020-06-15 | Russell | Virginia | 51167 | 8 | 0 |
243039 | 243039 | 2020-06-15 | Scott | Virginia | 51169 | 8 | 2 |
239885 | 239885 | 2020-06-14 | Lexington city | Virginia | 51678 | 8 | 0 |
239918 | 239918 | 2020-06-14 | Radford city | Virginia | 51750 | 8 | 0 |
239926 | 239926 | 2020-06-14 | Russell | Virginia | 51167 | 8 | 0 |
236777 | 236777 | 2020-06-13 | Lexington city | Virginia | 51678 | 8 | 0 |
236810 | 236810 | 2020-06-13 | Radford city | Virginia | 51750 | 8 | 0 |
236818 | 236818 | 2020-06-13 | Russell | Virginia | 51167 | 8 | 0 |
233642 | 233642 | 2020-06-12 | Floyd | Virginia | 51063 | 8 | 1 |
233670 | 233670 | 2020-06-12 | Lexington city | Virginia | 51678 | 8 | 0 |
233711 | 233711 | 2020-06-12 | Russell | Virginia | 51167 | 8 | 0 |
230537 | 230537 | 2020-06-11 | Floyd | Virginia | 51063 | 8 | 1 |
230565 | 230565 | 2020-06-11 | Lexington city | Virginia | 51678 | 8 | 0 |
230606 | 230606 | 2020-06-11 | Russell | Virginia | 51167 | 8 | 0 |
227433 | 227433 | 2020-06-10 | Floyd | Virginia | 51063 | 8 | 1 |
227461 | 227461 | 2020-06-10 | Lexington city | Virginia | 51678 | 8 | 0 |
227502 | 227502 | 2020-06-10 | Russell | Virginia | 51167 | 8 | 0 |
224333 | 224333 | 2020-06-09 | Floyd | Virginia | 51063 | 8 | 1 |
224361 | 224361 | 2020-06-09 | Lexington city | Virginia | 51678 | 8 | 0 |
224402 | 224402 | 2020-06-09 | Russell | Virginia | 51167 | 8 | 0 |
221237 | 221237 | 2020-06-08 | Floyd | Virginia | 51063 | 8 | 1 |
221265 | 221265 | 2020-06-08 | Lexington city | Virginia | 51678 | 8 | 0 |
221306 | 221306 | 2020-06-08 | Russell | Virginia | 51167 | 8 | 0 |
218173 | 218173 | 2020-06-07 | Lexington city | Virginia | 51678 | 8 | 0 |
218214 | 218214 | 2020-06-07 | Russell | Virginia | 51167 | 8 | 0 |
215109 | 215109 | 2020-06-06 | Poquoson city | Virginia | 51735 | 8 | 0 |
215124 | 215124 | 2020-06-06 | Russell | Virginia | 51167 | 8 | 0 |
212022 | 212022 | 2020-06-05 | Poquoson city | Virginia | 51735 | 8 | 0 |
212037 | 212037 | 2020-06-05 | Russell | Virginia | 51167 | 8 | 0 |
208937 | 208937 | 2020-06-04 | Poquoson city | Virginia | 51735 | 8 | 0 |
208952 | 208952 | 2020-06-04 | Russell | Virginia | 51167 | 8 | 0 |
205855 | 205855 | 2020-06-03 | Poquoson city | Virginia | 51735 | 8 | 0 |
205870 | 205870 | 2020-06-03 | Russell | Virginia | 51167 | 8 | 0 |
202776 | 202776 | 2020-06-02 | Poquoson city | Virginia | 51735 | 8 | 0 |
202791 | 202791 | 2020-06-02 | Russell | Virginia | 51167 | 8 | 0 |
199700 | 199700 | 2020-06-01 | Poquoson city | Virginia | 51735 | 8 | 0 |
199715 | 199715 | 2020-06-01 | Russell | Virginia | 51167 | 8 | 0 |
196627 | 196627 | 2020-05-31 | Poquoson city | Virginia | 51735 | 8 | 0 |
196642 | 196642 | 2020-05-31 | Russell | Virginia | 51167 | 8 | 0 |
193572 | 193572 | 2020-05-30 | Russell | Virginia | 51167 | 8 | 0 |
190506 | 190506 | 2020-05-29 | Russell | Virginia | 51167 | 8 | 0 |
187442 | 187442 | 2020-05-28 | Russell | Virginia | 51167 | 8 | 0 |
184341 | 184341 | 2020-05-27 | King and Queen | Virginia | 51097 | 8 | 0 |
184385 | 184385 | 2020-05-27 | Russell | Virginia | 51167 | 8 | 0 |
184395 | 184395 | 2020-05-27 | Surry | Virginia | 51181 | 8 | 1 |
181334 | 181334 | 2020-05-26 | Russell | Virginia | 51167 | 8 | 0 |
178252 | 178252 | 2020-05-25 | Lunenburg | Virginia | 51111 | 8 | 0 |
178290 | 178290 | 2020-05-25 | Russell | Virginia | 51167 | 8 | 0 |
175207 | 175207 | 2020-05-24 | Lunenburg | Virginia | 51111 | 8 | 0 |
175245 | 175245 | 2020-05-24 | Russell | Virginia | 51167 | 8 | 0 |
172202 | 172202 | 2020-05-23 | Russell | Virginia | 51167 | 8 | 0 |
169161 | 169161 | 2020-05-22 | Russell | Virginia | 51167 | 8 | 0 |
166082 | 166082 | 2020-05-21 | Lancaster | Virginia | 51103 | 8 | 0 |
166125 | 166125 | 2020-05-21 | Russell | Virginia | 51167 | 8 | 0 |
166127 | 166127 | 2020-05-21 | Scott | Virginia | 51169 | 8 | 2 |
163096 | 163096 | 2020-05-20 | Russell | Virginia | 51167 | 8 | 0 |
160068 | 160068 | 2020-05-19 | Russell | Virginia | 51167 | 8 | 0 |
157011 | 157011 | 2020-05-18 | Martinsville city | Virginia | 51690 | 8 | 0 |
157026 | 157026 | 2020-05-18 | Patrick | Virginia | 51141 | 8 | 0 |
157044 | 157044 | 2020-05-18 | Russell | Virginia | 51167 | 8 | 0 |
153935 | 153935 | 2020-05-17 | Buena Vista city | Virginia | 51530 | 8 | 0 |
154027 | 154027 | 2020-05-17 | Russell | Virginia | 51167 | 8 | 0 |
150924 | 150924 | 2020-05-16 | Buena Vista city | Virginia | 51530 | 8 | 0 |
151016 | 151016 | 2020-05-16 | Russell | Virginia | 51167 | 8 | 0 |
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);