ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-09-30" 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 |
---|---|---|---|---|---|---|---|
583606 | 583606 | 2020-09-30 | Adams | Illinois | 17001 | 1199 | 10 |
583607 | 583607 | 2020-09-30 | Alexander | Illinois | 17003 | 85 | 1 |
583608 | 583608 | 2020-09-30 | Bond | Illinois | 17005 | 342 | 6 |
583609 | 583609 | 2020-09-30 | Boone | Illinois | 17007 | 1153 | 23 |
583610 | 583610 | 2020-09-30 | Brown | Illinois | 17009 | 69 | 0 |
583611 | 583611 | 2020-09-30 | Bureau | Illinois | 17011 | 671 | 12 |
583612 | 583612 | 2020-09-30 | Calhoun | Illinois | 17013 | 62 | 0 |
583613 | 583613 | 2020-09-30 | Carroll | Illinois | 17015 | 238 | 6 |
583614 | 583614 | 2020-09-30 | Cass | Illinois | 17017 | 404 | 11 |
583615 | 583615 | 2020-09-30 | Champaign | Illinois | 17019 | 4818 | 21 |
583616 | 583616 | 2020-09-30 | Christian | Illinois | 17021 | 565 | 12 |
583617 | 583617 | 2020-09-30 | Clark | Illinois | 17023 | 183 | 3 |
583618 | 583618 | 2020-09-30 | Clay | Illinois | 17025 | 159 | 0 |
583619 | 583619 | 2020-09-30 | Clinton | Illinois | 17027 | 1222 | 21 |
583620 | 583620 | 2020-09-30 | Coles | Illinois | 17029 | 1508 | 31 |
583621 | 583621 | 2020-09-30 | Cook | Illinois | 17031 | 145462 | 5225 |
583622 | 583622 | 2020-09-30 | Crawford | Illinois | 17033 | 466 | 4 |
583623 | 583623 | 2020-09-30 | Cumberland | Illinois | 17035 | 219 | 5 |
583624 | 583624 | 2020-09-30 | De Witt | Illinois | 17039 | 129 | 2 |
583625 | 583625 | 2020-09-30 | DeKalb | Illinois | 17037 | 1682 | 39 |
583626 | 583626 | 2020-09-30 | Douglas | Illinois | 17041 | 318 | 7 |
583627 | 583627 | 2020-09-30 | DuPage | Illinois | 17043 | 17786 | 563 |
583628 | 583628 | 2020-09-30 | Edgar | Illinois | 17045 | 116 | 8 |
583629 | 583629 | 2020-09-30 | Edwards | Illinois | 17047 | 68 | 0 |
583630 | 583630 | 2020-09-30 | Effingham | Illinois | 17049 | 883 | 3 |
583631 | 583631 | 2020-09-30 | Fayette | Illinois | 17051 | 437 | 6 |
583632 | 583632 | 2020-09-30 | Ford | Illinois | 17053 | 108 | 5 |
583633 | 583633 | 2020-09-30 | Franklin | Illinois | 17055 | 552 | 3 |
583634 | 583634 | 2020-09-30 | Fulton | Illinois | 17057 | 190 | 0 |
583635 | 583635 | 2020-09-30 | Gallatin | Illinois | 17059 | 75 | 2 |
583636 | 583636 | 2020-09-30 | Greene | Illinois | 17061 | 235 | 13 |
583637 | 583637 | 2020-09-30 | Grundy | Illinois | 17063 | 687 | 6 |
583638 | 583638 | 2020-09-30 | Hamilton | Illinois | 17065 | 74 | 2 |
583639 | 583639 | 2020-09-30 | Hancock | Illinois | 17067 | 228 | 3 |
583640 | 583640 | 2020-09-30 | Hardin | Illinois | 17069 | 39 | 0 |
583641 | 583641 | 2020-09-30 | Henderson | Illinois | 17071 | 71 | 0 |
583642 | 583642 | 2020-09-30 | Henry | Illinois | 17073 | 679 | 5 |
583643 | 583643 | 2020-09-30 | Iroquois | Illinois | 17075 | 368 | 19 |
583644 | 583644 | 2020-09-30 | Jackson | Illinois | 17077 | 1276 | 25 |
583645 | 583645 | 2020-09-30 | Jasper | Illinois | 17079 | 212 | 10 |
583646 | 583646 | 2020-09-30 | Jefferson | Illinois | 17081 | 641 | 38 |
583647 | 583647 | 2020-09-30 | Jersey | Illinois | 17083 | 398 | 17 |
583648 | 583648 | 2020-09-30 | Jo Daviess | Illinois | 17085 | 275 | 2 |
583649 | 583649 | 2020-09-30 | Johnson | Illinois | 17087 | 163 | 0 |
583650 | 583650 | 2020-09-30 | Kane | Illinois | 17089 | 13337 | 327 |
583651 | 583651 | 2020-09-30 | Kankakee | Illinois | 17091 | 2795 | 77 |
583652 | 583652 | 2020-09-30 | Kendall | Illinois | 17093 | 2120 | 26 |
583653 | 583653 | 2020-09-30 | Knox | Illinois | 17095 | 704 | 3 |
583654 | 583654 | 2020-09-30 | LaSalle | Illinois | 17099 | 1758 | 57 |
583655 | 583655 | 2020-09-30 | Lake | Illinois | 17097 | 17171 | 488 |
583656 | 583656 | 2020-09-30 | Lawrence | Illinois | 17101 | 263 | 3 |
583657 | 583657 | 2020-09-30 | Lee | Illinois | 17103 | 394 | 1 |
583658 | 583658 | 2020-09-30 | Livingston | Illinois | 17105 | 408 | 6 |
583659 | 583659 | 2020-09-30 | Logan | Illinois | 17107 | 469 | 1 |
583660 | 583660 | 2020-09-30 | Macon | Illinois | 17115 | 1636 | 45 |
583661 | 583661 | 2020-09-30 | Macoupin | Illinois | 17117 | 567 | 7 |
583662 | 583662 | 2020-09-30 | Madison | Illinois | 17119 | 5883 | 143 |
583663 | 583663 | 2020-09-30 | Marion | Illinois | 17121 | 573 | 2 |
583664 | 583664 | 2020-09-30 | Marshall | Illinois | 17123 | 111 | 0 |
583665 | 583665 | 2020-09-30 | Mason | Illinois | 17125 | 161 | 1 |
583666 | 583666 | 2020-09-30 | Massac | Illinois | 17127 | 117 | 2 |
583667 | 583667 | 2020-09-30 | McDonough | Illinois | 17109 | 490 | 15 |
583668 | 583668 | 2020-09-30 | McHenry | Illinois | 17111 | 4730 | 122 |
583669 | 583669 | 2020-09-30 | McLean | Illinois | 17113 | 3325 | 23 |
583670 | 583670 | 2020-09-30 | Menard | Illinois | 17129 | 128 | 1 |
583671 | 583671 | 2020-09-30 | Mercer | Illinois | 17131 | 141 | 5 |
583672 | 583672 | 2020-09-30 | Monroe | Illinois | 17133 | 690 | 16 |
583673 | 583673 | 2020-09-30 | Montgomery | Illinois | 17135 | 389 | 12 |
583674 | 583674 | 2020-09-30 | Morgan | Illinois | 17137 | 697 | 24 |
583675 | 583675 | 2020-09-30 | Moultrie | Illinois | 17139 | 222 | 4 |
583676 | 583676 | 2020-09-30 | Ogle | Illinois | 17141 | 780 | 6 |
583677 | 583677 | 2020-09-30 | Peoria | Illinois | 17143 | 3566 | 52 |
583678 | 583678 | 2020-09-30 | Perry | Illinois | 17145 | 358 | 15 |
583679 | 583679 | 2020-09-30 | Piatt | Illinois | 17147 | 143 | 0 |
583680 | 583680 | 2020-09-30 | Pike | Illinois | 17149 | 139 | 1 |
583681 | 583681 | 2020-09-30 | Pope | Illinois | 17151 | 30 | 1 |
583682 | 583682 | 2020-09-30 | Pulaski | Illinois | 17153 | 183 | 1 |
583683 | 583683 | 2020-09-30 | Putnam | Illinois | 17155 | 63 | 0 |
583684 | 583684 | 2020-09-30 | Randolph | Illinois | 17157 | 958 | 11 |
583685 | 583685 | 2020-09-30 | Richland | Illinois | 17159 | 220 | 6 |
583686 | 583686 | 2020-09-30 | Rock Island | Illinois | 17161 | 3157 | 85 |
583687 | 583687 | 2020-09-30 | Saline | Illinois | 17165 | 362 | 4 |
583688 | 583688 | 2020-09-30 | Sangamon | Illinois | 17167 | 2483 | 46 |
583689 | 583689 | 2020-09-30 | Schuyler | Illinois | 17169 | 50 | 0 |
583690 | 583690 | 2020-09-30 | Scott | Illinois | 17171 | 80 | 0 |
583691 | 583691 | 2020-09-30 | Shelby | Illinois | 17173 | 408 | 4 |
583692 | 583692 | 2020-09-30 | St. Clair | Illinois | 17163 | 7523 | 192 |
583693 | 583693 | 2020-09-30 | Stark | Illinois | 17175 | 56 | 2 |
583694 | 583694 | 2020-09-30 | Stephenson | Illinois | 17177 | 548 | 6 |
583695 | 583695 | 2020-09-30 | Tazewell | Illinois | 17179 | 1821 | 28 |
583696 | 583696 | 2020-09-30 | Union | Illinois | 17181 | 524 | 24 |
583697 | 583697 | 2020-09-30 | Unknown | Illinois | 2412 | 240 | |
583698 | 583698 | 2020-09-30 | Vermilion | Illinois | 17183 | 830 | 4 |
583699 | 583699 | 2020-09-30 | Wabash | Illinois | 17185 | 162 | 3 |
583700 | 583700 | 2020-09-30 | Warren | Illinois | 17187 | 334 | 2 |
583701 | 583701 | 2020-09-30 | Washington | Illinois | 17189 | 219 | 1 |
583702 | 583702 | 2020-09-30 | Wayne | Illinois | 17191 | 300 | 5 |
583703 | 583703 | 2020-09-30 | White | Illinois | 17193 | 176 | 0 |
583704 | 583704 | 2020-09-30 | Whiteside | Illinois | 17195 | 811 | 21 |
583705 | 583705 | 2020-09-30 | Will | Illinois | 17197 | 14280 | 384 |
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);