ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Tallapoosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712708 | 1712708 | 2021-09-13 | Tallapoosa | Alabama | 1123 | 6149 | 163 |
1709461 | 1709461 | 2021-09-12 | Tallapoosa | Alabama | 1123 | 6129 | 163 |
1706214 | 1706214 | 2021-09-11 | Tallapoosa | Alabama | 1123 | 6116 | 163 |
1702966 | 1702966 | 2021-09-10 | Tallapoosa | Alabama | 1123 | 6035 | 163 |
1699716 | 1699716 | 2021-09-09 | Tallapoosa | Alabama | 1123 | 5976 | 163 |
1696467 | 1696467 | 2021-09-08 | Tallapoosa | Alabama | 1123 | 5923 | 163 |
1693219 | 1693219 | 2021-09-07 | Tallapoosa | Alabama | 1123 | 5861 | 163 |
1689970 | 1689970 | 2021-09-06 | Tallapoosa | Alabama | 1123 | 5851 | 163 |
1686720 | 1686720 | 2021-09-05 | Tallapoosa | Alabama | 1123 | 5836 | 163 |
1683470 | 1683470 | 2021-09-04 | Tallapoosa | Alabama | 1123 | 5799 | 163 |
1680219 | 1680219 | 2021-09-03 | Tallapoosa | Alabama | 1123 | 5740 | 163 |
1676971 | 1676971 | 2021-09-02 | Tallapoosa | Alabama | 1123 | 5675 | 163 |
1673724 | 1673724 | 2021-09-01 | Tallapoosa | Alabama | 1123 | 5627 | 163 |
1670476 | 1670476 | 2021-08-31 | Tallapoosa | Alabama | 1123 | 5577 | 163 |
1667229 | 1667229 | 2021-08-30 | Tallapoosa | Alabama | 1123 | 5524 | 161 |
1663981 | 1663981 | 2021-08-29 | Tallapoosa | Alabama | 1123 | 5489 | 161 |
1660733 | 1660733 | 2021-08-28 | Tallapoosa | Alabama | 1123 | 5468 | 161 |
1657485 | 1657485 | 2021-08-27 | Tallapoosa | Alabama | 1123 | 5420 | 160 |
1654237 | 1654237 | 2021-08-26 | Tallapoosa | Alabama | 1123 | 5361 | 159 |
1650991 | 1650991 | 2021-08-25 | Tallapoosa | Alabama | 1123 | 5257 | 158 |
1647742 | 1647742 | 2021-08-24 | Tallapoosa | Alabama | 1123 | 5257 | 158 |
1644493 | 1644493 | 2021-08-23 | Tallapoosa | Alabama | 1123 | 5257 | 158 |
1641243 | 1641243 | 2021-08-22 | Tallapoosa | Alabama | 1123 | 5247 | 158 |
1637993 | 1637993 | 2021-08-21 | Tallapoosa | Alabama | 1123 | 5223 | 158 |
1634743 | 1634743 | 2021-08-20 | Tallapoosa | Alabama | 1123 | 5147 | 158 |
1631495 | 1631495 | 2021-08-19 | Tallapoosa | Alabama | 1123 | 5103 | 158 |
1628248 | 1628248 | 2021-08-18 | Tallapoosa | Alabama | 1123 | 5060 | 157 |
1625001 | 1625001 | 2021-08-17 | Tallapoosa | Alabama | 1123 | 5036 | 157 |
1621754 | 1621754 | 2021-08-16 | Tallapoosa | Alabama | 1123 | 4977 | 157 |
1618506 | 1618506 | 2021-08-15 | Tallapoosa | Alabama | 1123 | 4956 | 157 |
1615258 | 1615258 | 2021-08-14 | Tallapoosa | Alabama | 1123 | 4879 | 157 |
1612009 | 1612009 | 2021-08-13 | Tallapoosa | Alabama | 1123 | 4879 | 157 |
1608762 | 1608762 | 2021-08-12 | Tallapoosa | Alabama | 1123 | 4848 | 157 |
1605513 | 1605513 | 2021-08-11 | Tallapoosa | Alabama | 1123 | 4826 | 157 |
1602263 | 1602263 | 2021-08-10 | Tallapoosa | Alabama | 1123 | 4770 | 157 |
1599015 | 1599015 | 2021-08-09 | Tallapoosa | Alabama | 1123 | 4734 | 157 |
1595766 | 1595766 | 2021-08-08 | Tallapoosa | Alabama | 1123 | 4710 | 157 |
1592517 | 1592517 | 2021-08-07 | Tallapoosa | Alabama | 1123 | 4710 | 157 |
1589268 | 1589268 | 2021-08-06 | Tallapoosa | Alabama | 1123 | 4659 | 156 |
1586019 | 1586019 | 2021-08-05 | Tallapoosa | Alabama | 1123 | 4633 | 156 |
1582769 | 1582769 | 2021-08-04 | Tallapoosa | Alabama | 1123 | 4591 | 156 |
1579519 | 1579519 | 2021-08-03 | Tallapoosa | Alabama | 1123 | 4571 | 156 |
1576271 | 1576271 | 2021-08-02 | Tallapoosa | Alabama | 1123 | 4525 | 156 |
1573023 | 1573023 | 2021-08-01 | Tallapoosa | Alabama | 1123 | 4519 | 156 |
1569775 | 1569775 | 2021-07-31 | Tallapoosa | Alabama | 1123 | 4511 | 156 |
1566527 | 1566527 | 2021-07-30 | Tallapoosa | Alabama | 1123 | 4462 | 156 |
1563279 | 1563279 | 2021-07-29 | Tallapoosa | Alabama | 1123 | 4462 | 156 |
1560031 | 1560031 | 2021-07-28 | Tallapoosa | Alabama | 1123 | 4440 | 156 |
1556784 | 1556784 | 2021-07-27 | Tallapoosa | Alabama | 1123 | 4420 | 157 |
1553537 | 1553537 | 2021-07-26 | Tallapoosa | Alabama | 1123 | 4383 | 157 |
1550290 | 1550290 | 2021-07-25 | Tallapoosa | Alabama | 1123 | 4379 | 157 |
1547043 | 1547043 | 2021-07-24 | Tallapoosa | Alabama | 1123 | 4372 | 157 |
1543796 | 1543796 | 2021-07-23 | Tallapoosa | Alabama | 1123 | 4362 | 156 |
1540548 | 1540548 | 2021-07-22 | Tallapoosa | Alabama | 1123 | 4343 | 156 |
1537301 | 1537301 | 2021-07-21 | Tallapoosa | Alabama | 1123 | 4326 | 156 |
1534053 | 1534053 | 2021-07-20 | Tallapoosa | Alabama | 1123 | 4315 | 156 |
1530806 | 1530806 | 2021-07-19 | Tallapoosa | Alabama | 1123 | 4291 | 156 |
1527559 | 1527559 | 2021-07-18 | Tallapoosa | Alabama | 1123 | 4291 | 156 |
1524312 | 1524312 | 2021-07-17 | Tallapoosa | Alabama | 1123 | 4290 | 156 |
1521064 | 1521064 | 2021-07-16 | Tallapoosa | Alabama | 1123 | 4278 | 156 |
1517816 | 1517816 | 2021-07-15 | Tallapoosa | Alabama | 1123 | 4264 | 156 |
1514569 | 1514569 | 2021-07-14 | Tallapoosa | Alabama | 1123 | 4245 | 156 |
1511323 | 1511323 | 2021-07-13 | Tallapoosa | Alabama | 1123 | 4207 | 156 |
1508076 | 1508076 | 2021-07-12 | Tallapoosa | Alabama | 1123 | 4207 | 156 |
1504830 | 1504830 | 2021-07-11 | Tallapoosa | Alabama | 1123 | 4201 | 156 |
1501584 | 1501584 | 2021-07-10 | Tallapoosa | Alabama | 1123 | 4201 | 156 |
1498338 | 1498338 | 2021-07-09 | Tallapoosa | Alabama | 1123 | 4196 | 156 |
1495091 | 1495091 | 2021-07-08 | Tallapoosa | Alabama | 1123 | 4173 | 156 |
1491844 | 1491844 | 2021-07-07 | Tallapoosa | Alabama | 1123 | 4173 | 156 |
1488597 | 1488597 | 2021-07-06 | Tallapoosa | Alabama | 1123 | 4154 | 156 |
1485350 | 1485350 | 2021-07-05 | Tallapoosa | Alabama | 1123 | 4154 | 156 |
1482104 | 1482104 | 2021-07-04 | Tallapoosa | Alabama | 1123 | 4154 | 156 |
1478857 | 1478857 | 2021-07-03 | Tallapoosa | Alabama | 1123 | 4154 | 156 |
1475611 | 1475611 | 2021-07-02 | Tallapoosa | Alabama | 1123 | 4154 | 156 |
1472365 | 1472365 | 2021-07-01 | Tallapoosa | Alabama | 1123 | 4153 | 155 |
1469120 | 1469120 | 2021-06-30 | Tallapoosa | Alabama | 1123 | 4153 | 155 |
1465875 | 1465875 | 2021-06-29 | Tallapoosa | Alabama | 1123 | 4149 | 155 |
1462630 | 1462630 | 2021-06-28 | Tallapoosa | Alabama | 1123 | 4149 | 155 |
1459385 | 1459385 | 2021-06-27 | Tallapoosa | Alabama | 1123 | 4145 | 155 |
1456140 | 1456140 | 2021-06-26 | Tallapoosa | Alabama | 1123 | 4145 | 155 |
1452895 | 1452895 | 2021-06-25 | Tallapoosa | Alabama | 1123 | 4145 | 155 |
1449649 | 1449649 | 2021-06-24 | Tallapoosa | Alabama | 1123 | 4137 | 155 |
1446404 | 1446404 | 2021-06-23 | Tallapoosa | Alabama | 1123 | 4137 | 155 |
1443159 | 1443159 | 2021-06-22 | Tallapoosa | Alabama | 1123 | 4144 | 155 |
1439914 | 1439914 | 2021-06-21 | Tallapoosa | Alabama | 1123 | 4144 | 155 |
1436667 | 1436667 | 2021-06-20 | Tallapoosa | Alabama | 1123 | 4138 | 155 |
1433420 | 1433420 | 2021-06-19 | Tallapoosa | Alabama | 1123 | 4138 | 155 |
1430174 | 1430174 | 2021-06-18 | Tallapoosa | Alabama | 1123 | 4138 | 155 |
1426929 | 1426929 | 2021-06-17 | Tallapoosa | Alabama | 1123 | 4136 | 155 |
1423683 | 1423683 | 2021-06-16 | Tallapoosa | Alabama | 1123 | 4136 | 155 |
1420436 | 1420436 | 2021-06-15 | Tallapoosa | Alabama | 1123 | 4133 | 155 |
1417191 | 1417191 | 2021-06-14 | Tallapoosa | Alabama | 1123 | 4127 | 154 |
1413945 | 1413945 | 2021-06-13 | Tallapoosa | Alabama | 1123 | 4117 | 154 |
1410700 | 1410700 | 2021-06-12 | Tallapoosa | Alabama | 1123 | 4117 | 154 |
1407455 | 1407455 | 2021-06-11 | Tallapoosa | Alabama | 1123 | 4117 | 154 |
1404209 | 1404209 | 2021-06-10 | Tallapoosa | Alabama | 1123 | 4114 | 155 |
1400964 | 1400964 | 2021-06-09 | Tallapoosa | Alabama | 1123 | 4113 | 155 |
1397719 | 1397719 | 2021-06-08 | Tallapoosa | Alabama | 1123 | 4112 | 155 |
1394472 | 1394472 | 2021-06-07 | Tallapoosa | Alabama | 1123 | 4109 | 155 |
1391227 | 1391227 | 2021-06-06 | Tallapoosa | Alabama | 1123 | 4096 | 155 |
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);