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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
448 | 448 | 2020-03-02 | Grafton | New Hampshire | 33009 | 1 | 0 |
482 | 482 | 2020-03-03 | Grafton | New Hampshire | 33009 | 2 | 0 |
517 | 517 | 2020-03-04 | Grafton | New Hampshire | 33009 | 2 | 0 |
563 | 563 | 2020-03-05 | Grafton | New Hampshire | 33009 | 2 | 0 |
624 | 624 | 2020-03-06 | Grafton | New Hampshire | 33009 | 2 | 0 |
711 | 711 | 2020-03-07 | Grafton | New Hampshire | 33009 | 3 | 0 |
712 | 712 | 2020-03-07 | Rockingham | New Hampshire | 33015 | 1 | 0 |
815 | 815 | 2020-03-08 | Grafton | New Hampshire | 33009 | 3 | 0 |
816 | 816 | 2020-03-08 | Rockingham | New Hampshire | 33015 | 1 | 0 |
939 | 939 | 2020-03-09 | Grafton | New Hampshire | 33009 | 3 | 0 |
940 | 940 | 2020-03-09 | Rockingham | New Hampshire | 33015 | 1 | 0 |
1089 | 1089 | 2020-03-10 | Grafton | New Hampshire | 33009 | 3 | 0 |
1090 | 1090 | 2020-03-10 | Rockingham | New Hampshire | 33015 | 2 | 0 |
1271 | 1271 | 2020-03-11 | Grafton | New Hampshire | 33009 | 3 | 0 |
1272 | 1272 | 2020-03-11 | Rockingham | New Hampshire | 33015 | 2 | 0 |
1500 | 1500 | 2020-03-12 | Grafton | New Hampshire | 33009 | 3 | 0 |
1501 | 1501 | 2020-03-12 | Rockingham | New Hampshire | 33015 | 3 | 0 |
1792 | 1792 | 2020-03-13 | Grafton | New Hampshire | 33009 | 3 | 0 |
1793 | 1793 | 2020-03-13 | Rockingham | New Hampshire | 33015 | 4 | 0 |
2138 | 2138 | 2020-03-14 | Grafton | New Hampshire | 33009 | 3 | 0 |
2139 | 2139 | 2020-03-14 | Rockingham | New Hampshire | 33015 | 4 | 0 |
2545 | 2545 | 2020-03-15 | Grafton | New Hampshire | 33009 | 3 | 0 |
2546 | 2546 | 2020-03-15 | Hillsborough | New Hampshire | 33011 | 1 | 0 |
2547 | 2547 | 2020-03-15 | Rockingham | New Hampshire | 33015 | 9 | 0 |
3000 | 3000 | 2020-03-16 | Carroll | New Hampshire | 33003 | 1 | 0 |
3001 | 3001 | 2020-03-16 | Grafton | New Hampshire | 33009 | 5 | 0 |
3002 | 3002 | 2020-03-16 | Hillsborough | New Hampshire | 33011 | 1 | 0 |
3003 | 3003 | 2020-03-16 | Rockingham | New Hampshire | 33015 | 10 | 0 |
3512 | 3512 | 2020-03-17 | Carroll | New Hampshire | 33003 | 1 | 0 |
3513 | 3513 | 2020-03-17 | Grafton | New Hampshire | 33009 | 7 | 0 |
3514 | 3514 | 2020-03-17 | Hillsborough | New Hampshire | 33011 | 4 | 0 |
3515 | 3515 | 2020-03-17 | Rockingham | New Hampshire | 33015 | 14 | 0 |
4105 | 4105 | 2020-03-18 | Belknap | New Hampshire | 33001 | 2 | 0 |
4106 | 4106 | 2020-03-18 | Carroll | New Hampshire | 33003 | 4 | 0 |
4107 | 4107 | 2020-03-18 | Grafton | New Hampshire | 33009 | 7 | 0 |
4108 | 4108 | 2020-03-18 | Hillsborough | New Hampshire | 33011 | 8 | 0 |
4109 | 4109 | 2020-03-18 | Merrimack | New Hampshire | 33013 | 1 | 0 |
4110 | 4110 | 2020-03-18 | Rockingham | New Hampshire | 33015 | 17 | 0 |
4831 | 4831 | 2020-03-19 | Belknap | New Hampshire | 33001 | 3 | 0 |
4832 | 4832 | 2020-03-19 | Carroll | New Hampshire | 33003 | 4 | 0 |
4833 | 4833 | 2020-03-19 | Grafton | New Hampshire | 33009 | 9 | 0 |
4834 | 4834 | 2020-03-19 | Hillsborough | New Hampshire | 33011 | 8 | 0 |
4835 | 4835 | 2020-03-19 | Merrimack | New Hampshire | 33013 | 2 | 0 |
4836 | 4836 | 2020-03-19 | Rockingham | New Hampshire | 33015 | 18 | 0 |
5673 | 5673 | 2020-03-20 | Belknap | New Hampshire | 33001 | 3 | 0 |
5674 | 5674 | 2020-03-20 | Carroll | New Hampshire | 33003 | 5 | 0 |
5675 | 5675 | 2020-03-20 | Cheshire | New Hampshire | 33005 | 1 | 0 |
5676 | 5676 | 2020-03-20 | Grafton | New Hampshire | 33009 | 13 | 0 |
5677 | 5677 | 2020-03-20 | Hillsborough | New Hampshire | 33011 | 11 | 0 |
5678 | 5678 | 2020-03-20 | Merrimack | New Hampshire | 33013 | 2 | 0 |
5679 | 5679 | 2020-03-20 | Rockingham | New Hampshire | 33015 | 20 | 0 |
6665 | 6665 | 2020-03-21 | Belknap | New Hampshire | 33001 | 3 | 0 |
6666 | 6666 | 2020-03-21 | Carroll | New Hampshire | 33003 | 5 | 0 |
6667 | 6667 | 2020-03-21 | Cheshire | New Hampshire | 33005 | 1 | 0 |
6668 | 6668 | 2020-03-21 | Grafton | New Hampshire | 33009 | 14 | 0 |
6669 | 6669 | 2020-03-21 | Hillsborough | New Hampshire | 33011 | 12 | 0 |
6670 | 6670 | 2020-03-21 | Merrimack | New Hampshire | 33013 | 4 | 0 |
6671 | 6671 | 2020-03-21 | Rockingham | New Hampshire | 33015 | 25 | 0 |
6672 | 6672 | 2020-03-21 | Strafford | New Hampshire | 33017 | 1 | 0 |
7755 | 7755 | 2020-03-22 | Belknap | New Hampshire | 33001 | 4 | 0 |
7756 | 7756 | 2020-03-22 | Carroll | New Hampshire | 33003 | 6 | 0 |
7757 | 7757 | 2020-03-22 | Cheshire | New Hampshire | 33005 | 1 | 0 |
7758 | 7758 | 2020-03-22 | Grafton | New Hampshire | 33009 | 15 | 0 |
7759 | 7759 | 2020-03-22 | Hillsborough | New Hampshire | 33011 | 16 | 0 |
7760 | 7760 | 2020-03-22 | Merrimack | New Hampshire | 33013 | 4 | 0 |
7761 | 7761 | 2020-03-22 | Rockingham | New Hampshire | 33015 | 28 | 0 |
7762 | 7762 | 2020-03-22 | Strafford | New Hampshire | 33017 | 3 | 0 |
7763 | 7763 | 2020-03-22 | Sullivan | New Hampshire | 33019 | 1 | 0 |
8951 | 8951 | 2020-03-23 | Belknap | New Hampshire | 33001 | 7 | 0 |
8952 | 8952 | 2020-03-23 | Carroll | New Hampshire | 33003 | 7 | 0 |
8953 | 8953 | 2020-03-23 | Cheshire | New Hampshire | 33005 | 1 | 0 |
8954 | 8954 | 2020-03-23 | Grafton | New Hampshire | 33009 | 20 | 0 |
8956 | 8956 | 2020-03-23 | Merrimack | New Hampshire | 33013 | 4 | 0 |
8957 | 8957 | 2020-03-23 | Rockingham | New Hampshire | 33015 | 38 | 0 |
8958 | 8958 | 2020-03-23 | Strafford | New Hampshire | 33017 | 4 | 0 |
8959 | 8959 | 2020-03-23 | Sullivan | New Hampshire | 33019 | 1 | 0 |
10255 | 10255 | 2020-03-24 | Belknap | New Hampshire | 33001 | 7 | 0 |
10256 | 10256 | 2020-03-24 | Carroll | New Hampshire | 33003 | 7 | 0 |
10257 | 10257 | 2020-03-24 | Cheshire | New Hampshire | 33005 | 1 | 0 |
10258 | 10258 | 2020-03-24 | Grafton | New Hampshire | 33009 | 21 | 0 |
10260 | 10260 | 2020-03-24 | Merrimack | New Hampshire | 33013 | 4 | 0 |
10261 | 10261 | 2020-03-24 | Rockingham | New Hampshire | 33015 | 42 | 0 |
10262 | 10262 | 2020-03-24 | Strafford | New Hampshire | 33017 | 5 | 0 |
10263 | 10263 | 2020-03-24 | Sullivan | New Hampshire | 33019 | 1 | 0 |
11687 | 11687 | 2020-03-25 | Belknap | New Hampshire | 33001 | 8 | 0 |
11688 | 11688 | 2020-03-25 | Carroll | New Hampshire | 33003 | 7 | 0 |
11689 | 11689 | 2020-03-25 | Cheshire | New Hampshire | 33005 | 1 | 0 |
11690 | 11690 | 2020-03-25 | Grafton | New Hampshire | 33009 | 22 | 0 |
11692 | 11692 | 2020-03-25 | Merrimack | New Hampshire | 33013 | 5 | 0 |
11693 | 11693 | 2020-03-25 | Rockingham | New Hampshire | 33015 | 56 | 0 |
11694 | 11694 | 2020-03-25 | Strafford | New Hampshire | 33017 | 7 | 0 |
11695 | 11695 | 2020-03-25 | Sullivan | New Hampshire | 33019 | 1 | 0 |
13290 | 13290 | 2020-03-26 | Belknap | New Hampshire | 33001 | 8 | 0 |
13291 | 13291 | 2020-03-26 | Carroll | New Hampshire | 33003 | 7 | 0 |
13292 | 13292 | 2020-03-26 | Cheshire | New Hampshire | 33005 | 2 | 0 |
13293 | 13293 | 2020-03-26 | Grafton | New Hampshire | 33009 | 23 | 0 |
13295 | 13295 | 2020-03-26 | Merrimack | New Hampshire | 33013 | 7 | 0 |
13296 | 13296 | 2020-03-26 | Rockingham | New Hampshire | 33015 | 67 | 0 |
13297 | 13297 | 2020-03-26 | Strafford | New Hampshire | 33017 | 7 | 0 |
13298 | 13298 | 2020-03-26 | Sullivan | New Hampshire | 33019 | 2 | 0 |
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);