ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,502 rows where state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 17031 236
- 17089 190
- 17111 190
- 17097 189
- 17035 186
- 17043 186
- 17163 186
- 17167 186
- 17203 186
- 17027 185
- 17195 185
- 17201 185
- 17143 184
- 17197 184
- 17077 182
- 17091 182
- 17093 182
- 17099 182
- 17119 182
- 17189 182
- 17199 182
- 17001 180
- 17021 180
- 17113 180
- 17037 179
- 17019 178
- 17085 178
- 17105 178
- 17161 178
- 17177 178
- …
county >30
- Cook 236
- Kane 190
- McHenry 190
- Lake 189
- Cumberland 186
- DuPage 186
- Sangamon 186
- St. Clair 186
- Woodford 186
- Clinton 185
- Whiteside 185
- Winnebago 185
- Peoria 184
- Will 184
- Jackson 182
- Kankakee 182
- Kendall 182
- LaSalle 182
- Madison 182
- Washington 182
- Williamson 182
- Adams 180
- Christian 180
- McLean 180
- DeKalb 179
- Champaign 178
- Jo Daviess 178
- Livingston 178
- Rock Island 178
- Stephenson 178
- …
state 1
- Illinois · 17,271 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535021 | 535021 | 2020-09-15 | Adams | Illinois | 17001 | 902 | 10 |
535022 | 535022 | 2020-09-15 | Alexander | Illinois | 17003 | 61 | 1 |
535023 | 535023 | 2020-09-15 | Bond | Illinois | 17005 | 245 | 4 |
535024 | 535024 | 2020-09-15 | Boone | Illinois | 17007 | 974 | 23 |
535025 | 535025 | 2020-09-15 | Brown | Illinois | 17009 | 31 | 0 |
535026 | 535026 | 2020-09-15 | Bureau | Illinois | 17011 | 511 | 9 |
535027 | 535027 | 2020-09-15 | Calhoun | Illinois | 17013 | 34 | 0 |
535028 | 535028 | 2020-09-15 | Carroll | Illinois | 17015 | 195 | 4 |
535029 | 535029 | 2020-09-15 | Cass | Illinois | 17017 | 353 | 11 |
535030 | 535030 | 2020-09-15 | Champaign | Illinois | 17019 | 4133 | 20 |
535031 | 535031 | 2020-09-15 | Christian | Illinois | 17021 | 320 | 11 |
535032 | 535032 | 2020-09-15 | Clark | Illinois | 17023 | 141 | 2 |
535033 | 535033 | 2020-09-15 | Clay | Illinois | 17025 | 134 | 0 |
535034 | 535034 | 2020-09-15 | Clinton | Illinois | 17027 | 971 | 19 |
535035 | 535035 | 2020-09-15 | Coles | Illinois | 17029 | 1268 | 26 |
535036 | 535036 | 2020-09-15 | Cook | Illinois | 17031 | 135690 | 5137 |
535037 | 535037 | 2020-09-15 | Crawford | Illinois | 17033 | 272 | 1 |
535038 | 535038 | 2020-09-15 | Cumberland | Illinois | 17035 | 183 | 4 |
535039 | 535039 | 2020-09-15 | De Witt | Illinois | 17039 | 86 | 1 |
535040 | 535040 | 2020-09-15 | DeKalb | Illinois | 17037 | 1396 | 36 |
535041 | 535041 | 2020-09-15 | Douglas | Illinois | 17041 | 267 | 5 |
535042 | 535042 | 2020-09-15 | DuPage | Illinois | 17043 | 16209 | 546 |
535043 | 535043 | 2020-09-15 | Edgar | Illinois | 17045 | 105 | 3 |
535044 | 535044 | 2020-09-15 | Edwards | Illinois | 17047 | 55 | 0 |
535045 | 535045 | 2020-09-15 | Effingham | Illinois | 17049 | 754 | 1 |
535046 | 535046 | 2020-09-15 | Fayette | Illinois | 17051 | 266 | 3 |
535047 | 535047 | 2020-09-15 | Ford | Illinois | 17053 | 86 | 4 |
535048 | 535048 | 2020-09-15 | Franklin | Illinois | 17055 | 440 | 1 |
535049 | 535049 | 2020-09-15 | Fulton | Illinois | 17057 | 126 | 0 |
535050 | 535050 | 2020-09-15 | Gallatin | Illinois | 17059 | 68 | 2 |
535051 | 535051 | 2020-09-15 | Greene | Illinois | 17061 | 187 | 2 |
535052 | 535052 | 2020-09-15 | Grundy | Illinois | 17063 | 595 | 5 |
535053 | 535053 | 2020-09-15 | Hamilton | Illinois | 17065 | 53 | 0 |
535054 | 535054 | 2020-09-15 | Hancock | Illinois | 17067 | 175 | 2 |
535055 | 535055 | 2020-09-15 | Hardin | Illinois | 17069 | 27 | 0 |
535056 | 535056 | 2020-09-15 | Henderson | Illinois | 17071 | 60 | 0 |
535057 | 535057 | 2020-09-15 | Henry | Illinois | 17073 | 583 | 4 |
535058 | 535058 | 2020-09-15 | Iroquois | Illinois | 17075 | 338 | 19 |
535059 | 535059 | 2020-09-15 | Jackson | Illinois | 17077 | 1169 | 24 |
535060 | 535060 | 2020-09-15 | Jasper | Illinois | 17079 | 184 | 8 |
535061 | 535061 | 2020-09-15 | Jefferson | Illinois | 17081 | 521 | 37 |
535062 | 535062 | 2020-09-15 | Jersey | Illinois | 17083 | 361 | 13 |
535063 | 535063 | 2020-09-15 | Jo Daviess | Illinois | 17085 | 217 | 2 |
535064 | 535064 | 2020-09-15 | Johnson | Illinois | 17087 | 130 | 0 |
535065 | 535065 | 2020-09-15 | Kane | Illinois | 17089 | 12254 | 326 |
535066 | 535066 | 2020-09-15 | Kankakee | Illinois | 17091 | 2588 | 73 |
535067 | 535067 | 2020-09-15 | Kendall | Illinois | 17093 | 1881 | 26 |
535068 | 535068 | 2020-09-15 | Knox | Illinois | 17095 | 538 | 3 |
535069 | 535069 | 2020-09-15 | LaSalle | Illinois | 17099 | 1518 | 54 |
535070 | 535070 | 2020-09-15 | Lake | Illinois | 17097 | 15906 | 481 |
535071 | 535071 | 2020-09-15 | Lawrence | Illinois | 17101 | 235 | 0 |
535072 | 535072 | 2020-09-15 | Lee | Illinois | 17103 | 306 | 1 |
535073 | 535073 | 2020-09-15 | Livingston | Illinois | 17105 | 272 | 4 |
535074 | 535074 | 2020-09-15 | Logan | Illinois | 17107 | 400 | 1 |
535075 | 535075 | 2020-09-15 | Macon | Illinois | 17115 | 1247 | 33 |
535076 | 535076 | 2020-09-15 | Macoupin | Illinois | 17117 | 440 | 6 |
535077 | 535077 | 2020-09-15 | Madison | Illinois | 17119 | 5020 | 122 |
535078 | 535078 | 2020-09-15 | Marion | Illinois | 17121 | 441 | 0 |
535079 | 535079 | 2020-09-15 | Marshall | Illinois | 17123 | 76 | 0 |
535080 | 535080 | 2020-09-15 | Mason | Illinois | 17125 | 111 | 1 |
535081 | 535081 | 2020-09-15 | Massac | Illinois | 17127 | 86 | 1 |
535082 | 535082 | 2020-09-15 | McDonough | Illinois | 17109 | 417 | 15 |
535083 | 535083 | 2020-09-15 | McHenry | Illinois | 17111 | 4339 | 119 |
535084 | 535084 | 2020-09-15 | McLean | Illinois | 17113 | 2980 | 18 |
535085 | 535085 | 2020-09-15 | Menard | Illinois | 17129 | 103 | 0 |
535086 | 535086 | 2020-09-15 | Mercer | Illinois | 17131 | 118 | 5 |
535087 | 535087 | 2020-09-15 | Monroe | Illinois | 17133 | 585 | 15 |
535088 | 535088 | 2020-09-15 | Montgomery | Illinois | 17135 | 287 | 11 |
535089 | 535089 | 2020-09-15 | Morgan | Illinois | 17137 | 619 | 21 |
535090 | 535090 | 2020-09-15 | Moultrie | Illinois | 17139 | 200 | 3 |
535091 | 535091 | 2020-09-15 | Ogle | Illinois | 17141 | 595 | 6 |
535092 | 535092 | 2020-09-15 | Peoria | Illinois | 17143 | 2983 | 47 |
535093 | 535093 | 2020-09-15 | Perry | Illinois | 17145 | 323 | 13 |
535094 | 535094 | 2020-09-15 | Piatt | Illinois | 17147 | 123 | 0 |
535095 | 535095 | 2020-09-15 | Pike | Illinois | 17149 | 101 | 1 |
535096 | 535096 | 2020-09-15 | Pope | Illinois | 17151 | 24 | 1 |
535097 | 535097 | 2020-09-15 | Pulaski | Illinois | 17153 | 149 | 1 |
535098 | 535098 | 2020-09-15 | Putnam | Illinois | 17155 | 33 | 0 |
535099 | 535099 | 2020-09-15 | Randolph | Illinois | 17157 | 880 | 10 |
535100 | 535100 | 2020-09-15 | Richland | Illinois | 17159 | 120 | 4 |
535101 | 535101 | 2020-09-15 | Rock Island | Illinois | 17161 | 2705 | 74 |
535102 | 535102 | 2020-09-15 | Saline | Illinois | 17165 | 217 | 3 |
535103 | 535103 | 2020-09-15 | Sangamon | Illinois | 17167 | 2149 | 44 |
535104 | 535104 | 2020-09-15 | Schuyler | Illinois | 17169 | 36 | 0 |
535105 | 535105 | 2020-09-15 | Scott | Illinois | 17171 | 62 | 0 |
535106 | 535106 | 2020-09-15 | Shelby | Illinois | 17173 | 319 | 3 |
535107 | 535107 | 2020-09-15 | St. Clair | Illinois | 17163 | 6750 | 181 |
535108 | 535108 | 2020-09-15 | Stark | Illinois | 17175 | 46 | 2 |
535109 | 535109 | 2020-09-15 | Stephenson | Illinois | 17177 | 434 | 6 |
535110 | 535110 | 2020-09-15 | Tazewell | Illinois | 17179 | 1442 | 16 |
535111 | 535111 | 2020-09-15 | Union | Illinois | 17181 | 476 | 24 |
535112 | 535112 | 2020-09-15 | Unknown | Illinois | 2027 | 230 | |
535113 | 535113 | 2020-09-15 | Vermilion | Illinois | 17183 | 498 | 4 |
535114 | 535114 | 2020-09-15 | Wabash | Illinois | 17185 | 134 | 1 |
535115 | 535115 | 2020-09-15 | Warren | Illinois | 17187 | 288 | 1 |
535116 | 535116 | 2020-09-15 | Washington | Illinois | 17189 | 160 | 1 |
535117 | 535117 | 2020-09-15 | Wayne | Illinois | 17191 | 224 | 4 |
535118 | 535118 | 2020-09-15 | White | Illinois | 17193 | 150 | 0 |
535119 | 535119 | 2020-09-15 | Whiteside | Illinois | 17195 | 650 | 20 |
535120 | 535120 | 2020-09-15 | Will | Illinois | 17197 | 12984 | 369 |
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);