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-07-15 and state = "Illinois" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
335230 | 335230 | 2020-07-15 | Adams | Illinois | 17001 | 208 | 1 |
335231 | 335231 | 2020-07-15 | Alexander | Illinois | 17003 | 26 | 0 |
335232 | 335232 | 2020-07-15 | Bond | Illinois | 17005 | 21 | 1 |
335233 | 335233 | 2020-07-15 | Boone | Illinois | 17007 | 641 | 21 |
335234 | 335234 | 2020-07-15 | Brown | Illinois | 17009 | 10 | 0 |
335235 | 335235 | 2020-07-15 | Bureau | Illinois | 17011 | 44 | 2 |
335236 | 335236 | 2020-07-15 | Calhoun | Illinois | 17013 | 2 | 0 |
335237 | 335237 | 2020-07-15 | Carroll | Illinois | 17015 | 21 | 2 |
335238 | 335238 | 2020-07-15 | Cass | Illinois | 17017 | 140 | 10 |
335239 | 335239 | 2020-07-15 | Champaign | Illinois | 17019 | 1089 | 17 |
335240 | 335240 | 2020-07-15 | Christian | Illinois | 17021 | 53 | 5 |
335241 | 335241 | 2020-07-15 | Clark | Illinois | 17023 | 45 | 0 |
335242 | 335242 | 2020-07-15 | Clay | Illinois | 17025 | 8 | 0 |
335243 | 335243 | 2020-07-15 | Clinton | Illinois | 17027 | 256 | 17 |
335244 | 335244 | 2020-07-15 | Coles | Illinois | 17029 | 209 | 17 |
335245 | 335245 | 2020-07-15 | Cook | Illinois | 17031 | 96662 | 4745 |
335246 | 335246 | 2020-07-15 | Crawford | Illinois | 17033 | 20 | 0 |
335247 | 335247 | 2020-07-15 | Cumberland | Illinois | 17035 | 31 | 0 |
335248 | 335248 | 2020-07-15 | De Witt | Illinois | 17039 | 18 | 0 |
335249 | 335249 | 2020-07-15 | DeKalb | Illinois | 17037 | 702 | 22 |
335250 | 335250 | 2020-07-15 | Douglas | Illinois | 17041 | 62 | 0 |
335251 | 335251 | 2020-07-15 | DuPage | Illinois | 17043 | 9867 | 492 |
335252 | 335252 | 2020-07-15 | Edgar | Illinois | 17045 | 20 | 0 |
335253 | 335253 | 2020-07-15 | Edwards | Illinois | 17047 | 5 | 0 |
335254 | 335254 | 2020-07-15 | Effingham | Illinois | 17049 | 35 | 1 |
335255 | 335255 | 2020-07-15 | Fayette | Illinois | 17051 | 28 | 3 |
335256 | 335256 | 2020-07-15 | Ford | Illinois | 17053 | 42 | 1 |
335257 | 335257 | 2020-07-15 | Franklin | Illinois | 17055 | 54 | 0 |
335258 | 335258 | 2020-07-15 | Fulton | Illinois | 17057 | 18 | 0 |
335259 | 335259 | 2020-07-15 | Gallatin | Illinois | 17059 | 8 | 0 |
335260 | 335260 | 2020-07-15 | Greene | Illinois | 17061 | 12 | 0 |
335261 | 335261 | 2020-07-15 | Grundy | Illinois | 17063 | 202 | 5 |
335262 | 335262 | 2020-07-15 | Hamilton | Illinois | 17065 | 7 | 0 |
335263 | 335263 | 2020-07-15 | Hancock | Illinois | 17067 | 21 | 1 |
335264 | 335264 | 2020-07-15 | Hardin | Illinois | 17069 | 2 | 0 |
335265 | 335265 | 2020-07-15 | Henderson | Illinois | 17071 | 8 | 0 |
335266 | 335266 | 2020-07-15 | Henry | Illinois | 17073 | 125 | 1 |
335267 | 335267 | 2020-07-15 | Iroquois | Illinois | 17075 | 179 | 5 |
335268 | 335268 | 2020-07-15 | Jackson | Illinois | 17077 | 366 | 19 |
335269 | 335269 | 2020-07-15 | Jasper | Illinois | 17079 | 47 | 7 |
335270 | 335270 | 2020-07-15 | Jefferson | Illinois | 17081 | 123 | 17 |
335271 | 335271 | 2020-07-15 | Jersey | Illinois | 17083 | 48 | 1 |
335272 | 335272 | 2020-07-15 | Jo Daviess | Illinois | 17085 | 57 | 1 |
335273 | 335273 | 2020-07-15 | Johnson | Illinois | 17087 | 29 | 0 |
335274 | 335274 | 2020-07-15 | Kane | Illinois | 17089 | 8274 | 286 |
335275 | 335275 | 2020-07-15 | Kankakee | Illinois | 17091 | 1523 | 66 |
335276 | 335276 | 2020-07-15 | Kendall | Illinois | 17093 | 1141 | 23 |
335277 | 335277 | 2020-07-15 | Knox | Illinois | 17095 | 176 | 0 |
335278 | 335278 | 2020-07-15 | LaSalle | Illinois | 17099 | 286 | 17 |
335279 | 335279 | 2020-07-15 | Lake | Illinois | 17097 | 10576 | 429 |
335280 | 335280 | 2020-07-15 | Lawrence | Illinois | 17101 | 13 | 0 |
335281 | 335281 | 2020-07-15 | Lee | Illinois | 17103 | 110 | 2 |
335282 | 335282 | 2020-07-15 | Livingston | Illinois | 17105 | 58 | 2 |
335283 | 335283 | 2020-07-15 | Logan | Illinois | 17107 | 27 | 0 |
335284 | 335284 | 2020-07-15 | Macon | Illinois | 17115 | 259 | 22 |
335285 | 335285 | 2020-07-15 | Macoupin | Illinois | 17117 | 75 | 3 |
335286 | 335286 | 2020-07-15 | Madison | Illinois | 17119 | 1318 | 71 |
335287 | 335287 | 2020-07-15 | Marion | Illinois | 17121 | 81 | 0 |
335288 | 335288 | 2020-07-15 | Marshall | Illinois | 17123 | 13 | 0 |
335289 | 335289 | 2020-07-15 | Mason | Illinois | 17125 | 29 | 0 |
335290 | 335290 | 2020-07-15 | Massac | Illinois | 17127 | 17 | 0 |
335291 | 335291 | 2020-07-15 | McDonough | Illinois | 17109 | 110 | 15 |
335292 | 335292 | 2020-07-15 | McHenry | Illinois | 17111 | 2418 | 105 |
335293 | 335293 | 2020-07-15 | McLean | Illinois | 17113 | 340 | 15 |
335294 | 335294 | 2020-07-15 | Menard | Illinois | 17129 | 33 | 0 |
335295 | 335295 | 2020-07-15 | Mercer | Illinois | 17131 | 29 | 0 |
335296 | 335296 | 2020-07-15 | Monroe | Illinois | 17133 | 171 | 13 |
335297 | 335297 | 2020-07-15 | Montgomery | Illinois | 17135 | 90 | 1 |
335298 | 335298 | 2020-07-15 | Morgan | Illinois | 17137 | 135 | 4 |
335299 | 335299 | 2020-07-15 | Moultrie | Illinois | 17139 | 28 | 0 |
335300 | 335300 | 2020-07-15 | Ogle | Illinois | 17141 | 338 | 5 |
335301 | 335301 | 2020-07-15 | Peoria | Illinois | 17143 | 736 | 30 |
335302 | 335302 | 2020-07-15 | Perry | Illinois | 17145 | 63 | 1 |
335303 | 335303 | 2020-07-15 | Piatt | Illinois | 17147 | 21 | 0 |
335304 | 335304 | 2020-07-15 | Pike | Illinois | 17149 | 8 | 0 |
335305 | 335305 | 2020-07-15 | Pope | Illinois | 17151 | 2 | 0 |
335306 | 335306 | 2020-07-15 | Pulaski | Illinois | 17153 | 86 | 0 |
335307 | 335307 | 2020-07-15 | Putnam | Illinois | 17155 | 1 | 0 |
335308 | 335308 | 2020-07-15 | Randolph | Illinois | 17157 | 337 | 7 |
335309 | 335309 | 2020-07-15 | Richland | Illinois | 17159 | 10 | 0 |
335310 | 335310 | 2020-07-15 | Rock Island | Illinois | 17161 | 1265 | 30 |
335311 | 335311 | 2020-07-15 | Saline | Illinois | 17165 | 20 | 0 |
335312 | 335312 | 2020-07-15 | Sangamon | Illinois | 17167 | 593 | 34 |
335313 | 335313 | 2020-07-15 | Schuyler | Illinois | 17169 | 14 | 0 |
335314 | 335314 | 2020-07-15 | Scott | Illinois | 17171 | 1 | 0 |
335315 | 335315 | 2020-07-15 | Shelby | Illinois | 17173 | 23 | 1 |
335316 | 335316 | 2020-07-15 | St. Clair | Illinois | 17163 | 2732 | 147 |
335317 | 335317 | 2020-07-15 | Stark | Illinois | 17175 | 6 | 0 |
335318 | 335318 | 2020-07-15 | Stephenson | Illinois | 17177 | 287 | 6 |
335319 | 335319 | 2020-07-15 | Tazewell | Illinois | 17179 | 196 | 8 |
335320 | 335320 | 2020-07-15 | Union | Illinois | 17181 | 215 | 19 |
335321 | 335321 | 2020-07-15 | Unknown | Illinois | 1132 | 201 | |
335322 | 335322 | 2020-07-15 | Vermilion | Illinois | 17183 | 96 | 2 |
335323 | 335323 | 2020-07-15 | Wabash | Illinois | 17185 | 23 | 0 |
335324 | 335324 | 2020-07-15 | Warren | Illinois | 17187 | 150 | 0 |
335325 | 335325 | 2020-07-15 | Washington | Illinois | 17189 | 28 | 0 |
335326 | 335326 | 2020-07-15 | Wayne | Illinois | 17191 | 19 | 1 |
335327 | 335327 | 2020-07-15 | White | Illinois | 17193 | 17 | 0 |
335328 | 335328 | 2020-07-15 | Whiteside | Illinois | 17195 | 224 | 15 |
335329 | 335329 | 2020-07-15 | Will | Illinois | 17197 | 7449 | 328 |
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);