ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where deaths = 69 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502715 | 2502715 | 2022-05-13 | Morgan | West Virginia | 54065 | 4307 | 69 |
2499457 | 2499457 | 2022-05-12 | Morgan | West Virginia | 54065 | 4303 | 69 |
2496199 | 2496199 | 2022-05-11 | Morgan | West Virginia | 54065 | 4301 | 69 |
2492941 | 2492941 | 2022-05-10 | Morgan | West Virginia | 54065 | 4298 | 69 |
2489683 | 2489683 | 2022-05-09 | Morgan | West Virginia | 54065 | 4298 | 69 |
2486426 | 2486426 | 2022-05-08 | Morgan | West Virginia | 54065 | 4295 | 69 |
2483168 | 2483168 | 2022-05-07 | Morgan | West Virginia | 54065 | 4295 | 69 |
2479910 | 2479910 | 2022-05-06 | Morgan | West Virginia | 54065 | 4295 | 69 |
2476652 | 2476652 | 2022-05-05 | Morgan | West Virginia | 54065 | 4294 | 69 |
2473394 | 2473394 | 2022-05-04 | Morgan | West Virginia | 54065 | 4290 | 69 |
2470137 | 2470137 | 2022-05-03 | Morgan | West Virginia | 54065 | 4289 | 69 |
2466881 | 2466881 | 2022-05-02 | Morgan | West Virginia | 54065 | 4287 | 69 |
2463626 | 2463626 | 2022-05-01 | Morgan | West Virginia | 54065 | 4283 | 69 |
2460370 | 2460370 | 2022-04-30 | Morgan | West Virginia | 54065 | 4283 | 69 |
2457114 | 2457114 | 2022-04-29 | Morgan | West Virginia | 54065 | 4283 | 69 |
2453858 | 2453858 | 2022-04-28 | Morgan | West Virginia | 54065 | 4280 | 69 |
2450602 | 2450602 | 2022-04-27 | Morgan | West Virginia | 54065 | 4276 | 69 |
2447346 | 2447346 | 2022-04-26 | Morgan | West Virginia | 54065 | 4273 | 69 |
2444090 | 2444090 | 2022-04-25 | Morgan | West Virginia | 54065 | 4271 | 69 |
2440834 | 2440834 | 2022-04-24 | Morgan | West Virginia | 54065 | 4264 | 69 |
2437578 | 2437578 | 2022-04-23 | Morgan | West Virginia | 54065 | 4264 | 69 |
2434322 | 2434322 | 2022-04-22 | Morgan | West Virginia | 54065 | 4264 | 69 |
2431066 | 2431066 | 2022-04-21 | Morgan | West Virginia | 54065 | 4259 | 69 |
2427810 | 2427810 | 2022-04-20 | Morgan | West Virginia | 54065 | 4254 | 69 |
2424554 | 2424554 | 2022-04-19 | Morgan | West Virginia | 54065 | 4254 | 69 |
2421298 | 2421298 | 2022-04-18 | Morgan | West Virginia | 54065 | 4253 | 69 |
2418042 | 2418042 | 2022-04-17 | Morgan | West Virginia | 54065 | 4251 | 69 |
2414786 | 2414786 | 2022-04-16 | Morgan | West Virginia | 54065 | 4251 | 69 |
2411530 | 2411530 | 2022-04-15 | Morgan | West Virginia | 54065 | 4251 | 69 |
2408274 | 2408274 | 2022-04-14 | Morgan | West Virginia | 54065 | 4249 | 69 |
2405018 | 2405018 | 2022-04-13 | Morgan | West Virginia | 54065 | 4248 | 69 |
2401763 | 2401763 | 2022-04-12 | Morgan | West Virginia | 54065 | 4247 | 69 |
2398508 | 2398508 | 2022-04-11 | Morgan | West Virginia | 54065 | 4247 | 69 |
2395253 | 2395253 | 2022-04-10 | Morgan | West Virginia | 54065 | 4243 | 69 |
2391997 | 2391997 | 2022-04-09 | Morgan | West Virginia | 54065 | 4243 | 69 |
2388741 | 2388741 | 2022-04-08 | Morgan | West Virginia | 54065 | 4243 | 69 |
2375722 | 2375722 | 2022-04-04 | Morgan | West Virginia | 54065 | 4242 | 69 |
2372470 | 2372470 | 2022-04-03 | Morgan | West Virginia | 54065 | 4238 | 69 |
2369217 | 2369217 | 2022-04-02 | Morgan | West Virginia | 54065 | 4238 | 69 |
2365964 | 2365964 | 2022-04-01 | Morgan | West Virginia | 54065 | 4238 | 69 |
2362711 | 2362711 | 2022-03-31 | Morgan | West Virginia | 54065 | 4234 | 69 |
2359457 | 2359457 | 2022-03-30 | Morgan | West Virginia | 54065 | 4234 | 69 |
2356203 | 2356203 | 2022-03-29 | Morgan | West Virginia | 54065 | 4230 | 69 |
2352944 | 2352944 | 2022-03-28 | McDowell | West Virginia | 54047 | 5591 | 69 |
2349692 | 2349692 | 2022-03-27 | McDowell | West Virginia | 54047 | 5586 | 69 |
2346439 | 2346439 | 2022-03-26 | McDowell | West Virginia | 54047 | 5586 | 69 |
2343186 | 2343186 | 2022-03-25 | McDowell | West Virginia | 54047 | 5586 | 69 |
2310640 | 2310640 | 2022-03-15 | Hampshire | West Virginia | 54027 | 5799 | 69 |
2307387 | 2307387 | 2022-03-14 | Hampshire | West Virginia | 54027 | 5795 | 69 |
2304136 | 2304136 | 2022-03-13 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2304168 | 2304168 | 2022-03-13 | Taylor | West Virginia | 54091 | 4467 | 69 |
2300884 | 2300884 | 2022-03-12 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2300916 | 2300916 | 2022-03-12 | Taylor | West Virginia | 54091 | 4467 | 69 |
2297632 | 2297632 | 2022-03-11 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2297664 | 2297664 | 2022-03-11 | Taylor | West Virginia | 54091 | 4467 | 69 |
2294380 | 2294380 | 2022-03-10 | Hampshire | West Virginia | 54027 | 5796 | 69 |
2294412 | 2294412 | 2022-03-10 | Taylor | West Virginia | 54091 | 4465 | 69 |
2268369 | 2268369 | 2022-03-02 | Lincoln | West Virginia | 54043 | 5433 | 69 |
2265116 | 2265116 | 2022-03-01 | Lincoln | West Virginia | 54043 | 5432 | 69 |
2261866 | 2261866 | 2022-02-28 | Lincoln | West Virginia | 54043 | 5430 | 69 |
2258615 | 2258615 | 2022-02-27 | Lincoln | West Virginia | 54043 | 5411 | 69 |
2255364 | 2255364 | 2022-02-26 | Lincoln | West Virginia | 54043 | 5411 | 69 |
2252113 | 2252113 | 2022-02-25 | Lincoln | West Virginia | 54043 | 5411 | 69 |
2248862 | 2248862 | 2022-02-24 | Lincoln | West Virginia | 54043 | 5404 | 69 |
2242339 | 2242339 | 2022-02-22 | Barbour | West Virginia | 54001 | 4634 | 69 |
2108998 | 2108998 | 2022-01-12 | Lewis | West Virginia | 54041 | 3935 | 69 |
2076488 | 2076488 | 2022-01-02 | Mason | West Virginia | 54053 | 4331 | 69 |
2073237 | 2073237 | 2022-01-01 | Mason | West Virginia | 54053 | 4331 | 69 |
2069986 | 2069986 | 2021-12-31 | Mason | West Virginia | 54053 | 4331 | 69 |
2066735 | 2066735 | 2021-12-30 | Mason | West Virginia | 54053 | 4331 | 69 |
1998488 | 1998488 | 2021-12-09 | Nicholas | West Virginia | 54067 | 4480 | 69 |
1995237 | 1995237 | 2021-12-08 | Nicholas | West Virginia | 54067 | 4458 | 69 |
1972501 | 1972501 | 2021-12-01 | Upshur | West Virginia | 54097 | 4462 | 69 |
1969251 | 1969251 | 2021-11-30 | Upshur | West Virginia | 54097 | 4448 | 69 |
1962749 | 1962749 | 2021-11-28 | Upshur | West Virginia | 54097 | 4378 | 69 |
1959498 | 1959498 | 2021-11-27 | Upshur | West Virginia | 54097 | 4378 | 69 |
1956247 | 1956247 | 2021-11-26 | Upshur | West Virginia | 54097 | 4378 | 69 |
1952996 | 1952996 | 2021-11-25 | Upshur | West Virginia | 54097 | 4378 | 69 |
1949745 | 1949745 | 2021-11-24 | Upshur | West Virginia | 54097 | 4378 | 69 |
1832713 | 1832713 | 2021-10-19 | Brooke | West Virginia | 54009 | 2995 | 69 |
1829464 | 1829464 | 2021-10-18 | Brooke | West Virginia | 54009 | 2991 | 69 |
1826215 | 1826215 | 2021-10-17 | Brooke | West Virginia | 54009 | 2989 | 69 |
1822966 | 1822966 | 2021-10-16 | Brooke | West Virginia | 54009 | 2983 | 69 |
1819717 | 1819717 | 2021-10-15 | Brooke | West Virginia | 54009 | 2979 | 69 |
1813265 | 1813265 | 2021-10-13 | Wayne | West Virginia | 54099 | 5450 | 69 |
1810016 | 1810016 | 2021-10-12 | Wayne | West Virginia | 54099 | 5430 | 69 |
1806756 | 1806756 | 2021-10-11 | Preston | West Virginia | 54077 | 4786 | 69 |
1806767 | 1806767 | 2021-10-11 | Wayne | West Virginia | 54099 | 5410 | 69 |
1764494 | 1764494 | 2021-09-28 | Jackson | West Virginia | 54035 | 3343 | 69 |
1761245 | 1761245 | 2021-09-27 | Jackson | West Virginia | 54035 | 3325 | 69 |
1735256 | 1735256 | 2021-09-19 | Jefferson | West Virginia | 54037 | 5893 | 69 |
1732006 | 1732006 | 2021-09-18 | Jefferson | West Virginia | 54037 | 5857 | 69 |
1728756 | 1728756 | 2021-09-17 | Jefferson | West Virginia | 54037 | 5805 | 69 |
1725506 | 1725506 | 2021-09-16 | Jefferson | West Virginia | 54037 | 5765 | 69 |
1722257 | 1722257 | 2021-09-15 | Jefferson | West Virginia | 54037 | 5740 | 69 |
1715755 | 1715755 | 2021-09-13 | Greenbrier | West Virginia | 54025 | 3920 | 69 |
1712509 | 1712509 | 2021-09-12 | Greenbrier | West Virginia | 54025 | 3882 | 69 |
1709262 | 1709262 | 2021-09-11 | Greenbrier | West Virginia | 54025 | 3834 | 69 |
1706015 | 1706015 | 2021-09-10 | Greenbrier | West Virginia | 54025 | 3784 | 69 |
1046871 | 1046871 | 2021-02-19 | Fayette | West Virginia | 54019 | 2587 | 69 |
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);