ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-01-11" 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 |
---|---|---|---|---|---|---|---|
2103229 | 2103229 | 2022-01-11 | Adams | Illinois | 17001 | 17991 | 205 |
2103230 | 2103230 | 2022-01-11 | Alexander | Illinois | 17003 | 953 | 13 |
2103231 | 2103231 | 2022-01-11 | Bond | Illinois | 17005 | 3401 | 34 |
2103232 | 2103232 | 2022-01-11 | Boone | Illinois | 17007 | 11001 | 106 |
2103233 | 2103233 | 2022-01-11 | Brown | Illinois | 17009 | 1336 | 19 |
2103234 | 2103234 | 2022-01-11 | Bureau | Illinois | 17011 | 6536 | 127 |
2103235 | 2103235 | 2022-01-11 | Calhoun | Illinois | 17013 | 1210 | 7 |
2103236 | 2103236 | 2022-01-11 | Carroll | Illinois | 17015 | 3236 | 43 |
2103237 | 2103237 | 2022-01-11 | Cass | Illinois | 17017 | 3589 | 41 |
2103238 | 2103238 | 2022-01-11 | Champaign | Illinois | 17019 | 46440 | 241 |
2103239 | 2103239 | 2022-01-11 | Christian | Illinois | 17021 | 7681 | 115 |
2103240 | 2103240 | 2022-01-11 | Clark | Illinois | 17023 | 3579 | 54 |
2103241 | 2103241 | 2022-01-11 | Clay | Illinois | 17025 | 3729 | 64 |
2103242 | 2103242 | 2022-01-11 | Clinton | Illinois | 17027 | 9692 | 117 |
2103243 | 2103243 | 2022-01-11 | Coles | Illinois | 17029 | 11302 | 148 |
2103244 | 2103244 | 2022-01-11 | Cook | Illinois | 17031 | 955286 | 12906 |
2103245 | 2103245 | 2022-01-11 | Crawford | Illinois | 17033 | 4193 | 52 |
2103246 | 2103246 | 2022-01-11 | Cumberland | Illinois | 17035 | 2571 | 43 |
2103247 | 2103247 | 2022-01-11 | De Witt | Illinois | 17039 | 3398 | 40 |
2103248 | 2103248 | 2022-01-11 | DeKalb | Illinois | 17037 | 18501 | 165 |
2103249 | 2103249 | 2022-01-11 | Douglas | Illinois | 17041 | 4718 | 49 |
2103250 | 2103250 | 2022-01-11 | DuPage | Illinois | 17043 | 167764 | 1566 |
2103251 | 2103251 | 2022-01-11 | Edgar | Illinois | 17045 | 3838 | 75 |
2103252 | 2103252 | 2022-01-11 | Edwards | Illinois | 17047 | 1356 | 23 |
2103253 | 2103253 | 2022-01-11 | Effingham | Illinois | 17049 | 8660 | 125 |
2103254 | 2103254 | 2022-01-11 | Fayette | Illinois | 17051 | 5588 | 80 |
2103255 | 2103255 | 2022-01-11 | Ford | Illinois | 17053 | 3561 | 69 |
2103256 | 2103256 | 2022-01-11 | Franklin | Illinois | 17055 | 9282 | 147 |
2103257 | 2103257 | 2022-01-11 | Fulton | Illinois | 17057 | 7586 | 109 |
2103258 | 2103258 | 2022-01-11 | Gallatin | Illinois | 17059 | 986 | 11 |
2103259 | 2103259 | 2022-01-11 | Greene | Illinois | 17061 | 2919 | 53 |
2103260 | 2103260 | 2022-01-11 | Grundy | Illinois | 17063 | 10894 | 112 |
2103261 | 2103261 | 2022-01-11 | Hamilton | Illinois | 17065 | 1662 | 28 |
2103262 | 2103262 | 2022-01-11 | Hancock | Illinois | 17067 | 3526 | 49 |
2103263 | 2103263 | 2022-01-11 | Hardin | Illinois | 17069 | 823 | 17 |
2103264 | 2103264 | 2022-01-11 | Henderson | Illinois | 17071 | 941 | 24 |
2103265 | 2103265 | 2022-01-11 | Henry | Illinois | 17073 | 9812 | 128 |
2103266 | 2103266 | 2022-01-11 | Iroquois | Illinois | 17075 | 6014 | 94 |
2103267 | 2103267 | 2022-01-11 | Jackson | Illinois | 17077 | 11272 | 113 |
2103268 | 2103268 | 2022-01-11 | Jasper | Illinois | 17079 | 2120 | 26 |
2103269 | 2103269 | 2022-01-11 | Jefferson | Illinois | 17081 | 8290 | 154 |
2103270 | 2103270 | 2022-01-11 | Jersey | Illinois | 17083 | 4983 | 77 |
2103271 | 2103271 | 2022-01-11 | Jo Daviess | Illinois | 17085 | 3163 | 35 |
2103272 | 2103272 | 2022-01-11 | Johnson | Illinois | 17087 | 2956 | 41 |
2103273 | 2103273 | 2022-01-11 | Kane | Illinois | 17089 | 99335 | 1022 |
2103274 | 2103274 | 2022-01-11 | Kankakee | Illinois | 17091 | 24954 | 314 |
2103275 | 2103275 | 2022-01-11 | Kendall | Illinois | 17093 | 25410 | 137 |
2103276 | 2103276 | 2022-01-11 | Knox | Illinois | 17095 | 10342 | 217 |
2103277 | 2103277 | 2022-01-11 | LaSalle | Illinois | 17099 | 22772 | 387 |
2103278 | 2103278 | 2022-01-11 | Lake | Illinois | 17097 | 117448 | 1246 |
2103279 | 2103279 | 2022-01-11 | Lawrence | Illinois | 17101 | 4163 | 47 |
2103280 | 2103280 | 2022-01-11 | Lee | Illinois | 17103 | 6877 | 110 |
2103281 | 2103281 | 2022-01-11 | Livingston | Illinois | 17105 | 8372 | 128 |
2103282 | 2103282 | 2022-01-11 | Logan | Illinois | 17107 | 7294 | 91 |
2103283 | 2103283 | 2022-01-11 | Macon | Illinois | 17115 | 23105 | 297 |
2103284 | 2103284 | 2022-01-11 | Macoupin | Illinois | 17117 | 9735 | 152 |
2103285 | 2103285 | 2022-01-11 | Madison | Illinois | 17119 | 56678 | 738 |
2103286 | 2103286 | 2022-01-11 | Marion | Illinois | 17121 | 9366 | 175 |
2103287 | 2103287 | 2022-01-11 | Marshall | Illinois | 17123 | 2220 | 26 |
2103288 | 2103288 | 2022-01-11 | Mason | Illinois | 17125 | 3029 | 57 |
2103289 | 2103289 | 2022-01-11 | Massac | Illinois | 17127 | 2857 | 64 |
2103290 | 2103290 | 2022-01-11 | McDonough | Illinois | 17109 | 5241 | 86 |
2103291 | 2103291 | 2022-01-11 | McHenry | Illinois | 17111 | 54134 | 404 |
2103292 | 2103292 | 2022-01-11 | McLean | Illinois | 17113 | 37435 | 289 |
2103293 | 2103293 | 2022-01-11 | Menard | Illinois | 17129 | 2714 | 19 |
2103294 | 2103294 | 2022-01-11 | Mercer | Illinois | 17131 | 3113 | 38 |
2103295 | 2103295 | 2022-01-11 | Monroe | Illinois | 17133 | 7535 | 109 |
2103296 | 2103296 | 2022-01-11 | Montgomery | Illinois | 17135 | 7189 | 94 |
2103297 | 2103297 | 2022-01-11 | Morgan | Illinois | 17137 | 6964 | 126 |
2103298 | 2103298 | 2022-01-11 | Moultrie | Illinois | 17139 | 3259 | 47 |
2103299 | 2103299 | 2022-01-11 | Ogle | Illinois | 17141 | 11124 | 125 |
2103300 | 2103300 | 2022-01-11 | Peoria | Illinois | 17143 | 39419 | 476 |
2103301 | 2103301 | 2022-01-11 | Perry | Illinois | 17145 | 5388 | 93 |
2103302 | 2103302 | 2022-01-11 | Piatt | Illinois | 17147 | 3446 | 23 |
2103303 | 2103303 | 2022-01-11 | Pike | Illinois | 17149 | 3965 | 63 |
2103304 | 2103304 | 2022-01-11 | Pope | Illinois | 17151 | 749 | 7 |
2103305 | 2103305 | 2022-01-11 | Pulaski | Illinois | 17153 | 1305 | 15 |
2103306 | 2103306 | 2022-01-11 | Putnam | Illinois | 17155 | 888 | 8 |
2103307 | 2103307 | 2022-01-11 | Randolph | Illinois | 17157 | 7133 | 115 |
2103308 | 2103308 | 2022-01-11 | Richland | Illinois | 17159 | 3829 | 76 |
2103309 | 2103309 | 2022-01-11 | Rock Island | Illinois | 17161 | 27254 | 457 |
2103310 | 2103310 | 2022-01-11 | Saline | Illinois | 17165 | 5626 | 95 |
2103311 | 2103311 | 2022-01-11 | Sangamon | Illinois | 17167 | 40885 | 358 |
2103312 | 2103312 | 2022-01-11 | Schuyler | Illinois | 17169 | 1525 | 27 |
2103313 | 2103313 | 2022-01-11 | Scott | Illinois | 17171 | 1039 | 9 |
2103314 | 2103314 | 2022-01-11 | Shelby | Illinois | 17173 | 4864 | 63 |
2103315 | 2103315 | 2022-01-11 | St. Clair | Illinois | 17163 | 56010 | 696 |
2103316 | 2103316 | 2022-01-11 | Stark | Illinois | 17175 | 1140 | 30 |
2103317 | 2103317 | 2022-01-11 | Stephenson | Illinois | 17177 | 9235 | 149 |
2103318 | 2103318 | 2022-01-11 | Tazewell | Illinois | 17179 | 30373 | 429 |
2103319 | 2103319 | 2022-01-11 | Union | Illinois | 17181 | 3968 | 61 |
2103320 | 2103320 | 2022-01-11 | Unknown | Illinois | 0 | 1333 | |
2103321 | 2103321 | 2022-01-11 | Vermilion | Illinois | 17183 | 21798 | 264 |
2103322 | 2103322 | 2022-01-11 | Wabash | Illinois | 17185 | 2660 | 22 |
2103323 | 2103323 | 2022-01-11 | Warren | Illinois | 17187 | 3318 | 76 |
2103324 | 2103324 | 2022-01-11 | Washington | Illinois | 17189 | 2791 | 37 |
2103325 | 2103325 | 2022-01-11 | Wayne | Illinois | 17191 | 3894 | 68 |
2103326 | 2103326 | 2022-01-11 | White | Illinois | 17193 | 3410 | 45 |
2103327 | 2103327 | 2022-01-11 | Whiteside | Illinois | 17195 | 11997 | 242 |
2103328 | 2103328 | 2022-01-11 | Will | Illinois | 17197 | 137073 | 1349 |
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);