ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-10-16" 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 |
---|---|---|---|---|---|---|---|
635484 | 635484 | 2020-10-16 | Adams | Illinois | 17001 | 1558 | 14 |
635485 | 635485 | 2020-10-16 | Alexander | Illinois | 17003 | 105 | 1 |
635486 | 635486 | 2020-10-16 | Bond | Illinois | 17005 | 432 | 9 |
635487 | 635487 | 2020-10-16 | Boone | Illinois | 17007 | 1562 | 24 |
635488 | 635488 | 2020-10-16 | Brown | Illinois | 17009 | 94 | 0 |
635489 | 635489 | 2020-10-16 | Bureau | Illinois | 17011 | 827 | 16 |
635490 | 635490 | 2020-10-16 | Calhoun | Illinois | 17013 | 67 | 0 |
635491 | 635491 | 2020-10-16 | Carroll | Illinois | 17015 | 336 | 7 |
635492 | 635492 | 2020-10-16 | Cass | Illinois | 17017 | 445 | 11 |
635493 | 635493 | 2020-10-16 | Champaign | Illinois | 17019 | 5596 | 28 |
635494 | 635494 | 2020-10-16 | Christian | Illinois | 17021 | 747 | 26 |
635495 | 635495 | 2020-10-16 | Clark | Illinois | 17023 | 247 | 6 |
635496 | 635496 | 2020-10-16 | Clay | Illinois | 17025 | 268 | 11 |
635497 | 635497 | 2020-10-16 | Clinton | Illinois | 17027 | 1515 | 23 |
635498 | 635498 | 2020-10-16 | Coles | Illinois | 17029 | 1730 | 38 |
635499 | 635499 | 2020-10-16 | Cook | Illinois | 17031 | 160645 | 5340 |
635500 | 635500 | 2020-10-16 | Crawford | Illinois | 17033 | 608 | 6 |
635501 | 635501 | 2020-10-16 | Cumberland | Illinois | 17035 | 246 | 5 |
635502 | 635502 | 2020-10-16 | De Witt | Illinois | 17039 | 219 | 3 |
635503 | 635503 | 2020-10-16 | DeKalb | Illinois | 17037 | 2070 | 42 |
635504 | 635504 | 2020-10-16 | Douglas | Illinois | 17041 | 470 | 8 |
635505 | 635505 | 2020-10-16 | DuPage | Illinois | 17043 | 20277 | 595 |
635506 | 635506 | 2020-10-16 | Edgar | Illinois | 17045 | 136 | 8 |
635507 | 635507 | 2020-10-16 | Edwards | Illinois | 17047 | 93 | 0 |
635508 | 635508 | 2020-10-16 | Effingham | Illinois | 17049 | 1044 | 3 |
635509 | 635509 | 2020-10-16 | Fayette | Illinois | 17051 | 597 | 17 |
635510 | 635510 | 2020-10-16 | Ford | Illinois | 17053 | 162 | 9 |
635511 | 635511 | 2020-10-16 | Franklin | Illinois | 17055 | 801 | 6 |
635512 | 635512 | 2020-10-16 | Fulton | Illinois | 17057 | 364 | 0 |
635513 | 635513 | 2020-10-16 | Gallatin | Illinois | 17059 | 101 | 2 |
635514 | 635514 | 2020-10-16 | Greene | Illinois | 17061 | 260 | 15 |
635515 | 635515 | 2020-10-16 | Grundy | Illinois | 17063 | 838 | 7 |
635516 | 635516 | 2020-10-16 | Hamilton | Illinois | 17065 | 103 | 2 |
635517 | 635517 | 2020-10-16 | Hancock | Illinois | 17067 | 270 | 3 |
635518 | 635518 | 2020-10-16 | Hardin | Illinois | 17069 | 49 | 0 |
635519 | 635519 | 2020-10-16 | Henderson | Illinois | 17071 | 95 | 0 |
635520 | 635520 | 2020-10-16 | Henry | Illinois | 17073 | 785 | 5 |
635521 | 635521 | 2020-10-16 | Iroquois | Illinois | 17075 | 439 | 19 |
635522 | 635522 | 2020-10-16 | Jackson | Illinois | 17077 | 1410 | 25 |
635523 | 635523 | 2020-10-16 | Jasper | Illinois | 17079 | 237 | 10 |
635524 | 635524 | 2020-10-16 | Jefferson | Illinois | 17081 | 840 | 43 |
635525 | 635525 | 2020-10-16 | Jersey | Illinois | 17083 | 446 | 21 |
635526 | 635526 | 2020-10-16 | Jo Daviess | Illinois | 17085 | 392 | 5 |
635527 | 635527 | 2020-10-16 | Johnson | Illinois | 17087 | 298 | 0 |
635528 | 635528 | 2020-10-16 | Kane | Illinois | 17089 | 14989 | 338 |
635529 | 635529 | 2020-10-16 | Kankakee | Illinois | 17091 | 3115 | 78 |
635530 | 635530 | 2020-10-16 | Kendall | Illinois | 17093 | 2464 | 27 |
635531 | 635531 | 2020-10-16 | Knox | Illinois | 17095 | 1029 | 9 |
635532 | 635532 | 2020-10-16 | LaSalle | Illinois | 17099 | 2100 | 58 |
635533 | 635533 | 2020-10-16 | Lake | Illinois | 17097 | 19102 | 501 |
635534 | 635534 | 2020-10-16 | Lawrence | Illinois | 17101 | 302 | 8 |
635535 | 635535 | 2020-10-16 | Lee | Illinois | 17103 | 562 | 1 |
635536 | 635536 | 2020-10-16 | Livingston | Illinois | 17105 | 517 | 9 |
635537 | 635537 | 2020-10-16 | Logan | Illinois | 17107 | 526 | 4 |
635538 | 635538 | 2020-10-16 | Macon | Illinois | 17115 | 2371 | 48 |
635539 | 635539 | 2020-10-16 | Macoupin | Illinois | 17117 | 703 | 8 |
635540 | 635540 | 2020-10-16 | Madison | Illinois | 17119 | 6714 | 152 |
635541 | 635541 | 2020-10-16 | Marion | Illinois | 17121 | 814 | 11 |
635542 | 635542 | 2020-10-16 | Marshall | Illinois | 17123 | 132 | 3 |
635543 | 635543 | 2020-10-16 | Mason | Illinois | 17125 | 225 | 1 |
635544 | 635544 | 2020-10-16 | Massac | Illinois | 17127 | 136 | 2 |
635545 | 635545 | 2020-10-16 | McDonough | Illinois | 17109 | 621 | 15 |
635546 | 635546 | 2020-10-16 | McHenry | Illinois | 17111 | 5506 | 125 |
635547 | 635547 | 2020-10-16 | McLean | Illinois | 17113 | 3815 | 30 |
635548 | 635548 | 2020-10-16 | Menard | Illinois | 17129 | 156 | 1 |
635549 | 635549 | 2020-10-16 | Mercer | Illinois | 17131 | 205 | 6 |
635550 | 635550 | 2020-10-16 | Monroe | Illinois | 17133 | 829 | 27 |
635551 | 635551 | 2020-10-16 | Montgomery | Illinois | 17135 | 511 | 13 |
635552 | 635552 | 2020-10-16 | Morgan | Illinois | 17137 | 811 | 25 |
635553 | 635553 | 2020-10-16 | Moultrie | Illinois | 17139 | 333 | 5 |
635554 | 635554 | 2020-10-16 | Ogle | Illinois | 17141 | 1005 | 7 |
635555 | 635555 | 2020-10-16 | Peoria | Illinois | 17143 | 4178 | 59 |
635556 | 635556 | 2020-10-16 | Perry | Illinois | 17145 | 394 | 16 |
635557 | 635557 | 2020-10-16 | Piatt | Illinois | 17147 | 195 | 0 |
635558 | 635558 | 2020-10-16 | Pike | Illinois | 17149 | 230 | 2 |
635559 | 635559 | 2020-10-16 | Pope | Illinois | 17151 | 36 | 1 |
635560 | 635560 | 2020-10-16 | Pulaski | Illinois | 17153 | 218 | 1 |
635561 | 635561 | 2020-10-16 | Putnam | Illinois | 17155 | 81 | 0 |
635562 | 635562 | 2020-10-16 | Randolph | Illinois | 17157 | 1107 | 14 |
635563 | 635563 | 2020-10-16 | Richland | Illinois | 17159 | 306 | 14 |
635564 | 635564 | 2020-10-16 | Rock Island | Illinois | 17161 | 3653 | 97 |
635565 | 635565 | 2020-10-16 | Saline | Illinois | 17165 | 468 | 7 |
635566 | 635566 | 2020-10-16 | Sangamon | Illinois | 17167 | 3293 | 57 |
635567 | 635567 | 2020-10-16 | Schuyler | Illinois | 17169 | 78 | 1 |
635568 | 635568 | 2020-10-16 | Scott | Illinois | 17171 | 88 | 0 |
635569 | 635569 | 2020-10-16 | Shelby | Illinois | 17173 | 563 | 8 |
635570 | 635570 | 2020-10-16 | St. Clair | Illinois | 17163 | 8309 | 213 |
635571 | 635571 | 2020-10-16 | Stark | Illinois | 17175 | 78 | 2 |
635572 | 635572 | 2020-10-16 | Stephenson | Illinois | 17177 | 746 | 7 |
635573 | 635573 | 2020-10-16 | Tazewell | Illinois | 17179 | 2335 | 45 |
635574 | 635574 | 2020-10-16 | Union | Illinois | 17181 | 713 | 25 |
635575 | 635575 | 2020-10-16 | Unknown | Illinois | 3477 | 255 | |
635576 | 635576 | 2020-10-16 | Vermilion | Illinois | 17183 | 1444 | 7 |
635577 | 635577 | 2020-10-16 | Wabash | Illinois | 17185 | 200 | 5 |
635578 | 635578 | 2020-10-16 | Warren | Illinois | 17187 | 432 | 6 |
635579 | 635579 | 2020-10-16 | Washington | Illinois | 17189 | 271 | 1 |
635580 | 635580 | 2020-10-16 | Wayne | Illinois | 17191 | 422 | 9 |
635581 | 635581 | 2020-10-16 | White | Illinois | 17193 | 228 | 1 |
635582 | 635582 | 2020-10-16 | Whiteside | Illinois | 17195 | 1154 | 21 |
635583 | 635583 | 2020-10-16 | Will | Illinois | 17197 | 16321 | 414 |
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);