ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 54091 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 ▼ |
---|---|---|---|---|---|---|---|
38001 | 38001 | 2020-04-06 | Taylor | West Virginia | 54091 | 1 | 0 |
40540 | 40540 | 2020-04-07 | Taylor | West Virginia | 54091 | 3 | 0 |
43112 | 43112 | 2020-04-08 | Taylor | West Virginia | 54091 | 5 | 0 |
45708 | 45708 | 2020-04-09 | Taylor | West Virginia | 54091 | 3 | 0 |
48336 | 48336 | 2020-04-10 | Taylor | West Virginia | 54091 | 3 | 0 |
50996 | 50996 | 2020-04-11 | Taylor | West Virginia | 54091 | 3 | 0 |
53673 | 53673 | 2020-04-12 | Taylor | West Virginia | 54091 | 3 | 0 |
56363 | 56363 | 2020-04-13 | Taylor | West Virginia | 54091 | 4 | 0 |
59070 | 59070 | 2020-04-14 | Taylor | West Virginia | 54091 | 4 | 0 |
61789 | 61789 | 2020-04-15 | Taylor | West Virginia | 54091 | 4 | 0 |
64522 | 64522 | 2020-04-16 | Taylor | West Virginia | 54091 | 4 | 0 |
67270 | 67270 | 2020-04-17 | Taylor | West Virginia | 54091 | 5 | 0 |
70032 | 70032 | 2020-04-18 | Taylor | West Virginia | 54091 | 5 | 0 |
72801 | 72801 | 2020-04-19 | Taylor | West Virginia | 54091 | 5 | 0 |
75577 | 75577 | 2020-04-20 | Taylor | West Virginia | 54091 | 5 | 0 |
78360 | 78360 | 2020-04-21 | Taylor | West Virginia | 54091 | 5 | 0 |
81153 | 81153 | 2020-04-22 | Taylor | West Virginia | 54091 | 5 | 0 |
83954 | 83954 | 2020-04-23 | Taylor | West Virginia | 54091 | 5 | 0 |
86761 | 86761 | 2020-04-24 | Taylor | West Virginia | 54091 | 5 | 0 |
89577 | 89577 | 2020-04-25 | Taylor | West Virginia | 54091 | 5 | 0 |
92395 | 92395 | 2020-04-26 | Taylor | West Virginia | 54091 | 6 | 0 |
95225 | 95225 | 2020-04-27 | Taylor | West Virginia | 54091 | 6 | 0 |
98070 | 98070 | 2020-04-28 | Taylor | West Virginia | 54091 | 6 | 0 |
100920 | 100920 | 2020-04-29 | Taylor | West Virginia | 54091 | 6 | 0 |
103775 | 103775 | 2020-04-30 | Taylor | West Virginia | 54091 | 6 | 0 |
106639 | 106639 | 2020-05-01 | Taylor | West Virginia | 54091 | 6 | 0 |
109508 | 109508 | 2020-05-02 | Taylor | West Virginia | 54091 | 7 | 0 |
112383 | 112383 | 2020-05-03 | Taylor | West Virginia | 54091 | 7 | 0 |
115266 | 115266 | 2020-05-04 | Taylor | West Virginia | 54091 | 7 | 0 |
118225 | 118225 | 2020-05-05 | Taylor | West Virginia | 54091 | 9 | 0 |
121190 | 121190 | 2020-05-06 | Taylor | West Virginia | 54091 | 8 | 0 |
124170 | 124170 | 2020-05-07 | Taylor | West Virginia | 54091 | 8 | 0 |
127155 | 127155 | 2020-05-08 | Taylor | West Virginia | 54091 | 8 | 0 |
130145 | 130145 | 2020-05-09 | Taylor | West Virginia | 54091 | 8 | 0 |
133135 | 133135 | 2020-05-10 | Taylor | West Virginia | 54091 | 8 | 0 |
136125 | 136125 | 2020-05-11 | Taylor | West Virginia | 54091 | 8 | 0 |
139116 | 139116 | 2020-05-12 | Taylor | West Virginia | 54091 | 8 | 0 |
142112 | 142112 | 2020-05-13 | Taylor | West Virginia | 54091 | 8 | 0 |
145109 | 145109 | 2020-05-14 | Taylor | West Virginia | 54091 | 8 | 0 |
148112 | 148112 | 2020-05-15 | Taylor | West Virginia | 54091 | 8 | 0 |
151121 | 151121 | 2020-05-16 | Taylor | West Virginia | 54091 | 8 | 0 |
154132 | 154132 | 2020-05-17 | Taylor | West Virginia | 54091 | 8 | 0 |
157149 | 157149 | 2020-05-18 | Taylor | West Virginia | 54091 | 8 | 0 |
160173 | 160173 | 2020-05-19 | Taylor | West Virginia | 54091 | 8 | 0 |
163201 | 163201 | 2020-05-20 | Taylor | West Virginia | 54091 | 8 | 0 |
166230 | 166230 | 2020-05-21 | Taylor | West Virginia | 54091 | 8 | 0 |
169266 | 169266 | 2020-05-22 | Taylor | West Virginia | 54091 | 8 | 0 |
172307 | 172307 | 2020-05-23 | Taylor | West Virginia | 54091 | 8 | 0 |
175350 | 175350 | 2020-05-24 | Taylor | West Virginia | 54091 | 8 | 0 |
178395 | 178395 | 2020-05-25 | Taylor | West Virginia | 54091 | 8 | 0 |
181439 | 181439 | 2020-05-26 | Taylor | West Virginia | 54091 | 8 | 0 |
184490 | 184490 | 2020-05-27 | Taylor | West Virginia | 54091 | 9 | 0 |
187547 | 187547 | 2020-05-28 | Taylor | West Virginia | 54091 | 8 | 0 |
190611 | 190611 | 2020-05-29 | Taylor | West Virginia | 54091 | 8 | 0 |
193677 | 193677 | 2020-05-30 | Taylor | West Virginia | 54091 | 8 | 0 |
196747 | 196747 | 2020-05-31 | Taylor | West Virginia | 54091 | 8 | 0 |
199820 | 199820 | 2020-06-01 | Taylor | West Virginia | 54091 | 9 | 0 |
202896 | 202896 | 2020-06-02 | Taylor | West Virginia | 54091 | 9 | 0 |
205975 | 205975 | 2020-06-03 | Taylor | West Virginia | 54091 | 9 | 0 |
209057 | 209057 | 2020-06-04 | Taylor | West Virginia | 54091 | 9 | 0 |
212142 | 212142 | 2020-06-05 | Taylor | West Virginia | 54091 | 9 | 0 |
215229 | 215229 | 2020-06-06 | Taylor | West Virginia | 54091 | 9 | 0 |
218319 | 218319 | 2020-06-07 | Taylor | West Virginia | 54091 | 9 | 0 |
221411 | 221411 | 2020-06-08 | Taylor | West Virginia | 54091 | 9 | 0 |
224507 | 224507 | 2020-06-09 | Taylor | West Virginia | 54091 | 9 | 0 |
227607 | 227607 | 2020-06-10 | Taylor | West Virginia | 54091 | 9 | 0 |
230711 | 230711 | 2020-06-11 | Taylor | West Virginia | 54091 | 10 | 0 |
233816 | 233816 | 2020-06-12 | Taylor | West Virginia | 54091 | 10 | 0 |
236923 | 236923 | 2020-06-13 | Taylor | West Virginia | 54091 | 10 | 0 |
240031 | 240031 | 2020-06-14 | Taylor | West Virginia | 54091 | 10 | 0 |
243142 | 243142 | 2020-06-15 | Taylor | West Virginia | 54091 | 10 | 0 |
246255 | 246255 | 2020-06-16 | Taylor | West Virginia | 54091 | 10 | 0 |
249367 | 249367 | 2020-06-17 | Taylor | West Virginia | 54091 | 12 | 0 |
252482 | 252482 | 2020-06-18 | Taylor | West Virginia | 54091 | 12 | 0 |
255601 | 255601 | 2020-06-19 | Taylor | West Virginia | 54091 | 13 | 0 |
258728 | 258728 | 2020-06-20 | Taylor | West Virginia | 54091 | 13 | 0 |
261855 | 261855 | 2020-06-21 | Taylor | West Virginia | 54091 | 13 | 0 |
264984 | 264984 | 2020-06-22 | Taylor | West Virginia | 54091 | 14 | 0 |
268113 | 268113 | 2020-06-23 | Taylor | West Virginia | 54091 | 14 | 0 |
271247 | 271247 | 2020-06-24 | Taylor | West Virginia | 54091 | 14 | 0 |
274387 | 274387 | 2020-06-25 | Taylor | West Virginia | 54091 | 14 | 0 |
277535 | 277535 | 2020-06-26 | Taylor | West Virginia | 54091 | 14 | 0 |
280683 | 280683 | 2020-06-27 | Taylor | West Virginia | 54091 | 16 | 0 |
283829 | 283829 | 2020-06-28 | Taylor | West Virginia | 54091 | 16 | 0 |
286975 | 286975 | 2020-06-29 | Taylor | West Virginia | 54091 | 16 | 0 |
290125 | 290125 | 2020-06-30 | Taylor | West Virginia | 54091 | 16 | 0 |
293278 | 293278 | 2020-07-01 | Taylor | West Virginia | 54091 | 16 | 0 |
296433 | 296433 | 2020-07-02 | Taylor | West Virginia | 54091 | 16 | 0 |
299595 | 299595 | 2020-07-03 | Taylor | West Virginia | 54091 | 17 | 0 |
302759 | 302759 | 2020-07-04 | Taylor | West Virginia | 54091 | 18 | 0 |
305923 | 305923 | 2020-07-05 | Taylor | West Virginia | 54091 | 17 | 0 |
309091 | 309091 | 2020-07-06 | Taylor | West Virginia | 54091 | 17 | 0 |
312260 | 312260 | 2020-07-07 | Taylor | West Virginia | 54091 | 18 | 0 |
315435 | 315435 | 2020-07-08 | Taylor | West Virginia | 54091 | 19 | 0 |
318608 | 318608 | 2020-07-09 | Taylor | West Virginia | 54091 | 20 | 0 |
321787 | 321787 | 2020-07-10 | Taylor | West Virginia | 54091 | 23 | 0 |
324968 | 324968 | 2020-07-11 | Taylor | West Virginia | 54091 | 23 | 0 |
328154 | 328154 | 2020-07-12 | Taylor | West Virginia | 54091 | 23 | 0 |
331340 | 331340 | 2020-07-13 | Taylor | West Virginia | 54091 | 23 | 0 |
334533 | 334533 | 2020-07-14 | Taylor | West Virginia | 54091 | 23 | 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);