ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where deaths = 195 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 22
county 22
- Danville city 14
- Lynchburg city 14
- Pittsylvania 7
- Campbell 6
- Franklin 5
- Henrico 5
- Hanover 4
- Loudoun 4
- Roanoke 4
- Rockingham 4
- Spotsylvania 4
- Suffolk city 4
- Wise 3
- Portsmouth city 2
- Shenandoah 2
- Virginia Beach city 2
- Arlington 1
- Augusta 1
- Chesterfield 1
- Henry 1
- Norfolk city 1
- Washington 1
state 1
- Virginia · 90 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440673 | 2440673 | 2022-04-24 | Franklin | Virginia | 51067 | 10813 | 195 |
2437417 | 2437417 | 2022-04-23 | Franklin | Virginia | 51067 | 10813 | 195 |
2434161 | 2434161 | 2022-04-22 | Franklin | Virginia | 51067 | 10813 | 195 |
2430905 | 2430905 | 2022-04-21 | Franklin | Virginia | 51067 | 10807 | 195 |
2427649 | 2427649 | 2022-04-20 | Franklin | Virginia | 51067 | 10801 | 195 |
2404944 | 2404944 | 2022-04-13 | Wise | Virginia | 51195 | 10248 | 195 |
2401653 | 2401653 | 2022-04-12 | Pittsylvania | Virginia | 51143 | 14020 | 195 |
2401689 | 2401689 | 2022-04-12 | Wise | Virginia | 51195 | 10248 | 195 |
2398398 | 2398398 | 2022-04-11 | Pittsylvania | Virginia | 51143 | 14025 | 195 |
2398434 | 2398434 | 2022-04-11 | Wise | Virginia | 51195 | 10248 | 195 |
2395143 | 2395143 | 2022-04-10 | Pittsylvania | Virginia | 51143 | 14021 | 195 |
2391887 | 2391887 | 2022-04-09 | Pittsylvania | Virginia | 51143 | 14021 | 195 |
2388631 | 2388631 | 2022-04-08 | Pittsylvania | Virginia | 51143 | 14021 | 195 |
2385376 | 2385376 | 2022-04-07 | Pittsylvania | Virginia | 51143 | 14002 | 195 |
2382121 | 2382121 | 2022-04-06 | Pittsylvania | Virginia | 51143 | 13981 | 195 |
2313726 | 2313726 | 2022-03-16 | Campbell | Virginia | 51031 | 11603 | 195 |
2310473 | 2310473 | 2022-03-15 | Campbell | Virginia | 51031 | 11585 | 195 |
2307220 | 2307220 | 2022-03-14 | Campbell | Virginia | 51031 | 11555 | 195 |
2303969 | 2303969 | 2022-03-13 | Campbell | Virginia | 51031 | 11534 | 195 |
2300717 | 2300717 | 2022-03-12 | Campbell | Virginia | 51031 | 11534 | 195 |
2297465 | 2297465 | 2022-03-11 | Campbell | Virginia | 51031 | 11534 | 195 |
2248677 | 2248677 | 2022-02-24 | Augusta | Virginia | 51015 | 18640 | 195 |
2196767 | 2196767 | 2022-02-08 | Washington | Virginia | 51191 | 12778 | 195 |
2190243 | 2190243 | 2022-02-06 | Rockingham | Virginia | 51165 | 13788 | 195 |
2186990 | 2186990 | 2022-02-05 | Rockingham | Virginia | 51165 | 13788 | 195 |
2183737 | 2183737 | 2022-02-04 | Rockingham | Virginia | 51165 | 13788 | 195 |
2180485 | 2180485 | 2022-02-03 | Rockingham | Virginia | 51165 | 13719 | 195 |
2173985 | 2173985 | 2022-02-01 | Shenandoah | Virginia | 51171 | 10189 | 195 |
2170733 | 2170733 | 2022-01-31 | Shenandoah | Virginia | 51171 | 10140 | 195 |
2125182 | 2125182 | 2022-01-17 | Spotsylvania | Virginia | 51177 | 22707 | 195 |
2121930 | 2121930 | 2022-01-16 | Spotsylvania | Virginia | 51177 | 22222 | 195 |
2118678 | 2118678 | 2022-01-15 | Spotsylvania | Virginia | 51177 | 22222 | 195 |
2115426 | 2115426 | 2022-01-14 | Spotsylvania | Virginia | 51177 | 22222 | 195 |
2079649 | 2079649 | 2022-01-03 | Roanoke | Virginia | 51161 | 14563 | 195 |
2076397 | 2076397 | 2022-01-02 | Roanoke | Virginia | 51161 | 14245 | 195 |
2073146 | 2073146 | 2022-01-01 | Roanoke | Virginia | 51161 | 14245 | 195 |
2069895 | 2069895 | 2021-12-31 | Roanoke | Virginia | 51161 | 14245 | 195 |
2034100 | 2034100 | 2021-12-20 | Henry | Virginia | 51089 | 7419 | 195 |
1991854 | 1991854 | 2021-12-07 | Lynchburg city | Virginia | 51680 | 12221 | 195 |
1988603 | 1988603 | 2021-12-06 | Lynchburg city | Virginia | 51680 | 12199 | 195 |
1969104 | 1969104 | 2021-11-30 | Lynchburg city | Virginia | 51680 | 12017 | 195 |
1965854 | 1965854 | 2021-11-29 | Lynchburg city | Virginia | 51680 | 12001 | 195 |
1962602 | 1962602 | 2021-11-28 | Lynchburg city | Virginia | 51680 | 11970 | 195 |
1959351 | 1959351 | 2021-11-27 | Lynchburg city | Virginia | 51680 | 11970 | 195 |
1956100 | 1956100 | 2021-11-26 | Lynchburg city | Virginia | 51680 | 11970 | 195 |
1952849 | 1952849 | 2021-11-25 | Lynchburg city | Virginia | 51680 | 11946 | 195 |
1949598 | 1949598 | 2021-11-24 | Lynchburg city | Virginia | 51680 | 11934 | 195 |
1946347 | 1946347 | 2021-11-23 | Lynchburg city | Virginia | 51680 | 11942 | 195 |
1943096 | 1943096 | 2021-11-22 | Lynchburg city | Virginia | 51680 | 11943 | 195 |
1939805 | 1939805 | 2021-11-21 | Danville city | Virginia | 51590 | 6415 | 195 |
1939846 | 1939846 | 2021-11-21 | Lynchburg city | Virginia | 51680 | 11908 | 195 |
1936555 | 1936555 | 2021-11-20 | Danville city | Virginia | 51590 | 6415 | 195 |
1936596 | 1936596 | 2021-11-20 | Lynchburg city | Virginia | 51680 | 11908 | 195 |
1933305 | 1933305 | 2021-11-19 | Danville city | Virginia | 51590 | 6415 | 195 |
1933346 | 1933346 | 2021-11-19 | Lynchburg city | Virginia | 51680 | 11908 | 195 |
1930053 | 1930053 | 2021-11-18 | Danville city | Virginia | 51590 | 6395 | 195 |
1926803 | 1926803 | 2021-11-17 | Danville city | Virginia | 51590 | 6392 | 195 |
1923553 | 1923553 | 2021-11-16 | Danville city | Virginia | 51590 | 6364 | 195 |
1920304 | 1920304 | 2021-11-15 | Danville city | Virginia | 51590 | 6353 | 195 |
1917054 | 1917054 | 2021-11-14 | Danville city | Virginia | 51590 | 6338 | 195 |
1913804 | 1913804 | 2021-11-13 | Danville city | Virginia | 51590 | 6338 | 195 |
1910554 | 1910554 | 2021-11-12 | Danville city | Virginia | 51590 | 6338 | 195 |
1907305 | 1907305 | 2021-11-11 | Danville city | Virginia | 51590 | 6331 | 195 |
1904056 | 1904056 | 2021-11-10 | Danville city | Virginia | 51590 | 6330 | 195 |
1900806 | 1900806 | 2021-11-09 | Danville city | Virginia | 51590 | 6312 | 195 |
1897556 | 1897556 | 2021-11-08 | Danville city | Virginia | 51590 | 6317 | 195 |
1861837 | 1861837 | 2021-10-28 | Hanover | Virginia | 51085 | 11762 | 195 |
1858588 | 1858588 | 2021-10-27 | Hanover | Virginia | 51085 | 11737 | 195 |
1855339 | 1855339 | 2021-10-26 | Hanover | Virginia | 51085 | 11721 | 195 |
1852090 | 1852090 | 2021-10-25 | Hanover | Virginia | 51085 | 11703 | 195 |
1624737 | 1624737 | 2021-08-16 | Suffolk city | Virginia | 51800 | 8659 | 195 |
1621490 | 1621490 | 2021-08-15 | Suffolk city | Virginia | 51800 | 8584 | 195 |
1618242 | 1618242 | 2021-08-14 | Suffolk city | Virginia | 51800 | 8584 | 195 |
1614994 | 1614994 | 2021-08-13 | Suffolk city | Virginia | 51800 | 8584 | 195 |
1326015 | 1326015 | 2021-05-16 | Portsmouth city | Virginia | 51740 | 9065 | 195 |
1322769 | 1322769 | 2021-05-15 | Portsmouth city | Virginia | 51740 | 9065 | 195 |
1079233 | 1079233 | 2021-03-01 | Norfolk city | Virginia | 51710 | 14935 | 195 |
1046760 | 1046760 | 2021-02-19 | Loudoun | Virginia | 51107 | 22486 | 195 |
1043515 | 1043515 | 2021-02-18 | Loudoun | Virginia | 51107 | 22405 | 195 |
1040270 | 1040270 | 2021-02-17 | Loudoun | Virginia | 51107 | 22351 | 195 |
1037025 | 1037025 | 2021-02-16 | Loudoun | Virginia | 51107 | 22310 | 195 |
972163 | 972163 | 2021-01-27 | Virginia Beach city | Virginia | 51810 | 25199 | 195 |
968918 | 968918 | 2021-01-26 | Virginia Beach city | Virginia | 51810 | 24918 | 195 |
955840 | 955840 | 2021-01-22 | Chesterfield | Virginia | 51041 | 17408 | 195 |
952577 | 952577 | 2021-01-21 | Arlington | Virginia | 51013 | 10954 | 195 |
530923 | 530923 | 2020-09-13 | Henrico | Virginia | 51087 | 5037 | 195 |
527686 | 527686 | 2020-09-12 | Henrico | Virginia | 51087 | 5000 | 195 |
524450 | 524450 | 2020-09-11 | Henrico | Virginia | 51087 | 4966 | 195 |
521214 | 521214 | 2020-09-10 | Henrico | Virginia | 51087 | 4925 | 195 |
517977 | 517977 | 2020-09-09 | Henrico | Virginia | 51087 | 4872 | 195 |
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);