ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 54093 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 |
---|---|---|---|---|---|---|---|
923579 | 923579 | 2021-01-12 | Tucker | West Virginia | 54093 | 403 | 4 |
920334 | 920334 | 2021-01-11 | Tucker | West Virginia | 54093 | 406 | 4 |
917089 | 917089 | 2021-01-10 | Tucker | West Virginia | 54093 | 404 | 4 |
913844 | 913844 | 2021-01-09 | Tucker | West Virginia | 54093 | 401 | 4 |
910599 | 910599 | 2021-01-08 | Tucker | West Virginia | 54093 | 399 | 4 |
907354 | 907354 | 2021-01-07 | Tucker | West Virginia | 54093 | 386 | 4 |
904108 | 904108 | 2021-01-06 | Tucker | West Virginia | 54093 | 364 | 4 |
900863 | 900863 | 2021-01-05 | Tucker | West Virginia | 54093 | 357 | 3 |
897618 | 897618 | 2021-01-04 | Tucker | West Virginia | 54093 | 355 | 2 |
894372 | 894372 | 2021-01-03 | Tucker | West Virginia | 54093 | 348 | 2 |
891126 | 891126 | 2021-01-02 | Tucker | West Virginia | 54093 | 341 | 2 |
887879 | 887879 | 2021-01-01 | Tucker | West Virginia | 54093 | 338 | 2 |
884634 | 884634 | 2020-12-31 | Tucker | West Virginia | 54093 | 330 | 2 |
881389 | 881389 | 2020-12-30 | Tucker | West Virginia | 54093 | 321 | 2 |
878144 | 878144 | 2020-12-29 | Tucker | West Virginia | 54093 | 312 | 2 |
874899 | 874899 | 2020-12-28 | Tucker | West Virginia | 54093 | 303 | 1 |
871654 | 871654 | 2020-12-27 | Tucker | West Virginia | 54093 | 302 | 1 |
868409 | 868409 | 2020-12-26 | Tucker | West Virginia | 54093 | 306 | 1 |
865164 | 865164 | 2020-12-25 | Tucker | West Virginia | 54093 | 302 | 1 |
861919 | 861919 | 2020-12-24 | Tucker | West Virginia | 54093 | 291 | 1 |
858674 | 858674 | 2020-12-23 | Tucker | West Virginia | 54093 | 280 | 1 |
855429 | 855429 | 2020-12-22 | Tucker | West Virginia | 54093 | 276 | 1 |
852184 | 852184 | 2020-12-21 | Tucker | West Virginia | 54093 | 272 | 1 |
848939 | 848939 | 2020-12-20 | Tucker | West Virginia | 54093 | 271 | 1 |
845694 | 845694 | 2020-12-19 | Tucker | West Virginia | 54093 | 267 | 1 |
842448 | 842448 | 2020-12-18 | Tucker | West Virginia | 54093 | 255 | 1 |
839203 | 839203 | 2020-12-17 | Tucker | West Virginia | 54093 | 252 | 1 |
835958 | 835958 | 2020-12-16 | Tucker | West Virginia | 54093 | 244 | 0 |
832712 | 832712 | 2020-12-15 | Tucker | West Virginia | 54093 | 242 | 0 |
829465 | 829465 | 2020-12-14 | Tucker | West Virginia | 54093 | 241 | 0 |
826219 | 826219 | 2020-12-13 | Tucker | West Virginia | 54093 | 241 | 0 |
822972 | 822972 | 2020-12-12 | Tucker | West Virginia | 54093 | 238 | 0 |
819726 | 819726 | 2020-12-11 | Tucker | West Virginia | 54093 | 219 | 0 |
816480 | 816480 | 2020-12-10 | Tucker | West Virginia | 54093 | 211 | 0 |
813234 | 813234 | 2020-12-09 | Tucker | West Virginia | 54093 | 207 | 0 |
809990 | 809990 | 2020-12-08 | Tucker | West Virginia | 54093 | 204 | 0 |
806745 | 806745 | 2020-12-07 | Tucker | West Virginia | 54093 | 196 | 0 |
803500 | 803500 | 2020-12-06 | Tucker | West Virginia | 54093 | 190 | 0 |
800255 | 800255 | 2020-12-05 | Tucker | West Virginia | 54093 | 176 | 0 |
797010 | 797010 | 2020-12-04 | Tucker | West Virginia | 54093 | 168 | 0 |
793765 | 793765 | 2020-12-03 | Tucker | West Virginia | 54093 | 159 | 0 |
790520 | 790520 | 2020-12-02 | Tucker | West Virginia | 54093 | 148 | 0 |
787275 | 787275 | 2020-12-01 | Tucker | West Virginia | 54093 | 141 | 0 |
784031 | 784031 | 2020-11-30 | Tucker | West Virginia | 54093 | 140 | 0 |
780786 | 780786 | 2020-11-29 | Tucker | West Virginia | 54093 | 140 | 0 |
777540 | 777540 | 2020-11-28 | Tucker | West Virginia | 54093 | 134 | 0 |
774295 | 774295 | 2020-11-27 | Tucker | West Virginia | 54093 | 132 | 0 |
771050 | 771050 | 2020-11-26 | Tucker | West Virginia | 54093 | 126 | 0 |
767804 | 767804 | 2020-11-25 | Tucker | West Virginia | 54093 | 117 | 0 |
764559 | 764559 | 2020-11-24 | Tucker | West Virginia | 54093 | 112 | 0 |
761314 | 761314 | 2020-11-23 | Tucker | West Virginia | 54093 | 105 | 0 |
758069 | 758069 | 2020-11-22 | Tucker | West Virginia | 54093 | 104 | 0 |
754822 | 754822 | 2020-11-21 | Tucker | West Virginia | 54093 | 101 | 0 |
751576 | 751576 | 2020-11-20 | Tucker | West Virginia | 54093 | 98 | 0 |
748330 | 748330 | 2020-11-19 | Tucker | West Virginia | 54093 | 91 | 0 |
745084 | 745084 | 2020-11-18 | Tucker | West Virginia | 54093 | 83 | 0 |
741837 | 741837 | 2020-11-17 | Tucker | West Virginia | 54093 | 77 | 0 |
738590 | 738590 | 2020-11-16 | Tucker | West Virginia | 54093 | 77 | 0 |
735346 | 735346 | 2020-11-15 | Tucker | West Virginia | 54093 | 75 | 0 |
732100 | 732100 | 2020-11-14 | Tucker | West Virginia | 54093 | 74 | 0 |
728855 | 728855 | 2020-11-13 | Tucker | West Virginia | 54093 | 72 | 0 |
725612 | 725612 | 2020-11-12 | Tucker | West Virginia | 54093 | 72 | 0 |
722369 | 722369 | 2020-11-11 | Tucker | West Virginia | 54093 | 71 | 0 |
719126 | 719126 | 2020-11-10 | Tucker | West Virginia | 54093 | 71 | 0 |
715883 | 715883 | 2020-11-09 | Tucker | West Virginia | 54093 | 70 | 0 |
712639 | 712639 | 2020-11-08 | Tucker | West Virginia | 54093 | 69 | 0 |
709395 | 709395 | 2020-11-07 | Tucker | West Virginia | 54093 | 69 | 0 |
706151 | 706151 | 2020-11-06 | Tucker | West Virginia | 54093 | 70 | 0 |
702908 | 702908 | 2020-11-05 | Tucker | West Virginia | 54093 | 68 | 0 |
699665 | 699665 | 2020-11-04 | Tucker | West Virginia | 54093 | 68 | 0 |
696421 | 696421 | 2020-11-03 | Tucker | West Virginia | 54093 | 67 | 0 |
693179 | 693179 | 2020-11-02 | Tucker | West Virginia | 54093 | 67 | 0 |
689935 | 689935 | 2020-11-01 | Tucker | West Virginia | 54093 | 67 | 0 |
686690 | 686690 | 2020-10-31 | Tucker | West Virginia | 54093 | 66 | 0 |
683447 | 683447 | 2020-10-30 | Tucker | West Virginia | 54093 | 65 | 0 |
680204 | 680204 | 2020-10-29 | Tucker | West Virginia | 54093 | 64 | 0 |
676961 | 676961 | 2020-10-28 | Tucker | West Virginia | 54093 | 63 | 0 |
673718 | 673718 | 2020-10-27 | Tucker | West Virginia | 54093 | 63 | 0 |
670476 | 670476 | 2020-10-26 | Tucker | West Virginia | 54093 | 63 | 0 |
667233 | 667233 | 2020-10-25 | Tucker | West Virginia | 54093 | 63 | 0 |
663988 | 663988 | 2020-10-24 | Tucker | West Virginia | 54093 | 62 | 0 |
660744 | 660744 | 2020-10-23 | Tucker | West Virginia | 54093 | 61 | 0 |
657500 | 657500 | 2020-10-22 | Tucker | West Virginia | 54093 | 60 | 0 |
654255 | 654255 | 2020-10-21 | Tucker | West Virginia | 54093 | 58 | 0 |
651010 | 651010 | 2020-10-20 | Tucker | West Virginia | 54093 | 56 | 0 |
647766 | 647766 | 2020-10-19 | Tucker | West Virginia | 54093 | 52 | 0 |
644520 | 644520 | 2020-10-18 | Tucker | West Virginia | 54093 | 52 | 0 |
641272 | 641272 | 2020-10-17 | Tucker | West Virginia | 54093 | 51 | 0 |
638025 | 638025 | 2020-10-16 | Tucker | West Virginia | 54093 | 52 | 0 |
634780 | 634780 | 2020-10-15 | Tucker | West Virginia | 54093 | 50 | 0 |
631535 | 631535 | 2020-10-14 | Tucker | West Virginia | 54093 | 49 | 0 |
628291 | 628291 | 2020-10-13 | Tucker | West Virginia | 54093 | 48 | 0 |
625048 | 625048 | 2020-10-12 | Tucker | West Virginia | 54093 | 47 | 0 |
621805 | 621805 | 2020-10-11 | Tucker | West Virginia | 54093 | 47 | 0 |
618562 | 618562 | 2020-10-10 | Tucker | West Virginia | 54093 | 46 | 0 |
615320 | 615320 | 2020-10-09 | Tucker | West Virginia | 54093 | 44 | 0 |
612079 | 612079 | 2020-10-08 | Tucker | West Virginia | 54093 | 42 | 0 |
608837 | 608837 | 2020-10-07 | Tucker | West Virginia | 54093 | 43 | 0 |
605594 | 605594 | 2020-10-06 | Tucker | West Virginia | 54093 | 43 | 0 |
602352 | 602352 | 2020-10-05 | Tucker | West Virginia | 54093 | 43 | 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);