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 439
- 17089 393
- 17111 393
- 17097 392
- 17035 389
- 17043 389
- 17163 389
- 17167 389
- 17203 389
- 17027 388
- 17195 388
- 17201 388
- 17143 387
- 17197 387
- 17077 385
- 17091 385
- 17093 385
- 17099 385
- 17119 385
- 17189 385
- 17199 385
- 17001 383
- 17021 383
- 17113 383
- 17037 382
- 17019 381
- 17085 381
- 17105 381
- 17161 381
- 17177 381
- …
county >30
- Cook 439
- Kane 393
- McHenry 393
- Lake 392
- Cumberland 389
- DuPage 389
- Sangamon 389
- St. Clair 389
- Woodford 389
- Clinton 388
- Whiteside 388
- Winnebago 388
- Peoria 387
- Will 387
- Jackson 385
- Kankakee 385
- Kendall 385
- LaSalle 385
- Madison 385
- Washington 385
- Williamson 385
- Adams 383
- Christian 383
- McLean 383
- DeKalb 382
- Champaign 381
- Jo Daviess 381
- Livingston 381
- Rock Island 381
- Stephenson 381
- …
state 1
- Illinois · 38,096 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193709 | 1193709 | 2021-04-06 | Adams | Illinois | 17001 | 8101 | 144 |
1193710 | 1193710 | 2021-04-06 | Alexander | Illinois | 17003 | 460 | 10 |
1193711 | 1193711 | 2021-04-06 | Bond | Illinois | 17005 | 1943 | 30 |
1193712 | 1193712 | 2021-04-06 | Boone | Illinois | 17007 | 6171 | 83 |
1193713 | 1193713 | 2021-04-06 | Brown | Illinois | 17009 | 681 | 12 |
1193714 | 1193714 | 2021-04-06 | Bureau | Illinois | 17011 | 3448 | 92 |
1193715 | 1193715 | 2021-04-06 | Calhoun | Illinois | 17013 | 505 | 5 |
1193716 | 1193716 | 2021-04-06 | Carroll | Illinois | 17015 | 1655 | 36 |
1193717 | 1193717 | 2021-04-06 | Cass | Illinois | 17017 | 1935 | 33 |
1193718 | 1193718 | 2021-04-06 | Champaign | Illinois | 17019 | 19227 | 144 |
1193719 | 1193719 | 2021-04-06 | Christian | Illinois | 17021 | 3433 | 89 |
1193720 | 1193720 | 2021-04-06 | Clark | Illinois | 17023 | 1731 | 40 |
1193721 | 1193721 | 2021-04-06 | Clay | Illinois | 17025 | 1462 | 47 |
1193722 | 1193722 | 2021-04-06 | Clinton | Illinois | 17027 | 5678 | 99 |
1193723 | 1193723 | 2021-04-06 | Coles | Illinois | 17029 | 5451 | 96 |
1193724 | 1193724 | 2021-04-06 | Cook | Illinois | 17031 | 505380 | 10264 |
1193725 | 1193725 | 2021-04-06 | Crawford | Illinois | 17033 | 2074 | 40 |
1193726 | 1193726 | 2021-04-06 | Cumberland | Illinois | 17035 | 1269 | 31 |
1193727 | 1193727 | 2021-04-06 | De Witt | Illinois | 17039 | 1339 | 30 |
1193728 | 1193728 | 2021-04-06 | DeKalb | Illinois | 17037 | 8987 | 122 |
1193729 | 1193729 | 2021-04-06 | Douglas | Illinois | 17041 | 2530 | 41 |
1193730 | 1193730 | 2021-04-06 | DuPage | Illinois | 17043 | 83350 | 1321 |
1193731 | 1193731 | 2021-04-06 | Edgar | Illinois | 17045 | 1641 | 59 |
1193732 | 1193732 | 2021-04-06 | Edwards | Illinois | 17047 | 542 | 13 |
1193733 | 1193733 | 2021-04-06 | Effingham | Illinois | 17049 | 4604 | 82 |
1193734 | 1193734 | 2021-04-06 | Fayette | Illinois | 17051 | 3108 | 57 |
1193735 | 1193735 | 2021-04-06 | Ford | Illinois | 17053 | 1652 | 54 |
1193736 | 1193736 | 2021-04-06 | Franklin | Illinois | 17055 | 4287 | 82 |
1193737 | 1193737 | 2021-04-06 | Fulton | Illinois | 17057 | 3414 | 58 |
1193738 | 1193738 | 2021-04-06 | Gallatin | Illinois | 17059 | 451 | 5 |
1193739 | 1193739 | 2021-04-06 | Greene | Illinois | 17061 | 1412 | 45 |
1193740 | 1193740 | 2021-04-06 | Grundy | Illinois | 17063 | 5478 | 74 |
1193741 | 1193741 | 2021-04-06 | Hamilton | Illinois | 17065 | 810 | 18 |
1193742 | 1193742 | 2021-04-06 | Hancock | Illinois | 17067 | 1706 | 40 |
1193743 | 1193743 | 2021-04-06 | Hardin | Illinois | 17069 | 362 | 12 |
1193744 | 1193744 | 2021-04-06 | Henderson | Illinois | 17071 | 518 | 23 |
1193745 | 1193745 | 2021-04-06 | Henry | Illinois | 17073 | 4567 | 89 |
1193746 | 1193746 | 2021-04-06 | Iroquois | Illinois | 17075 | 2857 | 65 |
1193747 | 1193747 | 2021-04-06 | Jackson | Illinois | 17077 | 4792 | 73 |
1193748 | 1193748 | 2021-04-06 | Jasper | Illinois | 17079 | 1137 | 19 |
1193749 | 1193749 | 2021-04-06 | Jefferson | Illinois | 17081 | 4090 | 119 |
1193750 | 1193750 | 2021-04-06 | Jersey | Illinois | 17083 | 2578 | 67 |
1193751 | 1193751 | 2021-04-06 | Jo Daviess | Illinois | 17085 | 1699 | 26 |
1193752 | 1193752 | 2021-04-06 | Johnson | Illinois | 17087 | 1376 | 20 |
1193753 | 1193753 | 2021-04-06 | Kane | Illinois | 17089 | 53632 | 797 |
1193754 | 1193754 | 2021-04-06 | Kankakee | Illinois | 17091 | 13121 | 202 |
1193755 | 1193755 | 2021-04-06 | Kendall | Illinois | 17093 | 12244 | 99 |
1193756 | 1193756 | 2021-04-06 | Knox | Illinois | 17095 | 5171 | 167 |
1193757 | 1193757 | 2021-04-06 | LaSalle | Illinois | 17099 | 11407 | 282 |
1193758 | 1193758 | 2021-04-06 | Lake | Illinois | 17097 | 62986 | 1027 |
1193759 | 1193759 | 2021-04-06 | Lawrence | Illinois | 17101 | 2383 | 33 |
1193760 | 1193760 | 2021-04-06 | Lee | Illinois | 17103 | 3777 | 87 |
1193761 | 1193761 | 2021-04-06 | Livingston | Illinois | 17105 | 4454 | 93 |
1193762 | 1193762 | 2021-04-06 | Logan | Illinois | 17107 | 3515 | 68 |
1193763 | 1193763 | 2021-04-06 | Macon | Illinois | 17115 | 9963 | 199 |
1193764 | 1193764 | 2021-04-06 | Macoupin | Illinois | 17117 | 4509 | 110 |
1193765 | 1193765 | 2021-04-06 | Madison | Illinois | 17119 | 29404 | 582 |
1193766 | 1193766 | 2021-04-06 | Marion | Illinois | 17121 | 4363 | 119 |
1193767 | 1193767 | 2021-04-06 | Marshall | Illinois | 17123 | 942 | 19 |
1193768 | 1193768 | 2021-04-06 | Mason | Illinois | 17125 | 1361 | 42 |
1193769 | 1193769 | 2021-04-06 | Massac | Illinois | 17127 | 1309 | 42 |
1193770 | 1193770 | 2021-04-06 | McDonough | Illinois | 17109 | 2469 | 54 |
1193771 | 1193771 | 2021-04-06 | McHenry | Illinois | 17111 | 25920 | 299 |
1193772 | 1193772 | 2021-04-06 | McLean | Illinois | 17113 | 15982 | 202 |
1193773 | 1193773 | 2021-04-06 | Menard | Illinois | 17129 | 1157 | 13 |
1193774 | 1193774 | 2021-04-06 | Mercer | Illinois | 17131 | 1327 | 33 |
1193775 | 1193775 | 2021-04-06 | Monroe | Illinois | 17133 | 4232 | 90 |
1193776 | 1193776 | 2021-04-06 | Montgomery | Illinois | 17135 | 3610 | 77 |
1193777 | 1193777 | 2021-04-06 | Morgan | Illinois | 17137 | 3793 | 101 |
1193778 | 1193778 | 2021-04-06 | Moultrie | Illinois | 17139 | 1543 | 33 |
1193779 | 1193779 | 2021-04-06 | Ogle | Illinois | 17141 | 5514 | 86 |
1193780 | 1193780 | 2021-04-06 | Peoria | Illinois | 17143 | 19459 | 293 |
1193781 | 1193781 | 2021-04-06 | Perry | Illinois | 17145 | 3119 | 68 |
1193782 | 1193782 | 2021-04-06 | Piatt | Illinois | 17147 | 1398 | 20 |
1193783 | 1193783 | 2021-04-06 | Pike | Illinois | 17149 | 1739 | 53 |
1193784 | 1193784 | 2021-04-06 | Pope | Illinois | 17151 | 302 | 3 |
1193785 | 1193785 | 2021-04-06 | Pulaski | Illinois | 17153 | 675 | 7 |
1193786 | 1193786 | 2021-04-06 | Putnam | Illinois | 17155 | 434 | 4 |
1193787 | 1193787 | 2021-04-06 | Randolph | Illinois | 17157 | 4058 | 88 |
1193788 | 1193788 | 2021-04-06 | Richland | Illinois | 17159 | 1696 | 48 |
1193789 | 1193789 | 2021-04-06 | Rock Island | Illinois | 17161 | 13873 | 342 |
1193790 | 1193790 | 2021-04-06 | Saline | Illinois | 17165 | 2452 | 69 |
1193791 | 1193791 | 2021-04-06 | Sangamon | Illinois | 17167 | 17188 | 269 |
1193792 | 1193792 | 2021-04-06 | Schuyler | Illinois | 17169 | 689 | 17 |
1193793 | 1193793 | 2021-04-06 | Scott | Illinois | 17171 | 461 | 1 |
1193794 | 1193794 | 2021-04-06 | Shelby | Illinois | 17173 | 2217 | 40 |
1193795 | 1193795 | 2021-04-06 | St. Clair | Illinois | 17163 | 29557 | 540 |
1193796 | 1193796 | 2021-04-06 | Stark | Illinois | 17175 | 569 | 23 |
1193797 | 1193797 | 2021-04-06 | Stephenson | Illinois | 17177 | 4346 | 98 |
1193798 | 1193798 | 2021-04-06 | Tazewell | Illinois | 17179 | 14894 | 280 |
1193799 | 1193799 | 2021-04-06 | Union | Illinois | 17181 | 2228 | 44 |
1193800 | 1193800 | 2021-04-06 | Unknown | Illinois | 0 | 262 | |
1193801 | 1193801 | 2021-04-06 | Vermilion | Illinois | 17183 | 8925 | 139 |
1193802 | 1193802 | 2021-04-06 | Wabash | Illinois | 17185 | 1336 | 15 |
1193803 | 1193803 | 2021-04-06 | Warren | Illinois | 17187 | 1703 | 49 |
1193804 | 1193804 | 2021-04-06 | Washington | Illinois | 17189 | 1617 | 31 |
1193805 | 1193805 | 2021-04-06 | Wayne | Illinois | 17191 | 1713 | 51 |
1193806 | 1193806 | 2021-04-06 | White | Illinois | 17193 | 1658 | 35 |
1193807 | 1193807 | 2021-04-06 | Whiteside | Illinois | 17195 | 6564 | 201 |
1193808 | 1193808 | 2021-04-06 | Will | Illinois | 17197 | 69467 | 1021 |
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);