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 |
---|---|---|---|---|---|---|---|
922217 | 922217 | 2021-01-12 | Belknap | New Hampshire | 33001 | 2286 | 70 |
922218 | 922218 | 2021-01-12 | Carroll | New Hampshire | 33003 | 1097 | 4 |
922219 | 922219 | 2021-01-12 | Cheshire | New Hampshire | 33005 | 1688 | 7 |
922220 | 922220 | 2021-01-12 | Coos | New Hampshire | 33007 | 844 | 19 |
922221 | 922221 | 2021-01-12 | Grafton | New Hampshire | 33009 | 1416 | 9 |
922222 | 922222 | 2021-01-12 | Hillsborough | New Hampshire | 33011 | 21091 | 481 |
922223 | 922223 | 2021-01-12 | Merrimack | New Hampshire | 33013 | 5659 | 83 |
922224 | 922224 | 2021-01-12 | Rockingham | New Hampshire | 33015 | 12910 | 160 |
922225 | 922225 | 2021-01-12 | Strafford | New Hampshire | 33017 | 4424 | 39 |
922226 | 922226 | 2021-01-12 | Sullivan | New Hampshire | 33019 | 680 | 6 |
922227 | 922227 | 2021-01-12 | Unknown | New Hampshire | 1053 | 0 | |
918972 | 918972 | 2021-01-11 | Belknap | New Hampshire | 33001 | 2252 | 69 |
918973 | 918973 | 2021-01-11 | Carroll | New Hampshire | 33003 | 1079 | 4 |
918974 | 918974 | 2021-01-11 | Cheshire | New Hampshire | 33005 | 1631 | 7 |
918975 | 918975 | 2021-01-11 | Coos | New Hampshire | 33007 | 831 | 18 |
918976 | 918976 | 2021-01-11 | Grafton | New Hampshire | 33009 | 1385 | 9 |
918977 | 918977 | 2021-01-11 | Hillsborough | New Hampshire | 33011 | 20790 | 479 |
918978 | 918978 | 2021-01-11 | Merrimack | New Hampshire | 33013 | 5622 | 81 |
918979 | 918979 | 2021-01-11 | Rockingham | New Hampshire | 33015 | 12692 | 158 |
918980 | 918980 | 2021-01-11 | Strafford | New Hampshire | 33017 | 4341 | 38 |
918981 | 918981 | 2021-01-11 | Sullivan | New Hampshire | 33019 | 664 | 6 |
918982 | 918982 | 2021-01-11 | Unknown | New Hampshire | 1020 | 0 | |
915727 | 915727 | 2021-01-10 | Belknap | New Hampshire | 33001 | 2229 | 69 |
915728 | 915728 | 2021-01-10 | Carroll | New Hampshire | 33003 | 1057 | 4 |
915729 | 915729 | 2021-01-10 | Cheshire | New Hampshire | 33005 | 1589 | 7 |
915730 | 915730 | 2021-01-10 | Coos | New Hampshire | 33007 | 812 | 18 |
915731 | 915731 | 2021-01-10 | Grafton | New Hampshire | 33009 | 1368 | 9 |
915732 | 915732 | 2021-01-10 | Hillsborough | New Hampshire | 33011 | 20580 | 479 |
915733 | 915733 | 2021-01-10 | Merrimack | New Hampshire | 33013 | 5509 | 81 |
915734 | 915734 | 2021-01-10 | Rockingham | New Hampshire | 33015 | 12565 | 158 |
915735 | 915735 | 2021-01-10 | Strafford | New Hampshire | 33017 | 4271 | 38 |
915736 | 915736 | 2021-01-10 | Sullivan | New Hampshire | 33019 | 632 | 6 |
915737 | 915737 | 2021-01-10 | Unknown | New Hampshire | 988 | 0 | |
912482 | 912482 | 2021-01-09 | Belknap | New Hampshire | 33001 | 2210 | 68 |
912483 | 912483 | 2021-01-09 | Carroll | New Hampshire | 33003 | 1040 | 4 |
912484 | 912484 | 2021-01-09 | Cheshire | New Hampshire | 33005 | 1509 | 7 |
912485 | 912485 | 2021-01-09 | Coos | New Hampshire | 33007 | 804 | 17 |
912486 | 912486 | 2021-01-09 | Grafton | New Hampshire | 33009 | 1348 | 9 |
912487 | 912487 | 2021-01-09 | Hillsborough | New Hampshire | 33011 | 20329 | 477 |
912488 | 912488 | 2021-01-09 | Merrimack | New Hampshire | 33013 | 5443 | 80 |
912489 | 912489 | 2021-01-09 | Rockingham | New Hampshire | 33015 | 12424 | 156 |
912490 | 912490 | 2021-01-09 | Strafford | New Hampshire | 33017 | 4187 | 38 |
912491 | 912491 | 2021-01-09 | Sullivan | New Hampshire | 33019 | 604 | 6 |
912492 | 912492 | 2021-01-09 | Unknown | New Hampshire | 973 | 0 | |
909237 | 909237 | 2021-01-08 | Belknap | New Hampshire | 33001 | 2178 | 63 |
909238 | 909238 | 2021-01-08 | Carroll | New Hampshire | 33003 | 1034 | 4 |
909239 | 909239 | 2021-01-08 | Cheshire | New Hampshire | 33005 | 1494 | 7 |
909240 | 909240 | 2021-01-08 | Coos | New Hampshire | 33007 | 797 | 16 |
909241 | 909241 | 2021-01-08 | Grafton | New Hampshire | 33009 | 1332 | 9 |
909242 | 909242 | 2021-01-08 | Hillsborough | New Hampshire | 33011 | 19989 | 472 |
909243 | 909243 | 2021-01-08 | Merrimack | New Hampshire | 33013 | 5388 | 78 |
909244 | 909244 | 2021-01-08 | Rockingham | New Hampshire | 33015 | 12243 | 155 |
909245 | 909245 | 2021-01-08 | Strafford | New Hampshire | 33017 | 4108 | 35 |
909246 | 909246 | 2021-01-08 | Sullivan | New Hampshire | 33019 | 588 | 6 |
909247 | 909247 | 2021-01-08 | Unknown | New Hampshire | 1001 | 1 | |
905991 | 905991 | 2021-01-07 | Belknap | New Hampshire | 33001 | 2136 | 58 |
905992 | 905992 | 2021-01-07 | Carroll | New Hampshire | 33003 | 1019 | 4 |
905993 | 905993 | 2021-01-07 | Cheshire | New Hampshire | 33005 | 1435 | 7 |
905994 | 905994 | 2021-01-07 | Coos | New Hampshire | 33007 | 774 | 16 |
905995 | 905995 | 2021-01-07 | Grafton | New Hampshire | 33009 | 1294 | 9 |
905996 | 905996 | 2021-01-07 | Hillsborough | New Hampshire | 33011 | 19618 | 464 |
905997 | 905997 | 2021-01-07 | Merrimack | New Hampshire | 33013 | 5322 | 75 |
905998 | 905998 | 2021-01-07 | Rockingham | New Hampshire | 33015 | 12090 | 152 |
905999 | 905999 | 2021-01-07 | Strafford | New Hampshire | 33017 | 4024 | 35 |
906000 | 906000 | 2021-01-07 | Sullivan | New Hampshire | 33019 | 552 | 6 |
906001 | 906001 | 2021-01-07 | Unknown | New Hampshire | 997 | 1 | |
902746 | 902746 | 2021-01-06 | Belknap | New Hampshire | 33001 | 2120 | 54 |
902747 | 902747 | 2021-01-06 | Carroll | New Hampshire | 33003 | 1001 | 4 |
902748 | 902748 | 2021-01-06 | Cheshire | New Hampshire | 33005 | 1421 | 7 |
902749 | 902749 | 2021-01-06 | Coos | New Hampshire | 33007 | 765 | 15 |
902750 | 902750 | 2021-01-06 | Grafton | New Hampshire | 33009 | 1282 | 9 |
902751 | 902751 | 2021-01-06 | Hillsborough | New Hampshire | 33011 | 19479 | 461 |
902752 | 902752 | 2021-01-06 | Merrimack | New Hampshire | 33013 | 5253 | 73 |
902753 | 902753 | 2021-01-06 | Rockingham | New Hampshire | 33015 | 11996 | 151 |
902754 | 902754 | 2021-01-06 | Strafford | New Hampshire | 33017 | 3973 | 35 |
902755 | 902755 | 2021-01-06 | Sullivan | New Hampshire | 33019 | 548 | 6 |
902756 | 902756 | 2021-01-06 | Unknown | New Hampshire | 1000 | 1 | |
899501 | 899501 | 2021-01-05 | Belknap | New Hampshire | 33001 | 2085 | 52 |
899502 | 899502 | 2021-01-05 | Carroll | New Hampshire | 33003 | 991 | 4 |
899503 | 899503 | 2021-01-05 | Cheshire | New Hampshire | 33005 | 1404 | 7 |
899504 | 899504 | 2021-01-05 | Coos | New Hampshire | 33007 | 734 | 15 |
899505 | 899505 | 2021-01-05 | Grafton | New Hampshire | 33009 | 1247 | 9 |
899506 | 899506 | 2021-01-05 | Hillsborough | New Hampshire | 33011 | 19166 | 452 |
899507 | 899507 | 2021-01-05 | Merrimack | New Hampshire | 33013 | 5188 | 69 |
899508 | 899508 | 2021-01-05 | Rockingham | New Hampshire | 33015 | 11776 | 145 |
899509 | 899509 | 2021-01-05 | Strafford | New Hampshire | 33017 | 3899 | 32 |
899510 | 899510 | 2021-01-05 | Sullivan | New Hampshire | 33019 | 523 | 6 |
899511 | 899511 | 2021-01-05 | Unknown | New Hampshire | 979 | 1 | |
896256 | 896256 | 2021-01-04 | Belknap | New Hampshire | 33001 | 2069 | 52 |
896257 | 896257 | 2021-01-04 | Carroll | New Hampshire | 33003 | 955 | 4 |
896258 | 896258 | 2021-01-04 | Cheshire | New Hampshire | 33005 | 1392 | 7 |
896259 | 896259 | 2021-01-04 | Coos | New Hampshire | 33007 | 723 | 15 |
896260 | 896260 | 2021-01-04 | Grafton | New Hampshire | 33009 | 1228 | 9 |
896261 | 896261 | 2021-01-04 | Hillsborough | New Hampshire | 33011 | 18954 | 445 |
896262 | 896262 | 2021-01-04 | Merrimack | New Hampshire | 33013 | 5121 | 68 |
896263 | 896263 | 2021-01-04 | Rockingham | New Hampshire | 33015 | 11581 | 142 |
896264 | 896264 | 2021-01-04 | Strafford | New Hampshire | 33017 | 3834 | 32 |
896265 | 896265 | 2021-01-04 | Sullivan | New Hampshire | 33019 | 509 | 6 |
896266 | 896266 | 2021-01-04 | Unknown | New Hampshire | 962 | 1 | |
893009 | 893009 | 2021-01-03 | Belknap | New Hampshire | 33001 | 2044 | 52 |
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);