ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where deaths = 106 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Granville 27
- Macon 16
- Scotland 11
- Sampson 10
- Beaufort 7
- Chatham 7
- Rockingham 7
- Rutherford 7
- Yadkin 7
- Pender 6
- Stokes 6
- Burke 5
- Montgomery 5
- Guilford 4
- Halifax 4
- Bladen 3
- Columbus 3
- Cabarrus 2
- Craven 2
- Davidson 2
- Edgecombe 2
- Lenoir 2
- Pasquotank 2
- Wayne 2
- Cumberland 1
- Durham 1
- Forsyth 1
- Harnett 1
- Lee 1
- McDowell 1
- …
state 1
- North Carolina · 161 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2309487 | 2309487 | 2022-03-15 | Macon | North Carolina | 37113 | 7505 | 106 |
2306234 | 2306234 | 2022-03-14 | Macon | North Carolina | 37113 | 7499 | 106 |
2302983 | 2302983 | 2022-03-13 | Macon | North Carolina | 37113 | 7468 | 106 |
2299731 | 2299731 | 2022-03-12 | Macon | North Carolina | 37113 | 7468 | 106 |
2296479 | 2296479 | 2022-03-11 | Macon | North Carolina | 37113 | 7468 | 106 |
2293227 | 2293227 | 2022-03-10 | Macon | North Carolina | 37113 | 7467 | 106 |
2289975 | 2289975 | 2022-03-09 | Macon | North Carolina | 37113 | 7451 | 106 |
2286723 | 2286723 | 2022-03-08 | Macon | North Carolina | 37113 | 7436 | 106 |
2283471 | 2283471 | 2022-03-07 | Macon | North Carolina | 37113 | 7430 | 106 |
2280219 | 2280219 | 2022-03-06 | Macon | North Carolina | 37113 | 7375 | 106 |
2276966 | 2276966 | 2022-03-05 | Macon | North Carolina | 37113 | 7375 | 106 |
2273713 | 2273713 | 2022-03-04 | Macon | North Carolina | 37113 | 7375 | 106 |
2270460 | 2270460 | 2022-03-03 | Macon | North Carolina | 37113 | 7343 | 106 |
2267208 | 2267208 | 2022-03-02 | Macon | North Carolina | 37113 | 7336 | 106 |
2267251 | 2267251 | 2022-03-02 | Yadkin | North Carolina | 37197 | 10676 | 106 |
2263956 | 2263956 | 2022-03-01 | Macon | North Carolina | 37113 | 7310 | 106 |
2263999 | 2263999 | 2022-03-01 | Yadkin | North Carolina | 37197 | 10666 | 106 |
2260705 | 2260705 | 2022-02-28 | Macon | North Carolina | 37113 | 7300 | 106 |
2260748 | 2260748 | 2022-02-28 | Yadkin | North Carolina | 37197 | 10661 | 106 |
2257417 | 2257417 | 2022-02-27 | Chatham | North Carolina | 37037 | 12425 | 106 |
2257497 | 2257497 | 2022-02-27 | Yadkin | North Carolina | 37197 | 10645 | 106 |
2254166 | 2254166 | 2022-02-26 | Chatham | North Carolina | 37037 | 12425 | 106 |
2254246 | 2254246 | 2022-02-26 | Yadkin | North Carolina | 37197 | 10645 | 106 |
2250915 | 2250915 | 2022-02-25 | Chatham | North Carolina | 37037 | 12425 | 106 |
2250995 | 2250995 | 2022-02-25 | Yadkin | North Carolina | 37197 | 10645 | 106 |
2247664 | 2247664 | 2022-02-24 | Chatham | North Carolina | 37037 | 12403 | 106 |
2247744 | 2247744 | 2022-02-24 | Yadkin | North Carolina | 37197 | 10631 | 106 |
2244413 | 2244413 | 2022-02-23 | Chatham | North Carolina | 37037 | 12383 | 106 |
2241162 | 2241162 | 2022-02-22 | Chatham | North Carolina | 37037 | 12362 | 106 |
2237911 | 2237911 | 2022-02-21 | Chatham | North Carolina | 37037 | 12368 | 106 |
2169666 | 2169666 | 2022-01-31 | Pender | North Carolina | 37141 | 13970 | 106 |
2166349 | 2166349 | 2022-01-30 | Bladen | North Carolina | 37017 | 8544 | 106 |
2166411 | 2166411 | 2022-01-30 | Pender | North Carolina | 37141 | 13617 | 106 |
2163094 | 2163094 | 2022-01-29 | Bladen | North Carolina | 37017 | 8544 | 106 |
2163156 | 2163156 | 2022-01-29 | Pender | North Carolina | 37141 | 13617 | 106 |
2159839 | 2159839 | 2022-01-28 | Bladen | North Carolina | 37017 | 8544 | 106 |
2159901 | 2159901 | 2022-01-28 | Pender | North Carolina | 37141 | 13617 | 106 |
2156646 | 2156646 | 2022-01-27 | Pender | North Carolina | 37141 | 13475 | 106 |
2153393 | 2153393 | 2022-01-26 | Pender | North Carolina | 37141 | 13330 | 106 |
2055806 | 2055806 | 2021-12-27 | Granville | North Carolina | 37077 | 8685 | 106 |
2052556 | 2052556 | 2021-12-26 | Granville | North Carolina | 37077 | 8685 | 106 |
2049306 | 2049306 | 2021-12-25 | Granville | North Carolina | 37077 | 8685 | 106 |
2046056 | 2046056 | 2021-12-24 | Granville | North Carolina | 37077 | 8685 | 106 |
2042806 | 2042806 | 2021-12-23 | Granville | North Carolina | 37077 | 8685 | 106 |
2039557 | 2039557 | 2021-12-22 | Granville | North Carolina | 37077 | 8685 | 106 |
2036307 | 2036307 | 2021-12-21 | Granville | North Carolina | 37077 | 8659 | 106 |
2033057 | 2033057 | 2021-12-20 | Granville | North Carolina | 37077 | 8643 | 106 |
2029807 | 2029807 | 2021-12-19 | Granville | North Carolina | 37077 | 8586 | 106 |
2026556 | 2026556 | 2021-12-18 | Granville | North Carolina | 37077 | 8586 | 106 |
2023305 | 2023305 | 2021-12-17 | Granville | North Carolina | 37077 | 8586 | 106 |
2020054 | 2020054 | 2021-12-16 | Granville | North Carolina | 37077 | 8553 | 106 |
2016803 | 2016803 | 2021-12-15 | Granville | North Carolina | 37077 | 8532 | 106 |
2013553 | 2013553 | 2021-12-14 | Granville | North Carolina | 37077 | 8510 | 106 |
2010302 | 2010302 | 2021-12-13 | Granville | North Carolina | 37077 | 8501 | 106 |
2007051 | 2007051 | 2021-12-12 | Granville | North Carolina | 37077 | 8454 | 106 |
2003800 | 2003800 | 2021-12-11 | Granville | North Carolina | 37077 | 8454 | 106 |
2000549 | 2000549 | 2021-12-10 | Granville | North Carolina | 37077 | 8454 | 106 |
1997299 | 1997299 | 2021-12-09 | Granville | North Carolina | 37077 | 8429 | 106 |
1994048 | 1994048 | 2021-12-08 | Granville | North Carolina | 37077 | 8416 | 106 |
1990797 | 1990797 | 2021-12-07 | Granville | North Carolina | 37077 | 8411 | 106 |
1987546 | 1987546 | 2021-12-06 | Granville | North Carolina | 37077 | 8396 | 106 |
1984296 | 1984296 | 2021-12-05 | Granville | North Carolina | 37077 | 8350 | 106 |
1981046 | 1981046 | 2021-12-04 | Granville | North Carolina | 37077 | 8350 | 106 |
1977796 | 1977796 | 2021-12-03 | Granville | North Carolina | 37077 | 8350 | 106 |
1974546 | 1974546 | 2021-12-02 | Granville | North Carolina | 37077 | 8331 | 106 |
1971297 | 1971297 | 2021-12-01 | Granville | North Carolina | 37077 | 8306 | 106 |
1929068 | 1929068 | 2021-11-18 | Pasquotank | North Carolina | 37139 | 5451 | 106 |
1925818 | 1925818 | 2021-11-17 | Pasquotank | North Carolina | 37139 | 5438 | 106 |
1854346 | 1854346 | 2021-10-26 | Stokes | North Carolina | 37169 | 6204 | 106 |
1851097 | 1851097 | 2021-10-25 | Stokes | North Carolina | 37169 | 6200 | 106 |
1847845 | 1847845 | 2021-10-24 | Scotland | North Carolina | 37165 | 5686 | 106 |
1847847 | 1847847 | 2021-10-24 | Stokes | North Carolina | 37169 | 6163 | 106 |
1844595 | 1844595 | 2021-10-23 | Scotland | North Carolina | 37165 | 5686 | 106 |
1844597 | 1844597 | 2021-10-23 | Stokes | North Carolina | 37169 | 6163 | 106 |
1841345 | 1841345 | 2021-10-22 | Scotland | North Carolina | 37165 | 5686 | 106 |
1841347 | 1841347 | 2021-10-22 | Stokes | North Carolina | 37169 | 6163 | 106 |
1838096 | 1838096 | 2021-10-21 | Scotland | North Carolina | 37165 | 5674 | 106 |
1838098 | 1838098 | 2021-10-21 | Stokes | North Carolina | 37169 | 6146 | 106 |
1834847 | 1834847 | 2021-10-20 | Scotland | North Carolina | 37165 | 5659 | 106 |
1831568 | 1831568 | 2021-10-19 | Lee | North Carolina | 37105 | 9333 | 106 |
1831598 | 1831598 | 2021-10-19 | Scotland | North Carolina | 37165 | 5654 | 106 |
1828349 | 1828349 | 2021-10-18 | Scotland | North Carolina | 37165 | 5651 | 106 |
1825100 | 1825100 | 2021-10-17 | Scotland | North Carolina | 37165 | 5636 | 106 |
1821851 | 1821851 | 2021-10-16 | Scotland | North Carolina | 37165 | 5636 | 106 |
1818602 | 1818602 | 2021-10-15 | Scotland | North Carolina | 37165 | 5636 | 106 |
1815353 | 1815353 | 2021-10-14 | Scotland | North Carolina | 37165 | 5628 | 106 |
1763345 | 1763345 | 2021-09-28 | Montgomery | North Carolina | 37123 | 4281 | 106 |
1760093 | 1760093 | 2021-09-27 | McDowell | North Carolina | 37111 | 7956 | 106 |
1760096 | 1760096 | 2021-09-27 | Montgomery | North Carolina | 37123 | 4275 | 106 |
1756848 | 1756848 | 2021-09-26 | Montgomery | North Carolina | 37123 | 4252 | 106 |
1753600 | 1753600 | 2021-09-25 | Montgomery | North Carolina | 37123 | 4252 | 106 |
1750352 | 1750352 | 2021-09-24 | Montgomery | North Carolina | 37123 | 4252 | 106 |
1747108 | 1747108 | 2021-09-23 | Orange | North Carolina | 37135 | 10889 | 106 |
1678821 | 1678821 | 2021-09-02 | Beaufort | North Carolina | 37013 | 5519 | 106 |
1675573 | 1675573 | 2021-09-01 | Beaufort | North Carolina | 37013 | 5473 | 106 |
1672326 | 1672326 | 2021-08-31 | Beaufort | North Carolina | 37013 | 5450 | 106 |
1669078 | 1669078 | 2021-08-30 | Beaufort | North Carolina | 37013 | 5430 | 106 |
1665831 | 1665831 | 2021-08-29 | Beaufort | North Carolina | 37013 | 5320 | 106 |
1662583 | 1662583 | 2021-08-28 | Beaufort | North Carolina | 37013 | 5320 | 106 |
1659335 | 1659335 | 2021-08-27 | Beaufort | North Carolina | 37013 | 5320 | 106 |
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);