ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Franklin" and fips = 17055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1830239 | 1830239 | 2021-10-19 | Franklin | Illinois | 17055 | 7319 | 127 |
1826990 | 1826990 | 2021-10-18 | Franklin | Illinois | 17055 | 7317 | 127 |
1823741 | 1823741 | 2021-10-17 | Franklin | Illinois | 17055 | 7276 | 126 |
1820492 | 1820492 | 2021-10-16 | Franklin | Illinois | 17055 | 7276 | 126 |
1817243 | 1817243 | 2021-10-15 | Franklin | Illinois | 17055 | 7276 | 126 |
1813995 | 1813995 | 2021-10-14 | Franklin | Illinois | 17055 | 7267 | 125 |
1810746 | 1810746 | 2021-10-13 | Franklin | Illinois | 17055 | 7256 | 125 |
1807497 | 1807497 | 2021-10-12 | Franklin | Illinois | 17055 | 7249 | 123 |
1804246 | 1804246 | 2021-10-11 | Franklin | Illinois | 17055 | 7200 | 120 |
1800997 | 1800997 | 2021-10-10 | Franklin | Illinois | 17055 | 7200 | 120 |
1797748 | 1797748 | 2021-10-09 | Franklin | Illinois | 17055 | 7200 | 120 |
1794499 | 1794499 | 2021-10-08 | Franklin | Illinois | 17055 | 7200 | 120 |
1791251 | 1791251 | 2021-10-07 | Franklin | Illinois | 17055 | 7175 | 118 |
1788002 | 1788002 | 2021-10-06 | Franklin | Illinois | 17055 | 7155 | 117 |
1784753 | 1784753 | 2021-10-05 | Franklin | Illinois | 17055 | 7149 | 117 |
1781504 | 1781504 | 2021-10-04 | Franklin | Illinois | 17055 | 7142 | 117 |
1778254 | 1778254 | 2021-10-03 | Franklin | Illinois | 17055 | 7086 | 115 |
1775004 | 1775004 | 2021-10-02 | Franklin | Illinois | 17055 | 7086 | 115 |
1771754 | 1771754 | 2021-10-01 | Franklin | Illinois | 17055 | 7086 | 115 |
1768505 | 1768505 | 2021-09-30 | Franklin | Illinois | 17055 | 7059 | 114 |
1765256 | 1765256 | 2021-09-29 | Franklin | Illinois | 17055 | 7035 | 112 |
1762007 | 1762007 | 2021-09-28 | Franklin | Illinois | 17055 | 7020 | 112 |
1758759 | 1758759 | 2021-09-27 | Franklin | Illinois | 17055 | 7007 | 112 |
1755511 | 1755511 | 2021-09-26 | Franklin | Illinois | 17055 | 6939 | 111 |
1752263 | 1752263 | 2021-09-25 | Franklin | Illinois | 17055 | 6939 | 111 |
1749014 | 1749014 | 2021-09-24 | Franklin | Illinois | 17055 | 6939 | 111 |
1745764 | 1745764 | 2021-09-23 | Franklin | Illinois | 17055 | 6913 | 111 |
1742515 | 1742515 | 2021-09-22 | Franklin | Illinois | 17055 | 6868 | 111 |
1739266 | 1739266 | 2021-09-21 | Franklin | Illinois | 17055 | 6846 | 108 |
1736017 | 1736017 | 2021-09-20 | Franklin | Illinois | 17055 | 6805 | 108 |
1732767 | 1732767 | 2021-09-19 | Franklin | Illinois | 17055 | 6696 | 106 |
1729517 | 1729517 | 2021-09-18 | Franklin | Illinois | 17055 | 6696 | 106 |
1726267 | 1726267 | 2021-09-17 | Franklin | Illinois | 17055 | 6696 | 106 |
1723018 | 1723018 | 2021-09-16 | Franklin | Illinois | 17055 | 6647 | 106 |
1719769 | 1719769 | 2021-09-15 | Franklin | Illinois | 17055 | 6589 | 106 |
1716521 | 1716521 | 2021-09-14 | Franklin | Illinois | 17055 | 6556 | 105 |
1713275 | 1713275 | 2021-09-13 | Franklin | Illinois | 17055 | 6524 | 105 |
1710028 | 1710028 | 2021-09-12 | Franklin | Illinois | 17055 | 6420 | 99 |
1706781 | 1706781 | 2021-09-11 | Franklin | Illinois | 17055 | 6420 | 99 |
1703533 | 1703533 | 2021-09-10 | Franklin | Illinois | 17055 | 6420 | 99 |
1700283 | 1700283 | 2021-09-09 | Franklin | Illinois | 17055 | 6381 | 99 |
1697034 | 1697034 | 2021-09-08 | Franklin | Illinois | 17055 | 6351 | 99 |
1693786 | 1693786 | 2021-09-07 | Franklin | Illinois | 17055 | 6326 | 99 |
1690537 | 1690537 | 2021-09-06 | Franklin | Illinois | 17055 | 6202 | 98 |
1687287 | 1687287 | 2021-09-05 | Franklin | Illinois | 17055 | 6202 | 98 |
1684037 | 1684037 | 2021-09-04 | Franklin | Illinois | 17055 | 6202 | 98 |
1680786 | 1680786 | 2021-09-03 | Franklin | Illinois | 17055 | 6202 | 98 |
1677538 | 1677538 | 2021-09-02 | Franklin | Illinois | 17055 | 6145 | 97 |
1674291 | 1674291 | 2021-09-01 | Franklin | Illinois | 17055 | 6114 | 97 |
1671042 | 1671042 | 2021-08-31 | Franklin | Illinois | 17055 | 6057 | 97 |
1667795 | 1667795 | 2021-08-30 | Franklin | Illinois | 17055 | 5997 | 97 |
1664548 | 1664548 | 2021-08-29 | Franklin | Illinois | 17055 | 5893 | 96 |
1661300 | 1661300 | 2021-08-28 | Franklin | Illinois | 17055 | 5893 | 96 |
1658052 | 1658052 | 2021-08-27 | Franklin | Illinois | 17055 | 5893 | 96 |
1654804 | 1654804 | 2021-08-26 | Franklin | Illinois | 17055 | 5848 | 96 |
1651557 | 1651557 | 2021-08-25 | Franklin | Illinois | 17055 | 5814 | 95 |
1648308 | 1648308 | 2021-08-24 | Franklin | Illinois | 17055 | 5784 | 95 |
1645060 | 1645060 | 2021-08-23 | Franklin | Illinois | 17055 | 5752 | 95 |
1641811 | 1641811 | 2021-08-22 | Franklin | Illinois | 17055 | 5641 | 95 |
1638561 | 1638561 | 2021-08-21 | Franklin | Illinois | 17055 | 5641 | 95 |
1635311 | 1635311 | 2021-08-20 | Franklin | Illinois | 17055 | 5641 | 95 |
1632061 | 1632061 | 2021-08-19 | Franklin | Illinois | 17055 | 5569 | 95 |
1628814 | 1628814 | 2021-08-18 | Franklin | Illinois | 17055 | 5537 | 95 |
1625567 | 1625567 | 2021-08-17 | Franklin | Illinois | 17055 | 5507 | 95 |
1622320 | 1622320 | 2021-08-16 | Franklin | Illinois | 17055 | 5472 | 95 |
1619073 | 1619073 | 2021-08-15 | Franklin | Illinois | 17055 | 5362 | 95 |
1615825 | 1615825 | 2021-08-14 | Franklin | Illinois | 17055 | 5362 | 95 |
1612576 | 1612576 | 2021-08-13 | Franklin | Illinois | 17055 | 5362 | 95 |
1609328 | 1609328 | 2021-08-12 | Franklin | Illinois | 17055 | 5328 | 95 |
1606079 | 1606079 | 2021-08-11 | Franklin | Illinois | 17055 | 5293 | 94 |
1602830 | 1602830 | 2021-08-10 | Franklin | Illinois | 17055 | 5243 | 94 |
1599581 | 1599581 | 2021-08-09 | Franklin | Illinois | 17055 | 5207 | 93 |
1596333 | 1596333 | 2021-08-08 | Franklin | Illinois | 17055 | 5098 | 91 |
1593084 | 1593084 | 2021-08-07 | Franklin | Illinois | 17055 | 5098 | 91 |
1589835 | 1589835 | 2021-08-06 | Franklin | Illinois | 17055 | 5098 | 91 |
1586586 | 1586586 | 2021-08-05 | Franklin | Illinois | 17055 | 5076 | 91 |
1583336 | 1583336 | 2021-08-04 | Franklin | Illinois | 17055 | 5039 | 91 |
1580086 | 1580086 | 2021-08-03 | Franklin | Illinois | 17055 | 5019 | 91 |
1576837 | 1576837 | 2021-08-02 | Franklin | Illinois | 17055 | 4977 | 91 |
1573589 | 1573589 | 2021-08-01 | Franklin | Illinois | 17055 | 4928 | 91 |
1570341 | 1570341 | 2021-07-31 | Franklin | Illinois | 17055 | 4928 | 91 |
1567093 | 1567093 | 2021-07-30 | Franklin | Illinois | 17055 | 4928 | 91 |
1563845 | 1563845 | 2021-07-29 | Franklin | Illinois | 17055 | 4902 | 91 |
1560597 | 1560597 | 2021-07-28 | Franklin | Illinois | 17055 | 4878 | 91 |
1557350 | 1557350 | 2021-07-27 | Franklin | Illinois | 17055 | 4858 | 90 |
1554103 | 1554103 | 2021-07-26 | Franklin | Illinois | 17055 | 4840 | 90 |
1550856 | 1550856 | 2021-07-25 | Franklin | Illinois | 17055 | 4781 | 90 |
1547609 | 1547609 | 2021-07-24 | Franklin | Illinois | 17055 | 4781 | 90 |
1544362 | 1544362 | 2021-07-23 | Franklin | Illinois | 17055 | 4781 | 90 |
1541114 | 1541114 | 2021-07-22 | Franklin | Illinois | 17055 | 4759 | 90 |
1537867 | 1537867 | 2021-07-21 | Franklin | Illinois | 17055 | 4723 | 90 |
1534619 | 1534619 | 2021-07-20 | Franklin | Illinois | 17055 | 4714 | 90 |
1531372 | 1531372 | 2021-07-19 | Franklin | Illinois | 17055 | 4709 | 90 |
1528125 | 1528125 | 2021-07-18 | Franklin | Illinois | 17055 | 4666 | 90 |
1524878 | 1524878 | 2021-07-17 | Franklin | Illinois | 17055 | 4666 | 90 |
1521630 | 1521630 | 2021-07-16 | Franklin | Illinois | 17055 | 4666 | 90 |
1518382 | 1518382 | 2021-07-15 | Franklin | Illinois | 17055 | 4658 | 90 |
1515135 | 1515135 | 2021-07-14 | Franklin | Illinois | 17055 | 4651 | 90 |
1511889 | 1511889 | 2021-07-13 | Franklin | Illinois | 17055 | 4643 | 90 |
1508642 | 1508642 | 2021-07-12 | Franklin | Illinois | 17055 | 4628 | 90 |
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);