ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 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
- Craig 11
- Alleghany 9
- Appomattox 9
- Botetourt 8
- Buchanan 8
- Charlotte 7
- Gloucester 6
- King William 5
- Martinsville city 4
- Salem city 4
- Sussex 4
- Clarke 3
- Essex 3
- Halifax 3
- Hopewell city 3
- King and Queen 3
- Lancaster 3
- Norton city 3
- Patrick 3
- Rappahannock 3
- Amelia 2
- Amherst 2
- Buckingham 2
- Charlottesville city 2
- Danville city 2
- Floyd 2
- Highland 2
- Lunenburg 2
- Lynchburg city 2
- Petersburg city 2
- …
state 1
- Virginia · 158 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
822813 | 822813 | 2020-12-12 | Highland | Virginia | 51091 | 31 | 0 |
819567 | 819567 | 2020-12-11 | Highland | Virginia | 51091 | 31 | 0 |
705941 | 705941 | 2020-11-06 | Bath | Virginia | 51017 | 31 | 0 |
608647 | 608647 | 2020-10-07 | Craig | Virginia | 51045 | 31 | 0 |
605404 | 605404 | 2020-10-06 | Craig | Virginia | 51045 | 31 | 0 |
602162 | 602162 | 2020-10-05 | Craig | Virginia | 51045 | 31 | 0 |
598919 | 598919 | 2020-10-04 | Craig | Virginia | 51045 | 31 | 0 |
595676 | 595676 | 2020-10-03 | Craig | Virginia | 51045 | 31 | 0 |
592434 | 592434 | 2020-10-02 | Craig | Virginia | 51045 | 31 | 0 |
589194 | 589194 | 2020-10-01 | Craig | Virginia | 51045 | 31 | 0 |
585953 | 585953 | 2020-09-30 | Craig | Virginia | 51045 | 31 | 0 |
582713 | 582713 | 2020-09-29 | Craig | Virginia | 51045 | 31 | 0 |
579474 | 579474 | 2020-09-28 | Craig | Virginia | 51045 | 31 | 0 |
576233 | 576233 | 2020-09-27 | Craig | Virginia | 51045 | 31 | 0 |
540651 | 540651 | 2020-09-16 | Mathews | Virginia | 51115 | 31 | 0 |
521244 | 521244 | 2020-09-10 | Norton city | Virginia | 51720 | 31 | 0 |
518007 | 518007 | 2020-09-09 | Norton city | Virginia | 51720 | 31 | 0 |
514772 | 514772 | 2020-09-08 | Norton city | Virginia | 51720 | 31 | 0 |
440378 | 440378 | 2020-08-16 | Bland | Virginia | 51021 | 31 | 0 |
398549 | 398549 | 2020-08-03 | Lancaster | Virginia | 51103 | 31 | 0 |
395333 | 395333 | 2020-08-02 | Lancaster | Virginia | 51103 | 31 | 0 |
392117 | 392117 | 2020-08-01 | Lancaster | Virginia | 51103 | 31 | 0 |
385657 | 385657 | 2020-07-30 | Floyd | Virginia | 51063 | 31 | 1 |
382439 | 382439 | 2020-07-29 | Floyd | Virginia | 51063 | 31 | 1 |
363137 | 363137 | 2020-07-23 | Bristol city | Virginia | 51520 | 31 | 0 |
363244 | 363244 | 2020-07-23 | Surry | Virginia | 51181 | 31 | 1 |
356730 | 356730 | 2020-07-21 | Buena Vista city | Virginia | 51530 | 31 | 0 |
356823 | 356823 | 2020-07-21 | Russell | Virginia | 51167 | 31 | 0 |
343973 | 343973 | 2020-07-17 | King and Queen | Virginia | 51097 | 31 | 1 |
340774 | 340774 | 2020-07-16 | King and Queen | Virginia | 51097 | 31 | 1 |
337578 | 337578 | 2020-07-15 | King and Queen | Virginia | 51097 | 31 | 1 |
321675 | 321675 | 2020-07-10 | Rappahannock | Virginia | 51157 | 31 | 0 |
318496 | 318496 | 2020-07-09 | Rappahannock | Virginia | 51157 | 31 | 0 |
315323 | 315323 | 2020-07-08 | Rappahannock | Virginia | 51157 | 31 | 0 |
302559 | 302559 | 2020-07-04 | Buchanan | Virginia | 51027 | 31 | 0 |
299395 | 299395 | 2020-07-03 | Buchanan | Virginia | 51027 | 31 | 0 |
296233 | 296233 | 2020-07-02 | Buchanan | Virginia | 51027 | 31 | 0 |
293078 | 293078 | 2020-07-01 | Buchanan | Virginia | 51027 | 31 | 0 |
293171 | 293171 | 2020-07-01 | Rockbridge | Virginia | 51163 | 31 | 0 |
289914 | 289914 | 2020-06-30 | Alleghany | Virginia | 51005 | 31 | 2 |
289925 | 289925 | 2020-06-30 | Buchanan | Virginia | 51027 | 31 | 0 |
289932 | 289932 | 2020-06-30 | Charlotte | Virginia | 51037 | 31 | 0 |
289982 | 289982 | 2020-06-30 | Lunenburg | Virginia | 51111 | 31 | 0 |
286764 | 286764 | 2020-06-29 | Alleghany | Virginia | 51005 | 31 | 2 |
286775 | 286775 | 2020-06-29 | Buchanan | Virginia | 51027 | 31 | 0 |
286782 | 286782 | 2020-06-29 | Charlotte | Virginia | 51037 | 31 | 0 |
286832 | 286832 | 2020-06-29 | Lunenburg | Virginia | 51111 | 31 | 0 |
283618 | 283618 | 2020-06-28 | Alleghany | Virginia | 51005 | 31 | 2 |
283629 | 283629 | 2020-06-28 | Buchanan | Virginia | 51027 | 31 | 0 |
280472 | 280472 | 2020-06-27 | Alleghany | Virginia | 51005 | 31 | 2 |
280483 | 280483 | 2020-06-27 | Buchanan | Virginia | 51027 | 31 | 0 |
277324 | 277324 | 2020-06-26 | Alleghany | Virginia | 51005 | 31 | 2 |
274176 | 274176 | 2020-06-25 | Alleghany | Virginia | 51005 | 31 | 2 |
271036 | 271036 | 2020-06-24 | Alleghany | Virginia | 51005 | 31 | 2 |
271038 | 271038 | 2020-06-24 | Amherst | Virginia | 51009 | 31 | 0 |
271054 | 271054 | 2020-06-24 | Charlotte | Virginia | 51037 | 31 | 0 |
267902 | 267902 | 2020-06-23 | Alleghany | Virginia | 51005 | 31 | 2 |
267904 | 267904 | 2020-06-23 | Amherst | Virginia | 51009 | 31 | 0 |
267920 | 267920 | 2020-06-23 | Charlotte | Virginia | 51037 | 31 | 0 |
264773 | 264773 | 2020-06-22 | Alleghany | Virginia | 51005 | 31 | 2 |
264791 | 264791 | 2020-06-22 | Charlotte | Virginia | 51037 | 31 | 0 |
261662 | 261662 | 2020-06-21 | Charlotte | Virginia | 51037 | 31 | 0 |
258535 | 258535 | 2020-06-20 | Charlotte | Virginia | 51037 | 31 | 0 |
255487 | 255487 | 2020-06-19 | Pulaski | Virginia | 51155 | 31 | 1 |
252368 | 252368 | 2020-06-18 | Pulaski | Virginia | 51155 | 31 | 1 |
239908 | 239908 | 2020-06-14 | Patrick | Virginia | 51141 | 31 | 0 |
236800 | 236800 | 2020-06-13 | Patrick | Virginia | 51141 | 31 | 0 |
233693 | 233693 | 2020-06-12 | Patrick | Virginia | 51141 | 31 | 0 |
218111 | 218111 | 2020-06-07 | Amelia | Virginia | 51007 | 31 | 1 |
215021 | 215021 | 2020-06-06 | Amelia | Virginia | 51007 | 31 | 1 |
215041 | 215041 | 2020-06-06 | Clarke | Virginia | 51043 | 31 | 0 |
215068 | 215068 | 2020-06-06 | Halifax | Virginia | 51083 | 31 | 1 |
211954 | 211954 | 2020-06-05 | Clarke | Virginia | 51043 | 31 | 0 |
211981 | 211981 | 2020-06-05 | Halifax | Virginia | 51083 | 31 | 1 |
211992 | 211992 | 2020-06-05 | King William | Virginia | 51101 | 31 | 0 |
208851 | 208851 | 2020-06-04 | Appomattox | Virginia | 51011 | 31 | 0 |
208857 | 208857 | 2020-06-04 | Brunswick | Virginia | 51025 | 31 | 1 |
208869 | 208869 | 2020-06-04 | Clarke | Virginia | 51043 | 31 | 0 |
208891 | 208891 | 2020-06-04 | Gloucester | Virginia | 51073 | 31 | 1 |
208896 | 208896 | 2020-06-04 | Halifax | Virginia | 51083 | 31 | 1 |
208907 | 208907 | 2020-06-04 | King William | Virginia | 51101 | 31 | 0 |
205769 | 205769 | 2020-06-03 | Appomattox | Virginia | 51011 | 31 | 0 |
205809 | 205809 | 2020-06-03 | Gloucester | Virginia | 51073 | 31 | 1 |
205825 | 205825 | 2020-06-03 | King William | Virginia | 51101 | 31 | 0 |
202690 | 202690 | 2020-06-02 | Appomattox | Virginia | 51011 | 31 | 0 |
202730 | 202730 | 2020-06-02 | Gloucester | Virginia | 51073 | 31 | 1 |
202746 | 202746 | 2020-06-02 | King William | Virginia | 51101 | 31 | 0 |
199614 | 199614 | 2020-06-01 | Appomattox | Virginia | 51011 | 31 | 0 |
199654 | 199654 | 2020-06-01 | Gloucester | Virginia | 51073 | 31 | 1 |
199670 | 199670 | 2020-06-01 | King William | Virginia | 51101 | 31 | 0 |
196541 | 196541 | 2020-05-31 | Appomattox | Virginia | 51011 | 31 | 0 |
196581 | 196581 | 2020-05-31 | Gloucester | Virginia | 51073 | 31 | 1 |
196609 | 196609 | 2020-05-31 | Martinsville city | Virginia | 51690 | 31 | 1 |
193471 | 193471 | 2020-05-30 | Appomattox | Virginia | 51011 | 31 | 0 |
193511 | 193511 | 2020-05-30 | Gloucester | Virginia | 51073 | 31 | 1 |
193539 | 193539 | 2020-05-30 | Martinsville city | Virginia | 51690 | 31 | 1 |
190405 | 190405 | 2020-05-29 | Appomattox | Virginia | 51011 | 31 | 0 |
190448 | 190448 | 2020-05-29 | Greene | Virginia | 51079 | 31 | 1 |
190473 | 190473 | 2020-05-29 | Martinsville city | Virginia | 51690 | 31 | 1 |
187341 | 187341 | 2020-05-28 | Appomattox | Virginia | 51011 | 31 | 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);