ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
242 rows where deaths = 78 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
- Stanly 54
- Pasquotank 28
- Cherokee 21
- Madison 14
- Person 12
- Ashe 10
- Vance 10
- Lee 8
- Northampton 8
- Stokes 7
- Anson 6
- Johnston 6
- Caldwell 5
- Chatham 5
- Hoke 5
- Lincoln 5
- Bladen 4
- Brunswick 4
- Edgecombe 3
- Granville 3
- Columbus 2
- Craven 2
- Guilford 2
- Harnett 2
- Richmond 2
- Rockingham 2
- Sampson 2
- Surry 2
- Cabarrus 1
- Durham 1
- …
state 1
- North Carolina · 242 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501490 | 2501490 | 2022-05-13 | Ashe | North Carolina | 37009 | 6471 | 78 |
2498232 | 2498232 | 2022-05-12 | Ashe | North Carolina | 37009 | 6471 | 78 |
2494974 | 2494974 | 2022-05-11 | Ashe | North Carolina | 37009 | 6471 | 78 |
2491716 | 2491716 | 2022-05-10 | Ashe | North Carolina | 37009 | 6440 | 78 |
2488458 | 2488458 | 2022-05-09 | Ashe | North Carolina | 37009 | 6440 | 78 |
2485201 | 2485201 | 2022-05-08 | Ashe | North Carolina | 37009 | 6440 | 78 |
2481943 | 2481943 | 2022-05-07 | Ashe | North Carolina | 37009 | 6440 | 78 |
2478685 | 2478685 | 2022-05-06 | Ashe | North Carolina | 37009 | 6440 | 78 |
2475427 | 2475427 | 2022-05-05 | Ashe | North Carolina | 37009 | 6440 | 78 |
2472170 | 2472170 | 2022-05-04 | Ashe | North Carolina | 37009 | 6440 | 78 |
2260715 | 2260715 | 2022-02-28 | Northampton | North Carolina | 37131 | 4285 | 78 |
2257455 | 2257455 | 2022-02-27 | Madison | North Carolina | 37115 | 4965 | 78 |
2257464 | 2257464 | 2022-02-27 | Northampton | North Carolina | 37131 | 4280 | 78 |
2254204 | 2254204 | 2022-02-26 | Madison | North Carolina | 37115 | 4965 | 78 |
2254213 | 2254213 | 2022-02-26 | Northampton | North Carolina | 37131 | 4280 | 78 |
2250953 | 2250953 | 2022-02-25 | Madison | North Carolina | 37115 | 4965 | 78 |
2250962 | 2250962 | 2022-02-25 | Northampton | North Carolina | 37131 | 4280 | 78 |
2247702 | 2247702 | 2022-02-24 | Madison | North Carolina | 37115 | 4959 | 78 |
2247711 | 2247711 | 2022-02-24 | Northampton | North Carolina | 37131 | 4276 | 78 |
2244451 | 2244451 | 2022-02-23 | Madison | North Carolina | 37115 | 4944 | 78 |
2244460 | 2244460 | 2022-02-23 | Northampton | North Carolina | 37131 | 4269 | 78 |
2241200 | 2241200 | 2022-02-22 | Madison | North Carolina | 37115 | 4931 | 78 |
2241209 | 2241209 | 2022-02-22 | Northampton | North Carolina | 37131 | 4265 | 78 |
2237949 | 2237949 | 2022-02-21 | Madison | North Carolina | 37115 | 4927 | 78 |
2237958 | 2237958 | 2022-02-21 | Northampton | North Carolina | 37131 | 4264 | 78 |
2234698 | 2234698 | 2022-02-20 | Madison | North Carolina | 37115 | 4885 | 78 |
2231447 | 2231447 | 2022-02-19 | Madison | North Carolina | 37115 | 4885 | 78 |
2228196 | 2228196 | 2022-02-18 | Madison | North Carolina | 37115 | 4885 | 78 |
2224945 | 2224945 | 2022-02-17 | Madison | North Carolina | 37115 | 4852 | 78 |
2221694 | 2221694 | 2022-02-16 | Madison | North Carolina | 37115 | 4820 | 78 |
2218443 | 2218443 | 2022-02-15 | Madison | North Carolina | 37115 | 4812 | 78 |
2215192 | 2215192 | 2022-02-14 | Madison | North Carolina | 37115 | 4803 | 78 |
2150116 | 2150116 | 2022-01-25 | Hertford | North Carolina | 37091 | 4383 | 78 |
2150128 | 2150128 | 2022-01-25 | Martin | North Carolina | 37117 | 5386 | 78 |
1990778 | 1990778 | 2021-12-07 | Cherokee | North Carolina | 37039 | 4800 | 78 |
1987527 | 1987527 | 2021-12-06 | Cherokee | North Carolina | 37039 | 4796 | 78 |
1984277 | 1984277 | 2021-12-05 | Cherokee | North Carolina | 37039 | 4776 | 78 |
1981027 | 1981027 | 2021-12-04 | Cherokee | North Carolina | 37039 | 4776 | 78 |
1977777 | 1977777 | 2021-12-03 | Cherokee | North Carolina | 37039 | 4776 | 78 |
1974527 | 1974527 | 2021-12-02 | Cherokee | North Carolina | 37039 | 4766 | 78 |
1971278 | 1971278 | 2021-12-01 | Cherokee | North Carolina | 37039 | 4760 | 78 |
1968028 | 1968028 | 2021-11-30 | Cherokee | North Carolina | 37039 | 4750 | 78 |
1964777 | 1964777 | 2021-11-29 | Cherokee | North Carolina | 37039 | 4743 | 78 |
1961525 | 1961525 | 2021-11-28 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1958274 | 1958274 | 2021-11-27 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1955023 | 1955023 | 2021-11-26 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1951772 | 1951772 | 2021-11-25 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1948521 | 1948521 | 2021-11-24 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1945270 | 1945270 | 2021-11-23 | Cherokee | North Carolina | 37039 | 4724 | 78 |
1942019 | 1942019 | 2021-11-22 | Cherokee | North Carolina | 37039 | 4723 | 78 |
1938769 | 1938769 | 2021-11-21 | Cherokee | North Carolina | 37039 | 4714 | 78 |
1935519 | 1935519 | 2021-11-20 | Cherokee | North Carolina | 37039 | 4714 | 78 |
1932269 | 1932269 | 2021-11-19 | Cherokee | North Carolina | 37039 | 4714 | 78 |
1929018 | 1929018 | 2021-11-18 | Cherokee | North Carolina | 37039 | 4707 | 78 |
1925768 | 1925768 | 2021-11-17 | Cherokee | North Carolina | 37039 | 4701 | 78 |
1851016 | 1851016 | 2021-10-25 | Anson | North Carolina | 37007 | 3820 | 78 |
1847766 | 1847766 | 2021-10-24 | Anson | North Carolina | 37007 | 3807 | 78 |
1844516 | 1844516 | 2021-10-23 | Anson | North Carolina | 37007 | 3807 | 78 |
1841266 | 1841266 | 2021-10-22 | Anson | North Carolina | 37007 | 3807 | 78 |
1838017 | 1838017 | 2021-10-21 | Anson | North Carolina | 37007 | 3799 | 78 |
1834768 | 1834768 | 2021-10-20 | Anson | North Carolina | 37007 | 3798 | 78 |
1828313 | 1828313 | 2021-10-18 | Hoke | North Carolina | 37093 | 7024 | 78 |
1825064 | 1825064 | 2021-10-17 | Hoke | North Carolina | 37093 | 7003 | 78 |
1821815 | 1821815 | 2021-10-16 | Hoke | North Carolina | 37093 | 7003 | 78 |
1818566 | 1818566 | 2021-10-15 | Hoke | North Carolina | 37093 | 7003 | 78 |
1815317 | 1815317 | 2021-10-14 | Hoke | North Carolina | 37093 | 6991 | 78 |
1756859 | 1756859 | 2021-09-26 | Person | North Carolina | 37145 | 4749 | 78 |
1753611 | 1753611 | 2021-09-25 | Person | North Carolina | 37145 | 4749 | 78 |
1750363 | 1750363 | 2021-09-24 | Person | North Carolina | 37145 | 4749 | 78 |
1747113 | 1747113 | 2021-09-23 | Person | North Carolina | 37145 | 4728 | 78 |
1743864 | 1743864 | 2021-09-22 | Person | North Carolina | 37145 | 4700 | 78 |
1740615 | 1740615 | 2021-09-21 | Person | North Carolina | 37145 | 4670 | 78 |
1737366 | 1737366 | 2021-09-20 | Person | North Carolina | 37145 | 4642 | 78 |
1734116 | 1734116 | 2021-09-19 | Person | North Carolina | 37145 | 4558 | 78 |
1730866 | 1730866 | 2021-09-18 | Person | North Carolina | 37145 | 4558 | 78 |
1727616 | 1727616 | 2021-09-17 | Person | North Carolina | 37145 | 4558 | 78 |
1724367 | 1724367 | 2021-09-16 | Person | North Carolina | 37145 | 4509 | 78 |
1721118 | 1721118 | 2021-09-15 | Person | North Carolina | 37145 | 4489 | 78 |
1691823 | 1691823 | 2021-09-06 | Bladen | North Carolina | 37017 | 4812 | 78 |
1688573 | 1688573 | 2021-09-05 | Bladen | North Carolina | 37017 | 4812 | 78 |
1685323 | 1685323 | 2021-09-04 | Bladen | North Carolina | 37017 | 4812 | 78 |
1682072 | 1682072 | 2021-09-03 | Bladen | North Carolina | 37017 | 4812 | 78 |
1672390 | 1672390 | 2021-08-31 | Pender | North Carolina | 37141 | 7157 | 78 |
1331443 | 1331443 | 2021-05-18 | Lee | North Carolina | 37105 | 6029 | 78 |
1328196 | 1328196 | 2021-05-17 | Lee | North Carolina | 37105 | 6026 | 78 |
1324950 | 1324950 | 2021-05-16 | Lee | North Carolina | 37105 | 6010 | 78 |
1321704 | 1321704 | 2021-05-15 | Lee | North Carolina | 37105 | 6010 | 78 |
1318458 | 1318458 | 2021-05-14 | Lee | North Carolina | 37105 | 6010 | 78 |
1315210 | 1315210 | 2021-05-13 | Lee | North Carolina | 37105 | 6005 | 78 |
1311964 | 1311964 | 2021-05-12 | Lee | North Carolina | 37105 | 6001 | 78 |
1308717 | 1308717 | 2021-05-11 | Lee | North Carolina | 37105 | 5994 | 78 |
1188600 | 1188600 | 2021-04-04 | Stokes | North Carolina | 37169 | 3777 | 78 |
1185353 | 1185353 | 2021-04-03 | Stokes | North Carolina | 37169 | 3777 | 78 |
1182106 | 1182106 | 2021-04-02 | Stokes | North Carolina | 37169 | 3777 | 78 |
1178859 | 1178859 | 2021-04-01 | Stokes | North Carolina | 37169 | 3777 | 78 |
1175612 | 1175612 | 2021-03-31 | Stokes | North Carolina | 37169 | 3772 | 78 |
1172359 | 1172359 | 2021-03-30 | Rockingham | North Carolina | 37157 | 7089 | 78 |
1172365 | 1172365 | 2021-03-30 | Stokes | North Carolina | 37169 | 3769 | 78 |
1169112 | 1169112 | 2021-03-29 | Rockingham | North Carolina | 37157 | 7084 | 78 |
1169118 | 1169118 | 2021-03-29 | Stokes | North Carolina | 37169 | 3769 | 78 |
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);