ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
215 rows where deaths = 1, fips = 54027 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
748297 | 748297 | 2020-11-19 | Hampshire | West Virginia | 54027 | 242 | 1 |
745051 | 745051 | 2020-11-18 | Hampshire | West Virginia | 54027 | 233 | 1 |
741804 | 741804 | 2020-11-17 | Hampshire | West Virginia | 54027 | 217 | 1 |
738557 | 738557 | 2020-11-16 | Hampshire | West Virginia | 54027 | 207 | 1 |
735313 | 735313 | 2020-11-15 | Hampshire | West Virginia | 54027 | 206 | 1 |
732067 | 732067 | 2020-11-14 | Hampshire | West Virginia | 54027 | 202 | 1 |
728822 | 728822 | 2020-11-13 | Hampshire | West Virginia | 54027 | 194 | 1 |
725579 | 725579 | 2020-11-12 | Hampshire | West Virginia | 54027 | 193 | 1 |
722336 | 722336 | 2020-11-11 | Hampshire | West Virginia | 54027 | 188 | 1 |
719093 | 719093 | 2020-11-10 | Hampshire | West Virginia | 54027 | 184 | 1 |
715850 | 715850 | 2020-11-09 | Hampshire | West Virginia | 54027 | 176 | 1 |
712606 | 712606 | 2020-11-08 | Hampshire | West Virginia | 54027 | 175 | 1 |
709362 | 709362 | 2020-11-07 | Hampshire | West Virginia | 54027 | 175 | 1 |
706118 | 706118 | 2020-11-06 | Hampshire | West Virginia | 54027 | 171 | 1 |
702875 | 702875 | 2020-11-05 | Hampshire | West Virginia | 54027 | 165 | 1 |
699632 | 699632 | 2020-11-04 | Hampshire | West Virginia | 54027 | 158 | 1 |
696388 | 696388 | 2020-11-03 | Hampshire | West Virginia | 54027 | 149 | 1 |
693146 | 693146 | 2020-11-02 | Hampshire | West Virginia | 54027 | 146 | 1 |
689902 | 689902 | 2020-11-01 | Hampshire | West Virginia | 54027 | 144 | 1 |
686657 | 686657 | 2020-10-31 | Hampshire | West Virginia | 54027 | 143 | 1 |
683414 | 683414 | 2020-10-30 | Hampshire | West Virginia | 54027 | 140 | 1 |
680171 | 680171 | 2020-10-29 | Hampshire | West Virginia | 54027 | 133 | 1 |
676928 | 676928 | 2020-10-28 | Hampshire | West Virginia | 54027 | 130 | 1 |
673685 | 673685 | 2020-10-27 | Hampshire | West Virginia | 54027 | 127 | 1 |
670443 | 670443 | 2020-10-26 | Hampshire | West Virginia | 54027 | 125 | 1 |
667200 | 667200 | 2020-10-25 | Hampshire | West Virginia | 54027 | 123 | 1 |
663955 | 663955 | 2020-10-24 | Hampshire | West Virginia | 54027 | 123 | 1 |
660711 | 660711 | 2020-10-23 | Hampshire | West Virginia | 54027 | 123 | 1 |
657467 | 657467 | 2020-10-22 | Hampshire | West Virginia | 54027 | 122 | 1 |
654222 | 654222 | 2020-10-21 | Hampshire | West Virginia | 54027 | 122 | 1 |
650977 | 650977 | 2020-10-20 | Hampshire | West Virginia | 54027 | 119 | 1 |
647733 | 647733 | 2020-10-19 | Hampshire | West Virginia | 54027 | 119 | 1 |
644487 | 644487 | 2020-10-18 | Hampshire | West Virginia | 54027 | 119 | 1 |
641239 | 641239 | 2020-10-17 | Hampshire | West Virginia | 54027 | 118 | 1 |
637992 | 637992 | 2020-10-16 | Hampshire | West Virginia | 54027 | 118 | 1 |
634747 | 634747 | 2020-10-15 | Hampshire | West Virginia | 54027 | 118 | 1 |
631502 | 631502 | 2020-10-14 | Hampshire | West Virginia | 54027 | 118 | 1 |
628258 | 628258 | 2020-10-13 | Hampshire | West Virginia | 54027 | 117 | 1 |
625015 | 625015 | 2020-10-12 | Hampshire | West Virginia | 54027 | 117 | 1 |
621772 | 621772 | 2020-10-11 | Hampshire | West Virginia | 54027 | 117 | 1 |
618529 | 618529 | 2020-10-10 | Hampshire | West Virginia | 54027 | 116 | 1 |
615287 | 615287 | 2020-10-09 | Hampshire | West Virginia | 54027 | 115 | 1 |
612046 | 612046 | 2020-10-08 | Hampshire | West Virginia | 54027 | 112 | 1 |
608804 | 608804 | 2020-10-07 | Hampshire | West Virginia | 54027 | 112 | 1 |
605561 | 605561 | 2020-10-06 | Hampshire | West Virginia | 54027 | 112 | 1 |
602319 | 602319 | 2020-10-05 | Hampshire | West Virginia | 54027 | 111 | 1 |
599076 | 599076 | 2020-10-04 | Hampshire | West Virginia | 54027 | 111 | 1 |
595833 | 595833 | 2020-10-03 | Hampshire | West Virginia | 54027 | 110 | 1 |
592591 | 592591 | 2020-10-02 | Hampshire | West Virginia | 54027 | 109 | 1 |
589351 | 589351 | 2020-10-01 | Hampshire | West Virginia | 54027 | 109 | 1 |
586110 | 586110 | 2020-09-30 | Hampshire | West Virginia | 54027 | 108 | 1 |
582870 | 582870 | 2020-09-29 | Hampshire | West Virginia | 54027 | 108 | 1 |
579631 | 579631 | 2020-09-28 | Hampshire | West Virginia | 54027 | 108 | 1 |
576390 | 576390 | 2020-09-27 | Hampshire | West Virginia | 54027 | 107 | 1 |
573146 | 573146 | 2020-09-26 | Hampshire | West Virginia | 54027 | 106 | 1 |
569904 | 569904 | 2020-09-25 | Hampshire | West Virginia | 54027 | 104 | 1 |
566663 | 566663 | 2020-09-24 | Hampshire | West Virginia | 54027 | 103 | 1 |
563422 | 563422 | 2020-09-23 | Hampshire | West Virginia | 54027 | 103 | 1 |
560183 | 560183 | 2020-09-22 | Hampshire | West Virginia | 54027 | 102 | 1 |
556947 | 556947 | 2020-09-21 | Hampshire | West Virginia | 54027 | 100 | 1 |
553710 | 553710 | 2020-09-20 | Hampshire | West Virginia | 54027 | 100 | 1 |
550471 | 550471 | 2020-09-19 | Hampshire | West Virginia | 54027 | 100 | 1 |
547232 | 547232 | 2020-09-18 | Hampshire | West Virginia | 54027 | 100 | 1 |
543995 | 543995 | 2020-09-17 | Hampshire | West Virginia | 54027 | 99 | 1 |
540759 | 540759 | 2020-09-16 | Hampshire | West Virginia | 54027 | 97 | 1 |
537522 | 537522 | 2020-09-15 | Hampshire | West Virginia | 54027 | 96 | 1 |
534286 | 534286 | 2020-09-14 | Hampshire | West Virginia | 54027 | 95 | 1 |
531051 | 531051 | 2020-09-13 | Hampshire | West Virginia | 54027 | 95 | 1 |
527814 | 527814 | 2020-09-12 | Hampshire | West Virginia | 54027 | 95 | 1 |
524578 | 524578 | 2020-09-11 | Hampshire | West Virginia | 54027 | 93 | 1 |
521342 | 521342 | 2020-09-10 | Hampshire | West Virginia | 54027 | 93 | 1 |
518105 | 518105 | 2020-09-09 | Hampshire | West Virginia | 54027 | 93 | 1 |
514870 | 514870 | 2020-09-08 | Hampshire | West Virginia | 54027 | 93 | 1 |
511637 | 511637 | 2020-09-07 | Hampshire | West Virginia | 54027 | 93 | 1 |
508404 | 508404 | 2020-09-06 | Hampshire | West Virginia | 54027 | 93 | 1 |
505172 | 505172 | 2020-09-05 | Hampshire | West Virginia | 54027 | 92 | 1 |
501938 | 501938 | 2020-09-04 | Hampshire | West Virginia | 54027 | 92 | 1 |
498704 | 498704 | 2020-09-03 | Hampshire | West Virginia | 54027 | 92 | 1 |
495471 | 495471 | 2020-09-02 | Hampshire | West Virginia | 54027 | 92 | 1 |
492237 | 492237 | 2020-09-01 | Hampshire | West Virginia | 54027 | 92 | 1 |
489004 | 489004 | 2020-08-31 | Hampshire | West Virginia | 54027 | 92 | 1 |
485771 | 485771 | 2020-08-30 | Hampshire | West Virginia | 54027 | 92 | 1 |
482536 | 482536 | 2020-08-29 | Hampshire | West Virginia | 54027 | 91 | 1 |
479302 | 479302 | 2020-08-28 | Hampshire | West Virginia | 54027 | 91 | 1 |
476069 | 476069 | 2020-08-27 | Hampshire | West Virginia | 54027 | 91 | 1 |
472836 | 472836 | 2020-08-26 | Hampshire | West Virginia | 54027 | 91 | 1 |
469604 | 469604 | 2020-08-25 | Hampshire | West Virginia | 54027 | 92 | 1 |
466375 | 466375 | 2020-08-24 | Hampshire | West Virginia | 54027 | 92 | 1 |
463146 | 463146 | 2020-08-23 | Hampshire | West Virginia | 54027 | 91 | 1 |
459917 | 459917 | 2020-08-22 | Hampshire | West Virginia | 54027 | 91 | 1 |
456690 | 456690 | 2020-08-21 | Hampshire | West Virginia | 54027 | 91 | 1 |
453462 | 453462 | 2020-08-20 | Hampshire | West Virginia | 54027 | 91 | 1 |
450234 | 450234 | 2020-08-19 | Hampshire | West Virginia | 54027 | 90 | 1 |
447006 | 447006 | 2020-08-18 | Hampshire | West Virginia | 54027 | 90 | 1 |
443779 | 443779 | 2020-08-17 | Hampshire | West Virginia | 54027 | 89 | 1 |
440553 | 440553 | 2020-08-16 | Hampshire | West Virginia | 54027 | 88 | 1 |
437327 | 437327 | 2020-08-15 | Hampshire | West Virginia | 54027 | 86 | 1 |
434101 | 434101 | 2020-08-14 | Hampshire | West Virginia | 54027 | 86 | 1 |
430876 | 430876 | 2020-08-13 | Hampshire | West Virginia | 54027 | 84 | 1 |
427648 | 427648 | 2020-08-12 | Hampshire | West Virginia | 54027 | 80 | 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);