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-04 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
300290 | 300290 | 2020-07-04 | Adams | Illinois | 17001 | 113 | 1 |
300291 | 300291 | 2020-07-04 | Alexander | Illinois | 17003 | 22 | 0 |
300292 | 300292 | 2020-07-04 | Bond | Illinois | 17005 | 16 | 1 |
300293 | 300293 | 2020-07-04 | Boone | Illinois | 17007 | 608 | 21 |
300294 | 300294 | 2020-07-04 | Brown | Illinois | 17009 | 10 | 0 |
300295 | 300295 | 2020-07-04 | Bureau | Illinois | 17011 | 30 | 2 |
300296 | 300296 | 2020-07-04 | Calhoun | Illinois | 17013 | 1 | 0 |
300297 | 300297 | 2020-07-04 | Carroll | Illinois | 17015 | 22 | 2 |
300298 | 300298 | 2020-07-04 | Cass | Illinois | 17017 | 136 | 7 |
300299 | 300299 | 2020-07-04 | Champaign | Illinois | 17019 | 939 | 13 |
300300 | 300300 | 2020-07-04 | Christian | Illinois | 17021 | 45 | 5 |
300301 | 300301 | 2020-07-04 | Clark | Illinois | 17023 | 15 | 0 |
300302 | 300302 | 2020-07-04 | Clay | Illinois | 17025 | 2 | 0 |
300303 | 300303 | 2020-07-04 | Clinton | Illinois | 17027 | 241 | 17 |
300304 | 300304 | 2020-07-04 | Coles | Illinois | 17029 | 172 | 17 |
300305 | 300305 | 2020-07-04 | Cook | Illinois | 17031 | 92240 | 4622 |
300306 | 300306 | 2020-07-04 | Crawford | Illinois | 17033 | 18 | 0 |
300307 | 300307 | 2020-07-04 | Cumberland | Illinois | 17035 | 16 | 0 |
300308 | 300308 | 2020-07-04 | De Witt | Illinois | 17039 | 11 | 0 |
300309 | 300309 | 2020-07-04 | DeKalb | Illinois | 17037 | 593 | 19 |
300310 | 300310 | 2020-07-04 | Douglas | Illinois | 17041 | 54 | 0 |
300311 | 300311 | 2020-07-04 | DuPage | Illinois | 17043 | 9276 | 475 |
300312 | 300312 | 2020-07-04 | Edgar | Illinois | 17045 | 10 | 0 |
300313 | 300313 | 2020-07-04 | Edwards | Illinois | 17047 | 2 | 0 |
300314 | 300314 | 2020-07-04 | Effingham | Illinois | 17049 | 17 | 1 |
300315 | 300315 | 2020-07-04 | Fayette | Illinois | 17051 | 23 | 3 |
300316 | 300316 | 2020-07-04 | Ford | Illinois | 17053 | 37 | 1 |
300317 | 300317 | 2020-07-04 | Franklin | Illinois | 17055 | 28 | 0 |
300318 | 300318 | 2020-07-04 | Fulton | Illinois | 17057 | 15 | 0 |
300319 | 300319 | 2020-07-04 | Gallatin | Illinois | 17059 | 2 | 0 |
300320 | 300320 | 2020-07-04 | Greene | Illinois | 17061 | 9 | 0 |
300321 | 300321 | 2020-07-04 | Grundy | Illinois | 17063 | 171 | 5 |
300322 | 300322 | 2020-07-04 | Hamilton | Illinois | 17065 | 5 | 0 |
300323 | 300323 | 2020-07-04 | Hancock | Illinois | 17067 | 19 | 1 |
300324 | 300324 | 2020-07-04 | Hardin | Illinois | 17069 | 1 | 0 |
300325 | 300325 | 2020-07-04 | Henderson | Illinois | 17071 | 8 | 0 |
300326 | 300326 | 2020-07-04 | Henry | Illinois | 17073 | 95 | 1 |
300327 | 300327 | 2020-07-04 | Iroquois | Illinois | 17075 | 161 | 5 |
300328 | 300328 | 2020-07-04 | Jackson | Illinois | 17077 | 336 | 19 |
300329 | 300329 | 2020-07-04 | Jasper | Illinois | 17079 | 47 | 7 |
300330 | 300330 | 2020-07-04 | Jefferson | Illinois | 17081 | 106 | 17 |
300331 | 300331 | 2020-07-04 | Jersey | Illinois | 17083 | 35 | 1 |
300332 | 300332 | 2020-07-04 | Jo Daviess | Illinois | 17085 | 45 | 1 |
300333 | 300333 | 2020-07-04 | Johnson | Illinois | 17087 | 21 | 0 |
300334 | 300334 | 2020-07-04 | Kane | Illinois | 17089 | 7890 | 277 |
300335 | 300335 | 2020-07-04 | Kankakee | Illinois | 17091 | 1373 | 65 |
300336 | 300336 | 2020-07-04 | Kendall | Illinois | 17093 | 1029 | 23 |
300337 | 300337 | 2020-07-04 | Knox | Illinois | 17095 | 137 | 0 |
300338 | 300338 | 2020-07-04 | LaSalle | Illinois | 17099 | 225 | 17 |
300339 | 300339 | 2020-07-04 | Lake | Illinois | 17097 | 9919 | 423 |
300340 | 300340 | 2020-07-04 | Lawrence | Illinois | 17101 | 7 | 0 |
300341 | 300341 | 2020-07-04 | Lee | Illinois | 17103 | 101 | 2 |
300342 | 300342 | 2020-07-04 | Livingston | Illinois | 17105 | 52 | 2 |
300343 | 300343 | 2020-07-04 | Logan | Illinois | 17107 | 17 | 0 |
300344 | 300344 | 2020-07-04 | Macon | Illinois | 17115 | 234 | 22 |
300345 | 300345 | 2020-07-04 | Macoupin | Illinois | 17117 | 55 | 3 |
300346 | 300346 | 2020-07-04 | Madison | Illinois | 17119 | 1007 | 69 |
300347 | 300347 | 2020-07-04 | Marion | Illinois | 17121 | 69 | 0 |
300348 | 300348 | 2020-07-04 | Marshall | Illinois | 17123 | 10 | 0 |
300349 | 300349 | 2020-07-04 | Mason | Illinois | 17125 | 22 | 0 |
300350 | 300350 | 2020-07-04 | Massac | Illinois | 17127 | 15 | 0 |
300351 | 300351 | 2020-07-04 | McDonough | Illinois | 17109 | 102 | 15 |
300352 | 300352 | 2020-07-04 | McHenry | Illinois | 17111 | 2103 | 97 |
300353 | 300353 | 2020-07-04 | McLean | Illinois | 17113 | 273 | 13 |
300354 | 300354 | 2020-07-04 | Menard | Illinois | 17129 | 24 | 0 |
300355 | 300355 | 2020-07-04 | Mercer | Illinois | 17131 | 23 | 0 |
300356 | 300356 | 2020-07-04 | Monroe | Illinois | 17133 | 129 | 13 |
300357 | 300357 | 2020-07-04 | Montgomery | Illinois | 17135 | 48 | 0 |
300358 | 300358 | 2020-07-04 | Morgan | Illinois | 17137 | 130 | 3 |
300359 | 300359 | 2020-07-04 | Moultrie | Illinois | 17139 | 19 | 0 |
300360 | 300360 | 2020-07-04 | Ogle | Illinois | 17141 | 277 | 4 |
300361 | 300361 | 2020-07-04 | Peoria | Illinois | 17143 | 551 | 28 |
300362 | 300362 | 2020-07-04 | Perry | Illinois | 17145 | 56 | 1 |
300363 | 300363 | 2020-07-04 | Piatt | Illinois | 17147 | 20 | 0 |
300364 | 300364 | 2020-07-04 | Pike | Illinois | 17149 | 3 | 0 |
300365 | 300365 | 2020-07-04 | Pope | Illinois | 17151 | 1 | 0 |
300366 | 300366 | 2020-07-04 | Pulaski | Illinois | 17153 | 76 | 0 |
300367 | 300367 | 2020-07-04 | Putnam | Illinois | 17155 | 1 | 0 |
300368 | 300368 | 2020-07-04 | Randolph | Illinois | 17157 | 288 | 7 |
300369 | 300369 | 2020-07-04 | Richland | Illinois | 17159 | 4 | 0 |
300370 | 300370 | 2020-07-04 | Rock Island | Illinois | 17161 | 1043 | 29 |
300371 | 300371 | 2020-07-04 | Saline | Illinois | 17165 | 9 | 0 |
300372 | 300372 | 2020-07-04 | Sangamon | Illinois | 17167 | 446 | 34 |
300373 | 300373 | 2020-07-04 | Schuyler | Illinois | 17169 | 13 | 0 |
300374 | 300374 | 2020-07-04 | Scott | Illinois | 17171 | 1 | 0 |
300375 | 300375 | 2020-07-04 | Shelby | Illinois | 17173 | 19 | 1 |
300376 | 300376 | 2020-07-04 | St. Clair | Illinois | 17163 | 2208 | 140 |
300377 | 300377 | 2020-07-04 | Stark | Illinois | 17175 | 4 | 0 |
300378 | 300378 | 2020-07-04 | Stephenson | Illinois | 17177 | 276 | 5 |
300379 | 300379 | 2020-07-04 | Tazewell | Illinois | 17179 | 149 | 8 |
300380 | 300380 | 2020-07-04 | Union | Illinois | 17181 | 194 | 19 |
300381 | 300381 | 2020-07-04 | Unknown | Illinois | 1122 | 210 | |
300382 | 300382 | 2020-07-04 | Vermilion | Illinois | 17183 | 77 | 2 |
300383 | 300383 | 2020-07-04 | Wabash | Illinois | 17185 | 22 | 0 |
300384 | 300384 | 2020-07-04 | Warren | Illinois | 17187 | 143 | 0 |
300385 | 300385 | 2020-07-04 | Washington | Illinois | 17189 | 21 | 0 |
300386 | 300386 | 2020-07-04 | Wayne | Illinois | 17191 | 14 | 1 |
300387 | 300387 | 2020-07-04 | White | Illinois | 17193 | 6 | 0 |
300388 | 300388 | 2020-07-04 | Whiteside | Illinois | 17195 | 193 | 15 |
300389 | 300389 | 2020-07-04 | Will | Illinois | 17197 | 6883 | 320 |
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);