ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,502 rows where state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Cook 157
- Kane 111
- McHenry 111
- Lake 110
- Cumberland 107
- DuPage 107
- Sangamon 107
- St. Clair 107
- Woodford 107
- Clinton 106
- Whiteside 106
- Winnebago 106
- Peoria 105
- Will 105
- Jackson 103
- Kankakee 103
- Kendall 103
- LaSalle 103
- Madison 103
- Washington 103
- Williamson 103
- Adams 101
- Christian 101
- McLean 101
- DeKalb 100
- Champaign 99
- Jo Daviess 99
- Livingston 99
- Rock Island 99
- Stephenson 99
- …
state 1
- Illinois · 9,138 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281373 | 281373 | 2020-06-28 | Adams | Illinois | 17001 | 83 | 1 |
281374 | 281374 | 2020-06-28 | Alexander | Illinois | 17003 | 22 | 0 |
281375 | 281375 | 2020-06-28 | Bond | Illinois | 17005 | 13 | 1 |
281376 | 281376 | 2020-06-28 | Boone | Illinois | 17007 | 577 | 21 |
281377 | 281377 | 2020-06-28 | Brown | Illinois | 17009 | 10 | 0 |
281378 | 281378 | 2020-06-28 | Bureau | Illinois | 17011 | 25 | 1 |
281379 | 281379 | 2020-06-28 | Calhoun | Illinois | 17013 | 1 | 0 |
281380 | 281380 | 2020-06-28 | Carroll | Illinois | 17015 | 21 | 2 |
281381 | 281381 | 2020-06-28 | Cass | Illinois | 17017 | 127 | 1 |
281382 | 281382 | 2020-06-28 | Champaign | Illinois | 17019 | 847 | 12 |
281383 | 281383 | 2020-06-28 | Christian | Illinois | 17021 | 43 | 5 |
281384 | 281384 | 2020-06-28 | Clark | Illinois | 17023 | 15 | 0 |
281385 | 281385 | 2020-06-28 | Clay | Illinois | 17025 | 2 | 0 |
281386 | 281386 | 2020-06-28 | Clinton | Illinois | 17027 | 233 | 17 |
281387 | 281387 | 2020-06-28 | Coles | Illinois | 17029 | 161 | 17 |
281388 | 281388 | 2020-06-28 | Cook | Illinois | 17031 | 89755 | 4542 |
281389 | 281389 | 2020-06-28 | Crawford | Illinois | 17033 | 18 | 0 |
281390 | 281390 | 2020-06-28 | Cumberland | Illinois | 17035 | 11 | 0 |
281391 | 281391 | 2020-06-28 | De Witt | Illinois | 17039 | 4 | 0 |
281392 | 281392 | 2020-06-28 | DeKalb | Illinois | 17037 | 558 | 18 |
281393 | 281393 | 2020-06-28 | Douglas | Illinois | 17041 | 48 | 0 |
281394 | 281394 | 2020-06-28 | DuPage | Illinois | 17043 | 8951 | 469 |
281395 | 281395 | 2020-06-28 | Edgar | Illinois | 17045 | 9 | 0 |
281396 | 281396 | 2020-06-28 | Edwards | Illinois | 17047 | 2 | 0 |
281397 | 281397 | 2020-06-28 | Effingham | Illinois | 17049 | 11 | 1 |
281398 | 281398 | 2020-06-28 | Fayette | Illinois | 17051 | 23 | 3 |
281399 | 281399 | 2020-06-28 | Ford | Illinois | 17053 | 30 | 1 |
281400 | 281400 | 2020-06-28 | Franklin | Illinois | 17055 | 13 | 0 |
281401 | 281401 | 2020-06-28 | Fulton | Illinois | 17057 | 15 | 0 |
281402 | 281402 | 2020-06-28 | Gallatin | Illinois | 17059 | 2 | 0 |
281403 | 281403 | 2020-06-28 | Greene | Illinois | 17061 | 9 | 0 |
281404 | 281404 | 2020-06-28 | Grundy | Illinois | 17063 | 160 | 4 |
281405 | 281405 | 2020-06-28 | Hamilton | Illinois | 17065 | 4 | 0 |
281406 | 281406 | 2020-06-28 | Hancock | Illinois | 17067 | 18 | 1 |
281407 | 281407 | 2020-06-28 | Hardin | Illinois | 17069 | 1 | 0 |
281408 | 281408 | 2020-06-28 | Henderson | Illinois | 17071 | 8 | 0 |
281409 | 281409 | 2020-06-28 | Henry | Illinois | 17073 | 83 | 1 |
281410 | 281410 | 2020-06-28 | Iroquois | Illinois | 17075 | 156 | 5 |
281411 | 281411 | 2020-06-28 | Jackson | Illinois | 17077 | 329 | 19 |
281412 | 281412 | 2020-06-28 | Jasper | Illinois | 17079 | 46 | 7 |
281413 | 281413 | 2020-06-28 | Jefferson | Illinois | 17081 | 106 | 17 |
281414 | 281414 | 2020-06-28 | Jersey | Illinois | 17083 | 35 | 1 |
281415 | 281415 | 2020-06-28 | Jo Daviess | Illinois | 17085 | 42 | 1 |
281416 | 281416 | 2020-06-28 | Johnson | Illinois | 17087 | 20 | 0 |
281417 | 281417 | 2020-06-28 | Kane | Illinois | 17089 | 7683 | 266 |
281418 | 281418 | 2020-06-28 | Kankakee | Illinois | 17091 | 1342 | 65 |
281419 | 281419 | 2020-06-28 | Kendall | Illinois | 17093 | 990 | 23 |
281420 | 281420 | 2020-06-28 | Knox | Illinois | 17095 | 124 | 0 |
281421 | 281421 | 2020-06-28 | LaSalle | Illinois | 17099 | 205 | 17 |
281422 | 281422 | 2020-06-28 | Lake | Illinois | 17097 | 9644 | 415 |
281423 | 281423 | 2020-06-28 | Lawrence | Illinois | 17101 | 7 | 0 |
281424 | 281424 | 2020-06-28 | Lee | Illinois | 17103 | 97 | 2 |
281425 | 281425 | 2020-06-28 | Livingston | Illinois | 17105 | 43 | 2 |
281426 | 281426 | 2020-06-28 | Logan | Illinois | 17107 | 13 | 0 |
281427 | 281427 | 2020-06-28 | Macon | Illinois | 17115 | 227 | 22 |
281428 | 281428 | 2020-06-28 | Macoupin | Illinois | 17117 | 51 | 3 |
281429 | 281429 | 2020-06-28 | Madison | Illinois | 17119 | 917 | 68 |
281430 | 281430 | 2020-06-28 | Marion | Illinois | 17121 | 65 | 0 |
281431 | 281431 | 2020-06-28 | Marshall | Illinois | 17123 | 8 | 0 |
281432 | 281432 | 2020-06-28 | Mason | Illinois | 17125 | 22 | 0 |
281433 | 281433 | 2020-06-28 | Massac | Illinois | 17127 | 11 | 0 |
281434 | 281434 | 2020-06-28 | McDonough | Illinois | 17109 | 100 | 15 |
281435 | 281435 | 2020-06-28 | McHenry | Illinois | 17111 | 1999 | 97 |
281436 | 281436 | 2020-06-28 | McLean | Illinois | 17113 | 257 | 13 |
281437 | 281437 | 2020-06-28 | Menard | Illinois | 17129 | 24 | 0 |
281438 | 281438 | 2020-06-28 | Mercer | Illinois | 17131 | 19 | 0 |
281439 | 281439 | 2020-06-28 | Monroe | Illinois | 17133 | 123 | 13 |
281440 | 281440 | 2020-06-28 | Montgomery | Illinois | 17135 | 41 | 0 |
281441 | 281441 | 2020-06-28 | Morgan | Illinois | 17137 | 126 | 3 |
281442 | 281442 | 2020-06-28 | Moultrie | Illinois | 17139 | 17 | 0 |
281443 | 281443 | 2020-06-28 | Ogle | Illinois | 17141 | 252 | 4 |
281444 | 281444 | 2020-06-28 | Peoria | Illinois | 17143 | 476 | 28 |
281445 | 281445 | 2020-06-28 | Perry | Illinois | 17145 | 49 | 0 |
281446 | 281446 | 2020-06-28 | Piatt | Illinois | 17147 | 19 | 0 |
281447 | 281447 | 2020-06-28 | Pike | Illinois | 17149 | 2 | 0 |
281448 | 281448 | 2020-06-28 | Pope | Illinois | 17151 | 1 | 0 |
281449 | 281449 | 2020-06-28 | Pulaski | Illinois | 17153 | 74 | 0 |
281450 | 281450 | 2020-06-28 | Putnam | Illinois | 17155 | 1 | 0 |
281451 | 281451 | 2020-06-28 | Randolph | Illinois | 17157 | 279 | 7 |
281452 | 281452 | 2020-06-28 | Richland | Illinois | 17159 | 4 | 0 |
281453 | 281453 | 2020-06-28 | Rock Island | Illinois | 17161 | 924 | 28 |
281454 | 281454 | 2020-06-28 | Saline | Illinois | 17165 | 9 | 0 |
281455 | 281455 | 2020-06-28 | Sangamon | Illinois | 17167 | 411 | 33 |
281456 | 281456 | 2020-06-28 | Schuyler | Illinois | 17169 | 13 | 0 |
281457 | 281457 | 2020-06-28 | Shelby | Illinois | 17173 | 18 | 1 |
281458 | 281458 | 2020-06-28 | St. Clair | Illinois | 17163 | 1956 | 138 |
281459 | 281459 | 2020-06-28 | Stark | Illinois | 17175 | 3 | 0 |
281460 | 281460 | 2020-06-28 | Stephenson | Illinois | 17177 | 268 | 5 |
281461 | 281461 | 2020-06-28 | Tazewell | Illinois | 17179 | 120 | 7 |
281462 | 281462 | 2020-06-28 | Union | Illinois | 17181 | 184 | 19 |
281463 | 281463 | 2020-06-28 | Unknown | Illinois | 1053 | 201 | |
281464 | 281464 | 2020-06-28 | Vermilion | Illinois | 17183 | 65 | 2 |
281465 | 281465 | 2020-06-28 | Wabash | Illinois | 17185 | 22 | 0 |
281466 | 281466 | 2020-06-28 | Warren | Illinois | 17187 | 135 | 0 |
281467 | 281467 | 2020-06-28 | Washington | Illinois | 17189 | 19 | 0 |
281468 | 281468 | 2020-06-28 | Wayne | Illinois | 17191 | 12 | 1 |
281469 | 281469 | 2020-06-28 | White | Illinois | 17193 | 4 | 0 |
281470 | 281470 | 2020-06-28 | Whiteside | Illinois | 17195 | 183 | 15 |
281471 | 281471 | 2020-06-28 | Will | Illinois | 17197 | 6608 | 319 |
281472 | 281472 | 2020-06-28 | Williamson | Illinois | 17199 | 113 | 4 |
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);