ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

631 rows where fips = 17031 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

  • 17031 · 631 ✖

county

Link rowid date ▲ county state fips cases deaths
1817231 1817231 2021-10-15 Cook Illinois 17031 631261 11723
1813983 1813983 2021-10-14 Cook Illinois 17031 630542 11712
1810734 1810734 2021-10-13 Cook Illinois 17031 629834 11700
1807485 1807485 2021-10-12 Cook Illinois 17031 628979 11682
1804234 1804234 2021-10-11 Cook Illinois 17031 626475 11664
1800985 1800985 2021-10-10 Cook Illinois 17031 626475 11664
1797736 1797736 2021-10-09 Cook Illinois 17031 626475 11664
1794487 1794487 2021-10-08 Cook Illinois 17031 626475 11664
1791239 1791239 2021-10-07 Cook Illinois 17031 625647 11651
1787990 1787990 2021-10-06 Cook Illinois 17031 624557 11644
1784741 1784741 2021-10-05 Cook Illinois 17031 623750 11634
1781492 1781492 2021-10-04 Cook Illinois 17031 622884 11622
1778242 1778242 2021-10-03 Cook Illinois 17031 620602 11603
1774992 1774992 2021-10-02 Cook Illinois 17031 620602 11603
1771742 1771742 2021-10-01 Cook Illinois 17031 620602 11603
1768493 1768493 2021-09-30 Cook Illinois 17031 619576 11595
1765244 1765244 2021-09-29 Cook Illinois 17031 618610 11584
1761995 1761995 2021-09-28 Cook Illinois 17031 617846 11580
1758747 1758747 2021-09-27 Cook Illinois 17031 617360 11563
1755499 1755499 2021-09-26 Cook Illinois 17031 615436 11542
1752251 1752251 2021-09-25 Cook Illinois 17031 615436 11542
1749002 1749002 2021-09-24 Cook Illinois 17031 615436 11542
1745752 1745752 2021-09-23 Cook Illinois 17031 614487 11525
1742503 1742503 2021-09-22 Cook Illinois 17031 613549 11519
1739254 1739254 2021-09-21 Cook Illinois 17031 612610 11508
1736005 1736005 2021-09-20 Cook Illinois 17031 611852 11503
1732755 1732755 2021-09-19 Cook Illinois 17031 609376 11480
1729505 1729505 2021-09-18 Cook Illinois 17031 609376 11480
1726255 1726255 2021-09-17 Cook Illinois 17031 609376 11480
1723006 1723006 2021-09-16 Cook Illinois 17031 608383 11463
1719757 1719757 2021-09-15 Cook Illinois 17031 607266 11457
1716509 1716509 2021-09-14 Cook Illinois 17031 606266 11448
1713263 1713263 2021-09-13 Cook Illinois 17031 605061 11432
1710016 1710016 2021-09-12 Cook Illinois 17031 602648 11405
1706769 1706769 2021-09-11 Cook Illinois 17031 602648 11405
1703521 1703521 2021-09-10 Cook Illinois 17031 602648 11405
1700271 1700271 2021-09-09 Cook Illinois 17031 601238 11396
1697022 1697022 2021-09-08 Cook Illinois 17031 600122 11393
1693774 1693774 2021-09-07 Cook Illinois 17031 599101 11371
1690525 1690525 2021-09-06 Cook Illinois 17031 595861 11351
1687275 1687275 2021-09-05 Cook Illinois 17031 595861 11351
1684025 1684025 2021-09-04 Cook Illinois 17031 595861 11351
1680774 1680774 2021-09-03 Cook Illinois 17031 595861 11351
1677526 1677526 2021-09-02 Cook Illinois 17031 594250 11342
1674279 1674279 2021-09-01 Cook Illinois 17031 593219 11313
1671030 1671030 2021-08-31 Cook Illinois 17031 592050 11304
1667783 1667783 2021-08-30 Cook Illinois 17031 590825 11294
1664536 1664536 2021-08-29 Cook Illinois 17031 588099 11288
1661288 1661288 2021-08-28 Cook Illinois 17031 588099 11288
1658040 1658040 2021-08-27 Cook Illinois 17031 588099 11288
1654792 1654792 2021-08-26 Cook Illinois 17031 586687 11282
1651545 1651545 2021-08-25 Cook Illinois 17031 585612 11257
1648296 1648296 2021-08-24 Cook Illinois 17031 584459 11245
1645048 1645048 2021-08-23 Cook Illinois 17031 583679 11237
1641799 1641799 2021-08-22 Cook Illinois 17031 581027 11222
1638549 1638549 2021-08-21 Cook Illinois 17031 581027 11222
1635299 1635299 2021-08-20 Cook Illinois 17031 581027 11222
1632049 1632049 2021-08-19 Cook Illinois 17031 579716 11216
1628802 1628802 2021-08-18 Cook Illinois 17031 578907 11211
1625555 1625555 2021-08-17 Cook Illinois 17031 578015 11196
1622308 1622308 2021-08-16 Cook Illinois 17031 577187 11186
1619061 1619061 2021-08-15 Cook Illinois 17031 574316 11179
1615813 1615813 2021-08-14 Cook Illinois 17031 574316 11179
1612564 1612564 2021-08-13 Cook Illinois 17031 574316 11179
1609316 1609316 2021-08-12 Cook Illinois 17031 573445 11170
1606067 1606067 2021-08-11 Cook Illinois 17031 572726 11165
1602818 1602818 2021-08-10 Cook Illinois 17031 571693 11164
1599569 1599569 2021-08-09 Cook Illinois 17031 571012 11156
1596321 1596321 2021-08-08 Cook Illinois 17031 568822 11147
1593072 1593072 2021-08-07 Cook Illinois 17031 568822 11147
1589823 1589823 2021-08-06 Cook Illinois 17031 568822 11147
1586574 1586574 2021-08-05 Cook Illinois 17031 567872 11140
1583324 1583324 2021-08-04 Cook Illinois 17031 566985 11136
1580074 1580074 2021-08-03 Cook Illinois 17031 566466 11131
1576825 1576825 2021-08-02 Cook Illinois 17031 565780 11127
1573577 1573577 2021-08-01 Cook Illinois 17031 564091 11121
1570329 1570329 2021-07-31 Cook Illinois 17031 564091 11121
1567081 1567081 2021-07-30 Cook Illinois 17031 564091 11121
1563833 1563833 2021-07-29 Cook Illinois 17031 563452 11119
1560585 1560585 2021-07-28 Cook Illinois 17031 563084 11114
1557338 1557338 2021-07-27 Cook Illinois 17031 562540 11112
1554091 1554091 2021-07-26 Cook Illinois 17031 562216 11109
1550844 1550844 2021-07-25 Cook Illinois 17031 561168 11108
1547597 1547597 2021-07-24 Cook Illinois 17031 561168 11108
1544350 1544350 2021-07-23 Cook Illinois 17031 561168 11108
1541102 1541102 2021-07-22 Cook Illinois 17031 560675 11107
1537855 1537855 2021-07-21 Cook Illinois 17031 560155 11105
1534607 1534607 2021-07-20 Cook Illinois 17031 559884 11105
1531360 1531360 2021-07-19 Cook Illinois 17031 559767 11102
1528113 1528113 2021-07-18 Cook Illinois 17031 558928 11094
1524866 1524866 2021-07-17 Cook Illinois 17031 558928 11094
1521618 1521618 2021-07-16 Cook Illinois 17031 558928 11094
1518370 1518370 2021-07-15 Cook Illinois 17031 558781 11093
1515123 1515123 2021-07-14 Cook Illinois 17031 558563 11091
1511877 1511877 2021-07-13 Cook Illinois 17031 558394 11091
1508630 1508630 2021-07-12 Cook Illinois 17031 558286 11084
1505384 1505384 2021-07-11 Cook Illinois 17031 557922 11077
1502138 1502138 2021-07-10 Cook Illinois 17031 557922 11077
1498892 1498892 2021-07-09 Cook Illinois 17031 557922 11077
1495645 1495645 2021-07-08 Cook Illinois 17031 557740 11074

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);