ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 207 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Roanoke city 8
- Portsmouth city 7
- Rockingham 5
- Hanover 4
- Augusta 3
- Washington 3
- Arlington 1
- Campbell 1
- Chesterfield 1
- Loudoun 1
- Lynchburg city 1
- Newport News city 1
- Prince William 1
- Roanoke 1
- Suffolk city 1
state 1
- Virginia · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2443894 | 2443894 | 2022-04-25 | Augusta | Virginia | 51015 | 18495 | 207 |
2382045 | 2382045 | 2022-04-06 | Campbell | Virginia | 51031 | 11964 | 207 |
2333235 | 2333235 | 2022-03-22 | Augusta | Virginia | 51015 | 18909 | 207 |
2329982 | 2329982 | 2022-03-21 | Augusta | Virginia | 51015 | 18909 | 207 |
2281312 | 2281312 | 2022-03-06 | Washington | Virginia | 51191 | 13605 | 207 |
2278059 | 2278059 | 2022-03-05 | Washington | Virginia | 51191 | 13605 | 207 |
2274806 | 2274806 | 2022-03-04 | Washington | Virginia | 51191 | 13605 | 207 |
2239025 | 2239025 | 2022-02-21 | Rockingham | Virginia | 51165 | 14252 | 207 |
2235774 | 2235774 | 2022-02-20 | Rockingham | Virginia | 51165 | 14205 | 207 |
2232523 | 2232523 | 2022-02-19 | Rockingham | Virginia | 51165 | 14205 | 207 |
2229272 | 2229272 | 2022-02-18 | Rockingham | Virginia | 51165 | 14205 | 207 |
2226021 | 2226021 | 2022-02-17 | Rockingham | Virginia | 51165 | 14180 | 207 |
2173978 | 2173978 | 2022-02-01 | Roanoke | Virginia | 51161 | 19250 | 207 |
2056845 | 2056845 | 2021-12-27 | Hanover | Virginia | 51085 | 13894 | 207 |
2053596 | 2053596 | 2021-12-26 | Hanover | Virginia | 51085 | 13661 | 207 |
2050346 | 2050346 | 2021-12-25 | Hanover | Virginia | 51085 | 13661 | 207 |
2047096 | 2047096 | 2021-12-24 | Hanover | Virginia | 51085 | 13661 | 207 |
2037364 | 2037364 | 2021-12-21 | Lynchburg city | Virginia | 51680 | 12525 | 207 |
1741683 | 1741683 | 2021-09-21 | Suffolk city | Virginia | 51800 | 9956 | 207 |
1696191 | 1696191 | 2021-09-07 | Roanoke city | Virginia | 51770 | 10074 | 207 |
1692943 | 1692943 | 2021-09-06 | Roanoke city | Virginia | 51770 | 10054 | 207 |
1689694 | 1689694 | 2021-09-05 | Roanoke city | Virginia | 51770 | 9966 | 207 |
1686444 | 1686444 | 2021-09-04 | Roanoke city | Virginia | 51770 | 9966 | 207 |
1683193 | 1683193 | 2021-09-03 | Roanoke city | Virginia | 51770 | 9966 | 207 |
1679943 | 1679943 | 2021-09-02 | Roanoke city | Virginia | 51770 | 9874 | 207 |
1676695 | 1676695 | 2021-09-01 | Roanoke city | Virginia | 51770 | 9810 | 207 |
1673448 | 1673448 | 2021-08-31 | Roanoke city | Virginia | 51770 | 9766 | 207 |
1644206 | 1644206 | 2021-08-22 | Portsmouth city | Virginia | 51740 | 10025 | 207 |
1640956 | 1640956 | 2021-08-21 | Portsmouth city | Virginia | 51740 | 10025 | 207 |
1637706 | 1637706 | 2021-08-20 | Portsmouth city | Virginia | 51740 | 10025 | 207 |
1634456 | 1634456 | 2021-08-19 | Portsmouth city | Virginia | 51740 | 9974 | 207 |
1631208 | 1631208 | 2021-08-18 | Portsmouth city | Virginia | 51740 | 9934 | 207 |
1627961 | 1627961 | 2021-08-17 | Portsmouth city | Virginia | 51740 | 9894 | 207 |
1624714 | 1624714 | 2021-08-16 | Portsmouth city | Virginia | 51740 | 9849 | 207 |
1163643 | 1163643 | 2021-03-27 | Newport News city | Virginia | 51700 | 12525 | 207 |
1062991 | 1062991 | 2021-02-24 | Loudoun | Virginia | 51107 | 22816 | 207 |
1010999 | 1010999 | 2021-02-08 | Arlington | Virginia | 51013 | 12262 | 207 |
994787 | 994787 | 2021-02-03 | Chesterfield | Virginia | 51041 | 19563 | 207 |
589265 | 589265 | 2020-10-01 | Prince William | Virginia | 51153 | 12594 | 207 |
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);