ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2020-06-21" 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 |
---|---|---|---|---|---|---|---|
259413 | 259413 | 2020-06-21 | Adams | Illinois | 17001 | 55 | 1 |
259414 | 259414 | 2020-06-21 | Alexander | Illinois | 17003 | 20 | 0 |
259415 | 259415 | 2020-06-21 | Bond | Illinois | 17005 | 12 | 1 |
259416 | 259416 | 2020-06-21 | Boone | Illinois | 17007 | 555 | 20 |
259417 | 259417 | 2020-06-21 | Brown | Illinois | 17009 | 10 | 0 |
259418 | 259418 | 2020-06-21 | Bureau | Illinois | 17011 | 24 | 1 |
259419 | 259419 | 2020-06-21 | Calhoun | Illinois | 17013 | 1 | 0 |
259420 | 259420 | 2020-06-21 | Carroll | Illinois | 17015 | 19 | 2 |
259421 | 259421 | 2020-06-21 | Cass | Illinois | 17017 | 100 | 0 |
259422 | 259422 | 2020-06-21 | Champaign | Illinois | 17019 | 775 | 12 |
259423 | 259423 | 2020-06-21 | Christian | Illinois | 17021 | 42 | 5 |
259424 | 259424 | 2020-06-21 | Clark | Illinois | 17023 | 13 | 0 |
259425 | 259425 | 2020-06-21 | Clay | Illinois | 17025 | 2 | 0 |
259426 | 259426 | 2020-06-21 | Clinton | Illinois | 17027 | 224 | 17 |
259427 | 259427 | 2020-06-21 | Coles | Illinois | 17029 | 151 | 17 |
259428 | 259428 | 2020-06-21 | Cook | Illinois | 17031 | 87177 | 4404 |
259429 | 259429 | 2020-06-21 | Crawford | Illinois | 17033 | 18 | 0 |
259430 | 259430 | 2020-06-21 | Cumberland | Illinois | 17035 | 10 | 0 |
259431 | 259431 | 2020-06-21 | De Witt | Illinois | 17039 | 4 | 0 |
259432 | 259432 | 2020-06-21 | DeKalb | Illinois | 17037 | 536 | 18 |
259433 | 259433 | 2020-06-21 | Douglas | Illinois | 17041 | 42 | 0 |
259434 | 259434 | 2020-06-21 | DuPage | Illinois | 17043 | 8684 | 448 |
259435 | 259435 | 2020-06-21 | Edgar | Illinois | 17045 | 6 | 0 |
259436 | 259436 | 2020-06-21 | Edwards | Illinois | 17047 | 2 | 0 |
259437 | 259437 | 2020-06-21 | Effingham | Illinois | 17049 | 12 | 1 |
259438 | 259438 | 2020-06-21 | Fayette | Illinois | 17051 | 23 | 3 |
259439 | 259439 | 2020-06-21 | Ford | Illinois | 17053 | 22 | 1 |
259440 | 259440 | 2020-06-21 | Franklin | Illinois | 17055 | 12 | 0 |
259441 | 259441 | 2020-06-21 | Fulton | Illinois | 17057 | 12 | 0 |
259442 | 259442 | 2020-06-21 | Gallatin | Illinois | 17059 | 2 | 0 |
259443 | 259443 | 2020-06-21 | Greene | Illinois | 17061 | 8 | 0 |
259444 | 259444 | 2020-06-21 | Grundy | Illinois | 17063 | 142 | 3 |
259445 | 259445 | 2020-06-21 | Hamilton | Illinois | 17065 | 2 | 0 |
259446 | 259446 | 2020-06-21 | Hancock | Illinois | 17067 | 18 | 1 |
259447 | 259447 | 2020-06-21 | Hardin | Illinois | 17069 | 1 | 0 |
259448 | 259448 | 2020-06-21 | Henderson | Illinois | 17071 | 8 | 0 |
259449 | 259449 | 2020-06-21 | Henry | Illinois | 17073 | 74 | 1 |
259450 | 259450 | 2020-06-21 | Iroquois | Illinois | 17075 | 143 | 5 |
259451 | 259451 | 2020-06-21 | Jackson | Illinois | 17077 | 323 | 18 |
259452 | 259452 | 2020-06-21 | Jasper | Illinois | 17079 | 46 | 7 |
259453 | 259453 | 2020-06-21 | Jefferson | Illinois | 17081 | 104 | 16 |
259454 | 259454 | 2020-06-21 | Jersey | Illinois | 17083 | 31 | 1 |
259455 | 259455 | 2020-06-21 | Jo Daviess | Illinois | 17085 | 38 | 1 |
259456 | 259456 | 2020-06-21 | Johnson | Illinois | 17087 | 20 | 0 |
259457 | 259457 | 2020-06-21 | Kane | Illinois | 17089 | 7461 | 251 |
259458 | 259458 | 2020-06-21 | Kankakee | Illinois | 17091 | 1234 | 61 |
259459 | 259459 | 2020-06-21 | Kendall | Illinois | 17093 | 946 | 22 |
259460 | 259460 | 2020-06-21 | Knox | Illinois | 17095 | 117 | 0 |
259461 | 259461 | 2020-06-21 | LaSalle | Illinois | 17099 | 190 | 16 |
259462 | 259462 | 2020-06-21 | Lake | Illinois | 17097 | 9326 | 401 |
259463 | 259463 | 2020-06-21 | Lawrence | Illinois | 17101 | 5 | 0 |
259464 | 259464 | 2020-06-21 | Lee | Illinois | 17103 | 96 | 1 |
259465 | 259465 | 2020-06-21 | Livingston | Illinois | 17105 | 37 | 2 |
259466 | 259466 | 2020-06-21 | Logan | Illinois | 17107 | 13 | 0 |
259467 | 259467 | 2020-06-21 | Macon | Illinois | 17115 | 218 | 21 |
259468 | 259468 | 2020-06-21 | Macoupin | Illinois | 17117 | 47 | 3 |
259469 | 259469 | 2020-06-21 | Madison | Illinois | 17119 | 813 | 66 |
259470 | 259470 | 2020-06-21 | Marion | Illinois | 17121 | 60 | 0 |
259471 | 259471 | 2020-06-21 | Marshall | Illinois | 17123 | 6 | 0 |
259472 | 259472 | 2020-06-21 | Mason | Illinois | 17125 | 19 | 0 |
259473 | 259473 | 2020-06-21 | Massac | Illinois | 17127 | 7 | 0 |
259474 | 259474 | 2020-06-21 | McDonough | Illinois | 17109 | 101 | 15 |
259475 | 259475 | 2020-06-21 | McHenry | Illinois | 17111 | 1911 | 91 |
259476 | 259476 | 2020-06-21 | McLean | Illinois | 17113 | 251 | 13 |
259477 | 259477 | 2020-06-21 | Menard | Illinois | 17129 | 23 | 0 |
259478 | 259478 | 2020-06-21 | Mercer | Illinois | 17131 | 20 | 0 |
259479 | 259479 | 2020-06-21 | Monroe | Illinois | 17133 | 113 | 12 |
259480 | 259480 | 2020-06-21 | Montgomery | Illinois | 17135 | 41 | 0 |
259481 | 259481 | 2020-06-21 | Morgan | Illinois | 17137 | 119 | 3 |
259482 | 259482 | 2020-06-21 | Moultrie | Illinois | 17139 | 15 | 0 |
259483 | 259483 | 2020-06-21 | Ogle | Illinois | 17141 | 241 | 4 |
259484 | 259484 | 2020-06-21 | Peoria | Illinois | 17143 | 428 | 25 |
259485 | 259485 | 2020-06-21 | Perry | Illinois | 17145 | 44 | 0 |
259486 | 259486 | 2020-06-21 | Piatt | Illinois | 17147 | 17 | 0 |
259487 | 259487 | 2020-06-21 | Pike | Illinois | 17149 | 2 | 0 |
259488 | 259488 | 2020-06-21 | Pope | Illinois | 17151 | 1 | 0 |
259489 | 259489 | 2020-06-21 | Pulaski | Illinois | 17153 | 66 | 0 |
259490 | 259490 | 2020-06-21 | Putnam | Illinois | 17155 | 1 | 0 |
259491 | 259491 | 2020-06-21 | Randolph | Illinois | 17157 | 278 | 7 |
259492 | 259492 | 2020-06-21 | Richland | Illinois | 17159 | 4 | 0 |
259493 | 259493 | 2020-06-21 | Rock Island | Illinois | 17161 | 807 | 28 |
259494 | 259494 | 2020-06-21 | Saline | Illinois | 17165 | 8 | 0 |
259495 | 259495 | 2020-06-21 | Sangamon | Illinois | 17167 | 389 | 33 |
259496 | 259496 | 2020-06-21 | Schuyler | Illinois | 17169 | 13 | 0 |
259497 | 259497 | 2020-06-21 | Shelby | Illinois | 17173 | 16 | 1 |
259498 | 259498 | 2020-06-21 | St. Clair | Illinois | 17163 | 1799 | 132 |
259499 | 259499 | 2020-06-21 | Stark | Illinois | 17175 | 3 | 0 |
259500 | 259500 | 2020-06-21 | Stephenson | Illinois | 17177 | 249 | 5 |
259501 | 259501 | 2020-06-21 | Tazewell | Illinois | 17179 | 112 | 7 |
259502 | 259502 | 2020-06-21 | Union | Illinois | 17181 | 182 | 18 |
259503 | 259503 | 2020-06-21 | Unknown | Illinois | 1000 | 204 | |
259504 | 259504 | 2020-06-21 | Vermilion | Illinois | 17183 | 49 | 2 |
259505 | 259505 | 2020-06-21 | Wabash | Illinois | 17185 | 22 | 0 |
259506 | 259506 | 2020-06-21 | Warren | Illinois | 17187 | 129 | 0 |
259507 | 259507 | 2020-06-21 | Washington | Illinois | 17189 | 19 | 0 |
259508 | 259508 | 2020-06-21 | Wayne | Illinois | 17191 | 11 | 1 |
259509 | 259509 | 2020-06-21 | White | Illinois | 17193 | 3 | 0 |
259510 | 259510 | 2020-06-21 | Whiteside | Illinois | 17195 | 172 | 15 |
259511 | 259511 | 2020-06-21 | Will | Illinois | 17197 | 6367 | 310 |
259512 | 259512 | 2020-06-21 | Williamson | Illinois | 17199 | 93 | 4 |
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);