ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Pike" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839411 | 1839411 | 2021-10-22 | Pike | Alabama | 1109 | 4791 | 105 |
1836162 | 1836162 | 2021-10-21 | Pike | Alabama | 1109 | 4722 | 105 |
1832913 | 1832913 | 2021-10-20 | Pike | Alabama | 1109 | 4722 | 105 |
1829664 | 1829664 | 2021-10-19 | Pike | Alabama | 1109 | 4722 | 105 |
1826415 | 1826415 | 2021-10-18 | Pike | Alabama | 1109 | 4721 | 105 |
1823166 | 1823166 | 2021-10-17 | Pike | Alabama | 1109 | 4720 | 105 |
1819917 | 1819917 | 2021-10-16 | Pike | Alabama | 1109 | 4719 | 105 |
1816668 | 1816668 | 2021-10-15 | Pike | Alabama | 1109 | 4716 | 105 |
1813420 | 1813420 | 2021-10-14 | Pike | Alabama | 1109 | 4713 | 105 |
1810171 | 1810171 | 2021-10-13 | Pike | Alabama | 1109 | 4708 | 104 |
1806922 | 1806922 | 2021-10-12 | Pike | Alabama | 1109 | 4700 | 104 |
1803671 | 1803671 | 2021-10-11 | Pike | Alabama | 1109 | 4691 | 104 |
1800422 | 1800422 | 2021-10-10 | Pike | Alabama | 1109 | 4691 | 104 |
1797173 | 1797173 | 2021-10-09 | Pike | Alabama | 1109 | 4689 | 104 |
1793924 | 1793924 | 2021-10-08 | Pike | Alabama | 1109 | 4685 | 103 |
1790675 | 1790675 | 2021-10-07 | Pike | Alabama | 1109 | 4684 | 103 |
1787427 | 1787427 | 2021-10-06 | Pike | Alabama | 1109 | 4680 | 102 |
1784178 | 1784178 | 2021-10-05 | Pike | Alabama | 1109 | 4676 | 101 |
1780929 | 1780929 | 2021-10-04 | Pike | Alabama | 1109 | 4672 | 101 |
1777679 | 1777679 | 2021-10-03 | Pike | Alabama | 1109 | 4668 | 101 |
1774429 | 1774429 | 2021-10-02 | Pike | Alabama | 1109 | 4664 | 101 |
1771179 | 1771179 | 2021-10-01 | Pike | Alabama | 1109 | 4655 | 100 |
1767930 | 1767930 | 2021-09-30 | Pike | Alabama | 1109 | 4651 | 99 |
1764681 | 1764681 | 2021-09-29 | Pike | Alabama | 1109 | 4650 | 98 |
1761432 | 1761432 | 2021-09-28 | Pike | Alabama | 1109 | 4639 | 98 |
1758184 | 1758184 | 2021-09-27 | Pike | Alabama | 1109 | 4632 | 97 |
1754936 | 1754936 | 2021-09-26 | Pike | Alabama | 1109 | 4623 | 97 |
1751688 | 1751688 | 2021-09-25 | Pike | Alabama | 1109 | 4615 | 97 |
1748439 | 1748439 | 2021-09-24 | Pike | Alabama | 1109 | 4600 | 96 |
1745189 | 1745189 | 2021-09-23 | Pike | Alabama | 1109 | 4588 | 95 |
1741940 | 1741940 | 2021-09-22 | Pike | Alabama | 1109 | 4562 | 94 |
1738691 | 1738691 | 2021-09-21 | Pike | Alabama | 1109 | 4548 | 93 |
1735442 | 1735442 | 2021-09-20 | Pike | Alabama | 1109 | 4529 | 91 |
1732192 | 1732192 | 2021-09-19 | Pike | Alabama | 1109 | 4518 | 91 |
1728942 | 1728942 | 2021-09-18 | Pike | Alabama | 1109 | 4500 | 91 |
1725692 | 1725692 | 2021-09-17 | Pike | Alabama | 1109 | 4482 | 89 |
1722443 | 1722443 | 2021-09-16 | Pike | Alabama | 1109 | 4414 | 88 |
1719195 | 1719195 | 2021-09-15 | Pike | Alabama | 1109 | 4391 | 88 |
1715947 | 1715947 | 2021-09-14 | Pike | Alabama | 1109 | 4357 | 88 |
1712701 | 1712701 | 2021-09-13 | Pike | Alabama | 1109 | 4315 | 87 |
1709454 | 1709454 | 2021-09-12 | Pike | Alabama | 1109 | 4299 | 87 |
1706207 | 1706207 | 2021-09-11 | Pike | Alabama | 1109 | 4294 | 87 |
1702959 | 1702959 | 2021-09-10 | Pike | Alabama | 1109 | 4257 | 87 |
1699709 | 1699709 | 2021-09-09 | Pike | Alabama | 1109 | 4214 | 86 |
1696460 | 1696460 | 2021-09-08 | Pike | Alabama | 1109 | 4191 | 85 |
1693212 | 1693212 | 2021-09-07 | Pike | Alabama | 1109 | 4152 | 84 |
1689963 | 1689963 | 2021-09-06 | Pike | Alabama | 1109 | 4140 | 84 |
1686713 | 1686713 | 2021-09-05 | Pike | Alabama | 1109 | 4133 | 84 |
1683463 | 1683463 | 2021-09-04 | Pike | Alabama | 1109 | 4109 | 84 |
1680212 | 1680212 | 2021-09-03 | Pike | Alabama | 1109 | 4082 | 84 |
1676964 | 1676964 | 2021-09-02 | Pike | Alabama | 1109 | 4054 | 84 |
1673717 | 1673717 | 2021-09-01 | Pike | Alabama | 1109 | 4019 | 84 |
1670469 | 1670469 | 2021-08-31 | Pike | Alabama | 1109 | 3989 | 84 |
1667222 | 1667222 | 2021-08-30 | Pike | Alabama | 1109 | 3934 | 84 |
1663974 | 1663974 | 2021-08-29 | Pike | Alabama | 1109 | 3905 | 84 |
1660726 | 1660726 | 2021-08-28 | Pike | Alabama | 1109 | 3897 | 84 |
1657478 | 1657478 | 2021-08-27 | Pike | Alabama | 1109 | 3867 | 84 |
1654230 | 1654230 | 2021-08-26 | Pike | Alabama | 1109 | 3827 | 82 |
1650984 | 1650984 | 2021-08-25 | Pike | Alabama | 1109 | 3778 | 81 |
1647735 | 1647735 | 2021-08-24 | Pike | Alabama | 1109 | 3778 | 81 |
1644486 | 1644486 | 2021-08-23 | Pike | Alabama | 1109 | 3778 | 81 |
1641236 | 1641236 | 2021-08-22 | Pike | Alabama | 1109 | 3768 | 81 |
1637986 | 1637986 | 2021-08-21 | Pike | Alabama | 1109 | 3760 | 81 |
1634736 | 1634736 | 2021-08-20 | Pike | Alabama | 1109 | 3680 | 81 |
1631488 | 1631488 | 2021-08-19 | Pike | Alabama | 1109 | 3668 | 81 |
1628241 | 1628241 | 2021-08-18 | Pike | Alabama | 1109 | 3646 | 81 |
1624994 | 1624994 | 2021-08-17 | Pike | Alabama | 1109 | 3614 | 81 |
1621747 | 1621747 | 2021-08-16 | Pike | Alabama | 1109 | 3598 | 80 |
1618499 | 1618499 | 2021-08-15 | Pike | Alabama | 1109 | 3593 | 80 |
1615251 | 1615251 | 2021-08-14 | Pike | Alabama | 1109 | 3567 | 80 |
1612002 | 1612002 | 2021-08-13 | Pike | Alabama | 1109 | 3567 | 80 |
1608755 | 1608755 | 2021-08-12 | Pike | Alabama | 1109 | 3534 | 80 |
1605506 | 1605506 | 2021-08-11 | Pike | Alabama | 1109 | 3510 | 80 |
1602256 | 1602256 | 2021-08-10 | Pike | Alabama | 1109 | 3494 | 79 |
1599008 | 1599008 | 2021-08-09 | Pike | Alabama | 1109 | 3470 | 79 |
1595759 | 1595759 | 2021-08-08 | Pike | Alabama | 1109 | 3454 | 79 |
1592510 | 1592510 | 2021-08-07 | Pike | Alabama | 1109 | 3454 | 79 |
1589261 | 1589261 | 2021-08-06 | Pike | Alabama | 1109 | 3430 | 79 |
1586012 | 1586012 | 2021-08-05 | Pike | Alabama | 1109 | 3395 | 79 |
1582762 | 1582762 | 2021-08-04 | Pike | Alabama | 1109 | 3369 | 79 |
1579512 | 1579512 | 2021-08-03 | Pike | Alabama | 1109 | 3340 | 79 |
1576264 | 1576264 | 2021-08-02 | Pike | Alabama | 1109 | 3330 | 79 |
1573016 | 1573016 | 2021-08-01 | Pike | Alabama | 1109 | 3325 | 79 |
1569768 | 1569768 | 2021-07-31 | Pike | Alabama | 1109 | 3320 | 79 |
1566520 | 1566520 | 2021-07-30 | Pike | Alabama | 1109 | 3290 | 79 |
1563272 | 1563272 | 2021-07-29 | Pike | Alabama | 1109 | 3290 | 79 |
1560024 | 1560024 | 2021-07-28 | Pike | Alabama | 1109 | 3278 | 79 |
1556777 | 1556777 | 2021-07-27 | Pike | Alabama | 1109 | 3269 | 79 |
1553530 | 1553530 | 2021-07-26 | Pike | Alabama | 1109 | 3255 | 79 |
1550283 | 1550283 | 2021-07-25 | Pike | Alabama | 1109 | 3248 | 79 |
1547036 | 1547036 | 2021-07-24 | Pike | Alabama | 1109 | 3242 | 79 |
1543789 | 1543789 | 2021-07-23 | Pike | Alabama | 1109 | 3236 | 79 |
1540541 | 1540541 | 2021-07-22 | Pike | Alabama | 1109 | 3231 | 79 |
1537294 | 1537294 | 2021-07-21 | Pike | Alabama | 1109 | 3226 | 79 |
1534046 | 1534046 | 2021-07-20 | Pike | Alabama | 1109 | 3213 | 79 |
1530799 | 1530799 | 2021-07-19 | Pike | Alabama | 1109 | 3210 | 78 |
1527552 | 1527552 | 2021-07-18 | Pike | Alabama | 1109 | 3208 | 78 |
1524305 | 1524305 | 2021-07-17 | Pike | Alabama | 1109 | 3205 | 78 |
1521057 | 1521057 | 2021-07-16 | Pike | Alabama | 1109 | 3200 | 78 |
1517809 | 1517809 | 2021-07-15 | Pike | Alabama | 1109 | 3194 | 78 |
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);