ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 28021 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811543 | 1811543 | 2021-10-13 | Claiborne | Mississippi | 28021 | 1305 | 37 |
1808294 | 1808294 | 2021-10-12 | Claiborne | Mississippi | 28021 | 1303 | 37 |
1805043 | 1805043 | 2021-10-11 | Claiborne | Mississippi | 28021 | 1303 | 37 |
1801794 | 1801794 | 2021-10-10 | Claiborne | Mississippi | 28021 | 1292 | 36 |
1798545 | 1798545 | 2021-10-09 | Claiborne | Mississippi | 28021 | 1292 | 36 |
1795296 | 1795296 | 2021-10-08 | Claiborne | Mississippi | 28021 | 1292 | 36 |
1792047 | 1792047 | 2021-10-07 | Claiborne | Mississippi | 28021 | 1289 | 35 |
1788798 | 1788798 | 2021-10-06 | Claiborne | Mississippi | 28021 | 1285 | 35 |
1785550 | 1785550 | 2021-10-05 | Claiborne | Mississippi | 28021 | 1284 | 35 |
1782301 | 1782301 | 2021-10-04 | Claiborne | Mississippi | 28021 | 1282 | 35 |
1779051 | 1779051 | 2021-10-03 | Claiborne | Mississippi | 28021 | 1279 | 35 |
1775801 | 1775801 | 2021-10-02 | Claiborne | Mississippi | 28021 | 1279 | 35 |
1772551 | 1772551 | 2021-10-01 | Claiborne | Mississippi | 28021 | 1279 | 35 |
1769302 | 1769302 | 2021-09-30 | Claiborne | Mississippi | 28021 | 1277 | 35 |
1766053 | 1766053 | 2021-09-29 | Claiborne | Mississippi | 28021 | 1273 | 35 |
1762804 | 1762804 | 2021-09-28 | Claiborne | Mississippi | 28021 | 1273 | 35 |
1759555 | 1759555 | 2021-09-27 | Claiborne | Mississippi | 28021 | 1271 | 34 |
1756307 | 1756307 | 2021-09-26 | Claiborne | Mississippi | 28021 | 1268 | 34 |
1753059 | 1753059 | 2021-09-25 | Claiborne | Mississippi | 28021 | 1268 | 34 |
1749811 | 1749811 | 2021-09-24 | Claiborne | Mississippi | 28021 | 1268 | 34 |
1746561 | 1746561 | 2021-09-23 | Claiborne | Mississippi | 28021 | 1266 | 34 |
1743312 | 1743312 | 2021-09-22 | Claiborne | Mississippi | 28021 | 1261 | 34 |
1740063 | 1740063 | 2021-09-21 | Claiborne | Mississippi | 28021 | 1261 | 34 |
1736814 | 1736814 | 2021-09-20 | Claiborne | Mississippi | 28021 | 1261 | 34 |
1733564 | 1733564 | 2021-09-19 | Claiborne | Mississippi | 28021 | 1256 | 34 |
1730314 | 1730314 | 2021-09-18 | Claiborne | Mississippi | 28021 | 1256 | 34 |
1727064 | 1727064 | 2021-09-17 | Claiborne | Mississippi | 28021 | 1256 | 34 |
1723815 | 1723815 | 2021-09-16 | Claiborne | Mississippi | 28021 | 1255 | 34 |
1720566 | 1720566 | 2021-09-15 | Claiborne | Mississippi | 28021 | 1241 | 34 |
1717318 | 1717318 | 2021-09-14 | Claiborne | Mississippi | 28021 | 1238 | 34 |
1714070 | 1714070 | 2021-09-13 | Claiborne | Mississippi | 28021 | 1238 | 34 |
1710824 | 1710824 | 2021-09-12 | Claiborne | Mississippi | 28021 | 1231 | 34 |
1707577 | 1707577 | 2021-09-11 | Claiborne | Mississippi | 28021 | 1231 | 34 |
1704330 | 1704330 | 2021-09-10 | Claiborne | Mississippi | 28021 | 1231 | 34 |
1701080 | 1701080 | 2021-09-09 | Claiborne | Mississippi | 28021 | 1229 | 33 |
1697831 | 1697831 | 2021-09-08 | Claiborne | Mississippi | 28021 | 1226 | 33 |
1694583 | 1694583 | 2021-09-07 | Claiborne | Mississippi | 28021 | 1224 | 33 |
1691334 | 1691334 | 2021-09-06 | Claiborne | Mississippi | 28021 | 1223 | 33 |
1688084 | 1688084 | 2021-09-05 | Claiborne | Mississippi | 28021 | 1214 | 33 |
1684834 | 1684834 | 2021-09-04 | Claiborne | Mississippi | 28021 | 1214 | 33 |
1681583 | 1681583 | 2021-09-03 | Claiborne | Mississippi | 28021 | 1214 | 33 |
1678335 | 1678335 | 2021-09-02 | Claiborne | Mississippi | 28021 | 1210 | 33 |
1675087 | 1675087 | 2021-09-01 | Claiborne | Mississippi | 28021 | 1210 | 33 |
1671839 | 1671839 | 2021-08-31 | Claiborne | Mississippi | 28021 | 1207 | 32 |
1668592 | 1668592 | 2021-08-30 | Claiborne | Mississippi | 28021 | 1205 | 32 |
1665345 | 1665345 | 2021-08-29 | Claiborne | Mississippi | 28021 | 1192 | 32 |
1662097 | 1662097 | 2021-08-28 | Claiborne | Mississippi | 28021 | 1192 | 32 |
1658849 | 1658849 | 2021-08-27 | Claiborne | Mississippi | 28021 | 1192 | 32 |
1655600 | 1655600 | 2021-08-26 | Claiborne | Mississippi | 28021 | 1189 | 32 |
1652353 | 1652353 | 2021-08-25 | Claiborne | Mississippi | 28021 | 1181 | 32 |
1649105 | 1649105 | 2021-08-24 | Claiborne | Mississippi | 28021 | 1175 | 32 |
1645856 | 1645856 | 2021-08-23 | Claiborne | Mississippi | 28021 | 1174 | 32 |
1642607 | 1642607 | 2021-08-22 | Claiborne | Mississippi | 28021 | 1165 | 32 |
1639357 | 1639357 | 2021-08-21 | Claiborne | Mississippi | 28021 | 1165 | 32 |
1636107 | 1636107 | 2021-08-20 | Claiborne | Mississippi | 28021 | 1165 | 32 |
1632857 | 1632857 | 2021-08-19 | Claiborne | Mississippi | 28021 | 1157 | 32 |
1629610 | 1629610 | 2021-08-18 | Claiborne | Mississippi | 28021 | 1142 | 32 |
1626363 | 1626363 | 2021-08-17 | Claiborne | Mississippi | 28021 | 1139 | 32 |
1623116 | 1623116 | 2021-08-16 | Claiborne | Mississippi | 28021 | 1132 | 32 |
1619869 | 1619869 | 2021-08-15 | Claiborne | Mississippi | 28021 | 1115 | 31 |
1616621 | 1616621 | 2021-08-14 | Claiborne | Mississippi | 28021 | 1115 | 31 |
1613373 | 1613373 | 2021-08-13 | Claiborne | Mississippi | 28021 | 1115 | 31 |
1610124 | 1610124 | 2021-08-12 | Claiborne | Mississippi | 28021 | 1104 | 31 |
1606876 | 1606876 | 2021-08-11 | Claiborne | Mississippi | 28021 | 1087 | 31 |
1603627 | 1603627 | 2021-08-10 | Claiborne | Mississippi | 28021 | 1081 | 31 |
1600378 | 1600378 | 2021-08-09 | Claiborne | Mississippi | 28021 | 1079 | 31 |
1597130 | 1597130 | 2021-08-08 | Claiborne | Mississippi | 28021 | 1065 | 31 |
1593881 | 1593881 | 2021-08-07 | Claiborne | Mississippi | 28021 | 1065 | 31 |
1590632 | 1590632 | 2021-08-06 | Claiborne | Mississippi | 28021 | 1065 | 31 |
1587383 | 1587383 | 2021-08-05 | Claiborne | Mississippi | 28021 | 1064 | 31 |
1584132 | 1584132 | 2021-08-04 | Claiborne | Mississippi | 28021 | 1061 | 31 |
1580883 | 1580883 | 2021-08-03 | Claiborne | Mississippi | 28021 | 1059 | 31 |
1577634 | 1577634 | 2021-08-02 | Claiborne | Mississippi | 28021 | 1057 | 31 |
1574386 | 1574386 | 2021-08-01 | Claiborne | Mississippi | 28021 | 1053 | 31 |
1571138 | 1571138 | 2021-07-31 | Claiborne | Mississippi | 28021 | 1053 | 31 |
1567890 | 1567890 | 2021-07-30 | Claiborne | Mississippi | 28021 | 1053 | 31 |
1564642 | 1564642 | 2021-07-29 | Claiborne | Mississippi | 28021 | 1050 | 31 |
1561394 | 1561394 | 2021-07-28 | Claiborne | Mississippi | 28021 | 1050 | 31 |
1558146 | 1558146 | 2021-07-27 | Claiborne | Mississippi | 28021 | 1048 | 31 |
1554899 | 1554899 | 2021-07-26 | Claiborne | Mississippi | 28021 | 1047 | 31 |
1551652 | 1551652 | 2021-07-25 | Claiborne | Mississippi | 28021 | 1043 | 31 |
1548405 | 1548405 | 2021-07-24 | Claiborne | Mississippi | 28021 | 1043 | 31 |
1545158 | 1545158 | 2021-07-23 | Claiborne | Mississippi | 28021 | 1043 | 31 |
1541910 | 1541910 | 2021-07-22 | Claiborne | Mississippi | 28021 | 1042 | 31 |
1538663 | 1538663 | 2021-07-21 | Claiborne | Mississippi | 28021 | 1042 | 31 |
1535416 | 1535416 | 2021-07-20 | Claiborne | Mississippi | 28021 | 1042 | 31 |
1532168 | 1532168 | 2021-07-19 | Claiborne | Mississippi | 28021 | 1040 | 31 |
1528921 | 1528921 | 2021-07-18 | Claiborne | Mississippi | 28021 | 1035 | 31 |
1525674 | 1525674 | 2021-07-17 | Claiborne | Mississippi | 28021 | 1035 | 31 |
1522427 | 1522427 | 2021-07-16 | Claiborne | Mississippi | 28021 | 1035 | 31 |
1519178 | 1519178 | 2021-07-15 | Claiborne | Mississippi | 28021 | 1035 | 31 |
1515931 | 1515931 | 2021-07-14 | Claiborne | Mississippi | 28021 | 1035 | 31 |
1512685 | 1512685 | 2021-07-13 | Claiborne | Mississippi | 28021 | 1035 | 31 |
1509438 | 1509438 | 2021-07-12 | Claiborne | Mississippi | 28021 | 1035 | 31 |
1506192 | 1506192 | 2021-07-11 | Claiborne | Mississippi | 28021 | 1034 | 31 |
1502946 | 1502946 | 2021-07-10 | Claiborne | Mississippi | 28021 | 1034 | 31 |
1499700 | 1499700 | 2021-07-09 | Claiborne | Mississippi | 28021 | 1034 | 31 |
1496454 | 1496454 | 2021-07-08 | Claiborne | Mississippi | 28021 | 1034 | 31 |
1493207 | 1493207 | 2021-07-07 | Claiborne | Mississippi | 28021 | 1033 | 31 |
1489960 | 1489960 | 2021-07-06 | Claiborne | Mississippi | 28021 | 1033 | 30 |
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);