ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-10-20" 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 |
---|---|---|---|---|---|---|---|
648469 | 648469 | 2020-10-20 | Adams | Illinois | 17001 | 1677 | 15 |
648470 | 648470 | 2020-10-20 | Alexander | Illinois | 17003 | 109 | 1 |
648471 | 648471 | 2020-10-20 | Bond | Illinois | 17005 | 471 | 9 |
648472 | 648472 | 2020-10-20 | Boone | Illinois | 17007 | 1687 | 25 |
648473 | 648473 | 2020-10-20 | Brown | Illinois | 17009 | 98 | 0 |
648474 | 648474 | 2020-10-20 | Bureau | Illinois | 17011 | 855 | 17 |
648475 | 648475 | 2020-10-20 | Calhoun | Illinois | 17013 | 67 | 0 |
648476 | 648476 | 2020-10-20 | Carroll | Illinois | 17015 | 367 | 8 |
648477 | 648477 | 2020-10-20 | Cass | Illinois | 17017 | 450 | 11 |
648478 | 648478 | 2020-10-20 | Champaign | Illinois | 17019 | 5741 | 28 |
648479 | 648479 | 2020-10-20 | Christian | Illinois | 17021 | 784 | 26 |
648480 | 648480 | 2020-10-20 | Clark | Illinois | 17023 | 272 | 9 |
648481 | 648481 | 2020-10-20 | Clay | Illinois | 17025 | 284 | 11 |
648482 | 648482 | 2020-10-20 | Clinton | Illinois | 17027 | 1631 | 24 |
648483 | 648483 | 2020-10-20 | Coles | Illinois | 17029 | 1798 | 38 |
648484 | 648484 | 2020-10-20 | Cook | Illinois | 17031 | 166457 | 5369 |
648485 | 648485 | 2020-10-20 | Crawford | Illinois | 17033 | 630 | 6 |
648486 | 648486 | 2020-10-20 | Cumberland | Illinois | 17035 | 258 | 6 |
648487 | 648487 | 2020-10-20 | De Witt | Illinois | 17039 | 233 | 3 |
648488 | 648488 | 2020-10-20 | DeKalb | Illinois | 17037 | 2209 | 42 |
648489 | 648489 | 2020-10-20 | Douglas | Illinois | 17041 | 563 | 8 |
648490 | 648490 | 2020-10-20 | DuPage | Illinois | 17043 | 21231 | 599 |
648491 | 648491 | 2020-10-20 | Edgar | Illinois | 17045 | 147 | 8 |
648492 | 648492 | 2020-10-20 | Edwards | Illinois | 17047 | 99 | 0 |
648493 | 648493 | 2020-10-20 | Effingham | Illinois | 17049 | 1095 | 3 |
648494 | 648494 | 2020-10-20 | Fayette | Illinois | 17051 | 638 | 21 |
648495 | 648495 | 2020-10-20 | Ford | Illinois | 17053 | 182 | 9 |
648496 | 648496 | 2020-10-20 | Franklin | Illinois | 17055 | 866 | 6 |
648497 | 648497 | 2020-10-20 | Fulton | Illinois | 17057 | 429 | 0 |
648498 | 648498 | 2020-10-20 | Gallatin | Illinois | 17059 | 105 | 2 |
648499 | 648499 | 2020-10-20 | Greene | Illinois | 17061 | 270 | 15 |
648500 | 648500 | 2020-10-20 | Grundy | Illinois | 17063 | 889 | 7 |
648501 | 648501 | 2020-10-20 | Hamilton | Illinois | 17065 | 114 | 2 |
648502 | 648502 | 2020-10-20 | Hancock | Illinois | 17067 | 285 | 3 |
648503 | 648503 | 2020-10-20 | Hardin | Illinois | 17069 | 49 | 0 |
648504 | 648504 | 2020-10-20 | Henderson | Illinois | 17071 | 111 | 0 |
648505 | 648505 | 2020-10-20 | Henry | Illinois | 17073 | 798 | 7 |
648506 | 648506 | 2020-10-20 | Iroquois | Illinois | 17075 | 459 | 19 |
648507 | 648507 | 2020-10-20 | Jackson | Illinois | 17077 | 1443 | 25 |
648508 | 648508 | 2020-10-20 | Jasper | Illinois | 17079 | 250 | 10 |
648509 | 648509 | 2020-10-20 | Jefferson | Illinois | 17081 | 867 | 44 |
648510 | 648510 | 2020-10-20 | Jersey | Illinois | 17083 | 456 | 21 |
648511 | 648511 | 2020-10-20 | Jo Daviess | Illinois | 17085 | 436 | 7 |
648512 | 648512 | 2020-10-20 | Johnson | Illinois | 17087 | 322 | 0 |
648513 | 648513 | 2020-10-20 | Kane | Illinois | 17089 | 15655 | 342 |
648514 | 648514 | 2020-10-20 | Kankakee | Illinois | 17091 | 3235 | 78 |
648515 | 648515 | 2020-10-20 | Kendall | Illinois | 17093 | 2540 | 28 |
648516 | 648516 | 2020-10-20 | Knox | Illinois | 17095 | 1151 | 9 |
648517 | 648517 | 2020-10-20 | LaSalle | Illinois | 17099 | 2207 | 60 |
648518 | 648518 | 2020-10-20 | Lake | Illinois | 17097 | 19758 | 506 |
648519 | 648519 | 2020-10-20 | Lawrence | Illinois | 17101 | 306 | 8 |
648520 | 648520 | 2020-10-20 | Lee | Illinois | 17103 | 627 | 1 |
648521 | 648521 | 2020-10-20 | Livingston | Illinois | 17105 | 557 | 10 |
648522 | 648522 | 2020-10-20 | Logan | Illinois | 17107 | 547 | 4 |
648523 | 648523 | 2020-10-20 | Macon | Illinois | 17115 | 2633 | 48 |
648524 | 648524 | 2020-10-20 | Macoupin | Illinois | 17117 | 741 | 10 |
648525 | 648525 | 2020-10-20 | Madison | Illinois | 17119 | 6904 | 152 |
648526 | 648526 | 2020-10-20 | Marion | Illinois | 17121 | 866 | 13 |
648527 | 648527 | 2020-10-20 | Marshall | Illinois | 17123 | 140 | 3 |
648528 | 648528 | 2020-10-20 | Mason | Illinois | 17125 | 238 | 1 |
648529 | 648529 | 2020-10-20 | Massac | Illinois | 17127 | 141 | 2 |
648530 | 648530 | 2020-10-20 | McDonough | Illinois | 17109 | 668 | 15 |
648531 | 648531 | 2020-10-20 | McHenry | Illinois | 17111 | 5851 | 125 |
648532 | 648532 | 2020-10-20 | McLean | Illinois | 17113 | 3918 | 31 |
648533 | 648533 | 2020-10-20 | Menard | Illinois | 17129 | 165 | 1 |
648534 | 648534 | 2020-10-20 | Mercer | Illinois | 17131 | 225 | 6 |
648535 | 648535 | 2020-10-20 | Monroe | Illinois | 17133 | 861 | 28 |
648536 | 648536 | 2020-10-20 | Montgomery | Illinois | 17135 | 555 | 14 |
648537 | 648537 | 2020-10-20 | Morgan | Illinois | 17137 | 840 | 25 |
648538 | 648538 | 2020-10-20 | Moultrie | Illinois | 17139 | 378 | 5 |
648539 | 648539 | 2020-10-20 | Ogle | Illinois | 17141 | 1092 | 7 |
648540 | 648540 | 2020-10-20 | Peoria | Illinois | 17143 | 4321 | 64 |
648541 | 648541 | 2020-10-20 | Perry | Illinois | 17145 | 409 | 16 |
648542 | 648542 | 2020-10-20 | Piatt | Illinois | 17147 | 218 | 0 |
648543 | 648543 | 2020-10-20 | Pike | Illinois | 17149 | 267 | 4 |
648544 | 648544 | 2020-10-20 | Pope | Illinois | 17151 | 36 | 1 |
648545 | 648545 | 2020-10-20 | Pulaski | Illinois | 17153 | 226 | 1 |
648546 | 648546 | 2020-10-20 | Putnam | Illinois | 17155 | 86 | 0 |
648547 | 648547 | 2020-10-20 | Randolph | Illinois | 17157 | 1159 | 14 |
648548 | 648548 | 2020-10-20 | Richland | Illinois | 17159 | 318 | 15 |
648549 | 648549 | 2020-10-20 | Rock Island | Illinois | 17161 | 3837 | 97 |
648550 | 648550 | 2020-10-20 | Saline | Illinois | 17165 | 505 | 7 |
648551 | 648551 | 2020-10-20 | Sangamon | Illinois | 17167 | 3556 | 62 |
648552 | 648552 | 2020-10-20 | Schuyler | Illinois | 17169 | 80 | 1 |
648553 | 648553 | 2020-10-20 | Scott | Illinois | 17171 | 95 | 0 |
648554 | 648554 | 2020-10-20 | Shelby | Illinois | 17173 | 592 | 8 |
648555 | 648555 | 2020-10-20 | St. Clair | Illinois | 17163 | 8541 | 217 |
648556 | 648556 | 2020-10-20 | Stark | Illinois | 17175 | 80 | 2 |
648557 | 648557 | 2020-10-20 | Stephenson | Illinois | 17177 | 820 | 7 |
648558 | 648558 | 2020-10-20 | Tazewell | Illinois | 17179 | 2467 | 50 |
648559 | 648559 | 2020-10-20 | Union | Illinois | 17181 | 738 | 25 |
648560 | 648560 | 2020-10-20 | Unknown | Illinois | 3462 | 255 | |
648561 | 648561 | 2020-10-20 | Vermilion | Illinois | 17183 | 1562 | 7 |
648562 | 648562 | 2020-10-20 | Wabash | Illinois | 17185 | 210 | 5 |
648563 | 648563 | 2020-10-20 | Warren | Illinois | 17187 | 464 | 7 |
648564 | 648564 | 2020-10-20 | Washington | Illinois | 17189 | 277 | 1 |
648565 | 648565 | 2020-10-20 | Wayne | Illinois | 17191 | 440 | 11 |
648566 | 648566 | 2020-10-20 | White | Illinois | 17193 | 235 | 1 |
648567 | 648567 | 2020-10-20 | Whiteside | Illinois | 17195 | 1244 | 22 |
648568 | 648568 | 2020-10-20 | Will | Illinois | 17197 | 17309 | 424 |
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);