ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jefferson" 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 |
---|---|---|---|---|---|---|---|
952760 | 952760 | 2021-01-21 | Jefferson | West Virginia | 54037 | 3072 | 31 |
949515 | 949515 | 2021-01-20 | Jefferson | West Virginia | 54037 | 3059 | 31 |
946269 | 946269 | 2021-01-19 | Jefferson | West Virginia | 54037 | 3044 | 31 |
943022 | 943022 | 2021-01-18 | Jefferson | West Virginia | 54037 | 3019 | 29 |
939777 | 939777 | 2021-01-17 | Jefferson | West Virginia | 54037 | 2981 | 29 |
936532 | 936532 | 2021-01-16 | Jefferson | West Virginia | 54037 | 2964 | 29 |
933287 | 933287 | 2021-01-15 | Jefferson | West Virginia | 54037 | 2937 | 29 |
930042 | 930042 | 2021-01-14 | Jefferson | West Virginia | 54037 | 2893 | 29 |
926797 | 926797 | 2021-01-13 | Jefferson | West Virginia | 54037 | 2861 | 28 |
923551 | 923551 | 2021-01-12 | Jefferson | West Virginia | 54037 | 2828 | 28 |
920306 | 920306 | 2021-01-11 | Jefferson | West Virginia | 54037 | 2795 | 27 |
917061 | 917061 | 2021-01-10 | Jefferson | West Virginia | 54037 | 2766 | 27 |
913816 | 913816 | 2021-01-09 | Jefferson | West Virginia | 54037 | 2737 | 27 |
910571 | 910571 | 2021-01-08 | Jefferson | West Virginia | 54037 | 2696 | 27 |
907326 | 907326 | 2021-01-07 | Jefferson | West Virginia | 54037 | 2627 | 27 |
904080 | 904080 | 2021-01-06 | Jefferson | West Virginia | 54037 | 2596 | 27 |
900835 | 900835 | 2021-01-05 | Jefferson | West Virginia | 54037 | 2547 | 27 |
897590 | 897590 | 2021-01-04 | Jefferson | West Virginia | 54037 | 2513 | 27 |
894344 | 894344 | 2021-01-03 | Jefferson | West Virginia | 54037 | 2492 | 26 |
891098 | 891098 | 2021-01-02 | Jefferson | West Virginia | 54037 | 2463 | 26 |
887851 | 887851 | 2021-01-01 | Jefferson | West Virginia | 54037 | 2423 | 26 |
884606 | 884606 | 2020-12-31 | Jefferson | West Virginia | 54037 | 2337 | 26 |
881361 | 881361 | 2020-12-30 | Jefferson | West Virginia | 54037 | 2324 | 26 |
878116 | 878116 | 2020-12-29 | Jefferson | West Virginia | 54037 | 2282 | 25 |
874871 | 874871 | 2020-12-28 | Jefferson | West Virginia | 54037 | 2249 | 25 |
871626 | 871626 | 2020-12-27 | Jefferson | West Virginia | 54037 | 2230 | 25 |
868381 | 868381 | 2020-12-26 | Jefferson | West Virginia | 54037 | 2212 | 25 |
865136 | 865136 | 2020-12-25 | Jefferson | West Virginia | 54037 | 2190 | 23 |
861891 | 861891 | 2020-12-24 | Jefferson | West Virginia | 54037 | 2150 | 23 |
858646 | 858646 | 2020-12-23 | Jefferson | West Virginia | 54037 | 2131 | 22 |
855401 | 855401 | 2020-12-22 | Jefferson | West Virginia | 54037 | 2108 | 22 |
852156 | 852156 | 2020-12-21 | Jefferson | West Virginia | 54037 | 2081 | 22 |
848911 | 848911 | 2020-12-20 | Jefferson | West Virginia | 54037 | 2054 | 22 |
845666 | 845666 | 2020-12-19 | Jefferson | West Virginia | 54037 | 2020 | 22 |
842420 | 842420 | 2020-12-18 | Jefferson | West Virginia | 54037 | 1990 | 20 |
839175 | 839175 | 2020-12-17 | Jefferson | West Virginia | 54037 | 1961 | 20 |
835930 | 835930 | 2020-12-16 | Jefferson | West Virginia | 54037 | 1914 | 19 |
832684 | 832684 | 2020-12-15 | Jefferson | West Virginia | 54037 | 1874 | 19 |
829437 | 829437 | 2020-12-14 | Jefferson | West Virginia | 54037 | 1836 | 19 |
826191 | 826191 | 2020-12-13 | Jefferson | West Virginia | 54037 | 1812 | 18 |
822944 | 822944 | 2020-12-12 | Jefferson | West Virginia | 54037 | 1793 | 18 |
819698 | 819698 | 2020-12-11 | Jefferson | West Virginia | 54037 | 1746 | 18 |
816452 | 816452 | 2020-12-10 | Jefferson | West Virginia | 54037 | 1724 | 17 |
813206 | 813206 | 2020-12-09 | Jefferson | West Virginia | 54037 | 1677 | 17 |
809962 | 809962 | 2020-12-08 | Jefferson | West Virginia | 54037 | 1638 | 17 |
806717 | 806717 | 2020-12-07 | Jefferson | West Virginia | 54037 | 1612 | 16 |
803472 | 803472 | 2020-12-06 | Jefferson | West Virginia | 54037 | 1584 | 16 |
800227 | 800227 | 2020-12-05 | Jefferson | West Virginia | 54037 | 1536 | 16 |
796982 | 796982 | 2020-12-04 | Jefferson | West Virginia | 54037 | 1486 | 16 |
793737 | 793737 | 2020-12-03 | Jefferson | West Virginia | 54037 | 1471 | 17 |
790492 | 790492 | 2020-12-02 | Jefferson | West Virginia | 54037 | 1442 | 16 |
787247 | 787247 | 2020-12-01 | Jefferson | West Virginia | 54037 | 1413 | 16 |
784003 | 784003 | 2020-11-30 | Jefferson | West Virginia | 54037 | 1371 | 16 |
780758 | 780758 | 2020-11-29 | Jefferson | West Virginia | 54037 | 1353 | 16 |
777512 | 777512 | 2020-11-28 | Jefferson | West Virginia | 54037 | 1309 | 16 |
774267 | 774267 | 2020-11-27 | Jefferson | West Virginia | 54037 | 1297 | 16 |
771022 | 771022 | 2020-11-26 | Jefferson | West Virginia | 54037 | 1263 | 16 |
767776 | 767776 | 2020-11-25 | Jefferson | West Virginia | 54037 | 1233 | 15 |
764531 | 764531 | 2020-11-24 | Jefferson | West Virginia | 54037 | 1206 | 15 |
761286 | 761286 | 2020-11-23 | Jefferson | West Virginia | 54037 | 1181 | 15 |
758041 | 758041 | 2020-11-22 | Jefferson | West Virginia | 54037 | 1165 | 15 |
754794 | 754794 | 2020-11-21 | Jefferson | West Virginia | 54037 | 1128 | 15 |
751548 | 751548 | 2020-11-20 | Jefferson | West Virginia | 54037 | 1093 | 15 |
748302 | 748302 | 2020-11-19 | Jefferson | West Virginia | 54037 | 1060 | 15 |
745056 | 745056 | 2020-11-18 | Jefferson | West Virginia | 54037 | 1028 | 15 |
741809 | 741809 | 2020-11-17 | Jefferson | West Virginia | 54037 | 997 | 13 |
738562 | 738562 | 2020-11-16 | Jefferson | West Virginia | 54037 | 978 | 12 |
735318 | 735318 | 2020-11-15 | Jefferson | West Virginia | 54037 | 947 | 11 |
732072 | 732072 | 2020-11-14 | Jefferson | West Virginia | 54037 | 907 | 11 |
728827 | 728827 | 2020-11-13 | Jefferson | West Virginia | 54037 | 854 | 11 |
725584 | 725584 | 2020-11-12 | Jefferson | West Virginia | 54037 | 822 | 11 |
722341 | 722341 | 2020-11-11 | Jefferson | West Virginia | 54037 | 800 | 11 |
719098 | 719098 | 2020-11-10 | Jefferson | West Virginia | 54037 | 770 | 11 |
715855 | 715855 | 2020-11-09 | Jefferson | West Virginia | 54037 | 761 | 11 |
712611 | 712611 | 2020-11-08 | Jefferson | West Virginia | 54037 | 748 | 10 |
709367 | 709367 | 2020-11-07 | Jefferson | West Virginia | 54037 | 700 | 10 |
706123 | 706123 | 2020-11-06 | Jefferson | West Virginia | 54037 | 690 | 10 |
702880 | 702880 | 2020-11-05 | Jefferson | West Virginia | 54037 | 676 | 9 |
699637 | 699637 | 2020-11-04 | Jefferson | West Virginia | 54037 | 667 | 9 |
696393 | 696393 | 2020-11-03 | Jefferson | West Virginia | 54037 | 659 | 9 |
693151 | 693151 | 2020-11-02 | Jefferson | West Virginia | 54037 | 634 | 5 |
689907 | 689907 | 2020-11-01 | Jefferson | West Virginia | 54037 | 626 | 5 |
686662 | 686662 | 2020-10-31 | Jefferson | West Virginia | 54037 | 622 | 5 |
683419 | 683419 | 2020-10-30 | Jefferson | West Virginia | 54037 | 614 | 5 |
680176 | 680176 | 2020-10-29 | Jefferson | West Virginia | 54037 | 603 | 5 |
676933 | 676933 | 2020-10-28 | Jefferson | West Virginia | 54037 | 599 | 5 |
673690 | 673690 | 2020-10-27 | Jefferson | West Virginia | 54037 | 580 | 5 |
670448 | 670448 | 2020-10-26 | Jefferson | West Virginia | 54037 | 567 | 4 |
667205 | 667205 | 2020-10-25 | Jefferson | West Virginia | 54037 | 561 | 4 |
663960 | 663960 | 2020-10-24 | Jefferson | West Virginia | 54037 | 558 | 4 |
660716 | 660716 | 2020-10-23 | Jefferson | West Virginia | 54037 | 554 | 4 |
657472 | 657472 | 2020-10-22 | Jefferson | West Virginia | 54037 | 545 | 4 |
654227 | 654227 | 2020-10-21 | Jefferson | West Virginia | 54037 | 538 | 4 |
650982 | 650982 | 2020-10-20 | Jefferson | West Virginia | 54037 | 532 | 4 |
647738 | 647738 | 2020-10-19 | Jefferson | West Virginia | 54037 | 525 | 4 |
644492 | 644492 | 2020-10-18 | Jefferson | West Virginia | 54037 | 521 | 4 |
641244 | 641244 | 2020-10-17 | Jefferson | West Virginia | 54037 | 518 | 4 |
637997 | 637997 | 2020-10-16 | Jefferson | West Virginia | 54037 | 513 | 4 |
634752 | 634752 | 2020-10-15 | Jefferson | West Virginia | 54037 | 495 | 4 |
631507 | 631507 | 2020-10-14 | Jefferson | West Virginia | 54037 | 488 | 4 |
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);