ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17021 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054116 | 1054116 | 2021-02-22 | Christian | Illinois | 17021 | 3282 | 82 |
1050869 | 1050869 | 2021-02-21 | Christian | Illinois | 17021 | 3275 | 80 |
1047622 | 1047622 | 2021-02-20 | Christian | Illinois | 17021 | 3267 | 80 |
1044377 | 1044377 | 2021-02-19 | Christian | Illinois | 17021 | 3264 | 80 |
1041132 | 1041132 | 2021-02-18 | Christian | Illinois | 17021 | 3259 | 80 |
1037887 | 1037887 | 2021-02-17 | Christian | Illinois | 17021 | 3249 | 80 |
1034642 | 1034642 | 2021-02-16 | Christian | Illinois | 17021 | 3247 | 80 |
1031396 | 1031396 | 2021-02-15 | Christian | Illinois | 17021 | 3243 | 80 |
1028149 | 1028149 | 2021-02-14 | Christian | Illinois | 17021 | 3241 | 80 |
1024904 | 1024904 | 2021-02-13 | Christian | Illinois | 17021 | 3238 | 80 |
1021659 | 1021659 | 2021-02-12 | Christian | Illinois | 17021 | 3236 | 80 |
1018414 | 1018414 | 2021-02-11 | Christian | Illinois | 17021 | 3232 | 80 |
1015169 | 1015169 | 2021-02-10 | Christian | Illinois | 17021 | 3224 | 80 |
1011924 | 1011924 | 2021-02-09 | Christian | Illinois | 17021 | 3211 | 80 |
1008678 | 1008678 | 2021-02-08 | Christian | Illinois | 17021 | 3200 | 80 |
1005432 | 1005432 | 2021-02-07 | Christian | Illinois | 17021 | 3193 | 80 |
1002186 | 1002186 | 2021-02-06 | Christian | Illinois | 17021 | 3185 | 80 |
998940 | 998940 | 2021-02-05 | Christian | Illinois | 17021 | 3160 | 80 |
995694 | 995694 | 2021-02-04 | Christian | Illinois | 17021 | 3156 | 80 |
992448 | 992448 | 2021-02-03 | Christian | Illinois | 17021 | 3146 | 80 |
989202 | 989202 | 2021-02-02 | Christian | Illinois | 17021 | 3136 | 80 |
985955 | 985955 | 2021-02-01 | Christian | Illinois | 17021 | 3124 | 80 |
982708 | 982708 | 2021-01-31 | Christian | Illinois | 17021 | 3119 | 80 |
979462 | 979462 | 2021-01-30 | Christian | Illinois | 17021 | 3114 | 80 |
976217 | 976217 | 2021-01-29 | Christian | Illinois | 17021 | 3106 | 80 |
972972 | 972972 | 2021-01-28 | Christian | Illinois | 17021 | 3090 | 80 |
969727 | 969727 | 2021-01-27 | Christian | Illinois | 17021 | 3077 | 80 |
966483 | 966483 | 2021-01-26 | Christian | Illinois | 17021 | 3067 | 80 |
963238 | 963238 | 2021-01-25 | Christian | Illinois | 17021 | 3062 | 80 |
959993 | 959993 | 2021-01-24 | Christian | Illinois | 17021 | 3056 | 79 |
956747 | 956747 | 2021-01-23 | Christian | Illinois | 17021 | 3052 | 79 |
953502 | 953502 | 2021-01-22 | Christian | Illinois | 17021 | 3034 | 77 |
950257 | 950257 | 2021-01-21 | Christian | Illinois | 17021 | 3007 | 76 |
947011 | 947011 | 2021-01-20 | Christian | Illinois | 17021 | 2997 | 75 |
943764 | 943764 | 2021-01-19 | Christian | Illinois | 17021 | 2986 | 74 |
940519 | 940519 | 2021-01-18 | Christian | Illinois | 17021 | 2979 | 74 |
937274 | 937274 | 2021-01-17 | Christian | Illinois | 17021 | 2974 | 74 |
934029 | 934029 | 2021-01-16 | Christian | Illinois | 17021 | 2964 | 74 |
930784 | 930784 | 2021-01-15 | Christian | Illinois | 17021 | 2953 | 73 |
927539 | 927539 | 2021-01-14 | Christian | Illinois | 17021 | 2923 | 72 |
924293 | 924293 | 2021-01-13 | Christian | Illinois | 17021 | 2896 | 72 |
921048 | 921048 | 2021-01-12 | Christian | Illinois | 17021 | 2880 | 71 |
917803 | 917803 | 2021-01-11 | Christian | Illinois | 17021 | 2851 | 70 |
914558 | 914558 | 2021-01-10 | Christian | Illinois | 17021 | 2836 | 70 |
911313 | 911313 | 2021-01-09 | Christian | Illinois | 17021 | 2820 | 70 |
908068 | 908068 | 2021-01-08 | Christian | Illinois | 17021 | 2799 | 70 |
904822 | 904822 | 2021-01-07 | Christian | Illinois | 17021 | 2763 | 70 |
901577 | 901577 | 2021-01-06 | Christian | Illinois | 17021 | 2718 | 68 |
898332 | 898332 | 2021-01-05 | Christian | Illinois | 17021 | 2702 | 68 |
895087 | 895087 | 2021-01-04 | Christian | Illinois | 17021 | 2682 | 68 |
891840 | 891840 | 2021-01-03 | Christian | Illinois | 17021 | 2671 | 68 |
888593 | 888593 | 2021-01-02 | Christian | Illinois | 17021 | 2652 | 67 |
885348 | 885348 | 2021-01-01 | Christian | Illinois | 17021 | 2600 | 66 |
882103 | 882103 | 2020-12-31 | Christian | Illinois | 17021 | 2600 | 66 |
878858 | 878858 | 2020-12-30 | Christian | Illinois | 17021 | 2567 | 64 |
875613 | 875613 | 2020-12-29 | Christian | Illinois | 17021 | 2548 | 64 |
872368 | 872368 | 2020-12-28 | Christian | Illinois | 17021 | 2525 | 63 |
869123 | 869123 | 2020-12-27 | Christian | Illinois | 17021 | 2516 | 63 |
865878 | 865878 | 2020-12-26 | Christian | Illinois | 17021 | 2496 | 63 |
862633 | 862633 | 2020-12-25 | Christian | Illinois | 17021 | 2493 | 63 |
859388 | 859388 | 2020-12-24 | Christian | Illinois | 17021 | 2483 | 63 |
856143 | 856143 | 2020-12-23 | Christian | Illinois | 17021 | 2450 | 59 |
852898 | 852898 | 2020-12-22 | Christian | Illinois | 17021 | 2438 | 59 |
849653 | 849653 | 2020-12-21 | Christian | Illinois | 17021 | 2428 | 58 |
846408 | 846408 | 2020-12-20 | Christian | Illinois | 17021 | 2421 | 58 |
843162 | 843162 | 2020-12-19 | Christian | Illinois | 17021 | 2407 | 57 |
839917 | 839917 | 2020-12-18 | Christian | Illinois | 17021 | 2381 | 57 |
836672 | 836672 | 2020-12-17 | Christian | Illinois | 17021 | 2357 | 57 |
833426 | 833426 | 2020-12-16 | Christian | Illinois | 17021 | 2336 | 55 |
830179 | 830179 | 2020-12-15 | Christian | Illinois | 17021 | 2322 | 53 |
826933 | 826933 | 2020-12-14 | Christian | Illinois | 17021 | 2311 | 53 |
823686 | 823686 | 2020-12-13 | Christian | Illinois | 17021 | 2256 | 53 |
820440 | 820440 | 2020-12-12 | Christian | Illinois | 17021 | 2230 | 52 |
817194 | 817194 | 2020-12-11 | Christian | Illinois | 17021 | 2204 | 52 |
813948 | 813948 | 2020-12-10 | Christian | Illinois | 17021 | 2130 | 51 |
810703 | 810703 | 2020-12-09 | Christian | Illinois | 17021 | 2100 | 51 |
807458 | 807458 | 2020-12-08 | Christian | Illinois | 17021 | 2068 | 50 |
804213 | 804213 | 2020-12-07 | Christian | Illinois | 17021 | 2056 | 48 |
800968 | 800968 | 2020-12-06 | Christian | Illinois | 17021 | 2039 | 48 |
797723 | 797723 | 2020-12-05 | Christian | Illinois | 17021 | 2016 | 47 |
794478 | 794478 | 2020-12-04 | Christian | Illinois | 17021 | 1984 | 47 |
791233 | 791233 | 2020-12-03 | Christian | Illinois | 17021 | 1969 | 44 |
787988 | 787988 | 2020-12-02 | Christian | Illinois | 17021 | 1940 | 44 |
784744 | 784744 | 2020-12-01 | Christian | Illinois | 17021 | 1914 | 44 |
781499 | 781499 | 2020-11-30 | Christian | Illinois | 17021 | 1903 | 44 |
778253 | 778253 | 2020-11-29 | Christian | Illinois | 17021 | 1894 | 44 |
775008 | 775008 | 2020-11-28 | Christian | Illinois | 17021 | 1882 | 44 |
771763 | 771763 | 2020-11-27 | Christian | Illinois | 17021 | 1854 | 44 |
768518 | 768518 | 2020-11-26 | Christian | Illinois | 17021 | 1841 | 43 |
765272 | 765272 | 2020-11-25 | Christian | Illinois | 17021 | 1807 | 41 |
762027 | 762027 | 2020-11-24 | Christian | Illinois | 17021 | 1776 | 41 |
758782 | 758782 | 2020-11-23 | Christian | Illinois | 17021 | 1748 | 40 |
755535 | 755535 | 2020-11-22 | Christian | Illinois | 17021 | 1731 | 39 |
752289 | 752289 | 2020-11-21 | Christian | Illinois | 17021 | 1719 | 38 |
749043 | 749043 | 2020-11-20 | Christian | Illinois | 17021 | 1692 | 37 |
745797 | 745797 | 2020-11-19 | Christian | Illinois | 17021 | 1631 | 36 |
742550 | 742550 | 2020-11-18 | Christian | Illinois | 17021 | 1591 | 34 |
739303 | 739303 | 2020-11-17 | Christian | Illinois | 17021 | 1558 | 34 |
736059 | 736059 | 2020-11-16 | Christian | Illinois | 17021 | 1524 | 34 |
732813 | 732813 | 2020-11-15 | Christian | Illinois | 17021 | 1495 | 34 |
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);