ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Boone" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840864 | 1840864 | 2021-10-22 | Boone | Missouri | 29019 | 25341 | 169 |
1837615 | 1837615 | 2021-10-21 | Boone | Missouri | 29019 | 25313 | 169 |
1834366 | 1834366 | 2021-10-20 | Boone | Missouri | 29019 | 25263 | 166 |
1831117 | 1831117 | 2021-10-19 | Boone | Missouri | 29019 | 25147 | 166 |
1827868 | 1827868 | 2021-10-18 | Boone | Missouri | 29019 | 25147 | 166 |
1824619 | 1824619 | 2021-10-17 | Boone | Missouri | 29019 | 25147 | 166 |
1821370 | 1821370 | 2021-10-16 | Boone | Missouri | 29019 | 25147 | 166 |
1818121 | 1818121 | 2021-10-15 | Boone | Missouri | 29019 | 25147 | 166 |
1814872 | 1814872 | 2021-10-14 | Boone | Missouri | 29019 | 25106 | 166 |
1811624 | 1811624 | 2021-10-13 | Boone | Missouri | 29019 | 25080 | 166 |
1808375 | 1808375 | 2021-10-12 | Boone | Missouri | 29019 | 24903 | 162 |
1805124 | 1805124 | 2021-10-11 | Boone | Missouri | 29019 | 24903 | 162 |
1801875 | 1801875 | 2021-10-10 | Boone | Missouri | 29019 | 24903 | 162 |
1798626 | 1798626 | 2021-10-09 | Boone | Missouri | 29019 | 24903 | 162 |
1795377 | 1795377 | 2021-10-08 | Boone | Missouri | 29019 | 24903 | 162 |
1792128 | 1792128 | 2021-10-07 | Boone | Missouri | 29019 | 24854 | 162 |
1788879 | 1788879 | 2021-10-06 | Boone | Missouri | 29019 | 24804 | 160 |
1785631 | 1785631 | 2021-10-05 | Boone | Missouri | 29019 | 24762 | 160 |
1782382 | 1782382 | 2021-10-04 | Boone | Missouri | 29019 | 24712 | 155 |
1779132 | 1779132 | 2021-10-03 | Boone | Missouri | 29019 | 24620 | 154 |
1775882 | 1775882 | 2021-10-02 | Boone | Missouri | 29019 | 24620 | 154 |
1772632 | 1772632 | 2021-10-01 | Boone | Missouri | 29019 | 24620 | 154 |
1769383 | 1769383 | 2021-09-30 | Boone | Missouri | 29019 | 24578 | 153 |
1766134 | 1766134 | 2021-09-29 | Boone | Missouri | 29019 | 24485 | 153 |
1762885 | 1762885 | 2021-09-28 | Boone | Missouri | 29019 | 24485 | 153 |
1759636 | 1759636 | 2021-09-27 | Boone | Missouri | 29019 | 24447 | 153 |
1756388 | 1756388 | 2021-09-26 | Boone | Missouri | 29019 | 24382 | 153 |
1753140 | 1753140 | 2021-09-25 | Boone | Missouri | 29019 | 24382 | 153 |
1749892 | 1749892 | 2021-09-24 | Boone | Missouri | 29019 | 24382 | 153 |
1746642 | 1746642 | 2021-09-23 | Boone | Missouri | 29019 | 24343 | 152 |
1743393 | 1743393 | 2021-09-22 | Boone | Missouri | 29019 | 24297 | 152 |
1740144 | 1740144 | 2021-09-21 | Boone | Missouri | 29019 | 24248 | 152 |
1736895 | 1736895 | 2021-09-20 | Boone | Missouri | 29019 | 24200 | 152 |
1733645 | 1733645 | 2021-09-19 | Boone | Missouri | 29019 | 24088 | 151 |
1730395 | 1730395 | 2021-09-18 | Boone | Missouri | 29019 | 24088 | 151 |
1727145 | 1727145 | 2021-09-17 | Boone | Missouri | 29019 | 24088 | 151 |
1723896 | 1723896 | 2021-09-16 | Boone | Missouri | 29019 | 24028 | 151 |
1720647 | 1720647 | 2021-09-15 | Boone | Missouri | 29019 | 23900 | 149 |
1717399 | 1717399 | 2021-09-14 | Boone | Missouri | 29019 | 23900 | 149 |
1714151 | 1714151 | 2021-09-13 | Boone | Missouri | 29019 | 23831 | 149 |
1710905 | 1710905 | 2021-09-12 | Boone | Missouri | 29019 | 23671 | 149 |
1707658 | 1707658 | 2021-09-11 | Boone | Missouri | 29019 | 23671 | 149 |
1704411 | 1704411 | 2021-09-10 | Boone | Missouri | 29019 | 23671 | 149 |
1701161 | 1701161 | 2021-09-09 | Boone | Missouri | 29019 | 23581 | 146 |
1697912 | 1697912 | 2021-09-08 | Boone | Missouri | 29019 | 23474 | 146 |
1694664 | 1694664 | 2021-09-07 | Boone | Missouri | 29019 | 23399 | 145 |
1691415 | 1691415 | 2021-09-06 | Boone | Missouri | 29019 | 23176 | 141 |
1688165 | 1688165 | 2021-09-05 | Boone | Missouri | 29019 | 23176 | 141 |
1684915 | 1684915 | 2021-09-04 | Boone | Missouri | 29019 | 23176 | 141 |
1681664 | 1681664 | 2021-09-03 | Boone | Missouri | 29019 | 23176 | 141 |
1678416 | 1678416 | 2021-09-02 | Boone | Missouri | 29019 | 22991 | 140 |
1675168 | 1675168 | 2021-09-01 | Boone | Missouri | 29019 | 22991 | 140 |
1671920 | 1671920 | 2021-08-31 | Boone | Missouri | 29019 | 22991 | 140 |
1668673 | 1668673 | 2021-08-30 | Boone | Missouri | 29019 | 22931 | 140 |
1665426 | 1665426 | 2021-08-29 | Boone | Missouri | 29019 | 22803 | 137 |
1662178 | 1662178 | 2021-08-28 | Boone | Missouri | 29019 | 22803 | 137 |
1658930 | 1658930 | 2021-08-27 | Boone | Missouri | 29019 | 22803 | 137 |
1655681 | 1655681 | 2021-08-26 | Boone | Missouri | 29019 | 22749 | 137 |
1652434 | 1652434 | 2021-08-25 | Boone | Missouri | 29019 | 22684 | 136 |
1649186 | 1649186 | 2021-08-24 | Boone | Missouri | 29019 | 22623 | 135 |
1645937 | 1645937 | 2021-08-23 | Boone | Missouri | 29019 | 22549 | 134 |
1642688 | 1642688 | 2021-08-22 | Boone | Missouri | 29019 | 22440 | 133 |
1639438 | 1639438 | 2021-08-21 | Boone | Missouri | 29019 | 22440 | 133 |
1636188 | 1636188 | 2021-08-20 | Boone | Missouri | 29019 | 22440 | 133 |
1632938 | 1632938 | 2021-08-19 | Boone | Missouri | 29019 | 22361 | 131 |
1629691 | 1629691 | 2021-08-18 | Boone | Missouri | 29019 | 22293 | 131 |
1626444 | 1626444 | 2021-08-17 | Boone | Missouri | 29019 | 22200 | 130 |
1623197 | 1623197 | 2021-08-16 | Boone | Missouri | 29019 | 22160 | 129 |
1619950 | 1619950 | 2021-08-15 | Boone | Missouri | 29019 | 22008 | 129 |
1616702 | 1616702 | 2021-08-14 | Boone | Missouri | 29019 | 22008 | 129 |
1613454 | 1613454 | 2021-08-13 | Boone | Missouri | 29019 | 22008 | 129 |
1610205 | 1610205 | 2021-08-12 | Boone | Missouri | 29019 | 21849 | 128 |
1606957 | 1606957 | 2021-08-11 | Boone | Missouri | 29019 | 21849 | 128 |
1603708 | 1603708 | 2021-08-10 | Boone | Missouri | 29019 | 21769 | 127 |
1600459 | 1600459 | 2021-08-09 | Boone | Missouri | 29019 | 21679 | 126 |
1597211 | 1597211 | 2021-08-08 | Boone | Missouri | 29019 | 21501 | 123 |
1593962 | 1593962 | 2021-08-07 | Boone | Missouri | 29019 | 21501 | 123 |
1590713 | 1590713 | 2021-08-06 | Boone | Missouri | 29019 | 21501 | 123 |
1587464 | 1587464 | 2021-08-05 | Boone | Missouri | 29019 | 21424 | 123 |
1584213 | 1584213 | 2021-08-04 | Boone | Missouri | 29019 | 21325 | 121 |
1580964 | 1580964 | 2021-08-03 | Boone | Missouri | 29019 | 21205 | 120 |
1577715 | 1577715 | 2021-08-02 | Boone | Missouri | 29019 | 21120 | 119 |
1574467 | 1574467 | 2021-08-01 | Boone | Missouri | 29019 | 20996 | 119 |
1571219 | 1571219 | 2021-07-31 | Boone | Missouri | 29019 | 20996 | 119 |
1567971 | 1567971 | 2021-07-30 | Boone | Missouri | 29019 | 20996 | 119 |
1564723 | 1564723 | 2021-07-29 | Boone | Missouri | 29019 | 20918 | 118 |
1561475 | 1561475 | 2021-07-28 | Boone | Missouri | 29019 | 20788 | 118 |
1558227 | 1558227 | 2021-07-27 | Boone | Missouri | 29019 | 20673 | 118 |
1554980 | 1554980 | 2021-07-26 | Boone | Missouri | 29019 | 20618 | 118 |
1551733 | 1551733 | 2021-07-25 | Boone | Missouri | 29019 | 20451 | 118 |
1548486 | 1548486 | 2021-07-24 | Boone | Missouri | 29019 | 20451 | 118 |
1545239 | 1545239 | 2021-07-23 | Boone | Missouri | 29019 | 20451 | 118 |
1541991 | 1541991 | 2021-07-22 | Boone | Missouri | 29019 | 20381 | 118 |
1538744 | 1538744 | 2021-07-21 | Boone | Missouri | 29019 | 20292 | 118 |
1535497 | 1535497 | 2021-07-20 | Boone | Missouri | 29019 | 20198 | 118 |
1532249 | 1532249 | 2021-07-19 | Boone | Missouri | 29019 | 20027 | 118 |
1529002 | 1529002 | 2021-07-18 | Boone | Missouri | 29019 | 19898 | 118 |
1525755 | 1525755 | 2021-07-17 | Boone | Missouri | 29019 | 19898 | 118 |
1522508 | 1522508 | 2021-07-16 | Boone | Missouri | 29019 | 19898 | 118 |
1519259 | 1519259 | 2021-07-15 | Boone | Missouri | 29019 | 19779 | 118 |
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);