ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where county = "Wayne" and fips = 17191 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174893 | 2174893 | 2022-02-02 | Wayne | Illinois | 17191 | 5021 | 75 |
2171640 | 2171640 | 2022-02-01 | Wayne | Illinois | 17191 | 5002 | 74 |
2168387 | 2168387 | 2022-01-31 | Wayne | Illinois | 17191 | 4972 | 74 |
2165132 | 2165132 | 2022-01-30 | Wayne | Illinois | 17191 | 4895 | 74 |
2161877 | 2161877 | 2022-01-29 | Wayne | Illinois | 17191 | 4895 | 74 |
2158622 | 2158622 | 2022-01-28 | Wayne | Illinois | 17191 | 4895 | 74 |
2155368 | 2155368 | 2022-01-27 | Wayne | Illinois | 17191 | 4832 | 74 |
2152115 | 2152115 | 2022-01-26 | Wayne | Illinois | 17191 | 4771 | 73 |
2148863 | 2148863 | 2022-01-25 | Wayne | Illinois | 17191 | 4685 | 73 |
2145611 | 2145611 | 2022-01-24 | Wayne | Illinois | 17191 | 4646 | 73 |
2142356 | 2142356 | 2022-01-23 | Wayne | Illinois | 17191 | 4488 | 73 |
2139101 | 2139101 | 2022-01-22 | Wayne | Illinois | 17191 | 4488 | 73 |
2135845 | 2135845 | 2022-01-21 | Wayne | Illinois | 17191 | 4488 | 73 |
2132593 | 2132593 | 2022-01-20 | Wayne | Illinois | 17191 | 4385 | 72 |
2129340 | 2129340 | 2022-01-19 | Wayne | Illinois | 17191 | 4326 | 71 |
2126086 | 2126086 | 2022-01-18 | Wayne | Illinois | 17191 | 4225 | 71 |
2122834 | 2122834 | 2022-01-17 | Wayne | Illinois | 17191 | 4069 | 71 |
2119582 | 2119582 | 2022-01-16 | Wayne | Illinois | 17191 | 4069 | 71 |
2116330 | 2116330 | 2022-01-15 | Wayne | Illinois | 17191 | 4069 | 71 |
2113079 | 2113079 | 2022-01-14 | Wayne | Illinois | 17191 | 4069 | 71 |
2109827 | 2109827 | 2022-01-13 | Wayne | Illinois | 17191 | 4012 | 70 |
2106576 | 2106576 | 2022-01-12 | Wayne | Illinois | 17191 | 3951 | 70 |
2103325 | 2103325 | 2022-01-11 | Wayne | Illinois | 17191 | 3894 | 68 |
2100074 | 2100074 | 2022-01-10 | Wayne | Illinois | 17191 | 3836 | 68 |
2096823 | 2096823 | 2022-01-09 | Wayne | Illinois | 17191 | 3763 | 68 |
2093571 | 2093571 | 2022-01-08 | Wayne | Illinois | 17191 | 3763 | 68 |
2090319 | 2090319 | 2022-01-07 | Wayne | Illinois | 17191 | 3763 | 68 |
2087068 | 2087068 | 2022-01-06 | Wayne | Illinois | 17191 | 3723 | 68 |
2083816 | 2083816 | 2022-01-05 | Wayne | Illinois | 17191 | 3701 | 68 |
2080564 | 2080564 | 2022-01-04 | Wayne | Illinois | 17191 | 3667 | 68 |
2077312 | 2077312 | 2022-01-03 | Wayne | Illinois | 17191 | 3639 | 68 |
2074061 | 2074061 | 2022-01-02 | Wayne | Illinois | 17191 | 3582 | 67 |
2070810 | 2070810 | 2022-01-01 | Wayne | Illinois | 17191 | 3582 | 67 |
2067559 | 2067559 | 2021-12-31 | Wayne | Illinois | 17191 | 3582 | 67 |
2064308 | 2064308 | 2021-12-30 | Wayne | Illinois | 17191 | 3582 | 67 |
2061058 | 2061058 | 2021-12-29 | Wayne | Illinois | 17191 | 3557 | 67 |
2057809 | 2057809 | 2021-12-28 | Wayne | Illinois | 17191 | 3536 | 67 |
2054560 | 2054560 | 2021-12-27 | Wayne | Illinois | 17191 | 3521 | 67 |
2051310 | 2051310 | 2021-12-26 | Wayne | Illinois | 17191 | 3480 | 67 |
2048060 | 2048060 | 2021-12-25 | Wayne | Illinois | 17191 | 3480 | 67 |
2044810 | 2044810 | 2021-12-24 | Wayne | Illinois | 17191 | 3480 | 67 |
2041561 | 2041561 | 2021-12-23 | Wayne | Illinois | 17191 | 3480 | 67 |
2038311 | 2038311 | 2021-12-22 | Wayne | Illinois | 17191 | 3464 | 67 |
2035061 | 2035061 | 2021-12-21 | Wayne | Illinois | 17191 | 3448 | 67 |
2031811 | 2031811 | 2021-12-20 | Wayne | Illinois | 17191 | 3443 | 67 |
2028560 | 2028560 | 2021-12-19 | Wayne | Illinois | 17191 | 3422 | 67 |
2025309 | 2025309 | 2021-12-18 | Wayne | Illinois | 17191 | 3422 | 67 |
2022058 | 2022058 | 2021-12-17 | Wayne | Illinois | 17191 | 3422 | 67 |
2018807 | 2018807 | 2021-12-16 | Wayne | Illinois | 17191 | 3413 | 67 |
2015557 | 2015557 | 2021-12-15 | Wayne | Illinois | 17191 | 3399 | 67 |
2012306 | 2012306 | 2021-12-14 | Wayne | Illinois | 17191 | 3390 | 67 |
2009055 | 2009055 | 2021-12-13 | Wayne | Illinois | 17191 | 3373 | 67 |
2005804 | 2005804 | 2021-12-12 | Wayne | Illinois | 17191 | 3340 | 67 |
2002553 | 2002553 | 2021-12-11 | Wayne | Illinois | 17191 | 3340 | 67 |
1999303 | 1999303 | 2021-12-10 | Wayne | Illinois | 17191 | 3340 | 67 |
1996052 | 1996052 | 2021-12-09 | Wayne | Illinois | 17191 | 3330 | 67 |
1992801 | 1992801 | 2021-12-08 | Wayne | Illinois | 17191 | 3323 | 67 |
1989550 | 1989550 | 2021-12-07 | Wayne | Illinois | 17191 | 3318 | 67 |
1986300 | 1986300 | 2021-12-06 | Wayne | Illinois | 17191 | 3308 | 66 |
1983050 | 1983050 | 2021-12-05 | Wayne | Illinois | 17191 | 3289 | 66 |
1979800 | 1979800 | 2021-12-04 | Wayne | Illinois | 17191 | 3289 | 66 |
1976550 | 1976550 | 2021-12-03 | Wayne | Illinois | 17191 | 3289 | 66 |
1973301 | 1973301 | 2021-12-02 | Wayne | Illinois | 17191 | 3278 | 66 |
1970051 | 1970051 | 2021-12-01 | Wayne | Illinois | 17191 | 3266 | 66 |
1966801 | 1966801 | 2021-11-30 | Wayne | Illinois | 17191 | 3257 | 66 |
1963549 | 1963549 | 2021-11-29 | Wayne | Illinois | 17191 | 3247 | 66 |
1960298 | 1960298 | 2021-11-28 | Wayne | Illinois | 17191 | 3220 | 66 |
1957047 | 1957047 | 2021-11-27 | Wayne | Illinois | 17191 | 3220 | 66 |
1953796 | 1953796 | 2021-11-26 | Wayne | Illinois | 17191 | 3220 | 66 |
1950545 | 1950545 | 2021-11-25 | Wayne | Illinois | 17191 | 3220 | 66 |
1947294 | 1947294 | 2021-11-24 | Wayne | Illinois | 17191 | 3220 | 66 |
1944043 | 1944043 | 2021-11-23 | Wayne | Illinois | 17191 | 3210 | 66 |
1940793 | 1940793 | 2021-11-22 | Wayne | Illinois | 17191 | 3200 | 66 |
1937543 | 1937543 | 2021-11-21 | Wayne | Illinois | 17191 | 3184 | 66 |
1934293 | 1934293 | 2021-11-20 | Wayne | Illinois | 17191 | 3184 | 66 |
1931042 | 1931042 | 2021-11-19 | Wayne | Illinois | 17191 | 3184 | 66 |
1927791 | 1927791 | 2021-11-18 | Wayne | Illinois | 17191 | 3178 | 66 |
1924541 | 1924541 | 2021-11-17 | Wayne | Illinois | 17191 | 3173 | 66 |
1921292 | 1921292 | 2021-11-16 | Wayne | Illinois | 17191 | 3167 | 66 |
1918042 | 1918042 | 2021-11-15 | Wayne | Illinois | 17191 | 3155 | 66 |
1914792 | 1914792 | 2021-11-14 | Wayne | Illinois | 17191 | 3142 | 66 |
1911542 | 1911542 | 2021-11-13 | Wayne | Illinois | 17191 | 3142 | 66 |
1908293 | 1908293 | 2021-11-12 | Wayne | Illinois | 17191 | 3142 | 66 |
1905044 | 1905044 | 2021-11-11 | Wayne | Illinois | 17191 | 3130 | 66 |
1901794 | 1901794 | 2021-11-10 | Wayne | Illinois | 17191 | 3130 | 66 |
1898544 | 1898544 | 2021-11-09 | Wayne | Illinois | 17191 | 3122 | 66 |
1895294 | 1895294 | 2021-11-08 | Wayne | Illinois | 17191 | 3115 | 66 |
1892044 | 1892044 | 2021-11-07 | Wayne | Illinois | 17191 | 3104 | 65 |
1888794 | 1888794 | 2021-11-06 | Wayne | Illinois | 17191 | 3104 | 65 |
1885544 | 1885544 | 2021-11-05 | Wayne | Illinois | 17191 | 3104 | 65 |
1882295 | 1882295 | 2021-11-04 | Wayne | Illinois | 17191 | 3099 | 65 |
1879046 | 1879046 | 2021-11-03 | Wayne | Illinois | 17191 | 3093 | 65 |
1875797 | 1875797 | 2021-11-02 | Wayne | Illinois | 17191 | 3092 | 64 |
1872548 | 1872548 | 2021-11-01 | Wayne | Illinois | 17191 | 3091 | 64 |
1869299 | 1869299 | 2021-10-31 | Wayne | Illinois | 17191 | 3087 | 64 |
1866050 | 1866050 | 2021-10-30 | Wayne | Illinois | 17191 | 3087 | 64 |
1862801 | 1862801 | 2021-10-29 | Wayne | Illinois | 17191 | 3087 | 64 |
1859552 | 1859552 | 2021-10-28 | Wayne | Illinois | 17191 | 3088 | 64 |
1856303 | 1856303 | 2021-10-27 | Wayne | Illinois | 17191 | 3081 | 64 |
1853054 | 1853054 | 2021-10-26 | Wayne | Illinois | 17191 | 3078 | 64 |
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);