ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17199 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930873 | 930873 | 2021-01-15 | Williamson | Illinois | 17199 | 6102 | 114 |
927628 | 927628 | 2021-01-14 | Williamson | Illinois | 17199 | 6056 | 113 |
924382 | 924382 | 2021-01-13 | Williamson | Illinois | 17199 | 6008 | 113 |
921137 | 921137 | 2021-01-12 | Williamson | Illinois | 17199 | 5963 | 112 |
917892 | 917892 | 2021-01-11 | Williamson | Illinois | 17199 | 5925 | 111 |
914647 | 914647 | 2021-01-10 | Williamson | Illinois | 17199 | 5887 | 111 |
911402 | 911402 | 2021-01-09 | Williamson | Illinois | 17199 | 5861 | 111 |
908157 | 908157 | 2021-01-08 | Williamson | Illinois | 17199 | 5784 | 111 |
904911 | 904911 | 2021-01-07 | Williamson | Illinois | 17199 | 5725 | 109 |
901666 | 901666 | 2021-01-06 | Williamson | Illinois | 17199 | 5659 | 108 |
898421 | 898421 | 2021-01-05 | Williamson | Illinois | 17199 | 5582 | 107 |
895176 | 895176 | 2021-01-04 | Williamson | Illinois | 17199 | 5519 | 107 |
891929 | 891929 | 2021-01-03 | Williamson | Illinois | 17199 | 5467 | 106 |
888683 | 888683 | 2021-01-02 | Williamson | Illinois | 17199 | 5407 | 106 |
885437 | 885437 | 2021-01-01 | Williamson | Illinois | 17199 | 5316 | 106 |
882192 | 882192 | 2020-12-31 | Williamson | Illinois | 17199 | 5316 | 106 |
878947 | 878947 | 2020-12-30 | Williamson | Illinois | 17199 | 5234 | 106 |
875702 | 875702 | 2020-12-29 | Williamson | Illinois | 17199 | 5132 | 106 |
872457 | 872457 | 2020-12-28 | Williamson | Illinois | 17199 | 5090 | 106 |
869212 | 869212 | 2020-12-27 | Williamson | Illinois | 17199 | 5038 | 106 |
865967 | 865967 | 2020-12-26 | Williamson | Illinois | 17199 | 5001 | 106 |
862722 | 862722 | 2020-12-25 | Williamson | Illinois | 17199 | 4986 | 106 |
859477 | 859477 | 2020-12-24 | Williamson | Illinois | 17199 | 4926 | 106 |
856232 | 856232 | 2020-12-23 | Williamson | Illinois | 17199 | 4888 | 107 |
852987 | 852987 | 2020-12-22 | Williamson | Illinois | 17199 | 4834 | 105 |
849742 | 849742 | 2020-12-21 | Williamson | Illinois | 17199 | 4789 | 105 |
846497 | 846497 | 2020-12-20 | Williamson | Illinois | 17199 | 4743 | 105 |
843251 | 843251 | 2020-12-19 | Williamson | Illinois | 17199 | 4722 | 105 |
840006 | 840006 | 2020-12-18 | Williamson | Illinois | 17199 | 4679 | 105 |
836761 | 836761 | 2020-12-17 | Williamson | Illinois | 17199 | 4627 | 104 |
833515 | 833515 | 2020-12-16 | Williamson | Illinois | 17199 | 4548 | 101 |
830268 | 830268 | 2020-12-15 | Williamson | Illinois | 17199 | 4483 | 100 |
827022 | 827022 | 2020-12-14 | Williamson | Illinois | 17199 | 4442 | 100 |
823775 | 823775 | 2020-12-13 | Williamson | Illinois | 17199 | 4404 | 100 |
820529 | 820529 | 2020-12-12 | Williamson | Illinois | 17199 | 4373 | 99 |
817283 | 817283 | 2020-12-11 | Williamson | Illinois | 17199 | 4311 | 97 |
814037 | 814037 | 2020-12-10 | Williamson | Illinois | 17199 | 4230 | 96 |
810792 | 810792 | 2020-12-09 | Williamson | Illinois | 17199 | 4169 | 94 |
807547 | 807547 | 2020-12-08 | Williamson | Illinois | 17199 | 4107 | 93 |
804302 | 804302 | 2020-12-07 | Williamson | Illinois | 17199 | 4060 | 91 |
801057 | 801057 | 2020-12-06 | Williamson | Illinois | 17199 | 4012 | 91 |
797812 | 797812 | 2020-12-05 | Williamson | Illinois | 17199 | 3979 | 90 |
794567 | 794567 | 2020-12-04 | Williamson | Illinois | 17199 | 3936 | 88 |
791322 | 791322 | 2020-12-03 | Williamson | Illinois | 17199 | 3859 | 88 |
788077 | 788077 | 2020-12-02 | Williamson | Illinois | 17199 | 3785 | 83 |
784833 | 784833 | 2020-12-01 | Williamson | Illinois | 17199 | 3717 | 83 |
781588 | 781588 | 2020-11-30 | Williamson | Illinois | 17199 | 3659 | 83 |
778342 | 778342 | 2020-11-29 | Williamson | Illinois | 17199 | 3610 | 83 |
775097 | 775097 | 2020-11-28 | Williamson | Illinois | 17199 | 3557 | 82 |
771852 | 771852 | 2020-11-27 | Williamson | Illinois | 17199 | 3510 | 80 |
768607 | 768607 | 2020-11-26 | Williamson | Illinois | 17199 | 3491 | 80 |
765361 | 765361 | 2020-11-25 | Williamson | Illinois | 17199 | 3407 | 79 |
762116 | 762116 | 2020-11-24 | Williamson | Illinois | 17199 | 3327 | 77 |
758871 | 758871 | 2020-11-23 | Williamson | Illinois | 17199 | 3284 | 77 |
755624 | 755624 | 2020-11-22 | Williamson | Illinois | 17199 | 3218 | 77 |
752378 | 752378 | 2020-11-21 | Williamson | Illinois | 17199 | 3176 | 76 |
749132 | 749132 | 2020-11-20 | Williamson | Illinois | 17199 | 3127 | 76 |
745886 | 745886 | 2020-11-19 | Williamson | Illinois | 17199 | 3063 | 76 |
742639 | 742639 | 2020-11-18 | Williamson | Illinois | 17199 | 2980 | 75 |
739392 | 739392 | 2020-11-17 | Williamson | Illinois | 17199 | 2919 | 74 |
736148 | 736148 | 2020-11-16 | Williamson | Illinois | 17199 | 2862 | 71 |
732902 | 732902 | 2020-11-15 | Williamson | Illinois | 17199 | 2829 | 71 |
729657 | 729657 | 2020-11-14 | Williamson | Illinois | 17199 | 2813 | 70 |
726414 | 726414 | 2020-11-13 | Williamson | Illinois | 17199 | 2748 | 69 |
723171 | 723171 | 2020-11-12 | Williamson | Illinois | 17199 | 2668 | 68 |
719928 | 719928 | 2020-11-11 | Williamson | Illinois | 17199 | 2594 | 68 |
716685 | 716685 | 2020-11-10 | Williamson | Illinois | 17199 | 2545 | 67 |
713441 | 713441 | 2020-11-09 | Williamson | Illinois | 17199 | 2452 | 66 |
710197 | 710197 | 2020-11-08 | Williamson | Illinois | 17199 | 2405 | 66 |
706953 | 706953 | 2020-11-07 | Williamson | Illinois | 17199 | 2353 | 66 |
703710 | 703710 | 2020-11-06 | Williamson | Illinois | 17199 | 2295 | 66 |
700468 | 700468 | 2020-11-05 | Williamson | Illinois | 17199 | 2226 | 65 |
697224 | 697224 | 2020-11-04 | Williamson | Illinois | 17199 | 2180 | 64 |
693982 | 693982 | 2020-11-03 | Williamson | Illinois | 17199 | 2153 | 63 |
690739 | 690739 | 2020-11-02 | Williamson | Illinois | 17199 | 2085 | 61 |
687494 | 687494 | 2020-11-01 | Williamson | Illinois | 17199 | 2062 | 61 |
684250 | 684250 | 2020-10-31 | Williamson | Illinois | 17199 | 2016 | 61 |
681007 | 681007 | 2020-10-30 | Williamson | Illinois | 17199 | 2016 | 61 |
677764 | 677764 | 2020-10-29 | Williamson | Illinois | 17199 | 1979 | 61 |
674521 | 674521 | 2020-10-28 | Williamson | Illinois | 17199 | 1938 | 61 |
671279 | 671279 | 2020-10-27 | Williamson | Illinois | 17199 | 1905 | 61 |
668036 | 668036 | 2020-10-26 | Williamson | Illinois | 17199 | 1888 | 59 |
664792 | 664792 | 2020-10-25 | Williamson | Illinois | 17199 | 1883 | 59 |
661547 | 661547 | 2020-10-24 | Williamson | Illinois | 17199 | 1857 | 59 |
658303 | 658303 | 2020-10-23 | Williamson | Illinois | 17199 | 1832 | 59 |
655058 | 655058 | 2020-10-22 | Williamson | Illinois | 17199 | 1800 | 59 |
651813 | 651813 | 2020-10-21 | Williamson | Illinois | 17199 | 1761 | 59 |
648569 | 648569 | 2020-10-20 | Williamson | Illinois | 17199 | 1737 | 58 |
645324 | 645324 | 2020-10-19 | Williamson | Illinois | 17199 | 1709 | 58 |
642077 | 642077 | 2020-10-18 | Williamson | Illinois | 17199 | 1696 | 57 |
638830 | 638830 | 2020-10-17 | Williamson | Illinois | 17199 | 1668 | 57 |
635584 | 635584 | 2020-10-16 | Williamson | Illinois | 17199 | 1655 | 57 |
632338 | 632338 | 2020-10-15 | Williamson | Illinois | 17199 | 1621 | 56 |
629094 | 629094 | 2020-10-14 | Williamson | Illinois | 17199 | 1601 | 56 |
625851 | 625851 | 2020-10-13 | Williamson | Illinois | 17199 | 1575 | 56 |
622609 | 622609 | 2020-10-12 | Williamson | Illinois | 17199 | 1564 | 56 |
619365 | 619365 | 2020-10-11 | Williamson | Illinois | 17199 | 1551 | 56 |
616123 | 616123 | 2020-10-10 | Williamson | Illinois | 17199 | 1532 | 56 |
612882 | 612882 | 2020-10-09 | Williamson | Illinois | 17199 | 1522 | 56 |
609640 | 609640 | 2020-10-08 | Williamson | Illinois | 17199 | 1521 | 55 |
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);