ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17043 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193730 | 1193730 | 2021-04-06 | DuPage | Illinois | 17043 | 83350 | 1321 |
1190480 | 1190480 | 2021-04-05 | DuPage | Illinois | 17043 | 83031 | 1321 |
1187233 | 1187233 | 2021-04-04 | DuPage | Illinois | 17043 | 82864 | 1318 |
1183986 | 1183986 | 2021-04-03 | DuPage | Illinois | 17043 | 82635 | 1318 |
1180739 | 1180739 | 2021-04-02 | DuPage | Illinois | 17043 | 82391 | 1319 |
1177492 | 1177492 | 2021-04-01 | DuPage | Illinois | 17043 | 82163 | 1319 |
1174245 | 1174245 | 2021-03-31 | DuPage | Illinois | 17043 | 81889 | 1316 |
1170998 | 1170998 | 2021-03-30 | DuPage | Illinois | 17043 | 81698 | 1315 |
1167750 | 1167750 | 2021-03-29 | DuPage | Illinois | 17043 | 81487 | 1316 |
1164502 | 1164502 | 2021-03-28 | DuPage | Illinois | 17043 | 81323 | 1314 |
1161254 | 1161254 | 2021-03-27 | DuPage | Illinois | 17043 | 81165 | 1313 |
1158006 | 1158006 | 2021-03-26 | DuPage | Illinois | 17043 | 80980 | 1311 |
1154759 | 1154759 | 2021-03-25 | DuPage | Illinois | 17043 | 80728 | 1311 |
1151512 | 1151512 | 2021-03-24 | DuPage | Illinois | 17043 | 80560 | 1308 |
1148265 | 1148265 | 2021-03-23 | DuPage | Illinois | 17043 | 80285 | 1308 |
1145018 | 1145018 | 2021-03-22 | DuPage | Illinois | 17043 | 80121 | 1308 |
1141771 | 1141771 | 2021-03-21 | DuPage | Illinois | 17043 | 79994 | 1308 |
1138525 | 1138525 | 2021-03-20 | DuPage | Illinois | 17043 | 79898 | 1306 |
1135279 | 1135279 | 2021-03-19 | DuPage | Illinois | 17043 | 79730 | 1305 |
1132032 | 1132032 | 2021-03-18 | DuPage | Illinois | 17043 | 79511 | 1303 |
1128784 | 1128784 | 2021-03-17 | DuPage | Illinois | 17043 | 79328 | 1299 |
1125538 | 1125538 | 2021-03-16 | DuPage | Illinois | 17043 | 79165 | 1299 |
1122292 | 1122292 | 2021-03-15 | DuPage | Illinois | 17043 | 79010 | 1298 |
1119045 | 1119045 | 2021-03-14 | DuPage | Illinois | 17043 | 78889 | 1297 |
1115798 | 1115798 | 2021-03-13 | DuPage | Illinois | 17043 | 78589 | 1297 |
1112552 | 1112552 | 2021-03-12 | DuPage | Illinois | 17043 | 78450 | 1296 |
1109306 | 1109306 | 2021-03-11 | DuPage | Illinois | 17043 | 78341 | 1293 |
1106060 | 1106060 | 2021-03-10 | DuPage | Illinois | 17043 | 78207 | 1291 |
1102814 | 1102814 | 2021-03-09 | DuPage | Illinois | 17043 | 78098 | 1291 |
1099568 | 1099568 | 2021-03-08 | DuPage | Illinois | 17043 | 77960 | 1290 |
1096320 | 1096320 | 2021-03-07 | DuPage | Illinois | 17043 | 77882 | 1290 |
1093074 | 1093074 | 2021-03-06 | DuPage | Illinois | 17043 | 77796 | 1290 |
1089828 | 1089828 | 2021-03-05 | DuPage | Illinois | 17043 | 77506 | 1290 |
1086583 | 1086583 | 2021-03-04 | DuPage | Illinois | 17043 | 77406 | 1289 |
1083337 | 1083337 | 2021-03-03 | DuPage | Illinois | 17043 | 77279 | 1287 |
1080091 | 1080091 | 2021-03-02 | DuPage | Illinois | 17043 | 77025 | 1283 |
1076846 | 1076846 | 2021-03-01 | DuPage | Illinois | 17043 | 76871 | 1281 |
1073600 | 1073600 | 2021-02-28 | DuPage | Illinois | 17043 | 76765 | 1281 |
1070354 | 1070354 | 2021-02-27 | DuPage | Illinois | 17043 | 76659 | 1279 |
1067109 | 1067109 | 2021-02-26 | DuPage | Illinois | 17043 | 76542 | 1278 |
1063864 | 1063864 | 2021-02-25 | DuPage | Illinois | 17043 | 76398 | 1275 |
1060619 | 1060619 | 2021-02-24 | DuPage | Illinois | 17043 | 76287 | 1274 |
1057373 | 1057373 | 2021-02-23 | DuPage | Illinois | 17043 | 76156 | 1273 |
1054127 | 1054127 | 2021-02-22 | DuPage | Illinois | 17043 | 76009 | 1270 |
1050880 | 1050880 | 2021-02-21 | DuPage | Illinois | 17043 | 75826 | 1268 |
1047633 | 1047633 | 2021-02-20 | DuPage | Illinois | 17043 | 75701 | 1263 |
1044388 | 1044388 | 2021-02-19 | DuPage | Illinois | 17043 | 75587 | 1260 |
1041143 | 1041143 | 2021-02-18 | DuPage | Illinois | 17043 | 75419 | 1257 |
1037898 | 1037898 | 2021-02-17 | DuPage | Illinois | 17043 | 75281 | 1249 |
1034653 | 1034653 | 2021-02-16 | DuPage | Illinois | 17043 | 75140 | 1244 |
1031407 | 1031407 | 2021-02-15 | DuPage | Illinois | 17043 | 74991 | 1241 |
1028160 | 1028160 | 2021-02-14 | DuPage | Illinois | 17043 | 74877 | 1238 |
1024915 | 1024915 | 2021-02-13 | DuPage | Illinois | 17043 | 74742 | 1238 |
1021670 | 1021670 | 2021-02-12 | DuPage | Illinois | 17043 | 74578 | 1230 |
1018425 | 1018425 | 2021-02-11 | DuPage | Illinois | 17043 | 74406 | 1230 |
1015180 | 1015180 | 2021-02-10 | DuPage | Illinois | 17043 | 74151 | 1224 |
1011935 | 1011935 | 2021-02-09 | DuPage | Illinois | 17043 | 73981 | 1221 |
1008689 | 1008689 | 2021-02-08 | DuPage | Illinois | 17043 | 73832 | 1220 |
1005443 | 1005443 | 2021-02-07 | DuPage | Illinois | 17043 | 73692 | 1217 |
1002197 | 1002197 | 2021-02-06 | DuPage | Illinois | 17043 | 73602 | 1213 |
998951 | 998951 | 2021-02-05 | DuPage | Illinois | 17043 | 73399 | 1208 |
995705 | 995705 | 2021-02-04 | DuPage | Illinois | 17043 | 73167 | 1204 |
992459 | 992459 | 2021-02-03 | DuPage | Illinois | 17043 | 72945 | 1200 |
989213 | 989213 | 2021-02-02 | DuPage | Illinois | 17043 | 72732 | 1196 |
985966 | 985966 | 2021-02-01 | DuPage | Illinois | 17043 | 72610 | 1196 |
982719 | 982719 | 2021-01-31 | DuPage | Illinois | 17043 | 72454 | 1191 |
979473 | 979473 | 2021-01-30 | DuPage | Illinois | 17043 | 72279 | 1191 |
976228 | 976228 | 2021-01-29 | DuPage | Illinois | 17043 | 72068 | 1191 |
972983 | 972983 | 2021-01-28 | DuPage | Illinois | 17043 | 71819 | 1189 |
969738 | 969738 | 2021-01-27 | DuPage | Illinois | 17043 | 71529 | 1183 |
966494 | 966494 | 2021-01-26 | DuPage | Illinois | 17043 | 71323 | 1179 |
963249 | 963249 | 2021-01-25 | DuPage | Illinois | 17043 | 71070 | 1173 |
960004 | 960004 | 2021-01-24 | DuPage | Illinois | 17043 | 70890 | 1168 |
956758 | 956758 | 2021-01-23 | DuPage | Illinois | 17043 | 70712 | 1168 |
953513 | 953513 | 2021-01-22 | DuPage | Illinois | 17043 | 70324 | 1165 |
950268 | 950268 | 2021-01-21 | DuPage | Illinois | 17043 | 69900 | 1160 |
947022 | 947022 | 2021-01-20 | DuPage | Illinois | 17043 | 69579 | 1157 |
943775 | 943775 | 2021-01-19 | DuPage | Illinois | 17043 | 69285 | 1153 |
940530 | 940530 | 2021-01-18 | DuPage | Illinois | 17043 | 68970 | 1151 |
937285 | 937285 | 2021-01-17 | DuPage | Illinois | 17043 | 68737 | 1145 |
934040 | 934040 | 2021-01-16 | DuPage | Illinois | 17043 | 68534 | 1144 |
930795 | 930795 | 2021-01-15 | DuPage | Illinois | 17043 | 68156 | 1136 |
927550 | 927550 | 2021-01-14 | DuPage | Illinois | 17043 | 67651 | 1129 |
924304 | 924304 | 2021-01-13 | DuPage | Illinois | 17043 | 67271 | 1122 |
921059 | 921059 | 2021-01-12 | DuPage | Illinois | 17043 | 66858 | 1116 |
917814 | 917814 | 2021-01-11 | DuPage | Illinois | 17043 | 66414 | 1109 |
914569 | 914569 | 2021-01-10 | DuPage | Illinois | 17043 | 66084 | 1107 |
911324 | 911324 | 2021-01-09 | DuPage | Illinois | 17043 | 65784 | 1105 |
908079 | 908079 | 2021-01-08 | DuPage | Illinois | 17043 | 65385 | 1099 |
904833 | 904833 | 2021-01-07 | DuPage | Illinois | 17043 | 64755 | 1092 |
901588 | 901588 | 2021-01-06 | DuPage | Illinois | 17043 | 64259 | 1082 |
898343 | 898343 | 2021-01-05 | DuPage | Illinois | 17043 | 63831 | 1074 |
895098 | 895098 | 2021-01-04 | DuPage | Illinois | 17043 | 63396 | 1062 |
891851 | 891851 | 2021-01-03 | DuPage | Illinois | 17043 | 63022 | 1055 |
888604 | 888604 | 2021-01-02 | DuPage | Illinois | 17043 | 62676 | 1051 |
885359 | 885359 | 2021-01-01 | DuPage | Illinois | 17043 | 61805 | 1030 |
882114 | 882114 | 2020-12-31 | DuPage | Illinois | 17043 | 61805 | 1030 |
878869 | 878869 | 2020-12-30 | DuPage | Illinois | 17043 | 61271 | 1024 |
875624 | 875624 | 2020-12-29 | DuPage | Illinois | 17043 | 60839 | 1012 |
872379 | 872379 | 2020-12-28 | DuPage | Illinois | 17043 | 60473 | 1003 |
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);