ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17167 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930856 | 930856 | 2021-01-15 | Sangamon | Illinois | 17167 | 14299 | 232 |
927611 | 927611 | 2021-01-14 | Sangamon | Illinois | 17167 | 14227 | 232 |
924365 | 924365 | 2021-01-13 | Sangamon | Illinois | 17167 | 14139 | 229 |
921120 | 921120 | 2021-01-12 | Sangamon | Illinois | 17167 | 14076 | 226 |
917875 | 917875 | 2021-01-11 | Sangamon | Illinois | 17167 | 14022 | 223 |
914630 | 914630 | 2021-01-10 | Sangamon | Illinois | 17167 | 13963 | 223 |
911385 | 911385 | 2021-01-09 | Sangamon | Illinois | 17167 | 13915 | 223 |
908140 | 908140 | 2021-01-08 | Sangamon | Illinois | 17167 | 13828 | 221 |
904894 | 904894 | 2021-01-07 | Sangamon | Illinois | 17167 | 13767 | 216 |
901649 | 901649 | 2021-01-06 | Sangamon | Illinois | 17167 | 13655 | 213 |
898404 | 898404 | 2021-01-05 | Sangamon | Illinois | 17167 | 13589 | 209 |
895159 | 895159 | 2021-01-04 | Sangamon | Illinois | 17167 | 13515 | 206 |
891912 | 891912 | 2021-01-03 | Sangamon | Illinois | 17167 | 13445 | 204 |
888665 | 888665 | 2021-01-02 | Sangamon | Illinois | 17167 | 13402 | 202 |
885420 | 885420 | 2021-01-01 | Sangamon | Illinois | 17167 | 13219 | 197 |
882175 | 882175 | 2020-12-31 | Sangamon | Illinois | 17167 | 13219 | 197 |
878930 | 878930 | 2020-12-30 | Sangamon | Illinois | 17167 | 13160 | 193 |
875685 | 875685 | 2020-12-29 | Sangamon | Illinois | 17167 | 13093 | 192 |
872440 | 872440 | 2020-12-28 | Sangamon | Illinois | 17167 | 13018 | 190 |
869195 | 869195 | 2020-12-27 | Sangamon | Illinois | 17167 | 12950 | 187 |
865950 | 865950 | 2020-12-26 | Sangamon | Illinois | 17167 | 12930 | 186 |
862705 | 862705 | 2020-12-25 | Sangamon | Illinois | 17167 | 12882 | 184 |
859460 | 859460 | 2020-12-24 | Sangamon | Illinois | 17167 | 12843 | 182 |
856215 | 856215 | 2020-12-23 | Sangamon | Illinois | 17167 | 12760 | 180 |
852970 | 852970 | 2020-12-22 | Sangamon | Illinois | 17167 | 12677 | 172 |
849725 | 849725 | 2020-12-21 | Sangamon | Illinois | 17167 | 12613 | 168 |
846480 | 846480 | 2020-12-20 | Sangamon | Illinois | 17167 | 12569 | 168 |
843234 | 843234 | 2020-12-19 | Sangamon | Illinois | 17167 | 12503 | 166 |
839989 | 839989 | 2020-12-18 | Sangamon | Illinois | 17167 | 12422 | 162 |
836744 | 836744 | 2020-12-17 | Sangamon | Illinois | 17167 | 12343 | 157 |
833498 | 833498 | 2020-12-16 | Sangamon | Illinois | 17167 | 12229 | 152 |
830251 | 830251 | 2020-12-15 | Sangamon | Illinois | 17167 | 12117 | 148 |
827005 | 827005 | 2020-12-14 | Sangamon | Illinois | 17167 | 12032 | 143 |
823758 | 823758 | 2020-12-13 | Sangamon | Illinois | 17167 | 11902 | 143 |
820512 | 820512 | 2020-12-12 | Sangamon | Illinois | 17167 | 11807 | 141 |
817266 | 817266 | 2020-12-11 | Sangamon | Illinois | 17167 | 11673 | 138 |
814020 | 814020 | 2020-12-10 | Sangamon | Illinois | 17167 | 11551 | 136 |
810775 | 810775 | 2020-12-09 | Sangamon | Illinois | 17167 | 11434 | 131 |
807530 | 807530 | 2020-12-08 | Sangamon | Illinois | 17167 | 11305 | 123 |
804285 | 804285 | 2020-12-07 | Sangamon | Illinois | 17167 | 11183 | 121 |
801040 | 801040 | 2020-12-06 | Sangamon | Illinois | 17167 | 11071 | 121 |
797795 | 797795 | 2020-12-05 | Sangamon | Illinois | 17167 | 10891 | 120 |
794550 | 794550 | 2020-12-04 | Sangamon | Illinois | 17167 | 10792 | 112 |
791305 | 791305 | 2020-12-03 | Sangamon | Illinois | 17167 | 10669 | 109 |
788060 | 788060 | 2020-12-02 | Sangamon | Illinois | 17167 | 10553 | 107 |
784816 | 784816 | 2020-12-01 | Sangamon | Illinois | 17167 | 10383 | 106 |
781571 | 781571 | 2020-11-30 | Sangamon | Illinois | 17167 | 10253 | 101 |
778325 | 778325 | 2020-11-29 | Sangamon | Illinois | 17167 | 10157 | 99 |
775080 | 775080 | 2020-11-28 | Sangamon | Illinois | 17167 | 10038 | 99 |
771835 | 771835 | 2020-11-27 | Sangamon | Illinois | 17167 | 9937 | 99 |
768590 | 768590 | 2020-11-26 | Sangamon | Illinois | 17167 | 9725 | 99 |
765344 | 765344 | 2020-11-25 | Sangamon | Illinois | 17167 | 9554 | 93 |
762099 | 762099 | 2020-11-24 | Sangamon | Illinois | 17167 | 9383 | 90 |
758854 | 758854 | 2020-11-23 | Sangamon | Illinois | 17167 | 9236 | 89 |
755607 | 755607 | 2020-11-22 | Sangamon | Illinois | 17167 | 9111 | 89 |
752361 | 752361 | 2020-11-21 | Sangamon | Illinois | 17167 | 8908 | 89 |
749115 | 749115 | 2020-11-20 | Sangamon | Illinois | 17167 | 8669 | 87 |
745869 | 745869 | 2020-11-19 | Sangamon | Illinois | 17167 | 8376 | 86 |
742622 | 742622 | 2020-11-18 | Sangamon | Illinois | 17167 | 8137 | 80 |
739375 | 739375 | 2020-11-17 | Sangamon | Illinois | 17167 | 8047 | 79 |
736131 | 736131 | 2020-11-16 | Sangamon | Illinois | 17167 | 7808 | 77 |
732885 | 732885 | 2020-11-15 | Sangamon | Illinois | 17167 | 7586 | 77 |
729640 | 729640 | 2020-11-14 | Sangamon | Illinois | 17167 | 7373 | 76 |
726397 | 726397 | 2020-11-13 | Sangamon | Illinois | 17167 | 7218 | 75 |
723154 | 723154 | 2020-11-12 | Sangamon | Illinois | 17167 | 6913 | 73 |
719911 | 719911 | 2020-11-11 | Sangamon | Illinois | 17167 | 6702 | 73 |
716668 | 716668 | 2020-11-10 | Sangamon | Illinois | 17167 | 6431 | 73 |
713424 | 713424 | 2020-11-09 | Sangamon | Illinois | 17167 | 6162 | 73 |
710180 | 710180 | 2020-11-08 | Sangamon | Illinois | 17167 | 5943 | 69 |
706936 | 706936 | 2020-11-07 | Sangamon | Illinois | 17167 | 5683 | 69 |
703693 | 703693 | 2020-11-06 | Sangamon | Illinois | 17167 | 5511 | 69 |
700450 | 700450 | 2020-11-05 | Sangamon | Illinois | 17167 | 5234 | 69 |
697206 | 697206 | 2020-11-04 | Sangamon | Illinois | 17167 | 5002 | 69 |
693964 | 693964 | 2020-11-03 | Sangamon | Illinois | 17167 | 4883 | 67 |
690721 | 690721 | 2020-11-02 | Sangamon | Illinois | 17167 | 4750 | 67 |
687476 | 687476 | 2020-11-01 | Sangamon | Illinois | 17167 | 4638 | 66 |
684232 | 684232 | 2020-10-31 | Sangamon | Illinois | 17167 | 4450 | 66 |
680989 | 680989 | 2020-10-30 | Sangamon | Illinois | 17167 | 4450 | 66 |
677746 | 677746 | 2020-10-29 | Sangamon | Illinois | 17167 | 4322 | 65 |
674503 | 674503 | 2020-10-28 | Sangamon | Illinois | 17167 | 4248 | 65 |
671261 | 671261 | 2020-10-27 | Sangamon | Illinois | 17167 | 4151 | 64 |
668018 | 668018 | 2020-10-26 | Sangamon | Illinois | 17167 | 4067 | 64 |
664774 | 664774 | 2020-10-25 | Sangamon | Illinois | 17167 | 3988 | 64 |
661529 | 661529 | 2020-10-24 | Sangamon | Illinois | 17167 | 3896 | 64 |
658285 | 658285 | 2020-10-23 | Sangamon | Illinois | 17167 | 3749 | 64 |
655040 | 655040 | 2020-10-22 | Sangamon | Illinois | 17167 | 3722 | 64 |
651795 | 651795 | 2020-10-21 | Sangamon | Illinois | 17167 | 3626 | 62 |
648551 | 648551 | 2020-10-20 | Sangamon | Illinois | 17167 | 3556 | 62 |
645306 | 645306 | 2020-10-19 | Sangamon | Illinois | 17167 | 3475 | 62 |
642059 | 642059 | 2020-10-18 | Sangamon | Illinois | 17167 | 3444 | 57 |
638812 | 638812 | 2020-10-17 | Sangamon | Illinois | 17167 | 3350 | 57 |
635566 | 635566 | 2020-10-16 | Sangamon | Illinois | 17167 | 3293 | 57 |
632320 | 632320 | 2020-10-15 | Sangamon | Illinois | 17167 | 3204 | 55 |
629076 | 629076 | 2020-10-14 | Sangamon | Illinois | 17167 | 3154 | 53 |
625833 | 625833 | 2020-10-13 | Sangamon | Illinois | 17167 | 3052 | 51 |
622591 | 622591 | 2020-10-12 | Sangamon | Illinois | 17167 | 3003 | 50 |
619347 | 619347 | 2020-10-11 | Sangamon | Illinois | 17167 | 2977 | 50 |
616105 | 616105 | 2020-10-10 | Sangamon | Illinois | 17167 | 2923 | 50 |
612864 | 612864 | 2020-10-09 | Sangamon | Illinois | 17167 | 2843 | 50 |
609622 | 609622 | 2020-10-08 | Sangamon | Illinois | 17167 | 2803 | 50 |
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);