ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "DeKalb" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1274916 | 1274916 | 2021-05-01 | DeKalb | Illinois | 17037 | 9885 | 124 |
1271669 | 1271669 | 2021-04-30 | DeKalb | Illinois | 17037 | 9885 | 124 |
1268422 | 1268422 | 2021-04-29 | DeKalb | Illinois | 17037 | 9863 | 123 |
1265175 | 1265175 | 2021-04-28 | DeKalb | Illinois | 17037 | 9842 | 123 |
1261928 | 1261928 | 2021-04-27 | DeKalb | Illinois | 17037 | 9801 | 123 |
1258681 | 1258681 | 2021-04-26 | DeKalb | Illinois | 17037 | 9765 | 123 |
1255434 | 1255434 | 2021-04-25 | DeKalb | Illinois | 17037 | 9694 | 123 |
1252187 | 1252187 | 2021-04-24 | DeKalb | Illinois | 17037 | 9694 | 123 |
1248940 | 1248940 | 2021-04-23 | DeKalb | Illinois | 17037 | 9694 | 123 |
1245693 | 1245693 | 2021-04-22 | DeKalb | Illinois | 17037 | 9651 | 123 |
1242446 | 1242446 | 2021-04-21 | DeKalb | Illinois | 17037 | 9610 | 123 |
1239199 | 1239199 | 2021-04-20 | DeKalb | Illinois | 17037 | 9562 | 123 |
1235952 | 1235952 | 2021-04-19 | DeKalb | Illinois | 17037 | 9528 | 123 |
1232705 | 1232705 | 2021-04-18 | DeKalb | Illinois | 17037 | 9416 | 123 |
1229456 | 1229456 | 2021-04-17 | DeKalb | Illinois | 17037 | 9416 | 123 |
1226208 | 1226208 | 2021-04-16 | DeKalb | Illinois | 17037 | 9416 | 123 |
1222961 | 1222961 | 2021-04-15 | DeKalb | Illinois | 17037 | 9359 | 123 |
1219713 | 1219713 | 2021-04-14 | DeKalb | Illinois | 17037 | 9313 | 123 |
1216465 | 1216465 | 2021-04-13 | DeKalb | Illinois | 17037 | 9277 | 123 |
1213218 | 1213218 | 2021-04-12 | DeKalb | Illinois | 17037 | 9234 | 123 |
1209970 | 1209970 | 2021-04-11 | DeKalb | Illinois | 17037 | 9114 | 123 |
1206721 | 1206721 | 2021-04-10 | DeKalb | Illinois | 17037 | 9114 | 122 |
1203473 | 1203473 | 2021-04-09 | DeKalb | Illinois | 17037 | 9114 | 122 |
1200225 | 1200225 | 2021-04-08 | DeKalb | Illinois | 17037 | 9066 | 122 |
1196976 | 1196976 | 2021-04-07 | DeKalb | Illinois | 17037 | 9018 | 122 |
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 |
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);