ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where deaths = 11 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
- Perquimans 104
- Graham 57
- Lenoir 57
- Polk 38
- Alleghany 36
- Hertford 35
- Pamlico 27
- Currituck 24
- Lee 22
- Hyde 20
- Jones 20
- Pitt 17
- Person 14
- Richmond 14
- Dare 13
- Gaston 13
- Moore 13
- Transylvania 13
- Chatham 10
- Davidson 9
- Caldwell 8
- Bertie 7
- Hoke 7
- Rutherford 7
- Yadkin 7
- Burke 6
- Anson 5
- Caswell 5
- Edgecombe 5
- Halifax 5
- …
state 1
- North Carolina · 717 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2244397 | 2244397 | 2022-02-23 | Alleghany | North Carolina | 37005 | 2888 | 11 |
2241146 | 2241146 | 2022-02-22 | Alleghany | North Carolina | 37005 | 2881 | 11 |
2237895 | 2237895 | 2022-02-21 | Alleghany | North Carolina | 37005 | 2876 | 11 |
2234644 | 2234644 | 2022-02-20 | Alleghany | North Carolina | 37005 | 2859 | 11 |
2231393 | 2231393 | 2022-02-19 | Alleghany | North Carolina | 37005 | 2859 | 11 |
2228142 | 2228142 | 2022-02-18 | Alleghany | North Carolina | 37005 | 2859 | 11 |
2224891 | 2224891 | 2022-02-17 | Alleghany | North Carolina | 37005 | 2851 | 11 |
2221640 | 2221640 | 2022-02-16 | Alleghany | North Carolina | 37005 | 2844 | 11 |
2218389 | 2218389 | 2022-02-15 | Alleghany | North Carolina | 37005 | 2840 | 11 |
2215138 | 2215138 | 2022-02-14 | Alleghany | North Carolina | 37005 | 2837 | 11 |
2211887 | 2211887 | 2022-02-13 | Alleghany | North Carolina | 37005 | 2819 | 11 |
2208634 | 2208634 | 2022-02-12 | Alleghany | North Carolina | 37005 | 2819 | 11 |
2205381 | 2205381 | 2022-02-11 | Alleghany | North Carolina | 37005 | 2819 | 11 |
2202128 | 2202128 | 2022-02-10 | Alleghany | North Carolina | 37005 | 2809 | 11 |
2198874 | 2198874 | 2022-02-09 | Alleghany | North Carolina | 37005 | 2800 | 11 |
2195620 | 2195620 | 2022-02-08 | Alleghany | North Carolina | 37005 | 2783 | 11 |
2192366 | 2192366 | 2022-02-07 | Alleghany | North Carolina | 37005 | 2778 | 11 |
2189112 | 2189112 | 2022-02-06 | Alleghany | North Carolina | 37005 | 2725 | 11 |
2185859 | 2185859 | 2022-02-05 | Alleghany | North Carolina | 37005 | 2725 | 11 |
2182607 | 2182607 | 2022-02-04 | Alleghany | North Carolina | 37005 | 2725 | 11 |
2179355 | 2179355 | 2022-02-03 | Alleghany | North Carolina | 37005 | 2697 | 11 |
2176104 | 2176104 | 2022-02-02 | Alleghany | North Carolina | 37005 | 2673 | 11 |
2172851 | 2172851 | 2022-02-01 | Alleghany | North Carolina | 37005 | 2668 | 11 |
2169598 | 2169598 | 2022-01-31 | Alleghany | North Carolina | 37005 | 2656 | 11 |
2166343 | 2166343 | 2022-01-30 | Alleghany | North Carolina | 37005 | 2599 | 11 |
2163088 | 2163088 | 2022-01-29 | Alleghany | North Carolina | 37005 | 2599 | 11 |
2159833 | 2159833 | 2022-01-28 | Alleghany | North Carolina | 37005 | 2599 | 11 |
2156578 | 2156578 | 2022-01-27 | Alleghany | North Carolina | 37005 | 2565 | 11 |
2153325 | 2153325 | 2022-01-26 | Alleghany | North Carolina | 37005 | 2547 | 11 |
2150073 | 2150073 | 2022-01-25 | Alleghany | North Carolina | 37005 | 2529 | 11 |
2146821 | 2146821 | 2022-01-24 | Alleghany | North Carolina | 37005 | 2513 | 11 |
2143567 | 2143567 | 2022-01-23 | Alleghany | North Carolina | 37005 | 2447 | 11 |
2140312 | 2140312 | 2022-01-22 | Alleghany | North Carolina | 37005 | 2447 | 11 |
2137056 | 2137056 | 2022-01-21 | Alleghany | North Carolina | 37005 | 2447 | 11 |
2133803 | 2133803 | 2022-01-20 | Alleghany | North Carolina | 37005 | 2435 | 11 |
2130551 | 2130551 | 2022-01-19 | Alleghany | North Carolina | 37005 | 2420 | 11 |
1808821 | 1808821 | 2021-10-12 | Hyde | North Carolina | 37095 | 819 | 11 |
1805570 | 1805570 | 2021-10-11 | Hyde | North Carolina | 37095 | 817 | 11 |
1802321 | 1802321 | 2021-10-10 | Hyde | North Carolina | 37095 | 818 | 11 |
1799072 | 1799072 | 2021-10-09 | Hyde | North Carolina | 37095 | 818 | 11 |
1795823 | 1795823 | 2021-10-08 | Hyde | North Carolina | 37095 | 818 | 11 |
1792574 | 1792574 | 2021-10-07 | Hyde | North Carolina | 37095 | 816 | 11 |
1789325 | 1789325 | 2021-10-06 | Hyde | North Carolina | 37095 | 812 | 11 |
1786077 | 1786077 | 2021-10-05 | Hyde | North Carolina | 37095 | 811 | 11 |
1782828 | 1782828 | 2021-10-04 | Hyde | North Carolina | 37095 | 811 | 11 |
1779579 | 1779579 | 2021-10-03 | Hyde | North Carolina | 37095 | 811 | 11 |
1779603 | 1779603 | 2021-10-03 | Perquimans | North Carolina | 37143 | 1436 | 11 |
1776329 | 1776329 | 2021-10-02 | Hyde | North Carolina | 37095 | 811 | 11 |
1776353 | 1776353 | 2021-10-02 | Perquimans | North Carolina | 37143 | 1436 | 11 |
1773079 | 1773079 | 2021-10-01 | Hyde | North Carolina | 37095 | 811 | 11 |
1773103 | 1773103 | 2021-10-01 | Perquimans | North Carolina | 37143 | 1436 | 11 |
1769829 | 1769829 | 2021-09-30 | Hyde | North Carolina | 37095 | 808 | 11 |
1769853 | 1769853 | 2021-09-30 | Perquimans | North Carolina | 37143 | 1431 | 11 |
1766580 | 1766580 | 2021-09-29 | Hyde | North Carolina | 37095 | 807 | 11 |
1766604 | 1766604 | 2021-09-29 | Perquimans | North Carolina | 37143 | 1419 | 11 |
1763331 | 1763331 | 2021-09-28 | Hyde | North Carolina | 37095 | 805 | 11 |
1763355 | 1763355 | 2021-09-28 | Perquimans | North Carolina | 37143 | 1412 | 11 |
1760082 | 1760082 | 2021-09-27 | Hyde | North Carolina | 37095 | 803 | 11 |
1760106 | 1760106 | 2021-09-27 | Perquimans | North Carolina | 37143 | 1410 | 11 |
1756834 | 1756834 | 2021-09-26 | Hyde | North Carolina | 37095 | 790 | 11 |
1756858 | 1756858 | 2021-09-26 | Perquimans | North Carolina | 37143 | 1389 | 11 |
1753586 | 1753586 | 2021-09-25 | Hyde | North Carolina | 37095 | 790 | 11 |
1753610 | 1753610 | 2021-09-25 | Perquimans | North Carolina | 37143 | 1389 | 11 |
1750338 | 1750338 | 2021-09-24 | Hyde | North Carolina | 37095 | 790 | 11 |
1750362 | 1750362 | 2021-09-24 | Perquimans | North Carolina | 37143 | 1389 | 11 |
1747088 | 1747088 | 2021-09-23 | Hyde | North Carolina | 37095 | 788 | 11 |
1747112 | 1747112 | 2021-09-23 | Perquimans | North Carolina | 37143 | 1384 | 11 |
1743819 | 1743819 | 2021-09-22 | Dare | North Carolina | 37055 | 3465 | 11 |
1743863 | 1743863 | 2021-09-22 | Perquimans | North Carolina | 37143 | 1375 | 11 |
1740570 | 1740570 | 2021-09-21 | Dare | North Carolina | 37055 | 3445 | 11 |
1740614 | 1740614 | 2021-09-21 | Perquimans | North Carolina | 37143 | 1368 | 11 |
1737321 | 1737321 | 2021-09-20 | Dare | North Carolina | 37055 | 3433 | 11 |
1737365 | 1737365 | 2021-09-20 | Perquimans | North Carolina | 37143 | 1366 | 11 |
1734071 | 1734071 | 2021-09-19 | Dare | North Carolina | 37055 | 3394 | 11 |
1734115 | 1734115 | 2021-09-19 | Perquimans | North Carolina | 37143 | 1350 | 11 |
1730821 | 1730821 | 2021-09-18 | Dare | North Carolina | 37055 | 3394 | 11 |
1730865 | 1730865 | 2021-09-18 | Perquimans | North Carolina | 37143 | 1350 | 11 |
1727571 | 1727571 | 2021-09-17 | Dare | North Carolina | 37055 | 3394 | 11 |
1727615 | 1727615 | 2021-09-17 | Perquimans | North Carolina | 37143 | 1350 | 11 |
1724322 | 1724322 | 2021-09-16 | Dare | North Carolina | 37055 | 3376 | 11 |
1724366 | 1724366 | 2021-09-16 | Perquimans | North Carolina | 37143 | 1338 | 11 |
1721073 | 1721073 | 2021-09-15 | Dare | North Carolina | 37055 | 3367 | 11 |
1721117 | 1721117 | 2021-09-15 | Perquimans | North Carolina | 37143 | 1333 | 11 |
1717825 | 1717825 | 2021-09-14 | Dare | North Carolina | 37055 | 3350 | 11 |
1717869 | 1717869 | 2021-09-14 | Perquimans | North Carolina | 37143 | 1326 | 11 |
1714577 | 1714577 | 2021-09-13 | Dare | North Carolina | 37055 | 3336 | 11 |
1714621 | 1714621 | 2021-09-13 | Perquimans | North Carolina | 37143 | 1321 | 11 |
1711331 | 1711331 | 2021-09-12 | Dare | North Carolina | 37055 | 3209 | 11 |
1711375 | 1711375 | 2021-09-12 | Perquimans | North Carolina | 37143 | 1281 | 11 |
1708084 | 1708084 | 2021-09-11 | Dare | North Carolina | 37055 | 3209 | 11 |
1708128 | 1708128 | 2021-09-11 | Perquimans | North Carolina | 37143 | 1281 | 11 |
1704837 | 1704837 | 2021-09-10 | Dare | North Carolina | 37055 | 3209 | 11 |
1704881 | 1704881 | 2021-09-10 | Perquimans | North Carolina | 37143 | 1281 | 11 |
1701631 | 1701631 | 2021-09-09 | Perquimans | North Carolina | 37143 | 1276 | 11 |
1698382 | 1698382 | 2021-09-08 | Perquimans | North Carolina | 37143 | 1271 | 11 |
1695134 | 1695134 | 2021-09-07 | Perquimans | North Carolina | 37143 | 1265 | 11 |
1691886 | 1691886 | 2021-09-06 | Perquimans | North Carolina | 37143 | 1218 | 11 |
1688636 | 1688636 | 2021-09-05 | Perquimans | North Carolina | 37143 | 1218 | 11 |
1685386 | 1685386 | 2021-09-04 | Perquimans | North Carolina | 37143 | 1218 | 11 |
1682135 | 1682135 | 2021-09-03 | Perquimans | North Carolina | 37143 | 1218 | 11 |
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);