ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17203 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386637 | 386637 | 2020-07-31 | Woodford | Illinois | 17203 | 89 | 3 |
383419 | 383419 | 2020-07-30 | Woodford | Illinois | 17203 | 86 | 3 |
380202 | 380202 | 2020-07-29 | Woodford | Illinois | 17203 | 80 | 3 |
376985 | 376985 | 2020-07-28 | Woodford | Illinois | 17203 | 77 | 3 |
373770 | 373770 | 2020-07-27 | Woodford | Illinois | 17203 | 75 | 3 |
370558 | 370558 | 2020-07-26 | Woodford | Illinois | 17203 | 71 | 3 |
367348 | 367348 | 2020-07-25 | Woodford | Illinois | 17203 | 69 | 3 |
364141 | 364141 | 2020-07-24 | Woodford | Illinois | 17203 | 68 | 3 |
360934 | 360934 | 2020-07-23 | Woodford | Illinois | 17203 | 68 | 3 |
357729 | 357729 | 2020-07-22 | Woodford | Illinois | 17203 | 68 | 3 |
354527 | 354527 | 2020-07-21 | Woodford | Illinois | 17203 | 66 | 3 |
351325 | 351325 | 2020-07-20 | Woodford | Illinois | 17203 | 66 | 3 |
348125 | 348125 | 2020-07-19 | Woodford | Illinois | 17203 | 64 | 3 |
344924 | 344924 | 2020-07-18 | Woodford | Illinois | 17203 | 63 | 3 |
341724 | 341724 | 2020-07-17 | Woodford | Illinois | 17203 | 60 | 3 |
338528 | 338528 | 2020-07-16 | Woodford | Illinois | 17203 | 58 | 3 |
335332 | 335332 | 2020-07-15 | Woodford | Illinois | 17203 | 57 | 2 |
332139 | 332139 | 2020-07-14 | Woodford | Illinois | 17203 | 54 | 2 |
328952 | 328952 | 2020-07-13 | Woodford | Illinois | 17203 | 54 | 2 |
325766 | 325766 | 2020-07-12 | Woodford | Illinois | 17203 | 48 | 2 |
322585 | 322585 | 2020-07-11 | Woodford | Illinois | 17203 | 46 | 2 |
319406 | 319406 | 2020-07-10 | Woodford | Illinois | 17203 | 46 | 2 |
316233 | 316233 | 2020-07-09 | Woodford | Illinois | 17203 | 43 | 2 |
313059 | 313059 | 2020-07-08 | Woodford | Illinois | 17203 | 39 | 2 |
309889 | 309889 | 2020-07-07 | Woodford | Illinois | 17203 | 38 | 2 |
306721 | 306721 | 2020-07-06 | Woodford | Illinois | 17203 | 36 | 2 |
303556 | 303556 | 2020-07-05 | Woodford | Illinois | 17203 | 35 | 2 |
300392 | 300392 | 2020-07-04 | Woodford | Illinois | 17203 | 35 | 2 |
297230 | 297230 | 2020-07-03 | Woodford | Illinois | 17203 | 35 | 2 |
294072 | 294072 | 2020-07-02 | Woodford | Illinois | 17203 | 35 | 2 |
290918 | 290918 | 2020-07-01 | Woodford | Illinois | 17203 | 34 | 2 |
287768 | 287768 | 2020-06-30 | Woodford | Illinois | 17203 | 34 | 2 |
284619 | 284619 | 2020-06-29 | Woodford | Illinois | 17203 | 34 | 2 |
281474 | 281474 | 2020-06-28 | Woodford | Illinois | 17203 | 34 | 2 |
278326 | 278326 | 2020-06-27 | Woodford | Illinois | 17203 | 34 | 2 |
275178 | 275178 | 2020-06-26 | Woodford | Illinois | 17203 | 34 | 2 |
272036 | 272036 | 2020-06-25 | Woodford | Illinois | 17203 | 34 | 2 |
268899 | 268899 | 2020-06-24 | Woodford | Illinois | 17203 | 33 | 2 |
265769 | 265769 | 2020-06-23 | Woodford | Illinois | 17203 | 33 | 2 |
262641 | 262641 | 2020-06-22 | Woodford | Illinois | 17203 | 33 | 2 |
259514 | 259514 | 2020-06-21 | Woodford | Illinois | 17203 | 33 | 2 |
256388 | 256388 | 2020-06-20 | Woodford | Illinois | 17203 | 33 | 2 |
253268 | 253268 | 2020-06-19 | Woodford | Illinois | 17203 | 32 | 2 |
250153 | 250153 | 2020-06-18 | Woodford | Illinois | 17203 | 31 | 2 |
247041 | 247041 | 2020-06-17 | Woodford | Illinois | 17203 | 31 | 2 |
243928 | 243928 | 2020-06-16 | Woodford | Illinois | 17203 | 29 | 2 |
240817 | 240817 | 2020-06-15 | Woodford | Illinois | 17203 | 28 | 2 |
237709 | 237709 | 2020-06-14 | Woodford | Illinois | 17203 | 25 | 2 |
234602 | 234602 | 2020-06-13 | Woodford | Illinois | 17203 | 25 | 2 |
231496 | 231496 | 2020-06-12 | Woodford | Illinois | 17203 | 24 | 2 |
228393 | 228393 | 2020-06-11 | Woodford | Illinois | 17203 | 24 | 2 |
225291 | 225291 | 2020-06-10 | Woodford | Illinois | 17203 | 23 | 2 |
222196 | 222196 | 2020-06-09 | Woodford | Illinois | 17203 | 23 | 2 |
219101 | 219101 | 2020-06-08 | Woodford | Illinois | 17203 | 23 | 2 |
216009 | 216009 | 2020-06-07 | Woodford | Illinois | 17203 | 23 | 2 |
212922 | 212922 | 2020-06-06 | Woodford | Illinois | 17203 | 22 | 2 |
209837 | 209837 | 2020-06-05 | Woodford | Illinois | 17203 | 22 | 2 |
206756 | 206756 | 2020-06-04 | Woodford | Illinois | 17203 | 22 | 2 |
203676 | 203676 | 2020-06-03 | Woodford | Illinois | 17203 | 22 | 2 |
200600 | 200600 | 2020-06-02 | Woodford | Illinois | 17203 | 22 | 2 |
197527 | 197527 | 2020-06-01 | Woodford | Illinois | 17203 | 22 | 2 |
194457 | 194457 | 2020-05-31 | Woodford | Illinois | 17203 | 21 | 2 |
191390 | 191390 | 2020-05-30 | Woodford | Illinois | 17203 | 20 | 2 |
188325 | 188325 | 2020-05-29 | Woodford | Illinois | 17203 | 19 | 2 |
185267 | 185267 | 2020-05-28 | Woodford | Illinois | 17203 | 19 | 2 |
182213 | 182213 | 2020-05-27 | Woodford | Illinois | 17203 | 19 | 2 |
179169 | 179169 | 2020-05-26 | Woodford | Illinois | 17203 | 19 | 2 |
176125 | 176125 | 2020-05-25 | Woodford | Illinois | 17203 | 18 | 2 |
173081 | 173081 | 2020-05-24 | Woodford | Illinois | 17203 | 18 | 2 |
170040 | 170040 | 2020-05-23 | Woodford | Illinois | 17203 | 18 | 2 |
167003 | 167003 | 2020-05-22 | Woodford | Illinois | 17203 | 18 | 2 |
163970 | 163970 | 2020-05-21 | Woodford | Illinois | 17203 | 18 | 2 |
160942 | 160942 | 2020-05-20 | Woodford | Illinois | 17203 | 18 | 2 |
157916 | 157916 | 2020-05-19 | Woodford | Illinois | 17203 | 16 | 1 |
154900 | 154900 | 2020-05-18 | Woodford | Illinois | 17203 | 16 | 1 |
151888 | 151888 | 2020-05-17 | Woodford | Illinois | 17203 | 14 | 1 |
148879 | 148879 | 2020-05-16 | Woodford | Illinois | 17203 | 14 | 1 |
145875 | 145875 | 2020-05-15 | Woodford | Illinois | 17203 | 14 | 1 |
142875 | 142875 | 2020-05-14 | Woodford | Illinois | 17203 | 14 | 1 |
139879 | 139879 | 2020-05-13 | Woodford | Illinois | 17203 | 15 | 1 |
136887 | 136887 | 2020-05-12 | Woodford | Illinois | 17203 | 15 | 1 |
133898 | 133898 | 2020-05-11 | Woodford | Illinois | 17203 | 15 | 1 |
130908 | 130908 | 2020-05-10 | Woodford | Illinois | 17203 | 15 | 1 |
127917 | 127917 | 2020-05-09 | Woodford | Illinois | 17203 | 15 | 1 |
124930 | 124930 | 2020-05-08 | Woodford | Illinois | 17203 | 15 | 1 |
121950 | 121950 | 2020-05-07 | Woodford | Illinois | 17203 | 15 | 1 |
118980 | 118980 | 2020-05-06 | Woodford | Illinois | 17203 | 15 | 1 |
116020 | 116020 | 2020-05-05 | Woodford | Illinois | 17203 | 13 | 1 |
113137 | 113137 | 2020-05-04 | Woodford | Illinois | 17203 | 13 | 1 |
110262 | 110262 | 2020-05-03 | Woodford | Illinois | 17203 | 13 | 1 |
107392 | 107392 | 2020-05-02 | Woodford | Illinois | 17203 | 13 | 1 |
104527 | 104527 | 2020-05-01 | Woodford | Illinois | 17203 | 14 | 1 |
101671 | 101671 | 2020-04-30 | Woodford | Illinois | 17203 | 13 | 1 |
98820 | 98820 | 2020-04-29 | Woodford | Illinois | 17203 | 12 | 1 |
95976 | 95976 | 2020-04-28 | Woodford | Illinois | 17203 | 12 | 1 |
93144 | 93144 | 2020-04-27 | Woodford | Illinois | 17203 | 11 | 1 |
90325 | 90325 | 2020-04-26 | Woodford | Illinois | 17203 | 11 | 1 |
87509 | 87509 | 2020-04-25 | Woodford | Illinois | 17203 | 11 | 1 |
84699 | 84699 | 2020-04-24 | Woodford | Illinois | 17203 | 11 | 1 |
81899 | 81899 | 2020-04-23 | Woodford | Illinois | 17203 | 11 | 1 |
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);