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 465
- 17089 419
- 17111 419
- 17097 418
- 17035 415
- 17043 415
- 17163 415
- 17167 415
- 17203 415
- 17027 414
- 17195 414
- 17201 414
- 17143 413
- 17197 413
- 17077 411
- 17091 411
- 17093 411
- 17099 411
- 17119 411
- 17189 411
- 17199 411
- 17001 409
- 17021 409
- 17113 409
- 17037 408
- 17019 407
- 17085 407
- 17105 407
- 17161 407
- 17177 407
- …
county >30
- Cook 465
- Kane 419
- McHenry 419
- Lake 418
- Cumberland 415
- DuPage 415
- Sangamon 415
- St. Clair 415
- Woodford 415
- Clinton 414
- Whiteside 414
- Winnebago 414
- Peoria 413
- Will 413
- Jackson 411
- Kankakee 411
- Kendall 411
- LaSalle 411
- Madison 411
- Washington 411
- Williamson 411
- Adams 409
- Christian 409
- McLean 409
- DeKalb 408
- Champaign 407
- Jo Daviess 407
- Livingston 407
- Rock Island 407
- Stephenson 407
- …
state 1
- Illinois · 40,774 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278144 | 1278144 | 2021-05-02 | Adams | Illinois | 17001 | 8325 | 149 |
1278145 | 1278145 | 2021-05-02 | Alexander | Illinois | 17003 | 465 | 11 |
1278146 | 1278146 | 2021-05-02 | Bond | Illinois | 17005 | 2019 | 30 |
1278147 | 1278147 | 2021-05-02 | Boone | Illinois | 17007 | 6596 | 83 |
1278148 | 1278148 | 2021-05-02 | Brown | Illinois | 17009 | 698 | 12 |
1278149 | 1278149 | 2021-05-02 | Bureau | Illinois | 17011 | 3637 | 95 |
1278150 | 1278150 | 2021-05-02 | Calhoun | Illinois | 17013 | 515 | 5 |
1278151 | 1278151 | 2021-05-02 | Carroll | Illinois | 17015 | 1733 | 37 |
1278152 | 1278152 | 2021-05-02 | Cass | Illinois | 17017 | 1973 | 33 |
1278153 | 1278153 | 2021-05-02 | Champaign | Illinois | 17019 | 20333 | 152 |
1278154 | 1278154 | 2021-05-02 | Christian | Illinois | 17021 | 3610 | 91 |
1278155 | 1278155 | 2021-05-02 | Clark | Illinois | 17023 | 1779 | 40 |
1278156 | 1278156 | 2021-05-02 | Clay | Illinois | 17025 | 1480 | 48 |
1278157 | 1278157 | 2021-05-02 | Clinton | Illinois | 17027 | 5737 | 99 |
1278158 | 1278158 | 2021-05-02 | Coles | Illinois | 17029 | 5635 | 96 |
1278159 | 1278159 | 2021-05-02 | Cook | Illinois | 17031 | 536384 | 10525 |
1278160 | 1278160 | 2021-05-02 | Crawford | Illinois | 17033 | 2107 | 42 |
1278161 | 1278161 | 2021-05-02 | Cumberland | Illinois | 17035 | 1288 | 31 |
1278162 | 1278162 | 2021-05-02 | De Witt | Illinois | 17039 | 1449 | 31 |
1278163 | 1278163 | 2021-05-02 | DeKalb | Illinois | 17037 | 9885 | 124 |
1278164 | 1278164 | 2021-05-02 | Douglas | Illinois | 17041 | 2568 | 41 |
1278165 | 1278165 | 2021-05-02 | DuPage | Illinois | 17043 | 89043 | 1351 |
1278166 | 1278166 | 2021-05-02 | Edgar | Illinois | 17045 | 1683 | 59 |
1278167 | 1278167 | 2021-05-02 | Edwards | Illinois | 17047 | 566 | 13 |
1278168 | 1278168 | 2021-05-02 | Effingham | Illinois | 17049 | 4703 | 83 |
1278169 | 1278169 | 2021-05-02 | Fayette | Illinois | 17051 | 3150 | 58 |
1278170 | 1278170 | 2021-05-02 | Ford | Illinois | 17053 | 1748 | 54 |
1278171 | 1278171 | 2021-05-02 | Franklin | Illinois | 17055 | 4390 | 83 |
1278172 | 1278172 | 2021-05-02 | Fulton | Illinois | 17057 | 3815 | 59 |
1278173 | 1278173 | 2021-05-02 | Gallatin | Illinois | 17059 | 457 | 5 |
1278174 | 1278174 | 2021-05-02 | Greene | Illinois | 17061 | 1431 | 46 |
1278175 | 1278175 | 2021-05-02 | Grundy | Illinois | 17063 | 5776 | 75 |
1278176 | 1278176 | 2021-05-02 | Hamilton | Illinois | 17065 | 829 | 18 |
1278177 | 1278177 | 2021-05-02 | Hancock | Illinois | 17067 | 1741 | 41 |
1278178 | 1278178 | 2021-05-02 | Hardin | Illinois | 17069 | 383 | 12 |
1278179 | 1278179 | 2021-05-02 | Henderson | Illinois | 17071 | 522 | 23 |
1278180 | 1278180 | 2021-05-02 | Henry | Illinois | 17073 | 4873 | 92 |
1278181 | 1278181 | 2021-05-02 | Iroquois | Illinois | 17075 | 2957 | 67 |
1278182 | 1278182 | 2021-05-02 | Jackson | Illinois | 17077 | 4946 | 74 |
1278183 | 1278183 | 2021-05-02 | Jasper | Illinois | 17079 | 1148 | 20 |
1278184 | 1278184 | 2021-05-02 | Jefferson | Illinois | 17081 | 4228 | 120 |
1278185 | 1278185 | 2021-05-02 | Jersey | Illinois | 17083 | 2678 | 68 |
1278186 | 1278186 | 2021-05-02 | Jo Daviess | Illinois | 17085 | 1797 | 27 |
1278187 | 1278187 | 2021-05-02 | Johnson | Illinois | 17087 | 1412 | 20 |
1278188 | 1278188 | 2021-05-02 | Kane | Illinois | 17089 | 57368 | 818 |
1278189 | 1278189 | 2021-05-02 | Kankakee | Illinois | 17091 | 13901 | 215 |
1278190 | 1278190 | 2021-05-02 | Kendall | Illinois | 17093 | 13181 | 100 |
1278191 | 1278191 | 2021-05-02 | Knox | Illinois | 17095 | 5469 | 169 |
1278192 | 1278192 | 2021-05-02 | LaSalle | Illinois | 17099 | 12236 | 294 |
1278193 | 1278193 | 2021-05-02 | Lake | Illinois | 17097 | 66132 | 1046 |
1278194 | 1278194 | 2021-05-02 | Lawrence | Illinois | 17101 | 2400 | 34 |
1278195 | 1278195 | 2021-05-02 | Lee | Illinois | 17103 | 4096 | 91 |
1278196 | 1278196 | 2021-05-02 | Livingston | Illinois | 17105 | 4738 | 96 |
1278197 | 1278197 | 2021-05-02 | Logan | Illinois | 17107 | 3790 | 70 |
1278198 | 1278198 | 2021-05-02 | Macon | Illinois | 17115 | 10544 | 204 |
1278199 | 1278199 | 2021-05-02 | Macoupin | Illinois | 17117 | 4648 | 110 |
1278200 | 1278200 | 2021-05-02 | Madison | Illinois | 17119 | 30211 | 591 |
1278201 | 1278201 | 2021-05-02 | Marion | Illinois | 17121 | 4440 | 121 |
1278202 | 1278202 | 2021-05-02 | Marshall | Illinois | 17123 | 1025 | 20 |
1278203 | 1278203 | 2021-05-02 | Mason | Illinois | 17125 | 1471 | 43 |
1278204 | 1278204 | 2021-05-02 | Massac | Illinois | 17127 | 1327 | 43 |
1278205 | 1278205 | 2021-05-02 | McDonough | Illinois | 17109 | 2761 | 57 |
1278206 | 1278206 | 2021-05-02 | McHenry | Illinois | 17111 | 28064 | 310 |
1278207 | 1278207 | 2021-05-02 | McLean | Illinois | 17113 | 17740 | 211 |
1278208 | 1278208 | 2021-05-02 | Menard | Illinois | 17129 | 1209 | 16 |
1278209 | 1278209 | 2021-05-02 | Mercer | Illinois | 17131 | 1423 | 33 |
1278210 | 1278210 | 2021-05-02 | Monroe | Illinois | 17133 | 4344 | 91 |
1278211 | 1278211 | 2021-05-02 | Montgomery | Illinois | 17135 | 3685 | 79 |
1278212 | 1278212 | 2021-05-02 | Morgan | Illinois | 17137 | 3908 | 101 |
1278213 | 1278213 | 2021-05-02 | Moultrie | Illinois | 17139 | 1595 | 34 |
1278214 | 1278214 | 2021-05-02 | Ogle | Illinois | 17141 | 5992 | 88 |
1278215 | 1278215 | 2021-05-02 | Peoria | Illinois | 17143 | 22562 | 318 |
1278216 | 1278216 | 2021-05-02 | Perry | Illinois | 17145 | 3140 | 68 |
1278217 | 1278217 | 2021-05-02 | Piatt | Illinois | 17147 | 1453 | 20 |
1278218 | 1278218 | 2021-05-02 | Pike | Illinois | 17149 | 1783 | 54 |
1278219 | 1278219 | 2021-05-02 | Pope | Illinois | 17151 | 314 | 4 |
1278220 | 1278220 | 2021-05-02 | Pulaski | Illinois | 17153 | 683 | 7 |
1278221 | 1278221 | 2021-05-02 | Putnam | Illinois | 17155 | 470 | 4 |
1278222 | 1278222 | 2021-05-02 | Randolph | Illinois | 17157 | 4116 | 90 |
1278223 | 1278223 | 2021-05-02 | Richland | Illinois | 17159 | 1732 | 49 |
1278224 | 1278224 | 2021-05-02 | Rock Island | Illinois | 17161 | 14644 | 348 |
1278225 | 1278225 | 2021-05-02 | Saline | Illinois | 17165 | 2549 | 69 |
1278226 | 1278226 | 2021-05-02 | Sangamon | Illinois | 17167 | 18363 | 273 |
1278227 | 1278227 | 2021-05-02 | Schuyler | Illinois | 17169 | 730 | 17 |
1278228 | 1278228 | 2021-05-02 | Scott | Illinois | 17171 | 476 | 1 |
1278229 | 1278229 | 2021-05-02 | Shelby | Illinois | 17173 | 2272 | 40 |
1278230 | 1278230 | 2021-05-02 | St. Clair | Illinois | 17163 | 30515 | 553 |
1278231 | 1278231 | 2021-05-02 | Stark | Illinois | 17175 | 629 | 23 |
1278232 | 1278232 | 2021-05-02 | Stephenson | Illinois | 17177 | 4644 | 100 |
1278233 | 1278233 | 2021-05-02 | Tazewell | Illinois | 17179 | 16605 | 311 |
1278234 | 1278234 | 2021-05-02 | Union | Illinois | 17181 | 2241 | 44 |
1278235 | 1278235 | 2021-05-02 | Unknown | Illinois | 0 | 318 | |
1278236 | 1278236 | 2021-05-02 | Vermilion | Illinois | 17183 | 9321 | 148 |
1278237 | 1278237 | 2021-05-02 | Wabash | Illinois | 17185 | 1341 | 15 |
1278238 | 1278238 | 2021-05-02 | Warren | Illinois | 17187 | 1774 | 49 |
1278239 | 1278239 | 2021-05-02 | Washington | Illinois | 17189 | 1636 | 31 |
1278240 | 1278240 | 2021-05-02 | Wayne | Illinois | 17191 | 1754 | 53 |
1278241 | 1278241 | 2021-05-02 | White | Illinois | 17193 | 1683 | 36 |
1278242 | 1278242 | 2021-05-02 | Whiteside | Illinois | 17195 | 7151 | 208 |
1278243 | 1278243 | 2021-05-02 | Will | Illinois | 17197 | 74136 | 1053 |
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);