ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
386 rows where deaths = 45 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Cherokee 80
- Greene 54
- Henry 42
- Cleburne 29
- Bullock 23
- Etowah 20
- Butler 19
- Sumter 15
- Macon 14
- Lamar 13
- Marshall 13
- Wilcox 7
- Limestone 6
- Clay 5
- Barbour 4
- Chilton 4
- Crenshaw 4
- Washington 4
- Winston 4
- Calhoun 3
- Dallas 3
- Jackson 3
- Lawrence 3
- Franklin 2
- Lauderdale 2
- Russell 2
- Shelby 2
- Blount 1
- Dale 1
- Elmore 1
- …
state 1
- Alabama · 386 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405188 | 2405188 | 2022-04-14 | Perry | Alabama | 1105 | 2092 | 45 |
2336869 | 2336869 | 2022-03-24 | Wilcox | Alabama | 1131 | 2872 | 45 |
2333615 | 2333615 | 2022-03-23 | Wilcox | Alabama | 1131 | 2872 | 45 |
2330361 | 2330361 | 2022-03-22 | Wilcox | Alabama | 1131 | 2871 | 45 |
2327109 | 2327109 | 2022-03-21 | Wilcox | Alabama | 1131 | 2871 | 45 |
2323856 | 2323856 | 2022-03-20 | Wilcox | Alabama | 1131 | 2871 | 45 |
2320602 | 2320602 | 2022-03-19 | Wilcox | Alabama | 1131 | 2871 | 45 |
2317348 | 2317348 | 2022-03-18 | Wilcox | Alabama | 1131 | 2871 | 45 |
2265304 | 2265304 | 2022-03-02 | Sumter | Alabama | 1119 | 2558 | 45 |
2262054 | 2262054 | 2022-03-01 | Sumter | Alabama | 1119 | 2555 | 45 |
2258803 | 2258803 | 2022-02-28 | Sumter | Alabama | 1119 | 2548 | 45 |
2255552 | 2255552 | 2022-02-27 | Sumter | Alabama | 1119 | 2548 | 45 |
2252301 | 2252301 | 2022-02-26 | Sumter | Alabama | 1119 | 2548 | 45 |
2249050 | 2249050 | 2022-02-25 | Sumter | Alabama | 1119 | 2538 | 45 |
2245799 | 2245799 | 2022-02-24 | Sumter | Alabama | 1119 | 2534 | 45 |
2242548 | 2242548 | 2022-02-23 | Sumter | Alabama | 1119 | 2526 | 45 |
2239297 | 2239297 | 2022-02-22 | Sumter | Alabama | 1119 | 2524 | 45 |
2236046 | 2236046 | 2022-02-21 | Sumter | Alabama | 1119 | 2523 | 45 |
2232795 | 2232795 | 2022-02-20 | Sumter | Alabama | 1119 | 2523 | 45 |
2229544 | 2229544 | 2022-02-19 | Sumter | Alabama | 1119 | 2523 | 45 |
2226293 | 2226293 | 2022-02-18 | Sumter | Alabama | 1119 | 2519 | 45 |
2223042 | 2223042 | 2022-02-17 | Sumter | Alabama | 1119 | 2514 | 45 |
2219791 | 2219791 | 2022-02-16 | Sumter | Alabama | 1119 | 2469 | 45 |
2083148 | 2083148 | 2022-01-05 | Greene | Alabama | 1063 | 1393 | 45 |
2079896 | 2079896 | 2022-01-04 | Greene | Alabama | 1063 | 1388 | 45 |
2076644 | 2076644 | 2022-01-03 | Greene | Alabama | 1063 | 1384 | 45 |
2073393 | 2073393 | 2022-01-02 | Greene | Alabama | 1063 | 1380 | 45 |
2070142 | 2070142 | 2022-01-01 | Greene | Alabama | 1063 | 1367 | 45 |
2066891 | 2066891 | 2021-12-31 | Greene | Alabama | 1063 | 1367 | 45 |
2063641 | 2063641 | 2021-12-30 | Greene | Alabama | 1063 | 1357 | 45 |
2060391 | 2060391 | 2021-12-29 | Greene | Alabama | 1063 | 1346 | 45 |
2057142 | 2057142 | 2021-12-28 | Greene | Alabama | 1063 | 1331 | 45 |
2053893 | 2053893 | 2021-12-27 | Greene | Alabama | 1063 | 1328 | 45 |
2050643 | 2050643 | 2021-12-26 | Greene | Alabama | 1063 | 1328 | 45 |
2047393 | 2047393 | 2021-12-25 | Greene | Alabama | 1063 | 1328 | 45 |
2044143 | 2044143 | 2021-12-24 | Greene | Alabama | 1063 | 1327 | 45 |
2040894 | 2040894 | 2021-12-23 | Greene | Alabama | 1063 | 1322 | 45 |
2037644 | 2037644 | 2021-12-22 | Greene | Alabama | 1063 | 1317 | 45 |
2034394 | 2034394 | 2021-12-21 | Greene | Alabama | 1063 | 1316 | 45 |
2031144 | 2031144 | 2021-12-20 | Greene | Alabama | 1063 | 1313 | 45 |
2027893 | 2027893 | 2021-12-19 | Greene | Alabama | 1063 | 1313 | 45 |
2024642 | 2024642 | 2021-12-18 | Greene | Alabama | 1063 | 1313 | 45 |
2021391 | 2021391 | 2021-12-17 | Greene | Alabama | 1063 | 1313 | 45 |
2018140 | 2018140 | 2021-12-16 | Greene | Alabama | 1063 | 1312 | 45 |
2014890 | 2014890 | 2021-12-15 | Greene | Alabama | 1063 | 1312 | 45 |
2011639 | 2011639 | 2021-12-14 | Greene | Alabama | 1063 | 1311 | 45 |
2008388 | 2008388 | 2021-12-13 | Greene | Alabama | 1063 | 1311 | 45 |
2005137 | 2005137 | 2021-12-12 | Greene | Alabama | 1063 | 1311 | 45 |
2001886 | 2001886 | 2021-12-11 | Greene | Alabama | 1063 | 1311 | 45 |
1998636 | 1998636 | 2021-12-10 | Greene | Alabama | 1063 | 1310 | 45 |
1995359 | 1995359 | 2021-12-09 | Bullock | Alabama | 1011 | 1534 | 45 |
1995385 | 1995385 | 2021-12-09 | Greene | Alabama | 1063 | 1310 | 45 |
1992108 | 1992108 | 2021-12-08 | Bullock | Alabama | 1011 | 1532 | 45 |
1992134 | 1992134 | 2021-12-08 | Greene | Alabama | 1063 | 1310 | 45 |
1988857 | 1988857 | 2021-12-07 | Bullock | Alabama | 1011 | 1528 | 45 |
1988883 | 1988883 | 2021-12-07 | Greene | Alabama | 1063 | 1308 | 45 |
1985607 | 1985607 | 2021-12-06 | Bullock | Alabama | 1011 | 1528 | 45 |
1985633 | 1985633 | 2021-12-06 | Greene | Alabama | 1063 | 1307 | 45 |
1982357 | 1982357 | 2021-12-05 | Bullock | Alabama | 1011 | 1528 | 45 |
1982383 | 1982383 | 2021-12-05 | Greene | Alabama | 1063 | 1307 | 45 |
1979107 | 1979107 | 2021-12-04 | Bullock | Alabama | 1011 | 1528 | 45 |
1979133 | 1979133 | 2021-12-04 | Greene | Alabama | 1063 | 1305 | 45 |
1975857 | 1975857 | 2021-12-03 | Bullock | Alabama | 1011 | 1527 | 45 |
1975883 | 1975883 | 2021-12-03 | Greene | Alabama | 1063 | 1303 | 45 |
1972608 | 1972608 | 2021-12-02 | Bullock | Alabama | 1011 | 1525 | 45 |
1972634 | 1972634 | 2021-12-02 | Greene | Alabama | 1063 | 1302 | 45 |
1969358 | 1969358 | 2021-12-01 | Bullock | Alabama | 1011 | 1525 | 45 |
1969384 | 1969384 | 2021-12-01 | Greene | Alabama | 1063 | 1302 | 45 |
1966108 | 1966108 | 2021-11-30 | Bullock | Alabama | 1011 | 1525 | 45 |
1966134 | 1966134 | 2021-11-30 | Greene | Alabama | 1063 | 1302 | 45 |
1962856 | 1962856 | 2021-11-29 | Bullock | Alabama | 1011 | 1526 | 45 |
1962882 | 1962882 | 2021-11-29 | Greene | Alabama | 1063 | 1302 | 45 |
1959605 | 1959605 | 2021-11-28 | Bullock | Alabama | 1011 | 1526 | 45 |
1959631 | 1959631 | 2021-11-28 | Greene | Alabama | 1063 | 1302 | 45 |
1956354 | 1956354 | 2021-11-27 | Bullock | Alabama | 1011 | 1526 | 45 |
1956380 | 1956380 | 2021-11-27 | Greene | Alabama | 1063 | 1302 | 45 |
1953103 | 1953103 | 2021-11-26 | Bullock | Alabama | 1011 | 1525 | 45 |
1953129 | 1953129 | 2021-11-26 | Greene | Alabama | 1063 | 1302 | 45 |
1949852 | 1949852 | 2021-11-25 | Bullock | Alabama | 1011 | 1525 | 45 |
1949878 | 1949878 | 2021-11-25 | Greene | Alabama | 1063 | 1302 | 45 |
1946601 | 1946601 | 2021-11-24 | Bullock | Alabama | 1011 | 1525 | 45 |
1946627 | 1946627 | 2021-11-24 | Greene | Alabama | 1063 | 1301 | 45 |
1943350 | 1943350 | 2021-11-23 | Bullock | Alabama | 1011 | 1527 | 45 |
1943376 | 1943376 | 2021-11-23 | Greene | Alabama | 1063 | 1301 | 45 |
1940100 | 1940100 | 2021-11-22 | Bullock | Alabama | 1011 | 1527 | 45 |
1940126 | 1940126 | 2021-11-22 | Greene | Alabama | 1063 | 1300 | 45 |
1936850 | 1936850 | 2021-11-21 | Bullock | Alabama | 1011 | 1527 | 45 |
1936876 | 1936876 | 2021-11-21 | Greene | Alabama | 1063 | 1300 | 45 |
1933600 | 1933600 | 2021-11-20 | Bullock | Alabama | 1011 | 1527 | 45 |
1933626 | 1933626 | 2021-11-20 | Greene | Alabama | 1063 | 1300 | 45 |
1930348 | 1930348 | 2021-11-19 | Bullock | Alabama | 1011 | 1524 | 45 |
1930374 | 1930374 | 2021-11-19 | Greene | Alabama | 1063 | 1298 | 45 |
1927098 | 1927098 | 2021-11-18 | Bullock | Alabama | 1011 | 1524 | 45 |
1927124 | 1927124 | 2021-11-18 | Greene | Alabama | 1063 | 1297 | 45 |
1923848 | 1923848 | 2021-11-17 | Bullock | Alabama | 1011 | 1525 | 45 |
1923874 | 1923874 | 2021-11-17 | Greene | Alabama | 1063 | 1295 | 45 |
1920625 | 1920625 | 2021-11-16 | Greene | Alabama | 1063 | 1296 | 45 |
1917375 | 1917375 | 2021-11-15 | Greene | Alabama | 1063 | 1294 | 45 |
1914125 | 1914125 | 2021-11-14 | Greene | Alabama | 1063 | 1294 | 45 |
1910875 | 1910875 | 2021-11-13 | Greene | Alabama | 1063 | 1294 | 45 |
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);