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 |
---|---|---|---|---|---|---|---|
1055286 | 1055286 | 2021-02-22 | Belknap | New Hampshire | 33001 | 3056 | 90 |
1055287 | 1055287 | 2021-02-22 | Carroll | New Hampshire | 33003 | 1653 | 6 |
1055288 | 1055288 | 2021-02-22 | Cheshire | New Hampshire | 33005 | 2568 | 25 |
1055289 | 1055289 | 2021-02-22 | Coos | New Hampshire | 33007 | 1280 | 36 |
1055290 | 1055290 | 2021-02-22 | Grafton | New Hampshire | 33009 | 2496 | 18 |
1055291 | 1055291 | 2021-02-22 | Hillsborough | New Hampshire | 33011 | 28018 | 575 |
1055292 | 1055292 | 2021-02-22 | Merrimack | New Hampshire | 33013 | 7316 | 103 |
1055293 | 1055293 | 2021-02-22 | Rockingham | New Hampshire | 33015 | 18072 | 205 |
1055294 | 1055294 | 2021-02-22 | Strafford | New Hampshire | 33017 | 6836 | 72 |
1055295 | 1055295 | 2021-02-22 | Sullivan | New Hampshire | 33019 | 1305 | 19 |
1055296 | 1055296 | 2021-02-22 | Unknown | New Hampshire | 1065 | 5 | |
1052039 | 1052039 | 2021-02-21 | Belknap | New Hampshire | 33001 | 3054 | 90 |
1052040 | 1052040 | 2021-02-21 | Carroll | New Hampshire | 33003 | 1646 | 6 |
1052041 | 1052041 | 2021-02-21 | Cheshire | New Hampshire | 33005 | 2538 | 25 |
1052042 | 1052042 | 2021-02-21 | Coos | New Hampshire | 33007 | 1273 | 36 |
1052043 | 1052043 | 2021-02-21 | Grafton | New Hampshire | 33009 | 2483 | 18 |
1052044 | 1052044 | 2021-02-21 | Hillsborough | New Hampshire | 33011 | 27947 | 575 |
1052045 | 1052045 | 2021-02-21 | Merrimack | New Hampshire | 33013 | 7299 | 103 |
1052046 | 1052046 | 2021-02-21 | Rockingham | New Hampshire | 33015 | 18022 | 205 |
1052047 | 1052047 | 2021-02-21 | Strafford | New Hampshire | 33017 | 6798 | 72 |
1052048 | 1052048 | 2021-02-21 | Sullivan | New Hampshire | 33019 | 1302 | 19 |
1052049 | 1052049 | 2021-02-21 | Unknown | New Hampshire | 1051 | 5 | |
1048792 | 1048792 | 2021-02-20 | Belknap | New Hampshire | 33001 | 3052 | 90 |
1048793 | 1048793 | 2021-02-20 | Carroll | New Hampshire | 33003 | 1642 | 6 |
1048794 | 1048794 | 2021-02-20 | Cheshire | New Hampshire | 33005 | 2527 | 25 |
1048795 | 1048795 | 2021-02-20 | Coos | New Hampshire | 33007 | 1267 | 35 |
1048796 | 1048796 | 2021-02-20 | Grafton | New Hampshire | 33009 | 2476 | 18 |
1048797 | 1048797 | 2021-02-20 | Hillsborough | New Hampshire | 33011 | 27867 | 575 |
1048798 | 1048798 | 2021-02-20 | Merrimack | New Hampshire | 33013 | 7262 | 103 |
1048799 | 1048799 | 2021-02-20 | Rockingham | New Hampshire | 33015 | 17964 | 205 |
1048800 | 1048800 | 2021-02-20 | Strafford | New Hampshire | 33017 | 6744 | 72 |
1048801 | 1048801 | 2021-02-20 | Sullivan | New Hampshire | 33019 | 1300 | 19 |
1048802 | 1048802 | 2021-02-20 | Unknown | New Hampshire | 1060 | 5 | |
1045546 | 1045546 | 2021-02-19 | Belknap | New Hampshire | 33001 | 3041 | 90 |
1045547 | 1045547 | 2021-02-19 | Carroll | New Hampshire | 33003 | 1637 | 6 |
1045548 | 1045548 | 2021-02-19 | Cheshire | New Hampshire | 33005 | 2517 | 25 |
1045549 | 1045549 | 2021-02-19 | Coos | New Hampshire | 33007 | 1260 | 35 |
1045550 | 1045550 | 2021-02-19 | Grafton | New Hampshire | 33009 | 2437 | 17 |
1045551 | 1045551 | 2021-02-19 | Hillsborough | New Hampshire | 33011 | 27762 | 575 |
1045552 | 1045552 | 2021-02-19 | Merrimack | New Hampshire | 33013 | 7235 | 103 |
1045553 | 1045553 | 2021-02-19 | Rockingham | New Hampshire | 33015 | 17864 | 205 |
1045554 | 1045554 | 2021-02-19 | Strafford | New Hampshire | 33017 | 6676 | 72 |
1045555 | 1045555 | 2021-02-19 | Sullivan | New Hampshire | 33019 | 1293 | 19 |
1045556 | 1045556 | 2021-02-19 | Unknown | New Hampshire | 1045 | 5 | |
1042301 | 1042301 | 2021-02-18 | Belknap | New Hampshire | 33001 | 3033 | 90 |
1042302 | 1042302 | 2021-02-18 | Carroll | New Hampshire | 33003 | 1627 | 6 |
1042303 | 1042303 | 2021-02-18 | Cheshire | New Hampshire | 33005 | 2502 | 24 |
1042304 | 1042304 | 2021-02-18 | Coos | New Hampshire | 33007 | 1250 | 35 |
1042305 | 1042305 | 2021-02-18 | Grafton | New Hampshire | 33009 | 2405 | 17 |
1042306 | 1042306 | 2021-02-18 | Hillsborough | New Hampshire | 33011 | 27663 | 574 |
1042307 | 1042307 | 2021-02-18 | Merrimack | New Hampshire | 33013 | 7205 | 103 |
1042308 | 1042308 | 2021-02-18 | Rockingham | New Hampshire | 33015 | 17774 | 205 |
1042309 | 1042309 | 2021-02-18 | Strafford | New Hampshire | 33017 | 6618 | 72 |
1042310 | 1042310 | 2021-02-18 | Sullivan | New Hampshire | 33019 | 1285 | 19 |
1042311 | 1042311 | 2021-02-18 | Unknown | New Hampshire | 1037 | 5 | |
1039056 | 1039056 | 2021-02-17 | Belknap | New Hampshire | 33001 | 3027 | 90 |
1039057 | 1039057 | 2021-02-17 | Carroll | New Hampshire | 33003 | 1616 | 6 |
1039058 | 1039058 | 2021-02-17 | Cheshire | New Hampshire | 33005 | 2475 | 24 |
1039059 | 1039059 | 2021-02-17 | Coos | New Hampshire | 33007 | 1240 | 35 |
1039060 | 1039060 | 2021-02-17 | Grafton | New Hampshire | 33009 | 2316 | 17 |
1039061 | 1039061 | 2021-02-17 | Hillsborough | New Hampshire | 33011 | 27541 | 574 |
1039062 | 1039062 | 2021-02-17 | Merrimack | New Hampshire | 33013 | 7165 | 103 |
1039063 | 1039063 | 2021-02-17 | Rockingham | New Hampshire | 33015 | 17692 | 203 |
1039064 | 1039064 | 2021-02-17 | Strafford | New Hampshire | 33017 | 6545 | 72 |
1039065 | 1039065 | 2021-02-17 | Sullivan | New Hampshire | 33019 | 1278 | 19 |
1039066 | 1039066 | 2021-02-17 | Unknown | New Hampshire | 1070 | 5 | |
1035811 | 1035811 | 2021-02-16 | Belknap | New Hampshire | 33001 | 3005 | 90 |
1035812 | 1035812 | 2021-02-16 | Carroll | New Hampshire | 33003 | 1616 | 6 |
1035813 | 1035813 | 2021-02-16 | Cheshire | New Hampshire | 33005 | 2458 | 24 |
1035814 | 1035814 | 2021-02-16 | Coos | New Hampshire | 33007 | 1232 | 34 |
1035815 | 1035815 | 2021-02-16 | Grafton | New Hampshire | 33009 | 2263 | 17 |
1035816 | 1035816 | 2021-02-16 | Hillsborough | New Hampshire | 33011 | 27369 | 570 |
1035817 | 1035817 | 2021-02-16 | Merrimack | New Hampshire | 33013 | 7117 | 103 |
1035818 | 1035818 | 2021-02-16 | Rockingham | New Hampshire | 33015 | 17385 | 198 |
1035819 | 1035819 | 2021-02-16 | Strafford | New Hampshire | 33017 | 6489 | 70 |
1035820 | 1035820 | 2021-02-16 | Sullivan | New Hampshire | 33019 | 1262 | 19 |
1035821 | 1035821 | 2021-02-16 | Unknown | New Hampshire | 1019 | 5 | |
1032566 | 1032566 | 2021-02-15 | Belknap | New Hampshire | 33001 | 3003 | 90 |
1032567 | 1032567 | 2021-02-15 | Carroll | New Hampshire | 33003 | 1607 | 6 |
1032568 | 1032568 | 2021-02-15 | Cheshire | New Hampshire | 33005 | 2442 | 24 |
1032569 | 1032569 | 2021-02-15 | Coos | New Hampshire | 33007 | 1228 | 34 |
1032570 | 1032570 | 2021-02-15 | Grafton | New Hampshire | 33009 | 2241 | 17 |
1032571 | 1032571 | 2021-02-15 | Hillsborough | New Hampshire | 33011 | 27315 | 570 |
1032572 | 1032572 | 2021-02-15 | Merrimack | New Hampshire | 33013 | 7099 | 103 |
1032573 | 1032573 | 2021-02-15 | Rockingham | New Hampshire | 33015 | 17341 | 198 |
1032574 | 1032574 | 2021-02-15 | Strafford | New Hampshire | 33017 | 6478 | 69 |
1032575 | 1032575 | 2021-02-15 | Sullivan | New Hampshire | 33019 | 1256 | 19 |
1032576 | 1032576 | 2021-02-15 | Unknown | New Hampshire | 1007 | 5 | |
1029319 | 1029319 | 2021-02-14 | Belknap | New Hampshire | 33001 | 2998 | 90 |
1029320 | 1029320 | 2021-02-14 | Carroll | New Hampshire | 33003 | 1604 | 6 |
1029321 | 1029321 | 2021-02-14 | Cheshire | New Hampshire | 33005 | 2429 | 24 |
1029322 | 1029322 | 2021-02-14 | Coos | New Hampshire | 33007 | 1225 | 33 |
1029323 | 1029323 | 2021-02-14 | Grafton | New Hampshire | 33009 | 2235 | 17 |
1029324 | 1029324 | 2021-02-14 | Hillsborough | New Hampshire | 33011 | 27241 | 569 |
1029325 | 1029325 | 2021-02-14 | Merrimack | New Hampshire | 33013 | 7083 | 103 |
1029326 | 1029326 | 2021-02-14 | Rockingham | New Hampshire | 33015 | 17303 | 198 |
1029327 | 1029327 | 2021-02-14 | Strafford | New Hampshire | 33017 | 6420 | 69 |
1029328 | 1029328 | 2021-02-14 | Sullivan | New Hampshire | 33019 | 1251 | 19 |
1029329 | 1029329 | 2021-02-14 | Unknown | New Hampshire | 996 | 5 | |
1026073 | 1026073 | 2021-02-13 | Belknap | New Hampshire | 33001 | 2991 | 90 |
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);