ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Warren" and fips = 17187 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174891 | 2174891 | 2022-02-02 | Warren | Illinois | 17187 | 3842 | 81 |
2171638 | 2171638 | 2022-02-01 | Warren | Illinois | 17187 | 3814 | 81 |
2168385 | 2168385 | 2022-01-31 | Warren | Illinois | 17187 | 3793 | 80 |
2165130 | 2165130 | 2022-01-30 | Warren | Illinois | 17187 | 3767 | 80 |
2161875 | 2161875 | 2022-01-29 | Warren | Illinois | 17187 | 3767 | 80 |
2158620 | 2158620 | 2022-01-28 | Warren | Illinois | 17187 | 3767 | 80 |
2155366 | 2155366 | 2022-01-27 | Warren | Illinois | 17187 | 3736 | 80 |
2152113 | 2152113 | 2022-01-26 | Warren | Illinois | 17187 | 3710 | 80 |
2148861 | 2148861 | 2022-01-25 | Warren | Illinois | 17187 | 3685 | 80 |
2145609 | 2145609 | 2022-01-24 | Warren | Illinois | 17187 | 3647 | 80 |
2142354 | 2142354 | 2022-01-23 | Warren | Illinois | 17187 | 3601 | 80 |
2139099 | 2139099 | 2022-01-22 | Warren | Illinois | 17187 | 3601 | 80 |
2135843 | 2135843 | 2022-01-21 | Warren | Illinois | 17187 | 3601 | 80 |
2132591 | 2132591 | 2022-01-20 | Warren | Illinois | 17187 | 3581 | 79 |
2129338 | 2129338 | 2022-01-19 | Warren | Illinois | 17187 | 3555 | 77 |
2126084 | 2126084 | 2022-01-18 | Warren | Illinois | 17187 | 3508 | 76 |
2122832 | 2122832 | 2022-01-17 | Warren | Illinois | 17187 | 3462 | 76 |
2119580 | 2119580 | 2022-01-16 | Warren | Illinois | 17187 | 3462 | 76 |
2116328 | 2116328 | 2022-01-15 | Warren | Illinois | 17187 | 3462 | 76 |
2113077 | 2113077 | 2022-01-14 | Warren | Illinois | 17187 | 3462 | 76 |
2109825 | 2109825 | 2022-01-13 | Warren | Illinois | 17187 | 3415 | 76 |
2106574 | 2106574 | 2022-01-12 | Warren | Illinois | 17187 | 3380 | 76 |
2103323 | 2103323 | 2022-01-11 | Warren | Illinois | 17187 | 3318 | 76 |
2100072 | 2100072 | 2022-01-10 | Warren | Illinois | 17187 | 3272 | 75 |
2096821 | 2096821 | 2022-01-09 | Warren | Illinois | 17187 | 3216 | 75 |
2093569 | 2093569 | 2022-01-08 | Warren | Illinois | 17187 | 3216 | 75 |
2090317 | 2090317 | 2022-01-07 | Warren | Illinois | 17187 | 3216 | 75 |
2087066 | 2087066 | 2022-01-06 | Warren | Illinois | 17187 | 3181 | 75 |
2083814 | 2083814 | 2022-01-05 | Warren | Illinois | 17187 | 3122 | 75 |
2080562 | 2080562 | 2022-01-04 | Warren | Illinois | 17187 | 3080 | 75 |
2077310 | 2077310 | 2022-01-03 | Warren | Illinois | 17187 | 3063 | 75 |
2074059 | 2074059 | 2022-01-02 | Warren | Illinois | 17187 | 2978 | 75 |
2070808 | 2070808 | 2022-01-01 | Warren | Illinois | 17187 | 2978 | 75 |
2067557 | 2067557 | 2021-12-31 | Warren | Illinois | 17187 | 2978 | 75 |
2064306 | 2064306 | 2021-12-30 | Warren | Illinois | 17187 | 2978 | 75 |
2061056 | 2061056 | 2021-12-29 | Warren | Illinois | 17187 | 2953 | 74 |
2057807 | 2057807 | 2021-12-28 | Warren | Illinois | 17187 | 2920 | 73 |
2054558 | 2054558 | 2021-12-27 | Warren | Illinois | 17187 | 2908 | 73 |
2051308 | 2051308 | 2021-12-26 | Warren | Illinois | 17187 | 2881 | 73 |
2048058 | 2048058 | 2021-12-25 | Warren | Illinois | 17187 | 2881 | 73 |
2044808 | 2044808 | 2021-12-24 | Warren | Illinois | 17187 | 2881 | 73 |
2041559 | 2041559 | 2021-12-23 | Warren | Illinois | 17187 | 2881 | 73 |
2038309 | 2038309 | 2021-12-22 | Warren | Illinois | 17187 | 2869 | 73 |
2035059 | 2035059 | 2021-12-21 | Warren | Illinois | 17187 | 2848 | 73 |
2031809 | 2031809 | 2021-12-20 | Warren | Illinois | 17187 | 2829 | 73 |
2028558 | 2028558 | 2021-12-19 | Warren | Illinois | 17187 | 2800 | 72 |
2025307 | 2025307 | 2021-12-18 | Warren | Illinois | 17187 | 2800 | 72 |
2022056 | 2022056 | 2021-12-17 | Warren | Illinois | 17187 | 2800 | 72 |
2018805 | 2018805 | 2021-12-16 | Warren | Illinois | 17187 | 2790 | 72 |
2015555 | 2015555 | 2021-12-15 | Warren | Illinois | 17187 | 2767 | 72 |
2012304 | 2012304 | 2021-12-14 | Warren | Illinois | 17187 | 2750 | 72 |
2009053 | 2009053 | 2021-12-13 | Warren | Illinois | 17187 | 2734 | 72 |
2005802 | 2005802 | 2021-12-12 | Warren | Illinois | 17187 | 2716 | 72 |
2002551 | 2002551 | 2021-12-11 | Warren | Illinois | 17187 | 2716 | 72 |
1999301 | 1999301 | 2021-12-10 | Warren | Illinois | 17187 | 2716 | 72 |
1996050 | 1996050 | 2021-12-09 | Warren | Illinois | 17187 | 2700 | 72 |
1992799 | 1992799 | 2021-12-08 | Warren | Illinois | 17187 | 2682 | 72 |
1989548 | 1989548 | 2021-12-07 | Warren | Illinois | 17187 | 2672 | 72 |
1986298 | 1986298 | 2021-12-06 | Warren | Illinois | 17187 | 2664 | 72 |
1983048 | 1983048 | 2021-12-05 | Warren | Illinois | 17187 | 2640 | 72 |
1979798 | 1979798 | 2021-12-04 | Warren | Illinois | 17187 | 2640 | 72 |
1976548 | 1976548 | 2021-12-03 | Warren | Illinois | 17187 | 2640 | 72 |
1973299 | 1973299 | 2021-12-02 | Warren | Illinois | 17187 | 2638 | 72 |
1970049 | 1970049 | 2021-12-01 | Warren | Illinois | 17187 | 2613 | 72 |
1966799 | 1966799 | 2021-11-30 | Warren | Illinois | 17187 | 2607 | 72 |
1963547 | 1963547 | 2021-11-29 | Warren | Illinois | 17187 | 2602 | 71 |
1960296 | 1960296 | 2021-11-28 | Warren | Illinois | 17187 | 2590 | 71 |
1957045 | 1957045 | 2021-11-27 | Warren | Illinois | 17187 | 2590 | 71 |
1953794 | 1953794 | 2021-11-26 | Warren | Illinois | 17187 | 2590 | 71 |
1950543 | 1950543 | 2021-11-25 | Warren | Illinois | 17187 | 2590 | 71 |
1947292 | 1947292 | 2021-11-24 | Warren | Illinois | 17187 | 2590 | 71 |
1944041 | 1944041 | 2021-11-23 | Warren | Illinois | 17187 | 2576 | 71 |
1940791 | 1940791 | 2021-11-22 | Warren | Illinois | 17187 | 2574 | 71 |
1937541 | 1937541 | 2021-11-21 | Warren | Illinois | 17187 | 2565 | 71 |
1934291 | 1934291 | 2021-11-20 | Warren | Illinois | 17187 | 2565 | 71 |
1931040 | 1931040 | 2021-11-19 | Warren | Illinois | 17187 | 2565 | 71 |
1927789 | 1927789 | 2021-11-18 | Warren | Illinois | 17187 | 2563 | 71 |
1924539 | 1924539 | 2021-11-17 | Warren | Illinois | 17187 | 2557 | 71 |
1921290 | 1921290 | 2021-11-16 | Warren | Illinois | 17187 | 2554 | 71 |
1918040 | 1918040 | 2021-11-15 | Warren | Illinois | 17187 | 2552 | 71 |
1914790 | 1914790 | 2021-11-14 | Warren | Illinois | 17187 | 2540 | 71 |
1911540 | 1911540 | 2021-11-13 | Warren | Illinois | 17187 | 2540 | 71 |
1908291 | 1908291 | 2021-11-12 | Warren | Illinois | 17187 | 2540 | 71 |
1905042 | 1905042 | 2021-11-11 | Warren | Illinois | 17187 | 2527 | 71 |
1901792 | 1901792 | 2021-11-10 | Warren | Illinois | 17187 | 2527 | 71 |
1898542 | 1898542 | 2021-11-09 | Warren | Illinois | 17187 | 2520 | 71 |
1895292 | 1895292 | 2021-11-08 | Warren | Illinois | 17187 | 2514 | 71 |
1892042 | 1892042 | 2021-11-07 | Warren | Illinois | 17187 | 2502 | 71 |
1888792 | 1888792 | 2021-11-06 | Warren | Illinois | 17187 | 2502 | 71 |
1885542 | 1885542 | 2021-11-05 | Warren | Illinois | 17187 | 2502 | 71 |
1882293 | 1882293 | 2021-11-04 | Warren | Illinois | 17187 | 2492 | 71 |
1879044 | 1879044 | 2021-11-03 | Warren | Illinois | 17187 | 2485 | 71 |
1875795 | 1875795 | 2021-11-02 | Warren | Illinois | 17187 | 2484 | 70 |
1872546 | 1872546 | 2021-11-01 | Warren | Illinois | 17187 | 2483 | 70 |
1869297 | 1869297 | 2021-10-31 | Warren | Illinois | 17187 | 2473 | 69 |
1866048 | 1866048 | 2021-10-30 | Warren | Illinois | 17187 | 2473 | 69 |
1862799 | 1862799 | 2021-10-29 | Warren | Illinois | 17187 | 2473 | 69 |
1859550 | 1859550 | 2021-10-28 | Warren | Illinois | 17187 | 2469 | 69 |
1856301 | 1856301 | 2021-10-27 | Warren | Illinois | 17187 | 2462 | 69 |
1853052 | 1853052 | 2021-10-26 | Warren | Illinois | 17187 | 2458 | 69 |
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);