ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
354 rows where deaths = 78 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Halifax 87
- Suffolk city 24
- Wythe 21
- Galax city 17
- Martinsville city 15
- Richmond city 15
- Pittsylvania 14
- Bristol city 10
- Norfolk city 10
- James City 9
- Franklin 8
- Alleghany 7
- Portsmouth city 7
- Caroline 6
- Carroll 6
- Chesapeake city 6
- Roanoke city 6
- Scott 6
- Staunton city 6
- Hopewell city 5
- Mecklenburg 5
- Rockbridge 5
- Roanoke 4
- Stafford 4
- Colonial Heights city 3
- Gloucester 3
- Hanover 3
- Patrick 3
- Spotsylvania 3
- York 3
- …
state 1
- Virginia · 354 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502557 | 2502557 | 2022-05-13 | Galax city | Virginia | 51640 | 2561 | 78 |
2499299 | 2499299 | 2022-05-12 | Galax city | Virginia | 51640 | 2559 | 78 |
2496041 | 2496041 | 2022-05-11 | Galax city | Virginia | 51640 | 2559 | 78 |
2492783 | 2492783 | 2022-05-10 | Galax city | Virginia | 51640 | 2558 | 78 |
2489525 | 2489525 | 2022-05-09 | Galax city | Virginia | 51640 | 2557 | 78 |
2486268 | 2486268 | 2022-05-08 | Galax city | Virginia | 51640 | 2556 | 78 |
2483010 | 2483010 | 2022-05-07 | Galax city | Virginia | 51640 | 2556 | 78 |
2479752 | 2479752 | 2022-05-06 | Galax city | Virginia | 51640 | 2556 | 78 |
2476494 | 2476494 | 2022-05-05 | Galax city | Virginia | 51640 | 2556 | 78 |
2473236 | 2473236 | 2022-05-04 | Galax city | Virginia | 51640 | 2552 | 78 |
2469980 | 2469980 | 2022-05-03 | Galax city | Virginia | 51640 | 2550 | 78 |
2466724 | 2466724 | 2022-05-02 | Galax city | Virginia | 51640 | 2550 | 78 |
2463469 | 2463469 | 2022-05-01 | Galax city | Virginia | 51640 | 2551 | 78 |
2460213 | 2460213 | 2022-04-30 | Galax city | Virginia | 51640 | 2551 | 78 |
2456957 | 2456957 | 2022-04-29 | Galax city | Virginia | 51640 | 2551 | 78 |
2453701 | 2453701 | 2022-04-28 | Galax city | Virginia | 51640 | 2551 | 78 |
2450445 | 2450445 | 2022-04-27 | Galax city | Virginia | 51640 | 2551 | 78 |
2421202 | 2421202 | 2022-04-18 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2417946 | 2417946 | 2022-04-17 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2414690 | 2414690 | 2022-04-16 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2411434 | 2411434 | 2022-04-15 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2408178 | 2408178 | 2022-04-14 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2401582 | 2401582 | 2022-04-12 | Charlottesville city | Virginia | 51540 | 9062 | 78 |
2401688 | 2401688 | 2022-04-12 | Winchester city | Virginia | 51840 | 6319 | 78 |
2395062 | 2395062 | 2022-04-10 | Bristol city | Virginia | 51520 | 4389 | 78 |
2391806 | 2391806 | 2022-04-09 | Bristol city | Virginia | 51520 | 4389 | 78 |
2388550 | 2388550 | 2022-04-08 | Bristol city | Virginia | 51520 | 4389 | 78 |
2385295 | 2385295 | 2022-04-07 | Bristol city | Virginia | 51520 | 4389 | 78 |
2375531 | 2375531 | 2022-04-04 | Bristol city | Virginia | 51520 | 4380 | 78 |
2372279 | 2372279 | 2022-04-03 | Bristol city | Virginia | 51520 | 4378 | 78 |
2369026 | 2369026 | 2022-04-02 | Bristol city | Virginia | 51520 | 4378 | 78 |
2365773 | 2365773 | 2022-04-01 | Bristol city | Virginia | 51520 | 4378 | 78 |
2362520 | 2362520 | 2022-03-31 | Bristol city | Virginia | 51520 | 4378 | 78 |
2359266 | 2359266 | 2022-03-30 | Bristol city | Virginia | 51520 | 4377 | 78 |
2313779 | 2313779 | 2022-03-16 | Louisa | Virginia | 51109 | 6507 | 78 |
2287710 | 2287710 | 2022-03-08 | Caroline | Virginia | 51033 | 6753 | 78 |
2284458 | 2284458 | 2022-03-07 | Caroline | Virginia | 51033 | 6754 | 78 |
2281206 | 2281206 | 2022-03-06 | Caroline | Virginia | 51033 | 6757 | 78 |
2277953 | 2277953 | 2022-03-05 | Caroline | Virginia | 51033 | 6757 | 78 |
2274700 | 2274700 | 2022-03-04 | Caroline | Virginia | 51033 | 6757 | 78 |
2271447 | 2271447 | 2022-03-03 | Caroline | Virginia | 51033 | 6788 | 78 |
2242201 | 2242201 | 2022-02-22 | Dinwiddie | Virginia | 51053 | 5148 | 78 |
2219499 | 2219499 | 2022-02-15 | Nottoway | Virginia | 51135 | 3857 | 78 |
2216228 | 2216228 | 2022-02-14 | Lee | Virginia | 51105 | 5899 | 78 |
2216249 | 2216249 | 2022-02-14 | Nottoway | Virginia | 51135 | 3853 | 78 |
2196757 | 2196757 | 2022-02-08 | Southampton | Virginia | 51175 | 3226 | 78 |
2193502 | 2193502 | 2022-02-07 | Southampton | Virginia | 51175 | 3223 | 78 |
2190161 | 2190161 | 2022-02-06 | Colonial Heights city | Virginia | 51570 | 4546 | 78 |
2190226 | 2190226 | 2022-02-06 | Patrick | Virginia | 51141 | 3259 | 78 |
2186908 | 2186908 | 2022-02-05 | Colonial Heights city | Virginia | 51570 | 4546 | 78 |
2186973 | 2186973 | 2022-02-05 | Patrick | Virginia | 51141 | 3259 | 78 |
2183655 | 2183655 | 2022-02-04 | Colonial Heights city | Virginia | 51570 | 4546 | 78 |
2183720 | 2183720 | 2022-02-04 | Patrick | Virginia | 51141 | 3259 | 78 |
2079653 | 2079653 | 2022-01-03 | Russell | Virginia | 51167 | 4689 | 78 |
1904073 | 1904073 | 2021-11-10 | Gloucester | Virginia | 51073 | 3900 | 78 |
1900823 | 1900823 | 2021-11-09 | Gloucester | Virginia | 51073 | 3897 | 78 |
1897573 | 1897573 | 2021-11-08 | Gloucester | Virginia | 51073 | 3895 | 78 |
1894277 | 1894277 | 2021-11-07 | Alleghany | Virginia | 51005 | 2152 | 78 |
1894386 | 1894386 | 2021-11-07 | Scott | Virginia | 51169 | 3217 | 78 |
1891027 | 1891027 | 2021-11-06 | Alleghany | Virginia | 51005 | 2152 | 78 |
1891136 | 1891136 | 2021-11-06 | Scott | Virginia | 51169 | 3217 | 78 |
1887777 | 1887777 | 2021-11-05 | Alleghany | Virginia | 51005 | 2152 | 78 |
1887886 | 1887886 | 2021-11-05 | Scott | Virginia | 51169 | 3217 | 78 |
1884527 | 1884527 | 2021-11-04 | Alleghany | Virginia | 51005 | 2147 | 78 |
1884636 | 1884636 | 2021-11-04 | Scott | Virginia | 51169 | 3203 | 78 |
1884656 | 1884656 | 2021-11-04 | York | Virginia | 51199 | 5535 | 78 |
1881278 | 1881278 | 2021-11-03 | Alleghany | Virginia | 51005 | 2140 | 78 |
1881366 | 1881366 | 2021-11-03 | Page | Virginia | 51139 | 3406 | 78 |
1881387 | 1881387 | 2021-11-03 | Scott | Virginia | 51169 | 3197 | 78 |
1881407 | 1881407 | 2021-11-03 | York | Virginia | 51199 | 5514 | 78 |
1878026 | 1878026 | 2021-11-02 | Accomack | Virginia | 51001 | 4097 | 78 |
1878029 | 1878029 | 2021-11-02 | Alleghany | Virginia | 51005 | 2136 | 78 |
1878117 | 1878117 | 2021-11-02 | Page | Virginia | 51139 | 3401 | 78 |
1878138 | 1878138 | 2021-11-02 | Scott | Virginia | 51169 | 3188 | 78 |
1878158 | 1878158 | 2021-11-02 | York | Virginia | 51199 | 5508 | 78 |
1874780 | 1874780 | 2021-11-01 | Alleghany | Virginia | 51005 | 2133 | 78 |
1816416 | 1816416 | 2021-10-14 | Warren | Virginia | 51187 | 4791 | 78 |
1813145 | 1813145 | 2021-10-13 | Pulaski | Virginia | 51155 | 3953 | 78 |
1809896 | 1809896 | 2021-10-12 | Pulaski | Virginia | 51155 | 3937 | 78 |
1806624 | 1806624 | 2021-10-11 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1803374 | 1803374 | 2021-10-10 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1800125 | 1800125 | 2021-10-09 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1796876 | 1796876 | 2021-10-08 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1793578 | 1793578 | 2021-10-07 | Culpeper | Virginia | 51047 | 6150 | 78 |
1793627 | 1793627 | 2021-10-07 | Mecklenburg | Virginia | 51117 | 3241 | 78 |
1790329 | 1790329 | 2021-10-06 | Culpeper | Virginia | 51047 | 6135 | 78 |
1783920 | 1783920 | 2021-10-04 | Staunton city | Virginia | 51790 | 3244 | 78 |
1780671 | 1780671 | 2021-10-03 | Staunton city | Virginia | 51790 | 3208 | 78 |
1777421 | 1777421 | 2021-10-02 | Staunton city | Virginia | 51790 | 3208 | 78 |
1774171 | 1774171 | 2021-10-01 | Staunton city | Virginia | 51790 | 3208 | 78 |
1770921 | 1770921 | 2021-09-30 | Staunton city | Virginia | 51790 | 3196 | 78 |
1767672 | 1767672 | 2021-09-29 | Staunton city | Virginia | 51790 | 3186 | 78 |
1696147 | 1696147 | 2021-09-07 | James City | Virginia | 51095 | 5802 | 78 |
1692899 | 1692899 | 2021-09-06 | James City | Virginia | 51095 | 5787 | 78 |
1689650 | 1689650 | 2021-09-05 | James City | Virginia | 51095 | 5687 | 78 |
1686400 | 1686400 | 2021-09-04 | James City | Virginia | 51095 | 5687 | 78 |
1683149 | 1683149 | 2021-09-03 | James City | Virginia | 51095 | 5687 | 78 |
1679899 | 1679899 | 2021-09-02 | James City | Virginia | 51095 | 5640 | 78 |
1676651 | 1676651 | 2021-09-01 | James City | Virginia | 51095 | 5595 | 78 |
1673404 | 1673404 | 2021-08-31 | James City | Virginia | 51095 | 5555 | 78 |
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);