ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1051 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712672 | 1712672 | 2021-09-13 | Elmore | Alabama | 1051 | 13694 | 239 |
1709425 | 1709425 | 2021-09-12 | Elmore | Alabama | 1051 | 13636 | 239 |
1706178 | 1706178 | 2021-09-11 | Elmore | Alabama | 1051 | 13600 | 239 |
1702930 | 1702930 | 2021-09-10 | Elmore | Alabama | 1051 | 13543 | 238 |
1699680 | 1699680 | 2021-09-09 | Elmore | Alabama | 1051 | 13485 | 235 |
1696431 | 1696431 | 2021-09-08 | Elmore | Alabama | 1051 | 13419 | 236 |
1693183 | 1693183 | 2021-09-07 | Elmore | Alabama | 1051 | 13341 | 236 |
1689934 | 1689934 | 2021-09-06 | Elmore | Alabama | 1051 | 13299 | 236 |
1686684 | 1686684 | 2021-09-05 | Elmore | Alabama | 1051 | 13254 | 236 |
1683434 | 1683434 | 2021-09-04 | Elmore | Alabama | 1051 | 13196 | 236 |
1680183 | 1680183 | 2021-09-03 | Elmore | Alabama | 1051 | 13120 | 236 |
1676935 | 1676935 | 2021-09-02 | Elmore | Alabama | 1051 | 13024 | 234 |
1673688 | 1673688 | 2021-09-01 | Elmore | Alabama | 1051 | 12923 | 234 |
1670440 | 1670440 | 2021-08-31 | Elmore | Alabama | 1051 | 12878 | 234 |
1667193 | 1667193 | 2021-08-30 | Elmore | Alabama | 1051 | 12829 | 234 |
1663945 | 1663945 | 2021-08-29 | Elmore | Alabama | 1051 | 12746 | 234 |
1660697 | 1660697 | 2021-08-28 | Elmore | Alabama | 1051 | 12683 | 234 |
1657449 | 1657449 | 2021-08-27 | Elmore | Alabama | 1051 | 12590 | 234 |
1654201 | 1654201 | 2021-08-26 | Elmore | Alabama | 1051 | 12518 | 233 |
1650955 | 1650955 | 2021-08-25 | Elmore | Alabama | 1051 | 12348 | 231 |
1647706 | 1647706 | 2021-08-24 | Elmore | Alabama | 1051 | 12348 | 231 |
1644457 | 1644457 | 2021-08-23 | Elmore | Alabama | 1051 | 12348 | 231 |
1641207 | 1641207 | 2021-08-22 | Elmore | Alabama | 1051 | 12310 | 231 |
1637957 | 1637957 | 2021-08-21 | Elmore | Alabama | 1051 | 12229 | 231 |
1634707 | 1634707 | 2021-08-20 | Elmore | Alabama | 1051 | 12114 | 230 |
1631459 | 1631459 | 2021-08-19 | Elmore | Alabama | 1051 | 12029 | 229 |
1628212 | 1628212 | 2021-08-18 | Elmore | Alabama | 1051 | 11926 | 228 |
1624965 | 1624965 | 2021-08-17 | Elmore | Alabama | 1051 | 11871 | 228 |
1621718 | 1621718 | 2021-08-16 | Elmore | Alabama | 1051 | 11711 | 226 |
1618470 | 1618470 | 2021-08-15 | Elmore | Alabama | 1051 | 11680 | 226 |
1615222 | 1615222 | 2021-08-14 | Elmore | Alabama | 1051 | 11489 | 225 |
1611973 | 1611973 | 2021-08-13 | Elmore | Alabama | 1051 | 11489 | 225 |
1608726 | 1608726 | 2021-08-12 | Elmore | Alabama | 1051 | 11437 | 222 |
1605477 | 1605477 | 2021-08-11 | Elmore | Alabama | 1051 | 11386 | 222 |
1602227 | 1602227 | 2021-08-10 | Elmore | Alabama | 1051 | 11333 | 220 |
1598979 | 1598979 | 2021-08-09 | Elmore | Alabama | 1051 | 11275 | 220 |
1595730 | 1595730 | 2021-08-08 | Elmore | Alabama | 1051 | 11187 | 220 |
1592481 | 1592481 | 2021-08-07 | Elmore | Alabama | 1051 | 11187 | 220 |
1589232 | 1589232 | 2021-08-06 | Elmore | Alabama | 1051 | 11139 | 220 |
1585983 | 1585983 | 2021-08-05 | Elmore | Alabama | 1051 | 11078 | 220 |
1582733 | 1582733 | 2021-08-04 | Elmore | Alabama | 1051 | 11006 | 220 |
1579483 | 1579483 | 2021-08-03 | Elmore | Alabama | 1051 | 10977 | 219 |
1576235 | 1576235 | 2021-08-02 | Elmore | Alabama | 1051 | 10946 | 219 |
1572987 | 1572987 | 2021-08-01 | Elmore | Alabama | 1051 | 10915 | 219 |
1569739 | 1569739 | 2021-07-31 | Elmore | Alabama | 1051 | 10890 | 219 |
1566491 | 1566491 | 2021-07-30 | Elmore | Alabama | 1051 | 10793 | 217 |
1563243 | 1563243 | 2021-07-29 | Elmore | Alabama | 1051 | 10793 | 217 |
1559995 | 1559995 | 2021-07-28 | Elmore | Alabama | 1051 | 10761 | 217 |
1556748 | 1556748 | 2021-07-27 | Elmore | Alabama | 1051 | 10727 | 217 |
1553501 | 1553501 | 2021-07-26 | Elmore | Alabama | 1051 | 10673 | 217 |
1550254 | 1550254 | 2021-07-25 | Elmore | Alabama | 1051 | 10654 | 217 |
1547007 | 1547007 | 2021-07-24 | Elmore | Alabama | 1051 | 10636 | 217 |
1543760 | 1543760 | 2021-07-23 | Elmore | Alabama | 1051 | 10614 | 217 |
1540512 | 1540512 | 2021-07-22 | Elmore | Alabama | 1051 | 10576 | 217 |
1537265 | 1537265 | 2021-07-21 | Elmore | Alabama | 1051 | 10559 | 217 |
1534017 | 1534017 | 2021-07-20 | Elmore | Alabama | 1051 | 10542 | 217 |
1530770 | 1530770 | 2021-07-19 | Elmore | Alabama | 1051 | 10518 | 216 |
1527523 | 1527523 | 2021-07-18 | Elmore | Alabama | 1051 | 10502 | 216 |
1524276 | 1524276 | 2021-07-17 | Elmore | Alabama | 1051 | 10483 | 216 |
1521028 | 1521028 | 2021-07-16 | Elmore | Alabama | 1051 | 10465 | 216 |
1517780 | 1517780 | 2021-07-15 | Elmore | Alabama | 1051 | 10445 | 216 |
1514533 | 1514533 | 2021-07-14 | Elmore | Alabama | 1051 | 10429 | 216 |
1511287 | 1511287 | 2021-07-13 | Elmore | Alabama | 1051 | 10395 | 215 |
1508040 | 1508040 | 2021-07-12 | Elmore | Alabama | 1051 | 10395 | 215 |
1504794 | 1504794 | 2021-07-11 | Elmore | Alabama | 1051 | 10376 | 215 |
1501548 | 1501548 | 2021-07-10 | Elmore | Alabama | 1051 | 10376 | 215 |
1498302 | 1498302 | 2021-07-09 | Elmore | Alabama | 1051 | 10367 | 215 |
1495055 | 1495055 | 2021-07-08 | Elmore | Alabama | 1051 | 10351 | 215 |
1491808 | 1491808 | 2021-07-07 | Elmore | Alabama | 1051 | 10351 | 215 |
1488561 | 1488561 | 2021-07-06 | Elmore | Alabama | 1051 | 10322 | 214 |
1485314 | 1485314 | 2021-07-05 | Elmore | Alabama | 1051 | 10322 | 214 |
1482068 | 1482068 | 2021-07-04 | Elmore | Alabama | 1051 | 10322 | 214 |
1478821 | 1478821 | 2021-07-03 | Elmore | Alabama | 1051 | 10322 | 214 |
1475575 | 1475575 | 2021-07-02 | Elmore | Alabama | 1051 | 10322 | 214 |
1472329 | 1472329 | 2021-07-01 | Elmore | Alabama | 1051 | 10315 | 214 |
1469084 | 1469084 | 2021-06-30 | Elmore | Alabama | 1051 | 10315 | 214 |
1465839 | 1465839 | 2021-06-29 | Elmore | Alabama | 1051 | 10311 | 214 |
1462594 | 1462594 | 2021-06-28 | Elmore | Alabama | 1051 | 10311 | 214 |
1459349 | 1459349 | 2021-06-27 | Elmore | Alabama | 1051 | 10305 | 214 |
1456104 | 1456104 | 2021-06-26 | Elmore | Alabama | 1051 | 10305 | 214 |
1452859 | 1452859 | 2021-06-25 | Elmore | Alabama | 1051 | 10305 | 214 |
1449613 | 1449613 | 2021-06-24 | Elmore | Alabama | 1051 | 10302 | 214 |
1446368 | 1446368 | 2021-06-23 | Elmore | Alabama | 1051 | 10302 | 214 |
1443123 | 1443123 | 2021-06-22 | Elmore | Alabama | 1051 | 10301 | 214 |
1439878 | 1439878 | 2021-06-21 | Elmore | Alabama | 1051 | 10301 | 214 |
1436631 | 1436631 | 2021-06-20 | Elmore | Alabama | 1051 | 10293 | 214 |
1433384 | 1433384 | 2021-06-19 | Elmore | Alabama | 1051 | 10293 | 214 |
1430138 | 1430138 | 2021-06-18 | Elmore | Alabama | 1051 | 10293 | 214 |
1426893 | 1426893 | 2021-06-17 | Elmore | Alabama | 1051 | 10295 | 213 |
1423647 | 1423647 | 2021-06-16 | Elmore | Alabama | 1051 | 10295 | 213 |
1420400 | 1420400 | 2021-06-15 | Elmore | Alabama | 1051 | 10293 | 212 |
1417155 | 1417155 | 2021-06-14 | Elmore | Alabama | 1051 | 10292 | 212 |
1413909 | 1413909 | 2021-06-13 | Elmore | Alabama | 1051 | 10295 | 212 |
1410664 | 1410664 | 2021-06-12 | Elmore | Alabama | 1051 | 10295 | 212 |
1407419 | 1407419 | 2021-06-11 | Elmore | Alabama | 1051 | 10295 | 212 |
1404173 | 1404173 | 2021-06-10 | Elmore | Alabama | 1051 | 10300 | 211 |
1400928 | 1400928 | 2021-06-09 | Elmore | Alabama | 1051 | 10298 | 211 |
1397683 | 1397683 | 2021-06-08 | Elmore | Alabama | 1051 | 10298 | 210 |
1394436 | 1394436 | 2021-06-07 | Elmore | Alabama | 1051 | 10296 | 210 |
1391191 | 1391191 | 2021-06-06 | Elmore | Alabama | 1051 | 10283 | 210 |
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);