ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where deaths = 140 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Fauquier 24
- Augusta 21
- Petersburg city 13
- Alexandria city 12
- Smyth 10
- Danville city 8
- Montgomery 7
- Franklin 6
- Spotsylvania 6
- Wythe 4
- Halifax 3
- Hampton city 3
- Henry 3
- Washington 3
- Harrisonburg city 2
- Henrico 2
- Lynchburg city 2
- Pittsylvania 2
- Virginia Beach city 2
- Albemarle 1
- Arlington 1
- Carroll 1
- Frederick 1
- Hanover 1
- Newport News city 1
- Portsmouth city 1
- Richmond city 1
- Roanoke 1
- Rockingham 1
- Shenandoah 1
- …
state 1
- Virginia · 146 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502603 | 2502603 | 2022-05-13 | Petersburg city | Virginia | 51730 | 8297 | 140 |
2499345 | 2499345 | 2022-05-12 | Petersburg city | Virginia | 51730 | 8300 | 140 |
2496087 | 2496087 | 2022-05-11 | Petersburg city | Virginia | 51730 | 8301 | 140 |
2492829 | 2492829 | 2022-05-10 | Petersburg city | Virginia | 51730 | 8299 | 140 |
2489571 | 2489571 | 2022-05-09 | Petersburg city | Virginia | 51730 | 8291 | 140 |
2486314 | 2486314 | 2022-05-08 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2483056 | 2483056 | 2022-05-07 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2479798 | 2479798 | 2022-05-06 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2476540 | 2476540 | 2022-05-05 | Petersburg city | Virginia | 51730 | 8279 | 140 |
2473282 | 2473282 | 2022-05-04 | Petersburg city | Virginia | 51730 | 8273 | 140 |
2470026 | 2470026 | 2022-05-03 | Petersburg city | Virginia | 51730 | 8274 | 140 |
2466770 | 2466770 | 2022-05-02 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2385322 | 2385322 | 2022-04-07 | Fauquier | Virginia | 51061 | 13020 | 140 |
2382067 | 2382067 | 2022-04-06 | Fauquier | Virginia | 51061 | 13021 | 140 |
2378812 | 2378812 | 2022-04-05 | Fauquier | Virginia | 51061 | 13022 | 140 |
2375558 | 2375558 | 2022-04-04 | Fauquier | Virginia | 51061 | 13012 | 140 |
2372306 | 2372306 | 2022-04-03 | Fauquier | Virginia | 51061 | 13010 | 140 |
2369053 | 2369053 | 2022-04-02 | Fauquier | Virginia | 51061 | 13010 | 140 |
2365800 | 2365800 | 2022-04-01 | Fauquier | Virginia | 51061 | 13010 | 140 |
2362547 | 2362547 | 2022-03-31 | Fauquier | Virginia | 51061 | 13008 | 140 |
2359293 | 2359293 | 2022-03-30 | Fauquier | Virginia | 51061 | 13015 | 140 |
2356039 | 2356039 | 2022-03-29 | Fauquier | Virginia | 51061 | 12976 | 140 |
2352786 | 2352786 | 2022-03-28 | Fauquier | Virginia | 51061 | 12971 | 140 |
2352877 | 2352877 | 2022-03-28 | Wythe | Virginia | 51197 | 7466 | 140 |
2349534 | 2349534 | 2022-03-27 | Fauquier | Virginia | 51061 | 12972 | 140 |
2349625 | 2349625 | 2022-03-27 | Wythe | Virginia | 51197 | 7464 | 140 |
2346281 | 2346281 | 2022-03-26 | Fauquier | Virginia | 51061 | 12972 | 140 |
2346372 | 2346372 | 2022-03-26 | Wythe | Virginia | 51197 | 7464 | 140 |
2343028 | 2343028 | 2022-03-25 | Fauquier | Virginia | 51061 | 12972 | 140 |
2343119 | 2343119 | 2022-03-25 | Wythe | Virginia | 51197 | 7464 | 140 |
2339775 | 2339775 | 2022-03-24 | Fauquier | Virginia | 51061 | 12963 | 140 |
2336521 | 2336521 | 2022-03-23 | Fauquier | Virginia | 51061 | 12956 | 140 |
2333267 | 2333267 | 2022-03-22 | Fauquier | Virginia | 51061 | 12948 | 140 |
2330014 | 2330014 | 2022-03-21 | Fauquier | Virginia | 51061 | 12948 | 140 |
2326762 | 2326762 | 2022-03-20 | Fauquier | Virginia | 51061 | 12924 | 140 |
2323509 | 2323509 | 2022-03-19 | Fauquier | Virginia | 51061 | 12924 | 140 |
2320255 | 2320255 | 2022-03-18 | Fauquier | Virginia | 51061 | 12924 | 140 |
2310475 | 2310475 | 2022-03-15 | Carroll | Virginia | 51035 | 6603 | 140 |
2307295 | 2307295 | 2022-03-14 | Petersburg city | Virginia | 51730 | 8279 | 140 |
2303991 | 2303991 | 2022-03-13 | Fauquier | Virginia | 51061 | 12825 | 140 |
2300739 | 2300739 | 2022-03-12 | Fauquier | Virginia | 51061 | 12825 | 140 |
2297487 | 2297487 | 2022-03-11 | Fauquier | Virginia | 51061 | 12825 | 140 |
2271509 | 2271509 | 2022-03-03 | Montgomery | Virginia | 51121 | 18291 | 140 |
2268257 | 2268257 | 2022-03-02 | Montgomery | Virginia | 51121 | 18281 | 140 |
2265004 | 2265004 | 2022-03-01 | Montgomery | Virginia | 51121 | 18267 | 140 |
2261754 | 2261754 | 2022-02-28 | Montgomery | Virginia | 51121 | 18246 | 140 |
2258503 | 2258503 | 2022-02-27 | Montgomery | Virginia | 51121 | 18201 | 140 |
2255252 | 2255252 | 2022-02-26 | Montgomery | Virginia | 51121 | 18201 | 140 |
2252001 | 2252001 | 2022-02-25 | Montgomery | Virginia | 51121 | 18201 | 140 |
2245419 | 2245419 | 2022-02-23 | Albemarle | Virginia | 51003 | 15374 | 140 |
2245542 | 2245542 | 2022-02-23 | Warren | Virginia | 51187 | 8355 | 140 |
2235719 | 2235719 | 2022-02-20 | Halifax | Virginia | 51083 | 6804 | 140 |
2232468 | 2232468 | 2022-02-19 | Halifax | Virginia | 51083 | 6804 | 140 |
2229217 | 2229217 | 2022-02-18 | Halifax | Virginia | 51083 | 6804 | 140 |
2225969 | 2225969 | 2022-02-17 | Harrisonburg city | Virginia | 51660 | 13009 | 140 |
2222718 | 2222718 | 2022-02-16 | Harrisonburg city | Virginia | 51660 | 12987 | 140 |
2173915 | 2173915 | 2022-02-01 | Franklin | Virginia | 51067 | 9842 | 140 |
2170663 | 2170663 | 2022-01-31 | Franklin | Virginia | 51067 | 9793 | 140 |
2167410 | 2167410 | 2022-01-30 | Franklin | Virginia | 51067 | 9641 | 140 |
2164155 | 2164155 | 2022-01-29 | Franklin | Virginia | 51067 | 9641 | 140 |
2160900 | 2160900 | 2022-01-28 | Franklin | Virginia | 51067 | 9641 | 140 |
2157644 | 2157644 | 2022-01-27 | Franklin | Virginia | 51067 | 9569 | 140 |
2121928 | 2121928 | 2022-01-16 | Smyth | Virginia | 51173 | 6115 | 140 |
2118676 | 2118676 | 2022-01-15 | Smyth | Virginia | 51173 | 6115 | 140 |
2115424 | 2115424 | 2022-01-14 | Smyth | Virginia | 51173 | 6115 | 140 |
2112172 | 2112172 | 2022-01-13 | Smyth | Virginia | 51173 | 6082 | 140 |
2108920 | 2108920 | 2022-01-12 | Smyth | Virginia | 51173 | 6012 | 140 |
2105669 | 2105669 | 2022-01-11 | Smyth | Virginia | 51173 | 5959 | 140 |
2102418 | 2102418 | 2022-01-10 | Smyth | Virginia | 51173 | 5916 | 140 |
2099167 | 2099167 | 2022-01-09 | Smyth | Virginia | 51173 | 5837 | 140 |
2095916 | 2095916 | 2022-01-08 | Smyth | Virginia | 51173 | 5837 | 140 |
2092664 | 2092664 | 2022-01-07 | Smyth | Virginia | 51173 | 5837 | 140 |
2063382 | 2063382 | 2021-12-29 | Pittsylvania | Virginia | 51143 | 9053 | 140 |
2060132 | 2060132 | 2021-12-28 | Pittsylvania | Virginia | 51143 | 9012 | 140 |
2037299 | 2037299 | 2021-12-21 | Augusta | Virginia | 51015 | 11413 | 140 |
2034049 | 2034049 | 2021-12-20 | Augusta | Virginia | 51015 | 11357 | 140 |
2030799 | 2030799 | 2021-12-19 | Augusta | Virginia | 51015 | 11231 | 140 |
2027548 | 2027548 | 2021-12-18 | Augusta | Virginia | 51015 | 11231 | 140 |
2024297 | 2024297 | 2021-12-17 | Augusta | Virginia | 51015 | 11231 | 140 |
2021046 | 2021046 | 2021-12-16 | Augusta | Virginia | 51015 | 11200 | 140 |
2017795 | 2017795 | 2021-12-15 | Augusta | Virginia | 51015 | 11152 | 140 |
2014545 | 2014545 | 2021-12-14 | Augusta | Virginia | 51015 | 11110 | 140 |
2011294 | 2011294 | 2021-12-13 | Augusta | Virginia | 51015 | 11094 | 140 |
2008043 | 2008043 | 2021-12-12 | Augusta | Virginia | 51015 | 11010 | 140 |
2004792 | 2004792 | 2021-12-11 | Augusta | Virginia | 51015 | 11010 | 140 |
2001541 | 2001541 | 2021-12-10 | Augusta | Virginia | 51015 | 11010 | 140 |
1998291 | 1998291 | 2021-12-09 | Augusta | Virginia | 51015 | 10962 | 140 |
1995040 | 1995040 | 2021-12-08 | Augusta | Virginia | 51015 | 10897 | 140 |
1991789 | 1991789 | 2021-12-07 | Augusta | Virginia | 51015 | 10883 | 140 |
1988538 | 1988538 | 2021-12-06 | Augusta | Virginia | 51015 | 10877 | 140 |
1985288 | 1985288 | 2021-12-05 | Augusta | Virginia | 51015 | 10781 | 140 |
1982038 | 1982038 | 2021-12-04 | Augusta | Virginia | 51015 | 10781 | 140 |
1978788 | 1978788 | 2021-12-03 | Augusta | Virginia | 51015 | 10781 | 140 |
1975538 | 1975538 | 2021-12-02 | Augusta | Virginia | 51015 | 10755 | 140 |
1969039 | 1969039 | 2021-11-30 | Augusta | Virginia | 51015 | 10706 | 140 |
1835831 | 1835831 | 2021-10-20 | Frederick | Virginia | 51069 | 11422 | 140 |
1826164 | 1826164 | 2021-10-17 | Washington | Virginia | 51191 | 7355 | 140 |
1822915 | 1822915 | 2021-10-16 | Washington | Virginia | 51191 | 7355 | 140 |
1819666 | 1819666 | 2021-10-15 | Washington | Virginia | 51191 | 7355 | 140 |
1809904 | 1809904 | 2021-10-12 | Rockingham | Virginia | 51165 | 9007 | 140 |
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);