ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where fips = 54059 and state = "West Virginia" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
53659 | 53659 | 2020-04-12 | Mingo | West Virginia | 54059 | 1 | 0 |
56349 | 56349 | 2020-04-13 | Mingo | West Virginia | 54059 | 1 | 0 |
59056 | 59056 | 2020-04-14 | Mingo | West Virginia | 54059 | 1 | 0 |
61775 | 61775 | 2020-04-15 | Mingo | West Virginia | 54059 | 1 | 1 |
64508 | 64508 | 2020-04-16 | Mingo | West Virginia | 54059 | 2 | 1 |
67256 | 67256 | 2020-04-17 | Mingo | West Virginia | 54059 | 2 | 1 |
70018 | 70018 | 2020-04-18 | Mingo | West Virginia | 54059 | 2 | 1 |
72787 | 72787 | 2020-04-19 | Mingo | West Virginia | 54059 | 2 | 1 |
75563 | 75563 | 2020-04-20 | Mingo | West Virginia | 54059 | 2 | 1 |
78346 | 78346 | 2020-04-21 | Mingo | West Virginia | 54059 | 2 | 1 |
81139 | 81139 | 2020-04-22 | Mingo | West Virginia | 54059 | 2 | 1 |
83940 | 83940 | 2020-04-23 | Mingo | West Virginia | 54059 | 2 | 1 |
86747 | 86747 | 2020-04-24 | Mingo | West Virginia | 54059 | 2 | 1 |
89563 | 89563 | 2020-04-25 | Mingo | West Virginia | 54059 | 2 | 1 |
92381 | 92381 | 2020-04-26 | Mingo | West Virginia | 54059 | 2 | 1 |
95210 | 95210 | 2020-04-27 | Mingo | West Virginia | 54059 | 2 | 1 |
98055 | 98055 | 2020-04-28 | Mingo | West Virginia | 54059 | 2 | 1 |
100905 | 100905 | 2020-04-29 | Mingo | West Virginia | 54059 | 2 | 1 |
103760 | 103760 | 2020-04-30 | Mingo | West Virginia | 54059 | 2 | 1 |
106624 | 106624 | 2020-05-01 | Mingo | West Virginia | 54059 | 2 | 1 |
109493 | 109493 | 2020-05-02 | Mingo | West Virginia | 54059 | 2 | 1 |
112367 | 112367 | 2020-05-03 | Mingo | West Virginia | 54059 | 2 | 1 |
115250 | 115250 | 2020-05-04 | Mingo | West Virginia | 54059 | 2 | 1 |
118209 | 118209 | 2020-05-05 | Mingo | West Virginia | 54059 | 2 | 1 |
121174 | 121174 | 2020-05-06 | Mingo | West Virginia | 54059 | 2 | 1 |
124154 | 124154 | 2020-05-07 | Mingo | West Virginia | 54059 | 2 | 1 |
127139 | 127139 | 2020-05-08 | Mingo | West Virginia | 54059 | 2 | 1 |
130129 | 130129 | 2020-05-09 | Mingo | West Virginia | 54059 | 2 | 1 |
133119 | 133119 | 2020-05-10 | Mingo | West Virginia | 54059 | 2 | 1 |
136109 | 136109 | 2020-05-11 | Mingo | West Virginia | 54059 | 3 | 1 |
139100 | 139100 | 2020-05-12 | Mingo | West Virginia | 54059 | 3 | 1 |
142096 | 142096 | 2020-05-13 | Mingo | West Virginia | 54059 | 3 | 1 |
145093 | 145093 | 2020-05-14 | Mingo | West Virginia | 54059 | 3 | 1 |
148096 | 148096 | 2020-05-15 | Mingo | West Virginia | 54059 | 3 | 1 |
151105 | 151105 | 2020-05-16 | Mingo | West Virginia | 54059 | 4 | 1 |
154116 | 154116 | 2020-05-17 | Mingo | West Virginia | 54059 | 4 | 1 |
157133 | 157133 | 2020-05-18 | Mingo | West Virginia | 54059 | 3 | 1 |
160157 | 160157 | 2020-05-19 | Mingo | West Virginia | 54059 | 3 | 1 |
163185 | 163185 | 2020-05-20 | Mingo | West Virginia | 54059 | 3 | 1 |
166214 | 166214 | 2020-05-21 | Mingo | West Virginia | 54059 | 3 | 1 |
169250 | 169250 | 2020-05-22 | Mingo | West Virginia | 54059 | 4 | 1 |
172291 | 172291 | 2020-05-23 | Mingo | West Virginia | 54059 | 5 | 1 |
175334 | 175334 | 2020-05-24 | Mingo | West Virginia | 54059 | 5 | 1 |
178379 | 178379 | 2020-05-25 | Mingo | West Virginia | 54059 | 5 | 1 |
181423 | 181423 | 2020-05-26 | Mingo | West Virginia | 54059 | 5 | 1 |
184474 | 184474 | 2020-05-27 | Mingo | West Virginia | 54059 | 6 | 1 |
187531 | 187531 | 2020-05-28 | Mingo | West Virginia | 54059 | 6 | 1 |
190595 | 190595 | 2020-05-29 | Mingo | West Virginia | 54059 | 6 | 1 |
193661 | 193661 | 2020-05-30 | Mingo | West Virginia | 54059 | 6 | 1 |
196731 | 196731 | 2020-05-31 | Mingo | West Virginia | 54059 | 7 | 1 |
199804 | 199804 | 2020-06-01 | Mingo | West Virginia | 54059 | 7 | 1 |
202880 | 202880 | 2020-06-02 | Mingo | West Virginia | 54059 | 7 | 1 |
205959 | 205959 | 2020-06-03 | Mingo | West Virginia | 54059 | 8 | 1 |
209041 | 209041 | 2020-06-04 | Mingo | West Virginia | 54059 | 8 | 1 |
212126 | 212126 | 2020-06-05 | Mingo | West Virginia | 54059 | 8 | 1 |
215213 | 215213 | 2020-06-06 | Mingo | West Virginia | 54059 | 8 | 1 |
218303 | 218303 | 2020-06-07 | Mingo | West Virginia | 54059 | 8 | 1 |
221395 | 221395 | 2020-06-08 | Mingo | West Virginia | 54059 | 9 | 1 |
224491 | 224491 | 2020-06-09 | Mingo | West Virginia | 54059 | 9 | 1 |
227591 | 227591 | 2020-06-10 | Mingo | West Virginia | 54059 | 10 | 1 |
230695 | 230695 | 2020-06-11 | Mingo | West Virginia | 54059 | 11 | 1 |
233800 | 233800 | 2020-06-12 | Mingo | West Virginia | 54059 | 12 | 2 |
236907 | 236907 | 2020-06-13 | Mingo | West Virginia | 54059 | 12 | 2 |
240015 | 240015 | 2020-06-14 | Mingo | West Virginia | 54059 | 12 | 2 |
243126 | 243126 | 2020-06-15 | Mingo | West Virginia | 54059 | 12 | 2 |
246239 | 246239 | 2020-06-16 | Mingo | West Virginia | 54059 | 12 | 2 |
249351 | 249351 | 2020-06-17 | Mingo | West Virginia | 54059 | 12 | 2 |
252466 | 252466 | 2020-06-18 | Mingo | West Virginia | 54059 | 12 | 2 |
255585 | 255585 | 2020-06-19 | Mingo | West Virginia | 54059 | 14 | 2 |
258712 | 258712 | 2020-06-20 | Mingo | West Virginia | 54059 | 14 | 2 |
261839 | 261839 | 2020-06-21 | Mingo | West Virginia | 54059 | 14 | 2 |
264968 | 264968 | 2020-06-22 | Mingo | West Virginia | 54059 | 15 | 2 |
268097 | 268097 | 2020-06-23 | Mingo | West Virginia | 54059 | 15 | 2 |
271231 | 271231 | 2020-06-24 | Mingo | West Virginia | 54059 | 15 | 2 |
274371 | 274371 | 2020-06-25 | Mingo | West Virginia | 54059 | 16 | 2 |
277519 | 277519 | 2020-06-26 | Mingo | West Virginia | 54059 | 16 | 2 |
280667 | 280667 | 2020-06-27 | Mingo | West Virginia | 54059 | 17 | 2 |
283813 | 283813 | 2020-06-28 | Mingo | West Virginia | 54059 | 17 | 2 |
286959 | 286959 | 2020-06-29 | Mingo | West Virginia | 54059 | 18 | 2 |
290109 | 290109 | 2020-06-30 | Mingo | West Virginia | 54059 | 20 | 2 |
293262 | 293262 | 2020-07-01 | Mingo | West Virginia | 54059 | 23 | 2 |
296417 | 296417 | 2020-07-02 | Mingo | West Virginia | 54059 | 22 | 2 |
299579 | 299579 | 2020-07-03 | Mingo | West Virginia | 54059 | 22 | 2 |
302743 | 302743 | 2020-07-04 | Mingo | West Virginia | 54059 | 23 | 2 |
305907 | 305907 | 2020-07-05 | Mingo | West Virginia | 54059 | 23 | 2 |
309075 | 309075 | 2020-07-06 | Mingo | West Virginia | 54059 | 23 | 2 |
312244 | 312244 | 2020-07-07 | Mingo | West Virginia | 54059 | 22 | 2 |
315419 | 315419 | 2020-07-08 | Mingo | West Virginia | 54059 | 26 | 2 |
318592 | 318592 | 2020-07-09 | Mingo | West Virginia | 54059 | 27 | 2 |
321771 | 321771 | 2020-07-10 | Mingo | West Virginia | 54059 | 29 | 2 |
324952 | 324952 | 2020-07-11 | Mingo | West Virginia | 54059 | 30 | 2 |
328138 | 328138 | 2020-07-12 | Mingo | West Virginia | 54059 | 32 | 2 |
331324 | 331324 | 2020-07-13 | Mingo | West Virginia | 54059 | 31 | 2 |
334517 | 334517 | 2020-07-14 | Mingo | West Virginia | 54059 | 31 | 2 |
337712 | 337712 | 2020-07-15 | Mingo | West Virginia | 54059 | 36 | 2 |
340908 | 340908 | 2020-07-16 | Mingo | West Virginia | 54059 | 41 | 2 |
344107 | 344107 | 2020-07-17 | Mingo | West Virginia | 54059 | 50 | 2 |
347307 | 347307 | 2020-07-18 | Mingo | West Virginia | 54059 | 52 | 2 |
350508 | 350508 | 2020-07-19 | Mingo | West Virginia | 54059 | 55 | 2 |
353710 | 353710 | 2020-07-20 | Mingo | West Virginia | 54059 | 62 | 2 |
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);