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

57,872 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 · 57,872 ✖
Link rowid date ▲ county state fips cases deaths
1817216 1817216 2021-10-15 Adams Illinois 17001 13072 181
1817217 1817217 2021-10-15 Alexander Illinois 17003 713 12
1817218 1817218 2021-10-15 Bond Illinois 17005 2550 30
1817219 1817219 2021-10-15 Boone Illinois 17007 7875 95
1817220 1817220 2021-10-15 Brown Illinois 17009 1058 15
1817221 1817221 2021-10-15 Bureau Illinois 17011 4411 102
1817222 1817222 2021-10-15 Calhoun Illinois 17013 686 5
1817223 1817223 2021-10-15 Carroll Illinois 17015 2356 39
1817224 1817224 2021-10-15 Cass Illinois 17017 2647 39
1817225 1817225 2021-10-15 Champaign Illinois 17019 26859 204
1817226 1817226 2021-10-15 Christian Illinois 17021 5303 100
1817227 1817227 2021-10-15 Clark Illinois 17023 2649 47
1817228 1817228 2021-10-15 Clay Illinois 17025 2573 59
1817229 1817229 2021-10-15 Clinton Illinois 17027 7095 111
1817230 1817230 2021-10-15 Coles Illinois 17029 7843 123
1817231 1817231 2021-10-15 Cook Illinois 17031 631261 11723
1817232 1817232 2021-10-15 Crawford Illinois 17033 3308 46
1817233 1817233 2021-10-15 Cumberland Illinois 17035 1885 38
1817234 1817234 2021-10-15 De Witt Illinois 17039 2042 37
1817235 1817235 2021-10-15 DeKalb Illinois 17037 12370 138
1817236 1817236 2021-10-15 Douglas Illinois 17041 3247 43
1817237 1817237 2021-10-15 DuPage Illinois 17043 107465 1459
1817238 1817238 2021-10-15 Edgar Illinois 17045 2552 69
1817239 1817239 2021-10-15 Edwards Illinois 17047 1025 19
1817240 1817240 2021-10-15 Effingham Illinois 17049 6554 110
1817241 1817241 2021-10-15 Fayette Illinois 17051 4289 67
1817242 1817242 2021-10-15 Ford Illinois 17053 2422 67
1817243 1817243 2021-10-15 Franklin Illinois 17055 7276 126
1817244 1817244 2021-10-15 Fulton Illinois 17057 5216 82
1817245 1817245 2021-10-15 Gallatin Illinois 17059 784 9
1817246 1817246 2021-10-15 Greene Illinois 17061 2045 53
1817247 1817247 2021-10-15 Grundy Illinois 17063 7317 90
1817248 1817248 2021-10-15 Hamilton Illinois 17065 1333 25
1817249 1817249 2021-10-15 Hancock Illinois 17067 2719 45
1817250 1817250 2021-10-15 Hardin Illinois 17069 594 16
1817251 1817251 2021-10-15 Henderson Illinois 17071 696 23
1817252 1817252 2021-10-15 Henry Illinois 17073 6598 105
1817253 1817253 2021-10-15 Iroquois Illinois 17075 4181 79
1817254 1817254 2021-10-15 Jackson Illinois 17077 8065 105
1817255 1817255 2021-10-15 Jasper Illinois 17079 1605 23
1817256 1817256 2021-10-15 Jefferson Illinois 17081 6492 143
1817257 1817257 2021-10-15 Jersey Illinois 17083 3342 72
1817258 1817258 2021-10-15 Jo Daviess Illinois 17085 2145 32
1817259 1817259 2021-10-15 Johnson Illinois 17087 2238 37
1817260 1817260 2021-10-15 Kane Illinois 17089 68004 918
1817261 1817261 2021-10-15 Kankakee Illinois 17091 17795 255
1817262 1817262 2021-10-15 Kendall Illinois 17093 16957 122
1817263 1817263 2021-10-15 Knox Illinois 17095 7197 200
1817264 1817264 2021-10-15 LaSalle Illinois 17099 14954 340
1817265 1817265 2021-10-15 Lake Illinois 17097 79526 1147
1817266 1817266 2021-10-15 Lawrence Illinois 17101 3299 41
1817267 1817267 2021-10-15 Lee Illinois 17103 4769 99
1817268 1817268 2021-10-15 Livingston Illinois 17105 5946 109
1817269 1817269 2021-10-15 Logan Illinois 17107 4925 87
1817270 1817270 2021-10-15 Macon Illinois 17115 15222 260
1817271 1817271 2021-10-15 Macoupin Illinois 17117 6893 133
1817272 1817272 2021-10-15 Madison Illinois 17119 39883 663
1817273 1817273 2021-10-15 Marion Illinois 17121 6871 149
1817274 1817274 2021-10-15 Marshall Illinois 17123 1409 23
1817275 1817275 2021-10-15 Mason Illinois 17125 2116 53
1817276 1817276 2021-10-15 Massac Illinois 17127 2137 51
1817277 1817277 2021-10-15 McDonough Illinois 17109 3723 72
1817278 1817278 2021-10-15 McHenry Illinois 17111 34415 348
1817279 1817279 2021-10-15 McLean Illinois 17113 22871 252
1817280 1817280 2021-10-15 Menard Illinois 17129 1710 17
1817281 1817281 2021-10-15 Mercer Illinois 17131 2022 35
1817282 1817282 2021-10-15 Monroe Illinois 17133 5236 100
1817283 1817283 2021-10-15 Montgomery Illinois 17135 4876 86
1817284 1817284 2021-10-15 Morgan Illinois 17137 5197 121
1817285 1817285 2021-10-15 Moultrie Illinois 17139 2288 41
1817286 1817286 2021-10-15 Ogle Illinois 17141 7524 95
1817287 1817287 2021-10-15 Peoria Illinois 17143 26885 399
1817288 1817288 2021-10-15 Perry Illinois 17145 4303 84
1817289 1817289 2021-10-15 Piatt Illinois 17147 2006 20
1817290 1817290 2021-10-15 Pike Illinois 17149 2626 61
1817291 1817291 2021-10-15 Pope Illinois 17151 544 6
1817292 1817292 2021-10-15 Pulaski Illinois 17153 1037 11
1817293 1817293 2021-10-15 Putnam Illinois 17155 560 5
1817294 1817294 2021-10-15 Randolph Illinois 17157 5523 105
1817295 1817295 2021-10-15 Richland Illinois 17159 2784 66
1817296 1817296 2021-10-15 Rock Island Illinois 17161 18699 401
1817297 1817297 2021-10-15 Saline Illinois 17165 4317 85
1817298 1817298 2021-10-15 Sangamon Illinois 17167 25613 325
1817299 1817299 2021-10-15 Schuyler Illinois 17169 1064 22
1817300 1817300 2021-10-15 Scott Illinois 17171 711 6
1817301 1817301 2021-10-15 Shelby Illinois 17173 3431 50
1817302 1817302 2021-10-15 St. Clair Illinois 17163 40072 635
1817303 1817303 2021-10-15 Stark Illinois 17175 809 28
1817304 1817304 2021-10-15 Stephenson Illinois 17177 5775 111
1817305 1817305 2021-10-15 Tazewell Illinois 17179 20525 364
1817306 1817306 2021-10-15 Union Illinois 17181 3054 52
1817307 1817307 2021-10-15 Unknown Illinois   0 763
1817308 1817308 2021-10-15 Vermilion Illinois 17183 14202 215
1817309 1817309 2021-10-15 Wabash Illinois 17185 2166 22
1817310 1817310 2021-10-15 Warren Illinois 17187 2427 68
1817311 1817311 2021-10-15 Washington Illinois 17189 2114 34
1817312 1817312 2021-10-15 Wayne Illinois 17191 2999 62
1817313 1817313 2021-10-15 White Illinois 17193 2785 43
1817314 1817314 2021-10-15 Whiteside Illinois 17195 8351 223
1817315 1817315 2021-10-15 Will Illinois 17197 90698 1191

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