ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Autauga" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712647 | 1712647 | 2021-09-13 | Autauga | Alabama | 1001 | 9317 | 119 |
1709400 | 1709400 | 2021-09-12 | Autauga | Alabama | 1001 | 9287 | 119 |
1706153 | 1706153 | 2021-09-11 | Autauga | Alabama | 1001 | 9246 | 119 |
1702905 | 1702905 | 2021-09-10 | Autauga | Alabama | 1001 | 9207 | 119 |
1699655 | 1699655 | 2021-09-09 | Autauga | Alabama | 1001 | 9145 | 119 |
1696406 | 1696406 | 2021-09-08 | Autauga | Alabama | 1001 | 9108 | 119 |
1693158 | 1693158 | 2021-09-07 | Autauga | Alabama | 1001 | 9063 | 119 |
1689909 | 1689909 | 2021-09-06 | Autauga | Alabama | 1001 | 9048 | 119 |
1686659 | 1686659 | 2021-09-05 | Autauga | Alabama | 1001 | 9012 | 119 |
1683409 | 1683409 | 2021-09-04 | Autauga | Alabama | 1001 | 8959 | 119 |
1680158 | 1680158 | 2021-09-03 | Autauga | Alabama | 1001 | 8909 | 119 |
1676910 | 1676910 | 2021-09-02 | Autauga | Alabama | 1001 | 8873 | 119 |
1673663 | 1673663 | 2021-09-01 | Autauga | Alabama | 1001 | 8798 | 118 |
1670415 | 1670415 | 2021-08-31 | Autauga | Alabama | 1001 | 8758 | 118 |
1667168 | 1667168 | 2021-08-30 | Autauga | Alabama | 1001 | 8719 | 118 |
1663920 | 1663920 | 2021-08-29 | Autauga | Alabama | 1001 | 8657 | 118 |
1660672 | 1660672 | 2021-08-28 | Autauga | Alabama | 1001 | 8637 | 118 |
1657424 | 1657424 | 2021-08-27 | Autauga | Alabama | 1001 | 8550 | 117 |
1654176 | 1654176 | 2021-08-26 | Autauga | Alabama | 1001 | 8486 | 115 |
1650930 | 1650930 | 2021-08-25 | Autauga | Alabama | 1001 | 8332 | 115 |
1647681 | 1647681 | 2021-08-24 | Autauga | Alabama | 1001 | 8332 | 115 |
1644432 | 1644432 | 2021-08-23 | Autauga | Alabama | 1001 | 8332 | 115 |
1641182 | 1641182 | 2021-08-22 | Autauga | Alabama | 1001 | 8311 | 115 |
1637932 | 1637932 | 2021-08-21 | Autauga | Alabama | 1001 | 8286 | 115 |
1634682 | 1634682 | 2021-08-20 | Autauga | Alabama | 1001 | 8199 | 115 |
1631434 | 1631434 | 2021-08-19 | Autauga | Alabama | 1001 | 8162 | 115 |
1628187 | 1628187 | 2021-08-18 | Autauga | Alabama | 1001 | 8132 | 115 |
1624940 | 1624940 | 2021-08-17 | Autauga | Alabama | 1001 | 8091 | 115 |
1621693 | 1621693 | 2021-08-16 | Autauga | Alabama | 1001 | 8061 | 114 |
1618445 | 1618445 | 2021-08-15 | Autauga | Alabama | 1001 | 8025 | 114 |
1615197 | 1615197 | 2021-08-14 | Autauga | Alabama | 1001 | 7931 | 114 |
1611948 | 1611948 | 2021-08-13 | Autauga | Alabama | 1001 | 7931 | 114 |
1608701 | 1608701 | 2021-08-12 | Autauga | Alabama | 1001 | 7890 | 114 |
1605452 | 1605452 | 2021-08-11 | Autauga | Alabama | 1001 | 7854 | 114 |
1602202 | 1602202 | 2021-08-10 | Autauga | Alabama | 1001 | 7818 | 114 |
1598954 | 1598954 | 2021-08-09 | Autauga | Alabama | 1001 | 7788 | 114 |
1595705 | 1595705 | 2021-08-08 | Autauga | Alabama | 1001 | 7745 | 114 |
1592456 | 1592456 | 2021-08-07 | Autauga | Alabama | 1001 | 7745 | 114 |
1589207 | 1589207 | 2021-08-06 | Autauga | Alabama | 1001 | 7694 | 114 |
1585958 | 1585958 | 2021-08-05 | Autauga | Alabama | 1001 | 7670 | 114 |
1582708 | 1582708 | 2021-08-04 | Autauga | Alabama | 1001 | 7635 | 114 |
1579458 | 1579458 | 2021-08-03 | Autauga | Alabama | 1001 | 7615 | 114 |
1576210 | 1576210 | 2021-08-02 | Autauga | Alabama | 1001 | 7585 | 114 |
1572962 | 1572962 | 2021-08-01 | Autauga | Alabama | 1001 | 7563 | 114 |
1569714 | 1569714 | 2021-07-31 | Autauga | Alabama | 1001 | 7537 | 114 |
1566466 | 1566466 | 2021-07-30 | Autauga | Alabama | 1001 | 7493 | 114 |
1563218 | 1563218 | 2021-07-29 | Autauga | Alabama | 1001 | 7493 | 114 |
1559970 | 1559970 | 2021-07-28 | Autauga | Alabama | 1001 | 7479 | 114 |
1556723 | 1556723 | 2021-07-27 | Autauga | Alabama | 1001 | 7456 | 114 |
1553476 | 1553476 | 2021-07-26 | Autauga | Alabama | 1001 | 7435 | 113 |
1550229 | 1550229 | 2021-07-25 | Autauga | Alabama | 1001 | 7419 | 113 |
1546982 | 1546982 | 2021-07-24 | Autauga | Alabama | 1001 | 7402 | 113 |
1543735 | 1543735 | 2021-07-23 | Autauga | Alabama | 1001 | 7394 | 113 |
1540487 | 1540487 | 2021-07-22 | Autauga | Alabama | 1001 | 7388 | 113 |
1537240 | 1537240 | 2021-07-21 | Autauga | Alabama | 1001 | 7375 | 113 |
1533992 | 1533992 | 2021-07-20 | Autauga | Alabama | 1001 | 7365 | 113 |
1530745 | 1530745 | 2021-07-19 | Autauga | Alabama | 1001 | 7350 | 113 |
1527498 | 1527498 | 2021-07-18 | Autauga | Alabama | 1001 | 7347 | 113 |
1524251 | 1524251 | 2021-07-17 | Autauga | Alabama | 1001 | 7346 | 113 |
1521003 | 1521003 | 2021-07-16 | Autauga | Alabama | 1001 | 7341 | 113 |
1517755 | 1517755 | 2021-07-15 | Autauga | Alabama | 1001 | 7329 | 113 |
1514508 | 1514508 | 2021-07-14 | Autauga | Alabama | 1001 | 7320 | 113 |
1511262 | 1511262 | 2021-07-13 | Autauga | Alabama | 1001 | 7306 | 113 |
1508015 | 1508015 | 2021-07-12 | Autauga | Alabama | 1001 | 7306 | 113 |
1504769 | 1504769 | 2021-07-11 | Autauga | Alabama | 1001 | 7299 | 113 |
1501523 | 1501523 | 2021-07-10 | Autauga | Alabama | 1001 | 7299 | 113 |
1498277 | 1498277 | 2021-07-09 | Autauga | Alabama | 1001 | 7294 | 113 |
1495030 | 1495030 | 2021-07-08 | Autauga | Alabama | 1001 | 7277 | 113 |
1491783 | 1491783 | 2021-07-07 | Autauga | Alabama | 1001 | 7277 | 113 |
1488536 | 1488536 | 2021-07-06 | Autauga | Alabama | 1001 | 7262 | 113 |
1485289 | 1485289 | 2021-07-05 | Autauga | Alabama | 1001 | 7262 | 113 |
1482043 | 1482043 | 2021-07-04 | Autauga | Alabama | 1001 | 7262 | 113 |
1478796 | 1478796 | 2021-07-03 | Autauga | Alabama | 1001 | 7262 | 113 |
1475550 | 1475550 | 2021-07-02 | Autauga | Alabama | 1001 | 7262 | 113 |
1472304 | 1472304 | 2021-07-01 | Autauga | Alabama | 1001 | 7257 | 113 |
1469059 | 1469059 | 2021-06-30 | Autauga | Alabama | 1001 | 7257 | 113 |
1465814 | 1465814 | 2021-06-29 | Autauga | Alabama | 1001 | 7247 | 113 |
1462569 | 1462569 | 2021-06-28 | Autauga | Alabama | 1001 | 7247 | 113 |
1459324 | 1459324 | 2021-06-27 | Autauga | Alabama | 1001 | 7244 | 113 |
1456079 | 1456079 | 2021-06-26 | Autauga | Alabama | 1001 | 7244 | 113 |
1452834 | 1452834 | 2021-06-25 | Autauga | Alabama | 1001 | 7244 | 113 |
1449588 | 1449588 | 2021-06-24 | Autauga | Alabama | 1001 | 7244 | 113 |
1446343 | 1446343 | 2021-06-23 | Autauga | Alabama | 1001 | 7244 | 113 |
1443098 | 1443098 | 2021-06-22 | Autauga | Alabama | 1001 | 7242 | 113 |
1439853 | 1439853 | 2021-06-21 | Autauga | Alabama | 1001 | 7242 | 113 |
1436606 | 1436606 | 2021-06-20 | Autauga | Alabama | 1001 | 7241 | 113 |
1433359 | 1433359 | 2021-06-19 | Autauga | Alabama | 1001 | 7241 | 113 |
1430113 | 1430113 | 2021-06-18 | Autauga | Alabama | 1001 | 7241 | 113 |
1426868 | 1426868 | 2021-06-17 | Autauga | Alabama | 1001 | 7230 | 113 |
1423622 | 1423622 | 2021-06-16 | Autauga | Alabama | 1001 | 7230 | 113 |
1420375 | 1420375 | 2021-06-15 | Autauga | Alabama | 1001 | 7230 | 113 |
1417130 | 1417130 | 2021-06-14 | Autauga | Alabama | 1001 | 7229 | 113 |
1413884 | 1413884 | 2021-06-13 | Autauga | Alabama | 1001 | 7215 | 113 |
1410639 | 1410639 | 2021-06-12 | Autauga | Alabama | 1001 | 7215 | 113 |
1407394 | 1407394 | 2021-06-11 | Autauga | Alabama | 1001 | 7215 | 113 |
1404148 | 1404148 | 2021-06-10 | Autauga | Alabama | 1001 | 7211 | 113 |
1400903 | 1400903 | 2021-06-09 | Autauga | Alabama | 1001 | 7209 | 113 |
1397658 | 1397658 | 2021-06-08 | Autauga | Alabama | 1001 | 7206 | 113 |
1394411 | 1394411 | 2021-06-07 | Autauga | Alabama | 1001 | 7206 | 113 |
1391166 | 1391166 | 2021-06-06 | Autauga | Alabama | 1001 | 7186 | 112 |
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);