ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
442 rows where deaths = 32 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Sumter 135
- Greene 34
- Crenshaw 20
- Lowndes 20
- Lamar 17
- Covington 15
- Wilcox 15
- Escambia 14
- Barbour 13
- Colbert 13
- Morgan 11
- Chilton 10
- Franklin 10
- Lee 10
- Dallas 9
- Baldwin 7
- Hale 7
- Houston 7
- Bullock 6
- Conecuh 6
- Henry 6
- St. Clair 6
- Randolph 5
- Washington 5
- Chambers 4
- Lawrence 4
- Marion 4
- DeKalb 3
- Monroe 3
- Shelby 3
- …
state 1
- Alabama · 442 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1741904 | 1741904 | 2021-09-22 | Coosa | Alabama | 1037 | 1664 | 32 |
1738655 | 1738655 | 2021-09-21 | Coosa | Alabama | 1037 | 1657 | 32 |
1722441 | 1722441 | 2021-09-16 | Perry | Alabama | 1105 | 1331 | 32 |
1676975 | 1676975 | 2021-09-02 | Wilcox | Alabama | 1131 | 1462 | 32 |
1673728 | 1673728 | 2021-09-01 | Wilcox | Alabama | 1131 | 1455 | 32 |
1670480 | 1670480 | 2021-08-31 | Wilcox | Alabama | 1131 | 1446 | 32 |
1667233 | 1667233 | 2021-08-30 | Wilcox | Alabama | 1131 | 1439 | 32 |
1663985 | 1663985 | 2021-08-29 | Wilcox | Alabama | 1131 | 1430 | 32 |
1660737 | 1660737 | 2021-08-28 | Wilcox | Alabama | 1131 | 1428 | 32 |
1657489 | 1657489 | 2021-08-27 | Wilcox | Alabama | 1131 | 1415 | 32 |
1654241 | 1654241 | 2021-08-26 | Wilcox | Alabama | 1131 | 1406 | 32 |
1650995 | 1650995 | 2021-08-25 | Wilcox | Alabama | 1131 | 1388 | 32 |
1647746 | 1647746 | 2021-08-24 | Wilcox | Alabama | 1131 | 1388 | 32 |
1644497 | 1644497 | 2021-08-23 | Wilcox | Alabama | 1131 | 1388 | 32 |
1641247 | 1641247 | 2021-08-22 | Wilcox | Alabama | 1131 | 1383 | 32 |
1637997 | 1637997 | 2021-08-21 | Wilcox | Alabama | 1131 | 1380 | 32 |
1634747 | 1634747 | 2021-08-20 | Wilcox | Alabama | 1131 | 1378 | 32 |
1631499 | 1631499 | 2021-08-19 | Wilcox | Alabama | 1131 | 1378 | 32 |
1585975 | 1585975 | 2021-08-05 | Conecuh | Alabama | 1035 | 1240 | 32 |
1582725 | 1582725 | 2021-08-04 | Conecuh | Alabama | 1035 | 1230 | 32 |
1579475 | 1579475 | 2021-08-03 | Conecuh | Alabama | 1035 | 1221 | 32 |
1576227 | 1576227 | 2021-08-02 | Conecuh | Alabama | 1035 | 1221 | 32 |
1572979 | 1572979 | 2021-08-01 | Conecuh | Alabama | 1035 | 1213 | 32 |
1569731 | 1569731 | 2021-07-31 | Conecuh | Alabama | 1035 | 1206 | 32 |
1560029 | 1560029 | 2021-07-28 | Sumter | Alabama | 1119 | 1090 | 32 |
1556782 | 1556782 | 2021-07-27 | Sumter | Alabama | 1119 | 1087 | 32 |
1553535 | 1553535 | 2021-07-26 | Sumter | Alabama | 1119 | 1084 | 32 |
1550288 | 1550288 | 2021-07-25 | Sumter | Alabama | 1119 | 1080 | 32 |
1547041 | 1547041 | 2021-07-24 | Sumter | Alabama | 1119 | 1080 | 32 |
1543794 | 1543794 | 2021-07-23 | Sumter | Alabama | 1119 | 1078 | 32 |
1540546 | 1540546 | 2021-07-22 | Sumter | Alabama | 1119 | 1075 | 32 |
1537299 | 1537299 | 2021-07-21 | Sumter | Alabama | 1119 | 1072 | 32 |
1534051 | 1534051 | 2021-07-20 | Sumter | Alabama | 1119 | 1071 | 32 |
1530804 | 1530804 | 2021-07-19 | Sumter | Alabama | 1119 | 1071 | 32 |
1527557 | 1527557 | 2021-07-18 | Sumter | Alabama | 1119 | 1071 | 32 |
1524310 | 1524310 | 2021-07-17 | Sumter | Alabama | 1119 | 1071 | 32 |
1521062 | 1521062 | 2021-07-16 | Sumter | Alabama | 1119 | 1071 | 32 |
1517814 | 1517814 | 2021-07-15 | Sumter | Alabama | 1119 | 1069 | 32 |
1514567 | 1514567 | 2021-07-14 | Sumter | Alabama | 1119 | 1069 | 32 |
1511321 | 1511321 | 2021-07-13 | Sumter | Alabama | 1119 | 1067 | 32 |
1508074 | 1508074 | 2021-07-12 | Sumter | Alabama | 1119 | 1067 | 32 |
1504828 | 1504828 | 2021-07-11 | Sumter | Alabama | 1119 | 1067 | 32 |
1501582 | 1501582 | 2021-07-10 | Sumter | Alabama | 1119 | 1067 | 32 |
1498336 | 1498336 | 2021-07-09 | Sumter | Alabama | 1119 | 1066 | 32 |
1495089 | 1495089 | 2021-07-08 | Sumter | Alabama | 1119 | 1063 | 32 |
1491842 | 1491842 | 2021-07-07 | Sumter | Alabama | 1119 | 1063 | 32 |
1488595 | 1488595 | 2021-07-06 | Sumter | Alabama | 1119 | 1062 | 32 |
1485348 | 1485348 | 2021-07-05 | Sumter | Alabama | 1119 | 1062 | 32 |
1482102 | 1482102 | 2021-07-04 | Sumter | Alabama | 1119 | 1062 | 32 |
1478855 | 1478855 | 2021-07-03 | Sumter | Alabama | 1119 | 1062 | 32 |
1475609 | 1475609 | 2021-07-02 | Sumter | Alabama | 1119 | 1062 | 32 |
1472363 | 1472363 | 2021-07-01 | Sumter | Alabama | 1119 | 1062 | 32 |
1469118 | 1469118 | 2021-06-30 | Sumter | Alabama | 1119 | 1062 | 32 |
1465873 | 1465873 | 2021-06-29 | Sumter | Alabama | 1119 | 1062 | 32 |
1462628 | 1462628 | 2021-06-28 | Sumter | Alabama | 1119 | 1062 | 32 |
1459383 | 1459383 | 2021-06-27 | Sumter | Alabama | 1119 | 1061 | 32 |
1456138 | 1456138 | 2021-06-26 | Sumter | Alabama | 1119 | 1061 | 32 |
1452893 | 1452893 | 2021-06-25 | Sumter | Alabama | 1119 | 1061 | 32 |
1449647 | 1449647 | 2021-06-24 | Sumter | Alabama | 1119 | 1060 | 32 |
1446402 | 1446402 | 2021-06-23 | Sumter | Alabama | 1119 | 1060 | 32 |
1443157 | 1443157 | 2021-06-22 | Sumter | Alabama | 1119 | 1058 | 32 |
1439912 | 1439912 | 2021-06-21 | Sumter | Alabama | 1119 | 1058 | 32 |
1436665 | 1436665 | 2021-06-20 | Sumter | Alabama | 1119 | 1057 | 32 |
1433418 | 1433418 | 2021-06-19 | Sumter | Alabama | 1119 | 1057 | 32 |
1430172 | 1430172 | 2021-06-18 | Sumter | Alabama | 1119 | 1057 | 32 |
1426927 | 1426927 | 2021-06-17 | Sumter | Alabama | 1119 | 1057 | 32 |
1423681 | 1423681 | 2021-06-16 | Sumter | Alabama | 1119 | 1057 | 32 |
1420434 | 1420434 | 2021-06-15 | Sumter | Alabama | 1119 | 1057 | 32 |
1417189 | 1417189 | 2021-06-14 | Sumter | Alabama | 1119 | 1057 | 32 |
1413943 | 1413943 | 2021-06-13 | Sumter | Alabama | 1119 | 1057 | 32 |
1410698 | 1410698 | 2021-06-12 | Sumter | Alabama | 1119 | 1057 | 32 |
1407453 | 1407453 | 2021-06-11 | Sumter | Alabama | 1119 | 1057 | 32 |
1404207 | 1404207 | 2021-06-10 | Sumter | Alabama | 1119 | 1057 | 32 |
1400962 | 1400962 | 2021-06-09 | Sumter | Alabama | 1119 | 1057 | 32 |
1397717 | 1397717 | 2021-06-08 | Sumter | Alabama | 1119 | 1057 | 32 |
1394470 | 1394470 | 2021-06-07 | Sumter | Alabama | 1119 | 1057 | 32 |
1391225 | 1391225 | 2021-06-06 | Sumter | Alabama | 1119 | 1057 | 32 |
1387980 | 1387980 | 2021-06-05 | Sumter | Alabama | 1119 | 1057 | 32 |
1384735 | 1384735 | 2021-06-04 | Sumter | Alabama | 1119 | 1057 | 32 |
1381489 | 1381489 | 2021-06-03 | Sumter | Alabama | 1119 | 1057 | 32 |
1378244 | 1378244 | 2021-06-02 | Sumter | Alabama | 1119 | 1056 | 32 |
1374998 | 1374998 | 2021-06-01 | Sumter | Alabama | 1119 | 1056 | 32 |
1371753 | 1371753 | 2021-05-31 | Sumter | Alabama | 1119 | 1056 | 32 |
1368507 | 1368507 | 2021-05-30 | Sumter | Alabama | 1119 | 1056 | 32 |
1365261 | 1365261 | 2021-05-29 | Sumter | Alabama | 1119 | 1056 | 32 |
1362015 | 1362015 | 2021-05-28 | Sumter | Alabama | 1119 | 1056 | 32 |
1358769 | 1358769 | 2021-05-27 | Sumter | Alabama | 1119 | 1056 | 32 |
1355523 | 1355523 | 2021-05-26 | Sumter | Alabama | 1119 | 1055 | 32 |
1352277 | 1352277 | 2021-05-25 | Sumter | Alabama | 1119 | 1054 | 32 |
1349031 | 1349031 | 2021-05-24 | Sumter | Alabama | 1119 | 1053 | 32 |
1345783 | 1345783 | 2021-05-23 | Sumter | Alabama | 1119 | 1053 | 32 |
1342535 | 1342535 | 2021-05-22 | Sumter | Alabama | 1119 | 1053 | 32 |
1339287 | 1339287 | 2021-05-21 | Sumter | Alabama | 1119 | 1053 | 32 |
1336040 | 1336040 | 2021-05-20 | Sumter | Alabama | 1119 | 1052 | 32 |
1332793 | 1332793 | 2021-05-19 | Sumter | Alabama | 1119 | 1052 | 32 |
1329546 | 1329546 | 2021-05-18 | Sumter | Alabama | 1119 | 1050 | 32 |
1326300 | 1326300 | 2021-05-17 | Sumter | Alabama | 1119 | 1050 | 32 |
1323054 | 1323054 | 2021-05-16 | Sumter | Alabama | 1119 | 1050 | 32 |
1319808 | 1319808 | 2021-05-15 | Sumter | Alabama | 1119 | 1049 | 32 |
1316560 | 1316560 | 2021-05-14 | Sumter | Alabama | 1119 | 1049 | 32 |
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);