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 2021-10-10 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1800970 | 1800970 | 2021-10-10 | Adams | Illinois | 17001 | 12983 | 180 |
1800971 | 1800971 | 2021-10-10 | Alexander | Illinois | 17003 | 699 | 11 |
1800972 | 1800972 | 2021-10-10 | Bond | Illinois | 17005 | 2513 | 30 |
1800973 | 1800973 | 2021-10-10 | Boone | Illinois | 17007 | 7784 | 95 |
1800974 | 1800974 | 2021-10-10 | Brown | Illinois | 17009 | 1056 | 15 |
1800975 | 1800975 | 2021-10-10 | Bureau | Illinois | 17011 | 4361 | 102 |
1800976 | 1800976 | 2021-10-10 | Calhoun | Illinois | 17013 | 676 | 5 |
1800977 | 1800977 | 2021-10-10 | Carroll | Illinois | 17015 | 2332 | 39 |
1800978 | 1800978 | 2021-10-10 | Cass | Illinois | 17017 | 2623 | 38 |
1800979 | 1800979 | 2021-10-10 | Champaign | Illinois | 17019 | 26580 | 200 |
1800980 | 1800980 | 2021-10-10 | Christian | Illinois | 17021 | 5150 | 100 |
1800981 | 1800981 | 2021-10-10 | Clark | Illinois | 17023 | 2626 | 47 |
1800982 | 1800982 | 2021-10-10 | Clay | Illinois | 17025 | 2537 | 56 |
1800983 | 1800983 | 2021-10-10 | Clinton | Illinois | 17027 | 7017 | 110 |
1800984 | 1800984 | 2021-10-10 | Coles | Illinois | 17029 | 7735 | 121 |
1800985 | 1800985 | 2021-10-10 | Cook | Illinois | 17031 | 626475 | 11664 |
1800986 | 1800986 | 2021-10-10 | Crawford | Illinois | 17033 | 3252 | 46 |
1800987 | 1800987 | 2021-10-10 | Cumberland | Illinois | 17035 | 1866 | 38 |
1800988 | 1800988 | 2021-10-10 | De Witt | Illinois | 17039 | 2029 | 37 |
1800989 | 1800989 | 2021-10-10 | DeKalb | Illinois | 17037 | 12253 | 138 |
1800990 | 1800990 | 2021-10-10 | Douglas | Illinois | 17041 | 3186 | 43 |
1800991 | 1800991 | 2021-10-10 | DuPage | Illinois | 17043 | 106401 | 1457 |
1800992 | 1800992 | 2021-10-10 | Edgar | Illinois | 17045 | 2491 | 68 |
1800993 | 1800993 | 2021-10-10 | Edwards | Illinois | 17047 | 1013 | 18 |
1800994 | 1800994 | 2021-10-10 | Effingham | Illinois | 17049 | 6482 | 108 |
1800995 | 1800995 | 2021-10-10 | Fayette | Illinois | 17051 | 4237 | 64 |
1800996 | 1800996 | 2021-10-10 | Ford | Illinois | 17053 | 2402 | 66 |
1800997 | 1800997 | 2021-10-10 | Franklin | Illinois | 17055 | 7200 | 120 |
1800998 | 1800998 | 2021-10-10 | Fulton | Illinois | 17057 | 5107 | 80 |
1800999 | 1800999 | 2021-10-10 | Gallatin | Illinois | 17059 | 783 | 8 |
1801000 | 1801000 | 2021-10-10 | Greene | Illinois | 17061 | 2033 | 53 |
1801001 | 1801001 | 2021-10-10 | Grundy | Illinois | 17063 | 7239 | 88 |
1801002 | 1801002 | 2021-10-10 | Hamilton | Illinois | 17065 | 1322 | 25 |
1801003 | 1801003 | 2021-10-10 | Hancock | Illinois | 17067 | 2695 | 45 |
1801004 | 1801004 | 2021-10-10 | Hardin | Illinois | 17069 | 577 | 16 |
1801005 | 1801005 | 2021-10-10 | Henderson | Illinois | 17071 | 690 | 23 |
1801006 | 1801006 | 2021-10-10 | Henry | Illinois | 17073 | 6496 | 105 |
1801007 | 1801007 | 2021-10-10 | Iroquois | Illinois | 17075 | 4128 | 78 |
1801008 | 1801008 | 2021-10-10 | Jackson | Illinois | 17077 | 7984 | 104 |
1801009 | 1801009 | 2021-10-10 | Jasper | Illinois | 17079 | 1589 | 23 |
1801010 | 1801010 | 2021-10-10 | Jefferson | Illinois | 17081 | 6373 | 140 |
1801011 | 1801011 | 2021-10-10 | Jersey | Illinois | 17083 | 3322 | 72 |
1801012 | 1801012 | 2021-10-10 | Jo Daviess | Illinois | 17085 | 2128 | 31 |
1801013 | 1801013 | 2021-10-10 | Johnson | Illinois | 17087 | 2226 | 37 |
1801014 | 1801014 | 2021-10-10 | Kane | Illinois | 17089 | 67368 | 917 |
1801015 | 1801015 | 2021-10-10 | Kankakee | Illinois | 17091 | 17567 | 249 |
1801016 | 1801016 | 2021-10-10 | Kendall | Illinois | 17093 | 16770 | 119 |
1801017 | 1801017 | 2021-10-10 | Knox | Illinois | 17095 | 7057 | 200 |
1801018 | 1801018 | 2021-10-10 | LaSalle | Illinois | 17099 | 14836 | 337 |
1801019 | 1801019 | 2021-10-10 | Lake | Illinois | 17097 | 78886 | 1143 |
1801020 | 1801020 | 2021-10-10 | Lawrence | Illinois | 17101 | 3211 | 41 |
1801021 | 1801021 | 2021-10-10 | Lee | Illinois | 17103 | 4713 | 99 |
1801022 | 1801022 | 2021-10-10 | Livingston | Illinois | 17105 | 5876 | 109 |
1801023 | 1801023 | 2021-10-10 | Logan | Illinois | 17107 | 4889 | 87 |
1801024 | 1801024 | 2021-10-10 | Macon | Illinois | 17115 | 15041 | 259 |
1801025 | 1801025 | 2021-10-10 | Macoupin | Illinois | 17117 | 6820 | 133 |
1801026 | 1801026 | 2021-10-10 | Madison | Illinois | 17119 | 39499 | 658 |
1801027 | 1801027 | 2021-10-10 | Marion | Illinois | 17121 | 6800 | 147 |
1801028 | 1801028 | 2021-10-10 | Marshall | Illinois | 17123 | 1397 | 23 |
1801029 | 1801029 | 2021-10-10 | Mason | Illinois | 17125 | 2089 | 52 |
1801030 | 1801030 | 2021-10-10 | Massac | Illinois | 17127 | 2113 | 49 |
1801031 | 1801031 | 2021-10-10 | McDonough | Illinois | 17109 | 3674 | 70 |
1801032 | 1801032 | 2021-10-10 | McHenry | Illinois | 17111 | 34060 | 346 |
1801033 | 1801033 | 2021-10-10 | McLean | Illinois | 17113 | 22616 | 251 |
1801034 | 1801034 | 2021-10-10 | Menard | Illinois | 17129 | 1695 | 17 |
1801035 | 1801035 | 2021-10-10 | Mercer | Illinois | 17131 | 1997 | 34 |
1801036 | 1801036 | 2021-10-10 | Monroe | Illinois | 17133 | 5197 | 100 |
1801037 | 1801037 | 2021-10-10 | Montgomery | Illinois | 17135 | 4813 | 84 |
1801038 | 1801038 | 2021-10-10 | Morgan | Illinois | 17137 | 5148 | 120 |
1801039 | 1801039 | 2021-10-10 | Moultrie | Illinois | 17139 | 2226 | 41 |
1801040 | 1801040 | 2021-10-10 | Ogle | Illinois | 17141 | 7429 | 95 |
1801041 | 1801041 | 2021-10-10 | Peoria | Illinois | 17143 | 26650 | 396 |
1801042 | 1801042 | 2021-10-10 | Perry | Illinois | 17145 | 4260 | 83 |
1801043 | 1801043 | 2021-10-10 | Piatt | Illinois | 17147 | 1984 | 20 |
1801044 | 1801044 | 2021-10-10 | Pike | Illinois | 17149 | 2607 | 59 |
1801045 | 1801045 | 2021-10-10 | Pope | Illinois | 17151 | 535 | 5 |
1801046 | 1801046 | 2021-10-10 | Pulaski | Illinois | 17153 | 1028 | 11 |
1801047 | 1801047 | 2021-10-10 | Putnam | Illinois | 17155 | 555 | 5 |
1801048 | 1801048 | 2021-10-10 | Randolph | Illinois | 17157 | 5470 | 104 |
1801049 | 1801049 | 2021-10-10 | Richland | Illinois | 17159 | 2762 | 66 |
1801050 | 1801050 | 2021-10-10 | Rock Island | Illinois | 17161 | 18434 | 397 |
1801051 | 1801051 | 2021-10-10 | Saline | Illinois | 17165 | 4288 | 85 |
1801052 | 1801052 | 2021-10-10 | Sangamon | Illinois | 17167 | 25381 | 324 |
1801053 | 1801053 | 2021-10-10 | Schuyler | Illinois | 17169 | 1030 | 22 |
1801054 | 1801054 | 2021-10-10 | Scott | Illinois | 17171 | 706 | 6 |
1801055 | 1801055 | 2021-10-10 | Shelby | Illinois | 17173 | 3341 | 48 |
1801056 | 1801056 | 2021-10-10 | St. Clair | Illinois | 17163 | 39804 | 634 |
1801057 | 1801057 | 2021-10-10 | Stark | Illinois | 17175 | 799 | 27 |
1801058 | 1801058 | 2021-10-10 | Stephenson | Illinois | 17177 | 5697 | 110 |
1801059 | 1801059 | 2021-10-10 | Tazewell | Illinois | 17179 | 20341 | 360 |
1801060 | 1801060 | 2021-10-10 | Union | Illinois | 17181 | 3020 | 51 |
1801061 | 1801061 | 2021-10-10 | Unknown | Illinois | 0 | 714 | |
1801062 | 1801062 | 2021-10-10 | Vermilion | Illinois | 17183 | 13930 | 212 |
1801063 | 1801063 | 2021-10-10 | Wabash | Illinois | 17185 | 2143 | 21 |
1801064 | 1801064 | 2021-10-10 | Warren | Illinois | 17187 | 2395 | 68 |
1801065 | 1801065 | 2021-10-10 | Washington | Illinois | 17189 | 2106 | 34 |
1801066 | 1801066 | 2021-10-10 | Wayne | Illinois | 17191 | 2923 | 61 |
1801067 | 1801067 | 2021-10-10 | White | Illinois | 17193 | 2747 | 43 |
1801068 | 1801068 | 2021-10-10 | Whiteside | Illinois | 17195 | 8266 | 220 |
1801069 | 1801069 | 2021-10-10 | Will | Illinois | 17197 | 89720 | 1185 |
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);