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
- 17031 190
- 17089 144
- 17111 144
- 17097 143
- 17035 140
- 17043 140
- 17163 140
- 17167 140
- 17203 140
- 17027 139
- 17195 139
- 17201 139
- 17143 138
- 17197 138
- 17077 136
- 17091 136
- 17093 136
- 17099 136
- 17119 136
- 17189 136
- 17199 136
- 17001 134
- 17021 134
- 17113 134
- 17037 133
- 17019 132
- 17085 132
- 17105 132
- 17161 132
- 17177 132
- …
county >30
- Cook 190
- Kane 144
- McHenry 144
- Lake 143
- Cumberland 140
- DuPage 140
- Sangamon 140
- St. Clair 140
- Woodford 140
- Clinton 139
- Whiteside 139
- Winnebago 139
- Peoria 138
- Will 138
- Jackson 136
- Kankakee 136
- Kendall 136
- LaSalle 136
- Madison 136
- Washington 136
- Williamson 136
- Adams 134
- Christian 134
- McLean 134
- DeKalb 133
- Champaign 132
- Jo Daviess 132
- Livingston 132
- Rock Island 132
- Stephenson 132
- …
state 1
- Illinois · 12,533 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386535 | 386535 | 2020-07-31 | Adams | Illinois | 17001 | 393 | 2 |
386536 | 386536 | 2020-07-31 | Alexander | Illinois | 17003 | 35 | 0 |
386537 | 386537 | 2020-07-31 | Bond | Illinois | 17005 | 48 | 2 |
386538 | 386538 | 2020-07-31 | Boone | Illinois | 17007 | 722 | 23 |
386539 | 386539 | 2020-07-31 | Brown | Illinois | 17009 | 13 | 0 |
386540 | 386540 | 2020-07-31 | Bureau | Illinois | 17011 | 123 | 2 |
386541 | 386541 | 2020-07-31 | Calhoun | Illinois | 17013 | 6 | 0 |
386542 | 386542 | 2020-07-31 | Carroll | Illinois | 17015 | 43 | 3 |
386543 | 386543 | 2020-07-31 | Cass | Illinois | 17017 | 192 | 11 |
386544 | 386544 | 2020-07-31 | Champaign | Illinois | 17019 | 1486 | 19 |
386545 | 386545 | 2020-07-31 | Christian | Illinois | 17021 | 101 | 5 |
386546 | 386546 | 2020-07-31 | Clark | Illinois | 17023 | 66 | 0 |
386547 | 386547 | 2020-07-31 | Clay | Illinois | 17025 | 12 | 0 |
386548 | 386548 | 2020-07-31 | Clinton | Illinois | 17027 | 330 | 17 |
386549 | 386549 | 2020-07-31 | Coles | Illinois | 17029 | 367 | 19 |
386550 | 386550 | 2020-07-31 | Cook | Illinois | 17031 | 105493 | 4886 |
386551 | 386551 | 2020-07-31 | Crawford | Illinois | 17033 | 29 | 0 |
386552 | 386552 | 2020-07-31 | Cumberland | Illinois | 17035 | 46 | 2 |
386553 | 386553 | 2020-07-31 | De Witt | Illinois | 17039 | 27 | 0 |
386554 | 386554 | 2020-07-31 | DeKalb | Illinois | 17037 | 836 | 29 |
386555 | 386555 | 2020-07-31 | Douglas | Illinois | 17041 | 103 | 2 |
386556 | 386556 | 2020-07-31 | DuPage | Illinois | 17043 | 11267 | 510 |
386557 | 386557 | 2020-07-31 | Edgar | Illinois | 17045 | 25 | 0 |
386558 | 386558 | 2020-07-31 | Edwards | Illinois | 17047 | 12 | 0 |
386559 | 386559 | 2020-07-31 | Effingham | Illinois | 17049 | 83 | 1 |
386560 | 386560 | 2020-07-31 | Fayette | Illinois | 17051 | 53 | 3 |
386561 | 386561 | 2020-07-31 | Ford | Illinois | 17053 | 38 | 1 |
386562 | 386562 | 2020-07-31 | Franklin | Illinois | 17055 | 116 | 0 |
386563 | 386563 | 2020-07-31 | Fulton | Illinois | 17057 | 24 | 0 |
386564 | 386564 | 2020-07-31 | Gallatin | Illinois | 17059 | 42 | 0 |
386565 | 386565 | 2020-07-31 | Greene | Illinois | 17061 | 17 | 0 |
386566 | 386566 | 2020-07-31 | Grundy | Illinois | 17063 | 269 | 5 |
386567 | 386567 | 2020-07-31 | Hamilton | Illinois | 17065 | 19 | 0 |
386568 | 386568 | 2020-07-31 | Hancock | Illinois | 17067 | 28 | 1 |
386569 | 386569 | 2020-07-31 | Hardin | Illinois | 17069 | 16 | 0 |
386570 | 386570 | 2020-07-31 | Henderson | Illinois | 17071 | 9 | 0 |
386571 | 386571 | 2020-07-31 | Henry | Illinois | 17073 | 194 | 1 |
386572 | 386572 | 2020-07-31 | Iroquois | Illinois | 17075 | 240 | 7 |
386573 | 386573 | 2020-07-31 | Jackson | Illinois | 17077 | 616 | 19 |
386574 | 386574 | 2020-07-31 | Jasper | Illinois | 17079 | 50 | 7 |
386575 | 386575 | 2020-07-31 | Jefferson | Illinois | 17081 | 176 | 17 |
386576 | 386576 | 2020-07-31 | Jersey | Illinois | 17083 | 62 | 1 |
386577 | 386577 | 2020-07-31 | Jo Daviess | Illinois | 17085 | 110 | 1 |
386578 | 386578 | 2020-07-31 | Johnson | Illinois | 17087 | 53 | 0 |
386579 | 386579 | 2020-07-31 | Kane | Illinois | 17089 | 9148 | 298 |
386580 | 386580 | 2020-07-31 | Kankakee | Illinois | 17091 | 1741 | 68 |
386581 | 386581 | 2020-07-31 | Kendall | Illinois | 17093 | 1322 | 24 |
386582 | 386582 | 2020-07-31 | Knox | Illinois | 17095 | 241 | 1 |
386583 | 386583 | 2020-07-31 | LaSalle | Illinois | 17099 | 480 | 18 |
386584 | 386584 | 2020-07-31 | Lake | Illinois | 17097 | 11855 | 440 |
386585 | 386585 | 2020-07-31 | Lawrence | Illinois | 17101 | 40 | 0 |
386586 | 386586 | 2020-07-31 | Lee | Illinois | 17103 | 136 | 2 |
386587 | 386587 | 2020-07-31 | Livingston | Illinois | 17105 | 85 | 2 |
386588 | 386588 | 2020-07-31 | Logan | Illinois | 17107 | 79 | 0 |
386589 | 386589 | 2020-07-31 | Macon | Illinois | 17115 | 434 | 23 |
386590 | 386590 | 2020-07-31 | Macoupin | Illinois | 17117 | 127 | 3 |
386591 | 386591 | 2020-07-31 | Madison | Illinois | 17119 | 2099 | 72 |
386592 | 386592 | 2020-07-31 | Marion | Illinois | 17121 | 130 | 0 |
386593 | 386593 | 2020-07-31 | Marshall | Illinois | 17123 | 18 | 0 |
386594 | 386594 | 2020-07-31 | Mason | Illinois | 17125 | 42 | 0 |
386595 | 386595 | 2020-07-31 | Massac | Illinois | 17127 | 33 | 0 |
386596 | 386596 | 2020-07-31 | McDonough | Illinois | 17109 | 123 | 15 |
386597 | 386597 | 2020-07-31 | McHenry | Illinois | 17111 | 2934 | 114 |
386598 | 386598 | 2020-07-31 | McLean | Illinois | 17113 | 536 | 15 |
386599 | 386599 | 2020-07-31 | Menard | Illinois | 17129 | 44 | 0 |
386600 | 386600 | 2020-07-31 | Mercer | Illinois | 17131 | 65 | 0 |
386601 | 386601 | 2020-07-31 | Monroe | Illinois | 17133 | 261 | 13 |
386602 | 386602 | 2020-07-31 | Montgomery | Illinois | 17135 | 138 | 5 |
386603 | 386603 | 2020-07-31 | Morgan | Illinois | 17137 | 184 | 5 |
386604 | 386604 | 2020-07-31 | Moultrie | Illinois | 17139 | 52 | 0 |
386605 | 386605 | 2020-07-31 | Ogle | Illinois | 17141 | 378 | 5 |
386606 | 386606 | 2020-07-31 | Peoria | Illinois | 17143 | 1254 | 34 |
386607 | 386607 | 2020-07-31 | Perry | Illinois | 17145 | 101 | 1 |
386608 | 386608 | 2020-07-31 | Piatt | Illinois | 17147 | 37 | 0 |
386609 | 386609 | 2020-07-31 | Pike | Illinois | 17149 | 13 | 0 |
386610 | 386610 | 2020-07-31 | Pope | Illinois | 17151 | 7 | 0 |
386611 | 386611 | 2020-07-31 | Pulaski | Illinois | 17153 | 90 | 0 |
386612 | 386612 | 2020-07-31 | Putnam | Illinois | 17155 | 7 | 0 |
386613 | 386613 | 2020-07-31 | Randolph | Illinois | 17157 | 417 | 7 |
386614 | 386614 | 2020-07-31 | Richland | Illinois | 17159 | 12 | 0 |
386615 | 386615 | 2020-07-31 | Rock Island | Illinois | 17161 | 1575 | 31 |
386616 | 386616 | 2020-07-31 | Saline | Illinois | 17165 | 102 | 1 |
386617 | 386617 | 2020-07-31 | Sangamon | Illinois | 17167 | 969 | 34 |
386618 | 386618 | 2020-07-31 | Schuyler | Illinois | 17169 | 15 | 0 |
386619 | 386619 | 2020-07-31 | Scott | Illinois | 17171 | 9 | 0 |
386620 | 386620 | 2020-07-31 | Shelby | Illinois | 17173 | 53 | 1 |
386621 | 386621 | 2020-07-31 | St. Clair | Illinois | 17163 | 3792 | 155 |
386622 | 386622 | 2020-07-31 | Stark | Illinois | 17175 | 7 | 0 |
386623 | 386623 | 2020-07-31 | Stephenson | Illinois | 17177 | 313 | 6 |
386624 | 386624 | 2020-07-31 | Tazewell | Illinois | 17179 | 335 | 8 |
386625 | 386625 | 2020-07-31 | Union | Illinois | 17181 | 276 | 21 |
386626 | 386626 | 2020-07-31 | Unknown | Illinois | 1229 | 197 | |
386627 | 386627 | 2020-07-31 | Vermilion | Illinois | 17183 | 189 | 2 |
386628 | 386628 | 2020-07-31 | Wabash | Illinois | 17185 | 29 | 0 |
386629 | 386629 | 2020-07-31 | Warren | Illinois | 17187 | 179 | 0 |
386630 | 386630 | 2020-07-31 | Washington | Illinois | 17189 | 56 | 0 |
386631 | 386631 | 2020-07-31 | Wayne | Illinois | 17191 | 40 | 1 |
386632 | 386632 | 2020-07-31 | White | Illinois | 17193 | 56 | 0 |
386633 | 386633 | 2020-07-31 | Whiteside | Illinois | 17195 | 319 | 16 |
386634 | 386634 | 2020-07-31 | Will | Illinois | 17197 | 8474 | 339 |
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);