ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11 rows where "date" is on date 2020-11-19 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
state 1
- New Hampshire · 11 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
746966 | 746966 | 2020-11-19 | Belknap | New Hampshire | 33001 | 486 | 7 |
746967 | 746967 | 2020-11-19 | Carroll | New Hampshire | 33003 | 263 | 2 |
746968 | 746968 | 2020-11-19 | Cheshire | New Hampshire | 33005 | 377 | 3 |
746969 | 746969 | 2020-11-19 | Coos | New Hampshire | 33007 | 266 | 4 |
746970 | 746970 | 2020-11-19 | Grafton | New Hampshire | 33009 | 445 | 2 |
746971 | 746971 | 2020-11-19 | Hillsborough | New Hampshire | 33011 | 7397 | 330 |
746972 | 746972 | 2020-11-19 | Merrimack | New Hampshire | 33013 | 1386 | 34 |
746973 | 746973 | 2020-11-19 | Rockingham | New Hampshire | 33015 | 3920 | 105 |
746974 | 746974 | 2020-11-19 | Strafford | New Hampshire | 33017 | 1303 | 14 |
746975 | 746975 | 2020-11-19 | Sullivan | New Hampshire | 33019 | 183 | 4 |
746976 | 746976 | 2020-11-19 | Unknown | New Hampshire | 251 | 1 |
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);