ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
375 rows where deaths = 34 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Greene 98
- Lamar 30
- Sumter 26
- Escambia 20
- Franklin 20
- Jackson 20
- Clay 16
- Choctaw 14
- Russell 13
- DeKalb 10
- Covington 9
- Dallas 9
- Conecuh 8
- Lee 8
- Blount 7
- Houston 7
- St. Clair 6
- Elmore 5
- Marengo 5
- Talladega 5
- Winston 5
- Limestone 4
- Lawrence 3
- Lowndes 3
- Montgomery 3
- Shelby 3
- Butler 2
- Chambers 2
- Hale 2
- Lauderdale 2
- …
state 1
- Alabama · 375 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2262006 | 2262006 | 2022-03-01 | Choctaw | Alabama | 1023 | 2033 | 34 |
2258755 | 2258755 | 2022-02-28 | Choctaw | Alabama | 1023 | 2017 | 34 |
2255504 | 2255504 | 2022-02-27 | Choctaw | Alabama | 1023 | 2017 | 34 |
2252253 | 2252253 | 2022-02-26 | Choctaw | Alabama | 1023 | 2017 | 34 |
2249002 | 2249002 | 2022-02-25 | Choctaw | Alabama | 1023 | 2004 | 34 |
2245751 | 2245751 | 2022-02-24 | Choctaw | Alabama | 1023 | 2003 | 34 |
2242500 | 2242500 | 2022-02-23 | Choctaw | Alabama | 1023 | 1998 | 34 |
2239249 | 2239249 | 2022-02-22 | Choctaw | Alabama | 1023 | 1995 | 34 |
2235998 | 2235998 | 2022-02-21 | Choctaw | Alabama | 1023 | 1995 | 34 |
2232747 | 2232747 | 2022-02-20 | Choctaw | Alabama | 1023 | 1995 | 34 |
2229496 | 2229496 | 2022-02-19 | Choctaw | Alabama | 1023 | 1995 | 34 |
2226245 | 2226245 | 2022-02-18 | Choctaw | Alabama | 1023 | 1994 | 34 |
2222994 | 2222994 | 2022-02-17 | Choctaw | Alabama | 1023 | 1990 | 34 |
2219743 | 2219743 | 2022-02-16 | Choctaw | Alabama | 1023 | 1964 | 34 |
1725703 | 1725703 | 2021-09-17 | Wilcox | Alabama | 1131 | 1539 | 34 |
1673722 | 1673722 | 2021-09-01 | Sumter | Alabama | 1119 | 1191 | 34 |
1670474 | 1670474 | 2021-08-31 | Sumter | Alabama | 1119 | 1182 | 34 |
1667227 | 1667227 | 2021-08-30 | Sumter | Alabama | 1119 | 1179 | 34 |
1663979 | 1663979 | 2021-08-29 | Sumter | Alabama | 1119 | 1179 | 34 |
1660731 | 1660731 | 2021-08-28 | Sumter | Alabama | 1119 | 1178 | 34 |
1657483 | 1657483 | 2021-08-27 | Sumter | Alabama | 1119 | 1175 | 34 |
1654193 | 1654193 | 2021-08-26 | Conecuh | Alabama | 1035 | 1484 | 34 |
1654235 | 1654235 | 2021-08-26 | Sumter | Alabama | 1119 | 1171 | 34 |
1650947 | 1650947 | 2021-08-25 | Conecuh | Alabama | 1035 | 1450 | 34 |
1650989 | 1650989 | 2021-08-25 | Sumter | Alabama | 1119 | 1163 | 34 |
1647698 | 1647698 | 2021-08-24 | Conecuh | Alabama | 1035 | 1450 | 34 |
1647740 | 1647740 | 2021-08-24 | Sumter | Alabama | 1119 | 1163 | 34 |
1644449 | 1644449 | 2021-08-23 | Conecuh | Alabama | 1035 | 1450 | 34 |
1644491 | 1644491 | 2021-08-23 | Sumter | Alabama | 1119 | 1163 | 34 |
1641199 | 1641199 | 2021-08-22 | Conecuh | Alabama | 1035 | 1441 | 34 |
1641241 | 1641241 | 2021-08-22 | Sumter | Alabama | 1119 | 1161 | 34 |
1637949 | 1637949 | 2021-08-21 | Conecuh | Alabama | 1035 | 1430 | 34 |
1637991 | 1637991 | 2021-08-21 | Sumter | Alabama | 1119 | 1159 | 34 |
1634699 | 1634699 | 2021-08-20 | Conecuh | Alabama | 1035 | 1412 | 34 |
1634741 | 1634741 | 2021-08-20 | Sumter | Alabama | 1119 | 1159 | 34 |
1631451 | 1631451 | 2021-08-19 | Conecuh | Alabama | 1035 | 1404 | 34 |
1631493 | 1631493 | 2021-08-19 | Sumter | Alabama | 1119 | 1153 | 34 |
1628246 | 1628246 | 2021-08-18 | Sumter | Alabama | 1119 | 1151 | 34 |
1624999 | 1624999 | 2021-08-17 | Sumter | Alabama | 1119 | 1149 | 34 |
1621752 | 1621752 | 2021-08-16 | Sumter | Alabama | 1119 | 1144 | 34 |
1618504 | 1618504 | 2021-08-15 | Sumter | Alabama | 1119 | 1144 | 34 |
1615256 | 1615256 | 2021-08-14 | Sumter | Alabama | 1119 | 1138 | 34 |
1612007 | 1612007 | 2021-08-13 | Sumter | Alabama | 1119 | 1138 | 34 |
1608760 | 1608760 | 2021-08-12 | Sumter | Alabama | 1119 | 1130 | 34 |
1605511 | 1605511 | 2021-08-11 | Sumter | Alabama | 1119 | 1124 | 34 |
1602261 | 1602261 | 2021-08-10 | Sumter | Alabama | 1119 | 1123 | 34 |
1599013 | 1599013 | 2021-08-09 | Sumter | Alabama | 1119 | 1119 | 34 |
1595764 | 1595764 | 2021-08-08 | Sumter | Alabama | 1119 | 1116 | 34 |
1592515 | 1592515 | 2021-08-07 | Sumter | Alabama | 1119 | 1116 | 34 |
1472335 | 1472335 | 2021-07-01 | Greene | Alabama | 1063 | 937 | 34 |
1469090 | 1469090 | 2021-06-30 | Greene | Alabama | 1063 | 937 | 34 |
1465845 | 1465845 | 2021-06-29 | Greene | Alabama | 1063 | 937 | 34 |
1462600 | 1462600 | 2021-06-28 | Greene | Alabama | 1063 | 937 | 34 |
1459355 | 1459355 | 2021-06-27 | Greene | Alabama | 1063 | 937 | 34 |
1456110 | 1456110 | 2021-06-26 | Greene | Alabama | 1063 | 937 | 34 |
1452865 | 1452865 | 2021-06-25 | Greene | Alabama | 1063 | 937 | 34 |
1449619 | 1449619 | 2021-06-24 | Greene | Alabama | 1063 | 937 | 34 |
1446374 | 1446374 | 2021-06-23 | Greene | Alabama | 1063 | 937 | 34 |
1443129 | 1443129 | 2021-06-22 | Greene | Alabama | 1063 | 936 | 34 |
1439884 | 1439884 | 2021-06-21 | Greene | Alabama | 1063 | 936 | 34 |
1436637 | 1436637 | 2021-06-20 | Greene | Alabama | 1063 | 936 | 34 |
1433390 | 1433390 | 2021-06-19 | Greene | Alabama | 1063 | 936 | 34 |
1430144 | 1430144 | 2021-06-18 | Greene | Alabama | 1063 | 936 | 34 |
1426899 | 1426899 | 2021-06-17 | Greene | Alabama | 1063 | 935 | 34 |
1423653 | 1423653 | 2021-06-16 | Greene | Alabama | 1063 | 935 | 34 |
1420406 | 1420406 | 2021-06-15 | Greene | Alabama | 1063 | 934 | 34 |
1417161 | 1417161 | 2021-06-14 | Greene | Alabama | 1063 | 934 | 34 |
1413915 | 1413915 | 2021-06-13 | Greene | Alabama | 1063 | 934 | 34 |
1410670 | 1410670 | 2021-06-12 | Greene | Alabama | 1063 | 934 | 34 |
1407425 | 1407425 | 2021-06-11 | Greene | Alabama | 1063 | 934 | 34 |
1404179 | 1404179 | 2021-06-10 | Greene | Alabama | 1063 | 934 | 34 |
1400934 | 1400934 | 2021-06-09 | Greene | Alabama | 1063 | 934 | 34 |
1397689 | 1397689 | 2021-06-08 | Greene | Alabama | 1063 | 933 | 34 |
1394442 | 1394442 | 2021-06-07 | Greene | Alabama | 1063 | 932 | 34 |
1391197 | 1391197 | 2021-06-06 | Greene | Alabama | 1063 | 932 | 34 |
1387952 | 1387952 | 2021-06-05 | Greene | Alabama | 1063 | 932 | 34 |
1384707 | 1384707 | 2021-06-04 | Greene | Alabama | 1063 | 932 | 34 |
1381461 | 1381461 | 2021-06-03 | Greene | Alabama | 1063 | 931 | 34 |
1378216 | 1378216 | 2021-06-02 | Greene | Alabama | 1063 | 931 | 34 |
1374970 | 1374970 | 2021-06-01 | Greene | Alabama | 1063 | 930 | 34 |
1371725 | 1371725 | 2021-05-31 | Greene | Alabama | 1063 | 928 | 34 |
1368479 | 1368479 | 2021-05-30 | Greene | Alabama | 1063 | 928 | 34 |
1365233 | 1365233 | 2021-05-29 | Greene | Alabama | 1063 | 928 | 34 |
1361987 | 1361987 | 2021-05-28 | Greene | Alabama | 1063 | 928 | 34 |
1358741 | 1358741 | 2021-05-27 | Greene | Alabama | 1063 | 928 | 34 |
1355495 | 1355495 | 2021-05-26 | Greene | Alabama | 1063 | 928 | 34 |
1352249 | 1352249 | 2021-05-25 | Greene | Alabama | 1063 | 927 | 34 |
1349003 | 1349003 | 2021-05-24 | Greene | Alabama | 1063 | 927 | 34 |
1345755 | 1345755 | 2021-05-23 | Greene | Alabama | 1063 | 927 | 34 |
1342507 | 1342507 | 2021-05-22 | Greene | Alabama | 1063 | 927 | 34 |
1339259 | 1339259 | 2021-05-21 | Greene | Alabama | 1063 | 926 | 34 |
1336012 | 1336012 | 2021-05-20 | Greene | Alabama | 1063 | 926 | 34 |
1332765 | 1332765 | 2021-05-19 | Greene | Alabama | 1063 | 926 | 34 |
1329518 | 1329518 | 2021-05-18 | Greene | Alabama | 1063 | 926 | 34 |
1326272 | 1326272 | 2021-05-17 | Greene | Alabama | 1063 | 926 | 34 |
1323026 | 1323026 | 2021-05-16 | Greene | Alabama | 1063 | 926 | 34 |
1319780 | 1319780 | 2021-05-15 | Greene | Alabama | 1063 | 926 | 34 |
1316532 | 1316532 | 2021-05-14 | Greene | Alabama | 1063 | 926 | 34 |
1313286 | 1313286 | 2021-05-13 | Greene | Alabama | 1063 | 925 | 34 |
1310039 | 1310039 | 2021-05-12 | Greene | Alabama | 1063 | 925 | 34 |
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);