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 2021-03-31 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1174224 | 1174224 | 2021-03-31 | Adams | Illinois | 17001 | 8076 | 144 |
1174225 | 1174225 | 2021-03-31 | Alexander | Illinois | 17003 | 456 | 10 |
1174226 | 1174226 | 2021-03-31 | Bond | Illinois | 17005 | 1939 | 30 |
1174227 | 1174227 | 2021-03-31 | Boone | Illinois | 17007 | 6112 | 83 |
1174228 | 1174228 | 2021-03-31 | Brown | Illinois | 17009 | 680 | 12 |
1174229 | 1174229 | 2021-03-31 | Bureau | Illinois | 17011 | 3421 | 92 |
1174230 | 1174230 | 2021-03-31 | Calhoun | Illinois | 17013 | 504 | 5 |
1174231 | 1174231 | 2021-03-31 | Carroll | Illinois | 17015 | 1641 | 36 |
1174232 | 1174232 | 2021-03-31 | Cass | Illinois | 17017 | 1926 | 33 |
1174233 | 1174233 | 2021-03-31 | Champaign | Illinois | 17019 | 19028 | 144 |
1174234 | 1174234 | 2021-03-31 | Christian | Illinois | 17021 | 3411 | 89 |
1174235 | 1174235 | 2021-03-31 | Clark | Illinois | 17023 | 1721 | 40 |
1174236 | 1174236 | 2021-03-31 | Clay | Illinois | 17025 | 1456 | 47 |
1174237 | 1174237 | 2021-03-31 | Clinton | Illinois | 17027 | 5672 | 98 |
1174238 | 1174238 | 2021-03-31 | Coles | Illinois | 17029 | 5427 | 96 |
1174239 | 1174239 | 2021-03-31 | Cook | Illinois | 17031 | 497885 | 10220 |
1174240 | 1174240 | 2021-03-31 | Crawford | Illinois | 17033 | 2063 | 40 |
1174241 | 1174241 | 2021-03-31 | Cumberland | Illinois | 17035 | 1266 | 31 |
1174242 | 1174242 | 2021-03-31 | De Witt | Illinois | 17039 | 1326 | 30 |
1174243 | 1174243 | 2021-03-31 | DeKalb | Illinois | 17037 | 8837 | 122 |
1174244 | 1174244 | 2021-03-31 | Douglas | Illinois | 17041 | 2517 | 41 |
1174245 | 1174245 | 2021-03-31 | DuPage | Illinois | 17043 | 81889 | 1316 |
1174246 | 1174246 | 2021-03-31 | Edgar | Illinois | 17045 | 1633 | 59 |
1174247 | 1174247 | 2021-03-31 | Edwards | Illinois | 17047 | 541 | 13 |
1174248 | 1174248 | 2021-03-31 | Effingham | Illinois | 17049 | 4576 | 82 |
1174249 | 1174249 | 2021-03-31 | Fayette | Illinois | 17051 | 3097 | 57 |
1174250 | 1174250 | 2021-03-31 | Ford | Illinois | 17053 | 1640 | 54 |
1174251 | 1174251 | 2021-03-31 | Franklin | Illinois | 17055 | 4264 | 82 |
1174252 | 1174252 | 2021-03-31 | Fulton | Illinois | 17057 | 3300 | 58 |
1174253 | 1174253 | 2021-03-31 | Gallatin | Illinois | 17059 | 451 | 5 |
1174254 | 1174254 | 2021-03-31 | Greene | Illinois | 17061 | 1402 | 45 |
1174255 | 1174255 | 2021-03-31 | Grundy | Illinois | 17063 | 5412 | 74 |
1174256 | 1174256 | 2021-03-31 | Hamilton | Illinois | 17065 | 805 | 18 |
1174257 | 1174257 | 2021-03-31 | Hancock | Illinois | 17067 | 1699 | 40 |
1174258 | 1174258 | 2021-03-31 | Hardin | Illinois | 17069 | 360 | 12 |
1174259 | 1174259 | 2021-03-31 | Henderson | Illinois | 17071 | 519 | 23 |
1174260 | 1174260 | 2021-03-31 | Henry | Illinois | 17073 | 4507 | 89 |
1174261 | 1174261 | 2021-03-31 | Iroquois | Illinois | 17075 | 2846 | 65 |
1174262 | 1174262 | 2021-03-31 | Jackson | Illinois | 17077 | 4742 | 73 |
1174263 | 1174263 | 2021-03-31 | Jasper | Illinois | 17079 | 1131 | 19 |
1174264 | 1174264 | 2021-03-31 | Jefferson | Illinois | 17081 | 4070 | 119 |
1174265 | 1174265 | 2021-03-31 | Jersey | Illinois | 17083 | 2558 | 67 |
1174266 | 1174266 | 2021-03-31 | Jo Daviess | Illinois | 17085 | 1682 | 25 |
1174267 | 1174267 | 2021-03-31 | Johnson | Illinois | 17087 | 1372 | 20 |
1174268 | 1174268 | 2021-03-31 | Kane | Illinois | 17089 | 52886 | 797 |
1174269 | 1174269 | 2021-03-31 | Kankakee | Illinois | 17091 | 13011 | 200 |
1174270 | 1174270 | 2021-03-31 | Kendall | Illinois | 17093 | 12009 | 99 |
1174271 | 1174271 | 2021-03-31 | Knox | Illinois | 17095 | 5135 | 166 |
1174272 | 1174272 | 2021-03-31 | LaSalle | Illinois | 17099 | 11283 | 281 |
1174273 | 1174273 | 2021-03-31 | Lake | Illinois | 17097 | 62242 | 1023 |
1174274 | 1174274 | 2021-03-31 | Lawrence | Illinois | 17101 | 2371 | 33 |
1174275 | 1174275 | 2021-03-31 | Lee | Illinois | 17103 | 3714 | 86 |
1174276 | 1174276 | 2021-03-31 | Livingston | Illinois | 17105 | 4412 | 92 |
1174277 | 1174277 | 2021-03-31 | Logan | Illinois | 17107 | 3465 | 67 |
1174278 | 1174278 | 2021-03-31 | Macon | Illinois | 17115 | 9879 | 198 |
1174279 | 1174279 | 2021-03-31 | Macoupin | Illinois | 17117 | 4496 | 110 |
1174280 | 1174280 | 2021-03-31 | Madison | Illinois | 17119 | 29202 | 575 |
1174281 | 1174281 | 2021-03-31 | Marion | Illinois | 17121 | 4364 | 120 |
1174282 | 1174282 | 2021-03-31 | Marshall | Illinois | 17123 | 919 | 19 |
1174283 | 1174283 | 2021-03-31 | Mason | Illinois | 17125 | 1349 | 42 |
1174284 | 1174284 | 2021-03-31 | Massac | Illinois | 17127 | 1307 | 40 |
1174285 | 1174285 | 2021-03-31 | McDonough | Illinois | 17109 | 2427 | 54 |
1174286 | 1174286 | 2021-03-31 | McHenry | Illinois | 17111 | 25586 | 299 |
1174287 | 1174287 | 2021-03-31 | McLean | Illinois | 17113 | 15644 | 201 |
1174288 | 1174288 | 2021-03-31 | Menard | Illinois | 17129 | 1138 | 13 |
1174289 | 1174289 | 2021-03-31 | Mercer | Illinois | 17131 | 1320 | 33 |
1174290 | 1174290 | 2021-03-31 | Monroe | Illinois | 17133 | 4202 | 90 |
1174291 | 1174291 | 2021-03-31 | Montgomery | Illinois | 17135 | 3595 | 77 |
1174292 | 1174292 | 2021-03-31 | Morgan | Illinois | 17137 | 3776 | 101 |
1174293 | 1174293 | 2021-03-31 | Moultrie | Illinois | 17139 | 1530 | 33 |
1174294 | 1174294 | 2021-03-31 | Ogle | Illinois | 17141 | 5416 | 86 |
1174295 | 1174295 | 2021-03-31 | Peoria | Illinois | 17143 | 18709 | 289 |
1174296 | 1174296 | 2021-03-31 | Perry | Illinois | 17145 | 3113 | 68 |
1174297 | 1174297 | 2021-03-31 | Piatt | Illinois | 17147 | 1390 | 20 |
1174298 | 1174298 | 2021-03-31 | Pike | Illinois | 17149 | 1734 | 53 |
1174299 | 1174299 | 2021-03-31 | Pope | Illinois | 17151 | 302 | 3 |
1174300 | 1174300 | 2021-03-31 | Pulaski | Illinois | 17153 | 673 | 7 |
1174301 | 1174301 | 2021-03-31 | Putnam | Illinois | 17155 | 432 | 4 |
1174302 | 1174302 | 2021-03-31 | Randolph | Illinois | 17157 | 4037 | 88 |
1174303 | 1174303 | 2021-03-31 | Richland | Illinois | 17159 | 1682 | 48 |
1174304 | 1174304 | 2021-03-31 | Rock Island | Illinois | 17161 | 13673 | 340 |
1174305 | 1174305 | 2021-03-31 | Saline | Illinois | 17165 | 2432 | 68 |
1174306 | 1174306 | 2021-03-31 | Sangamon | Illinois | 17167 | 16973 | 269 |
1174307 | 1174307 | 2021-03-31 | Schuyler | Illinois | 17169 | 687 | 17 |
1174308 | 1174308 | 2021-03-31 | Scott | Illinois | 17171 | 456 | 1 |
1174309 | 1174309 | 2021-03-31 | Shelby | Illinois | 17173 | 2206 | 39 |
1174310 | 1174310 | 2021-03-31 | St. Clair | Illinois | 17163 | 29377 | 537 |
1174311 | 1174311 | 2021-03-31 | Stark | Illinois | 17175 | 554 | 23 |
1174312 | 1174312 | 2021-03-31 | Stephenson | Illinois | 17177 | 4279 | 98 |
1174313 | 1174313 | 2021-03-31 | Tazewell | Illinois | 17179 | 14468 | 278 |
1174314 | 1174314 | 2021-03-31 | Union | Illinois | 17181 | 2225 | 43 |
1174315 | 1174315 | 2021-03-31 | Unknown | Illinois | 0 | 266 | |
1174316 | 1174316 | 2021-03-31 | Vermilion | Illinois | 17183 | 8877 | 139 |
1174317 | 1174317 | 2021-03-31 | Wabash | Illinois | 17185 | 1333 | 15 |
1174318 | 1174318 | 2021-03-31 | Warren | Illinois | 17187 | 1687 | 48 |
1174319 | 1174319 | 2021-03-31 | Washington | Illinois | 17189 | 1613 | 31 |
1174320 | 1174320 | 2021-03-31 | Wayne | Illinois | 17191 | 1708 | 51 |
1174321 | 1174321 | 2021-03-31 | White | Illinois | 17193 | 1652 | 35 |
1174322 | 1174322 | 2021-03-31 | Whiteside | Illinois | 17195 | 6418 | 200 |
1174323 | 1174323 | 2021-03-31 | Will | Illinois | 17197 | 68489 | 1015 |
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);