ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 2840 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Halifax 6
- Powhatan 3
- Accomack 2
- Danville city 1
- Lexington city 1
- Tazewell 1
- Warren 1
- Wise 1
- York 1
state 1
- Virginia · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453723 | 2453723 | 2022-04-28 | Lexington city | Virginia | 51678 | 2840 | 40 |
1894371 | 1894371 | 2021-11-07 | Powhatan | Virginia | 51145 | 2840 | 28 |
1891121 | 1891121 | 2021-11-06 | Powhatan | Virginia | 51145 | 2840 | 28 |
1887871 | 1887871 | 2021-11-05 | Powhatan | Virginia | 51145 | 2840 | 28 |
1491515 | 1491515 | 2021-07-06 | Halifax | Virginia | 51083 | 2840 | 78 |
1488268 | 1488268 | 2021-07-05 | Halifax | Virginia | 51083 | 2840 | 78 |
1485021 | 1485021 | 2021-07-04 | Halifax | Virginia | 51083 | 2840 | 78 |
1481775 | 1481775 | 2021-07-03 | Halifax | Virginia | 51083 | 2840 | 78 |
1478528 | 1478528 | 2021-07-02 | Halifax | Virginia | 51083 | 2840 | 78 |
1475282 | 1475282 | 2021-07-01 | Halifax | Virginia | 51083 | 2840 | 78 |
1332412 | 1332412 | 2021-05-18 | Accomack | Virginia | 51001 | 2840 | 41 |
1329165 | 1329165 | 2021-05-17 | Accomack | Virginia | 51001 | 2840 | 41 |
1254617 | 1254617 | 2021-04-24 | Warren | Virginia | 51187 | 2840 | 55 |
1063051 | 1063051 | 2021-02-24 | Wise | Virginia | 51195 | 2840 | 86 |
1033842 | 1033842 | 2021-02-15 | York | Virginia | 51199 | 2840 | 21 |
939709 | 939709 | 2021-01-17 | Tazewell | Virginia | 51185 | 2840 | 28 |
920148 | 920148 | 2021-01-11 | Danville city | Virginia | 51590 | 2840 | 63 |
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);