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 |
---|---|---|---|---|---|---|---|
536194 | 536194 | 2020-09-15 | Belknap | New Hampshire | 33001 | 135 | 4 |
536195 | 536195 | 2020-09-15 | Carroll | New Hampshire | 33003 | 117 | 2 |
536196 | 536196 | 2020-09-15 | Cheshire | New Hampshire | 33005 | 142 | 3 |
536197 | 536197 | 2020-09-15 | Coos | New Hampshire | 33007 | 21 | 0 |
536198 | 536198 | 2020-09-15 | Grafton | New Hampshire | 33009 | 129 | 1 |
536199 | 536199 | 2020-09-15 | Hillsborough | New Hampshire | 33011 | 4219 | 288 |
536200 | 536200 | 2020-09-15 | Merrimack | New Hampshire | 33013 | 540 | 23 |
536201 | 536201 | 2020-09-15 | Rockingham | New Hampshire | 33015 | 1932 | 103 |
536202 | 536202 | 2020-09-15 | Strafford | New Hampshire | 33017 | 463 | 13 |
536203 | 536203 | 2020-09-15 | Sullivan | New Hampshire | 33019 | 49 | 1 |
536204 | 536204 | 2020-09-15 | Unknown | New Hampshire | 1 | 0 | |
532959 | 532959 | 2020-09-14 | Belknap | New Hampshire | 33001 | 134 | 4 |
532960 | 532960 | 2020-09-14 | Carroll | New Hampshire | 33003 | 116 | 2 |
532961 | 532961 | 2020-09-14 | Cheshire | New Hampshire | 33005 | 141 | 3 |
532962 | 532962 | 2020-09-14 | Coos | New Hampshire | 33007 | 21 | 0 |
532963 | 532963 | 2020-09-14 | Grafton | New Hampshire | 33009 | 128 | 1 |
532964 | 532964 | 2020-09-14 | Hillsborough | New Hampshire | 33011 | 4207 | 288 |
532965 | 532965 | 2020-09-14 | Merrimack | New Hampshire | 33013 | 535 | 23 |
532966 | 532966 | 2020-09-14 | Rockingham | New Hampshire | 33015 | 1922 | 101 |
532967 | 532967 | 2020-09-14 | Strafford | New Hampshire | 33017 | 458 | 13 |
532968 | 532968 | 2020-09-14 | Sullivan | New Hampshire | 33019 | 49 | 1 |
532969 | 532969 | 2020-09-14 | Unknown | New Hampshire | 3 | 0 | |
529723 | 529723 | 2020-09-13 | Belknap | New Hampshire | 33001 | 133 | 4 |
529724 | 529724 | 2020-09-13 | Carroll | New Hampshire | 33003 | 116 | 2 |
529725 | 529725 | 2020-09-13 | Cheshire | New Hampshire | 33005 | 141 | 3 |
529726 | 529726 | 2020-09-13 | Coos | New Hampshire | 33007 | 21 | 0 |
529727 | 529727 | 2020-09-13 | Grafton | New Hampshire | 33009 | 127 | 1 |
529728 | 529728 | 2020-09-13 | Hillsborough | New Hampshire | 33011 | 4196 | 288 |
529729 | 529729 | 2020-09-13 | Merrimack | New Hampshire | 33013 | 534 | 23 |
529730 | 529730 | 2020-09-13 | Rockingham | New Hampshire | 33015 | 1919 | 101 |
529731 | 529731 | 2020-09-13 | Strafford | New Hampshire | 33017 | 457 | 13 |
529732 | 529732 | 2020-09-13 | Sullivan | New Hampshire | 33019 | 49 | 1 |
529733 | 529733 | 2020-09-13 | Unknown | New Hampshire | 3 | 0 | |
526487 | 526487 | 2020-09-12 | Belknap | New Hampshire | 33001 | 130 | 4 |
526488 | 526488 | 2020-09-12 | Carroll | New Hampshire | 33003 | 116 | 1 |
526489 | 526489 | 2020-09-12 | Cheshire | New Hampshire | 33005 | 140 | 3 |
526490 | 526490 | 2020-09-12 | Coos | New Hampshire | 33007 | 20 | 0 |
526491 | 526491 | 2020-09-12 | Grafton | New Hampshire | 33009 | 126 | 1 |
526492 | 526492 | 2020-09-12 | Hillsborough | New Hampshire | 33011 | 4180 | 288 |
526493 | 526493 | 2020-09-12 | Merrimack | New Hampshire | 33013 | 532 | 23 |
526494 | 526494 | 2020-09-12 | Rockingham | New Hampshire | 33015 | 1905 | 101 |
526495 | 526495 | 2020-09-12 | Strafford | New Hampshire | 33017 | 453 | 13 |
526496 | 526496 | 2020-09-12 | Sullivan | New Hampshire | 33019 | 49 | 1 |
526497 | 526497 | 2020-09-12 | Unknown | New Hampshire | 1 | 0 | |
523251 | 523251 | 2020-09-11 | Belknap | New Hampshire | 33001 | 130 | 4 |
523252 | 523252 | 2020-09-11 | Carroll | New Hampshire | 33003 | 114 | 1 |
523253 | 523253 | 2020-09-11 | Cheshire | New Hampshire | 33005 | 140 | 3 |
523254 | 523254 | 2020-09-11 | Coos | New Hampshire | 33007 | 20 | 0 |
523255 | 523255 | 2020-09-11 | Grafton | New Hampshire | 33009 | 126 | 1 |
523256 | 523256 | 2020-09-11 | Hillsborough | New Hampshire | 33011 | 4171 | 288 |
523257 | 523257 | 2020-09-11 | Merrimack | New Hampshire | 33013 | 528 | 23 |
523258 | 523258 | 2020-09-11 | Rockingham | New Hampshire | 33015 | 1895 | 100 |
523259 | 523259 | 2020-09-11 | Strafford | New Hampshire | 33017 | 446 | 13 |
523260 | 523260 | 2020-09-11 | Sullivan | New Hampshire | 33019 | 49 | 1 |
523261 | 523261 | 2020-09-11 | Unknown | New Hampshire | 1 | 0 | |
520014 | 520014 | 2020-09-10 | Belknap | New Hampshire | 33001 | 128 | 4 |
520015 | 520015 | 2020-09-10 | Carroll | New Hampshire | 33003 | 112 | 1 |
520016 | 520016 | 2020-09-10 | Cheshire | New Hampshire | 33005 | 140 | 3 |
520017 | 520017 | 2020-09-10 | Coos | New Hampshire | 33007 | 20 | 0 |
520018 | 520018 | 2020-09-10 | Grafton | New Hampshire | 33009 | 125 | 1 |
520019 | 520019 | 2020-09-10 | Hillsborough | New Hampshire | 33011 | 4158 | 288 |
520020 | 520020 | 2020-09-10 | Merrimack | New Hampshire | 33013 | 522 | 23 |
520021 | 520021 | 2020-09-10 | Rockingham | New Hampshire | 33015 | 1877 | 100 |
520022 | 520022 | 2020-09-10 | Strafford | New Hampshire | 33017 | 439 | 13 |
520023 | 520023 | 2020-09-10 | Sullivan | New Hampshire | 33019 | 49 | 1 |
520024 | 520024 | 2020-09-10 | Unknown | New Hampshire | 3 | 0 | |
516779 | 516779 | 2020-09-09 | Belknap | New Hampshire | 33001 | 127 | 4 |
516780 | 516780 | 2020-09-09 | Carroll | New Hampshire | 33003 | 112 | 1 |
516781 | 516781 | 2020-09-09 | Cheshire | New Hampshire | 33005 | 140 | 3 |
516782 | 516782 | 2020-09-09 | Coos | New Hampshire | 33007 | 20 | 0 |
516783 | 516783 | 2020-09-09 | Grafton | New Hampshire | 33009 | 123 | 1 |
516784 | 516784 | 2020-09-09 | Hillsborough | New Hampshire | 33011 | 4133 | 287 |
516785 | 516785 | 2020-09-09 | Merrimack | New Hampshire | 33013 | 517 | 23 |
516786 | 516786 | 2020-09-09 | Rockingham | New Hampshire | 33015 | 1865 | 100 |
516787 | 516787 | 2020-09-09 | Strafford | New Hampshire | 33017 | 429 | 13 |
516788 | 516788 | 2020-09-09 | Sullivan | New Hampshire | 33019 | 49 | 1 |
516789 | 516789 | 2020-09-09 | Unknown | New Hampshire | 2 | 0 | |
513545 | 513545 | 2020-09-08 | Belknap | New Hampshire | 33001 | 126 | 4 |
513546 | 513546 | 2020-09-08 | Carroll | New Hampshire | 33003 | 111 | 1 |
513547 | 513547 | 2020-09-08 | Cheshire | New Hampshire | 33005 | 140 | 3 |
513548 | 513548 | 2020-09-08 | Coos | New Hampshire | 33007 | 20 | 0 |
513549 | 513549 | 2020-09-08 | Grafton | New Hampshire | 33009 | 122 | 1 |
513550 | 513550 | 2020-09-08 | Hillsborough | New Hampshire | 33011 | 4121 | 287 |
513551 | 513551 | 2020-09-08 | Merrimack | New Hampshire | 33013 | 518 | 23 |
513552 | 513552 | 2020-09-08 | Rockingham | New Hampshire | 33015 | 1858 | 100 |
513553 | 513553 | 2020-09-08 | Strafford | New Hampshire | 33017 | 427 | 13 |
513554 | 513554 | 2020-09-08 | Sullivan | New Hampshire | 33019 | 48 | 1 |
513555 | 513555 | 2020-09-08 | Unknown | New Hampshire | 3 | 0 | |
510312 | 510312 | 2020-09-07 | Belknap | New Hampshire | 33001 | 126 | 4 |
510313 | 510313 | 2020-09-07 | Carroll | New Hampshire | 33003 | 111 | 1 |
510314 | 510314 | 2020-09-07 | Cheshire | New Hampshire | 33005 | 138 | 3 |
510315 | 510315 | 2020-09-07 | Coos | New Hampshire | 33007 | 20 | 0 |
510316 | 510316 | 2020-09-07 | Grafton | New Hampshire | 33009 | 120 | 1 |
510317 | 510317 | 2020-09-07 | Hillsborough | New Hampshire | 33011 | 4121 | 287 |
510318 | 510318 | 2020-09-07 | Merrimack | New Hampshire | 33013 | 517 | 23 |
510319 | 510319 | 2020-09-07 | Rockingham | New Hampshire | 33015 | 1847 | 100 |
510320 | 510320 | 2020-09-07 | Strafford | New Hampshire | 33017 | 426 | 13 |
510321 | 510321 | 2020-09-07 | Sullivan | New Hampshire | 33019 | 48 | 1 |
510322 | 510322 | 2020-09-07 | Unknown | New Hampshire | 2 | 0 | |
507079 | 507079 | 2020-09-06 | Belknap | New Hampshire | 33001 | 126 | 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);