ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
519 rows where deaths = 42 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Bullock 106
- Sumter 50
- Russell 31
- Chambers 25
- Monroe 24
- Marshall 22
- Henry 20
- Wilcox 20
- Autauga 16
- Cherokee 15
- St. Clair 15
- Bibb 14
- Dale 13
- Butler 12
- Cleburne 12
- Hale 11
- Washington 10
- Randolph 9
- Lawrence 8
- Lowndes 7
- Colbert 6
- Escambia 6
- Marion 6
- Coffee 5
- Cullman 5
- Lauderdale 5
- Winston 5
- Greene 4
- Talladega 4
- Baldwin 3
- …
state 1
- Alabama · 519 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2281574 | 2281574 | 2022-03-07 | Wilcox | Alabama | 1131 | 2864 | 42 |
2278321 | 2278321 | 2022-03-06 | Wilcox | Alabama | 1131 | 2864 | 42 |
2275068 | 2275068 | 2022-03-05 | Wilcox | Alabama | 1131 | 2864 | 42 |
2271815 | 2271815 | 2022-03-04 | Wilcox | Alabama | 1131 | 2864 | 42 |
2268563 | 2268563 | 2022-03-03 | Wilcox | Alabama | 1131 | 2861 | 42 |
2265310 | 2265310 | 2022-03-02 | Wilcox | Alabama | 1131 | 2858 | 42 |
2262060 | 2262060 | 2022-03-01 | Wilcox | Alabama | 1131 | 2856 | 42 |
2258809 | 2258809 | 2022-02-28 | Wilcox | Alabama | 1131 | 2855 | 42 |
2255558 | 2255558 | 2022-02-27 | Wilcox | Alabama | 1131 | 2855 | 42 |
2252307 | 2252307 | 2022-02-26 | Wilcox | Alabama | 1131 | 2855 | 42 |
2249056 | 2249056 | 2022-02-25 | Wilcox | Alabama | 1131 | 2855 | 42 |
2245805 | 2245805 | 2022-02-24 | Wilcox | Alabama | 1131 | 2850 | 42 |
2242554 | 2242554 | 2022-02-23 | Wilcox | Alabama | 1131 | 2849 | 42 |
2239303 | 2239303 | 2022-02-22 | Wilcox | Alabama | 1131 | 2843 | 42 |
2236052 | 2236052 | 2022-02-21 | Wilcox | Alabama | 1131 | 2840 | 42 |
2232801 | 2232801 | 2022-02-20 | Wilcox | Alabama | 1131 | 2839 | 42 |
2229550 | 2229550 | 2022-02-19 | Wilcox | Alabama | 1131 | 2839 | 42 |
2226286 | 2226286 | 2022-02-18 | Perry | Alabama | 1105 | 2073 | 42 |
2226299 | 2226299 | 2022-02-18 | Wilcox | Alabama | 1131 | 2832 | 42 |
2223035 | 2223035 | 2022-02-17 | Perry | Alabama | 1105 | 2067 | 42 |
2223048 | 2223048 | 2022-02-17 | Wilcox | Alabama | 1131 | 2828 | 42 |
2219797 | 2219797 | 2022-02-16 | Wilcox | Alabama | 1131 | 2824 | 42 |
2157982 | 2157982 | 2022-01-28 | Sumter | Alabama | 1119 | 2117 | 42 |
2154729 | 2154729 | 2022-01-27 | Sumter | Alabama | 1119 | 2117 | 42 |
2151476 | 2151476 | 2022-01-26 | Sumter | Alabama | 1119 | 2117 | 42 |
2148224 | 2148224 | 2022-01-25 | Sumter | Alabama | 1119 | 2117 | 42 |
2144972 | 2144972 | 2022-01-24 | Sumter | Alabama | 1119 | 2117 | 42 |
2141717 | 2141717 | 2022-01-23 | Sumter | Alabama | 1119 | 2108 | 42 |
2138461 | 2138461 | 2022-01-22 | Sumter | Alabama | 1119 | 2060 | 42 |
2135206 | 2135206 | 2022-01-21 | Sumter | Alabama | 1119 | 1982 | 42 |
2131954 | 2131954 | 2022-01-20 | Sumter | Alabama | 1119 | 1926 | 42 |
2128700 | 2128700 | 2022-01-19 | Sumter | Alabama | 1119 | 1862 | 42 |
2125447 | 2125447 | 2022-01-18 | Sumter | Alabama | 1119 | 1817 | 42 |
2122195 | 2122195 | 2022-01-17 | Sumter | Alabama | 1119 | 1808 | 42 |
2118943 | 2118943 | 2022-01-16 | Sumter | Alabama | 1119 | 1802 | 42 |
2115691 | 2115691 | 2022-01-15 | Sumter | Alabama | 1119 | 1737 | 42 |
2112439 | 2112439 | 2022-01-14 | Sumter | Alabama | 1119 | 1737 | 42 |
2109187 | 2109187 | 2022-01-13 | Sumter | Alabama | 1119 | 1737 | 42 |
2105936 | 2105936 | 2022-01-12 | Sumter | Alabama | 1119 | 1737 | 42 |
2102685 | 2102685 | 2022-01-11 | Sumter | Alabama | 1119 | 1705 | 42 |
2099434 | 2099434 | 2022-01-10 | Sumter | Alabama | 1119 | 1692 | 42 |
2096183 | 2096183 | 2022-01-09 | Sumter | Alabama | 1119 | 1683 | 42 |
2092931 | 2092931 | 2022-01-08 | Sumter | Alabama | 1119 | 1664 | 42 |
2089679 | 2089679 | 2022-01-07 | Sumter | Alabama | 1119 | 1628 | 42 |
2086428 | 2086428 | 2022-01-06 | Sumter | Alabama | 1119 | 1561 | 42 |
2083176 | 2083176 | 2022-01-05 | Sumter | Alabama | 1119 | 1523 | 42 |
2079924 | 2079924 | 2022-01-04 | Sumter | Alabama | 1119 | 1498 | 42 |
2076672 | 2076672 | 2022-01-03 | Sumter | Alabama | 1119 | 1488 | 42 |
2073421 | 2073421 | 2022-01-02 | Sumter | Alabama | 1119 | 1485 | 42 |
2070170 | 2070170 | 2022-01-01 | Sumter | Alabama | 1119 | 1473 | 42 |
2066919 | 2066919 | 2021-12-31 | Sumter | Alabama | 1119 | 1473 | 42 |
2063669 | 2063669 | 2021-12-30 | Sumter | Alabama | 1119 | 1460 | 42 |
2060419 | 2060419 | 2021-12-29 | Sumter | Alabama | 1119 | 1432 | 42 |
2057170 | 2057170 | 2021-12-28 | Sumter | Alabama | 1119 | 1422 | 42 |
2053921 | 2053921 | 2021-12-27 | Sumter | Alabama | 1119 | 1420 | 42 |
2050671 | 2050671 | 2021-12-26 | Sumter | Alabama | 1119 | 1418 | 42 |
2047421 | 2047421 | 2021-12-25 | Sumter | Alabama | 1119 | 1418 | 42 |
2044171 | 2044171 | 2021-12-24 | Sumter | Alabama | 1119 | 1417 | 42 |
2040922 | 2040922 | 2021-12-23 | Sumter | Alabama | 1119 | 1416 | 42 |
2037672 | 2037672 | 2021-12-22 | Sumter | Alabama | 1119 | 1415 | 42 |
2034422 | 2034422 | 2021-12-21 | Sumter | Alabama | 1119 | 1413 | 42 |
2031172 | 2031172 | 2021-12-20 | Sumter | Alabama | 1119 | 1412 | 42 |
2027921 | 2027921 | 2021-12-19 | Sumter | Alabama | 1119 | 1412 | 42 |
2024670 | 2024670 | 2021-12-18 | Sumter | Alabama | 1119 | 1412 | 42 |
2021419 | 2021419 | 2021-12-17 | Sumter | Alabama | 1119 | 1409 | 42 |
2018168 | 2018168 | 2021-12-16 | Sumter | Alabama | 1119 | 1408 | 42 |
2014918 | 2014918 | 2021-12-15 | Sumter | Alabama | 1119 | 1408 | 42 |
2011667 | 2011667 | 2021-12-14 | Sumter | Alabama | 1119 | 1409 | 42 |
2008416 | 2008416 | 2021-12-13 | Sumter | Alabama | 1119 | 1406 | 42 |
2005165 | 2005165 | 2021-12-12 | Sumter | Alabama | 1119 | 1406 | 42 |
2001914 | 2001914 | 2021-12-11 | Sumter | Alabama | 1119 | 1405 | 42 |
1998664 | 1998664 | 2021-12-10 | Sumter | Alabama | 1119 | 1405 | 42 |
1871868 | 1871868 | 2021-11-01 | Coosa | Alabama | 1037 | 1816 | 42 |
1868619 | 1868619 | 2021-10-31 | Coosa | Alabama | 1037 | 1815 | 42 |
1865370 | 1865370 | 2021-10-30 | Coosa | Alabama | 1037 | 1816 | 42 |
1748390 | 1748390 | 2021-09-24 | Bullock | Alabama | 1011 | 1488 | 42 |
1748416 | 1748416 | 2021-09-24 | Greene | Alabama | 1063 | 1206 | 42 |
1748422 | 1748422 | 2021-09-24 | Lamar | Alabama | 1075 | 1933 | 42 |
1745140 | 1745140 | 2021-09-23 | Bullock | Alabama | 1011 | 1486 | 42 |
1745166 | 1745166 | 2021-09-23 | Greene | Alabama | 1063 | 1205 | 42 |
1741891 | 1741891 | 2021-09-22 | Bullock | Alabama | 1011 | 1477 | 42 |
1741917 | 1741917 | 2021-09-22 | Greene | Alabama | 1063 | 1201 | 42 |
1738642 | 1738642 | 2021-09-21 | Bullock | Alabama | 1011 | 1475 | 42 |
1738668 | 1738668 | 2021-09-21 | Greene | Alabama | 1063 | 1198 | 42 |
1735393 | 1735393 | 2021-09-20 | Bullock | Alabama | 1011 | 1473 | 42 |
1732143 | 1732143 | 2021-09-19 | Bullock | Alabama | 1011 | 1472 | 42 |
1728893 | 1728893 | 2021-09-18 | Bullock | Alabama | 1011 | 1471 | 42 |
1725643 | 1725643 | 2021-09-17 | Bullock | Alabama | 1011 | 1468 | 42 |
1722394 | 1722394 | 2021-09-16 | Bullock | Alabama | 1011 | 1462 | 42 |
1719146 | 1719146 | 2021-09-15 | Bullock | Alabama | 1011 | 1456 | 42 |
1715898 | 1715898 | 2021-09-14 | Bullock | Alabama | 1011 | 1451 | 42 |
1712652 | 1712652 | 2021-09-13 | Bullock | Alabama | 1011 | 1442 | 42 |
1709405 | 1709405 | 2021-09-12 | Bullock | Alabama | 1011 | 1441 | 42 |
1706158 | 1706158 | 2021-09-11 | Bullock | Alabama | 1011 | 1440 | 42 |
1702910 | 1702910 | 2021-09-10 | Bullock | Alabama | 1011 | 1435 | 42 |
1699660 | 1699660 | 2021-09-09 | Bullock | Alabama | 1011 | 1434 | 42 |
1696411 | 1696411 | 2021-09-08 | Bullock | Alabama | 1011 | 1430 | 42 |
1693163 | 1693163 | 2021-09-07 | Bullock | Alabama | 1011 | 1422 | 42 |
1689914 | 1689914 | 2021-09-06 | Bullock | Alabama | 1011 | 1412 | 42 |
1686664 | 1686664 | 2021-09-05 | Bullock | Alabama | 1011 | 1409 | 42 |
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);