ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 17131 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417795 | 1417795 | 2021-06-14 | Mercer | Illinois | 17131 | 1493 | 34 |
1414549 | 1414549 | 2021-06-13 | Mercer | Illinois | 17131 | 1493 | 34 |
1411304 | 1411304 | 2021-06-12 | Mercer | Illinois | 17131 | 1492 | 34 |
1408059 | 1408059 | 2021-06-11 | Mercer | Illinois | 17131 | 1492 | 34 |
1404813 | 1404813 | 2021-06-10 | Mercer | Illinois | 17131 | 1492 | 34 |
1401568 | 1401568 | 2021-06-09 | Mercer | Illinois | 17131 | 1492 | 34 |
1398323 | 1398323 | 2021-06-08 | Mercer | Illinois | 17131 | 1492 | 34 |
1395076 | 1395076 | 2021-06-07 | Mercer | Illinois | 17131 | 1488 | 34 |
1391831 | 1391831 | 2021-06-06 | Mercer | Illinois | 17131 | 1488 | 34 |
1388586 | 1388586 | 2021-06-05 | Mercer | Illinois | 17131 | 1488 | 34 |
1385341 | 1385341 | 2021-06-04 | Mercer | Illinois | 17131 | 1488 | 34 |
1382095 | 1382095 | 2021-06-03 | Mercer | Illinois | 17131 | 1488 | 34 |
1378850 | 1378850 | 2021-06-02 | Mercer | Illinois | 17131 | 1488 | 34 |
1375604 | 1375604 | 2021-06-01 | Mercer | Illinois | 17131 | 1487 | 34 |
1372359 | 1372359 | 2021-05-31 | Mercer | Illinois | 17131 | 1487 | 34 |
1369114 | 1369114 | 2021-05-30 | Mercer | Illinois | 17131 | 1487 | 34 |
1365868 | 1365868 | 2021-05-29 | Mercer | Illinois | 17131 | 1487 | 34 |
1362622 | 1362622 | 2021-05-28 | Mercer | Illinois | 17131 | 1487 | 34 |
1359375 | 1359375 | 2021-05-27 | Mercer | Illinois | 17131 | 1486 | 34 |
1356129 | 1356129 | 2021-05-26 | Mercer | Illinois | 17131 | 1485 | 33 |
1352883 | 1352883 | 2021-05-25 | Mercer | Illinois | 17131 | 1484 | 33 |
1349637 | 1349637 | 2021-05-24 | Mercer | Illinois | 17131 | 1481 | 33 |
1346390 | 1346390 | 2021-05-23 | Mercer | Illinois | 17131 | 1480 | 33 |
1343142 | 1343142 | 2021-05-22 | Mercer | Illinois | 17131 | 1480 | 33 |
1339894 | 1339894 | 2021-05-21 | Mercer | Illinois | 17131 | 1479 | 33 |
1336647 | 1336647 | 2021-05-20 | Mercer | Illinois | 17131 | 1479 | 33 |
1333400 | 1333400 | 2021-05-19 | Mercer | Illinois | 17131 | 1478 | 33 |
1330153 | 1330153 | 2021-05-18 | Mercer | Illinois | 17131 | 1476 | 33 |
1326906 | 1326906 | 2021-05-17 | Mercer | Illinois | 17131 | 1475 | 33 |
1323660 | 1323660 | 2021-05-16 | Mercer | Illinois | 17131 | 1475 | 33 |
1320414 | 1320414 | 2021-05-15 | Mercer | Illinois | 17131 | 1473 | 33 |
1317167 | 1317167 | 2021-05-14 | Mercer | Illinois | 17131 | 1470 | 33 |
1313920 | 1313920 | 2021-05-13 | Mercer | Illinois | 17131 | 1469 | 33 |
1310673 | 1310673 | 2021-05-12 | Mercer | Illinois | 17131 | 1466 | 33 |
1307427 | 1307427 | 2021-05-11 | Mercer | Illinois | 17131 | 1464 | 33 |
1304181 | 1304181 | 2021-05-10 | Mercer | Illinois | 17131 | 1461 | 33 |
1300934 | 1300934 | 2021-05-09 | Mercer | Illinois | 17131 | 1456 | 33 |
1297687 | 1297687 | 2021-05-08 | Mercer | Illinois | 17131 | 1456 | 33 |
1294441 | 1294441 | 2021-05-07 | Mercer | Illinois | 17131 | 1451 | 33 |
1291195 | 1291195 | 2021-05-06 | Mercer | Illinois | 17131 | 1448 | 33 |
1287949 | 1287949 | 2021-05-05 | Mercer | Illinois | 17131 | 1443 | 33 |
1284703 | 1284703 | 2021-05-04 | Mercer | Illinois | 17131 | 1438 | 33 |
1281456 | 1281456 | 2021-05-03 | Mercer | Illinois | 17131 | 1426 | 33 |
1278209 | 1278209 | 2021-05-02 | Mercer | Illinois | 17131 | 1423 | 33 |
1274962 | 1274962 | 2021-05-01 | Mercer | Illinois | 17131 | 1421 | 33 |
1271715 | 1271715 | 2021-04-30 | Mercer | Illinois | 17131 | 1414 | 33 |
1268468 | 1268468 | 2021-04-29 | Mercer | Illinois | 17131 | 1410 | 33 |
1265221 | 1265221 | 2021-04-28 | Mercer | Illinois | 17131 | 1401 | 33 |
1261974 | 1261974 | 2021-04-27 | Mercer | Illinois | 17131 | 1394 | 33 |
1258727 | 1258727 | 2021-04-26 | Mercer | Illinois | 17131 | 1391 | 33 |
1255480 | 1255480 | 2021-04-25 | Mercer | Illinois | 17131 | 1387 | 33 |
1252233 | 1252233 | 2021-04-24 | Mercer | Illinois | 17131 | 1387 | 33 |
1248986 | 1248986 | 2021-04-23 | Mercer | Illinois | 17131 | 1381 | 33 |
1245739 | 1245739 | 2021-04-22 | Mercer | Illinois | 17131 | 1373 | 33 |
1242492 | 1242492 | 2021-04-21 | Mercer | Illinois | 17131 | 1369 | 33 |
1239245 | 1239245 | 2021-04-20 | Mercer | Illinois | 17131 | 1363 | 33 |
1235998 | 1235998 | 2021-04-19 | Mercer | Illinois | 17131 | 1354 | 33 |
1232751 | 1232751 | 2021-04-18 | Mercer | Illinois | 17131 | 1353 | 33 |
1229502 | 1229502 | 2021-04-17 | Mercer | Illinois | 17131 | 1352 | 33 |
1226254 | 1226254 | 2021-04-16 | Mercer | Illinois | 17131 | 1350 | 33 |
1223007 | 1223007 | 2021-04-15 | Mercer | Illinois | 17131 | 1350 | 33 |
1219759 | 1219759 | 2021-04-14 | Mercer | Illinois | 17131 | 1346 | 33 |
1216511 | 1216511 | 2021-04-13 | Mercer | Illinois | 17131 | 1344 | 33 |
1213264 | 1213264 | 2021-04-12 | Mercer | Illinois | 17131 | 1339 | 33 |
1210016 | 1210016 | 2021-04-11 | Mercer | Illinois | 17131 | 1339 | 33 |
1206767 | 1206767 | 2021-04-10 | Mercer | Illinois | 17131 | 1338 | 33 |
1203519 | 1203519 | 2021-04-09 | Mercer | Illinois | 17131 | 1337 | 33 |
1200271 | 1200271 | 2021-04-08 | Mercer | Illinois | 17131 | 1331 | 33 |
1197022 | 1197022 | 2021-04-07 | Mercer | Illinois | 17131 | 1330 | 33 |
1193774 | 1193774 | 2021-04-06 | Mercer | Illinois | 17131 | 1327 | 33 |
1190524 | 1190524 | 2021-04-05 | Mercer | Illinois | 17131 | 1324 | 33 |
1187277 | 1187277 | 2021-04-04 | Mercer | Illinois | 17131 | 1323 | 33 |
1184030 | 1184030 | 2021-04-03 | Mercer | Illinois | 17131 | 1323 | 33 |
1180783 | 1180783 | 2021-04-02 | Mercer | Illinois | 17131 | 1322 | 33 |
1177536 | 1177536 | 2021-04-01 | Mercer | Illinois | 17131 | 1322 | 33 |
1174289 | 1174289 | 2021-03-31 | Mercer | Illinois | 17131 | 1320 | 33 |
1171042 | 1171042 | 2021-03-30 | Mercer | Illinois | 17131 | 1318 | 33 |
1167794 | 1167794 | 2021-03-29 | Mercer | Illinois | 17131 | 1317 | 33 |
1164546 | 1164546 | 2021-03-28 | Mercer | Illinois | 17131 | 1316 | 33 |
1161298 | 1161298 | 2021-03-27 | Mercer | Illinois | 17131 | 1313 | 33 |
1158050 | 1158050 | 2021-03-26 | Mercer | Illinois | 17131 | 1313 | 33 |
1154803 | 1154803 | 2021-03-25 | Mercer | Illinois | 17131 | 1312 | 33 |
1151556 | 1151556 | 2021-03-24 | Mercer | Illinois | 17131 | 1310 | 33 |
1148309 | 1148309 | 2021-03-23 | Mercer | Illinois | 17131 | 1306 | 33 |
1145062 | 1145062 | 2021-03-22 | Mercer | Illinois | 17131 | 1302 | 33 |
1141815 | 1141815 | 2021-03-21 | Mercer | Illinois | 17131 | 1301 | 33 |
1138569 | 1138569 | 2021-03-20 | Mercer | Illinois | 17131 | 1300 | 33 |
1135323 | 1135323 | 2021-03-19 | Mercer | Illinois | 17131 | 1299 | 33 |
1132076 | 1132076 | 2021-03-18 | Mercer | Illinois | 17131 | 1297 | 33 |
1128828 | 1128828 | 2021-03-17 | Mercer | Illinois | 17131 | 1297 | 33 |
1125582 | 1125582 | 2021-03-16 | Mercer | Illinois | 17131 | 1297 | 33 |
1122336 | 1122336 | 2021-03-15 | Mercer | Illinois | 17131 | 1297 | 33 |
1119089 | 1119089 | 2021-03-14 | Mercer | Illinois | 17131 | 1295 | 33 |
1115842 | 1115842 | 2021-03-13 | Mercer | Illinois | 17131 | 1295 | 33 |
1112596 | 1112596 | 2021-03-12 | Mercer | Illinois | 17131 | 1295 | 33 |
1109350 | 1109350 | 2021-03-11 | Mercer | Illinois | 17131 | 1295 | 33 |
1106104 | 1106104 | 2021-03-10 | Mercer | Illinois | 17131 | 1294 | 33 |
1102858 | 1102858 | 2021-03-09 | Mercer | Illinois | 17131 | 1291 | 33 |
1099612 | 1099612 | 2021-03-08 | Mercer | Illinois | 17131 | 1290 | 33 |
1096364 | 1096364 | 2021-03-07 | Mercer | Illinois | 17131 | 1289 | 33 |
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);