ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Delaware" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109851 | 2109851 | 2022-01-13 | Delaware | Indiana | 18035 | 20404 | 376 |
2106600 | 2106600 | 2022-01-12 | Delaware | Indiana | 18035 | 20151 | 374 |
2103349 | 2103349 | 2022-01-11 | Delaware | Indiana | 18035 | 19980 | 373 |
2100098 | 2100098 | 2022-01-10 | Delaware | Indiana | 18035 | 19834 | 369 |
2096847 | 2096847 | 2022-01-09 | Delaware | Indiana | 18035 | 19479 | 363 |
2093595 | 2093595 | 2022-01-08 | Delaware | Indiana | 18035 | 19479 | 363 |
2090343 | 2090343 | 2022-01-07 | Delaware | Indiana | 18035 | 19479 | 363 |
2087092 | 2087092 | 2022-01-06 | Delaware | Indiana | 18035 | 19289 | 359 |
2083840 | 2083840 | 2022-01-05 | Delaware | Indiana | 18035 | 19097 | 357 |
2080588 | 2080588 | 2022-01-04 | Delaware | Indiana | 18035 | 18951 | 357 |
2077336 | 2077336 | 2022-01-03 | Delaware | Indiana | 18035 | 18883 | 351 |
2074085 | 2074085 | 2022-01-02 | Delaware | Indiana | 18035 | 18594 | 348 |
2070834 | 2070834 | 2022-01-01 | Delaware | Indiana | 18035 | 18594 | 348 |
2067583 | 2067583 | 2021-12-31 | Delaware | Indiana | 18035 | 18594 | 348 |
2064332 | 2064332 | 2021-12-30 | Delaware | Indiana | 18035 | 18594 | 348 |
2061082 | 2061082 | 2021-12-29 | Delaware | Indiana | 18035 | 18460 | 346 |
2057833 | 2057833 | 2021-12-28 | Delaware | Indiana | 18035 | 18397 | 344 |
2054584 | 2054584 | 2021-12-27 | Delaware | Indiana | 18035 | 18298 | 340 |
2051334 | 2051334 | 2021-12-26 | Delaware | Indiana | 18035 | 18107 | 339 |
2048084 | 2048084 | 2021-12-25 | Delaware | Indiana | 18035 | 18107 | 339 |
2044834 | 2044834 | 2021-12-24 | Delaware | Indiana | 18035 | 18107 | 339 |
2041585 | 2041585 | 2021-12-23 | Delaware | Indiana | 18035 | 18107 | 339 |
2038335 | 2038335 | 2021-12-22 | Delaware | Indiana | 18035 | 18107 | 339 |
2035085 | 2035085 | 2021-12-21 | Delaware | Indiana | 18035 | 18029 | 338 |
2031835 | 2031835 | 2021-12-20 | Delaware | Indiana | 18035 | 17973 | 331 |
2028584 | 2028584 | 2021-12-19 | Delaware | Indiana | 18035 | 17819 | 328 |
2025333 | 2025333 | 2021-12-18 | Delaware | Indiana | 18035 | 17819 | 328 |
2022082 | 2022082 | 2021-12-17 | Delaware | Indiana | 18035 | 17819 | 328 |
2018831 | 2018831 | 2021-12-16 | Delaware | Indiana | 18035 | 17775 | 328 |
2015581 | 2015581 | 2021-12-15 | Delaware | Indiana | 18035 | 17651 | 328 |
2012330 | 2012330 | 2021-12-14 | Delaware | Indiana | 18035 | 17578 | 323 |
2009079 | 2009079 | 2021-12-13 | Delaware | Indiana | 18035 | 17541 | 320 |
2005828 | 2005828 | 2021-12-12 | Delaware | Indiana | 18035 | 17349 | 319 |
2002577 | 2002577 | 2021-12-11 | Delaware | Indiana | 18035 | 17349 | 319 |
1999327 | 1999327 | 2021-12-10 | Delaware | Indiana | 18035 | 17349 | 319 |
1996076 | 1996076 | 2021-12-09 | Delaware | Indiana | 18035 | 17277 | 319 |
1992825 | 1992825 | 2021-12-08 | Delaware | Indiana | 18035 | 17178 | 318 |
1989574 | 1989574 | 2021-12-07 | Delaware | Indiana | 18035 | 17072 | 317 |
1986324 | 1986324 | 2021-12-06 | Delaware | Indiana | 18035 | 17023 | 314 |
1983074 | 1983074 | 2021-12-05 | Delaware | Indiana | 18035 | 16780 | 314 |
1979824 | 1979824 | 2021-12-04 | Delaware | Indiana | 18035 | 16780 | 314 |
1976574 | 1976574 | 2021-12-03 | Delaware | Indiana | 18035 | 16780 | 314 |
1973325 | 1973325 | 2021-12-02 | Delaware | Indiana | 18035 | 16685 | 311 |
1970075 | 1970075 | 2021-12-01 | Delaware | Indiana | 18035 | 16593 | 309 |
1966825 | 1966825 | 2021-11-30 | Delaware | Indiana | 18035 | 16498 | 307 |
1963573 | 1963573 | 2021-11-29 | Delaware | Indiana | 18035 | 16443 | 301 |
1960322 | 1960322 | 2021-11-28 | Delaware | Indiana | 18035 | 16248 | 296 |
1957071 | 1957071 | 2021-11-27 | Delaware | Indiana | 18035 | 16248 | 296 |
1953820 | 1953820 | 2021-11-26 | Delaware | Indiana | 18035 | 16248 | 296 |
1950569 | 1950569 | 2021-11-25 | Delaware | Indiana | 18035 | 16248 | 296 |
1947318 | 1947318 | 2021-11-24 | Delaware | Indiana | 18035 | 16248 | 296 |
1944067 | 1944067 | 2021-11-23 | Delaware | Indiana | 18035 | 16181 | 295 |
1940817 | 1940817 | 2021-11-22 | Delaware | Indiana | 18035 | 16139 | 293 |
1937567 | 1937567 | 2021-11-21 | Delaware | Indiana | 18035 | 16002 | 291 |
1934317 | 1934317 | 2021-11-20 | Delaware | Indiana | 18035 | 16002 | 291 |
1931066 | 1931066 | 2021-11-19 | Delaware | Indiana | 18035 | 16002 | 291 |
1927815 | 1927815 | 2021-11-18 | Delaware | Indiana | 18035 | 15959 | 291 |
1924565 | 1924565 | 2021-11-17 | Delaware | Indiana | 18035 | 15894 | 290 |
1921316 | 1921316 | 2021-11-16 | Delaware | Indiana | 18035 | 15838 | 288 |
1918066 | 1918066 | 2021-11-15 | Delaware | Indiana | 18035 | 15794 | 287 |
1914816 | 1914816 | 2021-11-14 | Delaware | Indiana | 18035 | 15669 | 286 |
1911566 | 1911566 | 2021-11-13 | Delaware | Indiana | 18035 | 15669 | 286 |
1908317 | 1908317 | 2021-11-12 | Delaware | Indiana | 18035 | 15669 | 286 |
1905068 | 1905068 | 2021-11-11 | Delaware | Indiana | 18035 | 15631 | 285 |
1901818 | 1901818 | 2021-11-10 | Delaware | Indiana | 18035 | 15512 | 285 |
1898568 | 1898568 | 2021-11-09 | Delaware | Indiana | 18035 | 15463 | 285 |
1895318 | 1895318 | 2021-11-08 | Delaware | Indiana | 18035 | 15439 | 283 |
1892068 | 1892068 | 2021-11-07 | Delaware | Indiana | 18035 | 15370 | 282 |
1888818 | 1888818 | 2021-11-06 | Delaware | Indiana | 18035 | 15370 | 282 |
1885568 | 1885568 | 2021-11-05 | Delaware | Indiana | 18035 | 15370 | 282 |
1882319 | 1882319 | 2021-11-04 | Delaware | Indiana | 18035 | 15341 | 283 |
1879070 | 1879070 | 2021-11-03 | Delaware | Indiana | 18035 | 15321 | 281 |
1875821 | 1875821 | 2021-11-02 | Delaware | Indiana | 18035 | 15289 | 279 |
1872572 | 1872572 | 2021-11-01 | Delaware | Indiana | 18035 | 15279 | 278 |
1869323 | 1869323 | 2021-10-31 | Delaware | Indiana | 18035 | 15231 | 276 |
1866074 | 1866074 | 2021-10-30 | Delaware | Indiana | 18035 | 15231 | 276 |
1862825 | 1862825 | 2021-10-29 | Delaware | Indiana | 18035 | 15231 | 276 |
1859576 | 1859576 | 2021-10-28 | Delaware | Indiana | 18035 | 15211 | 276 |
1856327 | 1856327 | 2021-10-27 | Delaware | Indiana | 18035 | 15181 | 275 |
1853078 | 1853078 | 2021-10-26 | Delaware | Indiana | 18035 | 15153 | 274 |
1849829 | 1849829 | 2021-10-25 | Delaware | Indiana | 18035 | 15145 | 274 |
1846579 | 1846579 | 2021-10-24 | Delaware | Indiana | 18035 | 15091 | 273 |
1843329 | 1843329 | 2021-10-23 | Delaware | Indiana | 18035 | 15091 | 273 |
1840079 | 1840079 | 2021-10-22 | Delaware | Indiana | 18035 | 15091 | 273 |
1836830 | 1836830 | 2021-10-21 | Delaware | Indiana | 18035 | 15061 | 271 |
1833581 | 1833581 | 2021-10-20 | Delaware | Indiana | 18035 | 15042 | 271 |
1830332 | 1830332 | 2021-10-19 | Delaware | Indiana | 18035 | 15024 | 270 |
1827083 | 1827083 | 2021-10-18 | Delaware | Indiana | 18035 | 15002 | 269 |
1823834 | 1823834 | 2021-10-17 | Delaware | Indiana | 18035 | 14949 | 266 |
1820585 | 1820585 | 2021-10-16 | Delaware | Indiana | 18035 | 14949 | 266 |
1817336 | 1817336 | 2021-10-15 | Delaware | Indiana | 18035 | 14949 | 266 |
1814088 | 1814088 | 2021-10-14 | Delaware | Indiana | 18035 | 14934 | 265 |
1810839 | 1810839 | 2021-10-13 | Delaware | Indiana | 18035 | 14906 | 263 |
1807590 | 1807590 | 2021-10-12 | Delaware | Indiana | 18035 | 14873 | 262 |
1804339 | 1804339 | 2021-10-11 | Delaware | Indiana | 18035 | 14845 | 257 |
1801090 | 1801090 | 2021-10-10 | Delaware | Indiana | 18035 | 14779 | 257 |
1797841 | 1797841 | 2021-10-09 | Delaware | Indiana | 18035 | 14779 | 257 |
1794592 | 1794592 | 2021-10-08 | Delaware | Indiana | 18035 | 14779 | 257 |
1791344 | 1791344 | 2021-10-07 | Delaware | Indiana | 18035 | 14726 | 257 |
1788095 | 1788095 | 2021-10-06 | Delaware | Indiana | 18035 | 14683 | 255 |
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);