ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28067 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278991 | 1278991 | 2021-05-02 | Jones | Mississippi | 28067 | 8354 | 163 |
1275744 | 1275744 | 2021-05-01 | Jones | Mississippi | 28067 | 8354 | 163 |
1272497 | 1272497 | 2021-04-30 | Jones | Mississippi | 28067 | 8354 | 163 |
1269250 | 1269250 | 2021-04-29 | Jones | Mississippi | 28067 | 8350 | 163 |
1266003 | 1266003 | 2021-04-28 | Jones | Mississippi | 28067 | 8348 | 163 |
1262756 | 1262756 | 2021-04-27 | Jones | Mississippi | 28067 | 8345 | 163 |
1259509 | 1259509 | 2021-04-26 | Jones | Mississippi | 28067 | 8342 | 161 |
1256262 | 1256262 | 2021-04-25 | Jones | Mississippi | 28067 | 8331 | 161 |
1253015 | 1253015 | 2021-04-24 | Jones | Mississippi | 28067 | 8331 | 161 |
1249768 | 1249768 | 2021-04-23 | Jones | Mississippi | 28067 | 8331 | 161 |
1246521 | 1246521 | 2021-04-22 | Jones | Mississippi | 28067 | 8327 | 161 |
1243274 | 1243274 | 2021-04-21 | Jones | Mississippi | 28067 | 8324 | 161 |
1240027 | 1240027 | 2021-04-20 | Jones | Mississippi | 28067 | 8324 | 161 |
1236780 | 1236780 | 2021-04-19 | Jones | Mississippi | 28067 | 8319 | 161 |
1233533 | 1233533 | 2021-04-18 | Jones | Mississippi | 28067 | 8318 | 161 |
1230285 | 1230285 | 2021-04-17 | Jones | Mississippi | 28067 | 8314 | 161 |
1227037 | 1227037 | 2021-04-16 | Jones | Mississippi | 28067 | 8310 | 161 |
1223789 | 1223789 | 2021-04-15 | Jones | Mississippi | 28067 | 8308 | 161 |
1220542 | 1220542 | 2021-04-14 | Jones | Mississippi | 28067 | 8299 | 160 |
1217294 | 1217294 | 2021-04-13 | Jones | Mississippi | 28067 | 8297 | 160 |
1214047 | 1214047 | 2021-04-12 | Jones | Mississippi | 28067 | 8293 | 160 |
1210799 | 1210799 | 2021-04-11 | Jones | Mississippi | 28067 | 8290 | 160 |
1207550 | 1207550 | 2021-04-10 | Jones | Mississippi | 28067 | 8289 | 160 |
1204302 | 1204302 | 2021-04-09 | Jones | Mississippi | 28067 | 8288 | 160 |
1201054 | 1201054 | 2021-04-08 | Jones | Mississippi | 28067 | 8285 | 160 |
1197805 | 1197805 | 2021-04-07 | Jones | Mississippi | 28067 | 8282 | 160 |
1194556 | 1194556 | 2021-04-06 | Jones | Mississippi | 28067 | 8272 | 160 |
1191307 | 1191307 | 2021-04-05 | Jones | Mississippi | 28067 | 8269 | 159 |
1188059 | 1188059 | 2021-04-04 | Jones | Mississippi | 28067 | 8267 | 159 |
1184812 | 1184812 | 2021-04-03 | Jones | Mississippi | 28067 | 8266 | 159 |
1181566 | 1181566 | 2021-04-02 | Jones | Mississippi | 28067 | 8253 | 159 |
1178319 | 1178319 | 2021-04-01 | Jones | Mississippi | 28067 | 8250 | 159 |
1175072 | 1175072 | 2021-03-31 | Jones | Mississippi | 28067 | 8247 | 158 |
1171825 | 1171825 | 2021-03-30 | Jones | Mississippi | 28067 | 8243 | 157 |
1168577 | 1168577 | 2021-03-29 | Jones | Mississippi | 28067 | 8244 | 156 |
1165329 | 1165329 | 2021-03-28 | Jones | Mississippi | 28067 | 8240 | 156 |
1162081 | 1162081 | 2021-03-27 | Jones | Mississippi | 28067 | 8237 | 156 |
1158833 | 1158833 | 2021-03-26 | Jones | Mississippi | 28067 | 8233 | 156 |
1155586 | 1155586 | 2021-03-25 | Jones | Mississippi | 28067 | 8226 | 154 |
1152339 | 1152339 | 2021-03-24 | Jones | Mississippi | 28067 | 8214 | 154 |
1149092 | 1149092 | 2021-03-23 | Jones | Mississippi | 28067 | 8205 | 154 |
1145845 | 1145845 | 2021-03-22 | Jones | Mississippi | 28067 | 8201 | 154 |
1142598 | 1142598 | 2021-03-21 | Jones | Mississippi | 28067 | 8196 | 154 |
1139351 | 1139351 | 2021-03-20 | Jones | Mississippi | 28067 | 8191 | 154 |
1136105 | 1136105 | 2021-03-19 | Jones | Mississippi | 28067 | 8186 | 153 |
1132859 | 1132859 | 2021-03-18 | Jones | Mississippi | 28067 | 8179 | 153 |
1129611 | 1129611 | 2021-03-17 | Jones | Mississippi | 28067 | 8176 | 153 |
1126364 | 1126364 | 2021-03-16 | Jones | Mississippi | 28067 | 8164 | 153 |
1123118 | 1123118 | 2021-03-15 | Jones | Mississippi | 28067 | 8144 | 152 |
1119871 | 1119871 | 2021-03-14 | Jones | Mississippi | 28067 | 8144 | 152 |
1116624 | 1116624 | 2021-03-13 | Jones | Mississippi | 28067 | 8138 | 152 |
1113378 | 1113378 | 2021-03-12 | Jones | Mississippi | 28067 | 8127 | 152 |
1110132 | 1110132 | 2021-03-11 | Jones | Mississippi | 28067 | 8096 | 150 |
1106886 | 1106886 | 2021-03-10 | Jones | Mississippi | 28067 | 8066 | 149 |
1103640 | 1103640 | 2021-03-09 | Jones | Mississippi | 28067 | 8052 | 149 |
1100394 | 1100394 | 2021-03-08 | Jones | Mississippi | 28067 | 8045 | 148 |
1097147 | 1097147 | 2021-03-07 | Jones | Mississippi | 28067 | 8042 | 148 |
1093900 | 1093900 | 2021-03-06 | Jones | Mississippi | 28067 | 8035 | 148 |
1090654 | 1090654 | 2021-03-05 | Jones | Mississippi | 28067 | 8017 | 148 |
1087409 | 1087409 | 2021-03-04 | Jones | Mississippi | 28067 | 8005 | 147 |
1084164 | 1084164 | 2021-03-03 | Jones | Mississippi | 28067 | 7990 | 147 |
1080918 | 1080918 | 2021-03-02 | Jones | Mississippi | 28067 | 7978 | 147 |
1077672 | 1077672 | 2021-03-01 | Jones | Mississippi | 28067 | 7962 | 146 |
1074426 | 1074426 | 2021-02-28 | Jones | Mississippi | 28067 | 7945 | 146 |
1071180 | 1071180 | 2021-02-27 | Jones | Mississippi | 28067 | 7928 | 146 |
1067935 | 1067935 | 2021-02-26 | Jones | Mississippi | 28067 | 7914 | 146 |
1064690 | 1064690 | 2021-02-25 | Jones | Mississippi | 28067 | 7891 | 145 |
1061446 | 1061446 | 2021-02-24 | Jones | Mississippi | 28067 | 7857 | 145 |
1058200 | 1058200 | 2021-02-23 | Jones | Mississippi | 28067 | 7836 | 144 |
1054954 | 1054954 | 2021-02-22 | Jones | Mississippi | 28067 | 7825 | 142 |
1051707 | 1051707 | 2021-02-21 | Jones | Mississippi | 28067 | 7814 | 142 |
1048460 | 1048460 | 2021-02-20 | Jones | Mississippi | 28067 | 7790 | 142 |
1045214 | 1045214 | 2021-02-19 | Jones | Mississippi | 28067 | 7772 | 142 |
1041969 | 1041969 | 2021-02-18 | Jones | Mississippi | 28067 | 7753 | 142 |
1038724 | 1038724 | 2021-02-17 | Jones | Mississippi | 28067 | 7747 | 142 |
1035479 | 1035479 | 2021-02-16 | Jones | Mississippi | 28067 | 7720 | 140 |
1032234 | 1032234 | 2021-02-15 | Jones | Mississippi | 28067 | 7691 | 139 |
1028987 | 1028987 | 2021-02-14 | Jones | Mississippi | 28067 | 7675 | 139 |
1025741 | 1025741 | 2021-02-13 | Jones | Mississippi | 28067 | 7646 | 139 |
1022496 | 1022496 | 2021-02-12 | Jones | Mississippi | 28067 | 7623 | 139 |
1019251 | 1019251 | 2021-02-11 | Jones | Mississippi | 28067 | 7585 | 138 |
1016006 | 1016006 | 2021-02-10 | Jones | Mississippi | 28067 | 7557 | 136 |
1012761 | 1012761 | 2021-02-09 | Jones | Mississippi | 28067 | 7524 | 136 |
1009516 | 1009516 | 2021-02-08 | Jones | Mississippi | 28067 | 7507 | 132 |
1006269 | 1006269 | 2021-02-07 | Jones | Mississippi | 28067 | 7490 | 132 |
1003023 | 1003023 | 2021-02-06 | Jones | Mississippi | 28067 | 7467 | 132 |
999778 | 999778 | 2021-02-05 | Jones | Mississippi | 28067 | 7427 | 127 |
996532 | 996532 | 2021-02-04 | Jones | Mississippi | 28067 | 7371 | 125 |
993286 | 993286 | 2021-02-03 | Jones | Mississippi | 28067 | 7332 | 124 |
990040 | 990040 | 2021-02-02 | Jones | Mississippi | 28067 | 7307 | 124 |
986793 | 986793 | 2021-02-01 | Jones | Mississippi | 28067 | 7278 | 123 |
983546 | 983546 | 2021-01-31 | Jones | Mississippi | 28067 | 7206 | 123 |
980300 | 980300 | 2021-01-30 | Jones | Mississippi | 28067 | 7166 | 122 |
977054 | 977054 | 2021-01-29 | Jones | Mississippi | 28067 | 7132 | 120 |
973809 | 973809 | 2021-01-28 | Jones | Mississippi | 28067 | 7039 | 120 |
970564 | 970564 | 2021-01-27 | Jones | Mississippi | 28067 | 6934 | 120 |
967319 | 967319 | 2021-01-26 | Jones | Mississippi | 28067 | 6853 | 120 |
964075 | 964075 | 2021-01-25 | Jones | Mississippi | 28067 | 6782 | 118 |
960830 | 960830 | 2021-01-24 | Jones | Mississippi | 28067 | 6731 | 118 |
957584 | 957584 | 2021-01-23 | Jones | Mississippi | 28067 | 6668 | 114 |
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);