ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 17143 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386606 | 386606 | 2020-07-31 | Peoria | Illinois | 17143 | 1254 | 34 |
383388 | 383388 | 2020-07-30 | Peoria | Illinois | 17143 | 1189 | 34 |
380171 | 380171 | 2020-07-29 | Peoria | Illinois | 17143 | 1106 | 34 |
376954 | 376954 | 2020-07-28 | Peoria | Illinois | 17143 | 1066 | 33 |
373739 | 373739 | 2020-07-27 | Peoria | Illinois | 17143 | 1036 | 33 |
370527 | 370527 | 2020-07-26 | Peoria | Illinois | 17143 | 1020 | 32 |
367317 | 367317 | 2020-07-25 | Peoria | Illinois | 17143 | 984 | 32 |
364110 | 364110 | 2020-07-24 | Peoria | Illinois | 17143 | 951 | 32 |
360903 | 360903 | 2020-07-23 | Peoria | Illinois | 17143 | 923 | 32 |
357698 | 357698 | 2020-07-22 | Peoria | Illinois | 17143 | 884 | 32 |
354496 | 354496 | 2020-07-21 | Peoria | Illinois | 17143 | 853 | 32 |
351294 | 351294 | 2020-07-20 | Peoria | Illinois | 17143 | 840 | 32 |
348094 | 348094 | 2020-07-19 | Peoria | Illinois | 17143 | 826 | 31 |
344893 | 344893 | 2020-07-18 | Peoria | Illinois | 17143 | 818 | 31 |
341693 | 341693 | 2020-07-17 | Peoria | Illinois | 17143 | 794 | 30 |
338497 | 338497 | 2020-07-16 | Peoria | Illinois | 17143 | 772 | 30 |
335301 | 335301 | 2020-07-15 | Peoria | Illinois | 17143 | 736 | 30 |
332108 | 332108 | 2020-07-14 | Peoria | Illinois | 17143 | 710 | 30 |
328921 | 328921 | 2020-07-13 | Peoria | Illinois | 17143 | 687 | 30 |
325735 | 325735 | 2020-07-12 | Peoria | Illinois | 17143 | 666 | 30 |
322554 | 322554 | 2020-07-11 | Peoria | Illinois | 17143 | 644 | 30 |
319375 | 319375 | 2020-07-10 | Peoria | Illinois | 17143 | 628 | 30 |
316202 | 316202 | 2020-07-09 | Peoria | Illinois | 17143 | 609 | 29 |
313028 | 313028 | 2020-07-08 | Peoria | Illinois | 17143 | 583 | 29 |
309858 | 309858 | 2020-07-07 | Peoria | Illinois | 17143 | 574 | 29 |
306690 | 306690 | 2020-07-06 | Peoria | Illinois | 17143 | 567 | 29 |
303525 | 303525 | 2020-07-05 | Peoria | Illinois | 17143 | 559 | 28 |
300361 | 300361 | 2020-07-04 | Peoria | Illinois | 17143 | 551 | 28 |
297199 | 297199 | 2020-07-03 | Peoria | Illinois | 17143 | 546 | 28 |
294042 | 294042 | 2020-07-02 | Peoria | Illinois | 17143 | 507 | 28 |
290888 | 290888 | 2020-07-01 | Peoria | Illinois | 17143 | 499 | 28 |
287738 | 287738 | 2020-06-30 | Peoria | Illinois | 17143 | 487 | 28 |
284589 | 284589 | 2020-06-29 | Peoria | Illinois | 17143 | 487 | 28 |
281444 | 281444 | 2020-06-28 | Peoria | Illinois | 17143 | 476 | 28 |
278296 | 278296 | 2020-06-27 | Peoria | Illinois | 17143 | 468 | 27 |
275148 | 275148 | 2020-06-26 | Peoria | Illinois | 17143 | 463 | 27 |
272006 | 272006 | 2020-06-25 | Peoria | Illinois | 17143 | 459 | 27 |
268869 | 268869 | 2020-06-24 | Peoria | Illinois | 17143 | 447 | 26 |
265739 | 265739 | 2020-06-23 | Peoria | Illinois | 17143 | 446 | 26 |
262611 | 262611 | 2020-06-22 | Peoria | Illinois | 17143 | 434 | 26 |
259484 | 259484 | 2020-06-21 | Peoria | Illinois | 17143 | 428 | 25 |
256358 | 256358 | 2020-06-20 | Peoria | Illinois | 17143 | 424 | 25 |
253238 | 253238 | 2020-06-19 | Peoria | Illinois | 17143 | 419 | 23 |
250123 | 250123 | 2020-06-18 | Peoria | Illinois | 17143 | 411 | 21 |
247011 | 247011 | 2020-06-17 | Peoria | Illinois | 17143 | 406 | 21 |
243898 | 243898 | 2020-06-16 | Peoria | Illinois | 17143 | 399 | 21 |
240787 | 240787 | 2020-06-15 | Peoria | Illinois | 17143 | 395 | 20 |
237679 | 237679 | 2020-06-14 | Peoria | Illinois | 17143 | 389 | 20 |
234572 | 234572 | 2020-06-13 | Peoria | Illinois | 17143 | 386 | 20 |
231466 | 231466 | 2020-06-12 | Peoria | Illinois | 17143 | 367 | 19 |
228363 | 228363 | 2020-06-11 | Peoria | Illinois | 17143 | 354 | 19 |
225261 | 225261 | 2020-06-10 | Peoria | Illinois | 17143 | 342 | 19 |
222166 | 222166 | 2020-06-09 | Peoria | Illinois | 17143 | 328 | 16 |
219071 | 219071 | 2020-06-08 | Peoria | Illinois | 17143 | 324 | 13 |
215980 | 215980 | 2020-06-07 | Peoria | Illinois | 17143 | 315 | 11 |
212893 | 212893 | 2020-06-06 | Peoria | Illinois | 17143 | 310 | 11 |
209808 | 209808 | 2020-06-05 | Peoria | Illinois | 17143 | 301 | 11 |
206727 | 206727 | 2020-06-04 | Peoria | Illinois | 17143 | 288 | 11 |
203647 | 203647 | 2020-06-03 | Peoria | Illinois | 17143 | 275 | 11 |
200571 | 200571 | 2020-06-02 | Peoria | Illinois | 17143 | 265 | 11 |
197498 | 197498 | 2020-06-01 | Peoria | Illinois | 17143 | 241 | 9 |
194428 | 194428 | 2020-05-31 | Peoria | Illinois | 17143 | 234 | 9 |
191361 | 191361 | 2020-05-30 | Peoria | Illinois | 17143 | 225 | 8 |
188296 | 188296 | 2020-05-29 | Peoria | Illinois | 17143 | 213 | 8 |
185238 | 185238 | 2020-05-28 | Peoria | Illinois | 17143 | 192 | 8 |
182184 | 182184 | 2020-05-27 | Peoria | Illinois | 17143 | 189 | 8 |
179140 | 179140 | 2020-05-26 | Peoria | Illinois | 17143 | 186 | 8 |
176096 | 176096 | 2020-05-25 | Peoria | Illinois | 17143 | 181 | 8 |
173052 | 173052 | 2020-05-24 | Peoria | Illinois | 17143 | 178 | 8 |
170011 | 170011 | 2020-05-23 | Peoria | Illinois | 17143 | 177 | 8 |
166974 | 166974 | 2020-05-22 | Peoria | Illinois | 17143 | 176 | 7 |
163941 | 163941 | 2020-05-21 | Peoria | Illinois | 17143 | 169 | 6 |
160913 | 160913 | 2020-05-20 | Peoria | Illinois | 17143 | 167 | 6 |
157887 | 157887 | 2020-05-19 | Peoria | Illinois | 17143 | 165 | 6 |
154871 | 154871 | 2020-05-18 | Peoria | Illinois | 17143 | 160 | 6 |
151859 | 151859 | 2020-05-17 | Peoria | Illinois | 17143 | 159 | 6 |
148850 | 148850 | 2020-05-16 | Peoria | Illinois | 17143 | 156 | 6 |
145847 | 145847 | 2020-05-15 | Peoria | Illinois | 17143 | 156 | 6 |
142847 | 142847 | 2020-05-14 | Peoria | Illinois | 17143 | 151 | 6 |
139851 | 139851 | 2020-05-13 | Peoria | Illinois | 17143 | 148 | 6 |
136859 | 136859 | 2020-05-12 | Peoria | Illinois | 17143 | 145 | 6 |
133870 | 133870 | 2020-05-11 | Peoria | Illinois | 17143 | 142 | 6 |
130879 | 130879 | 2020-05-10 | Peoria | Illinois | 17143 | 139 | 5 |
127888 | 127888 | 2020-05-09 | Peoria | Illinois | 17143 | 136 | 5 |
124901 | 124901 | 2020-05-08 | Peoria | Illinois | 17143 | 132 | 5 |
121922 | 121922 | 2020-05-07 | Peoria | Illinois | 17143 | 130 | 5 |
118952 | 118952 | 2020-05-06 | Peoria | Illinois | 17143 | 126 | 4 |
115992 | 115992 | 2020-05-05 | Peoria | Illinois | 17143 | 113 | 3 |
113109 | 113109 | 2020-05-04 | Peoria | Illinois | 17143 | 107 | 3 |
110234 | 110234 | 2020-05-03 | Peoria | Illinois | 17143 | 106 | 3 |
107364 | 107364 | 2020-05-02 | Peoria | Illinois | 17143 | 101 | 3 |
104499 | 104499 | 2020-05-01 | Peoria | Illinois | 17143 | 93 | 3 |
101643 | 101643 | 2020-04-30 | Peoria | Illinois | 17143 | 86 | 3 |
98792 | 98792 | 2020-04-29 | Peoria | Illinois | 17143 | 85 | 2 |
95948 | 95948 | 2020-04-28 | Peoria | Illinois | 17143 | 78 | 2 |
93116 | 93116 | 2020-04-27 | Peoria | Illinois | 17143 | 68 | 2 |
90297 | 90297 | 2020-04-26 | Peoria | Illinois | 17143 | 65 | 2 |
87481 | 87481 | 2020-04-25 | Peoria | Illinois | 17143 | 60 | 2 |
84671 | 84671 | 2020-04-24 | Peoria | Illinois | 17143 | 56 | 2 |
81871 | 81871 | 2020-04-23 | Peoria | Illinois | 17143 | 54 | 2 |
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);