ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 20 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- New Hampshire · 44 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2058903 | 2058903 | 2021-12-28 | Unknown | New Hampshire | 3374 | 20 | |
1928876 | 1928876 | 2021-11-18 | Carroll | New Hampshire | 33003 | 4529 | 20 |
1925626 | 1925626 | 2021-11-17 | Carroll | New Hampshire | 33003 | 4485 | 20 |
1922377 | 1922377 | 2021-11-16 | Carroll | New Hampshire | 33003 | 4433 | 20 |
1919127 | 1919127 | 2021-11-15 | Carroll | New Hampshire | 33003 | 4411 | 20 |
1915877 | 1915877 | 2021-11-14 | Carroll | New Hampshire | 33003 | 4334 | 20 |
1912627 | 1912627 | 2021-11-13 | Carroll | New Hampshire | 33003 | 4334 | 20 |
1909377 | 1909377 | 2021-11-12 | Carroll | New Hampshire | 33003 | 4334 | 20 |
1906128 | 1906128 | 2021-11-11 | Carroll | New Hampshire | 33003 | 4231 | 20 |
1902879 | 1902879 | 2021-11-10 | Carroll | New Hampshire | 33003 | 4231 | 20 |
1899629 | 1899629 | 2021-11-09 | Carroll | New Hampshire | 33003 | 4181 | 20 |
1162417 | 1162417 | 2021-03-27 | Grafton | New Hampshire | 33009 | 3028 | 20 |
1159169 | 1159169 | 2021-03-26 | Grafton | New Hampshire | 33009 | 3009 | 20 |
1155922 | 1155922 | 2021-03-25 | Grafton | New Hampshire | 33009 | 3002 | 20 |
1152675 | 1152675 | 2021-03-24 | Grafton | New Hampshire | 33009 | 2985 | 20 |
1084505 | 1084505 | 2021-03-03 | Sullivan | New Hampshire | 33019 | 1345 | 20 |
1081259 | 1081259 | 2021-03-02 | Sullivan | New Hampshire | 33019 | 1343 | 20 |
1078013 | 1078013 | 2021-03-01 | Sullivan | New Hampshire | 33019 | 1343 | 20 |
1074767 | 1074767 | 2021-02-28 | Sullivan | New Hampshire | 33019 | 1340 | 20 |
1071521 | 1071521 | 2021-02-27 | Sullivan | New Hampshire | 33019 | 1334 | 20 |
1068276 | 1068276 | 2021-02-26 | Sullivan | New Hampshire | 33019 | 1327 | 20 |
1000112 | 1000112 | 2021-02-05 | Cheshire | New Hampshire | 33005 | 2296 | 20 |
996866 | 996866 | 2021-02-04 | Cheshire | New Hampshire | 33005 | 2285 | 20 |
993620 | 993620 | 2021-02-03 | Cheshire | New Hampshire | 33005 | 2275 | 20 |
990374 | 990374 | 2021-02-02 | Cheshire | New Hampshire | 33005 | 2280 | 20 |
987127 | 987127 | 2021-02-01 | Cheshire | New Hampshire | 33005 | 2263 | 20 |
983880 | 983880 | 2021-01-31 | Cheshire | New Hampshire | 33005 | 2248 | 20 |
935201 | 935201 | 2021-01-16 | Coos | New Hampshire | 33007 | 919 | 20 |
931956 | 931956 | 2021-01-15 | Coos | New Hampshire | 33007 | 903 | 20 |
854075 | 854075 | 2020-12-22 | Strafford | New Hampshire | 33017 | 2908 | 20 |
850830 | 850830 | 2020-12-21 | Strafford | New Hampshire | 33017 | 2839 | 20 |
847585 | 847585 | 2020-12-20 | Strafford | New Hampshire | 33017 | 2778 | 20 |
844339 | 844339 | 2020-12-19 | Strafford | New Hampshire | 33017 | 2704 | 20 |
841094 | 841094 | 2020-12-18 | Strafford | New Hampshire | 33017 | 2628 | 20 |
837849 | 837849 | 2020-12-17 | Strafford | New Hampshire | 33017 | 2475 | 20 |
365204 | 365204 | 2020-07-24 | Merrimack | New Hampshire | 33013 | 448 | 20 |
361998 | 361998 | 2020-07-23 | Merrimack | New Hampshire | 33013 | 444 | 20 |
358792 | 358792 | 2020-07-22 | Merrimack | New Hampshire | 33013 | 443 | 20 |
355588 | 355588 | 2020-07-21 | Merrimack | New Hampshire | 33013 | 441 | 20 |
352385 | 352385 | 2020-07-20 | Merrimack | New Hampshire | 33013 | 440 | 20 |
349182 | 349182 | 2020-07-19 | Merrimack | New Hampshire | 33013 | 439 | 20 |
345981 | 345981 | 2020-07-18 | Merrimack | New Hampshire | 33013 | 437 | 20 |
342782 | 342782 | 2020-07-17 | Merrimack | New Hampshire | 33013 | 436 | 20 |
339584 | 339584 | 2020-07-16 | Merrimack | New Hampshire | 33013 | 435 | 20 |
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);