ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
862 rows where deaths = 7 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 130
- Jackson 87
- Warren 77
- Rutherford 41
- Yadkin 38
- Macon 28
- Martin 24
- Camden 21
- Richmond 21
- Lenoir 20
- Polk 20
- Graham 18
- Iredell 18
- Madison 18
- Jones 14
- Montgomery 14
- Bertie 13
- Transylvania 13
- Wilkes 13
- Edgecombe 10
- New Hanover 10
- Alexander 9
- Bladen 8
- Forsyth 8
- Gaston 8
- Hoke 8
- Lee 8
- Sampson 8
- Dare 7
- Greene 7
- …
state 1
- North Carolina · 862 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2211973 | 2211973 | 2022-02-13 | Tyrrell | North Carolina | 37177 | 941 | 7 |
2208720 | 2208720 | 2022-02-12 | Tyrrell | North Carolina | 37177 | 941 | 7 |
2205467 | 2205467 | 2022-02-11 | Tyrrell | North Carolina | 37177 | 941 | 7 |
2202214 | 2202214 | 2022-02-10 | Tyrrell | North Carolina | 37177 | 940 | 7 |
2198960 | 2198960 | 2022-02-09 | Tyrrell | North Carolina | 37177 | 934 | 7 |
2195706 | 2195706 | 2022-02-08 | Tyrrell | North Carolina | 37177 | 931 | 7 |
2192452 | 2192452 | 2022-02-07 | Tyrrell | North Carolina | 37177 | 932 | 7 |
2189198 | 2189198 | 2022-02-06 | Tyrrell | North Carolina | 37177 | 921 | 7 |
2185945 | 2185945 | 2022-02-05 | Tyrrell | North Carolina | 37177 | 921 | 7 |
2182693 | 2182693 | 2022-02-04 | Tyrrell | North Carolina | 37177 | 921 | 7 |
2179441 | 2179441 | 2022-02-03 | Tyrrell | North Carolina | 37177 | 916 | 7 |
2176190 | 2176190 | 2022-02-02 | Tyrrell | North Carolina | 37177 | 913 | 7 |
2172937 | 2172937 | 2022-02-01 | Tyrrell | North Carolina | 37177 | 911 | 7 |
2169684 | 2169684 | 2022-01-31 | Tyrrell | North Carolina | 37177 | 909 | 7 |
2166429 | 2166429 | 2022-01-30 | Tyrrell | North Carolina | 37177 | 901 | 7 |
2163174 | 2163174 | 2022-01-29 | Tyrrell | North Carolina | 37177 | 901 | 7 |
2159919 | 2159919 | 2022-01-28 | Tyrrell | North Carolina | 37177 | 901 | 7 |
2156664 | 2156664 | 2022-01-27 | Tyrrell | North Carolina | 37177 | 881 | 7 |
2153411 | 2153411 | 2022-01-26 | Tyrrell | North Carolina | 37177 | 871 | 7 |
2150159 | 2150159 | 2022-01-25 | Tyrrell | North Carolina | 37177 | 865 | 7 |
2146907 | 2146907 | 2022-01-24 | Tyrrell | North Carolina | 37177 | 864 | 7 |
2143653 | 2143653 | 2022-01-23 | Tyrrell | North Carolina | 37177 | 826 | 7 |
2140398 | 2140398 | 2022-01-22 | Tyrrell | North Carolina | 37177 | 826 | 7 |
2137142 | 2137142 | 2022-01-21 | Tyrrell | North Carolina | 37177 | 826 | 7 |
2133889 | 2133889 | 2022-01-20 | Tyrrell | North Carolina | 37177 | 803 | 7 |
2130637 | 2130637 | 2022-01-19 | Tyrrell | North Carolina | 37177 | 788 | 7 |
2127383 | 2127383 | 2022-01-18 | Tyrrell | North Carolina | 37177 | 785 | 7 |
2124131 | 2124131 | 2022-01-17 | Tyrrell | North Carolina | 37177 | 733 | 7 |
2120879 | 2120879 | 2022-01-16 | Tyrrell | North Carolina | 37177 | 733 | 7 |
2117627 | 2117627 | 2022-01-15 | Tyrrell | North Carolina | 37177 | 733 | 7 |
2114376 | 2114376 | 2022-01-14 | Tyrrell | North Carolina | 37177 | 733 | 7 |
2111124 | 2111124 | 2022-01-13 | Tyrrell | North Carolina | 37177 | 710 | 7 |
2107872 | 2107872 | 2022-01-12 | Tyrrell | North Carolina | 37177 | 679 | 7 |
2104621 | 2104621 | 2022-01-11 | Tyrrell | North Carolina | 37177 | 670 | 7 |
2101370 | 2101370 | 2022-01-10 | Tyrrell | North Carolina | 37177 | 668 | 7 |
2098119 | 2098119 | 2022-01-09 | Tyrrell | North Carolina | 37177 | 648 | 7 |
2094867 | 2094867 | 2022-01-08 | Tyrrell | North Carolina | 37177 | 648 | 7 |
2091615 | 2091615 | 2022-01-07 | Tyrrell | North Carolina | 37177 | 648 | 7 |
2088364 | 2088364 | 2022-01-06 | Tyrrell | North Carolina | 37177 | 639 | 7 |
2085112 | 2085112 | 2022-01-05 | Tyrrell | North Carolina | 37177 | 636 | 7 |
2081860 | 2081860 | 2022-01-04 | Tyrrell | North Carolina | 37177 | 630 | 7 |
2078522 | 2078522 | 2022-01-03 | Alleghany | North Carolina | 37005 | 2117 | 7 |
2078608 | 2078608 | 2022-01-03 | Tyrrell | North Carolina | 37177 | 629 | 7 |
2075271 | 2075271 | 2022-01-02 | Alleghany | North Carolina | 37005 | 2090 | 7 |
2075357 | 2075357 | 2022-01-02 | Tyrrell | North Carolina | 37177 | 624 | 7 |
2072020 | 2072020 | 2022-01-01 | Alleghany | North Carolina | 37005 | 2090 | 7 |
2072106 | 2072106 | 2022-01-01 | Tyrrell | North Carolina | 37177 | 624 | 7 |
2068769 | 2068769 | 2021-12-31 | Alleghany | North Carolina | 37005 | 2090 | 7 |
2068855 | 2068855 | 2021-12-31 | Tyrrell | North Carolina | 37177 | 624 | 7 |
2065518 | 2065518 | 2021-12-30 | Alleghany | North Carolina | 37005 | 2077 | 7 |
2065604 | 2065604 | 2021-12-30 | Tyrrell | North Carolina | 37177 | 618 | 7 |
2062268 | 2062268 | 2021-12-29 | Alleghany | North Carolina | 37005 | 2063 | 7 |
2062354 | 2062354 | 2021-12-29 | Tyrrell | North Carolina | 37177 | 616 | 7 |
2059105 | 2059105 | 2021-12-28 | Tyrrell | North Carolina | 37177 | 615 | 7 |
2055856 | 2055856 | 2021-12-27 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2052606 | 2052606 | 2021-12-26 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2049356 | 2049356 | 2021-12-25 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2046106 | 2046106 | 2021-12-24 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2042856 | 2042856 | 2021-12-23 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2039607 | 2039607 | 2021-12-22 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2036357 | 2036357 | 2021-12-21 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2033107 | 2033107 | 2021-12-20 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2029857 | 2029857 | 2021-12-19 | Tyrrell | North Carolina | 37177 | 604 | 7 |
2026606 | 2026606 | 2021-12-18 | Tyrrell | North Carolina | 37177 | 604 | 7 |
2023355 | 2023355 | 2021-12-17 | Tyrrell | North Carolina | 37177 | 604 | 7 |
2020104 | 2020104 | 2021-12-16 | Tyrrell | North Carolina | 37177 | 602 | 7 |
2016853 | 2016853 | 2021-12-15 | Tyrrell | North Carolina | 37177 | 600 | 7 |
2013603 | 2013603 | 2021-12-14 | Tyrrell | North Carolina | 37177 | 600 | 7 |
2010352 | 2010352 | 2021-12-13 | Tyrrell | North Carolina | 37177 | 599 | 7 |
2007101 | 2007101 | 2021-12-12 | Tyrrell | North Carolina | 37177 | 599 | 7 |
2003850 | 2003850 | 2021-12-11 | Tyrrell | North Carolina | 37177 | 599 | 7 |
2000599 | 2000599 | 2021-12-10 | Tyrrell | North Carolina | 37177 | 599 | 7 |
1997349 | 1997349 | 2021-12-09 | Tyrrell | North Carolina | 37177 | 597 | 7 |
1994098 | 1994098 | 2021-12-08 | Tyrrell | North Carolina | 37177 | 593 | 7 |
1990847 | 1990847 | 2021-12-07 | Tyrrell | North Carolina | 37177 | 589 | 7 |
1987596 | 1987596 | 2021-12-06 | Tyrrell | North Carolina | 37177 | 589 | 7 |
1984346 | 1984346 | 2021-12-05 | Tyrrell | North Carolina | 37177 | 589 | 7 |
1981096 | 1981096 | 2021-12-04 | Tyrrell | North Carolina | 37177 | 589 | 7 |
1977846 | 1977846 | 2021-12-03 | Tyrrell | North Carolina | 37177 | 589 | 7 |
1974596 | 1974596 | 2021-12-02 | Tyrrell | North Carolina | 37177 | 580 | 7 |
1971347 | 1971347 | 2021-12-01 | Tyrrell | North Carolina | 37177 | 580 | 7 |
1968097 | 1968097 | 2021-11-30 | Tyrrell | North Carolina | 37177 | 580 | 7 |
1964846 | 1964846 | 2021-11-29 | Tyrrell | North Carolina | 37177 | 585 | 7 |
1961594 | 1961594 | 2021-11-28 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1958343 | 1958343 | 2021-11-27 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1955092 | 1955092 | 2021-11-26 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1951841 | 1951841 | 2021-11-25 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1948590 | 1948590 | 2021-11-24 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1945339 | 1945339 | 2021-11-23 | Tyrrell | North Carolina | 37177 | 571 | 7 |
1942088 | 1942088 | 2021-11-22 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1938838 | 1938838 | 2021-11-21 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1935588 | 1935588 | 2021-11-20 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1932338 | 1932338 | 2021-11-19 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1929087 | 1929087 | 2021-11-18 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1925837 | 1925837 | 2021-11-17 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1922588 | 1922588 | 2021-11-16 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1919338 | 1919338 | 2021-11-15 | Tyrrell | North Carolina | 37177 | 570 | 7 |
1916088 | 1916088 | 2021-11-14 | Tyrrell | North Carolina | 37177 | 565 | 7 |
1912838 | 1912838 | 2021-11-13 | Tyrrell | North Carolina | 37177 | 565 | 7 |
1909588 | 1909588 | 2021-11-12 | Tyrrell | North Carolina | 37177 | 565 | 7 |
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);