ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 17037 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193728 | 1193728 | 2021-04-06 | DeKalb | Illinois | 17037 | 8987 | 122 |
1190478 | 1190478 | 2021-04-05 | DeKalb | Illinois | 17037 | 8946 | 122 |
1187231 | 1187231 | 2021-04-04 | DeKalb | Illinois | 17037 | 8864 | 122 |
1183984 | 1183984 | 2021-04-03 | DeKalb | Illinois | 17037 | 8864 | 122 |
1180737 | 1180737 | 2021-04-02 | DeKalb | Illinois | 17037 | 8864 | 122 |
1177490 | 1177490 | 2021-04-01 | DeKalb | Illinois | 17037 | 8864 | 122 |
1174243 | 1174243 | 2021-03-31 | DeKalb | Illinois | 17037 | 8837 | 122 |
1170996 | 1170996 | 2021-03-30 | DeKalb | Illinois | 17037 | 8815 | 122 |
1167748 | 1167748 | 2021-03-29 | DeKalb | Illinois | 17037 | 8800 | 122 |
1164500 | 1164500 | 2021-03-28 | DeKalb | Illinois | 17037 | 8749 | 122 |
1161252 | 1161252 | 2021-03-27 | DeKalb | Illinois | 17037 | 8749 | 122 |
1158004 | 1158004 | 2021-03-26 | DeKalb | Illinois | 17037 | 8749 | 122 |
1154757 | 1154757 | 2021-03-25 | DeKalb | Illinois | 17037 | 8737 | 122 |
1151510 | 1151510 | 2021-03-24 | DeKalb | Illinois | 17037 | 8720 | 122 |
1148263 | 1148263 | 2021-03-23 | DeKalb | Illinois | 17037 | 8703 | 122 |
1145016 | 1145016 | 2021-03-22 | DeKalb | Illinois | 17037 | 8687 | 122 |
1141769 | 1141769 | 2021-03-21 | DeKalb | Illinois | 17037 | 8662 | 120 |
1138523 | 1138523 | 2021-03-20 | DeKalb | Illinois | 17037 | 8662 | 120 |
1135277 | 1135277 | 2021-03-19 | DeKalb | Illinois | 17037 | 8662 | 120 |
1132030 | 1132030 | 2021-03-18 | DeKalb | Illinois | 17037 | 8652 | 120 |
1128782 | 1128782 | 2021-03-17 | DeKalb | Illinois | 17037 | 8639 | 120 |
1125536 | 1125536 | 2021-03-16 | DeKalb | Illinois | 17037 | 8629 | 120 |
1122290 | 1122290 | 2021-03-15 | DeKalb | Illinois | 17037 | 8615 | 120 |
1119043 | 1119043 | 2021-03-14 | DeKalb | Illinois | 17037 | 8598 | 120 |
1115796 | 1115796 | 2021-03-13 | DeKalb | Illinois | 17037 | 8598 | 120 |
1112550 | 1112550 | 2021-03-12 | DeKalb | Illinois | 17037 | 8598 | 120 |
1109304 | 1109304 | 2021-03-11 | DeKalb | Illinois | 17037 | 8586 | 120 |
1106058 | 1106058 | 2021-03-10 | DeKalb | Illinois | 17037 | 8572 | 120 |
1102812 | 1102812 | 2021-03-09 | DeKalb | Illinois | 17037 | 8563 | 120 |
1099566 | 1099566 | 2021-03-08 | DeKalb | Illinois | 17037 | 8554 | 120 |
1096318 | 1096318 | 2021-03-07 | DeKalb | Illinois | 17037 | 8520 | 120 |
1093072 | 1093072 | 2021-03-06 | DeKalb | Illinois | 17037 | 8520 | 120 |
1089826 | 1089826 | 2021-03-05 | DeKalb | Illinois | 17037 | 8520 | 120 |
1086581 | 1086581 | 2021-03-04 | DeKalb | Illinois | 17037 | 8511 | 118 |
1083335 | 1083335 | 2021-03-03 | DeKalb | Illinois | 17037 | 8496 | 118 |
1080089 | 1080089 | 2021-03-02 | DeKalb | Illinois | 17037 | 8465 | 117 |
1076844 | 1076844 | 2021-03-01 | DeKalb | Illinois | 17037 | 8409 | 117 |
1073598 | 1073598 | 2021-02-28 | DeKalb | Illinois | 17037 | 8409 | 117 |
1070352 | 1070352 | 2021-02-27 | DeKalb | Illinois | 17037 | 8409 | 117 |
1067107 | 1067107 | 2021-02-26 | DeKalb | Illinois | 17037 | 8409 | 117 |
1063862 | 1063862 | 2021-02-25 | DeKalb | Illinois | 17037 | 8386 | 117 |
1060617 | 1060617 | 2021-02-24 | DeKalb | Illinois | 17037 | 8376 | 116 |
1057371 | 1057371 | 2021-02-23 | DeKalb | Illinois | 17037 | 8339 | 116 |
1054125 | 1054125 | 2021-02-22 | DeKalb | Illinois | 17037 | 8321 | 116 |
1050878 | 1050878 | 2021-02-21 | DeKalb | Illinois | 17037 | 8297 | 116 |
1047631 | 1047631 | 2021-02-20 | DeKalb | Illinois | 17037 | 8297 | 116 |
1044386 | 1044386 | 2021-02-19 | DeKalb | Illinois | 17037 | 8297 | 116 |
1041141 | 1041141 | 2021-02-18 | DeKalb | Illinois | 17037 | 8280 | 116 |
1037896 | 1037896 | 2021-02-17 | DeKalb | Illinois | 17037 | 8252 | 114 |
1034651 | 1034651 | 2021-02-16 | DeKalb | Illinois | 17037 | 8236 | 114 |
1031405 | 1031405 | 2021-02-15 | DeKalb | Illinois | 17037 | 8197 | 114 |
1028158 | 1028158 | 2021-02-14 | DeKalb | Illinois | 17037 | 8197 | 114 |
1024913 | 1024913 | 2021-02-13 | DeKalb | Illinois | 17037 | 8197 | 113 |
1021668 | 1021668 | 2021-02-12 | DeKalb | Illinois | 17037 | 8197 | 113 |
1018423 | 1018423 | 2021-02-11 | DeKalb | Illinois | 17037 | 8178 | 113 |
1015178 | 1015178 | 2021-02-10 | DeKalb | Illinois | 17037 | 8153 | 112 |
1011933 | 1011933 | 2021-02-09 | DeKalb | Illinois | 17037 | 8135 | 111 |
1008687 | 1008687 | 2021-02-08 | DeKalb | Illinois | 17037 | 8121 | 111 |
1005441 | 1005441 | 2021-02-07 | DeKalb | Illinois | 17037 | 8100 | 111 |
1002195 | 1002195 | 2021-02-06 | DeKalb | Illinois | 17037 | 8100 | 111 |
998949 | 998949 | 2021-02-05 | DeKalb | Illinois | 17037 | 8100 | 110 |
995703 | 995703 | 2021-02-04 | DeKalb | Illinois | 17037 | 8072 | 110 |
992457 | 992457 | 2021-02-03 | DeKalb | Illinois | 17037 | 8048 | 107 |
989211 | 989211 | 2021-02-02 | DeKalb | Illinois | 17037 | 8016 | 107 |
985964 | 985964 | 2021-02-01 | DeKalb | Illinois | 17037 | 7998 | 107 |
982717 | 982717 | 2021-01-31 | DeKalb | Illinois | 17037 | 7942 | 105 |
979471 | 979471 | 2021-01-30 | DeKalb | Illinois | 17037 | 7942 | 105 |
976226 | 976226 | 2021-01-29 | DeKalb | Illinois | 17037 | 7942 | 105 |
972981 | 972981 | 2021-01-28 | DeKalb | Illinois | 17037 | 7896 | 103 |
969736 | 969736 | 2021-01-27 | DeKalb | Illinois | 17037 | 7874 | 99 |
966492 | 966492 | 2021-01-26 | DeKalb | Illinois | 17037 | 7855 | 96 |
963247 | 963247 | 2021-01-25 | DeKalb | Illinois | 17037 | 7831 | 95 |
960002 | 960002 | 2021-01-24 | DeKalb | Illinois | 17037 | 7755 | 94 |
956756 | 956756 | 2021-01-23 | DeKalb | Illinois | 17037 | 7755 | 93 |
953511 | 953511 | 2021-01-22 | DeKalb | Illinois | 17037 | 7755 | 92 |
950266 | 950266 | 2021-01-21 | DeKalb | Illinois | 17037 | 7706 | 92 |
947020 | 947020 | 2021-01-20 | DeKalb | Illinois | 17037 | 7665 | 92 |
943773 | 943773 | 2021-01-19 | DeKalb | Illinois | 17037 | 7612 | 92 |
940528 | 940528 | 2021-01-18 | DeKalb | Illinois | 17037 | 7469 | 92 |
937283 | 937283 | 2021-01-17 | DeKalb | Illinois | 17037 | 7469 | 92 |
934038 | 934038 | 2021-01-16 | DeKalb | Illinois | 17037 | 7469 | 92 |
930793 | 930793 | 2021-01-15 | DeKalb | Illinois | 17037 | 7469 | 90 |
927548 | 927548 | 2021-01-14 | DeKalb | Illinois | 17037 | 7425 | 89 |
924302 | 924302 | 2021-01-13 | DeKalb | Illinois | 17037 | 7361 | 89 |
921057 | 921057 | 2021-01-12 | DeKalb | Illinois | 17037 | 7328 | 89 |
917812 | 917812 | 2021-01-11 | DeKalb | Illinois | 17037 | 7270 | 87 |
914567 | 914567 | 2021-01-10 | DeKalb | Illinois | 17037 | 7151 | 87 |
911322 | 911322 | 2021-01-09 | DeKalb | Illinois | 17037 | 7151 | 87 |
908077 | 908077 | 2021-01-08 | DeKalb | Illinois | 17037 | 7151 | 85 |
904831 | 904831 | 2021-01-07 | DeKalb | Illinois | 17037 | 7107 | 84 |
901586 | 901586 | 2021-01-06 | DeKalb | Illinois | 17037 | 7031 | 84 |
898341 | 898341 | 2021-01-05 | DeKalb | Illinois | 17037 | 6983 | 83 |
895096 | 895096 | 2021-01-04 | DeKalb | Illinois | 17037 | 6941 | 83 |
891849 | 891849 | 2021-01-03 | DeKalb | Illinois | 17037 | 6776 | 82 |
888602 | 888602 | 2021-01-02 | DeKalb | Illinois | 17037 | 6768 | 82 |
885357 | 885357 | 2021-01-01 | DeKalb | Illinois | 17037 | 6768 | 81 |
882112 | 882112 | 2020-12-31 | DeKalb | Illinois | 17037 | 6768 | 81 |
878867 | 878867 | 2020-12-30 | DeKalb | Illinois | 17037 | 6709 | 77 |
875622 | 875622 | 2020-12-29 | DeKalb | Illinois | 17037 | 6640 | 76 |
872377 | 872377 | 2020-12-28 | DeKalb | Illinois | 17037 | 6606 | 75 |
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);