ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28071 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418578 | 1418578 | 2021-06-14 | Lafayette | Mississippi | 28071 | 6298 | 120 |
1415333 | 1415333 | 2021-06-13 | Lafayette | Mississippi | 28071 | 6295 | 120 |
1412087 | 1412087 | 2021-06-12 | Lafayette | Mississippi | 28071 | 6295 | 120 |
1408842 | 1408842 | 2021-06-11 | Lafayette | Mississippi | 28071 | 6295 | 120 |
1405597 | 1405597 | 2021-06-10 | Lafayette | Mississippi | 28071 | 6294 | 120 |
1402351 | 1402351 | 2021-06-09 | Lafayette | Mississippi | 28071 | 6287 | 120 |
1399106 | 1399106 | 2021-06-08 | Lafayette | Mississippi | 28071 | 6285 | 120 |
1395860 | 1395860 | 2021-06-07 | Lafayette | Mississippi | 28071 | 6283 | 120 |
1392614 | 1392614 | 2021-06-06 | Lafayette | Mississippi | 28071 | 6269 | 120 |
1389369 | 1389369 | 2021-06-05 | Lafayette | Mississippi | 28071 | 6269 | 120 |
1386124 | 1386124 | 2021-06-04 | Lafayette | Mississippi | 28071 | 6269 | 120 |
1382879 | 1382879 | 2021-06-03 | Lafayette | Mississippi | 28071 | 6266 | 119 |
1379633 | 1379633 | 2021-06-02 | Lafayette | Mississippi | 28071 | 6263 | 119 |
1376388 | 1376388 | 2021-06-01 | Lafayette | Mississippi | 28071 | 6261 | 119 |
1373142 | 1373142 | 2021-05-31 | Lafayette | Mississippi | 28071 | 6258 | 119 |
1369897 | 1369897 | 2021-05-30 | Lafayette | Mississippi | 28071 | 6254 | 119 |
1366651 | 1366651 | 2021-05-29 | Lafayette | Mississippi | 28071 | 6254 | 119 |
1363405 | 1363405 | 2021-05-28 | Lafayette | Mississippi | 28071 | 6254 | 119 |
1360158 | 1360158 | 2021-05-27 | Lafayette | Mississippi | 28071 | 6253 | 119 |
1356912 | 1356912 | 2021-05-26 | Lafayette | Mississippi | 28071 | 6252 | 119 |
1353666 | 1353666 | 2021-05-25 | Lafayette | Mississippi | 28071 | 6249 | 119 |
1350420 | 1350420 | 2021-05-24 | Lafayette | Mississippi | 28071 | 6245 | 119 |
1347174 | 1347174 | 2021-05-23 | Lafayette | Mississippi | 28071 | 6231 | 119 |
1343926 | 1343926 | 2021-05-22 | Lafayette | Mississippi | 28071 | 6231 | 119 |
1340677 | 1340677 | 2021-05-21 | Lafayette | Mississippi | 28071 | 6231 | 119 |
1337430 | 1337430 | 2021-05-20 | Lafayette | Mississippi | 28071 | 6228 | 119 |
1334183 | 1334183 | 2021-05-19 | Lafayette | Mississippi | 28071 | 6213 | 119 |
1330936 | 1330936 | 2021-05-18 | Lafayette | Mississippi | 28071 | 6214 | 119 |
1327689 | 1327689 | 2021-05-17 | Lafayette | Mississippi | 28071 | 6210 | 119 |
1324443 | 1324443 | 2021-05-16 | Lafayette | Mississippi | 28071 | 6203 | 119 |
1321197 | 1321197 | 2021-05-15 | Lafayette | Mississippi | 28071 | 6203 | 119 |
1317951 | 1317951 | 2021-05-14 | Lafayette | Mississippi | 28071 | 6203 | 119 |
1314703 | 1314703 | 2021-05-13 | Lafayette | Mississippi | 28071 | 6200 | 118 |
1311457 | 1311457 | 2021-05-12 | Lafayette | Mississippi | 28071 | 6187 | 118 |
1308210 | 1308210 | 2021-05-11 | Lafayette | Mississippi | 28071 | 6184 | 118 |
1304964 | 1304964 | 2021-05-10 | Lafayette | Mississippi | 28071 | 6175 | 118 |
1301718 | 1301718 | 2021-05-09 | Lafayette | Mississippi | 28071 | 6171 | 118 |
1298470 | 1298470 | 2021-05-08 | Lafayette | Mississippi | 28071 | 6171 | 118 |
1295224 | 1295224 | 2021-05-07 | Lafayette | Mississippi | 28071 | 6171 | 118 |
1291978 | 1291978 | 2021-05-06 | Lafayette | Mississippi | 28071 | 6168 | 118 |
1288732 | 1288732 | 2021-05-05 | Lafayette | Mississippi | 28071 | 6164 | 118 |
1285486 | 1285486 | 2021-05-04 | Lafayette | Mississippi | 28071 | 6162 | 118 |
1282240 | 1282240 | 2021-05-03 | Lafayette | Mississippi | 28071 | 6153 | 118 |
1278993 | 1278993 | 2021-05-02 | Lafayette | Mississippi | 28071 | 6142 | 118 |
1275746 | 1275746 | 2021-05-01 | Lafayette | Mississippi | 28071 | 6142 | 118 |
1272499 | 1272499 | 2021-04-30 | Lafayette | Mississippi | 28071 | 6142 | 118 |
1269252 | 1269252 | 2021-04-29 | Lafayette | Mississippi | 28071 | 6138 | 118 |
1266005 | 1266005 | 2021-04-28 | Lafayette | Mississippi | 28071 | 6134 | 118 |
1262758 | 1262758 | 2021-04-27 | Lafayette | Mississippi | 28071 | 6126 | 118 |
1259511 | 1259511 | 2021-04-26 | Lafayette | Mississippi | 28071 | 6120 | 118 |
1256264 | 1256264 | 2021-04-25 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1253017 | 1253017 | 2021-04-24 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1249770 | 1249770 | 2021-04-23 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1246523 | 1246523 | 2021-04-22 | Lafayette | Mississippi | 28071 | 6104 | 118 |
1243276 | 1243276 | 2021-04-21 | Lafayette | Mississippi | 28071 | 6099 | 118 |
1240029 | 1240029 | 2021-04-20 | Lafayette | Mississippi | 28071 | 6093 | 118 |
1236782 | 1236782 | 2021-04-19 | Lafayette | Mississippi | 28071 | 6081 | 118 |
1233535 | 1233535 | 2021-04-18 | Lafayette | Mississippi | 28071 | 6077 | 118 |
1230287 | 1230287 | 2021-04-17 | Lafayette | Mississippi | 28071 | 6077 | 118 |
1227039 | 1227039 | 2021-04-16 | Lafayette | Mississippi | 28071 | 6072 | 117 |
1223791 | 1223791 | 2021-04-15 | Lafayette | Mississippi | 28071 | 6063 | 117 |
1220544 | 1220544 | 2021-04-14 | Lafayette | Mississippi | 28071 | 6050 | 117 |
1217296 | 1217296 | 2021-04-13 | Lafayette | Mississippi | 28071 | 6039 | 117 |
1214049 | 1214049 | 2021-04-12 | Lafayette | Mississippi | 28071 | 6028 | 117 |
1210801 | 1210801 | 2021-04-11 | Lafayette | Mississippi | 28071 | 6027 | 117 |
1207552 | 1207552 | 2021-04-10 | Lafayette | Mississippi | 28071 | 6026 | 117 |
1204304 | 1204304 | 2021-04-09 | Lafayette | Mississippi | 28071 | 6020 | 117 |
1201056 | 1201056 | 2021-04-08 | Lafayette | Mississippi | 28071 | 6011 | 117 |
1197807 | 1197807 | 2021-04-07 | Lafayette | Mississippi | 28071 | 5997 | 116 |
1194558 | 1194558 | 2021-04-06 | Lafayette | Mississippi | 28071 | 5991 | 116 |
1191309 | 1191309 | 2021-04-05 | Lafayette | Mississippi | 28071 | 5980 | 116 |
1188061 | 1188061 | 2021-04-04 | Lafayette | Mississippi | 28071 | 5974 | 116 |
1184814 | 1184814 | 2021-04-03 | Lafayette | Mississippi | 28071 | 5969 | 116 |
1181568 | 1181568 | 2021-04-02 | Lafayette | Mississippi | 28071 | 5962 | 116 |
1178321 | 1178321 | 2021-04-01 | Lafayette | Mississippi | 28071 | 5951 | 116 |
1175074 | 1175074 | 2021-03-31 | Lafayette | Mississippi | 28071 | 5938 | 116 |
1171827 | 1171827 | 2021-03-30 | Lafayette | Mississippi | 28071 | 5928 | 116 |
1168579 | 1168579 | 2021-03-29 | Lafayette | Mississippi | 28071 | 5923 | 116 |
1165331 | 1165331 | 2021-03-28 | Lafayette | Mississippi | 28071 | 5918 | 116 |
1162083 | 1162083 | 2021-03-27 | Lafayette | Mississippi | 28071 | 5908 | 116 |
1158835 | 1158835 | 2021-03-26 | Lafayette | Mississippi | 28071 | 5906 | 116 |
1155588 | 1155588 | 2021-03-25 | Lafayette | Mississippi | 28071 | 5899 | 116 |
1152341 | 1152341 | 2021-03-24 | Lafayette | Mississippi | 28071 | 5892 | 116 |
1149094 | 1149094 | 2021-03-23 | Lafayette | Mississippi | 28071 | 5879 | 116 |
1145847 | 1145847 | 2021-03-22 | Lafayette | Mississippi | 28071 | 5873 | 115 |
1142600 | 1142600 | 2021-03-21 | Lafayette | Mississippi | 28071 | 5873 | 115 |
1139353 | 1139353 | 2021-03-20 | Lafayette | Mississippi | 28071 | 5869 | 114 |
1136107 | 1136107 | 2021-03-19 | Lafayette | Mississippi | 28071 | 5866 | 114 |
1132861 | 1132861 | 2021-03-18 | Lafayette | Mississippi | 28071 | 5863 | 114 |
1129613 | 1129613 | 2021-03-17 | Lafayette | Mississippi | 28071 | 5858 | 114 |
1126366 | 1126366 | 2021-03-16 | Lafayette | Mississippi | 28071 | 5842 | 114 |
1123120 | 1123120 | 2021-03-15 | Lafayette | Mississippi | 28071 | 5835 | 114 |
1119873 | 1119873 | 2021-03-14 | Lafayette | Mississippi | 28071 | 5834 | 114 |
1116626 | 1116626 | 2021-03-13 | Lafayette | Mississippi | 28071 | 5832 | 114 |
1113380 | 1113380 | 2021-03-12 | Lafayette | Mississippi | 28071 | 5808 | 114 |
1110134 | 1110134 | 2021-03-11 | Lafayette | Mississippi | 28071 | 5788 | 114 |
1106888 | 1106888 | 2021-03-10 | Lafayette | Mississippi | 28071 | 5779 | 114 |
1103642 | 1103642 | 2021-03-09 | Lafayette | Mississippi | 28071 | 5777 | 114 |
1100396 | 1100396 | 2021-03-08 | Lafayette | Mississippi | 28071 | 5768 | 114 |
1097149 | 1097149 | 2021-03-07 | Lafayette | Mississippi | 28071 | 5768 | 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);