ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 18019 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109843 | 2109843 | 2022-01-13 | Clark | Indiana | 18019 | 24334 | 331 |
2106592 | 2106592 | 2022-01-12 | Clark | Indiana | 18019 | 24048 | 329 |
2103341 | 2103341 | 2022-01-11 | Clark | Indiana | 18019 | 23836 | 326 |
2100090 | 2100090 | 2022-01-10 | Clark | Indiana | 18019 | 23682 | 320 |
2096839 | 2096839 | 2022-01-09 | Clark | Indiana | 18019 | 23171 | 319 |
2093587 | 2093587 | 2022-01-08 | Clark | Indiana | 18019 | 23171 | 319 |
2090335 | 2090335 | 2022-01-07 | Clark | Indiana | 18019 | 23171 | 319 |
2087084 | 2087084 | 2022-01-06 | Clark | Indiana | 18019 | 22947 | 318 |
2083832 | 2083832 | 2022-01-05 | Clark | Indiana | 18019 | 22620 | 314 |
2080580 | 2080580 | 2022-01-04 | Clark | Indiana | 18019 | 22423 | 313 |
2077328 | 2077328 | 2022-01-03 | Clark | Indiana | 18019 | 22343 | 311 |
2074077 | 2074077 | 2022-01-02 | Clark | Indiana | 18019 | 21919 | 310 |
2070826 | 2070826 | 2022-01-01 | Clark | Indiana | 18019 | 21919 | 310 |
2067575 | 2067575 | 2021-12-31 | Clark | Indiana | 18019 | 21919 | 310 |
2064324 | 2064324 | 2021-12-30 | Clark | Indiana | 18019 | 21919 | 310 |
2061074 | 2061074 | 2021-12-29 | Clark | Indiana | 18019 | 21760 | 309 |
2057825 | 2057825 | 2021-12-28 | Clark | Indiana | 18019 | 21530 | 309 |
2054576 | 2054576 | 2021-12-27 | Clark | Indiana | 18019 | 21445 | 305 |
2051326 | 2051326 | 2021-12-26 | Clark | Indiana | 18019 | 21245 | 304 |
2048076 | 2048076 | 2021-12-25 | Clark | Indiana | 18019 | 21245 | 304 |
2044826 | 2044826 | 2021-12-24 | Clark | Indiana | 18019 | 21245 | 304 |
2041577 | 2041577 | 2021-12-23 | Clark | Indiana | 18019 | 21245 | 304 |
2038327 | 2038327 | 2021-12-22 | Clark | Indiana | 18019 | 21245 | 304 |
2035077 | 2035077 | 2021-12-21 | Clark | Indiana | 18019 | 21178 | 300 |
2031827 | 2031827 | 2021-12-20 | Clark | Indiana | 18019 | 21131 | 297 |
2028576 | 2028576 | 2021-12-19 | Clark | Indiana | 18019 | 21002 | 295 |
2025325 | 2025325 | 2021-12-18 | Clark | Indiana | 18019 | 21002 | 295 |
2022074 | 2022074 | 2021-12-17 | Clark | Indiana | 18019 | 21002 | 295 |
2018823 | 2018823 | 2021-12-16 | Clark | Indiana | 18019 | 20963 | 295 |
2015573 | 2015573 | 2021-12-15 | Clark | Indiana | 18019 | 20882 | 295 |
2012322 | 2012322 | 2021-12-14 | Clark | Indiana | 18019 | 20816 | 295 |
2009071 | 2009071 | 2021-12-13 | Clark | Indiana | 18019 | 20773 | 294 |
2005820 | 2005820 | 2021-12-12 | Clark | Indiana | 18019 | 20655 | 294 |
2002569 | 2002569 | 2021-12-11 | Clark | Indiana | 18019 | 20655 | 294 |
1999319 | 1999319 | 2021-12-10 | Clark | Indiana | 18019 | 20655 | 294 |
1996068 | 1996068 | 2021-12-09 | Clark | Indiana | 18019 | 20581 | 291 |
1992817 | 1992817 | 2021-12-08 | Clark | Indiana | 18019 | 20503 | 290 |
1989566 | 1989566 | 2021-12-07 | Clark | Indiana | 18019 | 20468 | 289 |
1986316 | 1986316 | 2021-12-06 | Clark | Indiana | 18019 | 20414 | 289 |
1983066 | 1983066 | 2021-12-05 | Clark | Indiana | 18019 | 20260 | 289 |
1979816 | 1979816 | 2021-12-04 | Clark | Indiana | 18019 | 20260 | 289 |
1976566 | 1976566 | 2021-12-03 | Clark | Indiana | 18019 | 20260 | 289 |
1973317 | 1973317 | 2021-12-02 | Clark | Indiana | 18019 | 20168 | 288 |
1970067 | 1970067 | 2021-12-01 | Clark | Indiana | 18019 | 20093 | 288 |
1966817 | 1966817 | 2021-11-30 | Clark | Indiana | 18019 | 20007 | 287 |
1963565 | 1963565 | 2021-11-29 | Clark | Indiana | 18019 | 19920 | 285 |
1960314 | 1960314 | 2021-11-28 | Clark | Indiana | 18019 | 19807 | 285 |
1957063 | 1957063 | 2021-11-27 | Clark | Indiana | 18019 | 19807 | 285 |
1953812 | 1953812 | 2021-11-26 | Clark | Indiana | 18019 | 19807 | 285 |
1950561 | 1950561 | 2021-11-25 | Clark | Indiana | 18019 | 19807 | 285 |
1947310 | 1947310 | 2021-11-24 | Clark | Indiana | 18019 | 19807 | 285 |
1944059 | 1944059 | 2021-11-23 | Clark | Indiana | 18019 | 19737 | 284 |
1940809 | 1940809 | 2021-11-22 | Clark | Indiana | 18019 | 19687 | 284 |
1937559 | 1937559 | 2021-11-21 | Clark | Indiana | 18019 | 19585 | 281 |
1934309 | 1934309 | 2021-11-20 | Clark | Indiana | 18019 | 19585 | 281 |
1931058 | 1931058 | 2021-11-19 | Clark | Indiana | 18019 | 19585 | 281 |
1927807 | 1927807 | 2021-11-18 | Clark | Indiana | 18019 | 19536 | 281 |
1924557 | 1924557 | 2021-11-17 | Clark | Indiana | 18019 | 19491 | 281 |
1921308 | 1921308 | 2021-11-16 | Clark | Indiana | 18019 | 19445 | 281 |
1918058 | 1918058 | 2021-11-15 | Clark | Indiana | 18019 | 19387 | 279 |
1914808 | 1914808 | 2021-11-14 | Clark | Indiana | 18019 | 19311 | 279 |
1911558 | 1911558 | 2021-11-13 | Clark | Indiana | 18019 | 19311 | 279 |
1908309 | 1908309 | 2021-11-12 | Clark | Indiana | 18019 | 19311 | 279 |
1905060 | 1905060 | 2021-11-11 | Clark | Indiana | 18019 | 19282 | 278 |
1901810 | 1901810 | 2021-11-10 | Clark | Indiana | 18019 | 19198 | 278 |
1898560 | 1898560 | 2021-11-09 | Clark | Indiana | 18019 | 19170 | 278 |
1895310 | 1895310 | 2021-11-08 | Clark | Indiana | 18019 | 19136 | 274 |
1892060 | 1892060 | 2021-11-07 | Clark | Indiana | 18019 | 19076 | 273 |
1888810 | 1888810 | 2021-11-06 | Clark | Indiana | 18019 | 19076 | 273 |
1885560 | 1885560 | 2021-11-05 | Clark | Indiana | 18019 | 19076 | 273 |
1882311 | 1882311 | 2021-11-04 | Clark | Indiana | 18019 | 19045 | 271 |
1879062 | 1879062 | 2021-11-03 | Clark | Indiana | 18019 | 19013 | 270 |
1875813 | 1875813 | 2021-11-02 | Clark | Indiana | 18019 | 18988 | 270 |
1872564 | 1872564 | 2021-11-01 | Clark | Indiana | 18019 | 18963 | 270 |
1869315 | 1869315 | 2021-10-31 | Clark | Indiana | 18019 | 18910 | 267 |
1866066 | 1866066 | 2021-10-30 | Clark | Indiana | 18019 | 18910 | 267 |
1862817 | 1862817 | 2021-10-29 | Clark | Indiana | 18019 | 18910 | 267 |
1859568 | 1859568 | 2021-10-28 | Clark | Indiana | 18019 | 18878 | 267 |
1856319 | 1856319 | 2021-10-27 | Clark | Indiana | 18019 | 18809 | 266 |
1853070 | 1853070 | 2021-10-26 | Clark | Indiana | 18019 | 18663 | 265 |
1849821 | 1849821 | 2021-10-25 | Clark | Indiana | 18019 | 18632 | 264 |
1846571 | 1846571 | 2021-10-24 | Clark | Indiana | 18019 | 18579 | 262 |
1843321 | 1843321 | 2021-10-23 | Clark | Indiana | 18019 | 18579 | 262 |
1840071 | 1840071 | 2021-10-22 | Clark | Indiana | 18019 | 18579 | 262 |
1836822 | 1836822 | 2021-10-21 | Clark | Indiana | 18019 | 18562 | 262 |
1833573 | 1833573 | 2021-10-20 | Clark | Indiana | 18019 | 18527 | 262 |
1830324 | 1830324 | 2021-10-19 | Clark | Indiana | 18019 | 18471 | 262 |
1827075 | 1827075 | 2021-10-18 | Clark | Indiana | 18019 | 18446 | 260 |
1823826 | 1823826 | 2021-10-17 | Clark | Indiana | 18019 | 18405 | 258 |
1820577 | 1820577 | 2021-10-16 | Clark | Indiana | 18019 | 18405 | 258 |
1817328 | 1817328 | 2021-10-15 | Clark | Indiana | 18019 | 18405 | 258 |
1814080 | 1814080 | 2021-10-14 | Clark | Indiana | 18019 | 18358 | 258 |
1810831 | 1810831 | 2021-10-13 | Clark | Indiana | 18019 | 18315 | 256 |
1807582 | 1807582 | 2021-10-12 | Clark | Indiana | 18019 | 18279 | 256 |
1804331 | 1804331 | 2021-10-11 | Clark | Indiana | 18019 | 18267 | 254 |
1801082 | 1801082 | 2021-10-10 | Clark | Indiana | 18019 | 18169 | 254 |
1797833 | 1797833 | 2021-10-09 | Clark | Indiana | 18019 | 18169 | 254 |
1794584 | 1794584 | 2021-10-08 | Clark | Indiana | 18019 | 18169 | 254 |
1791336 | 1791336 | 2021-10-07 | Clark | Indiana | 18019 | 18098 | 251 |
1788087 | 1788087 | 2021-10-06 | Clark | Indiana | 18019 | 18069 | 251 |
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);