ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 1069 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712681 | 1712681 | 2021-09-13 | Houston | Alabama | 1069 | 15732 | 331 |
1709434 | 1709434 | 2021-09-12 | Houston | Alabama | 1069 | 15672 | 331 |
1706187 | 1706187 | 2021-09-11 | Houston | Alabama | 1069 | 15648 | 331 |
1702939 | 1702939 | 2021-09-10 | Houston | Alabama | 1069 | 15571 | 328 |
1699689 | 1699689 | 2021-09-09 | Houston | Alabama | 1069 | 15488 | 327 |
1696440 | 1696440 | 2021-09-08 | Houston | Alabama | 1069 | 15372 | 324 |
1693192 | 1693192 | 2021-09-07 | Houston | Alabama | 1069 | 15285 | 322 |
1689943 | 1689943 | 2021-09-06 | Houston | Alabama | 1069 | 15225 | 322 |
1686693 | 1686693 | 2021-09-05 | Houston | Alabama | 1069 | 15172 | 322 |
1683443 | 1683443 | 2021-09-04 | Houston | Alabama | 1069 | 15104 | 322 |
1680192 | 1680192 | 2021-09-03 | Houston | Alabama | 1069 | 15021 | 322 |
1676944 | 1676944 | 2021-09-02 | Houston | Alabama | 1069 | 14920 | 317 |
1673697 | 1673697 | 2021-09-01 | Houston | Alabama | 1069 | 14832 | 317 |
1670449 | 1670449 | 2021-08-31 | Houston | Alabama | 1069 | 14705 | 317 |
1667202 | 1667202 | 2021-08-30 | Houston | Alabama | 1069 | 14589 | 316 |
1663954 | 1663954 | 2021-08-29 | Houston | Alabama | 1069 | 14521 | 316 |
1660706 | 1660706 | 2021-08-28 | Houston | Alabama | 1069 | 14447 | 316 |
1657458 | 1657458 | 2021-08-27 | Houston | Alabama | 1069 | 14351 | 315 |
1654210 | 1654210 | 2021-08-26 | Houston | Alabama | 1069 | 14262 | 313 |
1650964 | 1650964 | 2021-08-25 | Houston | Alabama | 1069 | 14033 | 310 |
1647715 | 1647715 | 2021-08-24 | Houston | Alabama | 1069 | 14033 | 310 |
1644466 | 1644466 | 2021-08-23 | Houston | Alabama | 1069 | 14033 | 310 |
1641216 | 1641216 | 2021-08-22 | Houston | Alabama | 1069 | 13962 | 310 |
1637966 | 1637966 | 2021-08-21 | Houston | Alabama | 1069 | 13896 | 310 |
1634716 | 1634716 | 2021-08-20 | Houston | Alabama | 1069 | 13760 | 307 |
1631468 | 1631468 | 2021-08-19 | Houston | Alabama | 1069 | 13702 | 307 |
1628221 | 1628221 | 2021-08-18 | Houston | Alabama | 1069 | 13610 | 305 |
1624974 | 1624974 | 2021-08-17 | Houston | Alabama | 1069 | 13491 | 302 |
1621727 | 1621727 | 2021-08-16 | Houston | Alabama | 1069 | 13426 | 301 |
1618479 | 1618479 | 2021-08-15 | Houston | Alabama | 1069 | 13352 | 301 |
1615231 | 1615231 | 2021-08-14 | Houston | Alabama | 1069 | 13213 | 299 |
1611982 | 1611982 | 2021-08-13 | Houston | Alabama | 1069 | 13213 | 299 |
1608735 | 1608735 | 2021-08-12 | Houston | Alabama | 1069 | 13126 | 297 |
1605486 | 1605486 | 2021-08-11 | Houston | Alabama | 1069 | 12994 | 297 |
1602236 | 1602236 | 2021-08-10 | Houston | Alabama | 1069 | 12878 | 296 |
1598988 | 1598988 | 2021-08-09 | Houston | Alabama | 1069 | 12782 | 294 |
1595739 | 1595739 | 2021-08-08 | Houston | Alabama | 1069 | 12638 | 294 |
1592490 | 1592490 | 2021-08-07 | Houston | Alabama | 1069 | 12638 | 294 |
1589241 | 1589241 | 2021-08-06 | Houston | Alabama | 1069 | 12502 | 294 |
1585992 | 1585992 | 2021-08-05 | Houston | Alabama | 1069 | 12399 | 294 |
1582742 | 1582742 | 2021-08-04 | Houston | Alabama | 1069 | 12297 | 294 |
1579492 | 1579492 | 2021-08-03 | Houston | Alabama | 1069 | 12191 | 293 |
1576244 | 1576244 | 2021-08-02 | Houston | Alabama | 1069 | 12112 | 293 |
1572996 | 1572996 | 2021-08-01 | Houston | Alabama | 1069 | 12077 | 293 |
1569748 | 1569748 | 2021-07-31 | Houston | Alabama | 1069 | 12021 | 293 |
1566500 | 1566500 | 2021-07-30 | Houston | Alabama | 1069 | 11870 | 293 |
1563252 | 1563252 | 2021-07-29 | Houston | Alabama | 1069 | 11870 | 293 |
1560004 | 1560004 | 2021-07-28 | Houston | Alabama | 1069 | 11774 | 292 |
1556757 | 1556757 | 2021-07-27 | Houston | Alabama | 1069 | 11661 | 292 |
1553510 | 1553510 | 2021-07-26 | Houston | Alabama | 1069 | 11582 | 292 |
1550263 | 1550263 | 2021-07-25 | Houston | Alabama | 1069 | 11515 | 292 |
1547016 | 1547016 | 2021-07-24 | Houston | Alabama | 1069 | 11462 | 292 |
1543769 | 1543769 | 2021-07-23 | Houston | Alabama | 1069 | 11371 | 292 |
1540521 | 1540521 | 2021-07-22 | Houston | Alabama | 1069 | 11302 | 292 |
1537274 | 1537274 | 2021-07-21 | Houston | Alabama | 1069 | 11242 | 292 |
1534026 | 1534026 | 2021-07-20 | Houston | Alabama | 1069 | 11212 | 292 |
1530779 | 1530779 | 2021-07-19 | Houston | Alabama | 1069 | 11196 | 291 |
1527532 | 1527532 | 2021-07-18 | Houston | Alabama | 1069 | 11173 | 291 |
1524285 | 1524285 | 2021-07-17 | Houston | Alabama | 1069 | 11146 | 291 |
1521037 | 1521037 | 2021-07-16 | Houston | Alabama | 1069 | 11109 | 291 |
1517789 | 1517789 | 2021-07-15 | Houston | Alabama | 1069 | 11074 | 291 |
1514542 | 1514542 | 2021-07-14 | Houston | Alabama | 1069 | 11038 | 291 |
1511296 | 1511296 | 2021-07-13 | Houston | Alabama | 1069 | 10985 | 290 |
1508049 | 1508049 | 2021-07-12 | Houston | Alabama | 1069 | 10985 | 290 |
1504803 | 1504803 | 2021-07-11 | Houston | Alabama | 1069 | 10966 | 290 |
1501557 | 1501557 | 2021-07-10 | Houston | Alabama | 1069 | 10966 | 290 |
1498311 | 1498311 | 2021-07-09 | Houston | Alabama | 1069 | 10952 | 290 |
1495064 | 1495064 | 2021-07-08 | Houston | Alabama | 1069 | 10906 | 290 |
1491817 | 1491817 | 2021-07-07 | Houston | Alabama | 1069 | 10906 | 290 |
1488570 | 1488570 | 2021-07-06 | Houston | Alabama | 1069 | 10858 | 290 |
1485323 | 1485323 | 2021-07-05 | Houston | Alabama | 1069 | 10858 | 290 |
1482077 | 1482077 | 2021-07-04 | Houston | Alabama | 1069 | 10858 | 290 |
1478830 | 1478830 | 2021-07-03 | Houston | Alabama | 1069 | 10858 | 290 |
1475584 | 1475584 | 2021-07-02 | Houston | Alabama | 1069 | 10858 | 290 |
1472338 | 1472338 | 2021-07-01 | Houston | Alabama | 1069 | 10840 | 289 |
1469093 | 1469093 | 2021-06-30 | Houston | Alabama | 1069 | 10840 | 289 |
1465848 | 1465848 | 2021-06-29 | Houston | Alabama | 1069 | 10832 | 289 |
1462603 | 1462603 | 2021-06-28 | Houston | Alabama | 1069 | 10832 | 289 |
1459358 | 1459358 | 2021-06-27 | Houston | Alabama | 1069 | 10810 | 289 |
1456113 | 1456113 | 2021-06-26 | Houston | Alabama | 1069 | 10810 | 289 |
1452868 | 1452868 | 2021-06-25 | Houston | Alabama | 1069 | 10810 | 289 |
1449622 | 1449622 | 2021-06-24 | Houston | Alabama | 1069 | 10798 | 289 |
1446377 | 1446377 | 2021-06-23 | Houston | Alabama | 1069 | 10798 | 289 |
1443132 | 1443132 | 2021-06-22 | Houston | Alabama | 1069 | 10791 | 287 |
1439887 | 1439887 | 2021-06-21 | Houston | Alabama | 1069 | 10791 | 287 |
1436640 | 1436640 | 2021-06-20 | Houston | Alabama | 1069 | 10781 | 287 |
1433393 | 1433393 | 2021-06-19 | Houston | Alabama | 1069 | 10781 | 287 |
1430147 | 1430147 | 2021-06-18 | Houston | Alabama | 1069 | 10781 | 287 |
1426902 | 1426902 | 2021-06-17 | Houston | Alabama | 1069 | 10764 | 288 |
1423656 | 1423656 | 2021-06-16 | Houston | Alabama | 1069 | 10764 | 288 |
1420409 | 1420409 | 2021-06-15 | Houston | Alabama | 1069 | 10764 | 288 |
1417164 | 1417164 | 2021-06-14 | Houston | Alabama | 1069 | 10757 | 288 |
1413918 | 1413918 | 2021-06-13 | Houston | Alabama | 1069 | 10748 | 287 |
1410673 | 1410673 | 2021-06-12 | Houston | Alabama | 1069 | 10748 | 287 |
1407428 | 1407428 | 2021-06-11 | Houston | Alabama | 1069 | 10748 | 287 |
1404182 | 1404182 | 2021-06-10 | Houston | Alabama | 1069 | 10739 | 287 |
1400937 | 1400937 | 2021-06-09 | Houston | Alabama | 1069 | 10737 | 287 |
1397692 | 1397692 | 2021-06-08 | Houston | Alabama | 1069 | 10736 | 287 |
1394445 | 1394445 | 2021-06-07 | Houston | Alabama | 1069 | 10733 | 287 |
1391200 | 1391200 | 2021-06-06 | Houston | Alabama | 1069 | 10730 | 286 |
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);