ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 28089 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279002 | 1279002 | 2021-05-02 | Madison | Mississippi | 28089 | 10035 | 215 |
1275755 | 1275755 | 2021-05-01 | Madison | Mississippi | 28089 | 10035 | 215 |
1272508 | 1272508 | 2021-04-30 | Madison | Mississippi | 28089 | 10035 | 215 |
1269261 | 1269261 | 2021-04-29 | Madison | Mississippi | 28089 | 10024 | 215 |
1266014 | 1266014 | 2021-04-28 | Madison | Mississippi | 28089 | 10016 | 215 |
1262767 | 1262767 | 2021-04-27 | Madison | Mississippi | 28089 | 10010 | 215 |
1259520 | 1259520 | 2021-04-26 | Madison | Mississippi | 28089 | 10003 | 214 |
1256273 | 1256273 | 2021-04-25 | Madison | Mississippi | 28089 | 9990 | 214 |
1253026 | 1253026 | 2021-04-24 | Madison | Mississippi | 28089 | 9990 | 214 |
1249779 | 1249779 | 2021-04-23 | Madison | Mississippi | 28089 | 9990 | 214 |
1246532 | 1246532 | 2021-04-22 | Madison | Mississippi | 28089 | 9988 | 214 |
1243285 | 1243285 | 2021-04-21 | Madison | Mississippi | 28089 | 9981 | 213 |
1240038 | 1240038 | 2021-04-20 | Madison | Mississippi | 28089 | 9970 | 213 |
1236791 | 1236791 | 2021-04-19 | Madison | Mississippi | 28089 | 9965 | 212 |
1233544 | 1233544 | 2021-04-18 | Madison | Mississippi | 28089 | 9963 | 212 |
1230296 | 1230296 | 2021-04-17 | Madison | Mississippi | 28089 | 9957 | 212 |
1227048 | 1227048 | 2021-04-16 | Madison | Mississippi | 28089 | 9950 | 212 |
1223800 | 1223800 | 2021-04-15 | Madison | Mississippi | 28089 | 9949 | 211 |
1220553 | 1220553 | 2021-04-14 | Madison | Mississippi | 28089 | 9922 | 210 |
1217305 | 1217305 | 2021-04-13 | Madison | Mississippi | 28089 | 9908 | 210 |
1214058 | 1214058 | 2021-04-12 | Madison | Mississippi | 28089 | 9896 | 210 |
1210810 | 1210810 | 2021-04-11 | Madison | Mississippi | 28089 | 9895 | 210 |
1207561 | 1207561 | 2021-04-10 | Madison | Mississippi | 28089 | 9886 | 210 |
1204313 | 1204313 | 2021-04-09 | Madison | Mississippi | 28089 | 9876 | 210 |
1201065 | 1201065 | 2021-04-08 | Madison | Mississippi | 28089 | 9872 | 209 |
1197816 | 1197816 | 2021-04-07 | Madison | Mississippi | 28089 | 9864 | 209 |
1194567 | 1194567 | 2021-04-06 | Madison | Mississippi | 28089 | 9859 | 209 |
1191318 | 1191318 | 2021-04-05 | Madison | Mississippi | 28089 | 9856 | 209 |
1188070 | 1188070 | 2021-04-04 | Madison | Mississippi | 28089 | 9855 | 209 |
1184823 | 1184823 | 2021-04-03 | Madison | Mississippi | 28089 | 9848 | 209 |
1181577 | 1181577 | 2021-04-02 | Madison | Mississippi | 28089 | 9831 | 208 |
1178330 | 1178330 | 2021-04-01 | Madison | Mississippi | 28089 | 9826 | 208 |
1175083 | 1175083 | 2021-03-31 | Madison | Mississippi | 28089 | 9816 | 208 |
1171836 | 1171836 | 2021-03-30 | Madison | Mississippi | 28089 | 9805 | 208 |
1168588 | 1168588 | 2021-03-29 | Madison | Mississippi | 28089 | 9803 | 207 |
1165340 | 1165340 | 2021-03-28 | Madison | Mississippi | 28089 | 9799 | 207 |
1162092 | 1162092 | 2021-03-27 | Madison | Mississippi | 28089 | 9788 | 207 |
1158844 | 1158844 | 2021-03-26 | Madison | Mississippi | 28089 | 9782 | 207 |
1155597 | 1155597 | 2021-03-25 | Madison | Mississippi | 28089 | 9775 | 207 |
1152350 | 1152350 | 2021-03-24 | Madison | Mississippi | 28089 | 9757 | 207 |
1149103 | 1149103 | 2021-03-23 | Madison | Mississippi | 28089 | 9741 | 206 |
1145856 | 1145856 | 2021-03-22 | Madison | Mississippi | 28089 | 9720 | 206 |
1142609 | 1142609 | 2021-03-21 | Madison | Mississippi | 28089 | 9720 | 206 |
1139362 | 1139362 | 2021-03-20 | Madison | Mississippi | 28089 | 9710 | 206 |
1136116 | 1136116 | 2021-03-19 | Madison | Mississippi | 28089 | 9700 | 206 |
1132870 | 1132870 | 2021-03-18 | Madison | Mississippi | 28089 | 9691 | 206 |
1129622 | 1129622 | 2021-03-17 | Madison | Mississippi | 28089 | 9681 | 206 |
1126375 | 1126375 | 2021-03-16 | Madison | Mississippi | 28089 | 9666 | 206 |
1123129 | 1123129 | 2021-03-15 | Madison | Mississippi | 28089 | 9663 | 206 |
1119882 | 1119882 | 2021-03-14 | Madison | Mississippi | 28089 | 9663 | 206 |
1116635 | 1116635 | 2021-03-13 | Madison | Mississippi | 28089 | 9661 | 206 |
1113389 | 1113389 | 2021-03-12 | Madison | Mississippi | 28089 | 9640 | 206 |
1110143 | 1110143 | 2021-03-11 | Madison | Mississippi | 28089 | 9615 | 206 |
1106897 | 1106897 | 2021-03-10 | Madison | Mississippi | 28089 | 9569 | 204 |
1103651 | 1103651 | 2021-03-09 | Madison | Mississippi | 28089 | 9533 | 204 |
1100405 | 1100405 | 2021-03-08 | Madison | Mississippi | 28089 | 9525 | 204 |
1097158 | 1097158 | 2021-03-07 | Madison | Mississippi | 28089 | 9522 | 204 |
1093911 | 1093911 | 2021-03-06 | Madison | Mississippi | 28089 | 9516 | 204 |
1090665 | 1090665 | 2021-03-05 | Madison | Mississippi | 28089 | 9499 | 204 |
1087420 | 1087420 | 2021-03-04 | Madison | Mississippi | 28089 | 9484 | 203 |
1084175 | 1084175 | 2021-03-03 | Madison | Mississippi | 28089 | 9480 | 203 |
1080929 | 1080929 | 2021-03-02 | Madison | Mississippi | 28089 | 9466 | 203 |
1077683 | 1077683 | 2021-03-01 | Madison | Mississippi | 28089 | 9457 | 199 |
1074437 | 1074437 | 2021-02-28 | Madison | Mississippi | 28089 | 9448 | 199 |
1071191 | 1071191 | 2021-02-27 | Madison | Mississippi | 28089 | 9432 | 199 |
1067946 | 1067946 | 2021-02-26 | Madison | Mississippi | 28089 | 9420 | 196 |
1064701 | 1064701 | 2021-02-25 | Madison | Mississippi | 28089 | 9400 | 195 |
1061457 | 1061457 | 2021-02-24 | Madison | Mississippi | 28089 | 9378 | 194 |
1058211 | 1058211 | 2021-02-23 | Madison | Mississippi | 28089 | 9353 | 193 |
1054965 | 1054965 | 2021-02-22 | Madison | Mississippi | 28089 | 9343 | 190 |
1051718 | 1051718 | 2021-02-21 | Madison | Mississippi | 28089 | 9340 | 190 |
1048471 | 1048471 | 2021-02-20 | Madison | Mississippi | 28089 | 9336 | 190 |
1045225 | 1045225 | 2021-02-19 | Madison | Mississippi | 28089 | 9333 | 189 |
1041980 | 1041980 | 2021-02-18 | Madison | Mississippi | 28089 | 9327 | 189 |
1038735 | 1038735 | 2021-02-17 | Madison | Mississippi | 28089 | 9324 | 189 |
1035490 | 1035490 | 2021-02-16 | Madison | Mississippi | 28089 | 9318 | 189 |
1032245 | 1032245 | 2021-02-15 | Madison | Mississippi | 28089 | 9307 | 189 |
1028998 | 1028998 | 2021-02-14 | Madison | Mississippi | 28089 | 9295 | 189 |
1025752 | 1025752 | 2021-02-13 | Madison | Mississippi | 28089 | 9262 | 189 |
1022507 | 1022507 | 2021-02-12 | Madison | Mississippi | 28089 | 9242 | 189 |
1019262 | 1019262 | 2021-02-11 | Madison | Mississippi | 28089 | 9227 | 189 |
1016017 | 1016017 | 2021-02-10 | Madison | Mississippi | 28089 | 9204 | 188 |
1012772 | 1012772 | 2021-02-09 | Madison | Mississippi | 28089 | 9180 | 188 |
1009527 | 1009527 | 2021-02-08 | Madison | Mississippi | 28089 | 9162 | 186 |
1006280 | 1006280 | 2021-02-07 | Madison | Mississippi | 28089 | 9147 | 186 |
1003034 | 1003034 | 2021-02-06 | Madison | Mississippi | 28089 | 9112 | 186 |
999789 | 999789 | 2021-02-05 | Madison | Mississippi | 28089 | 9075 | 185 |
996543 | 996543 | 2021-02-04 | Madison | Mississippi | 28089 | 9042 | 183 |
993297 | 993297 | 2021-02-03 | Madison | Mississippi | 28089 | 9009 | 182 |
990051 | 990051 | 2021-02-02 | Madison | Mississippi | 28089 | 8988 | 178 |
986804 | 986804 | 2021-02-01 | Madison | Mississippi | 28089 | 8941 | 176 |
983557 | 983557 | 2021-01-31 | Madison | Mississippi | 28089 | 8922 | 176 |
980311 | 980311 | 2021-01-30 | Madison | Mississippi | 28089 | 8893 | 175 |
977065 | 977065 | 2021-01-29 | Madison | Mississippi | 28089 | 8856 | 173 |
973820 | 973820 | 2021-01-28 | Madison | Mississippi | 28089 | 8785 | 173 |
970575 | 970575 | 2021-01-27 | Madison | Mississippi | 28089 | 8736 | 173 |
967330 | 967330 | 2021-01-26 | Madison | Mississippi | 28089 | 8663 | 171 |
964086 | 964086 | 2021-01-25 | Madison | Mississippi | 28089 | 8619 | 169 |
960841 | 960841 | 2021-01-24 | Madison | Mississippi | 28089 | 8599 | 169 |
957595 | 957595 | 2021-01-23 | Madison | Mississippi | 28089 | 8568 | 168 |
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);