ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
486 rows where deaths = 22 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 |
---|---|---|---|---|---|---|---|
2126178 | 2126178 | 2022-01-18 | Warren | Indiana | 18171 | 1711 | 22 |
2122891 | 2122891 | 2022-01-17 | Martin | Indiana | 18101 | 1821 | 22 |
2122926 | 2122926 | 2022-01-17 | Warren | Indiana | 18171 | 1698 | 22 |
2119674 | 2119674 | 2022-01-16 | Warren | Indiana | 18171 | 1669 | 22 |
2116422 | 2116422 | 2022-01-15 | Warren | Indiana | 18171 | 1669 | 22 |
2113171 | 2113171 | 2022-01-14 | Warren | Indiana | 18171 | 1669 | 22 |
2109919 | 2109919 | 2022-01-13 | Warren | Indiana | 18171 | 1663 | 22 |
2106668 | 2106668 | 2022-01-12 | Warren | Indiana | 18171 | 1642 | 22 |
2103417 | 2103417 | 2022-01-11 | Warren | Indiana | 18171 | 1630 | 22 |
2100166 | 2100166 | 2022-01-10 | Warren | Indiana | 18171 | 1611 | 22 |
2096915 | 2096915 | 2022-01-09 | Warren | Indiana | 18171 | 1585 | 22 |
2093663 | 2093663 | 2022-01-08 | Warren | Indiana | 18171 | 1585 | 22 |
2090411 | 2090411 | 2022-01-07 | Warren | Indiana | 18171 | 1585 | 22 |
2087160 | 2087160 | 2022-01-06 | Warren | Indiana | 18171 | 1573 | 22 |
2083908 | 2083908 | 2022-01-05 | Warren | Indiana | 18171 | 1562 | 22 |
2080656 | 2080656 | 2022-01-04 | Warren | Indiana | 18171 | 1559 | 22 |
2077404 | 2077404 | 2022-01-03 | Warren | Indiana | 18171 | 1548 | 22 |
2074153 | 2074153 | 2022-01-02 | Warren | Indiana | 18171 | 1538 | 22 |
2070902 | 2070902 | 2022-01-01 | Warren | Indiana | 18171 | 1538 | 22 |
2067651 | 2067651 | 2021-12-31 | Warren | Indiana | 18171 | 1538 | 22 |
2064400 | 2064400 | 2021-12-30 | Warren | Indiana | 18171 | 1538 | 22 |
2061150 | 2061150 | 2021-12-29 | Warren | Indiana | 18171 | 1528 | 22 |
2057901 | 2057901 | 2021-12-28 | Warren | Indiana | 18171 | 1523 | 22 |
2054652 | 2054652 | 2021-12-27 | Warren | Indiana | 18171 | 1520 | 22 |
2051402 | 2051402 | 2021-12-26 | Warren | Indiana | 18171 | 1499 | 22 |
2048152 | 2048152 | 2021-12-25 | Warren | Indiana | 18171 | 1499 | 22 |
2044902 | 2044902 | 2021-12-24 | Warren | Indiana | 18171 | 1499 | 22 |
2041653 | 2041653 | 2021-12-23 | Warren | Indiana | 18171 | 1499 | 22 |
2038403 | 2038403 | 2021-12-22 | Warren | Indiana | 18171 | 1499 | 22 |
2035153 | 2035153 | 2021-12-21 | Warren | Indiana | 18171 | 1494 | 22 |
2031903 | 2031903 | 2021-12-20 | Warren | Indiana | 18171 | 1492 | 22 |
2028652 | 2028652 | 2021-12-19 | Warren | Indiana | 18171 | 1473 | 22 |
2025401 | 2025401 | 2021-12-18 | Warren | Indiana | 18171 | 1473 | 22 |
2022150 | 2022150 | 2021-12-17 | Warren | Indiana | 18171 | 1473 | 22 |
1804334 | 1804334 | 2021-10-11 | Crawford | Indiana | 18025 | 1565 | 22 |
1801085 | 1801085 | 2021-10-10 | Crawford | Indiana | 18025 | 1553 | 22 |
1797836 | 1797836 | 2021-10-09 | Crawford | Indiana | 18025 | 1553 | 22 |
1794587 | 1794587 | 2021-10-08 | Crawford | Indiana | 18025 | 1553 | 22 |
1791339 | 1791339 | 2021-10-07 | Crawford | Indiana | 18025 | 1540 | 22 |
1788090 | 1788090 | 2021-10-06 | Crawford | Indiana | 18025 | 1533 | 22 |
1784841 | 1784841 | 2021-10-05 | Crawford | Indiana | 18025 | 1531 | 22 |
1762143 | 1762143 | 2021-09-28 | Parke | Indiana | 18121 | 2245 | 22 |
1460034 | 1460034 | 2021-06-27 | Carroll | Indiana | 18015 | 1941 | 22 |
1456789 | 1456789 | 2021-06-26 | Carroll | Indiana | 18015 | 1941 | 22 |
1453544 | 1453544 | 2021-06-25 | Carroll | Indiana | 18015 | 1941 | 22 |
1450298 | 1450298 | 2021-06-24 | Carroll | Indiana | 18015 | 1940 | 22 |
1447053 | 1447053 | 2021-06-23 | Carroll | Indiana | 18015 | 1940 | 22 |
1443808 | 1443808 | 2021-06-22 | Carroll | Indiana | 18015 | 1940 | 22 |
1440563 | 1440563 | 2021-06-21 | Carroll | Indiana | 18015 | 1939 | 22 |
1437316 | 1437316 | 2021-06-20 | Carroll | Indiana | 18015 | 1938 | 22 |
1434069 | 1434069 | 2021-06-19 | Carroll | Indiana | 18015 | 1938 | 22 |
1430823 | 1430823 | 2021-06-18 | Carroll | Indiana | 18015 | 1936 | 22 |
1427578 | 1427578 | 2021-06-17 | Carroll | Indiana | 18015 | 1936 | 22 |
1424333 | 1424333 | 2021-06-16 | Carroll | Indiana | 18015 | 1936 | 22 |
1421085 | 1421085 | 2021-06-15 | Carroll | Indiana | 18015 | 1936 | 22 |
1417840 | 1417840 | 2021-06-14 | Carroll | Indiana | 18015 | 1936 | 22 |
1414594 | 1414594 | 2021-06-13 | Carroll | Indiana | 18015 | 1936 | 22 |
1411349 | 1411349 | 2021-06-12 | Carroll | Indiana | 18015 | 1936 | 22 |
1408104 | 1408104 | 2021-06-11 | Carroll | Indiana | 18015 | 1936 | 22 |
1404858 | 1404858 | 2021-06-10 | Carroll | Indiana | 18015 | 1935 | 22 |
1401613 | 1401613 | 2021-06-09 | Carroll | Indiana | 18015 | 1934 | 22 |
1398368 | 1398368 | 2021-06-08 | Carroll | Indiana | 18015 | 1934 | 22 |
1395121 | 1395121 | 2021-06-07 | Carroll | Indiana | 18015 | 1933 | 22 |
1391876 | 1391876 | 2021-06-06 | Carroll | Indiana | 18015 | 1932 | 22 |
1388631 | 1388631 | 2021-06-05 | Carroll | Indiana | 18015 | 1932 | 22 |
1385386 | 1385386 | 2021-06-04 | Carroll | Indiana | 18015 | 1932 | 22 |
1382140 | 1382140 | 2021-06-03 | Carroll | Indiana | 18015 | 1932 | 22 |
1378895 | 1378895 | 2021-06-02 | Carroll | Indiana | 18015 | 1932 | 22 |
1375649 | 1375649 | 2021-06-01 | Carroll | Indiana | 18015 | 1930 | 22 |
1372404 | 1372404 | 2021-05-31 | Carroll | Indiana | 18015 | 1928 | 22 |
1369159 | 1369159 | 2021-05-30 | Carroll | Indiana | 18015 | 1928 | 22 |
1365913 | 1365913 | 2021-05-29 | Carroll | Indiana | 18015 | 1925 | 22 |
1362667 | 1362667 | 2021-05-28 | Carroll | Indiana | 18015 | 1923 | 22 |
1359420 | 1359420 | 2021-05-27 | Carroll | Indiana | 18015 | 1921 | 22 |
1356174 | 1356174 | 2021-05-26 | Carroll | Indiana | 18015 | 1920 | 22 |
1352928 | 1352928 | 2021-05-25 | Carroll | Indiana | 18015 | 1920 | 22 |
1349682 | 1349682 | 2021-05-24 | Carroll | Indiana | 18015 | 1918 | 22 |
1346435 | 1346435 | 2021-05-23 | Carroll | Indiana | 18015 | 1916 | 22 |
1343187 | 1343187 | 2021-05-22 | Carroll | Indiana | 18015 | 1915 | 22 |
1339939 | 1339939 | 2021-05-21 | Carroll | Indiana | 18015 | 1914 | 22 |
1336692 | 1336692 | 2021-05-20 | Carroll | Indiana | 18015 | 1914 | 22 |
1333445 | 1333445 | 2021-05-19 | Carroll | Indiana | 18015 | 1911 | 22 |
1330198 | 1330198 | 2021-05-18 | Carroll | Indiana | 18015 | 1908 | 22 |
1326951 | 1326951 | 2021-05-17 | Carroll | Indiana | 18015 | 1906 | 22 |
1323705 | 1323705 | 2021-05-16 | Carroll | Indiana | 18015 | 1904 | 22 |
1320459 | 1320459 | 2021-05-15 | Carroll | Indiana | 18015 | 1903 | 22 |
1317212 | 1317212 | 2021-05-14 | Carroll | Indiana | 18015 | 1898 | 22 |
1313965 | 1313965 | 2021-05-13 | Carroll | Indiana | 18015 | 1896 | 22 |
1310718 | 1310718 | 2021-05-12 | Carroll | Indiana | 18015 | 1896 | 22 |
1307472 | 1307472 | 2021-05-11 | Carroll | Indiana | 18015 | 1895 | 22 |
1304226 | 1304226 | 2021-05-10 | Carroll | Indiana | 18015 | 1888 | 22 |
1300979 | 1300979 | 2021-05-09 | Carroll | Indiana | 18015 | 1887 | 22 |
1297732 | 1297732 | 2021-05-08 | Carroll | Indiana | 18015 | 1887 | 22 |
1294486 | 1294486 | 2021-05-07 | Carroll | Indiana | 18015 | 1885 | 22 |
1291240 | 1291240 | 2021-05-06 | Carroll | Indiana | 18015 | 1883 | 22 |
1287994 | 1287994 | 2021-05-05 | Carroll | Indiana | 18015 | 1880 | 22 |
1284748 | 1284748 | 2021-05-04 | Carroll | Indiana | 18015 | 1880 | 22 |
1281501 | 1281501 | 2021-05-03 | Carroll | Indiana | 18015 | 1880 | 22 |
1278254 | 1278254 | 2021-05-02 | Carroll | Indiana | 18015 | 1878 | 22 |
1275007 | 1275007 | 2021-05-01 | Carroll | Indiana | 18015 | 1879 | 22 |
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);