ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 7 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 10
state 1
- New Hampshire · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1961392 | 1961392 | 2021-11-28 | Unknown | New Hampshire | 1217 | 7 | |
1958141 | 1958141 | 2021-11-27 | Unknown | New Hampshire | 1217 | 7 | |
1954890 | 1954890 | 2021-11-26 | Unknown | New Hampshire | 1217 | 7 | |
1951639 | 1951639 | 2021-11-25 | Unknown | New Hampshire | 1217 | 7 | |
1948388 | 1948388 | 2021-11-24 | Unknown | New Hampshire | 1217 | 7 | |
1175405 | 1175405 | 2021-03-31 | Carroll | New Hampshire | 33003 | 1954 | 7 |
1172158 | 1172158 | 2021-03-30 | Carroll | New Hampshire | 33003 | 1942 | 7 |
1168910 | 1168910 | 2021-03-29 | Carroll | New Hampshire | 33003 | 1931 | 7 |
1165662 | 1165662 | 2021-03-28 | Carroll | New Hampshire | 33003 | 1924 | 7 |
1162414 | 1162414 | 2021-03-27 | Carroll | New Hampshire | 33003 | 1918 | 7 |
1159166 | 1159166 | 2021-03-26 | Carroll | New Hampshire | 33003 | 1907 | 7 |
1155919 | 1155919 | 2021-03-25 | Carroll | New Hampshire | 33003 | 1900 | 7 |
1152672 | 1152672 | 2021-03-24 | Carroll | New Hampshire | 33003 | 1886 | 7 |
1149425 | 1149425 | 2021-03-23 | Carroll | New Hampshire | 33003 | 1876 | 7 |
1146178 | 1146178 | 2021-03-22 | Carroll | New Hampshire | 33003 | 1868 | 7 |
1142931 | 1142931 | 2021-03-21 | Carroll | New Hampshire | 33003 | 1867 | 7 |
1139684 | 1139684 | 2021-03-20 | Carroll | New Hampshire | 33003 | 1863 | 7 |
1136438 | 1136438 | 2021-03-19 | Carroll | New Hampshire | 33003 | 1855 | 7 |
1133192 | 1133192 | 2021-03-18 | Carroll | New Hampshire | 33003 | 1850 | 7 |
1129944 | 1129944 | 2021-03-17 | Carroll | New Hampshire | 33003 | 1841 | 7 |
1126697 | 1126697 | 2021-03-16 | Carroll | New Hampshire | 33003 | 1833 | 7 |
1123451 | 1123451 | 2021-03-15 | Carroll | New Hampshire | 33003 | 1823 | 7 |
1120204 | 1120204 | 2021-03-14 | Carroll | New Hampshire | 33003 | 1817 | 7 |
1116957 | 1116957 | 2021-03-13 | Carroll | New Hampshire | 33003 | 1811 | 7 |
935200 | 935200 | 2021-01-16 | Cheshire | New Hampshire | 33005 | 1850 | 7 |
931955 | 931955 | 2021-01-15 | Cheshire | New Hampshire | 33005 | 1825 | 7 |
931962 | 931962 | 2021-01-15 | Sullivan | New Hampshire | 33019 | 775 | 7 |
928710 | 928710 | 2021-01-14 | Cheshire | New Hampshire | 33005 | 1782 | 7 |
925464 | 925464 | 2021-01-13 | Cheshire | New Hampshire | 33005 | 1753 | 7 |
922219 | 922219 | 2021-01-12 | Cheshire | New Hampshire | 33005 | 1688 | 7 |
918974 | 918974 | 2021-01-11 | Cheshire | New Hampshire | 33005 | 1631 | 7 |
915729 | 915729 | 2021-01-10 | Cheshire | New Hampshire | 33005 | 1589 | 7 |
912484 | 912484 | 2021-01-09 | Cheshire | New Hampshire | 33005 | 1509 | 7 |
909239 | 909239 | 2021-01-08 | Cheshire | New Hampshire | 33005 | 1494 | 7 |
905993 | 905993 | 2021-01-07 | Cheshire | New Hampshire | 33005 | 1435 | 7 |
902748 | 902748 | 2021-01-06 | Cheshire | New Hampshire | 33005 | 1421 | 7 |
899503 | 899503 | 2021-01-05 | Cheshire | New Hampshire | 33005 | 1404 | 7 |
896258 | 896258 | 2021-01-04 | Cheshire | New Hampshire | 33005 | 1392 | 7 |
893011 | 893011 | 2021-01-03 | Cheshire | New Hampshire | 33005 | 1351 | 7 |
889765 | 889765 | 2021-01-02 | Cheshire | New Hampshire | 33005 | 1319 | 7 |
886519 | 886519 | 2021-01-01 | Cheshire | New Hampshire | 33005 | 1263 | 7 |
883274 | 883274 | 2020-12-31 | Cheshire | New Hampshire | 33005 | 1263 | 7 |
837845 | 837845 | 2020-12-17 | Grafton | New Hampshire | 33009 | 916 | 7 |
834599 | 834599 | 2020-12-16 | Grafton | New Hampshire | 33009 | 880 | 7 |
789160 | 789160 | 2020-12-02 | Coos | New Hampshire | 33007 | 325 | 7 |
785915 | 785915 | 2020-12-01 | Coos | New Hampshire | 33007 | 323 | 7 |
782671 | 782671 | 2020-11-30 | Coos | New Hampshire | 33007 | 319 | 7 |
779425 | 779425 | 2020-11-29 | Coos | New Hampshire | 33007 | 308 | 7 |
753458 | 753458 | 2020-11-21 | Belknap | New Hampshire | 33001 | 533 | 7 |
750212 | 750212 | 2020-11-20 | Belknap | New Hampshire | 33001 | 511 | 7 |
746966 | 746966 | 2020-11-19 | Belknap | New Hampshire | 33001 | 486 | 7 |
743720 | 743720 | 2020-11-18 | Belknap | New Hampshire | 33001 | 461 | 7 |
122913 | 122913 | 2020-05-07 | Merrimack | New Hampshire | 33013 | 220 | 7 |
119938 | 119938 | 2020-05-06 | Merrimack | New Hampshire | 33013 | 213 | 7 |
96916 | 96916 | 2020-04-28 | Strafford | New Hampshire | 33017 | 133 | 7 |
94080 | 94080 | 2020-04-27 | Strafford | New Hampshire | 33017 | 132 | 7 |
91256 | 91256 | 2020-04-26 | Strafford | New Hampshire | 33017 | 132 | 7 |
88441 | 88441 | 2020-04-25 | Strafford | New Hampshire | 33017 | 129 | 7 |
36999 | 36999 | 2020-04-06 | Hillsborough | New Hampshire | 33011 | 272 | 7 |
34529 | 34529 | 2020-04-05 | Hillsborough | New Hampshire | 33011 | 249 | 7 |
32098 | 32098 | 2020-04-04 | Hillsborough | New Hampshire | 33011 | 231 | 7 |
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);