ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 216 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Chesterfield 8
- Roanoke city 8
- Lynchburg city 7
- Prince William 4
- Henry 3
- Rockingham 3
- Hampton city 2
- Augusta 1
- Hanover 1
- Henrico 1
- Newport News city 1
- Portsmouth city 1
- Richmond city 1
- Shenandoah 1
- Spotsylvania 1
state 1
- Virginia · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424358 | 2424358 | 2022-04-19 | Augusta | Virginia | 51015 | 19073 | 216 |
2258531 | 2258531 | 2022-02-27 | Rockingham | Virginia | 51165 | 14310 | 216 |
2255280 | 2255280 | 2022-02-26 | Rockingham | Virginia | 51165 | 14310 | 216 |
2252029 | 2252029 | 2022-02-25 | Rockingham | Virginia | 51165 | 14310 | 216 |
2226025 | 2226025 | 2022-02-17 | Shenandoah | Virginia | 51171 | 10552 | 216 |
2177181 | 2177181 | 2022-02-02 | Hanover | Virginia | 51085 | 20109 | 216 |
2177241 | 2177241 | 2022-02-02 | Spotsylvania | Virginia | 51177 | 25086 | 216 |
2167426 | 2167426 | 2022-01-30 | Henry | Virginia | 51089 | 10056 | 216 |
2164171 | 2164171 | 2022-01-29 | Henry | Virginia | 51089 | 10056 | 216 |
2160916 | 2160916 | 2022-01-28 | Henry | Virginia | 51089 | 10056 | 216 |
2089371 | 2089371 | 2022-01-06 | Lynchburg city | Virginia | 51680 | 14023 | 216 |
2086120 | 2086120 | 2022-01-05 | Lynchburg city | Virginia | 51680 | 13853 | 216 |
2082868 | 2082868 | 2022-01-04 | Lynchburg city | Virginia | 51680 | 13799 | 216 |
2079616 | 2079616 | 2022-01-03 | Lynchburg city | Virginia | 51680 | 13668 | 216 |
2076364 | 2076364 | 2022-01-02 | Lynchburg city | Virginia | 51680 | 13205 | 216 |
2073113 | 2073113 | 2022-01-01 | Lynchburg city | Virginia | 51680 | 13205 | 216 |
2069862 | 2069862 | 2021-12-31 | Lynchburg city | Virginia | 51680 | 13205 | 216 |
1783909 | 1783909 | 2021-10-04 | Roanoke city | Virginia | 51770 | 11409 | 216 |
1780660 | 1780660 | 2021-10-03 | Roanoke city | Virginia | 51770 | 11280 | 216 |
1777410 | 1777410 | 2021-10-02 | Roanoke city | Virginia | 51770 | 11280 | 216 |
1774160 | 1774160 | 2021-10-01 | Roanoke city | Virginia | 51770 | 11280 | 216 |
1770910 | 1770910 | 2021-09-30 | Roanoke city | Virginia | 51770 | 11193 | 216 |
1767609 | 1767609 | 2021-09-29 | Hampton city | Virginia | 51650 | 14186 | 216 |
1767661 | 1767661 | 2021-09-29 | Roanoke city | Virginia | 51770 | 11129 | 216 |
1764360 | 1764360 | 2021-09-28 | Hampton city | Virginia | 51650 | 14151 | 216 |
1764412 | 1764412 | 2021-09-28 | Roanoke city | Virginia | 51770 | 11088 | 216 |
1761163 | 1761163 | 2021-09-27 | Roanoke city | Virginia | 51770 | 11062 | 216 |
1738411 | 1738411 | 2021-09-20 | Portsmouth city | Virginia | 51740 | 11505 | 216 |
1215608 | 1215608 | 2021-04-12 | Newport News city | Virginia | 51700 | 13160 | 216 |
1098730 | 1098730 | 2021-03-07 | Richmond city | Virginia | 51760 | 15021 | 216 |
1046715 | 1046715 | 2021-02-19 | Chesterfield | Virginia | 51041 | 22835 | 216 |
1043470 | 1043470 | 2021-02-18 | Chesterfield | Virginia | 51041 | 22708 | 216 |
1036980 | 1036980 | 2021-02-16 | Chesterfield | Virginia | 51041 | 22541 | 216 |
1027242 | 1027242 | 2021-02-13 | Chesterfield | Virginia | 51041 | 22019 | 216 |
1023997 | 1023997 | 2021-02-12 | Chesterfield | Virginia | 51041 | 21701 | 216 |
1020752 | 1020752 | 2021-02-11 | Chesterfield | Virginia | 51041 | 21469 | 216 |
1017507 | 1017507 | 2021-02-10 | Chesterfield | Virginia | 51041 | 21131 | 216 |
1014262 | 1014262 | 2021-02-09 | Chesterfield | Virginia | 51041 | 20876 | 216 |
637906 | 637906 | 2020-10-16 | Prince William | Virginia | 51153 | 13451 | 216 |
634661 | 634661 | 2020-10-15 | Prince William | Virginia | 51153 | 13390 | 216 |
631416 | 631416 | 2020-10-14 | Prince William | Virginia | 51153 | 13311 | 216 |
628172 | 628172 | 2020-10-13 | Prince William | Virginia | 51153 | 13281 | 216 |
585982 | 585982 | 2020-09-30 | Henrico | Virginia | 51087 | 5491 | 216 |
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);