ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
303 rows where deaths = 85 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
- Alexander 51
- Carteret 42
- Lincoln 37
- Vance 36
- Chatham 17
- Martin 14
- Anson 11
- Pasquotank 10
- Scotland 10
- Rutherford 8
- Granville 7
- Macon 7
- Sampson 6
- Jackson 5
- Person 5
- Catawba 4
- Davidson 3
- Hoke 3
- Robeson 3
- Wilson 3
- Buncombe 2
- Columbus 2
- Gaston 2
- Halifax 2
- Lee 2
- Orange 2
- Burke 1
- Cleveland 1
- Davie 1
- Mecklenburg 1
- …
state 1
- North Carolina · 303 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2400551 | 2400551 | 2022-04-12 | Carteret | North Carolina | 37031 | 14079 | 85 |
| 2397296 | 2397296 | 2022-04-11 | Carteret | North Carolina | 37031 | 14079 | 85 |
| 2394041 | 2394041 | 2022-04-10 | Carteret | North Carolina | 37031 | 14079 | 85 |
| 2390785 | 2390785 | 2022-04-09 | Carteret | North Carolina | 37031 | 14079 | 85 |
| 2387529 | 2387529 | 2022-04-08 | Carteret | North Carolina | 37031 | 14079 | 85 |
| 2384274 | 2384274 | 2022-04-07 | Carteret | North Carolina | 37031 | 14079 | 85 |
| 2381019 | 2381019 | 2022-04-06 | Carteret | North Carolina | 37031 | 14079 | 85 |
| 2377764 | 2377764 | 2022-04-05 | Carteret | North Carolina | 37031 | 14077 | 85 |
| 2374511 | 2374511 | 2022-04-04 | Carteret | North Carolina | 37031 | 14077 | 85 |
| 2371259 | 2371259 | 2022-04-03 | Carteret | North Carolina | 37031 | 14073 | 85 |
| 2368006 | 2368006 | 2022-04-02 | Carteret | North Carolina | 37031 | 14073 | 85 |
| 2364753 | 2364753 | 2022-04-01 | Carteret | North Carolina | 37031 | 14073 | 85 |
| 2361499 | 2361499 | 2022-03-31 | Carteret | North Carolina | 37031 | 14071 | 85 |
| 2358245 | 2358245 | 2022-03-30 | Carteret | North Carolina | 37031 | 14071 | 85 |
| 2354991 | 2354991 | 2022-03-29 | Carteret | North Carolina | 37031 | 14069 | 85 |
| 2351738 | 2351738 | 2022-03-28 | Carteret | North Carolina | 37031 | 14067 | 85 |
| 2348486 | 2348486 | 2022-03-27 | Carteret | North Carolina | 37031 | 14063 | 85 |
| 2345233 | 2345233 | 2022-03-26 | Carteret | North Carolina | 37031 | 14063 | 85 |
| 2341980 | 2341980 | 2022-03-25 | Carteret | North Carolina | 37031 | 14063 | 85 |
| 2338727 | 2338727 | 2022-03-24 | Carteret | North Carolina | 37031 | 14060 | 85 |
| 2335473 | 2335473 | 2022-03-23 | Carteret | North Carolina | 37031 | 14055 | 85 |
| 2332219 | 2332219 | 2022-03-22 | Carteret | North Carolina | 37031 | 14050 | 85 |
| 2328966 | 2328966 | 2022-03-21 | Carteret | North Carolina | 37031 | 14046 | 85 |
| 2325714 | 2325714 | 2022-03-20 | Carteret | North Carolina | 37031 | 14036 | 85 |
| 2322461 | 2322461 | 2022-03-19 | Carteret | North Carolina | 37031 | 14036 | 85 |
| 2319207 | 2319207 | 2022-03-18 | Carteret | North Carolina | 37031 | 14036 | 85 |
| 2315953 | 2315953 | 2022-03-17 | Carteret | North Carolina | 37031 | 14027 | 85 |
| 2312700 | 2312700 | 2022-03-16 | Carteret | North Carolina | 37031 | 14019 | 85 |
| 2309447 | 2309447 | 2022-03-15 | Carteret | North Carolina | 37031 | 14020 | 85 |
| 2306194 | 2306194 | 2022-03-14 | Carteret | North Carolina | 37031 | 14015 | 85 |
| 2302943 | 2302943 | 2022-03-13 | Carteret | North Carolina | 37031 | 13995 | 85 |
| 2299691 | 2299691 | 2022-03-12 | Carteret | North Carolina | 37031 | 13995 | 85 |
| 2296439 | 2296439 | 2022-03-11 | Carteret | North Carolina | 37031 | 13995 | 85 |
| 2293187 | 2293187 | 2022-03-10 | Carteret | North Carolina | 37031 | 13986 | 85 |
| 2289935 | 2289935 | 2022-03-09 | Carteret | North Carolina | 37031 | 13979 | 85 |
| 2286683 | 2286683 | 2022-03-08 | Carteret | North Carolina | 37031 | 13977 | 85 |
| 2283431 | 2283431 | 2022-03-07 | Carteret | North Carolina | 37031 | 13968 | 85 |
| 2283465 | 2283465 | 2022-03-07 | Jackson | North Carolina | 37099 | 9216 | 85 |
| 2280179 | 2280179 | 2022-03-06 | Carteret | North Carolina | 37031 | 13943 | 85 |
| 2280213 | 2280213 | 2022-03-06 | Jackson | North Carolina | 37099 | 9198 | 85 |
| 2276926 | 2276926 | 2022-03-05 | Carteret | North Carolina | 37031 | 13943 | 85 |
| 2276960 | 2276960 | 2022-03-05 | Jackson | North Carolina | 37099 | 9198 | 85 |
| 2273673 | 2273673 | 2022-03-04 | Carteret | North Carolina | 37031 | 13943 | 85 |
| 2273707 | 2273707 | 2022-03-04 | Jackson | North Carolina | 37099 | 9198 | 85 |
| 2270420 | 2270420 | 2022-03-03 | Carteret | North Carolina | 37031 | 13933 | 85 |
| 2270454 | 2270454 | 2022-03-03 | Jackson | North Carolina | 37099 | 9190 | 85 |
| 2267168 | 2267168 | 2022-03-02 | Carteret | North Carolina | 37031 | 13920 | 85 |
| 2260707 | 2260707 | 2022-02-28 | Martin | North Carolina | 37117 | 6011 | 85 |
| 2257456 | 2257456 | 2022-02-27 | Martin | North Carolina | 37117 | 6001 | 85 |
| 2254205 | 2254205 | 2022-02-26 | Martin | North Carolina | 37117 | 6001 | 85 |
| 2250954 | 2250954 | 2022-02-25 | Martin | North Carolina | 37117 | 6001 | 85 |
| 2247703 | 2247703 | 2022-02-24 | Martin | North Carolina | 37117 | 5999 | 85 |
| 2244452 | 2244452 | 2022-02-23 | Martin | North Carolina | 37117 | 5990 | 85 |
| 2241201 | 2241201 | 2022-02-22 | Martin | North Carolina | 37117 | 5984 | 85 |
| 2237950 | 2237950 | 2022-02-21 | Martin | North Carolina | 37117 | 5978 | 85 |
| 2234699 | 2234699 | 2022-02-20 | Martin | North Carolina | 37117 | 5974 | 85 |
| 2231448 | 2231448 | 2022-02-19 | Martin | North Carolina | 37117 | 5974 | 85 |
| 2228197 | 2228197 | 2022-02-18 | Martin | North Carolina | 37117 | 5974 | 85 |
| 2224946 | 2224946 | 2022-02-17 | Martin | North Carolina | 37117 | 5967 | 85 |
| 2221667 | 2221667 | 2022-02-16 | Davie | North Carolina | 37059 | 10810 | 85 |
| 2221695 | 2221695 | 2022-02-16 | Martin | North Carolina | 37117 | 5963 | 85 |
| 2218444 | 2218444 | 2022-02-15 | Martin | North Carolina | 37117 | 5956 | 85 |
| 2065519 | 2065519 | 2021-12-30 | Anson | North Carolina | 37007 | 4249 | 85 |
| 2062269 | 2062269 | 2021-12-29 | Anson | North Carolina | 37007 | 4217 | 85 |
| 2059020 | 2059020 | 2021-12-28 | Anson | North Carolina | 37007 | 4204 | 85 |
| 2055771 | 2055771 | 2021-12-27 | Anson | North Carolina | 37007 | 4144 | 85 |
| 2052521 | 2052521 | 2021-12-26 | Anson | North Carolina | 37007 | 4144 | 85 |
| 2049271 | 2049271 | 2021-12-25 | Anson | North Carolina | 37007 | 4144 | 85 |
| 2046021 | 2046021 | 2021-12-24 | Anson | North Carolina | 37007 | 4144 | 85 |
| 2042771 | 2042771 | 2021-12-23 | Anson | North Carolina | 37007 | 4144 | 85 |
| 2039522 | 2039522 | 2021-12-22 | Anson | North Carolina | 37007 | 4144 | 85 |
| 2036272 | 2036272 | 2021-12-21 | Anson | North Carolina | 37007 | 4137 | 85 |
| 2033022 | 2033022 | 2021-12-20 | Anson | North Carolina | 37007 | 4133 | 85 |
| 2013570 | 2013570 | 2021-12-14 | Macon | North Carolina | 37113 | 5218 | 85 |
| 2010319 | 2010319 | 2021-12-13 | Macon | North Carolina | 37113 | 5216 | 85 |
| 2007068 | 2007068 | 2021-12-12 | Macon | North Carolina | 37113 | 5202 | 85 |
| 2003817 | 2003817 | 2021-12-11 | Macon | North Carolina | 37113 | 5202 | 85 |
| 2000566 | 2000566 | 2021-12-10 | Macon | North Carolina | 37113 | 5202 | 85 |
| 1997316 | 1997316 | 2021-12-09 | Macon | North Carolina | 37113 | 5188 | 85 |
| 1994065 | 1994065 | 2021-12-08 | Macon | North Carolina | 37113 | 5173 | 85 |
| 1906297 | 1906297 | 2021-11-11 | Hoke | North Carolina | 37093 | 7240 | 85 |
| 1903048 | 1903048 | 2021-11-10 | Hoke | North Carolina | 37093 | 7240 | 85 |
| 1899798 | 1899798 | 2021-11-09 | Hoke | North Carolina | 37093 | 7227 | 85 |
| 1779604 | 1779604 | 2021-10-03 | Person | North Carolina | 37145 | 4881 | 85 |
| 1776354 | 1776354 | 2021-10-02 | Person | North Carolina | 37145 | 4881 | 85 |
| 1773104 | 1773104 | 2021-10-01 | Person | North Carolina | 37145 | 4881 | 85 |
| 1769854 | 1769854 | 2021-09-30 | Person | North Carolina | 37145 | 4866 | 85 |
| 1766605 | 1766605 | 2021-09-29 | Person | North Carolina | 37145 | 4847 | 85 |
| 1643125 | 1643125 | 2021-08-22 | Granville | North Carolina | 37077 | 6465 | 85 |
| 1639875 | 1639875 | 2021-08-21 | Granville | North Carolina | 37077 | 6465 | 85 |
| 1636625 | 1636625 | 2021-08-20 | Granville | North Carolina | 37077 | 6465 | 85 |
| 1633375 | 1633375 | 2021-08-19 | Granville | North Carolina | 37077 | 6424 | 85 |
| 1630091 | 1630091 | 2021-08-18 | Alexander | North Carolina | 37003 | 4910 | 85 |
| 1630128 | 1630128 | 2021-08-18 | Granville | North Carolina | 37077 | 6395 | 85 |
| 1626844 | 1626844 | 2021-08-17 | Alexander | North Carolina | 37003 | 4872 | 85 |
| 1626881 | 1626881 | 2021-08-17 | Granville | North Carolina | 37077 | 6362 | 85 |
| 1626895 | 1626895 | 2021-08-17 | Lee | North Carolina | 37105 | 7064 | 85 |
| 1623597 | 1623597 | 2021-08-16 | Alexander | North Carolina | 37003 | 4869 | 85 |
| 1623634 | 1623634 | 2021-08-16 | Granville | North Carolina | 37077 | 6354 | 85 |
| 1623648 | 1623648 | 2021-08-16 | Lee | North Carolina | 37105 | 7023 | 85 |
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);