ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
885 rows where deaths = 11 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Ohio 236
- Union 200
- Newton 118
- LaGrange 46
- Scott 30
- Switzerland 30
- Jackson 17
- Martin 15
- White 15
- Vigo 13
- Posey 11
- Jennings 10
- Putnam 9
- Tippecanoe 8
- Benton 7
- Randolph 6
- Hancock 5
- Sullivan 5
- Adams 4
- Cass 4
- Gibson 4
- Perry 4
- Starke 4
- Washington 4
- Boone 3
- Carroll 3
- Clinton 3
- Delaware 3
- Franklin 3
- Greene 3
- …
state 1
- Indiana · 885 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1882379 | 1882379 | 2021-11-04 | Switzerland | Indiana | 18155 | 1373 | 11 |
1879130 | 1879130 | 2021-11-03 | Switzerland | Indiana | 18155 | 1372 | 11 |
1875881 | 1875881 | 2021-11-02 | Switzerland | Indiana | 18155 | 1369 | 11 |
1872632 | 1872632 | 2021-11-01 | Switzerland | Indiana | 18155 | 1367 | 11 |
1869383 | 1869383 | 2021-10-31 | Switzerland | Indiana | 18155 | 1366 | 11 |
1866134 | 1866134 | 2021-10-30 | Switzerland | Indiana | 18155 | 1366 | 11 |
1862885 | 1862885 | 2021-10-29 | Switzerland | Indiana | 18155 | 1366 | 11 |
1859636 | 1859636 | 2021-10-28 | Switzerland | Indiana | 18155 | 1365 | 11 |
1856387 | 1856387 | 2021-10-27 | Switzerland | Indiana | 18155 | 1361 | 11 |
1853138 | 1853138 | 2021-10-26 | Switzerland | Indiana | 18155 | 1357 | 11 |
1849889 | 1849889 | 2021-10-25 | Switzerland | Indiana | 18155 | 1354 | 11 |
1846639 | 1846639 | 2021-10-24 | Switzerland | Indiana | 18155 | 1351 | 11 |
1843389 | 1843389 | 2021-10-23 | Switzerland | Indiana | 18155 | 1351 | 11 |
1840139 | 1840139 | 2021-10-22 | Switzerland | Indiana | 18155 | 1351 | 11 |
1836890 | 1836890 | 2021-10-21 | Switzerland | Indiana | 18155 | 1350 | 11 |
1833641 | 1833641 | 2021-10-20 | Switzerland | Indiana | 18155 | 1349 | 11 |
1830392 | 1830392 | 2021-10-19 | Switzerland | Indiana | 18155 | 1344 | 11 |
1827143 | 1827143 | 2021-10-18 | Switzerland | Indiana | 18155 | 1343 | 11 |
1823894 | 1823894 | 2021-10-17 | Switzerland | Indiana | 18155 | 1340 | 11 |
1820645 | 1820645 | 2021-10-16 | Switzerland | Indiana | 18155 | 1340 | 11 |
1817396 | 1817396 | 2021-10-15 | Switzerland | Indiana | 18155 | 1340 | 11 |
1814148 | 1814148 | 2021-10-14 | Switzerland | Indiana | 18155 | 1335 | 11 |
1810899 | 1810899 | 2021-10-13 | Switzerland | Indiana | 18155 | 1331 | 11 |
1807650 | 1807650 | 2021-10-12 | Switzerland | Indiana | 18155 | 1330 | 11 |
1804399 | 1804399 | 2021-10-11 | Switzerland | Indiana | 18155 | 1328 | 11 |
1801150 | 1801150 | 2021-10-10 | Switzerland | Indiana | 18155 | 1319 | 11 |
1797901 | 1797901 | 2021-10-09 | Switzerland | Indiana | 18155 | 1319 | 11 |
1794652 | 1794652 | 2021-10-08 | Switzerland | Indiana | 18155 | 1319 | 11 |
1791404 | 1791404 | 2021-10-07 | Switzerland | Indiana | 18155 | 1314 | 11 |
1788155 | 1788155 | 2021-10-06 | Switzerland | Indiana | 18155 | 1312 | 11 |
1778387 | 1778387 | 2021-10-03 | Ohio | Indiana | 18115 | 818 | 11 |
1775137 | 1775137 | 2021-10-02 | Ohio | Indiana | 18115 | 818 | 11 |
1771887 | 1771887 | 2021-10-01 | Ohio | Indiana | 18115 | 818 | 11 |
1768638 | 1768638 | 2021-09-30 | Ohio | Indiana | 18115 | 817 | 11 |
1765389 | 1765389 | 2021-09-29 | Ohio | Indiana | 18115 | 814 | 11 |
1762140 | 1762140 | 2021-09-28 | Ohio | Indiana | 18115 | 812 | 11 |
1758892 | 1758892 | 2021-09-27 | Ohio | Indiana | 18115 | 809 | 11 |
1755644 | 1755644 | 2021-09-26 | Ohio | Indiana | 18115 | 805 | 11 |
1752396 | 1752396 | 2021-09-25 | Ohio | Indiana | 18115 | 805 | 11 |
1749147 | 1749147 | 2021-09-24 | Ohio | Indiana | 18115 | 805 | 11 |
1745897 | 1745897 | 2021-09-23 | Ohio | Indiana | 18115 | 801 | 11 |
1742648 | 1742648 | 2021-09-22 | Ohio | Indiana | 18115 | 797 | 11 |
1739399 | 1739399 | 2021-09-21 | Ohio | Indiana | 18115 | 785 | 11 |
1736150 | 1736150 | 2021-09-20 | Ohio | Indiana | 18115 | 781 | 11 |
1732900 | 1732900 | 2021-09-19 | Ohio | Indiana | 18115 | 772 | 11 |
1729650 | 1729650 | 2021-09-18 | Ohio | Indiana | 18115 | 772 | 11 |
1726400 | 1726400 | 2021-09-17 | Ohio | Indiana | 18115 | 772 | 11 |
1723151 | 1723151 | 2021-09-16 | Ohio | Indiana | 18115 | 761 | 11 |
1719902 | 1719902 | 2021-09-15 | Ohio | Indiana | 18115 | 758 | 11 |
1716654 | 1716654 | 2021-09-14 | Ohio | Indiana | 18115 | 749 | 11 |
1713408 | 1713408 | 2021-09-13 | Ohio | Indiana | 18115 | 744 | 11 |
1713431 | 1713431 | 2021-09-13 | Union | Indiana | 18161 | 939 | 11 |
1710161 | 1710161 | 2021-09-12 | Ohio | Indiana | 18115 | 738 | 11 |
1710184 | 1710184 | 2021-09-12 | Union | Indiana | 18161 | 921 | 11 |
1706914 | 1706914 | 2021-09-11 | Ohio | Indiana | 18115 | 738 | 11 |
1706937 | 1706937 | 2021-09-11 | Union | Indiana | 18161 | 921 | 11 |
1703666 | 1703666 | 2021-09-10 | Ohio | Indiana | 18115 | 738 | 11 |
1703689 | 1703689 | 2021-09-10 | Union | Indiana | 18161 | 921 | 11 |
1700416 | 1700416 | 2021-09-09 | Ohio | Indiana | 18115 | 735 | 11 |
1700439 | 1700439 | 2021-09-09 | Union | Indiana | 18161 | 914 | 11 |
1697167 | 1697167 | 2021-09-08 | Ohio | Indiana | 18115 | 730 | 11 |
1697190 | 1697190 | 2021-09-08 | Union | Indiana | 18161 | 905 | 11 |
1693919 | 1693919 | 2021-09-07 | Ohio | Indiana | 18115 | 726 | 11 |
1693942 | 1693942 | 2021-09-07 | Union | Indiana | 18161 | 897 | 11 |
1690670 | 1690670 | 2021-09-06 | Ohio | Indiana | 18115 | 707 | 11 |
1690693 | 1690693 | 2021-09-06 | Union | Indiana | 18161 | 887 | 11 |
1687420 | 1687420 | 2021-09-05 | Ohio | Indiana | 18115 | 707 | 11 |
1687443 | 1687443 | 2021-09-05 | Union | Indiana | 18161 | 887 | 11 |
1684170 | 1684170 | 2021-09-04 | Ohio | Indiana | 18115 | 707 | 11 |
1684193 | 1684193 | 2021-09-04 | Union | Indiana | 18161 | 887 | 11 |
1680919 | 1680919 | 2021-09-03 | Ohio | Indiana | 18115 | 707 | 11 |
1680942 | 1680942 | 2021-09-03 | Union | Indiana | 18161 | 887 | 11 |
1677671 | 1677671 | 2021-09-02 | Ohio | Indiana | 18115 | 707 | 11 |
1677694 | 1677694 | 2021-09-02 | Union | Indiana | 18161 | 882 | 11 |
1674424 | 1674424 | 2021-09-01 | Ohio | Indiana | 18115 | 701 | 11 |
1674447 | 1674447 | 2021-09-01 | Union | Indiana | 18161 | 878 | 11 |
1671175 | 1671175 | 2021-08-31 | Ohio | Indiana | 18115 | 697 | 11 |
1671198 | 1671198 | 2021-08-31 | Union | Indiana | 18161 | 873 | 11 |
1667928 | 1667928 | 2021-08-30 | Ohio | Indiana | 18115 | 688 | 11 |
1667951 | 1667951 | 2021-08-30 | Union | Indiana | 18161 | 869 | 11 |
1664681 | 1664681 | 2021-08-29 | Ohio | Indiana | 18115 | 683 | 11 |
1664704 | 1664704 | 2021-08-29 | Union | Indiana | 18161 | 854 | 11 |
1661433 | 1661433 | 2021-08-28 | Ohio | Indiana | 18115 | 683 | 11 |
1661456 | 1661456 | 2021-08-28 | Union | Indiana | 18161 | 854 | 11 |
1658185 | 1658185 | 2021-08-27 | Ohio | Indiana | 18115 | 683 | 11 |
1658208 | 1658208 | 2021-08-27 | Union | Indiana | 18161 | 854 | 11 |
1654937 | 1654937 | 2021-08-26 | Ohio | Indiana | 18115 | 680 | 11 |
1654960 | 1654960 | 2021-08-26 | Union | Indiana | 18161 | 847 | 11 |
1651690 | 1651690 | 2021-08-25 | Ohio | Indiana | 18115 | 669 | 11 |
1651713 | 1651713 | 2021-08-25 | Union | Indiana | 18161 | 842 | 11 |
1648441 | 1648441 | 2021-08-24 | Ohio | Indiana | 18115 | 655 | 11 |
1648464 | 1648464 | 2021-08-24 | Union | Indiana | 18161 | 836 | 11 |
1645193 | 1645193 | 2021-08-23 | Ohio | Indiana | 18115 | 652 | 11 |
1645216 | 1645216 | 2021-08-23 | Union | Indiana | 18161 | 832 | 11 |
1641944 | 1641944 | 2021-08-22 | Ohio | Indiana | 18115 | 644 | 11 |
1641967 | 1641967 | 2021-08-22 | Union | Indiana | 18161 | 820 | 11 |
1638694 | 1638694 | 2021-08-21 | Ohio | Indiana | 18115 | 644 | 11 |
1638717 | 1638717 | 2021-08-21 | Union | Indiana | 18161 | 820 | 11 |
1635444 | 1635444 | 2021-08-20 | Ohio | Indiana | 18115 | 644 | 11 |
1635467 | 1635467 | 2021-08-20 | Union | Indiana | 18161 | 820 | 11 |
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);