ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Wirt" 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 |
---|---|---|---|---|---|---|---|
923585 | 923585 | 2021-01-12 | Wirt | West Virginia | 54105 | 270 | 1 |
920340 | 920340 | 2021-01-11 | Wirt | West Virginia | 54105 | 268 | 1 |
917095 | 917095 | 2021-01-10 | Wirt | West Virginia | 54105 | 266 | 1 |
913850 | 913850 | 2021-01-09 | Wirt | West Virginia | 54105 | 256 | 1 |
910605 | 910605 | 2021-01-08 | Wirt | West Virginia | 54105 | 251 | 1 |
907360 | 907360 | 2021-01-07 | Wirt | West Virginia | 54105 | 249 | 1 |
904114 | 904114 | 2021-01-06 | Wirt | West Virginia | 54105 | 248 | 1 |
900869 | 900869 | 2021-01-05 | Wirt | West Virginia | 54105 | 245 | 1 |
897624 | 897624 | 2021-01-04 | Wirt | West Virginia | 54105 | 244 | 1 |
894378 | 894378 | 2021-01-03 | Wirt | West Virginia | 54105 | 238 | 1 |
891132 | 891132 | 2021-01-02 | Wirt | West Virginia | 54105 | 234 | 1 |
887885 | 887885 | 2021-01-01 | Wirt | West Virginia | 54105 | 229 | 1 |
884640 | 884640 | 2020-12-31 | Wirt | West Virginia | 54105 | 216 | 1 |
881395 | 881395 | 2020-12-30 | Wirt | West Virginia | 54105 | 216 | 1 |
878150 | 878150 | 2020-12-29 | Wirt | West Virginia | 54105 | 213 | 1 |
874905 | 874905 | 2020-12-28 | Wirt | West Virginia | 54105 | 210 | 1 |
871660 | 871660 | 2020-12-27 | Wirt | West Virginia | 54105 | 206 | 1 |
868415 | 868415 | 2020-12-26 | Wirt | West Virginia | 54105 | 202 | 1 |
865170 | 865170 | 2020-12-25 | Wirt | West Virginia | 54105 | 197 | 1 |
861925 | 861925 | 2020-12-24 | Wirt | West Virginia | 54105 | 193 | 1 |
858680 | 858680 | 2020-12-23 | Wirt | West Virginia | 54105 | 188 | 1 |
855435 | 855435 | 2020-12-22 | Wirt | West Virginia | 54105 | 185 | 1 |
852190 | 852190 | 2020-12-21 | Wirt | West Virginia | 54105 | 177 | 1 |
848945 | 848945 | 2020-12-20 | Wirt | West Virginia | 54105 | 175 | 1 |
845700 | 845700 | 2020-12-19 | Wirt | West Virginia | 54105 | 173 | 1 |
842454 | 842454 | 2020-12-18 | Wirt | West Virginia | 54105 | 170 | 1 |
839209 | 839209 | 2020-12-17 | Wirt | West Virginia | 54105 | 167 | 1 |
835964 | 835964 | 2020-12-16 | Wirt | West Virginia | 54105 | 164 | 1 |
832718 | 832718 | 2020-12-15 | Wirt | West Virginia | 54105 | 161 | 1 |
829471 | 829471 | 2020-12-14 | Wirt | West Virginia | 54105 | 159 | 1 |
826225 | 826225 | 2020-12-13 | Wirt | West Virginia | 54105 | 158 | 1 |
822978 | 822978 | 2020-12-12 | Wirt | West Virginia | 54105 | 156 | 1 |
819732 | 819732 | 2020-12-11 | Wirt | West Virginia | 54105 | 157 | 1 |
816486 | 816486 | 2020-12-10 | Wirt | West Virginia | 54105 | 152 | 1 |
813240 | 813240 | 2020-12-09 | Wirt | West Virginia | 54105 | 144 | 1 |
809996 | 809996 | 2020-12-08 | Wirt | West Virginia | 54105 | 141 | 1 |
806751 | 806751 | 2020-12-07 | Wirt | West Virginia | 54105 | 139 | 1 |
803506 | 803506 | 2020-12-06 | Wirt | West Virginia | 54105 | 134 | 1 |
800261 | 800261 | 2020-12-05 | Wirt | West Virginia | 54105 | 131 | 1 |
797016 | 797016 | 2020-12-04 | Wirt | West Virginia | 54105 | 129 | 1 |
793771 | 793771 | 2020-12-03 | Wirt | West Virginia | 54105 | 127 | 1 |
790526 | 790526 | 2020-12-02 | Wirt | West Virginia | 54105 | 120 | 1 |
787281 | 787281 | 2020-12-01 | Wirt | West Virginia | 54105 | 117 | 1 |
784037 | 784037 | 2020-11-30 | Wirt | West Virginia | 54105 | 113 | 1 |
780792 | 780792 | 2020-11-29 | Wirt | West Virginia | 54105 | 111 | 1 |
777546 | 777546 | 2020-11-28 | Wirt | West Virginia | 54105 | 109 | 1 |
774301 | 774301 | 2020-11-27 | Wirt | West Virginia | 54105 | 101 | 1 |
771056 | 771056 | 2020-11-26 | Wirt | West Virginia | 54105 | 95 | 1 |
767810 | 767810 | 2020-11-25 | Wirt | West Virginia | 54105 | 94 | 1 |
764565 | 764565 | 2020-11-24 | Wirt | West Virginia | 54105 | 92 | 1 |
761320 | 761320 | 2020-11-23 | Wirt | West Virginia | 54105 | 90 | 1 |
758075 | 758075 | 2020-11-22 | Wirt | West Virginia | 54105 | 89 | 1 |
754828 | 754828 | 2020-11-21 | Wirt | West Virginia | 54105 | 83 | 1 |
751582 | 751582 | 2020-11-20 | Wirt | West Virginia | 54105 | 77 | 1 |
748336 | 748336 | 2020-11-19 | Wirt | West Virginia | 54105 | 73 | 1 |
745090 | 745090 | 2020-11-18 | Wirt | West Virginia | 54105 | 73 | 1 |
741843 | 741843 | 2020-11-17 | Wirt | West Virginia | 54105 | 70 | 1 |
738596 | 738596 | 2020-11-16 | Wirt | West Virginia | 54105 | 66 | 1 |
735352 | 735352 | 2020-11-15 | Wirt | West Virginia | 54105 | 66 | 1 |
732106 | 732106 | 2020-11-14 | Wirt | West Virginia | 54105 | 65 | 1 |
728861 | 728861 | 2020-11-13 | Wirt | West Virginia | 54105 | 63 | 1 |
725618 | 725618 | 2020-11-12 | Wirt | West Virginia | 54105 | 63 | 1 |
722375 | 722375 | 2020-11-11 | Wirt | West Virginia | 54105 | 61 | 1 |
719132 | 719132 | 2020-11-10 | Wirt | West Virginia | 54105 | 59 | 1 |
715889 | 715889 | 2020-11-09 | Wirt | West Virginia | 54105 | 59 | 1 |
712645 | 712645 | 2020-11-08 | Wirt | West Virginia | 54105 | 59 | 1 |
709401 | 709401 | 2020-11-07 | Wirt | West Virginia | 54105 | 58 | 1 |
706157 | 706157 | 2020-11-06 | Wirt | West Virginia | 54105 | 59 | 0 |
702914 | 702914 | 2020-11-05 | Wirt | West Virginia | 54105 | 59 | 0 |
699671 | 699671 | 2020-11-04 | Wirt | West Virginia | 54105 | 59 | 0 |
696427 | 696427 | 2020-11-03 | Wirt | West Virginia | 54105 | 59 | 0 |
693185 | 693185 | 2020-11-02 | Wirt | West Virginia | 54105 | 56 | 0 |
689941 | 689941 | 2020-11-01 | Wirt | West Virginia | 54105 | 56 | 0 |
686696 | 686696 | 2020-10-31 | Wirt | West Virginia | 54105 | 56 | 0 |
683453 | 683453 | 2020-10-30 | Wirt | West Virginia | 54105 | 55 | 0 |
680210 | 680210 | 2020-10-29 | Wirt | West Virginia | 54105 | 53 | 0 |
676967 | 676967 | 2020-10-28 | Wirt | West Virginia | 54105 | 53 | 0 |
673724 | 673724 | 2020-10-27 | Wirt | West Virginia | 54105 | 51 | 0 |
670482 | 670482 | 2020-10-26 | Wirt | West Virginia | 54105 | 45 | 0 |
667239 | 667239 | 2020-10-25 | Wirt | West Virginia | 54105 | 42 | 0 |
663994 | 663994 | 2020-10-24 | Wirt | West Virginia | 54105 | 41 | 0 |
660750 | 660750 | 2020-10-23 | Wirt | West Virginia | 54105 | 37 | 0 |
657506 | 657506 | 2020-10-22 | Wirt | West Virginia | 54105 | 35 | 0 |
654261 | 654261 | 2020-10-21 | Wirt | West Virginia | 54105 | 32 | 0 |
651016 | 651016 | 2020-10-20 | Wirt | West Virginia | 54105 | 30 | 0 |
647772 | 647772 | 2020-10-19 | Wirt | West Virginia | 54105 | 28 | 0 |
644526 | 644526 | 2020-10-18 | Wirt | West Virginia | 54105 | 28 | 0 |
641278 | 641278 | 2020-10-17 | Wirt | West Virginia | 54105 | 28 | 0 |
638031 | 638031 | 2020-10-16 | Wirt | West Virginia | 54105 | 26 | 0 |
634786 | 634786 | 2020-10-15 | Wirt | West Virginia | 54105 | 23 | 0 |
631541 | 631541 | 2020-10-14 | Wirt | West Virginia | 54105 | 22 | 0 |
628297 | 628297 | 2020-10-13 | Wirt | West Virginia | 54105 | 22 | 0 |
625054 | 625054 | 2020-10-12 | Wirt | West Virginia | 54105 | 20 | 0 |
621811 | 621811 | 2020-10-11 | Wirt | West Virginia | 54105 | 20 | 0 |
618568 | 618568 | 2020-10-10 | Wirt | West Virginia | 54105 | 20 | 0 |
615326 | 615326 | 2020-10-09 | Wirt | West Virginia | 54105 | 19 | 0 |
612085 | 612085 | 2020-10-08 | Wirt | West Virginia | 54105 | 15 | 0 |
608843 | 608843 | 2020-10-07 | Wirt | West Virginia | 54105 | 12 | 0 |
605600 | 605600 | 2020-10-06 | Wirt | West Virginia | 54105 | 12 | 0 |
602358 | 602358 | 2020-10-05 | Wirt | West Virginia | 54105 | 12 | 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);