ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-07-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 |
---|---|---|---|---|---|---|---|
1534592 | 1534592 | 2021-07-20 | Adams | Illinois | 17001 | 9269 | 156 |
1534593 | 1534593 | 2021-07-20 | Alexander | Illinois | 17003 | 483 | 11 |
1534594 | 1534594 | 2021-07-20 | Bond | Illinois | 17005 | 2108 | 30 |
1534595 | 1534595 | 2021-07-20 | Boone | Illinois | 17007 | 6895 | 92 |
1534596 | 1534596 | 2021-07-20 | Brown | Illinois | 17009 | 797 | 12 |
1534597 | 1534597 | 2021-07-20 | Bureau | Illinois | 17011 | 3830 | 100 |
1534598 | 1534598 | 2021-07-20 | Calhoun | Illinois | 17013 | 533 | 5 |
1534599 | 1534599 | 2021-07-20 | Carroll | Illinois | 17015 | 2037 | 38 |
1534600 | 1534600 | 2021-07-20 | Cass | Illinois | 17017 | 2088 | 36 |
1534601 | 1534601 | 2021-07-20 | Champaign | Illinois | 17019 | 21361 | 166 |
1534602 | 1534602 | 2021-07-20 | Christian | Illinois | 17021 | 3906 | 93 |
1534603 | 1534603 | 2021-07-20 | Clark | Illinois | 17023 | 1886 | 42 |
1534604 | 1534604 | 2021-07-20 | Clay | Illinois | 17025 | 1526 | 48 |
1534605 | 1534605 | 2021-07-20 | Clinton | Illinois | 17027 | 5842 | 101 |
1534606 | 1534606 | 2021-07-20 | Coles | Illinois | 17029 | 5822 | 103 |
1534607 | 1534607 | 2021-07-20 | Cook | Illinois | 17031 | 559884 | 11105 |
1534608 | 1534608 | 2021-07-20 | Crawford | Illinois | 17033 | 2155 | 42 |
1534609 | 1534609 | 2021-07-20 | Cumberland | Illinois | 17035 | 1309 | 31 |
1534610 | 1534610 | 2021-07-20 | De Witt | Illinois | 17039 | 1597 | 36 |
1534611 | 1534611 | 2021-07-20 | DeKalb | Illinois | 17037 | 10446 | 127 |
1534612 | 1534612 | 2021-07-20 | Douglas | Illinois | 17041 | 2621 | 42 |
1534613 | 1534613 | 2021-07-20 | DuPage | Illinois | 17043 | 93095 | 1406 |
1534614 | 1534614 | 2021-07-20 | Edgar | Illinois | 17045 | 1778 | 62 |
1534615 | 1534615 | 2021-07-20 | Edwards | Illinois | 17047 | 607 | 13 |
1534616 | 1534616 | 2021-07-20 | Effingham | Illinois | 17049 | 4792 | 85 |
1534617 | 1534617 | 2021-07-20 | Fayette | Illinois | 17051 | 3242 | 59 |
1534618 | 1534618 | 2021-07-20 | Ford | Illinois | 17053 | 1914 | 58 |
1534619 | 1534619 | 2021-07-20 | Franklin | Illinois | 17055 | 4714 | 90 |
1534620 | 1534620 | 2021-07-20 | Fulton | Illinois | 17057 | 4085 | 67 |
1534621 | 1534621 | 2021-07-20 | Gallatin | Illinois | 17059 | 472 | 5 |
1534622 | 1534622 | 2021-07-20 | Greene | Illinois | 17061 | 1492 | 47 |
1534623 | 1534623 | 2021-07-20 | Grundy | Illinois | 17063 | 6020 | 83 |
1534624 | 1534624 | 2021-07-20 | Hamilton | Illinois | 17065 | 871 | 19 |
1534625 | 1534625 | 2021-07-20 | Hancock | Illinois | 17067 | 1885 | 42 |
1534626 | 1534626 | 2021-07-20 | Hardin | Illinois | 17069 | 393 | 12 |
1534627 | 1534627 | 2021-07-20 | Henderson | Illinois | 17071 | 534 | 23 |
1534628 | 1534628 | 2021-07-20 | Henry | Illinois | 17073 | 5109 | 99 |
1534629 | 1534629 | 2021-07-20 | Iroquois | Illinois | 17075 | 3231 | 70 |
1534630 | 1534630 | 2021-07-20 | Jackson | Illinois | 17077 | 5294 | 76 |
1534631 | 1534631 | 2021-07-20 | Jasper | Illinois | 17079 | 1168 | 20 |
1534632 | 1534632 | 2021-07-20 | Jefferson | Illinois | 17081 | 4586 | 124 |
1534633 | 1534633 | 2021-07-20 | Jersey | Illinois | 17083 | 2752 | 71 |
1534634 | 1534634 | 2021-07-20 | Jo Daviess | Illinois | 17085 | 1832 | 27 |
1534635 | 1534635 | 2021-07-20 | Johnson | Illinois | 17087 | 1516 | 22 |
1534636 | 1534636 | 2021-07-20 | Kane | Illinois | 17089 | 59811 | 867 |
1534637 | 1534637 | 2021-07-20 | Kankakee | Illinois | 17091 | 14697 | 232 |
1534638 | 1534638 | 2021-07-20 | Kendall | Illinois | 17093 | 13977 | 109 |
1534639 | 1534639 | 2021-07-20 | Knox | Illinois | 17095 | 5706 | 188 |
1534640 | 1534640 | 2021-07-20 | LaSalle | Illinois | 17099 | 12874 | 308 |
1534641 | 1534641 | 2021-07-20 | Lake | Illinois | 17097 | 68841 | 1097 |
1534642 | 1534642 | 2021-07-20 | Lawrence | Illinois | 17101 | 2431 | 36 |
1534643 | 1534643 | 2021-07-20 | Lee | Illinois | 17103 | 4216 | 93 |
1534644 | 1534644 | 2021-07-20 | Livingston | Illinois | 17105 | 4924 | 104 |
1534645 | 1534645 | 2021-07-20 | Logan | Illinois | 17107 | 4042 | 78 |
1534646 | 1534646 | 2021-07-20 | Macon | Illinois | 17115 | 11079 | 224 |
1534647 | 1534647 | 2021-07-20 | Macoupin | Illinois | 17117 | 4899 | 118 |
1534648 | 1534648 | 2021-07-20 | Madison | Illinois | 17119 | 31875 | 606 |
1534649 | 1534649 | 2021-07-20 | Marion | Illinois | 17121 | 4660 | 123 |
1534650 | 1534650 | 2021-07-20 | Marshall | Illinois | 17123 | 1093 | 21 |
1534651 | 1534651 | 2021-07-20 | Mason | Illinois | 17125 | 1613 | 48 |
1534652 | 1534652 | 2021-07-20 | Massac | Illinois | 17127 | 1387 | 43 |
1534653 | 1534653 | 2021-07-20 | McDonough | Illinois | 17109 | 3012 | 63 |
1534654 | 1534654 | 2021-07-20 | McHenry | Illinois | 17111 | 29384 | 325 |
1534655 | 1534655 | 2021-07-20 | McLean | Illinois | 17113 | 18720 | 229 |
1534656 | 1534656 | 2021-07-20 | Menard | Illinois | 17129 | 1267 | 16 |
1534657 | 1534657 | 2021-07-20 | Mercer | Illinois | 17131 | 1512 | 34 |
1534658 | 1534658 | 2021-07-20 | Monroe | Illinois | 17133 | 4450 | 94 |
1534659 | 1534659 | 2021-07-20 | Montgomery | Illinois | 17135 | 3823 | 80 |
1534660 | 1534660 | 2021-07-20 | Morgan | Illinois | 17137 | 4195 | 114 |
1534661 | 1534661 | 2021-07-20 | Moultrie | Illinois | 17139 | 1657 | 36 |
1534662 | 1534662 | 2021-07-20 | Ogle | Illinois | 17141 | 6265 | 92 |
1534663 | 1534663 | 2021-07-20 | Peoria | Illinois | 17143 | 23661 | 374 |
1534664 | 1534664 | 2021-07-20 | Perry | Illinois | 17145 | 3248 | 69 |
1534665 | 1534665 | 2021-07-20 | Piatt | Illinois | 17147 | 1547 | 20 |
1534666 | 1534666 | 2021-07-20 | Pike | Illinois | 17149 | 1943 | 56 |
1534667 | 1534667 | 2021-07-20 | Pope | Illinois | 17151 | 337 | 4 |
1534668 | 1534668 | 2021-07-20 | Pulaski | Illinois | 17153 | 719 | 7 |
1534669 | 1534669 | 2021-07-20 | Putnam | Illinois | 17155 | 492 | 4 |
1534670 | 1534670 | 2021-07-20 | Randolph | Illinois | 17157 | 4247 | 93 |
1534671 | 1534671 | 2021-07-20 | Richland | Illinois | 17159 | 1786 | 49 |
1534672 | 1534672 | 2021-07-20 | Rock Island | Illinois | 17161 | 15306 | 372 |
1534673 | 1534673 | 2021-07-20 | Saline | Illinois | 17165 | 2659 | 73 |
1534674 | 1534674 | 2021-07-20 | Sangamon | Illinois | 17167 | 19383 | 285 |
1534675 | 1534675 | 2021-07-20 | Schuyler | Illinois | 17169 | 802 | 19 |
1534676 | 1534676 | 2021-07-20 | Scott | Illinois | 17171 | 501 | 1 |
1534677 | 1534677 | 2021-07-20 | Shelby | Illinois | 17173 | 2346 | 41 |
1534678 | 1534678 | 2021-07-20 | St. Clair | Illinois | 17163 | 32171 | 570 |
1534679 | 1534679 | 2021-07-20 | Stark | Illinois | 17175 | 652 | 24 |
1534680 | 1534680 | 2021-07-20 | Stephenson | Illinois | 17177 | 4866 | 105 |
1534681 | 1534681 | 2021-07-20 | Tazewell | Illinois | 17179 | 17345 | 341 |
1534682 | 1534682 | 2021-07-20 | Union | Illinois | 17181 | 2405 | 45 |
1534683 | 1534683 | 2021-07-20 | Unknown | Illinois | 0 | 434 | |
1534684 | 1534684 | 2021-07-20 | Vermilion | Illinois | 17183 | 10138 | 169 |
1534685 | 1534685 | 2021-07-20 | Wabash | Illinois | 17185 | 1439 | 15 |
1534686 | 1534686 | 2021-07-20 | Warren | Illinois | 17187 | 1860 | 53 |
1534687 | 1534687 | 2021-07-20 | Washington | Illinois | 17189 | 1673 | 31 |
1534688 | 1534688 | 2021-07-20 | Wayne | Illinois | 17191 | 1844 | 54 |
1534689 | 1534689 | 2021-07-20 | White | Illinois | 17193 | 1748 | 36 |
1534690 | 1534690 | 2021-07-20 | Whiteside | Illinois | 17195 | 7322 | 216 |
1534691 | 1534691 | 2021-07-20 | Will | Illinois | 17197 | 77483 | 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);