ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Boone" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810827 | 1810827 | 2021-10-13 | Boone | Indiana | 18011 | 8786 | 121 |
1807578 | 1807578 | 2021-10-12 | Boone | Indiana | 18011 | 8771 | 121 |
1804327 | 1804327 | 2021-10-11 | Boone | Indiana | 18011 | 8763 | 121 |
1801078 | 1801078 | 2021-10-10 | Boone | Indiana | 18011 | 8733 | 121 |
1797829 | 1797829 | 2021-10-09 | Boone | Indiana | 18011 | 8733 | 121 |
1794580 | 1794580 | 2021-10-08 | Boone | Indiana | 18011 | 8733 | 121 |
1791332 | 1791332 | 2021-10-07 | Boone | Indiana | 18011 | 8706 | 121 |
1788083 | 1788083 | 2021-10-06 | Boone | Indiana | 18011 | 8690 | 121 |
1784834 | 1784834 | 2021-10-05 | Boone | Indiana | 18011 | 8661 | 120 |
1781585 | 1781585 | 2021-10-04 | Boone | Indiana | 18011 | 8653 | 120 |
1778335 | 1778335 | 2021-10-03 | Boone | Indiana | 18011 | 8607 | 118 |
1775085 | 1775085 | 2021-10-02 | Boone | Indiana | 18011 | 8607 | 118 |
1771835 | 1771835 | 2021-10-01 | Boone | Indiana | 18011 | 8607 | 118 |
1768586 | 1768586 | 2021-09-30 | Boone | Indiana | 18011 | 8586 | 118 |
1765337 | 1765337 | 2021-09-29 | Boone | Indiana | 18011 | 8563 | 118 |
1762088 | 1762088 | 2021-09-28 | Boone | Indiana | 18011 | 8534 | 118 |
1758840 | 1758840 | 2021-09-27 | Boone | Indiana | 18011 | 8528 | 118 |
1755592 | 1755592 | 2021-09-26 | Boone | Indiana | 18011 | 8484 | 117 |
1752344 | 1752344 | 2021-09-25 | Boone | Indiana | 18011 | 8484 | 117 |
1749095 | 1749095 | 2021-09-24 | Boone | Indiana | 18011 | 8484 | 117 |
1745845 | 1745845 | 2021-09-23 | Boone | Indiana | 18011 | 8438 | 117 |
1742596 | 1742596 | 2021-09-22 | Boone | Indiana | 18011 | 8410 | 117 |
1739347 | 1739347 | 2021-09-21 | Boone | Indiana | 18011 | 8389 | 116 |
1736098 | 1736098 | 2021-09-20 | Boone | Indiana | 18011 | 8372 | 115 |
1732848 | 1732848 | 2021-09-19 | Boone | Indiana | 18011 | 8320 | 115 |
1729598 | 1729598 | 2021-09-18 | Boone | Indiana | 18011 | 8320 | 115 |
1726348 | 1726348 | 2021-09-17 | Boone | Indiana | 18011 | 8320 | 115 |
1723099 | 1723099 | 2021-09-16 | Boone | Indiana | 18011 | 8281 | 115 |
1719850 | 1719850 | 2021-09-15 | Boone | Indiana | 18011 | 8252 | 115 |
1716602 | 1716602 | 2021-09-14 | Boone | Indiana | 18011 | 8203 | 115 |
1713356 | 1713356 | 2021-09-13 | Boone | Indiana | 18011 | 8172 | 115 |
1710109 | 1710109 | 2021-09-12 | Boone | Indiana | 18011 | 8089 | 115 |
1706862 | 1706862 | 2021-09-11 | Boone | Indiana | 18011 | 8089 | 115 |
1703614 | 1703614 | 2021-09-10 | Boone | Indiana | 18011 | 8089 | 115 |
1700364 | 1700364 | 2021-09-09 | Boone | Indiana | 18011 | 8055 | 115 |
1697115 | 1697115 | 2021-09-08 | Boone | Indiana | 18011 | 8023 | 114 |
1693867 | 1693867 | 2021-09-07 | Boone | Indiana | 18011 | 8009 | 114 |
1690618 | 1690618 | 2021-09-06 | Boone | Indiana | 18011 | 7904 | 114 |
1687368 | 1687368 | 2021-09-05 | Boone | Indiana | 18011 | 7904 | 114 |
1684118 | 1684118 | 2021-09-04 | Boone | Indiana | 18011 | 7904 | 114 |
1680867 | 1680867 | 2021-09-03 | Boone | Indiana | 18011 | 7904 | 114 |
1677619 | 1677619 | 2021-09-02 | Boone | Indiana | 18011 | 7887 | 114 |
1674372 | 1674372 | 2021-09-01 | Boone | Indiana | 18011 | 7844 | 114 |
1671123 | 1671123 | 2021-08-31 | Boone | Indiana | 18011 | 7821 | 114 |
1667876 | 1667876 | 2021-08-30 | Boone | Indiana | 18011 | 7801 | 112 |
1664629 | 1664629 | 2021-08-29 | Boone | Indiana | 18011 | 7718 | 111 |
1661381 | 1661381 | 2021-08-28 | Boone | Indiana | 18011 | 7718 | 111 |
1658133 | 1658133 | 2021-08-27 | Boone | Indiana | 18011 | 7718 | 111 |
1654885 | 1654885 | 2021-08-26 | Boone | Indiana | 18011 | 7691 | 111 |
1651638 | 1651638 | 2021-08-25 | Boone | Indiana | 18011 | 7667 | 111 |
1648389 | 1648389 | 2021-08-24 | Boone | Indiana | 18011 | 7648 | 111 |
1645141 | 1645141 | 2021-08-23 | Boone | Indiana | 18011 | 7639 | 111 |
1641892 | 1641892 | 2021-08-22 | Boone | Indiana | 18011 | 7590 | 111 |
1638642 | 1638642 | 2021-08-21 | Boone | Indiana | 18011 | 7590 | 111 |
1635392 | 1635392 | 2021-08-20 | Boone | Indiana | 18011 | 7590 | 111 |
1632142 | 1632142 | 2021-08-19 | Boone | Indiana | 18011 | 7574 | 111 |
1628895 | 1628895 | 2021-08-18 | Boone | Indiana | 18011 | 7553 | 111 |
1625648 | 1625648 | 2021-08-17 | Boone | Indiana | 18011 | 7537 | 110 |
1622401 | 1622401 | 2021-08-16 | Boone | Indiana | 18011 | 7522 | 110 |
1619154 | 1619154 | 2021-08-15 | Boone | Indiana | 18011 | 7481 | 110 |
1615906 | 1615906 | 2021-08-14 | Boone | Indiana | 18011 | 7481 | 110 |
1612657 | 1612657 | 2021-08-13 | Boone | Indiana | 18011 | 7481 | 110 |
1609409 | 1609409 | 2021-08-12 | Boone | Indiana | 18011 | 7464 | 110 |
1606160 | 1606160 | 2021-08-11 | Boone | Indiana | 18011 | 7437 | 110 |
1602911 | 1602911 | 2021-08-10 | Boone | Indiana | 18011 | 7414 | 110 |
1599662 | 1599662 | 2021-08-09 | Boone | Indiana | 18011 | 7407 | 110 |
1596414 | 1596414 | 2021-08-08 | Boone | Indiana | 18011 | 7377 | 109 |
1593165 | 1593165 | 2021-08-07 | Boone | Indiana | 18011 | 7377 | 109 |
1589916 | 1589916 | 2021-08-06 | Boone | Indiana | 18011 | 7377 | 109 |
1586667 | 1586667 | 2021-08-05 | Boone | Indiana | 18011 | 7365 | 109 |
1583417 | 1583417 | 2021-08-04 | Boone | Indiana | 18011 | 7336 | 109 |
1580167 | 1580167 | 2021-08-03 | Boone | Indiana | 18011 | 7308 | 109 |
1576918 | 1576918 | 2021-08-02 | Boone | Indiana | 18011 | 7298 | 109 |
1573670 | 1573670 | 2021-08-01 | Boone | Indiana | 18011 | 7255 | 109 |
1570422 | 1570422 | 2021-07-31 | Boone | Indiana | 18011 | 7255 | 109 |
1567174 | 1567174 | 2021-07-30 | Boone | Indiana | 18011 | 7255 | 109 |
1563926 | 1563926 | 2021-07-29 | Boone | Indiana | 18011 | 7240 | 109 |
1560678 | 1560678 | 2021-07-28 | Boone | Indiana | 18011 | 7230 | 109 |
1557431 | 1557431 | 2021-07-27 | Boone | Indiana | 18011 | 7203 | 109 |
1554184 | 1554184 | 2021-07-26 | Boone | Indiana | 18011 | 7192 | 109 |
1550937 | 1550937 | 2021-07-25 | Boone | Indiana | 18011 | 7164 | 109 |
1547690 | 1547690 | 2021-07-24 | Boone | Indiana | 18011 | 7164 | 109 |
1544443 | 1544443 | 2021-07-23 | Boone | Indiana | 18011 | 7164 | 109 |
1541195 | 1541195 | 2021-07-22 | Boone | Indiana | 18011 | 7156 | 109 |
1537948 | 1537948 | 2021-07-21 | Boone | Indiana | 18011 | 7146 | 109 |
1534700 | 1534700 | 2021-07-20 | Boone | Indiana | 18011 | 7142 | 109 |
1531453 | 1531453 | 2021-07-19 | Boone | Indiana | 18011 | 7131 | 109 |
1528206 | 1528206 | 2021-07-18 | Boone | Indiana | 18011 | 7111 | 109 |
1524959 | 1524959 | 2021-07-17 | Boone | Indiana | 18011 | 7111 | 109 |
1521711 | 1521711 | 2021-07-16 | Boone | Indiana | 18011 | 7111 | 109 |
1518463 | 1518463 | 2021-07-15 | Boone | Indiana | 18011 | 7106 | 109 |
1515216 | 1515216 | 2021-07-14 | Boone | Indiana | 18011 | 7100 | 109 |
1511970 | 1511970 | 2021-07-13 | Boone | Indiana | 18011 | 7098 | 109 |
1508723 | 1508723 | 2021-07-12 | Boone | Indiana | 18011 | 7088 | 109 |
1505477 | 1505477 | 2021-07-11 | Boone | Indiana | 18011 | 7078 | 109 |
1502231 | 1502231 | 2021-07-10 | Boone | Indiana | 18011 | 7078 | 109 |
1498985 | 1498985 | 2021-07-09 | Boone | Indiana | 18011 | 7078 | 109 |
1495738 | 1495738 | 2021-07-08 | Boone | Indiana | 18011 | 7075 | 109 |
1492492 | 1492492 | 2021-07-07 | Boone | Indiana | 18011 | 7066 | 108 |
1489245 | 1489245 | 2021-07-06 | Boone | Indiana | 18011 | 7062 | 108 |
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);