ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-04-12" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1213199 | 1213199 | 2021-04-12 | Adams | Illinois | 17001 | 8131 | 145 |
1213200 | 1213200 | 2021-04-12 | Alexander | Illinois | 17003 | 462 | 10 |
1213201 | 1213201 | 2021-04-12 | Bond | Illinois | 17005 | 1954 | 30 |
1213202 | 1213202 | 2021-04-12 | Boone | Illinois | 17007 | 6286 | 83 |
1213203 | 1213203 | 2021-04-12 | Brown | Illinois | 17009 | 684 | 12 |
1213204 | 1213204 | 2021-04-12 | Bureau | Illinois | 17011 | 3495 | 92 |
1213205 | 1213205 | 2021-04-12 | Calhoun | Illinois | 17013 | 507 | 5 |
1213206 | 1213206 | 2021-04-12 | Carroll | Illinois | 17015 | 1674 | 36 |
1213207 | 1213207 | 2021-04-12 | Cass | Illinois | 17017 | 1942 | 33 |
1213208 | 1213208 | 2021-04-12 | Champaign | Illinois | 17019 | 19486 | 144 |
1213209 | 1213209 | 2021-04-12 | Christian | Illinois | 17021 | 3475 | 89 |
1213210 | 1213210 | 2021-04-12 | Clark | Illinois | 17023 | 1741 | 40 |
1213211 | 1213211 | 2021-04-12 | Clay | Illinois | 17025 | 1465 | 47 |
1213212 | 1213212 | 2021-04-12 | Clinton | Illinois | 17027 | 5689 | 99 |
1213213 | 1213213 | 2021-04-12 | Coles | Illinois | 17029 | 5478 | 96 |
1213214 | 1213214 | 2021-04-12 | Cook | Illinois | 17031 | 513888 | 10326 |
1213215 | 1213215 | 2021-04-12 | Crawford | Illinois | 17033 | 2081 | 41 |
1213216 | 1213216 | 2021-04-12 | Cumberland | Illinois | 17035 | 1276 | 31 |
1213217 | 1213217 | 2021-04-12 | De Witt | Illinois | 17039 | 1360 | 30 |
1213218 | 1213218 | 2021-04-12 | DeKalb | Illinois | 17037 | 9234 | 123 |
1213219 | 1213219 | 2021-04-12 | Douglas | Illinois | 17041 | 2536 | 41 |
1213220 | 1213220 | 2021-04-12 | DuPage | Illinois | 17043 | 85016 | 1325 |
1213221 | 1213221 | 2021-04-12 | Edgar | Illinois | 17045 | 1653 | 59 |
1213222 | 1213222 | 2021-04-12 | Edwards | Illinois | 17047 | 544 | 13 |
1213223 | 1213223 | 2021-04-12 | Effingham | Illinois | 17049 | 4653 | 82 |
1213224 | 1213224 | 2021-04-12 | Fayette | Illinois | 17051 | 3121 | 57 |
1213225 | 1213225 | 2021-04-12 | Ford | Illinois | 17053 | 1673 | 54 |
1213226 | 1213226 | 2021-04-12 | Franklin | Illinois | 17055 | 4306 | 82 |
1213227 | 1213227 | 2021-04-12 | Fulton | Illinois | 17057 | 3548 | 58 |
1213228 | 1213228 | 2021-04-12 | Gallatin | Illinois | 17059 | 453 | 5 |
1213229 | 1213229 | 2021-04-12 | Greene | Illinois | 17061 | 1418 | 45 |
1213230 | 1213230 | 2021-04-12 | Grundy | Illinois | 17063 | 5546 | 75 |
1213231 | 1213231 | 2021-04-12 | Hamilton | Illinois | 17065 | 815 | 18 |
1213232 | 1213232 | 2021-04-12 | Hancock | Illinois | 17067 | 1711 | 40 |
1213233 | 1213233 | 2021-04-12 | Hardin | Illinois | 17069 | 365 | 12 |
1213234 | 1213234 | 2021-04-12 | Henderson | Illinois | 17071 | 519 | 23 |
1213235 | 1213235 | 2021-04-12 | Henry | Illinois | 17073 | 4640 | 90 |
1213236 | 1213236 | 2021-04-12 | Iroquois | Illinois | 17075 | 2880 | 66 |
1213237 | 1213237 | 2021-04-12 | Jackson | Illinois | 17077 | 4821 | 74 |
1213238 | 1213238 | 2021-04-12 | Jasper | Illinois | 17079 | 1139 | 19 |
1213239 | 1213239 | 2021-04-12 | Jefferson | Illinois | 17081 | 4123 | 119 |
1213240 | 1213240 | 2021-04-12 | Jersey | Illinois | 17083 | 2600 | 66 |
1213241 | 1213241 | 2021-04-12 | Jo Daviess | Illinois | 17085 | 1734 | 27 |
1213242 | 1213242 | 2021-04-12 | Johnson | Illinois | 17087 | 1383 | 20 |
1213243 | 1213243 | 2021-04-12 | Kane | Illinois | 17089 | 54635 | 801 |
1213244 | 1213244 | 2021-04-12 | Kankakee | Illinois | 17091 | 13317 | 204 |
1213245 | 1213245 | 2021-04-12 | Kendall | Illinois | 17093 | 12426 | 99 |
1213246 | 1213246 | 2021-04-12 | Knox | Illinois | 17095 | 5228 | 167 |
1213247 | 1213247 | 2021-04-12 | LaSalle | Illinois | 17099 | 11553 | 283 |
1213248 | 1213248 | 2021-04-12 | Lake | Illinois | 17097 | 63797 | 1030 |
1213249 | 1213249 | 2021-04-12 | Lawrence | Illinois | 17101 | 2385 | 34 |
1213250 | 1213250 | 2021-04-12 | Lee | Illinois | 17103 | 3882 | 88 |
1213251 | 1213251 | 2021-04-12 | Livingston | Illinois | 17105 | 4525 | 94 |
1213252 | 1213252 | 2021-04-12 | Logan | Illinois | 17107 | 3569 | 68 |
1213253 | 1213253 | 2021-04-12 | Macon | Illinois | 17115 | 10083 | 199 |
1213254 | 1213254 | 2021-04-12 | Macoupin | Illinois | 17117 | 4550 | 110 |
1213255 | 1213255 | 2021-04-12 | Madison | Illinois | 17119 | 29606 | 584 |
1213256 | 1213256 | 2021-04-12 | Marion | Illinois | 17121 | 4374 | 120 |
1213257 | 1213257 | 2021-04-12 | Marshall | Illinois | 17123 | 965 | 19 |
1213258 | 1213258 | 2021-04-12 | Mason | Illinois | 17125 | 1397 | 42 |
1213259 | 1213259 | 2021-04-12 | Massac | Illinois | 17127 | 1309 | 42 |
1213260 | 1213260 | 2021-04-12 | McDonough | Illinois | 17109 | 2516 | 54 |
1213261 | 1213261 | 2021-04-12 | McHenry | Illinois | 17111 | 26442 | 301 |
1213262 | 1213262 | 2021-04-12 | McLean | Illinois | 17113 | 16418 | 205 |
1213263 | 1213263 | 2021-04-12 | Menard | Illinois | 17129 | 1170 | 15 |
1213264 | 1213264 | 2021-04-12 | Mercer | Illinois | 17131 | 1339 | 33 |
1213265 | 1213265 | 2021-04-12 | Monroe | Illinois | 17133 | 4288 | 90 |
1213266 | 1213266 | 2021-04-12 | Montgomery | Illinois | 17135 | 3631 | 78 |
1213267 | 1213267 | 2021-04-12 | Morgan | Illinois | 17137 | 3806 | 101 |
1213268 | 1213268 | 2021-04-12 | Moultrie | Illinois | 17139 | 1556 | 33 |
1213269 | 1213269 | 2021-04-12 | Ogle | Illinois | 17141 | 5643 | 86 |
1213270 | 1213270 | 2021-04-12 | Peoria | Illinois | 17143 | 20369 | 297 |
1213271 | 1213271 | 2021-04-12 | Perry | Illinois | 17145 | 3126 | 68 |
1213272 | 1213272 | 2021-04-12 | Piatt | Illinois | 17147 | 1406 | 20 |
1213273 | 1213273 | 2021-04-12 | Pike | Illinois | 17149 | 1749 | 54 |
1213274 | 1213274 | 2021-04-12 | Pope | Illinois | 17151 | 304 | 3 |
1213275 | 1213275 | 2021-04-12 | Pulaski | Illinois | 17153 | 678 | 7 |
1213276 | 1213276 | 2021-04-12 | Putnam | Illinois | 17155 | 438 | 4 |
1213277 | 1213277 | 2021-04-12 | Randolph | Illinois | 17157 | 4074 | 90 |
1213278 | 1213278 | 2021-04-12 | Richland | Illinois | 17159 | 1700 | 48 |
1213279 | 1213279 | 2021-04-12 | Rock Island | Illinois | 17161 | 14057 | 346 |
1213280 | 1213280 | 2021-04-12 | Saline | Illinois | 17165 | 2469 | 69 |
1213281 | 1213281 | 2021-04-12 | Sangamon | Illinois | 17167 | 17431 | 270 |
1213282 | 1213282 | 2021-04-12 | Schuyler | Illinois | 17169 | 690 | 17 |
1213283 | 1213283 | 2021-04-12 | Scott | Illinois | 17171 | 466 | 1 |
1213284 | 1213284 | 2021-04-12 | Shelby | Illinois | 17173 | 2235 | 40 |
1213285 | 1213285 | 2021-04-12 | St. Clair | Illinois | 17163 | 29782 | 543 |
1213286 | 1213286 | 2021-04-12 | Stark | Illinois | 17175 | 592 | 23 |
1213287 | 1213287 | 2021-04-12 | Stephenson | Illinois | 17177 | 4438 | 98 |
1213288 | 1213288 | 2021-04-12 | Tazewell | Illinois | 17179 | 15400 | 286 |
1213289 | 1213289 | 2021-04-12 | Union | Illinois | 17181 | 2228 | 44 |
1213290 | 1213290 | 2021-04-12 | Unknown | Illinois | 0 | 267 | |
1213291 | 1213291 | 2021-04-12 | Vermilion | Illinois | 17183 | 8969 | 140 |
1213292 | 1213292 | 2021-04-12 | Wabash | Illinois | 17185 | 1340 | 15 |
1213293 | 1213293 | 2021-04-12 | Warren | Illinois | 17187 | 1717 | 49 |
1213294 | 1213294 | 2021-04-12 | Washington | Illinois | 17189 | 1622 | 31 |
1213295 | 1213295 | 2021-04-12 | Wayne | Illinois | 17191 | 1720 | 52 |
1213296 | 1213296 | 2021-04-12 | White | Illinois | 17193 | 1661 | 36 |
1213297 | 1213297 | 2021-04-12 | Whiteside | Illinois | 17195 | 6750 | 203 |
1213298 | 1213298 | 2021-04-12 | Will | Illinois | 17197 | 70580 | 1027 |
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);