ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17195 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635582 | 635582 | 2020-10-16 | Whiteside | Illinois | 17195 | 1154 | 21 |
632336 | 632336 | 2020-10-15 | Whiteside | Illinois | 17195 | 1079 | 21 |
629092 | 629092 | 2020-10-14 | Whiteside | Illinois | 17195 | 1055 | 21 |
625849 | 625849 | 2020-10-13 | Whiteside | Illinois | 17195 | 1055 | 21 |
622607 | 622607 | 2020-10-12 | Whiteside | Illinois | 17195 | 1022 | 21 |
619363 | 619363 | 2020-10-11 | Whiteside | Illinois | 17195 | 1005 | 21 |
616121 | 616121 | 2020-10-10 | Whiteside | Illinois | 17195 | 980 | 21 |
612880 | 612880 | 2020-10-09 | Whiteside | Illinois | 17195 | 977 | 21 |
609638 | 609638 | 2020-10-08 | Whiteside | Illinois | 17195 | 945 | 21 |
606395 | 606395 | 2020-10-07 | Whiteside | Illinois | 17195 | 924 | 21 |
603153 | 603153 | 2020-10-06 | Whiteside | Illinois | 17195 | 908 | 21 |
599910 | 599910 | 2020-10-05 | Whiteside | Illinois | 17195 | 892 | 21 |
596668 | 596668 | 2020-10-04 | Whiteside | Illinois | 17195 | 872 | 21 |
593426 | 593426 | 2020-10-03 | Whiteside | Illinois | 17195 | 872 | 21 |
590185 | 590185 | 2020-10-02 | Whiteside | Illinois | 17195 | 849 | 21 |
586944 | 586944 | 2020-10-01 | Whiteside | Illinois | 17195 | 824 | 21 |
583704 | 583704 | 2020-09-30 | Whiteside | Illinois | 17195 | 811 | 21 |
580465 | 580465 | 2020-09-29 | Whiteside | Illinois | 17195 | 788 | 21 |
577224 | 577224 | 2020-09-28 | Whiteside | Illinois | 17195 | 775 | 20 |
573982 | 573982 | 2020-09-27 | Whiteside | Illinois | 17195 | 755 | 20 |
570739 | 570739 | 2020-09-26 | Whiteside | Illinois | 17195 | 755 | 20 |
567497 | 567497 | 2020-09-25 | Whiteside | Illinois | 17195 | 744 | 20 |
564257 | 564257 | 2020-09-24 | Whiteside | Illinois | 17195 | 734 | 20 |
561017 | 561017 | 2020-09-23 | Whiteside | Illinois | 17195 | 725 | 20 |
557781 | 557781 | 2020-09-22 | Whiteside | Illinois | 17195 | 716 | 20 |
554544 | 554544 | 2020-09-21 | Whiteside | Illinois | 17195 | 708 | 20 |
551305 | 551305 | 2020-09-20 | Whiteside | Illinois | 17195 | 704 | 20 |
548066 | 548066 | 2020-09-19 | Whiteside | Illinois | 17195 | 699 | 20 |
544828 | 544828 | 2020-09-18 | Whiteside | Illinois | 17195 | 694 | 20 |
541592 | 541592 | 2020-09-17 | Whiteside | Illinois | 17195 | 668 | 20 |
538355 | 538355 | 2020-09-16 | Whiteside | Illinois | 17195 | 668 | 20 |
535119 | 535119 | 2020-09-15 | Whiteside | Illinois | 17195 | 650 | 20 |
531884 | 531884 | 2020-09-14 | Whiteside | Illinois | 17195 | 650 | 20 |
528647 | 528647 | 2020-09-13 | Whiteside | Illinois | 17195 | 637 | 20 |
525411 | 525411 | 2020-09-12 | Whiteside | Illinois | 17195 | 637 | 20 |
522175 | 522175 | 2020-09-11 | Whiteside | Illinois | 17195 | 624 | 19 |
518938 | 518938 | 2020-09-10 | Whiteside | Illinois | 17195 | 616 | 19 |
515703 | 515703 | 2020-09-09 | Whiteside | Illinois | 17195 | 616 | 19 |
512470 | 512470 | 2020-09-08 | Whiteside | Illinois | 17195 | 612 | 19 |
509237 | 509237 | 2020-09-07 | Whiteside | Illinois | 17195 | 604 | 19 |
506005 | 506005 | 2020-09-06 | Whiteside | Illinois | 17195 | 594 | 19 |
502771 | 502771 | 2020-09-05 | Whiteside | Illinois | 17195 | 589 | 19 |
499537 | 499537 | 2020-09-04 | Whiteside | Illinois | 17195 | 586 | 19 |
496304 | 496304 | 2020-09-03 | Whiteside | Illinois | 17195 | 566 | 19 |
493070 | 493070 | 2020-09-02 | Whiteside | Illinois | 17195 | 566 | 19 |
489837 | 489837 | 2020-09-01 | Whiteside | Illinois | 17195 | 541 | 19 |
486604 | 486604 | 2020-08-31 | Whiteside | Illinois | 17195 | 541 | 19 |
483369 | 483369 | 2020-08-30 | Whiteside | Illinois | 17195 | 523 | 19 |
480135 | 480135 | 2020-08-29 | Whiteside | Illinois | 17195 | 511 | 19 |
476902 | 476902 | 2020-08-28 | Whiteside | Illinois | 17195 | 509 | 19 |
473669 | 473669 | 2020-08-27 | Whiteside | Illinois | 17195 | 483 | 19 |
470437 | 470437 | 2020-08-26 | Whiteside | Illinois | 17195 | 483 | 18 |
467208 | 467208 | 2020-08-25 | Whiteside | Illinois | 17195 | 466 | 18 |
463979 | 463979 | 2020-08-24 | Whiteside | Illinois | 17195 | 466 | 18 |
460750 | 460750 | 2020-08-23 | Whiteside | Illinois | 17195 | 454 | 18 |
457523 | 457523 | 2020-08-22 | Whiteside | Illinois | 17195 | 449 | 18 |
454295 | 454295 | 2020-08-21 | Whiteside | Illinois | 17195 | 438 | 18 |
451067 | 451067 | 2020-08-20 | Whiteside | Illinois | 17195 | 418 | 18 |
447839 | 447839 | 2020-08-19 | Whiteside | Illinois | 17195 | 416 | 17 |
444612 | 444612 | 2020-08-18 | Whiteside | Illinois | 17195 | 407 | 17 |
441386 | 441386 | 2020-08-17 | Whiteside | Illinois | 17195 | 400 | 17 |
438160 | 438160 | 2020-08-16 | Whiteside | Illinois | 17195 | 400 | 17 |
434934 | 434934 | 2020-08-15 | Whiteside | Illinois | 17195 | 390 | 17 |
431709 | 431709 | 2020-08-14 | Whiteside | Illinois | 17195 | 390 | 17 |
428481 | 428481 | 2020-08-13 | Whiteside | Illinois | 17195 | 384 | 17 |
425257 | 425257 | 2020-08-12 | Whiteside | Illinois | 17195 | 373 | 17 |
422036 | 422036 | 2020-08-11 | Whiteside | Illinois | 17195 | 366 | 17 |
418813 | 418813 | 2020-08-10 | Whiteside | Illinois | 17195 | 361 | 17 |
415592 | 415592 | 2020-08-09 | Whiteside | Illinois | 17195 | 357 | 17 |
412372 | 412372 | 2020-08-08 | Whiteside | Illinois | 17195 | 357 | 17 |
409153 | 409153 | 2020-08-07 | Whiteside | Illinois | 17195 | 352 | 17 |
405933 | 405933 | 2020-08-06 | Whiteside | Illinois | 17195 | 348 | 16 |
402715 | 402715 | 2020-08-05 | Whiteside | Illinois | 17195 | 346 | 16 |
399499 | 399499 | 2020-08-04 | Whiteside | Illinois | 17195 | 332 | 16 |
396283 | 396283 | 2020-08-03 | Whiteside | Illinois | 17195 | 332 | 16 |
393067 | 393067 | 2020-08-02 | Whiteside | Illinois | 17195 | 328 | 16 |
389850 | 389850 | 2020-08-01 | Whiteside | Illinois | 17195 | 323 | 16 |
386633 | 386633 | 2020-07-31 | Whiteside | Illinois | 17195 | 319 | 16 |
383415 | 383415 | 2020-07-30 | Whiteside | Illinois | 17195 | 308 | 16 |
380198 | 380198 | 2020-07-29 | Whiteside | Illinois | 17195 | 297 | 16 |
376981 | 376981 | 2020-07-28 | Whiteside | Illinois | 17195 | 294 | 16 |
373766 | 373766 | 2020-07-27 | Whiteside | Illinois | 17195 | 294 | 16 |
370554 | 370554 | 2020-07-26 | Whiteside | Illinois | 17195 | 280 | 16 |
367344 | 367344 | 2020-07-25 | Whiteside | Illinois | 17195 | 280 | 16 |
364137 | 364137 | 2020-07-24 | Whiteside | Illinois | 17195 | 274 | 16 |
360930 | 360930 | 2020-07-23 | Whiteside | Illinois | 17195 | 269 | 16 |
357725 | 357725 | 2020-07-22 | Whiteside | Illinois | 17195 | 250 | 16 |
354523 | 354523 | 2020-07-21 | Whiteside | Illinois | 17195 | 241 | 16 |
351321 | 351321 | 2020-07-20 | Whiteside | Illinois | 17195 | 234 | 16 |
348121 | 348121 | 2020-07-19 | Whiteside | Illinois | 17195 | 233 | 16 |
344920 | 344920 | 2020-07-18 | Whiteside | Illinois | 17195 | 228 | 16 |
341720 | 341720 | 2020-07-17 | Whiteside | Illinois | 17195 | 226 | 16 |
338524 | 338524 | 2020-07-16 | Whiteside | Illinois | 17195 | 225 | 16 |
335328 | 335328 | 2020-07-15 | Whiteside | Illinois | 17195 | 224 | 15 |
332135 | 332135 | 2020-07-14 | Whiteside | Illinois | 17195 | 220 | 15 |
328948 | 328948 | 2020-07-13 | Whiteside | Illinois | 17195 | 218 | 15 |
325762 | 325762 | 2020-07-12 | Whiteside | Illinois | 17195 | 212 | 15 |
322581 | 322581 | 2020-07-11 | Whiteside | Illinois | 17195 | 209 | 15 |
319402 | 319402 | 2020-07-10 | Whiteside | Illinois | 17195 | 208 | 15 |
316229 | 316229 | 2020-07-09 | Whiteside | Illinois | 17195 | 203 | 15 |
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);