ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 18079 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174939 | 2174939 | 2022-02-02 | Jennings | Indiana | 18079 | 6676 | 96 |
2171686 | 2171686 | 2022-02-01 | Jennings | Indiana | 18079 | 6640 | 95 |
2168433 | 2168433 | 2022-01-31 | Jennings | Indiana | 18079 | 6619 | 95 |
2165178 | 2165178 | 2022-01-30 | Jennings | Indiana | 18079 | 6482 | 94 |
2161923 | 2161923 | 2022-01-29 | Jennings | Indiana | 18079 | 6482 | 94 |
2158668 | 2158668 | 2022-01-28 | Jennings | Indiana | 18079 | 6482 | 94 |
2155414 | 2155414 | 2022-01-27 | Jennings | Indiana | 18079 | 6392 | 94 |
2152161 | 2152161 | 2022-01-26 | Jennings | Indiana | 18079 | 6314 | 93 |
2148909 | 2148909 | 2022-01-25 | Jennings | Indiana | 18079 | 6266 | 91 |
2145657 | 2145657 | 2022-01-24 | Jennings | Indiana | 18079 | 6206 | 88 |
2142402 | 2142402 | 2022-01-23 | Jennings | Indiana | 18079 | 6009 | 88 |
2139147 | 2139147 | 2022-01-22 | Jennings | Indiana | 18079 | 6009 | 88 |
2135891 | 2135891 | 2022-01-21 | Jennings | Indiana | 18079 | 6009 | 88 |
2132639 | 2132639 | 2022-01-20 | Jennings | Indiana | 18079 | 5924 | 86 |
2129386 | 2129386 | 2022-01-19 | Jennings | Indiana | 18079 | 5870 | 84 |
2126132 | 2126132 | 2022-01-18 | Jennings | Indiana | 18079 | 5797 | 82 |
2122880 | 2122880 | 2022-01-17 | Jennings | Indiana | 18079 | 5730 | 82 |
2119628 | 2119628 | 2022-01-16 | Jennings | Indiana | 18079 | 5596 | 82 |
2116376 | 2116376 | 2022-01-15 | Jennings | Indiana | 18079 | 5596 | 82 |
2113125 | 2113125 | 2022-01-14 | Jennings | Indiana | 18079 | 5596 | 82 |
2109873 | 2109873 | 2022-01-13 | Jennings | Indiana | 18079 | 5534 | 81 |
2106622 | 2106622 | 2022-01-12 | Jennings | Indiana | 18079 | 5470 | 80 |
2103371 | 2103371 | 2022-01-11 | Jennings | Indiana | 18079 | 5412 | 78 |
2100120 | 2100120 | 2022-01-10 | Jennings | Indiana | 18079 | 5359 | 77 |
2096869 | 2096869 | 2022-01-09 | Jennings | Indiana | 18079 | 5268 | 76 |
2093617 | 2093617 | 2022-01-08 | Jennings | Indiana | 18079 | 5268 | 76 |
2090365 | 2090365 | 2022-01-07 | Jennings | Indiana | 18079 | 5268 | 76 |
2087114 | 2087114 | 2022-01-06 | Jennings | Indiana | 18079 | 5228 | 75 |
2083862 | 2083862 | 2022-01-05 | Jennings | Indiana | 18079 | 5175 | 75 |
2080610 | 2080610 | 2022-01-04 | Jennings | Indiana | 18079 | 5111 | 75 |
2077358 | 2077358 | 2022-01-03 | Jennings | Indiana | 18079 | 5087 | 75 |
2074107 | 2074107 | 2022-01-02 | Jennings | Indiana | 18079 | 5039 | 75 |
2070856 | 2070856 | 2022-01-01 | Jennings | Indiana | 18079 | 5039 | 75 |
2067605 | 2067605 | 2021-12-31 | Jennings | Indiana | 18079 | 5039 | 75 |
2064354 | 2064354 | 2021-12-30 | Jennings | Indiana | 18079 | 5039 | 75 |
2061104 | 2061104 | 2021-12-29 | Jennings | Indiana | 18079 | 5013 | 75 |
2057855 | 2057855 | 2021-12-28 | Jennings | Indiana | 18079 | 4983 | 75 |
2054606 | 2054606 | 2021-12-27 | Jennings | Indiana | 18079 | 4958 | 74 |
2051356 | 2051356 | 2021-12-26 | Jennings | Indiana | 18079 | 4909 | 74 |
2048106 | 2048106 | 2021-12-25 | Jennings | Indiana | 18079 | 4909 | 74 |
2044856 | 2044856 | 2021-12-24 | Jennings | Indiana | 18079 | 4909 | 74 |
2041607 | 2041607 | 2021-12-23 | Jennings | Indiana | 18079 | 4909 | 74 |
2038357 | 2038357 | 2021-12-22 | Jennings | Indiana | 18079 | 4909 | 74 |
2035107 | 2035107 | 2021-12-21 | Jennings | Indiana | 18079 | 4893 | 73 |
2031857 | 2031857 | 2021-12-20 | Jennings | Indiana | 18079 | 4869 | 73 |
2028606 | 2028606 | 2021-12-19 | Jennings | Indiana | 18079 | 4827 | 71 |
2025355 | 2025355 | 2021-12-18 | Jennings | Indiana | 18079 | 4827 | 71 |
2022104 | 2022104 | 2021-12-17 | Jennings | Indiana | 18079 | 4827 | 71 |
2018853 | 2018853 | 2021-12-16 | Jennings | Indiana | 18079 | 4805 | 71 |
2015603 | 2015603 | 2021-12-15 | Jennings | Indiana | 18079 | 4783 | 70 |
2012352 | 2012352 | 2021-12-14 | Jennings | Indiana | 18079 | 4755 | 70 |
2009101 | 2009101 | 2021-12-13 | Jennings | Indiana | 18079 | 4733 | 70 |
2005850 | 2005850 | 2021-12-12 | Jennings | Indiana | 18079 | 4664 | 70 |
2002599 | 2002599 | 2021-12-11 | Jennings | Indiana | 18079 | 4664 | 70 |
1999349 | 1999349 | 2021-12-10 | Jennings | Indiana | 18079 | 4664 | 70 |
1996098 | 1996098 | 2021-12-09 | Jennings | Indiana | 18079 | 4650 | 70 |
1992847 | 1992847 | 2021-12-08 | Jennings | Indiana | 18079 | 4631 | 70 |
1989596 | 1989596 | 2021-12-07 | Jennings | Indiana | 18079 | 4594 | 70 |
1986346 | 1986346 | 2021-12-06 | Jennings | Indiana | 18079 | 4576 | 70 |
1983096 | 1983096 | 2021-12-05 | Jennings | Indiana | 18079 | 4525 | 70 |
1979846 | 1979846 | 2021-12-04 | Jennings | Indiana | 18079 | 4525 | 70 |
1976596 | 1976596 | 2021-12-03 | Jennings | Indiana | 18079 | 4525 | 70 |
1973347 | 1973347 | 2021-12-02 | Jennings | Indiana | 18079 | 4493 | 70 |
1970097 | 1970097 | 2021-12-01 | Jennings | Indiana | 18079 | 4462 | 70 |
1966847 | 1966847 | 2021-11-30 | Jennings | Indiana | 18079 | 4422 | 69 |
1963595 | 1963595 | 2021-11-29 | Jennings | Indiana | 18079 | 4401 | 69 |
1960344 | 1960344 | 2021-11-28 | Jennings | Indiana | 18079 | 4351 | 69 |
1957093 | 1957093 | 2021-11-27 | Jennings | Indiana | 18079 | 4351 | 69 |
1953842 | 1953842 | 2021-11-26 | Jennings | Indiana | 18079 | 4351 | 69 |
1950591 | 1950591 | 2021-11-25 | Jennings | Indiana | 18079 | 4351 | 69 |
1947340 | 1947340 | 2021-11-24 | Jennings | Indiana | 18079 | 4351 | 69 |
1944089 | 1944089 | 2021-11-23 | Jennings | Indiana | 18079 | 4336 | 69 |
1940839 | 1940839 | 2021-11-22 | Jennings | Indiana | 18079 | 4318 | 69 |
1937589 | 1937589 | 2021-11-21 | Jennings | Indiana | 18079 | 4256 | 69 |
1934339 | 1934339 | 2021-11-20 | Jennings | Indiana | 18079 | 4256 | 69 |
1931088 | 1931088 | 2021-11-19 | Jennings | Indiana | 18079 | 4256 | 69 |
1927837 | 1927837 | 2021-11-18 | Jennings | Indiana | 18079 | 4236 | 69 |
1924587 | 1924587 | 2021-11-17 | Jennings | Indiana | 18079 | 4213 | 68 |
1921338 | 1921338 | 2021-11-16 | Jennings | Indiana | 18079 | 4189 | 68 |
1918088 | 1918088 | 2021-11-15 | Jennings | Indiana | 18079 | 4178 | 68 |
1914838 | 1914838 | 2021-11-14 | Jennings | Indiana | 18079 | 4140 | 68 |
1911588 | 1911588 | 2021-11-13 | Jennings | Indiana | 18079 | 4140 | 68 |
1908339 | 1908339 | 2021-11-12 | Jennings | Indiana | 18079 | 4140 | 68 |
1905090 | 1905090 | 2021-11-11 | Jennings | Indiana | 18079 | 4128 | 68 |
1901840 | 1901840 | 2021-11-10 | Jennings | Indiana | 18079 | 4062 | 67 |
1898590 | 1898590 | 2021-11-09 | Jennings | Indiana | 18079 | 4047 | 67 |
1895340 | 1895340 | 2021-11-08 | Jennings | Indiana | 18079 | 4044 | 67 |
1892090 | 1892090 | 2021-11-07 | Jennings | Indiana | 18079 | 4017 | 67 |
1888840 | 1888840 | 2021-11-06 | Jennings | Indiana | 18079 | 4017 | 67 |
1885590 | 1885590 | 2021-11-05 | Jennings | Indiana | 18079 | 4017 | 67 |
1882341 | 1882341 | 2021-11-04 | Jennings | Indiana | 18079 | 4006 | 67 |
1879092 | 1879092 | 2021-11-03 | Jennings | Indiana | 18079 | 3997 | 67 |
1875843 | 1875843 | 2021-11-02 | Jennings | Indiana | 18079 | 3984 | 67 |
1872594 | 1872594 | 2021-11-01 | Jennings | Indiana | 18079 | 3981 | 66 |
1869345 | 1869345 | 2021-10-31 | Jennings | Indiana | 18079 | 3955 | 66 |
1866096 | 1866096 | 2021-10-30 | Jennings | Indiana | 18079 | 3955 | 66 |
1862847 | 1862847 | 2021-10-29 | Jennings | Indiana | 18079 | 3955 | 66 |
1859598 | 1859598 | 2021-10-28 | Jennings | Indiana | 18079 | 3940 | 66 |
1856349 | 1856349 | 2021-10-27 | Jennings | Indiana | 18079 | 3930 | 66 |
1853100 | 1853100 | 2021-10-26 | Jennings | Indiana | 18079 | 3912 | 66 |
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);