ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
674 rows where deaths = 34 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Louisa 61
- Prince Edward 44
- Middlesex 33
- Waynesboro city 31
- Harrisonburg city 29
- Northampton 25
- Buena Vista city 24
- Hampton city 22
- Charlottesville city 21
- Botetourt 20
- Buckingham 19
- Suffolk city 17
- Fredericksburg city 16
- Grayson 16
- Mecklenburg 16
- Bristol city 15
- Orange 15
- Colonial Heights city 14
- Appomattox 12
- Nelson 10
- Powhatan 10
- Northumberland 9
- Washington 9
- Albemarle 8
- Russell 8
- Amelia 7
- Franklin city 7
- Buchanan 6
- Hanover 6
- King William 6
- …
state 1
- Virginia · 674 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427688 | 2427688 | 2022-04-20 | Nelson | Virginia | 51125 | 2537 | 34 |
2404896 | 2404896 | 2022-04-13 | Nelson | Virginia | 51125 | 2545 | 34 |
2401641 | 2401641 | 2022-04-12 | Nelson | Virginia | 51125 | 2554 | 34 |
2398386 | 2398386 | 2022-04-11 | Nelson | Virginia | 51125 | 2561 | 34 |
2395131 | 2395131 | 2022-04-10 | Nelson | Virginia | 51125 | 2556 | 34 |
2391875 | 2391875 | 2022-04-09 | Nelson | Virginia | 51125 | 2556 | 34 |
2388619 | 2388619 | 2022-04-08 | Nelson | Virginia | 51125 | 2556 | 34 |
2385364 | 2385364 | 2022-04-07 | Nelson | Virginia | 51125 | 2570 | 34 |
2382109 | 2382109 | 2022-04-06 | Nelson | Virginia | 51125 | 2593 | 34 |
2378854 | 2378854 | 2022-04-05 | Nelson | Virginia | 51125 | 2600 | 34 |
2336553 | 2336553 | 2022-03-23 | Lunenburg | Virginia | 51111 | 2349 | 34 |
2333299 | 2333299 | 2022-03-22 | Lunenburg | Virginia | 51111 | 2346 | 34 |
2330046 | 2330046 | 2022-03-21 | Lunenburg | Virginia | 51111 | 2346 | 34 |
2290989 | 2290989 | 2022-03-09 | Fredericksburg city | Virginia | 51630 | 5263 | 34 |
2287737 | 2287737 | 2022-03-08 | Fredericksburg city | Virginia | 51630 | 5256 | 34 |
2284485 | 2284485 | 2022-03-07 | Fredericksburg city | Virginia | 51630 | 5273 | 34 |
2281233 | 2281233 | 2022-03-06 | Fredericksburg city | Virginia | 51630 | 5324 | 34 |
2281252 | 2281252 | 2022-03-06 | King William | Virginia | 51101 | 3657 | 34 |
2277980 | 2277980 | 2022-03-05 | Fredericksburg city | Virginia | 51630 | 5324 | 34 |
2277999 | 2277999 | 2022-03-05 | King William | Virginia | 51101 | 3657 | 34 |
2274727 | 2274727 | 2022-03-04 | Fredericksburg city | Virginia | 51630 | 5324 | 34 |
2274746 | 2274746 | 2022-03-04 | King William | Virginia | 51101 | 3657 | 34 |
2271474 | 2271474 | 2022-03-03 | Fredericksburg city | Virginia | 51630 | 5350 | 34 |
2271493 | 2271493 | 2022-03-03 | King William | Virginia | 51101 | 3657 | 34 |
2268222 | 2268222 | 2022-03-02 | Fredericksburg city | Virginia | 51630 | 5344 | 34 |
2268241 | 2268241 | 2022-03-02 | King William | Virginia | 51101 | 3657 | 34 |
2264969 | 2264969 | 2022-03-01 | Fredericksburg city | Virginia | 51630 | 5334 | 34 |
2264988 | 2264988 | 2022-03-01 | King William | Virginia | 51101 | 3656 | 34 |
2261719 | 2261719 | 2022-02-28 | Fredericksburg city | Virginia | 51630 | 5329 | 34 |
2258468 | 2258468 | 2022-02-27 | Fredericksburg city | Virginia | 51630 | 5320 | 34 |
2255217 | 2255217 | 2022-02-26 | Fredericksburg city | Virginia | 51630 | 5320 | 34 |
2251966 | 2251966 | 2022-02-25 | Fredericksburg city | Virginia | 51630 | 5320 | 34 |
2248715 | 2248715 | 2022-02-24 | Fredericksburg city | Virginia | 51630 | 5312 | 34 |
2245464 | 2245464 | 2022-02-23 | Fredericksburg city | Virginia | 51630 | 5304 | 34 |
2242213 | 2242213 | 2022-02-22 | Fredericksburg city | Virginia | 51630 | 5301 | 34 |
2238980 | 2238980 | 2022-02-21 | King George | Virginia | 51099 | 4927 | 34 |
2235729 | 2235729 | 2022-02-20 | King George | Virginia | 51099 | 4909 | 34 |
2232478 | 2232478 | 2022-02-19 | King George | Virginia | 51099 | 4909 | 34 |
2229227 | 2229227 | 2022-02-18 | King George | Virginia | 51099 | 4909 | 34 |
2222735 | 2222735 | 2022-02-16 | Madison | Virginia | 51113 | 2011 | 34 |
2219484 | 2219484 | 2022-02-15 | Madison | Virginia | 51113 | 2007 | 34 |
2219531 | 2219531 | 2022-02-15 | Sussex | Virginia | 51183 | 2372 | 34 |
2216234 | 2216234 | 2022-02-14 | Madison | Virginia | 51113 | 1998 | 34 |
2196684 | 2196684 | 2022-02-08 | Fluvanna | Virginia | 51065 | 4616 | 34 |
2190175 | 2190175 | 2022-02-06 | Floyd | Virginia | 51063 | 2317 | 34 |
2186922 | 2186922 | 2022-02-05 | Floyd | Virginia | 51063 | 2317 | 34 |
2183669 | 2183669 | 2022-02-04 | Floyd | Virginia | 51063 | 2317 | 34 |
2144607 | 2144607 | 2022-01-23 | Buena Vista city | Virginia | 51530 | 1726 | 34 |
2144670 | 2144670 | 2022-01-23 | Middlesex | Virginia | 51119 | 1542 | 34 |
2144687 | 2144687 | 2022-01-23 | Powhatan | Virginia | 51145 | 4294 | 34 |
2141352 | 2141352 | 2022-01-22 | Buena Vista city | Virginia | 51530 | 1726 | 34 |
2141415 | 2141415 | 2022-01-22 | Middlesex | Virginia | 51119 | 1542 | 34 |
2141432 | 2141432 | 2022-01-22 | Powhatan | Virginia | 51145 | 4294 | 34 |
2138096 | 2138096 | 2022-01-21 | Buena Vista city | Virginia | 51530 | 1726 | 34 |
2138159 | 2138159 | 2022-01-21 | Middlesex | Virginia | 51119 | 1542 | 34 |
2138176 | 2138176 | 2022-01-21 | Powhatan | Virginia | 51145 | 4294 | 34 |
2134842 | 2134842 | 2022-01-20 | Buena Vista city | Virginia | 51530 | 1709 | 34 |
2134905 | 2134905 | 2022-01-20 | Middlesex | Virginia | 51119 | 1510 | 34 |
2134922 | 2134922 | 2022-01-20 | Powhatan | Virginia | 51145 | 4243 | 34 |
2131590 | 2131590 | 2022-01-19 | Buena Vista city | Virginia | 51530 | 1693 | 34 |
2131653 | 2131653 | 2022-01-19 | Middlesex | Virginia | 51119 | 1490 | 34 |
2131670 | 2131670 | 2022-01-19 | Powhatan | Virginia | 51145 | 4197 | 34 |
2128336 | 2128336 | 2022-01-18 | Buena Vista city | Virginia | 51530 | 1691 | 34 |
2128399 | 2128399 | 2022-01-18 | Middlesex | Virginia | 51119 | 1474 | 34 |
2128416 | 2128416 | 2022-01-18 | Powhatan | Virginia | 51145 | 4180 | 34 |
2125083 | 2125083 | 2022-01-17 | Buena Vista city | Virginia | 51530 | 1691 | 34 |
2125146 | 2125146 | 2022-01-17 | Middlesex | Virginia | 51119 | 1462 | 34 |
2125163 | 2125163 | 2022-01-17 | Powhatan | Virginia | 51145 | 4118 | 34 |
2121831 | 2121831 | 2022-01-16 | Buena Vista city | Virginia | 51530 | 1649 | 34 |
2121894 | 2121894 | 2022-01-16 | Middlesex | Virginia | 51119 | 1393 | 34 |
2121911 | 2121911 | 2022-01-16 | Powhatan | Virginia | 51145 | 3985 | 34 |
2118579 | 2118579 | 2022-01-15 | Buena Vista city | Virginia | 51530 | 1649 | 34 |
2118642 | 2118642 | 2022-01-15 | Middlesex | Virginia | 51119 | 1393 | 34 |
2118659 | 2118659 | 2022-01-15 | Powhatan | Virginia | 51145 | 3985 | 34 |
2115327 | 2115327 | 2022-01-14 | Buena Vista city | Virginia | 51530 | 1649 | 34 |
2115390 | 2115390 | 2022-01-14 | Middlesex | Virginia | 51119 | 1393 | 34 |
2115407 | 2115407 | 2022-01-14 | Powhatan | Virginia | 51145 | 3985 | 34 |
2112075 | 2112075 | 2022-01-13 | Buena Vista city | Virginia | 51530 | 1636 | 34 |
2112138 | 2112138 | 2022-01-13 | Middlesex | Virginia | 51119 | 1364 | 34 |
2108823 | 2108823 | 2022-01-12 | Buena Vista city | Virginia | 51530 | 1616 | 34 |
2108886 | 2108886 | 2022-01-12 | Middlesex | Virginia | 51119 | 1350 | 34 |
2105572 | 2105572 | 2022-01-11 | Buena Vista city | Virginia | 51530 | 1608 | 34 |
2105635 | 2105635 | 2022-01-11 | Middlesex | Virginia | 51119 | 1330 | 34 |
2102321 | 2102321 | 2022-01-10 | Buena Vista city | Virginia | 51530 | 1597 | 34 |
2102384 | 2102384 | 2022-01-10 | Middlesex | Virginia | 51119 | 1309 | 34 |
2099070 | 2099070 | 2022-01-09 | Buena Vista city | Virginia | 51530 | 1557 | 34 |
2099133 | 2099133 | 2022-01-09 | Middlesex | Virginia | 51119 | 1243 | 34 |
2095819 | 2095819 | 2022-01-08 | Buena Vista city | Virginia | 51530 | 1557 | 34 |
2095882 | 2095882 | 2022-01-08 | Middlesex | Virginia | 51119 | 1243 | 34 |
2092567 | 2092567 | 2022-01-07 | Buena Vista city | Virginia | 51530 | 1557 | 34 |
2092630 | 2092630 | 2022-01-07 | Middlesex | Virginia | 51119 | 1243 | 34 |
2089315 | 2089315 | 2022-01-06 | Buena Vista city | Virginia | 51530 | 1551 | 34 |
2089378 | 2089378 | 2022-01-06 | Middlesex | Virginia | 51119 | 1217 | 34 |
2086064 | 2086064 | 2022-01-05 | Buena Vista city | Virginia | 51530 | 1543 | 34 |
2086127 | 2086127 | 2022-01-05 | Middlesex | Virginia | 51119 | 1198 | 34 |
2082812 | 2082812 | 2022-01-04 | Buena Vista city | Virginia | 51530 | 1538 | 34 |
2082875 | 2082875 | 2022-01-04 | Middlesex | Virginia | 51119 | 1191 | 34 |
2079560 | 2079560 | 2022-01-03 | Buena Vista city | Virginia | 51530 | 1530 | 34 |
2079623 | 2079623 | 2022-01-03 | Middlesex | Virginia | 51119 | 1171 | 34 |
2076308 | 2076308 | 2022-01-02 | Buena Vista city | Virginia | 51530 | 1511 | 34 |
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);