ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
377 rows where deaths = 39 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177512 | 2177512 | 2022-02-03 | Wilcox | Alabama | 1131 | 2711 | 39 |
2174259 | 2174259 | 2022-02-02 | Wilcox | Alabama | 1131 | 2711 | 39 |
2171007 | 2171007 | 2022-02-01 | Wilcox | Alabama | 1131 | 2690 | 39 |
1884911 | 1884911 | 2021-11-05 | Wilcox | Alabama | 1131 | 1730 | 39 |
1881662 | 1881662 | 2021-11-04 | Wilcox | Alabama | 1131 | 1730 | 39 |
1878407 | 1878407 | 2021-11-03 | Sumter | Alabama | 1119 | 1349 | 39 |
1878413 | 1878413 | 2021-11-03 | Wilcox | Alabama | 1131 | 1724 | 39 |
1875158 | 1875158 | 2021-11-02 | Sumter | Alabama | 1119 | 1342 | 39 |
1875164 | 1875164 | 2021-11-02 | Wilcox | Alabama | 1131 | 1719 | 39 |
1871915 | 1871915 | 2021-11-01 | Wilcox | Alabama | 1131 | 1714 | 39 |
1868666 | 1868666 | 2021-10-31 | Wilcox | Alabama | 1131 | 1714 | 39 |
1865417 | 1865417 | 2021-10-30 | Wilcox | Alabama | 1131 | 1712 | 39 |
1862168 | 1862168 | 2021-10-29 | Wilcox | Alabama | 1131 | 1711 | 39 |
1858919 | 1858919 | 2021-10-28 | Wilcox | Alabama | 1131 | 1710 | 39 |
1855670 | 1855670 | 2021-10-27 | Wilcox | Alabama | 1131 | 1700 | 39 |
1852421 | 1852421 | 2021-10-26 | Wilcox | Alabama | 1131 | 1691 | 39 |
1849171 | 1849171 | 2021-10-25 | Wilcox | Alabama | 1131 | 1689 | 39 |
1845921 | 1845921 | 2021-10-24 | Wilcox | Alabama | 1131 | 1689 | 39 |
1842671 | 1842671 | 2021-10-23 | Wilcox | Alabama | 1131 | 1688 | 39 |
1839422 | 1839422 | 2021-10-22 | Wilcox | Alabama | 1131 | 1687 | 39 |
1836126 | 1836126 | 2021-10-21 | Coosa | Alabama | 1037 | 1797 | 39 |
1836173 | 1836173 | 2021-10-21 | Wilcox | Alabama | 1131 | 1679 | 39 |
1832877 | 1832877 | 2021-10-20 | Coosa | Alabama | 1037 | 1794 | 39 |
1832924 | 1832924 | 2021-10-20 | Wilcox | Alabama | 1131 | 1678 | 39 |
1810169 | 1810169 | 2021-10-13 | Perry | Alabama | 1105 | 1380 | 39 |
1806920 | 1806920 | 2021-10-12 | Perry | Alabama | 1105 | 1374 | 39 |
1803669 | 1803669 | 2021-10-11 | Perry | Alabama | 1105 | 1374 | 39 |
1800420 | 1800420 | 2021-10-10 | Perry | Alabama | 1105 | 1373 | 39 |
1797171 | 1797171 | 2021-10-09 | Perry | Alabama | 1105 | 1373 | 39 |
1793922 | 1793922 | 2021-10-08 | Perry | Alabama | 1105 | 1372 | 39 |
1790673 | 1790673 | 2021-10-07 | Perry | Alabama | 1105 | 1371 | 39 |
1787425 | 1787425 | 2021-10-06 | Perry | Alabama | 1105 | 1369 | 39 |
1738674 | 1738674 | 2021-09-21 | Lamar | Alabama | 1075 | 1906 | 39 |
1735405 | 1735405 | 2021-09-20 | Conecuh | Alabama | 1035 | 1779 | 39 |
1735425 | 1735425 | 2021-09-20 | Lamar | Alabama | 1075 | 1889 | 39 |
1732155 | 1732155 | 2021-09-19 | Conecuh | Alabama | 1035 | 1774 | 39 |
1732175 | 1732175 | 2021-09-19 | Lamar | Alabama | 1075 | 1887 | 39 |
1728905 | 1728905 | 2021-09-18 | Conecuh | Alabama | 1035 | 1771 | 39 |
1728925 | 1728925 | 2021-09-18 | Lamar | Alabama | 1075 | 1878 | 39 |
1725675 | 1725675 | 2021-09-17 | Lamar | Alabama | 1075 | 1863 | 39 |
1676941 | 1676941 | 2021-09-02 | Greene | Alabama | 1063 | 1145 | 39 |
1673694 | 1673694 | 2021-09-01 | Greene | Alabama | 1063 | 1144 | 39 |
1670446 | 1670446 | 2021-08-31 | Greene | Alabama | 1063 | 1139 | 39 |
1667199 | 1667199 | 2021-08-30 | Greene | Alabama | 1063 | 1131 | 39 |
1663951 | 1663951 | 2021-08-29 | Greene | Alabama | 1063 | 1129 | 39 |
1660703 | 1660703 | 2021-08-28 | Greene | Alabama | 1063 | 1124 | 39 |
1657455 | 1657455 | 2021-08-27 | Greene | Alabama | 1063 | 1113 | 39 |
1654207 | 1654207 | 2021-08-26 | Greene | Alabama | 1063 | 1099 | 39 |
1650961 | 1650961 | 2021-08-25 | Greene | Alabama | 1063 | 1073 | 39 |
1647712 | 1647712 | 2021-08-24 | Greene | Alabama | 1063 | 1073 | 39 |
1644463 | 1644463 | 2021-08-23 | Greene | Alabama | 1063 | 1073 | 39 |
1641213 | 1641213 | 2021-08-22 | Greene | Alabama | 1063 | 1072 | 39 |
1637963 | 1637963 | 2021-08-21 | Greene | Alabama | 1063 | 1065 | 39 |
1634713 | 1634713 | 2021-08-20 | Greene | Alabama | 1063 | 1057 | 39 |
1631465 | 1631465 | 2021-08-19 | Greene | Alabama | 1063 | 1049 | 39 |
1628218 | 1628218 | 2021-08-18 | Greene | Alabama | 1063 | 1039 | 39 |
1628251 | 1628251 | 2021-08-18 | Washington | Alabama | 1129 | 2129 | 39 |
1624971 | 1624971 | 2021-08-17 | Greene | Alabama | 1063 | 1035 | 39 |
1625004 | 1625004 | 2021-08-17 | Washington | Alabama | 1129 | 2091 | 39 |
1621724 | 1621724 | 2021-08-16 | Greene | Alabama | 1063 | 1031 | 39 |
1621757 | 1621757 | 2021-08-16 | Washington | Alabama | 1129 | 2082 | 39 |
1618476 | 1618476 | 2021-08-15 | Greene | Alabama | 1063 | 1030 | 39 |
1618509 | 1618509 | 2021-08-15 | Washington | Alabama | 1129 | 2078 | 39 |
1615228 | 1615228 | 2021-08-14 | Greene | Alabama | 1063 | 1020 | 39 |
1615261 | 1615261 | 2021-08-14 | Washington | Alabama | 1129 | 2055 | 39 |
1611979 | 1611979 | 2021-08-13 | Greene | Alabama | 1063 | 1020 | 39 |
1612012 | 1612012 | 2021-08-13 | Washington | Alabama | 1129 | 2055 | 39 |
1608765 | 1608765 | 2021-08-12 | Washington | Alabama | 1129 | 2031 | 39 |
1605516 | 1605516 | 2021-08-11 | Washington | Alabama | 1129 | 2015 | 39 |
1602266 | 1602266 | 2021-08-10 | Washington | Alabama | 1129 | 1993 | 39 |
1599018 | 1599018 | 2021-08-09 | Washington | Alabama | 1129 | 1978 | 39 |
1595769 | 1595769 | 2021-08-08 | Washington | Alabama | 1129 | 1959 | 39 |
1592520 | 1592520 | 2021-08-07 | Washington | Alabama | 1129 | 1959 | 39 |
1589271 | 1589271 | 2021-08-06 | Washington | Alabama | 1129 | 1941 | 39 |
1586022 | 1586022 | 2021-08-05 | Washington | Alabama | 1129 | 1915 | 39 |
1582772 | 1582772 | 2021-08-04 | Washington | Alabama | 1129 | 1894 | 39 |
1579522 | 1579522 | 2021-08-03 | Washington | Alabama | 1129 | 1868 | 39 |
1576274 | 1576274 | 2021-08-02 | Washington | Alabama | 1129 | 1852 | 39 |
1573026 | 1573026 | 2021-08-01 | Washington | Alabama | 1129 | 1852 | 39 |
1569778 | 1569778 | 2021-07-31 | Washington | Alabama | 1129 | 1843 | 39 |
1566530 | 1566530 | 2021-07-30 | Washington | Alabama | 1129 | 1821 | 39 |
1563282 | 1563282 | 2021-07-29 | Washington | Alabama | 1129 | 1821 | 39 |
1560034 | 1560034 | 2021-07-28 | Washington | Alabama | 1129 | 1801 | 39 |
1556787 | 1556787 | 2021-07-27 | Washington | Alabama | 1129 | 1793 | 39 |
1553540 | 1553540 | 2021-07-26 | Washington | Alabama | 1129 | 1783 | 39 |
1550293 | 1550293 | 2021-07-25 | Washington | Alabama | 1129 | 1771 | 39 |
1547046 | 1547046 | 2021-07-24 | Washington | Alabama | 1129 | 1762 | 39 |
1543799 | 1543799 | 2021-07-23 | Washington | Alabama | 1129 | 1751 | 39 |
1540551 | 1540551 | 2021-07-22 | Washington | Alabama | 1129 | 1745 | 39 |
1537304 | 1537304 | 2021-07-21 | Washington | Alabama | 1129 | 1741 | 39 |
1534056 | 1534056 | 2021-07-20 | Washington | Alabama | 1129 | 1737 | 39 |
1530809 | 1530809 | 2021-07-19 | Washington | Alabama | 1129 | 1734 | 39 |
1527562 | 1527562 | 2021-07-18 | Washington | Alabama | 1129 | 1732 | 39 |
1524315 | 1524315 | 2021-07-17 | Washington | Alabama | 1129 | 1731 | 39 |
1521067 | 1521067 | 2021-07-16 | Washington | Alabama | 1129 | 1728 | 39 |
1517819 | 1517819 | 2021-07-15 | Washington | Alabama | 1129 | 1726 | 39 |
1514572 | 1514572 | 2021-07-14 | Washington | Alabama | 1129 | 1721 | 39 |
1511326 | 1511326 | 2021-07-13 | Washington | Alabama | 1129 | 1714 | 39 |
1508079 | 1508079 | 2021-07-12 | Washington | Alabama | 1129 | 1714 | 39 |
1504833 | 1504833 | 2021-07-11 | Washington | Alabama | 1129 | 1713 | 39 |
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);