ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 54071 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 |
---|---|---|---|---|---|---|---|
638014 | 638014 | 2020-10-16 | Pendleton | West Virginia | 54071 | 65 | 1 |
634769 | 634769 | 2020-10-15 | Pendleton | West Virginia | 54071 | 63 | 1 |
631524 | 631524 | 2020-10-14 | Pendleton | West Virginia | 54071 | 62 | 1 |
628280 | 628280 | 2020-10-13 | Pendleton | West Virginia | 54071 | 59 | 1 |
625037 | 625037 | 2020-10-12 | Pendleton | West Virginia | 54071 | 57 | 1 |
621794 | 621794 | 2020-10-11 | Pendleton | West Virginia | 54071 | 57 | 1 |
618551 | 618551 | 2020-10-10 | Pendleton | West Virginia | 54071 | 56 | 1 |
615309 | 615309 | 2020-10-09 | Pendleton | West Virginia | 54071 | 55 | 1 |
612068 | 612068 | 2020-10-08 | Pendleton | West Virginia | 54071 | 54 | 1 |
608826 | 608826 | 2020-10-07 | Pendleton | West Virginia | 54071 | 54 | 1 |
605583 | 605583 | 2020-10-06 | Pendleton | West Virginia | 54071 | 53 | 1 |
602341 | 602341 | 2020-10-05 | Pendleton | West Virginia | 54071 | 53 | 1 |
599098 | 599098 | 2020-10-04 | Pendleton | West Virginia | 54071 | 53 | 1 |
595855 | 595855 | 2020-10-03 | Pendleton | West Virginia | 54071 | 53 | 1 |
592613 | 592613 | 2020-10-02 | Pendleton | West Virginia | 54071 | 53 | 1 |
589373 | 589373 | 2020-10-01 | Pendleton | West Virginia | 54071 | 53 | 1 |
586132 | 586132 | 2020-09-30 | Pendleton | West Virginia | 54071 | 53 | 1 |
582892 | 582892 | 2020-09-29 | Pendleton | West Virginia | 54071 | 53 | 1 |
579653 | 579653 | 2020-09-28 | Pendleton | West Virginia | 54071 | 53 | 1 |
576412 | 576412 | 2020-09-27 | Pendleton | West Virginia | 54071 | 53 | 1 |
573168 | 573168 | 2020-09-26 | Pendleton | West Virginia | 54071 | 53 | 1 |
569926 | 569926 | 2020-09-25 | Pendleton | West Virginia | 54071 | 52 | 1 |
566685 | 566685 | 2020-09-24 | Pendleton | West Virginia | 54071 | 52 | 1 |
563444 | 563444 | 2020-09-23 | Pendleton | West Virginia | 54071 | 52 | 1 |
560205 | 560205 | 2020-09-22 | Pendleton | West Virginia | 54071 | 52 | 1 |
556969 | 556969 | 2020-09-21 | Pendleton | West Virginia | 54071 | 52 | 1 |
553732 | 553732 | 2020-09-20 | Pendleton | West Virginia | 54071 | 52 | 1 |
550493 | 550493 | 2020-09-19 | Pendleton | West Virginia | 54071 | 52 | 1 |
547254 | 547254 | 2020-09-18 | Pendleton | West Virginia | 54071 | 51 | 1 |
544017 | 544017 | 2020-09-17 | Pendleton | West Virginia | 54071 | 51 | 1 |
540781 | 540781 | 2020-09-16 | Pendleton | West Virginia | 54071 | 48 | 1 |
537544 | 537544 | 2020-09-15 | Pendleton | West Virginia | 54071 | 47 | 1 |
534308 | 534308 | 2020-09-14 | Pendleton | West Virginia | 54071 | 46 | 1 |
531073 | 531073 | 2020-09-13 | Pendleton | West Virginia | 54071 | 46 | 1 |
527836 | 527836 | 2020-09-12 | Pendleton | West Virginia | 54071 | 46 | 1 |
524600 | 524600 | 2020-09-11 | Pendleton | West Virginia | 54071 | 45 | 1 |
521364 | 521364 | 2020-09-10 | Pendleton | West Virginia | 54071 | 46 | 1 |
518127 | 518127 | 2020-09-09 | Pendleton | West Virginia | 54071 | 45 | 1 |
514892 | 514892 | 2020-09-08 | Pendleton | West Virginia | 54071 | 45 | 1 |
511659 | 511659 | 2020-09-07 | Pendleton | West Virginia | 54071 | 45 | 1 |
508426 | 508426 | 2020-09-06 | Pendleton | West Virginia | 54071 | 45 | 1 |
505194 | 505194 | 2020-09-05 | Pendleton | West Virginia | 54071 | 45 | 1 |
501960 | 501960 | 2020-09-04 | Pendleton | West Virginia | 54071 | 45 | 1 |
498726 | 498726 | 2020-09-03 | Pendleton | West Virginia | 54071 | 45 | 1 |
495493 | 495493 | 2020-09-02 | Pendleton | West Virginia | 54071 | 45 | 1 |
492259 | 492259 | 2020-09-01 | Pendleton | West Virginia | 54071 | 45 | 1 |
489026 | 489026 | 2020-08-31 | Pendleton | West Virginia | 54071 | 44 | 1 |
485793 | 485793 | 2020-08-30 | Pendleton | West Virginia | 54071 | 44 | 1 |
482558 | 482558 | 2020-08-29 | Pendleton | West Virginia | 54071 | 44 | 1 |
479324 | 479324 | 2020-08-28 | Pendleton | West Virginia | 54071 | 44 | 1 |
476091 | 476091 | 2020-08-27 | Pendleton | West Virginia | 54071 | 44 | 1 |
472858 | 472858 | 2020-08-26 | Pendleton | West Virginia | 54071 | 44 | 1 |
469626 | 469626 | 2020-08-25 | Pendleton | West Virginia | 54071 | 48 | 1 |
466397 | 466397 | 2020-08-24 | Pendleton | West Virginia | 54071 | 48 | 1 |
463168 | 463168 | 2020-08-23 | Pendleton | West Virginia | 54071 | 48 | 1 |
459939 | 459939 | 2020-08-22 | Pendleton | West Virginia | 54071 | 48 | 1 |
456712 | 456712 | 2020-08-21 | Pendleton | West Virginia | 54071 | 47 | 1 |
453484 | 453484 | 2020-08-20 | Pendleton | West Virginia | 54071 | 47 | 1 |
450256 | 450256 | 2020-08-19 | Pendleton | West Virginia | 54071 | 47 | 1 |
447028 | 447028 | 2020-08-18 | Pendleton | West Virginia | 54071 | 43 | 1 |
443801 | 443801 | 2020-08-17 | Pendleton | West Virginia | 54071 | 43 | 1 |
440575 | 440575 | 2020-08-16 | Pendleton | West Virginia | 54071 | 43 | 1 |
437349 | 437349 | 2020-08-15 | Pendleton | West Virginia | 54071 | 42 | 1 |
434123 | 434123 | 2020-08-14 | Pendleton | West Virginia | 54071 | 42 | 1 |
430898 | 430898 | 2020-08-13 | Pendleton | West Virginia | 54071 | 42 | 1 |
427670 | 427670 | 2020-08-12 | Pendleton | West Virginia | 54071 | 42 | 1 |
424446 | 424446 | 2020-08-11 | Pendleton | West Virginia | 54071 | 42 | 1 |
421225 | 421225 | 2020-08-10 | Pendleton | West Virginia | 54071 | 41 | 1 |
418004 | 418004 | 2020-08-09 | Pendleton | West Virginia | 54071 | 40 | 1 |
414783 | 414783 | 2020-08-08 | Pendleton | West Virginia | 54071 | 39 | 1 |
411563 | 411563 | 2020-08-07 | Pendleton | West Virginia | 54071 | 40 | 1 |
408344 | 408344 | 2020-08-06 | Pendleton | West Virginia | 54071 | 58 | 1 |
405124 | 405124 | 2020-08-05 | Pendleton | West Virginia | 54071 | 42 | 1 |
401906 | 401906 | 2020-08-04 | Pendleton | West Virginia | 54071 | 41 | 1 |
398690 | 398690 | 2020-08-03 | Pendleton | West Virginia | 54071 | 38 | 1 |
395474 | 395474 | 2020-08-02 | Pendleton | West Virginia | 54071 | 37 | 1 |
392258 | 392258 | 2020-08-01 | Pendleton | West Virginia | 54071 | 37 | 1 |
389041 | 389041 | 2020-07-31 | Pendleton | West Virginia | 54071 | 37 | 1 |
385824 | 385824 | 2020-07-30 | Pendleton | West Virginia | 54071 | 37 | 1 |
382606 | 382606 | 2020-07-29 | Pendleton | West Virginia | 54071 | 36 | 1 |
379389 | 379389 | 2020-07-28 | Pendleton | West Virginia | 54071 | 31 | 1 |
376173 | 376173 | 2020-07-27 | Pendleton | West Virginia | 54071 | 28 | 1 |
372959 | 372959 | 2020-07-26 | Pendleton | West Virginia | 54071 | 28 | 1 |
369747 | 369747 | 2020-07-25 | Pendleton | West Virginia | 54071 | 28 | 1 |
366537 | 366537 | 2020-07-24 | Pendleton | West Virginia | 54071 | 28 | 1 |
363330 | 363330 | 2020-07-23 | Pendleton | West Virginia | 54071 | 26 | 1 |
360124 | 360124 | 2020-07-22 | Pendleton | West Virginia | 54071 | 25 | 1 |
356919 | 356919 | 2020-07-21 | Pendleton | West Virginia | 54071 | 20 | 1 |
353716 | 353716 | 2020-07-20 | Pendleton | West Virginia | 54071 | 20 | 1 |
350514 | 350514 | 2020-07-19 | Pendleton | West Virginia | 54071 | 20 | 1 |
347313 | 347313 | 2020-07-18 | Pendleton | West Virginia | 54071 | 20 | 1 |
344113 | 344113 | 2020-07-17 | Pendleton | West Virginia | 54071 | 19 | 1 |
340914 | 340914 | 2020-07-16 | Pendleton | West Virginia | 54071 | 18 | 1 |
337718 | 337718 | 2020-07-15 | Pendleton | West Virginia | 54071 | 18 | 1 |
334523 | 334523 | 2020-07-14 | Pendleton | West Virginia | 54071 | 17 | 1 |
331330 | 331330 | 2020-07-13 | Pendleton | West Virginia | 54071 | 16 | 1 |
328144 | 328144 | 2020-07-12 | Pendleton | West Virginia | 54071 | 16 | 1 |
324958 | 324958 | 2020-07-11 | Pendleton | West Virginia | 54071 | 16 | 1 |
321777 | 321777 | 2020-07-10 | Pendleton | West Virginia | 54071 | 16 | 1 |
318598 | 318598 | 2020-07-09 | Pendleton | West Virginia | 54071 | 14 | 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);