ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
667 rows where county = "Unknown" and state = "Illinois" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
11222 | 11222 | 2020-03-25 | Unknown | Illinois | 0 | 2 | |
888674 | 888674 | 2021-01-02 | Unknown | Illinois | 0 | 3 | |
979543 | 979543 | 2021-01-30 | Unknown | Illinois | 0 | 66 | |
982789 | 982789 | 2021-01-31 | Unknown | Illinois | 0 | 106 | |
986036 | 986036 | 2021-02-01 | Unknown | Illinois | 0 | 6 | |
989283 | 989283 | 2021-02-02 | Unknown | Illinois | 0 | 21 | |
992529 | 992529 | 2021-02-03 | Unknown | Illinois | 0 | 35 | |
995775 | 995775 | 2021-02-04 | Unknown | Illinois | 0 | 43 | |
999021 | 999021 | 2021-02-05 | Unknown | Illinois | 0 | 67 | |
1002267 | 1002267 | 2021-02-06 | Unknown | Illinois | 0 | 81 | |
1005513 | 1005513 | 2021-02-07 | Unknown | Illinois | 0 | 95 | |
1008759 | 1008759 | 2021-02-08 | Unknown | Illinois | 0 | 102 | |
1012005 | 1012005 | 2021-02-09 | Unknown | Illinois | 0 | 107 | |
1015250 | 1015250 | 2021-02-10 | Unknown | Illinois | 0 | 121 | |
1018495 | 1018495 | 2021-02-11 | Unknown | Illinois | 0 | 134 | |
1021740 | 1021740 | 2021-02-12 | Unknown | Illinois | 0 | 144 | |
1024985 | 1024985 | 2021-02-13 | Unknown | Illinois | 0 | 151 | |
1028230 | 1028230 | 2021-02-14 | Unknown | Illinois | 0 | 150 | |
1031477 | 1031477 | 2021-02-15 | Unknown | Illinois | 0 | 154 | |
1034723 | 1034723 | 2021-02-16 | Unknown | Illinois | 0 | 154 | |
1037968 | 1037968 | 2021-02-17 | Unknown | Illinois | 0 | 157 | |
1041213 | 1041213 | 2021-02-18 | Unknown | Illinois | 0 | 158 | |
1044458 | 1044458 | 2021-02-19 | Unknown | Illinois | 0 | 166 | |
1047703 | 1047703 | 2021-02-20 | Unknown | Illinois | 0 | 181 | |
1050950 | 1050950 | 2021-02-21 | Unknown | Illinois | 0 | 186 | |
1054197 | 1054197 | 2021-02-22 | Unknown | Illinois | 0 | 192 | |
1057443 | 1057443 | 2021-02-23 | Unknown | Illinois | 0 | 187 | |
1060689 | 1060689 | 2021-02-24 | Unknown | Illinois | 0 | 190 | |
1063934 | 1063934 | 2021-02-25 | Unknown | Illinois | 0 | 190 | |
1067179 | 1067179 | 2021-02-26 | Unknown | Illinois | 0 | 204 | |
1070424 | 1070424 | 2021-02-27 | Unknown | Illinois | 0 | 205 | |
1073670 | 1073670 | 2021-02-28 | Unknown | Illinois | 0 | 208 | |
1076916 | 1076916 | 2021-03-01 | Unknown | Illinois | 0 | 206 | |
1080161 | 1080161 | 2021-03-02 | Unknown | Illinois | 0 | 202 | |
1083407 | 1083407 | 2021-03-03 | Unknown | Illinois | 0 | 209 | |
1086653 | 1086653 | 2021-03-04 | Unknown | Illinois | 0 | 218 | |
1089898 | 1089898 | 2021-03-05 | Unknown | Illinois | 0 | 231 | |
1093144 | 1093144 | 2021-03-06 | Unknown | Illinois | 0 | 237 | |
1096390 | 1096390 | 2021-03-07 | Unknown | Illinois | 0 | 237 | |
1099638 | 1099638 | 2021-03-08 | Unknown | Illinois | 0 | 239 | |
1102884 | 1102884 | 2021-03-09 | Unknown | Illinois | 0 | 245 | |
1106130 | 1106130 | 2021-03-10 | Unknown | Illinois | 0 | 242 | |
1109376 | 1109376 | 2021-03-11 | Unknown | Illinois | 0 | 245 | |
1112622 | 1112622 | 2021-03-12 | Unknown | Illinois | 0 | 250 | |
1115868 | 1115868 | 2021-03-13 | Unknown | Illinois | 0 | 251 | |
1119115 | 1119115 | 2021-03-14 | Unknown | Illinois | 0 | 250 | |
1122362 | 1122362 | 2021-03-15 | Unknown | Illinois | 0 | 248 | |
1125608 | 1125608 | 2021-03-16 | Unknown | Illinois | 0 | 250 | |
1128854 | 1128854 | 2021-03-17 | Unknown | Illinois | 0 | 255 | |
1132102 | 1132102 | 2021-03-18 | Unknown | Illinois | 0 | 253 | |
1135349 | 1135349 | 2021-03-19 | Unknown | Illinois | 0 | 259 | |
1138595 | 1138595 | 2021-03-20 | Unknown | Illinois | 0 | 259 | |
1141841 | 1141841 | 2021-03-21 | Unknown | Illinois | 0 | 265 | |
1145088 | 1145088 | 2021-03-22 | Unknown | Illinois | 0 | 265 | |
1148335 | 1148335 | 2021-03-23 | Unknown | Illinois | 0 | 261 | |
1151582 | 1151582 | 2021-03-24 | Unknown | Illinois | 0 | 258 | |
1154829 | 1154829 | 2021-03-25 | Unknown | Illinois | 0 | 257 | |
1158076 | 1158076 | 2021-03-26 | Unknown | Illinois | 0 | 256 | |
1161324 | 1161324 | 2021-03-27 | Unknown | Illinois | 0 | 257 | |
1164572 | 1164572 | 2021-03-28 | Unknown | Illinois | 0 | 258 | |
1167820 | 1167820 | 2021-03-29 | Unknown | Illinois | 0 | 259 | |
1171068 | 1171068 | 2021-03-30 | Unknown | Illinois | 0 | 257 | |
1174315 | 1174315 | 2021-03-31 | Unknown | Illinois | 0 | 266 | |
1177562 | 1177562 | 2021-04-01 | Unknown | Illinois | 0 | 263 | |
1180809 | 1180809 | 2021-04-02 | Unknown | Illinois | 0 | 265 | |
1184056 | 1184056 | 2021-04-03 | Unknown | Illinois | 0 | 262 | |
1187303 | 1187303 | 2021-04-04 | Unknown | Illinois | 0 | 269 | |
1190550 | 1190550 | 2021-04-05 | Unknown | Illinois | 0 | 265 | |
1193800 | 1193800 | 2021-04-06 | Unknown | Illinois | 0 | 262 | |
1197048 | 1197048 | 2021-04-07 | Unknown | Illinois | 0 | 263 | |
1200297 | 1200297 | 2021-04-08 | Unknown | Illinois | 0 | 267 | |
1203545 | 1203545 | 2021-04-09 | Unknown | Illinois | 0 | 270 | |
1206793 | 1206793 | 2021-04-10 | Unknown | Illinois | 0 | 272 | |
1210042 | 1210042 | 2021-04-11 | Unknown | Illinois | 0 | 273 | |
1213290 | 1213290 | 2021-04-12 | Unknown | Illinois | 0 | 267 | |
1216537 | 1216537 | 2021-04-13 | Unknown | Illinois | 0 | 268 | |
1219785 | 1219785 | 2021-04-14 | Unknown | Illinois | 0 | 278 | |
1223033 | 1223033 | 2021-04-15 | Unknown | Illinois | 0 | 270 | |
1226280 | 1226280 | 2021-04-16 | Unknown | Illinois | 0 | 270 | |
1229528 | 1229528 | 2021-04-17 | Unknown | Illinois | 0 | 274 | |
1232777 | 1232777 | 2021-04-18 | Unknown | Illinois | 0 | 275 | |
1236024 | 1236024 | 2021-04-19 | Unknown | Illinois | 0 | 273 | |
1239271 | 1239271 | 2021-04-20 | Unknown | Illinois | 0 | 275 | |
1242518 | 1242518 | 2021-04-21 | Unknown | Illinois | 0 | 277 | |
1245765 | 1245765 | 2021-04-22 | Unknown | Illinois | 0 | 283 | |
1249012 | 1249012 | 2021-04-23 | Unknown | Illinois | 0 | 287 | |
1252259 | 1252259 | 2021-04-24 | Unknown | Illinois | 0 | 293 | |
1255506 | 1255506 | 2021-04-25 | Unknown | Illinois | 0 | 295 | |
1258753 | 1258753 | 2021-04-26 | Unknown | Illinois | 0 | 295 | |
1262000 | 1262000 | 2021-04-27 | Unknown | Illinois | 0 | 297 | |
1265247 | 1265247 | 2021-04-28 | Unknown | Illinois | 0 | 302 | |
1268494 | 1268494 | 2021-04-29 | Unknown | Illinois | 0 | 306 | |
1271741 | 1271741 | 2021-04-30 | Unknown | Illinois | 0 | 310 | |
1274988 | 1274988 | 2021-05-01 | Unknown | Illinois | 0 | 317 | |
1278235 | 1278235 | 2021-05-02 | Unknown | Illinois | 0 | 318 | |
1281482 | 1281482 | 2021-05-03 | Unknown | Illinois | 0 | 323 | |
1284729 | 1284729 | 2021-05-04 | Unknown | Illinois | 0 | 326 | |
1287975 | 1287975 | 2021-05-05 | Unknown | Illinois | 0 | 326 | |
1291221 | 1291221 | 2021-05-06 | Unknown | Illinois | 0 | 327 | |
1294467 | 1294467 | 2021-05-07 | Unknown | Illinois | 0 | 334 |
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);