ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
697 rows where deaths = 20 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
- Warren 154
- Avery 115
- Lincoln 46
- Cherokee 44
- Chowan 36
- Moore 25
- Franklin 24
- Wayne 23
- Duplin 17
- Martin 15
- Burke 13
- Gates 10
- Jackson 10
- Pasquotank 10
- New Hanover 8
- Wilkes 8
- Bladen 7
- Johnston 7
- Lee 7
- Richmond 7
- Rutherford 7
- Clay 6
- Madison 6
- Sampson 6
- Surry 6
- Bertie 5
- Graham 5
- Pamlico 5
- Watauga 5
- Currituck 4
- …
state 1
- North Carolina · 697 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501522 | 2501522 | 2022-05-13 | Gates | North Carolina | 37073 | 1926 | 20 |
2498264 | 2498264 | 2022-05-12 | Gates | North Carolina | 37073 | 1926 | 20 |
2495006 | 2495006 | 2022-05-11 | Gates | North Carolina | 37073 | 1926 | 20 |
2491748 | 2491748 | 2022-05-10 | Gates | North Carolina | 37073 | 1913 | 20 |
2488490 | 2488490 | 2022-05-09 | Gates | North Carolina | 37073 | 1913 | 20 |
2485233 | 2485233 | 2022-05-08 | Gates | North Carolina | 37073 | 1913 | 20 |
2481975 | 2481975 | 2022-05-07 | Gates | North Carolina | 37073 | 1913 | 20 |
2478717 | 2478717 | 2022-05-06 | Gates | North Carolina | 37073 | 1913 | 20 |
2475459 | 2475459 | 2022-05-05 | Gates | North Carolina | 37073 | 1913 | 20 |
2472202 | 2472202 | 2022-05-04 | Gates | North Carolina | 37073 | 1913 | 20 |
1786098 | 1786098 | 2021-10-05 | Pamlico | North Carolina | 37137 | 1629 | 20 |
1782849 | 1782849 | 2021-10-04 | Pamlico | North Carolina | 37137 | 1630 | 20 |
1779600 | 1779600 | 2021-10-03 | Pamlico | North Carolina | 37137 | 1607 | 20 |
1776350 | 1776350 | 2021-10-02 | Pamlico | North Carolina | 37137 | 1607 | 20 |
1773100 | 1773100 | 2021-10-01 | Pamlico | North Carolina | 37137 | 1607 | 20 |
1734081 | 1734081 | 2021-09-19 | Graham | North Carolina | 37075 | 1183 | 20 |
1734136 | 1734136 | 2021-09-19 | Warren | North Carolina | 37185 | 2121 | 20 |
1730831 | 1730831 | 2021-09-18 | Graham | North Carolina | 37075 | 1183 | 20 |
1730886 | 1730886 | 2021-09-18 | Warren | North Carolina | 37185 | 2121 | 20 |
1727581 | 1727581 | 2021-09-17 | Graham | North Carolina | 37075 | 1183 | 20 |
1727636 | 1727636 | 2021-09-17 | Warren | North Carolina | 37185 | 2121 | 20 |
1724321 | 1724321 | 2021-09-16 | Currituck | North Carolina | 37053 | 2281 | 20 |
1724332 | 1724332 | 2021-09-16 | Graham | North Carolina | 37075 | 1172 | 20 |
1724387 | 1724387 | 2021-09-16 | Warren | North Carolina | 37185 | 2109 | 20 |
1721072 | 1721072 | 2021-09-15 | Currituck | North Carolina | 37053 | 2259 | 20 |
1721083 | 1721083 | 2021-09-15 | Graham | North Carolina | 37075 | 1160 | 20 |
1721138 | 1721138 | 2021-09-15 | Warren | North Carolina | 37185 | 2096 | 20 |
1717824 | 1717824 | 2021-09-14 | Currituck | North Carolina | 37053 | 2237 | 20 |
1717890 | 1717890 | 2021-09-14 | Warren | North Carolina | 37185 | 2085 | 20 |
1714576 | 1714576 | 2021-09-13 | Currituck | North Carolina | 37053 | 2231 | 20 |
1714642 | 1714642 | 2021-09-13 | Warren | North Carolina | 37185 | 2082 | 20 |
1711396 | 1711396 | 2021-09-12 | Warren | North Carolina | 37185 | 2042 | 20 |
1708149 | 1708149 | 2021-09-11 | Warren | North Carolina | 37185 | 2042 | 20 |
1704902 | 1704902 | 2021-09-10 | Warren | North Carolina | 37185 | 2042 | 20 |
1701652 | 1701652 | 2021-09-09 | Warren | North Carolina | 37185 | 2037 | 20 |
1698403 | 1698403 | 2021-09-08 | Warren | North Carolina | 37185 | 2029 | 20 |
1695155 | 1695155 | 2021-09-07 | Warren | North Carolina | 37185 | 2029 | 20 |
1691907 | 1691907 | 2021-09-06 | Warren | North Carolina | 37185 | 2004 | 20 |
1688657 | 1688657 | 2021-09-05 | Warren | North Carolina | 37185 | 2004 | 20 |
1685407 | 1685407 | 2021-09-04 | Warren | North Carolina | 37185 | 2004 | 20 |
1682156 | 1682156 | 2021-09-03 | Warren | North Carolina | 37185 | 2004 | 20 |
1678907 | 1678907 | 2021-09-02 | Warren | North Carolina | 37185 | 1997 | 20 |
1675659 | 1675659 | 2021-09-01 | Warren | North Carolina | 37185 | 1987 | 20 |
1672341 | 1672341 | 2021-08-31 | Clay | North Carolina | 37043 | 1179 | 20 |
1672412 | 1672412 | 2021-08-31 | Warren | North Carolina | 37185 | 1975 | 20 |
1669093 | 1669093 | 2021-08-30 | Clay | North Carolina | 37043 | 1168 | 20 |
1669164 | 1669164 | 2021-08-30 | Warren | North Carolina | 37185 | 1969 | 20 |
1665846 | 1665846 | 2021-08-29 | Clay | North Carolina | 37043 | 1138 | 20 |
1665911 | 1665911 | 2021-08-29 | Swain | North Carolina | 37173 | 1463 | 20 |
1665917 | 1665917 | 2021-08-29 | Warren | North Carolina | 37185 | 1946 | 20 |
1662598 | 1662598 | 2021-08-28 | Clay | North Carolina | 37043 | 1138 | 20 |
1662663 | 1662663 | 2021-08-28 | Swain | North Carolina | 37173 | 1463 | 20 |
1662669 | 1662669 | 2021-08-28 | Warren | North Carolina | 37185 | 1946 | 20 |
1659350 | 1659350 | 2021-08-27 | Clay | North Carolina | 37043 | 1138 | 20 |
1659415 | 1659415 | 2021-08-27 | Swain | North Carolina | 37173 | 1463 | 20 |
1659421 | 1659421 | 2021-08-27 | Warren | North Carolina | 37185 | 1946 | 20 |
1656101 | 1656101 | 2021-08-26 | Clay | North Carolina | 37043 | 1125 | 20 |
1656172 | 1656172 | 2021-08-26 | Warren | North Carolina | 37185 | 1940 | 20 |
1652925 | 1652925 | 2021-08-25 | Warren | North Carolina | 37185 | 1934 | 20 |
1649677 | 1649677 | 2021-08-24 | Warren | North Carolina | 37185 | 1928 | 20 |
1646428 | 1646428 | 2021-08-23 | Warren | North Carolina | 37185 | 1915 | 20 |
1643179 | 1643179 | 2021-08-22 | Warren | North Carolina | 37185 | 1901 | 20 |
1639929 | 1639929 | 2021-08-21 | Warren | North Carolina | 37185 | 1901 | 20 |
1636679 | 1636679 | 2021-08-20 | Warren | North Carolina | 37185 | 1901 | 20 |
1633429 | 1633429 | 2021-08-19 | Warren | North Carolina | 37185 | 1897 | 20 |
1630182 | 1630182 | 2021-08-18 | Warren | North Carolina | 37185 | 1892 | 20 |
1626935 | 1626935 | 2021-08-17 | Warren | North Carolina | 37185 | 1885 | 20 |
1623688 | 1623688 | 2021-08-16 | Warren | North Carolina | 37185 | 1885 | 20 |
1620441 | 1620441 | 2021-08-15 | Warren | North Carolina | 37185 | 1874 | 20 |
1617193 | 1617193 | 2021-08-14 | Warren | North Carolina | 37185 | 1874 | 20 |
1613945 | 1613945 | 2021-08-13 | Warren | North Carolina | 37185 | 1874 | 20 |
1610696 | 1610696 | 2021-08-12 | Warren | North Carolina | 37185 | 1869 | 20 |
1607448 | 1607448 | 2021-08-11 | Warren | North Carolina | 37185 | 1866 | 20 |
1604199 | 1604199 | 2021-08-10 | Warren | North Carolina | 37185 | 1859 | 20 |
1600950 | 1600950 | 2021-08-09 | Warren | North Carolina | 37185 | 1858 | 20 |
1597702 | 1597702 | 2021-08-08 | Warren | North Carolina | 37185 | 1851 | 20 |
1594453 | 1594453 | 2021-08-07 | Warren | North Carolina | 37185 | 1851 | 20 |
1591204 | 1591204 | 2021-08-06 | Warren | North Carolina | 37185 | 1851 | 20 |
1587955 | 1587955 | 2021-08-05 | Warren | North Carolina | 37185 | 1846 | 20 |
1584705 | 1584705 | 2021-08-04 | Warren | North Carolina | 37185 | 1841 | 20 |
1581455 | 1581455 | 2021-08-03 | Warren | North Carolina | 37185 | 1838 | 20 |
1578206 | 1578206 | 2021-08-02 | Warren | North Carolina | 37185 | 1838 | 20 |
1574958 | 1574958 | 2021-08-01 | Warren | North Carolina | 37185 | 1836 | 20 |
1571710 | 1571710 | 2021-07-31 | Warren | North Carolina | 37185 | 1836 | 20 |
1568462 | 1568462 | 2021-07-30 | Warren | North Carolina | 37185 | 1836 | 20 |
1565214 | 1565214 | 2021-07-29 | Warren | North Carolina | 37185 | 1837 | 20 |
1561966 | 1561966 | 2021-07-28 | Warren | North Carolina | 37185 | 1834 | 20 |
1558718 | 1558718 | 2021-07-27 | Warren | North Carolina | 37185 | 1829 | 20 |
1555471 | 1555471 | 2021-07-26 | Warren | North Carolina | 37185 | 1829 | 20 |
1552224 | 1552224 | 2021-07-25 | Warren | North Carolina | 37185 | 1824 | 20 |
1548977 | 1548977 | 2021-07-24 | Warren | North Carolina | 37185 | 1824 | 20 |
1545730 | 1545730 | 2021-07-23 | Warren | North Carolina | 37185 | 1824 | 20 |
1542483 | 1542483 | 2021-07-22 | Warren | North Carolina | 37185 | 1823 | 20 |
1539235 | 1539235 | 2021-07-21 | Warren | North Carolina | 37185 | 1822 | 20 |
1535988 | 1535988 | 2021-07-20 | Warren | North Carolina | 37185 | 1821 | 20 |
1532740 | 1532740 | 2021-07-19 | Warren | North Carolina | 37185 | 1820 | 20 |
1529493 | 1529493 | 2021-07-18 | Warren | North Carolina | 37185 | 1820 | 20 |
1526246 | 1526246 | 2021-07-17 | Warren | North Carolina | 37185 | 1820 | 20 |
1522999 | 1522999 | 2021-07-16 | Warren | North Carolina | 37185 | 1820 | 20 |
1519751 | 1519751 | 2021-07-15 | Warren | North Carolina | 37185 | 1819 | 20 |
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);