ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Perry" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174961 | 2174961 | 2022-02-02 | Perry | Indiana | 18123 | 4458 | 64 |
2171708 | 2171708 | 2022-02-01 | Perry | Indiana | 18123 | 4418 | 63 |
2168455 | 2168455 | 2022-01-31 | Perry | Indiana | 18123 | 4381 | 62 |
2165200 | 2165200 | 2022-01-30 | Perry | Indiana | 18123 | 4327 | 61 |
2161945 | 2161945 | 2022-01-29 | Perry | Indiana | 18123 | 4327 | 61 |
2158690 | 2158690 | 2022-01-28 | Perry | Indiana | 18123 | 4327 | 61 |
2155436 | 2155436 | 2022-01-27 | Perry | Indiana | 18123 | 4273 | 61 |
2152183 | 2152183 | 2022-01-26 | Perry | Indiana | 18123 | 4239 | 61 |
2148931 | 2148931 | 2022-01-25 | Perry | Indiana | 18123 | 4199 | 61 |
2145679 | 2145679 | 2022-01-24 | Perry | Indiana | 18123 | 4106 | 61 |
2142424 | 2142424 | 2022-01-23 | Perry | Indiana | 18123 | 3990 | 61 |
2139169 | 2139169 | 2022-01-22 | Perry | Indiana | 18123 | 3990 | 61 |
2135913 | 2135913 | 2022-01-21 | Perry | Indiana | 18123 | 3990 | 61 |
2132661 | 2132661 | 2022-01-20 | Perry | Indiana | 18123 | 3879 | 61 |
2129408 | 2129408 | 2022-01-19 | Perry | Indiana | 18123 | 3782 | 61 |
2126154 | 2126154 | 2022-01-18 | Perry | Indiana | 18123 | 3702 | 61 |
2122902 | 2122902 | 2022-01-17 | Perry | Indiana | 18123 | 3636 | 61 |
2119650 | 2119650 | 2022-01-16 | Perry | Indiana | 18123 | 3582 | 61 |
2116398 | 2116398 | 2022-01-15 | Perry | Indiana | 18123 | 3582 | 61 |
2113147 | 2113147 | 2022-01-14 | Perry | Indiana | 18123 | 3582 | 61 |
2109895 | 2109895 | 2022-01-13 | Perry | Indiana | 18123 | 3537 | 61 |
2106644 | 2106644 | 2022-01-12 | Perry | Indiana | 18123 | 3506 | 61 |
2103393 | 2103393 | 2022-01-11 | Perry | Indiana | 18123 | 3451 | 61 |
2100142 | 2100142 | 2022-01-10 | Perry | Indiana | 18123 | 3407 | 61 |
2096891 | 2096891 | 2022-01-09 | Perry | Indiana | 18123 | 3374 | 59 |
2093639 | 2093639 | 2022-01-08 | Perry | Indiana | 18123 | 3374 | 59 |
2090387 | 2090387 | 2022-01-07 | Perry | Indiana | 18123 | 3374 | 59 |
2087136 | 2087136 | 2022-01-06 | Perry | Indiana | 18123 | 3331 | 59 |
2083884 | 2083884 | 2022-01-05 | Perry | Indiana | 18123 | 3298 | 59 |
2080632 | 2080632 | 2022-01-04 | Perry | Indiana | 18123 | 3266 | 59 |
2077380 | 2077380 | 2022-01-03 | Perry | Indiana | 18123 | 3243 | 59 |
2074129 | 2074129 | 2022-01-02 | Perry | Indiana | 18123 | 3226 | 59 |
2070878 | 2070878 | 2022-01-01 | Perry | Indiana | 18123 | 3226 | 59 |
2067627 | 2067627 | 2021-12-31 | Perry | Indiana | 18123 | 3226 | 59 |
2064376 | 2064376 | 2021-12-30 | Perry | Indiana | 18123 | 3226 | 59 |
2061126 | 2061126 | 2021-12-29 | Perry | Indiana | 18123 | 3208 | 59 |
2057877 | 2057877 | 2021-12-28 | Perry | Indiana | 18123 | 3174 | 59 |
2054628 | 2054628 | 2021-12-27 | Perry | Indiana | 18123 | 3151 | 59 |
2051378 | 2051378 | 2021-12-26 | Perry | Indiana | 18123 | 3135 | 59 |
2048128 | 2048128 | 2021-12-25 | Perry | Indiana | 18123 | 3135 | 59 |
2044878 | 2044878 | 2021-12-24 | Perry | Indiana | 18123 | 3135 | 59 |
2041629 | 2041629 | 2021-12-23 | Perry | Indiana | 18123 | 3135 | 59 |
2038379 | 2038379 | 2021-12-22 | Perry | Indiana | 18123 | 3135 | 59 |
2035129 | 2035129 | 2021-12-21 | Perry | Indiana | 18123 | 3122 | 59 |
2031879 | 2031879 | 2021-12-20 | Perry | Indiana | 18123 | 3113 | 59 |
2028628 | 2028628 | 2021-12-19 | Perry | Indiana | 18123 | 3095 | 58 |
2025377 | 2025377 | 2021-12-18 | Perry | Indiana | 18123 | 3095 | 58 |
2022126 | 2022126 | 2021-12-17 | Perry | Indiana | 18123 | 3095 | 58 |
2018875 | 2018875 | 2021-12-16 | Perry | Indiana | 18123 | 3090 | 58 |
2015625 | 2015625 | 2021-12-15 | Perry | Indiana | 18123 | 3077 | 58 |
2012374 | 2012374 | 2021-12-14 | Perry | Indiana | 18123 | 3067 | 58 |
2009123 | 2009123 | 2021-12-13 | Perry | Indiana | 18123 | 3055 | 58 |
2005872 | 2005872 | 2021-12-12 | Perry | Indiana | 18123 | 3035 | 58 |
2002621 | 2002621 | 2021-12-11 | Perry | Indiana | 18123 | 3035 | 58 |
1999371 | 1999371 | 2021-12-10 | Perry | Indiana | 18123 | 3035 | 58 |
1996120 | 1996120 | 2021-12-09 | Perry | Indiana | 18123 | 3001 | 57 |
1992869 | 1992869 | 2021-12-08 | Perry | Indiana | 18123 | 2981 | 57 |
1989618 | 1989618 | 2021-12-07 | Perry | Indiana | 18123 | 2958 | 57 |
1986368 | 1986368 | 2021-12-06 | Perry | Indiana | 18123 | 2941 | 57 |
1983118 | 1983118 | 2021-12-05 | Perry | Indiana | 18123 | 2917 | 56 |
1979868 | 1979868 | 2021-12-04 | Perry | Indiana | 18123 | 2917 | 56 |
1976618 | 1976618 | 2021-12-03 | Perry | Indiana | 18123 | 2917 | 56 |
1973369 | 1973369 | 2021-12-02 | Perry | Indiana | 18123 | 2897 | 56 |
1970119 | 1970119 | 2021-12-01 | Perry | Indiana | 18123 | 2883 | 56 |
1966869 | 1966869 | 2021-11-30 | Perry | Indiana | 18123 | 2863 | 56 |
1963617 | 1963617 | 2021-11-29 | Perry | Indiana | 18123 | 2844 | 56 |
1960366 | 1960366 | 2021-11-28 | Perry | Indiana | 18123 | 2826 | 56 |
1957115 | 1957115 | 2021-11-27 | Perry | Indiana | 18123 | 2826 | 56 |
1953864 | 1953864 | 2021-11-26 | Perry | Indiana | 18123 | 2826 | 56 |
1950613 | 1950613 | 2021-11-25 | Perry | Indiana | 18123 | 2826 | 56 |
1947362 | 1947362 | 2021-11-24 | Perry | Indiana | 18123 | 2826 | 56 |
1944111 | 1944111 | 2021-11-23 | Perry | Indiana | 18123 | 2814 | 56 |
1940861 | 1940861 | 2021-11-22 | Perry | Indiana | 18123 | 2804 | 56 |
1937611 | 1937611 | 2021-11-21 | Perry | Indiana | 18123 | 2780 | 56 |
1934361 | 1934361 | 2021-11-20 | Perry | Indiana | 18123 | 2780 | 56 |
1931110 | 1931110 | 2021-11-19 | Perry | Indiana | 18123 | 2780 | 56 |
1927859 | 1927859 | 2021-11-18 | Perry | Indiana | 18123 | 2768 | 55 |
1924609 | 1924609 | 2021-11-17 | Perry | Indiana | 18123 | 2762 | 55 |
1921360 | 1921360 | 2021-11-16 | Perry | Indiana | 18123 | 2750 | 55 |
1918110 | 1918110 | 2021-11-15 | Perry | Indiana | 18123 | 2744 | 55 |
1914860 | 1914860 | 2021-11-14 | Perry | Indiana | 18123 | 2734 | 55 |
1911610 | 1911610 | 2021-11-13 | Perry | Indiana | 18123 | 2734 | 55 |
1908361 | 1908361 | 2021-11-12 | Perry | Indiana | 18123 | 2734 | 55 |
1905112 | 1905112 | 2021-11-11 | Perry | Indiana | 18123 | 2729 | 55 |
1901862 | 1901862 | 2021-11-10 | Perry | Indiana | 18123 | 2716 | 55 |
1898612 | 1898612 | 2021-11-09 | Perry | Indiana | 18123 | 2709 | 55 |
1895362 | 1895362 | 2021-11-08 | Perry | Indiana | 18123 | 2707 | 55 |
1892112 | 1892112 | 2021-11-07 | Perry | Indiana | 18123 | 2700 | 55 |
1888862 | 1888862 | 2021-11-06 | Perry | Indiana | 18123 | 2700 | 55 |
1885612 | 1885612 | 2021-11-05 | Perry | Indiana | 18123 | 2700 | 55 |
1882363 | 1882363 | 2021-11-04 | Perry | Indiana | 18123 | 2697 | 55 |
1879114 | 1879114 | 2021-11-03 | Perry | Indiana | 18123 | 2689 | 55 |
1875865 | 1875865 | 2021-11-02 | Perry | Indiana | 18123 | 2687 | 55 |
1872616 | 1872616 | 2021-11-01 | Perry | Indiana | 18123 | 2683 | 55 |
1869367 | 1869367 | 2021-10-31 | Perry | Indiana | 18123 | 2682 | 55 |
1866118 | 1866118 | 2021-10-30 | Perry | Indiana | 18123 | 2682 | 55 |
1862869 | 1862869 | 2021-10-29 | Perry | Indiana | 18123 | 2682 | 55 |
1859620 | 1859620 | 2021-10-28 | Perry | Indiana | 18123 | 2680 | 55 |
1856371 | 1856371 | 2021-10-27 | Perry | Indiana | 18123 | 2674 | 55 |
1853122 | 1853122 | 2021-10-26 | Perry | Indiana | 18123 | 2670 | 55 |
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);