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-03-19 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 |
---|---|---|---|---|---|---|---|
1135258 | 1135258 | 2021-03-19 | Adams | Illinois | 17001 | 8058 | 144 |
1135259 | 1135259 | 2021-03-19 | Alexander | Illinois | 17003 | 453 | 10 |
1135260 | 1135260 | 2021-03-19 | Bond | Illinois | 17005 | 1923 | 30 |
1135261 | 1135261 | 2021-03-19 | Boone | Illinois | 17007 | 6021 | 83 |
1135262 | 1135262 | 2021-03-19 | Brown | Illinois | 17009 | 676 | 12 |
1135263 | 1135263 | 2021-03-19 | Bureau | Illinois | 17011 | 3383 | 91 |
1135264 | 1135264 | 2021-03-19 | Calhoun | Illinois | 17013 | 491 | 5 |
1135265 | 1135265 | 2021-03-19 | Carroll | Illinois | 17015 | 1602 | 36 |
1135266 | 1135266 | 2021-03-19 | Cass | Illinois | 17017 | 1902 | 33 |
1135267 | 1135267 | 2021-03-19 | Champaign | Illinois | 17019 | 18625 | 141 |
1135268 | 1135268 | 2021-03-19 | Christian | Illinois | 17021 | 3375 | 89 |
1135269 | 1135269 | 2021-03-19 | Clark | Illinois | 17023 | 1705 | 40 |
1135270 | 1135270 | 2021-03-19 | Clay | Illinois | 17025 | 1450 | 47 |
1135271 | 1135271 | 2021-03-19 | Clinton | Illinois | 17027 | 5638 | 98 |
1135272 | 1135272 | 2021-03-19 | Coles | Illinois | 17029 | 5349 | 95 |
1135273 | 1135273 | 2021-03-19 | Cook | Illinois | 17031 | 486730 | 10101 |
1135274 | 1135274 | 2021-03-19 | Crawford | Illinois | 17033 | 2026 | 40 |
1135275 | 1135275 | 2021-03-19 | Cumberland | Illinois | 17035 | 1236 | 31 |
1135276 | 1135276 | 2021-03-19 | De Witt | Illinois | 17039 | 1299 | 30 |
1135277 | 1135277 | 2021-03-19 | DeKalb | Illinois | 17037 | 8662 | 120 |
1135278 | 1135278 | 2021-03-19 | Douglas | Illinois | 17041 | 2509 | 39 |
1135279 | 1135279 | 2021-03-19 | DuPage | Illinois | 17043 | 79730 | 1305 |
1135280 | 1135280 | 2021-03-19 | Edgar | Illinois | 17045 | 1613 | 59 |
1135281 | 1135281 | 2021-03-19 | Edwards | Illinois | 17047 | 537 | 13 |
1135282 | 1135282 | 2021-03-19 | Effingham | Illinois | 17049 | 4522 | 80 |
1135283 | 1135283 | 2021-03-19 | Fayette | Illinois | 17051 | 3078 | 57 |
1135284 | 1135284 | 2021-03-19 | Ford | Illinois | 17053 | 1628 | 54 |
1135285 | 1135285 | 2021-03-19 | Franklin | Illinois | 17055 | 4209 | 78 |
1135286 | 1135286 | 2021-03-19 | Fulton | Illinois | 17057 | 3082 | 56 |
1135287 | 1135287 | 2021-03-19 | Gallatin | Illinois | 17059 | 446 | 5 |
1135288 | 1135288 | 2021-03-19 | Greene | Illinois | 17061 | 1393 | 45 |
1135289 | 1135289 | 2021-03-19 | Grundy | Illinois | 17063 | 5334 | 72 |
1135290 | 1135290 | 2021-03-19 | Hamilton | Illinois | 17065 | 796 | 18 |
1135291 | 1135291 | 2021-03-19 | Hancock | Illinois | 17067 | 1687 | 40 |
1135292 | 1135292 | 2021-03-19 | Hardin | Illinois | 17069 | 357 | 12 |
1135293 | 1135293 | 2021-03-19 | Henderson | Illinois | 17071 | 511 | 23 |
1135294 | 1135294 | 2021-03-19 | Henry | Illinois | 17073 | 4414 | 87 |
1135295 | 1135295 | 2021-03-19 | Iroquois | Illinois | 17075 | 2808 | 65 |
1135296 | 1135296 | 2021-03-19 | Jackson | Illinois | 17077 | 4663 | 73 |
1135297 | 1135297 | 2021-03-19 | Jasper | Illinois | 17079 | 1116 | 19 |
1135298 | 1135298 | 2021-03-19 | Jefferson | Illinois | 17081 | 4037 | 119 |
1135299 | 1135299 | 2021-03-19 | Jersey | Illinois | 17083 | 2523 | 67 |
1135300 | 1135300 | 2021-03-19 | Jo Daviess | Illinois | 17085 | 1631 | 25 |
1135301 | 1135301 | 2021-03-19 | Johnson | Illinois | 17087 | 1364 | 18 |
1135302 | 1135302 | 2021-03-19 | Kane | Illinois | 17089 | 51946 | 789 |
1135303 | 1135303 | 2021-03-19 | Kankakee | Illinois | 17091 | 12807 | 200 |
1135304 | 1135304 | 2021-03-19 | Kendall | Illinois | 17093 | 11863 | 97 |
1135305 | 1135305 | 2021-03-19 | Knox | Illinois | 17095 | 5059 | 164 |
1135306 | 1135306 | 2021-03-19 | LaSalle | Illinois | 17099 | 11110 | 279 |
1135307 | 1135307 | 2021-03-19 | Lake | Illinois | 17097 | 61225 | 1017 |
1135308 | 1135308 | 2021-03-19 | Lawrence | Illinois | 17101 | 2354 | 33 |
1135309 | 1135309 | 2021-03-19 | Lee | Illinois | 17103 | 3524 | 84 |
1135310 | 1135310 | 2021-03-19 | Livingston | Illinois | 17105 | 4338 | 91 |
1135311 | 1135311 | 2021-03-19 | Logan | Illinois | 17107 | 3359 | 67 |
1135312 | 1135312 | 2021-03-19 | Macon | Illinois | 17115 | 9731 | 196 |
1135313 | 1135313 | 2021-03-19 | Macoupin | Illinois | 17117 | 4448 | 109 |
1135314 | 1135314 | 2021-03-19 | Madison | Illinois | 17119 | 28716 | 557 |
1135315 | 1135315 | 2021-03-19 | Marion | Illinois | 17121 | 4313 | 119 |
1135316 | 1135316 | 2021-03-19 | Marshall | Illinois | 17123 | 885 | 17 |
1135317 | 1135317 | 2021-03-19 | Mason | Illinois | 17125 | 1308 | 42 |
1135318 | 1135318 | 2021-03-19 | Massac | Illinois | 17127 | 1303 | 39 |
1135319 | 1135319 | 2021-03-19 | McDonough | Illinois | 17109 | 2368 | 53 |
1135320 | 1135320 | 2021-03-19 | McHenry | Illinois | 17111 | 25104 | 294 |
1135321 | 1135321 | 2021-03-19 | McLean | Illinois | 17113 | 15066 | 198 |
1135322 | 1135322 | 2021-03-19 | Menard | Illinois | 17129 | 1081 | 12 |
1135323 | 1135323 | 2021-03-19 | Mercer | Illinois | 17131 | 1299 | 33 |
1135324 | 1135324 | 2021-03-19 | Monroe | Illinois | 17133 | 4148 | 89 |
1135325 | 1135325 | 2021-03-19 | Montgomery | Illinois | 17135 | 3574 | 77 |
1135326 | 1135326 | 2021-03-19 | Morgan | Illinois | 17137 | 3728 | 100 |
1135327 | 1135327 | 2021-03-19 | Moultrie | Illinois | 17139 | 1520 | 32 |
1135328 | 1135328 | 2021-03-19 | Ogle | Illinois | 17141 | 5234 | 85 |
1135329 | 1135329 | 2021-03-19 | Peoria | Illinois | 17143 | 17632 | 286 |
1135330 | 1135330 | 2021-03-19 | Perry | Illinois | 17145 | 3095 | 68 |
1135331 | 1135331 | 2021-03-19 | Piatt | Illinois | 17147 | 1375 | 20 |
1135332 | 1135332 | 2021-03-19 | Pike | Illinois | 17149 | 1724 | 53 |
1135333 | 1135333 | 2021-03-19 | Pope | Illinois | 17151 | 293 | 3 |
1135334 | 1135334 | 2021-03-19 | Pulaski | Illinois | 17153 | 673 | 7 |
1135335 | 1135335 | 2021-03-19 | Putnam | Illinois | 17155 | 430 | 4 |
1135336 | 1135336 | 2021-03-19 | Randolph | Illinois | 17157 | 4004 | 87 |
1135337 | 1135337 | 2021-03-19 | Richland | Illinois | 17159 | 1653 | 48 |
1135338 | 1135338 | 2021-03-19 | Rock Island | Illinois | 17161 | 13404 | 337 |
1135339 | 1135339 | 2021-03-19 | Saline | Illinois | 17165 | 2379 | 65 |
1135340 | 1135340 | 2021-03-19 | Sangamon | Illinois | 17167 | 16561 | 265 |
1135341 | 1135341 | 2021-03-19 | Schuyler | Illinois | 17169 | 684 | 17 |
1135342 | 1135342 | 2021-03-19 | Scott | Illinois | 17171 | 452 | 1 |
1135343 | 1135343 | 2021-03-19 | Shelby | Illinois | 17173 | 2193 | 38 |
1135344 | 1135344 | 2021-03-19 | St. Clair | Illinois | 17163 | 28979 | 527 |
1135345 | 1135345 | 2021-03-19 | Stark | Illinois | 17175 | 552 | 23 |
1135346 | 1135346 | 2021-03-19 | Stephenson | Illinois | 17177 | 4204 | 97 |
1135347 | 1135347 | 2021-03-19 | Tazewell | Illinois | 17179 | 13986 | 276 |
1135348 | 1135348 | 2021-03-19 | Union | Illinois | 17181 | 2219 | 43 |
1135349 | 1135349 | 2021-03-19 | Unknown | Illinois | 0 | 259 | |
1135350 | 1135350 | 2021-03-19 | Vermilion | Illinois | 17183 | 8784 | 137 |
1135351 | 1135351 | 2021-03-19 | Wabash | Illinois | 17185 | 1313 | 15 |
1135352 | 1135352 | 2021-03-19 | Warren | Illinois | 17187 | 1668 | 47 |
1135353 | 1135353 | 2021-03-19 | Washington | Illinois | 17189 | 1601 | 31 |
1135354 | 1135354 | 2021-03-19 | Wayne | Illinois | 17191 | 1697 | 50 |
1135355 | 1135355 | 2021-03-19 | White | Illinois | 17193 | 1642 | 35 |
1135356 | 1135356 | 2021-03-19 | Whiteside | Illinois | 17195 | 6148 | 196 |
1135357 | 1135357 | 2021-03-19 | Will | Illinois | 17197 | 67085 | 1004 |
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);