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-20 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
351223 | 351223 | 2020-07-20 | Adams | Illinois | 17001 | 285 | 1 |
351224 | 351224 | 2020-07-20 | Alexander | Illinois | 17003 | 32 | 0 |
351225 | 351225 | 2020-07-20 | Bond | Illinois | 17005 | 25 | 1 |
351226 | 351226 | 2020-07-20 | Boone | Illinois | 17007 | 656 | 21 |
351227 | 351227 | 2020-07-20 | Brown | Illinois | 17009 | 11 | 0 |
351228 | 351228 | 2020-07-20 | Bureau | Illinois | 17011 | 53 | 2 |
351229 | 351229 | 2020-07-20 | Calhoun | Illinois | 17013 | 2 | 0 |
351230 | 351230 | 2020-07-20 | Carroll | Illinois | 17015 | 23 | 2 |
351231 | 351231 | 2020-07-20 | Cass | Illinois | 17017 | 156 | 11 |
351232 | 351232 | 2020-07-20 | Champaign | Illinois | 17019 | 1249 | 17 |
351233 | 351233 | 2020-07-20 | Christian | Illinois | 17021 | 55 | 5 |
351234 | 351234 | 2020-07-20 | Clark | Illinois | 17023 | 50 | 0 |
351235 | 351235 | 2020-07-20 | Clay | Illinois | 17025 | 8 | 0 |
351236 | 351236 | 2020-07-20 | Clinton | Illinois | 17027 | 271 | 17 |
351237 | 351237 | 2020-07-20 | Coles | Illinois | 17029 | 249 | 17 |
351238 | 351238 | 2020-07-20 | Cook | Illinois | 17031 | 99052 | 4777 |
351239 | 351239 | 2020-07-20 | Crawford | Illinois | 17033 | 26 | 0 |
351240 | 351240 | 2020-07-20 | Cumberland | Illinois | 17035 | 36 | 1 |
351241 | 351241 | 2020-07-20 | De Witt | Illinois | 17039 | 21 | 0 |
351242 | 351242 | 2020-07-20 | DeKalb | Illinois | 17037 | 733 | 23 |
351243 | 351243 | 2020-07-20 | Douglas | Illinois | 17041 | 80 | 0 |
351244 | 351244 | 2020-07-20 | DuPage | Illinois | 17043 | 10317 | 498 |
351245 | 351245 | 2020-07-20 | Edgar | Illinois | 17045 | 23 | 0 |
351246 | 351246 | 2020-07-20 | Edwards | Illinois | 17047 | 5 | 0 |
351247 | 351247 | 2020-07-20 | Effingham | Illinois | 17049 | 42 | 1 |
351248 | 351248 | 2020-07-20 | Fayette | Illinois | 17051 | 38 | 3 |
351249 | 351249 | 2020-07-20 | Ford | Illinois | 17053 | 33 | 1 |
351250 | 351250 | 2020-07-20 | Franklin | Illinois | 17055 | 78 | 0 |
351251 | 351251 | 2020-07-20 | Fulton | Illinois | 17057 | 20 | 0 |
351252 | 351252 | 2020-07-20 | Gallatin | Illinois | 17059 | 21 | 0 |
351253 | 351253 | 2020-07-20 | Greene | Illinois | 17061 | 13 | 0 |
351254 | 351254 | 2020-07-20 | Grundy | Illinois | 17063 | 213 | 5 |
351255 | 351255 | 2020-07-20 | Hamilton | Illinois | 17065 | 11 | 0 |
351256 | 351256 | 2020-07-20 | Hancock | Illinois | 17067 | 22 | 1 |
351257 | 351257 | 2020-07-20 | Hardin | Illinois | 17069 | 6 | 0 |
351258 | 351258 | 2020-07-20 | Henderson | Illinois | 17071 | 8 | 0 |
351259 | 351259 | 2020-07-20 | Henry | Illinois | 17073 | 146 | 1 |
351260 | 351260 | 2020-07-20 | Iroquois | Illinois | 17075 | 181 | 5 |
351261 | 351261 | 2020-07-20 | Jackson | Illinois | 17077 | 420 | 19 |
351262 | 351262 | 2020-07-20 | Jasper | Illinois | 17079 | 49 | 7 |
351263 | 351263 | 2020-07-20 | Jefferson | Illinois | 17081 | 136 | 17 |
351264 | 351264 | 2020-07-20 | Jersey | Illinois | 17083 | 54 | 1 |
351265 | 351265 | 2020-07-20 | Jo Daviess | Illinois | 17085 | 66 | 1 |
351266 | 351266 | 2020-07-20 | Johnson | Illinois | 17087 | 42 | 0 |
351267 | 351267 | 2020-07-20 | Kane | Illinois | 17089 | 8473 | 290 |
351268 | 351268 | 2020-07-20 | Kankakee | Illinois | 17091 | 1582 | 66 |
351269 | 351269 | 2020-07-20 | Kendall | Illinois | 17093 | 1184 | 23 |
351270 | 351270 | 2020-07-20 | Knox | Illinois | 17095 | 193 | 0 |
351271 | 351271 | 2020-07-20 | LaSalle | Illinois | 17099 | 343 | 18 |
351272 | 351272 | 2020-07-20 | Lake | Illinois | 17097 | 10897 | 433 |
351273 | 351273 | 2020-07-20 | Lawrence | Illinois | 17101 | 27 | 0 |
351274 | 351274 | 2020-07-20 | Lee | Illinois | 17103 | 117 | 2 |
351275 | 351275 | 2020-07-20 | Livingston | Illinois | 17105 | 60 | 2 |
351276 | 351276 | 2020-07-20 | Logan | Illinois | 17107 | 51 | 0 |
351277 | 351277 | 2020-07-20 | Macon | Illinois | 17115 | 282 | 22 |
351278 | 351278 | 2020-07-20 | Macoupin | Illinois | 17117 | 89 | 3 |
351279 | 351279 | 2020-07-20 | Madison | Illinois | 17119 | 1534 | 71 |
351280 | 351280 | 2020-07-20 | Marion | Illinois | 17121 | 93 | 0 |
351281 | 351281 | 2020-07-20 | Marshall | Illinois | 17123 | 15 | 0 |
351282 | 351282 | 2020-07-20 | Mason | Illinois | 17125 | 36 | 0 |
351283 | 351283 | 2020-07-20 | Massac | Illinois | 17127 | 22 | 0 |
351284 | 351284 | 2020-07-20 | McDonough | Illinois | 17109 | 118 | 15 |
351285 | 351285 | 2020-07-20 | McHenry | Illinois | 17111 | 2538 | 108 |
351286 | 351286 | 2020-07-20 | McLean | Illinois | 17113 | 404 | 15 |
351287 | 351287 | 2020-07-20 | Menard | Illinois | 17129 | 35 | 0 |
351288 | 351288 | 2020-07-20 | Mercer | Illinois | 17131 | 34 | 0 |
351289 | 351289 | 2020-07-20 | Monroe | Illinois | 17133 | 198 | 13 |
351290 | 351290 | 2020-07-20 | Montgomery | Illinois | 17135 | 106 | 1 |
351291 | 351291 | 2020-07-20 | Morgan | Illinois | 17137 | 145 | 5 |
351292 | 351292 | 2020-07-20 | Moultrie | Illinois | 17139 | 30 | 0 |
351293 | 351293 | 2020-07-20 | Ogle | Illinois | 17141 | 352 | 5 |
351294 | 351294 | 2020-07-20 | Peoria | Illinois | 17143 | 840 | 32 |
351295 | 351295 | 2020-07-20 | Perry | Illinois | 17145 | 68 | 1 |
351296 | 351296 | 2020-07-20 | Piatt | Illinois | 17147 | 30 | 0 |
351297 | 351297 | 2020-07-20 | Pike | Illinois | 17149 | 9 | 0 |
351298 | 351298 | 2020-07-20 | Pope | Illinois | 17151 | 2 | 0 |
351299 | 351299 | 2020-07-20 | Pulaski | Illinois | 17153 | 88 | 0 |
351300 | 351300 | 2020-07-20 | Putnam | Illinois | 17155 | 2 | 0 |
351301 | 351301 | 2020-07-20 | Randolph | Illinois | 17157 | 370 | 7 |
351302 | 351302 | 2020-07-20 | Richland | Illinois | 17159 | 10 | 0 |
351303 | 351303 | 2020-07-20 | Rock Island | Illinois | 17161 | 1359 | 30 |
351304 | 351304 | 2020-07-20 | Saline | Illinois | 17165 | 56 | 0 |
351305 | 351305 | 2020-07-20 | Sangamon | Illinois | 17167 | 687 | 34 |
351306 | 351306 | 2020-07-20 | Schuyler | Illinois | 17169 | 14 | 0 |
351307 | 351307 | 2020-07-20 | Scott | Illinois | 17171 | 1 | 0 |
351308 | 351308 | 2020-07-20 | Shelby | Illinois | 17173 | 29 | 1 |
351309 | 351309 | 2020-07-20 | St. Clair | Illinois | 17163 | 3095 | 150 |
351310 | 351310 | 2020-07-20 | Stark | Illinois | 17175 | 6 | 0 |
351311 | 351311 | 2020-07-20 | Stephenson | Illinois | 17177 | 289 | 6 |
351312 | 351312 | 2020-07-20 | Tazewell | Illinois | 17179 | 226 | 8 |
351313 | 351313 | 2020-07-20 | Union | Illinois | 17181 | 237 | 21 |
351314 | 351314 | 2020-07-20 | Unknown | Illinois | 1175 | 193 | |
351315 | 351315 | 2020-07-20 | Vermilion | Illinois | 17183 | 130 | 2 |
351316 | 351316 | 2020-07-20 | Wabash | Illinois | 17185 | 23 | 0 |
351317 | 351317 | 2020-07-20 | Warren | Illinois | 17187 | 153 | 0 |
351318 | 351318 | 2020-07-20 | Washington | Illinois | 17189 | 35 | 0 |
351319 | 351319 | 2020-07-20 | Wayne | Illinois | 17191 | 27 | 1 |
351320 | 351320 | 2020-07-20 | White | Illinois | 17193 | 31 | 0 |
351321 | 351321 | 2020-07-20 | Whiteside | Illinois | 17195 | 234 | 16 |
351322 | 351322 | 2020-07-20 | Will | Illinois | 17197 | 7710 | 336 |
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);