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 |
---|---|---|---|---|---|---|---|
531803 | 531803 | 2020-09-14 | Cumberland | Illinois | 17035 | 182 | 4 |
528566 | 528566 | 2020-09-13 | Cumberland | Illinois | 17035 | 182 | 4 |
525330 | 525330 | 2020-09-12 | Cumberland | Illinois | 17035 | 179 | 4 |
522094 | 522094 | 2020-09-11 | Cumberland | Illinois | 17035 | 176 | 4 |
518857 | 518857 | 2020-09-10 | Cumberland | Illinois | 17035 | 176 | 4 |
515622 | 515622 | 2020-09-09 | Cumberland | Illinois | 17035 | 172 | 4 |
512389 | 512389 | 2020-09-08 | Cumberland | Illinois | 17035 | 170 | 4 |
509156 | 509156 | 2020-09-07 | Cumberland | Illinois | 17035 | 165 | 4 |
505924 | 505924 | 2020-09-06 | Cumberland | Illinois | 17035 | 164 | 4 |
502690 | 502690 | 2020-09-05 | Cumberland | Illinois | 17035 | 159 | 4 |
499456 | 499456 | 2020-09-04 | Cumberland | Illinois | 17035 | 154 | 4 |
496223 | 496223 | 2020-09-03 | Cumberland | Illinois | 17035 | 148 | 3 |
492989 | 492989 | 2020-09-02 | Cumberland | Illinois | 17035 | 146 | 3 |
489756 | 489756 | 2020-09-01 | Cumberland | Illinois | 17035 | 140 | 3 |
486523 | 486523 | 2020-08-31 | Cumberland | Illinois | 17035 | 140 | 3 |
483288 | 483288 | 2020-08-30 | Cumberland | Illinois | 17035 | 137 | 3 |
480054 | 480054 | 2020-08-29 | Cumberland | Illinois | 17035 | 133 | 3 |
476821 | 476821 | 2020-08-28 | Cumberland | Illinois | 17035 | 128 | 3 |
473588 | 473588 | 2020-08-27 | Cumberland | Illinois | 17035 | 127 | 3 |
470356 | 470356 | 2020-08-26 | Cumberland | Illinois | 17035 | 123 | 3 |
467127 | 467127 | 2020-08-25 | Cumberland | Illinois | 17035 | 114 | 3 |
463898 | 463898 | 2020-08-24 | Cumberland | Illinois | 17035 | 109 | 3 |
460669 | 460669 | 2020-08-23 | Cumberland | Illinois | 17035 | 107 | 3 |
457442 | 457442 | 2020-08-22 | Cumberland | Illinois | 17035 | 103 | 3 |
454214 | 454214 | 2020-08-21 | Cumberland | Illinois | 17035 | 95 | 3 |
450986 | 450986 | 2020-08-20 | Cumberland | Illinois | 17035 | 86 | 3 |
447758 | 447758 | 2020-08-19 | Cumberland | Illinois | 17035 | 82 | 3 |
444531 | 444531 | 2020-08-18 | Cumberland | Illinois | 17035 | 75 | 3 |
441305 | 441305 | 2020-08-17 | Cumberland | Illinois | 17035 | 69 | 3 |
438079 | 438079 | 2020-08-16 | Cumberland | Illinois | 17035 | 66 | 3 |
434853 | 434853 | 2020-08-15 | Cumberland | Illinois | 17035 | 62 | 3 |
431628 | 431628 | 2020-08-14 | Cumberland | Illinois | 17035 | 61 | 3 |
428400 | 428400 | 2020-08-13 | Cumberland | Illinois | 17035 | 60 | 3 |
425176 | 425176 | 2020-08-12 | Cumberland | Illinois | 17035 | 57 | 3 |
421955 | 421955 | 2020-08-11 | Cumberland | Illinois | 17035 | 57 | 3 |
418732 | 418732 | 2020-08-10 | Cumberland | Illinois | 17035 | 57 | 3 |
415511 | 415511 | 2020-08-09 | Cumberland | Illinois | 17035 | 55 | 2 |
412291 | 412291 | 2020-08-08 | Cumberland | Illinois | 17035 | 54 | 2 |
409072 | 409072 | 2020-08-07 | Cumberland | Illinois | 17035 | 53 | 2 |
405852 | 405852 | 2020-08-06 | Cumberland | Illinois | 17035 | 51 | 2 |
402634 | 402634 | 2020-08-05 | Cumberland | Illinois | 17035 | 47 | 2 |
399418 | 399418 | 2020-08-04 | Cumberland | Illinois | 17035 | 47 | 2 |
396202 | 396202 | 2020-08-03 | Cumberland | Illinois | 17035 | 47 | 2 |
392986 | 392986 | 2020-08-02 | Cumberland | Illinois | 17035 | 46 | 2 |
389769 | 389769 | 2020-08-01 | Cumberland | Illinois | 17035 | 46 | 2 |
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 |
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);