ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 1927 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 11
- Fluvanna 11
- Nottoway 10
- Colonial Heights city 1
- Danville city 1
- Dinwiddie 1
- Greensville 1
- Northampton 1
- Page 1
- Russell 1
- Scott 1
- Shenandoah 1
state 1
- Virginia · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2147929 | 2147929 | 2022-01-24 | Northampton | Virginia | 51131 | 1927 | 51 |
1897577 | 1897577 | 2021-11-08 | Greensville | Virginia | 51081 | 1927 | 26 |
1624645 | 1624645 | 2021-08-16 | Colonial Heights city | Virginia | 51570 | 1927 | 60 |
1579248 | 1579248 | 2021-08-02 | Scott | Virginia | 51169 | 1927 | 61 |
1494797 | 1494797 | 2021-07-07 | Nottoway | Virginia | 51135 | 1927 | 49 |
1491550 | 1491550 | 2021-07-06 | Nottoway | Virginia | 51135 | 1927 | 49 |
1488303 | 1488303 | 2021-07-05 | Nottoway | Virginia | 51135 | 1927 | 49 |
1485056 | 1485056 | 2021-07-04 | Nottoway | Virginia | 51135 | 1927 | 49 |
1481810 | 1481810 | 2021-07-03 | Nottoway | Virginia | 51135 | 1927 | 49 |
1478516 | 1478516 | 2021-07-02 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1478563 | 1478563 | 2021-07-02 | Nottoway | Virginia | 51135 | 1927 | 49 |
1475317 | 1475317 | 2021-07-01 | Nottoway | Virginia | 51135 | 1927 | 49 |
1465581 | 1465581 | 2021-06-28 | Nottoway | Virginia | 51135 | 1927 | 49 |
1462336 | 1462336 | 2021-06-27 | Nottoway | Virginia | 51135 | 1927 | 49 |
1459091 | 1459091 | 2021-06-26 | Nottoway | Virginia | 51135 | 1927 | 49 |
1455799 | 1455799 | 2021-06-25 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1452554 | 1452554 | 2021-06-24 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1449308 | 1449308 | 2021-06-23 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1446063 | 1446063 | 2021-06-22 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1442818 | 1442818 | 2021-06-21 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1439573 | 1439573 | 2021-06-20 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1436326 | 1436326 | 2021-06-19 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1433079 | 1433079 | 2021-06-18 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1429833 | 1429833 | 2021-06-17 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1426588 | 1426588 | 2021-06-16 | Fluvanna | Virginia | 51065 | 1927 | 20 |
1209119 | 1209119 | 2021-04-10 | Page | Virginia | 51139 | 1927 | 57 |
1140862 | 1140862 | 2021-03-20 | Dinwiddie | Virginia | 51053 | 1927 | 42 |
998118 | 998118 | 2021-02-04 | Russell | Virginia | 51167 | 1927 | 25 |
855324 | 855324 | 2020-12-22 | Shenandoah | Virginia | 51171 | 1927 | 69 |
819539 | 819539 | 2020-12-11 | Danville city | Virginia | 51590 | 1927 | 55 |
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);