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 |
---|---|---|---|---|---|---|---|
2171656 | 2171656 | 2022-02-01 | Clark | Indiana | 18019 | 29016 | 359 |
2168403 | 2168403 | 2022-01-31 | Clark | Indiana | 18019 | 28713 | 356 |
2165148 | 2165148 | 2022-01-30 | Clark | Indiana | 18019 | 28371 | 354 |
2161893 | 2161893 | 2022-01-29 | Clark | Indiana | 18019 | 28371 | 354 |
2158638 | 2158638 | 2022-01-28 | Clark | Indiana | 18019 | 28371 | 354 |
2155384 | 2155384 | 2022-01-27 | Clark | Indiana | 18019 | 27856 | 353 |
2152131 | 2152131 | 2022-01-26 | Clark | Indiana | 18019 | 27556 | 353 |
2148879 | 2148879 | 2022-01-25 | Clark | Indiana | 18019 | 27486 | 352 |
2145627 | 2145627 | 2022-01-24 | Clark | Indiana | 18019 | 27325 | 348 |
2142372 | 2142372 | 2022-01-23 | Clark | Indiana | 18019 | 26357 | 345 |
2139117 | 2139117 | 2022-01-22 | Clark | Indiana | 18019 | 26357 | 345 |
2135861 | 2135861 | 2022-01-21 | Clark | Indiana | 18019 | 26357 | 345 |
2132609 | 2132609 | 2022-01-20 | Clark | Indiana | 18019 | 25894 | 340 |
2129356 | 2129356 | 2022-01-19 | Clark | Indiana | 18019 | 25578 | 339 |
2126102 | 2126102 | 2022-01-18 | Clark | Indiana | 18019 | 25375 | 335 |
2122850 | 2122850 | 2022-01-17 | Clark | Indiana | 18019 | 25212 | 335 |
2119598 | 2119598 | 2022-01-16 | Clark | Indiana | 18019 | 24616 | 331 |
2116346 | 2116346 | 2022-01-15 | Clark | Indiana | 18019 | 24616 | 331 |
2113095 | 2113095 | 2022-01-14 | Clark | Indiana | 18019 | 24616 | 331 |
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 |
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);