ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
235 rows where deaths = 56 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 |
---|---|---|---|---|---|---|---|
2502694 | 2502694 | 2022-05-13 | Grant | West Virginia | 54023 | 3786 | 56 |
2499436 | 2499436 | 2022-05-12 | Grant | West Virginia | 54023 | 3786 | 56 |
2496178 | 2496178 | 2022-05-11 | Grant | West Virginia | 54023 | 3786 | 56 |
2492920 | 2492920 | 2022-05-10 | Grant | West Virginia | 54023 | 3786 | 56 |
2489662 | 2489662 | 2022-05-09 | Grant | West Virginia | 54023 | 3786 | 56 |
2486405 | 2486405 | 2022-05-08 | Grant | West Virginia | 54023 | 3787 | 56 |
2483147 | 2483147 | 2022-05-07 | Grant | West Virginia | 54023 | 3787 | 56 |
2479889 | 2479889 | 2022-05-06 | Grant | West Virginia | 54023 | 3787 | 56 |
2476631 | 2476631 | 2022-05-05 | Grant | West Virginia | 54023 | 3785 | 56 |
2473373 | 2473373 | 2022-05-04 | Grant | West Virginia | 54023 | 3785 | 56 |
2470116 | 2470116 | 2022-05-03 | Grant | West Virginia | 54023 | 3785 | 56 |
2466860 | 2466860 | 2022-05-02 | Grant | West Virginia | 54023 | 3785 | 56 |
2463605 | 2463605 | 2022-05-01 | Grant | West Virginia | 54023 | 3785 | 56 |
2460349 | 2460349 | 2022-04-30 | Grant | West Virginia | 54023 | 3785 | 56 |
2457093 | 2457093 | 2022-04-29 | Grant | West Virginia | 54023 | 3785 | 56 |
2453837 | 2453837 | 2022-04-28 | Grant | West Virginia | 54023 | 3783 | 56 |
2450581 | 2450581 | 2022-04-27 | Grant | West Virginia | 54023 | 3782 | 56 |
2447325 | 2447325 | 2022-04-26 | Grant | West Virginia | 54023 | 3782 | 56 |
2444069 | 2444069 | 2022-04-25 | Grant | West Virginia | 54023 | 3778 | 56 |
2440813 | 2440813 | 2022-04-24 | Grant | West Virginia | 54023 | 3776 | 56 |
2437557 | 2437557 | 2022-04-23 | Grant | West Virginia | 54023 | 3776 | 56 |
2434301 | 2434301 | 2022-04-22 | Grant | West Virginia | 54023 | 3776 | 56 |
2431045 | 2431045 | 2022-04-21 | Grant | West Virginia | 54023 | 3775 | 56 |
2427789 | 2427789 | 2022-04-20 | Grant | West Virginia | 54023 | 3774 | 56 |
2424533 | 2424533 | 2022-04-19 | Grant | West Virginia | 54023 | 3773 | 56 |
2421277 | 2421277 | 2022-04-18 | Grant | West Virginia | 54023 | 3773 | 56 |
2418021 | 2418021 | 2022-04-17 | Grant | West Virginia | 54023 | 3771 | 56 |
2414765 | 2414765 | 2022-04-16 | Grant | West Virginia | 54023 | 3771 | 56 |
2411509 | 2411509 | 2022-04-15 | Grant | West Virginia | 54023 | 3771 | 56 |
2408253 | 2408253 | 2022-04-14 | Grant | West Virginia | 54023 | 3769 | 56 |
2404997 | 2404997 | 2022-04-13 | Grant | West Virginia | 54023 | 3768 | 56 |
2401742 | 2401742 | 2022-04-12 | Grant | West Virginia | 54023 | 3766 | 56 |
2398487 | 2398487 | 2022-04-11 | Grant | West Virginia | 54023 | 3766 | 56 |
2395232 | 2395232 | 2022-04-10 | Grant | West Virginia | 54023 | 3766 | 56 |
2391976 | 2391976 | 2022-04-09 | Grant | West Virginia | 54023 | 3766 | 56 |
2388720 | 2388720 | 2022-04-08 | Grant | West Virginia | 54023 | 3766 | 56 |
2385465 | 2385465 | 2022-04-07 | Grant | West Virginia | 54023 | 3766 | 56 |
2382210 | 2382210 | 2022-04-06 | Grant | West Virginia | 54023 | 3766 | 56 |
2378955 | 2378955 | 2022-04-05 | Grant | West Virginia | 54023 | 3766 | 56 |
2375701 | 2375701 | 2022-04-04 | Grant | West Virginia | 54023 | 3765 | 56 |
2372449 | 2372449 | 2022-04-03 | Grant | West Virginia | 54023 | 3765 | 56 |
2369196 | 2369196 | 2022-04-02 | Grant | West Virginia | 54023 | 3765 | 56 |
2365943 | 2365943 | 2022-04-01 | Grant | West Virginia | 54023 | 3765 | 56 |
2362690 | 2362690 | 2022-03-31 | Grant | West Virginia | 54023 | 3765 | 56 |
2359436 | 2359436 | 2022-03-30 | Grant | West Virginia | 54023 | 3765 | 56 |
2356182 | 2356182 | 2022-03-29 | Grant | West Virginia | 54023 | 3765 | 56 |
2352929 | 2352929 | 2022-03-28 | Grant | West Virginia | 54023 | 3764 | 56 |
2349677 | 2349677 | 2022-03-27 | Grant | West Virginia | 54023 | 3765 | 56 |
2346424 | 2346424 | 2022-03-26 | Grant | West Virginia | 54023 | 3765 | 56 |
2343171 | 2343171 | 2022-03-25 | Grant | West Virginia | 54023 | 3765 | 56 |
2339918 | 2339918 | 2022-03-24 | Grant | West Virginia | 54023 | 3764 | 56 |
2336665 | 2336665 | 2022-03-23 | Grant | West Virginia | 54023 | 3763 | 56 |
2333411 | 2333411 | 2022-03-22 | Grant | West Virginia | 54023 | 3765 | 56 |
2330157 | 2330157 | 2022-03-21 | Grant | West Virginia | 54023 | 3764 | 56 |
2326905 | 2326905 | 2022-03-20 | Grant | West Virginia | 54023 | 3760 | 56 |
2323652 | 2323652 | 2022-03-19 | Grant | West Virginia | 54023 | 3760 | 56 |
2320398 | 2320398 | 2022-03-18 | Grant | West Virginia | 54023 | 3760 | 56 |
2317144 | 2317144 | 2022-03-17 | Grant | West Virginia | 54023 | 3758 | 56 |
2313891 | 2313891 | 2022-03-16 | Grant | West Virginia | 54023 | 3758 | 56 |
2310638 | 2310638 | 2022-03-15 | Grant | West Virginia | 54023 | 3758 | 56 |
2307385 | 2307385 | 2022-03-14 | Grant | West Virginia | 54023 | 3758 | 56 |
2304134 | 2304134 | 2022-03-13 | Grant | West Virginia | 54023 | 3755 | 56 |
2300882 | 2300882 | 2022-03-12 | Grant | West Virginia | 54023 | 3755 | 56 |
2297630 | 2297630 | 2022-03-11 | Grant | West Virginia | 54023 | 3755 | 56 |
2294378 | 2294378 | 2022-03-10 | Grant | West Virginia | 54023 | 3753 | 56 |
2291126 | 2291126 | 2022-03-09 | Grant | West Virginia | 54023 | 3751 | 56 |
2287874 | 2287874 | 2022-03-08 | Grant | West Virginia | 54023 | 3752 | 56 |
2284622 | 2284622 | 2022-03-07 | Grant | West Virginia | 54023 | 3750 | 56 |
2281370 | 2281370 | 2022-03-06 | Grant | West Virginia | 54023 | 3748 | 56 |
2278117 | 2278117 | 2022-03-05 | Grant | West Virginia | 54023 | 3748 | 56 |
2274864 | 2274864 | 2022-03-04 | Grant | West Virginia | 54023 | 3748 | 56 |
2271611 | 2271611 | 2022-03-03 | Grant | West Virginia | 54023 | 3746 | 56 |
2268359 | 2268359 | 2022-03-02 | Grant | West Virginia | 54023 | 3744 | 56 |
2154565 | 2154565 | 2022-01-26 | Taylor | West Virginia | 54091 | 3709 | 56 |
2151312 | 2151312 | 2022-01-25 | Taylor | West Virginia | 54091 | 3672 | 56 |
2148060 | 2148060 | 2022-01-24 | Taylor | West Virginia | 54091 | 3645 | 56 |
2144808 | 2144808 | 2022-01-23 | Taylor | West Virginia | 54091 | 3608 | 56 |
2141553 | 2141553 | 2022-01-22 | Taylor | West Virginia | 54091 | 3550 | 56 |
2138297 | 2138297 | 2022-01-21 | Taylor | West Virginia | 54091 | 3510 | 56 |
2134997 | 2134997 | 2022-01-20 | Barbour | West Virginia | 54001 | 3742 | 56 |
2135042 | 2135042 | 2022-01-20 | Taylor | West Virginia | 54091 | 3456 | 56 |
2131745 | 2131745 | 2022-01-19 | Barbour | West Virginia | 54001 | 3692 | 56 |
2131790 | 2131790 | 2022-01-19 | Taylor | West Virginia | 54091 | 3439 | 56 |
2128491 | 2128491 | 2022-01-18 | Barbour | West Virginia | 54001 | 3659 | 56 |
2128536 | 2128536 | 2022-01-18 | Taylor | West Virginia | 54091 | 3416 | 56 |
2125238 | 2125238 | 2022-01-17 | Barbour | West Virginia | 54001 | 3637 | 56 |
2125264 | 2125264 | 2022-01-17 | McDowell | West Virginia | 54047 | 3904 | 56 |
2125283 | 2125283 | 2022-01-17 | Taylor | West Virginia | 54091 | 3401 | 56 |
2121986 | 2121986 | 2022-01-16 | Barbour | West Virginia | 54001 | 3619 | 56 |
2122012 | 2122012 | 2022-01-16 | McDowell | West Virginia | 54047 | 3889 | 56 |
2122031 | 2122031 | 2022-01-16 | Taylor | West Virginia | 54091 | 3371 | 56 |
2118734 | 2118734 | 2022-01-15 | Barbour | West Virginia | 54001 | 3591 | 56 |
2118760 | 2118760 | 2022-01-15 | McDowell | West Virginia | 54047 | 3860 | 56 |
2118779 | 2118779 | 2022-01-15 | Taylor | West Virginia | 54091 | 3340 | 56 |
2115482 | 2115482 | 2022-01-14 | Barbour | West Virginia | 54001 | 3551 | 56 |
2115508 | 2115508 | 2022-01-14 | McDowell | West Virginia | 54047 | 3818 | 56 |
2115527 | 2115527 | 2022-01-14 | Taylor | West Virginia | 54091 | 3303 | 56 |
2112230 | 2112230 | 2022-01-13 | Barbour | West Virginia | 54001 | 3506 | 56 |
2112256 | 2112256 | 2022-01-13 | McDowell | West Virginia | 54047 | 3786 | 56 |
2108978 | 2108978 | 2022-01-12 | Barbour | West Virginia | 54001 | 3467 | 56 |
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);