ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2020-08-01 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389752 | 389752 | 2020-08-01 | Adams | Illinois | 17001 | 410 | 3 |
389753 | 389753 | 2020-08-01 | Alexander | Illinois | 17003 | 36 | 0 |
389754 | 389754 | 2020-08-01 | Bond | Illinois | 17005 | 49 | 2 |
389755 | 389755 | 2020-08-01 | Boone | Illinois | 17007 | 727 | 23 |
389756 | 389756 | 2020-08-01 | Brown | Illinois | 17009 | 13 | 0 |
389757 | 389757 | 2020-08-01 | Bureau | Illinois | 17011 | 132 | 2 |
389758 | 389758 | 2020-08-01 | Calhoun | Illinois | 17013 | 7 | 0 |
389759 | 389759 | 2020-08-01 | Carroll | Illinois | 17015 | 44 | 3 |
389760 | 389760 | 2020-08-01 | Cass | Illinois | 17017 | 198 | 11 |
389761 | 389761 | 2020-08-01 | Champaign | Illinois | 17019 | 1513 | 19 |
389762 | 389762 | 2020-08-01 | Christian | Illinois | 17021 | 111 | 5 |
389763 | 389763 | 2020-08-01 | Clark | Illinois | 17023 | 66 | 0 |
389764 | 389764 | 2020-08-01 | Clay | Illinois | 17025 | 13 | 0 |
389765 | 389765 | 2020-08-01 | Clinton | Illinois | 17027 | 333 | 17 |
389766 | 389766 | 2020-08-01 | Coles | Illinois | 17029 | 385 | 19 |
389767 | 389767 | 2020-08-01 | Cook | Illinois | 17031 | 106131 | 4888 |
389768 | 389768 | 2020-08-01 | Crawford | Illinois | 17033 | 29 | 0 |
389769 | 389769 | 2020-08-01 | Cumberland | Illinois | 17035 | 46 | 2 |
389770 | 389770 | 2020-08-01 | De Witt | Illinois | 17039 | 27 | 0 |
389771 | 389771 | 2020-08-01 | DeKalb | Illinois | 17037 | 836 | 29 |
389772 | 389772 | 2020-08-01 | Douglas | Illinois | 17041 | 102 | 2 |
389773 | 389773 | 2020-08-01 | DuPage | Illinois | 17043 | 11380 | 510 |
389774 | 389774 | 2020-08-01 | Edgar | Illinois | 17045 | 25 | 0 |
389775 | 389775 | 2020-08-01 | Edwards | Illinois | 17047 | 13 | 0 |
389776 | 389776 | 2020-08-01 | Effingham | Illinois | 17049 | 95 | 1 |
389777 | 389777 | 2020-08-01 | Fayette | Illinois | 17051 | 54 | 3 |
389778 | 389778 | 2020-08-01 | Ford | Illinois | 17053 | 39 | 1 |
389779 | 389779 | 2020-08-01 | Franklin | Illinois | 17055 | 118 | 0 |
389780 | 389780 | 2020-08-01 | Fulton | Illinois | 17057 | 25 | 0 |
389781 | 389781 | 2020-08-01 | Gallatin | Illinois | 17059 | 43 | 0 |
389782 | 389782 | 2020-08-01 | Greene | Illinois | 17061 | 19 | 0 |
389783 | 389783 | 2020-08-01 | Grundy | Illinois | 17063 | 274 | 5 |
389784 | 389784 | 2020-08-01 | Hamilton | Illinois | 17065 | 20 | 0 |
389785 | 389785 | 2020-08-01 | Hancock | Illinois | 17067 | 30 | 1 |
389786 | 389786 | 2020-08-01 | Hardin | Illinois | 17069 | 16 | 0 |
389787 | 389787 | 2020-08-01 | Henderson | Illinois | 17071 | 9 | 0 |
389788 | 389788 | 2020-08-01 | Henry | Illinois | 17073 | 195 | 1 |
389789 | 389789 | 2020-08-01 | Iroquois | Illinois | 17075 | 245 | 7 |
389790 | 389790 | 2020-08-01 | Jackson | Illinois | 17077 | 631 | 19 |
389791 | 389791 | 2020-08-01 | Jasper | Illinois | 17079 | 51 | 7 |
389792 | 389792 | 2020-08-01 | Jefferson | Illinois | 17081 | 184 | 17 |
389793 | 389793 | 2020-08-01 | Jersey | Illinois | 17083 | 65 | 1 |
389794 | 389794 | 2020-08-01 | Jo Daviess | Illinois | 17085 | 112 | 1 |
389795 | 389795 | 2020-08-01 | Johnson | Illinois | 17087 | 55 | 0 |
389796 | 389796 | 2020-08-01 | Kane | Illinois | 17089 | 9218 | 298 |
389797 | 389797 | 2020-08-01 | Kankakee | Illinois | 17091 | 1741 | 68 |
389798 | 389798 | 2020-08-01 | Kendall | Illinois | 17093 | 1329 | 24 |
389799 | 389799 | 2020-08-01 | Knox | Illinois | 17095 | 251 | 1 |
389800 | 389800 | 2020-08-01 | LaSalle | Illinois | 17099 | 497 | 18 |
389801 | 389801 | 2020-08-01 | Lake | Illinois | 17097 | 11952 | 440 |
389802 | 389802 | 2020-08-01 | Lawrence | Illinois | 17101 | 40 | 0 |
389803 | 389803 | 2020-08-01 | Lee | Illinois | 17103 | 146 | 2 |
389804 | 389804 | 2020-08-01 | Livingston | Illinois | 17105 | 92 | 2 |
389805 | 389805 | 2020-08-01 | Logan | Illinois | 17107 | 85 | 0 |
389806 | 389806 | 2020-08-01 | Macon | Illinois | 17115 | 450 | 23 |
389807 | 389807 | 2020-08-01 | Macoupin | Illinois | 17117 | 131 | 3 |
389808 | 389808 | 2020-08-01 | Madison | Illinois | 17119 | 2137 | 72 |
389809 | 389809 | 2020-08-01 | Marion | Illinois | 17121 | 132 | 0 |
389810 | 389810 | 2020-08-01 | Marshall | Illinois | 17123 | 21 | 0 |
389811 | 389811 | 2020-08-01 | Mason | Illinois | 17125 | 42 | 0 |
389812 | 389812 | 2020-08-01 | Massac | Illinois | 17127 | 34 | 0 |
389813 | 389813 | 2020-08-01 | McDonough | Illinois | 17109 | 125 | 15 |
389814 | 389814 | 2020-08-01 | McHenry | Illinois | 17111 | 2934 | 114 |
389815 | 389815 | 2020-08-01 | McLean | Illinois | 17113 | 552 | 15 |
389816 | 389816 | 2020-08-01 | Menard | Illinois | 17129 | 45 | 0 |
389817 | 389817 | 2020-08-01 | Mercer | Illinois | 17131 | 68 | 0 |
389818 | 389818 | 2020-08-01 | Monroe | Illinois | 17133 | 270 | 13 |
389819 | 389819 | 2020-08-01 | Montgomery | Illinois | 17135 | 141 | 5 |
389820 | 389820 | 2020-08-01 | Morgan | Illinois | 17137 | 189 | 5 |
389821 | 389821 | 2020-08-01 | Moultrie | Illinois | 17139 | 52 | 0 |
389822 | 389822 | 2020-08-01 | Ogle | Illinois | 17141 | 378 | 5 |
389823 | 389823 | 2020-08-01 | Peoria | Illinois | 17143 | 1280 | 34 |
389824 | 389824 | 2020-08-01 | Perry | Illinois | 17145 | 101 | 1 |
389825 | 389825 | 2020-08-01 | Piatt | Illinois | 17147 | 40 | 0 |
389826 | 389826 | 2020-08-01 | Pike | Illinois | 17149 | 13 | 0 |
389827 | 389827 | 2020-08-01 | Pope | Illinois | 17151 | 7 | 0 |
389828 | 389828 | 2020-08-01 | Pulaski | Illinois | 17153 | 90 | 0 |
389829 | 389829 | 2020-08-01 | Putnam | Illinois | 17155 | 7 | 0 |
389830 | 389830 | 2020-08-01 | Randolph | Illinois | 17157 | 422 | 7 |
389831 | 389831 | 2020-08-01 | Richland | Illinois | 17159 | 12 | 0 |
389832 | 389832 | 2020-08-01 | Rock Island | Illinois | 17161 | 1575 | 31 |
389833 | 389833 | 2020-08-01 | Saline | Illinois | 17165 | 105 | 1 |
389834 | 389834 | 2020-08-01 | Sangamon | Illinois | 17167 | 986 | 34 |
389835 | 389835 | 2020-08-01 | Schuyler | Illinois | 17169 | 15 | 0 |
389836 | 389836 | 2020-08-01 | Scott | Illinois | 17171 | 10 | 0 |
389837 | 389837 | 2020-08-01 | Shelby | Illinois | 17173 | 56 | 1 |
389838 | 389838 | 2020-08-01 | St. Clair | Illinois | 17163 | 3862 | 156 |
389839 | 389839 | 2020-08-01 | Stark | Illinois | 17175 | 7 | 0 |
389840 | 389840 | 2020-08-01 | Stephenson | Illinois | 17177 | 313 | 6 |
389841 | 389841 | 2020-08-01 | Tazewell | Illinois | 17179 | 361 | 8 |
389842 | 389842 | 2020-08-01 | Union | Illinois | 17181 | 296 | 21 |
389843 | 389843 | 2020-08-01 | Unknown | Illinois | 1256 | 197 | |
389844 | 389844 | 2020-08-01 | Vermilion | Illinois | 17183 | 200 | 2 |
389845 | 389845 | 2020-08-01 | Wabash | Illinois | 17185 | 30 | 0 |
389846 | 389846 | 2020-08-01 | Warren | Illinois | 17187 | 180 | 0 |
389847 | 389847 | 2020-08-01 | Washington | Illinois | 17189 | 56 | 0 |
389848 | 389848 | 2020-08-01 | Wayne | Illinois | 17191 | 43 | 1 |
389849 | 389849 | 2020-08-01 | White | Illinois | 17193 | 57 | 0 |
389850 | 389850 | 2020-08-01 | Whiteside | Illinois | 17195 | 323 | 16 |
389851 | 389851 | 2020-08-01 | Will | Illinois | 17197 | 8502 | 339 |
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);