ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,376 rows where deaths = 20 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Northumberland 141
- King George 119
- Middlesex 92
- Fairfax city 70
- Bath 59
- Essex 54
- Fluvanna 48
- Brunswick 42
- Norton city 41
- Clarke 37
- Floyd 37
- Bland 36
- Rockingham 34
- New Kent 25
- Madison 22
- Sussex 22
- Colonial Heights city 21
- Manassas city 20
- Nottoway 20
- Covington city 19
- Prince Edward 19
- Lunenburg 17
- Charles City 16
- Winchester city 16
- Buckingham 15
- Grayson 15
- Greene 14
- Nelson 14
- Williamsburg city 14
- Buena Vista city 13
- …
state 1
- Virginia · 1,376 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502519 | 2502519 | 2022-05-13 | Bath | Virginia | 51017 | 906 | 20 |
2502630 | 2502630 | 2022-05-13 | Surry | Virginia | 51181 | 1110 | 20 |
2499261 | 2499261 | 2022-05-12 | Bath | Virginia | 51017 | 905 | 20 |
2499372 | 2499372 | 2022-05-12 | Surry | Virginia | 51181 | 1110 | 20 |
2496003 | 2496003 | 2022-05-11 | Bath | Virginia | 51017 | 903 | 20 |
2496114 | 2496114 | 2022-05-11 | Surry | Virginia | 51181 | 1107 | 20 |
2492745 | 2492745 | 2022-05-10 | Bath | Virginia | 51017 | 902 | 20 |
2492856 | 2492856 | 2022-05-10 | Surry | Virginia | 51181 | 1105 | 20 |
2489487 | 2489487 | 2022-05-09 | Bath | Virginia | 51017 | 902 | 20 |
2489598 | 2489598 | 2022-05-09 | Surry | Virginia | 51181 | 1104 | 20 |
2486230 | 2486230 | 2022-05-08 | Bath | Virginia | 51017 | 901 | 20 |
2486341 | 2486341 | 2022-05-08 | Surry | Virginia | 51181 | 1100 | 20 |
2482972 | 2482972 | 2022-05-07 | Bath | Virginia | 51017 | 901 | 20 |
2483083 | 2483083 | 2022-05-07 | Surry | Virginia | 51181 | 1100 | 20 |
2479714 | 2479714 | 2022-05-06 | Bath | Virginia | 51017 | 901 | 20 |
2479825 | 2479825 | 2022-05-06 | Surry | Virginia | 51181 | 1100 | 20 |
2476456 | 2476456 | 2022-05-05 | Bath | Virginia | 51017 | 898 | 20 |
2476567 | 2476567 | 2022-05-05 | Surry | Virginia | 51181 | 1099 | 20 |
2473198 | 2473198 | 2022-05-04 | Bath | Virginia | 51017 | 898 | 20 |
2473309 | 2473309 | 2022-05-04 | Surry | Virginia | 51181 | 1099 | 20 |
2469942 | 2469942 | 2022-05-03 | Bath | Virginia | 51017 | 898 | 20 |
2470053 | 2470053 | 2022-05-03 | Surry | Virginia | 51181 | 1099 | 20 |
2466686 | 2466686 | 2022-05-02 | Bath | Virginia | 51017 | 898 | 20 |
2463431 | 2463431 | 2022-05-01 | Bath | Virginia | 51017 | 898 | 20 |
2460175 | 2460175 | 2022-04-30 | Bath | Virginia | 51017 | 898 | 20 |
2456919 | 2456919 | 2022-04-29 | Bath | Virginia | 51017 | 898 | 20 |
2453663 | 2453663 | 2022-04-28 | Bath | Virginia | 51017 | 898 | 20 |
2450407 | 2450407 | 2022-04-27 | Bath | Virginia | 51017 | 896 | 20 |
2447150 | 2447150 | 2022-04-26 | Bath | Virginia | 51017 | 894 | 20 |
2443895 | 2443895 | 2022-04-25 | Bath | Virginia | 51017 | 894 | 20 |
2440639 | 2440639 | 2022-04-24 | Bath | Virginia | 51017 | 893 | 20 |
2437383 | 2437383 | 2022-04-23 | Bath | Virginia | 51017 | 893 | 20 |
2434127 | 2434127 | 2022-04-22 | Bath | Virginia | 51017 | 893 | 20 |
2430871 | 2430871 | 2022-04-21 | Bath | Virginia | 51017 | 893 | 20 |
2427615 | 2427615 | 2022-04-20 | Bath | Virginia | 51017 | 893 | 20 |
2424359 | 2424359 | 2022-04-19 | Bath | Virginia | 51017 | 894 | 20 |
2421103 | 2421103 | 2022-04-18 | Bath | Virginia | 51017 | 894 | 20 |
2417847 | 2417847 | 2022-04-17 | Bath | Virginia | 51017 | 894 | 20 |
2414591 | 2414591 | 2022-04-16 | Bath | Virginia | 51017 | 894 | 20 |
2411335 | 2411335 | 2022-04-15 | Bath | Virginia | 51017 | 894 | 20 |
2408079 | 2408079 | 2022-04-14 | Bath | Virginia | 51017 | 894 | 20 |
2404823 | 2404823 | 2022-04-13 | Bath | Virginia | 51017 | 894 | 20 |
2401568 | 2401568 | 2022-04-12 | Bath | Virginia | 51017 | 894 | 20 |
2398313 | 2398313 | 2022-04-11 | Bath | Virginia | 51017 | 894 | 20 |
2395058 | 2395058 | 2022-04-10 | Bath | Virginia | 51017 | 893 | 20 |
2391802 | 2391802 | 2022-04-09 | Bath | Virginia | 51017 | 893 | 20 |
2388546 | 2388546 | 2022-04-08 | Bath | Virginia | 51017 | 893 | 20 |
2385291 | 2385291 | 2022-04-07 | Bath | Virginia | 51017 | 893 | 20 |
2382036 | 2382036 | 2022-04-06 | Bath | Virginia | 51017 | 893 | 20 |
2378781 | 2378781 | 2022-04-05 | Bath | Virginia | 51017 | 893 | 20 |
2375527 | 2375527 | 2022-04-04 | Bath | Virginia | 51017 | 893 | 20 |
2372275 | 2372275 | 2022-04-03 | Bath | Virginia | 51017 | 892 | 20 |
2369022 | 2369022 | 2022-04-02 | Bath | Virginia | 51017 | 892 | 20 |
2365769 | 2365769 | 2022-04-01 | Bath | Virginia | 51017 | 892 | 20 |
2362516 | 2362516 | 2022-03-31 | Bath | Virginia | 51017 | 891 | 20 |
2359262 | 2359262 | 2022-03-30 | Bath | Virginia | 51017 | 891 | 20 |
2356008 | 2356008 | 2022-03-29 | Bath | Virginia | 51017 | 892 | 20 |
2352755 | 2352755 | 2022-03-28 | Bath | Virginia | 51017 | 892 | 20 |
2349503 | 2349503 | 2022-03-27 | Bath | Virginia | 51017 | 891 | 20 |
2346250 | 2346250 | 2022-03-26 | Bath | Virginia | 51017 | 891 | 20 |
2342997 | 2342997 | 2022-03-25 | Bath | Virginia | 51017 | 891 | 20 |
2339744 | 2339744 | 2022-03-24 | Bath | Virginia | 51017 | 891 | 20 |
2336490 | 2336490 | 2022-03-23 | Bath | Virginia | 51017 | 891 | 20 |
2333236 | 2333236 | 2022-03-22 | Bath | Virginia | 51017 | 889 | 20 |
2329983 | 2329983 | 2022-03-21 | Bath | Virginia | 51017 | 889 | 20 |
2326731 | 2326731 | 2022-03-20 | Bath | Virginia | 51017 | 887 | 20 |
2323478 | 2323478 | 2022-03-19 | Bath | Virginia | 51017 | 887 | 20 |
2320224 | 2320224 | 2022-03-18 | Bath | Virginia | 51017 | 887 | 20 |
2316970 | 2316970 | 2022-03-17 | Bath | Virginia | 51017 | 887 | 20 |
2313717 | 2313717 | 2022-03-16 | Bath | Virginia | 51017 | 887 | 20 |
2310466 | 2310466 | 2022-03-15 | Bland | Virginia | 51021 | 1753 | 20 |
2307213 | 2307213 | 2022-03-14 | Bland | Virginia | 51021 | 1751 | 20 |
2303962 | 2303962 | 2022-03-13 | Bland | Virginia | 51021 | 1750 | 20 |
2304079 | 2304079 | 2022-03-13 | Williamsburg city | Virginia | 51830 | 1716 | 20 |
2300710 | 2300710 | 2022-03-12 | Bland | Virginia | 51021 | 1750 | 20 |
2300827 | 2300827 | 2022-03-12 | Williamsburg city | Virginia | 51830 | 1716 | 20 |
2297458 | 2297458 | 2022-03-11 | Bland | Virginia | 51021 | 1750 | 20 |
2297575 | 2297575 | 2022-03-11 | Williamsburg city | Virginia | 51830 | 1716 | 20 |
2294206 | 2294206 | 2022-03-10 | Bland | Virginia | 51021 | 1750 | 20 |
2294323 | 2294323 | 2022-03-10 | Williamsburg city | Virginia | 51830 | 1709 | 20 |
2290954 | 2290954 | 2022-03-09 | Bland | Virginia | 51021 | 1746 | 20 |
2291071 | 2291071 | 2022-03-09 | Williamsburg city | Virginia | 51830 | 1707 | 20 |
2287702 | 2287702 | 2022-03-08 | Bland | Virginia | 51021 | 1746 | 20 |
2287819 | 2287819 | 2022-03-08 | Williamsburg city | Virginia | 51830 | 1707 | 20 |
2284450 | 2284450 | 2022-03-07 | Bland | Virginia | 51021 | 1746 | 20 |
2284567 | 2284567 | 2022-03-07 | Williamsburg city | Virginia | 51830 | 1707 | 20 |
2281198 | 2281198 | 2022-03-06 | Bland | Virginia | 51021 | 1745 | 20 |
2281315 | 2281315 | 2022-03-06 | Williamsburg city | Virginia | 51830 | 1708 | 20 |
2277945 | 2277945 | 2022-03-05 | Bland | Virginia | 51021 | 1745 | 20 |
2278062 | 2278062 | 2022-03-05 | Williamsburg city | Virginia | 51830 | 1708 | 20 |
2274692 | 2274692 | 2022-03-04 | Bland | Virginia | 51021 | 1745 | 20 |
2274809 | 2274809 | 2022-03-04 | Williamsburg city | Virginia | 51830 | 1708 | 20 |
2271439 | 2271439 | 2022-03-03 | Bland | Virginia | 51021 | 1745 | 20 |
2271556 | 2271556 | 2022-03-03 | Williamsburg city | Virginia | 51830 | 1706 | 20 |
2268187 | 2268187 | 2022-03-02 | Bland | Virginia | 51021 | 1744 | 20 |
2268304 | 2268304 | 2022-03-02 | Williamsburg city | Virginia | 51830 | 1706 | 20 |
2264934 | 2264934 | 2022-03-01 | Bland | Virginia | 51021 | 1744 | 20 |
2265051 | 2265051 | 2022-03-01 | Williamsburg city | Virginia | 51830 | 1702 | 20 |
2261684 | 2261684 | 2022-02-28 | Bland | Virginia | 51021 | 1748 | 20 |
2261801 | 2261801 | 2022-02-28 | Williamsburg city | Virginia | 51830 | 1697 | 20 |
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);