ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,022 rows where state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Alabama · 887 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49623 | 49623 | 2022-08-16 | Alabama | 1 | 1449812 | 20026 |
49567 | 49567 | 2022-08-15 | Alabama | 1 | 1449812 | 20026 |
49511 | 49511 | 2022-08-14 | Alabama | 1 | 1449812 | 20026 |
49455 | 49455 | 2022-08-13 | Alabama | 1 | 1449812 | 20026 |
49399 | 49399 | 2022-08-12 | Alabama | 1 | 1449812 | 20026 |
49343 | 49343 | 2022-08-11 | Alabama | 1 | 1449812 | 20026 |
49287 | 49287 | 2022-08-10 | Alabama | 1 | 1436458 | 19974 |
49231 | 49231 | 2022-08-09 | Alabama | 1 | 1436458 | 19974 |
49175 | 49175 | 2022-08-08 | Alabama | 1 | 1436458 | 19974 |
49119 | 49119 | 2022-08-07 | Alabama | 1 | 1436458 | 19974 |
49063 | 49063 | 2022-08-06 | Alabama | 1 | 1436458 | 19974 |
49007 | 49007 | 2022-08-05 | Alabama | 1 | 1436458 | 19974 |
48951 | 48951 | 2022-08-04 | Alabama | 1 | 1436458 | 19974 |
48895 | 48895 | 2022-08-03 | Alabama | 1 | 1424411 | 19891 |
48839 | 48839 | 2022-08-02 | Alabama | 1 | 1424411 | 19891 |
48783 | 48783 | 2022-08-01 | Alabama | 1 | 1424411 | 19891 |
48727 | 48727 | 2022-07-31 | Alabama | 1 | 1424411 | 19891 |
48671 | 48671 | 2022-07-30 | Alabama | 1 | 1424411 | 19891 |
48615 | 48615 | 2022-07-29 | Alabama | 1 | 1424411 | 19891 |
48559 | 48559 | 2022-07-28 | Alabama | 1 | 1421760 | 19890 |
48503 | 48503 | 2022-07-27 | Alabama | 1 | 1419075 | 19890 |
48447 | 48447 | 2022-07-26 | Alabama | 1 | 1416310 | 19889 |
48391 | 48391 | 2022-07-25 | Alabama | 1 | 1413426 | 19888 |
48335 | 48335 | 2022-07-24 | Alabama | 1 | 1407699 | 19872 |
48279 | 48279 | 2022-07-23 | Alabama | 1 | 1407699 | 19872 |
48223 | 48223 | 2022-07-22 | Alabama | 1 | 1407699 | 19872 |
48167 | 48167 | 2022-07-21 | Alabama | 1 | 1404810 | 19859 |
48111 | 48111 | 2022-07-20 | Alabama | 1 | 1401893 | 19852 |
48055 | 48055 | 2022-07-19 | Alabama | 1 | 1398986 | 19836 |
47999 | 47999 | 2022-07-18 | Alabama | 1 | 1396285 | 19828 |
47943 | 47943 | 2022-07-17 | Alabama | 1 | 1390333 | 19822 |
47887 | 47887 | 2022-07-16 | Alabama | 1 | 1390333 | 19822 |
47831 | 47831 | 2022-07-15 | Alabama | 1 | 1390333 | 19822 |
47775 | 47775 | 2022-07-14 | Alabama | 1 | 1387729 | 19821 |
47719 | 47719 | 2022-07-13 | Alabama | 1 | 1384836 | 19812 |
47663 | 47663 | 2022-07-12 | Alabama | 1 | 1382137 | 19804 |
47607 | 47607 | 2022-07-11 | Alabama | 1 | 1378259 | 19795 |
47551 | 47551 | 2022-07-10 | Alabama | 1 | 1373684 | 19786 |
47495 | 47495 | 2022-07-09 | Alabama | 1 | 1373684 | 19786 |
47439 | 47439 | 2022-07-08 | Alabama | 1 | 1373684 | 19786 |
47383 | 47383 | 2022-07-07 | Alabama | 1 | 1370792 | 19781 |
47327 | 47327 | 2022-07-06 | Alabama | 1 | 1367570 | 19766 |
47271 | 47271 | 2022-07-05 | Alabama | 1 | 1363194 | 19766 |
47215 | 47215 | 2022-07-04 | Alabama | 1 | 1362388 | 19766 |
47159 | 47159 | 2022-07-03 | Alabama | 1 | 1359051 | 19759 |
47103 | 47103 | 2022-07-02 | Alabama | 1 | 1359051 | 19759 |
47047 | 47047 | 2022-07-01 | Alabama | 1 | 1359051 | 19759 |
46991 | 46991 | 2022-06-30 | Alabama | 1 | 1357266 | 19755 |
46935 | 46935 | 2022-06-29 | Alabama | 1 | 1355340 | 19740 |
46879 | 46879 | 2022-06-28 | Alabama | 1 | 1352915 | 19739 |
46823 | 46823 | 2022-06-27 | Alabama | 1 | 1350735 | 19734 |
46767 | 46767 | 2022-06-26 | Alabama | 1 | 1346268 | 19729 |
46711 | 46711 | 2022-06-25 | Alabama | 1 | 1346268 | 19729 |
46655 | 46655 | 2022-06-24 | Alabama | 1 | 1346268 | 19729 |
46599 | 46599 | 2022-06-23 | Alabama | 1 | 1344233 | 19723 |
46543 | 46543 | 2022-06-22 | Alabama | 1 | 1342150 | 19722 |
46487 | 46487 | 2022-06-21 | Alabama | 1 | 1340110 | 19697 |
46431 | 46431 | 2022-06-20 | Alabama | 1 | 1338177 | 19697 |
46375 | 46375 | 2022-06-19 | Alabama | 1 | 1334981 | 19696 |
46319 | 46319 | 2022-06-18 | Alabama | 1 | 1334981 | 19696 |
46263 | 46263 | 2022-06-17 | Alabama | 1 | 1334981 | 19696 |
46207 | 46207 | 2022-06-16 | Alabama | 1 | 1333137 | 19696 |
46151 | 46151 | 2022-06-15 | Alabama | 1 | 1331452 | 19696 |
46095 | 46095 | 2022-06-14 | Alabama | 1 | 1329827 | 19695 |
46039 | 46039 | 2022-06-13 | Alabama | 1 | 1328321 | 19695 |
45983 | 45983 | 2022-06-12 | Alabama | 1 | 1325361 | 19692 |
45927 | 45927 | 2022-06-11 | Alabama | 1 | 1325361 | 19692 |
45871 | 45871 | 2022-06-10 | Alabama | 1 | 1325361 | 19692 |
45815 | 45815 | 2022-06-09 | Alabama | 1 | 1324178 | 19684 |
45759 | 45759 | 2022-06-08 | Alabama | 1 | 1322957 | 19676 |
45703 | 45703 | 2022-06-07 | Alabama | 1 | 1321892 | 19676 |
45647 | 45647 | 2022-06-06 | Alabama | 1 | 1320708 | 19676 |
45591 | 45591 | 2022-06-05 | Alabama | 1 | 1317029 | 19664 |
45535 | 45535 | 2022-06-04 | Alabama | 1 | 1317029 | 19664 |
45479 | 45479 | 2022-06-03 | Alabama | 1 | 1317029 | 19664 |
45423 | 45423 | 2022-06-02 | Alabama | 1 | 1317029 | 19664 |
45367 | 45367 | 2022-06-01 | Alabama | 1 | 1315934 | 19664 |
45311 | 45311 | 2022-05-31 | Alabama | 1 | 1314963 | 19664 |
45255 | 45255 | 2022-05-30 | Alabama | 1 | 1312437 | 19658 |
45199 | 45199 | 2022-05-29 | Alabama | 1 | 1312437 | 19658 |
45143 | 45143 | 2022-05-28 | Alabama | 1 | 1312437 | 19658 |
45087 | 45087 | 2022-05-27 | Alabama | 1 | 1312437 | 19658 |
45031 | 45031 | 2022-05-26 | Alabama | 1 | 1311381 | 19651 |
44975 | 44975 | 2022-05-25 | Alabama | 1 | 1310513 | 19651 |
44919 | 44919 | 2022-05-24 | Alabama | 1 | 1309743 | 19650 |
44863 | 44863 | 2022-05-23 | Alabama | 1 | 1309185 | 19649 |
44807 | 44807 | 2022-05-22 | Alabama | 1 | 1307883 | 19645 |
44751 | 44751 | 2022-05-21 | Alabama | 1 | 1307883 | 19645 |
44695 | 44695 | 2022-05-20 | Alabama | 1 | 1307883 | 19645 |
44639 | 44639 | 2022-05-19 | Alabama | 1 | 1307291 | 19641 |
44583 | 44583 | 2022-05-18 | Alabama | 1 | 1306662 | 19633 |
44527 | 44527 | 2022-05-17 | Alabama | 1 | 1306116 | 19633 |
44471 | 44471 | 2022-05-16 | Alabama | 1 | 1305665 | 19631 |
44415 | 44415 | 2022-05-15 | Alabama | 1 | 1304710 | 19628 |
44359 | 44359 | 2022-05-14 | Alabama | 1 | 1304710 | 19628 |
44303 | 44303 | 2022-05-13 | Alabama | 1 | 1304710 | 19628 |
44247 | 44247 | 2022-05-12 | Alabama | 1 | 1304291 | 19623 |
44191 | 44191 | 2022-05-11 | Alabama | 1 | 1303835 | 19606 |
44135 | 44135 | 2022-05-10 | Alabama | 1 | 1303441 | 19606 |
44079 | 44079 | 2022-05-09 | Alabama | 1 | 1302945 | 19601 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );