ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 54001 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537509 | 537509 | 2020-09-15 | Barbour | West Virginia | 54001 | 37 | 1 |
534273 | 534273 | 2020-09-14 | Barbour | West Virginia | 54001 | 37 | 1 |
531038 | 531038 | 2020-09-13 | Barbour | West Virginia | 54001 | 36 | 1 |
527801 | 527801 | 2020-09-12 | Barbour | West Virginia | 54001 | 35 | 1 |
524565 | 524565 | 2020-09-11 | Barbour | West Virginia | 54001 | 35 | 1 |
521329 | 521329 | 2020-09-10 | Barbour | West Virginia | 54001 | 35 | 1 |
518092 | 518092 | 2020-09-09 | Barbour | West Virginia | 54001 | 35 | 1 |
514857 | 514857 | 2020-09-08 | Barbour | West Virginia | 54001 | 35 | 1 |
511624 | 511624 | 2020-09-07 | Barbour | West Virginia | 54001 | 35 | 1 |
508391 | 508391 | 2020-09-06 | Barbour | West Virginia | 54001 | 35 | 1 |
505159 | 505159 | 2020-09-05 | Barbour | West Virginia | 54001 | 34 | 1 |
501925 | 501925 | 2020-09-04 | Barbour | West Virginia | 54001 | 34 | 1 |
498691 | 498691 | 2020-09-03 | Barbour | West Virginia | 54001 | 34 | 1 |
495458 | 495458 | 2020-09-02 | Barbour | West Virginia | 54001 | 34 | 1 |
492224 | 492224 | 2020-09-01 | Barbour | West Virginia | 54001 | 33 | 1 |
488991 | 488991 | 2020-08-31 | Barbour | West Virginia | 54001 | 33 | 1 |
485758 | 485758 | 2020-08-30 | Barbour | West Virginia | 54001 | 33 | 1 |
482523 | 482523 | 2020-08-29 | Barbour | West Virginia | 54001 | 33 | 1 |
479289 | 479289 | 2020-08-28 | Barbour | West Virginia | 54001 | 33 | 1 |
476056 | 476056 | 2020-08-27 | Barbour | West Virginia | 54001 | 33 | 1 |
472823 | 472823 | 2020-08-26 | Barbour | West Virginia | 54001 | 33 | 1 |
469591 | 469591 | 2020-08-25 | Barbour | West Virginia | 54001 | 33 | 1 |
466362 | 466362 | 2020-08-24 | Barbour | West Virginia | 54001 | 33 | 1 |
463133 | 463133 | 2020-08-23 | Barbour | West Virginia | 54001 | 33 | 1 |
459904 | 459904 | 2020-08-22 | Barbour | West Virginia | 54001 | 33 | 1 |
456677 | 456677 | 2020-08-21 | Barbour | West Virginia | 54001 | 33 | 1 |
453449 | 453449 | 2020-08-20 | Barbour | West Virginia | 54001 | 33 | 1 |
450221 | 450221 | 2020-08-19 | Barbour | West Virginia | 54001 | 33 | 1 |
446993 | 446993 | 2020-08-18 | Barbour | West Virginia | 54001 | 33 | 1 |
443766 | 443766 | 2020-08-17 | Barbour | West Virginia | 54001 | 33 | 1 |
440540 | 440540 | 2020-08-16 | Barbour | West Virginia | 54001 | 33 | 1 |
437314 | 437314 | 2020-08-15 | Barbour | West Virginia | 54001 | 31 | 1 |
434088 | 434088 | 2020-08-14 | Barbour | West Virginia | 54001 | 31 | 1 |
430863 | 430863 | 2020-08-13 | Barbour | West Virginia | 54001 | 29 | 1 |
427635 | 427635 | 2020-08-12 | Barbour | West Virginia | 54001 | 29 | 1 |
424411 | 424411 | 2020-08-11 | Barbour | West Virginia | 54001 | 29 | 1 |
421190 | 421190 | 2020-08-10 | Barbour | West Virginia | 54001 | 29 | 1 |
417969 | 417969 | 2020-08-09 | Barbour | West Virginia | 54001 | 29 | 1 |
414748 | 414748 | 2020-08-08 | Barbour | West Virginia | 54001 | 29 | 1 |
411528 | 411528 | 2020-08-07 | Barbour | West Virginia | 54001 | 29 | 1 |
408309 | 408309 | 2020-08-06 | Barbour | West Virginia | 54001 | 29 | 1 |
405089 | 405089 | 2020-08-05 | Barbour | West Virginia | 54001 | 30 | 1 |
401871 | 401871 | 2020-08-04 | Barbour | West Virginia | 54001 | 29 | 1 |
398655 | 398655 | 2020-08-03 | Barbour | West Virginia | 54001 | 29 | 1 |
395439 | 395439 | 2020-08-02 | Barbour | West Virginia | 54001 | 29 | 1 |
392223 | 392223 | 2020-08-01 | Barbour | West Virginia | 54001 | 29 | 1 |
389006 | 389006 | 2020-07-31 | Barbour | West Virginia | 54001 | 29 | 1 |
385789 | 385789 | 2020-07-30 | Barbour | West Virginia | 54001 | 29 | 1 |
382571 | 382571 | 2020-07-29 | Barbour | West Virginia | 54001 | 29 | 1 |
379354 | 379354 | 2020-07-28 | Barbour | West Virginia | 54001 | 29 | 1 |
376138 | 376138 | 2020-07-27 | Barbour | West Virginia | 54001 | 28 | 1 |
372924 | 372924 | 2020-07-26 | Barbour | West Virginia | 54001 | 28 | 1 |
369712 | 369712 | 2020-07-25 | Barbour | West Virginia | 54001 | 28 | 1 |
366503 | 366503 | 2020-07-24 | Barbour | West Virginia | 54001 | 28 | 1 |
363296 | 363296 | 2020-07-23 | Barbour | West Virginia | 54001 | 27 | 1 |
360090 | 360090 | 2020-07-22 | Barbour | West Virginia | 54001 | 27 | 1 |
356885 | 356885 | 2020-07-21 | Barbour | West Virginia | 54001 | 26 | 1 |
353682 | 353682 | 2020-07-20 | Barbour | West Virginia | 54001 | 25 | 1 |
350480 | 350480 | 2020-07-19 | Barbour | West Virginia | 54001 | 25 | 1 |
347279 | 347279 | 2020-07-18 | Barbour | West Virginia | 54001 | 25 | 1 |
344079 | 344079 | 2020-07-17 | Barbour | West Virginia | 54001 | 24 | 1 |
340880 | 340880 | 2020-07-16 | Barbour | West Virginia | 54001 | 24 | 1 |
337684 | 337684 | 2020-07-15 | Barbour | West Virginia | 54001 | 23 | 1 |
334489 | 334489 | 2020-07-14 | Barbour | West Virginia | 54001 | 20 | 1 |
331296 | 331296 | 2020-07-13 | Barbour | West Virginia | 54001 | 20 | 1 |
328110 | 328110 | 2020-07-12 | Barbour | West Virginia | 54001 | 19 | 1 |
324924 | 324924 | 2020-07-11 | Barbour | West Virginia | 54001 | 19 | 1 |
321743 | 321743 | 2020-07-10 | Barbour | West Virginia | 54001 | 18 | 1 |
318564 | 318564 | 2020-07-09 | Barbour | West Virginia | 54001 | 17 | 1 |
315391 | 315391 | 2020-07-08 | Barbour | West Virginia | 54001 | 17 | 1 |
312216 | 312216 | 2020-07-07 | Barbour | West Virginia | 54001 | 17 | 1 |
309047 | 309047 | 2020-07-06 | Barbour | West Virginia | 54001 | 17 | 1 |
305879 | 305879 | 2020-07-05 | Barbour | West Virginia | 54001 | 16 | 1 |
302715 | 302715 | 2020-07-04 | Barbour | West Virginia | 54001 | 15 | 1 |
299551 | 299551 | 2020-07-03 | Barbour | West Virginia | 54001 | 15 | 1 |
296389 | 296389 | 2020-07-02 | Barbour | West Virginia | 54001 | 15 | 1 |
293234 | 293234 | 2020-07-01 | Barbour | West Virginia | 54001 | 15 | 1 |
290081 | 290081 | 2020-06-30 | Barbour | West Virginia | 54001 | 15 | 1 |
286931 | 286931 | 2020-06-29 | Barbour | West Virginia | 54001 | 15 | 1 |
283785 | 283785 | 2020-06-28 | Barbour | West Virginia | 54001 | 15 | 1 |
280639 | 280639 | 2020-06-27 | Barbour | West Virginia | 54001 | 15 | 1 |
277491 | 277491 | 2020-06-26 | Barbour | West Virginia | 54001 | 15 | 1 |
274343 | 274343 | 2020-06-25 | Barbour | West Virginia | 54001 | 15 | 1 |
271203 | 271203 | 2020-06-24 | Barbour | West Virginia | 54001 | 15 | 1 |
268069 | 268069 | 2020-06-23 | Barbour | West Virginia | 54001 | 15 | 1 |
264940 | 264940 | 2020-06-22 | Barbour | West Virginia | 54001 | 13 | 1 |
261811 | 261811 | 2020-06-21 | Barbour | West Virginia | 54001 | 12 | 1 |
258684 | 258684 | 2020-06-20 | Barbour | West Virginia | 54001 | 11 | 1 |
255557 | 255557 | 2020-06-19 | Barbour | West Virginia | 54001 | 11 | 1 |
252438 | 252438 | 2020-06-18 | Barbour | West Virginia | 54001 | 11 | 1 |
249323 | 249323 | 2020-06-17 | Barbour | West Virginia | 54001 | 11 | 1 |
246211 | 246211 | 2020-06-16 | Barbour | West Virginia | 54001 | 10 | 1 |
243098 | 243098 | 2020-06-15 | Barbour | West Virginia | 54001 | 10 | 1 |
239987 | 239987 | 2020-06-14 | Barbour | West Virginia | 54001 | 10 | 1 |
236879 | 236879 | 2020-06-13 | Barbour | West Virginia | 54001 | 10 | 1 |
233772 | 233772 | 2020-06-12 | Barbour | West Virginia | 54001 | 10 | 1 |
230667 | 230667 | 2020-06-11 | Barbour | West Virginia | 54001 | 10 | 1 |
227563 | 227563 | 2020-06-10 | Barbour | West Virginia | 54001 | 9 | 1 |
224463 | 224463 | 2020-06-09 | Barbour | West Virginia | 54001 | 9 | 1 |
221367 | 221367 | 2020-06-08 | Barbour | West Virginia | 54001 | 8 | 1 |
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);