ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 17111 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930836 | 930836 | 2021-01-15 | McHenry | Illinois | 17111 | 21268 | 244 |
927591 | 927591 | 2021-01-14 | McHenry | Illinois | 17111 | 21132 | 238 |
924345 | 924345 | 2021-01-13 | McHenry | Illinois | 17111 | 20995 | 235 |
921100 | 921100 | 2021-01-12 | McHenry | Illinois | 17111 | 20894 | 234 |
917855 | 917855 | 2021-01-11 | McHenry | Illinois | 17111 | 20747 | 233 |
914610 | 914610 | 2021-01-10 | McHenry | Illinois | 17111 | 20603 | 233 |
911365 | 911365 | 2021-01-09 | McHenry | Illinois | 17111 | 20467 | 232 |
908120 | 908120 | 2021-01-08 | McHenry | Illinois | 17111 | 20308 | 232 |
904874 | 904874 | 2021-01-07 | McHenry | Illinois | 17111 | 20118 | 230 |
901629 | 901629 | 2021-01-06 | McHenry | Illinois | 17111 | 19885 | 224 |
898384 | 898384 | 2021-01-05 | McHenry | Illinois | 17111 | 19766 | 223 |
895139 | 895139 | 2021-01-04 | McHenry | Illinois | 17111 | 19653 | 222 |
891892 | 891892 | 2021-01-03 | McHenry | Illinois | 17111 | 19533 | 222 |
888645 | 888645 | 2021-01-02 | McHenry | Illinois | 17111 | 19422 | 222 |
885400 | 885400 | 2021-01-01 | McHenry | Illinois | 17111 | 19128 | 217 |
882155 | 882155 | 2020-12-31 | McHenry | Illinois | 17111 | 19128 | 217 |
878910 | 878910 | 2020-12-30 | McHenry | Illinois | 17111 | 18949 | 217 |
875665 | 875665 | 2020-12-29 | McHenry | Illinois | 17111 | 18794 | 214 |
872420 | 872420 | 2020-12-28 | McHenry | Illinois | 17111 | 18692 | 211 |
869175 | 869175 | 2020-12-27 | McHenry | Illinois | 17111 | 18589 | 208 |
865930 | 865930 | 2020-12-26 | McHenry | Illinois | 17111 | 18474 | 207 |
862685 | 862685 | 2020-12-25 | McHenry | Illinois | 17111 | 18402 | 207 |
859440 | 859440 | 2020-12-24 | McHenry | Illinois | 17111 | 18260 | 204 |
856195 | 856195 | 2020-12-23 | McHenry | Illinois | 17111 | 18081 | 202 |
852950 | 852950 | 2020-12-22 | McHenry | Illinois | 17111 | 17939 | 197 |
849705 | 849705 | 2020-12-21 | McHenry | Illinois | 17111 | 17802 | 193 |
846460 | 846460 | 2020-12-20 | McHenry | Illinois | 17111 | 17713 | 194 |
843214 | 843214 | 2020-12-19 | McHenry | Illinois | 17111 | 17568 | 193 |
839969 | 839969 | 2020-12-18 | McHenry | Illinois | 17111 | 17380 | 192 |
836724 | 836724 | 2020-12-17 | McHenry | Illinois | 17111 | 17186 | 190 |
833478 | 833478 | 2020-12-16 | McHenry | Illinois | 17111 | 17023 | 187 |
830231 | 830231 | 2020-12-15 | McHenry | Illinois | 17111 | 16908 | 185 |
826985 | 826985 | 2020-12-14 | McHenry | Illinois | 17111 | 16773 | 184 |
823738 | 823738 | 2020-12-13 | McHenry | Illinois | 17111 | 16561 | 183 |
820492 | 820492 | 2020-12-12 | McHenry | Illinois | 17111 | 16388 | 182 |
817246 | 817246 | 2020-12-11 | McHenry | Illinois | 17111 | 16227 | 182 |
814000 | 814000 | 2020-12-10 | McHenry | Illinois | 17111 | 16086 | 179 |
810755 | 810755 | 2020-12-09 | McHenry | Illinois | 17111 | 15901 | 179 |
807510 | 807510 | 2020-12-08 | McHenry | Illinois | 17111 | 15776 | 177 |
804265 | 804265 | 2020-12-07 | McHenry | Illinois | 17111 | 15618 | 175 |
801020 | 801020 | 2020-12-06 | McHenry | Illinois | 17111 | 15488 | 174 |
797775 | 797775 | 2020-12-05 | McHenry | Illinois | 17111 | 15349 | 174 |
794530 | 794530 | 2020-12-04 | McHenry | Illinois | 17111 | 15160 | 170 |
791285 | 791285 | 2020-12-03 | McHenry | Illinois | 17111 | 14996 | 167 |
788040 | 788040 | 2020-12-02 | McHenry | Illinois | 17111 | 14817 | 167 |
784796 | 784796 | 2020-12-01 | McHenry | Illinois | 17111 | 14655 | 161 |
781551 | 781551 | 2020-11-30 | McHenry | Illinois | 17111 | 14350 | 156 |
778305 | 778305 | 2020-11-29 | McHenry | Illinois | 17111 | 14269 | 156 |
775060 | 775060 | 2020-11-28 | McHenry | Illinois | 17111 | 14182 | 156 |
771815 | 771815 | 2020-11-27 | McHenry | Illinois | 17111 | 13979 | 156 |
768570 | 768570 | 2020-11-26 | McHenry | Illinois | 17111 | 13788 | 155 |
765324 | 765324 | 2020-11-25 | McHenry | Illinois | 17111 | 13529 | 153 |
762079 | 762079 | 2020-11-24 | McHenry | Illinois | 17111 | 13332 | 150 |
758834 | 758834 | 2020-11-23 | McHenry | Illinois | 17111 | 13125 | 148 |
755587 | 755587 | 2020-11-22 | McHenry | Illinois | 17111 | 13008 | 147 |
752341 | 752341 | 2020-11-21 | McHenry | Illinois | 17111 | 12789 | 146 |
749095 | 749095 | 2020-11-20 | McHenry | Illinois | 17111 | 12483 | 145 |
745849 | 745849 | 2020-11-19 | McHenry | Illinois | 17111 | 12194 | 143 |
742602 | 742602 | 2020-11-18 | McHenry | Illinois | 17111 | 11937 | 139 |
739355 | 739355 | 2020-11-17 | McHenry | Illinois | 17111 | 11746 | 132 |
736111 | 736111 | 2020-11-16 | McHenry | Illinois | 17111 | 11494 | 130 |
732865 | 732865 | 2020-11-15 | McHenry | Illinois | 17111 | 11237 | 130 |
729620 | 729620 | 2020-11-14 | McHenry | Illinois | 17111 | 11069 | 129 |
726377 | 726377 | 2020-11-13 | McHenry | Illinois | 17111 | 10834 | 129 |
723134 | 723134 | 2020-11-12 | McHenry | Illinois | 17111 | 10506 | 129 |
719891 | 719891 | 2020-11-11 | McHenry | Illinois | 17111 | 10111 | 129 |
716648 | 716648 | 2020-11-10 | McHenry | Illinois | 17111 | 9858 | 126 |
713404 | 713404 | 2020-11-09 | McHenry | Illinois | 17111 | 9551 | 127 |
710160 | 710160 | 2020-11-08 | McHenry | Illinois | 17111 | 9204 | 126 |
706916 | 706916 | 2020-11-07 | McHenry | Illinois | 17111 | 8895 | 126 |
703673 | 703673 | 2020-11-06 | McHenry | Illinois | 17111 | 8532 | 125 |
700430 | 700430 | 2020-11-05 | McHenry | Illinois | 17111 | 8304 | 125 |
697186 | 697186 | 2020-11-04 | McHenry | Illinois | 17111 | 8022 | 125 |
693944 | 693944 | 2020-11-03 | McHenry | Illinois | 17111 | 7841 | 125 |
690701 | 690701 | 2020-11-02 | McHenry | Illinois | 17111 | 7643 | 125 |
687456 | 687456 | 2020-11-01 | McHenry | Illinois | 17111 | 7463 | 126 |
684212 | 684212 | 2020-10-31 | McHenry | Illinois | 17111 | 7151 | 126 |
680969 | 680969 | 2020-10-30 | McHenry | Illinois | 17111 | 7151 | 126 |
677726 | 677726 | 2020-10-29 | McHenry | Illinois | 17111 | 6999 | 126 |
674483 | 674483 | 2020-10-28 | McHenry | Illinois | 17111 | 6831 | 126 |
671241 | 671241 | 2020-10-27 | McHenry | Illinois | 17111 | 6698 | 126 |
667998 | 667998 | 2020-10-26 | McHenry | Illinois | 17111 | 6606 | 126 |
664754 | 664754 | 2020-10-25 | McHenry | Illinois | 17111 | 6446 | 126 |
661509 | 661509 | 2020-10-24 | McHenry | Illinois | 17111 | 6361 | 125 |
658265 | 658265 | 2020-10-23 | McHenry | Illinois | 17111 | 6178 | 125 |
655020 | 655020 | 2020-10-22 | McHenry | Illinois | 17111 | 6072 | 125 |
651775 | 651775 | 2020-10-21 | McHenry | Illinois | 17111 | 5933 | 125 |
648531 | 648531 | 2020-10-20 | McHenry | Illinois | 17111 | 5851 | 125 |
645286 | 645286 | 2020-10-19 | McHenry | Illinois | 17111 | 5762 | 125 |
642039 | 642039 | 2020-10-18 | McHenry | Illinois | 17111 | 5693 | 125 |
638792 | 638792 | 2020-10-17 | McHenry | Illinois | 17111 | 5595 | 125 |
635546 | 635546 | 2020-10-16 | McHenry | Illinois | 17111 | 5506 | 125 |
632300 | 632300 | 2020-10-15 | McHenry | Illinois | 17111 | 5409 | 125 |
629056 | 629056 | 2020-10-14 | McHenry | Illinois | 17111 | 5347 | 124 |
625813 | 625813 | 2020-10-13 | McHenry | Illinois | 17111 | 5297 | 124 |
622571 | 622571 | 2020-10-12 | McHenry | Illinois | 17111 | 5226 | 124 |
619327 | 619327 | 2020-10-11 | McHenry | Illinois | 17111 | 5178 | 124 |
616085 | 616085 | 2020-10-10 | McHenry | Illinois | 17111 | 5140 | 124 |
612844 | 612844 | 2020-10-09 | McHenry | Illinois | 17111 | 5085 | 124 |
609602 | 609602 | 2020-10-08 | McHenry | Illinois | 17111 | 5029 | 124 |
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);