ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walthall" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054994 | 1054994 | 2021-02-22 | Walthall | Mississippi | 28147 | 1230 | 40 |
1051747 | 1051747 | 2021-02-21 | Walthall | Mississippi | 28147 | 1230 | 40 |
1048500 | 1048500 | 2021-02-20 | Walthall | Mississippi | 28147 | 1230 | 40 |
1045254 | 1045254 | 2021-02-19 | Walthall | Mississippi | 28147 | 1230 | 40 |
1042009 | 1042009 | 2021-02-18 | Walthall | Mississippi | 28147 | 1228 | 40 |
1038764 | 1038764 | 2021-02-17 | Walthall | Mississippi | 28147 | 1228 | 40 |
1035519 | 1035519 | 2021-02-16 | Walthall | Mississippi | 28147 | 1227 | 39 |
1032274 | 1032274 | 2021-02-15 | Walthall | Mississippi | 28147 | 1227 | 39 |
1029027 | 1029027 | 2021-02-14 | Walthall | Mississippi | 28147 | 1227 | 39 |
1025781 | 1025781 | 2021-02-13 | Walthall | Mississippi | 28147 | 1226 | 39 |
1022536 | 1022536 | 2021-02-12 | Walthall | Mississippi | 28147 | 1222 | 39 |
1019291 | 1019291 | 2021-02-11 | Walthall | Mississippi | 28147 | 1216 | 39 |
1016046 | 1016046 | 2021-02-10 | Walthall | Mississippi | 28147 | 1213 | 39 |
1012801 | 1012801 | 2021-02-09 | Walthall | Mississippi | 28147 | 1210 | 39 |
1009556 | 1009556 | 2021-02-08 | Walthall | Mississippi | 28147 | 1209 | 39 |
1006309 | 1006309 | 2021-02-07 | Walthall | Mississippi | 28147 | 1205 | 39 |
1003063 | 1003063 | 2021-02-06 | Walthall | Mississippi | 28147 | 1204 | 39 |
999818 | 999818 | 2021-02-05 | Walthall | Mississippi | 28147 | 1203 | 39 |
996572 | 996572 | 2021-02-04 | Walthall | Mississippi | 28147 | 1194 | 38 |
993326 | 993326 | 2021-02-03 | Walthall | Mississippi | 28147 | 1194 | 38 |
990080 | 990080 | 2021-02-02 | Walthall | Mississippi | 28147 | 1190 | 38 |
986833 | 986833 | 2021-02-01 | Walthall | Mississippi | 28147 | 1187 | 38 |
983586 | 983586 | 2021-01-31 | Walthall | Mississippi | 28147 | 1186 | 38 |
980340 | 980340 | 2021-01-30 | Walthall | Mississippi | 28147 | 1185 | 38 |
977094 | 977094 | 2021-01-29 | Walthall | Mississippi | 28147 | 1181 | 38 |
973849 | 973849 | 2021-01-28 | Walthall | Mississippi | 28147 | 1175 | 38 |
970604 | 970604 | 2021-01-27 | Walthall | Mississippi | 28147 | 1166 | 38 |
967359 | 967359 | 2021-01-26 | Walthall | Mississippi | 28147 | 1154 | 38 |
964115 | 964115 | 2021-01-25 | Walthall | Mississippi | 28147 | 1150 | 37 |
960870 | 960870 | 2021-01-24 | Walthall | Mississippi | 28147 | 1145 | 37 |
957624 | 957624 | 2021-01-23 | Walthall | Mississippi | 28147 | 1143 | 37 |
954379 | 954379 | 2021-01-22 | Walthall | Mississippi | 28147 | 1140 | 37 |
951134 | 951134 | 2021-01-21 | Walthall | Mississippi | 28147 | 1134 | 37 |
947888 | 947888 | 2021-01-20 | Walthall | Mississippi | 28147 | 1128 | 36 |
944641 | 944641 | 2021-01-19 | Walthall | Mississippi | 28147 | 1123 | 36 |
941396 | 941396 | 2021-01-18 | Walthall | Mississippi | 28147 | 1123 | 36 |
938151 | 938151 | 2021-01-17 | Walthall | Mississippi | 28147 | 1118 | 36 |
934906 | 934906 | 2021-01-16 | Walthall | Mississippi | 28147 | 1117 | 36 |
931661 | 931661 | 2021-01-15 | Walthall | Mississippi | 28147 | 1111 | 36 |
928416 | 928416 | 2021-01-14 | Walthall | Mississippi | 28147 | 1105 | 36 |
925170 | 925170 | 2021-01-13 | Walthall | Mississippi | 28147 | 1096 | 36 |
921925 | 921925 | 2021-01-12 | Walthall | Mississippi | 28147 | 1085 | 36 |
918680 | 918680 | 2021-01-11 | Walthall | Mississippi | 28147 | 1082 | 36 |
915435 | 915435 | 2021-01-10 | Walthall | Mississippi | 28147 | 1079 | 36 |
912190 | 912190 | 2021-01-09 | Walthall | Mississippi | 28147 | 1073 | 36 |
908945 | 908945 | 2021-01-08 | Walthall | Mississippi | 28147 | 1066 | 36 |
905699 | 905699 | 2021-01-07 | Walthall | Mississippi | 28147 | 1054 | 36 |
902454 | 902454 | 2021-01-06 | Walthall | Mississippi | 28147 | 1046 | 35 |
899209 | 899209 | 2021-01-05 | Walthall | Mississippi | 28147 | 1029 | 35 |
895964 | 895964 | 2021-01-04 | Walthall | Mississippi | 28147 | 1026 | 34 |
892717 | 892717 | 2021-01-03 | Walthall | Mississippi | 28147 | 1023 | 34 |
889471 | 889471 | 2021-01-02 | Walthall | Mississippi | 28147 | 1017 | 34 |
886225 | 886225 | 2021-01-01 | Walthall | Mississippi | 28147 | 1012 | 34 |
882980 | 882980 | 2020-12-31 | Walthall | Mississippi | 28147 | 1002 | 34 |
879735 | 879735 | 2020-12-30 | Walthall | Mississippi | 28147 | 984 | 34 |
876490 | 876490 | 2020-12-29 | Walthall | Mississippi | 28147 | 972 | 34 |
873245 | 873245 | 2020-12-28 | Walthall | Mississippi | 28147 | 966 | 34 |
870000 | 870000 | 2020-12-27 | Walthall | Mississippi | 28147 | 960 | 34 |
866755 | 866755 | 2020-12-26 | Walthall | Mississippi | 28147 | 951 | 33 |
863510 | 863510 | 2020-12-25 | Walthall | Mississippi | 28147 | 950 | 33 |
860265 | 860265 | 2020-12-24 | Walthall | Mississippi | 28147 | 942 | 33 |
857020 | 857020 | 2020-12-23 | Walthall | Mississippi | 28147 | 932 | 33 |
853775 | 853775 | 2020-12-22 | Walthall | Mississippi | 28147 | 925 | 32 |
850530 | 850530 | 2020-12-21 | Walthall | Mississippi | 28147 | 919 | 32 |
847285 | 847285 | 2020-12-20 | Walthall | Mississippi | 28147 | 916 | 32 |
844039 | 844039 | 2020-12-19 | Walthall | Mississippi | 28147 | 909 | 32 |
840794 | 840794 | 2020-12-18 | Walthall | Mississippi | 28147 | 904 | 32 |
837549 | 837549 | 2020-12-17 | Walthall | Mississippi | 28147 | 890 | 32 |
834303 | 834303 | 2020-12-16 | Walthall | Mississippi | 28147 | 886 | 32 |
831056 | 831056 | 2020-12-15 | Walthall | Mississippi | 28147 | 883 | 32 |
827810 | 827810 | 2020-12-14 | Walthall | Mississippi | 28147 | 877 | 32 |
824563 | 824563 | 2020-12-13 | Walthall | Mississippi | 28147 | 871 | 32 |
821317 | 821317 | 2020-12-12 | Walthall | Mississippi | 28147 | 863 | 32 |
818071 | 818071 | 2020-12-11 | Walthall | Mississippi | 28147 | 856 | 32 |
814825 | 814825 | 2020-12-10 | Walthall | Mississippi | 28147 | 850 | 32 |
811580 | 811580 | 2020-12-09 | Walthall | Mississippi | 28147 | 841 | 31 |
808335 | 808335 | 2020-12-08 | Walthall | Mississippi | 28147 | 831 | 31 |
805090 | 805090 | 2020-12-07 | Walthall | Mississippi | 28147 | 826 | 30 |
801845 | 801845 | 2020-12-06 | Walthall | Mississippi | 28147 | 821 | 30 |
798600 | 798600 | 2020-12-05 | Walthall | Mississippi | 28147 | 812 | 30 |
795355 | 795355 | 2020-12-04 | Walthall | Mississippi | 28147 | 804 | 30 |
792110 | 792110 | 2020-12-03 | Walthall | Mississippi | 28147 | 799 | 30 |
788865 | 788865 | 2020-12-02 | Walthall | Mississippi | 28147 | 793 | 30 |
785620 | 785620 | 2020-12-01 | Walthall | Mississippi | 28147 | 776 | 29 |
782376 | 782376 | 2020-11-30 | Walthall | Mississippi | 28147 | 772 | 29 |
779130 | 779130 | 2020-11-29 | Walthall | Mississippi | 28147 | 769 | 29 |
775885 | 775885 | 2020-11-28 | Walthall | Mississippi | 28147 | 769 | 28 |
772640 | 772640 | 2020-11-27 | Walthall | Mississippi | 28147 | 763 | 28 |
769395 | 769395 | 2020-11-26 | Walthall | Mississippi | 28147 | 760 | 28 |
766149 | 766149 | 2020-11-25 | Walthall | Mississippi | 28147 | 753 | 28 |
762904 | 762904 | 2020-11-24 | Walthall | Mississippi | 28147 | 750 | 28 |
759659 | 759659 | 2020-11-23 | Walthall | Mississippi | 28147 | 743 | 28 |
756412 | 756412 | 2020-11-22 | Walthall | Mississippi | 28147 | 737 | 28 |
753166 | 753166 | 2020-11-21 | Walthall | Mississippi | 28147 | 735 | 28 |
749920 | 749920 | 2020-11-20 | Walthall | Mississippi | 28147 | 732 | 27 |
746674 | 746674 | 2020-11-19 | Walthall | Mississippi | 28147 | 728 | 27 |
743427 | 743427 | 2020-11-18 | Walthall | Mississippi | 28147 | 725 | 27 |
740180 | 740180 | 2020-11-17 | Walthall | Mississippi | 28147 | 719 | 27 |
736936 | 736936 | 2020-11-16 | Walthall | Mississippi | 28147 | 713 | 27 |
733690 | 733690 | 2020-11-15 | Walthall | Mississippi | 28147 | 712 | 27 |
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);