ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
283 rows where deaths = 33 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lamar 40
- Hale 28
- Franklin 21
- Choctaw 18
- Wilcox 14
- Conecuh 13
- Lauderdale 12
- Greene 9
- Sumter 9
- Lawrence 8
- Bullock 7
- Clarke 7
- Chilton 6
- Covington 6
- Escambia 6
- Marion 6
- Talladega 6
- Barbour 5
- Colbert 5
- Crenshaw 5
- Butler 4
- Chambers 4
- Monroe 4
- Russell 4
- Dallas 3
- Jefferson 3
- Lee 3
- Morgan 3
- Baldwin 2
- Cherokee 2
- …
state 1
- Alabama · 283 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2216493 | 2216493 | 2022-02-15 | Choctaw | Alabama | 1023 | 1953 | 33 |
2213242 | 2213242 | 2022-02-14 | Choctaw | Alabama | 1023 | 1938 | 33 |
2209989 | 2209989 | 2022-02-13 | Choctaw | Alabama | 1023 | 1938 | 33 |
2206736 | 2206736 | 2022-02-12 | Choctaw | Alabama | 1023 | 1935 | 33 |
2203483 | 2203483 | 2022-02-11 | Choctaw | Alabama | 1023 | 1930 | 33 |
2200229 | 2200229 | 2022-02-10 | Choctaw | Alabama | 1023 | 1907 | 33 |
2196975 | 2196975 | 2022-02-09 | Choctaw | Alabama | 1023 | 1904 | 33 |
2193720 | 2193720 | 2022-02-08 | Choctaw | Alabama | 1023 | 1889 | 33 |
2190467 | 2190467 | 2022-02-07 | Choctaw | Alabama | 1023 | 1867 | 33 |
2187214 | 2187214 | 2022-02-06 | Choctaw | Alabama | 1023 | 1858 | 33 |
2183961 | 2183961 | 2022-02-05 | Choctaw | Alabama | 1023 | 1858 | 33 |
2180709 | 2180709 | 2022-02-04 | Choctaw | Alabama | 1023 | 1850 | 33 |
2177458 | 2177458 | 2022-02-03 | Choctaw | Alabama | 1023 | 1784 | 33 |
2174205 | 2174205 | 2022-02-02 | Choctaw | Alabama | 1023 | 1784 | 33 |
2170953 | 2170953 | 2022-02-01 | Choctaw | Alabama | 1023 | 1781 | 33 |
2167700 | 2167700 | 2022-01-31 | Choctaw | Alabama | 1023 | 1778 | 33 |
2164445 | 2164445 | 2022-01-30 | Choctaw | Alabama | 1023 | 1775 | 33 |
2161190 | 2161190 | 2022-01-29 | Choctaw | Alabama | 1023 | 1769 | 33 |
1748403 | 1748403 | 2021-09-24 | Coosa | Alabama | 1037 | 1680 | 33 |
1745153 | 1745153 | 2021-09-23 | Coosa | Alabama | 1037 | 1675 | 33 |
1722454 | 1722454 | 2021-09-16 | Wilcox | Alabama | 1131 | 1535 | 33 |
1719206 | 1719206 | 2021-09-15 | Wilcox | Alabama | 1131 | 1530 | 33 |
1715958 | 1715958 | 2021-09-14 | Wilcox | Alabama | 1131 | 1528 | 33 |
1712712 | 1712712 | 2021-09-13 | Wilcox | Alabama | 1131 | 1519 | 33 |
1709465 | 1709465 | 2021-09-12 | Wilcox | Alabama | 1131 | 1516 | 33 |
1706218 | 1706218 | 2021-09-11 | Wilcox | Alabama | 1131 | 1512 | 33 |
1702970 | 1702970 | 2021-09-10 | Wilcox | Alabama | 1131 | 1504 | 33 |
1699720 | 1699720 | 2021-09-09 | Wilcox | Alabama | 1131 | 1501 | 33 |
1696471 | 1696471 | 2021-09-08 | Wilcox | Alabama | 1131 | 1490 | 33 |
1693223 | 1693223 | 2021-09-07 | Wilcox | Alabama | 1131 | 1485 | 33 |
1689974 | 1689974 | 2021-09-06 | Wilcox | Alabama | 1131 | 1478 | 33 |
1686724 | 1686724 | 2021-09-05 | Wilcox | Alabama | 1131 | 1476 | 33 |
1683474 | 1683474 | 2021-09-04 | Wilcox | Alabama | 1131 | 1470 | 33 |
1680223 | 1680223 | 2021-09-03 | Wilcox | Alabama | 1131 | 1466 | 33 |
1628204 | 1628204 | 2021-08-18 | Conecuh | Alabama | 1035 | 1369 | 33 |
1624957 | 1624957 | 2021-08-17 | Conecuh | Alabama | 1035 | 1361 | 33 |
1621710 | 1621710 | 2021-08-16 | Conecuh | Alabama | 1035 | 1350 | 33 |
1618462 | 1618462 | 2021-08-15 | Conecuh | Alabama | 1035 | 1342 | 33 |
1615214 | 1615214 | 2021-08-14 | Conecuh | Alabama | 1035 | 1320 | 33 |
1611965 | 1611965 | 2021-08-13 | Conecuh | Alabama | 1035 | 1320 | 33 |
1608718 | 1608718 | 2021-08-12 | Conecuh | Alabama | 1035 | 1308 | 33 |
1605469 | 1605469 | 2021-08-11 | Conecuh | Alabama | 1035 | 1295 | 33 |
1602219 | 1602219 | 2021-08-10 | Conecuh | Alabama | 1035 | 1282 | 33 |
1598971 | 1598971 | 2021-08-09 | Conecuh | Alabama | 1035 | 1273 | 33 |
1595722 | 1595722 | 2021-08-08 | Conecuh | Alabama | 1035 | 1259 | 33 |
1592473 | 1592473 | 2021-08-07 | Conecuh | Alabama | 1035 | 1259 | 33 |
1589224 | 1589224 | 2021-08-06 | Conecuh | Alabama | 1035 | 1247 | 33 |
1589266 | 1589266 | 2021-08-06 | Sumter | Alabama | 1119 | 1114 | 33 |
1586017 | 1586017 | 2021-08-05 | Sumter | Alabama | 1119 | 1112 | 33 |
1582767 | 1582767 | 2021-08-04 | Sumter | Alabama | 1119 | 1109 | 33 |
1579517 | 1579517 | 2021-08-03 | Sumter | Alabama | 1119 | 1106 | 33 |
1576269 | 1576269 | 2021-08-02 | Sumter | Alabama | 1119 | 1104 | 33 |
1573021 | 1573021 | 2021-08-01 | Sumter | Alabama | 1119 | 1103 | 33 |
1569773 | 1569773 | 2021-07-31 | Sumter | Alabama | 1119 | 1103 | 33 |
1566525 | 1566525 | 2021-07-30 | Sumter | Alabama | 1119 | 1095 | 33 |
1563277 | 1563277 | 2021-07-29 | Sumter | Alabama | 1119 | 1095 | 33 |
1196394 | 1196394 | 2021-04-07 | Lamar | Alabama | 1075 | 1392 | 33 |
1193146 | 1193146 | 2021-04-06 | Lamar | Alabama | 1075 | 1392 | 33 |
1189896 | 1189896 | 2021-04-05 | Lamar | Alabama | 1075 | 1392 | 33 |
1186649 | 1186649 | 2021-04-04 | Lamar | Alabama | 1075 | 1392 | 33 |
1183402 | 1183402 | 2021-04-03 | Lamar | Alabama | 1075 | 1392 | 33 |
1180155 | 1180155 | 2021-04-02 | Lamar | Alabama | 1075 | 1392 | 33 |
1176908 | 1176908 | 2021-04-01 | Lamar | Alabama | 1075 | 1390 | 33 |
1173661 | 1173661 | 2021-03-31 | Lamar | Alabama | 1075 | 1384 | 33 |
1170414 | 1170414 | 2021-03-30 | Lamar | Alabama | 1075 | 1384 | 33 |
1167166 | 1167166 | 2021-03-29 | Lamar | Alabama | 1075 | 1384 | 33 |
1163918 | 1163918 | 2021-03-28 | Lamar | Alabama | 1075 | 1384 | 33 |
1160670 | 1160670 | 2021-03-27 | Lamar | Alabama | 1075 | 1384 | 33 |
1157422 | 1157422 | 2021-03-26 | Lamar | Alabama | 1075 | 1382 | 33 |
1154169 | 1154169 | 2021-03-25 | Greene | Alabama | 1063 | 901 | 33 |
1154175 | 1154175 | 2021-03-25 | Lamar | Alabama | 1075 | 1378 | 33 |
1150922 | 1150922 | 2021-03-24 | Greene | Alabama | 1063 | 900 | 33 |
1150928 | 1150928 | 2021-03-24 | Lamar | Alabama | 1075 | 1378 | 33 |
1147675 | 1147675 | 2021-03-23 | Greene | Alabama | 1063 | 899 | 33 |
1147681 | 1147681 | 2021-03-23 | Lamar | Alabama | 1075 | 1372 | 33 |
1144428 | 1144428 | 2021-03-22 | Greene | Alabama | 1063 | 897 | 33 |
1144434 | 1144434 | 2021-03-22 | Lamar | Alabama | 1075 | 1373 | 33 |
1141181 | 1141181 | 2021-03-21 | Greene | Alabama | 1063 | 897 | 33 |
1141187 | 1141187 | 2021-03-21 | Lamar | Alabama | 1075 | 1372 | 33 |
1137935 | 1137935 | 2021-03-20 | Greene | Alabama | 1063 | 896 | 33 |
1137941 | 1137941 | 2021-03-20 | Lamar | Alabama | 1075 | 1372 | 33 |
1134689 | 1134689 | 2021-03-19 | Greene | Alabama | 1063 | 896 | 33 |
1134695 | 1134695 | 2021-03-19 | Lamar | Alabama | 1075 | 1369 | 33 |
1131441 | 1131441 | 2021-03-18 | Greene | Alabama | 1063 | 893 | 33 |
1131447 | 1131447 | 2021-03-18 | Lamar | Alabama | 1075 | 1368 | 33 |
1128194 | 1128194 | 2021-03-17 | Greene | Alabama | 1063 | 891 | 33 |
1128200 | 1128200 | 2021-03-17 | Lamar | Alabama | 1075 | 1367 | 33 |
1124954 | 1124954 | 2021-03-16 | Lamar | Alabama | 1075 | 1366 | 33 |
1121708 | 1121708 | 2021-03-15 | Lamar | Alabama | 1075 | 1365 | 33 |
1118461 | 1118461 | 2021-03-14 | Lamar | Alabama | 1075 | 1352 | 33 |
1115214 | 1115214 | 2021-03-13 | Lamar | Alabama | 1075 | 1351 | 33 |
1111968 | 1111968 | 2021-03-12 | Lamar | Alabama | 1075 | 1349 | 33 |
1108722 | 1108722 | 2021-03-11 | Lamar | Alabama | 1075 | 1351 | 33 |
1105476 | 1105476 | 2021-03-10 | Lamar | Alabama | 1075 | 1349 | 33 |
1102230 | 1102230 | 2021-03-09 | Lamar | Alabama | 1075 | 1340 | 33 |
1098984 | 1098984 | 2021-03-08 | Lamar | Alabama | 1075 | 1339 | 33 |
1095736 | 1095736 | 2021-03-07 | Lamar | Alabama | 1075 | 1339 | 33 |
1092490 | 1092490 | 2021-03-06 | Lamar | Alabama | 1075 | 1339 | 33 |
1089244 | 1089244 | 2021-03-05 | Lamar | Alabama | 1075 | 1339 | 33 |
1089263 | 1089263 | 2021-03-05 | Russell | Alabama | 1113 | 4073 | 33 |
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);