ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17119 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
606353 | 606353 | 2020-10-07 | Madison | Illinois | 17119 | 6156 | 148 |
603111 | 603111 | 2020-10-06 | Madison | Illinois | 17119 | 6106 | 147 |
599868 | 599868 | 2020-10-05 | Madison | Illinois | 17119 | 6083 | 147 |
596626 | 596626 | 2020-10-04 | Madison | Illinois | 17119 | 6050 | 147 |
593384 | 593384 | 2020-10-03 | Madison | Illinois | 17119 | 6024 | 147 |
590143 | 590143 | 2020-10-02 | Madison | Illinois | 17119 | 5994 | 145 |
586902 | 586902 | 2020-10-01 | Madison | Illinois | 17119 | 5937 | 144 |
583662 | 583662 | 2020-09-30 | Madison | Illinois | 17119 | 5883 | 143 |
580423 | 580423 | 2020-09-29 | Madison | Illinois | 17119 | 5835 | 141 |
577182 | 577182 | 2020-09-28 | Madison | Illinois | 17119 | 5777 | 140 |
573940 | 573940 | 2020-09-27 | Madison | Illinois | 17119 | 5716 | 136 |
570697 | 570697 | 2020-09-26 | Madison | Illinois | 17119 | 5666 | 136 |
567455 | 567455 | 2020-09-25 | Madison | Illinois | 17119 | 5577 | 136 |
564215 | 564215 | 2020-09-24 | Madison | Illinois | 17119 | 5518 | 136 |
560975 | 560975 | 2020-09-23 | Madison | Illinois | 17119 | 5464 | 131 |
557739 | 557739 | 2020-09-22 | Madison | Illinois | 17119 | 5422 | 131 |
554502 | 554502 | 2020-09-21 | Madison | Illinois | 17119 | 5380 | 130 |
551263 | 551263 | 2020-09-20 | Madison | Illinois | 17119 | 5341 | 130 |
548024 | 548024 | 2020-09-19 | Madison | Illinois | 17119 | 5291 | 130 |
544786 | 544786 | 2020-09-18 | Madison | Illinois | 17119 | 5231 | 130 |
541550 | 541550 | 2020-09-17 | Madison | Illinois | 17119 | 5154 | 130 |
538313 | 538313 | 2020-09-16 | Madison | Illinois | 17119 | 5088 | 126 |
535077 | 535077 | 2020-09-15 | Madison | Illinois | 17119 | 5020 | 122 |
531842 | 531842 | 2020-09-14 | Madison | Illinois | 17119 | 4965 | 121 |
528605 | 528605 | 2020-09-13 | Madison | Illinois | 17119 | 4908 | 119 |
525369 | 525369 | 2020-09-12 | Madison | Illinois | 17119 | 4872 | 118 |
522133 | 522133 | 2020-09-11 | Madison | Illinois | 17119 | 4780 | 117 |
518896 | 518896 | 2020-09-10 | Madison | Illinois | 17119 | 4693 | 115 |
515661 | 515661 | 2020-09-09 | Madison | Illinois | 17119 | 4631 | 113 |
512428 | 512428 | 2020-09-08 | Madison | Illinois | 17119 | 4585 | 108 |
509195 | 509195 | 2020-09-07 | Madison | Illinois | 17119 | 4536 | 108 |
505963 | 505963 | 2020-09-06 | Madison | Illinois | 17119 | 4498 | 108 |
502729 | 502729 | 2020-09-05 | Madison | Illinois | 17119 | 4448 | 108 |
499495 | 499495 | 2020-09-04 | Madison | Illinois | 17119 | 4380 | 105 |
496262 | 496262 | 2020-09-03 | Madison | Illinois | 17119 | 4219 | 103 |
493028 | 493028 | 2020-09-02 | Madison | Illinois | 17119 | 4182 | 101 |
489795 | 489795 | 2020-09-01 | Madison | Illinois | 17119 | 4102 | 100 |
486562 | 486562 | 2020-08-31 | Madison | Illinois | 17119 | 4040 | 98 |
483327 | 483327 | 2020-08-30 | Madison | Illinois | 17119 | 3982 | 98 |
480093 | 480093 | 2020-08-29 | Madison | Illinois | 17119 | 3956 | 97 |
476860 | 476860 | 2020-08-28 | Madison | Illinois | 17119 | 3868 | 95 |
473627 | 473627 | 2020-08-27 | Madison | Illinois | 17119 | 3818 | 95 |
470395 | 470395 | 2020-08-26 | Madison | Illinois | 17119 | 3752 | 93 |
467166 | 467166 | 2020-08-25 | Madison | Illinois | 17119 | 3666 | 92 |
463937 | 463937 | 2020-08-24 | Madison | Illinois | 17119 | 3606 | 91 |
460708 | 460708 | 2020-08-23 | Madison | Illinois | 17119 | 3562 | 91 |
457481 | 457481 | 2020-08-22 | Madison | Illinois | 17119 | 3503 | 91 |
454253 | 454253 | 2020-08-21 | Madison | Illinois | 17119 | 3441 | 90 |
451025 | 451025 | 2020-08-20 | Madison | Illinois | 17119 | 3366 | 88 |
447797 | 447797 | 2020-08-19 | Madison | Illinois | 17119 | 3289 | 87 |
444570 | 444570 | 2020-08-18 | Madison | Illinois | 17119 | 3241 | 87 |
441344 | 441344 | 2020-08-17 | Madison | Illinois | 17119 | 3152 | 85 |
438118 | 438118 | 2020-08-16 | Madison | Illinois | 17119 | 3111 | 85 |
434892 | 434892 | 2020-08-15 | Madison | Illinois | 17119 | 3051 | 85 |
431667 | 431667 | 2020-08-14 | Madison | Illinois | 17119 | 2969 | 85 |
428439 | 428439 | 2020-08-13 | Madison | Illinois | 17119 | 2855 | 82 |
425215 | 425215 | 2020-08-12 | Madison | Illinois | 17119 | 2777 | 78 |
421994 | 421994 | 2020-08-11 | Madison | Illinois | 17119 | 2702 | 78 |
418771 | 418771 | 2020-08-10 | Madison | Illinois | 17119 | 2634 | 77 |
415550 | 415550 | 2020-08-09 | Madison | Illinois | 17119 | 2591 | 77 |
412330 | 412330 | 2020-08-08 | Madison | Illinois | 17119 | 2530 | 77 |
409111 | 409111 | 2020-08-07 | Madison | Illinois | 17119 | 2470 | 77 |
405891 | 405891 | 2020-08-06 | Madison | Illinois | 17119 | 2410 | 74 |
402673 | 402673 | 2020-08-05 | Madison | Illinois | 17119 | 2320 | 73 |
399457 | 399457 | 2020-08-04 | Madison | Illinois | 17119 | 2266 | 73 |
396241 | 396241 | 2020-08-03 | Madison | Illinois | 17119 | 2222 | 73 |
393025 | 393025 | 2020-08-02 | Madison | Illinois | 17119 | 2186 | 73 |
389808 | 389808 | 2020-08-01 | Madison | Illinois | 17119 | 2137 | 72 |
386591 | 386591 | 2020-07-31 | Madison | Illinois | 17119 | 2099 | 72 |
383373 | 383373 | 2020-07-30 | Madison | Illinois | 17119 | 2047 | 72 |
380156 | 380156 | 2020-07-29 | Madison | Illinois | 17119 | 1975 | 72 |
376939 | 376939 | 2020-07-28 | Madison | Illinois | 17119 | 1942 | 72 |
373724 | 373724 | 2020-07-27 | Madison | Illinois | 17119 | 1915 | 72 |
370512 | 370512 | 2020-07-26 | Madison | Illinois | 17119 | 1840 | 71 |
367302 | 367302 | 2020-07-25 | Madison | Illinois | 17119 | 1762 | 71 |
364095 | 364095 | 2020-07-24 | Madison | Illinois | 17119 | 1701 | 71 |
360888 | 360888 | 2020-07-23 | Madison | Illinois | 17119 | 1655 | 71 |
357683 | 357683 | 2020-07-22 | Madison | Illinois | 17119 | 1604 | 71 |
354481 | 354481 | 2020-07-21 | Madison | Illinois | 17119 | 1544 | 71 |
351279 | 351279 | 2020-07-20 | Madison | Illinois | 17119 | 1534 | 71 |
348079 | 348079 | 2020-07-19 | Madison | Illinois | 17119 | 1478 | 71 |
344878 | 344878 | 2020-07-18 | Madison | Illinois | 17119 | 1457 | 71 |
341678 | 341678 | 2020-07-17 | Madison | Illinois | 17119 | 1413 | 71 |
338482 | 338482 | 2020-07-16 | Madison | Illinois | 17119 | 1368 | 71 |
335286 | 335286 | 2020-07-15 | Madison | Illinois | 17119 | 1318 | 71 |
332093 | 332093 | 2020-07-14 | Madison | Illinois | 17119 | 1285 | 71 |
328906 | 328906 | 2020-07-13 | Madison | Illinois | 17119 | 1258 | 71 |
325720 | 325720 | 2020-07-12 | Madison | Illinois | 17119 | 1198 | 70 |
322539 | 322539 | 2020-07-11 | Madison | Illinois | 17119 | 1167 | 70 |
319360 | 319360 | 2020-07-10 | Madison | Illinois | 17119 | 1134 | 70 |
316187 | 316187 | 2020-07-09 | Madison | Illinois | 17119 | 1111 | 70 |
313013 | 313013 | 2020-07-08 | Madison | Illinois | 17119 | 1090 | 70 |
309843 | 309843 | 2020-07-07 | Madison | Illinois | 17119 | 1062 | 70 |
306675 | 306675 | 2020-07-06 | Madison | Illinois | 17119 | 1043 | 70 |
303510 | 303510 | 2020-07-05 | Madison | Illinois | 17119 | 1036 | 69 |
300346 | 300346 | 2020-07-04 | Madison | Illinois | 17119 | 1007 | 69 |
297184 | 297184 | 2020-07-03 | Madison | Illinois | 17119 | 993 | 69 |
294027 | 294027 | 2020-07-02 | Madison | Illinois | 17119 | 974 | 69 |
290873 | 290873 | 2020-07-01 | Madison | Illinois | 17119 | 960 | 69 |
287723 | 287723 | 2020-06-30 | Madison | Illinois | 17119 | 939 | 68 |
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);