ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Lake" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174846 | 2174846 | 2022-02-02 | Lake | Illinois | 17097 | 141359 | 1316 |
2171593 | 2171593 | 2022-02-01 | Lake | Illinois | 17097 | 140683 | 1312 |
2168340 | 2168340 | 2022-01-31 | Lake | Illinois | 17097 | 140282 | 1308 |
2165085 | 2165085 | 2022-01-30 | Lake | Illinois | 17097 | 138901 | 1297 |
2161830 | 2161830 | 2022-01-29 | Lake | Illinois | 17097 | 138901 | 1297 |
2158575 | 2158575 | 2022-01-28 | Lake | Illinois | 17097 | 138901 | 1297 |
2155321 | 2155321 | 2022-01-27 | Lake | Illinois | 17097 | 137841 | 1292 |
2152068 | 2152068 | 2022-01-26 | Lake | Illinois | 17097 | 137048 | 1286 |
2148816 | 2148816 | 2022-01-25 | Lake | Illinois | 17097 | 136202 | 1284 |
2145564 | 2145564 | 2022-01-24 | Lake | Illinois | 17097 | 135535 | 1280 |
2142309 | 2142309 | 2022-01-23 | Lake | Illinois | 17097 | 132514 | 1275 |
2139054 | 2139054 | 2022-01-22 | Lake | Illinois | 17097 | 132514 | 1275 |
2135798 | 2135798 | 2022-01-21 | Lake | Illinois | 17097 | 132514 | 1275 |
2132546 | 2132546 | 2022-01-20 | Lake | Illinois | 17097 | 130602 | 1272 |
2129293 | 2129293 | 2022-01-19 | Lake | Illinois | 17097 | 129497 | 1269 |
2126039 | 2126039 | 2022-01-18 | Lake | Illinois | 17097 | 128044 | 1269 |
2122787 | 2122787 | 2022-01-17 | Lake | Illinois | 17097 | 122497 | 1258 |
2119535 | 2119535 | 2022-01-16 | Lake | Illinois | 17097 | 122497 | 1258 |
2116283 | 2116283 | 2022-01-15 | Lake | Illinois | 17097 | 122497 | 1258 |
2113032 | 2113032 | 2022-01-14 | Lake | Illinois | 17097 | 122497 | 1258 |
2109780 | 2109780 | 2022-01-13 | Lake | Illinois | 17097 | 121134 | 1254 |
2106529 | 2106529 | 2022-01-12 | Lake | Illinois | 17097 | 119305 | 1252 |
2103278 | 2103278 | 2022-01-11 | Lake | Illinois | 17097 | 117448 | 1246 |
2100027 | 2100027 | 2022-01-10 | Lake | Illinois | 17097 | 115776 | 1243 |
2096776 | 2096776 | 2022-01-09 | Lake | Illinois | 17097 | 111749 | 1235 |
2093524 | 2093524 | 2022-01-08 | Lake | Illinois | 17097 | 111749 | 1235 |
2090272 | 2090272 | 2022-01-07 | Lake | Illinois | 17097 | 111749 | 1235 |
2087021 | 2087021 | 2022-01-06 | Lake | Illinois | 17097 | 109715 | 1230 |
2083769 | 2083769 | 2022-01-05 | Lake | Illinois | 17097 | 107841 | 1227 |
2080517 | 2080517 | 2022-01-04 | Lake | Illinois | 17097 | 106216 | 1226 |
2077265 | 2077265 | 2022-01-03 | Lake | Illinois | 17097 | 105172 | 1225 |
2074014 | 2074014 | 2022-01-02 | Lake | Illinois | 17097 | 101282 | 1218 |
2070763 | 2070763 | 2022-01-01 | Lake | Illinois | 17097 | 101282 | 1218 |
2067512 | 2067512 | 2021-12-31 | Lake | Illinois | 17097 | 101282 | 1218 |
2064261 | 2064261 | 2021-12-30 | Lake | Illinois | 17097 | 101282 | 1218 |
2061011 | 2061011 | 2021-12-29 | Lake | Illinois | 17097 | 99892 | 1217 |
2057762 | 2057762 | 2021-12-28 | Lake | Illinois | 17097 | 99162 | 1215 |
2054513 | 2054513 | 2021-12-27 | Lake | Illinois | 17097 | 98185 | 1211 |
2051263 | 2051263 | 2021-12-26 | Lake | Illinois | 17097 | 96206 | 1208 |
2048013 | 2048013 | 2021-12-25 | Lake | Illinois | 17097 | 96206 | 1208 |
2044763 | 2044763 | 2021-12-24 | Lake | Illinois | 17097 | 96206 | 1208 |
2041514 | 2041514 | 2021-12-23 | Lake | Illinois | 17097 | 96206 | 1208 |
2038264 | 2038264 | 2021-12-22 | Lake | Illinois | 17097 | 95455 | 1205 |
2035014 | 2035014 | 2021-12-21 | Lake | Illinois | 17097 | 94873 | 1204 |
2031764 | 2031764 | 2021-12-20 | Lake | Illinois | 17097 | 94457 | 1204 |
2028513 | 2028513 | 2021-12-19 | Lake | Illinois | 17097 | 93165 | 1198 |
2025262 | 2025262 | 2021-12-18 | Lake | Illinois | 17097 | 93165 | 1198 |
2022011 | 2022011 | 2021-12-17 | Lake | Illinois | 17097 | 93165 | 1198 |
2018760 | 2018760 | 2021-12-16 | Lake | Illinois | 17097 | 92815 | 1197 |
2015510 | 2015510 | 2021-12-15 | Lake | Illinois | 17097 | 92293 | 1196 |
2012259 | 2012259 | 2021-12-14 | Lake | Illinois | 17097 | 91805 | 1194 |
2009008 | 2009008 | 2021-12-13 | Lake | Illinois | 17097 | 91456 | 1194 |
2005757 | 2005757 | 2021-12-12 | Lake | Illinois | 17097 | 90507 | 1193 |
2002506 | 2002506 | 2021-12-11 | Lake | Illinois | 17097 | 90507 | 1193 |
1999256 | 1999256 | 2021-12-10 | Lake | Illinois | 17097 | 90507 | 1193 |
1996005 | 1996005 | 2021-12-09 | Lake | Illinois | 17097 | 90226 | 1192 |
1992754 | 1992754 | 2021-12-08 | Lake | Illinois | 17097 | 89768 | 1190 |
1989503 | 1989503 | 2021-12-07 | Lake | Illinois | 17097 | 89449 | 1190 |
1986253 | 1986253 | 2021-12-06 | Lake | Illinois | 17097 | 89126 | 1189 |
1983003 | 1983003 | 2021-12-05 | Lake | Illinois | 17097 | 88161 | 1186 |
1979753 | 1979753 | 2021-12-04 | Lake | Illinois | 17097 | 88161 | 1186 |
1976503 | 1976503 | 2021-12-03 | Lake | Illinois | 17097 | 88161 | 1186 |
1973254 | 1973254 | 2021-12-02 | Lake | Illinois | 17097 | 87750 | 1186 |
1970004 | 1970004 | 2021-12-01 | Lake | Illinois | 17097 | 87188 | 1185 |
1966754 | 1966754 | 2021-11-30 | Lake | Illinois | 17097 | 86885 | 1182 |
1963502 | 1963502 | 2021-11-29 | Lake | Illinois | 17097 | 86646 | 1182 |
1960251 | 1960251 | 2021-11-28 | Lake | Illinois | 17097 | 85690 | 1181 |
1957000 | 1957000 | 2021-11-27 | Lake | Illinois | 17097 | 85690 | 1181 |
1953749 | 1953749 | 2021-11-26 | Lake | Illinois | 17097 | 85690 | 1181 |
1950498 | 1950498 | 2021-11-25 | Lake | Illinois | 17097 | 85690 | 1181 |
1947247 | 1947247 | 2021-11-24 | Lake | Illinois | 17097 | 85690 | 1181 |
1943996 | 1943996 | 2021-11-23 | Lake | Illinois | 17097 | 85462 | 1179 |
1940746 | 1940746 | 2021-11-22 | Lake | Illinois | 17097 | 85166 | 1179 |
1937496 | 1937496 | 2021-11-21 | Lake | Illinois | 17097 | 84549 | 1177 |
1934246 | 1934246 | 2021-11-20 | Lake | Illinois | 17097 | 84549 | 1177 |
1930995 | 1930995 | 2021-11-19 | Lake | Illinois | 17097 | 84549 | 1177 |
1927744 | 1927744 | 2021-11-18 | Lake | Illinois | 17097 | 84137 | 1176 |
1924494 | 1924494 | 2021-11-17 | Lake | Illinois | 17097 | 83912 | 1175 |
1921245 | 1921245 | 2021-11-16 | Lake | Illinois | 17097 | 83723 | 1175 |
1917995 | 1917995 | 2021-11-15 | Lake | Illinois | 17097 | 83557 | 1175 |
1914745 | 1914745 | 2021-11-14 | Lake | Illinois | 17097 | 83150 | 1172 |
1911495 | 1911495 | 2021-11-13 | Lake | Illinois | 17097 | 83150 | 1172 |
1908246 | 1908246 | 2021-11-12 | Lake | Illinois | 17097 | 83150 | 1172 |
1904997 | 1904997 | 2021-11-11 | Lake | Illinois | 17097 | 82659 | 1170 |
1901747 | 1901747 | 2021-11-10 | Lake | Illinois | 17097 | 82659 | 1170 |
1898497 | 1898497 | 2021-11-09 | Lake | Illinois | 17097 | 82402 | 1170 |
1895247 | 1895247 | 2021-11-08 | Lake | Illinois | 17097 | 82302 | 1170 |
1891997 | 1891997 | 2021-11-07 | Lake | Illinois | 17097 | 81931 | 1169 |
1888747 | 1888747 | 2021-11-06 | Lake | Illinois | 17097 | 81931 | 1169 |
1885497 | 1885497 | 2021-11-05 | Lake | Illinois | 17097 | 81931 | 1169 |
1882248 | 1882248 | 2021-11-04 | Lake | Illinois | 17097 | 81761 | 1168 |
1878999 | 1878999 | 2021-11-03 | Lake | Illinois | 17097 | 81589 | 1167 |
1875750 | 1875750 | 2021-11-02 | Lake | Illinois | 17097 | 81496 | 1165 |
1872501 | 1872501 | 2021-11-01 | Lake | Illinois | 17097 | 81410 | 1165 |
1869252 | 1869252 | 2021-10-31 | Lake | Illinois | 17097 | 81085 | 1163 |
1866003 | 1866003 | 2021-10-30 | Lake | Illinois | 17097 | 81085 | 1163 |
1862754 | 1862754 | 2021-10-29 | Lake | Illinois | 17097 | 81085 | 1163 |
1859505 | 1859505 | 2021-10-28 | Lake | Illinois | 17097 | 80940 | 1163 |
1856256 | 1856256 | 2021-10-27 | Lake | Illinois | 17097 | 80792 | 1163 |
1853007 | 1853007 | 2021-10-26 | Lake | Illinois | 17097 | 80675 | 1163 |
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);