ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
551 rows where deaths = 24 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Hardy 147
- Wirt 52
- Lincoln 43
- Jackson 41
- Taylor 27
- Tyler 22
- Ritchie 21
- Nicholas 18
- Mercer 16
- Lewis 15
- Barbour 13
- Roane 11
- Webster 11
- Hampshire 10
- Marion 10
- Kanawha 8
- Wetzel 8
- Harrison 7
- McDowell 7
- Randolph 7
- Braxton 6
- Clay 6
- Fayette 6
- Summers 6
- Wyoming 5
- Marshall 4
- Pleasants 4
- Berkeley 2
- Boone 2
- Brooke 2
- …
state 1
- West Virginia · 551 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496219 | 2496219 | 2022-05-11 | Wirt | West Virginia | 54105 | 1454 | 24 |
2492961 | 2492961 | 2022-05-10 | Wirt | West Virginia | 54105 | 1452 | 24 |
2489703 | 2489703 | 2022-05-09 | Wirt | West Virginia | 54105 | 1452 | 24 |
2486446 | 2486446 | 2022-05-08 | Wirt | West Virginia | 54105 | 1452 | 24 |
2483188 | 2483188 | 2022-05-07 | Wirt | West Virginia | 54105 | 1452 | 24 |
2479930 | 2479930 | 2022-05-06 | Wirt | West Virginia | 54105 | 1452 | 24 |
2476672 | 2476672 | 2022-05-05 | Wirt | West Virginia | 54105 | 1452 | 24 |
2473414 | 2473414 | 2022-05-04 | Wirt | West Virginia | 54105 | 1451 | 24 |
2470157 | 2470157 | 2022-05-03 | Wirt | West Virginia | 54105 | 1451 | 24 |
2466901 | 2466901 | 2022-05-02 | Wirt | West Virginia | 54105 | 1451 | 24 |
2463646 | 2463646 | 2022-05-01 | Wirt | West Virginia | 54105 | 1452 | 24 |
2460390 | 2460390 | 2022-04-30 | Wirt | West Virginia | 54105 | 1452 | 24 |
2457134 | 2457134 | 2022-04-29 | Wirt | West Virginia | 54105 | 1452 | 24 |
2453878 | 2453878 | 2022-04-28 | Wirt | West Virginia | 54105 | 1451 | 24 |
2450622 | 2450622 | 2022-04-27 | Wirt | West Virginia | 54105 | 1451 | 24 |
2447366 | 2447366 | 2022-04-26 | Wirt | West Virginia | 54105 | 1450 | 24 |
2444110 | 2444110 | 2022-04-25 | Wirt | West Virginia | 54105 | 1450 | 24 |
2440854 | 2440854 | 2022-04-24 | Wirt | West Virginia | 54105 | 1446 | 24 |
2437598 | 2437598 | 2022-04-23 | Wirt | West Virginia | 54105 | 1446 | 24 |
2434342 | 2434342 | 2022-04-22 | Wirt | West Virginia | 54105 | 1446 | 24 |
2431086 | 2431086 | 2022-04-21 | Wirt | West Virginia | 54105 | 1446 | 24 |
2427830 | 2427830 | 2022-04-20 | Wirt | West Virginia | 54105 | 1446 | 24 |
2424574 | 2424574 | 2022-04-19 | Wirt | West Virginia | 54105 | 1446 | 24 |
2421318 | 2421318 | 2022-04-18 | Wirt | West Virginia | 54105 | 1447 | 24 |
2418062 | 2418062 | 2022-04-17 | Wirt | West Virginia | 54105 | 1447 | 24 |
2414806 | 2414806 | 2022-04-16 | Wirt | West Virginia | 54105 | 1447 | 24 |
2411550 | 2411550 | 2022-04-15 | Wirt | West Virginia | 54105 | 1447 | 24 |
2408294 | 2408294 | 2022-04-14 | Wirt | West Virginia | 54105 | 1447 | 24 |
2405038 | 2405038 | 2022-04-13 | Wirt | West Virginia | 54105 | 1446 | 24 |
2401783 | 2401783 | 2022-04-12 | Wirt | West Virginia | 54105 | 1446 | 24 |
2398528 | 2398528 | 2022-04-11 | Wirt | West Virginia | 54105 | 1446 | 24 |
2395273 | 2395273 | 2022-04-10 | Wirt | West Virginia | 54105 | 1440 | 24 |
2392017 | 2392017 | 2022-04-09 | Wirt | West Virginia | 54105 | 1440 | 24 |
2388761 | 2388761 | 2022-04-08 | Wirt | West Virginia | 54105 | 1440 | 24 |
2385506 | 2385506 | 2022-04-07 | Wirt | West Virginia | 54105 | 1438 | 24 |
2382251 | 2382251 | 2022-04-06 | Wirt | West Virginia | 54105 | 1436 | 24 |
2378996 | 2378996 | 2022-04-05 | Wirt | West Virginia | 54105 | 1436 | 24 |
2375742 | 2375742 | 2022-04-04 | Wirt | West Virginia | 54105 | 1436 | 24 |
2372490 | 2372490 | 2022-04-03 | Wirt | West Virginia | 54105 | 1435 | 24 |
2369237 | 2369237 | 2022-04-02 | Wirt | West Virginia | 54105 | 1435 | 24 |
2365984 | 2365984 | 2022-04-01 | Wirt | West Virginia | 54105 | 1435 | 24 |
2362731 | 2362731 | 2022-03-31 | Wirt | West Virginia | 54105 | 1435 | 24 |
2359477 | 2359477 | 2022-03-30 | Wirt | West Virginia | 54105 | 1435 | 24 |
2356223 | 2356223 | 2022-03-29 | Wirt | West Virginia | 54105 | 1435 | 24 |
2352970 | 2352970 | 2022-03-28 | Wirt | West Virginia | 54105 | 1434 | 24 |
2349718 | 2349718 | 2022-03-27 | Wirt | West Virginia | 54105 | 1434 | 24 |
2346465 | 2346465 | 2022-03-26 | Wirt | West Virginia | 54105 | 1434 | 24 |
2343212 | 2343212 | 2022-03-25 | Wirt | West Virginia | 54105 | 1434 | 24 |
2339959 | 2339959 | 2022-03-24 | Wirt | West Virginia | 54105 | 1434 | 24 |
2336706 | 2336706 | 2022-03-23 | Wirt | West Virginia | 54105 | 1434 | 24 |
2333452 | 2333452 | 2022-03-22 | Wirt | West Virginia | 54105 | 1434 | 24 |
2330198 | 2330198 | 2022-03-21 | Wirt | West Virginia | 54105 | 1434 | 24 |
2125275 | 2125275 | 2022-01-17 | Pocahontas | West Virginia | 54075 | 1546 | 24 |
2076505 | 2076505 | 2022-01-02 | Ritchie | West Virginia | 54085 | 1696 | 24 |
2073254 | 2073254 | 2022-01-01 | Ritchie | West Virginia | 54085 | 1696 | 24 |
2070003 | 2070003 | 2021-12-31 | Ritchie | West Virginia | 54085 | 1696 | 24 |
2066752 | 2066752 | 2021-12-30 | Ritchie | West Virginia | 54085 | 1696 | 24 |
2063502 | 2063502 | 2021-12-29 | Ritchie | West Virginia | 54085 | 1690 | 24 |
2060252 | 2060252 | 2021-12-28 | Ritchie | West Virginia | 54085 | 1679 | 24 |
2057003 | 2057003 | 2021-12-27 | Ritchie | West Virginia | 54085 | 1675 | 24 |
2053754 | 2053754 | 2021-12-26 | Ritchie | West Virginia | 54085 | 1670 | 24 |
2050504 | 2050504 | 2021-12-25 | Ritchie | West Virginia | 54085 | 1670 | 24 |
2047254 | 2047254 | 2021-12-24 | Ritchie | West Virginia | 54085 | 1670 | 24 |
2044004 | 2044004 | 2021-12-23 | Ritchie | West Virginia | 54085 | 1670 | 24 |
2040755 | 2040755 | 2021-12-22 | Ritchie | West Virginia | 54085 | 1666 | 24 |
2037505 | 2037505 | 2021-12-21 | Ritchie | West Virginia | 54085 | 1658 | 24 |
2034255 | 2034255 | 2021-12-20 | Ritchie | West Virginia | 54085 | 1656 | 24 |
2031005 | 2031005 | 2021-12-19 | Ritchie | West Virginia | 54085 | 1650 | 24 |
2027754 | 2027754 | 2021-12-18 | Ritchie | West Virginia | 54085 | 1646 | 24 |
2024503 | 2024503 | 2021-12-17 | Ritchie | West Virginia | 54085 | 1641 | 24 |
2021252 | 2021252 | 2021-12-16 | Ritchie | West Virginia | 54085 | 1637 | 24 |
2018001 | 2018001 | 2021-12-15 | Ritchie | West Virginia | 54085 | 1630 | 24 |
2014751 | 2014751 | 2021-12-14 | Ritchie | West Virginia | 54085 | 1622 | 24 |
2011500 | 2011500 | 2021-12-13 | Ritchie | West Virginia | 54085 | 1621 | 24 |
2008214 | 2008214 | 2021-12-12 | Clay | West Virginia | 54015 | 1476 | 24 |
2004963 | 2004963 | 2021-12-11 | Clay | West Virginia | 54015 | 1461 | 24 |
2001712 | 2001712 | 2021-12-10 | Clay | West Virginia | 54015 | 1449 | 24 |
1998462 | 1998462 | 2021-12-09 | Clay | West Virginia | 54015 | 1441 | 24 |
1995211 | 1995211 | 2021-12-08 | Clay | West Virginia | 54015 | 1426 | 24 |
1991960 | 1991960 | 2021-12-07 | Clay | West Virginia | 54015 | 1427 | 24 |
1969206 | 1969206 | 2021-11-30 | Braxton | West Virginia | 54007 | 2386 | 24 |
1969250 | 1969250 | 2021-11-30 | Tyler | West Virginia | 54095 | 1449 | 24 |
1966000 | 1966000 | 2021-11-29 | Tyler | West Virginia | 54095 | 1446 | 24 |
1962704 | 1962704 | 2021-11-28 | Braxton | West Virginia | 54007 | 2355 | 24 |
1962748 | 1962748 | 2021-11-28 | Tyler | West Virginia | 54095 | 1433 | 24 |
1962751 | 1962751 | 2021-11-28 | Webster | West Virginia | 54101 | 1362 | 24 |
1959453 | 1959453 | 2021-11-27 | Braxton | West Virginia | 54007 | 2355 | 24 |
1959497 | 1959497 | 2021-11-27 | Tyler | West Virginia | 54095 | 1433 | 24 |
1959500 | 1959500 | 2021-11-27 | Webster | West Virginia | 54101 | 1362 | 24 |
1956202 | 1956202 | 2021-11-26 | Braxton | West Virginia | 54007 | 2355 | 24 |
1956246 | 1956246 | 2021-11-26 | Tyler | West Virginia | 54095 | 1433 | 24 |
1956249 | 1956249 | 2021-11-26 | Webster | West Virginia | 54101 | 1362 | 24 |
1952951 | 1952951 | 2021-11-25 | Braxton | West Virginia | 54007 | 2355 | 24 |
1952995 | 1952995 | 2021-11-25 | Tyler | West Virginia | 54095 | 1433 | 24 |
1952998 | 1952998 | 2021-11-25 | Webster | West Virginia | 54101 | 1362 | 24 |
1949700 | 1949700 | 2021-11-24 | Braxton | West Virginia | 54007 | 2355 | 24 |
1949744 | 1949744 | 2021-11-24 | Tyler | West Virginia | 54095 | 1433 | 24 |
1949747 | 1949747 | 2021-11-24 | Webster | West Virginia | 54101 | 1362 | 24 |
1946493 | 1946493 | 2021-11-23 | Tyler | West Virginia | 54095 | 1428 | 24 |
1946496 | 1946496 | 2021-11-23 | Webster | West Virginia | 54101 | 1335 | 24 |
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);