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 |
---|---|---|---|---|---|---|---|
1623141 | 1623141 | 2021-08-16 | Lafayette | Mississippi | 28071 | 7077 | 128 |
1619894 | 1619894 | 2021-08-15 | Lafayette | Mississippi | 28071 | 7012 | 127 |
1616646 | 1616646 | 2021-08-14 | Lafayette | Mississippi | 28071 | 7012 | 127 |
1613398 | 1613398 | 2021-08-13 | Lafayette | Mississippi | 28071 | 7012 | 127 |
1610149 | 1610149 | 2021-08-12 | Lafayette | Mississippi | 28071 | 6960 | 127 |
1606901 | 1606901 | 2021-08-11 | Lafayette | Mississippi | 28071 | 6923 | 127 |
1603652 | 1603652 | 2021-08-10 | Lafayette | Mississippi | 28071 | 6858 | 127 |
1600403 | 1600403 | 2021-08-09 | Lafayette | Mississippi | 28071 | 6814 | 126 |
1597155 | 1597155 | 2021-08-08 | Lafayette | Mississippi | 28071 | 6734 | 126 |
1593906 | 1593906 | 2021-08-07 | Lafayette | Mississippi | 28071 | 6734 | 126 |
1590657 | 1590657 | 2021-08-06 | Lafayette | Mississippi | 28071 | 6734 | 126 |
1587408 | 1587408 | 2021-08-05 | Lafayette | Mississippi | 28071 | 6716 | 125 |
1584157 | 1584157 | 2021-08-04 | Lafayette | Mississippi | 28071 | 6658 | 125 |
1580908 | 1580908 | 2021-08-03 | Lafayette | Mississippi | 28071 | 6631 | 125 |
1577659 | 1577659 | 2021-08-02 | Lafayette | Mississippi | 28071 | 6604 | 125 |
1574411 | 1574411 | 2021-08-01 | Lafayette | Mississippi | 28071 | 6548 | 124 |
1571163 | 1571163 | 2021-07-31 | Lafayette | Mississippi | 28071 | 6548 | 124 |
1567915 | 1567915 | 2021-07-30 | Lafayette | Mississippi | 28071 | 6548 | 124 |
1564667 | 1564667 | 2021-07-29 | Lafayette | Mississippi | 28071 | 6535 | 124 |
1561419 | 1561419 | 2021-07-28 | Lafayette | Mississippi | 28071 | 6513 | 124 |
1558171 | 1558171 | 2021-07-27 | Lafayette | Mississippi | 28071 | 6502 | 124 |
1554924 | 1554924 | 2021-07-26 | Lafayette | Mississippi | 28071 | 6485 | 124 |
1551677 | 1551677 | 2021-07-25 | Lafayette | Mississippi | 28071 | 6459 | 124 |
1548430 | 1548430 | 2021-07-24 | Lafayette | Mississippi | 28071 | 6459 | 124 |
1545183 | 1545183 | 2021-07-23 | Lafayette | Mississippi | 28071 | 6459 | 124 |
1541935 | 1541935 | 2021-07-22 | Lafayette | Mississippi | 28071 | 6446 | 124 |
1538688 | 1538688 | 2021-07-21 | Lafayette | Mississippi | 28071 | 6429 | 124 |
1535441 | 1535441 | 2021-07-20 | Lafayette | Mississippi | 28071 | 6421 | 124 |
1532193 | 1532193 | 2021-07-19 | Lafayette | Mississippi | 28071 | 6402 | 124 |
1528946 | 1528946 | 2021-07-18 | Lafayette | Mississippi | 28071 | 6378 | 124 |
1525699 | 1525699 | 2021-07-17 | Lafayette | Mississippi | 28071 | 6378 | 124 |
1522452 | 1522452 | 2021-07-16 | Lafayette | Mississippi | 28071 | 6378 | 124 |
1519203 | 1519203 | 2021-07-15 | Lafayette | Mississippi | 28071 | 6370 | 124 |
1515956 | 1515956 | 2021-07-14 | Lafayette | Mississippi | 28071 | 6366 | 124 |
1512710 | 1512710 | 2021-07-13 | Lafayette | Mississippi | 28071 | 6361 | 124 |
1509463 | 1509463 | 2021-07-12 | Lafayette | Mississippi | 28071 | 6361 | 124 |
1506217 | 1506217 | 2021-07-11 | Lafayette | Mississippi | 28071 | 6351 | 124 |
1502971 | 1502971 | 2021-07-10 | Lafayette | Mississippi | 28071 | 6351 | 124 |
1499725 | 1499725 | 2021-07-09 | Lafayette | Mississippi | 28071 | 6351 | 124 |
1496479 | 1496479 | 2021-07-08 | Lafayette | Mississippi | 28071 | 6345 | 124 |
1493232 | 1493232 | 2021-07-07 | Lafayette | Mississippi | 28071 | 6343 | 124 |
1489985 | 1489985 | 2021-07-06 | Lafayette | Mississippi | 28071 | 6342 | 124 |
1486738 | 1486738 | 2021-07-05 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1483492 | 1483492 | 2021-07-04 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1480246 | 1480246 | 2021-07-03 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1476999 | 1476999 | 2021-07-02 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1473753 | 1473753 | 2021-07-01 | Lafayette | Mississippi | 28071 | 6335 | 122 |
1470507 | 1470507 | 2021-06-30 | Lafayette | Mississippi | 28071 | 6333 | 122 |
1467262 | 1467262 | 2021-06-29 | Lafayette | Mississippi | 28071 | 6331 | 122 |
1464017 | 1464017 | 2021-06-28 | Lafayette | Mississippi | 28071 | 6325 | 121 |
1460772 | 1460772 | 2021-06-27 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1457527 | 1457527 | 2021-06-26 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1454282 | 1454282 | 2021-06-25 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1451037 | 1451037 | 2021-06-24 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1447791 | 1447791 | 2021-06-23 | Lafayette | Mississippi | 28071 | 6315 | 121 |
1444546 | 1444546 | 2021-06-22 | Lafayette | Mississippi | 28071 | 6314 | 121 |
1441301 | 1441301 | 2021-06-21 | Lafayette | Mississippi | 28071 | 6314 | 121 |
1438055 | 1438055 | 2021-06-20 | Lafayette | Mississippi | 28071 | 6313 | 121 |
1434808 | 1434808 | 2021-06-19 | Lafayette | Mississippi | 28071 | 6313 | 121 |
1431561 | 1431561 | 2021-06-18 | Lafayette | Mississippi | 28071 | 6313 | 121 |
1428316 | 1428316 | 2021-06-17 | Lafayette | Mississippi | 28071 | 6310 | 121 |
1425071 | 1425071 | 2021-06-16 | Lafayette | Mississippi | 28071 | 6303 | 121 |
1421823 | 1421823 | 2021-06-15 | Lafayette | Mississippi | 28071 | 6301 | 120 |
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 |
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);