ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where deaths = 35 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
state 1
- New Hampshire · 87 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2123919 | 2123919 | 2022-01-17 | Carroll | New Hampshire | 33003 | 7387 | 35 |
2120667 | 2120667 | 2022-01-16 | Carroll | New Hampshire | 33003 | 7387 | 35 |
2117415 | 2117415 | 2022-01-15 | Carroll | New Hampshire | 33003 | 7387 | 35 |
2114164 | 2114164 | 2022-01-14 | Carroll | New Hampshire | 33003 | 7387 | 35 |
2110912 | 2110912 | 2022-01-13 | Carroll | New Hampshire | 33003 | 7293 | 35 |
1919130 | 1919130 | 2021-11-15 | Grafton | New Hampshire | 33009 | 6761 | 35 |
1915880 | 1915880 | 2021-11-14 | Grafton | New Hampshire | 33009 | 6639 | 35 |
1912630 | 1912630 | 2021-11-13 | Grafton | New Hampshire | 33009 | 6639 | 35 |
1909380 | 1909380 | 2021-11-12 | Grafton | New Hampshire | 33009 | 6639 | 35 |
1906131 | 1906131 | 2021-11-11 | Grafton | New Hampshire | 33009 | 6513 | 35 |
1902882 | 1902882 | 2021-11-10 | Grafton | New Hampshire | 33009 | 6513 | 35 |
1899632 | 1899632 | 2021-11-09 | Grafton | New Hampshire | 33009 | 6471 | 35 |
1828152 | 1828152 | 2021-10-18 | Sullivan | New Hampshire | 33019 | 3151 | 35 |
1581241 | 1581241 | 2021-08-03 | Cheshire | New Hampshire | 33005 | 3986 | 35 |
1577992 | 1577992 | 2021-08-02 | Cheshire | New Hampshire | 33005 | 3975 | 35 |
1574744 | 1574744 | 2021-08-01 | Cheshire | New Hampshire | 33005 | 3956 | 35 |
1571496 | 1571496 | 2021-07-31 | Cheshire | New Hampshire | 33005 | 3956 | 35 |
1568248 | 1568248 | 2021-07-30 | Cheshire | New Hampshire | 33005 | 3956 | 35 |
1565000 | 1565000 | 2021-07-29 | Cheshire | New Hampshire | 33005 | 3948 | 35 |
1561752 | 1561752 | 2021-07-28 | Cheshire | New Hampshire | 33005 | 3946 | 35 |
1558504 | 1558504 | 2021-07-27 | Cheshire | New Hampshire | 33005 | 3944 | 35 |
1555257 | 1555257 | 2021-07-26 | Cheshire | New Hampshire | 33005 | 3941 | 35 |
1552010 | 1552010 | 2021-07-25 | Cheshire | New Hampshire | 33005 | 3934 | 35 |
1548763 | 1548763 | 2021-07-24 | Cheshire | New Hampshire | 33005 | 3934 | 35 |
1545516 | 1545516 | 2021-07-23 | Cheshire | New Hampshire | 33005 | 3934 | 35 |
1542268 | 1542268 | 2021-07-22 | Cheshire | New Hampshire | 33005 | 3931 | 35 |
1539021 | 1539021 | 2021-07-21 | Cheshire | New Hampshire | 33005 | 3933 | 35 |
1535774 | 1535774 | 2021-07-20 | Cheshire | New Hampshire | 33005 | 3930 | 35 |
1532526 | 1532526 | 2021-07-19 | Cheshire | New Hampshire | 33005 | 3928 | 35 |
1529279 | 1529279 | 2021-07-18 | Cheshire | New Hampshire | 33005 | 3927 | 35 |
1526032 | 1526032 | 2021-07-17 | Cheshire | New Hampshire | 33005 | 3927 | 35 |
1522785 | 1522785 | 2021-07-16 | Cheshire | New Hampshire | 33005 | 3927 | 35 |
1519536 | 1519536 | 2021-07-15 | Cheshire | New Hampshire | 33005 | 3926 | 35 |
1516289 | 1516289 | 2021-07-14 | Cheshire | New Hampshire | 33005 | 3920 | 35 |
1513042 | 1513042 | 2021-07-13 | Cheshire | New Hampshire | 33005 | 3916 | 35 |
1509795 | 1509795 | 2021-07-12 | Cheshire | New Hampshire | 33005 | 3915 | 35 |
1506549 | 1506549 | 2021-07-11 | Cheshire | New Hampshire | 33005 | 3915 | 35 |
1503303 | 1503303 | 2021-07-10 | Cheshire | New Hampshire | 33005 | 3915 | 35 |
1500057 | 1500057 | 2021-07-09 | Cheshire | New Hampshire | 33005 | 3915 | 35 |
1496811 | 1496811 | 2021-07-08 | Cheshire | New Hampshire | 33005 | 3914 | 35 |
1493564 | 1493564 | 2021-07-07 | Cheshire | New Hampshire | 33005 | 3911 | 35 |
1490317 | 1490317 | 2021-07-06 | Cheshire | New Hampshire | 33005 | 3904 | 35 |
1487070 | 1487070 | 2021-07-05 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1483824 | 1483824 | 2021-07-04 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1480578 | 1480578 | 2021-07-03 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1477331 | 1477331 | 2021-07-02 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1474085 | 1474085 | 2021-07-01 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1470839 | 1470839 | 2021-06-30 | Cheshire | New Hampshire | 33005 | 3899 | 35 |
1467594 | 1467594 | 2021-06-29 | Cheshire | New Hampshire | 33005 | 3898 | 35 |
1464349 | 1464349 | 2021-06-28 | Cheshire | New Hampshire | 33005 | 3898 | 35 |
1461104 | 1461104 | 2021-06-27 | Cheshire | New Hampshire | 33005 | 3898 | 35 |
1457859 | 1457859 | 2021-06-26 | Cheshire | New Hampshire | 33005 | 3898 | 35 |
1454614 | 1454614 | 2021-06-25 | Cheshire | New Hampshire | 33005 | 3898 | 35 |
1451369 | 1451369 | 2021-06-24 | Cheshire | New Hampshire | 33005 | 3897 | 35 |
1448123 | 1448123 | 2021-06-23 | Cheshire | New Hampshire | 33005 | 3893 | 35 |
1444878 | 1444878 | 2021-06-22 | Cheshire | New Hampshire | 33005 | 3893 | 35 |
1441633 | 1441633 | 2021-06-21 | Cheshire | New Hampshire | 33005 | 3892 | 35 |
1438387 | 1438387 | 2021-06-20 | Cheshire | New Hampshire | 33005 | 3891 | 35 |
1435140 | 1435140 | 2021-06-19 | Cheshire | New Hampshire | 33005 | 3891 | 35 |
1431893 | 1431893 | 2021-06-18 | Cheshire | New Hampshire | 33005 | 3891 | 35 |
1428648 | 1428648 | 2021-06-17 | Cheshire | New Hampshire | 33005 | 3889 | 35 |
1425403 | 1425403 | 2021-06-16 | Cheshire | New Hampshire | 33005 | 3888 | 35 |
1422155 | 1422155 | 2021-06-15 | Cheshire | New Hampshire | 33005 | 3888 | 35 |
1418910 | 1418910 | 2021-06-14 | Cheshire | New Hampshire | 33005 | 3888 | 35 |
1415665 | 1415665 | 2021-06-13 | Cheshire | New Hampshire | 33005 | 3887 | 35 |
1412419 | 1412419 | 2021-06-12 | Cheshire | New Hampshire | 33005 | 3887 | 35 |
1409174 | 1409174 | 2021-06-11 | Cheshire | New Hampshire | 33005 | 3887 | 35 |
1405929 | 1405929 | 2021-06-10 | Cheshire | New Hampshire | 33005 | 3886 | 35 |
1402683 | 1402683 | 2021-06-09 | Cheshire | New Hampshire | 33005 | 3882 | 35 |
1399438 | 1399438 | 2021-06-08 | Cheshire | New Hampshire | 33005 | 3880 | 35 |
1396192 | 1396192 | 2021-06-07 | Cheshire | New Hampshire | 33005 | 3878 | 35 |
1048795 | 1048795 | 2021-02-20 | Coos | New Hampshire | 33007 | 1267 | 35 |
1045549 | 1045549 | 2021-02-19 | Coos | New Hampshire | 33007 | 1260 | 35 |
1042304 | 1042304 | 2021-02-18 | Coos | New Hampshire | 33007 | 1250 | 35 |
1039059 | 1039059 | 2021-02-17 | Coos | New Hampshire | 33007 | 1240 | 35 |
909245 | 909245 | 2021-01-08 | Strafford | New Hampshire | 33017 | 4108 | 35 |
905999 | 905999 | 2021-01-07 | Strafford | New Hampshire | 33017 | 4024 | 35 |
902754 | 902754 | 2021-01-06 | Strafford | New Hampshire | 33017 | 3973 | 35 |
818363 | 818363 | 2020-12-11 | Belknap | New Hampshire | 33001 | 1138 | 35 |
792408 | 792408 | 2020-12-03 | Merrimack | New Hampshire | 33013 | 2149 | 35 |
789163 | 789163 | 2020-12-02 | Merrimack | New Hampshire | 33013 | 2055 | 35 |
785918 | 785918 | 2020-12-01 | Merrimack | New Hampshire | 33013 | 1973 | 35 |
782674 | 782674 | 2020-11-30 | Merrimack | New Hampshire | 33013 | 1862 | 35 |
779428 | 779428 | 2020-11-29 | Merrimack | New Hampshire | 33013 | 1810 | 35 |
776183 | 776183 | 2020-11-28 | Merrimack | New Hampshire | 33013 | 1768 | 35 |
772938 | 772938 | 2020-11-27 | Merrimack | New Hampshire | 33013 | 1695 | 35 |
102613 | 102613 | 2020-04-30 | Hillsborough | New Hampshire | 33011 | 964 | 35 |
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);