ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
492972 | 492972 | 2020-09-02 | Adams | Illinois | 17001 | 786 | 9 |
492973 | 492973 | 2020-09-02 | Alexander | Illinois | 17003 | 45 | 0 |
492974 | 492974 | 2020-09-02 | Bond | Illinois | 17005 | 161 | 3 |
492975 | 492975 | 2020-09-02 | Boone | Illinois | 17007 | 884 | 23 |
492976 | 492976 | 2020-09-02 | Brown | Illinois | 17009 | 23 | 0 |
492977 | 492977 | 2020-09-02 | Bureau | Illinois | 17011 | 393 | 9 |
492978 | 492978 | 2020-09-02 | Calhoun | Illinois | 17013 | 27 | 0 |
492979 | 492979 | 2020-09-02 | Carroll | Illinois | 17015 | 138 | 4 |
492980 | 492980 | 2020-09-02 | Cass | Illinois | 17017 | 309 | 11 |
492981 | 492981 | 2020-09-02 | Champaign | Illinois | 17019 | 2557 | 20 |
492982 | 492982 | 2020-09-02 | Christian | Illinois | 17021 | 249 | 7 |
492983 | 492983 | 2020-09-02 | Clark | Illinois | 17023 | 119 | 2 |
492984 | 492984 | 2020-09-02 | Clay | Illinois | 17025 | 91 | 0 |
492985 | 492985 | 2020-09-02 | Clinton | Illinois | 17027 | 765 | 17 |
492986 | 492986 | 2020-09-02 | Coles | Illinois | 17029 | 1027 | 22 |
492987 | 492987 | 2020-09-02 | Cook | Illinois | 17031 | 127616 | 5073 |
492988 | 492988 | 2020-09-02 | Crawford | Illinois | 17033 | 81 | 1 |
492989 | 492989 | 2020-09-02 | Cumberland | Illinois | 17035 | 146 | 3 |
492990 | 492990 | 2020-09-02 | De Witt | Illinois | 17039 | 48 | 1 |
492991 | 492991 | 2020-09-02 | DeKalb | Illinois | 17037 | 1195 | 36 |
492992 | 492992 | 2020-09-02 | Douglas | Illinois | 17041 | 231 | 5 |
492993 | 492993 | 2020-09-02 | DuPage | Illinois | 17043 | 14770 | 537 |
492994 | 492994 | 2020-09-02 | Edgar | Illinois | 17045 | 92 | 0 |
492995 | 492995 | 2020-09-02 | Edwards | Illinois | 17047 | 42 | 0 |
492996 | 492996 | 2020-09-02 | Effingham | Illinois | 17049 | 574 | 1 |
492997 | 492997 | 2020-09-02 | Fayette | Illinois | 17051 | 176 | 3 |
492998 | 492998 | 2020-09-02 | Ford | Illinois | 17053 | 72 | 3 |
492999 | 492999 | 2020-09-02 | Franklin | Illinois | 17055 | 349 | 1 |
493000 | 493000 | 2020-09-02 | Fulton | Illinois | 17057 | 94 | 0 |
493001 | 493001 | 2020-09-02 | Gallatin | Illinois | 17059 | 64 | 2 |
493002 | 493002 | 2020-09-02 | Greene | Illinois | 17061 | 129 | 1 |
493003 | 493003 | 2020-09-02 | Grundy | Illinois | 17063 | 501 | 5 |
493004 | 493004 | 2020-09-02 | Hamilton | Illinois | 17065 | 45 | 0 |
493005 | 493005 | 2020-09-02 | Hancock | Illinois | 17067 | 146 | 2 |
493006 | 493006 | 2020-09-02 | Hardin | Illinois | 17069 | 20 | 0 |
493007 | 493007 | 2020-09-02 | Henderson | Illinois | 17071 | 45 | 0 |
493008 | 493008 | 2020-09-02 | Henry | Illinois | 17073 | 472 | 1 |
493009 | 493009 | 2020-09-02 | Iroquois | Illinois | 17075 | 310 | 19 |
493010 | 493010 | 2020-09-02 | Jackson | Illinois | 17077 | 973 | 22 |
493011 | 493011 | 2020-09-02 | Jasper | Illinois | 17079 | 139 | 7 |
493012 | 493012 | 2020-09-02 | Jefferson | Illinois | 17081 | 463 | 35 |
493013 | 493013 | 2020-09-02 | Jersey | Illinois | 17083 | 285 | 6 |
493014 | 493014 | 2020-09-02 | Jo Daviess | Illinois | 17085 | 177 | 2 |
493015 | 493015 | 2020-09-02 | Johnson | Illinois | 17087 | 119 | 0 |
493016 | 493016 | 2020-09-02 | Kane | Illinois | 17089 | 11394 | 314 |
493017 | 493017 | 2020-09-02 | Kankakee | Illinois | 17091 | 2352 | 71 |
493018 | 493018 | 2020-09-02 | Kendall | Illinois | 17093 | 1716 | 25 |
493019 | 493019 | 2020-09-02 | Knox | Illinois | 17095 | 460 | 3 |
493020 | 493020 | 2020-09-02 | LaSalle | Illinois | 17099 | 1291 | 50 |
493021 | 493021 | 2020-09-02 | Lake | Illinois | 17097 | 14697 | 468 |
493022 | 493022 | 2020-09-02 | Lawrence | Illinois | 17101 | 142 | 0 |
493023 | 493023 | 2020-09-02 | Lee | Illinois | 17103 | 244 | 1 |
493024 | 493024 | 2020-09-02 | Livingston | Illinois | 17105 | 207 | 4 |
493025 | 493025 | 2020-09-02 | Logan | Illinois | 17107 | 276 | 1 |
493026 | 493026 | 2020-09-02 | Macon | Illinois | 17115 | 1007 | 27 |
493027 | 493027 | 2020-09-02 | Macoupin | Illinois | 17117 | 362 | 5 |
493028 | 493028 | 2020-09-02 | Madison | Illinois | 17119 | 4182 | 101 |
493029 | 493029 | 2020-09-02 | Marion | Illinois | 17121 | 286 | 0 |
493030 | 493030 | 2020-09-02 | Marshall | Illinois | 17123 | 53 | 0 |
493031 | 493031 | 2020-09-02 | Mason | Illinois | 17125 | 88 | 1 |
493032 | 493032 | 2020-09-02 | Massac | Illinois | 17127 | 65 | 1 |
493033 | 493033 | 2020-09-02 | McDonough | Illinois | 17109 | 231 | 15 |
493034 | 493034 | 2020-09-02 | McHenry | Illinois | 17111 | 3968 | 117 |
493035 | 493035 | 2020-09-02 | McLean | Illinois | 17113 | 2063 | 16 |
493036 | 493036 | 2020-09-02 | Menard | Illinois | 17129 | 72 | 0 |
493037 | 493037 | 2020-09-02 | Mercer | Illinois | 17131 | 103 | 5 |
493038 | 493038 | 2020-09-02 | Monroe | Illinois | 17133 | 472 | 14 |
493039 | 493039 | 2020-09-02 | Montgomery | Illinois | 17135 | 254 | 8 |
493040 | 493040 | 2020-09-02 | Morgan | Illinois | 17137 | 558 | 21 |
493041 | 493041 | 2020-09-02 | Moultrie | Illinois | 17139 | 169 | 2 |
493042 | 493042 | 2020-09-02 | Ogle | Illinois | 17141 | 518 | 5 |
493043 | 493043 | 2020-09-02 | Peoria | Illinois | 17143 | 2451 | 40 |
493044 | 493044 | 2020-09-02 | Perry | Illinois | 17145 | 298 | 10 |
493045 | 493045 | 2020-09-02 | Piatt | Illinois | 17147 | 82 | 0 |
493046 | 493046 | 2020-09-02 | Pike | Illinois | 17149 | 75 | 0 |
493047 | 493047 | 2020-09-02 | Pope | Illinois | 17151 | 19 | 1 |
493048 | 493048 | 2020-09-02 | Pulaski | Illinois | 17153 | 132 | 1 |
493049 | 493049 | 2020-09-02 | Putnam | Illinois | 17155 | 20 | 0 |
493050 | 493050 | 2020-09-02 | Randolph | Illinois | 17157 | 750 | 7 |
493051 | 493051 | 2020-09-02 | Richland | Illinois | 17159 | 66 | 3 |
493052 | 493052 | 2020-09-02 | Rock Island | Illinois | 17161 | 2290 | 65 |
493053 | 493053 | 2020-09-02 | Saline | Illinois | 17165 | 168 | 3 |
493054 | 493054 | 2020-09-02 | Sangamon | Illinois | 17167 | 1882 | 40 |
493055 | 493055 | 2020-09-02 | Schuyler | Illinois | 17169 | 24 | 0 |
493056 | 493056 | 2020-09-02 | Scott | Illinois | 17171 | 46 | 0 |
493057 | 493057 | 2020-09-02 | Shelby | Illinois | 17173 | 221 | 3 |
493058 | 493058 | 2020-09-02 | St. Clair | Illinois | 17163 | 5992 | 175 |
493059 | 493059 | 2020-09-02 | Stark | Illinois | 17175 | 28 | 0 |
493060 | 493060 | 2020-09-02 | Stephenson | Illinois | 17177 | 387 | 6 |
493061 | 493061 | 2020-09-02 | Tazewell | Illinois | 17179 | 1139 | 10 |
493062 | 493062 | 2020-09-02 | Union | Illinois | 17181 | 435 | 24 |
493063 | 493063 | 2020-09-02 | Unknown | Illinois | 1641 | 207 | |
493064 | 493064 | 2020-09-02 | Vermilion | Illinois | 17183 | 353 | 4 |
493065 | 493065 | 2020-09-02 | Wabash | Illinois | 17185 | 108 | 1 |
493066 | 493066 | 2020-09-02 | Warren | Illinois | 17187 | 264 | 1 |
493067 | 493067 | 2020-09-02 | Washington | Illinois | 17189 | 116 | 1 |
493068 | 493068 | 2020-09-02 | Wayne | Illinois | 17191 | 117 | 2 |
493069 | 493069 | 2020-09-02 | White | Illinois | 17193 | 128 | 0 |
493070 | 493070 | 2020-09-02 | Whiteside | Illinois | 17195 | 566 | 19 |
493071 | 493071 | 2020-09-02 | Will | Illinois | 17197 | 11731 | 362 |
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);