ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where deaths = 85 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 |
---|---|---|---|---|---|---|---|
2444078 | 2444078 | 2022-04-25 | Lewis | West Virginia | 54041 | 5324 | 85 |
2440822 | 2440822 | 2022-04-24 | Lewis | West Virginia | 54041 | 5321 | 85 |
2437566 | 2437566 | 2022-04-23 | Lewis | West Virginia | 54041 | 5321 | 85 |
2434310 | 2434310 | 2022-04-22 | Lewis | West Virginia | 54041 | 5321 | 85 |
2431054 | 2431054 | 2022-04-21 | Lewis | West Virginia | 54041 | 5322 | 85 |
2427798 | 2427798 | 2022-04-20 | Lewis | West Virginia | 54041 | 5320 | 85 |
2427829 | 2427829 | 2022-04-20 | Wetzel | West Virginia | 54103 | 4337 | 85 |
2424542 | 2424542 | 2022-04-19 | Lewis | West Virginia | 54041 | 5317 | 85 |
2424573 | 2424573 | 2022-04-19 | Wetzel | West Virginia | 54103 | 4337 | 85 |
2421286 | 2421286 | 2022-04-18 | Lewis | West Virginia | 54041 | 5316 | 85 |
2421317 | 2421317 | 2022-04-18 | Wetzel | West Virginia | 54103 | 4337 | 85 |
2418030 | 2418030 | 2022-04-17 | Lewis | West Virginia | 54041 | 5316 | 85 |
2414774 | 2414774 | 2022-04-16 | Lewis | West Virginia | 54041 | 5316 | 85 |
2411518 | 2411518 | 2022-04-15 | Lewis | West Virginia | 54041 | 5316 | 85 |
2408262 | 2408262 | 2022-04-14 | Lewis | West Virginia | 54041 | 5317 | 85 |
2405006 | 2405006 | 2022-04-13 | Lewis | West Virginia | 54041 | 5316 | 85 |
2405027 | 2405027 | 2022-04-13 | Randolph | West Virginia | 54083 | 9399 | 85 |
2401751 | 2401751 | 2022-04-12 | Lewis | West Virginia | 54041 | 5318 | 85 |
2401772 | 2401772 | 2022-04-12 | Randolph | West Virginia | 54083 | 9398 | 85 |
2398496 | 2398496 | 2022-04-11 | Lewis | West Virginia | 54041 | 5318 | 85 |
2395241 | 2395241 | 2022-04-10 | Lewis | West Virginia | 54041 | 5314 | 85 |
2391985 | 2391985 | 2022-04-09 | Lewis | West Virginia | 54041 | 5314 | 85 |
2388729 | 2388729 | 2022-04-08 | Lewis | West Virginia | 54041 | 5314 | 85 |
2385474 | 2385474 | 2022-04-07 | Lewis | West Virginia | 54041 | 5314 | 85 |
2382219 | 2382219 | 2022-04-06 | Lewis | West Virginia | 54041 | 5314 | 85 |
2378964 | 2378964 | 2022-04-05 | Lewis | West Virginia | 54041 | 5313 | 85 |
2313900 | 2313900 | 2022-03-16 | Lewis | West Virginia | 54041 | 5281 | 85 |
2291163 | 2291163 | 2022-03-09 | Upshur | West Virginia | 54097 | 6755 | 85 |
2287911 | 2287911 | 2022-03-08 | Upshur | West Virginia | 54097 | 6747 | 85 |
2284659 | 2284659 | 2022-03-07 | Upshur | West Virginia | 54097 | 6745 | 85 |
2203347 | 2203347 | 2022-02-10 | Mason | West Virginia | 54053 | 6194 | 85 |
2203355 | 2203355 | 2022-02-10 | Nicholas | West Virginia | 54067 | 6752 | 85 |
2200093 | 2200093 | 2022-02-09 | Mason | West Virginia | 54053 | 6153 | 85 |
2200101 | 2200101 | 2022-02-09 | Nicholas | West Virginia | 54067 | 6705 | 85 |
2193613 | 2193613 | 2022-02-07 | Wyoming | West Virginia | 54109 | 6339 | 85 |
2190360 | 2190360 | 2022-02-06 | Wyoming | West Virginia | 54109 | 6326 | 85 |
2187107 | 2187107 | 2022-02-05 | Wyoming | West Virginia | 54109 | 6292 | 85 |
2183854 | 2183854 | 2022-02-04 | Wyoming | West Virginia | 54109 | 6246 | 85 |
2180602 | 2180602 | 2022-02-03 | Wyoming | West Virginia | 54109 | 6190 | 85 |
2037467 | 2037467 | 2021-12-21 | Brooke | West Virginia | 54009 | 3586 | 85 |
2034217 | 2034217 | 2021-12-20 | Brooke | West Virginia | 54009 | 3570 | 85 |
2030967 | 2030967 | 2021-12-19 | Brooke | West Virginia | 54009 | 3561 | 85 |
2027716 | 2027716 | 2021-12-18 | Brooke | West Virginia | 54009 | 3553 | 85 |
2024465 | 2024465 | 2021-12-17 | Brooke | West Virginia | 54009 | 3543 | 85 |
1920493 | 1920493 | 2021-11-15 | Wayne | West Virginia | 54099 | 5832 | 85 |
1871718 | 1871718 | 2021-10-31 | Jefferson | West Virginia | 54037 | 6828 | 85 |
1871738 | 1871738 | 2021-10-31 | Preston | West Virginia | 54077 | 5262 | 85 |
1868469 | 1868469 | 2021-10-30 | Jefferson | West Virginia | 54037 | 6818 | 85 |
1868489 | 1868489 | 2021-10-30 | Preston | West Virginia | 54077 | 5246 | 85 |
1865220 | 1865220 | 2021-10-29 | Jefferson | West Virginia | 54037 | 6801 | 85 |
1865240 | 1865240 | 2021-10-29 | Preston | West Virginia | 54077 | 5234 | 85 |
1861971 | 1861971 | 2021-10-28 | Jefferson | West Virginia | 54037 | 6780 | 85 |
1858721 | 1858721 | 2021-10-27 | Jackson | West Virginia | 54035 | 3944 | 85 |
1858722 | 1858722 | 2021-10-27 | Jefferson | West Virginia | 54037 | 6762 | 85 |
1855473 | 1855473 | 2021-10-26 | Jefferson | West Virginia | 54037 | 6749 | 85 |
1689775 | 1689775 | 2021-09-05 | Harrison | West Virginia | 54033 | 7412 | 85 |
1686525 | 1686525 | 2021-09-04 | Harrison | West Virginia | 54033 | 7366 | 85 |
1683274 | 1683274 | 2021-09-03 | Harrison | West Virginia | 54033 | 7300 | 85 |
1673537 | 1673537 | 2021-08-31 | Marshall | West Virginia | 54051 | 4083 | 85 |
1670289 | 1670289 | 2021-08-30 | Marshall | West Virginia | 54051 | 4068 | 85 |
1667042 | 1667042 | 2021-08-29 | Marshall | West Virginia | 54051 | 4048 | 85 |
1309898 | 1309898 | 2021-05-11 | Raleigh | West Virginia | 54081 | 6760 | 85 |
1306640 | 1306640 | 2021-05-10 | Mineral | West Virginia | 54057 | 2849 | 85 |
1306652 | 1306652 | 2021-05-10 | Raleigh | West Virginia | 54081 | 6742 | 85 |
1303394 | 1303394 | 2021-05-09 | Mineral | West Virginia | 54057 | 2846 | 85 |
1303406 | 1303406 | 2021-05-09 | Raleigh | West Virginia | 54081 | 6735 | 85 |
1300147 | 1300147 | 2021-05-08 | Mineral | West Virginia | 54057 | 2844 | 85 |
1300159 | 1300159 | 2021-05-08 | Raleigh | West Virginia | 54081 | 6723 | 85 |
1296900 | 1296900 | 2021-05-07 | Mineral | West Virginia | 54057 | 2840 | 85 |
1293654 | 1293654 | 2021-05-06 | Mineral | West Virginia | 54057 | 2837 | 85 |
1261175 | 1261175 | 2021-04-26 | Harrison | West Virginia | 54033 | 5512 | 85 |
1257928 | 1257928 | 2021-04-25 | Harrison | West Virginia | 54033 | 5506 | 85 |
1254681 | 1254681 | 2021-04-24 | Harrison | West Virginia | 54033 | 5488 | 85 |
1251434 | 1251434 | 2021-04-23 | Harrison | West Virginia | 54033 | 5481 | 85 |
1248187 | 1248187 | 2021-04-22 | Harrison | West Virginia | 54033 | 5473 | 85 |
1244940 | 1244940 | 2021-04-21 | Harrison | West Virginia | 54033 | 5461 | 85 |
1241693 | 1241693 | 2021-04-20 | Harrison | West Virginia | 54033 | 5449 | 85 |
1241711 | 1241711 | 2021-04-20 | Ohio | West Virginia | 54069 | 4050 | 85 |
1238446 | 1238446 | 2021-04-19 | Harrison | West Virginia | 54033 | 5415 | 85 |
1238464 | 1238464 | 2021-04-19 | Ohio | West Virginia | 54069 | 4047 | 85 |
1235199 | 1235199 | 2021-04-18 | Harrison | West Virginia | 54033 | 5405 | 85 |
1235217 | 1235217 | 2021-04-18 | Ohio | West Virginia | 54069 | 4046 | 85 |
1231969 | 1231969 | 2021-04-17 | Ohio | West Virginia | 54069 | 4030 | 85 |
1228721 | 1228721 | 2021-04-16 | Ohio | West Virginia | 54069 | 4018 | 85 |
1225473 | 1225473 | 2021-04-15 | Ohio | West Virginia | 54069 | 4003 | 85 |
1222226 | 1222226 | 2021-04-14 | Ohio | West Virginia | 54069 | 3993 | 85 |
1218978 | 1218978 | 2021-04-13 | Ohio | West Virginia | 54069 | 3985 | 85 |
1196237 | 1196237 | 2021-04-06 | Monongalia | West Virginia | 54061 | 8731 | 85 |
1192989 | 1192989 | 2021-04-05 | Monongalia | West Virginia | 54061 | 8720 | 85 |
1189739 | 1189739 | 2021-04-04 | Monongalia | West Virginia | 54061 | 8709 | 85 |
1186492 | 1186492 | 2021-04-03 | Monongalia | West Virginia | 54061 | 8697 | 85 |
1183245 | 1183245 | 2021-04-02 | Monongalia | West Virginia | 54061 | 8675 | 85 |
1179998 | 1179998 | 2021-04-01 | Monongalia | West Virginia | 54061 | 8683 | 85 |
1176751 | 1176751 | 2021-03-31 | Monongalia | West Virginia | 54061 | 8655 | 85 |
1173504 | 1173504 | 2021-03-30 | Monongalia | West Virginia | 54061 | 8633 | 85 |
1170257 | 1170257 | 2021-03-29 | Monongalia | West Virginia | 54061 | 8628 | 85 |
1167009 | 1167009 | 2021-03-28 | Monongalia | West Virginia | 54061 | 8612 | 85 |
1163761 | 1163761 | 2021-03-27 | Monongalia | West Virginia | 54061 | 8587 | 85 |
1137793 | 1137793 | 2021-03-19 | Putnam | West Virginia | 54079 | 4390 | 85 |
1050123 | 1050123 | 2021-02-20 | Hancock | West Virginia | 54029 | 2570 | 85 |
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);