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 |
---|---|---|---|---|---|---|---|
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 |
79078 | 79078 | 2020-04-22 | Peoria | Illinois | 17143 | 46 | 2 |
76294 | 76294 | 2020-04-21 | Peoria | Illinois | 17143 | 44 | 2 |
73517 | 73517 | 2020-04-20 | Peoria | Illinois | 17143 | 43 | 2 |
70747 | 70747 | 2020-04-19 | Peoria | Illinois | 17143 | 39 | 2 |
67985 | 67985 | 2020-04-18 | Peoria | Illinois | 17143 | 37 | 2 |
65236 | 65236 | 2020-04-17 | Peoria | Illinois | 17143 | 34 | 1 |
62503 | 62503 | 2020-04-16 | Peoria | Illinois | 17143 | 34 | 1 |
59782 | 59782 | 2020-04-15 | Peoria | Illinois | 17143 | 33 | 1 |
57075 | 57075 | 2020-04-14 | Peoria | Illinois | 17143 | 31 | 1 |
54382 | 54382 | 2020-04-13 | Peoria | Illinois | 17143 | 30 | 1 |
51701 | 51701 | 2020-04-12 | Peoria | Illinois | 17143 | 27 | 1 |
49039 | 49039 | 2020-04-11 | Peoria | Illinois | 17143 | 23 | 1 |
46407 | 46407 | 2020-04-10 | Peoria | Illinois | 17143 | 20 | 1 |
43803 | 43803 | 2020-04-09 | Peoria | Illinois | 17143 | 16 | 1 |
41229 | 41229 | 2020-04-08 | Peoria | Illinois | 17143 | 16 | 1 |
38684 | 38684 | 2020-04-07 | Peoria | Illinois | 17143 | 13 | 1 |
36188 | 36188 | 2020-04-06 | Peoria | Illinois | 17143 | 12 | 1 |
33736 | 33736 | 2020-04-05 | Peoria | Illinois | 17143 | 14 | 2 |
31326 | 31326 | 2020-04-04 | Peoria | Illinois | 17143 | 11 | 0 |
28961 | 28961 | 2020-04-03 | Peoria | Illinois | 17143 | 11 | 0 |
26651 | 26651 | 2020-04-02 | Peoria | Illinois | 17143 | 11 | 0 |
24414 | 24414 | 2020-04-01 | Peoria | Illinois | 17143 | 10 | 0 |
22245 | 22245 | 2020-03-31 | Peoria | Illinois | 17143 | 8 | 0 |
20152 | 20152 | 2020-03-30 | Peoria | Illinois | 17143 | 8 | 0 |
18149 | 18149 | 2020-03-29 | Peoria | Illinois | 17143 | 8 | 0 |
16247 | 16247 | 2020-03-28 | Peoria | Illinois | 17143 | 7 | 0 |
14451 | 14451 | 2020-03-27 | Peoria | Illinois | 17143 | 6 | 0 |
12773 | 12773 | 2020-03-26 | Peoria | Illinois | 17143 | 5 | 0 |
11217 | 11217 | 2020-03-25 | Peoria | Illinois | 17143 | 4 | 0 |
9824 | 9824 | 2020-03-24 | Peoria | Illinois | 17143 | 3 | 0 |
8560 | 8560 | 2020-03-23 | Peoria | Illinois | 17143 | 3 | 0 |
7404 | 7404 | 2020-03-22 | Peoria | Illinois | 17143 | 3 | 0 |
6352 | 6352 | 2020-03-21 | Peoria | Illinois | 17143 | 3 | 0 |
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);