ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where deaths = 188 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1923847 | 1923847 | 2021-11-17 | Blount | Alabama | 1009 | 10568 | 188 |
1920598 | 1920598 | 2021-11-16 | Blount | Alabama | 1009 | 10548 | 188 |
1917348 | 1917348 | 2021-11-15 | Blount | Alabama | 1009 | 10536 | 188 |
1914098 | 1914098 | 2021-11-14 | Blount | Alabama | 1009 | 10534 | 188 |
1910848 | 1910848 | 2021-11-13 | Blount | Alabama | 1009 | 10530 | 188 |
1907617 | 1907617 | 2021-11-12 | Dale | Alabama | 1045 | 8988 | 188 |
1904368 | 1904368 | 2021-11-11 | Dale | Alabama | 1045 | 8984 | 188 |
1881616 | 1881616 | 2021-11-04 | Covington | Alabama | 1039 | 6768 | 188 |
1881619 | 1881619 | 2021-11-04 | Dale | Alabama | 1045 | 8952 | 188 |
1878370 | 1878370 | 2021-11-03 | Dale | Alabama | 1045 | 8954 | 188 |
1875121 | 1875121 | 2021-11-02 | Dale | Alabama | 1045 | 8954 | 188 |
1875134 | 1875134 | 2021-11-02 | Jackson | Alabama | 1071 | 10087 | 188 |
1871885 | 1871885 | 2021-11-01 | Jackson | Alabama | 1071 | 10059 | 188 |
1868636 | 1868636 | 2021-10-31 | Jackson | Alabama | 1071 | 10059 | 188 |
1865387 | 1865387 | 2021-10-30 | Jackson | Alabama | 1071 | 10055 | 188 |
1816629 | 1816629 | 2021-10-15 | Coffee | Alabama | 1031 | 9176 | 188 |
1813381 | 1813381 | 2021-10-14 | Coffee | Alabama | 1031 | 9171 | 188 |
1784140 | 1784140 | 2021-10-05 | Colbert | Alabama | 1033 | 8661 | 188 |
1771186 | 1771186 | 2021-10-01 | Tallapoosa | Alabama | 1123 | 6794 | 188 |
1758171 | 1758171 | 2021-09-27 | Limestone | Alabama | 1083 | 14609 | 188 |
1754923 | 1754923 | 2021-09-26 | Limestone | Alabama | 1083 | 14581 | 188 |
1751675 | 1751675 | 2021-09-25 | Limestone | Alabama | 1083 | 14553 | 188 |
1621733 | 1621733 | 2021-08-16 | Lee | Alabama | 1081 | 18461 | 188 |
1618485 | 1618485 | 2021-08-15 | Lee | Alabama | 1081 | 18400 | 188 |
1599014 | 1599014 | 2021-08-09 | Talladega | Alabama | 1121 | 9200 | 188 |
1595765 | 1595765 | 2021-08-08 | Talladega | Alabama | 1121 | 9141 | 188 |
1592516 | 1592516 | 2021-08-07 | Talladega | Alabama | 1121 | 9141 | 188 |
1589267 | 1589267 | 2021-08-06 | Talladega | Alabama | 1121 | 9105 | 188 |
1586018 | 1586018 | 2021-08-05 | Talladega | Alabama | 1121 | 9074 | 188 |
1582768 | 1582768 | 2021-08-04 | Talladega | Alabama | 1121 | 9032 | 188 |
1579518 | 1579518 | 2021-08-03 | Talladega | Alabama | 1121 | 9005 | 188 |
1576270 | 1576270 | 2021-08-02 | Talladega | Alabama | 1121 | 8972 | 188 |
1573022 | 1573022 | 2021-08-01 | Talladega | Alabama | 1121 | 8949 | 188 |
1569774 | 1569774 | 2021-07-31 | Talladega | Alabama | 1121 | 8935 | 188 |
1566526 | 1566526 | 2021-07-30 | Talladega | Alabama | 1121 | 8869 | 188 |
1563278 | 1563278 | 2021-07-29 | Talladega | Alabama | 1121 | 8869 | 188 |
1560030 | 1560030 | 2021-07-28 | Talladega | Alabama | 1121 | 8836 | 188 |
1404172 | 1404172 | 2021-06-10 | DeKalb | Alabama | 1049 | 8953 | 188 |
1400927 | 1400927 | 2021-06-09 | DeKalb | Alabama | 1049 | 8953 | 188 |
1397682 | 1397682 | 2021-06-08 | DeKalb | Alabama | 1049 | 8951 | 188 |
1394435 | 1394435 | 2021-06-07 | DeKalb | Alabama | 1049 | 8951 | 188 |
1391190 | 1391190 | 2021-06-06 | DeKalb | Alabama | 1049 | 8943 | 188 |
1387945 | 1387945 | 2021-06-05 | DeKalb | Alabama | 1049 | 8943 | 188 |
1384700 | 1384700 | 2021-06-04 | DeKalb | Alabama | 1049 | 8943 | 188 |
1381454 | 1381454 | 2021-06-03 | DeKalb | Alabama | 1049 | 8931 | 188 |
1378209 | 1378209 | 2021-06-02 | DeKalb | Alabama | 1049 | 8911 | 188 |
1374963 | 1374963 | 2021-06-01 | DeKalb | Alabama | 1049 | 8908 | 188 |
1371718 | 1371718 | 2021-05-31 | DeKalb | Alabama | 1049 | 8896 | 188 |
1368472 | 1368472 | 2021-05-30 | DeKalb | Alabama | 1049 | 8896 | 188 |
1365226 | 1365226 | 2021-05-29 | DeKalb | Alabama | 1049 | 8896 | 188 |
1361980 | 1361980 | 2021-05-28 | DeKalb | Alabama | 1049 | 8896 | 188 |
1358734 | 1358734 | 2021-05-27 | DeKalb | Alabama | 1049 | 8893 | 188 |
1355488 | 1355488 | 2021-05-26 | DeKalb | Alabama | 1049 | 8890 | 188 |
1352242 | 1352242 | 2021-05-25 | DeKalb | Alabama | 1049 | 8891 | 188 |
1348996 | 1348996 | 2021-05-24 | DeKalb | Alabama | 1049 | 8888 | 188 |
1345748 | 1345748 | 2021-05-23 | DeKalb | Alabama | 1049 | 8886 | 188 |
1342500 | 1342500 | 2021-05-22 | DeKalb | Alabama | 1049 | 8886 | 188 |
1339252 | 1339252 | 2021-05-21 | DeKalb | Alabama | 1049 | 8885 | 188 |
1336005 | 1336005 | 2021-05-20 | DeKalb | Alabama | 1049 | 8877 | 188 |
1332758 | 1332758 | 2021-05-19 | DeKalb | Alabama | 1049 | 8872 | 188 |
1329511 | 1329511 | 2021-05-18 | DeKalb | Alabama | 1049 | 8870 | 188 |
1326265 | 1326265 | 2021-05-17 | DeKalb | Alabama | 1049 | 8866 | 188 |
1323019 | 1323019 | 2021-05-16 | DeKalb | Alabama | 1049 | 8865 | 188 |
1319773 | 1319773 | 2021-05-15 | DeKalb | Alabama | 1049 | 8865 | 188 |
1316525 | 1316525 | 2021-05-14 | DeKalb | Alabama | 1049 | 8853 | 188 |
1219115 | 1219115 | 2021-04-14 | Cullman | Alabama | 1043 | 9492 | 188 |
1215867 | 1215867 | 2021-04-13 | Cullman | Alabama | 1043 | 9481 | 188 |
1212620 | 1212620 | 2021-04-12 | Cullman | Alabama | 1043 | 9475 | 188 |
1209371 | 1209371 | 2021-04-11 | Cullman | Alabama | 1043 | 9470 | 188 |
1206123 | 1206123 | 2021-04-10 | Cullman | Alabama | 1043 | 9467 | 188 |
1202875 | 1202875 | 2021-04-09 | Cullman | Alabama | 1043 | 9458 | 188 |
1199627 | 1199627 | 2021-04-08 | Cullman | Alabama | 1043 | 9450 | 188 |
1196378 | 1196378 | 2021-04-07 | Cullman | Alabama | 1043 | 9437 | 188 |
1193130 | 1193130 | 2021-04-06 | Cullman | Alabama | 1043 | 9421 | 188 |
1014616 | 1014616 | 2021-02-10 | Shelby | Alabama | 1117 | 21049 | 188 |
988643 | 988643 | 2021-02-02 | Morgan | Alabama | 1103 | 13048 | 188 |
952893 | 952893 | 2021-01-22 | Baldwin | Alabama | 1003 | 16981 | 188 |
949648 | 949648 | 2021-01-21 | Baldwin | Alabama | 1003 | 16798 | 188 |
612234 | 612234 | 2020-10-09 | Montgomery | Alabama | 1101 | 9152 | 188 |
608992 | 608992 | 2020-10-08 | Montgomery | Alabama | 1101 | 9107 | 188 |
605749 | 605749 | 2020-10-07 | Montgomery | Alabama | 1101 | 9083 | 188 |
602507 | 602507 | 2020-10-06 | Montgomery | Alabama | 1101 | 9061 | 188 |
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);