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)
Suggested facets: cases, deaths, date (date)
state 1
- Alabama · 1,022 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
57183 | 57183 | 2022-12-29 | Alabama | 1 | 1573637 | 21208 |
57127 | 57127 | 2022-12-28 | Alabama | 1 | 1568934 | 21208 |
57071 | 57071 | 2022-12-27 | Alabama | 1 | 1568934 | 21208 |
57015 | 57015 | 2022-12-26 | Alabama | 1 | 1568934 | 21208 |
56959 | 56959 | 2022-12-25 | Alabama | 1 | 1568934 | 21208 |
56903 | 56903 | 2022-12-24 | Alabama | 1 | 1568934 | 21208 |
56847 | 56847 | 2022-12-23 | Alabama | 1 | 1568934 | 21208 |
56791 | 56791 | 2022-12-22 | Alabama | 1 | 1568934 | 21208 |
56735 | 56735 | 2022-12-21 | Alabama | 1 | 1568934 | 21208 |
56679 | 56679 | 2022-12-20 | Alabama | 1 | 1561557 | 21178 |
56623 | 56623 | 2022-12-19 | Alabama | 1 | 1561557 | 21178 |
56567 | 56567 | 2022-12-18 | Alabama | 1 | 1561557 | 21178 |
56511 | 56511 | 2022-12-17 | Alabama | 1 | 1561557 | 21178 |
56455 | 56455 | 2022-12-16 | Alabama | 1 | 1561557 | 21178 |
56399 | 56399 | 2022-12-15 | Alabama | 1 | 1561557 | 21178 |
56343 | 56343 | 2022-12-14 | Alabama | 1 | 1561557 | 21178 |
56287 | 56287 | 2022-12-13 | Alabama | 1 | 1555092 | 21164 |
56231 | 56231 | 2022-12-12 | Alabama | 1 | 1555092 | 21164 |
56175 | 56175 | 2022-12-11 | Alabama | 1 | 1555092 | 21164 |
56119 | 56119 | 2022-12-10 | Alabama | 1 | 1555092 | 21164 |
56063 | 56063 | 2022-12-09 | Alabama | 1 | 1555092 | 21164 |
56007 | 56007 | 2022-12-08 | Alabama | 1 | 1555092 | 21164 |
55951 | 55951 | 2022-12-07 | Alabama | 1 | 1555092 | 21149 |
55895 | 55895 | 2022-12-06 | Alabama | 1 | 1549285 | 21129 |
55839 | 55839 | 2022-12-05 | Alabama | 1 | 1549285 | 21129 |
55783 | 55783 | 2022-12-04 | Alabama | 1 | 1549285 | 21129 |
55727 | 55727 | 2022-12-03 | Alabama | 1 | 1549285 | 21129 |
55671 | 55671 | 2022-12-02 | Alabama | 1 | 1549285 | 21129 |
55615 | 55615 | 2022-12-01 | Alabama | 1 | 1549285 | 21129 |
55559 | 55559 | 2022-11-30 | Alabama | 1 | 1549285 | 21129 |
55503 | 55503 | 2022-11-29 | Alabama | 1 | 1545099 | 21112 |
55447 | 55447 | 2022-11-28 | Alabama | 1 | 1545099 | 21112 |
55391 | 55391 | 2022-11-27 | Alabama | 1 | 1545099 | 21112 |
55335 | 55335 | 2022-11-26 | Alabama | 1 | 1545099 | 21112 |
55279 | 55279 | 2022-11-25 | Alabama | 1 | 1545099 | 21112 |
55223 | 55223 | 2022-11-24 | Alabama | 1 | 1545099 | 21112 |
55167 | 55167 | 2022-11-23 | Alabama | 1 | 1545099 | 21112 |
55111 | 55111 | 2022-11-22 | Alabama | 1 | 1542227 | 21100 |
55055 | 55055 | 2022-11-21 | Alabama | 1 | 1542227 | 21100 |
54999 | 54999 | 2022-11-20 | Alabama | 1 | 1542227 | 21100 |
54943 | 54943 | 2022-11-19 | Alabama | 1 | 1542227 | 21100 |
54887 | 54887 | 2022-11-18 | Alabama | 1 | 1542227 | 21100 |
54831 | 54831 | 2022-11-17 | Alabama | 1 | 1542227 | 21100 |
54775 | 54775 | 2022-11-16 | Alabama | 1 | 1542227 | 21100 |
54719 | 54719 | 2022-11-15 | Alabama | 1 | 1540329 | 21093 |
54663 | 54663 | 2022-11-14 | Alabama | 1 | 1540329 | 21093 |
54607 | 54607 | 2022-11-13 | Alabama | 1 | 1540329 | 21093 |
54551 | 54551 | 2022-11-12 | Alabama | 1 | 1540329 | 21093 |
54495 | 54495 | 2022-11-11 | Alabama | 1 | 1540329 | 21093 |
54439 | 54439 | 2022-11-10 | Alabama | 1 | 1540329 | 20608 |
54383 | 54383 | 2022-11-09 | Alabama | 1 | 1534287 | 20558 |
54327 | 54327 | 2022-11-08 | Alabama | 1 | 1534287 | 20558 |
54271 | 54271 | 2022-11-07 | Alabama | 1 | 1534287 | 20558 |
54215 | 54215 | 2022-11-06 | Alabama | 1 | 1534287 | 20558 |
54159 | 54159 | 2022-11-05 | Alabama | 1 | 1534287 | 20558 |
54103 | 54103 | 2022-11-04 | Alabama | 1 | 1534287 | 20558 |
54047 | 54047 | 2022-11-03 | Alabama | 1 | 1534287 | 20558 |
53991 | 53991 | 2022-11-02 | Alabama | 1 | 1534287 | 20558 |
53935 | 53935 | 2022-11-01 | Alabama | 1 | 1534287 | 20558 |
53879 | 53879 | 2022-10-31 | Alabama | 1 | 1534287 | 20558 |
53823 | 53823 | 2022-10-30 | Alabama | 1 | 1534287 | 20558 |
53767 | 53767 | 2022-10-29 | Alabama | 1 | 1534287 | 20558 |
53711 | 53711 | 2022-10-28 | Alabama | 1 | 1534287 | 20558 |
53655 | 53655 | 2022-10-27 | Alabama | 1 | 1534287 | 20558 |
53599 | 53599 | 2022-10-26 | Alabama | 1 | 1531305 | 20533 |
53543 | 53543 | 2022-10-25 | Alabama | 1 | 1531305 | 20533 |
53487 | 53487 | 2022-10-24 | Alabama | 1 | 1531305 | 20533 |
53431 | 53431 | 2022-10-23 | Alabama | 1 | 1531305 | 20533 |
53375 | 53375 | 2022-10-22 | Alabama | 1 | 1531305 | 20533 |
53319 | 53319 | 2022-10-21 | Alabama | 1 | 1531305 | 20533 |
53263 | 53263 | 2022-10-20 | Alabama | 1 | 1531305 | 20533 |
53207 | 53207 | 2022-10-19 | Alabama | 1 | 1530803 | 20526 |
53151 | 53151 | 2022-10-18 | Alabama | 1 | 1530411 | 20522 |
53095 | 53095 | 2022-10-17 | Alabama | 1 | 1529939 | 20508 |
53039 | 53039 | 2022-10-16 | Alabama | 1 | 1528739 | 20505 |
52983 | 52983 | 2022-10-15 | Alabama | 1 | 1528739 | 20505 |
52927 | 52927 | 2022-10-14 | Alabama | 1 | 1528739 | 20505 |
52871 | 52871 | 2022-10-13 | Alabama | 1 | 1528739 | 20505 |
52815 | 52815 | 2022-10-12 | Alabama | 1 | 1528319 | 20498 |
52759 | 52759 | 2022-10-11 | Alabama | 1 | 1527825 | 20489 |
52703 | 52703 | 2022-10-10 | Alabama | 1 | 1526381 | 20473 |
52647 | 52647 | 2022-10-09 | Alabama | 1 | 1526381 | 20473 |
52591 | 52591 | 2022-10-08 | Alabama | 1 | 1526381 | 20473 |
52535 | 52535 | 2022-10-07 | Alabama | 1 | 1526381 | 20473 |
52479 | 52479 | 2022-10-06 | Alabama | 1 | 1525724 | 20473 |
52423 | 52423 | 2022-10-05 | Alabama | 1 | 1525116 | 20455 |
52367 | 52367 | 2022-10-04 | Alabama | 1 | 1524549 | 20423 |
52311 | 52311 | 2022-10-03 | Alabama | 1 | 1523890 | 20423 |
52255 | 52255 | 2022-10-02 | Alabama | 1 | 1522879 | 20423 |
52199 | 52199 | 2022-10-01 | Alabama | 1 | 1522879 | 20423 |
52143 | 52143 | 2022-09-30 | Alabama | 1 | 1522879 | 20423 |
52087 | 52087 | 2022-09-29 | Alabama | 1 | 1522135 | 20422 |
52031 | 52031 | 2022-09-28 | Alabama | 1 | 1521363 | 20419 |
51975 | 51975 | 2022-09-27 | Alabama | 1 | 1520712 | 20402 |
51919 | 51919 | 2022-09-26 | Alabama | 1 | 1520092 | 20400 |
51863 | 51863 | 2022-09-25 | Alabama | 1 | 1517904 | 20395 |
51807 | 51807 | 2022-09-24 | Alabama | 1 | 1517904 | 20395 |
51751 | 51751 | 2022-09-23 | Alabama | 1 | 1517904 | 20395 |
51695 | 51695 | 2022-09-22 | Alabama | 1 | 1517904 | 20395 |
51639 | 51639 | 2022-09-21 | Alabama | 1 | 1517046 | 20380 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );