ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "DuPage" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930795 | 930795 | 2021-01-15 | DuPage | Illinois | 17043 | 68156 | 1136 |
927550 | 927550 | 2021-01-14 | DuPage | Illinois | 17043 | 67651 | 1129 |
924304 | 924304 | 2021-01-13 | DuPage | Illinois | 17043 | 67271 | 1122 |
921059 | 921059 | 2021-01-12 | DuPage | Illinois | 17043 | 66858 | 1116 |
917814 | 917814 | 2021-01-11 | DuPage | Illinois | 17043 | 66414 | 1109 |
914569 | 914569 | 2021-01-10 | DuPage | Illinois | 17043 | 66084 | 1107 |
911324 | 911324 | 2021-01-09 | DuPage | Illinois | 17043 | 65784 | 1105 |
908079 | 908079 | 2021-01-08 | DuPage | Illinois | 17043 | 65385 | 1099 |
904833 | 904833 | 2021-01-07 | DuPage | Illinois | 17043 | 64755 | 1092 |
901588 | 901588 | 2021-01-06 | DuPage | Illinois | 17043 | 64259 | 1082 |
898343 | 898343 | 2021-01-05 | DuPage | Illinois | 17043 | 63831 | 1074 |
895098 | 895098 | 2021-01-04 | DuPage | Illinois | 17043 | 63396 | 1062 |
891851 | 891851 | 2021-01-03 | DuPage | Illinois | 17043 | 63022 | 1055 |
888604 | 888604 | 2021-01-02 | DuPage | Illinois | 17043 | 62676 | 1051 |
885359 | 885359 | 2021-01-01 | DuPage | Illinois | 17043 | 61805 | 1030 |
882114 | 882114 | 2020-12-31 | DuPage | Illinois | 17043 | 61805 | 1030 |
878869 | 878869 | 2020-12-30 | DuPage | Illinois | 17043 | 61271 | 1024 |
875624 | 875624 | 2020-12-29 | DuPage | Illinois | 17043 | 60839 | 1012 |
872379 | 872379 | 2020-12-28 | DuPage | Illinois | 17043 | 60473 | 1003 |
869134 | 869134 | 2020-12-27 | DuPage | Illinois | 17043 | 60077 | 991 |
865889 | 865889 | 2020-12-26 | DuPage | Illinois | 17043 | 59758 | 985 |
862644 | 862644 | 2020-12-25 | DuPage | Illinois | 17043 | 59577 | 981 |
859399 | 859399 | 2020-12-24 | DuPage | Illinois | 17043 | 59212 | 971 |
856154 | 856154 | 2020-12-23 | DuPage | Illinois | 17043 | 58741 | 966 |
852909 | 852909 | 2020-12-22 | DuPage | Illinois | 17043 | 58402 | 959 |
849664 | 849664 | 2020-12-21 | DuPage | Illinois | 17043 | 58048 | 952 |
846419 | 846419 | 2020-12-20 | DuPage | Illinois | 17043 | 57784 | 947 |
843173 | 843173 | 2020-12-19 | DuPage | Illinois | 17043 | 57421 | 944 |
839928 | 839928 | 2020-12-18 | DuPage | Illinois | 17043 | 56881 | 935 |
836683 | 836683 | 2020-12-17 | DuPage | Illinois | 17043 | 56512 | 928 |
833437 | 833437 | 2020-12-16 | DuPage | Illinois | 17043 | 55941 | 920 |
830190 | 830190 | 2020-12-15 | DuPage | Illinois | 17043 | 55495 | 912 |
826944 | 826944 | 2020-12-14 | DuPage | Illinois | 17043 | 55013 | 904 |
823697 | 823697 | 2020-12-13 | DuPage | Illinois | 17043 | 54533 | 904 |
820451 | 820451 | 2020-12-12 | DuPage | Illinois | 17043 | 54080 | 895 |
817205 | 817205 | 2020-12-11 | DuPage | Illinois | 17043 | 53456 | 890 |
813959 | 813959 | 2020-12-10 | DuPage | Illinois | 17043 | 52882 | 875 |
810714 | 810714 | 2020-12-09 | DuPage | Illinois | 17043 | 52300 | 865 |
807469 | 807469 | 2020-12-08 | DuPage | Illinois | 17043 | 51672 | 855 |
804224 | 804224 | 2020-12-07 | DuPage | Illinois | 17043 | 51051 | 850 |
800979 | 800979 | 2020-12-06 | DuPage | Illinois | 17043 | 50484 | 848 |
797734 | 797734 | 2020-12-05 | DuPage | Illinois | 17043 | 49976 | 844 |
794489 | 794489 | 2020-12-04 | DuPage | Illinois | 17043 | 49311 | 832 |
791244 | 791244 | 2020-12-03 | DuPage | Illinois | 17043 | 48499 | 821 |
787999 | 787999 | 2020-12-02 | DuPage | Illinois | 17043 | 47742 | 808 |
784755 | 784755 | 2020-12-01 | DuPage | Illinois | 17043 | 47179 | 797 |
781510 | 781510 | 2020-11-30 | DuPage | Illinois | 17043 | 45446 | 790 |
778264 | 778264 | 2020-11-29 | DuPage | Illinois | 17043 | 45087 | 788 |
775019 | 775019 | 2020-11-28 | DuPage | Illinois | 17043 | 44656 | 786 |
771774 | 771774 | 2020-11-27 | DuPage | Illinois | 17043 | 44035 | 777 |
768529 | 768529 | 2020-11-26 | DuPage | Illinois | 17043 | 43513 | 770 |
765283 | 765283 | 2020-11-25 | DuPage | Illinois | 17043 | 42881 | 762 |
762038 | 762038 | 2020-11-24 | DuPage | Illinois | 17043 | 42201 | 754 |
758793 | 758793 | 2020-11-23 | DuPage | Illinois | 17043 | 41602 | 748 |
755546 | 755546 | 2020-11-22 | DuPage | Illinois | 17043 | 41006 | 746 |
752300 | 752300 | 2020-11-21 | DuPage | Illinois | 17043 | 40314 | 744 |
749054 | 749054 | 2020-11-20 | DuPage | Illinois | 17043 | 39547 | 739 |
745808 | 745808 | 2020-11-19 | DuPage | Illinois | 17043 | 38670 | 731 |
742561 | 742561 | 2020-11-18 | DuPage | Illinois | 17043 | 37632 | 716 |
739314 | 739314 | 2020-11-17 | DuPage | Illinois | 17043 | 36941 | 708 |
736070 | 736070 | 2020-11-16 | DuPage | Illinois | 17043 | 35878 | 704 |
732824 | 732824 | 2020-11-15 | DuPage | Illinois | 17043 | 35284 | 703 |
729579 | 729579 | 2020-11-14 | DuPage | Illinois | 17043 | 34607 | 699 |
726336 | 726336 | 2020-11-13 | DuPage | Illinois | 17043 | 33851 | 692 |
723093 | 723093 | 2020-11-12 | DuPage | Illinois | 17043 | 33102 | 691 |
719850 | 719850 | 2020-11-11 | DuPage | Illinois | 17043 | 32487 | 688 |
716607 | 716607 | 2020-11-10 | DuPage | Illinois | 17043 | 31830 | 683 |
713363 | 713363 | 2020-11-09 | DuPage | Illinois | 17043 | 30977 | 681 |
710119 | 710119 | 2020-11-08 | DuPage | Illinois | 17043 | 30244 | 680 |
706875 | 706875 | 2020-11-07 | DuPage | Illinois | 17043 | 29541 | 679 |
703632 | 703632 | 2020-11-06 | DuPage | Illinois | 17043 | 28834 | 675 |
700389 | 700389 | 2020-11-05 | DuPage | Illinois | 17043 | 27584 | 634 |
697145 | 697145 | 2020-11-04 | DuPage | Illinois | 17043 | 27065 | 632 |
693903 | 693903 | 2020-11-03 | DuPage | Illinois | 17043 | 26512 | 626 |
690660 | 690660 | 2020-11-02 | DuPage | Illinois | 17043 | 26065 | 624 |
687415 | 687415 | 2020-11-01 | DuPage | Illinois | 17043 | 25681 | 622 |
684171 | 684171 | 2020-10-31 | DuPage | Illinois | 17043 | 24696 | 619 |
680928 | 680928 | 2020-10-30 | DuPage | Illinois | 17043 | 24696 | 619 |
677685 | 677685 | 2020-10-29 | DuPage | Illinois | 17043 | 24240 | 617 |
674442 | 674442 | 2020-10-28 | DuPage | Illinois | 17043 | 23780 | 615 |
671200 | 671200 | 2020-10-27 | DuPage | Illinois | 17043 | 23408 | 608 |
667957 | 667957 | 2020-10-26 | DuPage | Illinois | 17043 | 23099 | 607 |
664713 | 664713 | 2020-10-25 | DuPage | Illinois | 17043 | 22783 | 606 |
661468 | 661468 | 2020-10-24 | DuPage | Illinois | 17043 | 22546 | 607 |
658224 | 658224 | 2020-10-23 | DuPage | Illinois | 17043 | 22100 | 605 |
654979 | 654979 | 2020-10-22 | DuPage | Illinois | 17043 | 21776 | 605 |
651734 | 651734 | 2020-10-21 | DuPage | Illinois | 17043 | 21470 | 603 |
648490 | 648490 | 2020-10-20 | DuPage | Illinois | 17043 | 21231 | 599 |
645245 | 645245 | 2020-10-19 | DuPage | Illinois | 17043 | 20947 | 598 |
641998 | 641998 | 2020-10-18 | DuPage | Illinois | 17043 | 20724 | 596 |
638751 | 638751 | 2020-10-17 | DuPage | Illinois | 17043 | 20477 | 596 |
635505 | 635505 | 2020-10-16 | DuPage | Illinois | 17043 | 20277 | 595 |
632259 | 632259 | 2020-10-15 | DuPage | Illinois | 17043 | 19967 | 592 |
629015 | 629015 | 2020-10-14 | DuPage | Illinois | 17043 | 19767 | 588 |
625772 | 625772 | 2020-10-13 | DuPage | Illinois | 17043 | 19640 | 585 |
622530 | 622530 | 2020-10-12 | DuPage | Illinois | 17043 | 19467 | 583 |
619286 | 619286 | 2020-10-11 | DuPage | Illinois | 17043 | 19310 | 583 |
616044 | 616044 | 2020-10-10 | DuPage | Illinois | 17043 | 19156 | 580 |
612803 | 612803 | 2020-10-09 | DuPage | Illinois | 17043 | 18985 | 579 |
609561 | 609561 | 2020-10-08 | DuPage | Illinois | 17043 | 18788 | 577 |
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);