ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where deaths = 39 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Orange 56
- Waynesboro city 52
- Westmoreland 46
- Lexington city 42
- Botetourt 38
- Northumberland 37
- Radford city 36
- Buena Vista city 34
- Grayson 26
- Russell 24
- Greensville 22
- King George 21
- Bristol city 17
- Amelia 16
- Petersburg city 16
- Sussex 15
- King William 14
- Albemarle 13
- Spotsylvania 11
- Accomack 10
- Alleghany 10
- Mecklenburg 9
- Charlottesville city 8
- Lunenburg 8
- Madison 8
- Fairfax city 7
- Galax city 7
- Richmond city 7
- Southampton 7
- Fluvanna 6
- …
state 1
- Virginia · 746 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502574 | 2502574 | 2022-05-13 | King George | Virginia | 51099 | 5119 | 39 |
2502582 | 2502582 | 2022-05-13 | Lunenburg | Virginia | 51111 | 2460 | 39 |
2499316 | 2499316 | 2022-05-12 | King George | Virginia | 51099 | 5105 | 39 |
2499324 | 2499324 | 2022-05-12 | Lunenburg | Virginia | 51111 | 2458 | 39 |
2496058 | 2496058 | 2022-05-11 | King George | Virginia | 51099 | 5095 | 39 |
2496066 | 2496066 | 2022-05-11 | Lunenburg | Virginia | 51111 | 2457 | 39 |
2492808 | 2492808 | 2022-05-10 | Lunenburg | Virginia | 51111 | 2455 | 39 |
2489550 | 2489550 | 2022-05-09 | Lunenburg | Virginia | 51111 | 2453 | 39 |
2486293 | 2486293 | 2022-05-08 | Lunenburg | Virginia | 51111 | 2453 | 39 |
2483035 | 2483035 | 2022-05-07 | Lunenburg | Virginia | 51111 | 2453 | 39 |
2479777 | 2479777 | 2022-05-06 | Lunenburg | Virginia | 51111 | 2453 | 39 |
2463486 | 2463486 | 2022-05-01 | King George | Virginia | 51099 | 5037 | 39 |
2460230 | 2460230 | 2022-04-30 | King George | Virginia | 51099 | 5037 | 39 |
2456974 | 2456974 | 2022-04-29 | King George | Virginia | 51099 | 5037 | 39 |
2453718 | 2453718 | 2022-04-28 | King George | Virginia | 51099 | 5035 | 39 |
2450462 | 2450462 | 2022-04-27 | King George | Virginia | 51099 | 5030 | 39 |
2447194 | 2447194 | 2022-04-26 | Greensville | Virginia | 51081 | 3326 | 39 |
2447205 | 2447205 | 2022-04-26 | King George | Virginia | 51099 | 5024 | 39 |
2443939 | 2443939 | 2022-04-25 | Greensville | Virginia | 51081 | 3326 | 39 |
2443950 | 2443950 | 2022-04-25 | King George | Virginia | 51099 | 5023 | 39 |
2440683 | 2440683 | 2022-04-24 | Greensville | Virginia | 51081 | 3327 | 39 |
2440694 | 2440694 | 2022-04-24 | King George | Virginia | 51099 | 5020 | 39 |
2437427 | 2437427 | 2022-04-23 | Greensville | Virginia | 51081 | 3327 | 39 |
2437438 | 2437438 | 2022-04-23 | King George | Virginia | 51099 | 5020 | 39 |
2434171 | 2434171 | 2022-04-22 | Greensville | Virginia | 51081 | 3327 | 39 |
2434182 | 2434182 | 2022-04-22 | King George | Virginia | 51099 | 5020 | 39 |
2430915 | 2430915 | 2022-04-21 | Greensville | Virginia | 51081 | 3325 | 39 |
2430926 | 2430926 | 2022-04-21 | King George | Virginia | 51099 | 5018 | 39 |
2427659 | 2427659 | 2022-04-20 | Greensville | Virginia | 51081 | 3324 | 39 |
2427670 | 2427670 | 2022-04-20 | King George | Virginia | 51099 | 5019 | 39 |
2424403 | 2424403 | 2022-04-19 | Greensville | Virginia | 51081 | 3323 | 39 |
2424414 | 2424414 | 2022-04-19 | King George | Virginia | 51099 | 5019 | 39 |
2421147 | 2421147 | 2022-04-18 | Greensville | Virginia | 51081 | 3324 | 39 |
2421158 | 2421158 | 2022-04-18 | King George | Virginia | 51099 | 5017 | 39 |
2421159 | 2421159 | 2022-04-18 | King William | Virginia | 51101 | 3697 | 39 |
2417891 | 2417891 | 2022-04-17 | Greensville | Virginia | 51081 | 3328 | 39 |
2417902 | 2417902 | 2022-04-17 | King George | Virginia | 51099 | 5011 | 39 |
2417903 | 2417903 | 2022-04-17 | King William | Virginia | 51101 | 3695 | 39 |
2414635 | 2414635 | 2022-04-16 | Greensville | Virginia | 51081 | 3328 | 39 |
2414646 | 2414646 | 2022-04-16 | King George | Virginia | 51099 | 5011 | 39 |
2414647 | 2414647 | 2022-04-16 | King William | Virginia | 51101 | 3695 | 39 |
2411379 | 2411379 | 2022-04-15 | Greensville | Virginia | 51081 | 3328 | 39 |
2411390 | 2411390 | 2022-04-15 | King George | Virginia | 51099 | 5011 | 39 |
2411391 | 2411391 | 2022-04-15 | King William | Virginia | 51101 | 3695 | 39 |
2408123 | 2408123 | 2022-04-14 | Greensville | Virginia | 51081 | 3327 | 39 |
2408134 | 2408134 | 2022-04-14 | King George | Virginia | 51099 | 5010 | 39 |
2408135 | 2408135 | 2022-04-14 | King William | Virginia | 51101 | 3691 | 39 |
2404867 | 2404867 | 2022-04-13 | Greensville | Virginia | 51081 | 3327 | 39 |
2404879 | 2404879 | 2022-04-13 | King William | Virginia | 51101 | 3689 | 39 |
2404888 | 2404888 | 2022-04-13 | Madison | Virginia | 51113 | 2348 | 39 |
2401612 | 2401612 | 2022-04-12 | Greensville | Virginia | 51081 | 3324 | 39 |
2401624 | 2401624 | 2022-04-12 | King William | Virginia | 51101 | 3688 | 39 |
2401633 | 2401633 | 2022-04-12 | Madison | Virginia | 51113 | 2347 | 39 |
2398369 | 2398369 | 2022-04-11 | King William | Virginia | 51101 | 3688 | 39 |
2398378 | 2398378 | 2022-04-11 | Madison | Virginia | 51113 | 2346 | 39 |
2395114 | 2395114 | 2022-04-10 | King William | Virginia | 51101 | 3686 | 39 |
2395123 | 2395123 | 2022-04-10 | Madison | Virginia | 51113 | 2343 | 39 |
2391858 | 2391858 | 2022-04-09 | King William | Virginia | 51101 | 3686 | 39 |
2391867 | 2391867 | 2022-04-09 | Madison | Virginia | 51113 | 2343 | 39 |
2388602 | 2388602 | 2022-04-08 | King William | Virginia | 51101 | 3686 | 39 |
2388611 | 2388611 | 2022-04-08 | Madison | Virginia | 51113 | 2343 | 39 |
2385347 | 2385347 | 2022-04-07 | King William | Virginia | 51101 | 3685 | 39 |
2385356 | 2385356 | 2022-04-07 | Madison | Virginia | 51113 | 2343 | 39 |
2382092 | 2382092 | 2022-04-06 | King William | Virginia | 51101 | 3685 | 39 |
2382101 | 2382101 | 2022-04-06 | Madison | Virginia | 51113 | 2313 | 39 |
2378837 | 2378837 | 2022-04-05 | King William | Virginia | 51101 | 3684 | 39 |
2356052 | 2356052 | 2022-03-29 | Greensville | Virginia | 51081 | 3313 | 39 |
2352799 | 2352799 | 2022-03-28 | Greensville | Virginia | 51081 | 3313 | 39 |
2349547 | 2349547 | 2022-03-27 | Greensville | Virginia | 51081 | 3312 | 39 |
2346294 | 2346294 | 2022-03-26 | Greensville | Virginia | 51081 | 3312 | 39 |
2343041 | 2343041 | 2022-03-25 | Greensville | Virginia | 51081 | 3312 | 39 |
2339788 | 2339788 | 2022-03-24 | Greensville | Virginia | 51081 | 3313 | 39 |
2336534 | 2336534 | 2022-03-23 | Greensville | Virginia | 51081 | 3315 | 39 |
2326791 | 2326791 | 2022-03-20 | Lexington city | Virginia | 51678 | 2824 | 39 |
2323538 | 2323538 | 2022-03-19 | Lexington city | Virginia | 51678 | 2824 | 39 |
2320284 | 2320284 | 2022-03-18 | Lexington city | Virginia | 51678 | 2824 | 39 |
2317030 | 2317030 | 2022-03-17 | Lexington city | Virginia | 51678 | 2819 | 39 |
2313725 | 2313725 | 2022-03-16 | Buena Vista city | Virginia | 51530 | 1997 | 39 |
2313777 | 2313777 | 2022-03-16 | Lexington city | Virginia | 51678 | 2818 | 39 |
2313829 | 2313829 | 2022-03-16 | Sussex | Virginia | 51183 | 2412 | 39 |
2310472 | 2310472 | 2022-03-15 | Buena Vista city | Virginia | 51530 | 1997 | 39 |
2310524 | 2310524 | 2022-03-15 | Lexington city | Virginia | 51678 | 2818 | 39 |
2310576 | 2310576 | 2022-03-15 | Sussex | Virginia | 51183 | 2409 | 39 |
2307219 | 2307219 | 2022-03-14 | Buena Vista city | Virginia | 51530 | 1997 | 39 |
2307271 | 2307271 | 2022-03-14 | Lexington city | Virginia | 51678 | 2818 | 39 |
2307323 | 2307323 | 2022-03-14 | Sussex | Virginia | 51183 | 2408 | 39 |
2303968 | 2303968 | 2022-03-13 | Buena Vista city | Virginia | 51530 | 1993 | 39 |
2304020 | 2304020 | 2022-03-13 | Lexington city | Virginia | 51678 | 2828 | 39 |
2304072 | 2304072 | 2022-03-13 | Sussex | Virginia | 51183 | 2409 | 39 |
2300716 | 2300716 | 2022-03-12 | Buena Vista city | Virginia | 51530 | 1993 | 39 |
2300768 | 2300768 | 2022-03-12 | Lexington city | Virginia | 51678 | 2828 | 39 |
2300820 | 2300820 | 2022-03-12 | Sussex | Virginia | 51183 | 2409 | 39 |
2297464 | 2297464 | 2022-03-11 | Buena Vista city | Virginia | 51530 | 1993 | 39 |
2297516 | 2297516 | 2022-03-11 | Lexington city | Virginia | 51678 | 2828 | 39 |
2297568 | 2297568 | 2022-03-11 | Sussex | Virginia | 51183 | 2409 | 39 |
2294212 | 2294212 | 2022-03-10 | Buena Vista city | Virginia | 51530 | 1992 | 39 |
2294264 | 2294264 | 2022-03-10 | Lexington city | Virginia | 51678 | 2827 | 39 |
2294316 | 2294316 | 2022-03-10 | Sussex | Virginia | 51183 | 2408 | 39 |
2290960 | 2290960 | 2022-03-09 | Buena Vista city | Virginia | 51530 | 1991 | 39 |
2291012 | 2291012 | 2022-03-09 | Lexington city | Virginia | 51678 | 2825 | 39 |
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);