ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17043 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716515 | 1716515 | 2021-09-14 | DuPage | Illinois | 17043 | 102512 | 1433 |
1713269 | 1713269 | 2021-09-13 | DuPage | Illinois | 17043 | 102230 | 1433 |
1710022 | 1710022 | 2021-09-12 | DuPage | Illinois | 17043 | 101781 | 1431 |
1706775 | 1706775 | 2021-09-11 | DuPage | Illinois | 17043 | 101781 | 1431 |
1703527 | 1703527 | 2021-09-10 | DuPage | Illinois | 17043 | 101781 | 1431 |
1700277 | 1700277 | 2021-09-09 | DuPage | Illinois | 17043 | 101493 | 1431 |
1697028 | 1697028 | 2021-09-08 | DuPage | Illinois | 17043 | 101319 | 1430 |
1693780 | 1693780 | 2021-09-07 | DuPage | Illinois | 17043 | 101096 | 1430 |
1690531 | 1690531 | 2021-09-06 | DuPage | Illinois | 17043 | 100436 | 1430 |
1687281 | 1687281 | 2021-09-05 | DuPage | Illinois | 17043 | 100436 | 1430 |
1684031 | 1684031 | 2021-09-04 | DuPage | Illinois | 17043 | 100436 | 1430 |
1680780 | 1680780 | 2021-09-03 | DuPage | Illinois | 17043 | 100436 | 1430 |
1677532 | 1677532 | 2021-09-02 | DuPage | Illinois | 17043 | 100120 | 1426 |
1674285 | 1674285 | 2021-09-01 | DuPage | Illinois | 17043 | 99854 | 1425 |
1671036 | 1671036 | 2021-08-31 | DuPage | Illinois | 17043 | 99590 | 1421 |
1667789 | 1667789 | 2021-08-30 | DuPage | Illinois | 17043 | 99315 | 1421 |
1664542 | 1664542 | 2021-08-29 | DuPage | Illinois | 17043 | 98780 | 1421 |
1661294 | 1661294 | 2021-08-28 | DuPage | Illinois | 17043 | 98780 | 1421 |
1658046 | 1658046 | 2021-08-27 | DuPage | Illinois | 17043 | 98780 | 1421 |
1654798 | 1654798 | 2021-08-26 | DuPage | Illinois | 17043 | 98462 | 1419 |
1651551 | 1651551 | 2021-08-25 | DuPage | Illinois | 17043 | 98245 | 1416 |
1648302 | 1648302 | 2021-08-24 | DuPage | Illinois | 17043 | 98022 | 1416 |
1645054 | 1645054 | 2021-08-23 | DuPage | Illinois | 17043 | 97864 | 1415 |
1641805 | 1641805 | 2021-08-22 | DuPage | Illinois | 17043 | 97397 | 1413 |
1638555 | 1638555 | 2021-08-21 | DuPage | Illinois | 17043 | 97397 | 1413 |
1635305 | 1635305 | 2021-08-20 | DuPage | Illinois | 17043 | 97397 | 1413 |
1632055 | 1632055 | 2021-08-19 | DuPage | Illinois | 17043 | 97141 | 1413 |
1628808 | 1628808 | 2021-08-18 | DuPage | Illinois | 17043 | 96987 | 1412 |
1625561 | 1625561 | 2021-08-17 | DuPage | Illinois | 17043 | 96851 | 1411 |
1622314 | 1622314 | 2021-08-16 | DuPage | Illinois | 17043 | 96689 | 1410 |
1619067 | 1619067 | 2021-08-15 | DuPage | Illinois | 17043 | 96160 | 1408 |
1615819 | 1615819 | 2021-08-14 | DuPage | Illinois | 17043 | 96160 | 1408 |
1612570 | 1612570 | 2021-08-13 | DuPage | Illinois | 17043 | 96160 | 1408 |
1609322 | 1609322 | 2021-08-12 | DuPage | Illinois | 17043 | 95914 | 1409 |
1606073 | 1606073 | 2021-08-11 | DuPage | Illinois | 17043 | 95750 | 1408 |
1602824 | 1602824 | 2021-08-10 | DuPage | Illinois | 17043 | 95529 | 1408 |
1599575 | 1599575 | 2021-08-09 | DuPage | Illinois | 17043 | 95374 | 1408 |
1596327 | 1596327 | 2021-08-08 | DuPage | Illinois | 17043 | 94926 | 1407 |
1593078 | 1593078 | 2021-08-07 | DuPage | Illinois | 17043 | 94926 | 1407 |
1589829 | 1589829 | 2021-08-06 | DuPage | Illinois | 17043 | 94926 | 1407 |
1586580 | 1586580 | 2021-08-05 | DuPage | Illinois | 17043 | 94782 | 1407 |
1583330 | 1583330 | 2021-08-04 | DuPage | Illinois | 17043 | 94558 | 1406 |
1580080 | 1580080 | 2021-08-03 | DuPage | Illinois | 17043 | 94445 | 1406 |
1576831 | 1576831 | 2021-08-02 | DuPage | Illinois | 17043 | 94295 | 1406 |
1573583 | 1573583 | 2021-08-01 | DuPage | Illinois | 17043 | 94007 | 1406 |
1570335 | 1570335 | 2021-07-31 | DuPage | Illinois | 17043 | 94007 | 1406 |
1567087 | 1567087 | 2021-07-30 | DuPage | Illinois | 17043 | 94007 | 1406 |
1563839 | 1563839 | 2021-07-29 | DuPage | Illinois | 17043 | 93852 | 1406 |
1560591 | 1560591 | 2021-07-28 | DuPage | Illinois | 17043 | 93753 | 1406 |
1557344 | 1557344 | 2021-07-27 | DuPage | Illinois | 17043 | 93641 | 1406 |
1554097 | 1554097 | 2021-07-26 | DuPage | Illinois | 17043 | 93568 | 1406 |
1550850 | 1550850 | 2021-07-25 | DuPage | Illinois | 17043 | 93353 | 1406 |
1547603 | 1547603 | 2021-07-24 | DuPage | Illinois | 17043 | 93353 | 1406 |
1544356 | 1544356 | 2021-07-23 | DuPage | Illinois | 17043 | 93353 | 1406 |
1541108 | 1541108 | 2021-07-22 | DuPage | Illinois | 17043 | 93274 | 1406 |
1537861 | 1537861 | 2021-07-21 | DuPage | Illinois | 17043 | 93155 | 1406 |
1534613 | 1534613 | 2021-07-20 | DuPage | Illinois | 17043 | 93095 | 1406 |
1531366 | 1531366 | 2021-07-19 | DuPage | Illinois | 17043 | 93057 | 1406 |
1528119 | 1528119 | 2021-07-18 | DuPage | Illinois | 17043 | 92920 | 1406 |
1524872 | 1524872 | 2021-07-17 | DuPage | Illinois | 17043 | 92920 | 1406 |
1521624 | 1521624 | 2021-07-16 | DuPage | Illinois | 17043 | 92920 | 1406 |
1518376 | 1518376 | 2021-07-15 | DuPage | Illinois | 17043 | 92888 | 1406 |
1515129 | 1515129 | 2021-07-14 | DuPage | Illinois | 17043 | 92846 | 1406 |
1511883 | 1511883 | 2021-07-13 | DuPage | Illinois | 17043 | 92808 | 1406 |
1508636 | 1508636 | 2021-07-12 | DuPage | Illinois | 17043 | 92788 | 1406 |
1505390 | 1505390 | 2021-07-11 | DuPage | Illinois | 17043 | 92713 | 1405 |
1502144 | 1502144 | 2021-07-10 | DuPage | Illinois | 17043 | 92713 | 1405 |
1498898 | 1498898 | 2021-07-09 | DuPage | Illinois | 17043 | 92713 | 1405 |
1495651 | 1495651 | 2021-07-08 | DuPage | Illinois | 17043 | 92688 | 1405 |
1492405 | 1492405 | 2021-07-07 | DuPage | Illinois | 17043 | 92668 | 1405 |
1489158 | 1489158 | 2021-07-06 | DuPage | Illinois | 17043 | 92651 | 1406 |
1485911 | 1485911 | 2021-07-05 | DuPage | Illinois | 17043 | 92595 | 1405 |
1482665 | 1482665 | 2021-07-04 | DuPage | Illinois | 17043 | 92595 | 1405 |
1479418 | 1479418 | 2021-07-03 | DuPage | Illinois | 17043 | 92595 | 1405 |
1476172 | 1476172 | 2021-07-02 | DuPage | Illinois | 17043 | 92595 | 1405 |
1472926 | 1472926 | 2021-07-01 | DuPage | Illinois | 17043 | 92579 | 1406 |
1469680 | 1469680 | 2021-06-30 | DuPage | Illinois | 17043 | 92565 | 1406 |
1466435 | 1466435 | 2021-06-29 | DuPage | Illinois | 17043 | 92561 | 1410 |
1463190 | 1463190 | 2021-06-28 | DuPage | Illinois | 17043 | 92547 | 1410 |
1459945 | 1459945 | 2021-06-27 | DuPage | Illinois | 17043 | 92473 | 1410 |
1456700 | 1456700 | 2021-06-26 | DuPage | Illinois | 17043 | 92473 | 1410 |
1453455 | 1453455 | 2021-06-25 | DuPage | Illinois | 17043 | 92473 | 1410 |
1450209 | 1450209 | 2021-06-24 | DuPage | Illinois | 17043 | 92446 | 1408 |
1446964 | 1446964 | 2021-06-23 | DuPage | Illinois | 17043 | 92446 | 1407 |
1443719 | 1443719 | 2021-06-22 | DuPage | Illinois | 17043 | 92425 | 1404 |
1440474 | 1440474 | 2021-06-21 | DuPage | Illinois | 17043 | 92413 | 1403 |
1437227 | 1437227 | 2021-06-20 | DuPage | Illinois | 17043 | 92368 | 1401 |
1433980 | 1433980 | 2021-06-19 | DuPage | Illinois | 17043 | 92368 | 1401 |
1430734 | 1430734 | 2021-06-18 | DuPage | Illinois | 17043 | 92368 | 1401 |
1427489 | 1427489 | 2021-06-17 | DuPage | Illinois | 17043 | 92362 | 1401 |
1424244 | 1424244 | 2021-06-16 | DuPage | Illinois | 17043 | 92351 | 1401 |
1420996 | 1420996 | 2021-06-15 | DuPage | Illinois | 17043 | 92328 | 1401 |
1417751 | 1417751 | 2021-06-14 | DuPage | Illinois | 17043 | 92318 | 1403 |
1414505 | 1414505 | 2021-06-13 | DuPage | Illinois | 17043 | 92309 | 1403 |
1411260 | 1411260 | 2021-06-12 | DuPage | Illinois | 17043 | 92297 | 1403 |
1408015 | 1408015 | 2021-06-11 | DuPage | Illinois | 17043 | 92281 | 1403 |
1404769 | 1404769 | 2021-06-10 | DuPage | Illinois | 17043 | 92264 | 1401 |
1401524 | 1401524 | 2021-06-09 | DuPage | Illinois | 17043 | 92249 | 1398 |
1398279 | 1398279 | 2021-06-08 | DuPage | Illinois | 17043 | 92213 | 1397 |
1395032 | 1395032 | 2021-06-07 | DuPage | Illinois | 17043 | 92170 | 1395 |
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);