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-07-31 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 |
---|---|---|---|---|---|---|---|
1570314 | 1570314 | 2021-07-31 | Adams | Illinois | 17001 | 9751 | 158 |
1570315 | 1570315 | 2021-07-31 | Alexander | Illinois | 17003 | 495 | 11 |
1570316 | 1570316 | 2021-07-31 | Bond | Illinois | 17005 | 2139 | 29 |
1570317 | 1570317 | 2021-07-31 | Boone | Illinois | 17007 | 6965 | 92 |
1570318 | 1570318 | 2021-07-31 | Brown | Illinois | 17009 | 813 | 12 |
1570319 | 1570319 | 2021-07-31 | Bureau | Illinois | 17011 | 3866 | 100 |
1570320 | 1570320 | 2021-07-31 | Calhoun | Illinois | 17013 | 544 | 5 |
1570321 | 1570321 | 2021-07-31 | Carroll | Illinois | 17015 | 2054 | 38 |
1570322 | 1570322 | 2021-07-31 | Cass | Illinois | 17017 | 2115 | 36 |
1570323 | 1570323 | 2021-07-31 | Champaign | Illinois | 17019 | 21705 | 167 |
1570324 | 1570324 | 2021-07-31 | Christian | Illinois | 17021 | 3975 | 93 |
1570325 | 1570325 | 2021-07-31 | Clark | Illinois | 17023 | 1913 | 42 |
1570326 | 1570326 | 2021-07-31 | Clay | Illinois | 17025 | 1563 | 48 |
1570327 | 1570327 | 2021-07-31 | Clinton | Illinois | 17027 | 5942 | 102 |
1570328 | 1570328 | 2021-07-31 | Coles | Illinois | 17029 | 5887 | 103 |
1570329 | 1570329 | 2021-07-31 | Cook | Illinois | 17031 | 564091 | 11121 |
1570330 | 1570330 | 2021-07-31 | Crawford | Illinois | 17033 | 2211 | 42 |
1570331 | 1570331 | 2021-07-31 | Cumberland | Illinois | 17035 | 1314 | 32 |
1570332 | 1570332 | 2021-07-31 | De Witt | Illinois | 17039 | 1615 | 36 |
1570333 | 1570333 | 2021-07-31 | DeKalb | Illinois | 17037 | 10553 | 127 |
1570334 | 1570334 | 2021-07-31 | Douglas | Illinois | 17041 | 2654 | 42 |
1570335 | 1570335 | 2021-07-31 | DuPage | Illinois | 17043 | 94007 | 1406 |
1570336 | 1570336 | 2021-07-31 | Edgar | Illinois | 17045 | 1809 | 62 |
1570337 | 1570337 | 2021-07-31 | Edwards | Illinois | 17047 | 642 | 13 |
1570338 | 1570338 | 2021-07-31 | Effingham | Illinois | 17049 | 4839 | 85 |
1570339 | 1570339 | 2021-07-31 | Fayette | Illinois | 17051 | 3274 | 59 |
1570340 | 1570340 | 2021-07-31 | Ford | Illinois | 17053 | 1954 | 58 |
1570341 | 1570341 | 2021-07-31 | Franklin | Illinois | 17055 | 4928 | 91 |
1570342 | 1570342 | 2021-07-31 | Fulton | Illinois | 17057 | 4121 | 67 |
1570343 | 1570343 | 2021-07-31 | Gallatin | Illinois | 17059 | 514 | 5 |
1570344 | 1570344 | 2021-07-31 | Greene | Illinois | 17061 | 1557 | 47 |
1570345 | 1570345 | 2021-07-31 | Grundy | Illinois | 17063 | 6074 | 83 |
1570346 | 1570346 | 2021-07-31 | Hamilton | Illinois | 17065 | 917 | 19 |
1570347 | 1570347 | 2021-07-31 | Hancock | Illinois | 17067 | 1949 | 42 |
1570348 | 1570348 | 2021-07-31 | Hardin | Illinois | 17069 | 397 | 12 |
1570349 | 1570349 | 2021-07-31 | Henderson | Illinois | 17071 | 534 | 23 |
1570350 | 1570350 | 2021-07-31 | Henry | Illinois | 17073 | 5171 | 99 |
1570351 | 1570351 | 2021-07-31 | Iroquois | Illinois | 17075 | 3310 | 70 |
1570352 | 1570352 | 2021-07-31 | Jackson | Illinois | 17077 | 5512 | 76 |
1570353 | 1570353 | 2021-07-31 | Jasper | Illinois | 17079 | 1170 | 20 |
1570354 | 1570354 | 2021-07-31 | Jefferson | Illinois | 17081 | 4703 | 124 |
1570355 | 1570355 | 2021-07-31 | Jersey | Illinois | 17083 | 2802 | 71 |
1570356 | 1570356 | 2021-07-31 | Jo Daviess | Illinois | 17085 | 1840 | 27 |
1570357 | 1570357 | 2021-07-31 | Johnson | Illinois | 17087 | 1567 | 22 |
1570358 | 1570358 | 2021-07-31 | Kane | Illinois | 17089 | 60205 | 868 |
1570359 | 1570359 | 2021-07-31 | Kankakee | Illinois | 17091 | 14768 | 232 |
1570360 | 1570360 | 2021-07-31 | Kendall | Illinois | 17093 | 14083 | 109 |
1570361 | 1570361 | 2021-07-31 | Knox | Illinois | 17095 | 5743 | 188 |
1570362 | 1570362 | 2021-07-31 | LaSalle | Illinois | 17099 | 12987 | 309 |
1570363 | 1570363 | 2021-07-31 | Lake | Illinois | 17097 | 69363 | 1099 |
1570364 | 1570364 | 2021-07-31 | Lawrence | Illinois | 17101 | 2455 | 36 |
1570365 | 1570365 | 2021-07-31 | Lee | Illinois | 17103 | 4243 | 93 |
1570366 | 1570366 | 2021-07-31 | Livingston | Illinois | 17105 | 4951 | 106 |
1570367 | 1570367 | 2021-07-31 | Logan | Illinois | 17107 | 4100 | 79 |
1570368 | 1570368 | 2021-07-31 | Macon | Illinois | 17115 | 11214 | 225 |
1570369 | 1570369 | 2021-07-31 | Macoupin | Illinois | 17117 | 5010 | 119 |
1570370 | 1570370 | 2021-07-31 | Madison | Illinois | 17119 | 32649 | 609 |
1570371 | 1570371 | 2021-07-31 | Marion | Illinois | 17121 | 4836 | 124 |
1570372 | 1570372 | 2021-07-31 | Marshall | Illinois | 17123 | 1114 | 21 |
1570373 | 1570373 | 2021-07-31 | Mason | Illinois | 17125 | 1648 | 48 |
1570374 | 1570374 | 2021-07-31 | Massac | Illinois | 17127 | 1461 | 44 |
1570375 | 1570375 | 2021-07-31 | McDonough | Illinois | 17109 | 3085 | 63 |
1570376 | 1570376 | 2021-07-31 | McHenry | Illinois | 17111 | 29684 | 325 |
1570377 | 1570377 | 2021-07-31 | McLean | Illinois | 17113 | 18931 | 230 |
1570378 | 1570378 | 2021-07-31 | Menard | Illinois | 17129 | 1287 | 16 |
1570379 | 1570379 | 2021-07-31 | Mercer | Illinois | 17131 | 1525 | 34 |
1570380 | 1570380 | 2021-07-31 | Monroe | Illinois | 17133 | 4535 | 94 |
1570381 | 1570381 | 2021-07-31 | Montgomery | Illinois | 17135 | 3866 | 80 |
1570382 | 1570382 | 2021-07-31 | Morgan | Illinois | 17137 | 4258 | 114 |
1570383 | 1570383 | 2021-07-31 | Moultrie | Illinois | 17139 | 1687 | 36 |
1570384 | 1570384 | 2021-07-31 | Ogle | Illinois | 17141 | 6305 | 92 |
1570385 | 1570385 | 2021-07-31 | Peoria | Illinois | 17143 | 23852 | 375 |
1570386 | 1570386 | 2021-07-31 | Perry | Illinois | 17145 | 3302 | 71 |
1570387 | 1570387 | 2021-07-31 | Piatt | Illinois | 17147 | 1569 | 20 |
1570388 | 1570388 | 2021-07-31 | Pike | Illinois | 17149 | 2032 | 56 |
1570389 | 1570389 | 2021-07-31 | Pope | Illinois | 17151 | 346 | 4 |
1570390 | 1570390 | 2021-07-31 | Pulaski | Illinois | 17153 | 749 | 7 |
1570391 | 1570391 | 2021-07-31 | Putnam | Illinois | 17155 | 495 | 4 |
1570392 | 1570392 | 2021-07-31 | Randolph | Illinois | 17157 | 4339 | 93 |
1570393 | 1570393 | 2021-07-31 | Richland | Illinois | 17159 | 1828 | 49 |
1570394 | 1570394 | 2021-07-31 | Rock Island | Illinois | 17161 | 15422 | 372 |
1570395 | 1570395 | 2021-07-31 | Saline | Illinois | 17165 | 2740 | 73 |
1570396 | 1570396 | 2021-07-31 | Sangamon | Illinois | 17167 | 19759 | 287 |
1570397 | 1570397 | 2021-07-31 | Schuyler | Illinois | 17169 | 818 | 19 |
1570398 | 1570398 | 2021-07-31 | Scott | Illinois | 17171 | 518 | 1 |
1570399 | 1570399 | 2021-07-31 | Shelby | Illinois | 17173 | 2374 | 41 |
1570400 | 1570400 | 2021-07-31 | St. Clair | Illinois | 17163 | 33221 | 571 |
1570401 | 1570401 | 2021-07-31 | Stark | Illinois | 17175 | 669 | 25 |
1570402 | 1570402 | 2021-07-31 | Stephenson | Illinois | 17177 | 4898 | 105 |
1570403 | 1570403 | 2021-07-31 | Tazewell | Illinois | 17179 | 17551 | 343 |
1570404 | 1570404 | 2021-07-31 | Union | Illinois | 17181 | 2518 | 46 |
1570405 | 1570405 | 2021-07-31 | Unknown | Illinois | 0 | 453 | |
1570406 | 1570406 | 2021-07-31 | Vermilion | Illinois | 17183 | 10297 | 171 |
1570407 | 1570407 | 2021-07-31 | Wabash | Illinois | 17185 | 1506 | 15 |
1570408 | 1570408 | 2021-07-31 | Warren | Illinois | 17187 | 1868 | 53 |
1570409 | 1570409 | 2021-07-31 | Washington | Illinois | 17189 | 1701 | 31 |
1570410 | 1570410 | 2021-07-31 | Wayne | Illinois | 17191 | 1920 | 54 |
1570411 | 1570411 | 2021-07-31 | White | Illinois | 17193 | 1833 | 36 |
1570412 | 1570412 | 2021-07-31 | Whiteside | Illinois | 17195 | 7347 | 216 |
1570413 | 1570413 | 2021-07-31 | Will | Illinois | 17197 | 78328 | 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);