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)
Suggested facets: date (date)
fips >30
- 17031 841
- 17089 795
- 17111 795
- 17097 794
- 17035 791
- 17043 791
- 17163 791
- 17167 791
- 17203 791
- 17027 790
- 17195 790
- 17201 790
- 17143 789
- 17197 789
- 17077 787
- 17091 787
- 17093 787
- 17099 787
- 17119 787
- 17189 787
- 17199 787
- 17001 785
- 17021 785
- 17113 785
- 17037 784
- 17019 783
- 17085 783
- 17105 783
- 17161 783
- 17177 783
- …
county >30
- Cook 841
- Kane 795
- McHenry 795
- Lake 794
- Cumberland 791
- DuPage 791
- Sangamon 791
- St. Clair 791
- Woodford 791
- Clinton 790
- Whiteside 790
- Winnebago 790
- Peoria 789
- Will 789
- Jackson 787
- Kankakee 787
- Kendall 787
- LaSalle 787
- Madison 787
- Washington 787
- Williamson 787
- Adams 785
- Christian 785
- McLean 785
- DeKalb 784
- Champaign 783
- Jo Daviess 783
- Livingston 783
- Rock Island 783
- Stephenson 783
- …
state 1
- Illinois · 79,502 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2500177 | 2500177 | 2022-05-13 | Adams | Illinois | 17001 | 22525 | 238 |
| 2500178 | 2500178 | 2022-05-13 | Alexander | Illinois | 17003 | 1288 | 15 |
| 2500179 | 2500179 | 2022-05-13 | Bond | Illinois | 17005 | 4370 | 37 |
| 2500180 | 2500180 | 2022-05-13 | Boone | Illinois | 17007 | 14162 | 130 |
| 2500181 | 2500181 | 2022-05-13 | Brown | Illinois | 17009 | 2430 | 21 |
| 2500182 | 2500182 | 2022-05-13 | Bureau | Illinois | 17011 | 8461 | 140 |
| 2500183 | 2500183 | 2022-05-13 | Calhoun | Illinois | 17013 | 1537 | 8 |
| 2500184 | 2500184 | 2022-05-13 | Carroll | Illinois | 17015 | 4301 | 49 |
| 2500185 | 2500185 | 2022-05-13 | Cass | Illinois | 17017 | 4640 | 44 |
| 2500186 | 2500186 | 2022-05-13 | Champaign | Illinois | 17019 | 67086 | 296 |
| 2500187 | 2500187 | 2022-05-13 | Christian | Illinois | 17021 | 10330 | 131 |
| 2500188 | 2500188 | 2022-05-13 | Clark | Illinois | 17023 | 4887 | 60 |
| 2500189 | 2500189 | 2022-05-13 | Clay | Illinois | 17025 | 4750 | 74 |
| 2500190 | 2500190 | 2022-05-13 | Clinton | Illinois | 17027 | 12066 | 122 |
| 2500191 | 2500191 | 2022-05-13 | Coles | Illinois | 17029 | 15526 | 175 |
| 2500192 | 2500192 | 2022-05-13 | Cook | Illinois | 17031 | 1193914 | 14936 |
| 2500193 | 2500193 | 2022-05-13 | Crawford | Illinois | 17033 | 6249 | 61 |
| 2500194 | 2500194 | 2022-05-13 | Cumberland | Illinois | 17035 | 3381 | 49 |
| 2500195 | 2500195 | 2022-05-13 | De Witt | Illinois | 17039 | 4424 | 45 |
| 2500196 | 2500196 | 2022-05-13 | DeKalb | Illinois | 17037 | 24537 | 201 |
| 2500197 | 2500197 | 2022-05-13 | Douglas | Illinois | 17041 | 6609 | 61 |
| 2500198 | 2500198 | 2022-05-13 | DuPage | Illinois | 17043 | 224631 | 1806 |
| 2500199 | 2500199 | 2022-05-13 | Edgar | Illinois | 17045 | 5209 | 79 |
| 2500200 | 2500200 | 2022-05-13 | Edwards | Illinois | 17047 | 1749 | 29 |
| 2500201 | 2500201 | 2022-05-13 | Effingham | Illinois | 17049 | 10711 | 150 |
| 2500202 | 2500202 | 2022-05-13 | Fayette | Illinois | 17051 | 7155 | 104 |
| 2500203 | 2500203 | 2022-05-13 | Ford | Illinois | 17053 | 4496 | 75 |
| 2500204 | 2500204 | 2022-05-13 | Franklin | Illinois | 17055 | 12272 | 178 |
| 2500205 | 2500205 | 2022-05-13 | Fulton | Illinois | 17057 | 10257 | 135 |
| 2500206 | 2500206 | 2022-05-13 | Gallatin | Illinois | 17059 | 1415 | 18 |
| 2500207 | 2500207 | 2022-05-13 | Greene | Illinois | 17061 | 3663 | 58 |
| 2500208 | 2500208 | 2022-05-13 | Grundy | Illinois | 17063 | 13009 | 140 |
| 2500209 | 2500209 | 2022-05-13 | Hamilton | Illinois | 17065 | 2181 | 34 |
| 2500210 | 2500210 | 2022-05-13 | Hancock | Illinois | 17067 | 4420 | 58 |
| 2500211 | 2500211 | 2022-05-13 | Hardin | Illinois | 17069 | 1059 | 20 |
| 2500212 | 2500212 | 2022-05-13 | Henderson | Illinois | 17071 | 1166 | 28 |
| 2500213 | 2500213 | 2022-05-13 | Henry | Illinois | 17073 | 12884 | 150 |
| 2500214 | 2500214 | 2022-05-13 | Iroquois | Illinois | 17075 | 7294 | 118 |
| 2500215 | 2500215 | 2022-05-13 | Jackson | Illinois | 17077 | 15840 | 130 |
| 2500216 | 2500216 | 2022-05-13 | Jasper | Illinois | 17079 | 2691 | 33 |
| 2500217 | 2500217 | 2022-05-13 | Jefferson | Illinois | 17081 | 11159 | 176 |
| 2500218 | 2500218 | 2022-05-13 | Jersey | Illinois | 17083 | 6320 | 91 |
| 2500219 | 2500219 | 2022-05-13 | Jo Daviess | Illinois | 17085 | 4105 | 39 |
| 2500220 | 2500220 | 2022-05-13 | Johnson | Illinois | 17087 | 4538 | 46 |
| 2500221 | 2500221 | 2022-05-13 | Kane | Illinois | 17089 | 131751 | 1179 |
| 2500222 | 2500222 | 2022-05-13 | Kankakee | Illinois | 17091 | 29350 | 373 |
| 2500223 | 2500223 | 2022-05-13 | Kendall | Illinois | 17093 | 32538 | 171 |
| 2500224 | 2500224 | 2022-05-13 | Knox | Illinois | 17095 | 12722 | 246 |
| 2500225 | 2500225 | 2022-05-13 | LaSalle | Illinois | 17099 | 29734 | 442 |
| 2500226 | 2500226 | 2022-05-13 | Lake | Illinois | 17097 | 159179 | 1466 |
| 2500227 | 2500227 | 2022-05-13 | Lawrence | Illinois | 17101 | 5489 | 52 |
| 2500228 | 2500228 | 2022-05-13 | Lee | Illinois | 17103 | 9020 | 118 |
| 2500229 | 2500229 | 2022-05-13 | Livingston | Illinois | 17105 | 10928 | 148 |
| 2500230 | 2500230 | 2022-05-13 | Logan | Illinois | 17107 | 9922 | 100 |
| 2500231 | 2500231 | 2022-05-13 | Macon | Illinois | 17115 | 31113 | 354 |
| 2500232 | 2500232 | 2022-05-13 | Macoupin | Illinois | 17117 | 12975 | 171 |
| 2500233 | 2500233 | 2022-05-13 | Madison | Illinois | 17119 | 71577 | 866 |
| 2500234 | 2500234 | 2022-05-13 | Marion | Illinois | 17121 | 11933 | 217 |
| 2500235 | 2500235 | 2022-05-13 | Marshall | Illinois | 17123 | 2809 | 33 |
| 2500236 | 2500236 | 2022-05-13 | Mason | Illinois | 17125 | 3980 | 61 |
| 2500237 | 2500237 | 2022-05-13 | Massac | Illinois | 17127 | 3887 | 71 |
| 2500238 | 2500238 | 2022-05-13 | McDonough | Illinois | 17109 | 7303 | 105 |
| 2500239 | 2500239 | 2022-05-13 | McHenry | Illinois | 17111 | 79189 | 511 |
| 2500240 | 2500240 | 2022-05-13 | McLean | Illinois | 17113 | 52348 | 330 |
| 2500241 | 2500241 | 2022-05-13 | Menard | Illinois | 17129 | 3560 | 24 |
| 2500242 | 2500242 | 2022-05-13 | Mercer | Illinois | 17131 | 4087 | 47 |
| 2500243 | 2500243 | 2022-05-13 | Monroe | Illinois | 17133 | 9633 | 128 |
| 2500244 | 2500244 | 2022-05-13 | Montgomery | Illinois | 17135 | 9872 | 111 |
| 2500245 | 2500245 | 2022-05-13 | Morgan | Illinois | 17137 | 9661 | 144 |
| 2500246 | 2500246 | 2022-05-13 | Moultrie | Illinois | 17139 | 4100 | 52 |
| 2500247 | 2500247 | 2022-05-13 | Ogle | Illinois | 17141 | 14285 | 136 |
| 2500248 | 2500248 | 2022-05-13 | Peoria | Illinois | 17143 | 47902 | 555 |
| 2500249 | 2500249 | 2022-05-13 | Perry | Illinois | 17145 | 7509 | 106 |
| 2500250 | 2500250 | 2022-05-13 | Piatt | Illinois | 17147 | 4575 | 29 |
| 2500251 | 2500251 | 2022-05-13 | Pike | Illinois | 17149 | 5050 | 70 |
| 2500252 | 2500252 | 2022-05-13 | Pope | Illinois | 17151 | 960 | 8 |
| 2500253 | 2500253 | 2022-05-13 | Pulaski | Illinois | 17153 | 1730 | 19 |
| 2500254 | 2500254 | 2022-05-13 | Putnam | Illinois | 17155 | 1158 | 10 |
| 2500255 | 2500255 | 2022-05-13 | Randolph | Illinois | 17157 | 10567 | 132 |
| 2500256 | 2500256 | 2022-05-13 | Richland | Illinois | 17159 | 5167 | 83 |
| 2500257 | 2500257 | 2022-05-13 | Rock Island | Illinois | 17161 | 33837 | 523 |
| 2500258 | 2500258 | 2022-05-13 | Saline | Illinois | 17165 | 7935 | 111 |
| 2500259 | 2500259 | 2022-05-13 | Sangamon | Illinois | 17167 | 56637 | 432 |
| 2500260 | 2500260 | 2022-05-13 | Schuyler | Illinois | 17169 | 1977 | 29 |
| 2500261 | 2500261 | 2022-05-13 | Scott | Illinois | 17171 | 1276 | 12 |
| 2500262 | 2500262 | 2022-05-13 | Shelby | Illinois | 17173 | 6262 | 80 |
| 2500263 | 2500263 | 2022-05-13 | St. Clair | Illinois | 17163 | 70571 | 776 |
| 2500264 | 2500264 | 2022-05-13 | Stark | Illinois | 17175 | 1536 | 33 |
| 2500265 | 2500265 | 2022-05-13 | Stephenson | Illinois | 17177 | 11687 | 176 |
| 2500266 | 2500266 | 2022-05-13 | Tazewell | Illinois | 17179 | 37644 | 500 |
| 2500267 | 2500267 | 2022-05-13 | Union | Illinois | 17181 | 5415 | 68 |
| 2500268 | 2500268 | 2022-05-13 | Unknown | Illinois | 0 | 2271 | |
| 2500269 | 2500269 | 2022-05-13 | Vermilion | Illinois | 17183 | 28275 | 313 |
| 2500270 | 2500270 | 2022-05-13 | Wabash | Illinois | 17185 | 3730 | 31 |
| 2500271 | 2500271 | 2022-05-13 | Warren | Illinois | 17187 | 4089 | 87 |
| 2500272 | 2500272 | 2022-05-13 | Washington | Illinois | 17189 | 3455 | 41 |
| 2500273 | 2500273 | 2022-05-13 | Wayne | Illinois | 17191 | 5320 | 85 |
| 2500274 | 2500274 | 2022-05-13 | White | Illinois | 17193 | 4413 | 59 |
| 2500275 | 2500275 | 2022-05-13 | Whiteside | Illinois | 17195 | 15768 | 268 |
| 2500276 | 2500276 | 2022-05-13 | Will | Illinois | 17197 | 169447 | 1612 |
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);