ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,164 rows where deaths = 6 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Tyrrell 261
- Alleghany 75
- Davie 61
- Camden 55
- Warren 54
- Wilkes 41
- Hyde 36
- Martin 35
- Mitchell 34
- Watauga 33
- Yadkin 32
- Caswell 25
- Pitt 25
- Dare 22
- Person 22
- Nash 21
- Craven 17
- Granville 17
- Polk 16
- Halifax 14
- Anson 13
- Pamlico 13
- Bertie 12
- Caldwell 12
- Cherokee 12
- Gaston 12
- Randolph 12
- Rutherford 10
- Sampson 10
- Washington 10
- …
state 1
- North Carolina · 1,164 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2059019 | 2059019 | 2021-12-28 | Alleghany | North Carolina | 37005 | 2063 | 6 |
2055770 | 2055770 | 2021-12-27 | Alleghany | North Carolina | 37005 | 2028 | 6 |
2052520 | 2052520 | 2021-12-26 | Alleghany | North Carolina | 37005 | 2028 | 6 |
2049270 | 2049270 | 2021-12-25 | Alleghany | North Carolina | 37005 | 2028 | 6 |
2046020 | 2046020 | 2021-12-24 | Alleghany | North Carolina | 37005 | 2028 | 6 |
2042770 | 2042770 | 2021-12-23 | Alleghany | North Carolina | 37005 | 2028 | 6 |
2039521 | 2039521 | 2021-12-22 | Alleghany | North Carolina | 37005 | 2028 | 6 |
2036271 | 2036271 | 2021-12-21 | Alleghany | North Carolina | 37005 | 2017 | 6 |
2033021 | 2033021 | 2021-12-20 | Alleghany | North Carolina | 37005 | 2013 | 6 |
2029771 | 2029771 | 2021-12-19 | Alleghany | North Carolina | 37005 | 1979 | 6 |
2026520 | 2026520 | 2021-12-18 | Alleghany | North Carolina | 37005 | 1979 | 6 |
2023269 | 2023269 | 2021-12-17 | Alleghany | North Carolina | 37005 | 1979 | 6 |
2020018 | 2020018 | 2021-12-16 | Alleghany | North Carolina | 37005 | 1972 | 6 |
2016767 | 2016767 | 2021-12-15 | Alleghany | North Carolina | 37005 | 1962 | 6 |
2013517 | 2013517 | 2021-12-14 | Alleghany | North Carolina | 37005 | 1947 | 6 |
2010266 | 2010266 | 2021-12-13 | Alleghany | North Carolina | 37005 | 1944 | 6 |
2007015 | 2007015 | 2021-12-12 | Alleghany | North Carolina | 37005 | 1911 | 6 |
2003764 | 2003764 | 2021-12-11 | Alleghany | North Carolina | 37005 | 1911 | 6 |
2000513 | 2000513 | 2021-12-10 | Alleghany | North Carolina | 37005 | 1911 | 6 |
1997263 | 1997263 | 2021-12-09 | Alleghany | North Carolina | 37005 | 1890 | 6 |
1994012 | 1994012 | 2021-12-08 | Alleghany | North Carolina | 37005 | 1882 | 6 |
1990761 | 1990761 | 2021-12-07 | Alleghany | North Carolina | 37005 | 1852 | 6 |
1987510 | 1987510 | 2021-12-06 | Alleghany | North Carolina | 37005 | 1847 | 6 |
1984260 | 1984260 | 2021-12-05 | Alleghany | North Carolina | 37005 | 1826 | 6 |
1981010 | 1981010 | 2021-12-04 | Alleghany | North Carolina | 37005 | 1826 | 6 |
1977760 | 1977760 | 2021-12-03 | Alleghany | North Carolina | 37005 | 1826 | 6 |
1974510 | 1974510 | 2021-12-02 | Alleghany | North Carolina | 37005 | 1818 | 6 |
1971261 | 1971261 | 2021-12-01 | Alleghany | North Carolina | 37005 | 1815 | 6 |
1968011 | 1968011 | 2021-11-30 | Alleghany | North Carolina | 37005 | 1807 | 6 |
1964760 | 1964760 | 2021-11-29 | Alleghany | North Carolina | 37005 | 1799 | 6 |
1961508 | 1961508 | 2021-11-28 | Alleghany | North Carolina | 37005 | 1777 | 6 |
1958257 | 1958257 | 2021-11-27 | Alleghany | North Carolina | 37005 | 1777 | 6 |
1955006 | 1955006 | 2021-11-26 | Alleghany | North Carolina | 37005 | 1777 | 6 |
1951755 | 1951755 | 2021-11-25 | Alleghany | North Carolina | 37005 | 1777 | 6 |
1948504 | 1948504 | 2021-11-24 | Alleghany | North Carolina | 37005 | 1777 | 6 |
1945253 | 1945253 | 2021-11-23 | Alleghany | North Carolina | 37005 | 1761 | 6 |
1942002 | 1942002 | 2021-11-22 | Alleghany | North Carolina | 37005 | 1760 | 6 |
1938752 | 1938752 | 2021-11-21 | Alleghany | North Carolina | 37005 | 1719 | 6 |
1935502 | 1935502 | 2021-11-20 | Alleghany | North Carolina | 37005 | 1719 | 6 |
1932252 | 1932252 | 2021-11-19 | Alleghany | North Carolina | 37005 | 1719 | 6 |
1929001 | 1929001 | 2021-11-18 | Alleghany | North Carolina | 37005 | 1713 | 6 |
1925751 | 1925751 | 2021-11-17 | Alleghany | North Carolina | 37005 | 1702 | 6 |
1922502 | 1922502 | 2021-11-16 | Alleghany | North Carolina | 37005 | 1697 | 6 |
1919252 | 1919252 | 2021-11-15 | Alleghany | North Carolina | 37005 | 1681 | 6 |
1916002 | 1916002 | 2021-11-14 | Alleghany | North Carolina | 37005 | 1658 | 6 |
1912752 | 1912752 | 2021-11-13 | Alleghany | North Carolina | 37005 | 1658 | 6 |
1909502 | 1909502 | 2021-11-12 | Alleghany | North Carolina | 37005 | 1658 | 6 |
1906253 | 1906253 | 2021-11-11 | Alleghany | North Carolina | 37005 | 1651 | 6 |
1903004 | 1903004 | 2021-11-10 | Alleghany | North Carolina | 37005 | 1651 | 6 |
1899754 | 1899754 | 2021-11-09 | Alleghany | North Carolina | 37005 | 1646 | 6 |
1896504 | 1896504 | 2021-11-08 | Alleghany | North Carolina | 37005 | 1639 | 6 |
1893254 | 1893254 | 2021-11-07 | Alleghany | North Carolina | 37005 | 1625 | 6 |
1890004 | 1890004 | 2021-11-06 | Alleghany | North Carolina | 37005 | 1625 | 6 |
1886754 | 1886754 | 2021-11-05 | Alleghany | North Carolina | 37005 | 1625 | 6 |
1883505 | 1883505 | 2021-11-04 | Alleghany | North Carolina | 37005 | 1623 | 6 |
1880256 | 1880256 | 2021-11-03 | Alleghany | North Carolina | 37005 | 1623 | 6 |
1877007 | 1877007 | 2021-11-02 | Alleghany | North Carolina | 37005 | 1621 | 6 |
1873758 | 1873758 | 2021-11-01 | Alleghany | North Carolina | 37005 | 1621 | 6 |
1870509 | 1870509 | 2021-10-31 | Alleghany | North Carolina | 37005 | 1614 | 6 |
1867260 | 1867260 | 2021-10-30 | Alleghany | North Carolina | 37005 | 1614 | 6 |
1864011 | 1864011 | 2021-10-29 | Alleghany | North Carolina | 37005 | 1614 | 6 |
1860762 | 1860762 | 2021-10-28 | Alleghany | North Carolina | 37005 | 1614 | 6 |
1857513 | 1857513 | 2021-10-27 | Alleghany | North Carolina | 37005 | 1608 | 6 |
1854264 | 1854264 | 2021-10-26 | Alleghany | North Carolina | 37005 | 1609 | 6 |
1851015 | 1851015 | 2021-10-25 | Alleghany | North Carolina | 37005 | 1609 | 6 |
1847765 | 1847765 | 2021-10-24 | Alleghany | North Carolina | 37005 | 1606 | 6 |
1844515 | 1844515 | 2021-10-23 | Alleghany | North Carolina | 37005 | 1606 | 6 |
1841265 | 1841265 | 2021-10-22 | Alleghany | North Carolina | 37005 | 1606 | 6 |
1838016 | 1838016 | 2021-10-21 | Alleghany | North Carolina | 37005 | 1604 | 6 |
1834767 | 1834767 | 2021-10-20 | Alleghany | North Carolina | 37005 | 1599 | 6 |
1831518 | 1831518 | 2021-10-19 | Alleghany | North Carolina | 37005 | 1599 | 6 |
1828269 | 1828269 | 2021-10-18 | Alleghany | North Carolina | 37005 | 1599 | 6 |
1825020 | 1825020 | 2021-10-17 | Alleghany | North Carolina | 37005 | 1590 | 6 |
1821771 | 1821771 | 2021-10-16 | Alleghany | North Carolina | 37005 | 1590 | 6 |
1818522 | 1818522 | 2021-10-15 | Alleghany | North Carolina | 37005 | 1590 | 6 |
1789366 | 1789366 | 2021-10-06 | Tyrrell | North Carolina | 37177 | 530 | 6 |
1786118 | 1786118 | 2021-10-05 | Tyrrell | North Carolina | 37177 | 525 | 6 |
1782869 | 1782869 | 2021-10-04 | Tyrrell | North Carolina | 37177 | 525 | 6 |
1779620 | 1779620 | 2021-10-03 | Tyrrell | North Carolina | 37177 | 516 | 6 |
1776370 | 1776370 | 2021-10-02 | Tyrrell | North Carolina | 37177 | 516 | 6 |
1773120 | 1773120 | 2021-10-01 | Tyrrell | North Carolina | 37177 | 516 | 6 |
1769870 | 1769870 | 2021-09-30 | Tyrrell | North Carolina | 37177 | 513 | 6 |
1766621 | 1766621 | 2021-09-29 | Tyrrell | North Carolina | 37177 | 510 | 6 |
1763372 | 1763372 | 2021-09-28 | Tyrrell | North Carolina | 37177 | 509 | 6 |
1760123 | 1760123 | 2021-09-27 | Tyrrell | North Carolina | 37177 | 507 | 6 |
1756875 | 1756875 | 2021-09-26 | Tyrrell | North Carolina | 37177 | 503 | 6 |
1753627 | 1753627 | 2021-09-25 | Tyrrell | North Carolina | 37177 | 503 | 6 |
1750379 | 1750379 | 2021-09-24 | Tyrrell | North Carolina | 37177 | 503 | 6 |
1747129 | 1747129 | 2021-09-23 | Tyrrell | North Carolina | 37177 | 501 | 6 |
1743880 | 1743880 | 2021-09-22 | Tyrrell | North Carolina | 37177 | 495 | 6 |
1740631 | 1740631 | 2021-09-21 | Tyrrell | North Carolina | 37177 | 492 | 6 |
1737382 | 1737382 | 2021-09-20 | Tyrrell | North Carolina | 37177 | 491 | 6 |
1734132 | 1734132 | 2021-09-19 | Tyrrell | North Carolina | 37177 | 484 | 6 |
1730882 | 1730882 | 2021-09-18 | Tyrrell | North Carolina | 37177 | 484 | 6 |
1727632 | 1727632 | 2021-09-17 | Tyrrell | North Carolina | 37177 | 484 | 6 |
1724383 | 1724383 | 2021-09-16 | Tyrrell | North Carolina | 37177 | 481 | 6 |
1721134 | 1721134 | 2021-09-15 | Tyrrell | North Carolina | 37177 | 480 | 6 |
1717886 | 1717886 | 2021-09-14 | Tyrrell | North Carolina | 37177 | 476 | 6 |
1714638 | 1714638 | 2021-09-13 | Tyrrell | North Carolina | 37177 | 475 | 6 |
1711392 | 1711392 | 2021-09-12 | Tyrrell | North Carolina | 37177 | 465 | 6 |
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);