ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
664 rows where deaths = 28 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
- Yancey 150
- Graham 92
- Jones 61
- Swain 40
- Sampson 28
- Northampton 21
- Yadkin 19
- Transylvania 15
- Macon 14
- Mitchell 14
- Greene 13
- Wilson 12
- Davie 11
- Franklin 10
- Pamlico 10
- Polk 10
- Hoke 9
- Warren 9
- Washington 8
- Ashe 7
- Bladen 7
- Caldwell 7
- Harnett 7
- Avery 6
- Catawba 6
- Wayne 6
- Duplin 5
- Wilkes 5
- Brunswick 4
- Caswell 4
- …
state 1
- North Carolina · 664 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501554 | 2501554 | 2022-05-13 | Pamlico | North Carolina | 37137 | 2630 | 28 |
2498296 | 2498296 | 2022-05-12 | Pamlico | North Carolina | 37137 | 2630 | 28 |
2495038 | 2495038 | 2022-05-11 | Pamlico | North Carolina | 37137 | 2630 | 28 |
2491780 | 2491780 | 2022-05-10 | Pamlico | North Carolina | 37137 | 2616 | 28 |
2488522 | 2488522 | 2022-05-09 | Pamlico | North Carolina | 37137 | 2616 | 28 |
2485265 | 2485265 | 2022-05-08 | Pamlico | North Carolina | 37137 | 2616 | 28 |
2482007 | 2482007 | 2022-05-07 | Pamlico | North Carolina | 37137 | 2616 | 28 |
2478749 | 2478749 | 2022-05-06 | Pamlico | North Carolina | 37137 | 2616 | 28 |
2475491 | 2475491 | 2022-05-05 | Pamlico | North Carolina | 37137 | 2616 | 28 |
2472234 | 2472234 | 2022-05-04 | Pamlico | North Carolina | 37137 | 2616 | 28 |
2179413 | 2179413 | 2022-02-03 | Mitchell | North Carolina | 37121 | 3033 | 28 |
2176162 | 2176162 | 2022-02-02 | Mitchell | North Carolina | 37121 | 2992 | 28 |
2172909 | 2172909 | 2022-02-01 | Mitchell | North Carolina | 37121 | 2985 | 28 |
2169656 | 2169656 | 2022-01-31 | Mitchell | North Carolina | 37121 | 2984 | 28 |
2166401 | 2166401 | 2022-01-30 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2163146 | 2163146 | 2022-01-29 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2159891 | 2159891 | 2022-01-28 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2156636 | 2156636 | 2022-01-27 | Mitchell | North Carolina | 37121 | 2940 | 28 |
2153383 | 2153383 | 2022-01-26 | Mitchell | North Carolina | 37121 | 2924 | 28 |
2150131 | 2150131 | 2022-01-25 | Mitchell | North Carolina | 37121 | 2908 | 28 |
2146879 | 2146879 | 2022-01-24 | Mitchell | North Carolina | 37121 | 2903 | 28 |
2143625 | 2143625 | 2022-01-23 | Mitchell | North Carolina | 37121 | 2846 | 28 |
2140370 | 2140370 | 2022-01-22 | Mitchell | North Carolina | 37121 | 2846 | 28 |
2137114 | 2137114 | 2022-01-21 | Mitchell | North Carolina | 37121 | 2846 | 28 |
2124080 | 2124080 | 2022-01-17 | Graham | North Carolina | 37075 | 1667 | 28 |
2120828 | 2120828 | 2022-01-16 | Graham | North Carolina | 37075 | 1667 | 28 |
2117576 | 2117576 | 2022-01-15 | Graham | North Carolina | 37075 | 1667 | 28 |
2114325 | 2114325 | 2022-01-14 | Graham | North Carolina | 37075 | 1667 | 28 |
2111073 | 2111073 | 2022-01-13 | Graham | North Carolina | 37075 | 1651 | 28 |
2107821 | 2107821 | 2022-01-12 | Graham | North Carolina | 37075 | 1622 | 28 |
2104570 | 2104570 | 2022-01-11 | Graham | North Carolina | 37075 | 1597 | 28 |
2101319 | 2101319 | 2022-01-10 | Graham | North Carolina | 37075 | 1568 | 28 |
2098068 | 2098068 | 2022-01-09 | Graham | North Carolina | 37075 | 1541 | 28 |
2094816 | 2094816 | 2022-01-08 | Graham | North Carolina | 37075 | 1541 | 28 |
2091564 | 2091564 | 2022-01-07 | Graham | North Carolina | 37075 | 1541 | 28 |
2088313 | 2088313 | 2022-01-06 | Graham | North Carolina | 37075 | 1538 | 28 |
2085061 | 2085061 | 2022-01-05 | Graham | North Carolina | 37075 | 1515 | 28 |
2081809 | 2081809 | 2022-01-04 | Graham | North Carolina | 37075 | 1501 | 28 |
2078557 | 2078557 | 2022-01-03 | Graham | North Carolina | 37075 | 1485 | 28 |
2075306 | 2075306 | 2022-01-02 | Graham | North Carolina | 37075 | 1474 | 28 |
2072055 | 2072055 | 2022-01-01 | Graham | North Carolina | 37075 | 1474 | 28 |
2068804 | 2068804 | 2021-12-31 | Graham | North Carolina | 37075 | 1474 | 28 |
2065553 | 2065553 | 2021-12-30 | Graham | North Carolina | 37075 | 1463 | 28 |
2062303 | 2062303 | 2021-12-29 | Graham | North Carolina | 37075 | 1449 | 28 |
2059054 | 2059054 | 2021-12-28 | Graham | North Carolina | 37075 | 1445 | 28 |
2055805 | 2055805 | 2021-12-27 | Graham | North Carolina | 37075 | 1436 | 28 |
2055854 | 2055854 | 2021-12-27 | Swain | North Carolina | 37173 | 2240 | 28 |
2052555 | 2052555 | 2021-12-26 | Graham | North Carolina | 37075 | 1436 | 28 |
2052604 | 2052604 | 2021-12-26 | Swain | North Carolina | 37173 | 2240 | 28 |
2049305 | 2049305 | 2021-12-25 | Graham | North Carolina | 37075 | 1436 | 28 |
2049354 | 2049354 | 2021-12-25 | Swain | North Carolina | 37173 | 2240 | 28 |
2046055 | 2046055 | 2021-12-24 | Graham | North Carolina | 37075 | 1436 | 28 |
2046104 | 2046104 | 2021-12-24 | Swain | North Carolina | 37173 | 2240 | 28 |
2042805 | 2042805 | 2021-12-23 | Graham | North Carolina | 37075 | 1436 | 28 |
2042854 | 2042854 | 2021-12-23 | Swain | North Carolina | 37173 | 2240 | 28 |
2039556 | 2039556 | 2021-12-22 | Graham | North Carolina | 37075 | 1436 | 28 |
2039605 | 2039605 | 2021-12-22 | Swain | North Carolina | 37173 | 2240 | 28 |
2036306 | 2036306 | 2021-12-21 | Graham | North Carolina | 37075 | 1427 | 28 |
2036355 | 2036355 | 2021-12-21 | Swain | North Carolina | 37173 | 2236 | 28 |
2033056 | 2033056 | 2021-12-20 | Graham | North Carolina | 37075 | 1422 | 28 |
2033105 | 2033105 | 2021-12-20 | Swain | North Carolina | 37173 | 2234 | 28 |
2029806 | 2029806 | 2021-12-19 | Graham | North Carolina | 37075 | 1415 | 28 |
2029855 | 2029855 | 2021-12-19 | Swain | North Carolina | 37173 | 2222 | 28 |
2026555 | 2026555 | 2021-12-18 | Graham | North Carolina | 37075 | 1415 | 28 |
2026604 | 2026604 | 2021-12-18 | Swain | North Carolina | 37173 | 2222 | 28 |
2023304 | 2023304 | 2021-12-17 | Graham | North Carolina | 37075 | 1415 | 28 |
2023353 | 2023353 | 2021-12-17 | Swain | North Carolina | 37173 | 2222 | 28 |
2020053 | 2020053 | 2021-12-16 | Graham | North Carolina | 37075 | 1407 | 28 |
2020102 | 2020102 | 2021-12-16 | Swain | North Carolina | 37173 | 2215 | 28 |
2016802 | 2016802 | 2021-12-15 | Graham | North Carolina | 37075 | 1404 | 28 |
2016851 | 2016851 | 2021-12-15 | Swain | North Carolina | 37173 | 2205 | 28 |
2013552 | 2013552 | 2021-12-14 | Graham | North Carolina | 37075 | 1403 | 28 |
2013601 | 2013601 | 2021-12-14 | Swain | North Carolina | 37173 | 2196 | 28 |
2010301 | 2010301 | 2021-12-13 | Graham | North Carolina | 37075 | 1399 | 28 |
2010350 | 2010350 | 2021-12-13 | Swain | North Carolina | 37173 | 2189 | 28 |
2007050 | 2007050 | 2021-12-12 | Graham | North Carolina | 37075 | 1395 | 28 |
2007099 | 2007099 | 2021-12-12 | Swain | North Carolina | 37173 | 2179 | 28 |
2003799 | 2003799 | 2021-12-11 | Graham | North Carolina | 37075 | 1395 | 28 |
2003848 | 2003848 | 2021-12-11 | Swain | North Carolina | 37173 | 2179 | 28 |
2000548 | 2000548 | 2021-12-10 | Graham | North Carolina | 37075 | 1395 | 28 |
2000597 | 2000597 | 2021-12-10 | Swain | North Carolina | 37173 | 2179 | 28 |
1997298 | 1997298 | 2021-12-09 | Graham | North Carolina | 37075 | 1391 | 28 |
1997347 | 1997347 | 2021-12-09 | Swain | North Carolina | 37173 | 2174 | 28 |
1994047 | 1994047 | 2021-12-08 | Graham | North Carolina | 37075 | 1388 | 28 |
1994096 | 1994096 | 2021-12-08 | Swain | North Carolina | 37173 | 2167 | 28 |
1990796 | 1990796 | 2021-12-07 | Graham | North Carolina | 37075 | 1385 | 28 |
1990845 | 1990845 | 2021-12-07 | Swain | North Carolina | 37173 | 2157 | 28 |
1987545 | 1987545 | 2021-12-06 | Graham | North Carolina | 37075 | 1379 | 28 |
1987594 | 1987594 | 2021-12-06 | Swain | North Carolina | 37173 | 2139 | 28 |
1984295 | 1984295 | 2021-12-05 | Graham | North Carolina | 37075 | 1373 | 28 |
1984344 | 1984344 | 2021-12-05 | Swain | North Carolina | 37173 | 2114 | 28 |
1981045 | 1981045 | 2021-12-04 | Graham | North Carolina | 37075 | 1373 | 28 |
1981094 | 1981094 | 2021-12-04 | Swain | North Carolina | 37173 | 2114 | 28 |
1977795 | 1977795 | 2021-12-03 | Graham | North Carolina | 37075 | 1373 | 28 |
1977844 | 1977844 | 2021-12-03 | Swain | North Carolina | 37173 | 2114 | 28 |
1974545 | 1974545 | 2021-12-02 | Graham | North Carolina | 37075 | 1368 | 28 |
1974594 | 1974594 | 2021-12-02 | Swain | North Carolina | 37173 | 2098 | 28 |
1971296 | 1971296 | 2021-12-01 | Graham | North Carolina | 37075 | 1365 | 28 |
1971345 | 1971345 | 2021-12-01 | Swain | North Carolina | 37173 | 2089 | 28 |
1968046 | 1968046 | 2021-11-30 | Graham | North Carolina | 37075 | 1360 | 28 |
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);