ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 17089 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386579 | 386579 | 2020-07-31 | Kane | Illinois | 17089 | 9148 | 298 |
383361 | 383361 | 2020-07-30 | Kane | Illinois | 17089 | 9065 | 297 |
380144 | 380144 | 2020-07-29 | Kane | Illinois | 17089 | 8979 | 297 |
376927 | 376927 | 2020-07-28 | Kane | Illinois | 17089 | 8899 | 294 |
373712 | 373712 | 2020-07-27 | Kane | Illinois | 17089 | 8853 | 294 |
370500 | 370500 | 2020-07-26 | Kane | Illinois | 17089 | 8738 | 294 |
367290 | 367290 | 2020-07-25 | Kane | Illinois | 17089 | 8738 | 294 |
364083 | 364083 | 2020-07-24 | Kane | Illinois | 17089 | 8694 | 294 |
360876 | 360876 | 2020-07-23 | Kane | Illinois | 17089 | 8623 | 294 |
357671 | 357671 | 2020-07-22 | Kane | Illinois | 17089 | 8548 | 294 |
354469 | 354469 | 2020-07-21 | Kane | Illinois | 17089 | 8496 | 292 |
351267 | 351267 | 2020-07-20 | Kane | Illinois | 17089 | 8473 | 290 |
348067 | 348067 | 2020-07-19 | Kane | Illinois | 17089 | 8448 | 289 |
344866 | 344866 | 2020-07-18 | Kane | Illinois | 17089 | 8397 | 289 |
341666 | 341666 | 2020-07-17 | Kane | Illinois | 17089 | 8352 | 288 |
338470 | 338470 | 2020-07-16 | Kane | Illinois | 17089 | 8320 | 288 |
335274 | 335274 | 2020-07-15 | Kane | Illinois | 17089 | 8274 | 286 |
332081 | 332081 | 2020-07-14 | Kane | Illinois | 17089 | 8214 | 285 |
328894 | 328894 | 2020-07-13 | Kane | Illinois | 17089 | 8196 | 281 |
325708 | 325708 | 2020-07-12 | Kane | Illinois | 17089 | 8160 | 281 |
322527 | 322527 | 2020-07-11 | Kane | Illinois | 17089 | 8139 | 281 |
319348 | 319348 | 2020-07-10 | Kane | Illinois | 17089 | 8028 | 281 |
316175 | 316175 | 2020-07-09 | Kane | Illinois | 17089 | 7998 | 281 |
313001 | 313001 | 2020-07-08 | Kane | Illinois | 17089 | 7998 | 280 |
309831 | 309831 | 2020-07-07 | Kane | Illinois | 17089 | 7964 | 277 |
306663 | 306663 | 2020-07-06 | Kane | Illinois | 17089 | 7933 | 277 |
303498 | 303498 | 2020-07-05 | Kane | Illinois | 17089 | 7917 | 277 |
300334 | 300334 | 2020-07-04 | Kane | Illinois | 17089 | 7890 | 277 |
297172 | 297172 | 2020-07-03 | Kane | Illinois | 17089 | 7858 | 275 |
294015 | 294015 | 2020-07-02 | Kane | Illinois | 17089 | 7817 | 273 |
290861 | 290861 | 2020-07-01 | Kane | Illinois | 17089 | 7792 | 272 |
287711 | 287711 | 2020-06-30 | Kane | Illinois | 17089 | 7750 | 269 |
284562 | 284562 | 2020-06-29 | Kane | Illinois | 17089 | 7729 | 266 |
281417 | 281417 | 2020-06-28 | Kane | Illinois | 17089 | 7683 | 266 |
278269 | 278269 | 2020-06-27 | Kane | Illinois | 17089 | 7656 | 265 |
275121 | 275121 | 2020-06-26 | Kane | Illinois | 17089 | 7638 | 262 |
271979 | 271979 | 2020-06-25 | Kane | Illinois | 17089 | 7597 | 257 |
268842 | 268842 | 2020-06-24 | Kane | Illinois | 17089 | 7553 | 255 |
265712 | 265712 | 2020-06-23 | Kane | Illinois | 17089 | 7514 | 254 |
262584 | 262584 | 2020-06-22 | Kane | Illinois | 17089 | 7485 | 252 |
259457 | 259457 | 2020-06-21 | Kane | Illinois | 17089 | 7461 | 251 |
256331 | 256331 | 2020-06-20 | Kane | Illinois | 17089 | 7415 | 250 |
253211 | 253211 | 2020-06-19 | Kane | Illinois | 17089 | 7342 | 245 |
250096 | 250096 | 2020-06-18 | Kane | Illinois | 17089 | 7286 | 242 |
246984 | 246984 | 2020-06-17 | Kane | Illinois | 17089 | 7246 | 240 |
243871 | 243871 | 2020-06-16 | Kane | Illinois | 17089 | 7223 | 234 |
240760 | 240760 | 2020-06-15 | Kane | Illinois | 17089 | 7175 | 234 |
237652 | 237652 | 2020-06-14 | Kane | Illinois | 17089 | 7154 | 231 |
234545 | 234545 | 2020-06-13 | Kane | Illinois | 17089 | 7126 | 230 |
231439 | 231439 | 2020-06-12 | Kane | Illinois | 17089 | 7074 | 228 |
228336 | 228336 | 2020-06-11 | Kane | Illinois | 17089 | 7053 | 227 |
225234 | 225234 | 2020-06-10 | Kane | Illinois | 17089 | 6956 | 221 |
222139 | 222139 | 2020-06-09 | Kane | Illinois | 17089 | 6956 | 221 |
219044 | 219044 | 2020-06-08 | Kane | Illinois | 17089 | 6906 | 215 |
215953 | 215953 | 2020-06-07 | Kane | Illinois | 17089 | 6859 | 215 |
212866 | 212866 | 2020-06-06 | Kane | Illinois | 17089 | 6793 | 215 |
209781 | 209781 | 2020-06-05 | Kane | Illinois | 17089 | 6736 | 207 |
206700 | 206700 | 2020-06-04 | Kane | Illinois | 17089 | 6638 | 198 |
203620 | 203620 | 2020-06-03 | Kane | Illinois | 17089 | 6590 | 194 |
200544 | 200544 | 2020-06-02 | Kane | Illinois | 17089 | 6514 | 188 |
197471 | 197471 | 2020-06-01 | Kane | Illinois | 17089 | 6461 | 178 |
194401 | 194401 | 2020-05-31 | Kane | Illinois | 17089 | 6408 | 178 |
191334 | 191334 | 2020-05-30 | Kane | Illinois | 17089 | 6327 | 176 |
188269 | 188269 | 2020-05-29 | Kane | Illinois | 17089 | 6235 | 170 |
185211 | 185211 | 2020-05-28 | Kane | Illinois | 17089 | 6145 | 167 |
182157 | 182157 | 2020-05-27 | Kane | Illinois | 17089 | 6000 | 163 |
179113 | 179113 | 2020-05-26 | Kane | Illinois | 17089 | 5920 | 155 |
176069 | 176069 | 2020-05-25 | Kane | Illinois | 17089 | 5846 | 152 |
173025 | 173025 | 2020-05-24 | Kane | Illinois | 17089 | 5703 | 152 |
169984 | 169984 | 2020-05-23 | Kane | Illinois | 17089 | 5575 | 152 |
166947 | 166947 | 2020-05-22 | Kane | Illinois | 17089 | 5327 | 150 |
163914 | 163914 | 2020-05-21 | Kane | Illinois | 17089 | 4981 | 145 |
160886 | 160886 | 2020-05-20 | Kane | Illinois | 17089 | 4813 | 136 |
157860 | 157860 | 2020-05-19 | Kane | Illinois | 17089 | 4682 | 120 |
154844 | 154844 | 2020-05-18 | Kane | Illinois | 17089 | 4584 | 115 |
151832 | 151832 | 2020-05-17 | Kane | Illinois | 17089 | 4396 | 115 |
148823 | 148823 | 2020-05-16 | Kane | Illinois | 17089 | 4263 | 109 |
145820 | 145820 | 2020-05-15 | Kane | Illinois | 17089 | 4159 | 107 |
142820 | 142820 | 2020-05-14 | Kane | Illinois | 17089 | 3995 | 104 |
139824 | 139824 | 2020-05-13 | Kane | Illinois | 17089 | 3744 | 98 |
136832 | 136832 | 2020-05-12 | Kane | Illinois | 17089 | 3592 | 93 |
133843 | 133843 | 2020-05-11 | Kane | Illinois | 17089 | 3126 | 90 |
130852 | 130852 | 2020-05-10 | Kane | Illinois | 17089 | 3003 | 89 |
127861 | 127861 | 2020-05-09 | Kane | Illinois | 17089 | 2818 | 88 |
124874 | 124874 | 2020-05-08 | Kane | Illinois | 17089 | 2668 | 84 |
121895 | 121895 | 2020-05-07 | Kane | Illinois | 17089 | 2498 | 78 |
118925 | 118925 | 2020-05-06 | Kane | Illinois | 17089 | 2331 | 74 |
115965 | 115965 | 2020-05-05 | Kane | Illinois | 17089 | 2206 | 65 |
113082 | 113082 | 2020-05-04 | Kane | Illinois | 17089 | 2115 | 57 |
110207 | 110207 | 2020-05-03 | Kane | Illinois | 17089 | 1935 | 57 |
107337 | 107337 | 2020-05-02 | Kane | Illinois | 17089 | 1803 | 57 |
104472 | 104472 | 2020-05-01 | Kane | Illinois | 17089 | 1677 | 52 |
101616 | 101616 | 2020-04-30 | Kane | Illinois | 17089 | 1526 | 48 |
98765 | 98765 | 2020-04-29 | Kane | Illinois | 17089 | 1412 | 45 |
95921 | 95921 | 2020-04-28 | Kane | Illinois | 17089 | 1308 | 41 |
93089 | 93089 | 2020-04-27 | Kane | Illinois | 17089 | 1185 | 39 |
90270 | 90270 | 2020-04-26 | Kane | Illinois | 17089 | 1109 | 39 |
87454 | 87454 | 2020-04-25 | Kane | Illinois | 17089 | 1049 | 39 |
84644 | 84644 | 2020-04-24 | Kane | Illinois | 17089 | 962 | 39 |
81844 | 81844 | 2020-04-23 | Kane | Illinois | 17089 | 863 | 39 |
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);