ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 17037 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930793 | 930793 | 2021-01-15 | DeKalb | Illinois | 17037 | 7469 | 90 |
927548 | 927548 | 2021-01-14 | DeKalb | Illinois | 17037 | 7425 | 89 |
924302 | 924302 | 2021-01-13 | DeKalb | Illinois | 17037 | 7361 | 89 |
921057 | 921057 | 2021-01-12 | DeKalb | Illinois | 17037 | 7328 | 89 |
917812 | 917812 | 2021-01-11 | DeKalb | Illinois | 17037 | 7270 | 87 |
914567 | 914567 | 2021-01-10 | DeKalb | Illinois | 17037 | 7151 | 87 |
911322 | 911322 | 2021-01-09 | DeKalb | Illinois | 17037 | 7151 | 87 |
908077 | 908077 | 2021-01-08 | DeKalb | Illinois | 17037 | 7151 | 85 |
904831 | 904831 | 2021-01-07 | DeKalb | Illinois | 17037 | 7107 | 84 |
901586 | 901586 | 2021-01-06 | DeKalb | Illinois | 17037 | 7031 | 84 |
898341 | 898341 | 2021-01-05 | DeKalb | Illinois | 17037 | 6983 | 83 |
895096 | 895096 | 2021-01-04 | DeKalb | Illinois | 17037 | 6941 | 83 |
891849 | 891849 | 2021-01-03 | DeKalb | Illinois | 17037 | 6776 | 82 |
888602 | 888602 | 2021-01-02 | DeKalb | Illinois | 17037 | 6768 | 82 |
885357 | 885357 | 2021-01-01 | DeKalb | Illinois | 17037 | 6768 | 81 |
882112 | 882112 | 2020-12-31 | DeKalb | Illinois | 17037 | 6768 | 81 |
878867 | 878867 | 2020-12-30 | DeKalb | Illinois | 17037 | 6709 | 77 |
875622 | 875622 | 2020-12-29 | DeKalb | Illinois | 17037 | 6640 | 76 |
872377 | 872377 | 2020-12-28 | DeKalb | Illinois | 17037 | 6606 | 75 |
869132 | 869132 | 2020-12-27 | DeKalb | Illinois | 17037 | 6473 | 75 |
865887 | 865887 | 2020-12-26 | DeKalb | Illinois | 17037 | 6473 | 75 |
862642 | 862642 | 2020-12-25 | DeKalb | Illinois | 17037 | 6473 | 75 |
859397 | 859397 | 2020-12-24 | DeKalb | Illinois | 17037 | 6473 | 74 |
856152 | 856152 | 2020-12-23 | DeKalb | Illinois | 17037 | 6423 | 72 |
852907 | 852907 | 2020-12-22 | DeKalb | Illinois | 17037 | 6382 | 68 |
849662 | 849662 | 2020-12-21 | DeKalb | Illinois | 17037 | 6354 | 68 |
846417 | 846417 | 2020-12-20 | DeKalb | Illinois | 17037 | 6253 | 68 |
843171 | 843171 | 2020-12-19 | DeKalb | Illinois | 17037 | 6253 | 69 |
839926 | 839926 | 2020-12-18 | DeKalb | Illinois | 17037 | 6253 | 66 |
836681 | 836681 | 2020-12-17 | DeKalb | Illinois | 17037 | 6204 | 64 |
833435 | 833435 | 2020-12-16 | DeKalb | Illinois | 17037 | 6120 | 64 |
830188 | 830188 | 2020-12-15 | DeKalb | Illinois | 17037 | 6084 | 60 |
826942 | 826942 | 2020-12-14 | DeKalb | Illinois | 17037 | 6021 | 60 |
823695 | 823695 | 2020-12-13 | DeKalb | Illinois | 17037 | 5892 | 60 |
820449 | 820449 | 2020-12-12 | DeKalb | Illinois | 17037 | 5892 | 60 |
817203 | 817203 | 2020-12-11 | DeKalb | Illinois | 17037 | 5892 | 58 |
813957 | 813957 | 2020-12-10 | DeKalb | Illinois | 17037 | 5831 | 56 |
810712 | 810712 | 2020-12-09 | DeKalb | Illinois | 17037 | 5741 | 54 |
807467 | 807467 | 2020-12-08 | DeKalb | Illinois | 17037 | 5708 | 52 |
804222 | 804222 | 2020-12-07 | DeKalb | Illinois | 17037 | 5644 | 51 |
800977 | 800977 | 2020-12-06 | DeKalb | Illinois | 17037 | 5488 | 51 |
797732 | 797732 | 2020-12-05 | DeKalb | Illinois | 17037 | 5458 | 51 |
794487 | 794487 | 2020-12-04 | DeKalb | Illinois | 17037 | 5458 | 49 |
791242 | 791242 | 2020-12-03 | DeKalb | Illinois | 17037 | 5368 | 49 |
787997 | 787997 | 2020-12-02 | DeKalb | Illinois | 17037 | 5292 | 48 |
784753 | 784753 | 2020-12-01 | DeKalb | Illinois | 17037 | 5237 | 48 |
781508 | 781508 | 2020-11-30 | DeKalb | Illinois | 17037 | 5101 | 48 |
778262 | 778262 | 2020-11-29 | DeKalb | Illinois | 17037 | 4990 | 47 |
775017 | 775017 | 2020-11-28 | DeKalb | Illinois | 17037 | 4947 | 47 |
771772 | 771772 | 2020-11-27 | DeKalb | Illinois | 17037 | 4881 | 47 |
768527 | 768527 | 2020-11-26 | DeKalb | Illinois | 17037 | 4848 | 46 |
765281 | 765281 | 2020-11-25 | DeKalb | Illinois | 17037 | 4848 | 46 |
762036 | 762036 | 2020-11-24 | DeKalb | Illinois | 17037 | 4788 | 45 |
758791 | 758791 | 2020-11-23 | DeKalb | Illinois | 17037 | 4708 | 45 |
755544 | 755544 | 2020-11-22 | DeKalb | Illinois | 17037 | 4567 | 45 |
752298 | 752298 | 2020-11-21 | DeKalb | Illinois | 17037 | 4518 | 45 |
749052 | 749052 | 2020-11-20 | DeKalb | Illinois | 17037 | 4518 | 45 |
745806 | 745806 | 2020-11-19 | DeKalb | Illinois | 17037 | 4393 | 44 |
742559 | 742559 | 2020-11-18 | DeKalb | Illinois | 17037 | 4279 | 44 |
739312 | 739312 | 2020-11-17 | DeKalb | Illinois | 17037 | 4207 | 44 |
736068 | 736068 | 2020-11-16 | DeKalb | Illinois | 17037 | 4122 | 44 |
732822 | 732822 | 2020-11-15 | DeKalb | Illinois | 17037 | 4002 | 44 |
729577 | 729577 | 2020-11-14 | DeKalb | Illinois | 17037 | 3927 | 44 |
726334 | 726334 | 2020-11-13 | DeKalb | Illinois | 17037 | 3915 | 44 |
723091 | 723091 | 2020-11-12 | DeKalb | Illinois | 17037 | 3806 | 44 |
719848 | 719848 | 2020-11-11 | DeKalb | Illinois | 17037 | 3618 | 43 |
716605 | 716605 | 2020-11-10 | DeKalb | Illinois | 17037 | 3600 | 43 |
713361 | 713361 | 2020-11-09 | DeKalb | Illinois | 17037 | 3507 | 43 |
710117 | 710117 | 2020-11-08 | DeKalb | Illinois | 17037 | 3348 | 43 |
706873 | 706873 | 2020-11-07 | DeKalb | Illinois | 17037 | 3251 | 43 |
703630 | 703630 | 2020-11-06 | DeKalb | Illinois | 17037 | 3228 | 43 |
700387 | 700387 | 2020-11-05 | DeKalb | Illinois | 17037 | 3113 | 43 |
697143 | 697143 | 2020-11-04 | DeKalb | Illinois | 17037 | 3046 | 43 |
693901 | 693901 | 2020-11-03 | DeKalb | Illinois | 17037 | 2978 | 43 |
690658 | 690658 | 2020-11-02 | DeKalb | Illinois | 17037 | 2930 | 43 |
687413 | 687413 | 2020-11-01 | DeKalb | Illinois | 17037 | 2779 | 43 |
684169 | 684169 | 2020-10-31 | DeKalb | Illinois | 17037 | 2728 | 43 |
680926 | 680926 | 2020-10-30 | DeKalb | Illinois | 17037 | 2728 | 43 |
677683 | 677683 | 2020-10-29 | DeKalb | Illinois | 17037 | 2608 | 43 |
674440 | 674440 | 2020-10-28 | DeKalb | Illinois | 17037 | 2549 | 42 |
671198 | 671198 | 2020-10-27 | DeKalb | Illinois | 17037 | 2509 | 42 |
667955 | 667955 | 2020-10-26 | DeKalb | Illinois | 17037 | 2476 | 42 |
664711 | 664711 | 2020-10-25 | DeKalb | Illinois | 17037 | 2358 | 42 |
661466 | 661466 | 2020-10-24 | DeKalb | Illinois | 17037 | 2327 | 42 |
658222 | 658222 | 2020-10-23 | DeKalb | Illinois | 17037 | 2327 | 42 |
654977 | 654977 | 2020-10-22 | DeKalb | Illinois | 17037 | 2292 | 42 |
651732 | 651732 | 2020-10-21 | DeKalb | Illinois | 17037 | 2236 | 42 |
648488 | 648488 | 2020-10-20 | DeKalb | Illinois | 17037 | 2209 | 42 |
645243 | 645243 | 2020-10-19 | DeKalb | Illinois | 17037 | 2162 | 42 |
641996 | 641996 | 2020-10-18 | DeKalb | Illinois | 17037 | 2072 | 42 |
638749 | 638749 | 2020-10-17 | DeKalb | Illinois | 17037 | 2070 | 42 |
635503 | 635503 | 2020-10-16 | DeKalb | Illinois | 17037 | 2070 | 42 |
632257 | 632257 | 2020-10-15 | DeKalb | Illinois | 17037 | 2047 | 42 |
629013 | 629013 | 2020-10-14 | DeKalb | Illinois | 17037 | 2010 | 42 |
625770 | 625770 | 2020-10-13 | DeKalb | Illinois | 17037 | 1976 | 41 |
622528 | 622528 | 2020-10-12 | DeKalb | Illinois | 17037 | 1903 | 41 |
619284 | 619284 | 2020-10-11 | DeKalb | Illinois | 17037 | 1903 | 41 |
616042 | 616042 | 2020-10-10 | DeKalb | Illinois | 17037 | 1903 | 41 |
612801 | 612801 | 2020-10-09 | DeKalb | Illinois | 17037 | 1903 | 41 |
609559 | 609559 | 2020-10-08 | DeKalb | Illinois | 17037 | 1863 | 41 |
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);