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 |
---|---|---|---|---|---|---|---|
636664 | 636664 | 2020-10-16 | Belknap | New Hampshire | 33001 | 186 | 5 |
636665 | 636665 | 2020-10-16 | Carroll | New Hampshire | 33003 | 134 | 2 |
636666 | 636666 | 2020-10-16 | Cheshire | New Hampshire | 33005 | 171 | 3 |
636667 | 636667 | 2020-10-16 | Coos | New Hampshire | 33007 | 29 | 0 |
636668 | 636668 | 2020-10-16 | Grafton | New Hampshire | 33009 | 176 | 1 |
636669 | 636669 | 2020-10-16 | Hillsborough | New Hampshire | 33011 | 5040 | 310 |
636670 | 636670 | 2020-10-16 | Merrimack | New Hampshire | 33013 | 733 | 24 |
636671 | 636671 | 2020-10-16 | Rockingham | New Hampshire | 33015 | 2332 | 105 |
636672 | 636672 | 2020-10-16 | Strafford | New Hampshire | 33017 | 640 | 14 |
636673 | 636673 | 2020-10-16 | Sullivan | New Hampshire | 33019 | 67 | 1 |
636674 | 636674 | 2020-10-16 | Unknown | New Hampshire | 6 | 0 | |
633418 | 633418 | 2020-10-15 | Belknap | New Hampshire | 33001 | 185 | 5 |
633419 | 633419 | 2020-10-15 | Carroll | New Hampshire | 33003 | 134 | 2 |
633420 | 633420 | 2020-10-15 | Cheshire | New Hampshire | 33005 | 167 | 3 |
633421 | 633421 | 2020-10-15 | Coos | New Hampshire | 33007 | 28 | 0 |
633422 | 633422 | 2020-10-15 | Grafton | New Hampshire | 33009 | 174 | 1 |
633423 | 633423 | 2020-10-15 | Hillsborough | New Hampshire | 33011 | 4999 | 308 |
633424 | 633424 | 2020-10-15 | Merrimack | New Hampshire | 33013 | 718 | 24 |
633425 | 633425 | 2020-10-15 | Rockingham | New Hampshire | 33015 | 2313 | 105 |
633426 | 633426 | 2020-10-15 | Strafford | New Hampshire | 33017 | 634 | 14 |
633427 | 633427 | 2020-10-15 | Sullivan | New Hampshire | 33019 | 66 | 1 |
633428 | 633428 | 2020-10-15 | Unknown | New Hampshire | 8 | 0 | |
630173 | 630173 | 2020-10-14 | Belknap | New Hampshire | 33001 | 182 | 5 |
630174 | 630174 | 2020-10-14 | Carroll | New Hampshire | 33003 | 133 | 2 |
630175 | 630175 | 2020-10-14 | Cheshire | New Hampshire | 33005 | 166 | 3 |
630176 | 630176 | 2020-10-14 | Coos | New Hampshire | 33007 | 23 | 0 |
630177 | 630177 | 2020-10-14 | Grafton | New Hampshire | 33009 | 172 | 1 |
630178 | 630178 | 2020-10-14 | Hillsborough | New Hampshire | 33011 | 4971 | 304 |
630179 | 630179 | 2020-10-14 | Merrimack | New Hampshire | 33013 | 707 | 24 |
630180 | 630180 | 2020-10-14 | Rockingham | New Hampshire | 33015 | 2289 | 104 |
630181 | 630181 | 2020-10-14 | Strafford | New Hampshire | 33017 | 633 | 14 |
630182 | 630182 | 2020-10-14 | Sullivan | New Hampshire | 33019 | 65 | 1 |
630183 | 630183 | 2020-10-14 | Unknown | New Hampshire | 8 | 0 | |
626929 | 626929 | 2020-10-13 | Belknap | New Hampshire | 33001 | 181 | 5 |
626930 | 626930 | 2020-10-13 | Carroll | New Hampshire | 33003 | 133 | 2 |
626931 | 626931 | 2020-10-13 | Cheshire | New Hampshire | 33005 | 162 | 3 |
626932 | 626932 | 2020-10-13 | Coos | New Hampshire | 33007 | 23 | 0 |
626933 | 626933 | 2020-10-13 | Grafton | New Hampshire | 33009 | 170 | 1 |
626934 | 626934 | 2020-10-13 | Hillsborough | New Hampshire | 33011 | 4939 | 303 |
626935 | 626935 | 2020-10-13 | Merrimack | New Hampshire | 33013 | 698 | 24 |
626936 | 626936 | 2020-10-13 | Rockingham | New Hampshire | 33015 | 2268 | 104 |
626937 | 626937 | 2020-10-13 | Strafford | New Hampshire | 33017 | 630 | 13 |
626938 | 626938 | 2020-10-13 | Sullivan | New Hampshire | 33019 | 65 | 1 |
626939 | 626939 | 2020-10-13 | Unknown | New Hampshire | 10 | 0 | |
623687 | 623687 | 2020-10-12 | Belknap | New Hampshire | 33001 | 181 | 5 |
623688 | 623688 | 2020-10-12 | Carroll | New Hampshire | 33003 | 132 | 2 |
623689 | 623689 | 2020-10-12 | Cheshire | New Hampshire | 33005 | 161 | 3 |
623690 | 623690 | 2020-10-12 | Coos | New Hampshire | 33007 | 23 | 0 |
623691 | 623691 | 2020-10-12 | Grafton | New Hampshire | 33009 | 169 | 1 |
623692 | 623692 | 2020-10-12 | Hillsborough | New Hampshire | 33011 | 4910 | 303 |
623693 | 623693 | 2020-10-12 | Merrimack | New Hampshire | 33013 | 690 | 24 |
623694 | 623694 | 2020-10-12 | Rockingham | New Hampshire | 33015 | 2247 | 104 |
623695 | 623695 | 2020-10-12 | Strafford | New Hampshire | 33017 | 622 | 13 |
623696 | 623696 | 2020-10-12 | Sullivan | New Hampshire | 33019 | 65 | 1 |
623697 | 623697 | 2020-10-12 | Unknown | New Hampshire | 8 | 0 | |
620444 | 620444 | 2020-10-11 | Belknap | New Hampshire | 33001 | 175 | 5 |
620445 | 620445 | 2020-10-11 | Carroll | New Hampshire | 33003 | 133 | 2 |
620446 | 620446 | 2020-10-11 | Cheshire | New Hampshire | 33005 | 159 | 3 |
620447 | 620447 | 2020-10-11 | Coos | New Hampshire | 33007 | 22 | 0 |
620448 | 620448 | 2020-10-11 | Grafton | New Hampshire | 33009 | 165 | 1 |
620449 | 620449 | 2020-10-11 | Hillsborough | New Hampshire | 33011 | 4887 | 303 |
620450 | 620450 | 2020-10-11 | Merrimack | New Hampshire | 33013 | 689 | 24 |
620451 | 620451 | 2020-10-11 | Rockingham | New Hampshire | 33015 | 2224 | 104 |
620452 | 620452 | 2020-10-11 | Strafford | New Hampshire | 33017 | 618 | 13 |
620453 | 620453 | 2020-10-11 | Sullivan | New Hampshire | 33019 | 65 | 1 |
620454 | 620454 | 2020-10-11 | Unknown | New Hampshire | 6 | 0 | |
617202 | 617202 | 2020-10-10 | Belknap | New Hampshire | 33001 | 172 | 5 |
617203 | 617203 | 2020-10-10 | Carroll | New Hampshire | 33003 | 133 | 2 |
617204 | 617204 | 2020-10-10 | Cheshire | New Hampshire | 33005 | 159 | 3 |
617205 | 617205 | 2020-10-10 | Coos | New Hampshire | 33007 | 22 | 0 |
617206 | 617206 | 2020-10-10 | Grafton | New Hampshire | 33009 | 164 | 1 |
617207 | 617207 | 2020-10-10 | Hillsborough | New Hampshire | 33011 | 4866 | 302 |
617208 | 617208 | 2020-10-10 | Merrimack | New Hampshire | 33013 | 684 | 24 |
617209 | 617209 | 2020-10-10 | Rockingham | New Hampshire | 33015 | 2210 | 104 |
617210 | 617210 | 2020-10-10 | Strafford | New Hampshire | 33017 | 608 | 13 |
617211 | 617211 | 2020-10-10 | Sullivan | New Hampshire | 33019 | 65 | 1 |
617212 | 617212 | 2020-10-10 | Unknown | New Hampshire | 9 | 0 | |
613960 | 613960 | 2020-10-09 | Belknap | New Hampshire | 33001 | 170 | 4 |
613961 | 613961 | 2020-10-09 | Carroll | New Hampshire | 33003 | 133 | 2 |
613962 | 613962 | 2020-10-09 | Cheshire | New Hampshire | 33005 | 159 | 3 |
613963 | 613963 | 2020-10-09 | Coos | New Hampshire | 33007 | 22 | 0 |
613964 | 613964 | 2020-10-09 | Grafton | New Hampshire | 33009 | 159 | 1 |
613965 | 613965 | 2020-10-09 | Hillsborough | New Hampshire | 33011 | 4820 | 298 |
613966 | 613966 | 2020-10-09 | Merrimack | New Hampshire | 33013 | 644 | 24 |
613967 | 613967 | 2020-10-09 | Rockingham | New Hampshire | 33015 | 2189 | 104 |
613968 | 613968 | 2020-10-09 | Strafford | New Hampshire | 33017 | 603 | 13 |
613969 | 613969 | 2020-10-09 | Sullivan | New Hampshire | 33019 | 64 | 1 |
613970 | 613970 | 2020-10-09 | Unknown | New Hampshire | 7 | 0 | |
610719 | 610719 | 2020-10-08 | Belknap | New Hampshire | 33001 | 166 | 4 |
610720 | 610720 | 2020-10-08 | Carroll | New Hampshire | 33003 | 130 | 2 |
610721 | 610721 | 2020-10-08 | Cheshire | New Hampshire | 33005 | 155 | 3 |
610722 | 610722 | 2020-10-08 | Coos | New Hampshire | 33007 | 22 | 0 |
610723 | 610723 | 2020-10-08 | Grafton | New Hampshire | 33009 | 157 | 1 |
610724 | 610724 | 2020-10-08 | Hillsborough | New Hampshire | 33011 | 4775 | 296 |
610725 | 610725 | 2020-10-08 | Merrimack | New Hampshire | 33013 | 630 | 24 |
610726 | 610726 | 2020-10-08 | Rockingham | New Hampshire | 33015 | 2175 | 104 |
610727 | 610727 | 2020-10-08 | Strafford | New Hampshire | 33017 | 603 | 13 |
610728 | 610728 | 2020-10-08 | Sullivan | New Hampshire | 33019 | 63 | 1 |
610729 | 610729 | 2020-10-08 | Unknown | New Hampshire | 2 | 0 | |
607477 | 607477 | 2020-10-07 | Belknap | New Hampshire | 33001 | 166 | 4 |
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);