ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 54089 and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
50995 | 50995 | 2020-04-11 | Summers | West Virginia | 54089 | 1 | 0 |
53672 | 53672 | 2020-04-12 | Summers | West Virginia | 54089 | 1 | 0 |
56362 | 56362 | 2020-04-13 | Summers | West Virginia | 54089 | 1 | 0 |
59069 | 59069 | 2020-04-14 | Summers | West Virginia | 54089 | 1 | 0 |
61788 | 61788 | 2020-04-15 | Summers | West Virginia | 54089 | 1 | 0 |
64521 | 64521 | 2020-04-16 | Summers | West Virginia | 54089 | 1 | 0 |
67269 | 67269 | 2020-04-17 | Summers | West Virginia | 54089 | 1 | 0 |
70031 | 70031 | 2020-04-18 | Summers | West Virginia | 54089 | 1 | 0 |
72800 | 72800 | 2020-04-19 | Summers | West Virginia | 54089 | 1 | 0 |
75576 | 75576 | 2020-04-20 | Summers | West Virginia | 54089 | 1 | 0 |
78359 | 78359 | 2020-04-21 | Summers | West Virginia | 54089 | 1 | 0 |
81152 | 81152 | 2020-04-22 | Summers | West Virginia | 54089 | 1 | 0 |
83953 | 83953 | 2020-04-23 | Summers | West Virginia | 54089 | 1 | 0 |
86760 | 86760 | 2020-04-24 | Summers | West Virginia | 54089 | 1 | 0 |
89576 | 89576 | 2020-04-25 | Summers | West Virginia | 54089 | 1 | 0 |
92394 | 92394 | 2020-04-26 | Summers | West Virginia | 54089 | 1 | 0 |
95224 | 95224 | 2020-04-27 | Summers | West Virginia | 54089 | 1 | 0 |
98069 | 98069 | 2020-04-28 | Summers | West Virginia | 54089 | 1 | 0 |
100919 | 100919 | 2020-04-29 | Summers | West Virginia | 54089 | 1 | 0 |
103774 | 103774 | 2020-04-30 | Summers | West Virginia | 54089 | 1 | 0 |
106638 | 106638 | 2020-05-01 | Summers | West Virginia | 54089 | 1 | 0 |
109507 | 109507 | 2020-05-02 | Summers | West Virginia | 54089 | 1 | 0 |
112382 | 112382 | 2020-05-03 | Summers | West Virginia | 54089 | 1 | 0 |
115265 | 115265 | 2020-05-04 | Summers | West Virginia | 54089 | 1 | 0 |
118224 | 118224 | 2020-05-05 | Summers | West Virginia | 54089 | 1 | 0 |
121189 | 121189 | 2020-05-06 | Summers | West Virginia | 54089 | 1 | 0 |
124169 | 124169 | 2020-05-07 | Summers | West Virginia | 54089 | 1 | 0 |
127154 | 127154 | 2020-05-08 | Summers | West Virginia | 54089 | 1 | 0 |
130144 | 130144 | 2020-05-09 | Summers | West Virginia | 54089 | 1 | 0 |
133134 | 133134 | 2020-05-10 | Summers | West Virginia | 54089 | 1 | 0 |
136124 | 136124 | 2020-05-11 | Summers | West Virginia | 54089 | 1 | 0 |
139115 | 139115 | 2020-05-12 | Summers | West Virginia | 54089 | 1 | 0 |
142111 | 142111 | 2020-05-13 | Summers | West Virginia | 54089 | 1 | 0 |
145108 | 145108 | 2020-05-14 | Summers | West Virginia | 54089 | 1 | 0 |
148111 | 148111 | 2020-05-15 | Summers | West Virginia | 54089 | 1 | 0 |
151120 | 151120 | 2020-05-16 | Summers | West Virginia | 54089 | 1 | 0 |
154131 | 154131 | 2020-05-17 | Summers | West Virginia | 54089 | 1 | 0 |
157148 | 157148 | 2020-05-18 | Summers | West Virginia | 54089 | 1 | 0 |
160172 | 160172 | 2020-05-19 | Summers | West Virginia | 54089 | 1 | 0 |
163200 | 163200 | 2020-05-20 | Summers | West Virginia | 54089 | 1 | 0 |
166229 | 166229 | 2020-05-21 | Summers | West Virginia | 54089 | 1 | 0 |
169265 | 169265 | 2020-05-22 | Summers | West Virginia | 54089 | 2 | 0 |
172306 | 172306 | 2020-05-23 | Summers | West Virginia | 54089 | 2 | 0 |
175349 | 175349 | 2020-05-24 | Summers | West Virginia | 54089 | 2 | 0 |
178394 | 178394 | 2020-05-25 | Summers | West Virginia | 54089 | 1 | 0 |
181438 | 181438 | 2020-05-26 | Summers | West Virginia | 54089 | 1 | 0 |
184489 | 184489 | 2020-05-27 | Summers | West Virginia | 54089 | 1 | 0 |
187546 | 187546 | 2020-05-28 | Summers | West Virginia | 54089 | 1 | 0 |
190610 | 190610 | 2020-05-29 | Summers | West Virginia | 54089 | 1 | 0 |
193676 | 193676 | 2020-05-30 | Summers | West Virginia | 54089 | 1 | 0 |
196746 | 196746 | 2020-05-31 | Summers | West Virginia | 54089 | 1 | 0 |
199819 | 199819 | 2020-06-01 | Summers | West Virginia | 54089 | 1 | 0 |
202895 | 202895 | 2020-06-02 | Summers | West Virginia | 54089 | 1 | 0 |
205974 | 205974 | 2020-06-03 | Summers | West Virginia | 54089 | 1 | 0 |
209056 | 209056 | 2020-06-04 | Summers | West Virginia | 54089 | 1 | 0 |
212141 | 212141 | 2020-06-05 | Summers | West Virginia | 54089 | 1 | 0 |
215228 | 215228 | 2020-06-06 | Summers | West Virginia | 54089 | 1 | 0 |
218318 | 218318 | 2020-06-07 | Summers | West Virginia | 54089 | 1 | 0 |
221410 | 221410 | 2020-06-08 | Summers | West Virginia | 54089 | 1 | 0 |
224506 | 224506 | 2020-06-09 | Summers | West Virginia | 54089 | 1 | 0 |
227606 | 227606 | 2020-06-10 | Summers | West Virginia | 54089 | 1 | 0 |
230710 | 230710 | 2020-06-11 | Summers | West Virginia | 54089 | 1 | 0 |
233815 | 233815 | 2020-06-12 | Summers | West Virginia | 54089 | 1 | 0 |
236922 | 236922 | 2020-06-13 | Summers | West Virginia | 54089 | 1 | 0 |
240030 | 240030 | 2020-06-14 | Summers | West Virginia | 54089 | 1 | 0 |
243141 | 243141 | 2020-06-15 | Summers | West Virginia | 54089 | 1 | 0 |
246254 | 246254 | 2020-06-16 | Summers | West Virginia | 54089 | 1 | 0 |
249366 | 249366 | 2020-06-17 | Summers | West Virginia | 54089 | 1 | 0 |
252481 | 252481 | 2020-06-18 | Summers | West Virginia | 54089 | 1 | 0 |
255600 | 255600 | 2020-06-19 | Summers | West Virginia | 54089 | 1 | 0 |
258727 | 258727 | 2020-06-20 | Summers | West Virginia | 54089 | 1 | 0 |
261854 | 261854 | 2020-06-21 | Summers | West Virginia | 54089 | 1 | 0 |
264983 | 264983 | 2020-06-22 | Summers | West Virginia | 54089 | 1 | 0 |
268112 | 268112 | 2020-06-23 | Summers | West Virginia | 54089 | 1 | 0 |
271246 | 271246 | 2020-06-24 | Summers | West Virginia | 54089 | 1 | 0 |
274386 | 274386 | 2020-06-25 | Summers | West Virginia | 54089 | 1 | 0 |
277534 | 277534 | 2020-06-26 | Summers | West Virginia | 54089 | 1 | 0 |
280682 | 280682 | 2020-06-27 | Summers | West Virginia | 54089 | 1 | 0 |
283828 | 283828 | 2020-06-28 | Summers | West Virginia | 54089 | 2 | 0 |
286974 | 286974 | 2020-06-29 | Summers | West Virginia | 54089 | 2 | 0 |
290124 | 290124 | 2020-06-30 | Summers | West Virginia | 54089 | 2 | 0 |
293277 | 293277 | 2020-07-01 | Summers | West Virginia | 54089 | 2 | 0 |
296432 | 296432 | 2020-07-02 | Summers | West Virginia | 54089 | 2 | 0 |
299594 | 299594 | 2020-07-03 | Summers | West Virginia | 54089 | 2 | 0 |
302758 | 302758 | 2020-07-04 | Summers | West Virginia | 54089 | 2 | 0 |
305922 | 305922 | 2020-07-05 | Summers | West Virginia | 54089 | 2 | 0 |
309090 | 309090 | 2020-07-06 | Summers | West Virginia | 54089 | 2 | 0 |
312259 | 312259 | 2020-07-07 | Summers | West Virginia | 54089 | 2 | 0 |
315434 | 315434 | 2020-07-08 | Summers | West Virginia | 54089 | 2 | 0 |
318607 | 318607 | 2020-07-09 | Summers | West Virginia | 54089 | 2 | 0 |
321786 | 321786 | 2020-07-10 | Summers | West Virginia | 54089 | 2 | 0 |
324967 | 324967 | 2020-07-11 | Summers | West Virginia | 54089 | 2 | 0 |
328153 | 328153 | 2020-07-12 | Summers | West Virginia | 54089 | 2 | 0 |
331339 | 331339 | 2020-07-13 | Summers | West Virginia | 54089 | 2 | 0 |
334532 | 334532 | 2020-07-14 | Summers | West Virginia | 54089 | 2 | 0 |
337727 | 337727 | 2020-07-15 | Summers | West Virginia | 54089 | 2 | 0 |
340923 | 340923 | 2020-07-16 | Summers | West Virginia | 54089 | 2 | 0 |
344122 | 344122 | 2020-07-17 | Summers | West Virginia | 54089 | 2 | 0 |
347322 | 347322 | 2020-07-18 | Summers | West Virginia | 54089 | 3 | 0 |
350523 | 350523 | 2020-07-19 | Summers | West Virginia | 54089 | 2 | 0 |
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);