ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
477 rows where deaths = 18 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2269281 | 2269281 | 2022-03-03 | Switzerland | Indiana | 18155 | 2302 | 18 |
2246502 | 2246502 | 2022-02-24 | Ohio | Indiana | 18115 | 1437 | 18 |
2243251 | 2243251 | 2022-02-23 | Ohio | Indiana | 18115 | 1437 | 18 |
2240000 | 2240000 | 2022-02-22 | Ohio | Indiana | 18115 | 1437 | 18 |
2236749 | 2236749 | 2022-02-21 | Ohio | Indiana | 18115 | 1437 | 18 |
2233498 | 2233498 | 2022-02-20 | Ohio | Indiana | 18115 | 1436 | 18 |
2230247 | 2230247 | 2022-02-19 | Ohio | Indiana | 18115 | 1436 | 18 |
2226996 | 2226996 | 2022-02-18 | Ohio | Indiana | 18115 | 1436 | 18 |
2223745 | 2223745 | 2022-02-17 | Ohio | Indiana | 18115 | 1435 | 18 |
2220494 | 2220494 | 2022-02-16 | Ohio | Indiana | 18115 | 1434 | 18 |
2051397 | 2051397 | 2021-12-26 | Union | Indiana | 18161 | 1387 | 18 |
2048147 | 2048147 | 2021-12-25 | Union | Indiana | 18161 | 1387 | 18 |
2044897 | 2044897 | 2021-12-24 | Union | Indiana | 18161 | 1387 | 18 |
2041648 | 2041648 | 2021-12-23 | Union | Indiana | 18161 | 1387 | 18 |
2038398 | 2038398 | 2021-12-22 | Union | Indiana | 18161 | 1387 | 18 |
2035148 | 2035148 | 2021-12-21 | Union | Indiana | 18161 | 1374 | 18 |
2031821 | 2031821 | 2021-12-20 | Benton | Indiana | 18007 | 1811 | 18 |
2031898 | 2031898 | 2021-12-20 | Union | Indiana | 18161 | 1370 | 18 |
2028570 | 2028570 | 2021-12-19 | Benton | Indiana | 18007 | 1789 | 18 |
2028647 | 2028647 | 2021-12-19 | Union | Indiana | 18161 | 1351 | 18 |
2025319 | 2025319 | 2021-12-18 | Benton | Indiana | 18007 | 1789 | 18 |
2025396 | 2025396 | 2021-12-18 | Union | Indiana | 18161 | 1351 | 18 |
2022068 | 2022068 | 2021-12-17 | Benton | Indiana | 18007 | 1789 | 18 |
2022145 | 2022145 | 2021-12-17 | Union | Indiana | 18161 | 1351 | 18 |
2018817 | 2018817 | 2021-12-16 | Benton | Indiana | 18007 | 1779 | 18 |
2015567 | 2015567 | 2021-12-15 | Benton | Indiana | 18007 | 1768 | 18 |
2012316 | 2012316 | 2021-12-14 | Benton | Indiana | 18007 | 1773 | 18 |
2009065 | 2009065 | 2021-12-13 | Benton | Indiana | 18007 | 1766 | 18 |
2005814 | 2005814 | 2021-12-12 | Benton | Indiana | 18007 | 1743 | 18 |
2002563 | 2002563 | 2021-12-11 | Benton | Indiana | 18007 | 1743 | 18 |
1999313 | 1999313 | 2021-12-10 | Benton | Indiana | 18007 | 1743 | 18 |
1996062 | 1996062 | 2021-12-09 | Benton | Indiana | 18007 | 1731 | 18 |
1992811 | 1992811 | 2021-12-08 | Benton | Indiana | 18007 | 1722 | 18 |
1989560 | 1989560 | 2021-12-07 | Benton | Indiana | 18007 | 1719 | 18 |
1986392 | 1986392 | 2021-12-06 | Warren | Indiana | 18171 | 1381 | 18 |
1983142 | 1983142 | 2021-12-05 | Warren | Indiana | 18171 | 1361 | 18 |
1979892 | 1979892 | 2021-12-04 | Warren | Indiana | 18171 | 1361 | 18 |
1976642 | 1976642 | 2021-12-03 | Warren | Indiana | 18171 | 1361 | 18 |
1973393 | 1973393 | 2021-12-02 | Warren | Indiana | 18171 | 1356 | 18 |
1970143 | 1970143 | 2021-12-01 | Warren | Indiana | 18171 | 1342 | 18 |
1966893 | 1966893 | 2021-11-30 | Warren | Indiana | 18171 | 1326 | 18 |
1963641 | 1963641 | 2021-11-29 | Warren | Indiana | 18171 | 1325 | 18 |
1960390 | 1960390 | 2021-11-28 | Warren | Indiana | 18171 | 1317 | 18 |
1957139 | 1957139 | 2021-11-27 | Warren | Indiana | 18171 | 1317 | 18 |
1953888 | 1953888 | 2021-11-26 | Warren | Indiana | 18171 | 1317 | 18 |
1950637 | 1950637 | 2021-11-25 | Warren | Indiana | 18171 | 1317 | 18 |
1947386 | 1947386 | 2021-11-24 | Warren | Indiana | 18171 | 1317 | 18 |
1944135 | 1944135 | 2021-11-23 | Warren | Indiana | 18171 | 1312 | 18 |
1940885 | 1940885 | 2021-11-22 | Warren | Indiana | 18171 | 1307 | 18 |
1937635 | 1937635 | 2021-11-21 | Warren | Indiana | 18171 | 1297 | 18 |
1934385 | 1934385 | 2021-11-20 | Warren | Indiana | 18171 | 1297 | 18 |
1931134 | 1931134 | 2021-11-19 | Warren | Indiana | 18171 | 1297 | 18 |
1927883 | 1927883 | 2021-11-18 | Warren | Indiana | 18171 | 1295 | 18 |
1924633 | 1924633 | 2021-11-17 | Warren | Indiana | 18171 | 1281 | 18 |
1921384 | 1921384 | 2021-11-16 | Warren | Indiana | 18171 | 1274 | 18 |
1918134 | 1918134 | 2021-11-15 | Warren | Indiana | 18171 | 1268 | 18 |
1914884 | 1914884 | 2021-11-14 | Warren | Indiana | 18171 | 1263 | 18 |
1911634 | 1911634 | 2021-11-13 | Warren | Indiana | 18171 | 1263 | 18 |
1908385 | 1908385 | 2021-11-12 | Warren | Indiana | 18171 | 1263 | 18 |
1905136 | 1905136 | 2021-11-11 | Warren | Indiana | 18171 | 1263 | 18 |
1901886 | 1901886 | 2021-11-10 | Warren | Indiana | 18171 | 1252 | 18 |
1898636 | 1898636 | 2021-11-09 | Warren | Indiana | 18171 | 1250 | 18 |
1895386 | 1895386 | 2021-11-08 | Warren | Indiana | 18171 | 1244 | 18 |
1892136 | 1892136 | 2021-11-07 | Warren | Indiana | 18171 | 1238 | 18 |
1888886 | 1888886 | 2021-11-06 | Warren | Indiana | 18171 | 1238 | 18 |
1885636 | 1885636 | 2021-11-05 | Warren | Indiana | 18171 | 1238 | 18 |
1882387 | 1882387 | 2021-11-04 | Warren | Indiana | 18171 | 1237 | 18 |
1879138 | 1879138 | 2021-11-03 | Warren | Indiana | 18171 | 1236 | 18 |
1875889 | 1875889 | 2021-11-02 | Warren | Indiana | 18171 | 1230 | 18 |
1872640 | 1872640 | 2021-11-01 | Warren | Indiana | 18171 | 1227 | 18 |
1869391 | 1869391 | 2021-10-31 | Warren | Indiana | 18171 | 1225 | 18 |
1866142 | 1866142 | 2021-10-30 | Warren | Indiana | 18171 | 1225 | 18 |
1862893 | 1862893 | 2021-10-29 | Warren | Indiana | 18171 | 1225 | 18 |
1859644 | 1859644 | 2021-10-28 | Warren | Indiana | 18171 | 1223 | 18 |
1856395 | 1856395 | 2021-10-27 | Warren | Indiana | 18171 | 1219 | 18 |
1853146 | 1853146 | 2021-10-26 | Warren | Indiana | 18171 | 1217 | 18 |
1849897 | 1849897 | 2021-10-25 | Warren | Indiana | 18171 | 1217 | 18 |
1846647 | 1846647 | 2021-10-24 | Warren | Indiana | 18171 | 1214 | 18 |
1843397 | 1843397 | 2021-10-23 | Warren | Indiana | 18171 | 1214 | 18 |
1840147 | 1840147 | 2021-10-22 | Warren | Indiana | 18171 | 1214 | 18 |
1836898 | 1836898 | 2021-10-21 | Warren | Indiana | 18171 | 1213 | 18 |
1833649 | 1833649 | 2021-10-20 | Warren | Indiana | 18171 | 1211 | 18 |
1830400 | 1830400 | 2021-10-19 | Warren | Indiana | 18171 | 1209 | 18 |
1827151 | 1827151 | 2021-10-18 | Warren | Indiana | 18171 | 1208 | 18 |
1823902 | 1823902 | 2021-10-17 | Warren | Indiana | 18171 | 1204 | 18 |
1820653 | 1820653 | 2021-10-16 | Warren | Indiana | 18171 | 1204 | 18 |
1817404 | 1817404 | 2021-10-15 | Warren | Indiana | 18171 | 1204 | 18 |
1814156 | 1814156 | 2021-10-14 | Warren | Indiana | 18171 | 1202 | 18 |
1810907 | 1810907 | 2021-10-13 | Warren | Indiana | 18171 | 1193 | 18 |
1807658 | 1807658 | 2021-10-12 | Warren | Indiana | 18171 | 1193 | 18 |
1804407 | 1804407 | 2021-10-11 | Warren | Indiana | 18171 | 1190 | 18 |
1801158 | 1801158 | 2021-10-10 | Warren | Indiana | 18171 | 1184 | 18 |
1797909 | 1797909 | 2021-10-09 | Warren | Indiana | 18171 | 1184 | 18 |
1794660 | 1794660 | 2021-10-08 | Warren | Indiana | 18171 | 1184 | 18 |
1791412 | 1791412 | 2021-10-07 | Warren | Indiana | 18171 | 1180 | 18 |
1788163 | 1788163 | 2021-10-06 | Warren | Indiana | 18171 | 1179 | 18 |
1784914 | 1784914 | 2021-10-05 | Warren | Indiana | 18171 | 1179 | 18 |
1781665 | 1781665 | 2021-10-04 | Warren | Indiana | 18171 | 1176 | 18 |
1778415 | 1778415 | 2021-10-03 | Warren | Indiana | 18171 | 1176 | 18 |
1775165 | 1775165 | 2021-10-02 | Warren | Indiana | 18171 | 1176 | 18 |
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);