ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 271 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 26
county 26
- Bath 16
- Northampton 5
- Patrick 4
- Hampton city 2
- Alleghany 1
- Appomattox 1
- Cumberland 1
- Emporia city 1
- Floyd 1
- Frederick 1
- Goochland 1
- Greene 1
- Highland 1
- King William 1
- Lexington city 1
- Martinsville city 1
- Mecklenburg 1
- Northumberland 1
- Nottoway 1
- Petersburg city 1
- Salem city 1
- Shenandoah 1
- Stafford 1
- Sussex 1
- Virginia Beach city 1
- Waynesboro city 1
state 1
- Virginia · 49 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112118 | 2112118 | 2022-01-13 | Highland | Virginia | 51091 | 271 | 4 |
1420062 | 1420062 | 2021-06-14 | Bath | Virginia | 51017 | 271 | 11 |
1416817 | 1416817 | 2021-06-13 | Bath | Virginia | 51017 | 271 | 11 |
1413571 | 1413571 | 2021-06-12 | Bath | Virginia | 51017 | 271 | 11 |
1410326 | 1410326 | 2021-06-11 | Bath | Virginia | 51017 | 271 | 11 |
1407081 | 1407081 | 2021-06-10 | Bath | Virginia | 51017 | 271 | 10 |
1403835 | 1403835 | 2021-06-09 | Bath | Virginia | 51017 | 271 | 10 |
1400590 | 1400590 | 2021-06-08 | Bath | Virginia | 51017 | 271 | 10 |
1397345 | 1397345 | 2021-06-07 | Bath | Virginia | 51017 | 271 | 10 |
1394098 | 1394098 | 2021-06-06 | Bath | Virginia | 51017 | 271 | 10 |
1390853 | 1390853 | 2021-06-05 | Bath | Virginia | 51017 | 271 | 10 |
1332421 | 1332421 | 2021-05-18 | Bath | Virginia | 51017 | 271 | 10 |
1329174 | 1329174 | 2021-05-17 | Bath | Virginia | 51017 | 271 | 10 |
1325928 | 1325928 | 2021-05-16 | Bath | Virginia | 51017 | 271 | 10 |
1322682 | 1322682 | 2021-05-15 | Bath | Virginia | 51017 | 271 | 10 |
1319436 | 1319436 | 2021-05-14 | Bath | Virginia | 51017 | 271 | 10 |
1316188 | 1316188 | 2021-05-13 | Bath | Virginia | 51017 | 271 | 10 |
946110 | 946110 | 2021-01-19 | Cumberland | Virginia | 51049 | 271 | 4 |
777408 | 777408 | 2020-11-28 | Northumberland | Virginia | 51133 | 271 | 8 |
757915 | 757915 | 2020-11-22 | King William | Virginia | 51101 | 271 | 5 |
754606 | 754606 | 2020-11-21 | Alleghany | Virginia | 51005 | 271 | 7 |
715705 | 715705 | 2020-11-09 | Floyd | Virginia | 51063 | 271 | 15 |
702758 | 702758 | 2020-11-05 | Lexington city | Virginia | 51678 | 271 | 1 |
654042 | 654042 | 2020-10-21 | Appomattox | Virginia | 51011 | 271 | 5 |
654088 | 654088 | 2020-10-21 | Greene | Virginia | 51079 | 271 | 3 |
634596 | 634596 | 2020-10-15 | Emporia city | Virginia | 51595 | 271 | 26 |
595736 | 595736 | 2020-10-03 | Nottoway | Virginia | 51135 | 271 | 20 |
582795 | 582795 | 2020-09-29 | Salem city | Virginia | 51775 | 271 | 6 |
582810 | 582810 | 2020-09-29 | Waynesboro city | Virginia | 51820 | 271 | 3 |
576254 | 576254 | 2020-09-27 | Goochland | Virginia | 51075 | 271 | 7 |
563328 | 563328 | 2020-09-23 | Patrick | Virginia | 51141 | 271 | 24 |
560089 | 560089 | 2020-09-22 | Patrick | Virginia | 51141 | 271 | 24 |
556853 | 556853 | 2020-09-21 | Patrick | Virginia | 51141 | 271 | 24 |
553616 | 553616 | 2020-09-20 | Patrick | Virginia | 51141 | 271 | 24 |
456581 | 456581 | 2020-08-21 | Martinsville city | Virginia | 51690 | 271 | 3 |
382519 | 382519 | 2020-07-29 | Sussex | Virginia | 51183 | 271 | 8 |
343986 | 343986 | 2020-07-17 | Mecklenburg | Virginia | 51117 | 271 | 29 |
302630 | 302630 | 2020-07-04 | Northampton | Virginia | 51131 | 271 | 28 |
302637 | 302637 | 2020-07-04 | Petersburg city | Virginia | 51730 | 271 | 5 |
299466 | 299466 | 2020-07-03 | Northampton | Virginia | 51131 | 271 | 28 |
296304 | 296304 | 2020-07-02 | Northampton | Virginia | 51131 | 271 | 28 |
267953 | 267953 | 2020-06-23 | Hampton city | Virginia | 51650 | 271 | 5 |
267984 | 267984 | 2020-06-23 | Northampton | Virginia | 51131 | 271 | 28 |
264824 | 264824 | 2020-06-22 | Hampton city | Virginia | 51650 | 271 | 5 |
264855 | 264855 | 2020-06-22 | Northampton | Virginia | 51131 | 271 | 28 |
178225 | 178225 | 2020-05-25 | Frederick | Virginia | 51069 | 271 | 4 |
142010 | 142010 | 2020-05-13 | Shenandoah | Virginia | 51171 | 271 | 8 |
112285 | 112285 | 2020-05-03 | Stafford | Virginia | 51179 | 271 | 2 |
69944 | 69944 | 2020-04-18 | Virginia Beach city | Virginia | 51810 | 271 | 5 |
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);