ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 173 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- West Virginia · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398515 | 2398515 | 2022-04-11 | Putnam | West Virginia | 54079 | 16650 | 173 |
2395260 | 2395260 | 2022-04-10 | Putnam | West Virginia | 54079 | 16646 | 173 |
2392004 | 2392004 | 2022-04-09 | Putnam | West Virginia | 54079 | 16646 | 173 |
2388748 | 2388748 | 2022-04-08 | Putnam | West Virginia | 54079 | 16646 | 173 |
2385493 | 2385493 | 2022-04-07 | Putnam | West Virginia | 54079 | 16636 | 173 |
2330185 | 2330185 | 2022-03-21 | Putnam | West Virginia | 54079 | 16574 | 173 |
2326933 | 2326933 | 2022-03-20 | Putnam | West Virginia | 54079 | 16567 | 173 |
2323680 | 2323680 | 2022-03-19 | Putnam | West Virginia | 54079 | 16567 | 173 |
2320426 | 2320426 | 2022-03-18 | Putnam | West Virginia | 54079 | 16567 | 173 |
2307397 | 2307397 | 2022-03-14 | Marion | West Virginia | 54049 | 14836 | 173 |
2291137 | 2291137 | 2022-03-09 | Logan | West Virginia | 54045 | 9518 | 173 |
2287885 | 2287885 | 2022-03-08 | Logan | West Virginia | 54045 | 9515 | 173 |
2261854 | 2261854 | 2022-02-28 | Fayette | West Virginia | 54019 | 12817 | 173 |
1939961 | 1939961 | 2021-11-21 | Harrison | West Virginia | 54033 | 11964 | 173 |
1936711 | 1936711 | 2021-11-20 | Harrison | West Virginia | 54033 | 11943 | 173 |
1933461 | 1933461 | 2021-11-19 | Harrison | West Virginia | 54033 | 11914 | 173 |
1871740 | 1871740 | 2021-10-31 | Raleigh | West Virginia | 54081 | 11490 | 173 |
1868491 | 1868491 | 2021-10-30 | Raleigh | West Virginia | 54081 | 11477 | 173 |
1865242 | 1865242 | 2021-10-29 | Raleigh | West Virginia | 54081 | 11439 | 173 |
1861993 | 1861993 | 2021-10-28 | Raleigh | West Virginia | 54081 | 11401 | 173 |
1826212 | 1826212 | 2021-10-17 | Berkeley | West Virginia | 54003 | 17936 | 173 |
1822963 | 1822963 | 2021-10-16 | Berkeley | West Virginia | 54003 | 17882 | 173 |
1819714 | 1819714 | 2021-10-15 | Berkeley | West Virginia | 54003 | 17810 | 173 |
1394314 | 1394314 | 2021-06-06 | Wood | West Virginia | 54107 | 7902 | 173 |
1391069 | 1391069 | 2021-06-05 | Wood | West Virginia | 54107 | 7902 | 173 |
1387824 | 1387824 | 2021-06-04 | Wood | West Virginia | 54107 | 7902 | 173 |
1384579 | 1384579 | 2021-06-03 | Wood | West Virginia | 54107 | 7898 | 173 |
1381285 | 1381285 | 2021-06-02 | Cabell | West Virginia | 54011 | 8812 | 173 |
1381333 | 1381333 | 2021-06-02 | Wood | West Virginia | 54107 | 7895 | 173 |
1378040 | 1378040 | 2021-06-01 | Cabell | West Virginia | 54011 | 8804 | 173 |
1378088 | 1378088 | 2021-06-01 | Wood | West Virginia | 54107 | 7892 | 173 |
1374794 | 1374794 | 2021-05-31 | Cabell | West Virginia | 54011 | 8794 | 173 |
1374842 | 1374842 | 2021-05-31 | Wood | West Virginia | 54107 | 7879 | 173 |
1371549 | 1371549 | 2021-05-30 | Cabell | West Virginia | 54011 | 8794 | 173 |
1371597 | 1371597 | 2021-05-30 | Wood | West Virginia | 54107 | 7879 | 173 |
1368303 | 1368303 | 2021-05-29 | Cabell | West Virginia | 54011 | 8794 | 173 |
1368351 | 1368351 | 2021-05-29 | Wood | West Virginia | 54107 | 7879 | 173 |
1365057 | 1365057 | 2021-05-28 | Cabell | West Virginia | 54011 | 8794 | 173 |
1365105 | 1365105 | 2021-05-28 | Wood | West Virginia | 54107 | 7879 | 173 |
1361811 | 1361811 | 2021-05-27 | Cabell | West Virginia | 54011 | 8788 | 173 |
1361859 | 1361859 | 2021-05-27 | Wood | West Virginia | 54107 | 7875 | 173 |
1358565 | 1358565 | 2021-05-26 | Cabell | West Virginia | 54011 | 8784 | 173 |
1355319 | 1355319 | 2021-05-25 | Cabell | West Virginia | 54011 | 8780 | 173 |
1157240 | 1157240 | 2021-03-25 | Cabell | West Virginia | 54011 | 8260 | 173 |
1153993 | 1153993 | 2021-03-24 | Cabell | West Virginia | 54011 | 8246 | 173 |
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);