ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 18141 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109907 | 2109907 | 2022-01-13 | St. Joseph | Indiana | 18141 | 61447 | 765 |
2106656 | 2106656 | 2022-01-12 | St. Joseph | Indiana | 18141 | 60802 | 763 |
2103405 | 2103405 | 2022-01-11 | St. Joseph | Indiana | 18141 | 60353 | 756 |
2100154 | 2100154 | 2022-01-10 | St. Joseph | Indiana | 18141 | 59935 | 755 |
2096903 | 2096903 | 2022-01-09 | St. Joseph | Indiana | 18141 | 58613 | 745 |
2093651 | 2093651 | 2022-01-08 | St. Joseph | Indiana | 18141 | 58613 | 745 |
2090399 | 2090399 | 2022-01-07 | St. Joseph | Indiana | 18141 | 58613 | 745 |
2087148 | 2087148 | 2022-01-06 | St. Joseph | Indiana | 18141 | 58097 | 736 |
2083896 | 2083896 | 2022-01-05 | St. Joseph | Indiana | 18141 | 57518 | 731 |
2080644 | 2080644 | 2022-01-04 | St. Joseph | Indiana | 18141 | 57012 | 730 |
2077392 | 2077392 | 2022-01-03 | St. Joseph | Indiana | 18141 | 56603 | 724 |
2074141 | 2074141 | 2022-01-02 | St. Joseph | Indiana | 18141 | 55466 | 721 |
2070890 | 2070890 | 2022-01-01 | St. Joseph | Indiana | 18141 | 55466 | 721 |
2067639 | 2067639 | 2021-12-31 | St. Joseph | Indiana | 18141 | 55466 | 721 |
2064388 | 2064388 | 2021-12-30 | St. Joseph | Indiana | 18141 | 55466 | 721 |
2061138 | 2061138 | 2021-12-29 | St. Joseph | Indiana | 18141 | 55051 | 720 |
2057889 | 2057889 | 2021-12-28 | St. Joseph | Indiana | 18141 | 54705 | 719 |
2054640 | 2054640 | 2021-12-27 | St. Joseph | Indiana | 18141 | 54480 | 713 |
2051390 | 2051390 | 2021-12-26 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2048140 | 2048140 | 2021-12-25 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2044890 | 2044890 | 2021-12-24 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2041641 | 2041641 | 2021-12-23 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2038391 | 2038391 | 2021-12-22 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2035141 | 2035141 | 2021-12-21 | St. Joseph | Indiana | 18141 | 53560 | 701 |
2031891 | 2031891 | 2021-12-20 | St. Joseph | Indiana | 18141 | 53426 | 697 |
2028640 | 2028640 | 2021-12-19 | St. Joseph | Indiana | 18141 | 52980 | 696 |
2025389 | 2025389 | 2021-12-18 | St. Joseph | Indiana | 18141 | 52980 | 696 |
2022138 | 2022138 | 2021-12-17 | St. Joseph | Indiana | 18141 | 52980 | 696 |
2018887 | 2018887 | 2021-12-16 | St. Joseph | Indiana | 18141 | 52735 | 695 |
2015637 | 2015637 | 2021-12-15 | St. Joseph | Indiana | 18141 | 52477 | 694 |
2012386 | 2012386 | 2021-12-14 | St. Joseph | Indiana | 18141 | 52249 | 689 |
2009135 | 2009135 | 2021-12-13 | St. Joseph | Indiana | 18141 | 52034 | 683 |
2005884 | 2005884 | 2021-12-12 | St. Joseph | Indiana | 18141 | 51518 | 681 |
2002633 | 2002633 | 2021-12-11 | St. Joseph | Indiana | 18141 | 51518 | 681 |
1999383 | 1999383 | 2021-12-10 | St. Joseph | Indiana | 18141 | 51518 | 681 |
1996132 | 1996132 | 2021-12-09 | St. Joseph | Indiana | 18141 | 51289 | 678 |
1992881 | 1992881 | 2021-12-08 | St. Joseph | Indiana | 18141 | 50971 | 676 |
1989630 | 1989630 | 2021-12-07 | St. Joseph | Indiana | 18141 | 50715 | 671 |
1986380 | 1986380 | 2021-12-06 | St. Joseph | Indiana | 18141 | 50497 | 669 |
1983130 | 1983130 | 2021-12-05 | St. Joseph | Indiana | 18141 | 49858 | 668 |
1979880 | 1979880 | 2021-12-04 | St. Joseph | Indiana | 18141 | 49858 | 668 |
1976630 | 1976630 | 2021-12-03 | St. Joseph | Indiana | 18141 | 49858 | 668 |
1973381 | 1973381 | 2021-12-02 | St. Joseph | Indiana | 18141 | 49531 | 664 |
1970131 | 1970131 | 2021-12-01 | St. Joseph | Indiana | 18141 | 49255 | 664 |
1966881 | 1966881 | 2021-11-30 | St. Joseph | Indiana | 18141 | 49004 | 662 |
1963629 | 1963629 | 2021-11-29 | St. Joseph | Indiana | 18141 | 48798 | 658 |
1960378 | 1960378 | 2021-11-28 | St. Joseph | Indiana | 18141 | 48172 | 657 |
1957127 | 1957127 | 2021-11-27 | St. Joseph | Indiana | 18141 | 48172 | 657 |
1953876 | 1953876 | 2021-11-26 | St. Joseph | Indiana | 18141 | 48172 | 657 |
1950625 | 1950625 | 2021-11-25 | St. Joseph | Indiana | 18141 | 48172 | 657 |
1947374 | 1947374 | 2021-11-24 | St. Joseph | Indiana | 18141 | 48172 | 657 |
1944123 | 1944123 | 2021-11-23 | St. Joseph | Indiana | 18141 | 47976 | 657 |
1940873 | 1940873 | 2021-11-22 | St. Joseph | Indiana | 18141 | 47813 | 655 |
1937623 | 1937623 | 2021-11-21 | St. Joseph | Indiana | 18141 | 47442 | 653 |
1934373 | 1934373 | 2021-11-20 | St. Joseph | Indiana | 18141 | 47442 | 653 |
1931122 | 1931122 | 2021-11-19 | St. Joseph | Indiana | 18141 | 47442 | 653 |
1927871 | 1927871 | 2021-11-18 | St. Joseph | Indiana | 18141 | 47255 | 652 |
1924621 | 1924621 | 2021-11-17 | St. Joseph | Indiana | 18141 | 47058 | 651 |
1921372 | 1921372 | 2021-11-16 | St. Joseph | Indiana | 18141 | 46899 | 651 |
1918122 | 1918122 | 2021-11-15 | St. Joseph | Indiana | 18141 | 46764 | 650 |
1914872 | 1914872 | 2021-11-14 | St. Joseph | Indiana | 18141 | 46447 | 648 |
1911622 | 1911622 | 2021-11-13 | St. Joseph | Indiana | 18141 | 46447 | 648 |
1908373 | 1908373 | 2021-11-12 | St. Joseph | Indiana | 18141 | 46447 | 648 |
1905124 | 1905124 | 2021-11-11 | St. Joseph | Indiana | 18141 | 46317 | 647 |
1901874 | 1901874 | 2021-11-10 | St. Joseph | Indiana | 18141 | 46027 | 644 |
1898624 | 1898624 | 2021-11-09 | St. Joseph | Indiana | 18141 | 45890 | 644 |
1895374 | 1895374 | 2021-11-08 | St. Joseph | Indiana | 18141 | 45818 | 641 |
1892124 | 1892124 | 2021-11-07 | St. Joseph | Indiana | 18141 | 45559 | 641 |
1888874 | 1888874 | 2021-11-06 | St. Joseph | Indiana | 18141 | 45559 | 641 |
1885624 | 1885624 | 2021-11-05 | St. Joseph | Indiana | 18141 | 45559 | 641 |
1882375 | 1882375 | 2021-11-04 | St. Joseph | Indiana | 18141 | 45426 | 641 |
1879126 | 1879126 | 2021-11-03 | St. Joseph | Indiana | 18141 | 45329 | 641 |
1875877 | 1875877 | 2021-11-02 | St. Joseph | Indiana | 18141 | 45243 | 640 |
1872628 | 1872628 | 2021-11-01 | St. Joseph | Indiana | 18141 | 45162 | 640 |
1869379 | 1869379 | 2021-10-31 | St. Joseph | Indiana | 18141 | 44933 | 640 |
1866130 | 1866130 | 2021-10-30 | St. Joseph | Indiana | 18141 | 44933 | 640 |
1862881 | 1862881 | 2021-10-29 | St. Joseph | Indiana | 18141 | 44933 | 640 |
1859632 | 1859632 | 2021-10-28 | St. Joseph | Indiana | 18141 | 44842 | 640 |
1856383 | 1856383 | 2021-10-27 | St. Joseph | Indiana | 18141 | 44742 | 639 |
1853134 | 1853134 | 2021-10-26 | St. Joseph | Indiana | 18141 | 44664 | 637 |
1849885 | 1849885 | 2021-10-25 | St. Joseph | Indiana | 18141 | 44596 | 635 |
1846635 | 1846635 | 2021-10-24 | St. Joseph | Indiana | 18141 | 44434 | 633 |
1843385 | 1843385 | 2021-10-23 | St. Joseph | Indiana | 18141 | 44434 | 633 |
1840135 | 1840135 | 2021-10-22 | St. Joseph | Indiana | 18141 | 44434 | 633 |
1836886 | 1836886 | 2021-10-21 | St. Joseph | Indiana | 18141 | 44348 | 631 |
1833637 | 1833637 | 2021-10-20 | St. Joseph | Indiana | 18141 | 44247 | 629 |
1830388 | 1830388 | 2021-10-19 | St. Joseph | Indiana | 18141 | 44192 | 626 |
1827139 | 1827139 | 2021-10-18 | St. Joseph | Indiana | 18141 | 44146 | 625 |
1823890 | 1823890 | 2021-10-17 | St. Joseph | Indiana | 18141 | 43991 | 625 |
1820641 | 1820641 | 2021-10-16 | St. Joseph | Indiana | 18141 | 43991 | 625 |
1817392 | 1817392 | 2021-10-15 | St. Joseph | Indiana | 18141 | 43991 | 625 |
1814144 | 1814144 | 2021-10-14 | St. Joseph | Indiana | 18141 | 43893 | 624 |
1810895 | 1810895 | 2021-10-13 | St. Joseph | Indiana | 18141 | 43811 | 622 |
1807646 | 1807646 | 2021-10-12 | St. Joseph | Indiana | 18141 | 43728 | 621 |
1804395 | 1804395 | 2021-10-11 | St. Joseph | Indiana | 18141 | 43680 | 620 |
1801146 | 1801146 | 2021-10-10 | St. Joseph | Indiana | 18141 | 43471 | 617 |
1797897 | 1797897 | 2021-10-09 | St. Joseph | Indiana | 18141 | 43471 | 617 |
1794648 | 1794648 | 2021-10-08 | St. Joseph | Indiana | 18141 | 43471 | 617 |
1791400 | 1791400 | 2021-10-07 | St. Joseph | Indiana | 18141 | 43289 | 617 |
1788151 | 1788151 | 2021-10-06 | St. Joseph | Indiana | 18141 | 43196 | 617 |
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);