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 2021-12-22 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2038215 | 2038215 | 2021-12-22 | Adams | Illinois | 17001 | 15685 | 193 |
2038216 | 2038216 | 2021-12-22 | Alexander | Illinois | 17003 | 858 | 13 |
2038217 | 2038217 | 2021-12-22 | Bond | Illinois | 17005 | 2957 | 34 |
2038218 | 2038218 | 2021-12-22 | Boone | Illinois | 17007 | 9697 | 101 |
2038219 | 2038219 | 2021-12-22 | Brown | Illinois | 17009 | 1194 | 19 |
2038220 | 2038220 | 2021-12-22 | Bureau | Illinois | 17011 | 5450 | 116 |
2038221 | 2038221 | 2021-12-22 | Calhoun | Illinois | 17013 | 926 | 7 |
2038222 | 2038222 | 2021-12-22 | Carroll | Illinois | 17015 | 2951 | 42 |
2038223 | 2038223 | 2021-12-22 | Cass | Illinois | 17017 | 3005 | 40 |
2038224 | 2038224 | 2021-12-22 | Champaign | Illinois | 17019 | 34103 | 227 |
2038225 | 2038225 | 2021-12-22 | Christian | Illinois | 17021 | 6485 | 102 |
2038226 | 2038226 | 2021-12-22 | Clark | Illinois | 17023 | 3188 | 53 |
2038227 | 2038227 | 2021-12-22 | Clay | Illinois | 17025 | 3246 | 60 |
2038228 | 2038228 | 2021-12-22 | Clinton | Illinois | 17027 | 7937 | 116 |
2038229 | 2038229 | 2021-12-22 | Coles | Illinois | 17029 | 9405 | 144 |
2038230 | 2038230 | 2021-12-22 | Cook | Illinois | 17031 | 749730 | 12366 |
2038231 | 2038231 | 2021-12-22 | Crawford | Illinois | 17033 | 3790 | 48 |
2038232 | 2038232 | 2021-12-22 | Cumberland | Illinois | 17035 | 2274 | 41 |
2038233 | 2038233 | 2021-12-22 | De Witt | Illinois | 17039 | 2803 | 39 |
2038234 | 2038234 | 2021-12-22 | DeKalb | Illinois | 17037 | 15240 | 159 |
2038235 | 2038235 | 2021-12-22 | Douglas | Illinois | 17041 | 3957 | 44 |
2038236 | 2038236 | 2021-12-22 | DuPage | Illinois | 17043 | 130919 | 1520 |
2038237 | 2038237 | 2021-12-22 | Edgar | Illinois | 17045 | 3359 | 71 |
2038238 | 2038238 | 2021-12-22 | Edwards | Illinois | 17047 | 1233 | 21 |
2038239 | 2038239 | 2021-12-22 | Effingham | Illinois | 17049 | 7707 | 124 |
2038240 | 2038240 | 2021-12-22 | Fayette | Illinois | 17051 | 4973 | 75 |
2038241 | 2038241 | 2021-12-22 | Ford | Illinois | 17053 | 2931 | 67 |
2038242 | 2038242 | 2021-12-22 | Franklin | Illinois | 17055 | 8316 | 140 |
2038243 | 2038243 | 2021-12-22 | Fulton | Illinois | 17057 | 6308 | 98 |
2038244 | 2038244 | 2021-12-22 | Gallatin | Illinois | 17059 | 897 | 11 |
2038245 | 2038245 | 2021-12-22 | Greene | Illinois | 17061 | 2460 | 53 |
2038246 | 2038246 | 2021-12-22 | Grundy | Illinois | 17063 | 9223 | 100 |
2038247 | 2038247 | 2021-12-22 | Hamilton | Illinois | 17065 | 1495 | 27 |
2038248 | 2038248 | 2021-12-22 | Hancock | Illinois | 17067 | 3300 | 46 |
2038249 | 2038249 | 2021-12-22 | Hardin | Illinois | 17069 | 742 | 16 |
2038250 | 2038250 | 2021-12-22 | Henderson | Illinois | 17071 | 866 | 24 |
2038251 | 2038251 | 2021-12-22 | Henry | Illinois | 17073 | 8184 | 123 |
2038252 | 2038252 | 2021-12-22 | Iroquois | Illinois | 17075 | 5198 | 89 |
2038253 | 2038253 | 2021-12-22 | Jackson | Illinois | 17077 | 8950 | 111 |
2038254 | 2038254 | 2021-12-22 | Jasper | Illinois | 17079 | 1878 | 23 |
2038255 | 2038255 | 2021-12-22 | Jefferson | Illinois | 17081 | 7326 | 150 |
2038256 | 2038256 | 2021-12-22 | Jersey | Illinois | 17083 | 4137 | 74 |
2038257 | 2038257 | 2021-12-22 | Jo Daviess | Illinois | 17085 | 2824 | 35 |
2038258 | 2038258 | 2021-12-22 | Johnson | Illinois | 17087 | 2646 | 38 |
2038259 | 2038259 | 2021-12-22 | Kane | Illinois | 17089 | 80744 | 990 |
2038260 | 2038260 | 2021-12-22 | Kankakee | Illinois | 17091 | 21355 | 293 |
2038261 | 2038261 | 2021-12-22 | Kendall | Illinois | 17093 | 20017 | 134 |
2038262 | 2038262 | 2021-12-22 | Knox | Illinois | 17095 | 8459 | 212 |
2038263 | 2038263 | 2021-12-22 | LaSalle | Illinois | 17099 | 18099 | 360 |
2038264 | 2038264 | 2021-12-22 | Lake | Illinois | 17097 | 95455 | 1205 |
2038265 | 2038265 | 2021-12-22 | Lawrence | Illinois | 17101 | 3788 | 46 |
2038266 | 2038266 | 2021-12-22 | Lee | Illinois | 17103 | 5727 | 106 |
2038267 | 2038267 | 2021-12-22 | Livingston | Illinois | 17105 | 7053 | 125 |
2038268 | 2038268 | 2021-12-22 | Logan | Illinois | 17107 | 5908 | 90 |
2038269 | 2038269 | 2021-12-22 | Macon | Illinois | 17115 | 18764 | 280 |
2038270 | 2038270 | 2021-12-22 | Macoupin | Illinois | 17117 | 8255 | 149 |
2038271 | 2038271 | 2021-12-22 | Madison | Illinois | 17119 | 46271 | 714 |
2038272 | 2038272 | 2021-12-22 | Marion | Illinois | 17121 | 8085 | 164 |
2038273 | 2038273 | 2021-12-22 | Marshall | Illinois | 17123 | 1793 | 25 |
2038274 | 2038274 | 2021-12-22 | Mason | Illinois | 17125 | 2580 | 54 |
2038275 | 2038275 | 2021-12-22 | Massac | Illinois | 17127 | 2552 | 59 |
2038276 | 2038276 | 2021-12-22 | McDonough | Illinois | 17109 | 4507 | 82 |
2038277 | 2038277 | 2021-12-22 | McHenry | Illinois | 17111 | 44204 | 387 |
2038278 | 2038278 | 2021-12-22 | McLean | Illinois | 17113 | 28166 | 276 |
2038279 | 2038279 | 2021-12-22 | Menard | Illinois | 17129 | 2092 | 19 |
2038280 | 2038280 | 2021-12-22 | Mercer | Illinois | 17131 | 2650 | 37 |
2038281 | 2038281 | 2021-12-22 | Monroe | Illinois | 17133 | 6045 | 107 |
2038282 | 2038282 | 2021-12-22 | Montgomery | Illinois | 17135 | 5868 | 91 |
2038283 | 2038283 | 2021-12-22 | Morgan | Illinois | 17137 | 5865 | 125 |
2038284 | 2038284 | 2021-12-22 | Moultrie | Illinois | 17139 | 2854 | 44 |
2038285 | 2038285 | 2021-12-22 | Ogle | Illinois | 17141 | 9675 | 114 |
2038286 | 2038286 | 2021-12-22 | Peoria | Illinois | 17143 | 32053 | 437 |
2038287 | 2038287 | 2021-12-22 | Perry | Illinois | 17145 | 4751 | 89 |
2038288 | 2038288 | 2021-12-22 | Piatt | Illinois | 17147 | 2764 | 22 |
2038289 | 2038289 | 2021-12-22 | Pike | Illinois | 17149 | 3405 | 61 |
2038290 | 2038290 | 2021-12-22 | Pope | Illinois | 17151 | 678 | 7 |
2038291 | 2038291 | 2021-12-22 | Pulaski | Illinois | 17153 | 1175 | 15 |
2038292 | 2038292 | 2021-12-22 | Putnam | Illinois | 17155 | 746 | 7 |
2038293 | 2038293 | 2021-12-22 | Randolph | Illinois | 17157 | 6064 | 113 |
2038294 | 2038294 | 2021-12-22 | Richland | Illinois | 17159 | 3398 | 75 |
2038295 | 2038295 | 2021-12-22 | Rock Island | Illinois | 17161 | 22952 | 442 |
2038296 | 2038296 | 2021-12-22 | Saline | Illinois | 17165 | 4852 | 90 |
2038297 | 2038297 | 2021-12-22 | Sangamon | Illinois | 17167 | 30639 | 347 |
2038298 | 2038298 | 2021-12-22 | Schuyler | Illinois | 17169 | 1256 | 26 |
2038299 | 2038299 | 2021-12-22 | Scott | Illinois | 17171 | 853 | 7 |
2038300 | 2038300 | 2021-12-22 | Shelby | Illinois | 17173 | 4294 | 57 |
2038301 | 2038301 | 2021-12-22 | St. Clair | Illinois | 17163 | 45761 | 674 |
2038302 | 2038302 | 2021-12-22 | Stark | Illinois | 17175 | 994 | 29 |
2038303 | 2038303 | 2021-12-22 | Stephenson | Illinois | 17177 | 8074 | 140 |
2038304 | 2038304 | 2021-12-22 | Tazewell | Illinois | 17179 | 25197 | 407 |
2038305 | 2038305 | 2021-12-22 | Union | Illinois | 17181 | 3498 | 56 |
2038306 | 2038306 | 2021-12-22 | Unknown | Illinois | 0 | 1093 | |
2038307 | 2038307 | 2021-12-22 | Vermilion | Illinois | 17183 | 18304 | 249 |
2038308 | 2038308 | 2021-12-22 | Wabash | Illinois | 17185 | 2357 | 22 |
2038309 | 2038309 | 2021-12-22 | Warren | Illinois | 17187 | 2869 | 73 |
2038310 | 2038310 | 2021-12-22 | Washington | Illinois | 17189 | 2367 | 36 |
2038311 | 2038311 | 2021-12-22 | Wayne | Illinois | 17191 | 3464 | 67 |
2038312 | 2038312 | 2021-12-22 | White | Illinois | 17193 | 3063 | 43 |
2038313 | 2038313 | 2021-12-22 | Whiteside | Illinois | 17195 | 10173 | 237 |
2038314 | 2038314 | 2021-12-22 | Will | Illinois | 17197 | 110581 | 1290 |
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);