ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2020-08-07 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 |
---|---|---|---|---|---|---|---|
409055 | 409055 | 2020-08-07 | Adams | Illinois | 17001 | 506 | 5 |
409056 | 409056 | 2020-08-07 | Alexander | Illinois | 17003 | 36 | 0 |
409057 | 409057 | 2020-08-07 | Bond | Illinois | 17005 | 59 | 3 |
409058 | 409058 | 2020-08-07 | Boone | Illinois | 17007 | 758 | 23 |
409059 | 409059 | 2020-08-07 | Brown | Illinois | 17009 | 13 | 0 |
409060 | 409060 | 2020-08-07 | Bureau | Illinois | 17011 | 179 | 2 |
409061 | 409061 | 2020-08-07 | Calhoun | Illinois | 17013 | 9 | 0 |
409062 | 409062 | 2020-08-07 | Carroll | Illinois | 17015 | 50 | 4 |
409063 | 409063 | 2020-08-07 | Cass | Illinois | 17017 | 223 | 11 |
409064 | 409064 | 2020-08-07 | Champaign | Illinois | 17019 | 1625 | 19 |
409065 | 409065 | 2020-08-07 | Christian | Illinois | 17021 | 134 | 5 |
409066 | 409066 | 2020-08-07 | Clark | Illinois | 17023 | 79 | 2 |
409067 | 409067 | 2020-08-07 | Clay | Illinois | 17025 | 20 | 0 |
409068 | 409068 | 2020-08-07 | Clinton | Illinois | 17027 | 387 | 17 |
409069 | 409069 | 2020-08-07 | Coles | Illinois | 17029 | 448 | 20 |
409070 | 409070 | 2020-08-07 | Cook | Illinois | 17031 | 110002 | 4920 |
409071 | 409071 | 2020-08-07 | Crawford | Illinois | 17033 | 29 | 0 |
409072 | 409072 | 2020-08-07 | Cumberland | Illinois | 17035 | 53 | 2 |
409073 | 409073 | 2020-08-07 | De Witt | Illinois | 17039 | 33 | 0 |
409074 | 409074 | 2020-08-07 | DeKalb | Illinois | 17037 | 928 | 30 |
409075 | 409075 | 2020-08-07 | Douglas | Illinois | 17041 | 108 | 2 |
409076 | 409076 | 2020-08-07 | DuPage | Illinois | 17043 | 12021 | 519 |
409077 | 409077 | 2020-08-07 | Edgar | Illinois | 17045 | 28 | 0 |
409078 | 409078 | 2020-08-07 | Edwards | Illinois | 17047 | 17 | 0 |
409079 | 409079 | 2020-08-07 | Effingham | Illinois | 17049 | 139 | 1 |
409080 | 409080 | 2020-08-07 | Fayette | Illinois | 17051 | 60 | 3 |
409081 | 409081 | 2020-08-07 | Ford | Illinois | 17053 | 49 | 2 |
409082 | 409082 | 2020-08-07 | Franklin | Illinois | 17055 | 156 | 0 |
409083 | 409083 | 2020-08-07 | Fulton | Illinois | 17057 | 33 | 0 |
409084 | 409084 | 2020-08-07 | Gallatin | Illinois | 17059 | 49 | 2 |
409085 | 409085 | 2020-08-07 | Greene | Illinois | 17061 | 38 | 0 |
409086 | 409086 | 2020-08-07 | Grundy | Illinois | 17063 | 307 | 5 |
409087 | 409087 | 2020-08-07 | Hamilton | Illinois | 17065 | 28 | 0 |
409088 | 409088 | 2020-08-07 | Hancock | Illinois | 17067 | 47 | 1 |
409089 | 409089 | 2020-08-07 | Hardin | Illinois | 17069 | 18 | 0 |
409090 | 409090 | 2020-08-07 | Henderson | Illinois | 17071 | 10 | 0 |
409091 | 409091 | 2020-08-07 | Henry | Illinois | 17073 | 232 | 1 |
409092 | 409092 | 2020-08-07 | Iroquois | Illinois | 17075 | 257 | 11 |
409093 | 409093 | 2020-08-07 | Jackson | Illinois | 17077 | 695 | 19 |
409094 | 409094 | 2020-08-07 | Jasper | Illinois | 17079 | 59 | 7 |
409095 | 409095 | 2020-08-07 | Jefferson | Illinois | 17081 | 247 | 19 |
409096 | 409096 | 2020-08-07 | Jersey | Illinois | 17083 | 98 | 2 |
409097 | 409097 | 2020-08-07 | Jo Daviess | Illinois | 17085 | 124 | 1 |
409098 | 409098 | 2020-08-07 | Johnson | Illinois | 17087 | 66 | 0 |
409099 | 409099 | 2020-08-07 | Kane | Illinois | 17089 | 9684 | 303 |
409100 | 409100 | 2020-08-07 | Kankakee | Illinois | 17091 | 1834 | 68 |
409101 | 409101 | 2020-08-07 | Kendall | Illinois | 17093 | 1391 | 25 |
409102 | 409102 | 2020-08-07 | Knox | Illinois | 17095 | 291 | 1 |
409103 | 409103 | 2020-08-07 | LaSalle | Illinois | 17099 | 684 | 24 |
409104 | 409104 | 2020-08-07 | Lake | Illinois | 17097 | 12491 | 445 |
409105 | 409105 | 2020-08-07 | Lawrence | Illinois | 17101 | 45 | 0 |
409106 | 409106 | 2020-08-07 | Lee | Illinois | 17103 | 165 | 1 |
409107 | 409107 | 2020-08-07 | Livingston | Illinois | 17105 | 105 | 2 |
409108 | 409108 | 2020-08-07 | Logan | Illinois | 17107 | 106 | 0 |
409109 | 409109 | 2020-08-07 | Macon | Illinois | 17115 | 578 | 23 |
409110 | 409110 | 2020-08-07 | Macoupin | Illinois | 17117 | 156 | 3 |
409111 | 409111 | 2020-08-07 | Madison | Illinois | 17119 | 2470 | 77 |
409112 | 409112 | 2020-08-07 | Marion | Illinois | 17121 | 152 | 0 |
409113 | 409113 | 2020-08-07 | Marshall | Illinois | 17123 | 24 | 0 |
409114 | 409114 | 2020-08-07 | Mason | Illinois | 17125 | 45 | 0 |
409115 | 409115 | 2020-08-07 | Massac | Illinois | 17127 | 37 | 0 |
409116 | 409116 | 2020-08-07 | McDonough | Illinois | 17109 | 139 | 15 |
409117 | 409117 | 2020-08-07 | McHenry | Illinois | 17111 | 3189 | 115 |
409118 | 409118 | 2020-08-07 | McLean | Illinois | 17113 | 624 | 15 |
409119 | 409119 | 2020-08-07 | Menard | Illinois | 17129 | 53 | 0 |
409120 | 409120 | 2020-08-07 | Mercer | Illinois | 17131 | 73 | 3 |
409121 | 409121 | 2020-08-07 | Monroe | Illinois | 17133 | 305 | 13 |
409122 | 409122 | 2020-08-07 | Montgomery | Illinois | 17135 | 161 | 6 |
409123 | 409123 | 2020-08-07 | Morgan | Illinois | 17137 | 229 | 6 |
409124 | 409124 | 2020-08-07 | Moultrie | Illinois | 17139 | 72 | 0 |
409125 | 409125 | 2020-08-07 | Ogle | Illinois | 17141 | 404 | 5 |
409126 | 409126 | 2020-08-07 | Peoria | Illinois | 17143 | 1525 | 35 |
409127 | 409127 | 2020-08-07 | Perry | Illinois | 17145 | 149 | 1 |
409128 | 409128 | 2020-08-07 | Piatt | Illinois | 17147 | 56 | 0 |
409129 | 409129 | 2020-08-07 | Pike | Illinois | 17149 | 20 | 0 |
409130 | 409130 | 2020-08-07 | Pope | Illinois | 17151 | 8 | 0 |
409131 | 409131 | 2020-08-07 | Pulaski | Illinois | 17153 | 92 | 0 |
409132 | 409132 | 2020-08-07 | Putnam | Illinois | 17155 | 11 | 0 |
409133 | 409133 | 2020-08-07 | Randolph | Illinois | 17157 | 452 | 7 |
409134 | 409134 | 2020-08-07 | Richland | Illinois | 17159 | 18 | 0 |
409135 | 409135 | 2020-08-07 | Rock Island | Illinois | 17161 | 1715 | 36 |
409136 | 409136 | 2020-08-07 | Saline | Illinois | 17165 | 130 | 2 |
409137 | 409137 | 2020-08-07 | Sangamon | Illinois | 17167 | 1194 | 34 |
409138 | 409138 | 2020-08-07 | Schuyler | Illinois | 17169 | 17 | 0 |
409139 | 409139 | 2020-08-07 | Scott | Illinois | 17171 | 16 | 0 |
409140 | 409140 | 2020-08-07 | Shelby | Illinois | 17173 | 75 | 1 |
409141 | 409141 | 2020-08-07 | St. Clair | Illinois | 17163 | 4282 | 160 |
409142 | 409142 | 2020-08-07 | Stark | Illinois | 17175 | 7 | 0 |
409143 | 409143 | 2020-08-07 | Stephenson | Illinois | 17177 | 325 | 6 |
409144 | 409144 | 2020-08-07 | Tazewell | Illinois | 17179 | 486 | 8 |
409145 | 409145 | 2020-08-07 | Union | Illinois | 17181 | 318 | 23 |
409146 | 409146 | 2020-08-07 | Unknown | Illinois | 1244 | 209 | |
409147 | 409147 | 2020-08-07 | Vermilion | Illinois | 17183 | 229 | 2 |
409148 | 409148 | 2020-08-07 | Wabash | Illinois | 17185 | 34 | 0 |
409149 | 409149 | 2020-08-07 | Warren | Illinois | 17187 | 189 | 0 |
409150 | 409150 | 2020-08-07 | Washington | Illinois | 17189 | 64 | 0 |
409151 | 409151 | 2020-08-07 | Wayne | Illinois | 17191 | 59 | 1 |
409152 | 409152 | 2020-08-07 | White | Illinois | 17193 | 64 | 0 |
409153 | 409153 | 2020-08-07 | Whiteside | Illinois | 17195 | 352 | 17 |
409154 | 409154 | 2020-08-07 | Will | Illinois | 17197 | 9120 | 345 |
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);