ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17091 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193754 | 1193754 | 2021-04-06 | Kankakee | Illinois | 17091 | 13121 | 202 |
1190504 | 1190504 | 2021-04-05 | Kankakee | Illinois | 17091 | 13093 | 202 |
1187257 | 1187257 | 2021-04-04 | Kankakee | Illinois | 17091 | 13077 | 202 |
1184010 | 1184010 | 2021-04-03 | Kankakee | Illinois | 17091 | 13065 | 200 |
1180763 | 1180763 | 2021-04-02 | Kankakee | Illinois | 17091 | 13046 | 200 |
1177516 | 1177516 | 2021-04-01 | Kankakee | Illinois | 17091 | 13032 | 200 |
1174269 | 1174269 | 2021-03-31 | Kankakee | Illinois | 17091 | 13011 | 200 |
1171022 | 1171022 | 2021-03-30 | Kankakee | Illinois | 17091 | 12988 | 200 |
1167774 | 1167774 | 2021-03-29 | Kankakee | Illinois | 17091 | 12967 | 200 |
1164526 | 1164526 | 2021-03-28 | Kankakee | Illinois | 17091 | 12954 | 200 |
1161278 | 1161278 | 2021-03-27 | Kankakee | Illinois | 17091 | 12939 | 200 |
1158030 | 1158030 | 2021-03-26 | Kankakee | Illinois | 17091 | 12919 | 200 |
1154783 | 1154783 | 2021-03-25 | Kankakee | Illinois | 17091 | 12891 | 200 |
1151536 | 1151536 | 2021-03-24 | Kankakee | Illinois | 17091 | 12865 | 200 |
1148289 | 1148289 | 2021-03-23 | Kankakee | Illinois | 17091 | 12846 | 200 |
1145042 | 1145042 | 2021-03-22 | Kankakee | Illinois | 17091 | 12837 | 200 |
1141795 | 1141795 | 2021-03-21 | Kankakee | Illinois | 17091 | 12833 | 200 |
1138549 | 1138549 | 2021-03-20 | Kankakee | Illinois | 17091 | 12819 | 200 |
1135303 | 1135303 | 2021-03-19 | Kankakee | Illinois | 17091 | 12807 | 200 |
1132056 | 1132056 | 2021-03-18 | Kankakee | Illinois | 17091 | 12797 | 199 |
1128808 | 1128808 | 2021-03-17 | Kankakee | Illinois | 17091 | 12772 | 199 |
1125562 | 1125562 | 2021-03-16 | Kankakee | Illinois | 17091 | 12764 | 199 |
1122316 | 1122316 | 2021-03-15 | Kankakee | Illinois | 17091 | 12742 | 199 |
1119069 | 1119069 | 2021-03-14 | Kankakee | Illinois | 17091 | 12739 | 199 |
1115822 | 1115822 | 2021-03-13 | Kankakee | Illinois | 17091 | 12729 | 198 |
1112576 | 1112576 | 2021-03-12 | Kankakee | Illinois | 17091 | 12708 | 198 |
1109330 | 1109330 | 2021-03-11 | Kankakee | Illinois | 17091 | 12686 | 198 |
1106084 | 1106084 | 2021-03-10 | Kankakee | Illinois | 17091 | 12655 | 198 |
1102838 | 1102838 | 2021-03-09 | Kankakee | Illinois | 17091 | 12634 | 198 |
1099592 | 1099592 | 2021-03-08 | Kankakee | Illinois | 17091 | 12610 | 198 |
1096344 | 1096344 | 2021-03-07 | Kankakee | Illinois | 17091 | 12605 | 198 |
1093098 | 1093098 | 2021-03-06 | Kankakee | Illinois | 17091 | 12594 | 198 |
1089852 | 1089852 | 2021-03-05 | Kankakee | Illinois | 17091 | 12576 | 197 |
1086607 | 1086607 | 2021-03-04 | Kankakee | Illinois | 17091 | 12555 | 197 |
1083361 | 1083361 | 2021-03-03 | Kankakee | Illinois | 17091 | 12538 | 197 |
1080115 | 1080115 | 2021-03-02 | Kankakee | Illinois | 17091 | 12518 | 197 |
1076870 | 1076870 | 2021-03-01 | Kankakee | Illinois | 17091 | 12502 | 197 |
1073624 | 1073624 | 2021-02-28 | Kankakee | Illinois | 17091 | 12496 | 197 |
1070378 | 1070378 | 2021-02-27 | Kankakee | Illinois | 17091 | 12482 | 197 |
1067133 | 1067133 | 2021-02-26 | Kankakee | Illinois | 17091 | 12468 | 197 |
1063888 | 1063888 | 2021-02-25 | Kankakee | Illinois | 17091 | 12438 | 197 |
1060643 | 1060643 | 2021-02-24 | Kankakee | Illinois | 17091 | 12408 | 196 |
1057397 | 1057397 | 2021-02-23 | Kankakee | Illinois | 17091 | 12383 | 196 |
1054151 | 1054151 | 2021-02-22 | Kankakee | Illinois | 17091 | 12360 | 196 |
1050904 | 1050904 | 2021-02-21 | Kankakee | Illinois | 17091 | 12341 | 196 |
1047657 | 1047657 | 2021-02-20 | Kankakee | Illinois | 17091 | 12326 | 196 |
1044412 | 1044412 | 2021-02-19 | Kankakee | Illinois | 17091 | 12291 | 195 |
1041167 | 1041167 | 2021-02-18 | Kankakee | Illinois | 17091 | 12259 | 195 |
1037922 | 1037922 | 2021-02-17 | Kankakee | Illinois | 17091 | 12231 | 194 |
1034677 | 1034677 | 2021-02-16 | Kankakee | Illinois | 17091 | 12216 | 194 |
1031431 | 1031431 | 2021-02-15 | Kankakee | Illinois | 17091 | 12200 | 194 |
1028184 | 1028184 | 2021-02-14 | Kankakee | Illinois | 17091 | 12185 | 194 |
1024939 | 1024939 | 2021-02-13 | Kankakee | Illinois | 17091 | 12178 | 194 |
1021694 | 1021694 | 2021-02-12 | Kankakee | Illinois | 17091 | 12155 | 194 |
1018449 | 1018449 | 2021-02-11 | Kankakee | Illinois | 17091 | 12126 | 194 |
1015204 | 1015204 | 2021-02-10 | Kankakee | Illinois | 17091 | 12102 | 194 |
1011959 | 1011959 | 2021-02-09 | Kankakee | Illinois | 17091 | 12069 | 194 |
1008713 | 1008713 | 2021-02-08 | Kankakee | Illinois | 17091 | 12050 | 194 |
1005467 | 1005467 | 2021-02-07 | Kankakee | Illinois | 17091 | 12036 | 194 |
1002221 | 1002221 | 2021-02-06 | Kankakee | Illinois | 17091 | 12023 | 193 |
998975 | 998975 | 2021-02-05 | Kankakee | Illinois | 17091 | 12000 | 193 |
995729 | 995729 | 2021-02-04 | Kankakee | Illinois | 17091 | 11980 | 191 |
992483 | 992483 | 2021-02-03 | Kankakee | Illinois | 17091 | 11980 | 191 |
989237 | 989237 | 2021-02-02 | Kankakee | Illinois | 17091 | 11980 | 189 |
985990 | 985990 | 2021-02-01 | Kankakee | Illinois | 17091 | 11980 | 189 |
982743 | 982743 | 2021-01-31 | Kankakee | Illinois | 17091 | 11878 | 189 |
979497 | 979497 | 2021-01-30 | Kankakee | Illinois | 17091 | 11869 | 189 |
976252 | 976252 | 2021-01-29 | Kankakee | Illinois | 17091 | 11842 | 189 |
973007 | 973007 | 2021-01-28 | Kankakee | Illinois | 17091 | 11818 | 189 |
969762 | 969762 | 2021-01-27 | Kankakee | Illinois | 17091 | 11779 | 188 |
966518 | 966518 | 2021-01-26 | Kankakee | Illinois | 17091 | 11760 | 188 |
963273 | 963273 | 2021-01-25 | Kankakee | Illinois | 17091 | 11733 | 187 |
960028 | 960028 | 2021-01-24 | Kankakee | Illinois | 17091 | 11720 | 187 |
956782 | 956782 | 2021-01-23 | Kankakee | Illinois | 17091 | 11692 | 187 |
953537 | 953537 | 2021-01-22 | Kankakee | Illinois | 17091 | 11631 | 185 |
950292 | 950292 | 2021-01-21 | Kankakee | Illinois | 17091 | 11593 | 185 |
947046 | 947046 | 2021-01-20 | Kankakee | Illinois | 17091 | 11542 | 180 |
943799 | 943799 | 2021-01-19 | Kankakee | Illinois | 17091 | 11488 | 179 |
940554 | 940554 | 2021-01-18 | Kankakee | Illinois | 17091 | 11465 | 179 |
937309 | 937309 | 2021-01-17 | Kankakee | Illinois | 17091 | 11431 | 179 |
934064 | 934064 | 2021-01-16 | Kankakee | Illinois | 17091 | 11401 | 179 |
930819 | 930819 | 2021-01-15 | Kankakee | Illinois | 17091 | 11393 | 177 |
927574 | 927574 | 2021-01-14 | Kankakee | Illinois | 17091 | 11393 | 175 |
924328 | 924328 | 2021-01-13 | Kankakee | Illinois | 17091 | 11277 | 174 |
921083 | 921083 | 2021-01-12 | Kankakee | Illinois | 17091 | 11277 | 173 |
917838 | 917838 | 2021-01-11 | Kankakee | Illinois | 17091 | 11277 | 171 |
914593 | 914593 | 2021-01-10 | Kankakee | Illinois | 17091 | 11146 | 171 |
911348 | 911348 | 2021-01-09 | Kankakee | Illinois | 17091 | 11109 | 171 |
908103 | 908103 | 2021-01-08 | Kankakee | Illinois | 17091 | 11109 | 169 |
904857 | 904857 | 2021-01-07 | Kankakee | Illinois | 17091 | 11109 | 168 |
901612 | 901612 | 2021-01-06 | Kankakee | Illinois | 17091 | 10938 | 167 |
898367 | 898367 | 2021-01-05 | Kankakee | Illinois | 17091 | 10866 | 164 |
895122 | 895122 | 2021-01-04 | Kankakee | Illinois | 17091 | 10797 | 164 |
891875 | 891875 | 2021-01-03 | Kankakee | Illinois | 17091 | 10776 | 163 |
888628 | 888628 | 2021-01-02 | Kankakee | Illinois | 17091 | 10758 | 161 |
885383 | 885383 | 2021-01-01 | Kankakee | Illinois | 17091 | 10717 | 159 |
882138 | 882138 | 2020-12-31 | Kankakee | Illinois | 17091 | 10717 | 159 |
878893 | 878893 | 2020-12-30 | Kankakee | Illinois | 17091 | 10717 | 156 |
875648 | 875648 | 2020-12-29 | Kankakee | Illinois | 17091 | 10610 | 153 |
872403 | 872403 | 2020-12-28 | Kankakee | Illinois | 17091 | 10610 | 152 |
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);