ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Blount" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712651 | 1712651 | 2021-09-13 | Blount | Alabama | 1009 | 9199 | 146 |
1709404 | 1709404 | 2021-09-12 | Blount | Alabama | 1009 | 9176 | 146 |
1706157 | 1706157 | 2021-09-11 | Blount | Alabama | 1009 | 9161 | 146 |
1702909 | 1702909 | 2021-09-10 | Blount | Alabama | 1009 | 9095 | 146 |
1699659 | 1699659 | 2021-09-09 | Blount | Alabama | 1009 | 9048 | 147 |
1696410 | 1696410 | 2021-09-08 | Blount | Alabama | 1009 | 8998 | 147 |
1693162 | 1693162 | 2021-09-07 | Blount | Alabama | 1009 | 8951 | 146 |
1689913 | 1689913 | 2021-09-06 | Blount | Alabama | 1009 | 8899 | 146 |
1686663 | 1686663 | 2021-09-05 | Blount | Alabama | 1009 | 8862 | 146 |
1683413 | 1683413 | 2021-09-04 | Blount | Alabama | 1009 | 8830 | 146 |
1680162 | 1680162 | 2021-09-03 | Blount | Alabama | 1009 | 8763 | 146 |
1676914 | 1676914 | 2021-09-02 | Blount | Alabama | 1009 | 8699 | 145 |
1673667 | 1673667 | 2021-09-01 | Blount | Alabama | 1009 | 8631 | 145 |
1670419 | 1670419 | 2021-08-31 | Blount | Alabama | 1009 | 8595 | 145 |
1667172 | 1667172 | 2021-08-30 | Blount | Alabama | 1009 | 8530 | 144 |
1663924 | 1663924 | 2021-08-29 | Blount | Alabama | 1009 | 8512 | 144 |
1660676 | 1660676 | 2021-08-28 | Blount | Alabama | 1009 | 8482 | 144 |
1657428 | 1657428 | 2021-08-27 | Blount | Alabama | 1009 | 8413 | 143 |
1654180 | 1654180 | 2021-08-26 | Blount | Alabama | 1009 | 8340 | 142 |
1650934 | 1650934 | 2021-08-25 | Blount | Alabama | 1009 | 8173 | 142 |
1647685 | 1647685 | 2021-08-24 | Blount | Alabama | 1009 | 8173 | 142 |
1644436 | 1644436 | 2021-08-23 | Blount | Alabama | 1009 | 8173 | 142 |
1641186 | 1641186 | 2021-08-22 | Blount | Alabama | 1009 | 8145 | 142 |
1637936 | 1637936 | 2021-08-21 | Blount | Alabama | 1009 | 8084 | 142 |
1634686 | 1634686 | 2021-08-20 | Blount | Alabama | 1009 | 8018 | 142 |
1631438 | 1631438 | 2021-08-19 | Blount | Alabama | 1009 | 7977 | 142 |
1628191 | 1628191 | 2021-08-18 | Blount | Alabama | 1009 | 7930 | 142 |
1624944 | 1624944 | 2021-08-17 | Blount | Alabama | 1009 | 7884 | 142 |
1621697 | 1621697 | 2021-08-16 | Blount | Alabama | 1009 | 7833 | 141 |
1618449 | 1618449 | 2021-08-15 | Blount | Alabama | 1009 | 7803 | 140 |
1615201 | 1615201 | 2021-08-14 | Blount | Alabama | 1009 | 7758 | 140 |
1611952 | 1611952 | 2021-08-13 | Blount | Alabama | 1009 | 7758 | 140 |
1608705 | 1608705 | 2021-08-12 | Blount | Alabama | 1009 | 7696 | 140 |
1605456 | 1605456 | 2021-08-11 | Blount | Alabama | 1009 | 7658 | 140 |
1602206 | 1602206 | 2021-08-10 | Blount | Alabama | 1009 | 7631 | 140 |
1598958 | 1598958 | 2021-08-09 | Blount | Alabama | 1009 | 7603 | 140 |
1595709 | 1595709 | 2021-08-08 | Blount | Alabama | 1009 | 7567 | 140 |
1592460 | 1592460 | 2021-08-07 | Blount | Alabama | 1009 | 7567 | 140 |
1589211 | 1589211 | 2021-08-06 | Blount | Alabama | 1009 | 7542 | 140 |
1585962 | 1585962 | 2021-08-05 | Blount | Alabama | 1009 | 7497 | 140 |
1582712 | 1582712 | 2021-08-04 | Blount | Alabama | 1009 | 7463 | 140 |
1579462 | 1579462 | 2021-08-03 | Blount | Alabama | 1009 | 7417 | 139 |
1576214 | 1576214 | 2021-08-02 | Blount | Alabama | 1009 | 7382 | 139 |
1572966 | 1572966 | 2021-08-01 | Blount | Alabama | 1009 | 7362 | 139 |
1569718 | 1569718 | 2021-07-31 | Blount | Alabama | 1009 | 7352 | 139 |
1566470 | 1566470 | 2021-07-30 | Blount | Alabama | 1009 | 7298 | 139 |
1563222 | 1563222 | 2021-07-29 | Blount | Alabama | 1009 | 7298 | 139 |
1559974 | 1559974 | 2021-07-28 | Blount | Alabama | 1009 | 7266 | 139 |
1556727 | 1556727 | 2021-07-27 | Blount | Alabama | 1009 | 7233 | 139 |
1553480 | 1553480 | 2021-07-26 | Blount | Alabama | 1009 | 7195 | 139 |
1550233 | 1550233 | 2021-07-25 | Blount | Alabama | 1009 | 7184 | 139 |
1546986 | 1546986 | 2021-07-24 | Blount | Alabama | 1009 | 7182 | 139 |
1543739 | 1543739 | 2021-07-23 | Blount | Alabama | 1009 | 7161 | 139 |
1540491 | 1540491 | 2021-07-22 | Blount | Alabama | 1009 | 7147 | 139 |
1537244 | 1537244 | 2021-07-21 | Blount | Alabama | 1009 | 7133 | 139 |
1533996 | 1533996 | 2021-07-20 | Blount | Alabama | 1009 | 7108 | 139 |
1530749 | 1530749 | 2021-07-19 | Blount | Alabama | 1009 | 7103 | 139 |
1527502 | 1527502 | 2021-07-18 | Blount | Alabama | 1009 | 7099 | 139 |
1524255 | 1524255 | 2021-07-17 | Blount | Alabama | 1009 | 7090 | 139 |
1521007 | 1521007 | 2021-07-16 | Blount | Alabama | 1009 | 7073 | 139 |
1517759 | 1517759 | 2021-07-15 | Blount | Alabama | 1009 | 7059 | 139 |
1514512 | 1514512 | 2021-07-14 | Blount | Alabama | 1009 | 7055 | 139 |
1511266 | 1511266 | 2021-07-13 | Blount | Alabama | 1009 | 7025 | 139 |
1508019 | 1508019 | 2021-07-12 | Blount | Alabama | 1009 | 7025 | 139 |
1504773 | 1504773 | 2021-07-11 | Blount | Alabama | 1009 | 7023 | 139 |
1501527 | 1501527 | 2021-07-10 | Blount | Alabama | 1009 | 7023 | 139 |
1498281 | 1498281 | 2021-07-09 | Blount | Alabama | 1009 | 7018 | 139 |
1495034 | 1495034 | 2021-07-08 | Blount | Alabama | 1009 | 7013 | 139 |
1491787 | 1491787 | 2021-07-07 | Blount | Alabama | 1009 | 7013 | 139 |
1488540 | 1488540 | 2021-07-06 | Blount | Alabama | 1009 | 6988 | 139 |
1485293 | 1485293 | 2021-07-05 | Blount | Alabama | 1009 | 6988 | 139 |
1482047 | 1482047 | 2021-07-04 | Blount | Alabama | 1009 | 6988 | 139 |
1478800 | 1478800 | 2021-07-03 | Blount | Alabama | 1009 | 6988 | 139 |
1475554 | 1475554 | 2021-07-02 | Blount | Alabama | 1009 | 6988 | 139 |
1472308 | 1472308 | 2021-07-01 | Blount | Alabama | 1009 | 6987 | 139 |
1469063 | 1469063 | 2021-06-30 | Blount | Alabama | 1009 | 6987 | 139 |
1465818 | 1465818 | 2021-06-29 | Blount | Alabama | 1009 | 6975 | 139 |
1462573 | 1462573 | 2021-06-28 | Blount | Alabama | 1009 | 6975 | 139 |
1459328 | 1459328 | 2021-06-27 | Blount | Alabama | 1009 | 6967 | 139 |
1456083 | 1456083 | 2021-06-26 | Blount | Alabama | 1009 | 6967 | 139 |
1452838 | 1452838 | 2021-06-25 | Blount | Alabama | 1009 | 6967 | 139 |
1449592 | 1449592 | 2021-06-24 | Blount | Alabama | 1009 | 6957 | 139 |
1446347 | 1446347 | 2021-06-23 | Blount | Alabama | 1009 | 6957 | 139 |
1443102 | 1443102 | 2021-06-22 | Blount | Alabama | 1009 | 6950 | 139 |
1439857 | 1439857 | 2021-06-21 | Blount | Alabama | 1009 | 6950 | 139 |
1436610 | 1436610 | 2021-06-20 | Blount | Alabama | 1009 | 6945 | 139 |
1433363 | 1433363 | 2021-06-19 | Blount | Alabama | 1009 | 6945 | 139 |
1430117 | 1430117 | 2021-06-18 | Blount | Alabama | 1009 | 6945 | 139 |
1426872 | 1426872 | 2021-06-17 | Blount | Alabama | 1009 | 6944 | 139 |
1423626 | 1423626 | 2021-06-16 | Blount | Alabama | 1009 | 6944 | 139 |
1420379 | 1420379 | 2021-06-15 | Blount | Alabama | 1009 | 6938 | 139 |
1417134 | 1417134 | 2021-06-14 | Blount | Alabama | 1009 | 6937 | 139 |
1413888 | 1413888 | 2021-06-13 | Blount | Alabama | 1009 | 6925 | 139 |
1410643 | 1410643 | 2021-06-12 | Blount | Alabama | 1009 | 6925 | 139 |
1407398 | 1407398 | 2021-06-11 | Blount | Alabama | 1009 | 6925 | 139 |
1404152 | 1404152 | 2021-06-10 | Blount | Alabama | 1009 | 6921 | 139 |
1400907 | 1400907 | 2021-06-09 | Blount | Alabama | 1009 | 6921 | 139 |
1397662 | 1397662 | 2021-06-08 | Blount | Alabama | 1009 | 6918 | 139 |
1394415 | 1394415 | 2021-06-07 | Blount | Alabama | 1009 | 6916 | 139 |
1391170 | 1391170 | 2021-06-06 | Blount | Alabama | 1009 | 6906 | 139 |
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);