ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Houston" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810583 | 1810583 | 2021-10-13 | Houston | Georgia | 13153 | 24643 | 358 |
1807334 | 1807334 | 2021-10-12 | Houston | Georgia | 13153 | 24629 | 358 |
1804083 | 1804083 | 2021-10-11 | Houston | Georgia | 13153 | 24543 | 353 |
1800834 | 1800834 | 2021-10-10 | Houston | Georgia | 13153 | 24543 | 353 |
1797585 | 1797585 | 2021-10-09 | Houston | Georgia | 13153 | 24543 | 353 |
1794336 | 1794336 | 2021-10-08 | Houston | Georgia | 13153 | 24543 | 353 |
1791088 | 1791088 | 2021-10-07 | Houston | Georgia | 13153 | 24519 | 349 |
1787839 | 1787839 | 2021-10-06 | Houston | Georgia | 13153 | 24456 | 346 |
1784590 | 1784590 | 2021-10-05 | Houston | Georgia | 13153 | 24405 | 343 |
1781341 | 1781341 | 2021-10-04 | Houston | Georgia | 13153 | 24350 | 341 |
1778091 | 1778091 | 2021-10-03 | Houston | Georgia | 13153 | 24262 | 337 |
1774841 | 1774841 | 2021-10-02 | Houston | Georgia | 13153 | 24262 | 337 |
1771591 | 1771591 | 2021-10-01 | Houston | Georgia | 13153 | 24262 | 337 |
1768342 | 1768342 | 2021-09-30 | Houston | Georgia | 13153 | 24217 | 334 |
1765093 | 1765093 | 2021-09-29 | Houston | Georgia | 13153 | 24159 | 333 |
1761844 | 1761844 | 2021-09-28 | Houston | Georgia | 13153 | 24107 | 330 |
1758596 | 1758596 | 2021-09-27 | Houston | Georgia | 13153 | 24038 | 326 |
1755348 | 1755348 | 2021-09-26 | Houston | Georgia | 13153 | 23927 | 323 |
1752100 | 1752100 | 2021-09-25 | Houston | Georgia | 13153 | 23927 | 323 |
1748851 | 1748851 | 2021-09-24 | Houston | Georgia | 13153 | 23927 | 323 |
1745601 | 1745601 | 2021-09-23 | Houston | Georgia | 13153 | 23860 | 322 |
1742352 | 1742352 | 2021-09-22 | Houston | Georgia | 13153 | 23767 | 317 |
1739103 | 1739103 | 2021-09-21 | Houston | Georgia | 13153 | 23694 | 315 |
1735854 | 1735854 | 2021-09-20 | Houston | Georgia | 13153 | 23587 | 313 |
1732604 | 1732604 | 2021-09-19 | Houston | Georgia | 13153 | 23410 | 312 |
1729354 | 1729354 | 2021-09-18 | Houston | Georgia | 13153 | 23410 | 312 |
1726104 | 1726104 | 2021-09-17 | Houston | Georgia | 13153 | 23410 | 312 |
1722855 | 1722855 | 2021-09-16 | Houston | Georgia | 13153 | 23276 | 309 |
1719606 | 1719606 | 2021-09-15 | Houston | Georgia | 13153 | 23079 | 306 |
1716358 | 1716358 | 2021-09-14 | Houston | Georgia | 13153 | 22934 | 301 |
1713112 | 1713112 | 2021-09-13 | Houston | Georgia | 13153 | 22716 | 298 |
1709865 | 1709865 | 2021-09-12 | Houston | Georgia | 13153 | 22436 | 290 |
1706618 | 1706618 | 2021-09-11 | Houston | Georgia | 13153 | 22436 | 290 |
1703370 | 1703370 | 2021-09-10 | Houston | Georgia | 13153 | 22436 | 290 |
1700120 | 1700120 | 2021-09-09 | Houston | Georgia | 13153 | 22194 | 290 |
1696871 | 1696871 | 2021-09-08 | Houston | Georgia | 13153 | 21909 | 289 |
1693623 | 1693623 | 2021-09-07 | Houston | Georgia | 13153 | 21636 | 288 |
1690374 | 1690374 | 2021-09-06 | Houston | Georgia | 13153 | 21013 | 284 |
1687124 | 1687124 | 2021-09-05 | Houston | Georgia | 13153 | 21013 | 284 |
1683874 | 1683874 | 2021-09-04 | Houston | Georgia | 13153 | 21013 | 284 |
1680623 | 1680623 | 2021-09-03 | Houston | Georgia | 13153 | 21013 | 284 |
1677375 | 1677375 | 2021-09-02 | Houston | Georgia | 13153 | 20718 | 281 |
1674128 | 1674128 | 2021-09-01 | Houston | Georgia | 13153 | 20493 | 281 |
1670880 | 1670880 | 2021-08-31 | Houston | Georgia | 13153 | 20273 | 281 |
1667633 | 1667633 | 2021-08-30 | Houston | Georgia | 13153 | 20155 | 281 |
1664386 | 1664386 | 2021-08-29 | Houston | Georgia | 13153 | 19730 | 280 |
1661138 | 1661138 | 2021-08-28 | Houston | Georgia | 13153 | 19730 | 280 |
1657890 | 1657890 | 2021-08-27 | Houston | Georgia | 13153 | 19730 | 280 |
1654642 | 1654642 | 2021-08-26 | Houston | Georgia | 13153 | 19510 | 280 |
1651395 | 1651395 | 2021-08-25 | Houston | Georgia | 13153 | 19289 | 279 |
1648146 | 1648146 | 2021-08-24 | Houston | Georgia | 13153 | 19109 | 279 |
1644898 | 1644898 | 2021-08-23 | Houston | Georgia | 13153 | 18858 | 277 |
1641648 | 1641648 | 2021-08-22 | Houston | Georgia | 13153 | 18499 | 277 |
1638398 | 1638398 | 2021-08-21 | Houston | Georgia | 13153 | 18499 | 277 |
1635148 | 1635148 | 2021-08-20 | Houston | Georgia | 13153 | 18499 | 277 |
1631899 | 1631899 | 2021-08-19 | Houston | Georgia | 13153 | 18273 | 277 |
1628652 | 1628652 | 2021-08-18 | Houston | Georgia | 13153 | 18066 | 277 |
1625405 | 1625405 | 2021-08-17 | Houston | Georgia | 13153 | 17888 | 277 |
1622158 | 1622158 | 2021-08-16 | Houston | Georgia | 13153 | 17719 | 276 |
1618911 | 1618911 | 2021-08-15 | Houston | Georgia | 13153 | 17273 | 276 |
1615663 | 1615663 | 2021-08-14 | Houston | Georgia | 13153 | 17273 | 276 |
1612414 | 1612414 | 2021-08-13 | Houston | Georgia | 13153 | 17273 | 276 |
1609166 | 1609166 | 2021-08-12 | Houston | Georgia | 13153 | 17102 | 275 |
1605917 | 1605917 | 2021-08-11 | Houston | Georgia | 13153 | 16967 | 274 |
1602668 | 1602668 | 2021-08-10 | Houston | Georgia | 13153 | 16842 | 274 |
1599419 | 1599419 | 2021-08-09 | Houston | Georgia | 13153 | 16667 | 274 |
1596170 | 1596170 | 2021-08-08 | Houston | Georgia | 13153 | 16423 | 274 |
1592921 | 1592921 | 2021-08-07 | Houston | Georgia | 13153 | 16423 | 274 |
1589672 | 1589672 | 2021-08-06 | Houston | Georgia | 13153 | 16423 | 274 |
1586423 | 1586423 | 2021-08-05 | Houston | Georgia | 13153 | 16305 | 274 |
1583173 | 1583173 | 2021-08-04 | Houston | Georgia | 13153 | 16201 | 274 |
1579923 | 1579923 | 2021-08-03 | Houston | Georgia | 13153 | 16113 | 274 |
1576675 | 1576675 | 2021-08-02 | Houston | Georgia | 13153 | 15954 | 274 |
1573427 | 1573427 | 2021-08-01 | Houston | Georgia | 13153 | 15806 | 274 |
1570179 | 1570179 | 2021-07-31 | Houston | Georgia | 13153 | 15806 | 274 |
1566931 | 1566931 | 2021-07-30 | Houston | Georgia | 13153 | 15806 | 274 |
1563683 | 1563683 | 2021-07-29 | Houston | Georgia | 13153 | 15724 | 274 |
1560435 | 1560435 | 2021-07-28 | Houston | Georgia | 13153 | 15654 | 274 |
1557188 | 1557188 | 2021-07-27 | Houston | Georgia | 13153 | 15576 | 274 |
1553941 | 1553941 | 2021-07-26 | Houston | Georgia | 13153 | 15487 | 274 |
1550694 | 1550694 | 2021-07-25 | Houston | Georgia | 13153 | 15405 | 274 |
1547447 | 1547447 | 2021-07-24 | Houston | Georgia | 13153 | 15405 | 274 |
1544200 | 1544200 | 2021-07-23 | Houston | Georgia | 13153 | 15405 | 274 |
1540952 | 1540952 | 2021-07-22 | Houston | Georgia | 13153 | 15347 | 274 |
1537705 | 1537705 | 2021-07-21 | Houston | Georgia | 13153 | 15309 | 274 |
1534457 | 1534457 | 2021-07-20 | Houston | Georgia | 13153 | 15287 | 273 |
1531210 | 1531210 | 2021-07-19 | Houston | Georgia | 13153 | 15231 | 274 |
1527963 | 1527963 | 2021-07-18 | Houston | Georgia | 13153 | 15188 | 274 |
1524716 | 1524716 | 2021-07-17 | Houston | Georgia | 13153 | 15188 | 274 |
1521468 | 1521468 | 2021-07-16 | Houston | Georgia | 13153 | 15188 | 274 |
1518220 | 1518220 | 2021-07-15 | Houston | Georgia | 13153 | 15158 | 274 |
1514973 | 1514973 | 2021-07-14 | Houston | Georgia | 13153 | 15132 | 274 |
1511727 | 1511727 | 2021-07-13 | Houston | Georgia | 13153 | 15109 | 274 |
1508480 | 1508480 | 2021-07-12 | Houston | Georgia | 13153 | 15082 | 274 |
1505234 | 1505234 | 2021-07-11 | Houston | Georgia | 13153 | 15053 | 274 |
1501988 | 1501988 | 2021-07-10 | Houston | Georgia | 13153 | 15053 | 274 |
1498742 | 1498742 | 2021-07-09 | Houston | Georgia | 13153 | 15053 | 274 |
1495495 | 1495495 | 2021-07-08 | Houston | Georgia | 13153 | 15040 | 274 |
1492249 | 1492249 | 2021-07-07 | Houston | Georgia | 13153 | 15024 | 274 |
1489002 | 1489002 | 2021-07-06 | Houston | Georgia | 13153 | 15017 | 273 |
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);