ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where deaths = 116 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Harrisonburg city 21
- Isle of Wight 12
- Montgomery 12
- Rockingham 9
- Mecklenburg 8
- Page 8
- Bedford 7
- Stafford 7
- Campbell 3
- Carroll 3
- James City 3
- Roanoke city 3
- Wythe 3
- Franklin 2
- Spotsylvania 2
- Staunton city 2
- Virginia Beach city 2
- Warren 2
- Wise 2
- Arlington 1
- Augusta 1
- Buchanan 1
- Chesapeake city 1
- Danville city 1
- Hampton city 1
- Hanover 1
- Newport News city 1
- Richmond city 1
- Smyth 1
- Suffolk city 1
- …
state 1
- Virginia · 123 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496112 | 2496112 | 2022-05-11 | Staunton city | Virginia | 51790 | 5781 | 116 |
2492854 | 2492854 | 2022-05-10 | Staunton city | Virginia | 51790 | 5752 | 116 |
2466739 | 2466739 | 2022-05-02 | Isle of Wight | Virginia | 51093 | 7348 | 116 |
2463484 | 2463484 | 2022-05-01 | Isle of Wight | Virginia | 51093 | 7330 | 116 |
2460228 | 2460228 | 2022-04-30 | Isle of Wight | Virginia | 51093 | 7330 | 116 |
2456972 | 2456972 | 2022-04-29 | Isle of Wight | Virginia | 51093 | 7330 | 116 |
2447203 | 2447203 | 2022-04-26 | Isle of Wight | Virginia | 51093 | 7315 | 116 |
2443948 | 2443948 | 2022-04-25 | Isle of Wight | Virginia | 51093 | 7309 | 116 |
2440692 | 2440692 | 2022-04-24 | Isle of Wight | Virginia | 51093 | 7292 | 116 |
2437436 | 2437436 | 2022-04-23 | Isle of Wight | Virginia | 51093 | 7292 | 116 |
2434180 | 2434180 | 2022-04-22 | Isle of Wight | Virginia | 51093 | 7292 | 116 |
2430924 | 2430924 | 2022-04-21 | Isle of Wight | Virginia | 51093 | 7285 | 116 |
2427668 | 2427668 | 2022-04-20 | Isle of Wight | Virginia | 51093 | 7288 | 116 |
2424412 | 2424412 | 2022-04-19 | Isle of Wight | Virginia | 51093 | 7284 | 116 |
2404829 | 2404829 | 2022-04-13 | Buchanan | Virginia | 51027 | 4878 | 116 |
2378851 | 2378851 | 2022-04-05 | Mecklenburg | Virginia | 51117 | 6053 | 116 |
2375597 | 2375597 | 2022-04-04 | Mecklenburg | Virginia | 51117 | 6051 | 116 |
2372345 | 2372345 | 2022-04-03 | Mecklenburg | Virginia | 51117 | 6050 | 116 |
2369092 | 2369092 | 2022-04-02 | Mecklenburg | Virginia | 51117 | 6050 | 116 |
2365839 | 2365839 | 2022-04-01 | Mecklenburg | Virginia | 51117 | 6050 | 116 |
2362586 | 2362586 | 2022-03-31 | Mecklenburg | Virginia | 51117 | 6042 | 116 |
2359332 | 2359332 | 2022-03-30 | Mecklenburg | Virginia | 51117 | 6041 | 116 |
2356078 | 2356078 | 2022-03-29 | Mecklenburg | Virginia | 51117 | 6041 | 116 |
2313771 | 2313771 | 2022-03-16 | James City | Virginia | 51095 | 14719 | 116 |
2310518 | 2310518 | 2022-03-15 | James City | Virginia | 51095 | 14712 | 116 |
2307265 | 2307265 | 2022-03-14 | James City | Virginia | 51095 | 14707 | 116 |
2284530 | 2284530 | 2022-03-07 | Page | Virginia | 51139 | 5524 | 116 |
2281278 | 2281278 | 2022-03-06 | Page | Virginia | 51139 | 5519 | 116 |
2278025 | 2278025 | 2022-03-05 | Page | Virginia | 51139 | 5519 | 116 |
2274772 | 2274772 | 2022-03-04 | Page | Virginia | 51139 | 5519 | 116 |
2271519 | 2271519 | 2022-03-03 | Page | Virginia | 51139 | 5519 | 116 |
2268267 | 2268267 | 2022-03-02 | Page | Virginia | 51139 | 5517 | 116 |
2265014 | 2265014 | 2022-03-01 | Page | Virginia | 51139 | 5512 | 116 |
2261764 | 2261764 | 2022-02-28 | Page | Virginia | 51139 | 5509 | 116 |
2157725 | 2157725 | 2022-01-27 | Warren | Virginia | 51187 | 7918 | 116 |
2154368 | 2154368 | 2022-01-26 | Carroll | Virginia | 51035 | 5776 | 116 |
2154472 | 2154472 | 2022-01-26 | Warren | Virginia | 51187 | 7885 | 116 |
2151115 | 2151115 | 2022-01-25 | Carroll | Virginia | 51035 | 5693 | 116 |
2147863 | 2147863 | 2022-01-24 | Carroll | Virginia | 51035 | 5644 | 116 |
2099110 | 2099110 | 2022-01-09 | Harrisonburg city | Virginia | 51660 | 9705 | 116 |
2095859 | 2095859 | 2022-01-08 | Harrisonburg city | Virginia | 51660 | 9705 | 116 |
2092607 | 2092607 | 2022-01-07 | Harrisonburg city | Virginia | 51660 | 9705 | 116 |
2089355 | 2089355 | 2022-01-06 | Harrisonburg city | Virginia | 51660 | 9589 | 116 |
2086104 | 2086104 | 2022-01-05 | Harrisonburg city | Virginia | 51660 | 9454 | 116 |
2082852 | 2082852 | 2022-01-04 | Harrisonburg city | Virginia | 51660 | 9397 | 116 |
2082912 | 2082912 | 2022-01-04 | Stafford | Virginia | 51179 | 22050 | 116 |
2079600 | 2079600 | 2022-01-03 | Harrisonburg city | Virginia | 51660 | 9306 | 116 |
2079660 | 2079660 | 2022-01-03 | Stafford | Virginia | 51179 | 21210 | 116 |
2076348 | 2076348 | 2022-01-02 | Harrisonburg city | Virginia | 51660 | 9119 | 116 |
2076408 | 2076408 | 2022-01-02 | Stafford | Virginia | 51179 | 20210 | 116 |
2073097 | 2073097 | 2022-01-01 | Harrisonburg city | Virginia | 51660 | 9119 | 116 |
2073157 | 2073157 | 2022-01-01 | Stafford | Virginia | 51179 | 20210 | 116 |
2069846 | 2069846 | 2021-12-31 | Harrisonburg city | Virginia | 51660 | 9119 | 116 |
2069906 | 2069906 | 2021-12-31 | Stafford | Virginia | 51179 | 20210 | 116 |
2066595 | 2066595 | 2021-12-30 | Harrisonburg city | Virginia | 51660 | 9061 | 116 |
2066655 | 2066655 | 2021-12-30 | Stafford | Virginia | 51179 | 19785 | 116 |
2063345 | 2063345 | 2021-12-29 | Harrisonburg city | Virginia | 51660 | 9009 | 116 |
2063405 | 2063405 | 2021-12-29 | Stafford | Virginia | 51179 | 19484 | 116 |
2060095 | 2060095 | 2021-12-28 | Harrisonburg city | Virginia | 51660 | 8961 | 116 |
2056846 | 2056846 | 2021-12-27 | Harrisonburg city | Virginia | 51660 | 8951 | 116 |
2053597 | 2053597 | 2021-12-26 | Harrisonburg city | Virginia | 51660 | 8910 | 116 |
2050347 | 2050347 | 2021-12-25 | Harrisonburg city | Virginia | 51660 | 8910 | 116 |
2047097 | 2047097 | 2021-12-24 | Harrisonburg city | Virginia | 51660 | 8910 | 116 |
2043847 | 2043847 | 2021-12-23 | Harrisonburg city | Virginia | 51660 | 8880 | 116 |
2043921 | 2043921 | 2021-12-23 | Wythe | Virginia | 51197 | 5044 | 116 |
2040598 | 2040598 | 2021-12-22 | Harrisonburg city | Virginia | 51660 | 8867 | 116 |
2040672 | 2040672 | 2021-12-22 | Wythe | Virginia | 51197 | 5033 | 116 |
2037348 | 2037348 | 2021-12-21 | Harrisonburg city | Virginia | 51660 | 8840 | 116 |
2037422 | 2037422 | 2021-12-21 | Wythe | Virginia | 51197 | 5017 | 116 |
2034098 | 2034098 | 2021-12-20 | Harrisonburg city | Virginia | 51660 | 8821 | 116 |
2017830 | 2017830 | 2021-12-15 | Franklin | Virginia | 51067 | 6902 | 116 |
2014580 | 2014580 | 2021-12-14 | Franklin | Virginia | 51067 | 6868 | 116 |
2011367 | 2011367 | 2021-12-13 | Montgomery | Virginia | 51121 | 12445 | 116 |
2008116 | 2008116 | 2021-12-12 | Montgomery | Virginia | 51121 | 12379 | 116 |
2004865 | 2004865 | 2021-12-11 | Montgomery | Virginia | 51121 | 12379 | 116 |
2001614 | 2001614 | 2021-12-10 | Montgomery | Virginia | 51121 | 12379 | 116 |
1998364 | 1998364 | 2021-12-09 | Montgomery | Virginia | 51121 | 12356 | 116 |
1995113 | 1995113 | 2021-12-08 | Montgomery | Virginia | 51121 | 12329 | 116 |
1991862 | 1991862 | 2021-12-07 | Montgomery | Virginia | 51121 | 12297 | 116 |
1988611 | 1988611 | 2021-12-06 | Montgomery | Virginia | 51121 | 12269 | 116 |
1985361 | 1985361 | 2021-12-05 | Montgomery | Virginia | 51121 | 12221 | 116 |
1982111 | 1982111 | 2021-12-04 | Montgomery | Virginia | 51121 | 12221 | 116 |
1978861 | 1978861 | 2021-12-03 | Montgomery | Virginia | 51121 | 12221 | 116 |
1975611 | 1975611 | 2021-12-02 | Montgomery | Virginia | 51121 | 12196 | 116 |
1949647 | 1949647 | 2021-11-24 | Tazewell | Virginia | 51185 | 6019 | 116 |
1852148 | 1852148 | 2021-10-25 | Smyth | Virginia | 51173 | 4837 | 116 |
1816300 | 1816300 | 2021-10-14 | Augusta | Virginia | 51015 | 10004 | 116 |
1741694 | 1741694 | 2021-09-21 | Wise | Virginia | 51195 | 4400 | 116 |
1738445 | 1738445 | 2021-09-20 | Wise | Virginia | 51195 | 4364 | 116 |
1722077 | 1722077 | 2021-09-15 | Bedford | Virginia | 51019 | 8551 | 116 |
1718829 | 1718829 | 2021-09-14 | Bedford | Virginia | 51019 | 8483 | 116 |
1715581 | 1715581 | 2021-09-13 | Bedford | Virginia | 51019 | 8417 | 116 |
1712335 | 1712335 | 2021-09-12 | Bedford | Virginia | 51019 | 8294 | 116 |
1709088 | 1709088 | 2021-09-11 | Bedford | Virginia | 51019 | 8294 | 116 |
1705841 | 1705841 | 2021-09-10 | Bedford | Virginia | 51019 | 8294 | 116 |
1702591 | 1702591 | 2021-09-09 | Bedford | Virginia | 51019 | 8137 | 116 |
1699350 | 1699350 | 2021-09-08 | Campbell | Virginia | 51031 | 5892 | 116 |
1696102 | 1696102 | 2021-09-07 | Campbell | Virginia | 51031 | 5844 | 116 |
1696193 | 1696193 | 2021-09-07 | Rockingham | Virginia | 51165 | 7838 | 116 |
1692854 | 1692854 | 2021-09-06 | Campbell | Virginia | 51031 | 5823 | 116 |
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);