ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 1103 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712698 | 1712698 | 2021-09-13 | Morgan | Alabama | 1103 | 18881 | 307 |
1709451 | 1709451 | 2021-09-12 | Morgan | Alabama | 1103 | 18775 | 307 |
1706204 | 1706204 | 2021-09-11 | Morgan | Alabama | 1103 | 18728 | 307 |
1702956 | 1702956 | 2021-09-10 | Morgan | Alabama | 1103 | 18599 | 306 |
1699706 | 1699706 | 2021-09-09 | Morgan | Alabama | 1103 | 18448 | 306 |
1696457 | 1696457 | 2021-09-08 | Morgan | Alabama | 1103 | 18327 | 303 |
1693209 | 1693209 | 2021-09-07 | Morgan | Alabama | 1103 | 18236 | 302 |
1689960 | 1689960 | 2021-09-06 | Morgan | Alabama | 1103 | 18155 | 302 |
1686710 | 1686710 | 2021-09-05 | Morgan | Alabama | 1103 | 18070 | 302 |
1683460 | 1683460 | 2021-09-04 | Morgan | Alabama | 1103 | 17970 | 302 |
1680209 | 1680209 | 2021-09-03 | Morgan | Alabama | 1103 | 17836 | 302 |
1676961 | 1676961 | 2021-09-02 | Morgan | Alabama | 1103 | 17708 | 302 |
1673714 | 1673714 | 2021-09-01 | Morgan | Alabama | 1103 | 17589 | 299 |
1670466 | 1670466 | 2021-08-31 | Morgan | Alabama | 1103 | 17485 | 299 |
1667219 | 1667219 | 2021-08-30 | Morgan | Alabama | 1103 | 17353 | 296 |
1663971 | 1663971 | 2021-08-29 | Morgan | Alabama | 1103 | 17211 | 296 |
1660723 | 1660723 | 2021-08-28 | Morgan | Alabama | 1103 | 17074 | 296 |
1657475 | 1657475 | 2021-08-27 | Morgan | Alabama | 1103 | 16948 | 296 |
1654227 | 1654227 | 2021-08-26 | Morgan | Alabama | 1103 | 16800 | 295 |
1650981 | 1650981 | 2021-08-25 | Morgan | Alabama | 1103 | 16501 | 293 |
1647732 | 1647732 | 2021-08-24 | Morgan | Alabama | 1103 | 16501 | 293 |
1644483 | 1644483 | 2021-08-23 | Morgan | Alabama | 1103 | 16501 | 293 |
1641233 | 1641233 | 2021-08-22 | Morgan | Alabama | 1103 | 16451 | 293 |
1637983 | 1637983 | 2021-08-21 | Morgan | Alabama | 1103 | 16400 | 293 |
1634733 | 1634733 | 2021-08-20 | Morgan | Alabama | 1103 | 16268 | 293 |
1631485 | 1631485 | 2021-08-19 | Morgan | Alabama | 1103 | 16176 | 293 |
1628238 | 1628238 | 2021-08-18 | Morgan | Alabama | 1103 | 16106 | 293 |
1624991 | 1624991 | 2021-08-17 | Morgan | Alabama | 1103 | 16030 | 291 |
1621744 | 1621744 | 2021-08-16 | Morgan | Alabama | 1103 | 15954 | 291 |
1618496 | 1618496 | 2021-08-15 | Morgan | Alabama | 1103 | 15889 | 291 |
1615248 | 1615248 | 2021-08-14 | Morgan | Alabama | 1103 | 15764 | 291 |
1611999 | 1611999 | 2021-08-13 | Morgan | Alabama | 1103 | 15764 | 291 |
1608752 | 1608752 | 2021-08-12 | Morgan | Alabama | 1103 | 15702 | 291 |
1605503 | 1605503 | 2021-08-11 | Morgan | Alabama | 1103 | 15634 | 291 |
1602253 | 1602253 | 2021-08-10 | Morgan | Alabama | 1103 | 15577 | 291 |
1599005 | 1599005 | 2021-08-09 | Morgan | Alabama | 1103 | 15516 | 291 |
1595756 | 1595756 | 2021-08-08 | Morgan | Alabama | 1103 | 15433 | 291 |
1592507 | 1592507 | 2021-08-07 | Morgan | Alabama | 1103 | 15433 | 291 |
1589258 | 1589258 | 2021-08-06 | Morgan | Alabama | 1103 | 15382 | 291 |
1586009 | 1586009 | 2021-08-05 | Morgan | Alabama | 1103 | 15325 | 291 |
1582759 | 1582759 | 2021-08-04 | Morgan | Alabama | 1103 | 15265 | 291 |
1579509 | 1579509 | 2021-08-03 | Morgan | Alabama | 1103 | 15225 | 291 |
1576261 | 1576261 | 2021-08-02 | Morgan | Alabama | 1103 | 15199 | 291 |
1573013 | 1573013 | 2021-08-01 | Morgan | Alabama | 1103 | 15170 | 291 |
1569765 | 1569765 | 2021-07-31 | Morgan | Alabama | 1103 | 15147 | 291 |
1566517 | 1566517 | 2021-07-30 | Morgan | Alabama | 1103 | 15055 | 290 |
1563269 | 1563269 | 2021-07-29 | Morgan | Alabama | 1103 | 15055 | 290 |
1560021 | 1560021 | 2021-07-28 | Morgan | Alabama | 1103 | 15017 | 290 |
1556774 | 1556774 | 2021-07-27 | Morgan | Alabama | 1103 | 14990 | 289 |
1553527 | 1553527 | 2021-07-26 | Morgan | Alabama | 1103 | 14952 | 289 |
1550280 | 1550280 | 2021-07-25 | Morgan | Alabama | 1103 | 14941 | 289 |
1547033 | 1547033 | 2021-07-24 | Morgan | Alabama | 1103 | 14916 | 289 |
1543786 | 1543786 | 2021-07-23 | Morgan | Alabama | 1103 | 14904 | 288 |
1540538 | 1540538 | 2021-07-22 | Morgan | Alabama | 1103 | 14877 | 288 |
1537291 | 1537291 | 2021-07-21 | Morgan | Alabama | 1103 | 14858 | 288 |
1534043 | 1534043 | 2021-07-20 | Morgan | Alabama | 1103 | 14831 | 288 |
1530796 | 1530796 | 2021-07-19 | Morgan | Alabama | 1103 | 14814 | 288 |
1527549 | 1527549 | 2021-07-18 | Morgan | Alabama | 1103 | 14808 | 288 |
1524302 | 1524302 | 2021-07-17 | Morgan | Alabama | 1103 | 14801 | 288 |
1521054 | 1521054 | 2021-07-16 | Morgan | Alabama | 1103 | 14793 | 288 |
1517806 | 1517806 | 2021-07-15 | Morgan | Alabama | 1103 | 14786 | 288 |
1514559 | 1514559 | 2021-07-14 | Morgan | Alabama | 1103 | 14761 | 288 |
1511313 | 1511313 | 2021-07-13 | Morgan | Alabama | 1103 | 14731 | 288 |
1508066 | 1508066 | 2021-07-12 | Morgan | Alabama | 1103 | 14731 | 288 |
1504820 | 1504820 | 2021-07-11 | Morgan | Alabama | 1103 | 14717 | 288 |
1501574 | 1501574 | 2021-07-10 | Morgan | Alabama | 1103 | 14717 | 288 |
1498328 | 1498328 | 2021-07-09 | Morgan | Alabama | 1103 | 14708 | 288 |
1495081 | 1495081 | 2021-07-08 | Morgan | Alabama | 1103 | 14695 | 288 |
1491834 | 1491834 | 2021-07-07 | Morgan | Alabama | 1103 | 14695 | 288 |
1488587 | 1488587 | 2021-07-06 | Morgan | Alabama | 1103 | 14669 | 287 |
1485340 | 1485340 | 2021-07-05 | Morgan | Alabama | 1103 | 14669 | 287 |
1482094 | 1482094 | 2021-07-04 | Morgan | Alabama | 1103 | 14669 | 287 |
1478847 | 1478847 | 2021-07-03 | Morgan | Alabama | 1103 | 14669 | 287 |
1475601 | 1475601 | 2021-07-02 | Morgan | Alabama | 1103 | 14669 | 287 |
1472355 | 1472355 | 2021-07-01 | Morgan | Alabama | 1103 | 14666 | 287 |
1469110 | 1469110 | 2021-06-30 | Morgan | Alabama | 1103 | 14666 | 287 |
1465865 | 1465865 | 2021-06-29 | Morgan | Alabama | 1103 | 14662 | 287 |
1462620 | 1462620 | 2021-06-28 | Morgan | Alabama | 1103 | 14662 | 287 |
1459375 | 1459375 | 2021-06-27 | Morgan | Alabama | 1103 | 14656 | 287 |
1456130 | 1456130 | 2021-06-26 | Morgan | Alabama | 1103 | 14656 | 287 |
1452885 | 1452885 | 2021-06-25 | Morgan | Alabama | 1103 | 14656 | 287 |
1449639 | 1449639 | 2021-06-24 | Morgan | Alabama | 1103 | 14650 | 286 |
1446394 | 1446394 | 2021-06-23 | Morgan | Alabama | 1103 | 14650 | 286 |
1443149 | 1443149 | 2021-06-22 | Morgan | Alabama | 1103 | 14639 | 285 |
1439904 | 1439904 | 2021-06-21 | Morgan | Alabama | 1103 | 14639 | 285 |
1436657 | 1436657 | 2021-06-20 | Morgan | Alabama | 1103 | 14629 | 285 |
1433410 | 1433410 | 2021-06-19 | Morgan | Alabama | 1103 | 14629 | 285 |
1430164 | 1430164 | 2021-06-18 | Morgan | Alabama | 1103 | 14629 | 285 |
1426919 | 1426919 | 2021-06-17 | Morgan | Alabama | 1103 | 14626 | 285 |
1423673 | 1423673 | 2021-06-16 | Morgan | Alabama | 1103 | 14626 | 285 |
1420426 | 1420426 | 2021-06-15 | Morgan | Alabama | 1103 | 14621 | 285 |
1417181 | 1417181 | 2021-06-14 | Morgan | Alabama | 1103 | 14618 | 285 |
1413935 | 1413935 | 2021-06-13 | Morgan | Alabama | 1103 | 14614 | 285 |
1410690 | 1410690 | 2021-06-12 | Morgan | Alabama | 1103 | 14614 | 285 |
1407445 | 1407445 | 2021-06-11 | Morgan | Alabama | 1103 | 14614 | 285 |
1404199 | 1404199 | 2021-06-10 | Morgan | Alabama | 1103 | 14604 | 284 |
1400954 | 1400954 | 2021-06-09 | Morgan | Alabama | 1103 | 14592 | 284 |
1397709 | 1397709 | 2021-06-08 | Morgan | Alabama | 1103 | 14578 | 284 |
1394462 | 1394462 | 2021-06-07 | Morgan | Alabama | 1103 | 14573 | 284 |
1391217 | 1391217 | 2021-06-06 | Morgan | Alabama | 1103 | 14556 | 283 |
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);