ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2020-06-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 |
---|---|---|---|---|---|---|---|
287667 | 287667 | 2020-06-30 | Adams | Illinois | 17001 | 87 | 1 |
287668 | 287668 | 2020-06-30 | Alexander | Illinois | 17003 | 22 | 0 |
287669 | 287669 | 2020-06-30 | Bond | Illinois | 17005 | 13 | 1 |
287670 | 287670 | 2020-06-30 | Boone | Illinois | 17007 | 586 | 21 |
287671 | 287671 | 2020-06-30 | Brown | Illinois | 17009 | 10 | 0 |
287672 | 287672 | 2020-06-30 | Bureau | Illinois | 17011 | 29 | 2 |
287673 | 287673 | 2020-06-30 | Calhoun | Illinois | 17013 | 1 | 0 |
287674 | 287674 | 2020-06-30 | Carroll | Illinois | 17015 | 21 | 2 |
287675 | 287675 | 2020-06-30 | Cass | Illinois | 17017 | 129 | 2 |
287676 | 287676 | 2020-06-30 | Champaign | Illinois | 17019 | 866 | 12 |
287677 | 287677 | 2020-06-30 | Christian | Illinois | 17021 | 43 | 5 |
287678 | 287678 | 2020-06-30 | Clark | Illinois | 17023 | 14 | 0 |
287679 | 287679 | 2020-06-30 | Clay | Illinois | 17025 | 2 | 0 |
287680 | 287680 | 2020-06-30 | Clinton | Illinois | 17027 | 236 | 17 |
287681 | 287681 | 2020-06-30 | Coles | Illinois | 17029 | 164 | 17 |
287682 | 287682 | 2020-06-30 | Cook | Illinois | 17031 | 90536 | 4565 |
287683 | 287683 | 2020-06-30 | Crawford | Illinois | 17033 | 18 | 0 |
287684 | 287684 | 2020-06-30 | Cumberland | Illinois | 17035 | 11 | 0 |
287685 | 287685 | 2020-06-30 | De Witt | Illinois | 17039 | 6 | 0 |
287686 | 287686 | 2020-06-30 | DeKalb | Illinois | 17037 | 574 | 18 |
287687 | 287687 | 2020-06-30 | Douglas | Illinois | 17041 | 52 | 0 |
287688 | 287688 | 2020-06-30 | DuPage | Illinois | 17043 | 9036 | 470 |
287689 | 287689 | 2020-06-30 | Edgar | Illinois | 17045 | 10 | 0 |
287690 | 287690 | 2020-06-30 | Edwards | Illinois | 17047 | 2 | 0 |
287691 | 287691 | 2020-06-30 | Effingham | Illinois | 17049 | 12 | 1 |
287692 | 287692 | 2020-06-30 | Fayette | Illinois | 17051 | 23 | 3 |
287693 | 287693 | 2020-06-30 | Ford | Illinois | 17053 | 31 | 1 |
287694 | 287694 | 2020-06-30 | Franklin | Illinois | 17055 | 14 | 0 |
287695 | 287695 | 2020-06-30 | Fulton | Illinois | 17057 | 15 | 0 |
287696 | 287696 | 2020-06-30 | Gallatin | Illinois | 17059 | 2 | 0 |
287697 | 287697 | 2020-06-30 | Greene | Illinois | 17061 | 9 | 0 |
287698 | 287698 | 2020-06-30 | Grundy | Illinois | 17063 | 162 | 4 |
287699 | 287699 | 2020-06-30 | Hamilton | Illinois | 17065 | 5 | 0 |
287700 | 287700 | 2020-06-30 | Hancock | Illinois | 17067 | 18 | 1 |
287701 | 287701 | 2020-06-30 | Hardin | Illinois | 17069 | 1 | 0 |
287702 | 287702 | 2020-06-30 | Henderson | Illinois | 17071 | 8 | 0 |
287703 | 287703 | 2020-06-30 | Henry | Illinois | 17073 | 84 | 1 |
287704 | 287704 | 2020-06-30 | Iroquois | Illinois | 17075 | 157 | 5 |
287705 | 287705 | 2020-06-30 | Jackson | Illinois | 17077 | 332 | 19 |
287706 | 287706 | 2020-06-30 | Jasper | Illinois | 17079 | 46 | 7 |
287707 | 287707 | 2020-06-30 | Jefferson | Illinois | 17081 | 107 | 17 |
287708 | 287708 | 2020-06-30 | Jersey | Illinois | 17083 | 35 | 1 |
287709 | 287709 | 2020-06-30 | Jo Daviess | Illinois | 17085 | 42 | 1 |
287710 | 287710 | 2020-06-30 | Johnson | Illinois | 17087 | 20 | 0 |
287711 | 287711 | 2020-06-30 | Kane | Illinois | 17089 | 7750 | 269 |
287712 | 287712 | 2020-06-30 | Kankakee | Illinois | 17091 | 1358 | 65 |
287713 | 287713 | 2020-06-30 | Kendall | Illinois | 17093 | 1008 | 23 |
287714 | 287714 | 2020-06-30 | Knox | Illinois | 17095 | 130 | 0 |
287715 | 287715 | 2020-06-30 | LaSalle | Illinois | 17099 | 216 | 17 |
287716 | 287716 | 2020-06-30 | Lake | Illinois | 17097 | 9719 | 416 |
287717 | 287717 | 2020-06-30 | Lawrence | Illinois | 17101 | 7 | 0 |
287718 | 287718 | 2020-06-30 | Lee | Illinois | 17103 | 97 | 2 |
287719 | 287719 | 2020-06-30 | Livingston | Illinois | 17105 | 43 | 2 |
287720 | 287720 | 2020-06-30 | Logan | Illinois | 17107 | 14 | 0 |
287721 | 287721 | 2020-06-30 | Macon | Illinois | 17115 | 232 | 22 |
287722 | 287722 | 2020-06-30 | Macoupin | Illinois | 17117 | 51 | 3 |
287723 | 287723 | 2020-06-30 | Madison | Illinois | 17119 | 939 | 68 |
287724 | 287724 | 2020-06-30 | Marion | Illinois | 17121 | 65 | 0 |
287725 | 287725 | 2020-06-30 | Marshall | Illinois | 17123 | 8 | 0 |
287726 | 287726 | 2020-06-30 | Mason | Illinois | 17125 | 22 | 0 |
287727 | 287727 | 2020-06-30 | Massac | Illinois | 17127 | 11 | 0 |
287728 | 287728 | 2020-06-30 | McDonough | Illinois | 17109 | 100 | 15 |
287729 | 287729 | 2020-06-30 | McHenry | Illinois | 17111 | 2032 | 97 |
287730 | 287730 | 2020-06-30 | McLean | Illinois | 17113 | 260 | 13 |
287731 | 287731 | 2020-06-30 | Menard | Illinois | 17129 | 25 | 0 |
287732 | 287732 | 2020-06-30 | Mercer | Illinois | 17131 | 20 | 0 |
287733 | 287733 | 2020-06-30 | Monroe | Illinois | 17133 | 127 | 13 |
287734 | 287734 | 2020-06-30 | Montgomery | Illinois | 17135 | 44 | 0 |
287735 | 287735 | 2020-06-30 | Morgan | Illinois | 17137 | 128 | 3 |
287736 | 287736 | 2020-06-30 | Moultrie | Illinois | 17139 | 17 | 0 |
287737 | 287737 | 2020-06-30 | Ogle | Illinois | 17141 | 267 | 4 |
287738 | 287738 | 2020-06-30 | Peoria | Illinois | 17143 | 487 | 28 |
287739 | 287739 | 2020-06-30 | Perry | Illinois | 17145 | 51 | 1 |
287740 | 287740 | 2020-06-30 | Piatt | Illinois | 17147 | 19 | 0 |
287741 | 287741 | 2020-06-30 | Pike | Illinois | 17149 | 2 | 0 |
287742 | 287742 | 2020-06-30 | Pope | Illinois | 17151 | 1 | 0 |
287743 | 287743 | 2020-06-30 | Pulaski | Illinois | 17153 | 74 | 0 |
287744 | 287744 | 2020-06-30 | Putnam | Illinois | 17155 | 1 | 0 |
287745 | 287745 | 2020-06-30 | Randolph | Illinois | 17157 | 285 | 7 |
287746 | 287746 | 2020-06-30 | Richland | Illinois | 17159 | 4 | 0 |
287747 | 287747 | 2020-06-30 | Rock Island | Illinois | 17161 | 947 | 29 |
287748 | 287748 | 2020-06-30 | Saline | Illinois | 17165 | 9 | 0 |
287749 | 287749 | 2020-06-30 | Sangamon | Illinois | 17167 | 431 | 34 |
287750 | 287750 | 2020-06-30 | Schuyler | Illinois | 17169 | 13 | 0 |
287751 | 287751 | 2020-06-30 | Shelby | Illinois | 17173 | 18 | 1 |
287752 | 287752 | 2020-06-30 | St. Clair | Illinois | 17163 | 2086 | 138 |
287753 | 287753 | 2020-06-30 | Stark | Illinois | 17175 | 3 | 0 |
287754 | 287754 | 2020-06-30 | Stephenson | Illinois | 17177 | 270 | 5 |
287755 | 287755 | 2020-06-30 | Tazewell | Illinois | 17179 | 127 | 8 |
287756 | 287756 | 2020-06-30 | Union | Illinois | 17181 | 188 | 19 |
287757 | 287757 | 2020-06-30 | Unknown | Illinois | 1053 | 201 | |
287758 | 287758 | 2020-06-30 | Vermilion | Illinois | 17183 | 65 | 2 |
287759 | 287759 | 2020-06-30 | Wabash | Illinois | 17185 | 22 | 0 |
287760 | 287760 | 2020-06-30 | Warren | Illinois | 17187 | 136 | 0 |
287761 | 287761 | 2020-06-30 | Washington | Illinois | 17189 | 19 | 0 |
287762 | 287762 | 2020-06-30 | Wayne | Illinois | 17191 | 14 | 1 |
287763 | 287763 | 2020-06-30 | White | Illinois | 17193 | 4 | 0 |
287764 | 287764 | 2020-06-30 | Whiteside | Illinois | 17195 | 186 | 15 |
287765 | 287765 | 2020-06-30 | Will | Illinois | 17197 | 6686 | 321 |
287766 | 287766 | 2020-06-30 | Williamson | Illinois | 17199 | 115 | 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);