ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109881 | 2109881 | 2022-01-13 | Madison | Indiana | 18095 | 27184 | 552 |
2106630 | 2106630 | 2022-01-12 | Madison | Indiana | 18095 | 26803 | 549 |
2103379 | 2103379 | 2022-01-11 | Madison | Indiana | 18095 | 26473 | 546 |
2100128 | 2100128 | 2022-01-10 | Madison | Indiana | 18095 | 26198 | 544 |
2096877 | 2096877 | 2022-01-09 | Madison | Indiana | 18095 | 25534 | 538 |
2093625 | 2093625 | 2022-01-08 | Madison | Indiana | 18095 | 25534 | 538 |
2090373 | 2090373 | 2022-01-07 | Madison | Indiana | 18095 | 25534 | 538 |
2087122 | 2087122 | 2022-01-06 | Madison | Indiana | 18095 | 25173 | 532 |
2083870 | 2083870 | 2022-01-05 | Madison | Indiana | 18095 | 24823 | 531 |
2080618 | 2080618 | 2022-01-04 | Madison | Indiana | 18095 | 24536 | 529 |
2077366 | 2077366 | 2022-01-03 | Madison | Indiana | 18095 | 24383 | 522 |
2074115 | 2074115 | 2022-01-02 | Madison | Indiana | 18095 | 23854 | 519 |
2070864 | 2070864 | 2022-01-01 | Madison | Indiana | 18095 | 23854 | 519 |
2067613 | 2067613 | 2021-12-31 | Madison | Indiana | 18095 | 23854 | 519 |
2064362 | 2064362 | 2021-12-30 | Madison | Indiana | 18095 | 23854 | 519 |
2061112 | 2061112 | 2021-12-29 | Madison | Indiana | 18095 | 23638 | 517 |
2057863 | 2057863 | 2021-12-28 | Madison | Indiana | 18095 | 23507 | 517 |
2054614 | 2054614 | 2021-12-27 | Madison | Indiana | 18095 | 23386 | 510 |
2051364 | 2051364 | 2021-12-26 | Madison | Indiana | 18095 | 22944 | 509 |
2048114 | 2048114 | 2021-12-25 | Madison | Indiana | 18095 | 22944 | 509 |
2044864 | 2044864 | 2021-12-24 | Madison | Indiana | 18095 | 22944 | 509 |
2041615 | 2041615 | 2021-12-23 | Madison | Indiana | 18095 | 22944 | 509 |
2038365 | 2038365 | 2021-12-22 | Madison | Indiana | 18095 | 22944 | 509 |
2035115 | 2035115 | 2021-12-21 | Madison | Indiana | 18095 | 22834 | 508 |
2031865 | 2031865 | 2021-12-20 | Madison | Indiana | 18095 | 22750 | 499 |
2028614 | 2028614 | 2021-12-19 | Madison | Indiana | 18095 | 22484 | 498 |
2025363 | 2025363 | 2021-12-18 | Madison | Indiana | 18095 | 22484 | 498 |
2022112 | 2022112 | 2021-12-17 | Madison | Indiana | 18095 | 22484 | 498 |
2018861 | 2018861 | 2021-12-16 | Madison | Indiana | 18095 | 22382 | 498 |
2015611 | 2015611 | 2021-12-15 | Madison | Indiana | 18095 | 22254 | 495 |
2012360 | 2012360 | 2021-12-14 | Madison | Indiana | 18095 | 22154 | 493 |
2009109 | 2009109 | 2021-12-13 | Madison | Indiana | 18095 | 22069 | 492 |
2005858 | 2005858 | 2021-12-12 | Madison | Indiana | 18095 | 21783 | 489 |
2002607 | 2002607 | 2021-12-11 | Madison | Indiana | 18095 | 21783 | 489 |
1999357 | 1999357 | 2021-12-10 | Madison | Indiana | 18095 | 21783 | 489 |
1996106 | 1996106 | 2021-12-09 | Madison | Indiana | 18095 | 21675 | 487 |
1992855 | 1992855 | 2021-12-08 | Madison | Indiana | 18095 | 21532 | 486 |
1989604 | 1989604 | 2021-12-07 | Madison | Indiana | 18095 | 21414 | 485 |
1986354 | 1986354 | 2021-12-06 | Madison | Indiana | 18095 | 21352 | 481 |
1983104 | 1983104 | 2021-12-05 | Madison | Indiana | 18095 | 21165 | 479 |
1979854 | 1979854 | 2021-12-04 | Madison | Indiana | 18095 | 21165 | 479 |
1976604 | 1976604 | 2021-12-03 | Madison | Indiana | 18095 | 21165 | 479 |
1973355 | 1973355 | 2021-12-02 | Madison | Indiana | 18095 | 21036 | 476 |
1970105 | 1970105 | 2021-12-01 | Madison | Indiana | 18095 | 20914 | 474 |
1966855 | 1966855 | 2021-11-30 | Madison | Indiana | 18095 | 20783 | 471 |
1963603 | 1963603 | 2021-11-29 | Madison | Indiana | 18095 | 20690 | 468 |
1960352 | 1960352 | 2021-11-28 | Madison | Indiana | 18095 | 20474 | 468 |
1957101 | 1957101 | 2021-11-27 | Madison | Indiana | 18095 | 20474 | 468 |
1953850 | 1953850 | 2021-11-26 | Madison | Indiana | 18095 | 20474 | 468 |
1950599 | 1950599 | 2021-11-25 | Madison | Indiana | 18095 | 20474 | 468 |
1947348 | 1947348 | 2021-11-24 | Madison | Indiana | 18095 | 20474 | 468 |
1944097 | 1944097 | 2021-11-23 | Madison | Indiana | 18095 | 20394 | 467 |
1940847 | 1940847 | 2021-11-22 | Madison | Indiana | 18095 | 20312 | 464 |
1937597 | 1937597 | 2021-11-21 | Madison | Indiana | 18095 | 20132 | 460 |
1934347 | 1934347 | 2021-11-20 | Madison | Indiana | 18095 | 20132 | 460 |
1931096 | 1931096 | 2021-11-19 | Madison | Indiana | 18095 | 20132 | 460 |
1927845 | 1927845 | 2021-11-18 | Madison | Indiana | 18095 | 20050 | 460 |
1924595 | 1924595 | 2021-11-17 | Madison | Indiana | 18095 | 19961 | 458 |
1921346 | 1921346 | 2021-11-16 | Madison | Indiana | 18095 | 19879 | 457 |
1918096 | 1918096 | 2021-11-15 | Madison | Indiana | 18095 | 19808 | 455 |
1914846 | 1914846 | 2021-11-14 | Madison | Indiana | 18095 | 19681 | 454 |
1911596 | 1911596 | 2021-11-13 | Madison | Indiana | 18095 | 19681 | 454 |
1908347 | 1908347 | 2021-11-12 | Madison | Indiana | 18095 | 19681 | 454 |
1905098 | 1905098 | 2021-11-11 | Madison | Indiana | 18095 | 19631 | 452 |
1901848 | 1901848 | 2021-11-10 | Madison | Indiana | 18095 | 19494 | 452 |
1898598 | 1898598 | 2021-11-09 | Madison | Indiana | 18095 | 19447 | 451 |
1895348 | 1895348 | 2021-11-08 | Madison | Indiana | 18095 | 19381 | 450 |
1892098 | 1892098 | 2021-11-07 | Madison | Indiana | 18095 | 19267 | 450 |
1888848 | 1888848 | 2021-11-06 | Madison | Indiana | 18095 | 19267 | 450 |
1885598 | 1885598 | 2021-11-05 | Madison | Indiana | 18095 | 19267 | 450 |
1882349 | 1882349 | 2021-11-04 | Madison | Indiana | 18095 | 19228 | 446 |
1879100 | 1879100 | 2021-11-03 | Madison | Indiana | 18095 | 19180 | 446 |
1875851 | 1875851 | 2021-11-02 | Madison | Indiana | 18095 | 19130 | 442 |
1872602 | 1872602 | 2021-11-01 | Madison | Indiana | 18095 | 19102 | 439 |
1869353 | 1869353 | 2021-10-31 | Madison | Indiana | 18095 | 19006 | 439 |
1866104 | 1866104 | 2021-10-30 | Madison | Indiana | 18095 | 19006 | 439 |
1862855 | 1862855 | 2021-10-29 | Madison | Indiana | 18095 | 19006 | 439 |
1859606 | 1859606 | 2021-10-28 | Madison | Indiana | 18095 | 18972 | 438 |
1856357 | 1856357 | 2021-10-27 | Madison | Indiana | 18095 | 18908 | 437 |
1853108 | 1853108 | 2021-10-26 | Madison | Indiana | 18095 | 18881 | 435 |
1849859 | 1849859 | 2021-10-25 | Madison | Indiana | 18095 | 18853 | 433 |
1846609 | 1846609 | 2021-10-24 | Madison | Indiana | 18095 | 18781 | 432 |
1843359 | 1843359 | 2021-10-23 | Madison | Indiana | 18095 | 18781 | 432 |
1840109 | 1840109 | 2021-10-22 | Madison | Indiana | 18095 | 18781 | 432 |
1836860 | 1836860 | 2021-10-21 | Madison | Indiana | 18095 | 18757 | 432 |
1833611 | 1833611 | 2021-10-20 | Madison | Indiana | 18095 | 18727 | 431 |
1830362 | 1830362 | 2021-10-19 | Madison | Indiana | 18095 | 18694 | 428 |
1827113 | 1827113 | 2021-10-18 | Madison | Indiana | 18095 | 18647 | 427 |
1823864 | 1823864 | 2021-10-17 | Madison | Indiana | 18095 | 18571 | 427 |
1820615 | 1820615 | 2021-10-16 | Madison | Indiana | 18095 | 18571 | 427 |
1817366 | 1817366 | 2021-10-15 | Madison | Indiana | 18095 | 18571 | 427 |
1814118 | 1814118 | 2021-10-14 | Madison | Indiana | 18095 | 18521 | 427 |
1810869 | 1810869 | 2021-10-13 | Madison | Indiana | 18095 | 18464 | 423 |
1807620 | 1807620 | 2021-10-12 | Madison | Indiana | 18095 | 18380 | 423 |
1804369 | 1804369 | 2021-10-11 | Madison | Indiana | 18095 | 18341 | 423 |
1801120 | 1801120 | 2021-10-10 | Madison | Indiana | 18095 | 18237 | 420 |
1797871 | 1797871 | 2021-10-09 | Madison | Indiana | 18095 | 18237 | 420 |
1794622 | 1794622 | 2021-10-08 | Madison | Indiana | 18095 | 18237 | 420 |
1791374 | 1791374 | 2021-10-07 | Madison | Indiana | 18095 | 18171 | 420 |
1788125 | 1788125 | 2021-10-06 | Madison | Indiana | 18095 | 18138 | 420 |
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);