ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Johnson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174840 | 2174840 | 2022-02-02 | Johnson | Illinois | 17087 | 3985 | 44 |
2171587 | 2171587 | 2022-02-01 | Johnson | Illinois | 17087 | 3935 | 44 |
2168334 | 2168334 | 2022-01-31 | Johnson | Illinois | 17087 | 3911 | 44 |
2165079 | 2165079 | 2022-01-30 | Johnson | Illinois | 17087 | 3783 | 44 |
2161824 | 2161824 | 2022-01-29 | Johnson | Illinois | 17087 | 3783 | 44 |
2158569 | 2158569 | 2022-01-28 | Johnson | Illinois | 17087 | 3783 | 44 |
2155315 | 2155315 | 2022-01-27 | Johnson | Illinois | 17087 | 3734 | 44 |
2152062 | 2152062 | 2022-01-26 | Johnson | Illinois | 17087 | 3681 | 43 |
2148810 | 2148810 | 2022-01-25 | Johnson | Illinois | 17087 | 3575 | 43 |
2145558 | 2145558 | 2022-01-24 | Johnson | Illinois | 17087 | 3538 | 43 |
2142303 | 2142303 | 2022-01-23 | Johnson | Illinois | 17087 | 3406 | 43 |
2139048 | 2139048 | 2022-01-22 | Johnson | Illinois | 17087 | 3406 | 43 |
2135792 | 2135792 | 2022-01-21 | Johnson | Illinois | 17087 | 3406 | 43 |
2132540 | 2132540 | 2022-01-20 | Johnson | Illinois | 17087 | 3364 | 43 |
2129287 | 2129287 | 2022-01-19 | Johnson | Illinois | 17087 | 3300 | 43 |
2126033 | 2126033 | 2022-01-18 | Johnson | Illinois | 17087 | 3190 | 43 |
2122781 | 2122781 | 2022-01-17 | Johnson | Illinois | 17087 | 3067 | 43 |
2119529 | 2119529 | 2022-01-16 | Johnson | Illinois | 17087 | 3067 | 43 |
2116277 | 2116277 | 2022-01-15 | Johnson | Illinois | 17087 | 3067 | 43 |
2113026 | 2113026 | 2022-01-14 | Johnson | Illinois | 17087 | 3067 | 43 |
2109774 | 2109774 | 2022-01-13 | Johnson | Illinois | 17087 | 3025 | 43 |
2106523 | 2106523 | 2022-01-12 | Johnson | Illinois | 17087 | 2988 | 41 |
2103272 | 2103272 | 2022-01-11 | Johnson | Illinois | 17087 | 2956 | 41 |
2100021 | 2100021 | 2022-01-10 | Johnson | Illinois | 17087 | 2936 | 41 |
2096770 | 2096770 | 2022-01-09 | Johnson | Illinois | 17087 | 2891 | 41 |
2093518 | 2093518 | 2022-01-08 | Johnson | Illinois | 17087 | 2891 | 41 |
2090266 | 2090266 | 2022-01-07 | Johnson | Illinois | 17087 | 2891 | 41 |
2087015 | 2087015 | 2022-01-06 | Johnson | Illinois | 17087 | 2878 | 40 |
2083763 | 2083763 | 2022-01-05 | Johnson | Illinois | 17087 | 2851 | 40 |
2080511 | 2080511 | 2022-01-04 | Johnson | Illinois | 17087 | 2818 | 40 |
2077259 | 2077259 | 2022-01-03 | Johnson | Illinois | 17087 | 2794 | 40 |
2074008 | 2074008 | 2022-01-02 | Johnson | Illinois | 17087 | 2720 | 40 |
2070757 | 2070757 | 2022-01-01 | Johnson | Illinois | 17087 | 2720 | 40 |
2067506 | 2067506 | 2021-12-31 | Johnson | Illinois | 17087 | 2720 | 40 |
2064255 | 2064255 | 2021-12-30 | Johnson | Illinois | 17087 | 2720 | 40 |
2061005 | 2061005 | 2021-12-29 | Johnson | Illinois | 17087 | 2692 | 39 |
2057756 | 2057756 | 2021-12-28 | Johnson | Illinois | 17087 | 2678 | 39 |
2054507 | 2054507 | 2021-12-27 | Johnson | Illinois | 17087 | 2671 | 39 |
2051257 | 2051257 | 2021-12-26 | Johnson | Illinois | 17087 | 2653 | 39 |
2048007 | 2048007 | 2021-12-25 | Johnson | Illinois | 17087 | 2653 | 39 |
2044757 | 2044757 | 2021-12-24 | Johnson | Illinois | 17087 | 2653 | 39 |
2041508 | 2041508 | 2021-12-23 | Johnson | Illinois | 17087 | 2653 | 39 |
2038258 | 2038258 | 2021-12-22 | Johnson | Illinois | 17087 | 2646 | 38 |
2035008 | 2035008 | 2021-12-21 | Johnson | Illinois | 17087 | 2636 | 38 |
2031758 | 2031758 | 2021-12-20 | Johnson | Illinois | 17087 | 2627 | 38 |
2028507 | 2028507 | 2021-12-19 | Johnson | Illinois | 17087 | 2595 | 38 |
2025256 | 2025256 | 2021-12-18 | Johnson | Illinois | 17087 | 2595 | 38 |
2022005 | 2022005 | 2021-12-17 | Johnson | Illinois | 17087 | 2595 | 38 |
2018754 | 2018754 | 2021-12-16 | Johnson | Illinois | 17087 | 2589 | 38 |
2015504 | 2015504 | 2021-12-15 | Johnson | Illinois | 17087 | 2581 | 38 |
2012253 | 2012253 | 2021-12-14 | Johnson | Illinois | 17087 | 2574 | 38 |
2009002 | 2009002 | 2021-12-13 | Johnson | Illinois | 17087 | 2562 | 38 |
2005751 | 2005751 | 2021-12-12 | Johnson | Illinois | 17087 | 2539 | 38 |
2002500 | 2002500 | 2021-12-11 | Johnson | Illinois | 17087 | 2539 | 38 |
1999250 | 1999250 | 2021-12-10 | Johnson | Illinois | 17087 | 2539 | 38 |
1995999 | 1995999 | 2021-12-09 | Johnson | Illinois | 17087 | 2526 | 38 |
1992748 | 1992748 | 2021-12-08 | Johnson | Illinois | 17087 | 2515 | 38 |
1989497 | 1989497 | 2021-12-07 | Johnson | Illinois | 17087 | 2506 | 38 |
1986247 | 1986247 | 2021-12-06 | Johnson | Illinois | 17087 | 2496 | 38 |
1982997 | 1982997 | 2021-12-05 | Johnson | Illinois | 17087 | 2481 | 38 |
1979747 | 1979747 | 2021-12-04 | Johnson | Illinois | 17087 | 2481 | 38 |
1976497 | 1976497 | 2021-12-03 | Johnson | Illinois | 17087 | 2481 | 38 |
1973248 | 1973248 | 2021-12-02 | Johnson | Illinois | 17087 | 2473 | 38 |
1969998 | 1969998 | 2021-12-01 | Johnson | Illinois | 17087 | 2463 | 38 |
1966748 | 1966748 | 2021-11-30 | Johnson | Illinois | 17087 | 2457 | 38 |
1963496 | 1963496 | 2021-11-29 | Johnson | Illinois | 17087 | 2450 | 38 |
1960245 | 1960245 | 2021-11-28 | Johnson | Illinois | 17087 | 2430 | 38 |
1956994 | 1956994 | 2021-11-27 | Johnson | Illinois | 17087 | 2430 | 38 |
1953743 | 1953743 | 2021-11-26 | Johnson | Illinois | 17087 | 2430 | 38 |
1950492 | 1950492 | 2021-11-25 | Johnson | Illinois | 17087 | 2430 | 38 |
1947241 | 1947241 | 2021-11-24 | Johnson | Illinois | 17087 | 2430 | 38 |
1943990 | 1943990 | 2021-11-23 | Johnson | Illinois | 17087 | 2423 | 38 |
1940740 | 1940740 | 2021-11-22 | Johnson | Illinois | 17087 | 2414 | 38 |
1937490 | 1937490 | 2021-11-21 | Johnson | Illinois | 17087 | 2412 | 38 |
1934240 | 1934240 | 2021-11-20 | Johnson | Illinois | 17087 | 2412 | 38 |
1930989 | 1930989 | 2021-11-19 | Johnson | Illinois | 17087 | 2412 | 38 |
1927738 | 1927738 | 2021-11-18 | Johnson | Illinois | 17087 | 2405 | 38 |
1924488 | 1924488 | 2021-11-17 | Johnson | Illinois | 17087 | 2399 | 38 |
1921239 | 1921239 | 2021-11-16 | Johnson | Illinois | 17087 | 2396 | 38 |
1917989 | 1917989 | 2021-11-15 | Johnson | Illinois | 17087 | 2392 | 38 |
1914739 | 1914739 | 2021-11-14 | Johnson | Illinois | 17087 | 2385 | 38 |
1911489 | 1911489 | 2021-11-13 | Johnson | Illinois | 17087 | 2385 | 38 |
1908240 | 1908240 | 2021-11-12 | Johnson | Illinois | 17087 | 2385 | 38 |
1904991 | 1904991 | 2021-11-11 | Johnson | Illinois | 17087 | 2383 | 38 |
1901741 | 1901741 | 2021-11-10 | Johnson | Illinois | 17087 | 2383 | 38 |
1898491 | 1898491 | 2021-11-09 | Johnson | Illinois | 17087 | 2377 | 38 |
1895241 | 1895241 | 2021-11-08 | Johnson | Illinois | 17087 | 2372 | 38 |
1891991 | 1891991 | 2021-11-07 | Johnson | Illinois | 17087 | 2363 | 38 |
1888741 | 1888741 | 2021-11-06 | Johnson | Illinois | 17087 | 2363 | 38 |
1885491 | 1885491 | 2021-11-05 | Johnson | Illinois | 17087 | 2363 | 38 |
1882242 | 1882242 | 2021-11-04 | Johnson | Illinois | 17087 | 2360 | 38 |
1878993 | 1878993 | 2021-11-03 | Johnson | Illinois | 17087 | 2351 | 38 |
1875744 | 1875744 | 2021-11-02 | Johnson | Illinois | 17087 | 2349 | 38 |
1872495 | 1872495 | 2021-11-01 | Johnson | Illinois | 17087 | 2346 | 38 |
1869246 | 1869246 | 2021-10-31 | Johnson | Illinois | 17087 | 2336 | 38 |
1865997 | 1865997 | 2021-10-30 | Johnson | Illinois | 17087 | 2336 | 38 |
1862748 | 1862748 | 2021-10-29 | Johnson | Illinois | 17087 | 2336 | 38 |
1859499 | 1859499 | 2021-10-28 | Johnson | Illinois | 17087 | 2333 | 38 |
1856250 | 1856250 | 2021-10-27 | Johnson | Illinois | 17087 | 2329 | 38 |
1853001 | 1853001 | 2021-10-26 | Johnson | Illinois | 17087 | 2317 | 38 |
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);