ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where deaths = 308 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 7
state 1
- Virginia · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2281283 | 2281283 | 2022-03-06 | Portsmouth city | Virginia | 51740 | 20613 | 308 |
2278030 | 2278030 | 2022-03-05 | Portsmouth city | Virginia | 51740 | 20613 | 308 |
2274777 | 2274777 | 2022-03-04 | Portsmouth city | Virginia | 51740 | 20613 | 308 |
2238923 | 2238923 | 2022-02-21 | Arlington | Virginia | 51013 | 39923 | 308 |
2203257 | 2203257 | 2022-02-10 | Roanoke city | Virginia | 51770 | 20319 | 308 |
2034111 | 2034111 | 2021-12-20 | Loudoun | Virginia | 51107 | 38699 | 308 |
2030861 | 2030861 | 2021-12-19 | Loudoun | Virginia | 51107 | 38086 | 308 |
2027610 | 2027610 | 2021-12-18 | Loudoun | Virginia | 51107 | 38086 | 308 |
2024359 | 2024359 | 2021-12-17 | Loudoun | Virginia | 51107 | 38086 | 308 |
2021122 | 2021122 | 2021-12-16 | Newport News city | Virginia | 51700 | 21757 | 308 |
2017871 | 2017871 | 2021-12-15 | Newport News city | Virginia | 51700 | 21708 | 308 |
1497979 | 1497979 | 2021-07-08 | Chesapeake city | Virginia | 51550 | 21317 | 308 |
1494732 | 1494732 | 2021-07-07 | Chesapeake city | Virginia | 51550 | 21301 | 308 |
1491485 | 1491485 | 2021-07-06 | Chesapeake city | Virginia | 51550 | 21288 | 308 |
1488238 | 1488238 | 2021-07-05 | Chesapeake city | Virginia | 51550 | 21282 | 308 |
1484991 | 1484991 | 2021-07-04 | Chesapeake city | Virginia | 51550 | 21279 | 308 |
978630 | 978630 | 2021-01-29 | Prince William | Virginia | 51153 | 34751 | 308 |
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);