ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 18089 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174945 | 2174945 | 2022-02-02 | Lake | Indiana | 18089 | 104056 | 1685 |
2171692 | 2171692 | 2022-02-01 | Lake | Indiana | 18089 | 103867 | 1671 |
2168439 | 2168439 | 2022-01-31 | Lake | Indiana | 18089 | 103679 | 1663 |
2165184 | 2165184 | 2022-01-30 | Lake | Indiana | 18089 | 103192 | 1653 |
2161929 | 2161929 | 2022-01-29 | Lake | Indiana | 18089 | 103192 | 1653 |
2158674 | 2158674 | 2022-01-28 | Lake | Indiana | 18089 | 103192 | 1653 |
2155420 | 2155420 | 2022-01-27 | Lake | Indiana | 18089 | 102780 | 1636 |
2152167 | 2152167 | 2022-01-26 | Lake | Indiana | 18089 | 102505 | 1624 |
2148915 | 2148915 | 2022-01-25 | Lake | Indiana | 18089 | 102424 | 1605 |
2145663 | 2145663 | 2022-01-24 | Lake | Indiana | 18089 | 102241 | 1589 |
2142408 | 2142408 | 2022-01-23 | Lake | Indiana | 18089 | 101151 | 1582 |
2139153 | 2139153 | 2022-01-22 | Lake | Indiana | 18089 | 101151 | 1582 |
2135897 | 2135897 | 2022-01-21 | Lake | Indiana | 18089 | 101151 | 1582 |
2132645 | 2132645 | 2022-01-20 | Lake | Indiana | 18089 | 100773 | 1572 |
2129392 | 2129392 | 2022-01-19 | Lake | Indiana | 18089 | 100303 | 1564 |
2126138 | 2126138 | 2022-01-18 | Lake | Indiana | 18089 | 99745 | 1540 |
2122886 | 2122886 | 2022-01-17 | Lake | Indiana | 18089 | 99309 | 1520 |
2119634 | 2119634 | 2022-01-16 | Lake | Indiana | 18089 | 97687 | 1514 |
2116382 | 2116382 | 2022-01-15 | Lake | Indiana | 18089 | 97687 | 1514 |
2113131 | 2113131 | 2022-01-14 | Lake | Indiana | 18089 | 97687 | 1514 |
2109879 | 2109879 | 2022-01-13 | Lake | Indiana | 18089 | 97013 | 1499 |
2106628 | 2106628 | 2022-01-12 | Lake | Indiana | 18089 | 96314 | 1490 |
2103377 | 2103377 | 2022-01-11 | Lake | Indiana | 18089 | 95573 | 1478 |
2100126 | 2100126 | 2022-01-10 | Lake | Indiana | 18089 | 94941 | 1462 |
2096875 | 2096875 | 2022-01-09 | Lake | Indiana | 18089 | 92404 | 1451 |
2093623 | 2093623 | 2022-01-08 | Lake | Indiana | 18089 | 92404 | 1451 |
2090371 | 2090371 | 2022-01-07 | Lake | Indiana | 18089 | 92404 | 1451 |
2087120 | 2087120 | 2022-01-06 | Lake | Indiana | 18089 | 91229 | 1439 |
2083868 | 2083868 | 2022-01-05 | Lake | Indiana | 18089 | 90222 | 1434 |
2080616 | 2080616 | 2022-01-04 | Lake | Indiana | 18089 | 89418 | 1429 |
2077364 | 2077364 | 2022-01-03 | Lake | Indiana | 18089 | 88577 | 1411 |
2074113 | 2074113 | 2022-01-02 | Lake | Indiana | 18089 | 84637 | 1406 |
2070862 | 2070862 | 2022-01-01 | Lake | Indiana | 18089 | 84637 | 1406 |
2067611 | 2067611 | 2021-12-31 | Lake | Indiana | 18089 | 84637 | 1406 |
2064360 | 2064360 | 2021-12-30 | Lake | Indiana | 18089 | 84637 | 1406 |
2061110 | 2061110 | 2021-12-29 | Lake | Indiana | 18089 | 83165 | 1399 |
2057861 | 2057861 | 2021-12-28 | Lake | Indiana | 18089 | 82412 | 1392 |
2054612 | 2054612 | 2021-12-27 | Lake | Indiana | 18089 | 81740 | 1376 |
2051362 | 2051362 | 2021-12-26 | Lake | Indiana | 18089 | 78676 | 1371 |
2048112 | 2048112 | 2021-12-25 | Lake | Indiana | 18089 | 78676 | 1371 |
2044862 | 2044862 | 2021-12-24 | Lake | Indiana | 18089 | 78676 | 1371 |
2041613 | 2041613 | 2021-12-23 | Lake | Indiana | 18089 | 78676 | 1371 |
2038363 | 2038363 | 2021-12-22 | Lake | Indiana | 18089 | 78676 | 1371 |
2035113 | 2035113 | 2021-12-21 | Lake | Indiana | 18089 | 78189 | 1365 |
2031863 | 2031863 | 2021-12-20 | Lake | Indiana | 18089 | 77728 | 1358 |
2028612 | 2028612 | 2021-12-19 | Lake | Indiana | 18089 | 76729 | 1353 |
2025361 | 2025361 | 2021-12-18 | Lake | Indiana | 18089 | 76729 | 1353 |
2022110 | 2022110 | 2021-12-17 | Lake | Indiana | 18089 | 76729 | 1353 |
2018859 | 2018859 | 2021-12-16 | Lake | Indiana | 18089 | 76304 | 1346 |
2015609 | 2015609 | 2021-12-15 | Lake | Indiana | 18089 | 75933 | 1344 |
2012358 | 2012358 | 2021-12-14 | Lake | Indiana | 18089 | 75664 | 1332 |
2009107 | 2009107 | 2021-12-13 | Lake | Indiana | 18089 | 75347 | 1325 |
2005856 | 2005856 | 2021-12-12 | Lake | Indiana | 18089 | 74618 | 1321 |
2002605 | 2002605 | 2021-12-11 | Lake | Indiana | 18089 | 74618 | 1321 |
1999355 | 1999355 | 2021-12-10 | Lake | Indiana | 18089 | 74618 | 1321 |
1996104 | 1996104 | 2021-12-09 | Lake | Indiana | 18089 | 74283 | 1319 |
1992853 | 1992853 | 2021-12-08 | Lake | Indiana | 18089 | 73960 | 1316 |
1989602 | 1989602 | 2021-12-07 | Lake | Indiana | 18089 | 73693 | 1311 |
1986352 | 1986352 | 2021-12-06 | Lake | Indiana | 18089 | 73334 | 1306 |
1983102 | 1983102 | 2021-12-05 | Lake | Indiana | 18089 | 72578 | 1305 |
1979852 | 1979852 | 2021-12-04 | Lake | Indiana | 18089 | 72578 | 1305 |
1976602 | 1976602 | 2021-12-03 | Lake | Indiana | 18089 | 72578 | 1305 |
1973353 | 1973353 | 2021-12-02 | Lake | Indiana | 18089 | 72266 | 1298 |
1970103 | 1970103 | 2021-12-01 | Lake | Indiana | 18089 | 71960 | 1294 |
1966853 | 1966853 | 2021-11-30 | Lake | Indiana | 18089 | 71598 | 1288 |
1963601 | 1963601 | 2021-11-29 | Lake | Indiana | 18089 | 71347 | 1275 |
1960350 | 1960350 | 2021-11-28 | Lake | Indiana | 18089 | 70611 | 1270 |
1957099 | 1957099 | 2021-11-27 | Lake | Indiana | 18089 | 70611 | 1270 |
1953848 | 1953848 | 2021-11-26 | Lake | Indiana | 18089 | 70611 | 1270 |
1950597 | 1950597 | 2021-11-25 | Lake | Indiana | 18089 | 70611 | 1270 |
1947346 | 1947346 | 2021-11-24 | Lake | Indiana | 18089 | 70611 | 1270 |
1944095 | 1944095 | 2021-11-23 | Lake | Indiana | 18089 | 70428 | 1269 |
1940845 | 1940845 | 2021-11-22 | Lake | Indiana | 18089 | 70211 | 1263 |
1937595 | 1937595 | 2021-11-21 | Lake | Indiana | 18089 | 69774 | 1260 |
1934345 | 1934345 | 2021-11-20 | Lake | Indiana | 18089 | 69774 | 1260 |
1931094 | 1931094 | 2021-11-19 | Lake | Indiana | 18089 | 69774 | 1260 |
1927843 | 1927843 | 2021-11-18 | Lake | Indiana | 18089 | 69582 | 1257 |
1924593 | 1924593 | 2021-11-17 | Lake | Indiana | 18089 | 69390 | 1256 |
1921344 | 1921344 | 2021-11-16 | Lake | Indiana | 18089 | 69245 | 1256 |
1918094 | 1918094 | 2021-11-15 | Lake | Indiana | 18089 | 69083 | 1251 |
1914844 | 1914844 | 2021-11-14 | Lake | Indiana | 18089 | 68736 | 1250 |
1911594 | 1911594 | 2021-11-13 | Lake | Indiana | 18089 | 68736 | 1250 |
1908345 | 1908345 | 2021-11-12 | Lake | Indiana | 18089 | 68736 | 1250 |
1905096 | 1905096 | 2021-11-11 | Lake | Indiana | 18089 | 68597 | 1248 |
1901846 | 1901846 | 2021-11-10 | Lake | Indiana | 18089 | 68289 | 1246 |
1898596 | 1898596 | 2021-11-09 | Lake | Indiana | 18089 | 68162 | 1244 |
1895346 | 1895346 | 2021-11-08 | Lake | Indiana | 18089 | 68032 | 1240 |
1892096 | 1892096 | 2021-11-07 | Lake | Indiana | 18089 | 67796 | 1238 |
1888846 | 1888846 | 2021-11-06 | Lake | Indiana | 18089 | 67796 | 1238 |
1885596 | 1885596 | 2021-11-05 | Lake | Indiana | 18089 | 67796 | 1238 |
1882347 | 1882347 | 2021-11-04 | Lake | Indiana | 18089 | 67672 | 1237 |
1879098 | 1879098 | 2021-11-03 | Lake | Indiana | 18089 | 67549 | 1236 |
1875849 | 1875849 | 2021-11-02 | Lake | Indiana | 18089 | 67477 | 1231 |
1872600 | 1872600 | 2021-11-01 | Lake | Indiana | 18089 | 67380 | 1229 |
1869351 | 1869351 | 2021-10-31 | Lake | Indiana | 18089 | 67118 | 1225 |
1866102 | 1866102 | 2021-10-30 | Lake | Indiana | 18089 | 67118 | 1225 |
1862853 | 1862853 | 2021-10-29 | Lake | Indiana | 18089 | 67118 | 1225 |
1859604 | 1859604 | 2021-10-28 | Lake | Indiana | 18089 | 67006 | 1225 |
1856355 | 1856355 | 2021-10-27 | Lake | Indiana | 18089 | 66906 | 1224 |
1853106 | 1853106 | 2021-10-26 | Lake | Indiana | 18089 | 66818 | 1218 |
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);