ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
416 rows where deaths = 14 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
- Pamlico 35
- Carteret 23
- Gates 22
- Burke 20
- Currituck 19
- Northampton 18
- Lincoln 17
- Jones 16
- Rockingham 14
- Watauga 14
- Polk 13
- Anson 12
- Moore 12
- Rutherford 12
- Caldwell 10
- Catawba 9
- Dare 9
- Davie 9
- Pitt 8
- Cherokee 7
- Pasquotank 7
- Yadkin 7
- Hertford 6
- Henderson 5
- Cumberland 4
- Franklin 4
- Lee 4
- McDowell 4
- Mitchell 4
- New Hanover 4
- …
state 1
- North Carolina · 416 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1925776 | 1925776 | 2021-11-17 | Dare | North Carolina | 37055 | 4014 | 14 |
1922527 | 1922527 | 2021-11-16 | Dare | North Carolina | 37055 | 4005 | 14 |
1919277 | 1919277 | 2021-11-15 | Dare | North Carolina | 37055 | 3997 | 14 |
1916027 | 1916027 | 2021-11-14 | Dare | North Carolina | 37055 | 3975 | 14 |
1912777 | 1912777 | 2021-11-13 | Dare | North Carolina | 37055 | 3975 | 14 |
1909527 | 1909527 | 2021-11-12 | Dare | North Carolina | 37055 | 3975 | 14 |
1906278 | 1906278 | 2021-11-11 | Dare | North Carolina | 37055 | 3949 | 14 |
1903029 | 1903029 | 2021-11-10 | Dare | North Carolina | 37055 | 3949 | 14 |
1899779 | 1899779 | 2021-11-09 | Dare | North Carolina | 37055 | 3933 | 14 |
1747077 | 1747077 | 2021-09-23 | Gates | North Carolina | 37073 | 950 | 14 |
1743828 | 1743828 | 2021-09-22 | Gates | North Carolina | 37073 | 944 | 14 |
1740579 | 1740579 | 2021-09-21 | Gates | North Carolina | 37073 | 940 | 14 |
1737330 | 1737330 | 2021-09-20 | Gates | North Carolina | 37073 | 938 | 14 |
1734080 | 1734080 | 2021-09-19 | Gates | North Carolina | 37073 | 930 | 14 |
1730830 | 1730830 | 2021-09-18 | Gates | North Carolina | 37073 | 930 | 14 |
1727580 | 1727580 | 2021-09-17 | Gates | North Carolina | 37073 | 930 | 14 |
1724331 | 1724331 | 2021-09-16 | Gates | North Carolina | 37073 | 927 | 14 |
1721082 | 1721082 | 2021-09-15 | Gates | North Carolina | 37073 | 922 | 14 |
1717834 | 1717834 | 2021-09-14 | Gates | North Carolina | 37073 | 912 | 14 |
1714586 | 1714586 | 2021-09-13 | Gates | North Carolina | 37073 | 908 | 14 |
1711340 | 1711340 | 2021-09-12 | Gates | North Carolina | 37073 | 893 | 14 |
1711372 | 1711372 | 2021-09-12 | Pamlico | North Carolina | 37137 | 1381 | 14 |
1708093 | 1708093 | 2021-09-11 | Gates | North Carolina | 37073 | 893 | 14 |
1708125 | 1708125 | 2021-09-11 | Pamlico | North Carolina | 37137 | 1381 | 14 |
1704846 | 1704846 | 2021-09-10 | Gates | North Carolina | 37073 | 893 | 14 |
1704878 | 1704878 | 2021-09-10 | Pamlico | North Carolina | 37137 | 1381 | 14 |
1701596 | 1701596 | 2021-09-09 | Gates | North Carolina | 37073 | 888 | 14 |
1701628 | 1701628 | 2021-09-09 | Pamlico | North Carolina | 37137 | 1369 | 14 |
1698347 | 1698347 | 2021-09-08 | Gates | North Carolina | 37073 | 877 | 14 |
1698379 | 1698379 | 2021-09-08 | Pamlico | North Carolina | 37137 | 1351 | 14 |
1695099 | 1695099 | 2021-09-07 | Gates | North Carolina | 37073 | 873 | 14 |
1695131 | 1695131 | 2021-09-07 | Pamlico | North Carolina | 37137 | 1353 | 14 |
1691851 | 1691851 | 2021-09-06 | Gates | North Carolina | 37073 | 863 | 14 |
1691883 | 1691883 | 2021-09-06 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1688601 | 1688601 | 2021-09-05 | Gates | North Carolina | 37073 | 863 | 14 |
1688633 | 1688633 | 2021-09-05 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1685351 | 1685351 | 2021-09-04 | Gates | North Carolina | 37073 | 863 | 14 |
1685383 | 1685383 | 2021-09-04 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1682100 | 1682100 | 2021-09-03 | Gates | North Carolina | 37073 | 863 | 14 |
1682132 | 1682132 | 2021-09-03 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1678851 | 1678851 | 2021-09-02 | Gates | North Carolina | 37073 | 861 | 14 |
1678883 | 1678883 | 2021-09-02 | Pamlico | North Carolina | 37137 | 1308 | 14 |
1675635 | 1675635 | 2021-09-01 | Pamlico | North Carolina | 37137 | 1304 | 14 |
1672388 | 1672388 | 2021-08-31 | Pamlico | North Carolina | 37137 | 1297 | 14 |
1669140 | 1669140 | 2021-08-30 | Pamlico | North Carolina | 37137 | 1288 | 14 |
1665893 | 1665893 | 2021-08-29 | Pamlico | North Carolina | 37137 | 1267 | 14 |
1662645 | 1662645 | 2021-08-28 | Pamlico | North Carolina | 37137 | 1267 | 14 |
1659397 | 1659397 | 2021-08-27 | Pamlico | North Carolina | 37137 | 1267 | 14 |
1656148 | 1656148 | 2021-08-26 | Pamlico | North Carolina | 37137 | 1262 | 14 |
1652901 | 1652901 | 2021-08-25 | Pamlico | North Carolina | 37137 | 1252 | 14 |
1649653 | 1649653 | 2021-08-24 | Pamlico | North Carolina | 37137 | 1247 | 14 |
1646404 | 1646404 | 2021-08-23 | Pamlico | North Carolina | 37137 | 1242 | 14 |
1643155 | 1643155 | 2021-08-22 | Pamlico | North Carolina | 37137 | 1230 | 14 |
1639905 | 1639905 | 2021-08-21 | Pamlico | North Carolina | 37137 | 1230 | 14 |
1636655 | 1636655 | 2021-08-20 | Pamlico | North Carolina | 37137 | 1230 | 14 |
1633405 | 1633405 | 2021-08-19 | Pamlico | North Carolina | 37137 | 1224 | 14 |
1630127 | 1630127 | 2021-08-18 | Graham | North Carolina | 37075 | 804 | 14 |
1630158 | 1630158 | 2021-08-18 | Pamlico | North Carolina | 37137 | 1214 | 14 |
1626880 | 1626880 | 2021-08-17 | Graham | North Carolina | 37075 | 796 | 14 |
1626911 | 1626911 | 2021-08-17 | Pamlico | North Carolina | 37137 | 1209 | 14 |
1623633 | 1623633 | 2021-08-16 | Graham | North Carolina | 37075 | 788 | 14 |
1623664 | 1623664 | 2021-08-16 | Pamlico | North Carolina | 37137 | 1208 | 14 |
1620417 | 1620417 | 2021-08-15 | Pamlico | North Carolina | 37137 | 1191 | 14 |
1617169 | 1617169 | 2021-08-14 | Pamlico | North Carolina | 37137 | 1191 | 14 |
1613921 | 1613921 | 2021-08-13 | Pamlico | North Carolina | 37137 | 1191 | 14 |
1610672 | 1610672 | 2021-08-12 | Pamlico | North Carolina | 37137 | 1188 | 14 |
1607424 | 1607424 | 2021-08-11 | Pamlico | North Carolina | 37137 | 1177 | 14 |
1604175 | 1604175 | 2021-08-10 | Pamlico | North Carolina | 37137 | 1173 | 14 |
1600926 | 1600926 | 2021-08-09 | Pamlico | North Carolina | 37137 | 1169 | 14 |
1042451 | 1042451 | 2021-02-18 | Currituck | North Carolina | 37053 | 1312 | 14 |
1039206 | 1039206 | 2021-02-17 | Currituck | North Carolina | 37053 | 1285 | 14 |
1035961 | 1035961 | 2021-02-16 | Currituck | North Carolina | 37053 | 1272 | 14 |
1032716 | 1032716 | 2021-02-15 | Currituck | North Carolina | 37053 | 1267 | 14 |
1029470 | 1029470 | 2021-02-14 | Currituck | North Carolina | 37053 | 1258 | 14 |
1026223 | 1026223 | 2021-02-13 | Currituck | North Carolina | 37053 | 1249 | 14 |
1022978 | 1022978 | 2021-02-12 | Currituck | North Carolina | 37053 | 1226 | 14 |
1019733 | 1019733 | 2021-02-11 | Currituck | North Carolina | 37053 | 1214 | 14 |
1016488 | 1016488 | 2021-02-10 | Currituck | North Carolina | 37053 | 1202 | 14 |
1013243 | 1013243 | 2021-02-09 | Currituck | North Carolina | 37053 | 1191 | 14 |
1009998 | 1009998 | 2021-02-08 | Currituck | North Carolina | 37053 | 1185 | 14 |
1006752 | 1006752 | 2021-02-07 | Currituck | North Carolina | 37053 | 1176 | 14 |
1003506 | 1003506 | 2021-02-06 | Currituck | North Carolina | 37053 | 1168 | 14 |
1003540 | 1003540 | 2021-02-06 | Mitchell | North Carolina | 37121 | 1181 | 14 |
1000260 | 1000260 | 2021-02-05 | Currituck | North Carolina | 37053 | 1145 | 14 |
1000294 | 1000294 | 2021-02-05 | Mitchell | North Carolina | 37121 | 1181 | 14 |
997014 | 997014 | 2021-02-04 | Currituck | North Carolina | 37053 | 1142 | 14 |
997048 | 997048 | 2021-02-04 | Mitchell | North Carolina | 37121 | 1177 | 14 |
997080 | 997080 | 2021-02-04 | Warren | North Carolina | 37185 | 1474 | 14 |
993768 | 993768 | 2021-02-03 | Currituck | North Carolina | 37053 | 1130 | 14 |
993802 | 993802 | 2021-02-03 | Mitchell | North Carolina | 37121 | 1174 | 14 |
993834 | 993834 | 2021-02-03 | Warren | North Carolina | 37185 | 1464 | 14 |
990522 | 990522 | 2021-02-02 | Currituck | North Carolina | 37053 | 1124 | 14 |
990588 | 990588 | 2021-02-02 | Warren | North Carolina | 37185 | 1426 | 14 |
987276 | 987276 | 2021-02-01 | Currituck | North Carolina | 37053 | 1122 | 14 |
984029 | 984029 | 2021-01-31 | Currituck | North Carolina | 37053 | 1111 | 14 |
980772 | 980772 | 2021-01-30 | Caswell | North Carolina | 37033 | 1708 | 14 |
980842 | 980842 | 2021-01-30 | Swain | North Carolina | 37173 | 1058 | 14 |
977526 | 977526 | 2021-01-29 | Caswell | North Carolina | 37033 | 1708 | 14 |
977596 | 977596 | 2021-01-29 | Swain | North Carolina | 37173 | 1058 | 14 |
974281 | 974281 | 2021-01-28 | Caswell | North Carolina | 37033 | 1698 | 14 |
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);