ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Allen" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109835 | 2109835 | 2022-01-13 | Allen | Indiana | 18003 | 86748 | 1031 |
2106584 | 2106584 | 2022-01-12 | Allen | Indiana | 18003 | 85606 | 1025 |
2103333 | 2103333 | 2022-01-11 | Allen | Indiana | 18003 | 84384 | 1018 |
2100082 | 2100082 | 2022-01-10 | Allen | Indiana | 18003 | 83475 | 1013 |
2096831 | 2096831 | 2022-01-09 | Allen | Indiana | 18003 | 80867 | 1009 |
2093579 | 2093579 | 2022-01-08 | Allen | Indiana | 18003 | 80867 | 1009 |
2090327 | 2090327 | 2022-01-07 | Allen | Indiana | 18003 | 80867 | 1009 |
2087076 | 2087076 | 2022-01-06 | Allen | Indiana | 18003 | 79733 | 1003 |
2083824 | 2083824 | 2022-01-05 | Allen | Indiana | 18003 | 78545 | 993 |
2080572 | 2080572 | 2022-01-04 | Allen | Indiana | 18003 | 77301 | 993 |
2077320 | 2077320 | 2022-01-03 | Allen | Indiana | 18003 | 76764 | 985 |
2074069 | 2074069 | 2022-01-02 | Allen | Indiana | 18003 | 75061 | 985 |
2070818 | 2070818 | 2022-01-01 | Allen | Indiana | 18003 | 75061 | 985 |
2067567 | 2067567 | 2021-12-31 | Allen | Indiana | 18003 | 75061 | 985 |
2064316 | 2064316 | 2021-12-30 | Allen | Indiana | 18003 | 75061 | 985 |
2061066 | 2061066 | 2021-12-29 | Allen | Indiana | 18003 | 74434 | 985 |
2057817 | 2057817 | 2021-12-28 | Allen | Indiana | 18003 | 73978 | 984 |
2054568 | 2054568 | 2021-12-27 | Allen | Indiana | 18003 | 73661 | 971 |
2051318 | 2051318 | 2021-12-26 | Allen | Indiana | 18003 | 72539 | 969 |
2048068 | 2048068 | 2021-12-25 | Allen | Indiana | 18003 | 72539 | 969 |
2044818 | 2044818 | 2021-12-24 | Allen | Indiana | 18003 | 72539 | 969 |
2041569 | 2041569 | 2021-12-23 | Allen | Indiana | 18003 | 72539 | 969 |
2038319 | 2038319 | 2021-12-22 | Allen | Indiana | 18003 | 72539 | 969 |
2035069 | 2035069 | 2021-12-21 | Allen | Indiana | 18003 | 72264 | 965 |
2031819 | 2031819 | 2021-12-20 | Allen | Indiana | 18003 | 72068 | 959 |
2028568 | 2028568 | 2021-12-19 | Allen | Indiana | 18003 | 71387 | 952 |
2025317 | 2025317 | 2021-12-18 | Allen | Indiana | 18003 | 71387 | 952 |
2022066 | 2022066 | 2021-12-17 | Allen | Indiana | 18003 | 71387 | 952 |
2018815 | 2018815 | 2021-12-16 | Allen | Indiana | 18003 | 71135 | 951 |
2015565 | 2015565 | 2021-12-15 | Allen | Indiana | 18003 | 70725 | 944 |
2012314 | 2012314 | 2021-12-14 | Allen | Indiana | 18003 | 70394 | 939 |
2009063 | 2009063 | 2021-12-13 | Allen | Indiana | 18003 | 70199 | 929 |
2005812 | 2005812 | 2021-12-12 | Allen | Indiana | 18003 | 69483 | 929 |
2002561 | 2002561 | 2021-12-11 | Allen | Indiana | 18003 | 69483 | 929 |
1999311 | 1999311 | 2021-12-10 | Allen | Indiana | 18003 | 69483 | 929 |
1996060 | 1996060 | 2021-12-09 | Allen | Indiana | 18003 | 69166 | 926 |
1992809 | 1992809 | 2021-12-08 | Allen | Indiana | 18003 | 68823 | 923 |
1989558 | 1989558 | 2021-12-07 | Allen | Indiana | 18003 | 68395 | 917 |
1986308 | 1986308 | 2021-12-06 | Allen | Indiana | 18003 | 68064 | 909 |
1983058 | 1983058 | 2021-12-05 | Allen | Indiana | 18003 | 67123 | 908 |
1979808 | 1979808 | 2021-12-04 | Allen | Indiana | 18003 | 67123 | 908 |
1976558 | 1976558 | 2021-12-03 | Allen | Indiana | 18003 | 67123 | 908 |
1973309 | 1973309 | 2021-12-02 | Allen | Indiana | 18003 | 66744 | 907 |
1970059 | 1970059 | 2021-12-01 | Allen | Indiana | 18003 | 66340 | 907 |
1966809 | 1966809 | 2021-11-30 | Allen | Indiana | 18003 | 65862 | 906 |
1963557 | 1963557 | 2021-11-29 | Allen | Indiana | 18003 | 65597 | 893 |
1960306 | 1960306 | 2021-11-28 | Allen | Indiana | 18003 | 64407 | 888 |
1957055 | 1957055 | 2021-11-27 | Allen | Indiana | 18003 | 64407 | 888 |
1953804 | 1953804 | 2021-11-26 | Allen | Indiana | 18003 | 64407 | 888 |
1950553 | 1950553 | 2021-11-25 | Allen | Indiana | 18003 | 64407 | 888 |
1947302 | 1947302 | 2021-11-24 | Allen | Indiana | 18003 | 64407 | 888 |
1944051 | 1944051 | 2021-11-23 | Allen | Indiana | 18003 | 64007 | 887 |
1940801 | 1940801 | 2021-11-22 | Allen | Indiana | 18003 | 63787 | 882 |
1937551 | 1937551 | 2021-11-21 | Allen | Indiana | 18003 | 63093 | 881 |
1934301 | 1934301 | 2021-11-20 | Allen | Indiana | 18003 | 63093 | 881 |
1931050 | 1931050 | 2021-11-19 | Allen | Indiana | 18003 | 63093 | 881 |
1927799 | 1927799 | 2021-11-18 | Allen | Indiana | 18003 | 62809 | 879 |
1924549 | 1924549 | 2021-11-17 | Allen | Indiana | 18003 | 62378 | 877 |
1921300 | 1921300 | 2021-11-16 | Allen | Indiana | 18003 | 62115 | 872 |
1918050 | 1918050 | 2021-11-15 | Allen | Indiana | 18003 | 61887 | 867 |
1914800 | 1914800 | 2021-11-14 | Allen | Indiana | 18003 | 61277 | 867 |
1911550 | 1911550 | 2021-11-13 | Allen | Indiana | 18003 | 61277 | 867 |
1908301 | 1908301 | 2021-11-12 | Allen | Indiana | 18003 | 61277 | 867 |
1905052 | 1905052 | 2021-11-11 | Allen | Indiana | 18003 | 61063 | 864 |
1901802 | 1901802 | 2021-11-10 | Allen | Indiana | 18003 | 60619 | 862 |
1898552 | 1898552 | 2021-11-09 | Allen | Indiana | 18003 | 60363 | 862 |
1895302 | 1895302 | 2021-11-08 | Allen | Indiana | 18003 | 60249 | 853 |
1892052 | 1892052 | 2021-11-07 | Allen | Indiana | 18003 | 59811 | 851 |
1888802 | 1888802 | 2021-11-06 | Allen | Indiana | 18003 | 59811 | 851 |
1885552 | 1885552 | 2021-11-05 | Allen | Indiana | 18003 | 59811 | 851 |
1882303 | 1882303 | 2021-11-04 | Allen | Indiana | 18003 | 59610 | 848 |
1879054 | 1879054 | 2021-11-03 | Allen | Indiana | 18003 | 59444 | 848 |
1875805 | 1875805 | 2021-11-02 | Allen | Indiana | 18003 | 59254 | 845 |
1872556 | 1872556 | 2021-11-01 | Allen | Indiana | 18003 | 59175 | 840 |
1869307 | 1869307 | 2021-10-31 | Allen | Indiana | 18003 | 58844 | 839 |
1866058 | 1866058 | 2021-10-30 | Allen | Indiana | 18003 | 58844 | 839 |
1862809 | 1862809 | 2021-10-29 | Allen | Indiana | 18003 | 58844 | 839 |
1859560 | 1859560 | 2021-10-28 | Allen | Indiana | 18003 | 58699 | 839 |
1856311 | 1856311 | 2021-10-27 | Allen | Indiana | 18003 | 58547 | 835 |
1853062 | 1853062 | 2021-10-26 | Allen | Indiana | 18003 | 58400 | 829 |
1849813 | 1849813 | 2021-10-25 | Allen | Indiana | 18003 | 58313 | 827 |
1846563 | 1846563 | 2021-10-24 | Allen | Indiana | 18003 | 58052 | 826 |
1843313 | 1843313 | 2021-10-23 | Allen | Indiana | 18003 | 58052 | 826 |
1840063 | 1840063 | 2021-10-22 | Allen | Indiana | 18003 | 58052 | 826 |
1836814 | 1836814 | 2021-10-21 | Allen | Indiana | 18003 | 57879 | 826 |
1833565 | 1833565 | 2021-10-20 | Allen | Indiana | 18003 | 57733 | 825 |
1830316 | 1830316 | 2021-10-19 | Allen | Indiana | 18003 | 57576 | 821 |
1827067 | 1827067 | 2021-10-18 | Allen | Indiana | 18003 | 57500 | 818 |
1823818 | 1823818 | 2021-10-17 | Allen | Indiana | 18003 | 57219 | 816 |
1820569 | 1820569 | 2021-10-16 | Allen | Indiana | 18003 | 57219 | 816 |
1817320 | 1817320 | 2021-10-15 | Allen | Indiana | 18003 | 57219 | 816 |
1814072 | 1814072 | 2021-10-14 | Allen | Indiana | 18003 | 57059 | 816 |
1810823 | 1810823 | 2021-10-13 | Allen | Indiana | 18003 | 56825 | 814 |
1807574 | 1807574 | 2021-10-12 | Allen | Indiana | 18003 | 56648 | 814 |
1804323 | 1804323 | 2021-10-11 | Allen | Indiana | 18003 | 56483 | 813 |
1801074 | 1801074 | 2021-10-10 | Allen | Indiana | 18003 | 56184 | 812 |
1797825 | 1797825 | 2021-10-09 | Allen | Indiana | 18003 | 56184 | 812 |
1794576 | 1794576 | 2021-10-08 | Allen | Indiana | 18003 | 56184 | 812 |
1791328 | 1791328 | 2021-10-07 | Allen | Indiana | 18003 | 55910 | 812 |
1788079 | 1788079 | 2021-10-06 | Allen | Indiana | 18003 | 55794 | 811 |
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);