ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,612 rows where state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194889 | 1194889 | 2021-04-06 | Belknap | New Hampshire | 33001 | 3443 | 96 |
1194890 | 1194890 | 2021-04-06 | Carroll | New Hampshire | 33003 | 2033 | 8 |
1194891 | 1194891 | 2021-04-06 | Cheshire | New Hampshire | 33005 | 3196 | 33 |
1194892 | 1194892 | 2021-04-06 | Coos | New Hampshire | 33007 | 1540 | 38 |
1194893 | 1194893 | 2021-04-06 | Grafton | New Hampshire | 33009 | 3210 | 21 |
1194894 | 1194894 | 2021-04-06 | Hillsborough | New Hampshire | 33011 | 32171 | 610 |
1194895 | 1194895 | 2021-04-06 | Merrimack | New Hampshire | 33013 | 8474 | 110 |
1194896 | 1194896 | 2021-04-06 | Rockingham | New Hampshire | 33015 | 21488 | 229 |
1194897 | 1194897 | 2021-04-06 | Strafford | New Hampshire | 33017 | 8321 | 76 |
1194898 | 1194898 | 2021-04-06 | Sullivan | New Hampshire | 33019 | 1485 | 22 |
1194899 | 1194899 | 2021-04-06 | Unknown | New Hampshire | 1149 | 6 | |
1191640 | 1191640 | 2021-04-05 | Belknap | New Hampshire | 33001 | 3427 | 96 |
1191641 | 1191641 | 2021-04-05 | Carroll | New Hampshire | 33003 | 2021 | 8 |
1191642 | 1191642 | 2021-04-05 | Cheshire | New Hampshire | 33005 | 3181 | 33 |
1191643 | 1191643 | 2021-04-05 | Coos | New Hampshire | 33007 | 1536 | 38 |
1191644 | 1191644 | 2021-04-05 | Grafton | New Hampshire | 33009 | 3187 | 21 |
1191645 | 1191645 | 2021-04-05 | Hillsborough | New Hampshire | 33011 | 32047 | 610 |
1191646 | 1191646 | 2021-04-05 | Merrimack | New Hampshire | 33013 | 8428 | 110 |
1191647 | 1191647 | 2021-04-05 | Rockingham | New Hampshire | 33015 | 21364 | 229 |
1191648 | 1191648 | 2021-04-05 | Strafford | New Hampshire | 33017 | 8296 | 76 |
1191649 | 1191649 | 2021-04-05 | Sullivan | New Hampshire | 33019 | 1478 | 22 |
1191650 | 1191650 | 2021-04-05 | Unknown | New Hampshire | 1160 | 6 | |
1188392 | 1188392 | 2021-04-04 | Belknap | New Hampshire | 33001 | 3413 | 96 |
1188393 | 1188393 | 2021-04-04 | Carroll | New Hampshire | 33003 | 2014 | 8 |
1188394 | 1188394 | 2021-04-04 | Cheshire | New Hampshire | 33005 | 3177 | 33 |
1188395 | 1188395 | 2021-04-04 | Coos | New Hampshire | 33007 | 1534 | 38 |
1188396 | 1188396 | 2021-04-04 | Grafton | New Hampshire | 33009 | 3175 | 21 |
1188397 | 1188397 | 2021-04-04 | Hillsborough | New Hampshire | 33011 | 31978 | 610 |
1188398 | 1188398 | 2021-04-04 | Merrimack | New Hampshire | 33013 | 8400 | 110 |
1188399 | 1188399 | 2021-04-04 | Rockingham | New Hampshire | 33015 | 21283 | 229 |
1188400 | 1188400 | 2021-04-04 | Strafford | New Hampshire | 33017 | 8249 | 76 |
1188401 | 1188401 | 2021-04-04 | Sullivan | New Hampshire | 33019 | 1469 | 22 |
1188402 | 1188402 | 2021-04-04 | Unknown | New Hampshire | 1154 | 6 | |
1185145 | 1185145 | 2021-04-03 | Belknap | New Hampshire | 33001 | 3401 | 96 |
1185146 | 1185146 | 2021-04-03 | Carroll | New Hampshire | 33003 | 2008 | 8 |
1185147 | 1185147 | 2021-04-03 | Cheshire | New Hampshire | 33005 | 3166 | 32 |
1185148 | 1185148 | 2021-04-03 | Coos | New Hampshire | 33007 | 1528 | 38 |
1185149 | 1185149 | 2021-04-03 | Grafton | New Hampshire | 33009 | 3160 | 21 |
1185150 | 1185150 | 2021-04-03 | Hillsborough | New Hampshire | 33011 | 31844 | 609 |
1185151 | 1185151 | 2021-04-03 | Merrimack | New Hampshire | 33013 | 8371 | 110 |
1185152 | 1185152 | 2021-04-03 | Rockingham | New Hampshire | 33015 | 21200 | 229 |
1185153 | 1185153 | 2021-04-03 | Strafford | New Hampshire | 33017 | 8177 | 76 |
1185154 | 1185154 | 2021-04-03 | Sullivan | New Hampshire | 33019 | 1460 | 22 |
1185155 | 1185155 | 2021-04-03 | Unknown | New Hampshire | 1133 | 6 | |
1181898 | 1181898 | 2021-04-02 | Belknap | New Hampshire | 33001 | 3378 | 96 |
1181899 | 1181899 | 2021-04-02 | Carroll | New Hampshire | 33003 | 1987 | 8 |
1181900 | 1181900 | 2021-04-02 | Cheshire | New Hampshire | 33005 | 3149 | 32 |
1181901 | 1181901 | 2021-04-02 | Coos | New Hampshire | 33007 | 1517 | 38 |
1181902 | 1181902 | 2021-04-02 | Grafton | New Hampshire | 33009 | 3137 | 21 |
1181903 | 1181903 | 2021-04-02 | Hillsborough | New Hampshire | 33011 | 31681 | 608 |
1181904 | 1181904 | 2021-04-02 | Merrimack | New Hampshire | 33013 | 8315 | 110 |
1181905 | 1181905 | 2021-04-02 | Rockingham | New Hampshire | 33015 | 21075 | 228 |
1181906 | 1181906 | 2021-04-02 | Strafford | New Hampshire | 33017 | 8136 | 76 |
1181907 | 1181907 | 2021-04-02 | Sullivan | New Hampshire | 33019 | 1454 | 22 |
1181908 | 1181908 | 2021-04-02 | Unknown | New Hampshire | 1181 | 6 | |
1178651 | 1178651 | 2021-04-01 | Belknap | New Hampshire | 33001 | 3370 | 96 |
1178652 | 1178652 | 2021-04-01 | Carroll | New Hampshire | 33003 | 1970 | 8 |
1178653 | 1178653 | 2021-04-01 | Cheshire | New Hampshire | 33005 | 3145 | 32 |
1178654 | 1178654 | 2021-04-01 | Coos | New Hampshire | 33007 | 1508 | 38 |
1178655 | 1178655 | 2021-04-01 | Grafton | New Hampshire | 33009 | 3118 | 21 |
1178656 | 1178656 | 2021-04-01 | Hillsborough | New Hampshire | 33011 | 31533 | 608 |
1178657 | 1178657 | 2021-04-01 | Merrimack | New Hampshire | 33013 | 8277 | 110 |
1178658 | 1178658 | 2021-04-01 | Rockingham | New Hampshire | 33015 | 20985 | 228 |
1178659 | 1178659 | 2021-04-01 | Strafford | New Hampshire | 33017 | 8074 | 76 |
1178660 | 1178660 | 2021-04-01 | Sullivan | New Hampshire | 33019 | 1453 | 22 |
1178661 | 1178661 | 2021-04-01 | Unknown | New Hampshire | 1106 | 6 | |
1175404 | 1175404 | 2021-03-31 | Belknap | New Hampshire | 33001 | 3364 | 95 |
1175405 | 1175405 | 2021-03-31 | Carroll | New Hampshire | 33003 | 1954 | 7 |
1175406 | 1175406 | 2021-03-31 | Cheshire | New Hampshire | 33005 | 3134 | 32 |
1175407 | 1175407 | 2021-03-31 | Coos | New Hampshire | 33007 | 1498 | 38 |
1175408 | 1175408 | 2021-03-31 | Grafton | New Hampshire | 33009 | 3101 | 21 |
1175409 | 1175409 | 2021-03-31 | Hillsborough | New Hampshire | 33011 | 31371 | 605 |
1175410 | 1175410 | 2021-03-31 | Merrimack | New Hampshire | 33013 | 8237 | 110 |
1175411 | 1175411 | 2021-03-31 | Rockingham | New Hampshire | 33015 | 20887 | 227 |
1175412 | 1175412 | 2021-03-31 | Strafford | New Hampshire | 33017 | 8017 | 76 |
1175413 | 1175413 | 2021-03-31 | Sullivan | New Hampshire | 33019 | 1448 | 22 |
1175414 | 1175414 | 2021-03-31 | Unknown | New Hampshire | 1165 | 5 | |
1172157 | 1172157 | 2021-03-30 | Belknap | New Hampshire | 33001 | 3342 | 95 |
1172158 | 1172158 | 2021-03-30 | Carroll | New Hampshire | 33003 | 1942 | 7 |
1172159 | 1172159 | 2021-03-30 | Cheshire | New Hampshire | 33005 | 3128 | 32 |
1172160 | 1172160 | 2021-03-30 | Coos | New Hampshire | 33007 | 1487 | 38 |
1172161 | 1172161 | 2021-03-30 | Grafton | New Hampshire | 33009 | 3084 | 21 |
1172162 | 1172162 | 2021-03-30 | Hillsborough | New Hampshire | 33011 | 31231 | 605 |
1172163 | 1172163 | 2021-03-30 | Merrimack | New Hampshire | 33013 | 8185 | 110 |
1172164 | 1172164 | 2021-03-30 | Rockingham | New Hampshire | 33015 | 20752 | 226 |
1172165 | 1172165 | 2021-03-30 | Strafford | New Hampshire | 33017 | 7978 | 76 |
1172166 | 1172166 | 2021-03-30 | Sullivan | New Hampshire | 33019 | 1445 | 22 |
1172167 | 1172167 | 2021-03-30 | Unknown | New Hampshire | 1140 | 5 | |
1168909 | 1168909 | 2021-03-29 | Belknap | New Hampshire | 33001 | 3335 | 95 |
1168910 | 1168910 | 2021-03-29 | Carroll | New Hampshire | 33003 | 1931 | 7 |
1168911 | 1168911 | 2021-03-29 | Cheshire | New Hampshire | 33005 | 3111 | 32 |
1168912 | 1168912 | 2021-03-29 | Coos | New Hampshire | 33007 | 1482 | 38 |
1168913 | 1168913 | 2021-03-29 | Grafton | New Hampshire | 33009 | 3065 | 21 |
1168914 | 1168914 | 2021-03-29 | Hillsborough | New Hampshire | 33011 | 31104 | 605 |
1168915 | 1168915 | 2021-03-29 | Merrimack | New Hampshire | 33013 | 8154 | 110 |
1168916 | 1168916 | 2021-03-29 | Rockingham | New Hampshire | 33015 | 20655 | 226 |
1168917 | 1168917 | 2021-03-29 | Strafford | New Hampshire | 33017 | 7944 | 76 |
1168918 | 1168918 | 2021-03-29 | Sullivan | New Hampshire | 33019 | 1437 | 22 |
1168919 | 1168919 | 2021-03-29 | Unknown | New Hampshire | 1122 | 5 | |
1165661 | 1165661 | 2021-03-28 | Belknap | New Hampshire | 33001 | 3324 | 95 |
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);