ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-09-15" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719742 | 1719742 | 2021-09-15 | Adams | Illinois | 17001 | 12525 | 176 |
1719743 | 1719743 | 2021-09-15 | Alexander | Illinois | 17003 | 660 | 11 |
1719744 | 1719744 | 2021-09-15 | Bond | Illinois | 17005 | 2415 | 29 |
1719745 | 1719745 | 2021-09-15 | Boone | Illinois | 17007 | 7533 | 93 |
1719746 | 1719746 | 2021-09-15 | Brown | Illinois | 17009 | 1012 | 13 |
1719747 | 1719747 | 2021-09-15 | Bureau | Illinois | 17011 | 4216 | 100 |
1719748 | 1719748 | 2021-09-15 | Calhoun | Illinois | 17013 | 634 | 5 |
1719749 | 1719749 | 2021-09-15 | Carroll | Illinois | 17015 | 2236 | 38 |
1719750 | 1719750 | 2021-09-15 | Cass | Illinois | 17017 | 2456 | 37 |
1719751 | 1719751 | 2021-09-15 | Champaign | Illinois | 17019 | 25478 | 190 |
1719752 | 1719752 | 2021-09-15 | Christian | Illinois | 17021 | 4749 | 98 |
1719753 | 1719753 | 2021-09-15 | Clark | Illinois | 17023 | 2410 | 46 |
1719754 | 1719754 | 2021-09-15 | Clay | Illinois | 17025 | 2305 | 52 |
1719755 | 1719755 | 2021-09-15 | Clinton | Illinois | 17027 | 6735 | 106 |
1719756 | 1719756 | 2021-09-15 | Coles | Illinois | 17029 | 7121 | 111 |
1719757 | 1719757 | 2021-09-15 | Cook | Illinois | 17031 | 607266 | 11457 |
1719758 | 1719758 | 2021-09-15 | Crawford | Illinois | 17033 | 2940 | 46 |
1719759 | 1719759 | 2021-09-15 | Cumberland | Illinois | 17035 | 1724 | 35 |
1719760 | 1719760 | 2021-09-15 | De Witt | Illinois | 17039 | 1912 | 37 |
1719761 | 1719761 | 2021-09-15 | DeKalb | Illinois | 17037 | 11741 | 131 |
1719762 | 1719762 | 2021-09-15 | Douglas | Illinois | 17041 | 3012 | 42 |
1719763 | 1719763 | 2021-09-15 | DuPage | Illinois | 17043 | 102689 | 1436 |
1719764 | 1719764 | 2021-09-15 | Edgar | Illinois | 17045 | 2268 | 64 |
1719765 | 1719765 | 2021-09-15 | Edwards | Illinois | 17047 | 940 | 16 |
1719766 | 1719766 | 2021-09-15 | Effingham | Illinois | 17049 | 5809 | 91 |
1719767 | 1719767 | 2021-09-15 | Fayette | Illinois | 17051 | 3852 | 59 |
1719768 | 1719768 | 2021-09-15 | Ford | Illinois | 17053 | 2327 | 63 |
1719769 | 1719769 | 2021-09-15 | Franklin | Illinois | 17055 | 6589 | 106 |
1719770 | 1719770 | 2021-09-15 | Fulton | Illinois | 17057 | 4753 | 77 |
1719771 | 1719771 | 2021-09-15 | Gallatin | Illinois | 17059 | 721 | 5 |
1719772 | 1719772 | 2021-09-15 | Greene | Illinois | 17061 | 1977 | 51 |
1719773 | 1719773 | 2021-09-15 | Grundy | Illinois | 17063 | 6904 | 85 |
1719774 | 1719774 | 2021-09-15 | Hamilton | Illinois | 17065 | 1257 | 23 |
1719775 | 1719775 | 2021-09-15 | Hancock | Illinois | 17067 | 2509 | 44 |
1719776 | 1719776 | 2021-09-15 | Hardin | Illinois | 17069 | 554 | 13 |
1719777 | 1719777 | 2021-09-15 | Henderson | Illinois | 17071 | 626 | 23 |
1719778 | 1719778 | 2021-09-15 | Henry | Illinois | 17073 | 6041 | 101 |
1719779 | 1719779 | 2021-09-15 | Iroquois | Illinois | 17075 | 3891 | 72 |
1719780 | 1719780 | 2021-09-15 | Jackson | Illinois | 17077 | 7483 | 90 |
1719781 | 1719781 | 2021-09-15 | Jasper | Illinois | 17079 | 1487 | 20 |
1719782 | 1719782 | 2021-09-15 | Jefferson | Illinois | 17081 | 5933 | 131 |
1719783 | 1719783 | 2021-09-15 | Jersey | Illinois | 17083 | 3187 | 72 |
1719784 | 1719784 | 2021-09-15 | Jo Daviess | Illinois | 17085 | 2016 | 27 |
1719785 | 1719785 | 2021-09-15 | Johnson | Illinois | 17087 | 2078 | 27 |
1719786 | 1719786 | 2021-09-15 | Kane | Illinois | 17089 | 65145 | 890 |
1719787 | 1719787 | 2021-09-15 | Kankakee | Illinois | 17091 | 16409 | 240 |
1719788 | 1719788 | 2021-09-15 | Kendall | Illinois | 17093 | 15549 | 113 |
1719789 | 1719789 | 2021-09-15 | Knox | Illinois | 17095 | 6439 | 194 |
1719790 | 1719790 | 2021-09-15 | LaSalle | Illinois | 17099 | 14258 | 328 |
1719791 | 1719791 | 2021-09-15 | Lake | Illinois | 17097 | 76122 | 1124 |
1719792 | 1719792 | 2021-09-15 | Lawrence | Illinois | 17101 | 2910 | 40 |
1719793 | 1719793 | 2021-09-15 | Lee | Illinois | 17103 | 4524 | 95 |
1719794 | 1719794 | 2021-09-15 | Livingston | Illinois | 17105 | 5602 | 106 |
1719795 | 1719795 | 2021-09-15 | Logan | Illinois | 17107 | 4713 | 86 |
1719796 | 1719796 | 2021-09-15 | Macon | Illinois | 17115 | 14134 | 240 |
1719797 | 1719797 | 2021-09-15 | Macoupin | Illinois | 17117 | 6299 | 126 |
1719798 | 1719798 | 2021-09-15 | Madison | Illinois | 17119 | 37519 | 637 |
1719799 | 1719799 | 2021-09-15 | Marion | Illinois | 17121 | 6392 | 141 |
1719800 | 1719800 | 2021-09-15 | Marshall | Illinois | 17123 | 1327 | 23 |
1719801 | 1719801 | 2021-09-15 | Mason | Illinois | 17125 | 1945 | 52 |
1719802 | 1719802 | 2021-09-15 | Massac | Illinois | 17127 | 1926 | 46 |
1719803 | 1719803 | 2021-09-15 | McDonough | Illinois | 17109 | 3508 | 67 |
1719804 | 1719804 | 2021-09-15 | McHenry | Illinois | 17111 | 32619 | 337 |
1719805 | 1719805 | 2021-09-15 | McLean | Illinois | 17113 | 21470 | 239 |
1719806 | 1719806 | 2021-09-15 | Menard | Illinois | 17129 | 1541 | 16 |
1719807 | 1719807 | 2021-09-15 | Mercer | Illinois | 17131 | 1854 | 34 |
1719808 | 1719808 | 2021-09-15 | Monroe | Illinois | 17133 | 5010 | 98 |
1719809 | 1719809 | 2021-09-15 | Montgomery | Illinois | 17135 | 4597 | 82 |
1719810 | 1719810 | 2021-09-15 | Morgan | Illinois | 17137 | 4941 | 117 |
1719811 | 1719811 | 2021-09-15 | Moultrie | Illinois | 17139 | 2067 | 38 |
1719812 | 1719812 | 2021-09-15 | Ogle | Illinois | 17141 | 6999 | 93 |
1719813 | 1719813 | 2021-09-15 | Peoria | Illinois | 17143 | 25726 | 389 |
1719814 | 1719814 | 2021-09-15 | Perry | Illinois | 17145 | 4077 | 79 |
1719815 | 1719815 | 2021-09-15 | Piatt | Illinois | 17147 | 1883 | 20 |
1719816 | 1719816 | 2021-09-15 | Pike | Illinois | 17149 | 2494 | 59 |
1719817 | 1719817 | 2021-09-15 | Pope | Illinois | 17151 | 468 | 5 |
1719818 | 1719818 | 2021-09-15 | Pulaski | Illinois | 17153 | 967 | 11 |
1719819 | 1719819 | 2021-09-15 | Putnam | Illinois | 17155 | 541 | 5 |
1719820 | 1719820 | 2021-09-15 | Randolph | Illinois | 17157 | 5170 | 102 |
1719821 | 1719821 | 2021-09-15 | Richland | Illinois | 17159 | 2540 | 61 |
1719822 | 1719822 | 2021-09-15 | Rock Island | Illinois | 17161 | 17502 | 385 |
1719823 | 1719823 | 2021-09-15 | Saline | Illinois | 17165 | 3935 | 78 |
1719824 | 1719824 | 2021-09-15 | Sangamon | Illinois | 17167 | 24108 | 305 |
1719825 | 1719825 | 2021-09-15 | Schuyler | Illinois | 17169 | 956 | 20 |
1719826 | 1719826 | 2021-09-15 | Scott | Illinois | 17171 | 688 | 5 |
1719827 | 1719827 | 2021-09-15 | Shelby | Illinois | 17173 | 2969 | 46 |
1719828 | 1719828 | 2021-09-15 | St. Clair | Illinois | 17163 | 38339 | 602 |
1719829 | 1719829 | 2021-09-15 | Stark | Illinois | 17175 | 754 | 26 |
1719830 | 1719830 | 2021-09-15 | Stephenson | Illinois | 17177 | 5340 | 107 |
1719831 | 1719831 | 2021-09-15 | Tazewell | Illinois | 17179 | 19477 | 360 |
1719832 | 1719832 | 2021-09-15 | Union | Illinois | 17181 | 2924 | 49 |
1719833 | 1719833 | 2021-09-15 | Unknown | Illinois | 0 | 584 | |
1719834 | 1719834 | 2021-09-15 | Vermilion | Illinois | 17183 | 12805 | 197 |
1719835 | 1719835 | 2021-09-15 | Wabash | Illinois | 17185 | 1937 | 18 |
1719836 | 1719836 | 2021-09-15 | Warren | Illinois | 17187 | 2186 | 58 |
1719837 | 1719837 | 2021-09-15 | Washington | Illinois | 17189 | 2038 | 33 |
1719838 | 1719838 | 2021-09-15 | Wayne | Illinois | 17191 | 2639 | 57 |
1719839 | 1719839 | 2021-09-15 | White | Illinois | 17193 | 2592 | 39 |
1719840 | 1719840 | 2021-09-15 | Whiteside | Illinois | 17195 | 7874 | 218 |
1719841 | 1719841 | 2021-09-15 | Will | Illinois | 17197 | 86210 | 1153 |
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);