ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17043 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
322504 | 322504 | 2020-07-11 | DuPage | Illinois | 17043 | 9641 | 485 |
319325 | 319325 | 2020-07-10 | DuPage | Illinois | 17043 | 9571 | 483 |
316152 | 316152 | 2020-07-09 | DuPage | Illinois | 17043 | 9507 | 483 |
312978 | 312978 | 2020-07-08 | DuPage | Illinois | 17043 | 9457 | 480 |
309808 | 309808 | 2020-07-07 | DuPage | Illinois | 17043 | 9395 | 477 |
306640 | 306640 | 2020-07-06 | DuPage | Illinois | 17043 | 9364 | 475 |
303475 | 303475 | 2020-07-05 | DuPage | Illinois | 17043 | 9315 | 475 |
300311 | 300311 | 2020-07-04 | DuPage | Illinois | 17043 | 9276 | 475 |
297149 | 297149 | 2020-07-03 | DuPage | Illinois | 17043 | 9209 | 474 |
293992 | 293992 | 2020-07-02 | DuPage | Illinois | 17043 | 9147 | 473 |
290838 | 290838 | 2020-07-01 | DuPage | Illinois | 17043 | 9086 | 472 |
287688 | 287688 | 2020-06-30 | DuPage | Illinois | 17043 | 9036 | 470 |
284539 | 284539 | 2020-06-29 | DuPage | Illinois | 17043 | 8996 | 470 |
281394 | 281394 | 2020-06-28 | DuPage | Illinois | 17043 | 8951 | 469 |
278246 | 278246 | 2020-06-27 | DuPage | Illinois | 17043 | 8922 | 468 |
275098 | 275098 | 2020-06-26 | DuPage | Illinois | 17043 | 8879 | 465 |
271956 | 271956 | 2020-06-25 | DuPage | Illinois | 17043 | 8829 | 463 |
268819 | 268819 | 2020-06-24 | DuPage | Illinois | 17043 | 8782 | 458 |
265689 | 265689 | 2020-06-23 | DuPage | Illinois | 17043 | 8742 | 455 |
262561 | 262561 | 2020-06-22 | DuPage | Illinois | 17043 | 8716 | 449 |
259434 | 259434 | 2020-06-21 | DuPage | Illinois | 17043 | 8684 | 448 |
256308 | 256308 | 2020-06-20 | DuPage | Illinois | 17043 | 8648 | 448 |
253188 | 253188 | 2020-06-19 | DuPage | Illinois | 17043 | 8611 | 444 |
250073 | 250073 | 2020-06-18 | DuPage | Illinois | 17043 | 8575 | 443 |
246961 | 246961 | 2020-06-17 | DuPage | Illinois | 17043 | 8546 | 435 |
243848 | 243848 | 2020-06-16 | DuPage | Illinois | 17043 | 8501 | 432 |
240737 | 240737 | 2020-06-15 | DuPage | Illinois | 17043 | 8465 | 431 |
237629 | 237629 | 2020-06-14 | DuPage | Illinois | 17043 | 8434 | 431 |
234522 | 234522 | 2020-06-13 | DuPage | Illinois | 17043 | 8402 | 430 |
231416 | 231416 | 2020-06-12 | DuPage | Illinois | 17043 | 8360 | 429 |
228313 | 228313 | 2020-06-11 | DuPage | Illinois | 17043 | 8318 | 425 |
225211 | 225211 | 2020-06-10 | DuPage | Illinois | 17043 | 8263 | 418 |
222116 | 222116 | 2020-06-09 | DuPage | Illinois | 17043 | 8223 | 411 |
219021 | 219021 | 2020-06-08 | DuPage | Illinois | 17043 | 8157 | 406 |
215930 | 215930 | 2020-06-07 | DuPage | Illinois | 17043 | 8120 | 404 |
212843 | 212843 | 2020-06-06 | DuPage | Illinois | 17043 | 8070 | 400 |
209758 | 209758 | 2020-06-05 | DuPage | Illinois | 17043 | 8003 | 394 |
206677 | 206677 | 2020-06-04 | DuPage | Illinois | 17043 | 7947 | 392 |
203597 | 203597 | 2020-06-03 | DuPage | Illinois | 17043 | 7915 | 384 |
200521 | 200521 | 2020-06-02 | DuPage | Illinois | 17043 | 7838 | 380 |
197448 | 197448 | 2020-06-01 | DuPage | Illinois | 17043 | 7773 | 374 |
194378 | 194378 | 2020-05-31 | DuPage | Illinois | 17043 | 7717 | 373 |
191311 | 191311 | 2020-05-30 | DuPage | Illinois | 17043 | 7640 | 368 |
188246 | 188246 | 2020-05-29 | DuPage | Illinois | 17043 | 7564 | 362 |
185189 | 185189 | 2020-05-28 | DuPage | Illinois | 17043 | 7479 | 351 |
182135 | 182135 | 2020-05-27 | DuPage | Illinois | 17043 | 7369 | 347 |
179091 | 179091 | 2020-05-26 | DuPage | Illinois | 17043 | 7305 | 341 |
176047 | 176047 | 2020-05-25 | DuPage | Illinois | 17043 | 7207 | 339 |
173003 | 173003 | 2020-05-24 | DuPage | Illinois | 17043 | 7063 | 340 |
169962 | 169962 | 2020-05-23 | DuPage | Illinois | 17043 | 6891 | 339 |
166925 | 166925 | 2020-05-22 | DuPage | Illinois | 17043 | 6744 | 337 |
163892 | 163892 | 2020-05-21 | DuPage | Illinois | 17043 | 6471 | 332 |
160864 | 160864 | 2020-05-20 | DuPage | Illinois | 17043 | 6308 | 326 |
157838 | 157838 | 2020-05-19 | DuPage | Illinois | 17043 | 6171 | 315 |
154822 | 154822 | 2020-05-18 | DuPage | Illinois | 17043 | 6076 | 300 |
151810 | 151810 | 2020-05-17 | DuPage | Illinois | 17043 | 5904 | 298 |
148801 | 148801 | 2020-05-16 | DuPage | Illinois | 17043 | 5780 | 293 |
145798 | 145798 | 2020-05-15 | DuPage | Illinois | 17043 | 5634 | 287 |
142798 | 142798 | 2020-05-14 | DuPage | Illinois | 17043 | 5453 | 279 |
139802 | 139802 | 2020-05-13 | DuPage | Illinois | 17043 | 5244 | 271 |
136811 | 136811 | 2020-05-12 | DuPage | Illinois | 17043 | 5121 | 258 |
133822 | 133822 | 2020-05-11 | DuPage | Illinois | 17043 | 4745 | 251 |
130831 | 130831 | 2020-05-10 | DuPage | Illinois | 17043 | 4603 | 248 |
127840 | 127840 | 2020-05-09 | DuPage | Illinois | 17043 | 4493 | 247 |
124853 | 124853 | 2020-05-08 | DuPage | Illinois | 17043 | 4374 | 236 |
121874 | 121874 | 2020-05-07 | DuPage | Illinois | 17043 | 4213 | 228 |
118904 | 118904 | 2020-05-06 | DuPage | Illinois | 17043 | 4056 | 220 |
115944 | 115944 | 2020-05-05 | DuPage | Illinois | 17043 | 3918 | 207 |
113061 | 113061 | 2020-05-04 | DuPage | Illinois | 17043 | 3803 | 196 |
110186 | 110186 | 2020-05-03 | DuPage | Illinois | 17043 | 3611 | 192 |
107316 | 107316 | 2020-05-02 | DuPage | Illinois | 17043 | 3432 | 189 |
104451 | 104451 | 2020-05-01 | DuPage | Illinois | 17043 | 3256 | 174 |
101595 | 101595 | 2020-04-30 | DuPage | Illinois | 17043 | 3081 | 163 |
98744 | 98744 | 2020-04-29 | DuPage | Illinois | 17043 | 2870 | 142 |
95900 | 95900 | 2020-04-28 | DuPage | Illinois | 17043 | 2736 | 139 |
93068 | 93068 | 2020-04-27 | DuPage | Illinois | 17043 | 2628 | 133 |
90249 | 90249 | 2020-04-26 | DuPage | Illinois | 17043 | 2443 | 131 |
87433 | 87433 | 2020-04-25 | DuPage | Illinois | 17043 | 2311 | 127 |
84623 | 84623 | 2020-04-24 | DuPage | Illinois | 17043 | 2219 | 125 |
81823 | 81823 | 2020-04-23 | DuPage | Illinois | 17043 | 2047 | 118 |
79030 | 79030 | 2020-04-22 | DuPage | Illinois | 17043 | 1947 | 103 |
76246 | 76246 | 2020-04-21 | DuPage | Illinois | 17043 | 1864 | 98 |
73470 | 73470 | 2020-04-20 | DuPage | Illinois | 17043 | 1761 | 90 |
70700 | 70700 | 2020-04-19 | DuPage | Illinois | 17043 | 1695 | 85 |
67938 | 67938 | 2020-04-18 | DuPage | Illinois | 17043 | 1642 | 83 |
65190 | 65190 | 2020-04-17 | DuPage | Illinois | 17043 | 1560 | 77 |
62458 | 62458 | 2020-04-16 | DuPage | Illinois | 17043 | 1463 | 69 |
59737 | 59737 | 2020-04-15 | DuPage | Illinois | 17043 | 1386 | 66 |
57030 | 57030 | 2020-04-14 | DuPage | Illinois | 17043 | 1312 | 61 |
54337 | 54337 | 2020-04-13 | DuPage | Illinois | 17043 | 1223 | 56 |
51657 | 51657 | 2020-04-12 | DuPage | Illinois | 17043 | 1162 | 50 |
48995 | 48995 | 2020-04-11 | DuPage | Illinois | 17043 | 1048 | 48 |
46364 | 46364 | 2020-04-10 | DuPage | Illinois | 17043 | 1008 | 42 |
43762 | 43762 | 2020-04-09 | DuPage | Illinois | 17043 | 943 | 36 |
41188 | 41188 | 2020-04-08 | DuPage | Illinois | 17043 | 875 | 30 |
38644 | 38644 | 2020-04-07 | DuPage | Illinois | 17043 | 795 | 26 |
36149 | 36149 | 2020-04-06 | DuPage | Illinois | 17043 | 715 | 22 |
33698 | 33698 | 2020-04-05 | DuPage | Illinois | 17043 | 656 | 22 |
31289 | 31289 | 2020-04-04 | DuPage | Illinois | 17043 | 590 | 18 |
28927 | 28927 | 2020-04-03 | DuPage | Illinois | 17043 | 500 | 16 |
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);