ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 17197 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930872 | 930872 | 2021-01-15 | Will | Illinois | 17197 | 57429 | 861 |
927627 | 927627 | 2021-01-14 | Will | Illinois | 17197 | 57104 | 856 |
924381 | 924381 | 2021-01-13 | Will | Illinois | 17197 | 56766 | 851 |
921136 | 921136 | 2021-01-12 | Will | Illinois | 17197 | 56435 | 845 |
917891 | 917891 | 2021-01-11 | Will | Illinois | 17197 | 56145 | 837 |
914646 | 914646 | 2021-01-10 | Will | Illinois | 17197 | 55872 | 835 |
911401 | 911401 | 2021-01-09 | Will | Illinois | 17197 | 55611 | 833 |
908156 | 908156 | 2021-01-08 | Will | Illinois | 17197 | 55181 | 824 |
904910 | 904910 | 2021-01-07 | Will | Illinois | 17197 | 54678 | 815 |
901665 | 901665 | 2021-01-06 | Will | Illinois | 17197 | 54211 | 806 |
898420 | 898420 | 2021-01-05 | Will | Illinois | 17197 | 53778 | 795 |
895175 | 895175 | 2021-01-04 | Will | Illinois | 17197 | 53443 | 792 |
891928 | 891928 | 2021-01-03 | Will | Illinois | 17197 | 53165 | 789 |
888682 | 888682 | 2021-01-02 | Will | Illinois | 17197 | 52899 | 788 |
885436 | 885436 | 2021-01-01 | Will | Illinois | 17197 | 52293 | 780 |
882191 | 882191 | 2020-12-31 | Will | Illinois | 17197 | 52293 | 780 |
878946 | 878946 | 2020-12-30 | Will | Illinois | 17197 | 51794 | 773 |
875701 | 875701 | 2020-12-29 | Will | Illinois | 17197 | 51466 | 767 |
872456 | 872456 | 2020-12-28 | Will | Illinois | 17197 | 51137 | 761 |
869211 | 869211 | 2020-12-27 | Will | Illinois | 17197 | 50920 | 756 |
865966 | 865966 | 2020-12-26 | Will | Illinois | 17197 | 50712 | 753 |
862721 | 862721 | 2020-12-25 | Will | Illinois | 17197 | 50528 | 748 |
859476 | 859476 | 2020-12-24 | Will | Illinois | 17197 | 50238 | 741 |
856231 | 856231 | 2020-12-23 | Will | Illinois | 17197 | 49861 | 736 |
852986 | 852986 | 2020-12-22 | Will | Illinois | 17197 | 49522 | 728 |
849741 | 849741 | 2020-12-21 | Will | Illinois | 17197 | 49253 | 723 |
846496 | 846496 | 2020-12-20 | Will | Illinois | 17197 | 49025 | 718 |
843250 | 843250 | 2020-12-19 | Will | Illinois | 17197 | 48657 | 710 |
840005 | 840005 | 2020-12-18 | Will | Illinois | 17197 | 48272 | 705 |
836760 | 836760 | 2020-12-17 | Will | Illinois | 17197 | 47899 | 698 |
833514 | 833514 | 2020-12-16 | Will | Illinois | 17197 | 47257 | 691 |
830267 | 830267 | 2020-12-15 | Will | Illinois | 17197 | 46879 | 685 |
827021 | 827021 | 2020-12-14 | Will | Illinois | 17197 | 46584 | 673 |
823774 | 823774 | 2020-12-13 | Will | Illinois | 17197 | 46265 | 672 |
820528 | 820528 | 2020-12-12 | Will | Illinois | 17197 | 45881 | 668 |
817282 | 817282 | 2020-12-11 | Will | Illinois | 17197 | 45363 | 659 |
814036 | 814036 | 2020-12-10 | Will | Illinois | 17197 | 44883 | 650 |
810791 | 810791 | 2020-12-09 | Will | Illinois | 17197 | 44069 | 637 |
807546 | 807546 | 2020-12-08 | Will | Illinois | 17197 | 43578 | 627 |
804301 | 804301 | 2020-12-07 | Will | Illinois | 17197 | 43192 | 621 |
801056 | 801056 | 2020-12-06 | Will | Illinois | 17197 | 42798 | 618 |
797811 | 797811 | 2020-12-05 | Will | Illinois | 17197 | 42380 | 614 |
794566 | 794566 | 2020-12-04 | Will | Illinois | 17197 | 41826 | 600 |
791321 | 791321 | 2020-12-03 | Will | Illinois | 17197 | 41204 | 590 |
788076 | 788076 | 2020-12-02 | Will | Illinois | 17197 | 40611 | 578 |
784832 | 784832 | 2020-12-01 | Will | Illinois | 17197 | 40092 | 567 |
781587 | 781587 | 2020-11-30 | Will | Illinois | 17197 | 39020 | 565 |
778341 | 778341 | 2020-11-29 | Will | Illinois | 17197 | 38684 | 563 |
775096 | 775096 | 2020-11-28 | Will | Illinois | 17197 | 38291 | 563 |
771851 | 771851 | 2020-11-27 | Will | Illinois | 17197 | 37864 | 560 |
768606 | 768606 | 2020-11-26 | Will | Illinois | 17197 | 37368 | 553 |
765360 | 765360 | 2020-11-25 | Will | Illinois | 17197 | 36762 | 544 |
762115 | 762115 | 2020-11-24 | Will | Illinois | 17197 | 36082 | 532 |
758870 | 758870 | 2020-11-23 | Will | Illinois | 17197 | 35444 | 530 |
755623 | 755623 | 2020-11-22 | Will | Illinois | 17197 | 34965 | 530 |
752377 | 752377 | 2020-11-21 | Will | Illinois | 17197 | 34338 | 526 |
749131 | 749131 | 2020-11-20 | Will | Illinois | 17197 | 33564 | 519 |
745885 | 745885 | 2020-11-19 | Will | Illinois | 17197 | 32818 | 517 |
742638 | 742638 | 2020-11-18 | Will | Illinois | 17197 | 31913 | 513 |
739391 | 739391 | 2020-11-17 | Will | Illinois | 17197 | 31289 | 510 |
736147 | 736147 | 2020-11-16 | Will | Illinois | 17197 | 30384 | 508 |
732901 | 732901 | 2020-11-15 | Will | Illinois | 17197 | 29725 | 507 |
729656 | 729656 | 2020-11-14 | Will | Illinois | 17197 | 29092 | 505 |
726413 | 726413 | 2020-11-13 | Will | Illinois | 17197 | 28304 | 494 |
723170 | 723170 | 2020-11-12 | Will | Illinois | 17197 | 27412 | 493 |
719927 | 719927 | 2020-11-11 | Will | Illinois | 17197 | 26627 | 491 |
716684 | 716684 | 2020-11-10 | Will | Illinois | 17197 | 25892 | 481 |
713440 | 713440 | 2020-11-09 | Will | Illinois | 17197 | 25132 | 477 |
710196 | 710196 | 2020-11-08 | Will | Illinois | 17197 | 24580 | 476 |
706952 | 706952 | 2020-11-07 | Will | Illinois | 17197 | 24010 | 475 |
703709 | 703709 | 2020-11-06 | Will | Illinois | 17197 | 23279 | 473 |
700467 | 700467 | 2020-11-05 | Will | Illinois | 17197 | 22323 | 452 |
697223 | 697223 | 2020-11-04 | Will | Illinois | 17197 | 21795 | 449 |
693981 | 693981 | 2020-11-03 | Will | Illinois | 17197 | 21419 | 448 |
690738 | 690738 | 2020-11-02 | Will | Illinois | 17197 | 21043 | 446 |
687493 | 687493 | 2020-11-01 | Will | Illinois | 17197 | 20657 | 445 |
684249 | 684249 | 2020-10-31 | Will | Illinois | 17197 | 19946 | 439 |
681006 | 681006 | 2020-10-30 | Will | Illinois | 17197 | 19946 | 439 |
677763 | 677763 | 2020-10-29 | Will | Illinois | 17197 | 19516 | 434 |
674520 | 674520 | 2020-10-28 | Will | Illinois | 17197 | 19141 | 430 |
671278 | 671278 | 2020-10-27 | Will | Illinois | 17197 | 18807 | 429 |
668035 | 668035 | 2020-10-26 | Will | Illinois | 17197 | 18621 | 427 |
664791 | 664791 | 2020-10-25 | Will | Illinois | 17197 | 18356 | 427 |
661546 | 661546 | 2020-10-24 | Will | Illinois | 17197 | 18179 | 427 |
658302 | 658302 | 2020-10-23 | Will | Illinois | 17197 | 17862 | 427 |
655057 | 655057 | 2020-10-22 | Will | Illinois | 17197 | 17616 | 425 |
651812 | 651812 | 2020-10-21 | Will | Illinois | 17197 | 17354 | 424 |
648568 | 648568 | 2020-10-20 | Will | Illinois | 17197 | 17309 | 424 |
645323 | 645323 | 2020-10-19 | Will | Illinois | 17197 | 17100 | 421 |
642076 | 642076 | 2020-10-18 | Will | Illinois | 17197 | 16748 | 418 |
638829 | 638829 | 2020-10-17 | Will | Illinois | 17197 | 16481 | 418 |
635583 | 635583 | 2020-10-16 | Will | Illinois | 17197 | 16321 | 414 |
632337 | 632337 | 2020-10-15 | Will | Illinois | 17197 | 16181 | 415 |
629093 | 629093 | 2020-10-14 | Will | Illinois | 17197 | 16031 | 411 |
625850 | 625850 | 2020-10-13 | Will | Illinois | 17197 | 15879 | 404 |
622608 | 622608 | 2020-10-12 | Will | Illinois | 17197 | 15644 | 402 |
619364 | 619364 | 2020-10-11 | Will | Illinois | 17197 | 15508 | 401 |
616122 | 616122 | 2020-10-10 | Will | Illinois | 17197 | 15394 | 400 |
612881 | 612881 | 2020-10-09 | Will | Illinois | 17197 | 15202 | 398 |
609639 | 609639 | 2020-10-08 | Will | Illinois | 17197 | 15153 | 399 |
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);