ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where deaths = 22, fips = 17087 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1586602 | 1586602 | 2021-08-05 | Johnson | Illinois | 17087 | 1613 | 22 |
1583352 | 1583352 | 2021-08-04 | Johnson | Illinois | 17087 | 1603 | 22 |
1580102 | 1580102 | 2021-08-03 | Johnson | Illinois | 17087 | 1594 | 22 |
1576853 | 1576853 | 2021-08-02 | Johnson | Illinois | 17087 | 1585 | 22 |
1573605 | 1573605 | 2021-08-01 | Johnson | Illinois | 17087 | 1567 | 22 |
1570357 | 1570357 | 2021-07-31 | Johnson | Illinois | 17087 | 1567 | 22 |
1567109 | 1567109 | 2021-07-30 | Johnson | Illinois | 17087 | 1567 | 22 |
1563861 | 1563861 | 2021-07-29 | Johnson | Illinois | 17087 | 1559 | 22 |
1560613 | 1560613 | 2021-07-28 | Johnson | Illinois | 17087 | 1554 | 22 |
1557366 | 1557366 | 2021-07-27 | Johnson | Illinois | 17087 | 1545 | 22 |
1554119 | 1554119 | 2021-07-26 | Johnson | Illinois | 17087 | 1536 | 22 |
1550872 | 1550872 | 2021-07-25 | Johnson | Illinois | 17087 | 1525 | 22 |
1547625 | 1547625 | 2021-07-24 | Johnson | Illinois | 17087 | 1525 | 22 |
1544378 | 1544378 | 2021-07-23 | Johnson | Illinois | 17087 | 1525 | 22 |
1541130 | 1541130 | 2021-07-22 | Johnson | Illinois | 17087 | 1520 | 22 |
1537883 | 1537883 | 2021-07-21 | Johnson | Illinois | 17087 | 1517 | 22 |
1534635 | 1534635 | 2021-07-20 | Johnson | Illinois | 17087 | 1516 | 22 |
1531388 | 1531388 | 2021-07-19 | Johnson | Illinois | 17087 | 1510 | 22 |
1528141 | 1528141 | 2021-07-18 | Johnson | Illinois | 17087 | 1502 | 22 |
1524894 | 1524894 | 2021-07-17 | Johnson | Illinois | 17087 | 1502 | 22 |
1521646 | 1521646 | 2021-07-16 | Johnson | Illinois | 17087 | 1502 | 22 |
1518398 | 1518398 | 2021-07-15 | Johnson | Illinois | 17087 | 1501 | 22 |
1515151 | 1515151 | 2021-07-14 | Johnson | Illinois | 17087 | 1497 | 22 |
1511905 | 1511905 | 2021-07-13 | Johnson | Illinois | 17087 | 1493 | 22 |
1508658 | 1508658 | 2021-07-12 | Johnson | Illinois | 17087 | 1493 | 22 |
1505412 | 1505412 | 2021-07-11 | Johnson | Illinois | 17087 | 1491 | 22 |
1502166 | 1502166 | 2021-07-10 | Johnson | Illinois | 17087 | 1491 | 22 |
1498920 | 1498920 | 2021-07-09 | Johnson | Illinois | 17087 | 1491 | 22 |
1495673 | 1495673 | 2021-07-08 | Johnson | Illinois | 17087 | 1491 | 22 |
1492427 | 1492427 | 2021-07-07 | Johnson | Illinois | 17087 | 1488 | 22 |
1489180 | 1489180 | 2021-07-06 | Johnson | Illinois | 17087 | 1483 | 22 |
1485933 | 1485933 | 2021-07-05 | Johnson | Illinois | 17087 | 1482 | 22 |
1482687 | 1482687 | 2021-07-04 | Johnson | Illinois | 17087 | 1482 | 22 |
1479440 | 1479440 | 2021-07-03 | Johnson | Illinois | 17087 | 1482 | 22 |
1476194 | 1476194 | 2021-07-02 | Johnson | Illinois | 17087 | 1482 | 22 |
1472948 | 1472948 | 2021-07-01 | Johnson | Illinois | 17087 | 1483 | 22 |
1469702 | 1469702 | 2021-06-30 | Johnson | Illinois | 17087 | 1483 | 22 |
1466457 | 1466457 | 2021-06-29 | Johnson | Illinois | 17087 | 1482 | 22 |
1463212 | 1463212 | 2021-06-28 | Johnson | Illinois | 17087 | 1481 | 22 |
1459967 | 1459967 | 2021-06-27 | Johnson | Illinois | 17087 | 1481 | 22 |
1456722 | 1456722 | 2021-06-26 | Johnson | Illinois | 17087 | 1481 | 22 |
1453477 | 1453477 | 2021-06-25 | Johnson | Illinois | 17087 | 1481 | 22 |
1450231 | 1450231 | 2021-06-24 | Johnson | Illinois | 17087 | 1481 | 22 |
1446986 | 1446986 | 2021-06-23 | Johnson | Illinois | 17087 | 1481 | 22 |
1443741 | 1443741 | 2021-06-22 | Johnson | Illinois | 17087 | 1481 | 22 |
1440496 | 1440496 | 2021-06-21 | Johnson | Illinois | 17087 | 1481 | 22 |
1437249 | 1437249 | 2021-06-20 | Johnson | Illinois | 17087 | 1476 | 22 |
1434002 | 1434002 | 2021-06-19 | Johnson | Illinois | 17087 | 1476 | 22 |
1430756 | 1430756 | 2021-06-18 | Johnson | Illinois | 17087 | 1476 | 22 |
1427511 | 1427511 | 2021-06-17 | Johnson | Illinois | 17087 | 1473 | 22 |
1424266 | 1424266 | 2021-06-16 | Johnson | Illinois | 17087 | 1472 | 22 |
1421018 | 1421018 | 2021-06-15 | Johnson | Illinois | 17087 | 1472 | 22 |
1417773 | 1417773 | 2021-06-14 | Johnson | Illinois | 17087 | 1473 | 22 |
1414527 | 1414527 | 2021-06-13 | Johnson | Illinois | 17087 | 1473 | 22 |
1411282 | 1411282 | 2021-06-12 | Johnson | Illinois | 17087 | 1473 | 22 |
1408037 | 1408037 | 2021-06-11 | Johnson | Illinois | 17087 | 1472 | 22 |
1404791 | 1404791 | 2021-06-10 | Johnson | Illinois | 17087 | 1472 | 22 |
1401546 | 1401546 | 2021-06-09 | Johnson | Illinois | 17087 | 1472 | 22 |
1398301 | 1398301 | 2021-06-08 | Johnson | Illinois | 17087 | 1472 | 22 |
1395054 | 1395054 | 2021-06-07 | Johnson | Illinois | 17087 | 1470 | 22 |
1391809 | 1391809 | 2021-06-06 | Johnson | Illinois | 17087 | 1470 | 22 |
1388564 | 1388564 | 2021-06-05 | Johnson | Illinois | 17087 | 1470 | 22 |
1385319 | 1385319 | 2021-06-04 | Johnson | Illinois | 17087 | 1469 | 22 |
1382073 | 1382073 | 2021-06-03 | Johnson | Illinois | 17087 | 1468 | 22 |
1378828 | 1378828 | 2021-06-02 | Johnson | Illinois | 17087 | 1467 | 22 |
1375582 | 1375582 | 2021-06-01 | Johnson | Illinois | 17087 | 1466 | 22 |
1372337 | 1372337 | 2021-05-31 | Johnson | Illinois | 17087 | 1466 | 22 |
1369092 | 1369092 | 2021-05-30 | Johnson | Illinois | 17087 | 1466 | 22 |
1365846 | 1365846 | 2021-05-29 | Johnson | Illinois | 17087 | 1464 | 22 |
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);