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 |
---|---|---|---|---|---|---|---|
2174973 | 2174973 | 2022-02-02 | St. Joseph | Indiana | 18141 | 68786 | 807 |
2171720 | 2171720 | 2022-02-01 | St. Joseph | Indiana | 18141 | 68567 | 803 |
2168467 | 2168467 | 2022-01-31 | St. Joseph | Indiana | 18141 | 68356 | 795 |
2165212 | 2165212 | 2022-01-30 | St. Joseph | Indiana | 18141 | 67837 | 794 |
2161957 | 2161957 | 2022-01-29 | St. Joseph | Indiana | 18141 | 67837 | 794 |
2158702 | 2158702 | 2022-01-28 | St. Joseph | Indiana | 18141 | 67837 | 794 |
2155448 | 2155448 | 2022-01-27 | St. Joseph | Indiana | 18141 | 67247 | 792 |
2152195 | 2152195 | 2022-01-26 | St. Joseph | Indiana | 18141 | 66914 | 791 |
2148943 | 2148943 | 2022-01-25 | St. Joseph | Indiana | 18141 | 66799 | 788 |
2145691 | 2145691 | 2022-01-24 | St. Joseph | Indiana | 18141 | 66520 | 786 |
2142436 | 2142436 | 2022-01-23 | St. Joseph | Indiana | 18141 | 65406 | 786 |
2139181 | 2139181 | 2022-01-22 | St. Joseph | Indiana | 18141 | 65406 | 786 |
2135925 | 2135925 | 2022-01-21 | St. Joseph | Indiana | 18141 | 65406 | 786 |
2132673 | 2132673 | 2022-01-20 | St. Joseph | Indiana | 18141 | 64773 | 783 |
2129420 | 2129420 | 2022-01-19 | St. Joseph | Indiana | 18141 | 64096 | 779 |
2126166 | 2126166 | 2022-01-18 | St. Joseph | Indiana | 18141 | 63476 | 774 |
2122914 | 2122914 | 2022-01-17 | St. Joseph | Indiana | 18141 | 63121 | 770 |
2119662 | 2119662 | 2022-01-16 | St. Joseph | Indiana | 18141 | 62011 | 768 |
2116410 | 2116410 | 2022-01-15 | St. Joseph | Indiana | 18141 | 62011 | 768 |
2113159 | 2113159 | 2022-01-14 | St. Joseph | Indiana | 18141 | 62011 | 768 |
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 |
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);