ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where fips = 18125 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810884 | 1810884 | 2021-10-13 | Pike | Indiana | 18125 | 2268 | 44 |
1807635 | 1807635 | 2021-10-12 | Pike | Indiana | 18125 | 2263 | 44 |
1804384 | 1804384 | 2021-10-11 | Pike | Indiana | 18125 | 2259 | 44 |
1801135 | 1801135 | 2021-10-10 | Pike | Indiana | 18125 | 2242 | 42 |
1797886 | 1797886 | 2021-10-09 | Pike | Indiana | 18125 | 2242 | 42 |
1794637 | 1794637 | 2021-10-08 | Pike | Indiana | 18125 | 2242 | 42 |
1791389 | 1791389 | 2021-10-07 | Pike | Indiana | 18125 | 2228 | 42 |
1788140 | 1788140 | 2021-10-06 | Pike | Indiana | 18125 | 2219 | 42 |
1784891 | 1784891 | 2021-10-05 | Pike | Indiana | 18125 | 2210 | 41 |
1781642 | 1781642 | 2021-10-04 | Pike | Indiana | 18125 | 2201 | 41 |
1778392 | 1778392 | 2021-10-03 | Pike | Indiana | 18125 | 2188 | 41 |
1775142 | 1775142 | 2021-10-02 | Pike | Indiana | 18125 | 2188 | 41 |
1771892 | 1771892 | 2021-10-01 | Pike | Indiana | 18125 | 2188 | 41 |
1768643 | 1768643 | 2021-09-30 | Pike | Indiana | 18125 | 2180 | 41 |
1765394 | 1765394 | 2021-09-29 | Pike | Indiana | 18125 | 2167 | 41 |
1762145 | 1762145 | 2021-09-28 | Pike | Indiana | 18125 | 2146 | 41 |
1758897 | 1758897 | 2021-09-27 | Pike | Indiana | 18125 | 2140 | 41 |
1755649 | 1755649 | 2021-09-26 | Pike | Indiana | 18125 | 2117 | 40 |
1752401 | 1752401 | 2021-09-25 | Pike | Indiana | 18125 | 2117 | 40 |
1749152 | 1749152 | 2021-09-24 | Pike | Indiana | 18125 | 2117 | 40 |
1745902 | 1745902 | 2021-09-23 | Pike | Indiana | 18125 | 2095 | 39 |
1742653 | 1742653 | 2021-09-22 | Pike | Indiana | 18125 | 2076 | 39 |
1739404 | 1739404 | 2021-09-21 | Pike | Indiana | 18125 | 2056 | 39 |
1736155 | 1736155 | 2021-09-20 | Pike | Indiana | 18125 | 2045 | 38 |
1732905 | 1732905 | 2021-09-19 | Pike | Indiana | 18125 | 2025 | 38 |
1729655 | 1729655 | 2021-09-18 | Pike | Indiana | 18125 | 2025 | 38 |
1726405 | 1726405 | 2021-09-17 | Pike | Indiana | 18125 | 2025 | 38 |
1723156 | 1723156 | 2021-09-16 | Pike | Indiana | 18125 | 2014 | 38 |
1719907 | 1719907 | 2021-09-15 | Pike | Indiana | 18125 | 2009 | 38 |
1716659 | 1716659 | 2021-09-14 | Pike | Indiana | 18125 | 1984 | 38 |
1713413 | 1713413 | 2021-09-13 | Pike | Indiana | 18125 | 1963 | 37 |
1710166 | 1710166 | 2021-09-12 | Pike | Indiana | 18125 | 1929 | 36 |
1706919 | 1706919 | 2021-09-11 | Pike | Indiana | 18125 | 1929 | 36 |
1703671 | 1703671 | 2021-09-10 | Pike | Indiana | 18125 | 1929 | 36 |
1700421 | 1700421 | 2021-09-09 | Pike | Indiana | 18125 | 1906 | 36 |
1697172 | 1697172 | 2021-09-08 | Pike | Indiana | 18125 | 1865 | 36 |
1693924 | 1693924 | 2021-09-07 | Pike | Indiana | 18125 | 1855 | 35 |
1690675 | 1690675 | 2021-09-06 | Pike | Indiana | 18125 | 1809 | 35 |
1687425 | 1687425 | 2021-09-05 | Pike | Indiana | 18125 | 1809 | 35 |
1684175 | 1684175 | 2021-09-04 | Pike | Indiana | 18125 | 1809 | 35 |
1680924 | 1680924 | 2021-09-03 | Pike | Indiana | 18125 | 1809 | 35 |
1677676 | 1677676 | 2021-09-02 | Pike | Indiana | 18125 | 1788 | 35 |
1674429 | 1674429 | 2021-09-01 | Pike | Indiana | 18125 | 1750 | 35 |
1671180 | 1671180 | 2021-08-31 | Pike | Indiana | 18125 | 1732 | 35 |
1667933 | 1667933 | 2021-08-30 | Pike | Indiana | 18125 | 1723 | 35 |
1664686 | 1664686 | 2021-08-29 | Pike | Indiana | 18125 | 1673 | 35 |
1661438 | 1661438 | 2021-08-28 | Pike | Indiana | 18125 | 1673 | 35 |
1658190 | 1658190 | 2021-08-27 | Pike | Indiana | 18125 | 1673 | 35 |
1654942 | 1654942 | 2021-08-26 | Pike | Indiana | 18125 | 1647 | 35 |
1651695 | 1651695 | 2021-08-25 | Pike | Indiana | 18125 | 1618 | 35 |
1648446 | 1648446 | 2021-08-24 | Pike | Indiana | 18125 | 1585 | 35 |
1645198 | 1645198 | 2021-08-23 | Pike | Indiana | 18125 | 1579 | 35 |
1641949 | 1641949 | 2021-08-22 | Pike | Indiana | 18125 | 1553 | 35 |
1638699 | 1638699 | 2021-08-21 | Pike | Indiana | 18125 | 1553 | 35 |
1635449 | 1635449 | 2021-08-20 | Pike | Indiana | 18125 | 1553 | 35 |
1632199 | 1632199 | 2021-08-19 | Pike | Indiana | 18125 | 1542 | 35 |
1628952 | 1628952 | 2021-08-18 | Pike | Indiana | 18125 | 1528 | 35 |
1625705 | 1625705 | 2021-08-17 | Pike | Indiana | 18125 | 1514 | 35 |
1622458 | 1622458 | 2021-08-16 | Pike | Indiana | 18125 | 1507 | 35 |
1619211 | 1619211 | 2021-08-15 | Pike | Indiana | 18125 | 1495 | 35 |
1615963 | 1615963 | 2021-08-14 | Pike | Indiana | 18125 | 1495 | 35 |
1612714 | 1612714 | 2021-08-13 | Pike | Indiana | 18125 | 1495 | 35 |
1609466 | 1609466 | 2021-08-12 | Pike | Indiana | 18125 | 1479 | 35 |
1606217 | 1606217 | 2021-08-11 | Pike | Indiana | 18125 | 1471 | 35 |
1602968 | 1602968 | 2021-08-10 | Pike | Indiana | 18125 | 1465 | 35 |
1599719 | 1599719 | 2021-08-09 | Pike | Indiana | 18125 | 1462 | 34 |
1596471 | 1596471 | 2021-08-08 | Pike | Indiana | 18125 | 1448 | 34 |
1593222 | 1593222 | 2021-08-07 | Pike | Indiana | 18125 | 1448 | 34 |
1589973 | 1589973 | 2021-08-06 | Pike | Indiana | 18125 | 1448 | 34 |
1586724 | 1586724 | 2021-08-05 | Pike | Indiana | 18125 | 1444 | 34 |
1583474 | 1583474 | 2021-08-04 | Pike | Indiana | 18125 | 1439 | 34 |
1580224 | 1580224 | 2021-08-03 | Pike | Indiana | 18125 | 1440 | 34 |
1576975 | 1576975 | 2021-08-02 | Pike | Indiana | 18125 | 1437 | 34 |
1573727 | 1573727 | 2021-08-01 | Pike | Indiana | 18125 | 1434 | 34 |
1570479 | 1570479 | 2021-07-31 | Pike | Indiana | 18125 | 1434 | 34 |
1567231 | 1567231 | 2021-07-30 | Pike | Indiana | 18125 | 1434 | 34 |
1563983 | 1563983 | 2021-07-29 | Pike | Indiana | 18125 | 1430 | 34 |
1560735 | 1560735 | 2021-07-28 | Pike | Indiana | 18125 | 1425 | 34 |
1557488 | 1557488 | 2021-07-27 | Pike | Indiana | 18125 | 1417 | 34 |
1554241 | 1554241 | 2021-07-26 | Pike | Indiana | 18125 | 1414 | 34 |
1550994 | 1550994 | 2021-07-25 | Pike | Indiana | 18125 | 1412 | 34 |
1547747 | 1547747 | 2021-07-24 | Pike | Indiana | 18125 | 1412 | 34 |
1544500 | 1544500 | 2021-07-23 | Pike | Indiana | 18125 | 1412 | 34 |
1541252 | 1541252 | 2021-07-22 | Pike | Indiana | 18125 | 1409 | 34 |
1538005 | 1538005 | 2021-07-21 | Pike | Indiana | 18125 | 1406 | 34 |
1534757 | 1534757 | 2021-07-20 | Pike | Indiana | 18125 | 1405 | 34 |
1531510 | 1531510 | 2021-07-19 | Pike | Indiana | 18125 | 1401 | 34 |
1528263 | 1528263 | 2021-07-18 | Pike | Indiana | 18125 | 1396 | 34 |
1525016 | 1525016 | 2021-07-17 | Pike | Indiana | 18125 | 1396 | 34 |
1521768 | 1521768 | 2021-07-16 | Pike | Indiana | 18125 | 1396 | 34 |
1518520 | 1518520 | 2021-07-15 | Pike | Indiana | 18125 | 1394 | 34 |
1515273 | 1515273 | 2021-07-14 | Pike | Indiana | 18125 | 1393 | 34 |
1512027 | 1512027 | 2021-07-13 | Pike | Indiana | 18125 | 1393 | 34 |
1508780 | 1508780 | 2021-07-12 | Pike | Indiana | 18125 | 1392 | 34 |
1505534 | 1505534 | 2021-07-11 | Pike | Indiana | 18125 | 1388 | 34 |
1502288 | 1502288 | 2021-07-10 | Pike | Indiana | 18125 | 1388 | 34 |
1499042 | 1499042 | 2021-07-09 | Pike | Indiana | 18125 | 1388 | 34 |
1495795 | 1495795 | 2021-07-08 | Pike | Indiana | 18125 | 1388 | 34 |
1492549 | 1492549 | 2021-07-07 | Pike | Indiana | 18125 | 1387 | 34 |
1489302 | 1489302 | 2021-07-06 | Pike | Indiana | 18125 | 1387 | 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);