ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Crawford" and fips = 17033 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174813 | 2174813 | 2022-02-02 | Crawford | Illinois | 17033 | 5906 | 55 |
2171560 | 2171560 | 2022-02-01 | Crawford | Illinois | 17033 | 5861 | 55 |
2168307 | 2168307 | 2022-01-31 | Crawford | Illinois | 17033 | 5792 | 54 |
2165052 | 2165052 | 2022-01-30 | Crawford | Illinois | 17033 | 5583 | 54 |
2161797 | 2161797 | 2022-01-29 | Crawford | Illinois | 17033 | 5583 | 54 |
2158542 | 2158542 | 2022-01-28 | Crawford | Illinois | 17033 | 5583 | 54 |
2155288 | 2155288 | 2022-01-27 | Crawford | Illinois | 17033 | 5509 | 54 |
2152035 | 2152035 | 2022-01-26 | Crawford | Illinois | 17033 | 5455 | 54 |
2148783 | 2148783 | 2022-01-25 | Crawford | Illinois | 17033 | 5384 | 53 |
2145531 | 2145531 | 2022-01-24 | Crawford | Illinois | 17033 | 5264 | 53 |
2142276 | 2142276 | 2022-01-23 | Crawford | Illinois | 17033 | 4951 | 53 |
2139021 | 2139021 | 2022-01-22 | Crawford | Illinois | 17033 | 4951 | 53 |
2135765 | 2135765 | 2022-01-21 | Crawford | Illinois | 17033 | 4951 | 53 |
2132513 | 2132513 | 2022-01-20 | Crawford | Illinois | 17033 | 4870 | 53 |
2129260 | 2129260 | 2022-01-19 | Crawford | Illinois | 17033 | 4788 | 53 |
2126006 | 2126006 | 2022-01-18 | Crawford | Illinois | 17033 | 4648 | 53 |
2122754 | 2122754 | 2022-01-17 | Crawford | Illinois | 17033 | 4446 | 53 |
2119502 | 2119502 | 2022-01-16 | Crawford | Illinois | 17033 | 4446 | 53 |
2116250 | 2116250 | 2022-01-15 | Crawford | Illinois | 17033 | 4446 | 53 |
2112999 | 2112999 | 2022-01-14 | Crawford | Illinois | 17033 | 4446 | 53 |
2109747 | 2109747 | 2022-01-13 | Crawford | Illinois | 17033 | 4365 | 53 |
2106496 | 2106496 | 2022-01-12 | Crawford | Illinois | 17033 | 4287 | 53 |
2103245 | 2103245 | 2022-01-11 | Crawford | Illinois | 17033 | 4193 | 52 |
2099994 | 2099994 | 2022-01-10 | Crawford | Illinois | 17033 | 4104 | 52 |
2096743 | 2096743 | 2022-01-09 | Crawford | Illinois | 17033 | 4061 | 52 |
2093491 | 2093491 | 2022-01-08 | Crawford | Illinois | 17033 | 4061 | 52 |
2090239 | 2090239 | 2022-01-07 | Crawford | Illinois | 17033 | 4061 | 52 |
2086988 | 2086988 | 2022-01-06 | Crawford | Illinois | 17033 | 4018 | 52 |
2083736 | 2083736 | 2022-01-05 | Crawford | Illinois | 17033 | 3983 | 51 |
2080484 | 2080484 | 2022-01-04 | Crawford | Illinois | 17033 | 3950 | 51 |
2077232 | 2077232 | 2022-01-03 | Crawford | Illinois | 17033 | 3908 | 51 |
2073981 | 2073981 | 2022-01-02 | Crawford | Illinois | 17033 | 3875 | 51 |
2070730 | 2070730 | 2022-01-01 | Crawford | Illinois | 17033 | 3875 | 51 |
2067479 | 2067479 | 2021-12-31 | Crawford | Illinois | 17033 | 3875 | 51 |
2064228 | 2064228 | 2021-12-30 | Crawford | Illinois | 17033 | 3875 | 51 |
2060978 | 2060978 | 2021-12-29 | Crawford | Illinois | 17033 | 3856 | 51 |
2057729 | 2057729 | 2021-12-28 | Crawford | Illinois | 17033 | 3851 | 51 |
2054480 | 2054480 | 2021-12-27 | Crawford | Illinois | 17033 | 3830 | 51 |
2051230 | 2051230 | 2021-12-26 | Crawford | Illinois | 17033 | 3807 | 51 |
2047980 | 2047980 | 2021-12-25 | Crawford | Illinois | 17033 | 3807 | 51 |
2044730 | 2044730 | 2021-12-24 | Crawford | Illinois | 17033 | 3807 | 51 |
2041481 | 2041481 | 2021-12-23 | Crawford | Illinois | 17033 | 3807 | 51 |
2038231 | 2038231 | 2021-12-22 | Crawford | Illinois | 17033 | 3790 | 48 |
2034981 | 2034981 | 2021-12-21 | Crawford | Illinois | 17033 | 3762 | 48 |
2031731 | 2031731 | 2021-12-20 | Crawford | Illinois | 17033 | 3740 | 48 |
2028480 | 2028480 | 2021-12-19 | Crawford | Illinois | 17033 | 3714 | 48 |
2025229 | 2025229 | 2021-12-18 | Crawford | Illinois | 17033 | 3714 | 48 |
2021978 | 2021978 | 2021-12-17 | Crawford | Illinois | 17033 | 3714 | 48 |
2018727 | 2018727 | 2021-12-16 | Crawford | Illinois | 17033 | 3704 | 47 |
2015477 | 2015477 | 2021-12-15 | Crawford | Illinois | 17033 | 3694 | 47 |
2012226 | 2012226 | 2021-12-14 | Crawford | Illinois | 17033 | 3677 | 47 |
2008975 | 2008975 | 2021-12-13 | Crawford | Illinois | 17033 | 3659 | 47 |
2005724 | 2005724 | 2021-12-12 | Crawford | Illinois | 17033 | 3640 | 47 |
2002473 | 2002473 | 2021-12-11 | Crawford | Illinois | 17033 | 3640 | 47 |
1999223 | 1999223 | 2021-12-10 | Crawford | Illinois | 17033 | 3640 | 47 |
1995972 | 1995972 | 2021-12-09 | Crawford | Illinois | 17033 | 3625 | 47 |
1992721 | 1992721 | 2021-12-08 | Crawford | Illinois | 17033 | 3615 | 47 |
1989470 | 1989470 | 2021-12-07 | Crawford | Illinois | 17033 | 3600 | 47 |
1986220 | 1986220 | 2021-12-06 | Crawford | Illinois | 17033 | 3586 | 47 |
1982970 | 1982970 | 2021-12-05 | Crawford | Illinois | 17033 | 3558 | 47 |
1979720 | 1979720 | 2021-12-04 | Crawford | Illinois | 17033 | 3558 | 47 |
1976470 | 1976470 | 2021-12-03 | Crawford | Illinois | 17033 | 3558 | 47 |
1973221 | 1973221 | 2021-12-02 | Crawford | Illinois | 17033 | 3550 | 47 |
1969971 | 1969971 | 2021-12-01 | Crawford | Illinois | 17033 | 3539 | 47 |
1966721 | 1966721 | 2021-11-30 | Crawford | Illinois | 17033 | 3535 | 47 |
1963469 | 1963469 | 2021-11-29 | Crawford | Illinois | 17033 | 3521 | 47 |
1960218 | 1960218 | 2021-11-28 | Crawford | Illinois | 17033 | 3500 | 47 |
1956967 | 1956967 | 2021-11-27 | Crawford | Illinois | 17033 | 3500 | 47 |
1953716 | 1953716 | 2021-11-26 | Crawford | Illinois | 17033 | 3500 | 47 |
1950465 | 1950465 | 2021-11-25 | Crawford | Illinois | 17033 | 3500 | 47 |
1947214 | 1947214 | 2021-11-24 | Crawford | Illinois | 17033 | 3500 | 47 |
1943963 | 1943963 | 2021-11-23 | Crawford | Illinois | 17033 | 3497 | 47 |
1940713 | 1940713 | 2021-11-22 | Crawford | Illinois | 17033 | 3486 | 47 |
1937463 | 1937463 | 2021-11-21 | Crawford | Illinois | 17033 | 3473 | 47 |
1934213 | 1934213 | 2021-11-20 | Crawford | Illinois | 17033 | 3473 | 47 |
1930962 | 1930962 | 2021-11-19 | Crawford | Illinois | 17033 | 3473 | 47 |
1927711 | 1927711 | 2021-11-18 | Crawford | Illinois | 17033 | 3469 | 47 |
1924461 | 1924461 | 2021-11-17 | Crawford | Illinois | 17033 | 3462 | 47 |
1921212 | 1921212 | 2021-11-16 | Crawford | Illinois | 17033 | 3453 | 47 |
1917962 | 1917962 | 2021-11-15 | Crawford | Illinois | 17033 | 3442 | 47 |
1914712 | 1914712 | 2021-11-14 | Crawford | Illinois | 17033 | 3433 | 47 |
1911462 | 1911462 | 2021-11-13 | Crawford | Illinois | 17033 | 3433 | 47 |
1908213 | 1908213 | 2021-11-12 | Crawford | Illinois | 17033 | 3433 | 47 |
1904964 | 1904964 | 2021-11-11 | Crawford | Illinois | 17033 | 3424 | 47 |
1901714 | 1901714 | 2021-11-10 | Crawford | Illinois | 17033 | 3424 | 47 |
1898464 | 1898464 | 2021-11-09 | Crawford | Illinois | 17033 | 3420 | 47 |
1895214 | 1895214 | 2021-11-08 | Crawford | Illinois | 17033 | 3413 | 46 |
1891964 | 1891964 | 2021-11-07 | Crawford | Illinois | 17033 | 3405 | 46 |
1888714 | 1888714 | 2021-11-06 | Crawford | Illinois | 17033 | 3405 | 46 |
1885464 | 1885464 | 2021-11-05 | Crawford | Illinois | 17033 | 3405 | 46 |
1882215 | 1882215 | 2021-11-04 | Crawford | Illinois | 17033 | 3394 | 46 |
1878966 | 1878966 | 2021-11-03 | Crawford | Illinois | 17033 | 3384 | 46 |
1875717 | 1875717 | 2021-11-02 | Crawford | Illinois | 17033 | 3379 | 46 |
1872468 | 1872468 | 2021-11-01 | Crawford | Illinois | 17033 | 3370 | 46 |
1869219 | 1869219 | 2021-10-31 | Crawford | Illinois | 17033 | 3362 | 46 |
1865970 | 1865970 | 2021-10-30 | Crawford | Illinois | 17033 | 3362 | 46 |
1862721 | 1862721 | 2021-10-29 | Crawford | Illinois | 17033 | 3362 | 46 |
1859472 | 1859472 | 2021-10-28 | Crawford | Illinois | 17033 | 3361 | 46 |
1856223 | 1856223 | 2021-10-27 | Crawford | Illinois | 17033 | 3356 | 46 |
1852974 | 1852974 | 2021-10-26 | Crawford | Illinois | 17033 | 3353 | 46 |
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);