ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-11-04" 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 |
---|---|---|---|---|---|---|---|
1882199 | 1882199 | 2021-11-04 | Adams | Illinois | 17001 | 13447 | 185 |
1882200 | 1882200 | 2021-11-04 | Alexander | Illinois | 17003 | 764 | 13 |
1882201 | 1882201 | 2021-11-04 | Bond | Illinois | 17005 | 2618 | 33 |
1882202 | 1882202 | 2021-11-04 | Boone | Illinois | 17007 | 8080 | 96 |
1882203 | 1882203 | 2021-11-04 | Brown | Illinois | 17009 | 1082 | 17 |
1882204 | 1882204 | 2021-11-04 | Bureau | Illinois | 17011 | 4557 | 106 |
1882205 | 1882205 | 2021-11-04 | Calhoun | Illinois | 17013 | 710 | 5 |
1882206 | 1882206 | 2021-11-04 | Carroll | Illinois | 17015 | 2403 | 40 |
1882207 | 1882207 | 2021-11-04 | Cass | Illinois | 17017 | 2694 | 40 |
1882208 | 1882208 | 2021-11-04 | Champaign | Illinois | 17019 | 27606 | 206 |
1882209 | 1882209 | 2021-11-04 | Christian | Illinois | 17021 | 5489 | 100 |
1882210 | 1882210 | 2021-11-04 | Clark | Illinois | 17023 | 2731 | 50 |
1882211 | 1882211 | 2021-11-04 | Clay | Illinois | 17025 | 2662 | 59 |
1882212 | 1882212 | 2021-11-04 | Clinton | Illinois | 17027 | 7210 | 113 |
1882213 | 1882213 | 2021-11-04 | Coles | Illinois | 17029 | 8104 | 131 |
1882214 | 1882214 | 2021-11-04 | Cook | Illinois | 17031 | 646008 | 11876 |
1882215 | 1882215 | 2021-11-04 | Crawford | Illinois | 17033 | 3394 | 46 |
1882216 | 1882216 | 2021-11-04 | Cumberland | Illinois | 17035 | 1938 | 39 |
1882217 | 1882217 | 2021-11-04 | De Witt | Illinois | 17039 | 2136 | 37 |
1882218 | 1882218 | 2021-11-04 | DeKalb | Illinois | 17037 | 12747 | 139 |
1882219 | 1882219 | 2021-11-04 | Douglas | Illinois | 17041 | 3345 | 44 |
1882220 | 1882220 | 2021-11-04 | DuPage | Illinois | 17043 | 110799 | 1474 |
1882221 | 1882221 | 2021-11-04 | Edgar | Illinois | 17045 | 2674 | 70 |
1882222 | 1882222 | 2021-11-04 | Edwards | Illinois | 17047 | 1050 | 20 |
1882223 | 1882223 | 2021-11-04 | Effingham | Illinois | 17049 | 6778 | 113 |
1882224 | 1882224 | 2021-11-04 | Fayette | Illinois | 17051 | 4404 | 69 |
1882225 | 1882225 | 2021-11-04 | Ford | Illinois | 17053 | 2517 | 67 |
1882226 | 1882226 | 2021-11-04 | Franklin | Illinois | 17055 | 7380 | 128 |
1882227 | 1882227 | 2021-11-04 | Fulton | Illinois | 17057 | 5352 | 91 |
1882228 | 1882228 | 2021-11-04 | Gallatin | Illinois | 17059 | 800 | 10 |
1882229 | 1882229 | 2021-11-04 | Greene | Illinois | 17061 | 2073 | 53 |
1882230 | 1882230 | 2021-11-04 | Grundy | Illinois | 17063 | 7563 | 93 |
1882231 | 1882231 | 2021-11-04 | Hamilton | Illinois | 17065 | 1364 | 25 |
1882232 | 1882232 | 2021-11-04 | Hancock | Illinois | 17067 | 2817 | 45 |
1882233 | 1882233 | 2021-11-04 | Hardin | Illinois | 17069 | 623 | 16 |
1882234 | 1882234 | 2021-11-04 | Henderson | Illinois | 17071 | 742 | 23 |
1882235 | 1882235 | 2021-11-04 | Henry | Illinois | 17073 | 6791 | 106 |
1882236 | 1882236 | 2021-11-04 | Iroquois | Illinois | 17075 | 4320 | 81 |
1882237 | 1882237 | 2021-11-04 | Jackson | Illinois | 17077 | 8175 | 106 |
1882238 | 1882238 | 2021-11-04 | Jasper | Illinois | 17079 | 1637 | 23 |
1882239 | 1882239 | 2021-11-04 | Jefferson | Illinois | 17081 | 6689 | 147 |
1882240 | 1882240 | 2021-11-04 | Jersey | Illinois | 17083 | 3425 | 72 |
1882241 | 1882241 | 2021-11-04 | Jo Daviess | Illinois | 17085 | 2256 | 32 |
1882242 | 1882242 | 2021-11-04 | Johnson | Illinois | 17087 | 2360 | 38 |
1882243 | 1882243 | 2021-11-04 | Kane | Illinois | 17089 | 69626 | 940 |
1882244 | 1882244 | 2021-11-04 | Kankakee | Illinois | 17091 | 18272 | 269 |
1882245 | 1882245 | 2021-11-04 | Kendall | Illinois | 17093 | 17421 | 126 |
1882246 | 1882246 | 2021-11-04 | Knox | Illinois | 17095 | 7544 | 203 |
1882247 | 1882247 | 2021-11-04 | LaSalle | Illinois | 17099 | 15289 | 345 |
1882248 | 1882248 | 2021-11-04 | Lake | Illinois | 17097 | 81761 | 1168 |
1882249 | 1882249 | 2021-11-04 | Lawrence | Illinois | 17101 | 3404 | 44 |
1882250 | 1882250 | 2021-11-04 | Lee | Illinois | 17103 | 4887 | 101 |
1882251 | 1882251 | 2021-11-04 | Livingston | Illinois | 17105 | 6061 | 111 |
1882252 | 1882252 | 2021-11-04 | Logan | Illinois | 17107 | 5005 | 89 |
1882253 | 1882253 | 2021-11-04 | Macon | Illinois | 17115 | 15609 | 262 |
1882254 | 1882254 | 2021-11-04 | Macoupin | Illinois | 17117 | 7190 | 138 |
1882255 | 1882255 | 2021-11-04 | Madison | Illinois | 17119 | 40807 | 680 |
1882256 | 1882256 | 2021-11-04 | Marion | Illinois | 17121 | 7057 | 154 |
1882257 | 1882257 | 2021-11-04 | Marshall | Illinois | 17123 | 1434 | 25 |
1882258 | 1882258 | 2021-11-04 | Mason | Illinois | 17125 | 2178 | 54 |
1882259 | 1882259 | 2021-11-04 | Massac | Illinois | 17127 | 2223 | 56 |
1882260 | 1882260 | 2021-11-04 | McDonough | Illinois | 17109 | 3810 | 77 |
1882261 | 1882261 | 2021-11-04 | McHenry | Illinois | 17111 | 35734 | 362 |
1882262 | 1882262 | 2021-11-04 | McLean | Illinois | 17113 | 23490 | 260 |
1882263 | 1882263 | 2021-11-04 | Menard | Illinois | 17129 | 1751 | 17 |
1882264 | 1882264 | 2021-11-04 | Mercer | Illinois | 17131 | 2125 | 37 |
1882265 | 1882265 | 2021-11-04 | Monroe | Illinois | 17133 | 5330 | 105 |
1882266 | 1882266 | 2021-11-04 | Montgomery | Illinois | 17135 | 5026 | 89 |
1882267 | 1882267 | 2021-11-04 | Morgan | Illinois | 17137 | 5355 | 123 |
1882268 | 1882268 | 2021-11-04 | Moultrie | Illinois | 17139 | 2467 | 41 |
1882269 | 1882269 | 2021-11-04 | Ogle | Illinois | 17141 | 7781 | 101 |
1882270 | 1882270 | 2021-11-04 | Peoria | Illinois | 17143 | 27463 | 409 |
1882271 | 1882271 | 2021-11-04 | Perry | Illinois | 17145 | 4387 | 85 |
1882272 | 1882272 | 2021-11-04 | Piatt | Illinois | 17147 | 2065 | 20 |
1882273 | 1882273 | 2021-11-04 | Pike | Illinois | 17149 | 2697 | 61 |
1882274 | 1882274 | 2021-11-04 | Pope | Illinois | 17151 | 568 | 6 |
1882275 | 1882275 | 2021-11-04 | Pulaski | Illinois | 17153 | 1067 | 12 |
1882276 | 1882276 | 2021-11-04 | Putnam | Illinois | 17155 | 575 | 5 |
1882277 | 1882277 | 2021-11-04 | Randolph | Illinois | 17157 | 5602 | 109 |
1882278 | 1882278 | 2021-11-04 | Richland | Illinois | 17159 | 2878 | 66 |
1882279 | 1882279 | 2021-11-04 | Rock Island | Illinois | 17161 | 19301 | 413 |
1882280 | 1882280 | 2021-11-04 | Saline | Illinois | 17165 | 4410 | 87 |
1882281 | 1882281 | 2021-11-04 | Sangamon | Illinois | 17167 | 26154 | 331 |
1882282 | 1882282 | 2021-11-04 | Schuyler | Illinois | 17169 | 1121 | 24 |
1882283 | 1882283 | 2021-11-04 | Scott | Illinois | 17171 | 718 | 7 |
1882284 | 1882284 | 2021-11-04 | Shelby | Illinois | 17173 | 3621 | 53 |
1882285 | 1882285 | 2021-11-04 | St. Clair | Illinois | 17163 | 40747 | 650 |
1882286 | 1882286 | 2021-11-04 | Stark | Illinois | 17175 | 835 | 29 |
1882287 | 1882287 | 2021-11-04 | Stephenson | Illinois | 17177 | 6132 | 115 |
1882288 | 1882288 | 2021-11-04 | Tazewell | Illinois | 17179 | 20934 | 374 |
1882289 | 1882289 | 2021-11-04 | Union | Illinois | 17181 | 3120 | 52 |
1882290 | 1882290 | 2021-11-04 | Unknown | Illinois | 0 | 848 | |
1882291 | 1882291 | 2021-11-04 | Vermilion | Illinois | 17183 | 14846 | 222 |
1882292 | 1882292 | 2021-11-04 | Wabash | Illinois | 17185 | 2188 | 22 |
1882293 | 1882293 | 2021-11-04 | Warren | Illinois | 17187 | 2492 | 71 |
1882294 | 1882294 | 2021-11-04 | Washington | Illinois | 17189 | 2152 | 35 |
1882295 | 1882295 | 2021-11-04 | Wayne | Illinois | 17191 | 3099 | 65 |
1882296 | 1882296 | 2021-11-04 | White | Illinois | 17193 | 2832 | 43 |
1882297 | 1882297 | 2021-11-04 | Whiteside | Illinois | 17195 | 8572 | 229 |
1882298 | 1882298 | 2021-11-04 | Will | Illinois | 17197 | 93284 | 1214 |
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);