ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where fips = 54085 and state = "West Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
112380 | 112380 | 2020-05-03 | Ritchie | West Virginia | 54085 | 1 | 0 |
115263 | 115263 | 2020-05-04 | Ritchie | West Virginia | 54085 | 1 | 0 |
118222 | 118222 | 2020-05-05 | Ritchie | West Virginia | 54085 | 1 | 0 |
121187 | 121187 | 2020-05-06 | Ritchie | West Virginia | 54085 | 1 | 0 |
124167 | 124167 | 2020-05-07 | Ritchie | West Virginia | 54085 | 1 | 0 |
127152 | 127152 | 2020-05-08 | Ritchie | West Virginia | 54085 | 1 | 0 |
130142 | 130142 | 2020-05-09 | Ritchie | West Virginia | 54085 | 1 | 0 |
133132 | 133132 | 2020-05-10 | Ritchie | West Virginia | 54085 | 1 | 0 |
136122 | 136122 | 2020-05-11 | Ritchie | West Virginia | 54085 | 1 | 0 |
139113 | 139113 | 2020-05-12 | Ritchie | West Virginia | 54085 | 1 | 0 |
142109 | 142109 | 2020-05-13 | Ritchie | West Virginia | 54085 | 1 | 0 |
145106 | 145106 | 2020-05-14 | Ritchie | West Virginia | 54085 | 1 | 0 |
148109 | 148109 | 2020-05-15 | Ritchie | West Virginia | 54085 | 1 | 0 |
151118 | 151118 | 2020-05-16 | Ritchie | West Virginia | 54085 | 1 | 0 |
154129 | 154129 | 2020-05-17 | Ritchie | West Virginia | 54085 | 1 | 0 |
157146 | 157146 | 2020-05-18 | Ritchie | West Virginia | 54085 | 1 | 0 |
160170 | 160170 | 2020-05-19 | Ritchie | West Virginia | 54085 | 1 | 0 |
163198 | 163198 | 2020-05-20 | Ritchie | West Virginia | 54085 | 1 | 0 |
166227 | 166227 | 2020-05-21 | Ritchie | West Virginia | 54085 | 1 | 0 |
169263 | 169263 | 2020-05-22 | Ritchie | West Virginia | 54085 | 1 | 0 |
172304 | 172304 | 2020-05-23 | Ritchie | West Virginia | 54085 | 1 | 0 |
175347 | 175347 | 2020-05-24 | Ritchie | West Virginia | 54085 | 1 | 0 |
178392 | 178392 | 2020-05-25 | Ritchie | West Virginia | 54085 | 1 | 0 |
181436 | 181436 | 2020-05-26 | Ritchie | West Virginia | 54085 | 1 | 0 |
184487 | 184487 | 2020-05-27 | Ritchie | West Virginia | 54085 | 1 | 0 |
187544 | 187544 | 2020-05-28 | Ritchie | West Virginia | 54085 | 1 | 0 |
190608 | 190608 | 2020-05-29 | Ritchie | West Virginia | 54085 | 1 | 0 |
193674 | 193674 | 2020-05-30 | Ritchie | West Virginia | 54085 | 1 | 0 |
196744 | 196744 | 2020-05-31 | Ritchie | West Virginia | 54085 | 1 | 0 |
199817 | 199817 | 2020-06-01 | Ritchie | West Virginia | 54085 | 1 | 0 |
202893 | 202893 | 2020-06-02 | Ritchie | West Virginia | 54085 | 1 | 0 |
205972 | 205972 | 2020-06-03 | Ritchie | West Virginia | 54085 | 1 | 0 |
209054 | 209054 | 2020-06-04 | Ritchie | West Virginia | 54085 | 1 | 0 |
212139 | 212139 | 2020-06-05 | Ritchie | West Virginia | 54085 | 1 | 0 |
215226 | 215226 | 2020-06-06 | Ritchie | West Virginia | 54085 | 1 | 0 |
218316 | 218316 | 2020-06-07 | Ritchie | West Virginia | 54085 | 1 | 0 |
221408 | 221408 | 2020-06-08 | Ritchie | West Virginia | 54085 | 1 | 0 |
224504 | 224504 | 2020-06-09 | Ritchie | West Virginia | 54085 | 1 | 0 |
227604 | 227604 | 2020-06-10 | Ritchie | West Virginia | 54085 | 2 | 0 |
230708 | 230708 | 2020-06-11 | Ritchie | West Virginia | 54085 | 2 | 0 |
233813 | 233813 | 2020-06-12 | Ritchie | West Virginia | 54085 | 2 | 0 |
236920 | 236920 | 2020-06-13 | Ritchie | West Virginia | 54085 | 2 | 0 |
240028 | 240028 | 2020-06-14 | Ritchie | West Virginia | 54085 | 2 | 0 |
243139 | 243139 | 2020-06-15 | Ritchie | West Virginia | 54085 | 2 | 0 |
246252 | 246252 | 2020-06-16 | Ritchie | West Virginia | 54085 | 2 | 0 |
249364 | 249364 | 2020-06-17 | Ritchie | West Virginia | 54085 | 2 | 0 |
252479 | 252479 | 2020-06-18 | Ritchie | West Virginia | 54085 | 2 | 0 |
255598 | 255598 | 2020-06-19 | Ritchie | West Virginia | 54085 | 2 | 0 |
258725 | 258725 | 2020-06-20 | Ritchie | West Virginia | 54085 | 3 | 0 |
261852 | 261852 | 2020-06-21 | Ritchie | West Virginia | 54085 | 3 | 0 |
264981 | 264981 | 2020-06-22 | Ritchie | West Virginia | 54085 | 3 | 0 |
268110 | 268110 | 2020-06-23 | Ritchie | West Virginia | 54085 | 3 | 0 |
271244 | 271244 | 2020-06-24 | Ritchie | West Virginia | 54085 | 2 | 0 |
274384 | 274384 | 2020-06-25 | Ritchie | West Virginia | 54085 | 2 | 0 |
277532 | 277532 | 2020-06-26 | Ritchie | West Virginia | 54085 | 2 | 0 |
280680 | 280680 | 2020-06-27 | Ritchie | West Virginia | 54085 | 2 | 0 |
283826 | 283826 | 2020-06-28 | Ritchie | West Virginia | 54085 | 2 | 0 |
286972 | 286972 | 2020-06-29 | Ritchie | West Virginia | 54085 | 2 | 0 |
290122 | 290122 | 2020-06-30 | Ritchie | West Virginia | 54085 | 2 | 0 |
293275 | 293275 | 2020-07-01 | Ritchie | West Virginia | 54085 | 2 | 0 |
296430 | 296430 | 2020-07-02 | Ritchie | West Virginia | 54085 | 2 | 0 |
299592 | 299592 | 2020-07-03 | Ritchie | West Virginia | 54085 | 2 | 0 |
302756 | 302756 | 2020-07-04 | Ritchie | West Virginia | 54085 | 2 | 0 |
305920 | 305920 | 2020-07-05 | Ritchie | West Virginia | 54085 | 2 | 0 |
309088 | 309088 | 2020-07-06 | Ritchie | West Virginia | 54085 | 2 | 0 |
312257 | 312257 | 2020-07-07 | Ritchie | West Virginia | 54085 | 2 | 0 |
315432 | 315432 | 2020-07-08 | Ritchie | West Virginia | 54085 | 2 | 0 |
318605 | 318605 | 2020-07-09 | Ritchie | West Virginia | 54085 | 2 | 0 |
321784 | 321784 | 2020-07-10 | Ritchie | West Virginia | 54085 | 2 | 0 |
324965 | 324965 | 2020-07-11 | Ritchie | West Virginia | 54085 | 2 | 0 |
328151 | 328151 | 2020-07-12 | Ritchie | West Virginia | 54085 | 2 | 0 |
331337 | 331337 | 2020-07-13 | Ritchie | West Virginia | 54085 | 2 | 0 |
334530 | 334530 | 2020-07-14 | Ritchie | West Virginia | 54085 | 2 | 0 |
337725 | 337725 | 2020-07-15 | Ritchie | West Virginia | 54085 | 2 | 0 |
340921 | 340921 | 2020-07-16 | Ritchie | West Virginia | 54085 | 3 | 0 |
344120 | 344120 | 2020-07-17 | Ritchie | West Virginia | 54085 | 3 | 0 |
347320 | 347320 | 2020-07-18 | Ritchie | West Virginia | 54085 | 3 | 0 |
350521 | 350521 | 2020-07-19 | Ritchie | West Virginia | 54085 | 3 | 0 |
353723 | 353723 | 2020-07-20 | Ritchie | West Virginia | 54085 | 3 | 0 |
356926 | 356926 | 2020-07-21 | Ritchie | West Virginia | 54085 | 3 | 0 |
360131 | 360131 | 2020-07-22 | Ritchie | West Virginia | 54085 | 3 | 0 |
363337 | 363337 | 2020-07-23 | Ritchie | West Virginia | 54085 | 3 | 0 |
366544 | 366544 | 2020-07-24 | Ritchie | West Virginia | 54085 | 3 | 0 |
369754 | 369754 | 2020-07-25 | Ritchie | West Virginia | 54085 | 3 | 0 |
372966 | 372966 | 2020-07-26 | Ritchie | West Virginia | 54085 | 3 | 0 |
376180 | 376180 | 2020-07-27 | Ritchie | West Virginia | 54085 | 3 | 0 |
379396 | 379396 | 2020-07-28 | Ritchie | West Virginia | 54085 | 3 | 0 |
382613 | 382613 | 2020-07-29 | Ritchie | West Virginia | 54085 | 3 | 0 |
385831 | 385831 | 2020-07-30 | Ritchie | West Virginia | 54085 | 3 | 0 |
389048 | 389048 | 2020-07-31 | Ritchie | West Virginia | 54085 | 3 | 0 |
392265 | 392265 | 2020-08-01 | Ritchie | West Virginia | 54085 | 3 | 0 |
395481 | 395481 | 2020-08-02 | Ritchie | West Virginia | 54085 | 3 | 0 |
398697 | 398697 | 2020-08-03 | Ritchie | West Virginia | 54085 | 3 | 0 |
401913 | 401913 | 2020-08-04 | Ritchie | West Virginia | 54085 | 3 | 0 |
405131 | 405131 | 2020-08-05 | Ritchie | West Virginia | 54085 | 3 | 0 |
408351 | 408351 | 2020-08-06 | Ritchie | West Virginia | 54085 | 3 | 0 |
411570 | 411570 | 2020-08-07 | Ritchie | West Virginia | 54085 | 3 | 0 |
414790 | 414790 | 2020-08-08 | Ritchie | West Virginia | 54085 | 3 | 0 |
418011 | 418011 | 2020-08-09 | Ritchie | West Virginia | 54085 | 3 | 0 |
421232 | 421232 | 2020-08-10 | Ritchie | West Virginia | 54085 | 3 | 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);