ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 18017 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814079 | 1814079 | 2021-10-14 | Cass | Indiana | 18017 | 7459 | 121 |
1810830 | 1810830 | 2021-10-13 | Cass | Indiana | 18017 | 7439 | 121 |
1807581 | 1807581 | 2021-10-12 | Cass | Indiana | 18017 | 7417 | 121 |
1804330 | 1804330 | 2021-10-11 | Cass | Indiana | 18017 | 7407 | 121 |
1801081 | 1801081 | 2021-10-10 | Cass | Indiana | 18017 | 7382 | 121 |
1797832 | 1797832 | 2021-10-09 | Cass | Indiana | 18017 | 7382 | 121 |
1794583 | 1794583 | 2021-10-08 | Cass | Indiana | 18017 | 7382 | 121 |
1791335 | 1791335 | 2021-10-07 | Cass | Indiana | 18017 | 7365 | 121 |
1788086 | 1788086 | 2021-10-06 | Cass | Indiana | 18017 | 7340 | 121 |
1784837 | 1784837 | 2021-10-05 | Cass | Indiana | 18017 | 7337 | 121 |
1781588 | 1781588 | 2021-10-04 | Cass | Indiana | 18017 | 7330 | 120 |
1778338 | 1778338 | 2021-10-03 | Cass | Indiana | 18017 | 7301 | 120 |
1775088 | 1775088 | 2021-10-02 | Cass | Indiana | 18017 | 7301 | 120 |
1771838 | 1771838 | 2021-10-01 | Cass | Indiana | 18017 | 7301 | 120 |
1768589 | 1768589 | 2021-09-30 | Cass | Indiana | 18017 | 7294 | 120 |
1765340 | 1765340 | 2021-09-29 | Cass | Indiana | 18017 | 7274 | 120 |
1762091 | 1762091 | 2021-09-28 | Cass | Indiana | 18017 | 7260 | 120 |
1758843 | 1758843 | 2021-09-27 | Cass | Indiana | 18017 | 7251 | 120 |
1755595 | 1755595 | 2021-09-26 | Cass | Indiana | 18017 | 7225 | 120 |
1752347 | 1752347 | 2021-09-25 | Cass | Indiana | 18017 | 7225 | 120 |
1749098 | 1749098 | 2021-09-24 | Cass | Indiana | 18017 | 7225 | 120 |
1745848 | 1745848 | 2021-09-23 | Cass | Indiana | 18017 | 7215 | 119 |
1742599 | 1742599 | 2021-09-22 | Cass | Indiana | 18017 | 7182 | 119 |
1739350 | 1739350 | 2021-09-21 | Cass | Indiana | 18017 | 7166 | 119 |
1736101 | 1736101 | 2021-09-20 | Cass | Indiana | 18017 | 7145 | 119 |
1732851 | 1732851 | 2021-09-19 | Cass | Indiana | 18017 | 7102 | 119 |
1729601 | 1729601 | 2021-09-18 | Cass | Indiana | 18017 | 7102 | 119 |
1726351 | 1726351 | 2021-09-17 | Cass | Indiana | 18017 | 7102 | 119 |
1723102 | 1723102 | 2021-09-16 | Cass | Indiana | 18017 | 7081 | 119 |
1719853 | 1719853 | 2021-09-15 | Cass | Indiana | 18017 | 7065 | 119 |
1716605 | 1716605 | 2021-09-14 | Cass | Indiana | 18017 | 7035 | 119 |
1713359 | 1713359 | 2021-09-13 | Cass | Indiana | 18017 | 7009 | 119 |
1710112 | 1710112 | 2021-09-12 | Cass | Indiana | 18017 | 6932 | 119 |
1706865 | 1706865 | 2021-09-11 | Cass | Indiana | 18017 | 6932 | 119 |
1703617 | 1703617 | 2021-09-10 | Cass | Indiana | 18017 | 6932 | 119 |
1700367 | 1700367 | 2021-09-09 | Cass | Indiana | 18017 | 6892 | 119 |
1697118 | 1697118 | 2021-09-08 | Cass | Indiana | 18017 | 6851 | 119 |
1693870 | 1693870 | 2021-09-07 | Cass | Indiana | 18017 | 6828 | 119 |
1690621 | 1690621 | 2021-09-06 | Cass | Indiana | 18017 | 6727 | 119 |
1687371 | 1687371 | 2021-09-05 | Cass | Indiana | 18017 | 6727 | 119 |
1684121 | 1684121 | 2021-09-04 | Cass | Indiana | 18017 | 6727 | 119 |
1680870 | 1680870 | 2021-09-03 | Cass | Indiana | 18017 | 6727 | 119 |
1677622 | 1677622 | 2021-09-02 | Cass | Indiana | 18017 | 6687 | 118 |
1674375 | 1674375 | 2021-09-01 | Cass | Indiana | 18017 | 6635 | 118 |
1671126 | 1671126 | 2021-08-31 | Cass | Indiana | 18017 | 6603 | 117 |
1667879 | 1667879 | 2021-08-30 | Cass | Indiana | 18017 | 6577 | 117 |
1664632 | 1664632 | 2021-08-29 | Cass | Indiana | 18017 | 6498 | 116 |
1661384 | 1661384 | 2021-08-28 | Cass | Indiana | 18017 | 6498 | 116 |
1658136 | 1658136 | 2021-08-27 | Cass | Indiana | 18017 | 6498 | 116 |
1654888 | 1654888 | 2021-08-26 | Cass | Indiana | 18017 | 6467 | 116 |
1651641 | 1651641 | 2021-08-25 | Cass | Indiana | 18017 | 6426 | 116 |
1648392 | 1648392 | 2021-08-24 | Cass | Indiana | 18017 | 6404 | 116 |
1645144 | 1645144 | 2021-08-23 | Cass | Indiana | 18017 | 6390 | 115 |
1641895 | 1641895 | 2021-08-22 | Cass | Indiana | 18017 | 6354 | 115 |
1638645 | 1638645 | 2021-08-21 | Cass | Indiana | 18017 | 6354 | 115 |
1635395 | 1635395 | 2021-08-20 | Cass | Indiana | 18017 | 6354 | 115 |
1632145 | 1632145 | 2021-08-19 | Cass | Indiana | 18017 | 6339 | 115 |
1628898 | 1628898 | 2021-08-18 | Cass | Indiana | 18017 | 6325 | 115 |
1625651 | 1625651 | 2021-08-17 | Cass | Indiana | 18017 | 6315 | 115 |
1622404 | 1622404 | 2021-08-16 | Cass | Indiana | 18017 | 6300 | 115 |
1619157 | 1619157 | 2021-08-15 | Cass | Indiana | 18017 | 6264 | 114 |
1615909 | 1615909 | 2021-08-14 | Cass | Indiana | 18017 | 6264 | 114 |
1612660 | 1612660 | 2021-08-13 | Cass | Indiana | 18017 | 6264 | 114 |
1609412 | 1609412 | 2021-08-12 | Cass | Indiana | 18017 | 6241 | 114 |
1606163 | 1606163 | 2021-08-11 | Cass | Indiana | 18017 | 6226 | 114 |
1602914 | 1602914 | 2021-08-10 | Cass | Indiana | 18017 | 6221 | 114 |
1599665 | 1599665 | 2021-08-09 | Cass | Indiana | 18017 | 6203 | 114 |
1596417 | 1596417 | 2021-08-08 | Cass | Indiana | 18017 | 6173 | 114 |
1593168 | 1593168 | 2021-08-07 | Cass | Indiana | 18017 | 6173 | 114 |
1589919 | 1589919 | 2021-08-06 | Cass | Indiana | 18017 | 6173 | 114 |
1586670 | 1586670 | 2021-08-05 | Cass | Indiana | 18017 | 6156 | 114 |
1583420 | 1583420 | 2021-08-04 | Cass | Indiana | 18017 | 6141 | 114 |
1580170 | 1580170 | 2021-08-03 | Cass | Indiana | 18017 | 6135 | 114 |
1576921 | 1576921 | 2021-08-02 | Cass | Indiana | 18017 | 6126 | 114 |
1573673 | 1573673 | 2021-08-01 | Cass | Indiana | 18017 | 6115 | 114 |
1570425 | 1570425 | 2021-07-31 | Cass | Indiana | 18017 | 6115 | 114 |
1567177 | 1567177 | 2021-07-30 | Cass | Indiana | 18017 | 6115 | 114 |
1563929 | 1563929 | 2021-07-29 | Cass | Indiana | 18017 | 6106 | 114 |
1560681 | 1560681 | 2021-07-28 | Cass | Indiana | 18017 | 6101 | 114 |
1557434 | 1557434 | 2021-07-27 | Cass | Indiana | 18017 | 6095 | 113 |
1554187 | 1554187 | 2021-07-26 | Cass | Indiana | 18017 | 6090 | 113 |
1550940 | 1550940 | 2021-07-25 | Cass | Indiana | 18017 | 6088 | 113 |
1547693 | 1547693 | 2021-07-24 | Cass | Indiana | 18017 | 6088 | 113 |
1544446 | 1544446 | 2021-07-23 | Cass | Indiana | 18017 | 6088 | 113 |
1541198 | 1541198 | 2021-07-22 | Cass | Indiana | 18017 | 6088 | 113 |
1537951 | 1537951 | 2021-07-21 | Cass | Indiana | 18017 | 6086 | 113 |
1534703 | 1534703 | 2021-07-20 | Cass | Indiana | 18017 | 6083 | 113 |
1531456 | 1531456 | 2021-07-19 | Cass | Indiana | 18017 | 6078 | 113 |
1528209 | 1528209 | 2021-07-18 | Cass | Indiana | 18017 | 6074 | 113 |
1524962 | 1524962 | 2021-07-17 | Cass | Indiana | 18017 | 6074 | 113 |
1521714 | 1521714 | 2021-07-16 | Cass | Indiana | 18017 | 6074 | 113 |
1518466 | 1518466 | 2021-07-15 | Cass | Indiana | 18017 | 6073 | 113 |
1515219 | 1515219 | 2021-07-14 | Cass | Indiana | 18017 | 6070 | 113 |
1511973 | 1511973 | 2021-07-13 | Cass | Indiana | 18017 | 6068 | 112 |
1508726 | 1508726 | 2021-07-12 | Cass | Indiana | 18017 | 6060 | 112 |
1505480 | 1505480 | 2021-07-11 | Cass | Indiana | 18017 | 6059 | 112 |
1502234 | 1502234 | 2021-07-10 | Cass | Indiana | 18017 | 6059 | 112 |
1498988 | 1498988 | 2021-07-09 | Cass | Indiana | 18017 | 6059 | 112 |
1495741 | 1495741 | 2021-07-08 | Cass | Indiana | 18017 | 6057 | 112 |
1492495 | 1492495 | 2021-07-07 | Cass | Indiana | 18017 | 6054 | 112 |
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);