ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marion" and fips = 17121 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174854 | 2174854 | 2022-02-02 | Marion | Illinois | 17121 | 11360 | 196 |
2171601 | 2171601 | 2022-02-01 | Marion | Illinois | 17121 | 11313 | 194 |
2168348 | 2168348 | 2022-01-31 | Marion | Illinois | 17121 | 11242 | 194 |
2165093 | 2165093 | 2022-01-30 | Marion | Illinois | 17121 | 11123 | 191 |
2161838 | 2161838 | 2022-01-29 | Marion | Illinois | 17121 | 11123 | 191 |
2158583 | 2158583 | 2022-01-28 | Marion | Illinois | 17121 | 11123 | 191 |
2155329 | 2155329 | 2022-01-27 | Marion | Illinois | 17121 | 11037 | 190 |
2152076 | 2152076 | 2022-01-26 | Marion | Illinois | 17121 | 10942 | 186 |
2148824 | 2148824 | 2022-01-25 | Marion | Illinois | 17121 | 10877 | 186 |
2145572 | 2145572 | 2022-01-24 | Marion | Illinois | 17121 | 10799 | 186 |
2142317 | 2142317 | 2022-01-23 | Marion | Illinois | 17121 | 10549 | 186 |
2139062 | 2139062 | 2022-01-22 | Marion | Illinois | 17121 | 10549 | 186 |
2135806 | 2135806 | 2022-01-21 | Marion | Illinois | 17121 | 10549 | 186 |
2132554 | 2132554 | 2022-01-20 | Marion | Illinois | 17121 | 10433 | 183 |
2129301 | 2129301 | 2022-01-19 | Marion | Illinois | 17121 | 10291 | 181 |
2126047 | 2126047 | 2022-01-18 | Marion | Illinois | 17121 | 10128 | 181 |
2122795 | 2122795 | 2022-01-17 | Marion | Illinois | 17121 | 9766 | 181 |
2119543 | 2119543 | 2022-01-16 | Marion | Illinois | 17121 | 9766 | 181 |
2116291 | 2116291 | 2022-01-15 | Marion | Illinois | 17121 | 9766 | 181 |
2113040 | 2113040 | 2022-01-14 | Marion | Illinois | 17121 | 9766 | 181 |
2109788 | 2109788 | 2022-01-13 | Marion | Illinois | 17121 | 9657 | 180 |
2106537 | 2106537 | 2022-01-12 | Marion | Illinois | 17121 | 9499 | 179 |
2103286 | 2103286 | 2022-01-11 | Marion | Illinois | 17121 | 9366 | 175 |
2100035 | 2100035 | 2022-01-10 | Marion | Illinois | 17121 | 9248 | 175 |
2096784 | 2096784 | 2022-01-09 | Marion | Illinois | 17121 | 9015 | 174 |
2093532 | 2093532 | 2022-01-08 | Marion | Illinois | 17121 | 9015 | 174 |
2090280 | 2090280 | 2022-01-07 | Marion | Illinois | 17121 | 9015 | 174 |
2087029 | 2087029 | 2022-01-06 | Marion | Illinois | 17121 | 8923 | 173 |
2083777 | 2083777 | 2022-01-05 | Marion | Illinois | 17121 | 8799 | 173 |
2080525 | 2080525 | 2022-01-04 | Marion | Illinois | 17121 | 8709 | 173 |
2077273 | 2077273 | 2022-01-03 | Marion | Illinois | 17121 | 8619 | 173 |
2074022 | 2074022 | 2022-01-02 | Marion | Illinois | 17121 | 8394 | 171 |
2070771 | 2070771 | 2022-01-01 | Marion | Illinois | 17121 | 8394 | 171 |
2067520 | 2067520 | 2021-12-31 | Marion | Illinois | 17121 | 8394 | 171 |
2064269 | 2064269 | 2021-12-30 | Marion | Illinois | 17121 | 8394 | 171 |
2061019 | 2061019 | 2021-12-29 | Marion | Illinois | 17121 | 8326 | 169 |
2057770 | 2057770 | 2021-12-28 | Marion | Illinois | 17121 | 8283 | 169 |
2054521 | 2054521 | 2021-12-27 | Marion | Illinois | 17121 | 8204 | 169 |
2051271 | 2051271 | 2021-12-26 | Marion | Illinois | 17121 | 8107 | 165 |
2048021 | 2048021 | 2021-12-25 | Marion | Illinois | 17121 | 8107 | 165 |
2044771 | 2044771 | 2021-12-24 | Marion | Illinois | 17121 | 8107 | 165 |
2041522 | 2041522 | 2021-12-23 | Marion | Illinois | 17121 | 8107 | 165 |
2038272 | 2038272 | 2021-12-22 | Marion | Illinois | 17121 | 8085 | 164 |
2035022 | 2035022 | 2021-12-21 | Marion | Illinois | 17121 | 8041 | 163 |
2031772 | 2031772 | 2021-12-20 | Marion | Illinois | 17121 | 8008 | 163 |
2028521 | 2028521 | 2021-12-19 | Marion | Illinois | 17121 | 7917 | 163 |
2025270 | 2025270 | 2021-12-18 | Marion | Illinois | 17121 | 7917 | 163 |
2022019 | 2022019 | 2021-12-17 | Marion | Illinois | 17121 | 7917 | 163 |
2018768 | 2018768 | 2021-12-16 | Marion | Illinois | 17121 | 7880 | 163 |
2015518 | 2015518 | 2021-12-15 | Marion | Illinois | 17121 | 7868 | 162 |
2012267 | 2012267 | 2021-12-14 | Marion | Illinois | 17121 | 7831 | 162 |
2009016 | 2009016 | 2021-12-13 | Marion | Illinois | 17121 | 7791 | 162 |
2005765 | 2005765 | 2021-12-12 | Marion | Illinois | 17121 | 7703 | 161 |
2002514 | 2002514 | 2021-12-11 | Marion | Illinois | 17121 | 7703 | 161 |
1999264 | 1999264 | 2021-12-10 | Marion | Illinois | 17121 | 7703 | 161 |
1996013 | 1996013 | 2021-12-09 | Marion | Illinois | 17121 | 7675 | 161 |
1992762 | 1992762 | 2021-12-08 | Marion | Illinois | 17121 | 7658 | 161 |
1989511 | 1989511 | 2021-12-07 | Marion | Illinois | 17121 | 7626 | 161 |
1986261 | 1986261 | 2021-12-06 | Marion | Illinois | 17121 | 7597 | 161 |
1983011 | 1983011 | 2021-12-05 | Marion | Illinois | 17121 | 7552 | 160 |
1979761 | 1979761 | 2021-12-04 | Marion | Illinois | 17121 | 7552 | 160 |
1976511 | 1976511 | 2021-12-03 | Marion | Illinois | 17121 | 7552 | 160 |
1973262 | 1973262 | 2021-12-02 | Marion | Illinois | 17121 | 7531 | 159 |
1970012 | 1970012 | 2021-12-01 | Marion | Illinois | 17121 | 7505 | 159 |
1966762 | 1966762 | 2021-11-30 | Marion | Illinois | 17121 | 7489 | 157 |
1963510 | 1963510 | 2021-11-29 | Marion | Illinois | 17121 | 7470 | 157 |
1960259 | 1960259 | 2021-11-28 | Marion | Illinois | 17121 | 7408 | 157 |
1957008 | 1957008 | 2021-11-27 | Marion | Illinois | 17121 | 7408 | 157 |
1953757 | 1953757 | 2021-11-26 | Marion | Illinois | 17121 | 7408 | 157 |
1950506 | 1950506 | 2021-11-25 | Marion | Illinois | 17121 | 7408 | 157 |
1947255 | 1947255 | 2021-11-24 | Marion | Illinois | 17121 | 7408 | 157 |
1944004 | 1944004 | 2021-11-23 | Marion | Illinois | 17121 | 7390 | 157 |
1940754 | 1940754 | 2021-11-22 | Marion | Illinois | 17121 | 7376 | 155 |
1937504 | 1937504 | 2021-11-21 | Marion | Illinois | 17121 | 7348 | 155 |
1934254 | 1934254 | 2021-11-20 | Marion | Illinois | 17121 | 7348 | 155 |
1931003 | 1931003 | 2021-11-19 | Marion | Illinois | 17121 | 7348 | 155 |
1927752 | 1927752 | 2021-11-18 | Marion | Illinois | 17121 | 7324 | 155 |
1924502 | 1924502 | 2021-11-17 | Marion | Illinois | 17121 | 7297 | 155 |
1921253 | 1921253 | 2021-11-16 | Marion | Illinois | 17121 | 7267 | 154 |
1918003 | 1918003 | 2021-11-15 | Marion | Illinois | 17121 | 7246 | 154 |
1914753 | 1914753 | 2021-11-14 | Marion | Illinois | 17121 | 7192 | 154 |
1911503 | 1911503 | 2021-11-13 | Marion | Illinois | 17121 | 7192 | 154 |
1908254 | 1908254 | 2021-11-12 | Marion | Illinois | 17121 | 7192 | 154 |
1905005 | 1905005 | 2021-11-11 | Marion | Illinois | 17121 | 7170 | 154 |
1901755 | 1901755 | 2021-11-10 | Marion | Illinois | 17121 | 7170 | 154 |
1898505 | 1898505 | 2021-11-09 | Marion | Illinois | 17121 | 7133 | 154 |
1895255 | 1895255 | 2021-11-08 | Marion | Illinois | 17121 | 7122 | 154 |
1892005 | 1892005 | 2021-11-07 | Marion | Illinois | 17121 | 7075 | 154 |
1888755 | 1888755 | 2021-11-06 | Marion | Illinois | 17121 | 7075 | 154 |
1885505 | 1885505 | 2021-11-05 | Marion | Illinois | 17121 | 7075 | 154 |
1882256 | 1882256 | 2021-11-04 | Marion | Illinois | 17121 | 7057 | 154 |
1879007 | 1879007 | 2021-11-03 | Marion | Illinois | 17121 | 7035 | 154 |
1875758 | 1875758 | 2021-11-02 | Marion | Illinois | 17121 | 7025 | 154 |
1872509 | 1872509 | 2021-11-01 | Marion | Illinois | 17121 | 7013 | 152 |
1869260 | 1869260 | 2021-10-31 | Marion | Illinois | 17121 | 6993 | 152 |
1866011 | 1866011 | 2021-10-30 | Marion | Illinois | 17121 | 6993 | 152 |
1862762 | 1862762 | 2021-10-29 | Marion | Illinois | 17121 | 6993 | 152 |
1859513 | 1859513 | 2021-10-28 | Marion | Illinois | 17121 | 6985 | 151 |
1856264 | 1856264 | 2021-10-27 | Marion | Illinois | 17121 | 6973 | 150 |
1853015 | 1853015 | 2021-10-26 | Marion | Illinois | 17121 | 6966 | 150 |
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);