ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17021 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535031 | 535031 | 2020-09-15 | Christian | Illinois | 17021 | 320 | 11 |
531796 | 531796 | 2020-09-14 | Christian | Illinois | 17021 | 306 | 10 |
528559 | 528559 | 2020-09-13 | Christian | Illinois | 17021 | 305 | 10 |
525323 | 525323 | 2020-09-12 | Christian | Illinois | 17021 | 297 | 10 |
522087 | 522087 | 2020-09-11 | Christian | Illinois | 17021 | 291 | 10 |
518850 | 518850 | 2020-09-10 | Christian | Illinois | 17021 | 284 | 9 |
515615 | 515615 | 2020-09-09 | Christian | Illinois | 17021 | 269 | 8 |
512382 | 512382 | 2020-09-08 | Christian | Illinois | 17021 | 267 | 7 |
509149 | 509149 | 2020-09-07 | Christian | Illinois | 17021 | 267 | 7 |
505917 | 505917 | 2020-09-06 | Christian | Illinois | 17021 | 267 | 7 |
502683 | 502683 | 2020-09-05 | Christian | Illinois | 17021 | 267 | 7 |
499449 | 499449 | 2020-09-04 | Christian | Illinois | 17021 | 264 | 7 |
496216 | 496216 | 2020-09-03 | Christian | Illinois | 17021 | 250 | 7 |
492982 | 492982 | 2020-09-02 | Christian | Illinois | 17021 | 249 | 7 |
489749 | 489749 | 2020-09-01 | Christian | Illinois | 17021 | 244 | 6 |
486516 | 486516 | 2020-08-31 | Christian | Illinois | 17021 | 232 | 5 |
483281 | 483281 | 2020-08-30 | Christian | Illinois | 17021 | 231 | 5 |
480047 | 480047 | 2020-08-29 | Christian | Illinois | 17021 | 230 | 5 |
476814 | 476814 | 2020-08-28 | Christian | Illinois | 17021 | 216 | 5 |
473581 | 473581 | 2020-08-27 | Christian | Illinois | 17021 | 195 | 5 |
470349 | 470349 | 2020-08-26 | Christian | Illinois | 17021 | 192 | 5 |
467120 | 467120 | 2020-08-25 | Christian | Illinois | 17021 | 191 | 5 |
463891 | 463891 | 2020-08-24 | Christian | Illinois | 17021 | 185 | 5 |
460662 | 460662 | 2020-08-23 | Christian | Illinois | 17021 | 184 | 5 |
457435 | 457435 | 2020-08-22 | Christian | Illinois | 17021 | 182 | 5 |
454207 | 454207 | 2020-08-21 | Christian | Illinois | 17021 | 171 | 5 |
450979 | 450979 | 2020-08-20 | Christian | Illinois | 17021 | 167 | 5 |
447751 | 447751 | 2020-08-19 | Christian | Illinois | 17021 | 166 | 5 |
444524 | 444524 | 2020-08-18 | Christian | Illinois | 17021 | 161 | 5 |
441298 | 441298 | 2020-08-17 | Christian | Illinois | 17021 | 157 | 5 |
438072 | 438072 | 2020-08-16 | Christian | Illinois | 17021 | 153 | 5 |
434846 | 434846 | 2020-08-15 | Christian | Illinois | 17021 | 150 | 5 |
431621 | 431621 | 2020-08-14 | Christian | Illinois | 17021 | 146 | 5 |
428393 | 428393 | 2020-08-13 | Christian | Illinois | 17021 | 144 | 5 |
425169 | 425169 | 2020-08-12 | Christian | Illinois | 17021 | 144 | 5 |
421948 | 421948 | 2020-08-11 | Christian | Illinois | 17021 | 143 | 5 |
418725 | 418725 | 2020-08-10 | Christian | Illinois | 17021 | 143 | 5 |
415504 | 415504 | 2020-08-09 | Christian | Illinois | 17021 | 142 | 5 |
412284 | 412284 | 2020-08-08 | Christian | Illinois | 17021 | 137 | 5 |
409065 | 409065 | 2020-08-07 | Christian | Illinois | 17021 | 134 | 5 |
405845 | 405845 | 2020-08-06 | Christian | Illinois | 17021 | 128 | 5 |
402627 | 402627 | 2020-08-05 | Christian | Illinois | 17021 | 126 | 5 |
399411 | 399411 | 2020-08-04 | Christian | Illinois | 17021 | 117 | 5 |
396195 | 396195 | 2020-08-03 | Christian | Illinois | 17021 | 115 | 5 |
392979 | 392979 | 2020-08-02 | Christian | Illinois | 17021 | 113 | 5 |
389762 | 389762 | 2020-08-01 | Christian | Illinois | 17021 | 111 | 5 |
386545 | 386545 | 2020-07-31 | Christian | Illinois | 17021 | 101 | 5 |
383327 | 383327 | 2020-07-30 | Christian | Illinois | 17021 | 97 | 5 |
380110 | 380110 | 2020-07-29 | Christian | Illinois | 17021 | 89 | 5 |
376893 | 376893 | 2020-07-28 | Christian | Illinois | 17021 | 80 | 5 |
373678 | 373678 | 2020-07-27 | Christian | Illinois | 17021 | 80 | 5 |
370466 | 370466 | 2020-07-26 | Christian | Illinois | 17021 | 78 | 5 |
367256 | 367256 | 2020-07-25 | Christian | Illinois | 17021 | 76 | 5 |
364049 | 364049 | 2020-07-24 | Christian | Illinois | 17021 | 75 | 5 |
360842 | 360842 | 2020-07-23 | Christian | Illinois | 17021 | 65 | 5 |
357637 | 357637 | 2020-07-22 | Christian | Illinois | 17021 | 60 | 5 |
354435 | 354435 | 2020-07-21 | Christian | Illinois | 17021 | 56 | 5 |
351233 | 351233 | 2020-07-20 | Christian | Illinois | 17021 | 55 | 5 |
348033 | 348033 | 2020-07-19 | Christian | Illinois | 17021 | 55 | 5 |
344832 | 344832 | 2020-07-18 | Christian | Illinois | 17021 | 55 | 5 |
341632 | 341632 | 2020-07-17 | Christian | Illinois | 17021 | 54 | 5 |
338436 | 338436 | 2020-07-16 | Christian | Illinois | 17021 | 53 | 5 |
335240 | 335240 | 2020-07-15 | Christian | Illinois | 17021 | 53 | 5 |
332047 | 332047 | 2020-07-14 | Christian | Illinois | 17021 | 52 | 5 |
328860 | 328860 | 2020-07-13 | Christian | Illinois | 17021 | 53 | 5 |
325674 | 325674 | 2020-07-12 | Christian | Illinois | 17021 | 51 | 5 |
322493 | 322493 | 2020-07-11 | Christian | Illinois | 17021 | 50 | 5 |
319314 | 319314 | 2020-07-10 | Christian | Illinois | 17021 | 49 | 5 |
316141 | 316141 | 2020-07-09 | Christian | Illinois | 17021 | 48 | 5 |
312967 | 312967 | 2020-07-08 | Christian | Illinois | 17021 | 47 | 5 |
309797 | 309797 | 2020-07-07 | Christian | Illinois | 17021 | 47 | 5 |
306629 | 306629 | 2020-07-06 | Christian | Illinois | 17021 | 47 | 5 |
303464 | 303464 | 2020-07-05 | Christian | Illinois | 17021 | 45 | 5 |
300300 | 300300 | 2020-07-04 | Christian | Illinois | 17021 | 45 | 5 |
297138 | 297138 | 2020-07-03 | Christian | Illinois | 17021 | 45 | 5 |
293981 | 293981 | 2020-07-02 | Christian | Illinois | 17021 | 45 | 5 |
290827 | 290827 | 2020-07-01 | Christian | Illinois | 17021 | 43 | 5 |
287677 | 287677 | 2020-06-30 | Christian | Illinois | 17021 | 43 | 5 |
284528 | 284528 | 2020-06-29 | Christian | Illinois | 17021 | 43 | 5 |
281383 | 281383 | 2020-06-28 | Christian | Illinois | 17021 | 43 | 5 |
278235 | 278235 | 2020-06-27 | Christian | Illinois | 17021 | 43 | 5 |
275087 | 275087 | 2020-06-26 | Christian | Illinois | 17021 | 42 | 5 |
271945 | 271945 | 2020-06-25 | Christian | Illinois | 17021 | 42 | 5 |
268808 | 268808 | 2020-06-24 | Christian | Illinois | 17021 | 42 | 5 |
265678 | 265678 | 2020-06-23 | Christian | Illinois | 17021 | 42 | 5 |
262550 | 262550 | 2020-06-22 | Christian | Illinois | 17021 | 42 | 5 |
259423 | 259423 | 2020-06-21 | Christian | Illinois | 17021 | 42 | 5 |
256297 | 256297 | 2020-06-20 | Christian | Illinois | 17021 | 42 | 5 |
253177 | 253177 | 2020-06-19 | Christian | Illinois | 17021 | 42 | 5 |
250062 | 250062 | 2020-06-18 | Christian | Illinois | 17021 | 42 | 5 |
246950 | 246950 | 2020-06-17 | Christian | Illinois | 17021 | 39 | 5 |
243837 | 243837 | 2020-06-16 | Christian | Illinois | 17021 | 39 | 5 |
240726 | 240726 | 2020-06-15 | Christian | Illinois | 17021 | 39 | 5 |
237618 | 237618 | 2020-06-14 | Christian | Illinois | 17021 | 37 | 5 |
234511 | 234511 | 2020-06-13 | Christian | Illinois | 17021 | 35 | 5 |
231405 | 231405 | 2020-06-12 | Christian | Illinois | 17021 | 35 | 5 |
228302 | 228302 | 2020-06-11 | Christian | Illinois | 17021 | 35 | 5 |
225200 | 225200 | 2020-06-10 | Christian | Illinois | 17021 | 35 | 5 |
222105 | 222105 | 2020-06-09 | Christian | Illinois | 17021 | 35 | 5 |
219010 | 219010 | 2020-06-08 | Christian | Illinois | 17021 | 35 | 5 |
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);