ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

35,006 rows where state = "Illinois" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Illinois · 35,006 ✖
Link rowid date ▲ county state fips cases deaths
1096299 1096299 2021-03-07 Adams Illinois 17001 8046 143
1096300 1096300 2021-03-07 Alexander Illinois 17003 453 9
1096301 1096301 2021-03-07 Bond Illinois 17005 1918 30
1096302 1096302 2021-03-07 Boone Illinois 17007 5945 82
1096303 1096303 2021-03-07 Brown Illinois 17009 666 12
1096304 1096304 2021-03-07 Bureau Illinois 17011 3335 90
1096305 1096305 2021-03-07 Calhoun Illinois 17013 482 5
1096306 1096306 2021-03-07 Carroll Illinois 17015 1582 36
1096307 1096307 2021-03-07 Cass Illinois 17017 1898 31
1096308 1096308 2021-03-07 Champaign Illinois 17019 18404 136
1096309 1096309 2021-03-07 Christian Illinois 17021 3336 87
1096310 1096310 2021-03-07 Clark Illinois 17023 1688 39
1096311 1096311 2021-03-07 Clay Illinois 17025 1436 47
1096312 1096312 2021-03-07 Clinton Illinois 17027 5583 98
1096313 1096313 2021-03-07 Coles Illinois 17029 5251 94
1096314 1096314 2021-03-07 Cook Illinois 17031 478884 10008
1096315 1096315 2021-03-07 Crawford Illinois 17033 2013 40
1096316 1096316 2021-03-07 Cumberland Illinois 17035 1204 30
1096317 1096317 2021-03-07 De Witt Illinois 17039 1284 29
1096318 1096318 2021-03-07 DeKalb Illinois 17037 8520 120
1096319 1096319 2021-03-07 Douglas Illinois 17041 2477 39
1096320 1096320 2021-03-07 DuPage Illinois 17043 77882 1290
1096321 1096321 2021-03-07 Edgar Illinois 17045 1556 58
1096322 1096322 2021-03-07 Edwards Illinois 17047 528 11
1096323 1096323 2021-03-07 Effingham Illinois 17049 4508 80
1096324 1096324 2021-03-07 Fayette Illinois 17051 3071 55
1096325 1096325 2021-03-07 Ford Illinois 17053 1604 54
1096326 1096326 2021-03-07 Franklin Illinois 17055 4167 78
1096327 1096327 2021-03-07 Fulton Illinois 17057 2903 54
1096328 1096328 2021-03-07 Gallatin Illinois 17059 438 5
1096329 1096329 2021-03-07 Greene Illinois 17061 1387 45
1096330 1096330 2021-03-07 Grundy Illinois 17063 5209 67
1096331 1096331 2021-03-07 Hamilton Illinois 17065 796 18
1096332 1096332 2021-03-07 Hancock Illinois 17067 1685 40
1096333 1096333 2021-03-07 Hardin Illinois 17069 348 12
1096334 1096334 2021-03-07 Henderson Illinois 17071 504 23
1096335 1096335 2021-03-07 Henry Illinois 17073 4360 87
1096336 1096336 2021-03-07 Iroquois Illinois 17075 2789 64
1096337 1096337 2021-03-07 Jackson Illinois 17077 4623 71
1096338 1096338 2021-03-07 Jasper Illinois 17079 1113 19
1096339 1096339 2021-03-07 Jefferson Illinois 17081 3998 118
1096340 1096340 2021-03-07 Jersey Illinois 17083 2499 66
1096341 1096341 2021-03-07 Jo Daviess Illinois 17085 1616 25
1096342 1096342 2021-03-07 Johnson Illinois 17087 1355 18
1096343 1096343 2021-03-07 Kane Illinois 17089 51237 775
1096344 1096344 2021-03-07 Kankakee Illinois 17091 12605 198
1096345 1096345 2021-03-07 Kendall Illinois 17093 11509 96
1096346 1096346 2021-03-07 Knox Illinois 17095 5026 164
1096347 1096347 2021-03-07 LaSalle Illinois 17099 10924 277
1096348 1096348 2021-03-07 Lake Illinois 17097 60155 1005
1096349 1096349 2021-03-07 Lawrence Illinois 17101 2319 33
1096350 1096350 2021-03-07 Lee Illinois 17103 3383 82
1096351 1096351 2021-03-07 Livingston Illinois 17105 4269 91
1096352 1096352 2021-03-07 Logan Illinois 17107 3315 67
1096353 1096353 2021-03-07 Macon Illinois 17115 9531 196
1096354 1096354 2021-03-07 Macoupin Illinois 17117 4385 109
1096355 1096355 2021-03-07 Madison Illinois 17119 28259 539
1096356 1096356 2021-03-07 Marion Illinois 17121 4280 119
1096357 1096357 2021-03-07 Marshall Illinois 17123 851 17
1096358 1096358 2021-03-07 Mason Illinois 17125 1290 42
1096359 1096359 2021-03-07 Massac Illinois 17127 1285 38
1096360 1096360 2021-03-07 McDonough Illinois 17109 2340 52
1096361 1096361 2021-03-07 McHenry Illinois 17111 24669 292
1096362 1096362 2021-03-07 McLean Illinois 17113 14738 196
1096363 1096363 2021-03-07 Menard Illinois 17129 1044 12
1096364 1096364 2021-03-07 Mercer Illinois 17131 1289 33
1096365 1096365 2021-03-07 Monroe Illinois 17133 4092 87
1096366 1096366 2021-03-07 Montgomery Illinois 17135 3543 76
1096367 1096367 2021-03-07 Morgan Illinois 17137 3684 99
1096368 1096368 2021-03-07 Moultrie Illinois 17139 1503 32
1096369 1096369 2021-03-07 Ogle Illinois 17141 5075 83
1096370 1096370 2021-03-07 Peoria Illinois 17143 17144 285
1096371 1096371 2021-03-07 Perry Illinois 17145 3074 66
1096372 1096372 2021-03-07 Piatt Illinois 17147 1343 20
1096373 1096373 2021-03-07 Pike Illinois 17149 1701 53
1096374 1096374 2021-03-07 Pope Illinois 17151 284 3
1096375 1096375 2021-03-07 Pulaski Illinois 17153 671 6
1096376 1096376 2021-03-07 Putnam Illinois 17155 422 4
1096377 1096377 2021-03-07 Randolph Illinois 17157 3985 86
1096378 1096378 2021-03-07 Richland Illinois 17159 1637 47
1096379 1096379 2021-03-07 Rock Island Illinois 17161 13203 330
1096380 1096380 2021-03-07 Saline Illinois 17165 2339 64
1096381 1096381 2021-03-07 Sangamon Illinois 17167 16285 264
1096382 1096382 2021-03-07 Schuyler Illinois 17169 682 17
1096383 1096383 2021-03-07 Scott Illinois 17171 449 1
1096384 1096384 2021-03-07 Shelby Illinois 17173 2163 37
1096385 1096385 2021-03-07 St. Clair Illinois 17163 28389 515
1096386 1096386 2021-03-07 Stark Illinois 17175 543 23
1096387 1096387 2021-03-07 Stephenson Illinois 17177 4122 95
1096388 1096388 2021-03-07 Tazewell Illinois 17179 13677 275
1096389 1096389 2021-03-07 Union Illinois 17181 2207 42
1096390 1096390 2021-03-07 Unknown Illinois   0 237
1096391 1096391 2021-03-07 Vermilion Illinois 17183 8646 136
1096392 1096392 2021-03-07 Wabash Illinois 17185 1305 15
1096393 1096393 2021-03-07 Warren Illinois 17187 1666 47
1096394 1096394 2021-03-07 Washington Illinois 17189 1588 30
1096395 1096395 2021-03-07 Wayne Illinois 17191 1692 50
1096396 1096396 2021-03-07 White Illinois 17193 1614 35
1096397 1096397 2021-03-07 Whiteside Illinois 17195 6022 192
1096398 1096398 2021-03-07 Will Illinois 17197 65885 986

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);