ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
381 rows where deaths = 19 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 |
---|---|---|---|---|---|---|---|
2502693 | 2502693 | 2022-05-13 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2499435 | 2499435 | 2022-05-12 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2496177 | 2496177 | 2022-05-11 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2492919 | 2492919 | 2022-05-10 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2489661 | 2489661 | 2022-05-09 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2486404 | 2486404 | 2022-05-08 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2483146 | 2483146 | 2022-05-07 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2479888 | 2479888 | 2022-05-06 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2476630 | 2476630 | 2022-05-05 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2473372 | 2473372 | 2022-05-04 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2470115 | 2470115 | 2022-05-03 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2466859 | 2466859 | 2022-05-02 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2463604 | 2463604 | 2022-05-01 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2460348 | 2460348 | 2022-04-30 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2457092 | 2457092 | 2022-04-29 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2453836 | 2453836 | 2022-04-28 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2450580 | 2450580 | 2022-04-27 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2447324 | 2447324 | 2022-04-26 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2444068 | 2444068 | 2022-04-25 | Gilmer | West Virginia | 54021 | 2096 | 19 |
2440812 | 2440812 | 2022-04-24 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2437556 | 2437556 | 2022-04-23 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2434300 | 2434300 | 2022-04-22 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2431044 | 2431044 | 2022-04-21 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2427788 | 2427788 | 2022-04-20 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2424532 | 2424532 | 2022-04-19 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2421276 | 2421276 | 2022-04-18 | Gilmer | West Virginia | 54021 | 2093 | 19 |
2418020 | 2418020 | 2022-04-17 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2414764 | 2414764 | 2022-04-16 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2411508 | 2411508 | 2022-04-15 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2408252 | 2408252 | 2022-04-14 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2404996 | 2404996 | 2022-04-13 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2401741 | 2401741 | 2022-04-12 | Gilmer | West Virginia | 54021 | 2092 | 19 |
2398486 | 2398486 | 2022-04-11 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2395231 | 2395231 | 2022-04-10 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2391975 | 2391975 | 2022-04-09 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2388719 | 2388719 | 2022-04-08 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2385464 | 2385464 | 2022-04-07 | Gilmer | West Virginia | 54021 | 2091 | 19 |
2382209 | 2382209 | 2022-04-06 | Gilmer | West Virginia | 54021 | 2090 | 19 |
2378954 | 2378954 | 2022-04-05 | Gilmer | West Virginia | 54021 | 2090 | 19 |
2375700 | 2375700 | 2022-04-04 | Gilmer | West Virginia | 54021 | 2089 | 19 |
2372448 | 2372448 | 2022-04-03 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2369195 | 2369195 | 2022-04-02 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2365942 | 2365942 | 2022-04-01 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2362689 | 2362689 | 2022-03-31 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2359435 | 2359435 | 2022-03-30 | Gilmer | West Virginia | 54021 | 2088 | 19 |
2196866 | 2196866 | 2022-02-08 | Wirt | West Virginia | 54105 | 1378 | 19 |
2193611 | 2193611 | 2022-02-07 | Wirt | West Virginia | 54105 | 1369 | 19 |
2190358 | 2190358 | 2022-02-06 | Wirt | West Virginia | 54105 | 1368 | 19 |
2187105 | 2187105 | 2022-02-05 | Wirt | West Virginia | 54105 | 1364 | 19 |
2183852 | 2183852 | 2022-02-04 | Wirt | West Virginia | 54105 | 1361 | 19 |
2180600 | 2180600 | 2022-02-03 | Wirt | West Virginia | 54105 | 1351 | 19 |
2177349 | 2177349 | 2022-02-02 | Wirt | West Virginia | 54105 | 1345 | 19 |
2174096 | 2174096 | 2022-02-01 | Wirt | West Virginia | 54105 | 1335 | 19 |
2170844 | 2170844 | 2022-01-31 | Wirt | West Virginia | 54105 | 1335 | 19 |
2167591 | 2167591 | 2022-01-30 | Wirt | West Virginia | 54105 | 1330 | 19 |
2164336 | 2164336 | 2022-01-29 | Wirt | West Virginia | 54105 | 1326 | 19 |
2161081 | 2161081 | 2022-01-28 | Wirt | West Virginia | 54105 | 1308 | 19 |
2157825 | 2157825 | 2022-01-27 | Wirt | West Virginia | 54105 | 1292 | 19 |
2154572 | 2154572 | 2022-01-26 | Wirt | West Virginia | 54105 | 1288 | 19 |
2151319 | 2151319 | 2022-01-25 | Wirt | West Virginia | 54105 | 1277 | 19 |
2148067 | 2148067 | 2022-01-24 | Wirt | West Virginia | 54105 | 1265 | 19 |
2144815 | 2144815 | 2022-01-23 | Wirt | West Virginia | 54105 | 1245 | 19 |
2141560 | 2141560 | 2022-01-22 | Wirt | West Virginia | 54105 | 1223 | 19 |
2138304 | 2138304 | 2022-01-21 | Wirt | West Virginia | 54105 | 1212 | 19 |
2135049 | 2135049 | 2022-01-20 | Wirt | West Virginia | 54105 | 1185 | 19 |
2131797 | 2131797 | 2022-01-19 | Wirt | West Virginia | 54105 | 1171 | 19 |
2128543 | 2128543 | 2022-01-18 | Wirt | West Virginia | 54105 | 1157 | 19 |
2125290 | 2125290 | 2022-01-17 | Wirt | West Virginia | 54105 | 1147 | 19 |
2122038 | 2122038 | 2022-01-16 | Wirt | West Virginia | 54105 | 1136 | 19 |
2118786 | 2118786 | 2022-01-15 | Wirt | West Virginia | 54105 | 1121 | 19 |
2115534 | 2115534 | 2022-01-14 | Wirt | West Virginia | 54105 | 1111 | 19 |
2112282 | 2112282 | 2022-01-13 | Wirt | West Virginia | 54105 | 1090 | 19 |
2109030 | 2109030 | 2022-01-12 | Wirt | West Virginia | 54105 | 1076 | 19 |
2105779 | 2105779 | 2022-01-11 | Wirt | West Virginia | 54105 | 1071 | 19 |
2102528 | 2102528 | 2022-01-10 | Wirt | West Virginia | 54105 | 1066 | 19 |
2099277 | 2099277 | 2022-01-09 | Wirt | West Virginia | 54105 | 1058 | 19 |
2096026 | 2096026 | 2022-01-08 | Wirt | West Virginia | 54105 | 1053 | 19 |
2092774 | 2092774 | 2022-01-07 | Wirt | West Virginia | 54105 | 1050 | 19 |
1965990 | 1965990 | 2021-11-29 | Pocahontas | West Virginia | 54075 | 1257 | 19 |
1962738 | 1962738 | 2021-11-28 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1959487 | 1959487 | 2021-11-27 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1956236 | 1956236 | 2021-11-26 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1952985 | 1952985 | 2021-11-25 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1949734 | 1949734 | 2021-11-24 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1904246 | 1904246 | 2021-11-10 | Webster | West Virginia | 54101 | 1238 | 19 |
1900996 | 1900996 | 2021-11-09 | Webster | West Virginia | 54101 | 1231 | 19 |
1897746 | 1897746 | 2021-11-08 | Webster | West Virginia | 54101 | 1214 | 19 |
1881494 | 1881494 | 2021-11-03 | Tyler | West Virginia | 54095 | 1364 | 19 |
1878245 | 1878245 | 2021-11-02 | Tyler | West Virginia | 54095 | 1365 | 19 |
1874996 | 1874996 | 2021-11-01 | Tyler | West Virginia | 54095 | 1363 | 19 |
1871747 | 1871747 | 2021-10-31 | Tyler | West Virginia | 54095 | 1360 | 19 |
1868498 | 1868498 | 2021-10-30 | Tyler | West Virginia | 54095 | 1359 | 19 |
1865249 | 1865249 | 2021-10-29 | Tyler | West Virginia | 54095 | 1359 | 19 |
1862000 | 1862000 | 2021-10-28 | Tyler | West Virginia | 54095 | 1359 | 19 |
1858746 | 1858746 | 2021-10-27 | Ritchie | West Virginia | 54085 | 1460 | 19 |
1855462 | 1855462 | 2021-10-26 | Clay | West Virginia | 54015 | 1224 | 19 |
1855497 | 1855497 | 2021-10-26 | Ritchie | West Virginia | 54085 | 1457 | 19 |
1855498 | 1855498 | 2021-10-26 | Roane | West Virginia | 54087 | 1478 | 19 |
1852213 | 1852213 | 2021-10-25 | Clay | West Virginia | 54015 | 1223 | 19 |
1852248 | 1852248 | 2021-10-25 | Ritchie | West Virginia | 54085 | 1454 | 19 |
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);