ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where county = "Mercer", deaths = 34 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1804284 | 1804284 | 2021-10-11 | Mercer | Illinois | 17131 | 1997 | 34 |
1801035 | 1801035 | 2021-10-10 | Mercer | Illinois | 17131 | 1997 | 34 |
1797786 | 1797786 | 2021-10-09 | Mercer | Illinois | 17131 | 1997 | 34 |
1794537 | 1794537 | 2021-10-08 | Mercer | Illinois | 17131 | 1997 | 34 |
1791289 | 1791289 | 2021-10-07 | Mercer | Illinois | 17131 | 1994 | 34 |
1788040 | 1788040 | 2021-10-06 | Mercer | Illinois | 17131 | 1990 | 34 |
1784791 | 1784791 | 2021-10-05 | Mercer | Illinois | 17131 | 1982 | 34 |
1781542 | 1781542 | 2021-10-04 | Mercer | Illinois | 17131 | 1977 | 34 |
1778292 | 1778292 | 2021-10-03 | Mercer | Illinois | 17131 | 1962 | 34 |
1775042 | 1775042 | 2021-10-02 | Mercer | Illinois | 17131 | 1962 | 34 |
1771792 | 1771792 | 2021-10-01 | Mercer | Illinois | 17131 | 1962 | 34 |
1768543 | 1768543 | 2021-09-30 | Mercer | Illinois | 17131 | 1958 | 34 |
1765294 | 1765294 | 2021-09-29 | Mercer | Illinois | 17131 | 1941 | 34 |
1762045 | 1762045 | 2021-09-28 | Mercer | Illinois | 17131 | 1931 | 34 |
1758797 | 1758797 | 2021-09-27 | Mercer | Illinois | 17131 | 1922 | 34 |
1755549 | 1755549 | 2021-09-26 | Mercer | Illinois | 17131 | 1912 | 34 |
1752301 | 1752301 | 2021-09-25 | Mercer | Illinois | 17131 | 1912 | 34 |
1749052 | 1749052 | 2021-09-24 | Mercer | Illinois | 17131 | 1912 | 34 |
1745802 | 1745802 | 2021-09-23 | Mercer | Illinois | 17131 | 1912 | 34 |
1742553 | 1742553 | 2021-09-22 | Mercer | Illinois | 17131 | 1906 | 34 |
1739304 | 1739304 | 2021-09-21 | Mercer | Illinois | 17131 | 1894 | 34 |
1723056 | 1723056 | 2021-09-16 | Mercer | Illinois | 17131 | 1861 | 34 |
1719807 | 1719807 | 2021-09-15 | Mercer | Illinois | 17131 | 1854 | 34 |
1716559 | 1716559 | 2021-09-14 | Mercer | Illinois | 17131 | 1847 | 34 |
1713313 | 1713313 | 2021-09-13 | Mercer | Illinois | 17131 | 1837 | 34 |
1710066 | 1710066 | 2021-09-12 | Mercer | Illinois | 17131 | 1819 | 34 |
1706819 | 1706819 | 2021-09-11 | Mercer | Illinois | 17131 | 1819 | 34 |
1703571 | 1703571 | 2021-09-10 | Mercer | Illinois | 17131 | 1819 | 34 |
1700321 | 1700321 | 2021-09-09 | Mercer | Illinois | 17131 | 1812 | 34 |
1697072 | 1697072 | 2021-09-08 | Mercer | Illinois | 17131 | 1798 | 34 |
1693824 | 1693824 | 2021-09-07 | Mercer | Illinois | 17131 | 1779 | 34 |
1690575 | 1690575 | 2021-09-06 | Mercer | Illinois | 17131 | 1767 | 34 |
1687325 | 1687325 | 2021-09-05 | Mercer | Illinois | 17131 | 1767 | 34 |
1684075 | 1684075 | 2021-09-04 | Mercer | Illinois | 17131 | 1767 | 34 |
1680824 | 1680824 | 2021-09-03 | Mercer | Illinois | 17131 | 1767 | 34 |
1677576 | 1677576 | 2021-09-02 | Mercer | Illinois | 17131 | 1756 | 34 |
1674329 | 1674329 | 2021-09-01 | Mercer | Illinois | 17131 | 1744 | 34 |
1671080 | 1671080 | 2021-08-31 | Mercer | Illinois | 17131 | 1721 | 34 |
1667833 | 1667833 | 2021-08-30 | Mercer | Illinois | 17131 | 1711 | 34 |
1664586 | 1664586 | 2021-08-29 | Mercer | Illinois | 17131 | 1692 | 34 |
1661338 | 1661338 | 2021-08-28 | Mercer | Illinois | 17131 | 1692 | 34 |
1658090 | 1658090 | 2021-08-27 | Mercer | Illinois | 17131 | 1692 | 34 |
1654842 | 1654842 | 2021-08-26 | Mercer | Illinois | 17131 | 1680 | 34 |
1651595 | 1651595 | 2021-08-25 | Mercer | Illinois | 17131 | 1666 | 34 |
1648346 | 1648346 | 2021-08-24 | Mercer | Illinois | 17131 | 1655 | 34 |
1645098 | 1645098 | 2021-08-23 | Mercer | Illinois | 17131 | 1629 | 34 |
1641849 | 1641849 | 2021-08-22 | Mercer | Illinois | 17131 | 1617 | 34 |
1638599 | 1638599 | 2021-08-21 | Mercer | Illinois | 17131 | 1617 | 34 |
1635349 | 1635349 | 2021-08-20 | Mercer | Illinois | 17131 | 1617 | 34 |
1632099 | 1632099 | 2021-08-19 | Mercer | Illinois | 17131 | 1605 | 34 |
1628852 | 1628852 | 2021-08-18 | Mercer | Illinois | 17131 | 1595 | 34 |
1625605 | 1625605 | 2021-08-17 | Mercer | Illinois | 17131 | 1584 | 34 |
1622358 | 1622358 | 2021-08-16 | Mercer | Illinois | 17131 | 1566 | 34 |
1619111 | 1619111 | 2021-08-15 | Mercer | Illinois | 17131 | 1559 | 34 |
1615863 | 1615863 | 2021-08-14 | Mercer | Illinois | 17131 | 1559 | 34 |
1612614 | 1612614 | 2021-08-13 | Mercer | Illinois | 17131 | 1559 | 34 |
1609366 | 1609366 | 2021-08-12 | Mercer | Illinois | 17131 | 1551 | 34 |
1606117 | 1606117 | 2021-08-11 | Mercer | Illinois | 17131 | 1549 | 34 |
1602868 | 1602868 | 2021-08-10 | Mercer | Illinois | 17131 | 1542 | 34 |
1599619 | 1599619 | 2021-08-09 | Mercer | Illinois | 17131 | 1540 | 34 |
1596371 | 1596371 | 2021-08-08 | Mercer | Illinois | 17131 | 1534 | 34 |
1593122 | 1593122 | 2021-08-07 | Mercer | Illinois | 17131 | 1534 | 34 |
1589873 | 1589873 | 2021-08-06 | Mercer | Illinois | 17131 | 1534 | 34 |
1586624 | 1586624 | 2021-08-05 | Mercer | Illinois | 17131 | 1532 | 34 |
1583374 | 1583374 | 2021-08-04 | Mercer | Illinois | 17131 | 1530 | 34 |
1580124 | 1580124 | 2021-08-03 | Mercer | Illinois | 17131 | 1530 | 34 |
1576875 | 1576875 | 2021-08-02 | Mercer | Illinois | 17131 | 1528 | 34 |
1573627 | 1573627 | 2021-08-01 | Mercer | Illinois | 17131 | 1525 | 34 |
1570379 | 1570379 | 2021-07-31 | Mercer | Illinois | 17131 | 1525 | 34 |
1567131 | 1567131 | 2021-07-30 | Mercer | Illinois | 17131 | 1525 | 34 |
1563883 | 1563883 | 2021-07-29 | Mercer | Illinois | 17131 | 1524 | 34 |
1560635 | 1560635 | 2021-07-28 | Mercer | Illinois | 17131 | 1524 | 34 |
1557388 | 1557388 | 2021-07-27 | Mercer | Illinois | 17131 | 1517 | 34 |
1554141 | 1554141 | 2021-07-26 | Mercer | Illinois | 17131 | 1515 | 34 |
1550894 | 1550894 | 2021-07-25 | Mercer | Illinois | 17131 | 1513 | 34 |
1547647 | 1547647 | 2021-07-24 | Mercer | Illinois | 17131 | 1513 | 34 |
1544400 | 1544400 | 2021-07-23 | Mercer | Illinois | 17131 | 1513 | 34 |
1541152 | 1541152 | 2021-07-22 | Mercer | Illinois | 17131 | 1513 | 34 |
1537905 | 1537905 | 2021-07-21 | Mercer | Illinois | 17131 | 1512 | 34 |
1534657 | 1534657 | 2021-07-20 | Mercer | Illinois | 17131 | 1512 | 34 |
1531410 | 1531410 | 2021-07-19 | Mercer | Illinois | 17131 | 1512 | 34 |
1528163 | 1528163 | 2021-07-18 | Mercer | Illinois | 17131 | 1509 | 34 |
1524916 | 1524916 | 2021-07-17 | Mercer | Illinois | 17131 | 1509 | 34 |
1521668 | 1521668 | 2021-07-16 | Mercer | Illinois | 17131 | 1509 | 34 |
1518420 | 1518420 | 2021-07-15 | Mercer | Illinois | 17131 | 1506 | 34 |
1515173 | 1515173 | 2021-07-14 | Mercer | Illinois | 17131 | 1504 | 34 |
1511927 | 1511927 | 2021-07-13 | Mercer | Illinois | 17131 | 1503 | 34 |
1508680 | 1508680 | 2021-07-12 | Mercer | Illinois | 17131 | 1503 | 34 |
1505434 | 1505434 | 2021-07-11 | Mercer | Illinois | 17131 | 1503 | 34 |
1502188 | 1502188 | 2021-07-10 | Mercer | Illinois | 17131 | 1503 | 34 |
1498942 | 1498942 | 2021-07-09 | Mercer | Illinois | 17131 | 1503 | 34 |
1495695 | 1495695 | 2021-07-08 | Mercer | Illinois | 17131 | 1500 | 34 |
1492449 | 1492449 | 2021-07-07 | Mercer | Illinois | 17131 | 1500 | 34 |
1489202 | 1489202 | 2021-07-06 | Mercer | Illinois | 17131 | 1500 | 34 |
1485955 | 1485955 | 2021-07-05 | Mercer | Illinois | 17131 | 1500 | 34 |
1482709 | 1482709 | 2021-07-04 | Mercer | Illinois | 17131 | 1500 | 34 |
1479462 | 1479462 | 2021-07-03 | Mercer | Illinois | 17131 | 1500 | 34 |
1476216 | 1476216 | 2021-07-02 | Mercer | Illinois | 17131 | 1500 | 34 |
1472970 | 1472970 | 2021-07-01 | Mercer | Illinois | 17131 | 1499 | 34 |
1469724 | 1469724 | 2021-06-30 | Mercer | Illinois | 17131 | 1499 | 34 |
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);