ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
413 rows where deaths = 42 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 |
---|---|---|---|---|---|---|---|
2168454 | 2168454 | 2022-01-31 | Parke | Indiana | 18121 | 3460 | 42 |
2168463 | 2168463 | 2022-01-31 | Rush | Indiana | 18139 | 4660 | 42 |
2165199 | 2165199 | 2022-01-30 | Parke | Indiana | 18121 | 3432 | 42 |
2165208 | 2165208 | 2022-01-30 | Rush | Indiana | 18139 | 4577 | 42 |
2161944 | 2161944 | 2022-01-29 | Parke | Indiana | 18121 | 3432 | 42 |
2161953 | 2161953 | 2022-01-29 | Rush | Indiana | 18139 | 4577 | 42 |
2158689 | 2158689 | 2022-01-28 | Parke | Indiana | 18121 | 3432 | 42 |
2158698 | 2158698 | 2022-01-28 | Rush | Indiana | 18139 | 4577 | 42 |
1996066 | 1996066 | 2021-12-09 | Carroll | Indiana | 18015 | 3072 | 42 |
1992815 | 1992815 | 2021-12-08 | Carroll | Indiana | 18015 | 3050 | 42 |
1989564 | 1989564 | 2021-12-07 | Carroll | Indiana | 18015 | 3026 | 42 |
1986314 | 1986314 | 2021-12-06 | Carroll | Indiana | 18015 | 3019 | 42 |
1983064 | 1983064 | 2021-12-05 | Carroll | Indiana | 18015 | 2965 | 42 |
1979814 | 1979814 | 2021-12-04 | Carroll | Indiana | 18015 | 2965 | 42 |
1976564 | 1976564 | 2021-12-03 | Carroll | Indiana | 18015 | 2965 | 42 |
1973315 | 1973315 | 2021-12-02 | Carroll | Indiana | 18015 | 2945 | 42 |
1970065 | 1970065 | 2021-12-01 | Carroll | Indiana | 18015 | 2921 | 42 |
1833568 | 1833568 | 2021-10-20 | Blackford | Indiana | 18009 | 1930 | 42 |
1830319 | 1830319 | 2021-10-19 | Blackford | Indiana | 18009 | 1923 | 42 |
1830387 | 1830387 | 2021-10-19 | Spencer | Indiana | 18147 | 3378 | 42 |
1827138 | 1827138 | 2021-10-18 | Spencer | Indiana | 18147 | 3375 | 42 |
1823889 | 1823889 | 2021-10-17 | Spencer | Indiana | 18147 | 3366 | 42 |
1820640 | 1820640 | 2021-10-16 | Spencer | Indiana | 18147 | 3366 | 42 |
1817391 | 1817391 | 2021-10-15 | Spencer | Indiana | 18147 | 3366 | 42 |
1814143 | 1814143 | 2021-10-14 | Spencer | Indiana | 18147 | 3360 | 42 |
1810886 | 1810886 | 2021-10-13 | Posey | Indiana | 18129 | 3731 | 42 |
1810894 | 1810894 | 2021-10-13 | Spencer | Indiana | 18147 | 3354 | 42 |
1807637 | 1807637 | 2021-10-12 | Posey | Indiana | 18129 | 3715 | 42 |
1804386 | 1804386 | 2021-10-11 | Posey | Indiana | 18129 | 3714 | 42 |
1801135 | 1801135 | 2021-10-10 | Pike | Indiana | 18125 | 2242 | 42 |
1801137 | 1801137 | 2021-10-10 | Posey | Indiana | 18129 | 3707 | 42 |
1797886 | 1797886 | 2021-10-09 | Pike | Indiana | 18125 | 2242 | 42 |
1797888 | 1797888 | 2021-10-09 | Posey | Indiana | 18129 | 3707 | 42 |
1794637 | 1794637 | 2021-10-08 | Pike | Indiana | 18125 | 2242 | 42 |
1794639 | 1794639 | 2021-10-08 | Posey | Indiana | 18129 | 3707 | 42 |
1791389 | 1791389 | 2021-10-07 | Pike | Indiana | 18125 | 2228 | 42 |
1791391 | 1791391 | 2021-10-07 | Posey | Indiana | 18129 | 3701 | 42 |
1788140 | 1788140 | 2021-10-06 | Pike | Indiana | 18125 | 2219 | 42 |
1788142 | 1788142 | 2021-10-06 | Posey | Indiana | 18129 | 3693 | 42 |
1762120 | 1762120 | 2021-09-28 | Jay | Indiana | 18075 | 2627 | 42 |
1758872 | 1758872 | 2021-09-27 | Jay | Indiana | 18075 | 2613 | 42 |
1755624 | 1755624 | 2021-09-26 | Jay | Indiana | 18075 | 2583 | 42 |
1752376 | 1752376 | 2021-09-25 | Jay | Indiana | 18075 | 2583 | 42 |
1749127 | 1749127 | 2021-09-24 | Jay | Indiana | 18075 | 2583 | 42 |
1745877 | 1745877 | 2021-09-23 | Jay | Indiana | 18075 | 2576 | 42 |
1690668 | 1690668 | 2021-09-06 | Newton | Indiana | 18111 | 1307 | 42 |
1687418 | 1687418 | 2021-09-05 | Newton | Indiana | 18111 | 1307 | 42 |
1684168 | 1684168 | 2021-09-04 | Newton | Indiana | 18111 | 1307 | 42 |
1680917 | 1680917 | 2021-09-03 | Newton | Indiana | 18111 | 1307 | 42 |
1677669 | 1677669 | 2021-09-02 | Newton | Indiana | 18111 | 1301 | 42 |
1674422 | 1674422 | 2021-09-01 | Newton | Indiana | 18111 | 1296 | 42 |
1671173 | 1671173 | 2021-08-31 | Newton | Indiana | 18111 | 1292 | 42 |
1667926 | 1667926 | 2021-08-30 | Newton | Indiana | 18111 | 1288 | 42 |
1664679 | 1664679 | 2021-08-29 | Newton | Indiana | 18111 | 1282 | 42 |
1661431 | 1661431 | 2021-08-28 | Newton | Indiana | 18111 | 1282 | 42 |
1658183 | 1658183 | 2021-08-27 | Newton | Indiana | 18111 | 1282 | 42 |
1654935 | 1654935 | 2021-08-26 | Newton | Indiana | 18111 | 1282 | 42 |
1654967 | 1654967 | 2021-08-26 | Washington | Indiana | 18175 | 2869 | 42 |
1651688 | 1651688 | 2021-08-25 | Newton | Indiana | 18111 | 1277 | 42 |
1651720 | 1651720 | 2021-08-25 | Washington | Indiana | 18175 | 2835 | 42 |
1648439 | 1648439 | 2021-08-24 | Newton | Indiana | 18111 | 1275 | 42 |
1648471 | 1648471 | 2021-08-24 | Washington | Indiana | 18175 | 2806 | 42 |
1645191 | 1645191 | 2021-08-23 | Newton | Indiana | 18111 | 1274 | 42 |
1641942 | 1641942 | 2021-08-22 | Newton | Indiana | 18111 | 1271 | 42 |
1638692 | 1638692 | 2021-08-21 | Newton | Indiana | 18111 | 1271 | 42 |
1635442 | 1635442 | 2021-08-20 | Newton | Indiana | 18111 | 1271 | 42 |
1632192 | 1632192 | 2021-08-19 | Newton | Indiana | 18111 | 1267 | 42 |
1440580 | 1440580 | 2021-06-21 | Fulton | Indiana | 18049 | 2031 | 42 |
1437333 | 1437333 | 2021-06-20 | Fulton | Indiana | 18049 | 2030 | 42 |
1434086 | 1434086 | 2021-06-19 | Fulton | Indiana | 18049 | 2030 | 42 |
1430840 | 1430840 | 2021-06-18 | Fulton | Indiana | 18049 | 2023 | 42 |
1427595 | 1427595 | 2021-06-17 | Fulton | Indiana | 18049 | 2022 | 42 |
1424350 | 1424350 | 2021-06-16 | Fulton | Indiana | 18049 | 2022 | 42 |
1421102 | 1421102 | 2021-06-15 | Fulton | Indiana | 18049 | 2022 | 42 |
1421169 | 1421169 | 2021-06-15 | Whitley | Indiana | 18183 | 4060 | 42 |
1417857 | 1417857 | 2021-06-14 | Fulton | Indiana | 18049 | 2016 | 42 |
1417924 | 1417924 | 2021-06-14 | Whitley | Indiana | 18183 | 4060 | 42 |
1414611 | 1414611 | 2021-06-13 | Fulton | Indiana | 18049 | 2016 | 42 |
1414678 | 1414678 | 2021-06-13 | Whitley | Indiana | 18183 | 4056 | 42 |
1411366 | 1411366 | 2021-06-12 | Fulton | Indiana | 18049 | 2016 | 42 |
1411433 | 1411433 | 2021-06-12 | Whitley | Indiana | 18183 | 4056 | 42 |
1408121 | 1408121 | 2021-06-11 | Fulton | Indiana | 18049 | 2008 | 42 |
1408188 | 1408188 | 2021-06-11 | Whitley | Indiana | 18183 | 4056 | 42 |
1404875 | 1404875 | 2021-06-10 | Fulton | Indiana | 18049 | 2007 | 42 |
1404942 | 1404942 | 2021-06-10 | Whitley | Indiana | 18183 | 4054 | 42 |
1401630 | 1401630 | 2021-06-09 | Fulton | Indiana | 18049 | 2006 | 42 |
1401697 | 1401697 | 2021-06-09 | Whitley | Indiana | 18183 | 4049 | 42 |
1398385 | 1398385 | 2021-06-08 | Fulton | Indiana | 18049 | 2004 | 42 |
1398452 | 1398452 | 2021-06-08 | Whitley | Indiana | 18183 | 4048 | 42 |
1395138 | 1395138 | 2021-06-07 | Fulton | Indiana | 18049 | 1997 | 42 |
1391893 | 1391893 | 2021-06-06 | Fulton | Indiana | 18049 | 1991 | 42 |
1388648 | 1388648 | 2021-06-05 | Fulton | Indiana | 18049 | 1991 | 42 |
1385385 | 1385385 | 2021-06-04 | Brown | Indiana | 18013 | 1035 | 42 |
1385403 | 1385403 | 2021-06-04 | Fulton | Indiana | 18049 | 1988 | 42 |
1385455 | 1385455 | 2021-06-04 | Sullivan | Indiana | 18153 | 2138 | 42 |
1382139 | 1382139 | 2021-06-03 | Brown | Indiana | 18013 | 1035 | 42 |
1382157 | 1382157 | 2021-06-03 | Fulton | Indiana | 18049 | 1986 | 42 |
1382209 | 1382209 | 2021-06-03 | Sullivan | Indiana | 18153 | 2138 | 42 |
1378894 | 1378894 | 2021-06-02 | Brown | Indiana | 18013 | 1032 | 42 |
1378964 | 1378964 | 2021-06-02 | Sullivan | Indiana | 18153 | 2135 | 42 |
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);