ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kankakee" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930819 | 930819 | 2021-01-15 | Kankakee | Illinois | 17091 | 11393 | 177 |
927574 | 927574 | 2021-01-14 | Kankakee | Illinois | 17091 | 11393 | 175 |
924328 | 924328 | 2021-01-13 | Kankakee | Illinois | 17091 | 11277 | 174 |
921083 | 921083 | 2021-01-12 | Kankakee | Illinois | 17091 | 11277 | 173 |
917838 | 917838 | 2021-01-11 | Kankakee | Illinois | 17091 | 11277 | 171 |
914593 | 914593 | 2021-01-10 | Kankakee | Illinois | 17091 | 11146 | 171 |
911348 | 911348 | 2021-01-09 | Kankakee | Illinois | 17091 | 11109 | 171 |
908103 | 908103 | 2021-01-08 | Kankakee | Illinois | 17091 | 11109 | 169 |
904857 | 904857 | 2021-01-07 | Kankakee | Illinois | 17091 | 11109 | 168 |
901612 | 901612 | 2021-01-06 | Kankakee | Illinois | 17091 | 10938 | 167 |
898367 | 898367 | 2021-01-05 | Kankakee | Illinois | 17091 | 10866 | 164 |
895122 | 895122 | 2021-01-04 | Kankakee | Illinois | 17091 | 10797 | 164 |
891875 | 891875 | 2021-01-03 | Kankakee | Illinois | 17091 | 10776 | 163 |
888628 | 888628 | 2021-01-02 | Kankakee | Illinois | 17091 | 10758 | 161 |
885383 | 885383 | 2021-01-01 | Kankakee | Illinois | 17091 | 10717 | 159 |
882138 | 882138 | 2020-12-31 | Kankakee | Illinois | 17091 | 10717 | 159 |
878893 | 878893 | 2020-12-30 | Kankakee | Illinois | 17091 | 10717 | 156 |
875648 | 875648 | 2020-12-29 | Kankakee | Illinois | 17091 | 10610 | 153 |
872403 | 872403 | 2020-12-28 | Kankakee | Illinois | 17091 | 10610 | 152 |
869158 | 869158 | 2020-12-27 | Kankakee | Illinois | 17091 | 10488 | 152 |
865913 | 865913 | 2020-12-26 | Kankakee | Illinois | 17091 | 10471 | 152 |
862668 | 862668 | 2020-12-25 | Kankakee | Illinois | 17091 | 10451 | 151 |
859423 | 859423 | 2020-12-24 | Kankakee | Illinois | 17091 | 10451 | 151 |
856178 | 856178 | 2020-12-23 | Kankakee | Illinois | 17091 | 10451 | 149 |
852933 | 852933 | 2020-12-22 | Kankakee | Illinois | 17091 | 10366 | 149 |
849688 | 849688 | 2020-12-21 | Kankakee | Illinois | 17091 | 10311 | 149 |
846443 | 846443 | 2020-12-20 | Kankakee | Illinois | 17091 | 10215 | 149 |
843197 | 843197 | 2020-12-19 | Kankakee | Illinois | 17091 | 10186 | 149 |
839952 | 839952 | 2020-12-18 | Kankakee | Illinois | 17091 | 10144 | 145 |
836707 | 836707 | 2020-12-17 | Kankakee | Illinois | 17091 | 10144 | 142 |
833461 | 833461 | 2020-12-16 | Kankakee | Illinois | 17091 | 10088 | 140 |
830214 | 830214 | 2020-12-15 | Kankakee | Illinois | 17091 | 10025 | 137 |
826968 | 826968 | 2020-12-14 | Kankakee | Illinois | 17091 | 9959 | 135 |
823721 | 823721 | 2020-12-13 | Kankakee | Illinois | 17091 | 9845 | 133 |
820475 | 820475 | 2020-12-12 | Kankakee | Illinois | 17091 | 9788 | 133 |
817229 | 817229 | 2020-12-11 | Kankakee | Illinois | 17091 | 9788 | 132 |
813983 | 813983 | 2020-12-10 | Kankakee | Illinois | 17091 | 9650 | 131 |
810738 | 810738 | 2020-12-09 | Kankakee | Illinois | 17091 | 9564 | 127 |
807493 | 807493 | 2020-12-08 | Kankakee | Illinois | 17091 | 9475 | 125 |
804248 | 804248 | 2020-12-07 | Kankakee | Illinois | 17091 | 9406 | 124 |
801003 | 801003 | 2020-12-06 | Kankakee | Illinois | 17091 | 9364 | 124 |
797758 | 797758 | 2020-12-05 | Kankakee | Illinois | 17091 | 9299 | 124 |
794513 | 794513 | 2020-12-04 | Kankakee | Illinois | 17091 | 9226 | 124 |
791268 | 791268 | 2020-12-03 | Kankakee | Illinois | 17091 | 9184 | 124 |
788023 | 788023 | 2020-12-02 | Kankakee | Illinois | 17091 | 9073 | 123 |
784779 | 784779 | 2020-12-01 | Kankakee | Illinois | 17091 | 8912 | 120 |
781534 | 781534 | 2020-11-30 | Kankakee | Illinois | 17091 | 8689 | 106 |
778288 | 778288 | 2020-11-29 | Kankakee | Illinois | 17091 | 8636 | 106 |
775043 | 775043 | 2020-11-28 | Kankakee | Illinois | 17091 | 8548 | 106 |
771798 | 771798 | 2020-11-27 | Kankakee | Illinois | 17091 | 8438 | 106 |
768553 | 768553 | 2020-11-26 | Kankakee | Illinois | 17091 | 8341 | 106 |
765307 | 765307 | 2020-11-25 | Kankakee | Illinois | 17091 | 8279 | 106 |
762062 | 762062 | 2020-11-24 | Kankakee | Illinois | 17091 | 8111 | 103 |
758817 | 758817 | 2020-11-23 | Kankakee | Illinois | 17091 | 7863 | 96 |
755570 | 755570 | 2020-11-22 | Kankakee | Illinois | 17091 | 7753 | 96 |
752324 | 752324 | 2020-11-21 | Kankakee | Illinois | 17091 | 7536 | 95 |
749078 | 749078 | 2020-11-20 | Kankakee | Illinois | 17091 | 7450 | 95 |
745832 | 745832 | 2020-11-19 | Kankakee | Illinois | 17091 | 7281 | 94 |
742585 | 742585 | 2020-11-18 | Kankakee | Illinois | 17091 | 7056 | 91 |
739338 | 739338 | 2020-11-17 | Kankakee | Illinois | 17091 | 6902 | 91 |
736094 | 736094 | 2020-11-16 | Kankakee | Illinois | 17091 | 6722 | 88 |
732848 | 732848 | 2020-11-15 | Kankakee | Illinois | 17091 | 6455 | 88 |
729603 | 729603 | 2020-11-14 | Kankakee | Illinois | 17091 | 6245 | 88 |
726360 | 726360 | 2020-11-13 | Kankakee | Illinois | 17091 | 5968 | 87 |
723117 | 723117 | 2020-11-12 | Kankakee | Illinois | 17091 | 5722 | 87 |
719874 | 719874 | 2020-11-11 | Kankakee | Illinois | 17091 | 5494 | 87 |
716631 | 716631 | 2020-11-10 | Kankakee | Illinois | 17091 | 5367 | 86 |
713387 | 713387 | 2020-11-09 | Kankakee | Illinois | 17091 | 5164 | 86 |
710143 | 710143 | 2020-11-08 | Kankakee | Illinois | 17091 | 4949 | 86 |
706899 | 706899 | 2020-11-07 | Kankakee | Illinois | 17091 | 4784 | 86 |
703656 | 703656 | 2020-11-06 | Kankakee | Illinois | 17091 | 4663 | 84 |
700413 | 700413 | 2020-11-05 | Kankakee | Illinois | 17091 | 4425 | 84 |
697169 | 697169 | 2020-11-04 | Kankakee | Illinois | 17091 | 4116 | 83 |
693927 | 693927 | 2020-11-03 | Kankakee | Illinois | 17091 | 3997 | 81 |
690684 | 690684 | 2020-11-02 | Kankakee | Illinois | 17091 | 3930 | 81 |
687439 | 687439 | 2020-11-01 | Kankakee | Illinois | 17091 | 3867 | 81 |
684195 | 684195 | 2020-10-31 | Kankakee | Illinois | 17091 | 3682 | 81 |
680952 | 680952 | 2020-10-30 | Kankakee | Illinois | 17091 | 3682 | 81 |
677709 | 677709 | 2020-10-29 | Kankakee | Illinois | 17091 | 3666 | 81 |
674466 | 674466 | 2020-10-28 | Kankakee | Illinois | 17091 | 3505 | 81 |
671224 | 671224 | 2020-10-27 | Kankakee | Illinois | 17091 | 3481 | 80 |
667981 | 667981 | 2020-10-26 | Kankakee | Illinois | 17091 | 3481 | 80 |
664737 | 664737 | 2020-10-25 | Kankakee | Illinois | 17091 | 3388 | 80 |
661492 | 661492 | 2020-10-24 | Kankakee | Illinois | 17091 | 3367 | 80 |
658248 | 658248 | 2020-10-23 | Kankakee | Illinois | 17091 | 3367 | 79 |
655003 | 655003 | 2020-10-22 | Kankakee | Illinois | 17091 | 3326 | 78 |
651758 | 651758 | 2020-10-21 | Kankakee | Illinois | 17091 | 3265 | 78 |
648514 | 648514 | 2020-10-20 | Kankakee | Illinois | 17091 | 3235 | 78 |
645269 | 645269 | 2020-10-19 | Kankakee | Illinois | 17091 | 3208 | 78 |
642022 | 642022 | 2020-10-18 | Kankakee | Illinois | 17091 | 3143 | 78 |
638775 | 638775 | 2020-10-17 | Kankakee | Illinois | 17091 | 3115 | 78 |
635529 | 635529 | 2020-10-16 | Kankakee | Illinois | 17091 | 3115 | 78 |
632283 | 632283 | 2020-10-15 | Kankakee | Illinois | 17091 | 3076 | 78 |
629039 | 629039 | 2020-10-14 | Kankakee | Illinois | 17091 | 3036 | 78 |
625796 | 625796 | 2020-10-13 | Kankakee | Illinois | 17091 | 3015 | 78 |
622554 | 622554 | 2020-10-12 | Kankakee | Illinois | 17091 | 2980 | 78 |
619310 | 619310 | 2020-10-11 | Kankakee | Illinois | 17091 | 2969 | 78 |
616068 | 616068 | 2020-10-10 | Kankakee | Illinois | 17091 | 2960 | 78 |
612827 | 612827 | 2020-10-09 | Kankakee | Illinois | 17091 | 2934 | 79 |
609585 | 609585 | 2020-10-08 | Kankakee | Illinois | 17091 | 2934 | 79 |
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);