ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 15 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 9
- Coos 19
- Strafford 9
- Rockingham 5
- Hillsborough 4
- Unknown 2
- Belknap 1
- Cheshire 1
- Grafton 1
- Merrimack 1
state 1
- New Hampshire · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2016651 | 2016651 | 2021-12-15 | Unknown | New Hampshire | 2293 | 15 | |
2013400 | 2013400 | 2021-12-14 | Unknown | New Hampshire | 2262 | 15 | |
990376 | 990376 | 2021-02-02 | Grafton | New Hampshire | 33009 | 1989 | 15 |
974143 | 974143 | 2021-01-28 | Cheshire | New Hampshire | 33005 | 2186 | 15 |
902749 | 902749 | 2021-01-06 | Coos | New Hampshire | 33007 | 765 | 15 |
899504 | 899504 | 2021-01-05 | Coos | New Hampshire | 33007 | 734 | 15 |
896259 | 896259 | 2021-01-04 | Coos | New Hampshire | 33007 | 723 | 15 |
893012 | 893012 | 2021-01-03 | Coos | New Hampshire | 33007 | 715 | 15 |
889766 | 889766 | 2021-01-02 | Coos | New Hampshire | 33007 | 694 | 15 |
886520 | 886520 | 2021-01-01 | Coos | New Hampshire | 33007 | 662 | 15 |
883275 | 883275 | 2020-12-31 | Coos | New Hampshire | 33007 | 662 | 15 |
880030 | 880030 | 2020-12-30 | Coos | New Hampshire | 33007 | 640 | 15 |
876785 | 876785 | 2020-12-29 | Coos | New Hampshire | 33007 | 632 | 15 |
873540 | 873540 | 2020-12-28 | Coos | New Hampshire | 33007 | 614 | 15 |
870295 | 870295 | 2020-12-27 | Coos | New Hampshire | 33007 | 586 | 15 |
867050 | 867050 | 2020-12-26 | Coos | New Hampshire | 33007 | 575 | 15 |
863805 | 863805 | 2020-12-25 | Coos | New Hampshire | 33007 | 516 | 15 |
860560 | 860560 | 2020-12-24 | Coos | New Hampshire | 33007 | 516 | 15 |
857315 | 857315 | 2020-12-23 | Coos | New Hampshire | 33007 | 513 | 15 |
854070 | 854070 | 2020-12-22 | Coos | New Hampshire | 33007 | 507 | 15 |
850825 | 850825 | 2020-12-21 | Coos | New Hampshire | 33007 | 500 | 15 |
847580 | 847580 | 2020-12-20 | Coos | New Hampshire | 33007 | 488 | 15 |
844334 | 844334 | 2020-12-19 | Coos | New Hampshire | 33007 | 470 | 15 |
792410 | 792410 | 2020-12-03 | Strafford | New Hampshire | 33017 | 1726 | 15 |
789157 | 789157 | 2020-12-02 | Belknap | New Hampshire | 33001 | 815 | 15 |
789165 | 789165 | 2020-12-02 | Strafford | New Hampshire | 33017 | 1682 | 15 |
785920 | 785920 | 2020-12-01 | Strafford | New Hampshire | 33017 | 1649 | 15 |
782676 | 782676 | 2020-11-30 | Strafford | New Hampshire | 33017 | 1611 | 15 |
779430 | 779430 | 2020-11-29 | Strafford | New Hampshire | 33017 | 1585 | 15 |
776185 | 776185 | 2020-11-28 | Strafford | New Hampshire | 33017 | 1558 | 15 |
772940 | 772940 | 2020-11-27 | Strafford | New Hampshire | 33017 | 1523 | 15 |
769695 | 769695 | 2020-11-26 | Strafford | New Hampshire | 33017 | 1494 | 15 |
766449 | 766449 | 2020-11-25 | Strafford | New Hampshire | 33017 | 1494 | 15 |
201603 | 201603 | 2020-06-02 | Merrimack | New Hampshire | 33013 | 352 | 15 |
96915 | 96915 | 2020-04-28 | Rockingham | New Hampshire | 33015 | 664 | 15 |
94079 | 94079 | 2020-04-27 | Rockingham | New Hampshire | 33015 | 643 | 15 |
91255 | 91255 | 2020-04-26 | Rockingham | New Hampshire | 33015 | 619 | 15 |
88440 | 88440 | 2020-04-25 | Rockingham | New Hampshire | 33015 | 593 | 15 |
85629 | 85629 | 2020-04-24 | Rockingham | New Hampshire | 33015 | 568 | 15 |
55275 | 55275 | 2020-04-13 | Hillsborough | New Hampshire | 33011 | 398 | 15 |
52592 | 52592 | 2020-04-12 | Hillsborough | New Hampshire | 33011 | 385 | 15 |
49919 | 49919 | 2020-04-11 | Hillsborough | New Hampshire | 33011 | 367 | 15 |
47266 | 47266 | 2020-04-10 | Hillsborough | New Hampshire | 33011 | 344 | 15 |
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);