ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Watauga" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948596 | 1948596 | 2021-11-24 | Watauga | North Carolina | 37189 | 6879 | 40 |
1945345 | 1945345 | 2021-11-23 | Watauga | North Carolina | 37189 | 6866 | 40 |
1942094 | 1942094 | 2021-11-22 | Watauga | North Carolina | 37189 | 6861 | 40 |
1938844 | 1938844 | 2021-11-21 | Watauga | North Carolina | 37189 | 6845 | 40 |
1935594 | 1935594 | 2021-11-20 | Watauga | North Carolina | 37189 | 6845 | 40 |
1932344 | 1932344 | 2021-11-19 | Watauga | North Carolina | 37189 | 6845 | 40 |
1929093 | 1929093 | 2021-11-18 | Watauga | North Carolina | 37189 | 6837 | 40 |
1925843 | 1925843 | 2021-11-17 | Watauga | North Carolina | 37189 | 6829 | 40 |
1922594 | 1922594 | 2021-11-16 | Watauga | North Carolina | 37189 | 6818 | 40 |
1919344 | 1919344 | 2021-11-15 | Watauga | North Carolina | 37189 | 6815 | 40 |
1916094 | 1916094 | 2021-11-14 | Watauga | North Carolina | 37189 | 6789 | 39 |
1912844 | 1912844 | 2021-11-13 | Watauga | North Carolina | 37189 | 6789 | 39 |
1909594 | 1909594 | 2021-11-12 | Watauga | North Carolina | 37189 | 6789 | 39 |
1906345 | 1906345 | 2021-11-11 | Watauga | North Carolina | 37189 | 6760 | 39 |
1903096 | 1903096 | 2021-11-10 | Watauga | North Carolina | 37189 | 6760 | 39 |
1899846 | 1899846 | 2021-11-09 | Watauga | North Carolina | 37189 | 6748 | 39 |
1896596 | 1896596 | 2021-11-08 | Watauga | North Carolina | 37189 | 6743 | 39 |
1893346 | 1893346 | 2021-11-07 | Watauga | North Carolina | 37189 | 6711 | 39 |
1890096 | 1890096 | 2021-11-06 | Watauga | North Carolina | 37189 | 6711 | 39 |
1886846 | 1886846 | 2021-11-05 | Watauga | North Carolina | 37189 | 6711 | 39 |
1883597 | 1883597 | 2021-11-04 | Watauga | North Carolina | 37189 | 6688 | 39 |
1880348 | 1880348 | 2021-11-03 | Watauga | North Carolina | 37189 | 6672 | 39 |
1877099 | 1877099 | 2021-11-02 | Watauga | North Carolina | 37189 | 6660 | 39 |
1873850 | 1873850 | 2021-11-01 | Watauga | North Carolina | 37189 | 6653 | 38 |
1870601 | 1870601 | 2021-10-31 | Watauga | North Carolina | 37189 | 6636 | 38 |
1867352 | 1867352 | 2021-10-30 | Watauga | North Carolina | 37189 | 6636 | 38 |
1864103 | 1864103 | 2021-10-29 | Watauga | North Carolina | 37189 | 6636 | 38 |
1860854 | 1860854 | 2021-10-28 | Watauga | North Carolina | 37189 | 6631 | 38 |
1857605 | 1857605 | 2021-10-27 | Watauga | North Carolina | 37189 | 6599 | 37 |
1854356 | 1854356 | 2021-10-26 | Watauga | North Carolina | 37189 | 6584 | 37 |
1851107 | 1851107 | 2021-10-25 | Watauga | North Carolina | 37189 | 6583 | 37 |
1847857 | 1847857 | 2021-10-24 | Watauga | North Carolina | 37189 | 6557 | 37 |
1844607 | 1844607 | 2021-10-23 | Watauga | North Carolina | 37189 | 6557 | 37 |
1841357 | 1841357 | 2021-10-22 | Watauga | North Carolina | 37189 | 6557 | 37 |
1838108 | 1838108 | 2021-10-21 | Watauga | North Carolina | 37189 | 6549 | 38 |
1834859 | 1834859 | 2021-10-20 | Watauga | North Carolina | 37189 | 6527 | 38 |
1831610 | 1831610 | 2021-10-19 | Watauga | North Carolina | 37189 | 6518 | 38 |
1828361 | 1828361 | 2021-10-18 | Watauga | North Carolina | 37189 | 6514 | 38 |
1825112 | 1825112 | 2021-10-17 | Watauga | North Carolina | 37189 | 6478 | 38 |
1821863 | 1821863 | 2021-10-16 | Watauga | North Carolina | 37189 | 6478 | 38 |
1818614 | 1818614 | 2021-10-15 | Watauga | North Carolina | 37189 | 6478 | 38 |
1815365 | 1815365 | 2021-10-14 | Watauga | North Carolina | 37189 | 6460 | 38 |
1812117 | 1812117 | 2021-10-13 | Watauga | North Carolina | 37189 | 6431 | 35 |
1808868 | 1808868 | 2021-10-12 | Watauga | North Carolina | 37189 | 6423 | 35 |
1805617 | 1805617 | 2021-10-11 | Watauga | North Carolina | 37189 | 6420 | 35 |
1802368 | 1802368 | 2021-10-10 | Watauga | North Carolina | 37189 | 6386 | 34 |
1799119 | 1799119 | 2021-10-09 | Watauga | North Carolina | 37189 | 6386 | 34 |
1795870 | 1795870 | 2021-10-08 | Watauga | North Carolina | 37189 | 6386 | 34 |
1792621 | 1792621 | 2021-10-07 | Watauga | North Carolina | 37189 | 6374 | 34 |
1789372 | 1789372 | 2021-10-06 | Watauga | North Carolina | 37189 | 6346 | 34 |
1786124 | 1786124 | 2021-10-05 | Watauga | North Carolina | 37189 | 6325 | 34 |
1782875 | 1782875 | 2021-10-04 | Watauga | North Carolina | 37189 | 6308 | 34 |
1779626 | 1779626 | 2021-10-03 | Watauga | North Carolina | 37189 | 6295 | 34 |
1776376 | 1776376 | 2021-10-02 | Watauga | North Carolina | 37189 | 6295 | 34 |
1773126 | 1773126 | 2021-10-01 | Watauga | North Carolina | 37189 | 6295 | 34 |
1769876 | 1769876 | 2021-09-30 | Watauga | North Carolina | 37189 | 6263 | 34 |
1766627 | 1766627 | 2021-09-29 | Watauga | North Carolina | 37189 | 6244 | 34 |
1763378 | 1763378 | 2021-09-28 | Watauga | North Carolina | 37189 | 6220 | 34 |
1760129 | 1760129 | 2021-09-27 | Watauga | North Carolina | 37189 | 6209 | 34 |
1756881 | 1756881 | 2021-09-26 | Watauga | North Carolina | 37189 | 6164 | 34 |
1753633 | 1753633 | 2021-09-25 | Watauga | North Carolina | 37189 | 6164 | 34 |
1750385 | 1750385 | 2021-09-24 | Watauga | North Carolina | 37189 | 6164 | 34 |
1747135 | 1747135 | 2021-09-23 | Watauga | North Carolina | 37189 | 6143 | 34 |
1743886 | 1743886 | 2021-09-22 | Watauga | North Carolina | 37189 | 6114 | 34 |
1740637 | 1740637 | 2021-09-21 | Watauga | North Carolina | 37189 | 6105 | 34 |
1737388 | 1737388 | 2021-09-20 | Watauga | North Carolina | 37189 | 6086 | 34 |
1734138 | 1734138 | 2021-09-19 | Watauga | North Carolina | 37189 | 6016 | 34 |
1730888 | 1730888 | 2021-09-18 | Watauga | North Carolina | 37189 | 6016 | 34 |
1727638 | 1727638 | 2021-09-17 | Watauga | North Carolina | 37189 | 6016 | 34 |
1724389 | 1724389 | 2021-09-16 | Watauga | North Carolina | 37189 | 5973 | 34 |
1721140 | 1721140 | 2021-09-15 | Watauga | North Carolina | 37189 | 5961 | 34 |
1717892 | 1717892 | 2021-09-14 | Watauga | North Carolina | 37189 | 5935 | 34 |
1714644 | 1714644 | 2021-09-13 | Watauga | North Carolina | 37189 | 5911 | 34 |
1711398 | 1711398 | 2021-09-12 | Watauga | North Carolina | 37189 | 5817 | 34 |
1708151 | 1708151 | 2021-09-11 | Watauga | North Carolina | 37189 | 5817 | 34 |
1704904 | 1704904 | 2021-09-10 | Watauga | North Carolina | 37189 | 5817 | 34 |
1701654 | 1701654 | 2021-09-09 | Watauga | North Carolina | 37189 | 5794 | 34 |
1698405 | 1698405 | 2021-09-08 | Watauga | North Carolina | 37189 | 5761 | 34 |
1695157 | 1695157 | 2021-09-07 | Watauga | North Carolina | 37189 | 5754 | 34 |
1691909 | 1691909 | 2021-09-06 | Watauga | North Carolina | 37189 | 5635 | 34 |
1688659 | 1688659 | 2021-09-05 | Watauga | North Carolina | 37189 | 5635 | 34 |
1685409 | 1685409 | 2021-09-04 | Watauga | North Carolina | 37189 | 5635 | 34 |
1682158 | 1682158 | 2021-09-03 | Watauga | North Carolina | 37189 | 5635 | 34 |
1678909 | 1678909 | 2021-09-02 | Watauga | North Carolina | 37189 | 5577 | 34 |
1675661 | 1675661 | 2021-09-01 | Watauga | North Carolina | 37189 | 5555 | 34 |
1672414 | 1672414 | 2021-08-31 | Watauga | North Carolina | 37189 | 5532 | 33 |
1669166 | 1669166 | 2021-08-30 | Watauga | North Carolina | 37189 | 5491 | 33 |
1665919 | 1665919 | 2021-08-29 | Watauga | North Carolina | 37189 | 5455 | 33 |
1662671 | 1662671 | 2021-08-28 | Watauga | North Carolina | 37189 | 5455 | 33 |
1659423 | 1659423 | 2021-08-27 | Watauga | North Carolina | 37189 | 5455 | 33 |
1656174 | 1656174 | 2021-08-26 | Watauga | North Carolina | 37189 | 5427 | 33 |
1652927 | 1652927 | 2021-08-25 | Watauga | North Carolina | 37189 | 5402 | 33 |
1649679 | 1649679 | 2021-08-24 | Watauga | North Carolina | 37189 | 5381 | 33 |
1646430 | 1646430 | 2021-08-23 | Watauga | North Carolina | 37189 | 5365 | 33 |
1643181 | 1643181 | 2021-08-22 | Watauga | North Carolina | 37189 | 5294 | 33 |
1639931 | 1639931 | 2021-08-21 | Watauga | North Carolina | 37189 | 5294 | 33 |
1636681 | 1636681 | 2021-08-20 | Watauga | North Carolina | 37189 | 5294 | 33 |
1633431 | 1633431 | 2021-08-19 | Watauga | North Carolina | 37189 | 5275 | 33 |
1630184 | 1630184 | 2021-08-18 | Watauga | North Carolina | 37189 | 5260 | 33 |
1626937 | 1626937 | 2021-08-17 | Watauga | North Carolina | 37189 | 5253 | 33 |
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);