ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
203 rows where deaths = 59 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Northampton 27
- Union 14
- Orange 13
- Alamance 12
- Alexander 12
- Columbus 10
- Pasquotank 10
- Hoke 9
- Granville 8
- Henderson 8
- Anson 7
- Chatham 7
- Bertie 6
- Pitt 6
- Cherokee 5
- Rockingham 5
- Rutherford 5
- Person 4
- Caldwell 3
- Catawba 3
- Lenoir 3
- Richmond 3
- Brunswick 2
- Cabarrus 2
- Edgecombe 2
- Gaston 2
- Johnston 2
- Sampson 2
- Scotland 2
- Transylvania 2
- …
state 1
- North Carolina · 203 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2172936 | 2172936 | 2022-02-01 | Transylvania | North Carolina | 37175 | 5691 | 59 |
2169603 | 2169603 | 2022-01-31 | Bertie | North Carolina | 37015 | 4005 | 59 |
2169683 | 2169683 | 2022-01-31 | Transylvania | North Carolina | 37175 | 5676 | 59 |
2166348 | 2166348 | 2022-01-30 | Bertie | North Carolina | 37015 | 3953 | 59 |
2163093 | 2163093 | 2022-01-29 | Bertie | North Carolina | 37015 | 3953 | 59 |
2159838 | 2159838 | 2022-01-28 | Bertie | North Carolina | 37015 | 3953 | 59 |
2156583 | 2156583 | 2022-01-27 | Bertie | North Carolina | 37015 | 3932 | 59 |
2153330 | 2153330 | 2022-01-26 | Bertie | North Carolina | 37015 | 3888 | 59 |
1740562 | 1740562 | 2021-09-21 | Cherokee | North Carolina | 37039 | 4310 | 59 |
1737313 | 1737313 | 2021-09-20 | Cherokee | North Carolina | 37039 | 4294 | 59 |
1734063 | 1734063 | 2021-09-19 | Cherokee | North Carolina | 37039 | 4212 | 59 |
1730813 | 1730813 | 2021-09-18 | Cherokee | North Carolina | 37039 | 4212 | 59 |
1727563 | 1727563 | 2021-09-17 | Cherokee | North Carolina | 37039 | 4212 | 59 |
1678864 | 1678864 | 2021-09-02 | Jackson | North Carolina | 37099 | 4502 | 59 |
1672366 | 1672366 | 2021-08-31 | Hoke | North Carolina | 37093 | 6035 | 59 |
1669118 | 1669118 | 2021-08-30 | Hoke | North Carolina | 37093 | 6020 | 59 |
1665871 | 1665871 | 2021-08-29 | Hoke | North Carolina | 37093 | 5913 | 59 |
1662623 | 1662623 | 2021-08-28 | Hoke | North Carolina | 37093 | 5913 | 59 |
1659375 | 1659375 | 2021-08-27 | Hoke | North Carolina | 37093 | 5913 | 59 |
1656126 | 1656126 | 2021-08-26 | Hoke | North Carolina | 37093 | 5855 | 59 |
1652879 | 1652879 | 2021-08-25 | Hoke | North Carolina | 37093 | 5814 | 59 |
1649588 | 1649588 | 2021-08-24 | Anson | North Carolina | 37007 | 2956 | 59 |
1649631 | 1649631 | 2021-08-24 | Hoke | North Carolina | 37093 | 5769 | 59 |
1646339 | 1646339 | 2021-08-23 | Anson | North Carolina | 37007 | 2946 | 59 |
1646382 | 1646382 | 2021-08-23 | Hoke | North Carolina | 37093 | 5744 | 59 |
1643090 | 1643090 | 2021-08-22 | Anson | North Carolina | 37007 | 2889 | 59 |
1639840 | 1639840 | 2021-08-21 | Anson | North Carolina | 37007 | 2889 | 59 |
1636590 | 1636590 | 2021-08-20 | Anson | North Carolina | 37007 | 2889 | 59 |
1633340 | 1633340 | 2021-08-19 | Anson | North Carolina | 37007 | 2872 | 59 |
1630093 | 1630093 | 2021-08-18 | Anson | North Carolina | 37007 | 2857 | 59 |
1587871 | 1587871 | 2021-08-05 | Bladen | North Carolina | 37017 | 3900 | 59 |
1373661 | 1373661 | 2021-05-31 | Northampton | North Carolina | 37131 | 1888 | 59 |
1370416 | 1370416 | 2021-05-30 | Northampton | North Carolina | 37131 | 1888 | 59 |
1367170 | 1367170 | 2021-05-29 | Northampton | North Carolina | 37131 | 1888 | 59 |
1363924 | 1363924 | 2021-05-28 | Northampton | North Carolina | 37131 | 1888 | 59 |
1360678 | 1360678 | 2021-05-27 | Northampton | North Carolina | 37131 | 1891 | 59 |
1357432 | 1357432 | 2021-05-26 | Northampton | North Carolina | 37131 | 1891 | 59 |
1354186 | 1354186 | 2021-05-25 | Northampton | North Carolina | 37131 | 1890 | 59 |
1350940 | 1350940 | 2021-05-24 | Northampton | North Carolina | 37131 | 1889 | 59 |
1347694 | 1347694 | 2021-05-23 | Northampton | North Carolina | 37131 | 1886 | 59 |
1344446 | 1344446 | 2021-05-22 | Northampton | North Carolina | 37131 | 1886 | 59 |
1341198 | 1341198 | 2021-05-21 | Northampton | North Carolina | 37131 | 1886 | 59 |
1337950 | 1337950 | 2021-05-20 | Northampton | North Carolina | 37131 | 1885 | 59 |
1334703 | 1334703 | 2021-05-19 | Northampton | North Carolina | 37131 | 1881 | 59 |
1331456 | 1331456 | 2021-05-18 | Northampton | North Carolina | 37131 | 1880 | 59 |
1328209 | 1328209 | 2021-05-17 | Northampton | North Carolina | 37131 | 1880 | 59 |
1324963 | 1324963 | 2021-05-16 | Northampton | North Carolina | 37131 | 1876 | 59 |
1321717 | 1321717 | 2021-05-15 | Northampton | North Carolina | 37131 | 1876 | 59 |
1318471 | 1318471 | 2021-05-14 | Northampton | North Carolina | 37131 | 1876 | 59 |
1315223 | 1315223 | 2021-05-13 | Northampton | North Carolina | 37131 | 1875 | 59 |
1311977 | 1311977 | 2021-05-12 | Northampton | North Carolina | 37131 | 1874 | 59 |
1308730 | 1308730 | 2021-05-11 | Northampton | North Carolina | 37131 | 1874 | 59 |
1305484 | 1305484 | 2021-05-10 | Northampton | North Carolina | 37131 | 1874 | 59 |
1302238 | 1302238 | 2021-05-09 | Northampton | North Carolina | 37131 | 1873 | 59 |
1298990 | 1298990 | 2021-05-08 | Northampton | North Carolina | 37131 | 1873 | 59 |
1295744 | 1295744 | 2021-05-07 | Northampton | North Carolina | 37131 | 1873 | 59 |
1292498 | 1292498 | 2021-05-06 | Northampton | North Carolina | 37131 | 1872 | 59 |
1289252 | 1289252 | 2021-05-05 | Northampton | North Carolina | 37131 | 1869 | 59 |
1058701 | 1058701 | 2021-02-23 | Hertford | North Carolina | 37091 | 1934 | 59 |
1058734 | 1058734 | 2021-02-23 | Rockingham | North Carolina | 37157 | 6713 | 59 |
1055488 | 1055488 | 2021-02-22 | Rockingham | North Carolina | 37157 | 6711 | 59 |
1052242 | 1052242 | 2021-02-21 | Rockingham | North Carolina | 37157 | 6702 | 59 |
1048995 | 1048995 | 2021-02-20 | Rockingham | North Carolina | 37157 | 6689 | 59 |
1045748 | 1045748 | 2021-02-19 | Rockingham | North Carolina | 37157 | 6680 | 59 |
1036007 | 1036007 | 2021-02-16 | Person | North Carolina | 37145 | 2826 | 59 |
1032762 | 1032762 | 2021-02-15 | Person | North Carolina | 37145 | 2819 | 59 |
1029516 | 1029516 | 2021-02-14 | Person | North Carolina | 37145 | 2813 | 59 |
1026269 | 1026269 | 2021-02-13 | Person | North Carolina | 37145 | 2798 | 59 |
1009973 | 1009973 | 2021-02-08 | Alexander | North Carolina | 37003 | 3650 | 59 |
1009985 | 1009985 | 2021-02-08 | Caldwell | North Carolina | 37027 | 8191 | 59 |
1006727 | 1006727 | 2021-02-07 | Alexander | North Carolina | 37003 | 3641 | 59 |
1006739 | 1006739 | 2021-02-07 | Caldwell | North Carolina | 37027 | 8169 | 59 |
1003481 | 1003481 | 2021-02-06 | Alexander | North Carolina | 37003 | 3624 | 59 |
1003493 | 1003493 | 2021-02-06 | Caldwell | North Carolina | 37027 | 8138 | 59 |
1000235 | 1000235 | 2021-02-05 | Alexander | North Carolina | 37003 | 3608 | 59 |
996989 | 996989 | 2021-02-04 | Alexander | North Carolina | 37003 | 3603 | 59 |
993743 | 993743 | 2021-02-03 | Alexander | North Carolina | 37003 | 3589 | 59 |
990497 | 990497 | 2021-02-02 | Alexander | North Carolina | 37003 | 3522 | 59 |
987251 | 987251 | 2021-02-01 | Alexander | North Carolina | 37003 | 3514 | 59 |
984004 | 984004 | 2021-01-31 | Alexander | North Carolina | 37003 | 3503 | 59 |
980757 | 980757 | 2021-01-30 | Alexander | North Carolina | 37003 | 3473 | 59 |
977511 | 977511 | 2021-01-29 | Alexander | North Carolina | 37003 | 3473 | 59 |
974266 | 974266 | 2021-01-28 | Alexander | North Carolina | 37003 | 3455 | 59 |
951626 | 951626 | 2021-01-21 | Richmond | North Carolina | 37153 | 3382 | 59 |
948381 | 948381 | 2021-01-20 | Richmond | North Carolina | 37153 | 3333 | 59 |
945134 | 945134 | 2021-01-19 | Richmond | North Carolina | 37153 | 3304 | 59 |
935391 | 935391 | 2021-01-16 | Pasquotank | North Carolina | 37139 | 2356 | 59 |
932146 | 932146 | 2021-01-15 | Pasquotank | North Carolina | 37139 | 2310 | 59 |
928901 | 928901 | 2021-01-14 | Pasquotank | North Carolina | 37139 | 2262 | 59 |
928914 | 928914 | 2021-01-14 | Scotland | North Carolina | 37165 | 2895 | 59 |
925628 | 925628 | 2021-01-13 | Halifax | North Carolina | 37083 | 3541 | 59 |
925656 | 925656 | 2021-01-13 | Pasquotank | North Carolina | 37139 | 2223 | 59 |
925669 | 925669 | 2021-01-13 | Scotland | North Carolina | 37165 | 2848 | 59 |
922410 | 922410 | 2021-01-12 | Pasquotank | North Carolina | 37139 | 2170 | 59 |
919165 | 919165 | 2021-01-11 | Pasquotank | North Carolina | 37139 | 2156 | 59 |
915920 | 915920 | 2021-01-10 | Pasquotank | North Carolina | 37139 | 2130 | 59 |
912675 | 912675 | 2021-01-09 | Pasquotank | North Carolina | 37139 | 2107 | 59 |
909430 | 909430 | 2021-01-08 | Pasquotank | North Carolina | 37139 | 2069 | 59 |
906185 | 906185 | 2021-01-07 | Pasquotank | North Carolina | 37139 | 1985 | 59 |
870497 | 870497 | 2020-12-27 | Sampson | North Carolina | 37163 | 4785 | 59 |
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);