ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where deaths = 95 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502731 | 2502731 | 2022-05-13 | Upshur | West Virginia | 54097 | 6928 | 95 |
2499473 | 2499473 | 2022-05-12 | Upshur | West Virginia | 54097 | 6918 | 95 |
2496215 | 2496215 | 2022-05-11 | Upshur | West Virginia | 54097 | 6907 | 95 |
2492957 | 2492957 | 2022-05-10 | Upshur | West Virginia | 54097 | 6890 | 95 |
2489699 | 2489699 | 2022-05-09 | Upshur | West Virginia | 54097 | 6890 | 95 |
2486442 | 2486442 | 2022-05-08 | Upshur | West Virginia | 54097 | 6878 | 95 |
2483184 | 2483184 | 2022-05-07 | Upshur | West Virginia | 54097 | 6878 | 95 |
2479926 | 2479926 | 2022-05-06 | Upshur | West Virginia | 54097 | 6878 | 95 |
2476668 | 2476668 | 2022-05-05 | Upshur | West Virginia | 54097 | 6872 | 95 |
2473410 | 2473410 | 2022-05-04 | Upshur | West Virginia | 54097 | 6867 | 95 |
2470153 | 2470153 | 2022-05-03 | Upshur | West Virginia | 54097 | 6864 | 95 |
2466897 | 2466897 | 2022-05-02 | Upshur | West Virginia | 54097 | 6861 | 95 |
2463642 | 2463642 | 2022-05-01 | Upshur | West Virginia | 54097 | 6852 | 95 |
2460386 | 2460386 | 2022-04-30 | Upshur | West Virginia | 54097 | 6852 | 95 |
2457130 | 2457130 | 2022-04-29 | Upshur | West Virginia | 54097 | 6852 | 95 |
2453874 | 2453874 | 2022-04-28 | Upshur | West Virginia | 54097 | 6851 | 95 |
2450618 | 2450618 | 2022-04-27 | Upshur | West Virginia | 54097 | 6849 | 95 |
2447362 | 2447362 | 2022-04-26 | Upshur | West Virginia | 54097 | 6842 | 95 |
2444106 | 2444106 | 2022-04-25 | Upshur | West Virginia | 54097 | 6839 | 95 |
2440850 | 2440850 | 2022-04-24 | Upshur | West Virginia | 54097 | 6833 | 95 |
2437594 | 2437594 | 2022-04-23 | Upshur | West Virginia | 54097 | 6833 | 95 |
2434338 | 2434338 | 2022-04-22 | Upshur | West Virginia | 54097 | 6833 | 95 |
2431082 | 2431082 | 2022-04-21 | Upshur | West Virginia | 54097 | 6829 | 95 |
2427826 | 2427826 | 2022-04-20 | Upshur | West Virginia | 54097 | 6825 | 95 |
2424570 | 2424570 | 2022-04-19 | Upshur | West Virginia | 54097 | 6822 | 95 |
2421314 | 2421314 | 2022-04-18 | Upshur | West Virginia | 54097 | 6822 | 95 |
2418058 | 2418058 | 2022-04-17 | Upshur | West Virginia | 54097 | 6818 | 95 |
2414802 | 2414802 | 2022-04-16 | Upshur | West Virginia | 54097 | 6818 | 95 |
2411546 | 2411546 | 2022-04-15 | Upshur | West Virginia | 54097 | 6818 | 95 |
2408290 | 2408290 | 2022-04-14 | Upshur | West Virginia | 54097 | 6818 | 95 |
2405034 | 2405034 | 2022-04-13 | Upshur | West Virginia | 54097 | 6818 | 95 |
2401779 | 2401779 | 2022-04-12 | Upshur | West Virginia | 54097 | 6816 | 95 |
2398509 | 2398509 | 2022-04-11 | Nicholas | West Virginia | 54067 | 7301 | 95 |
2398524 | 2398524 | 2022-04-11 | Upshur | West Virginia | 54097 | 6816 | 95 |
2395254 | 2395254 | 2022-04-10 | Nicholas | West Virginia | 54067 | 7300 | 95 |
2395269 | 2395269 | 2022-04-10 | Upshur | West Virginia | 54097 | 6818 | 95 |
2391998 | 2391998 | 2022-04-09 | Nicholas | West Virginia | 54067 | 7300 | 95 |
2392013 | 2392013 | 2022-04-09 | Upshur | West Virginia | 54097 | 6818 | 95 |
2388742 | 2388742 | 2022-04-08 | Nicholas | West Virginia | 54067 | 7300 | 95 |
2388757 | 2388757 | 2022-04-08 | Upshur | West Virginia | 54097 | 6818 | 95 |
2385487 | 2385487 | 2022-04-07 | Nicholas | West Virginia | 54067 | 7299 | 95 |
2385502 | 2385502 | 2022-04-07 | Upshur | West Virginia | 54097 | 6817 | 95 |
2382232 | 2382232 | 2022-04-06 | Nicholas | West Virginia | 54067 | 7299 | 95 |
2382247 | 2382247 | 2022-04-06 | Upshur | West Virginia | 54097 | 6817 | 95 |
2089519 | 2089519 | 2022-01-06 | Wayne | West Virginia | 54099 | 6809 | 95 |
2086268 | 2086268 | 2022-01-05 | Wayne | West Virginia | 54099 | 6752 | 95 |
2083016 | 2083016 | 2022-01-04 | Wayne | West Virginia | 54099 | 6710 | 95 |
2034231 | 2034231 | 2021-12-20 | Jefferson | West Virginia | 54037 | 8397 | 95 |
2034242 | 2034242 | 2021-12-20 | Mingo | West Virginia | 54059 | 5201 | 95 |
2030981 | 2030981 | 2021-12-19 | Jefferson | West Virginia | 54037 | 8364 | 95 |
2027730 | 2027730 | 2021-12-18 | Jefferson | West Virginia | 54037 | 8317 | 95 |
2024479 | 2024479 | 2021-12-17 | Jefferson | West Virginia | 54037 | 8237 | 95 |
2021228 | 2021228 | 2021-12-16 | Jefferson | West Virginia | 54037 | 8198 | 95 |
2017977 | 2017977 | 2021-12-15 | Jefferson | West Virginia | 54037 | 8130 | 95 |
1926981 | 1926981 | 2021-11-17 | Preston | West Virginia | 54077 | 5584 | 95 |
1874961 | 1874961 | 2021-11-01 | Greenbrier | West Virginia | 54025 | 4955 | 95 |
1871712 | 1871712 | 2021-10-31 | Greenbrier | West Virginia | 54025 | 4944 | 95 |
1868463 | 1868463 | 2021-10-30 | Greenbrier | West Virginia | 54025 | 4936 | 95 |
1865214 | 1865214 | 2021-10-29 | Greenbrier | West Virginia | 54025 | 4925 | 95 |
1861965 | 1861965 | 2021-10-28 | Greenbrier | West Virginia | 54025 | 4902 | 95 |
1771009 | 1771009 | 2021-09-30 | Ohio | West Virginia | 54069 | 5647 | 95 |
1767760 | 1767760 | 2021-09-29 | Ohio | West Virginia | 54069 | 5634 | 95 |
1764511 | 1764511 | 2021-09-28 | Ohio | West Virginia | 54069 | 5618 | 95 |
1761262 | 1761262 | 2021-09-27 | Ohio | West Virginia | 54069 | 5609 | 95 |
1748259 | 1748259 | 2021-09-23 | Marshall | West Virginia | 54051 | 4739 | 95 |
1719007 | 1719007 | 2021-09-14 | Harrison | West Virginia | 54033 | 7979 | 95 |
1715759 | 1715759 | 2021-09-13 | Harrison | West Virginia | 54033 | 7926 | 95 |
1442988 | 1442988 | 2021-06-21 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1439743 | 1439743 | 2021-06-20 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1436496 | 1436496 | 2021-06-19 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1433249 | 1433249 | 2021-06-18 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1430003 | 1430003 | 2021-06-17 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1420247 | 1420247 | 2021-06-14 | Logan | West Virginia | 54045 | 3267 | 95 |
1417002 | 1417002 | 2021-06-13 | Logan | West Virginia | 54045 | 3263 | 95 |
1413756 | 1413756 | 2021-06-12 | Logan | West Virginia | 54045 | 3263 | 95 |
1410511 | 1410511 | 2021-06-11 | Logan | West Virginia | 54045 | 3263 | 95 |
1407266 | 1407266 | 2021-06-10 | Logan | West Virginia | 54045 | 3262 | 95 |
1404020 | 1404020 | 2021-06-09 | Logan | West Virginia | 54045 | 3255 | 95 |
1400775 | 1400775 | 2021-06-08 | Logan | West Virginia | 54045 | 3249 | 95 |
1397530 | 1397530 | 2021-06-07 | Logan | West Virginia | 54045 | 3246 | 95 |
1394283 | 1394283 | 2021-06-06 | Logan | West Virginia | 54045 | 3229 | 95 |
1391038 | 1391038 | 2021-06-05 | Logan | West Virginia | 54045 | 3229 | 95 |
1387793 | 1387793 | 2021-06-04 | Logan | West Virginia | 54045 | 3229 | 95 |
1384548 | 1384548 | 2021-06-03 | Logan | West Virginia | 54045 | 3228 | 95 |
1381302 | 1381302 | 2021-06-02 | Logan | West Virginia | 54045 | 3224 | 95 |
1378057 | 1378057 | 2021-06-01 | Logan | West Virginia | 54045 | 3220 | 95 |
1374811 | 1374811 | 2021-05-31 | Logan | West Virginia | 54045 | 3208 | 95 |
1371566 | 1371566 | 2021-05-30 | Logan | West Virginia | 54045 | 3208 | 95 |
1368320 | 1368320 | 2021-05-29 | Logan | West Virginia | 54045 | 3208 | 95 |
1365074 | 1365074 | 2021-05-28 | Logan | West Virginia | 54045 | 3208 | 95 |
1361828 | 1361828 | 2021-05-27 | Logan | West Virginia | 54045 | 3202 | 95 |
1358582 | 1358582 | 2021-05-26 | Logan | West Virginia | 54045 | 3199 | 95 |
1199495 | 1199495 | 2021-04-07 | Putnam | West Virginia | 54079 | 4662 | 95 |
1173488 | 1173488 | 2021-03-30 | Hancock | West Virginia | 54029 | 2630 | 95 |
1170241 | 1170241 | 2021-03-29 | Hancock | West Virginia | 54029 | 2629 | 95 |
1166993 | 1166993 | 2021-03-28 | Hancock | West Virginia | 54029 | 2627 | 95 |
1163745 | 1163745 | 2021-03-27 | Hancock | West Virginia | 54029 | 2627 | 95 |
1160497 | 1160497 | 2021-03-26 | Hancock | West Virginia | 54029 | 2622 | 95 |
1157249 | 1157249 | 2021-03-25 | Hancock | West Virginia | 54029 | 2617 | 95 |
1154002 | 1154002 | 2021-03-24 | Hancock | West Virginia | 54029 | 2613 | 95 |
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);