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 |
---|---|---|---|---|---|---|---|
1278974 | 1278974 | 2021-05-02 | DeSoto | Mississippi | 28033 | 21321 | 256 |
1275727 | 1275727 | 2021-05-01 | DeSoto | Mississippi | 28033 | 21321 | 256 |
1272480 | 1272480 | 2021-04-30 | DeSoto | Mississippi | 28033 | 21321 | 256 |
1269233 | 1269233 | 2021-04-29 | DeSoto | Mississippi | 28033 | 21289 | 256 |
1265986 | 1265986 | 2021-04-28 | DeSoto | Mississippi | 28033 | 21271 | 256 |
1262739 | 1262739 | 2021-04-27 | DeSoto | Mississippi | 28033 | 21238 | 255 |
1259492 | 1259492 | 2021-04-26 | DeSoto | Mississippi | 28033 | 21217 | 255 |
1256245 | 1256245 | 2021-04-25 | DeSoto | Mississippi | 28033 | 21158 | 254 |
1252998 | 1252998 | 2021-04-24 | DeSoto | Mississippi | 28033 | 21158 | 254 |
1249751 | 1249751 | 2021-04-23 | DeSoto | Mississippi | 28033 | 21158 | 254 |
1246504 | 1246504 | 2021-04-22 | DeSoto | Mississippi | 28033 | 21120 | 253 |
1243257 | 1243257 | 2021-04-21 | DeSoto | Mississippi | 28033 | 21074 | 251 |
1240010 | 1240010 | 2021-04-20 | DeSoto | Mississippi | 28033 | 21058 | 251 |
1236763 | 1236763 | 2021-04-19 | DeSoto | Mississippi | 28033 | 21005 | 250 |
1233516 | 1233516 | 2021-04-18 | DeSoto | Mississippi | 28033 | 20997 | 250 |
1230268 | 1230268 | 2021-04-17 | DeSoto | Mississippi | 28033 | 20983 | 250 |
1227020 | 1227020 | 2021-04-16 | DeSoto | Mississippi | 28033 | 20931 | 250 |
1223772 | 1223772 | 2021-04-15 | DeSoto | Mississippi | 28033 | 20901 | 250 |
1220525 | 1220525 | 2021-04-14 | DeSoto | Mississippi | 28033 | 20852 | 248 |
1217277 | 1217277 | 2021-04-13 | DeSoto | Mississippi | 28033 | 20826 | 248 |
1214030 | 1214030 | 2021-04-12 | DeSoto | Mississippi | 28033 | 20784 | 248 |
1210782 | 1210782 | 2021-04-11 | DeSoto | Mississippi | 28033 | 20772 | 248 |
1207533 | 1207533 | 2021-04-10 | DeSoto | Mississippi | 28033 | 20757 | 248 |
1204285 | 1204285 | 2021-04-09 | DeSoto | Mississippi | 28033 | 20729 | 248 |
1201037 | 1201037 | 2021-04-08 | DeSoto | Mississippi | 28033 | 20701 | 248 |
1197788 | 1197788 | 2021-04-07 | DeSoto | Mississippi | 28033 | 20668 | 248 |
1194539 | 1194539 | 2021-04-06 | DeSoto | Mississippi | 28033 | 20648 | 248 |
1191290 | 1191290 | 2021-04-05 | DeSoto | Mississippi | 28033 | 20638 | 248 |
1188042 | 1188042 | 2021-04-04 | DeSoto | Mississippi | 28033 | 20628 | 248 |
1184795 | 1184795 | 2021-04-03 | DeSoto | Mississippi | 28033 | 20617 | 248 |
1181549 | 1181549 | 2021-04-02 | DeSoto | Mississippi | 28033 | 20590 | 248 |
1178302 | 1178302 | 2021-04-01 | DeSoto | Mississippi | 28033 | 20555 | 248 |
1175055 | 1175055 | 2021-03-31 | DeSoto | Mississippi | 28033 | 20531 | 247 |
1171808 | 1171808 | 2021-03-30 | DeSoto | Mississippi | 28033 | 20490 | 246 |
1168560 | 1168560 | 2021-03-29 | DeSoto | Mississippi | 28033 | 20470 | 246 |
1165312 | 1165312 | 2021-03-28 | DeSoto | Mississippi | 28033 | 20462 | 246 |
1162064 | 1162064 | 2021-03-27 | DeSoto | Mississippi | 28033 | 20449 | 246 |
1158816 | 1158816 | 2021-03-26 | DeSoto | Mississippi | 28033 | 20426 | 246 |
1155569 | 1155569 | 2021-03-25 | DeSoto | Mississippi | 28033 | 20389 | 246 |
1152322 | 1152322 | 2021-03-24 | DeSoto | Mississippi | 28033 | 20349 | 245 |
1149075 | 1149075 | 2021-03-23 | DeSoto | Mississippi | 28033 | 20301 | 245 |
1145828 | 1145828 | 2021-03-22 | DeSoto | Mississippi | 28033 | 20245 | 245 |
1142581 | 1142581 | 2021-03-21 | DeSoto | Mississippi | 28033 | 20232 | 245 |
1139334 | 1139334 | 2021-03-20 | DeSoto | Mississippi | 28033 | 20219 | 245 |
1136088 | 1136088 | 2021-03-19 | DeSoto | Mississippi | 28033 | 20178 | 244 |
1132842 | 1132842 | 2021-03-18 | DeSoto | Mississippi | 28033 | 20156 | 244 |
1129594 | 1129594 | 2021-03-17 | DeSoto | Mississippi | 28033 | 20117 | 244 |
1126347 | 1126347 | 2021-03-16 | DeSoto | Mississippi | 28033 | 20089 | 242 |
1123101 | 1123101 | 2021-03-15 | DeSoto | Mississippi | 28033 | 20047 | 238 |
1119854 | 1119854 | 2021-03-14 | DeSoto | Mississippi | 28033 | 20039 | 238 |
1116607 | 1116607 | 2021-03-13 | DeSoto | Mississippi | 28033 | 20025 | 238 |
1113361 | 1113361 | 2021-03-12 | DeSoto | Mississippi | 28033 | 19991 | 238 |
1110115 | 1110115 | 2021-03-11 | DeSoto | Mississippi | 28033 | 19914 | 237 |
1106869 | 1106869 | 2021-03-10 | DeSoto | Mississippi | 28033 | 19868 | 233 |
1103623 | 1103623 | 2021-03-09 | DeSoto | Mississippi | 28033 | 19848 | 232 |
1100377 | 1100377 | 2021-03-08 | DeSoto | Mississippi | 28033 | 19831 | 231 |
1097130 | 1097130 | 2021-03-07 | DeSoto | Mississippi | 28033 | 19829 | 231 |
1093883 | 1093883 | 2021-03-06 | DeSoto | Mississippi | 28033 | 19814 | 231 |
1090637 | 1090637 | 2021-03-05 | DeSoto | Mississippi | 28033 | 19774 | 231 |
1087392 | 1087392 | 2021-03-04 | DeSoto | Mississippi | 28033 | 19731 | 230 |
1084147 | 1084147 | 2021-03-03 | DeSoto | Mississippi | 28033 | 19700 | 230 |
1080901 | 1080901 | 2021-03-02 | DeSoto | Mississippi | 28033 | 19690 | 230 |
1077655 | 1077655 | 2021-03-01 | DeSoto | Mississippi | 28033 | 19672 | 230 |
1074409 | 1074409 | 2021-02-28 | DeSoto | Mississippi | 28033 | 19660 | 230 |
1071163 | 1071163 | 2021-02-27 | DeSoto | Mississippi | 28033 | 19626 | 230 |
1067918 | 1067918 | 2021-02-26 | DeSoto | Mississippi | 28033 | 19601 | 229 |
1064673 | 1064673 | 2021-02-25 | DeSoto | Mississippi | 28033 | 19560 | 229 |
1061429 | 1061429 | 2021-02-24 | DeSoto | Mississippi | 28033 | 19515 | 228 |
1058183 | 1058183 | 2021-02-23 | DeSoto | Mississippi | 28033 | 19470 | 226 |
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 |
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);