ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1041122 | 1041122 | 2021-02-18 | Adams | Illinois | 17001 | 7933 | 140 |
1041123 | 1041123 | 2021-02-18 | Alexander | Illinois | 17003 | 440 | 8 |
1041124 | 1041124 | 2021-02-18 | Bond | Illinois | 17005 | 1876 | 29 |
1041125 | 1041125 | 2021-02-18 | Boone | Illinois | 17007 | 5886 | 83 |
1041126 | 1041126 | 2021-02-18 | Brown | Illinois | 17009 | 650 | 12 |
1041127 | 1041127 | 2021-02-18 | Bureau | Illinois | 17011 | 3239 | 86 |
1041128 | 1041128 | 2021-02-18 | Calhoun | Illinois | 17013 | 470 | 5 |
1041129 | 1041129 | 2021-02-18 | Carroll | Illinois | 17015 | 1551 | 35 |
1041130 | 1041130 | 2021-02-18 | Cass | Illinois | 17017 | 1864 | 31 |
1041131 | 1041131 | 2021-02-18 | Champaign | Illinois | 17019 | 17672 | 128 |
1041132 | 1041132 | 2021-02-18 | Christian | Illinois | 17021 | 3259 | 80 |
1041133 | 1041133 | 2021-02-18 | Clark | Illinois | 17023 | 1657 | 37 |
1041134 | 1041134 | 2021-02-18 | Clay | Illinois | 17025 | 1417 | 46 |
1041135 | 1041135 | 2021-02-18 | Clinton | Illinois | 17027 | 5528 | 97 |
1041136 | 1041136 | 2021-02-18 | Coles | Illinois | 17029 | 5114 | 91 |
1041137 | 1041137 | 2021-02-18 | Cook | Illinois | 17031 | 467986 | 9775 |
1041138 | 1041138 | 2021-02-18 | Crawford | Illinois | 17033 | 1989 | 37 |
1041139 | 1041139 | 2021-02-18 | Cumberland | Illinois | 17035 | 1174 | 29 |
1041140 | 1041140 | 2021-02-18 | De Witt | Illinois | 17039 | 1266 | 29 |
1041141 | 1041141 | 2021-02-18 | DeKalb | Illinois | 17037 | 8280 | 116 |
1041142 | 1041142 | 2021-02-18 | Douglas | Illinois | 17041 | 2327 | 36 |
1041143 | 1041143 | 2021-02-18 | DuPage | Illinois | 17043 | 75419 | 1257 |
1041144 | 1041144 | 2021-02-18 | Edgar | Illinois | 17045 | 1533 | 56 |
1041145 | 1041145 | 2021-02-18 | Edwards | Illinois | 17047 | 521 | 11 |
1041146 | 1041146 | 2021-02-18 | Effingham | Illinois | 17049 | 4473 | 79 |
1041147 | 1041147 | 2021-02-18 | Fayette | Illinois | 17051 | 3052 | 55 |
1041148 | 1041148 | 2021-02-18 | Ford | Illinois | 17053 | 1532 | 51 |
1041149 | 1041149 | 2021-02-18 | Franklin | Illinois | 17055 | 4109 | 77 |
1041150 | 1041150 | 2021-02-18 | Fulton | Illinois | 17057 | 2801 | 52 |
1041151 | 1041151 | 2021-02-18 | Gallatin | Illinois | 17059 | 432 | 5 |
1041152 | 1041152 | 2021-02-18 | Greene | Illinois | 17061 | 1372 | 44 |
1041153 | 1041153 | 2021-02-18 | Grundy | Illinois | 17063 | 4991 | 66 |
1041154 | 1041154 | 2021-02-18 | Hamilton | Illinois | 17065 | 779 | 18 |
1041155 | 1041155 | 2021-02-18 | Hancock | Illinois | 17067 | 1654 | 39 |
1041156 | 1041156 | 2021-02-18 | Hardin | Illinois | 17069 | 341 | 11 |
1041157 | 1041157 | 2021-02-18 | Henderson | Illinois | 17071 | 491 | 17 |
1041158 | 1041158 | 2021-02-18 | Henry | Illinois | 17073 | 4289 | 82 |
1041159 | 1041159 | 2021-02-18 | Iroquois | Illinois | 17075 | 2758 | 61 |
1041160 | 1041160 | 2021-02-18 | Jackson | Illinois | 17077 | 4561 | 71 |
1041161 | 1041161 | 2021-02-18 | Jasper | Illinois | 17079 | 1101 | 19 |
1041162 | 1041162 | 2021-02-18 | Jefferson | Illinois | 17081 | 3907 | 115 |
1041163 | 1041163 | 2021-02-18 | Jersey | Illinois | 17083 | 2466 | 63 |
1041164 | 1041164 | 2021-02-18 | Jo Daviess | Illinois | 17085 | 1591 | 25 |
1041165 | 1041165 | 2021-02-18 | Johnson | Illinois | 17087 | 1338 | 17 |
1041166 | 1041166 | 2021-02-18 | Kane | Illinois | 17089 | 49900 | 753 |
1041167 | 1041167 | 2021-02-18 | Kankakee | Illinois | 17091 | 12259 | 195 |
1041168 | 1041168 | 2021-02-18 | Kendall | Illinois | 17093 | 10875 | 91 |
1041169 | 1041169 | 2021-02-18 | Knox | Illinois | 17095 | 4952 | 156 |
1041170 | 1041170 | 2021-02-18 | LaSalle | Illinois | 17099 | 10562 | 269 |
1041171 | 1041171 | 2021-02-18 | Lake | Illinois | 17097 | 58393 | 981 |
1041172 | 1041172 | 2021-02-18 | Lawrence | Illinois | 17101 | 2265 | 33 |
1041173 | 1041173 | 2021-02-18 | Lee | Illinois | 17103 | 3298 | 82 |
1041174 | 1041174 | 2021-02-18 | Livingston | Illinois | 17105 | 4098 | 84 |
1041175 | 1041175 | 2021-02-18 | Logan | Illinois | 17107 | 3291 | 64 |
1041176 | 1041176 | 2021-02-18 | Macon | Illinois | 17115 | 9369 | 190 |
1041177 | 1041177 | 2021-02-18 | Macoupin | Illinois | 17117 | 4294 | 105 |
1041178 | 1041178 | 2021-02-18 | Madison | Illinois | 17119 | 27507 | 520 |
1041179 | 1041179 | 2021-02-18 | Marion | Illinois | 17121 | 4235 | 116 |
1041180 | 1041180 | 2021-02-18 | Marshall | Illinois | 17123 | 829 | 16 |
1041181 | 1041181 | 2021-02-18 | Mason | Illinois | 17125 | 1260 | 42 |
1041182 | 1041182 | 2021-02-18 | Massac | Illinois | 17127 | 1233 | 34 |
1041183 | 1041183 | 2021-02-18 | McDonough | Illinois | 17109 | 2296 | 52 |
1041184 | 1041184 | 2021-02-18 | McHenry | Illinois | 17111 | 23853 | 286 |
1041185 | 1041185 | 2021-02-18 | McLean | Illinois | 17113 | 14370 | 190 |
1041186 | 1041186 | 2021-02-18 | Menard | Illinois | 17129 | 1022 | 12 |
1041187 | 1041187 | 2021-02-18 | Mercer | Illinois | 17131 | 1264 | 32 |
1041188 | 1041188 | 2021-02-18 | Monroe | Illinois | 17133 | 4005 | 80 |
1041189 | 1041189 | 2021-02-18 | Montgomery | Illinois | 17135 | 3428 | 73 |
1041190 | 1041190 | 2021-02-18 | Morgan | Illinois | 17137 | 3619 | 97 |
1041191 | 1041191 | 2021-02-18 | Moultrie | Illinois | 17139 | 1477 | 30 |
1041192 | 1041192 | 2021-02-18 | Ogle | Illinois | 17141 | 4935 | 79 |
1041193 | 1041193 | 2021-02-18 | Peoria | Illinois | 17143 | 16776 | 272 |
1041194 | 1041194 | 2021-02-18 | Perry | Illinois | 17145 | 2994 | 66 |
1041195 | 1041195 | 2021-02-18 | Piatt | Illinois | 17147 | 1293 | 19 |
1041196 | 1041196 | 2021-02-18 | Pike | Illinois | 17149 | 1667 | 51 |
1041197 | 1041197 | 2021-02-18 | Pope | Illinois | 17151 | 281 | 3 |
1041198 | 1041198 | 2021-02-18 | Pulaski | Illinois | 17153 | 667 | 5 |
1041199 | 1041199 | 2021-02-18 | Putnam | Illinois | 17155 | 403 | 4 |
1041200 | 1041200 | 2021-02-18 | Randolph | Illinois | 17157 | 3936 | 82 |
1041201 | 1041201 | 2021-02-18 | Richland | Illinois | 17159 | 1629 | 47 |
1041202 | 1041202 | 2021-02-18 | Rock Island | Illinois | 17161 | 12892 | 326 |
1041203 | 1041203 | 2021-02-18 | Saline | Illinois | 17165 | 2255 | 60 |
1041204 | 1041204 | 2021-02-18 | Sangamon | Illinois | 17167 | 15874 | 255 |
1041205 | 1041205 | 2021-02-18 | Schuyler | Illinois | 17169 | 669 | 17 |
1041206 | 1041206 | 2021-02-18 | Scott | Illinois | 17171 | 446 | 1 |
1041207 | 1041207 | 2021-02-18 | Shelby | Illinois | 17173 | 2107 | 36 |
1041208 | 1041208 | 2021-02-18 | St. Clair | Illinois | 17163 | 27454 | 498 |
1041209 | 1041209 | 2021-02-18 | Stark | Illinois | 17175 | 533 | 22 |
1041210 | 1041210 | 2021-02-18 | Stephenson | Illinois | 17177 | 4016 | 91 |
1041211 | 1041211 | 2021-02-18 | Tazewell | Illinois | 17179 | 13298 | 270 |
1041212 | 1041212 | 2021-02-18 | Union | Illinois | 17181 | 2171 | 35 |
1041213 | 1041213 | 2021-02-18 | Unknown | Illinois | 0 | 158 | |
1041214 | 1041214 | 2021-02-18 | Vermilion | Illinois | 17183 | 8403 | 130 |
1041215 | 1041215 | 2021-02-18 | Wabash | Illinois | 17185 | 1292 | 15 |
1041216 | 1041216 | 2021-02-18 | Warren | Illinois | 17187 | 1658 | 46 |
1041217 | 1041217 | 2021-02-18 | Washington | Illinois | 17189 | 1566 | 29 |
1041218 | 1041218 | 2021-02-18 | Wayne | Illinois | 17191 | 1656 | 46 |
1041219 | 1041219 | 2021-02-18 | White | Illinois | 17193 | 1587 | 33 |
1041220 | 1041220 | 2021-02-18 | Whiteside | Illinois | 17195 | 5901 | 187 |
1041221 | 1041221 | 2021-02-18 | Will | Illinois | 17197 | 63856 | 951 |
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);