ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 16 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
state 1
- New Hampshire · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2032905 | 2032905 | 2021-12-20 | Unknown | New Hampshire | 2628 | 16 | |
2029654 | 2029654 | 2021-12-19 | Unknown | New Hampshire | 2448 | 16 | |
2026403 | 2026403 | 2021-12-18 | Unknown | New Hampshire | 2448 | 16 | |
2023152 | 2023152 | 2021-12-17 | Unknown | New Hampshire | 2448 | 16 | |
2019901 | 2019901 | 2021-12-16 | Unknown | New Hampshire | 2360 | 16 | |
1714427 | 1714427 | 2021-09-13 | Carroll | New Hampshire | 33003 | 3001 | 16 |
1711181 | 1711181 | 2021-09-12 | Carroll | New Hampshire | 33003 | 2947 | 16 |
1707934 | 1707934 | 2021-09-11 | Carroll | New Hampshire | 33003 | 2947 | 16 |
1704687 | 1704687 | 2021-09-10 | Carroll | New Hampshire | 33003 | 2947 | 16 |
1701437 | 1701437 | 2021-09-09 | Carroll | New Hampshire | 33003 | 2921 | 16 |
1698188 | 1698188 | 2021-09-08 | Carroll | New Hampshire | 33003 | 2893 | 16 |
1694940 | 1694940 | 2021-09-07 | Carroll | New Hampshire | 33003 | 2885 | 16 |
1691691 | 1691691 | 2021-09-06 | Carroll | New Hampshire | 33003 | 2848 | 16 |
1688441 | 1688441 | 2021-09-05 | Carroll | New Hampshire | 33003 | 2848 | 16 |
1685191 | 1685191 | 2021-09-04 | Carroll | New Hampshire | 33003 | 2848 | 16 |
1681940 | 1681940 | 2021-09-03 | Carroll | New Hampshire | 33003 | 2848 | 16 |
1009852 | 1009852 | 2021-02-08 | Grafton | New Hampshire | 33009 | 2126 | 16 |
1006605 | 1006605 | 2021-02-07 | Grafton | New Hampshire | 33009 | 2120 | 16 |
1003359 | 1003359 | 2021-02-06 | Grafton | New Hampshire | 33009 | 2097 | 16 |
1000114 | 1000114 | 2021-02-05 | Grafton | New Hampshire | 33009 | 2074 | 16 |
996868 | 996868 | 2021-02-04 | Grafton | New Hampshire | 33009 | 2036 | 16 |
993627 | 993627 | 2021-02-03 | Sullivan | New Hampshire | 33019 | 1142 | 16 |
990381 | 990381 | 2021-02-02 | Sullivan | New Hampshire | 33019 | 1132 | 16 |
987134 | 987134 | 2021-02-01 | Sullivan | New Hampshire | 33019 | 1116 | 16 |
983887 | 983887 | 2021-01-31 | Sullivan | New Hampshire | 33019 | 1109 | 16 |
980641 | 980641 | 2021-01-30 | Sullivan | New Hampshire | 33019 | 1091 | 16 |
977388 | 977388 | 2021-01-29 | Cheshire | New Hampshire | 33005 | 2209 | 16 |
977395 | 977395 | 2021-01-29 | Sullivan | New Hampshire | 33019 | 1066 | 16 |
909240 | 909240 | 2021-01-08 | Coos | New Hampshire | 33007 | 797 | 16 |
905994 | 905994 | 2021-01-07 | Coos | New Hampshire | 33007 | 774 | 16 |
798900 | 798900 | 2020-12-05 | Strafford | New Hampshire | 33017 | 1805 | 16 |
795655 | 795655 | 2020-12-04 | Strafford | New Hampshire | 33017 | 1781 | 16 |
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);