ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where date = "2020-04-26" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
90229 | 90229 | 2020-04-26 | Adams | Illinois | 17001 | 32 | 0 |
90230 | 90230 | 2020-04-26 | Alexander | Illinois | 17003 | 3 | 0 |
90231 | 90231 | 2020-04-26 | Bond | Illinois | 17005 | 5 | 1 |
90232 | 90232 | 2020-04-26 | Boone | Illinois | 17007 | 76 | 8 |
90233 | 90233 | 2020-04-26 | Bureau | Illinois | 17011 | 10 | 0 |
90234 | 90234 | 2020-04-26 | Calhoun | Illinois | 17013 | 1 | 0 |
90235 | 90235 | 2020-04-26 | Carroll | Illinois | 17015 | 9 | 2 |
90236 | 90236 | 2020-04-26 | Cass | Illinois | 17017 | 27 | 0 |
90237 | 90237 | 2020-04-26 | Champaign | Illinois | 17019 | 105 | 5 |
90238 | 90238 | 2020-04-26 | Christian | Illinois | 17021 | 28 | 5 |
90239 | 90239 | 2020-04-26 | Clark | Illinois | 17023 | 4 | 0 |
90240 | 90240 | 2020-04-26 | Clay | Illinois | 17025 | 2 | 0 |
90241 | 90241 | 2020-04-26 | Clinton | Illinois | 17027 | 84 | 1 |
90242 | 90242 | 2020-04-26 | Coles | Illinois | 17029 | 22 | 1 |
90243 | 90243 | 2020-04-26 | Cook | Illinois | 17031 | 30574 | 1313 |
90244 | 90244 | 2020-04-26 | Crawford | Illinois | 17033 | 10 | 0 |
90245 | 90245 | 2020-04-26 | Cumberland | Illinois | 17035 | 3 | 0 |
90246 | 90246 | 2020-04-26 | De Witt | Illinois | 17039 | 1 | 0 |
90247 | 90247 | 2020-04-26 | DeKalb | Illinois | 17037 | 71 | 1 |
90248 | 90248 | 2020-04-26 | Douglas | Illinois | 17041 | 13 | 0 |
90249 | 90249 | 2020-04-26 | DuPage | Illinois | 17043 | 2443 | 131 |
90250 | 90250 | 2020-04-26 | Effingham | Illinois | 17049 | 5 | 1 |
90251 | 90251 | 2020-04-26 | Fayette | Illinois | 17051 | 16 | 2 |
90252 | 90252 | 2020-04-26 | Ford | Illinois | 17053 | 8 | 1 |
90253 | 90253 | 2020-04-26 | Franklin | Illinois | 17055 | 8 | 0 |
90254 | 90254 | 2020-04-26 | Fulton | Illinois | 17057 | 3 | 0 |
90255 | 90255 | 2020-04-26 | Gallatin | Illinois | 17059 | 2 | 0 |
90256 | 90256 | 2020-04-26 | Greene | Illinois | 17061 | 2 | 0 |
90257 | 90257 | 2020-04-26 | Grundy | Illinois | 17063 | 30 | 0 |
90258 | 90258 | 2020-04-26 | Hamilton | Illinois | 17065 | 2 | 0 |
90259 | 90259 | 2020-04-26 | Hancock | Illinois | 17067 | 4 | 0 |
90260 | 90260 | 2020-04-26 | Hardin | Illinois | 17069 | 1 | 0 |
90261 | 90261 | 2020-04-26 | Henderson | Illinois | 17071 | 4 | 0 |
90262 | 90262 | 2020-04-26 | Henry | Illinois | 17073 | 36 | 0 |
90263 | 90263 | 2020-04-26 | Iroquois | Illinois | 17075 | 18 | 0 |
90264 | 90264 | 2020-04-26 | Jackson | Illinois | 17077 | 67 | 7 |
90265 | 90265 | 2020-04-26 | Jasper | Illinois | 17079 | 41 | 2 |
90266 | 90266 | 2020-04-26 | Jefferson | Illinois | 17081 | 83 | 5 |
90267 | 90267 | 2020-04-26 | Jersey | Illinois | 17083 | 12 | 1 |
90268 | 90268 | 2020-04-26 | Jo Daviess | Illinois | 17085 | 11 | 0 |
90269 | 90269 | 2020-04-26 | Johnson | Illinois | 17087 | 4 | 0 |
90270 | 90270 | 2020-04-26 | Kane | Illinois | 17089 | 1109 | 39 |
90271 | 90271 | 2020-04-26 | Kankakee | Illinois | 17091 | 304 | 26 |
90272 | 90272 | 2020-04-26 | Kendall | Illinois | 17093 | 208 | 5 |
90273 | 90273 | 2020-04-26 | Knox | Illinois | 17095 | 36 | 0 |
90274 | 90274 | 2020-04-26 | LaSalle | Illinois | 17099 | 44 | 1 |
90275 | 90275 | 2020-04-26 | Lake | Illinois | 17097 | 2990 | 118 |
90276 | 90276 | 2020-04-26 | Lawrence | Illinois | 17101 | 3 | 0 |
90277 | 90277 | 2020-04-26 | Lee | Illinois | 17103 | 19 | 0 |
90278 | 90278 | 2020-04-26 | Livingston | Illinois | 17105 | 20 | 1 |
90279 | 90279 | 2020-04-26 | Logan | Illinois | 17107 | 4 | 0 |
90280 | 90280 | 2020-04-26 | Macon | Illinois | 17115 | 102 | 11 |
90281 | 90281 | 2020-04-26 | Macoupin | Illinois | 17117 | 28 | 0 |
90282 | 90282 | 2020-04-26 | Madison | Illinois | 17119 | 305 | 16 |
90283 | 90283 | 2020-04-26 | Marion | Illinois | 17121 | 26 | 0 |
90284 | 90284 | 2020-04-26 | Marshall | Illinois | 17123 | 4 | 0 |
90285 | 90285 | 2020-04-26 | Mason | Illinois | 17125 | 6 | 0 |
90286 | 90286 | 2020-04-26 | Massac | Illinois | 17127 | 4 | 0 |
90287 | 90287 | 2020-04-26 | McDonough | Illinois | 17109 | 6 | 0 |
90288 | 90288 | 2020-04-26 | McHenry | Illinois | 17111 | 513 | 28 |
90289 | 90289 | 2020-04-26 | McLean | Illinois | 17113 | 88 | 3 |
90290 | 90290 | 2020-04-26 | Menard | Illinois | 17129 | 4 | 0 |
90291 | 90291 | 2020-04-26 | Mercer | Illinois | 17131 | 7 | 0 |
90292 | 90292 | 2020-04-26 | Monroe | Illinois | 17133 | 64 | 10 |
90293 | 90293 | 2020-04-26 | Montgomery | Illinois | 17135 | 23 | 0 |
90294 | 90294 | 2020-04-26 | Morgan | Illinois | 17137 | 16 | 1 |
90295 | 90295 | 2020-04-26 | Moultrie | Illinois | 17139 | 4 | 0 |
90296 | 90296 | 2020-04-26 | Ogle | Illinois | 17141 | 87 | 1 |
90297 | 90297 | 2020-04-26 | Peoria | Illinois | 17143 | 65 | 2 |
90298 | 90298 | 2020-04-26 | Perry | Illinois | 17145 | 8 | 0 |
90299 | 90299 | 2020-04-26 | Piatt | Illinois | 17147 | 7 | 0 |
90300 | 90300 | 2020-04-26 | Pike | Illinois | 17149 | 1 | 0 |
90301 | 90301 | 2020-04-26 | Pulaski | Illinois | 17153 | 15 | 0 |
90302 | 90302 | 2020-04-26 | Randolph | Illinois | 17157 | 104 | 1 |
90303 | 90303 | 2020-04-26 | Richland | Illinois | 17159 | 3 | 0 |
90304 | 90304 | 2020-04-26 | Rock Island | Illinois | 17161 | 304 | 7 |
90305 | 90305 | 2020-04-26 | Saline | Illinois | 17165 | 3 | 0 |
90306 | 90306 | 2020-04-26 | Sangamon | Illinois | 17167 | 104 | 6 |
90307 | 90307 | 2020-04-26 | Schuyler | Illinois | 17169 | 1 | 0 |
90308 | 90308 | 2020-04-26 | Shelby | Illinois | 17173 | 10 | 0 |
90309 | 90309 | 2020-04-26 | St. Clair | Illinois | 17163 | 391 | 24 |
90310 | 90310 | 2020-04-26 | Stark | Illinois | 17175 | 1 | 0 |
90311 | 90311 | 2020-04-26 | Stephenson | Illinois | 17177 | 16 | 0 |
90312 | 90312 | 2020-04-26 | Tazewell | Illinois | 17179 | 36 | 3 |
90313 | 90313 | 2020-04-26 | Union | Illinois | 17181 | 8 | 0 |
90314 | 90314 | 2020-04-26 | Unknown | Illinois | 308 | 0 | |
90315 | 90315 | 2020-04-26 | Vermilion | Illinois | 17183 | 11 | 0 |
90316 | 90316 | 2020-04-26 | Wabash | Illinois | 17185 | 1 | 0 |
90317 | 90317 | 2020-04-26 | Warren | Illinois | 17187 | 49 | 0 |
90318 | 90318 | 2020-04-26 | Washington | Illinois | 17189 | 8 | 0 |
90319 | 90319 | 2020-04-26 | Wayne | Illinois | 17191 | 2 | 0 |
90320 | 90320 | 2020-04-26 | White | Illinois | 17193 | 1 | 0 |
90321 | 90321 | 2020-04-26 | Whiteside | Illinois | 17195 | 62 | 5 |
90322 | 90322 | 2020-04-26 | Will | Illinois | 17197 | 2126 | 133 |
90323 | 90323 | 2020-04-26 | Williamson | Illinois | 17199 | 25 | 0 |
90324 | 90324 | 2020-04-26 | Winnebago | Illinois | 17201 | 318 | 14 |
90325 | 90325 | 2020-04-26 | Woodford | Illinois | 17203 | 11 | 1 |
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);