ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
873 rows where deaths = 36 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Northampton 89
- Amelia 75
- Appomattox 61
- Prince Edward 46
- Fairfax city 43
- Bristol city 29
- Buchanan 29
- Lexington city 28
- Botetourt 27
- Louisa 21
- Russell 20
- Radford city 19
- Warren 19
- Brunswick 14
- King George 14
- Rockingham 14
- Lunenburg 13
- Buckingham 12
- Waynesboro city 12
- Goochland 11
- Madison 11
- Richmond city 11
- Caroline 10
- Carroll 10
- Harrisonburg city 10
- Northumberland 10
- Buena Vista city 9
- Petersburg city 9
- Powhatan 9
- Amherst 8
- …
state 1
- Virginia · 873 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502592 | 2502592 | 2022-05-13 | Nelson | Virginia | 51125 | 2589 | 36 |
2499334 | 2499334 | 2022-05-12 | Nelson | Virginia | 51125 | 2586 | 36 |
2496076 | 2496076 | 2022-05-11 | Nelson | Virginia | 51125 | 2585 | 36 |
2404886 | 2404886 | 2022-04-13 | Lunenburg | Virginia | 51111 | 2401 | 36 |
2401631 | 2401631 | 2022-04-12 | Lunenburg | Virginia | 51111 | 2397 | 36 |
2398376 | 2398376 | 2022-04-11 | Lunenburg | Virginia | 51111 | 2373 | 36 |
2395121 | 2395121 | 2022-04-10 | Lunenburg | Virginia | 51111 | 2370 | 36 |
2391865 | 2391865 | 2022-04-09 | Lunenburg | Virginia | 51111 | 2370 | 36 |
2388609 | 2388609 | 2022-04-08 | Lunenburg | Virginia | 51111 | 2370 | 36 |
2385354 | 2385354 | 2022-04-07 | Lunenburg | Virginia | 51111 | 2370 | 36 |
2382099 | 2382099 | 2022-04-06 | Lunenburg | Virginia | 51111 | 2364 | 36 |
2378844 | 2378844 | 2022-04-05 | Lunenburg | Virginia | 51111 | 2363 | 36 |
2375590 | 2375590 | 2022-04-04 | Lunenburg | Virginia | 51111 | 2361 | 36 |
2372338 | 2372338 | 2022-04-03 | Lunenburg | Virginia | 51111 | 2360 | 36 |
2369085 | 2369085 | 2022-04-02 | Lunenburg | Virginia | 51111 | 2360 | 36 |
2365832 | 2365832 | 2022-04-01 | Lunenburg | Virginia | 51111 | 2360 | 36 |
2326787 | 2326787 | 2022-03-20 | King William | Virginia | 51101 | 3669 | 36 |
2323534 | 2323534 | 2022-03-19 | King William | Virginia | 51101 | 3669 | 36 |
2320280 | 2320280 | 2022-03-18 | King William | Virginia | 51101 | 3669 | 36 |
2317026 | 2317026 | 2022-03-17 | King William | Virginia | 51101 | 3668 | 36 |
2313773 | 2313773 | 2022-03-16 | King William | Virginia | 51101 | 3667 | 36 |
2310520 | 2310520 | 2022-03-15 | King William | Virginia | 51101 | 3665 | 36 |
2307267 | 2307267 | 2022-03-14 | King William | Virginia | 51101 | 3663 | 36 |
2304015 | 2304015 | 2022-03-13 | King George | Virginia | 51099 | 4972 | 36 |
2300763 | 2300763 | 2022-03-12 | King George | Virginia | 51099 | 4972 | 36 |
2297511 | 2297511 | 2022-03-11 | King George | Virginia | 51099 | 4972 | 36 |
2294259 | 2294259 | 2022-03-10 | King George | Virginia | 51099 | 4968 | 36 |
2294269 | 2294269 | 2022-03-10 | Madison | Virginia | 51113 | 2178 | 36 |
2291007 | 2291007 | 2022-03-09 | King George | Virginia | 51099 | 4970 | 36 |
2291017 | 2291017 | 2022-03-09 | Madison | Virginia | 51113 | 2154 | 36 |
2287755 | 2287755 | 2022-03-08 | King George | Virginia | 51099 | 4970 | 36 |
2287765 | 2287765 | 2022-03-08 | Madison | Virginia | 51113 | 2152 | 36 |
2284503 | 2284503 | 2022-03-07 | King George | Virginia | 51099 | 4970 | 36 |
2284513 | 2284513 | 2022-03-07 | Madison | Virginia | 51113 | 2150 | 36 |
2281251 | 2281251 | 2022-03-06 | King George | Virginia | 51099 | 4964 | 36 |
2281261 | 2281261 | 2022-03-06 | Madison | Virginia | 51113 | 2110 | 36 |
2277998 | 2277998 | 2022-03-05 | King George | Virginia | 51099 | 4964 | 36 |
2278008 | 2278008 | 2022-03-05 | Madison | Virginia | 51113 | 2110 | 36 |
2274745 | 2274745 | 2022-03-04 | King George | Virginia | 51099 | 4964 | 36 |
2274755 | 2274755 | 2022-03-04 | Madison | Virginia | 51113 | 2110 | 36 |
2271492 | 2271492 | 2022-03-03 | King George | Virginia | 51099 | 4961 | 36 |
2271502 | 2271502 | 2022-03-03 | Madison | Virginia | 51113 | 2086 | 36 |
2268240 | 2268240 | 2022-03-02 | King George | Virginia | 51099 | 4960 | 36 |
2268250 | 2268250 | 2022-03-02 | Madison | Virginia | 51113 | 2055 | 36 |
2264976 | 2264976 | 2022-03-01 | Greensville | Virginia | 51081 | 3288 | 36 |
2264987 | 2264987 | 2022-03-01 | King George | Virginia | 51099 | 4956 | 36 |
2264997 | 2264997 | 2022-03-01 | Madison | Virginia | 51113 | 2025 | 36 |
2261726 | 2261726 | 2022-02-28 | Greensville | Virginia | 51081 | 3288 | 36 |
2261737 | 2261737 | 2022-02-28 | King George | Virginia | 51099 | 4956 | 36 |
2261747 | 2261747 | 2022-02-28 | Madison | Virginia | 51113 | 2019 | 36 |
2225934 | 2225934 | 2022-02-17 | Charlotte | Virginia | 51037 | 2304 | 36 |
2222683 | 2222683 | 2022-02-16 | Charlotte | Virginia | 51037 | 2294 | 36 |
2219432 | 2219432 | 2022-02-15 | Charlotte | Virginia | 51037 | 2291 | 36 |
2216182 | 2216182 | 2022-02-14 | Charlotte | Virginia | 51037 | 2289 | 36 |
2212950 | 2212950 | 2022-02-13 | Floyd | Virginia | 51063 | 2380 | 36 |
2212951 | 2212951 | 2022-02-13 | Fluvanna | Virginia | 51065 | 4667 | 36 |
2209697 | 2209697 | 2022-02-12 | Floyd | Virginia | 51063 | 2380 | 36 |
2209698 | 2209698 | 2022-02-12 | Fluvanna | Virginia | 51065 | 4667 | 36 |
2206444 | 2206444 | 2022-02-11 | Floyd | Virginia | 51063 | 2380 | 36 |
2206445 | 2206445 | 2022-02-11 | Fluvanna | Virginia | 51065 | 4667 | 36 |
2203191 | 2203191 | 2022-02-10 | Floyd | Virginia | 51063 | 2368 | 36 |
2203192 | 2203192 | 2022-02-10 | Fluvanna | Virginia | 51065 | 4650 | 36 |
2199937 | 2199937 | 2022-02-09 | Floyd | Virginia | 51063 | 2365 | 36 |
2196683 | 2196683 | 2022-02-08 | Floyd | Virginia | 51063 | 2355 | 36 |
2193428 | 2193428 | 2022-02-07 | Floyd | Virginia | 51063 | 2344 | 36 |
2180393 | 2180393 | 2022-02-03 | Buena Vista city | Virginia | 51530 | 1852 | 36 |
2177142 | 2177142 | 2022-02-02 | Buena Vista city | Virginia | 51530 | 1844 | 36 |
2173889 | 2173889 | 2022-02-01 | Buena Vista city | Virginia | 51530 | 1835 | 36 |
2173910 | 2173910 | 2022-02-01 | Fairfax city | Virginia | 51600 | 1915 | 36 |
2173952 | 2173952 | 2022-02-01 | Middlesex | Virginia | 51119 | 1694 | 36 |
2173969 | 2173969 | 2022-02-01 | Powhatan | Virginia | 51145 | 4559 | 36 |
2170637 | 2170637 | 2022-01-31 | Buena Vista city | Virginia | 51530 | 1831 | 36 |
2170658 | 2170658 | 2022-01-31 | Fairfax city | Virginia | 51600 | 1911 | 36 |
2170700 | 2170700 | 2022-01-31 | Middlesex | Virginia | 51119 | 1688 | 36 |
2170717 | 2170717 | 2022-01-31 | Powhatan | Virginia | 51145 | 4545 | 36 |
2167384 | 2167384 | 2022-01-30 | Buena Vista city | Virginia | 51530 | 1810 | 36 |
2167405 | 2167405 | 2022-01-30 | Fairfax city | Virginia | 51600 | 1902 | 36 |
2167447 | 2167447 | 2022-01-30 | Middlesex | Virginia | 51119 | 1656 | 36 |
2167464 | 2167464 | 2022-01-30 | Powhatan | Virginia | 51145 | 4482 | 36 |
2164129 | 2164129 | 2022-01-29 | Buena Vista city | Virginia | 51530 | 1810 | 36 |
2164150 | 2164150 | 2022-01-29 | Fairfax city | Virginia | 51600 | 1902 | 36 |
2164192 | 2164192 | 2022-01-29 | Middlesex | Virginia | 51119 | 1656 | 36 |
2164209 | 2164209 | 2022-01-29 | Powhatan | Virginia | 51145 | 4482 | 36 |
2160874 | 2160874 | 2022-01-28 | Buena Vista city | Virginia | 51530 | 1810 | 36 |
2160895 | 2160895 | 2022-01-28 | Fairfax city | Virginia | 51600 | 1902 | 36 |
2160937 | 2160937 | 2022-01-28 | Middlesex | Virginia | 51119 | 1656 | 36 |
2160954 | 2160954 | 2022-01-28 | Powhatan | Virginia | 51145 | 4482 | 36 |
2157618 | 2157618 | 2022-01-27 | Buena Vista city | Virginia | 51530 | 1794 | 36 |
2157639 | 2157639 | 2022-01-27 | Fairfax city | Virginia | 51600 | 1892 | 36 |
2157681 | 2157681 | 2022-01-27 | Middlesex | Virginia | 51119 | 1642 | 36 |
2157698 | 2157698 | 2022-01-27 | Powhatan | Virginia | 51145 | 4443 | 36 |
2154365 | 2154365 | 2022-01-26 | Buena Vista city | Virginia | 51530 | 1784 | 36 |
2154386 | 2154386 | 2022-01-26 | Fairfax city | Virginia | 51600 | 1885 | 36 |
2154428 | 2154428 | 2022-01-26 | Middlesex | Virginia | 51119 | 1620 | 36 |
2154445 | 2154445 | 2022-01-26 | Powhatan | Virginia | 51145 | 4415 | 36 |
2151121 | 2151121 | 2022-01-25 | Clarke | Virginia | 51043 | 2354 | 36 |
2151133 | 2151133 | 2022-01-25 | Fairfax city | Virginia | 51600 | 1880 | 36 |
2151192 | 2151192 | 2022-01-25 | Powhatan | Virginia | 51145 | 4389 | 36 |
2147881 | 2147881 | 2022-01-24 | Fairfax city | Virginia | 51600 | 1877 | 36 |
2147940 | 2147940 | 2022-01-24 | Powhatan | Virginia | 51145 | 4347 | 36 |
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);