ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Lake" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930823 | 930823 | 2021-01-15 | Lake | Illinois | 17097 | 52591 | 877 |
927578 | 927578 | 2021-01-14 | Lake | Illinois | 17097 | 52264 | 874 |
924332 | 924332 | 2021-01-13 | Lake | Illinois | 17097 | 51944 | 872 |
921087 | 921087 | 2021-01-12 | Lake | Illinois | 17097 | 51685 | 864 |
917842 | 917842 | 2021-01-11 | Lake | Illinois | 17097 | 51253 | 858 |
914597 | 914597 | 2021-01-10 | Lake | Illinois | 17097 | 51027 | 857 |
911352 | 911352 | 2021-01-09 | Lake | Illinois | 17097 | 50860 | 857 |
908107 | 908107 | 2021-01-08 | Lake | Illinois | 17097 | 50662 | 853 |
904861 | 904861 | 2021-01-07 | Lake | Illinois | 17097 | 50213 | 847 |
901616 | 901616 | 2021-01-06 | Lake | Illinois | 17097 | 49805 | 840 |
898371 | 898371 | 2021-01-05 | Lake | Illinois | 17097 | 49517 | 837 |
895126 | 895126 | 2021-01-04 | Lake | Illinois | 17097 | 49151 | 829 |
891879 | 891879 | 2021-01-03 | Lake | Illinois | 17097 | 48978 | 827 |
888632 | 888632 | 2021-01-02 | Lake | Illinois | 17097 | 48809 | 826 |
885387 | 885387 | 2021-01-01 | Lake | Illinois | 17097 | 48300 | 818 |
882142 | 882142 | 2020-12-31 | Lake | Illinois | 17097 | 48300 | 818 |
878897 | 878897 | 2020-12-30 | Lake | Illinois | 17097 | 47939 | 812 |
875652 | 875652 | 2020-12-29 | Lake | Illinois | 17097 | 47564 | 802 |
872407 | 872407 | 2020-12-28 | Lake | Illinois | 17097 | 47325 | 797 |
869162 | 869162 | 2020-12-27 | Lake | Illinois | 17097 | 47101 | 794 |
865917 | 865917 | 2020-12-26 | Lake | Illinois | 17097 | 46940 | 788 |
862672 | 862672 | 2020-12-25 | Lake | Illinois | 17097 | 46833 | 786 |
859427 | 859427 | 2020-12-24 | Lake | Illinois | 17097 | 46551 | 772 |
856182 | 856182 | 2020-12-23 | Lake | Illinois | 17097 | 46271 | 765 |
852937 | 852937 | 2020-12-22 | Lake | Illinois | 17097 | 45936 | 763 |
849692 | 849692 | 2020-12-21 | Lake | Illinois | 17097 | 45653 | 757 |
846447 | 846447 | 2020-12-20 | Lake | Illinois | 17097 | 45431 | 754 |
843201 | 843201 | 2020-12-19 | Lake | Illinois | 17097 | 45168 | 753 |
839956 | 839956 | 2020-12-18 | Lake | Illinois | 17097 | 44858 | 747 |
836711 | 836711 | 2020-12-17 | Lake | Illinois | 17097 | 44533 | 735 |
833465 | 833465 | 2020-12-16 | Lake | Illinois | 17097 | 44099 | 729 |
830218 | 830218 | 2020-12-15 | Lake | Illinois | 17097 | 43764 | 726 |
826972 | 826972 | 2020-12-14 | Lake | Illinois | 17097 | 43437 | 721 |
823725 | 823725 | 2020-12-13 | Lake | Illinois | 17097 | 43088 | 718 |
820479 | 820479 | 2020-12-12 | Lake | Illinois | 17097 | 42727 | 712 |
817233 | 817233 | 2020-12-11 | Lake | Illinois | 17097 | 42410 | 706 |
813987 | 813987 | 2020-12-10 | Lake | Illinois | 17097 | 42110 | 700 |
810742 | 810742 | 2020-12-09 | Lake | Illinois | 17097 | 41667 | 694 |
807497 | 807497 | 2020-12-08 | Lake | Illinois | 17097 | 41303 | 688 |
804252 | 804252 | 2020-12-07 | Lake | Illinois | 17097 | 40932 | 683 |
801007 | 801007 | 2020-12-06 | Lake | Illinois | 17097 | 40293 | 681 |
797762 | 797762 | 2020-12-05 | Lake | Illinois | 17097 | 39927 | 675 |
794517 | 794517 | 2020-12-04 | Lake | Illinois | 17097 | 39563 | 669 |
791272 | 791272 | 2020-12-03 | Lake | Illinois | 17097 | 39051 | 663 |
788027 | 788027 | 2020-12-02 | Lake | Illinois | 17097 | 38638 | 655 |
784783 | 784783 | 2020-12-01 | Lake | Illinois | 17097 | 38073 | 641 |
781538 | 781538 | 2020-11-30 | Lake | Illinois | 17097 | 37596 | 634 |
778292 | 778292 | 2020-11-29 | Lake | Illinois | 17097 | 37299 | 631 |
775047 | 775047 | 2020-11-28 | Lake | Illinois | 17097 | 36845 | 631 |
771802 | 771802 | 2020-11-27 | Lake | Illinois | 17097 | 36375 | 629 |
768557 | 768557 | 2020-11-26 | Lake | Illinois | 17097 | 36001 | 623 |
765311 | 765311 | 2020-11-25 | Lake | Illinois | 17097 | 35460 | 619 |
762066 | 762066 | 2020-11-24 | Lake | Illinois | 17097 | 34915 | 612 |
758821 | 758821 | 2020-11-23 | Lake | Illinois | 17097 | 34539 | 604 |
755574 | 755574 | 2020-11-22 | Lake | Illinois | 17097 | 34159 | 602 |
752328 | 752328 | 2020-11-21 | Lake | Illinois | 17097 | 33841 | 600 |
749082 | 749082 | 2020-11-20 | Lake | Illinois | 17097 | 33260 | 590 |
745836 | 745836 | 2020-11-19 | Lake | Illinois | 17097 | 32825 | 586 |
742589 | 742589 | 2020-11-18 | Lake | Illinois | 17097 | 32063 | 578 |
739342 | 739342 | 2020-11-17 | Lake | Illinois | 17097 | 31753 | 577 |
736098 | 736098 | 2020-11-16 | Lake | Illinois | 17097 | 31079 | 572 |
732852 | 732852 | 2020-11-15 | Lake | Illinois | 17097 | 30532 | 571 |
729607 | 729607 | 2020-11-14 | Lake | Illinois | 17097 | 30031 | 569 |
726364 | 726364 | 2020-11-13 | Lake | Illinois | 17097 | 29497 | 561 |
723121 | 723121 | 2020-11-12 | Lake | Illinois | 17097 | 28602 | 559 |
719878 | 719878 | 2020-11-11 | Lake | Illinois | 17097 | 27920 | 556 |
716635 | 716635 | 2020-11-10 | Lake | Illinois | 17097 | 27189 | 552 |
713391 | 713391 | 2020-11-09 | Lake | Illinois | 17097 | 26541 | 549 |
710147 | 710147 | 2020-11-08 | Lake | Illinois | 17097 | 26144 | 549 |
706903 | 706903 | 2020-11-07 | Lake | Illinois | 17097 | 25758 | 548 |
703660 | 703660 | 2020-11-06 | Lake | Illinois | 17097 | 25124 | 546 |
700417 | 700417 | 2020-11-05 | Lake | Illinois | 17097 | 24105 | 530 |
697173 | 697173 | 2020-11-04 | Lake | Illinois | 17097 | 23652 | 525 |
693931 | 693931 | 2020-11-03 | Lake | Illinois | 17097 | 23177 | 524 |
690688 | 690688 | 2020-11-02 | Lake | Illinois | 17097 | 22817 | 523 |
687443 | 687443 | 2020-11-01 | Lake | Illinois | 17097 | 22618 | 522 |
684199 | 684199 | 2020-10-31 | Lake | Illinois | 17097 | 21819 | 518 |
680956 | 680956 | 2020-10-30 | Lake | Illinois | 17097 | 21819 | 518 |
677713 | 677713 | 2020-10-29 | Lake | Illinois | 17097 | 21608 | 518 |
674470 | 674470 | 2020-10-28 | Lake | Illinois | 17097 | 21373 | 514 |
671228 | 671228 | 2020-10-27 | Lake | Illinois | 17097 | 21010 | 511 |
667985 | 667985 | 2020-10-26 | Lake | Illinois | 17097 | 20815 | 511 |
664741 | 664741 | 2020-10-25 | Lake | Illinois | 17097 | 20630 | 510 |
661496 | 661496 | 2020-10-24 | Lake | Illinois | 17097 | 20485 | 509 |
658252 | 658252 | 2020-10-23 | Lake | Illinois | 17097 | 20157 | 508 |
655007 | 655007 | 2020-10-22 | Lake | Illinois | 17097 | 20042 | 507 |
651762 | 651762 | 2020-10-21 | Lake | Illinois | 17097 | 19856 | 507 |
648518 | 648518 | 2020-10-20 | Lake | Illinois | 17097 | 19758 | 506 |
645273 | 645273 | 2020-10-19 | Lake | Illinois | 17097 | 19579 | 503 |
642026 | 642026 | 2020-10-18 | Lake | Illinois | 17097 | 19438 | 503 |
638779 | 638779 | 2020-10-17 | Lake | Illinois | 17097 | 19252 | 501 |
635533 | 635533 | 2020-10-16 | Lake | Illinois | 17097 | 19102 | 501 |
632287 | 632287 | 2020-10-15 | Lake | Illinois | 17097 | 18909 | 499 |
629043 | 629043 | 2020-10-14 | Lake | Illinois | 17097 | 18704 | 499 |
625800 | 625800 | 2020-10-13 | Lake | Illinois | 17097 | 18541 | 499 |
622558 | 622558 | 2020-10-12 | Lake | Illinois | 17097 | 18394 | 498 |
619314 | 619314 | 2020-10-11 | Lake | Illinois | 17097 | 18251 | 498 |
616072 | 616072 | 2020-10-10 | Lake | Illinois | 17097 | 18141 | 498 |
612831 | 612831 | 2020-10-09 | Lake | Illinois | 17097 | 18056 | 495 |
609589 | 609589 | 2020-10-08 | Lake | Illinois | 17097 | 17946 | 494 |
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);