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 |
---|---|---|---|---|---|---|---|
930830 | 930830 | 2021-01-15 | Madison | Illinois | 17119 | 23853 | 455 |
927585 | 927585 | 2021-01-14 | Madison | Illinois | 17119 | 23664 | 449 |
924339 | 924339 | 2021-01-13 | Madison | Illinois | 17119 | 23450 | 445 |
921094 | 921094 | 2021-01-12 | Madison | Illinois | 17119 | 23239 | 444 |
917849 | 917849 | 2021-01-11 | Madison | Illinois | 17119 | 23063 | 433 |
914604 | 914604 | 2021-01-10 | Madison | Illinois | 17119 | 22953 | 433 |
911359 | 911359 | 2021-01-09 | Madison | Illinois | 17119 | 22785 | 429 |
908114 | 908114 | 2021-01-08 | Madison | Illinois | 17119 | 22561 | 426 |
904868 | 904868 | 2021-01-07 | Madison | Illinois | 17119 | 22258 | 423 |
901623 | 901623 | 2021-01-06 | Madison | Illinois | 17119 | 22058 | 418 |
898378 | 898378 | 2021-01-05 | Madison | Illinois | 17119 | 21825 | 411 |
895133 | 895133 | 2021-01-04 | Madison | Illinois | 17119 | 21688 | 402 |
891886 | 891886 | 2021-01-03 | Madison | Illinois | 17119 | 21557 | 397 |
888639 | 888639 | 2021-01-02 | Madison | Illinois | 17119 | 21409 | 394 |
885394 | 885394 | 2021-01-01 | Madison | Illinois | 17119 | 21054 | 389 |
882149 | 882149 | 2020-12-31 | Madison | Illinois | 17119 | 21054 | 389 |
878904 | 878904 | 2020-12-30 | Madison | Illinois | 17119 | 20827 | 384 |
875659 | 875659 | 2020-12-29 | Madison | Illinois | 17119 | 20555 | 384 |
872414 | 872414 | 2020-12-28 | Madison | Illinois | 17119 | 20434 | 382 |
869169 | 869169 | 2020-12-27 | Madison | Illinois | 17119 | 20334 | 379 |
865924 | 865924 | 2020-12-26 | Madison | Illinois | 17119 | 20238 | 373 |
862679 | 862679 | 2020-12-25 | Madison | Illinois | 17119 | 20181 | 373 |
859434 | 859434 | 2020-12-24 | Madison | Illinois | 17119 | 20065 | 372 |
856189 | 856189 | 2020-12-23 | Madison | Illinois | 17119 | 19793 | 366 |
852944 | 852944 | 2020-12-22 | Madison | Illinois | 17119 | 19568 | 362 |
849699 | 849699 | 2020-12-21 | Madison | Illinois | 17119 | 19386 | 360 |
846454 | 846454 | 2020-12-20 | Madison | Illinois | 17119 | 19267 | 355 |
843208 | 843208 | 2020-12-19 | Madison | Illinois | 17119 | 19129 | 354 |
839963 | 839963 | 2020-12-18 | Madison | Illinois | 17119 | 18933 | 350 |
836718 | 836718 | 2020-12-17 | Madison | Illinois | 17119 | 18707 | 346 |
833472 | 833472 | 2020-12-16 | Madison | Illinois | 17119 | 18388 | 344 |
830225 | 830225 | 2020-12-15 | Madison | Illinois | 17119 | 18164 | 337 |
826979 | 826979 | 2020-12-14 | Madison | Illinois | 17119 | 17969 | 329 |
823732 | 823732 | 2020-12-13 | Madison | Illinois | 17119 | 17766 | 329 |
820486 | 820486 | 2020-12-12 | Madison | Illinois | 17119 | 17482 | 325 |
817240 | 817240 | 2020-12-11 | Madison | Illinois | 17119 | 17273 | 316 |
813994 | 813994 | 2020-12-10 | Madison | Illinois | 17119 | 17020 | 313 |
810749 | 810749 | 2020-12-09 | Madison | Illinois | 17119 | 16760 | 307 |
807504 | 807504 | 2020-12-08 | Madison | Illinois | 17119 | 16537 | 298 |
804259 | 804259 | 2020-12-07 | Madison | Illinois | 17119 | 16348 | 287 |
801014 | 801014 | 2020-12-06 | Madison | Illinois | 17119 | 16167 | 285 |
797769 | 797769 | 2020-12-05 | Madison | Illinois | 17119 | 15899 | 276 |
794524 | 794524 | 2020-12-04 | Madison | Illinois | 17119 | 15643 | 271 |
791279 | 791279 | 2020-12-03 | Madison | Illinois | 17119 | 15363 | 270 |
788034 | 788034 | 2020-12-02 | Madison | Illinois | 17119 | 15129 | 263 |
784790 | 784790 | 2020-12-01 | Madison | Illinois | 17119 | 14832 | 262 |
781545 | 781545 | 2020-11-30 | Madison | Illinois | 17119 | 14607 | 259 |
778299 | 778299 | 2020-11-29 | Madison | Illinois | 17119 | 14379 | 255 |
775054 | 775054 | 2020-11-28 | Madison | Illinois | 17119 | 14210 | 253 |
771809 | 771809 | 2020-11-27 | Madison | Illinois | 17119 | 14013 | 249 |
768564 | 768564 | 2020-11-26 | Madison | Illinois | 17119 | 13868 | 241 |
765318 | 765318 | 2020-11-25 | Madison | Illinois | 17119 | 13560 | 241 |
762073 | 762073 | 2020-11-24 | Madison | Illinois | 17119 | 13291 | 235 |
758828 | 758828 | 2020-11-23 | Madison | Illinois | 17119 | 13074 | 231 |
755581 | 755581 | 2020-11-22 | Madison | Illinois | 17119 | 12865 | 219 |
752335 | 752335 | 2020-11-21 | Madison | Illinois | 17119 | 12653 | 219 |
749089 | 749089 | 2020-11-20 | Madison | Illinois | 17119 | 12394 | 219 |
745843 | 745843 | 2020-11-19 | Madison | Illinois | 17119 | 12032 | 217 |
742596 | 742596 | 2020-11-18 | Madison | Illinois | 17119 | 11826 | 204 |
739349 | 739349 | 2020-11-17 | Madison | Illinois | 17119 | 11500 | 200 |
736105 | 736105 | 2020-11-16 | Madison | Illinois | 17119 | 11271 | 184 |
732859 | 732859 | 2020-11-15 | Madison | Illinois | 17119 | 10983 | 183 |
729614 | 729614 | 2020-11-14 | Madison | Illinois | 17119 | 10777 | 181 |
726371 | 726371 | 2020-11-13 | Madison | Illinois | 17119 | 10504 | 177 |
723128 | 723128 | 2020-11-12 | Madison | Illinois | 17119 | 10169 | 173 |
719885 | 719885 | 2020-11-11 | Madison | Illinois | 17119 | 9951 | 173 |
716642 | 716642 | 2020-11-10 | Madison | Illinois | 17119 | 9601 | 170 |
713398 | 713398 | 2020-11-09 | Madison | Illinois | 17119 | 9364 | 169 |
710154 | 710154 | 2020-11-08 | Madison | Illinois | 17119 | 9154 | 169 |
706910 | 706910 | 2020-11-07 | Madison | Illinois | 17119 | 8976 | 168 |
703667 | 703667 | 2020-11-06 | Madison | Illinois | 17119 | 8763 | 164 |
700424 | 700424 | 2020-11-05 | Madison | Illinois | 17119 | 8270 | 164 |
697180 | 697180 | 2020-11-04 | Madison | Illinois | 17119 | 8152 | 163 |
693938 | 693938 | 2020-11-03 | Madison | Illinois | 17119 | 8032 | 163 |
690695 | 690695 | 2020-11-02 | Madison | Illinois | 17119 | 7917 | 159 |
687450 | 687450 | 2020-11-01 | Madison | Illinois | 17119 | 7795 | 160 |
684206 | 684206 | 2020-10-31 | Madison | Illinois | 17119 | 7694 | 159 |
680963 | 680963 | 2020-10-30 | Madison | Illinois | 17119 | 7622 | 158 |
677720 | 677720 | 2020-10-29 | Madison | Illinois | 17119 | 7501 | 158 |
674477 | 674477 | 2020-10-28 | Madison | Illinois | 17119 | 7441 | 157 |
671235 | 671235 | 2020-10-27 | Madison | Illinois | 17119 | 7339 | 156 |
667992 | 667992 | 2020-10-26 | Madison | Illinois | 17119 | 7289 | 154 |
664748 | 664748 | 2020-10-25 | Madison | Illinois | 17119 | 7215 | 154 |
661503 | 661503 | 2020-10-24 | Madison | Illinois | 17119 | 7133 | 154 |
658259 | 658259 | 2020-10-23 | Madison | Illinois | 17119 | 7084 | 154 |
655014 | 655014 | 2020-10-22 | Madison | Illinois | 17119 | 7027 | 153 |
651769 | 651769 | 2020-10-21 | Madison | Illinois | 17119 | 6944 | 153 |
648525 | 648525 | 2020-10-20 | Madison | Illinois | 17119 | 6904 | 152 |
645280 | 645280 | 2020-10-19 | Madison | Illinois | 17119 | 6853 | 152 |
642033 | 642033 | 2020-10-18 | Madison | Illinois | 17119 | 6810 | 152 |
638786 | 638786 | 2020-10-17 | Madison | Illinois | 17119 | 6748 | 152 |
635540 | 635540 | 2020-10-16 | Madison | Illinois | 17119 | 6714 | 152 |
632294 | 632294 | 2020-10-15 | Madison | Illinois | 17119 | 6618 | 151 |
629050 | 629050 | 2020-10-14 | Madison | Illinois | 17119 | 6562 | 150 |
625807 | 625807 | 2020-10-13 | Madison | Illinois | 17119 | 6491 | 149 |
622565 | 622565 | 2020-10-12 | Madison | Illinois | 17119 | 6436 | 148 |
619321 | 619321 | 2020-10-11 | Madison | Illinois | 17119 | 6382 | 148 |
616079 | 616079 | 2020-10-10 | Madison | Illinois | 17119 | 6341 | 148 |
612838 | 612838 | 2020-10-09 | Madison | Illinois | 17119 | 6319 | 148 |
609596 | 609596 | 2020-10-08 | Madison | Illinois | 17119 | 6242 | 148 |
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);