ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Perry" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717363 | 1717363 | 2021-09-14 | Perry | Mississippi | 28111 | 1938 | 53 |
1714115 | 1714115 | 2021-09-13 | Perry | Mississippi | 28111 | 1931 | 53 |
1710869 | 1710869 | 2021-09-12 | Perry | Mississippi | 28111 | 1910 | 49 |
1707622 | 1707622 | 2021-09-11 | Perry | Mississippi | 28111 | 1910 | 49 |
1704375 | 1704375 | 2021-09-10 | Perry | Mississippi | 28111 | 1910 | 49 |
1701125 | 1701125 | 2021-09-09 | Perry | Mississippi | 28111 | 1900 | 49 |
1697876 | 1697876 | 2021-09-08 | Perry | Mississippi | 28111 | 1882 | 48 |
1694628 | 1694628 | 2021-09-07 | Perry | Mississippi | 28111 | 1872 | 48 |
1691379 | 1691379 | 2021-09-06 | Perry | Mississippi | 28111 | 1864 | 47 |
1688129 | 1688129 | 2021-09-05 | Perry | Mississippi | 28111 | 1824 | 45 |
1684879 | 1684879 | 2021-09-04 | Perry | Mississippi | 28111 | 1824 | 45 |
1681628 | 1681628 | 2021-09-03 | Perry | Mississippi | 28111 | 1824 | 45 |
1678380 | 1678380 | 2021-09-02 | Perry | Mississippi | 28111 | 1805 | 45 |
1675132 | 1675132 | 2021-09-01 | Perry | Mississippi | 28111 | 1786 | 45 |
1671884 | 1671884 | 2021-08-31 | Perry | Mississippi | 28111 | 1777 | 44 |
1668637 | 1668637 | 2021-08-30 | Perry | Mississippi | 28111 | 1770 | 44 |
1665390 | 1665390 | 2021-08-29 | Perry | Mississippi | 28111 | 1723 | 42 |
1662142 | 1662142 | 2021-08-28 | Perry | Mississippi | 28111 | 1723 | 42 |
1658894 | 1658894 | 2021-08-27 | Perry | Mississippi | 28111 | 1723 | 42 |
1655645 | 1655645 | 2021-08-26 | Perry | Mississippi | 28111 | 1697 | 42 |
1652398 | 1652398 | 2021-08-25 | Perry | Mississippi | 28111 | 1680 | 42 |
1649150 | 1649150 | 2021-08-24 | Perry | Mississippi | 28111 | 1665 | 42 |
1645901 | 1645901 | 2021-08-23 | Perry | Mississippi | 28111 | 1652 | 42 |
1642652 | 1642652 | 2021-08-22 | Perry | Mississippi | 28111 | 1593 | 41 |
1639402 | 1639402 | 2021-08-21 | Perry | Mississippi | 28111 | 1593 | 41 |
1636152 | 1636152 | 2021-08-20 | Perry | Mississippi | 28111 | 1593 | 41 |
1632902 | 1632902 | 2021-08-19 | Perry | Mississippi | 28111 | 1556 | 41 |
1629655 | 1629655 | 2021-08-18 | Perry | Mississippi | 28111 | 1530 | 41 |
1626408 | 1626408 | 2021-08-17 | Perry | Mississippi | 28111 | 1510 | 41 |
1623161 | 1623161 | 2021-08-16 | Perry | Mississippi | 28111 | 1501 | 40 |
1619914 | 1619914 | 2021-08-15 | Perry | Mississippi | 28111 | 1471 | 39 |
1616666 | 1616666 | 2021-08-14 | Perry | Mississippi | 28111 | 1471 | 39 |
1613418 | 1613418 | 2021-08-13 | Perry | Mississippi | 28111 | 1471 | 39 |
1610169 | 1610169 | 2021-08-12 | Perry | Mississippi | 28111 | 1447 | 39 |
1606921 | 1606921 | 2021-08-11 | Perry | Mississippi | 28111 | 1433 | 39 |
1603672 | 1603672 | 2021-08-10 | Perry | Mississippi | 28111 | 1425 | 38 |
1600423 | 1600423 | 2021-08-09 | Perry | Mississippi | 28111 | 1408 | 38 |
1597175 | 1597175 | 2021-08-08 | Perry | Mississippi | 28111 | 1385 | 38 |
1593926 | 1593926 | 2021-08-07 | Perry | Mississippi | 28111 | 1385 | 38 |
1590677 | 1590677 | 2021-08-06 | Perry | Mississippi | 28111 | 1385 | 38 |
1587428 | 1587428 | 2021-08-05 | Perry | Mississippi | 28111 | 1379 | 38 |
1584177 | 1584177 | 2021-08-04 | Perry | Mississippi | 28111 | 1370 | 38 |
1580928 | 1580928 | 2021-08-03 | Perry | Mississippi | 28111 | 1361 | 38 |
1577679 | 1577679 | 2021-08-02 | Perry | Mississippi | 28111 | 1356 | 38 |
1574431 | 1574431 | 2021-08-01 | Perry | Mississippi | 28111 | 1335 | 38 |
1571183 | 1571183 | 2021-07-31 | Perry | Mississippi | 28111 | 1335 | 38 |
1567935 | 1567935 | 2021-07-30 | Perry | Mississippi | 28111 | 1335 | 38 |
1564687 | 1564687 | 2021-07-29 | Perry | Mississippi | 28111 | 1332 | 38 |
1561439 | 1561439 | 2021-07-28 | Perry | Mississippi | 28111 | 1329 | 38 |
1558191 | 1558191 | 2021-07-27 | Perry | Mississippi | 28111 | 1324 | 38 |
1554944 | 1554944 | 2021-07-26 | Perry | Mississippi | 28111 | 1321 | 38 |
1551697 | 1551697 | 2021-07-25 | Perry | Mississippi | 28111 | 1310 | 38 |
1548450 | 1548450 | 2021-07-24 | Perry | Mississippi | 28111 | 1310 | 38 |
1545203 | 1545203 | 2021-07-23 | Perry | Mississippi | 28111 | 1310 | 38 |
1541955 | 1541955 | 2021-07-22 | Perry | Mississippi | 28111 | 1308 | 38 |
1538708 | 1538708 | 2021-07-21 | Perry | Mississippi | 28111 | 1305 | 38 |
1535461 | 1535461 | 2021-07-20 | Perry | Mississippi | 28111 | 1302 | 38 |
1532213 | 1532213 | 2021-07-19 | Perry | Mississippi | 28111 | 1301 | 38 |
1528966 | 1528966 | 2021-07-18 | Perry | Mississippi | 28111 | 1296 | 38 |
1525719 | 1525719 | 2021-07-17 | Perry | Mississippi | 28111 | 1296 | 38 |
1522472 | 1522472 | 2021-07-16 | Perry | Mississippi | 28111 | 1296 | 38 |
1519223 | 1519223 | 2021-07-15 | Perry | Mississippi | 28111 | 1295 | 38 |
1515976 | 1515976 | 2021-07-14 | Perry | Mississippi | 28111 | 1294 | 38 |
1512730 | 1512730 | 2021-07-13 | Perry | Mississippi | 28111 | 1293 | 38 |
1509483 | 1509483 | 2021-07-12 | Perry | Mississippi | 28111 | 1293 | 38 |
1506237 | 1506237 | 2021-07-11 | Perry | Mississippi | 28111 | 1292 | 38 |
1502991 | 1502991 | 2021-07-10 | Perry | Mississippi | 28111 | 1292 | 38 |
1499745 | 1499745 | 2021-07-09 | Perry | Mississippi | 28111 | 1292 | 38 |
1496499 | 1496499 | 2021-07-08 | Perry | Mississippi | 28111 | 1287 | 38 |
1493252 | 1493252 | 2021-07-07 | Perry | Mississippi | 28111 | 1283 | 38 |
1490005 | 1490005 | 2021-07-06 | Perry | Mississippi | 28111 | 1287 | 38 |
1486758 | 1486758 | 2021-07-05 | Perry | Mississippi | 28111 | 1283 | 38 |
1483512 | 1483512 | 2021-07-04 | Perry | Mississippi | 28111 | 1283 | 38 |
1480266 | 1480266 | 2021-07-03 | Perry | Mississippi | 28111 | 1283 | 38 |
1477019 | 1477019 | 2021-07-02 | Perry | Mississippi | 28111 | 1283 | 38 |
1473773 | 1473773 | 2021-07-01 | Perry | Mississippi | 28111 | 1283 | 38 |
1470527 | 1470527 | 2021-06-30 | Perry | Mississippi | 28111 | 1283 | 38 |
1467282 | 1467282 | 2021-06-29 | Perry | Mississippi | 28111 | 1283 | 38 |
1464037 | 1464037 | 2021-06-28 | Perry | Mississippi | 28111 | 1283 | 38 |
1460792 | 1460792 | 2021-06-27 | Perry | Mississippi | 28111 | 1277 | 38 |
1457547 | 1457547 | 2021-06-26 | Perry | Mississippi | 28111 | 1277 | 38 |
1454302 | 1454302 | 2021-06-25 | Perry | Mississippi | 28111 | 1277 | 38 |
1451057 | 1451057 | 2021-06-24 | Perry | Mississippi | 28111 | 1275 | 38 |
1447811 | 1447811 | 2021-06-23 | Perry | Mississippi | 28111 | 1275 | 38 |
1444566 | 1444566 | 2021-06-22 | Perry | Mississippi | 28111 | 1275 | 38 |
1441321 | 1441321 | 2021-06-21 | Perry | Mississippi | 28111 | 1275 | 38 |
1438075 | 1438075 | 2021-06-20 | Perry | Mississippi | 28111 | 1272 | 38 |
1434828 | 1434828 | 2021-06-19 | Perry | Mississippi | 28111 | 1272 | 38 |
1431581 | 1431581 | 2021-06-18 | Perry | Mississippi | 28111 | 1272 | 38 |
1428336 | 1428336 | 2021-06-17 | Perry | Mississippi | 28111 | 1271 | 38 |
1425091 | 1425091 | 2021-06-16 | Perry | Mississippi | 28111 | 1267 | 38 |
1421843 | 1421843 | 2021-06-15 | Perry | Mississippi | 28111 | 1266 | 38 |
1418598 | 1418598 | 2021-06-14 | Perry | Mississippi | 28111 | 1266 | 38 |
1415353 | 1415353 | 2021-06-13 | Perry | Mississippi | 28111 | 1266 | 38 |
1412107 | 1412107 | 2021-06-12 | Perry | Mississippi | 28111 | 1266 | 38 |
1408862 | 1408862 | 2021-06-11 | Perry | Mississippi | 28111 | 1266 | 38 |
1405617 | 1405617 | 2021-06-10 | Perry | Mississippi | 28111 | 1266 | 38 |
1402371 | 1402371 | 2021-06-09 | Perry | Mississippi | 28111 | 1266 | 38 |
1399126 | 1399126 | 2021-06-08 | Perry | Mississippi | 28111 | 1266 | 38 |
1395880 | 1395880 | 2021-06-07 | Perry | Mississippi | 28111 | 1266 | 38 |
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);