ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Menard" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814032 | 1814032 | 2021-10-14 | Menard | Illinois | 17129 | 1709 | 17 |
1810783 | 1810783 | 2021-10-13 | Menard | Illinois | 17129 | 1706 | 17 |
1807534 | 1807534 | 2021-10-12 | Menard | Illinois | 17129 | 1701 | 17 |
1804283 | 1804283 | 2021-10-11 | Menard | Illinois | 17129 | 1695 | 17 |
1801034 | 1801034 | 2021-10-10 | Menard | Illinois | 17129 | 1695 | 17 |
1797785 | 1797785 | 2021-10-09 | Menard | Illinois | 17129 | 1695 | 17 |
1794536 | 1794536 | 2021-10-08 | Menard | Illinois | 17129 | 1695 | 17 |
1791288 | 1791288 | 2021-10-07 | Menard | Illinois | 17129 | 1687 | 17 |
1788039 | 1788039 | 2021-10-06 | Menard | Illinois | 17129 | 1683 | 17 |
1784790 | 1784790 | 2021-10-05 | Menard | Illinois | 17129 | 1676 | 17 |
1781541 | 1781541 | 2021-10-04 | Menard | Illinois | 17129 | 1674 | 17 |
1778291 | 1778291 | 2021-10-03 | Menard | Illinois | 17129 | 1656 | 17 |
1775041 | 1775041 | 2021-10-02 | Menard | Illinois | 17129 | 1656 | 17 |
1771791 | 1771791 | 2021-10-01 | Menard | Illinois | 17129 | 1656 | 17 |
1768542 | 1768542 | 2021-09-30 | Menard | Illinois | 17129 | 1649 | 17 |
1765293 | 1765293 | 2021-09-29 | Menard | Illinois | 17129 | 1641 | 17 |
1762044 | 1762044 | 2021-09-28 | Menard | Illinois | 17129 | 1631 | 16 |
1758796 | 1758796 | 2021-09-27 | Menard | Illinois | 17129 | 1626 | 16 |
1755548 | 1755548 | 2021-09-26 | Menard | Illinois | 17129 | 1608 | 16 |
1752300 | 1752300 | 2021-09-25 | Menard | Illinois | 17129 | 1608 | 16 |
1749051 | 1749051 | 2021-09-24 | Menard | Illinois | 17129 | 1608 | 16 |
1745801 | 1745801 | 2021-09-23 | Menard | Illinois | 17129 | 1598 | 16 |
1742552 | 1742552 | 2021-09-22 | Menard | Illinois | 17129 | 1586 | 16 |
1739303 | 1739303 | 2021-09-21 | Menard | Illinois | 17129 | 1580 | 16 |
1736054 | 1736054 | 2021-09-20 | Menard | Illinois | 17129 | 1579 | 16 |
1732804 | 1732804 | 2021-09-19 | Menard | Illinois | 17129 | 1558 | 16 |
1729554 | 1729554 | 2021-09-18 | Menard | Illinois | 17129 | 1558 | 16 |
1726304 | 1726304 | 2021-09-17 | Menard | Illinois | 17129 | 1558 | 16 |
1723055 | 1723055 | 2021-09-16 | Menard | Illinois | 17129 | 1551 | 16 |
1719806 | 1719806 | 2021-09-15 | Menard | Illinois | 17129 | 1541 | 16 |
1716558 | 1716558 | 2021-09-14 | Menard | Illinois | 17129 | 1539 | 16 |
1713312 | 1713312 | 2021-09-13 | Menard | Illinois | 17129 | 1535 | 16 |
1710065 | 1710065 | 2021-09-12 | Menard | Illinois | 17129 | 1504 | 16 |
1706818 | 1706818 | 2021-09-11 | Menard | Illinois | 17129 | 1504 | 16 |
1703570 | 1703570 | 2021-09-10 | Menard | Illinois | 17129 | 1504 | 16 |
1700320 | 1700320 | 2021-09-09 | Menard | Illinois | 17129 | 1498 | 16 |
1697071 | 1697071 | 2021-09-08 | Menard | Illinois | 17129 | 1492 | 16 |
1693823 | 1693823 | 2021-09-07 | Menard | Illinois | 17129 | 1490 | 16 |
1690574 | 1690574 | 2021-09-06 | Menard | Illinois | 17129 | 1474 | 16 |
1687324 | 1687324 | 2021-09-05 | Menard | Illinois | 17129 | 1474 | 16 |
1684074 | 1684074 | 2021-09-04 | Menard | Illinois | 17129 | 1474 | 16 |
1680823 | 1680823 | 2021-09-03 | Menard | Illinois | 17129 | 1474 | 16 |
1677575 | 1677575 | 2021-09-02 | Menard | Illinois | 17129 | 1465 | 16 |
1674328 | 1674328 | 2021-09-01 | Menard | Illinois | 17129 | 1456 | 16 |
1671079 | 1671079 | 2021-08-31 | Menard | Illinois | 17129 | 1454 | 16 |
1667832 | 1667832 | 2021-08-30 | Menard | Illinois | 17129 | 1445 | 16 |
1664585 | 1664585 | 2021-08-29 | Menard | Illinois | 17129 | 1425 | 16 |
1661337 | 1661337 | 2021-08-28 | Menard | Illinois | 17129 | 1425 | 16 |
1658089 | 1658089 | 2021-08-27 | Menard | Illinois | 17129 | 1425 | 16 |
1654841 | 1654841 | 2021-08-26 | Menard | Illinois | 17129 | 1422 | 16 |
1651594 | 1651594 | 2021-08-25 | Menard | Illinois | 17129 | 1416 | 16 |
1648345 | 1648345 | 2021-08-24 | Menard | Illinois | 17129 | 1400 | 16 |
1645097 | 1645097 | 2021-08-23 | Menard | Illinois | 17129 | 1398 | 16 |
1641848 | 1641848 | 2021-08-22 | Menard | Illinois | 17129 | 1385 | 16 |
1638598 | 1638598 | 2021-08-21 | Menard | Illinois | 17129 | 1385 | 16 |
1635348 | 1635348 | 2021-08-20 | Menard | Illinois | 17129 | 1385 | 16 |
1632098 | 1632098 | 2021-08-19 | Menard | Illinois | 17129 | 1382 | 16 |
1628851 | 1628851 | 2021-08-18 | Menard | Illinois | 17129 | 1381 | 16 |
1625604 | 1625604 | 2021-08-17 | Menard | Illinois | 17129 | 1375 | 16 |
1622357 | 1622357 | 2021-08-16 | Menard | Illinois | 17129 | 1367 | 16 |
1619110 | 1619110 | 2021-08-15 | Menard | Illinois | 17129 | 1357 | 16 |
1615862 | 1615862 | 2021-08-14 | Menard | Illinois | 17129 | 1357 | 16 |
1612613 | 1612613 | 2021-08-13 | Menard | Illinois | 17129 | 1357 | 16 |
1609365 | 1609365 | 2021-08-12 | Menard | Illinois | 17129 | 1354 | 16 |
1606116 | 1606116 | 2021-08-11 | Menard | Illinois | 17129 | 1351 | 16 |
1602867 | 1602867 | 2021-08-10 | Menard | Illinois | 17129 | 1343 | 16 |
1599618 | 1599618 | 2021-08-09 | Menard | Illinois | 17129 | 1340 | 16 |
1596370 | 1596370 | 2021-08-08 | Menard | Illinois | 17129 | 1316 | 16 |
1593121 | 1593121 | 2021-08-07 | Menard | Illinois | 17129 | 1316 | 16 |
1589872 | 1589872 | 2021-08-06 | Menard | Illinois | 17129 | 1316 | 16 |
1586623 | 1586623 | 2021-08-05 | Menard | Illinois | 17129 | 1312 | 16 |
1583373 | 1583373 | 2021-08-04 | Menard | Illinois | 17129 | 1309 | 16 |
1580123 | 1580123 | 2021-08-03 | Menard | Illinois | 17129 | 1303 | 16 |
1576874 | 1576874 | 2021-08-02 | Menard | Illinois | 17129 | 1300 | 16 |
1573626 | 1573626 | 2021-08-01 | Menard | Illinois | 17129 | 1287 | 16 |
1570378 | 1570378 | 2021-07-31 | Menard | Illinois | 17129 | 1287 | 16 |
1567130 | 1567130 | 2021-07-30 | Menard | Illinois | 17129 | 1287 | 16 |
1563882 | 1563882 | 2021-07-29 | Menard | Illinois | 17129 | 1287 | 16 |
1560634 | 1560634 | 2021-07-28 | Menard | Illinois | 17129 | 1284 | 16 |
1557387 | 1557387 | 2021-07-27 | Menard | Illinois | 17129 | 1279 | 16 |
1554140 | 1554140 | 2021-07-26 | Menard | Illinois | 17129 | 1279 | 16 |
1550893 | 1550893 | 2021-07-25 | Menard | Illinois | 17129 | 1269 | 16 |
1547646 | 1547646 | 2021-07-24 | Menard | Illinois | 17129 | 1269 | 16 |
1544399 | 1544399 | 2021-07-23 | Menard | Illinois | 17129 | 1269 | 16 |
1541151 | 1541151 | 2021-07-22 | Menard | Illinois | 17129 | 1269 | 16 |
1537904 | 1537904 | 2021-07-21 | Menard | Illinois | 17129 | 1268 | 16 |
1534656 | 1534656 | 2021-07-20 | Menard | Illinois | 17129 | 1267 | 16 |
1531409 | 1531409 | 2021-07-19 | Menard | Illinois | 17129 | 1267 | 16 |
1528162 | 1528162 | 2021-07-18 | Menard | Illinois | 17129 | 1263 | 16 |
1524915 | 1524915 | 2021-07-17 | Menard | Illinois | 17129 | 1263 | 16 |
1521667 | 1521667 | 2021-07-16 | Menard | Illinois | 17129 | 1263 | 16 |
1518419 | 1518419 | 2021-07-15 | Menard | Illinois | 17129 | 1263 | 16 |
1515172 | 1515172 | 2021-07-14 | Menard | Illinois | 17129 | 1263 | 16 |
1511926 | 1511926 | 2021-07-13 | Menard | Illinois | 17129 | 1263 | 16 |
1508679 | 1508679 | 2021-07-12 | Menard | Illinois | 17129 | 1261 | 16 |
1505433 | 1505433 | 2021-07-11 | Menard | Illinois | 17129 | 1261 | 16 |
1502187 | 1502187 | 2021-07-10 | Menard | Illinois | 17129 | 1261 | 16 |
1498941 | 1498941 | 2021-07-09 | Menard | Illinois | 17129 | 1261 | 16 |
1495694 | 1495694 | 2021-07-08 | Menard | Illinois | 17129 | 1259 | 16 |
1492448 | 1492448 | 2021-07-07 | Menard | Illinois | 17129 | 1259 | 16 |
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);