ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jefferson" and fips = 54037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056620 | 1056620 | 2021-02-22 | Jefferson | West Virginia | 54037 | 3579 | 37 |
1053374 | 1053374 | 2021-02-21 | Jefferson | West Virginia | 54037 | 3575 | 37 |
1050127 | 1050127 | 2021-02-20 | Jefferson | West Virginia | 54037 | 3561 | 37 |
1046880 | 1046880 | 2021-02-19 | Jefferson | West Virginia | 54037 | 3560 | 37 |
1043635 | 1043635 | 2021-02-18 | Jefferson | West Virginia | 54037 | 3550 | 36 |
1040390 | 1040390 | 2021-02-17 | Jefferson | West Virginia | 54037 | 3541 | 36 |
1037145 | 1037145 | 2021-02-16 | Jefferson | West Virginia | 54037 | 3527 | 36 |
1033900 | 1033900 | 2021-02-15 | Jefferson | West Virginia | 54037 | 3520 | 36 |
1030654 | 1030654 | 2021-02-14 | Jefferson | West Virginia | 54037 | 3512 | 36 |
1027407 | 1027407 | 2021-02-13 | Jefferson | West Virginia | 54037 | 3501 | 36 |
1024162 | 1024162 | 2021-02-12 | Jefferson | West Virginia | 54037 | 3490 | 36 |
1020917 | 1020917 | 2021-02-11 | Jefferson | West Virginia | 54037 | 3476 | 36 |
1017672 | 1017672 | 2021-02-10 | Jefferson | West Virginia | 54037 | 3462 | 36 |
1014427 | 1014427 | 2021-02-09 | Jefferson | West Virginia | 54037 | 3456 | 35 |
1011182 | 1011182 | 2021-02-08 | Jefferson | West Virginia | 54037 | 3451 | 35 |
1007936 | 1007936 | 2021-02-07 | Jefferson | West Virginia | 54037 | 3438 | 35 |
1004690 | 1004690 | 2021-02-06 | Jefferson | West Virginia | 54037 | 3421 | 35 |
1001444 | 1001444 | 2021-02-05 | Jefferson | West Virginia | 54037 | 3394 | 35 |
998198 | 998198 | 2021-02-04 | Jefferson | West Virginia | 54037 | 3381 | 35 |
994952 | 994952 | 2021-02-03 | Jefferson | West Virginia | 54037 | 3377 | 35 |
991706 | 991706 | 2021-02-02 | Jefferson | West Virginia | 54037 | 3366 | 34 |
988460 | 988460 | 2021-02-01 | Jefferson | West Virginia | 54037 | 3360 | 34 |
985213 | 985213 | 2021-01-31 | Jefferson | West Virginia | 54037 | 3351 | 34 |
981966 | 981966 | 2021-01-30 | Jefferson | West Virginia | 54037 | 3324 | 33 |
978720 | 978720 | 2021-01-29 | Jefferson | West Virginia | 54037 | 3299 | 33 |
975475 | 975475 | 2021-01-28 | Jefferson | West Virginia | 54037 | 3270 | 32 |
972230 | 972230 | 2021-01-27 | Jefferson | West Virginia | 54037 | 3248 | 31 |
968985 | 968985 | 2021-01-26 | Jefferson | West Virginia | 54037 | 3223 | 31 |
965741 | 965741 | 2021-01-25 | Jefferson | West Virginia | 54037 | 3182 | 31 |
962496 | 962496 | 2021-01-24 | Jefferson | West Virginia | 54037 | 3170 | 31 |
959251 | 959251 | 2021-01-23 | Jefferson | West Virginia | 54037 | 3139 | 31 |
956005 | 956005 | 2021-01-22 | Jefferson | West Virginia | 54037 | 3112 | 31 |
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 |
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);