ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "DeSoto" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054937 | 1054937 | 2021-02-22 | DeSoto | Mississippi | 28033 | 19441 | 226 |
1051690 | 1051690 | 2021-02-21 | DeSoto | Mississippi | 28033 | 19415 | 226 |
1048443 | 1048443 | 2021-02-20 | DeSoto | Mississippi | 28033 | 19389 | 226 |
1045197 | 1045197 | 2021-02-19 | DeSoto | Mississippi | 28033 | 19351 | 226 |
1041952 | 1041952 | 2021-02-18 | DeSoto | Mississippi | 28033 | 19341 | 226 |
1038707 | 1038707 | 2021-02-17 | DeSoto | Mississippi | 28033 | 19331 | 226 |
1035462 | 1035462 | 2021-02-16 | DeSoto | Mississippi | 28033 | 19273 | 226 |
1032217 | 1032217 | 2021-02-15 | DeSoto | Mississippi | 28033 | 19234 | 226 |
1028970 | 1028970 | 2021-02-14 | DeSoto | Mississippi | 28033 | 19176 | 226 |
1025724 | 1025724 | 2021-02-13 | DeSoto | Mississippi | 28033 | 19082 | 226 |
1022479 | 1022479 | 2021-02-12 | DeSoto | Mississippi | 28033 | 19045 | 222 |
1019234 | 1019234 | 2021-02-11 | DeSoto | Mississippi | 28033 | 18991 | 221 |
1015989 | 1015989 | 2021-02-10 | DeSoto | Mississippi | 28033 | 18904 | 220 |
1012744 | 1012744 | 2021-02-09 | DeSoto | Mississippi | 28033 | 18881 | 220 |
1009499 | 1009499 | 2021-02-08 | DeSoto | Mississippi | 28033 | 18838 | 217 |
1006252 | 1006252 | 2021-02-07 | DeSoto | Mississippi | 28033 | 18783 | 217 |
1003006 | 1003006 | 2021-02-06 | DeSoto | Mississippi | 28033 | 18726 | 217 |
999761 | 999761 | 2021-02-05 | DeSoto | Mississippi | 28033 | 18648 | 214 |
996515 | 996515 | 2021-02-04 | DeSoto | Mississippi | 28033 | 18569 | 212 |
993269 | 993269 | 2021-02-03 | DeSoto | Mississippi | 28033 | 18490 | 210 |
990023 | 990023 | 2021-02-02 | DeSoto | Mississippi | 28033 | 18450 | 209 |
986776 | 986776 | 2021-02-01 | DeSoto | Mississippi | 28033 | 18408 | 202 |
983529 | 983529 | 2021-01-31 | DeSoto | Mississippi | 28033 | 18370 | 201 |
980283 | 980283 | 2021-01-30 | DeSoto | Mississippi | 28033 | 18323 | 200 |
977037 | 977037 | 2021-01-29 | DeSoto | Mississippi | 28033 | 18239 | 199 |
973792 | 973792 | 2021-01-28 | DeSoto | Mississippi | 28033 | 18119 | 199 |
970547 | 970547 | 2021-01-27 | DeSoto | Mississippi | 28033 | 18020 | 198 |
967302 | 967302 | 2021-01-26 | DeSoto | Mississippi | 28033 | 17928 | 195 |
964058 | 964058 | 2021-01-25 | DeSoto | Mississippi | 28033 | 17807 | 191 |
960813 | 960813 | 2021-01-24 | DeSoto | Mississippi | 28033 | 17741 | 191 |
957567 | 957567 | 2021-01-23 | DeSoto | Mississippi | 28033 | 17675 | 191 |
954322 | 954322 | 2021-01-22 | DeSoto | Mississippi | 28033 | 17561 | 191 |
951077 | 951077 | 2021-01-21 | DeSoto | Mississippi | 28033 | 17436 | 187 |
947831 | 947831 | 2021-01-20 | DeSoto | Mississippi | 28033 | 17331 | 186 |
944584 | 944584 | 2021-01-19 | DeSoto | Mississippi | 28033 | 17257 | 180 |
941339 | 941339 | 2021-01-18 | DeSoto | Mississippi | 28033 | 17197 | 175 |
938094 | 938094 | 2021-01-17 | DeSoto | Mississippi | 28033 | 17120 | 175 |
934849 | 934849 | 2021-01-16 | DeSoto | Mississippi | 28033 | 17010 | 171 |
931604 | 931604 | 2021-01-15 | DeSoto | Mississippi | 28033 | 16841 | 171 |
928359 | 928359 | 2021-01-14 | DeSoto | Mississippi | 28033 | 16717 | 168 |
925113 | 925113 | 2021-01-13 | DeSoto | Mississippi | 28033 | 16627 | 164 |
921868 | 921868 | 2021-01-12 | DeSoto | Mississippi | 28033 | 16475 | 161 |
918623 | 918623 | 2021-01-11 | DeSoto | Mississippi | 28033 | 16358 | 155 |
915378 | 915378 | 2021-01-10 | DeSoto | Mississippi | 28033 | 16277 | 154 |
912133 | 912133 | 2021-01-09 | DeSoto | Mississippi | 28033 | 16090 | 152 |
908888 | 908888 | 2021-01-08 | DeSoto | Mississippi | 28033 | 15910 | 151 |
905642 | 905642 | 2021-01-07 | DeSoto | Mississippi | 28033 | 15775 | 149 |
902397 | 902397 | 2021-01-06 | DeSoto | Mississippi | 28033 | 15586 | 148 |
899152 | 899152 | 2021-01-05 | DeSoto | Mississippi | 28033 | 15363 | 145 |
895907 | 895907 | 2021-01-04 | DeSoto | Mississippi | 28033 | 15263 | 141 |
892660 | 892660 | 2021-01-03 | DeSoto | Mississippi | 28033 | 15142 | 141 |
889414 | 889414 | 2021-01-02 | DeSoto | Mississippi | 28033 | 15023 | 139 |
886168 | 886168 | 2021-01-01 | DeSoto | Mississippi | 28033 | 14885 | 139 |
882923 | 882923 | 2020-12-31 | DeSoto | Mississippi | 28033 | 14714 | 139 |
879678 | 879678 | 2020-12-30 | DeSoto | Mississippi | 28033 | 14512 | 137 |
876433 | 876433 | 2020-12-29 | DeSoto | Mississippi | 28033 | 14287 | 135 |
873188 | 873188 | 2020-12-28 | DeSoto | Mississippi | 28033 | 14149 | 135 |
869943 | 869943 | 2020-12-27 | DeSoto | Mississippi | 28033 | 14005 | 133 |
866698 | 866698 | 2020-12-26 | DeSoto | Mississippi | 28033 | 13932 | 132 |
863453 | 863453 | 2020-12-25 | DeSoto | Mississippi | 28033 | 13822 | 131 |
860208 | 860208 | 2020-12-24 | DeSoto | Mississippi | 28033 | 13674 | 129 |
856963 | 856963 | 2020-12-23 | DeSoto | Mississippi | 28033 | 13485 | 128 |
853718 | 853718 | 2020-12-22 | DeSoto | Mississippi | 28033 | 13307 | 128 |
850473 | 850473 | 2020-12-21 | DeSoto | Mississippi | 28033 | 13165 | 128 |
847228 | 847228 | 2020-12-20 | DeSoto | Mississippi | 28033 | 13081 | 128 |
843982 | 843982 | 2020-12-19 | DeSoto | Mississippi | 28033 | 12853 | 127 |
840737 | 840737 | 2020-12-18 | DeSoto | Mississippi | 28033 | 12746 | 121 |
837492 | 837492 | 2020-12-17 | DeSoto | Mississippi | 28033 | 12561 | 117 |
834246 | 834246 | 2020-12-16 | DeSoto | Mississippi | 28033 | 12433 | 116 |
830999 | 830999 | 2020-12-15 | DeSoto | Mississippi | 28033 | 12217 | 115 |
827753 | 827753 | 2020-12-14 | DeSoto | Mississippi | 28033 | 12089 | 114 |
824506 | 824506 | 2020-12-13 | DeSoto | Mississippi | 28033 | 11976 | 114 |
821260 | 821260 | 2020-12-12 | DeSoto | Mississippi | 28033 | 11868 | 114 |
818014 | 818014 | 2020-12-11 | DeSoto | Mississippi | 28033 | 11694 | 111 |
814768 | 814768 | 2020-12-10 | DeSoto | Mississippi | 28033 | 11503 | 110 |
811523 | 811523 | 2020-12-09 | DeSoto | Mississippi | 28033 | 11375 | 110 |
808278 | 808278 | 2020-12-08 | DeSoto | Mississippi | 28033 | 11203 | 110 |
805033 | 805033 | 2020-12-07 | DeSoto | Mississippi | 28033 | 11132 | 106 |
801788 | 801788 | 2020-12-06 | DeSoto | Mississippi | 28033 | 11051 | 106 |
798543 | 798543 | 2020-12-05 | DeSoto | Mississippi | 28033 | 10942 | 106 |
795298 | 795298 | 2020-12-04 | DeSoto | Mississippi | 28033 | 10863 | 104 |
792053 | 792053 | 2020-12-03 | DeSoto | Mississippi | 28033 | 10708 | 104 |
788808 | 788808 | 2020-12-02 | DeSoto | Mississippi | 28033 | 10563 | 104 |
785563 | 785563 | 2020-12-01 | DeSoto | Mississippi | 28033 | 10409 | 104 |
782319 | 782319 | 2020-11-30 | DeSoto | Mississippi | 28033 | 10332 | 104 |
779073 | 779073 | 2020-11-29 | DeSoto | Mississippi | 28033 | 10249 | 104 |
775828 | 775828 | 2020-11-28 | DeSoto | Mississippi | 28033 | 10097 | 104 |
772583 | 772583 | 2020-11-27 | DeSoto | Mississippi | 28033 | 9953 | 104 |
769338 | 769338 | 2020-11-26 | DeSoto | Mississippi | 28033 | 9874 | 101 |
766092 | 766092 | 2020-11-25 | DeSoto | Mississippi | 28033 | 9731 | 99 |
762847 | 762847 | 2020-11-24 | DeSoto | Mississippi | 28033 | 9632 | 99 |
759602 | 759602 | 2020-11-23 | DeSoto | Mississippi | 28033 | 9569 | 99 |
756355 | 756355 | 2020-11-22 | DeSoto | Mississippi | 28033 | 9527 | 99 |
753109 | 753109 | 2020-11-21 | DeSoto | Mississippi | 28033 | 9467 | 97 |
749863 | 749863 | 2020-11-20 | DeSoto | Mississippi | 28033 | 9358 | 97 |
746617 | 746617 | 2020-11-19 | DeSoto | Mississippi | 28033 | 9232 | 93 |
743370 | 743370 | 2020-11-18 | DeSoto | Mississippi | 28033 | 9117 | 92 |
740123 | 740123 | 2020-11-17 | DeSoto | Mississippi | 28033 | 8985 | 91 |
736879 | 736879 | 2020-11-16 | DeSoto | Mississippi | 28033 | 8912 | 87 |
733633 | 733633 | 2020-11-15 | DeSoto | Mississippi | 28033 | 8857 | 87 |
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);