ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where deaths = 127 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 |
---|---|---|---|---|---|---|---|
2346569 | 2346569 | 2022-03-27 | Butler | Alabama | 1013 | 5048 | 127 |
2343316 | 2343316 | 2022-03-26 | Butler | Alabama | 1013 | 5048 | 127 |
2340063 | 2340063 | 2022-03-25 | Butler | Alabama | 1013 | 5048 | 127 |
2336810 | 2336810 | 2022-03-24 | Butler | Alabama | 1013 | 5048 | 127 |
2333556 | 2333556 | 2022-03-23 | Butler | Alabama | 1013 | 5046 | 127 |
2330302 | 2330302 | 2022-03-22 | Butler | Alabama | 1013 | 5046 | 127 |
2323857 | 2323857 | 2022-03-20 | Winston | Alabama | 1133 | 7568 | 127 |
2320603 | 2320603 | 2022-03-19 | Winston | Alabama | 1133 | 7568 | 127 |
2317349 | 2317349 | 2022-03-18 | Winston | Alabama | 1133 | 7568 | 127 |
2278310 | 2278310 | 2022-03-06 | Pike | Alabama | 1109 | 7417 | 127 |
2275057 | 2275057 | 2022-03-05 | Pike | Alabama | 1109 | 7417 | 127 |
2271804 | 2271804 | 2022-03-04 | Pike | Alabama | 1109 | 7417 | 127 |
2268552 | 2268552 | 2022-03-03 | Pike | Alabama | 1109 | 7421 | 127 |
2265299 | 2265299 | 2022-03-02 | Pike | Alabama | 1109 | 7420 | 127 |
2262049 | 2262049 | 2022-03-01 | Pike | Alabama | 1109 | 7418 | 127 |
2239267 | 2239267 | 2022-02-22 | Franklin | Alabama | 1059 | 9769 | 127 |
2236016 | 2236016 | 2022-02-21 | Franklin | Alabama | 1059 | 9764 | 127 |
2232765 | 2232765 | 2022-02-20 | Franklin | Alabama | 1059 | 9764 | 127 |
2229514 | 2229514 | 2022-02-19 | Franklin | Alabama | 1059 | 9763 | 127 |
1946635 | 1946635 | 2021-11-24 | Lawrence | Alabama | 1079 | 4819 | 127 |
1943384 | 1943384 | 2021-11-23 | Lawrence | Alabama | 1079 | 4806 | 127 |
1940134 | 1940134 | 2021-11-22 | Lawrence | Alabama | 1079 | 4790 | 127 |
1936884 | 1936884 | 2021-11-21 | Lawrence | Alabama | 1079 | 4785 | 127 |
1933634 | 1933634 | 2021-11-20 | Lawrence | Alabama | 1079 | 4784 | 127 |
1930382 | 1930382 | 2021-11-19 | Lawrence | Alabama | 1079 | 4780 | 127 |
1927132 | 1927132 | 2021-11-18 | Lawrence | Alabama | 1079 | 4748 | 127 |
1881643 | 1881643 | 2021-11-04 | Marion | Alabama | 1093 | 5288 | 127 |
1871896 | 1871896 | 2021-11-01 | Marion | Alabama | 1093 | 5250 | 127 |
1868647 | 1868647 | 2021-10-31 | Marion | Alabama | 1093 | 5248 | 127 |
1865398 | 1865398 | 2021-10-30 | Marion | Alabama | 1093 | 5246 | 127 |
1862133 | 1862133 | 2021-10-29 | Geneva | Alabama | 1061 | 4590 | 127 |
1862149 | 1862149 | 2021-10-29 | Marion | Alabama | 1093 | 5242 | 127 |
1858884 | 1858884 | 2021-10-28 | Geneva | Alabama | 1061 | 4590 | 127 |
1858900 | 1858900 | 2021-10-28 | Marion | Alabama | 1093 | 5237 | 127 |
1855635 | 1855635 | 2021-10-27 | Geneva | Alabama | 1061 | 4582 | 127 |
1855651 | 1855651 | 2021-10-27 | Marion | Alabama | 1093 | 5220 | 127 |
1852386 | 1852386 | 2021-10-26 | Geneva | Alabama | 1061 | 4577 | 127 |
1852402 | 1852402 | 2021-10-26 | Marion | Alabama | 1093 | 5016 | 127 |
1849136 | 1849136 | 2021-10-25 | Geneva | Alabama | 1061 | 4575 | 127 |
1849152 | 1849152 | 2021-10-25 | Marion | Alabama | 1093 | 5010 | 127 |
1845886 | 1845886 | 2021-10-24 | Geneva | Alabama | 1061 | 4574 | 127 |
1845902 | 1845902 | 2021-10-24 | Marion | Alabama | 1093 | 5007 | 127 |
1842636 | 1842636 | 2021-10-23 | Geneva | Alabama | 1061 | 4571 | 127 |
1842652 | 1842652 | 2021-10-23 | Marion | Alabama | 1093 | 5005 | 127 |
1839387 | 1839387 | 2021-10-22 | Geneva | Alabama | 1061 | 4568 | 127 |
1826387 | 1826387 | 2021-10-18 | Escambia | Alabama | 1053 | 6747 | 127 |
1823138 | 1823138 | 2021-10-17 | Escambia | Alabama | 1053 | 6743 | 127 |
1819889 | 1819889 | 2021-10-16 | Escambia | Alabama | 1053 | 6732 | 127 |
1816640 | 1816640 | 2021-10-15 | Escambia | Alabama | 1053 | 6725 | 127 |
1813392 | 1813392 | 2021-10-14 | Escambia | Alabama | 1053 | 6714 | 127 |
1810143 | 1810143 | 2021-10-13 | Escambia | Alabama | 1053 | 6696 | 127 |
1806894 | 1806894 | 2021-10-12 | Escambia | Alabama | 1053 | 6692 | 127 |
1803643 | 1803643 | 2021-10-11 | Escambia | Alabama | 1053 | 6688 | 127 |
1800394 | 1800394 | 2021-10-10 | Escambia | Alabama | 1053 | 6688 | 127 |
1797145 | 1797145 | 2021-10-09 | Escambia | Alabama | 1053 | 6682 | 127 |
1793896 | 1793896 | 2021-10-08 | Escambia | Alabama | 1053 | 6676 | 127 |
1790647 | 1790647 | 2021-10-07 | Escambia | Alabama | 1053 | 6672 | 127 |
1735388 | 1735388 | 2021-09-20 | Autauga | Alabama | 1001 | 9527 | 127 |
1732138 | 1732138 | 2021-09-19 | Autauga | Alabama | 1001 | 9511 | 127 |
1728888 | 1728888 | 2021-09-18 | Autauga | Alabama | 1001 | 9493 | 127 |
1722397 | 1722397 | 2021-09-16 | Chambers | Alabama | 1017 | 5182 | 127 |
1719149 | 1719149 | 2021-09-15 | Chambers | Alabama | 1017 | 5155 | 127 |
1715901 | 1715901 | 2021-09-14 | Chambers | Alabama | 1017 | 5125 | 127 |
1715903 | 1715903 | 2021-09-14 | Chilton | Alabama | 1021 | 6132 | 127 |
1712655 | 1712655 | 2021-09-13 | Chambers | Alabama | 1017 | 5084 | 127 |
1712657 | 1712657 | 2021-09-13 | Chilton | Alabama | 1021 | 6100 | 127 |
1709408 | 1709408 | 2021-09-12 | Chambers | Alabama | 1017 | 5062 | 127 |
1709410 | 1709410 | 2021-09-12 | Chilton | Alabama | 1021 | 6063 | 127 |
1706161 | 1706161 | 2021-09-11 | Chambers | Alabama | 1017 | 5052 | 127 |
1706163 | 1706163 | 2021-09-11 | Chilton | Alabama | 1021 | 6046 | 127 |
1702913 | 1702913 | 2021-09-10 | Chambers | Alabama | 1017 | 5019 | 127 |
1702915 | 1702915 | 2021-09-10 | Chilton | Alabama | 1021 | 6003 | 127 |
1699663 | 1699663 | 2021-09-09 | Chambers | Alabama | 1017 | 4994 | 127 |
1696414 | 1696414 | 2021-09-08 | Chambers | Alabama | 1017 | 4960 | 127 |
1693166 | 1693166 | 2021-09-07 | Chambers | Alabama | 1017 | 4930 | 127 |
1689917 | 1689917 | 2021-09-06 | Chambers | Alabama | 1017 | 4905 | 127 |
1686667 | 1686667 | 2021-09-05 | Chambers | Alabama | 1017 | 4888 | 127 |
1683417 | 1683417 | 2021-09-04 | Chambers | Alabama | 1017 | 4871 | 127 |
1680166 | 1680166 | 2021-09-03 | Chambers | Alabama | 1017 | 4840 | 127 |
1676918 | 1676918 | 2021-09-02 | Chambers | Alabama | 1017 | 4807 | 127 |
1673671 | 1673671 | 2021-09-01 | Chambers | Alabama | 1017 | 4768 | 127 |
1670423 | 1670423 | 2021-08-31 | Chambers | Alabama | 1017 | 4732 | 127 |
1667176 | 1667176 | 2021-08-30 | Chambers | Alabama | 1017 | 4672 | 127 |
1663928 | 1663928 | 2021-08-29 | Chambers | Alabama | 1017 | 4642 | 127 |
1660680 | 1660680 | 2021-08-28 | Chambers | Alabama | 1017 | 4619 | 127 |
1657432 | 1657432 | 2021-08-27 | Chambers | Alabama | 1017 | 4575 | 127 |
1654184 | 1654184 | 2021-08-26 | Chambers | Alabama | 1017 | 4540 | 127 |
1628209 | 1628209 | 2021-08-18 | Dale | Alabama | 1045 | 6696 | 127 |
1608720 | 1608720 | 2021-08-12 | Covington | Alabama | 1039 | 5112 | 127 |
1605471 | 1605471 | 2021-08-11 | Covington | Alabama | 1039 | 5088 | 127 |
1443113 | 1443113 | 2021-06-22 | Coffee | Alabama | 1031 | 5638 | 127 |
1439868 | 1439868 | 2021-06-21 | Coffee | Alabama | 1031 | 5638 | 127 |
1436621 | 1436621 | 2021-06-20 | Coffee | Alabama | 1031 | 5635 | 127 |
1433374 | 1433374 | 2021-06-19 | Coffee | Alabama | 1031 | 5635 | 127 |
1430128 | 1430128 | 2021-06-18 | Coffee | Alabama | 1031 | 5635 | 127 |
1426883 | 1426883 | 2021-06-17 | Coffee | Alabama | 1031 | 5627 | 127 |
1423637 | 1423637 | 2021-06-16 | Coffee | Alabama | 1031 | 5627 | 127 |
1420390 | 1420390 | 2021-06-15 | Coffee | Alabama | 1031 | 5626 | 127 |
1193125 | 1193125 | 2021-04-06 | Colbert | Alabama | 1033 | 6184 | 127 |
1189875 | 1189875 | 2021-04-05 | Colbert | Alabama | 1033 | 6182 | 127 |
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);