ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18119 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109893 | 2109893 | 2022-01-13 | Owen | Indiana | 18119 | 4525 | 96 |
2106642 | 2106642 | 2022-01-12 | Owen | Indiana | 18119 | 4454 | 95 |
2103391 | 2103391 | 2022-01-11 | Owen | Indiana | 18119 | 4390 | 94 |
2100140 | 2100140 | 2022-01-10 | Owen | Indiana | 18119 | 4335 | 93 |
2096889 | 2096889 | 2022-01-09 | Owen | Indiana | 18119 | 4219 | 90 |
2093637 | 2093637 | 2022-01-08 | Owen | Indiana | 18119 | 4219 | 90 |
2090385 | 2090385 | 2022-01-07 | Owen | Indiana | 18119 | 4219 | 90 |
2087134 | 2087134 | 2022-01-06 | Owen | Indiana | 18119 | 4180 | 87 |
2083882 | 2083882 | 2022-01-05 | Owen | Indiana | 18119 | 4142 | 87 |
2080630 | 2080630 | 2022-01-04 | Owen | Indiana | 18119 | 4088 | 87 |
2077378 | 2077378 | 2022-01-03 | Owen | Indiana | 18119 | 4052 | 87 |
2074127 | 2074127 | 2022-01-02 | Owen | Indiana | 18119 | 3967 | 87 |
2070876 | 2070876 | 2022-01-01 | Owen | Indiana | 18119 | 3967 | 87 |
2067625 | 2067625 | 2021-12-31 | Owen | Indiana | 18119 | 3967 | 87 |
2064374 | 2064374 | 2021-12-30 | Owen | Indiana | 18119 | 3967 | 87 |
2061124 | 2061124 | 2021-12-29 | Owen | Indiana | 18119 | 3928 | 87 |
2057875 | 2057875 | 2021-12-28 | Owen | Indiana | 18119 | 3899 | 87 |
2054626 | 2054626 | 2021-12-27 | Owen | Indiana | 18119 | 3884 | 85 |
2051376 | 2051376 | 2021-12-26 | Owen | Indiana | 18119 | 3824 | 85 |
2048126 | 2048126 | 2021-12-25 | Owen | Indiana | 18119 | 3824 | 85 |
2044876 | 2044876 | 2021-12-24 | Owen | Indiana | 18119 | 3824 | 85 |
2041627 | 2041627 | 2021-12-23 | Owen | Indiana | 18119 | 3824 | 85 |
2038377 | 2038377 | 2021-12-22 | Owen | Indiana | 18119 | 3824 | 85 |
2035127 | 2035127 | 2021-12-21 | Owen | Indiana | 18119 | 3802 | 84 |
2031877 | 2031877 | 2021-12-20 | Owen | Indiana | 18119 | 3793 | 84 |
2028626 | 2028626 | 2021-12-19 | Owen | Indiana | 18119 | 3759 | 83 |
2025375 | 2025375 | 2021-12-18 | Owen | Indiana | 18119 | 3759 | 83 |
2022124 | 2022124 | 2021-12-17 | Owen | Indiana | 18119 | 3759 | 83 |
2018873 | 2018873 | 2021-12-16 | Owen | Indiana | 18119 | 3741 | 82 |
2015623 | 2015623 | 2021-12-15 | Owen | Indiana | 18119 | 3723 | 82 |
2012372 | 2012372 | 2021-12-14 | Owen | Indiana | 18119 | 3702 | 81 |
2009121 | 2009121 | 2021-12-13 | Owen | Indiana | 18119 | 3687 | 81 |
2005870 | 2005870 | 2021-12-12 | Owen | Indiana | 18119 | 3641 | 81 |
2002619 | 2002619 | 2021-12-11 | Owen | Indiana | 18119 | 3641 | 81 |
1999369 | 1999369 | 2021-12-10 | Owen | Indiana | 18119 | 3641 | 81 |
1996118 | 1996118 | 2021-12-09 | Owen | Indiana | 18119 | 3632 | 80 |
1992867 | 1992867 | 2021-12-08 | Owen | Indiana | 18119 | 3620 | 80 |
1989616 | 1989616 | 2021-12-07 | Owen | Indiana | 18119 | 3600 | 80 |
1986366 | 1986366 | 2021-12-06 | Owen | Indiana | 18119 | 3589 | 80 |
1983116 | 1983116 | 2021-12-05 | Owen | Indiana | 18119 | 3539 | 80 |
1979866 | 1979866 | 2021-12-04 | Owen | Indiana | 18119 | 3539 | 80 |
1976616 | 1976616 | 2021-12-03 | Owen | Indiana | 18119 | 3539 | 80 |
1973367 | 1973367 | 2021-12-02 | Owen | Indiana | 18119 | 3516 | 80 |
1970117 | 1970117 | 2021-12-01 | Owen | Indiana | 18119 | 3500 | 80 |
1966867 | 1966867 | 2021-11-30 | Owen | Indiana | 18119 | 3479 | 80 |
1963615 | 1963615 | 2021-11-29 | Owen | Indiana | 18119 | 3466 | 79 |
1960364 | 1960364 | 2021-11-28 | Owen | Indiana | 18119 | 3420 | 79 |
1957113 | 1957113 | 2021-11-27 | Owen | Indiana | 18119 | 3420 | 79 |
1953862 | 1953862 | 2021-11-26 | Owen | Indiana | 18119 | 3420 | 79 |
1950611 | 1950611 | 2021-11-25 | Owen | Indiana | 18119 | 3420 | 79 |
1947360 | 1947360 | 2021-11-24 | Owen | Indiana | 18119 | 3420 | 79 |
1944109 | 1944109 | 2021-11-23 | Owen | Indiana | 18119 | 3410 | 78 |
1940859 | 1940859 | 2021-11-22 | Owen | Indiana | 18119 | 3405 | 78 |
1937609 | 1937609 | 2021-11-21 | Owen | Indiana | 18119 | 3384 | 78 |
1934359 | 1934359 | 2021-11-20 | Owen | Indiana | 18119 | 3384 | 78 |
1931108 | 1931108 | 2021-11-19 | Owen | Indiana | 18119 | 3384 | 78 |
1927857 | 1927857 | 2021-11-18 | Owen | Indiana | 18119 | 3364 | 78 |
1924607 | 1924607 | 2021-11-17 | Owen | Indiana | 18119 | 3357 | 78 |
1921358 | 1921358 | 2021-11-16 | Owen | Indiana | 18119 | 3341 | 77 |
1918108 | 1918108 | 2021-11-15 | Owen | Indiana | 18119 | 3337 | 77 |
1914858 | 1914858 | 2021-11-14 | Owen | Indiana | 18119 | 3315 | 77 |
1911608 | 1911608 | 2021-11-13 | Owen | Indiana | 18119 | 3315 | 77 |
1908359 | 1908359 | 2021-11-12 | Owen | Indiana | 18119 | 3315 | 77 |
1905110 | 1905110 | 2021-11-11 | Owen | Indiana | 18119 | 3309 | 77 |
1901860 | 1901860 | 2021-11-10 | Owen | Indiana | 18119 | 3290 | 76 |
1898610 | 1898610 | 2021-11-09 | Owen | Indiana | 18119 | 3282 | 76 |
1895360 | 1895360 | 2021-11-08 | Owen | Indiana | 18119 | 3272 | 76 |
1892110 | 1892110 | 2021-11-07 | Owen | Indiana | 18119 | 3249 | 76 |
1888860 | 1888860 | 2021-11-06 | Owen | Indiana | 18119 | 3249 | 76 |
1885610 | 1885610 | 2021-11-05 | Owen | Indiana | 18119 | 3249 | 76 |
1882361 | 1882361 | 2021-11-04 | Owen | Indiana | 18119 | 3238 | 76 |
1879112 | 1879112 | 2021-11-03 | Owen | Indiana | 18119 | 3228 | 76 |
1875863 | 1875863 | 2021-11-02 | Owen | Indiana | 18119 | 3212 | 75 |
1872614 | 1872614 | 2021-11-01 | Owen | Indiana | 18119 | 3203 | 74 |
1869365 | 1869365 | 2021-10-31 | Owen | Indiana | 18119 | 3187 | 73 |
1866116 | 1866116 | 2021-10-30 | Owen | Indiana | 18119 | 3187 | 73 |
1862867 | 1862867 | 2021-10-29 | Owen | Indiana | 18119 | 3187 | 73 |
1859618 | 1859618 | 2021-10-28 | Owen | Indiana | 18119 | 3181 | 73 |
1856369 | 1856369 | 2021-10-27 | Owen | Indiana | 18119 | 3179 | 73 |
1853120 | 1853120 | 2021-10-26 | Owen | Indiana | 18119 | 3165 | 73 |
1849871 | 1849871 | 2021-10-25 | Owen | Indiana | 18119 | 3158 | 73 |
1846621 | 1846621 | 2021-10-24 | Owen | Indiana | 18119 | 3150 | 73 |
1843371 | 1843371 | 2021-10-23 | Owen | Indiana | 18119 | 3150 | 73 |
1840121 | 1840121 | 2021-10-22 | Owen | Indiana | 18119 | 3150 | 73 |
1836872 | 1836872 | 2021-10-21 | Owen | Indiana | 18119 | 3144 | 72 |
1833623 | 1833623 | 2021-10-20 | Owen | Indiana | 18119 | 3142 | 72 |
1830374 | 1830374 | 2021-10-19 | Owen | Indiana | 18119 | 3130 | 72 |
1827125 | 1827125 | 2021-10-18 | Owen | Indiana | 18119 | 3123 | 72 |
1823876 | 1823876 | 2021-10-17 | Owen | Indiana | 18119 | 3104 | 71 |
1820627 | 1820627 | 2021-10-16 | Owen | Indiana | 18119 | 3104 | 71 |
1817378 | 1817378 | 2021-10-15 | Owen | Indiana | 18119 | 3104 | 71 |
1814130 | 1814130 | 2021-10-14 | Owen | Indiana | 18119 | 3096 | 71 |
1810881 | 1810881 | 2021-10-13 | Owen | Indiana | 18119 | 3086 | 69 |
1807632 | 1807632 | 2021-10-12 | Owen | Indiana | 18119 | 3071 | 69 |
1804381 | 1804381 | 2021-10-11 | Owen | Indiana | 18119 | 3067 | 69 |
1801132 | 1801132 | 2021-10-10 | Owen | Indiana | 18119 | 3043 | 69 |
1797883 | 1797883 | 2021-10-09 | Owen | Indiana | 18119 | 3043 | 69 |
1794634 | 1794634 | 2021-10-08 | Owen | Indiana | 18119 | 3043 | 69 |
1791386 | 1791386 | 2021-10-07 | Owen | Indiana | 18119 | 3019 | 69 |
1788137 | 1788137 | 2021-10-06 | Owen | Indiana | 18119 | 3007 | 69 |
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);