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 201
- 17089 155
- 17111 155
- 17097 154
- 17035 151
- 17043 151
- 17163 151
- 17167 151
- 17203 151
- 17027 150
- 17195 150
- 17201 150
- 17143 149
- 17197 149
- 17077 147
- 17091 147
- 17093 147
- 17099 147
- 17119 147
- 17189 147
- 17199 147
- 17001 145
- 17021 145
- 17113 145
- 17037 144
- 17019 143
- 17085 143
- 17105 143
- 17161 143
- 17177 143
- …
county >30
- Cook 201
- Kane 155
- McHenry 155
- Lake 154
- Cumberland 151
- DuPage 151
- Sangamon 151
- St. Clair 151
- Woodford 151
- Clinton 150
- Whiteside 150
- Winnebago 150
- Peoria 149
- Will 149
- Jackson 147
- Kankakee 147
- Kendall 147
- LaSalle 147
- Madison 147
- Washington 147
- Williamson 147
- Adams 145
- Christian 145
- McLean 145
- DeKalb 144
- Champaign 143
- Jo Daviess 143
- Livingston 143
- Rock Island 143
- Stephenson 143
- …
state 1
- Illinois · 13,666 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
421938 | 421938 | 2020-08-11 | Adams | Illinois | 17001 | 557 | 7 |
421939 | 421939 | 2020-08-11 | Alexander | Illinois | 17003 | 37 | 0 |
421940 | 421940 | 2020-08-11 | Bond | Illinois | 17005 | 62 | 3 |
421941 | 421941 | 2020-08-11 | Boone | Illinois | 17007 | 769 | 23 |
421942 | 421942 | 2020-08-11 | Brown | Illinois | 17009 | 15 | 0 |
421943 | 421943 | 2020-08-11 | Bureau | Illinois | 17011 | 231 | 3 |
421944 | 421944 | 2020-08-11 | Calhoun | Illinois | 17013 | 9 | 0 |
421945 | 421945 | 2020-08-11 | Carroll | Illinois | 17015 | 61 | 4 |
421946 | 421946 | 2020-08-11 | Cass | Illinois | 17017 | 233 | 11 |
421947 | 421947 | 2020-08-11 | Champaign | Illinois | 17019 | 1693 | 19 |
421948 | 421948 | 2020-08-11 | Christian | Illinois | 17021 | 143 | 5 |
421949 | 421949 | 2020-08-11 | Clark | Illinois | 17023 | 87 | 2 |
421950 | 421950 | 2020-08-11 | Clay | Illinois | 17025 | 26 | 0 |
421951 | 421951 | 2020-08-11 | Clinton | Illinois | 17027 | 415 | 17 |
421952 | 421952 | 2020-08-11 | Coles | Illinois | 17029 | 492 | 21 |
421953 | 421953 | 2020-08-11 | Cook | Illinois | 17031 | 112485 | 4933 |
421954 | 421954 | 2020-08-11 | Crawford | Illinois | 17033 | 30 | 0 |
421955 | 421955 | 2020-08-11 | Cumberland | Illinois | 17035 | 57 | 3 |
421956 | 421956 | 2020-08-11 | De Witt | Illinois | 17039 | 34 | 0 |
421957 | 421957 | 2020-08-11 | DeKalb | Illinois | 17037 | 977 | 30 |
421958 | 421958 | 2020-08-11 | Douglas | Illinois | 17041 | 122 | 2 |
421959 | 421959 | 2020-08-11 | DuPage | Illinois | 17043 | 12427 | 522 |
421960 | 421960 | 2020-08-11 | Edgar | Illinois | 17045 | 29 | 0 |
421961 | 421961 | 2020-08-11 | Edwards | Illinois | 17047 | 20 | 0 |
421962 | 421962 | 2020-08-11 | Effingham | Illinois | 17049 | 163 | 1 |
421963 | 421963 | 2020-08-11 | Fayette | Illinois | 17051 | 69 | 3 |
421964 | 421964 | 2020-08-11 | Ford | Illinois | 17053 | 50 | 2 |
421965 | 421965 | 2020-08-11 | Franklin | Illinois | 17055 | 194 | 1 |
421966 | 421966 | 2020-08-11 | Fulton | Illinois | 17057 | 35 | 0 |
421967 | 421967 | 2020-08-11 | Gallatin | Illinois | 17059 | 51 | 2 |
421968 | 421968 | 2020-08-11 | Greene | Illinois | 17061 | 59 | 0 |
421969 | 421969 | 2020-08-11 | Grundy | Illinois | 17063 | 334 | 5 |
421970 | 421970 | 2020-08-11 | Hamilton | Illinois | 17065 | 29 | 0 |
421971 | 421971 | 2020-08-11 | Hancock | Illinois | 17067 | 63 | 1 |
421972 | 421972 | 2020-08-11 | Hardin | Illinois | 17069 | 18 | 0 |
421973 | 421973 | 2020-08-11 | Henderson | Illinois | 17071 | 13 | 0 |
421974 | 421974 | 2020-08-11 | Henry | Illinois | 17073 | 253 | 1 |
421975 | 421975 | 2020-08-11 | Iroquois | Illinois | 17075 | 267 | 11 |
421976 | 421976 | 2020-08-11 | Jackson | Illinois | 17077 | 731 | 20 |
421977 | 421977 | 2020-08-11 | Jasper | Illinois | 17079 | 60 | 7 |
421978 | 421978 | 2020-08-11 | Jefferson | Illinois | 17081 | 292 | 19 |
421979 | 421979 | 2020-08-11 | Jersey | Illinois | 17083 | 117 | 2 |
421980 | 421980 | 2020-08-11 | Jo Daviess | Illinois | 17085 | 130 | 1 |
421981 | 421981 | 2020-08-11 | Johnson | Illinois | 17087 | 71 | 0 |
421982 | 421982 | 2020-08-11 | Kane | Illinois | 17089 | 9933 | 305 |
421983 | 421983 | 2020-08-11 | Kankakee | Illinois | 17091 | 1883 | 69 |
421984 | 421984 | 2020-08-11 | Kendall | Illinois | 17093 | 1451 | 25 |
421985 | 421985 | 2020-08-11 | Knox | Illinois | 17095 | 313 | 1 |
421986 | 421986 | 2020-08-11 | LaSalle | Illinois | 17099 | 801 | 24 |
421987 | 421987 | 2020-08-11 | Lake | Illinois | 17097 | 12852 | 447 |
421988 | 421988 | 2020-08-11 | Lawrence | Illinois | 17101 | 51 | 0 |
421989 | 421989 | 2020-08-11 | Lee | Illinois | 17103 | 178 | 1 |
421990 | 421990 | 2020-08-11 | Livingston | Illinois | 17105 | 122 | 3 |
421991 | 421991 | 2020-08-11 | Logan | Illinois | 17107 | 157 | 1 |
421992 | 421992 | 2020-08-11 | Macon | Illinois | 17115 | 650 | 23 |
421993 | 421993 | 2020-08-11 | Macoupin | Illinois | 17117 | 182 | 3 |
421994 | 421994 | 2020-08-11 | Madison | Illinois | 17119 | 2702 | 78 |
421995 | 421995 | 2020-08-11 | Marion | Illinois | 17121 | 165 | 0 |
421996 | 421996 | 2020-08-11 | Marshall | Illinois | 17123 | 28 | 0 |
421997 | 421997 | 2020-08-11 | Mason | Illinois | 17125 | 56 | 0 |
421998 | 421998 | 2020-08-11 | Massac | Illinois | 17127 | 41 | 0 |
421999 | 421999 | 2020-08-11 | McDonough | Illinois | 17109 | 145 | 15 |
422000 | 422000 | 2020-08-11 | McHenry | Illinois | 17111 | 3314 | 115 |
422001 | 422001 | 2020-08-11 | McLean | Illinois | 17113 | 670 | 15 |
422002 | 422002 | 2020-08-11 | Menard | Illinois | 17129 | 57 | 0 |
422003 | 422003 | 2020-08-11 | Mercer | Illinois | 17131 | 76 | 4 |
422004 | 422004 | 2020-08-11 | Monroe | Illinois | 17133 | 323 | 13 |
422005 | 422005 | 2020-08-11 | Montgomery | Illinois | 17135 | 171 | 6 |
422006 | 422006 | 2020-08-11 | Morgan | Illinois | 17137 | 269 | 6 |
422007 | 422007 | 2020-08-11 | Moultrie | Illinois | 17139 | 75 | 0 |
422008 | 422008 | 2020-08-11 | Ogle | Illinois | 17141 | 429 | 5 |
422009 | 422009 | 2020-08-11 | Peoria | Illinois | 17143 | 1667 | 36 |
422010 | 422010 | 2020-08-11 | Perry | Illinois | 17145 | 184 | 2 |
422011 | 422011 | 2020-08-11 | Piatt | Illinois | 17147 | 63 | 0 |
422012 | 422012 | 2020-08-11 | Pike | Illinois | 17149 | 24 | 0 |
422013 | 422013 | 2020-08-11 | Pope | Illinois | 17151 | 11 | 0 |
422014 | 422014 | 2020-08-11 | Pulaski | Illinois | 17153 | 94 | 1 |
422015 | 422015 | 2020-08-11 | Putnam | Illinois | 17155 | 14 | 0 |
422016 | 422016 | 2020-08-11 | Randolph | Illinois | 17157 | 474 | 7 |
422017 | 422017 | 2020-08-11 | Richland | Illinois | 17159 | 20 | 0 |
422018 | 422018 | 2020-08-11 | Rock Island | Illinois | 17161 | 1800 | 39 |
422019 | 422019 | 2020-08-11 | Saline | Illinois | 17165 | 134 | 2 |
422020 | 422020 | 2020-08-11 | Sangamon | Illinois | 17167 | 1321 | 34 |
422021 | 422021 | 2020-08-11 | Schuyler | Illinois | 17169 | 18 | 0 |
422022 | 422022 | 2020-08-11 | Scott | Illinois | 17171 | 21 | 0 |
422023 | 422023 | 2020-08-11 | Shelby | Illinois | 17173 | 86 | 1 |
422024 | 422024 | 2020-08-11 | St. Clair | Illinois | 17163 | 4518 | 161 |
422025 | 422025 | 2020-08-11 | Stark | Illinois | 17175 | 7 | 0 |
422026 | 422026 | 2020-08-11 | Stephenson | Illinois | 17177 | 334 | 6 |
422027 | 422027 | 2020-08-11 | Tazewell | Illinois | 17179 | 610 | 8 |
422028 | 422028 | 2020-08-11 | Union | Illinois | 17181 | 327 | 23 |
422029 | 422029 | 2020-08-11 | Unknown | Illinois | 1244 | 209 | |
422030 | 422030 | 2020-08-11 | Vermilion | Illinois | 17183 | 234 | 2 |
422031 | 422031 | 2020-08-11 | Wabash | Illinois | 17185 | 40 | 0 |
422032 | 422032 | 2020-08-11 | Warren | Illinois | 17187 | 191 | 0 |
422033 | 422033 | 2020-08-11 | Washington | Illinois | 17189 | 67 | 0 |
422034 | 422034 | 2020-08-11 | Wayne | Illinois | 17191 | 66 | 2 |
422035 | 422035 | 2020-08-11 | White | Illinois | 17193 | 71 | 0 |
422036 | 422036 | 2020-08-11 | Whiteside | Illinois | 17195 | 366 | 17 |
422037 | 422037 | 2020-08-11 | Will | Illinois | 17197 | 9413 | 346 |
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);