ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17177 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386623 | 386623 | 2020-07-31 | Stephenson | Illinois | 17177 | 313 | 6 |
383405 | 383405 | 2020-07-30 | Stephenson | Illinois | 17177 | 312 | 6 |
380188 | 380188 | 2020-07-29 | Stephenson | Illinois | 17177 | 311 | 6 |
376971 | 376971 | 2020-07-28 | Stephenson | Illinois | 17177 | 311 | 6 |
373756 | 373756 | 2020-07-27 | Stephenson | Illinois | 17177 | 307 | 6 |
370544 | 370544 | 2020-07-26 | Stephenson | Illinois | 17177 | 306 | 6 |
367334 | 367334 | 2020-07-25 | Stephenson | Illinois | 17177 | 304 | 6 |
364127 | 364127 | 2020-07-24 | Stephenson | Illinois | 17177 | 299 | 6 |
360920 | 360920 | 2020-07-23 | Stephenson | Illinois | 17177 | 296 | 6 |
357715 | 357715 | 2020-07-22 | Stephenson | Illinois | 17177 | 292 | 6 |
354513 | 354513 | 2020-07-21 | Stephenson | Illinois | 17177 | 290 | 6 |
351311 | 351311 | 2020-07-20 | Stephenson | Illinois | 17177 | 289 | 6 |
348111 | 348111 | 2020-07-19 | Stephenson | Illinois | 17177 | 289 | 6 |
344910 | 344910 | 2020-07-18 | Stephenson | Illinois | 17177 | 288 | 6 |
341710 | 341710 | 2020-07-17 | Stephenson | Illinois | 17177 | 287 | 6 |
338514 | 338514 | 2020-07-16 | Stephenson | Illinois | 17177 | 287 | 6 |
335318 | 335318 | 2020-07-15 | Stephenson | Illinois | 17177 | 287 | 6 |
332125 | 332125 | 2020-07-14 | Stephenson | Illinois | 17177 | 287 | 6 |
328938 | 328938 | 2020-07-13 | Stephenson | Illinois | 17177 | 286 | 6 |
325752 | 325752 | 2020-07-12 | Stephenson | Illinois | 17177 | 285 | 6 |
322571 | 322571 | 2020-07-11 | Stephenson | Illinois | 17177 | 283 | 6 |
319392 | 319392 | 2020-07-10 | Stephenson | Illinois | 17177 | 282 | 6 |
316219 | 316219 | 2020-07-09 | Stephenson | Illinois | 17177 | 282 | 6 |
313045 | 313045 | 2020-07-08 | Stephenson | Illinois | 17177 | 280 | 6 |
309875 | 309875 | 2020-07-07 | Stephenson | Illinois | 17177 | 280 | 6 |
306707 | 306707 | 2020-07-06 | Stephenson | Illinois | 17177 | 278 | 5 |
303542 | 303542 | 2020-07-05 | Stephenson | Illinois | 17177 | 276 | 5 |
300378 | 300378 | 2020-07-04 | Stephenson | Illinois | 17177 | 276 | 5 |
297216 | 297216 | 2020-07-03 | Stephenson | Illinois | 17177 | 275 | 5 |
294058 | 294058 | 2020-07-02 | Stephenson | Illinois | 17177 | 275 | 5 |
290904 | 290904 | 2020-07-01 | Stephenson | Illinois | 17177 | 274 | 5 |
287754 | 287754 | 2020-06-30 | Stephenson | Illinois | 17177 | 270 | 5 |
284605 | 284605 | 2020-06-29 | Stephenson | Illinois | 17177 | 268 | 5 |
281460 | 281460 | 2020-06-28 | Stephenson | Illinois | 17177 | 268 | 5 |
278312 | 278312 | 2020-06-27 | Stephenson | Illinois | 17177 | 268 | 5 |
275164 | 275164 | 2020-06-26 | Stephenson | Illinois | 17177 | 265 | 5 |
272022 | 272022 | 2020-06-25 | Stephenson | Illinois | 17177 | 261 | 5 |
268885 | 268885 | 2020-06-24 | Stephenson | Illinois | 17177 | 257 | 5 |
265755 | 265755 | 2020-06-23 | Stephenson | Illinois | 17177 | 255 | 5 |
262627 | 262627 | 2020-06-22 | Stephenson | Illinois | 17177 | 248 | 5 |
259500 | 259500 | 2020-06-21 | Stephenson | Illinois | 17177 | 249 | 5 |
256374 | 256374 | 2020-06-20 | Stephenson | Illinois | 17177 | 249 | 5 |
253254 | 253254 | 2020-06-19 | Stephenson | Illinois | 17177 | 242 | 5 |
250139 | 250139 | 2020-06-18 | Stephenson | Illinois | 17177 | 236 | 5 |
247027 | 247027 | 2020-06-17 | Stephenson | Illinois | 17177 | 233 | 5 |
243914 | 243914 | 2020-06-16 | Stephenson | Illinois | 17177 | 231 | 5 |
240803 | 240803 | 2020-06-15 | Stephenson | Illinois | 17177 | 231 | 5 |
237695 | 237695 | 2020-06-14 | Stephenson | Illinois | 17177 | 231 | 5 |
234588 | 234588 | 2020-06-13 | Stephenson | Illinois | 17177 | 228 | 5 |
231482 | 231482 | 2020-06-12 | Stephenson | Illinois | 17177 | 226 | 5 |
228379 | 228379 | 2020-06-11 | Stephenson | Illinois | 17177 | 223 | 5 |
225277 | 225277 | 2020-06-10 | Stephenson | Illinois | 17177 | 222 | 5 |
222182 | 222182 | 2020-06-09 | Stephenson | Illinois | 17177 | 220 | 5 |
219087 | 219087 | 2020-06-08 | Stephenson | Illinois | 17177 | 219 | 5 |
215996 | 215996 | 2020-06-07 | Stephenson | Illinois | 17177 | 216 | 5 |
212909 | 212909 | 2020-06-06 | Stephenson | Illinois | 17177 | 214 | 5 |
209824 | 209824 | 2020-06-05 | Stephenson | Illinois | 17177 | 211 | 5 |
206743 | 206743 | 2020-06-04 | Stephenson | Illinois | 17177 | 209 | 5 |
203663 | 203663 | 2020-06-03 | Stephenson | Illinois | 17177 | 210 | 5 |
200587 | 200587 | 2020-06-02 | Stephenson | Illinois | 17177 | 211 | 2 |
197514 | 197514 | 2020-06-01 | Stephenson | Illinois | 17177 | 209 | 2 |
194444 | 194444 | 2020-05-31 | Stephenson | Illinois | 17177 | 206 | 2 |
191377 | 191377 | 2020-05-30 | Stephenson | Illinois | 17177 | 201 | 2 |
188312 | 188312 | 2020-05-29 | Stephenson | Illinois | 17177 | 199 | 2 |
185254 | 185254 | 2020-05-28 | Stephenson | Illinois | 17177 | 199 | 2 |
182200 | 182200 | 2020-05-27 | Stephenson | Illinois | 17177 | 194 | 2 |
179156 | 179156 | 2020-05-26 | Stephenson | Illinois | 17177 | 195 | 2 |
176112 | 176112 | 2020-05-25 | Stephenson | Illinois | 17177 | 190 | 2 |
173068 | 173068 | 2020-05-24 | Stephenson | Illinois | 17177 | 187 | 2 |
170027 | 170027 | 2020-05-23 | Stephenson | Illinois | 17177 | 176 | 2 |
166990 | 166990 | 2020-05-22 | Stephenson | Illinois | 17177 | 173 | 2 |
163957 | 163957 | 2020-05-21 | Stephenson | Illinois | 17177 | 167 | 2 |
160929 | 160929 | 2020-05-20 | Stephenson | Illinois | 17177 | 161 | 1 |
157903 | 157903 | 2020-05-19 | Stephenson | Illinois | 17177 | 160 | 1 |
154887 | 154887 | 2020-05-18 | Stephenson | Illinois | 17177 | 156 | 1 |
151875 | 151875 | 2020-05-17 | Stephenson | Illinois | 17177 | 150 | 1 |
148866 | 148866 | 2020-05-16 | Stephenson | Illinois | 17177 | 136 | 0 |
145862 | 145862 | 2020-05-15 | Stephenson | Illinois | 17177 | 135 | 0 |
142862 | 142862 | 2020-05-14 | Stephenson | Illinois | 17177 | 119 | 0 |
139866 | 139866 | 2020-05-13 | Stephenson | Illinois | 17177 | 118 | 0 |
136874 | 136874 | 2020-05-12 | Stephenson | Illinois | 17177 | 110 | 0 |
133885 | 133885 | 2020-05-11 | Stephenson | Illinois | 17177 | 99 | 0 |
130894 | 130894 | 2020-05-10 | Stephenson | Illinois | 17177 | 97 | 0 |
127903 | 127903 | 2020-05-09 | Stephenson | Illinois | 17177 | 88 | 0 |
124916 | 124916 | 2020-05-08 | Stephenson | Illinois | 17177 | 84 | 0 |
121936 | 121936 | 2020-05-07 | Stephenson | Illinois | 17177 | 78 | 0 |
118966 | 118966 | 2020-05-06 | Stephenson | Illinois | 17177 | 72 | 0 |
116006 | 116006 | 2020-05-05 | Stephenson | Illinois | 17177 | 70 | 0 |
113123 | 113123 | 2020-05-04 | Stephenson | Illinois | 17177 | 71 | 0 |
110248 | 110248 | 2020-05-03 | Stephenson | Illinois | 17177 | 63 | 0 |
107378 | 107378 | 2020-05-02 | Stephenson | Illinois | 17177 | 53 | 0 |
104513 | 104513 | 2020-05-01 | Stephenson | Illinois | 17177 | 45 | 0 |
101657 | 101657 | 2020-04-30 | Stephenson | Illinois | 17177 | 35 | 0 |
98806 | 98806 | 2020-04-29 | Stephenson | Illinois | 17177 | 29 | 0 |
95962 | 95962 | 2020-04-28 | Stephenson | Illinois | 17177 | 22 | 0 |
93130 | 93130 | 2020-04-27 | Stephenson | Illinois | 17177 | 16 | 0 |
90311 | 90311 | 2020-04-26 | Stephenson | Illinois | 17177 | 16 | 0 |
87495 | 87495 | 2020-04-25 | Stephenson | Illinois | 17177 | 16 | 0 |
84685 | 84685 | 2020-04-24 | Stephenson | Illinois | 17177 | 13 | 0 |
81885 | 81885 | 2020-04-23 | Stephenson | Illinois | 17177 | 13 | 0 |
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);