ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17001 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054106 | 1054106 | 2021-02-22 | Adams | Illinois | 17001 | 7956 | 142 |
1050859 | 1050859 | 2021-02-21 | Adams | Illinois | 17001 | 7958 | 142 |
1047612 | 1047612 | 2021-02-20 | Adams | Illinois | 17001 | 7957 | 142 |
1044367 | 1044367 | 2021-02-19 | Adams | Illinois | 17001 | 7944 | 142 |
1041122 | 1041122 | 2021-02-18 | Adams | Illinois | 17001 | 7933 | 140 |
1037877 | 1037877 | 2021-02-17 | Adams | Illinois | 17001 | 7936 | 140 |
1034632 | 1034632 | 2021-02-16 | Adams | Illinois | 17001 | 7917 | 140 |
1031386 | 1031386 | 2021-02-15 | Adams | Illinois | 17001 | 7887 | 140 |
1028139 | 1028139 | 2021-02-14 | Adams | Illinois | 17001 | 7891 | 140 |
1024894 | 1024894 | 2021-02-13 | Adams | Illinois | 17001 | 7899 | 140 |
1021649 | 1021649 | 2021-02-12 | Adams | Illinois | 17001 | 7881 | 140 |
1018404 | 1018404 | 2021-02-11 | Adams | Illinois | 17001 | 7870 | 140 |
1015159 | 1015159 | 2021-02-10 | Adams | Illinois | 17001 | 7852 | 140 |
1011914 | 1011914 | 2021-02-09 | Adams | Illinois | 17001 | 7833 | 138 |
1008668 | 1008668 | 2021-02-08 | Adams | Illinois | 17001 | 7807 | 138 |
1005422 | 1005422 | 2021-02-07 | Adams | Illinois | 17001 | 7808 | 138 |
1002176 | 1002176 | 2021-02-06 | Adams | Illinois | 17001 | 7819 | 138 |
998930 | 998930 | 2021-02-05 | Adams | Illinois | 17001 | 7825 | 138 |
995684 | 995684 | 2021-02-04 | Adams | Illinois | 17001 | 7775 | 137 |
992438 | 992438 | 2021-02-03 | Adams | Illinois | 17001 | 7761 | 137 |
989192 | 989192 | 2021-02-02 | Adams | Illinois | 17001 | 7749 | 136 |
985945 | 985945 | 2021-02-01 | Adams | Illinois | 17001 | 7733 | 136 |
982698 | 982698 | 2021-01-31 | Adams | Illinois | 17001 | 7703 | 136 |
979452 | 979452 | 2021-01-30 | Adams | Illinois | 17001 | 7714 | 136 |
976207 | 976207 | 2021-01-29 | Adams | Illinois | 17001 | 7722 | 136 |
972962 | 972962 | 2021-01-28 | Adams | Illinois | 17001 | 7668 | 136 |
969717 | 969717 | 2021-01-27 | Adams | Illinois | 17001 | 7651 | 135 |
966473 | 966473 | 2021-01-26 | Adams | Illinois | 17001 | 7630 | 131 |
963228 | 963228 | 2021-01-25 | Adams | Illinois | 17001 | 7591 | 129 |
959983 | 959983 | 2021-01-24 | Adams | Illinois | 17001 | 7545 | 129 |
956737 | 956737 | 2021-01-23 | Adams | Illinois | 17001 | 7551 | 127 |
953492 | 953492 | 2021-01-22 | Adams | Illinois | 17001 | 7572 | 125 |
950247 | 950247 | 2021-01-21 | Adams | Illinois | 17001 | 7479 | 123 |
947001 | 947001 | 2021-01-20 | Adams | Illinois | 17001 | 7439 | 121 |
943754 | 943754 | 2021-01-19 | Adams | Illinois | 17001 | 7405 | 117 |
940509 | 940509 | 2021-01-18 | Adams | Illinois | 17001 | 7370 | 117 |
937264 | 937264 | 2021-01-17 | Adams | Illinois | 17001 | 7310 | 117 |
934019 | 934019 | 2021-01-16 | Adams | Illinois | 17001 | 7329 | 117 |
930774 | 930774 | 2021-01-15 | Adams | Illinois | 17001 | 7314 | 114 |
927529 | 927529 | 2021-01-14 | Adams | Illinois | 17001 | 7266 | 108 |
924283 | 924283 | 2021-01-13 | Adams | Illinois | 17001 | 7215 | 100 |
921038 | 921038 | 2021-01-12 | Adams | Illinois | 17001 | 7192 | 99 |
917793 | 917793 | 2021-01-11 | Adams | Illinois | 17001 | 7115 | 98 |
914548 | 914548 | 2021-01-10 | Adams | Illinois | 17001 | 7062 | 97 |
911303 | 911303 | 2021-01-09 | Adams | Illinois | 17001 | 7045 | 97 |
908058 | 908058 | 2021-01-08 | Adams | Illinois | 17001 | 7011 | 96 |
904812 | 904812 | 2021-01-07 | Adams | Illinois | 17001 | 6960 | 94 |
901567 | 901567 | 2021-01-06 | Adams | Illinois | 17001 | 6925 | 86 |
898322 | 898322 | 2021-01-05 | Adams | Illinois | 17001 | 6942 | 84 |
895077 | 895077 | 2021-01-04 | Adams | Illinois | 17001 | 6763 | 83 |
891830 | 891830 | 2021-01-03 | Adams | Illinois | 17001 | 6616 | 83 |
888583 | 888583 | 2021-01-02 | Adams | Illinois | 17001 | 6628 | 83 |
885338 | 885338 | 2021-01-01 | Adams | Illinois | 17001 | 6582 | 82 |
882093 | 882093 | 2020-12-31 | Adams | Illinois | 17001 | 6582 | 82 |
878848 | 878848 | 2020-12-30 | Adams | Illinois | 17001 | 6433 | 80 |
875603 | 875603 | 2020-12-29 | Adams | Illinois | 17001 | 6470 | 79 |
872358 | 872358 | 2020-12-28 | Adams | Illinois | 17001 | 6172 | 78 |
869113 | 869113 | 2020-12-27 | Adams | Illinois | 17001 | 6156 | 77 |
865868 | 865868 | 2020-12-26 | Adams | Illinois | 17001 | 6117 | 77 |
862623 | 862623 | 2020-12-25 | Adams | Illinois | 17001 | 6162 | 74 |
859378 | 859378 | 2020-12-24 | Adams | Illinois | 17001 | 6162 | 73 |
856133 | 856133 | 2020-12-23 | Adams | Illinois | 17001 | 6051 | 72 |
852888 | 852888 | 2020-12-22 | Adams | Illinois | 17001 | 6040 | 72 |
849643 | 849643 | 2020-12-21 | Adams | Illinois | 17001 | 5922 | 69 |
846398 | 846398 | 2020-12-20 | Adams | Illinois | 17001 | 5827 | 69 |
843152 | 843152 | 2020-12-19 | Adams | Illinois | 17001 | 5811 | 68 |
839907 | 839907 | 2020-12-18 | Adams | Illinois | 17001 | 5752 | 68 |
836662 | 836662 | 2020-12-17 | Adams | Illinois | 17001 | 5746 | 67 |
833416 | 833416 | 2020-12-16 | Adams | Illinois | 17001 | 5629 | 67 |
830169 | 830169 | 2020-12-15 | Adams | Illinois | 17001 | 5640 | 64 |
826923 | 826923 | 2020-12-14 | Adams | Illinois | 17001 | 5478 | 63 |
823676 | 823676 | 2020-12-13 | Adams | Illinois | 17001 | 5434 | 63 |
820430 | 820430 | 2020-12-12 | Adams | Illinois | 17001 | 5494 | 63 |
817184 | 817184 | 2020-12-11 | Adams | Illinois | 17001 | 5391 | 63 |
813938 | 813938 | 2020-12-10 | Adams | Illinois | 17001 | 5308 | 61 |
810693 | 810693 | 2020-12-09 | Adams | Illinois | 17001 | 5279 | 58 |
807448 | 807448 | 2020-12-08 | Adams | Illinois | 17001 | 5227 | 57 |
804203 | 804203 | 2020-12-07 | Adams | Illinois | 17001 | 5086 | 57 |
800958 | 800958 | 2020-12-06 | Adams | Illinois | 17001 | 5074 | 57 |
797713 | 797713 | 2020-12-05 | Adams | Illinois | 17001 | 5038 | 57 |
794468 | 794468 | 2020-12-04 | Adams | Illinois | 17001 | 5049 | 56 |
791223 | 791223 | 2020-12-03 | Adams | Illinois | 17001 | 4996 | 55 |
787978 | 787978 | 2020-12-02 | Adams | Illinois | 17001 | 4886 | 54 |
784734 | 784734 | 2020-12-01 | Adams | Illinois | 17001 | 4901 | 50 |
781489 | 781489 | 2020-11-30 | Adams | Illinois | 17001 | 4815 | 48 |
778243 | 778243 | 2020-11-29 | Adams | Illinois | 17001 | 4768 | 48 |
774998 | 774998 | 2020-11-28 | Adams | Illinois | 17001 | 4732 | 48 |
771753 | 771753 | 2020-11-27 | Adams | Illinois | 17001 | 4651 | 48 |
768508 | 768508 | 2020-11-26 | Adams | Illinois | 17001 | 4652 | 48 |
765262 | 765262 | 2020-11-25 | Adams | Illinois | 17001 | 4652 | 48 |
762017 | 762017 | 2020-11-24 | Adams | Illinois | 17001 | 4585 | 46 |
758772 | 758772 | 2020-11-23 | Adams | Illinois | 17001 | 4442 | 46 |
755525 | 755525 | 2020-11-22 | Adams | Illinois | 17001 | 4402 | 46 |
752279 | 752279 | 2020-11-21 | Adams | Illinois | 17001 | 4372 | 46 |
749033 | 749033 | 2020-11-20 | Adams | Illinois | 17001 | 4328 | 43 |
745787 | 745787 | 2020-11-19 | Adams | Illinois | 17001 | 4243 | 41 |
742540 | 742540 | 2020-11-18 | Adams | Illinois | 17001 | 4042 | 41 |
739293 | 739293 | 2020-11-17 | Adams | Illinois | 17001 | 4138 | 40 |
736049 | 736049 | 2020-11-16 | Adams | Illinois | 17001 | 3733 | 39 |
732803 | 732803 | 2020-11-15 | Adams | Illinois | 17001 | 3629 | 39 |
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);