ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where county = "Clay" 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 |
---|---|---|---|---|---|---|---|
923540 | 923540 | 2021-01-12 | Clay | West Virginia | 54015 | 288 | 4 |
920295 | 920295 | 2021-01-11 | Clay | West Virginia | 54015 | 286 | 4 |
917050 | 917050 | 2021-01-10 | Clay | West Virginia | 54015 | 285 | 4 |
913805 | 913805 | 2021-01-09 | Clay | West Virginia | 54015 | 283 | 4 |
910560 | 910560 | 2021-01-08 | Clay | West Virginia | 54015 | 278 | 4 |
907315 | 907315 | 2021-01-07 | Clay | West Virginia | 54015 | 271 | 4 |
904069 | 904069 | 2021-01-06 | Clay | West Virginia | 54015 | 269 | 4 |
900824 | 900824 | 2021-01-05 | Clay | West Virginia | 54015 | 269 | 4 |
897579 | 897579 | 2021-01-04 | Clay | West Virginia | 54015 | 271 | 4 |
894333 | 894333 | 2021-01-03 | Clay | West Virginia | 54015 | 268 | 4 |
891087 | 891087 | 2021-01-02 | Clay | West Virginia | 54015 | 263 | 4 |
887840 | 887840 | 2021-01-01 | Clay | West Virginia | 54015 | 263 | 4 |
884595 | 884595 | 2020-12-31 | Clay | West Virginia | 54015 | 258 | 4 |
881350 | 881350 | 2020-12-30 | Clay | West Virginia | 54015 | 258 | 4 |
878105 | 878105 | 2020-12-29 | Clay | West Virginia | 54015 | 252 | 4 |
874860 | 874860 | 2020-12-28 | Clay | West Virginia | 54015 | 252 | 4 |
871615 | 871615 | 2020-12-27 | Clay | West Virginia | 54015 | 245 | 4 |
868370 | 868370 | 2020-12-26 | Clay | West Virginia | 54015 | 246 | 4 |
865125 | 865125 | 2020-12-25 | Clay | West Virginia | 54015 | 243 | 4 |
861880 | 861880 | 2020-12-24 | Clay | West Virginia | 54015 | 241 | 4 |
858635 | 858635 | 2020-12-23 | Clay | West Virginia | 54015 | 239 | 4 |
855390 | 855390 | 2020-12-22 | Clay | West Virginia | 54015 | 236 | 3 |
852145 | 852145 | 2020-12-21 | Clay | West Virginia | 54015 | 231 | 3 |
848900 | 848900 | 2020-12-20 | Clay | West Virginia | 54015 | 230 | 3 |
845655 | 845655 | 2020-12-19 | Clay | West Virginia | 54015 | 223 | 3 |
842409 | 842409 | 2020-12-18 | Clay | West Virginia | 54015 | 222 | 3 |
839164 | 839164 | 2020-12-17 | Clay | West Virginia | 54015 | 216 | 3 |
835919 | 835919 | 2020-12-16 | Clay | West Virginia | 54015 | 211 | 3 |
832673 | 832673 | 2020-12-15 | Clay | West Virginia | 54015 | 200 | 3 |
829426 | 829426 | 2020-12-14 | Clay | West Virginia | 54015 | 193 | 3 |
826180 | 826180 | 2020-12-13 | Clay | West Virginia | 54015 | 192 | 3 |
822933 | 822933 | 2020-12-12 | Clay | West Virginia | 54015 | 190 | 3 |
819687 | 819687 | 2020-12-11 | Clay | West Virginia | 54015 | 186 | 3 |
816441 | 816441 | 2020-12-10 | Clay | West Virginia | 54015 | 183 | 3 |
813195 | 813195 | 2020-12-09 | Clay | West Virginia | 54015 | 170 | 3 |
809951 | 809951 | 2020-12-08 | Clay | West Virginia | 54015 | 161 | 3 |
806706 | 806706 | 2020-12-07 | Clay | West Virginia | 54015 | 158 | 3 |
803461 | 803461 | 2020-12-06 | Clay | West Virginia | 54015 | 149 | 3 |
800216 | 800216 | 2020-12-05 | Clay | West Virginia | 54015 | 149 | 3 |
796971 | 796971 | 2020-12-04 | Clay | West Virginia | 54015 | 147 | 3 |
793726 | 793726 | 2020-12-03 | Clay | West Virginia | 54015 | 132 | 3 |
790481 | 790481 | 2020-12-02 | Clay | West Virginia | 54015 | 123 | 3 |
787236 | 787236 | 2020-12-01 | Clay | West Virginia | 54015 | 120 | 3 |
783992 | 783992 | 2020-11-30 | Clay | West Virginia | 54015 | 121 | 3 |
780747 | 780747 | 2020-11-29 | Clay | West Virginia | 54015 | 117 | 3 |
777501 | 777501 | 2020-11-28 | Clay | West Virginia | 54015 | 107 | 3 |
774256 | 774256 | 2020-11-27 | Clay | West Virginia | 54015 | 107 | 3 |
771011 | 771011 | 2020-11-26 | Clay | West Virginia | 54015 | 106 | 3 |
767765 | 767765 | 2020-11-25 | Clay | West Virginia | 54015 | 107 | 3 |
764520 | 764520 | 2020-11-24 | Clay | West Virginia | 54015 | 107 | 3 |
761275 | 761275 | 2020-11-23 | Clay | West Virginia | 54015 | 104 | 3 |
758030 | 758030 | 2020-11-22 | Clay | West Virginia | 54015 | 104 | 3 |
754783 | 754783 | 2020-11-21 | Clay | West Virginia | 54015 | 104 | 3 |
751537 | 751537 | 2020-11-20 | Clay | West Virginia | 54015 | 104 | 3 |
748291 | 748291 | 2020-11-19 | Clay | West Virginia | 54015 | 100 | 3 |
745045 | 745045 | 2020-11-18 | Clay | West Virginia | 54015 | 100 | 3 |
741798 | 741798 | 2020-11-17 | Clay | West Virginia | 54015 | 99 | 3 |
738551 | 738551 | 2020-11-16 | Clay | West Virginia | 54015 | 94 | 3 |
735307 | 735307 | 2020-11-15 | Clay | West Virginia | 54015 | 94 | 3 |
732061 | 732061 | 2020-11-14 | Clay | West Virginia | 54015 | 94 | 3 |
728816 | 728816 | 2020-11-13 | Clay | West Virginia | 54015 | 94 | 3 |
725573 | 725573 | 2020-11-12 | Clay | West Virginia | 54015 | 92 | 3 |
722330 | 722330 | 2020-11-11 | Clay | West Virginia | 54015 | 81 | 3 |
719087 | 719087 | 2020-11-10 | Clay | West Virginia | 54015 | 75 | 3 |
715844 | 715844 | 2020-11-09 | Clay | West Virginia | 54015 | 75 | 3 |
712600 | 712600 | 2020-11-08 | Clay | West Virginia | 54015 | 75 | 3 |
709356 | 709356 | 2020-11-07 | Clay | West Virginia | 54015 | 74 | 3 |
706112 | 706112 | 2020-11-06 | Clay | West Virginia | 54015 | 72 | 3 |
702869 | 702869 | 2020-11-05 | Clay | West Virginia | 54015 | 70 | 3 |
699626 | 699626 | 2020-11-04 | Clay | West Virginia | 54015 | 69 | 3 |
696382 | 696382 | 2020-11-03 | Clay | West Virginia | 54015 | 65 | 3 |
693140 | 693140 | 2020-11-02 | Clay | West Virginia | 54015 | 65 | 3 |
689896 | 689896 | 2020-11-01 | Clay | West Virginia | 54015 | 65 | 3 |
686651 | 686651 | 2020-10-31 | Clay | West Virginia | 54015 | 65 | 3 |
683408 | 683408 | 2020-10-30 | Clay | West Virginia | 54015 | 63 | 3 |
680165 | 680165 | 2020-10-29 | Clay | West Virginia | 54015 | 64 | 3 |
676922 | 676922 | 2020-10-28 | Clay | West Virginia | 54015 | 62 | 3 |
673679 | 673679 | 2020-10-27 | Clay | West Virginia | 54015 | 61 | 3 |
670437 | 670437 | 2020-10-26 | Clay | West Virginia | 54015 | 60 | 3 |
667194 | 667194 | 2020-10-25 | Clay | West Virginia | 54015 | 59 | 3 |
663949 | 663949 | 2020-10-24 | Clay | West Virginia | 54015 | 58 | 3 |
660705 | 660705 | 2020-10-23 | Clay | West Virginia | 54015 | 58 | 3 |
657461 | 657461 | 2020-10-22 | Clay | West Virginia | 54015 | 56 | 3 |
654216 | 654216 | 2020-10-21 | Clay | West Virginia | 54015 | 55 | 3 |
650971 | 650971 | 2020-10-20 | Clay | West Virginia | 54015 | 55 | 3 |
647727 | 647727 | 2020-10-19 | Clay | West Virginia | 54015 | 55 | 2 |
644481 | 644481 | 2020-10-18 | Clay | West Virginia | 54015 | 55 | 2 |
641233 | 641233 | 2020-10-17 | Clay | West Virginia | 54015 | 51 | 2 |
637986 | 637986 | 2020-10-16 | Clay | West Virginia | 54015 | 51 | 2 |
634741 | 634741 | 2020-10-15 | Clay | West Virginia | 54015 | 50 | 2 |
631496 | 631496 | 2020-10-14 | Clay | West Virginia | 54015 | 48 | 2 |
628252 | 628252 | 2020-10-13 | Clay | West Virginia | 54015 | 51 | 2 |
625009 | 625009 | 2020-10-12 | Clay | West Virginia | 54015 | 49 | 2 |
621766 | 621766 | 2020-10-11 | Clay | West Virginia | 54015 | 49 | 2 |
618523 | 618523 | 2020-10-10 | Clay | West Virginia | 54015 | 48 | 2 |
615281 | 615281 | 2020-10-09 | Clay | West Virginia | 54015 | 48 | 2 |
612040 | 612040 | 2020-10-08 | Clay | West Virginia | 54015 | 44 | 2 |
608798 | 608798 | 2020-10-07 | Clay | West Virginia | 54015 | 43 | 2 |
605555 | 605555 | 2020-10-06 | Clay | West Virginia | 54015 | 37 | 2 |
602313 | 602313 | 2020-10-05 | Clay | West Virginia | 54015 | 37 | 2 |
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);