ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
126 rows where deaths = 78 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 |
---|---|---|---|---|---|---|---|
2398497 | 2398497 | 2022-04-11 | Lincoln | West Virginia | 54043 | 5520 | 78 |
2395242 | 2395242 | 2022-04-10 | Lincoln | West Virginia | 54043 | 5522 | 78 |
2391986 | 2391986 | 2022-04-09 | Lincoln | West Virginia | 54043 | 5522 | 78 |
2388730 | 2388730 | 2022-04-08 | Lincoln | West Virginia | 54043 | 5522 | 78 |
2385475 | 2385475 | 2022-04-07 | Lincoln | West Virginia | 54043 | 5520 | 78 |
2382220 | 2382220 | 2022-04-06 | Lincoln | West Virginia | 54043 | 5520 | 78 |
2375711 | 2375711 | 2022-04-04 | Lincoln | West Virginia | 54043 | 5515 | 78 |
2372459 | 2372459 | 2022-04-03 | Lincoln | West Virginia | 54043 | 5510 | 78 |
2369206 | 2369206 | 2022-04-02 | Lincoln | West Virginia | 54043 | 5510 | 78 |
2365953 | 2365953 | 2022-04-01 | Lincoln | West Virginia | 54043 | 5510 | 78 |
2362700 | 2362700 | 2022-03-31 | Lincoln | West Virginia | 54043 | 5509 | 78 |
2359446 | 2359446 | 2022-03-30 | Lincoln | West Virginia | 54043 | 5508 | 78 |
2307415 | 2307415 | 2022-03-14 | Randolph | West Virginia | 54083 | 9314 | 78 |
2304164 | 2304164 | 2022-03-13 | Randolph | West Virginia | 54083 | 9319 | 78 |
2300912 | 2300912 | 2022-03-12 | Randolph | West Virginia | 54083 | 9319 | 78 |
2297660 | 2297660 | 2022-03-11 | Randolph | West Virginia | 54083 | 9319 | 78 |
2294408 | 2294408 | 2022-03-10 | Randolph | West Virginia | 54083 | 9312 | 78 |
2287883 | 2287883 | 2022-03-08 | Lewis | West Virginia | 54041 | 5268 | 78 |
2284631 | 2284631 | 2022-03-07 | Lewis | West Virginia | 54041 | 5260 | 78 |
2281379 | 2281379 | 2022-03-06 | Lewis | West Virginia | 54041 | 5249 | 78 |
2278126 | 2278126 | 2022-03-05 | Lewis | West Virginia | 54041 | 5249 | 78 |
2274873 | 2274873 | 2022-03-04 | Lewis | West Virginia | 54041 | 5249 | 78 |
2271620 | 2271620 | 2022-03-03 | Lewis | West Virginia | 54041 | 5239 | 78 |
2268368 | 2268368 | 2022-03-02 | Lewis | West Virginia | 54041 | 5228 | 78 |
2265115 | 2265115 | 2022-03-01 | Lewis | West Virginia | 54041 | 5219 | 78 |
2261865 | 2261865 | 2022-02-28 | Lewis | West Virginia | 54041 | 5209 | 78 |
2258614 | 2258614 | 2022-02-27 | Lewis | West Virginia | 54041 | 5182 | 78 |
2258645 | 2258645 | 2022-02-27 | Wetzel | West Virginia | 54103 | 4234 | 78 |
2255363 | 2255363 | 2022-02-26 | Lewis | West Virginia | 54041 | 5182 | 78 |
2255394 | 2255394 | 2022-02-26 | Wetzel | West Virginia | 54103 | 4234 | 78 |
2252112 | 2252112 | 2022-02-25 | Lewis | West Virginia | 54041 | 5182 | 78 |
2252143 | 2252143 | 2022-02-25 | Wetzel | West Virginia | 54103 | 4234 | 78 |
2248861 | 2248861 | 2022-02-24 | Lewis | West Virginia | 54041 | 5165 | 78 |
2248892 | 2248892 | 2022-02-24 | Wetzel | West Virginia | 54103 | 4224 | 78 |
2245610 | 2245610 | 2022-02-23 | Lewis | West Virginia | 54041 | 5147 | 78 |
2242359 | 2242359 | 2022-02-22 | Lewis | West Virginia | 54041 | 5128 | 78 |
2219630 | 2219630 | 2022-02-15 | Upshur | West Virginia | 54097 | 6452 | 78 |
2216380 | 2216380 | 2022-02-14 | Upshur | West Virginia | 54097 | 6437 | 78 |
2213129 | 2213129 | 2022-02-13 | Upshur | West Virginia | 54097 | 6409 | 78 |
2209876 | 2209876 | 2022-02-12 | Upshur | West Virginia | 54097 | 6388 | 78 |
2206623 | 2206623 | 2022-02-11 | Upshur | West Virginia | 54097 | 6354 | 78 |
2203370 | 2203370 | 2022-02-10 | Upshur | West Virginia | 54097 | 6283 | 78 |
2200116 | 2200116 | 2022-02-09 | Upshur | West Virginia | 54097 | 6228 | 78 |
2177322 | 2177322 | 2022-02-02 | Mason | West Virginia | 54053 | 5813 | 78 |
2148048 | 2148048 | 2022-01-24 | Nicholas | West Virginia | 54067 | 5966 | 78 |
2144796 | 2144796 | 2022-01-23 | Nicholas | West Virginia | 54067 | 5895 | 78 |
2141541 | 2141541 | 2022-01-22 | Nicholas | West Virginia | 54067 | 5805 | 78 |
2138285 | 2138285 | 2022-01-21 | Nicholas | West Virginia | 54067 | 5686 | 78 |
2135030 | 2135030 | 2022-01-20 | Nicholas | West Virginia | 54067 | 5584 | 78 |
2131778 | 2131778 | 2022-01-19 | Nicholas | West Virginia | 54067 | 5507 | 78 |
2128524 | 2128524 | 2022-01-18 | Nicholas | West Virginia | 54067 | 5448 | 78 |
2125271 | 2125271 | 2022-01-17 | Nicholas | West Virginia | 54067 | 5402 | 78 |
2122019 | 2122019 | 2022-01-16 | Nicholas | West Virginia | 54067 | 5358 | 78 |
2118767 | 2118767 | 2022-01-15 | Nicholas | West Virginia | 54067 | 5322 | 78 |
2115515 | 2115515 | 2022-01-14 | Nicholas | West Virginia | 54067 | 5271 | 78 |
2112263 | 2112263 | 2022-01-13 | Nicholas | West Virginia | 54067 | 5241 | 78 |
2109011 | 2109011 | 2022-01-12 | Nicholas | West Virginia | 54067 | 5203 | 78 |
2109032 | 2109032 | 2022-01-12 | Wyoming | West Virginia | 54109 | 4617 | 78 |
1985456 | 1985456 | 2021-12-05 | Brooke | West Virginia | 54009 | 3428 | 78 |
1982206 | 1982206 | 2021-12-04 | Brooke | West Virginia | 54009 | 3417 | 78 |
1978956 | 1978956 | 2021-12-03 | Brooke | West Virginia | 54009 | 3409 | 78 |
1975706 | 1975706 | 2021-12-02 | Brooke | West Virginia | 54009 | 3388 | 78 |
1972457 | 1972457 | 2021-12-01 | Brooke | West Virginia | 54009 | 3370 | 78 |
1969207 | 1969207 | 2021-11-30 | Brooke | West Virginia | 54009 | 3350 | 78 |
1965957 | 1965957 | 2021-11-29 | Brooke | West Virginia | 54009 | 3342 | 78 |
1962705 | 1962705 | 2021-11-28 | Brooke | West Virginia | 54009 | 3309 | 78 |
1959454 | 1959454 | 2021-11-27 | Brooke | West Virginia | 54009 | 3309 | 78 |
1956203 | 1956203 | 2021-11-26 | Brooke | West Virginia | 54009 | 3309 | 78 |
1952952 | 1952952 | 2021-11-25 | Brooke | West Virginia | 54009 | 3309 | 78 |
1949701 | 1949701 | 2021-11-24 | Brooke | West Virginia | 54009 | 3309 | 78 |
1874998 | 1874998 | 2021-11-01 | Wayne | West Virginia | 54099 | 5674 | 78 |
1871749 | 1871749 | 2021-10-31 | Wayne | West Virginia | 54099 | 5668 | 78 |
1868500 | 1868500 | 2021-10-30 | Wayne | West Virginia | 54099 | 5661 | 78 |
1865251 | 1865251 | 2021-10-29 | Wayne | West Virginia | 54099 | 5648 | 78 |
1862002 | 1862002 | 2021-10-28 | Wayne | West Virginia | 54099 | 5640 | 78 |
1858753 | 1858753 | 2021-10-27 | Wayne | West Virginia | 54099 | 5628 | 78 |
1855504 | 1855504 | 2021-10-26 | Wayne | West Virginia | 54099 | 5611 | 78 |
1839236 | 1839236 | 2021-10-21 | Mingo | West Virginia | 54059 | 4513 | 78 |
1835987 | 1835987 | 2021-10-20 | Mingo | West Virginia | 54059 | 4495 | 78 |
1748247 | 1748247 | 2021-09-23 | Greenbrier | West Virginia | 54025 | 4209 | 78 |
1468933 | 1468933 | 2021-06-29 | Marshall | West Virginia | 54051 | 3537 | 78 |
1465688 | 1465688 | 2021-06-28 | Marshall | West Virginia | 54051 | 3537 | 78 |
1462443 | 1462443 | 2021-06-27 | Marshall | West Virginia | 54051 | 3536 | 78 |
1459198 | 1459198 | 2021-06-26 | Marshall | West Virginia | 54051 | 3536 | 78 |
1455953 | 1455953 | 2021-06-25 | Marshall | West Virginia | 54051 | 3536 | 78 |
1452708 | 1452708 | 2021-06-24 | Marshall | West Virginia | 54051 | 3536 | 78 |
1449462 | 1449462 | 2021-06-23 | Marshall | West Virginia | 54051 | 3536 | 78 |
1446217 | 1446217 | 2021-06-22 | Marshall | West Virginia | 54051 | 3536 | 78 |
1442972 | 1442972 | 2021-06-21 | Marshall | West Virginia | 54051 | 3536 | 78 |
1439727 | 1439727 | 2021-06-20 | Marshall | West Virginia | 54051 | 3536 | 78 |
1436480 | 1436480 | 2021-06-19 | Marshall | West Virginia | 54051 | 3536 | 78 |
1433233 | 1433233 | 2021-06-18 | Marshall | West Virginia | 54051 | 3536 | 78 |
1429987 | 1429987 | 2021-06-17 | Marshall | West Virginia | 54051 | 3536 | 78 |
1426742 | 1426742 | 2021-06-16 | Marshall | West Virginia | 54051 | 3533 | 78 |
1423496 | 1423496 | 2021-06-15 | Marshall | West Virginia | 54051 | 3533 | 78 |
1420249 | 1420249 | 2021-06-14 | Marshall | West Virginia | 54051 | 3533 | 78 |
1417004 | 1417004 | 2021-06-13 | Marshall | West Virginia | 54051 | 3531 | 78 |
1413758 | 1413758 | 2021-06-12 | Marshall | West Virginia | 54051 | 3531 | 78 |
1410513 | 1410513 | 2021-06-11 | Marshall | West Virginia | 54051 | 3531 | 78 |
1355323 | 1355323 | 2021-05-25 | Fayette | West Virginia | 54019 | 3497 | 78 |
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);