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 408
- 17089 362
- 17111 362
- 17097 361
- 17203 359
- 17035 358
- 17043 358
- 17163 358
- 17167 358
- 17201 358
- 17027 357
- 17195 357
- 17143 356
- 17197 356
- 17199 355
- 17077 354
- 17091 354
- 17093 354
- 17099 354
- 17119 354
- 17189 354
- 17001 352
- 17021 352
- 17113 352
- 17037 351
- 17019 350
- 17085 350
- 17105 350
- 17161 350
- 17177 350
- …
county >30
- Cook 408
- Kane 362
- McHenry 362
- Lake 361
- Woodford 359
- Cumberland 358
- DuPage 358
- Sangamon 358
- St. Clair 358
- Winnebago 358
- Clinton 357
- Whiteside 357
- Peoria 356
- Will 356
- Williamson 355
- Jackson 354
- Kankakee 354
- Kendall 354
- LaSalle 354
- Madison 354
- Washington 354
- Adams 352
- Christian 352
- McLean 352
- DeKalb 351
- Champaign 350
- Jo Daviess 350
- Livingston 350
- Rock Island 350
- Stephenson 350
- …
state 1
- Illinois · 34,906 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1096399 | 1096399 | 2021-03-07 | Williamson | Illinois | 17199 | 6866 | 133 |
1096400 | 1096400 | 2021-03-07 | Winnebago | Illinois | 17201 | 28470 | 474 |
1096401 | 1096401 | 2021-03-07 | Woodford | Illinois | 17203 | 3742 | 73 |
1093053 | 1093053 | 2021-03-06 | Adams | Illinois | 17001 | 8037 | 143 |
1093054 | 1093054 | 2021-03-06 | Alexander | Illinois | 17003 | 453 | 9 |
1093055 | 1093055 | 2021-03-06 | Bond | Illinois | 17005 | 1917 | 30 |
1093056 | 1093056 | 2021-03-06 | Boone | Illinois | 17007 | 5940 | 82 |
1093057 | 1093057 | 2021-03-06 | Brown | Illinois | 17009 | 666 | 12 |
1093058 | 1093058 | 2021-03-06 | Bureau | Illinois | 17011 | 3331 | 90 |
1093059 | 1093059 | 2021-03-06 | Calhoun | Illinois | 17013 | 482 | 5 |
1093060 | 1093060 | 2021-03-06 | Carroll | Illinois | 17015 | 1581 | 36 |
1093061 | 1093061 | 2021-03-06 | Cass | Illinois | 17017 | 1896 | 31 |
1093062 | 1093062 | 2021-03-06 | Champaign | Illinois | 17019 | 18386 | 136 |
1093063 | 1093063 | 2021-03-06 | Christian | Illinois | 17021 | 3330 | 87 |
1093064 | 1093064 | 2021-03-06 | Clark | Illinois | 17023 | 1689 | 39 |
1093065 | 1093065 | 2021-03-06 | Clay | Illinois | 17025 | 1436 | 47 |
1093066 | 1093066 | 2021-03-06 | Clinton | Illinois | 17027 | 5581 | 98 |
1093067 | 1093067 | 2021-03-06 | Coles | Illinois | 17029 | 5253 | 94 |
1093068 | 1093068 | 2021-03-06 | Cook | Illinois | 17031 | 478498 | 10002 |
1093069 | 1093069 | 2021-03-06 | Crawford | Illinois | 17033 | 2013 | 40 |
1093070 | 1093070 | 2021-03-06 | Cumberland | Illinois | 17035 | 1204 | 30 |
1093071 | 1093071 | 2021-03-06 | De Witt | Illinois | 17039 | 1284 | 29 |
1093072 | 1093072 | 2021-03-06 | DeKalb | Illinois | 17037 | 8520 | 120 |
1093073 | 1093073 | 2021-03-06 | Douglas | Illinois | 17041 | 2474 | 39 |
1093074 | 1093074 | 2021-03-06 | DuPage | Illinois | 17043 | 77796 | 1290 |
1093075 | 1093075 | 2021-03-06 | Edgar | Illinois | 17045 | 1555 | 58 |
1093076 | 1093076 | 2021-03-06 | Edwards | Illinois | 17047 | 528 | 11 |
1093077 | 1093077 | 2021-03-06 | Effingham | Illinois | 17049 | 4504 | 80 |
1093078 | 1093078 | 2021-03-06 | Fayette | Illinois | 17051 | 3070 | 55 |
1093079 | 1093079 | 2021-03-06 | Ford | Illinois | 17053 | 1602 | 54 |
1093080 | 1093080 | 2021-03-06 | Franklin | Illinois | 17055 | 4164 | 78 |
1093081 | 1093081 | 2021-03-06 | Fulton | Illinois | 17057 | 2894 | 54 |
1093082 | 1093082 | 2021-03-06 | Gallatin | Illinois | 17059 | 438 | 5 |
1093083 | 1093083 | 2021-03-06 | Greene | Illinois | 17061 | 1386 | 45 |
1093084 | 1093084 | 2021-03-06 | Grundy | Illinois | 17063 | 5204 | 67 |
1093085 | 1093085 | 2021-03-06 | Hamilton | Illinois | 17065 | 796 | 18 |
1093086 | 1093086 | 2021-03-06 | Hancock | Illinois | 17067 | 1685 | 40 |
1093087 | 1093087 | 2021-03-06 | Hardin | Illinois | 17069 | 346 | 12 |
1093088 | 1093088 | 2021-03-06 | Henderson | Illinois | 17071 | 504 | 23 |
1093089 | 1093089 | 2021-03-06 | Henry | Illinois | 17073 | 4356 | 87 |
1093090 | 1093090 | 2021-03-06 | Iroquois | Illinois | 17075 | 2788 | 64 |
1093091 | 1093091 | 2021-03-06 | Jackson | Illinois | 17077 | 4620 | 71 |
1093092 | 1093092 | 2021-03-06 | Jasper | Illinois | 17079 | 1113 | 19 |
1093093 | 1093093 | 2021-03-06 | Jefferson | Illinois | 17081 | 3997 | 118 |
1093094 | 1093094 | 2021-03-06 | Jersey | Illinois | 17083 | 2499 | 66 |
1093095 | 1093095 | 2021-03-06 | Jo Daviess | Illinois | 17085 | 1615 | 25 |
1093096 | 1093096 | 2021-03-06 | Johnson | Illinois | 17087 | 1353 | 18 |
1093097 | 1093097 | 2021-03-06 | Kane | Illinois | 17089 | 51199 | 775 |
1093098 | 1093098 | 2021-03-06 | Kankakee | Illinois | 17091 | 12594 | 198 |
1093099 | 1093099 | 2021-03-06 | Kendall | Illinois | 17093 | 11509 | 96 |
1093100 | 1093100 | 2021-03-06 | Knox | Illinois | 17095 | 5023 | 164 |
1093101 | 1093101 | 2021-03-06 | LaSalle | Illinois | 17099 | 10910 | 277 |
1093102 | 1093102 | 2021-03-06 | Lake | Illinois | 17097 | 60112 | 1004 |
1093103 | 1093103 | 2021-03-06 | Lawrence | Illinois | 17101 | 2319 | 33 |
1093104 | 1093104 | 2021-03-06 | Lee | Illinois | 17103 | 3381 | 82 |
1093105 | 1093105 | 2021-03-06 | Livingston | Illinois | 17105 | 4259 | 90 |
1093106 | 1093106 | 2021-03-06 | Logan | Illinois | 17107 | 3314 | 67 |
1093107 | 1093107 | 2021-03-06 | Macon | Illinois | 17115 | 9520 | 196 |
1093108 | 1093108 | 2021-03-06 | Macoupin | Illinois | 17117 | 4379 | 109 |
1093109 | 1093109 | 2021-03-06 | Madison | Illinois | 17119 | 28231 | 537 |
1093110 | 1093110 | 2021-03-06 | Marion | Illinois | 17121 | 4276 | 119 |
1093111 | 1093111 | 2021-03-06 | Marshall | Illinois | 17123 | 847 | 17 |
1093112 | 1093112 | 2021-03-06 | Mason | Illinois | 17125 | 1288 | 42 |
1093113 | 1093113 | 2021-03-06 | Massac | Illinois | 17127 | 1282 | 37 |
1093114 | 1093114 | 2021-03-06 | McDonough | Illinois | 17109 | 2338 | 52 |
1093115 | 1093115 | 2021-03-06 | McHenry | Illinois | 17111 | 24644 | 292 |
1093116 | 1093116 | 2021-03-06 | McLean | Illinois | 17113 | 14732 | 196 |
1093117 | 1093117 | 2021-03-06 | Menard | Illinois | 17129 | 1042 | 12 |
1093118 | 1093118 | 2021-03-06 | Mercer | Illinois | 17131 | 1289 | 33 |
1093119 | 1093119 | 2021-03-06 | Monroe | Illinois | 17133 | 4090 | 87 |
1093120 | 1093120 | 2021-03-06 | Montgomery | Illinois | 17135 | 3542 | 76 |
1093121 | 1093121 | 2021-03-06 | Morgan | Illinois | 17137 | 3684 | 99 |
1093122 | 1093122 | 2021-03-06 | Moultrie | Illinois | 17139 | 1503 | 32 |
1093123 | 1093123 | 2021-03-06 | Ogle | Illinois | 17141 | 5070 | 83 |
1093124 | 1093124 | 2021-03-06 | Peoria | Illinois | 17143 | 17144 | 285 |
1093125 | 1093125 | 2021-03-06 | Perry | Illinois | 17145 | 3071 | 66 |
1093126 | 1093126 | 2021-03-06 | Piatt | Illinois | 17147 | 1342 | 20 |
1093127 | 1093127 | 2021-03-06 | Pike | Illinois | 17149 | 1700 | 53 |
1093128 | 1093128 | 2021-03-06 | Pope | Illinois | 17151 | 284 | 3 |
1093129 | 1093129 | 2021-03-06 | Pulaski | Illinois | 17153 | 671 | 6 |
1093130 | 1093130 | 2021-03-06 | Putnam | Illinois | 17155 | 422 | 4 |
1093131 | 1093131 | 2021-03-06 | Randolph | Illinois | 17157 | 3981 | 86 |
1093132 | 1093132 | 2021-03-06 | Richland | Illinois | 17159 | 1636 | 47 |
1093133 | 1093133 | 2021-03-06 | Rock Island | Illinois | 17161 | 13169 | 330 |
1093134 | 1093134 | 2021-03-06 | Saline | Illinois | 17165 | 2335 | 64 |
1093135 | 1093135 | 2021-03-06 | Sangamon | Illinois | 17167 | 16266 | 264 |
1093136 | 1093136 | 2021-03-06 | Schuyler | Illinois | 17169 | 682 | 17 |
1093137 | 1093137 | 2021-03-06 | Scott | Illinois | 17171 | 449 | 1 |
1093138 | 1093138 | 2021-03-06 | Shelby | Illinois | 17173 | 2159 | 37 |
1093139 | 1093139 | 2021-03-06 | St. Clair | Illinois | 17163 | 28332 | 515 |
1093140 | 1093140 | 2021-03-06 | Stark | Illinois | 17175 | 544 | 23 |
1093141 | 1093141 | 2021-03-06 | Stephenson | Illinois | 17177 | 4115 | 95 |
1093142 | 1093142 | 2021-03-06 | Tazewell | Illinois | 17179 | 13659 | 275 |
1093143 | 1093143 | 2021-03-06 | Union | Illinois | 17181 | 2207 | 42 |
1093144 | 1093144 | 2021-03-06 | Unknown | Illinois | 0 | 237 | |
1093145 | 1093145 | 2021-03-06 | Vermilion | Illinois | 17183 | 8635 | 136 |
1093146 | 1093146 | 2021-03-06 | Wabash | Illinois | 17185 | 1305 | 15 |
1093147 | 1093147 | 2021-03-06 | Warren | Illinois | 17187 | 1666 | 47 |
1093148 | 1093148 | 2021-03-06 | Washington | Illinois | 17189 | 1587 | 30 |
1093149 | 1093149 | 2021-03-06 | Wayne | Illinois | 17191 | 1690 | 50 |
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);