ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17035 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386552 | 386552 | 2020-07-31 | Cumberland | Illinois | 17035 | 46 | 2 |
383334 | 383334 | 2020-07-30 | Cumberland | Illinois | 17035 | 43 | 2 |
380117 | 380117 | 2020-07-29 | Cumberland | Illinois | 17035 | 39 | 2 |
376900 | 376900 | 2020-07-28 | Cumberland | Illinois | 17035 | 39 | 2 |
373685 | 373685 | 2020-07-27 | Cumberland | Illinois | 17035 | 39 | 2 |
370473 | 370473 | 2020-07-26 | Cumberland | Illinois | 17035 | 39 | 2 |
367263 | 367263 | 2020-07-25 | Cumberland | Illinois | 17035 | 39 | 2 |
364056 | 364056 | 2020-07-24 | Cumberland | Illinois | 17035 | 40 | 1 |
360849 | 360849 | 2020-07-23 | Cumberland | Illinois | 17035 | 37 | 1 |
357644 | 357644 | 2020-07-22 | Cumberland | Illinois | 17035 | 36 | 1 |
354442 | 354442 | 2020-07-21 | Cumberland | Illinois | 17035 | 37 | 1 |
351240 | 351240 | 2020-07-20 | Cumberland | Illinois | 17035 | 36 | 1 |
348040 | 348040 | 2020-07-19 | Cumberland | Illinois | 17035 | 36 | 1 |
344839 | 344839 | 2020-07-18 | Cumberland | Illinois | 17035 | 36 | 1 |
341639 | 341639 | 2020-07-17 | Cumberland | Illinois | 17035 | 31 | 1 |
338443 | 338443 | 2020-07-16 | Cumberland | Illinois | 17035 | 31 | 1 |
335247 | 335247 | 2020-07-15 | Cumberland | Illinois | 17035 | 31 | 0 |
332054 | 332054 | 2020-07-14 | Cumberland | Illinois | 17035 | 30 | 0 |
328867 | 328867 | 2020-07-13 | Cumberland | Illinois | 17035 | 30 | 0 |
325681 | 325681 | 2020-07-12 | Cumberland | Illinois | 17035 | 29 | 0 |
322500 | 322500 | 2020-07-11 | Cumberland | Illinois | 17035 | 29 | 0 |
319321 | 319321 | 2020-07-10 | Cumberland | Illinois | 17035 | 30 | 0 |
316148 | 316148 | 2020-07-09 | Cumberland | Illinois | 17035 | 24 | 0 |
312974 | 312974 | 2020-07-08 | Cumberland | Illinois | 17035 | 24 | 0 |
309804 | 309804 | 2020-07-07 | Cumberland | Illinois | 17035 | 17 | 0 |
306636 | 306636 | 2020-07-06 | Cumberland | Illinois | 17035 | 17 | 0 |
303471 | 303471 | 2020-07-05 | Cumberland | Illinois | 17035 | 16 | 0 |
300307 | 300307 | 2020-07-04 | Cumberland | Illinois | 17035 | 16 | 0 |
297145 | 297145 | 2020-07-03 | Cumberland | Illinois | 17035 | 12 | 0 |
293988 | 293988 | 2020-07-02 | Cumberland | Illinois | 17035 | 12 | 0 |
290834 | 290834 | 2020-07-01 | Cumberland | Illinois | 17035 | 12 | 0 |
287684 | 287684 | 2020-06-30 | Cumberland | Illinois | 17035 | 11 | 0 |
284535 | 284535 | 2020-06-29 | Cumberland | Illinois | 17035 | 11 | 0 |
281390 | 281390 | 2020-06-28 | Cumberland | Illinois | 17035 | 11 | 0 |
278242 | 278242 | 2020-06-27 | Cumberland | Illinois | 17035 | 11 | 0 |
275094 | 275094 | 2020-06-26 | Cumberland | Illinois | 17035 | 10 | 0 |
271952 | 271952 | 2020-06-25 | Cumberland | Illinois | 17035 | 10 | 0 |
268815 | 268815 | 2020-06-24 | Cumberland | Illinois | 17035 | 10 | 0 |
265685 | 265685 | 2020-06-23 | Cumberland | Illinois | 17035 | 10 | 0 |
262557 | 262557 | 2020-06-22 | Cumberland | Illinois | 17035 | 10 | 0 |
259430 | 259430 | 2020-06-21 | Cumberland | Illinois | 17035 | 10 | 0 |
256304 | 256304 | 2020-06-20 | Cumberland | Illinois | 17035 | 10 | 0 |
253184 | 253184 | 2020-06-19 | Cumberland | Illinois | 17035 | 10 | 0 |
250069 | 250069 | 2020-06-18 | Cumberland | Illinois | 17035 | 10 | 0 |
246957 | 246957 | 2020-06-17 | Cumberland | Illinois | 17035 | 10 | 0 |
243844 | 243844 | 2020-06-16 | Cumberland | Illinois | 17035 | 10 | 0 |
240733 | 240733 | 2020-06-15 | Cumberland | Illinois | 17035 | 10 | 0 |
237625 | 237625 | 2020-06-14 | Cumberland | Illinois | 17035 | 10 | 0 |
234518 | 234518 | 2020-06-13 | Cumberland | Illinois | 17035 | 10 | 0 |
231412 | 231412 | 2020-06-12 | Cumberland | Illinois | 17035 | 10 | 0 |
228309 | 228309 | 2020-06-11 | Cumberland | Illinois | 17035 | 10 | 0 |
225207 | 225207 | 2020-06-10 | Cumberland | Illinois | 17035 | 10 | 0 |
222112 | 222112 | 2020-06-09 | Cumberland | Illinois | 17035 | 10 | 0 |
219017 | 219017 | 2020-06-08 | Cumberland | Illinois | 17035 | 10 | 0 |
215926 | 215926 | 2020-06-07 | Cumberland | Illinois | 17035 | 10 | 0 |
212839 | 212839 | 2020-06-06 | Cumberland | Illinois | 17035 | 10 | 0 |
209754 | 209754 | 2020-06-05 | Cumberland | Illinois | 17035 | 10 | 0 |
206673 | 206673 | 2020-06-04 | Cumberland | Illinois | 17035 | 10 | 0 |
203593 | 203593 | 2020-06-03 | Cumberland | Illinois | 17035 | 10 | 0 |
200517 | 200517 | 2020-06-02 | Cumberland | Illinois | 17035 | 10 | 0 |
197444 | 197444 | 2020-06-01 | Cumberland | Illinois | 17035 | 10 | 0 |
194374 | 194374 | 2020-05-31 | Cumberland | Illinois | 17035 | 10 | 0 |
191307 | 191307 | 2020-05-30 | Cumberland | Illinois | 17035 | 10 | 0 |
188242 | 188242 | 2020-05-29 | Cumberland | Illinois | 17035 | 10 | 0 |
185185 | 185185 | 2020-05-28 | Cumberland | Illinois | 17035 | 10 | 0 |
182131 | 182131 | 2020-05-27 | Cumberland | Illinois | 17035 | 10 | 0 |
179087 | 179087 | 2020-05-26 | Cumberland | Illinois | 17035 | 10 | 0 |
176043 | 176043 | 2020-05-25 | Cumberland | Illinois | 17035 | 10 | 0 |
172999 | 172999 | 2020-05-24 | Cumberland | Illinois | 17035 | 10 | 0 |
169958 | 169958 | 2020-05-23 | Cumberland | Illinois | 17035 | 10 | 0 |
166921 | 166921 | 2020-05-22 | Cumberland | Illinois | 17035 | 10 | 0 |
163888 | 163888 | 2020-05-21 | Cumberland | Illinois | 17035 | 10 | 0 |
160860 | 160860 | 2020-05-20 | Cumberland | Illinois | 17035 | 10 | 0 |
157834 | 157834 | 2020-05-19 | Cumberland | Illinois | 17035 | 9 | 0 |
154818 | 154818 | 2020-05-18 | Cumberland | Illinois | 17035 | 9 | 0 |
151806 | 151806 | 2020-05-17 | Cumberland | Illinois | 17035 | 8 | 0 |
148797 | 148797 | 2020-05-16 | Cumberland | Illinois | 17035 | 8 | 0 |
145794 | 145794 | 2020-05-15 | Cumberland | Illinois | 17035 | 8 | 0 |
142794 | 142794 | 2020-05-14 | Cumberland | Illinois | 17035 | 8 | 0 |
139798 | 139798 | 2020-05-13 | Cumberland | Illinois | 17035 | 7 | 0 |
136807 | 136807 | 2020-05-12 | Cumberland | Illinois | 17035 | 6 | 0 |
133818 | 133818 | 2020-05-11 | Cumberland | Illinois | 17035 | 4 | 0 |
130827 | 130827 | 2020-05-10 | Cumberland | Illinois | 17035 | 4 | 0 |
127836 | 127836 | 2020-05-09 | Cumberland | Illinois | 17035 | 4 | 0 |
124849 | 124849 | 2020-05-08 | Cumberland | Illinois | 17035 | 4 | 0 |
121870 | 121870 | 2020-05-07 | Cumberland | Illinois | 17035 | 4 | 0 |
118900 | 118900 | 2020-05-06 | Cumberland | Illinois | 17035 | 4 | 0 |
115940 | 115940 | 2020-05-05 | Cumberland | Illinois | 17035 | 4 | 0 |
113057 | 113057 | 2020-05-04 | Cumberland | Illinois | 17035 | 4 | 0 |
110182 | 110182 | 2020-05-03 | Cumberland | Illinois | 17035 | 3 | 0 |
107312 | 107312 | 2020-05-02 | Cumberland | Illinois | 17035 | 3 | 0 |
104447 | 104447 | 2020-05-01 | Cumberland | Illinois | 17035 | 3 | 0 |
101591 | 101591 | 2020-04-30 | Cumberland | Illinois | 17035 | 3 | 0 |
98740 | 98740 | 2020-04-29 | Cumberland | Illinois | 17035 | 3 | 0 |
95896 | 95896 | 2020-04-28 | Cumberland | Illinois | 17035 | 3 | 0 |
93064 | 93064 | 2020-04-27 | Cumberland | Illinois | 17035 | 3 | 0 |
90245 | 90245 | 2020-04-26 | Cumberland | Illinois | 17035 | 3 | 0 |
87429 | 87429 | 2020-04-25 | Cumberland | Illinois | 17035 | 3 | 0 |
84619 | 84619 | 2020-04-24 | Cumberland | Illinois | 17035 | 2 | 0 |
81819 | 81819 | 2020-04-23 | Cumberland | Illinois | 17035 | 2 | 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);