ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17113 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193772 | 1193772 | 2021-04-06 | McLean | Illinois | 17113 | 15982 | 202 |
1190522 | 1190522 | 2021-04-05 | McLean | Illinois | 17113 | 15935 | 202 |
1187275 | 1187275 | 2021-04-04 | McLean | Illinois | 17113 | 15919 | 202 |
1184028 | 1184028 | 2021-04-03 | McLean | Illinois | 17113 | 15831 | 202 |
1180781 | 1180781 | 2021-04-02 | McLean | Illinois | 17113 | 15792 | 202 |
1177534 | 1177534 | 2021-04-01 | McLean | Illinois | 17113 | 15719 | 202 |
1174287 | 1174287 | 2021-03-31 | McLean | Illinois | 17113 | 15644 | 201 |
1171040 | 1171040 | 2021-03-30 | McLean | Illinois | 17113 | 15561 | 201 |
1167792 | 1167792 | 2021-03-29 | McLean | Illinois | 17113 | 15500 | 201 |
1164544 | 1164544 | 2021-03-28 | McLean | Illinois | 17113 | 15460 | 201 |
1161296 | 1161296 | 2021-03-27 | McLean | Illinois | 17113 | 15410 | 201 |
1158048 | 1158048 | 2021-03-26 | McLean | Illinois | 17113 | 15355 | 202 |
1154801 | 1154801 | 2021-03-25 | McLean | Illinois | 17113 | 15303 | 201 |
1151554 | 1151554 | 2021-03-24 | McLean | Illinois | 17113 | 15255 | 201 |
1148307 | 1148307 | 2021-03-23 | McLean | Illinois | 17113 | 15208 | 199 |
1145060 | 1145060 | 2021-03-22 | McLean | Illinois | 17113 | 15148 | 199 |
1141813 | 1141813 | 2021-03-21 | McLean | Illinois | 17113 | 15136 | 199 |
1138567 | 1138567 | 2021-03-20 | McLean | Illinois | 17113 | 15103 | 199 |
1135321 | 1135321 | 2021-03-19 | McLean | Illinois | 17113 | 15066 | 198 |
1132074 | 1132074 | 2021-03-18 | McLean | Illinois | 17113 | 15017 | 198 |
1128826 | 1128826 | 2021-03-17 | McLean | Illinois | 17113 | 14987 | 198 |
1125580 | 1125580 | 2021-03-16 | McLean | Illinois | 17113 | 14966 | 198 |
1122334 | 1122334 | 2021-03-15 | McLean | Illinois | 17113 | 14935 | 198 |
1119087 | 1119087 | 2021-03-14 | McLean | Illinois | 17113 | 14914 | 198 |
1115840 | 1115840 | 2021-03-13 | McLean | Illinois | 17113 | 14896 | 198 |
1112594 | 1112594 | 2021-03-12 | McLean | Illinois | 17113 | 14863 | 197 |
1109348 | 1109348 | 2021-03-11 | McLean | Illinois | 17113 | 14842 | 197 |
1106102 | 1106102 | 2021-03-10 | McLean | Illinois | 17113 | 14820 | 196 |
1102856 | 1102856 | 2021-03-09 | McLean | Illinois | 17113 | 14787 | 196 |
1099610 | 1099610 | 2021-03-08 | McLean | Illinois | 17113 | 14757 | 196 |
1096362 | 1096362 | 2021-03-07 | McLean | Illinois | 17113 | 14738 | 196 |
1093116 | 1093116 | 2021-03-06 | McLean | Illinois | 17113 | 14732 | 196 |
1089870 | 1089870 | 2021-03-05 | McLean | Illinois | 17113 | 14707 | 196 |
1086625 | 1086625 | 2021-03-04 | McLean | Illinois | 17113 | 14681 | 196 |
1083379 | 1083379 | 2021-03-03 | McLean | Illinois | 17113 | 14660 | 195 |
1080133 | 1080133 | 2021-03-02 | McLean | Illinois | 17113 | 14633 | 194 |
1076888 | 1076888 | 2021-03-01 | McLean | Illinois | 17113 | 14621 | 193 |
1073642 | 1073642 | 2021-02-28 | McLean | Illinois | 17113 | 14601 | 193 |
1070396 | 1070396 | 2021-02-27 | McLean | Illinois | 17113 | 14581 | 193 |
1067151 | 1067151 | 2021-02-26 | McLean | Illinois | 17113 | 14560 | 193 |
1063906 | 1063906 | 2021-02-25 | McLean | Illinois | 17113 | 14538 | 192 |
1060661 | 1060661 | 2021-02-24 | McLean | Illinois | 17113 | 14500 | 192 |
1057415 | 1057415 | 2021-02-23 | McLean | Illinois | 17113 | 14485 | 192 |
1054169 | 1054169 | 2021-02-22 | McLean | Illinois | 17113 | 14452 | 192 |
1050922 | 1050922 | 2021-02-21 | McLean | Illinois | 17113 | 14438 | 192 |
1047675 | 1047675 | 2021-02-20 | McLean | Illinois | 17113 | 14432 | 192 |
1044430 | 1044430 | 2021-02-19 | McLean | Illinois | 17113 | 14400 | 192 |
1041185 | 1041185 | 2021-02-18 | McLean | Illinois | 17113 | 14370 | 190 |
1037940 | 1037940 | 2021-02-17 | McLean | Illinois | 17113 | 14332 | 189 |
1034695 | 1034695 | 2021-02-16 | McLean | Illinois | 17113 | 14312 | 189 |
1031449 | 1031449 | 2021-02-15 | McLean | Illinois | 17113 | 14288 | 189 |
1028202 | 1028202 | 2021-02-14 | McLean | Illinois | 17113 | 14274 | 188 |
1024957 | 1024957 | 2021-02-13 | McLean | Illinois | 17113 | 14271 | 188 |
1021712 | 1021712 | 2021-02-12 | McLean | Illinois | 17113 | 14243 | 187 |
1018467 | 1018467 | 2021-02-11 | McLean | Illinois | 17113 | 14239 | 186 |
1015222 | 1015222 | 2021-02-10 | McLean | Illinois | 17113 | 14231 | 185 |
1011977 | 1011977 | 2021-02-09 | McLean | Illinois | 17113 | 14197 | 183 |
1008731 | 1008731 | 2021-02-08 | McLean | Illinois | 17113 | 14162 | 182 |
1005485 | 1005485 | 2021-02-07 | McLean | Illinois | 17113 | 14154 | 182 |
1002239 | 1002239 | 2021-02-06 | McLean | Illinois | 17113 | 14132 | 182 |
998993 | 998993 | 2021-02-05 | McLean | Illinois | 17113 | 14108 | 182 |
995747 | 995747 | 2021-02-04 | McLean | Illinois | 17113 | 14031 | 181 |
992501 | 992501 | 2021-02-03 | McLean | Illinois | 17113 | 14005 | 178 |
989255 | 989255 | 2021-02-02 | McLean | Illinois | 17113 | 13928 | 178 |
986008 | 986008 | 2021-02-01 | McLean | Illinois | 17113 | 13913 | 178 |
982761 | 982761 | 2021-01-31 | McLean | Illinois | 17113 | 13873 | 178 |
979515 | 979515 | 2021-01-30 | McLean | Illinois | 17113 | 13841 | 178 |
976270 | 976270 | 2021-01-29 | McLean | Illinois | 17113 | 13812 | 178 |
973025 | 973025 | 2021-01-28 | McLean | Illinois | 17113 | 13744 | 177 |
969780 | 969780 | 2021-01-27 | McLean | Illinois | 17113 | 13686 | 176 |
966536 | 966536 | 2021-01-26 | McLean | Illinois | 17113 | 13653 | 174 |
963291 | 963291 | 2021-01-25 | McLean | Illinois | 17113 | 13590 | 173 |
960046 | 960046 | 2021-01-24 | McLean | Illinois | 17113 | 13564 | 171 |
956800 | 956800 | 2021-01-23 | McLean | Illinois | 17113 | 13537 | 170 |
953555 | 953555 | 2021-01-22 | McLean | Illinois | 17113 | 13472 | 170 |
950310 | 950310 | 2021-01-21 | McLean | Illinois | 17113 | 13350 | 168 |
947064 | 947064 | 2021-01-20 | McLean | Illinois | 17113 | 13294 | 164 |
943817 | 943817 | 2021-01-19 | McLean | Illinois | 17113 | 13244 | 159 |
940572 | 940572 | 2021-01-18 | McLean | Illinois | 17113 | 13170 | 159 |
937327 | 937327 | 2021-01-17 | McLean | Illinois | 17113 | 13143 | 159 |
934082 | 934082 | 2021-01-16 | McLean | Illinois | 17113 | 13093 | 159 |
930837 | 930837 | 2021-01-15 | McLean | Illinois | 17113 | 13013 | 156 |
927592 | 927592 | 2021-01-14 | McLean | Illinois | 17113 | 12931 | 152 |
924346 | 924346 | 2021-01-13 | McLean | Illinois | 17113 | 12839 | 149 |
921101 | 921101 | 2021-01-12 | McLean | Illinois | 17113 | 12772 | 146 |
917856 | 917856 | 2021-01-11 | McLean | Illinois | 17113 | 12671 | 146 |
914611 | 914611 | 2021-01-10 | McLean | Illinois | 17113 | 12611 | 146 |
911366 | 911366 | 2021-01-09 | McLean | Illinois | 17113 | 12525 | 144 |
908121 | 908121 | 2021-01-08 | McLean | Illinois | 17113 | 12412 | 141 |
904875 | 904875 | 2021-01-07 | McLean | Illinois | 17113 | 12285 | 137 |
901630 | 901630 | 2021-01-06 | McLean | Illinois | 17113 | 12141 | 134 |
898385 | 898385 | 2021-01-05 | McLean | Illinois | 17113 | 12036 | 128 |
895140 | 895140 | 2021-01-04 | McLean | Illinois | 17113 | 11951 | 125 |
891893 | 891893 | 2021-01-03 | McLean | Illinois | 17113 | 11885 | 124 |
888646 | 888646 | 2021-01-02 | McLean | Illinois | 17113 | 11797 | 124 |
885401 | 885401 | 2021-01-01 | McLean | Illinois | 17113 | 11621 | 115 |
882156 | 882156 | 2020-12-31 | McLean | Illinois | 17113 | 11621 | 115 |
878911 | 878911 | 2020-12-30 | McLean | Illinois | 17113 | 11500 | 108 |
875666 | 875666 | 2020-12-29 | McLean | Illinois | 17113 | 11365 | 105 |
872421 | 872421 | 2020-12-28 | McLean | Illinois | 17113 | 11293 | 100 |
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);