ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-07-19" 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 |
---|---|---|---|---|---|---|---|
1531345 | 1531345 | 2021-07-19 | Adams | Illinois | 17001 | 9229 | 156 |
1531346 | 1531346 | 2021-07-19 | Alexander | Illinois | 17003 | 479 | 11 |
1531347 | 1531347 | 2021-07-19 | Bond | Illinois | 17005 | 2107 | 30 |
1531348 | 1531348 | 2021-07-19 | Boone | Illinois | 17007 | 6894 | 92 |
1531349 | 1531349 | 2021-07-19 | Brown | Illinois | 17009 | 794 | 12 |
1531350 | 1531350 | 2021-07-19 | Bureau | Illinois | 17011 | 3826 | 100 |
1531351 | 1531351 | 2021-07-19 | Calhoun | Illinois | 17013 | 532 | 5 |
1531352 | 1531352 | 2021-07-19 | Carroll | Illinois | 17015 | 2039 | 38 |
1531353 | 1531353 | 2021-07-19 | Cass | Illinois | 17017 | 2087 | 36 |
1531354 | 1531354 | 2021-07-19 | Champaign | Illinois | 17019 | 21328 | 166 |
1531355 | 1531355 | 2021-07-19 | Christian | Illinois | 17021 | 3899 | 93 |
1531356 | 1531356 | 2021-07-19 | Clark | Illinois | 17023 | 1885 | 42 |
1531357 | 1531357 | 2021-07-19 | Clay | Illinois | 17025 | 1525 | 48 |
1531358 | 1531358 | 2021-07-19 | Clinton | Illinois | 17027 | 5838 | 101 |
1531359 | 1531359 | 2021-07-19 | Coles | Illinois | 17029 | 5818 | 103 |
1531360 | 1531360 | 2021-07-19 | Cook | Illinois | 17031 | 559767 | 11102 |
1531361 | 1531361 | 2021-07-19 | Crawford | Illinois | 17033 | 2151 | 42 |
1531362 | 1531362 | 2021-07-19 | Cumberland | Illinois | 17035 | 1308 | 31 |
1531363 | 1531363 | 2021-07-19 | De Witt | Illinois | 17039 | 1594 | 36 |
1531364 | 1531364 | 2021-07-19 | DeKalb | Illinois | 17037 | 10441 | 127 |
1531365 | 1531365 | 2021-07-19 | Douglas | Illinois | 17041 | 2618 | 42 |
1531366 | 1531366 | 2021-07-19 | DuPage | Illinois | 17043 | 93057 | 1406 |
1531367 | 1531367 | 2021-07-19 | Edgar | Illinois | 17045 | 1777 | 62 |
1531368 | 1531368 | 2021-07-19 | Edwards | Illinois | 17047 | 605 | 13 |
1531369 | 1531369 | 2021-07-19 | Effingham | Illinois | 17049 | 4788 | 85 |
1531370 | 1531370 | 2021-07-19 | Fayette | Illinois | 17051 | 3241 | 59 |
1531371 | 1531371 | 2021-07-19 | Ford | Illinois | 17053 | 1913 | 58 |
1531372 | 1531372 | 2021-07-19 | Franklin | Illinois | 17055 | 4709 | 90 |
1531373 | 1531373 | 2021-07-19 | Fulton | Illinois | 17057 | 4083 | 67 |
1531374 | 1531374 | 2021-07-19 | Gallatin | Illinois | 17059 | 472 | 5 |
1531375 | 1531375 | 2021-07-19 | Greene | Illinois | 17061 | 1489 | 47 |
1531376 | 1531376 | 2021-07-19 | Grundy | Illinois | 17063 | 6019 | 83 |
1531377 | 1531377 | 2021-07-19 | Hamilton | Illinois | 17065 | 866 | 19 |
1531378 | 1531378 | 2021-07-19 | Hancock | Illinois | 17067 | 1881 | 42 |
1531379 | 1531379 | 2021-07-19 | Hardin | Illinois | 17069 | 393 | 12 |
1531380 | 1531380 | 2021-07-19 | Henderson | Illinois | 17071 | 534 | 23 |
1531381 | 1531381 | 2021-07-19 | Henry | Illinois | 17073 | 5107 | 99 |
1531382 | 1531382 | 2021-07-19 | Iroquois | Illinois | 17075 | 3230 | 70 |
1531383 | 1531383 | 2021-07-19 | Jackson | Illinois | 17077 | 5285 | 76 |
1531384 | 1531384 | 2021-07-19 | Jasper | Illinois | 17079 | 1168 | 20 |
1531385 | 1531385 | 2021-07-19 | Jefferson | Illinois | 17081 | 4576 | 124 |
1531386 | 1531386 | 2021-07-19 | Jersey | Illinois | 17083 | 2750 | 71 |
1531387 | 1531387 | 2021-07-19 | Jo Daviess | Illinois | 17085 | 1830 | 27 |
1531388 | 1531388 | 2021-07-19 | Johnson | Illinois | 17087 | 1510 | 22 |
1531389 | 1531389 | 2021-07-19 | Kane | Illinois | 17089 | 59800 | 867 |
1531390 | 1531390 | 2021-07-19 | Kankakee | Illinois | 17091 | 14693 | 231 |
1531391 | 1531391 | 2021-07-19 | Kendall | Illinois | 17093 | 13977 | 109 |
1531392 | 1531392 | 2021-07-19 | Knox | Illinois | 17095 | 5703 | 187 |
1531393 | 1531393 | 2021-07-19 | LaSalle | Illinois | 17099 | 12872 | 308 |
1531394 | 1531394 | 2021-07-19 | Lake | Illinois | 17097 | 68816 | 1097 |
1531395 | 1531395 | 2021-07-19 | Lawrence | Illinois | 17101 | 2423 | 36 |
1531396 | 1531396 | 2021-07-19 | Lee | Illinois | 17103 | 4211 | 93 |
1531397 | 1531397 | 2021-07-19 | Livingston | Illinois | 17105 | 4922 | 104 |
1531398 | 1531398 | 2021-07-19 | Logan | Illinois | 17107 | 4040 | 78 |
1531399 | 1531399 | 2021-07-19 | Macon | Illinois | 17115 | 11073 | 224 |
1531400 | 1531400 | 2021-07-19 | Macoupin | Illinois | 17117 | 4894 | 118 |
1531401 | 1531401 | 2021-07-19 | Madison | Illinois | 17119 | 31822 | 606 |
1531402 | 1531402 | 2021-07-19 | Marion | Illinois | 17121 | 4646 | 123 |
1531403 | 1531403 | 2021-07-19 | Marshall | Illinois | 17123 | 1093 | 21 |
1531404 | 1531404 | 2021-07-19 | Mason | Illinois | 17125 | 1610 | 48 |
1531405 | 1531405 | 2021-07-19 | Massac | Illinois | 17127 | 1387 | 43 |
1531406 | 1531406 | 2021-07-19 | McDonough | Illinois | 17109 | 3009 | 63 |
1531407 | 1531407 | 2021-07-19 | McHenry | Illinois | 17111 | 29377 | 325 |
1531408 | 1531408 | 2021-07-19 | McLean | Illinois | 17113 | 18712 | 229 |
1531409 | 1531409 | 2021-07-19 | Menard | Illinois | 17129 | 1267 | 16 |
1531410 | 1531410 | 2021-07-19 | Mercer | Illinois | 17131 | 1512 | 34 |
1531411 | 1531411 | 2021-07-19 | Monroe | Illinois | 17133 | 4448 | 94 |
1531412 | 1531412 | 2021-07-19 | Montgomery | Illinois | 17135 | 3823 | 80 |
1531413 | 1531413 | 2021-07-19 | Morgan | Illinois | 17137 | 4195 | 114 |
1531414 | 1531414 | 2021-07-19 | Moultrie | Illinois | 17139 | 1656 | 36 |
1531415 | 1531415 | 2021-07-19 | Ogle | Illinois | 17141 | 6264 | 92 |
1531416 | 1531416 | 2021-07-19 | Peoria | Illinois | 17143 | 23614 | 372 |
1531417 | 1531417 | 2021-07-19 | Perry | Illinois | 17145 | 3246 | 69 |
1531418 | 1531418 | 2021-07-19 | Piatt | Illinois | 17147 | 1546 | 20 |
1531419 | 1531419 | 2021-07-19 | Pike | Illinois | 17149 | 1929 | 56 |
1531420 | 1531420 | 2021-07-19 | Pope | Illinois | 17151 | 336 | 4 |
1531421 | 1531421 | 2021-07-19 | Pulaski | Illinois | 17153 | 716 | 7 |
1531422 | 1531422 | 2021-07-19 | Putnam | Illinois | 17155 | 492 | 4 |
1531423 | 1531423 | 2021-07-19 | Randolph | Illinois | 17157 | 4244 | 93 |
1531424 | 1531424 | 2021-07-19 | Richland | Illinois | 17159 | 1782 | 49 |
1531425 | 1531425 | 2021-07-19 | Rock Island | Illinois | 17161 | 15305 | 372 |
1531426 | 1531426 | 2021-07-19 | Saline | Illinois | 17165 | 2657 | 73 |
1531427 | 1531427 | 2021-07-19 | Sangamon | Illinois | 17167 | 19372 | 284 |
1531428 | 1531428 | 2021-07-19 | Schuyler | Illinois | 17169 | 802 | 19 |
1531429 | 1531429 | 2021-07-19 | Scott | Illinois | 17171 | 500 | 1 |
1531430 | 1531430 | 2021-07-19 | Shelby | Illinois | 17173 | 2342 | 41 |
1531431 | 1531431 | 2021-07-19 | St. Clair | Illinois | 17163 | 32171 | 570 |
1531432 | 1531432 | 2021-07-19 | Stark | Illinois | 17175 | 652 | 24 |
1531433 | 1531433 | 2021-07-19 | Stephenson | Illinois | 17177 | 4866 | 105 |
1531434 | 1531434 | 2021-07-19 | Tazewell | Illinois | 17179 | 17346 | 341 |
1531435 | 1531435 | 2021-07-19 | Union | Illinois | 17181 | 2397 | 45 |
1531436 | 1531436 | 2021-07-19 | Unknown | Illinois | 0 | 436 | |
1531437 | 1531437 | 2021-07-19 | Vermilion | Illinois | 17183 | 10136 | 169 |
1531438 | 1531438 | 2021-07-19 | Wabash | Illinois | 17185 | 1425 | 15 |
1531439 | 1531439 | 2021-07-19 | Warren | Illinois | 17187 | 1859 | 53 |
1531440 | 1531440 | 2021-07-19 | Washington | Illinois | 17189 | 1673 | 31 |
1531441 | 1531441 | 2021-07-19 | Wayne | Illinois | 17191 | 1839 | 54 |
1531442 | 1531442 | 2021-07-19 | White | Illinois | 17193 | 1738 | 36 |
1531443 | 1531443 | 2021-07-19 | Whiteside | Illinois | 17195 | 7319 | 216 |
1531444 | 1531444 | 2021-07-19 | Will | Illinois | 17197 | 77454 | 1115 |
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);