ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 27, fips = 33019 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1642972 | 1642972 | 2021-08-22 | Sullivan | New Hampshire | 33019 | 2026 | 27 |
1639722 | 1639722 | 2021-08-21 | Sullivan | New Hampshire | 33019 | 2026 | 27 |
1636472 | 1636472 | 2021-08-20 | Sullivan | New Hampshire | 33019 | 2026 | 27 |
1633222 | 1633222 | 2021-08-19 | Sullivan | New Hampshire | 33019 | 2011 | 27 |
1629975 | 1629975 | 2021-08-18 | Sullivan | New Hampshire | 33019 | 2005 | 27 |
1626728 | 1626728 | 2021-08-17 | Sullivan | New Hampshire | 33019 | 1998 | 27 |
1623481 | 1623481 | 2021-08-16 | Sullivan | New Hampshire | 33019 | 1993 | 27 |
1620234 | 1620234 | 2021-08-15 | Sullivan | New Hampshire | 33019 | 1961 | 27 |
1616986 | 1616986 | 2021-08-14 | Sullivan | New Hampshire | 33019 | 1961 | 27 |
1613738 | 1613738 | 2021-08-13 | Sullivan | New Hampshire | 33019 | 1961 | 27 |
1610489 | 1610489 | 2021-08-12 | Sullivan | New Hampshire | 33019 | 1951 | 27 |
1607241 | 1607241 | 2021-08-11 | Sullivan | New Hampshire | 33019 | 1943 | 27 |
1603992 | 1603992 | 2021-08-10 | Sullivan | New Hampshire | 33019 | 1939 | 27 |
1600743 | 1600743 | 2021-08-09 | Sullivan | New Hampshire | 33019 | 1937 | 27 |
1597495 | 1597495 | 2021-08-08 | Sullivan | New Hampshire | 33019 | 1926 | 27 |
1594246 | 1594246 | 2021-08-07 | Sullivan | New Hampshire | 33019 | 1926 | 27 |
1590997 | 1590997 | 2021-08-06 | Sullivan | New Hampshire | 33019 | 1926 | 27 |
1587748 | 1587748 | 2021-08-05 | Sullivan | New Hampshire | 33019 | 1923 | 27 |
1584497 | 1584497 | 2021-08-04 | Sullivan | New Hampshire | 33019 | 1920 | 27 |
1581248 | 1581248 | 2021-08-03 | Sullivan | New Hampshire | 33019 | 1914 | 27 |
1577999 | 1577999 | 2021-08-02 | Sullivan | New Hampshire | 33019 | 1913 | 27 |
1574751 | 1574751 | 2021-08-01 | Sullivan | New Hampshire | 33019 | 1907 | 27 |
1571503 | 1571503 | 2021-07-31 | Sullivan | New Hampshire | 33019 | 1907 | 27 |
1568255 | 1568255 | 2021-07-30 | Sullivan | New Hampshire | 33019 | 1907 | 27 |
1565007 | 1565007 | 2021-07-29 | Sullivan | New Hampshire | 33019 | 1906 | 27 |
1561759 | 1561759 | 2021-07-28 | Sullivan | New Hampshire | 33019 | 1904 | 27 |
1558511 | 1558511 | 2021-07-27 | Sullivan | New Hampshire | 33019 | 1904 | 27 |
1555264 | 1555264 | 2021-07-26 | Sullivan | New Hampshire | 33019 | 1902 | 27 |
1552017 | 1552017 | 2021-07-25 | Sullivan | New Hampshire | 33019 | 1901 | 27 |
1548770 | 1548770 | 2021-07-24 | Sullivan | New Hampshire | 33019 | 1901 | 27 |
1545523 | 1545523 | 2021-07-23 | Sullivan | New Hampshire | 33019 | 1901 | 27 |
1542275 | 1542275 | 2021-07-22 | Sullivan | New Hampshire | 33019 | 1900 | 27 |
1539028 | 1539028 | 2021-07-21 | Sullivan | New Hampshire | 33019 | 1897 | 27 |
1535781 | 1535781 | 2021-07-20 | Sullivan | New Hampshire | 33019 | 1897 | 27 |
1532533 | 1532533 | 2021-07-19 | Sullivan | New Hampshire | 33019 | 1896 | 27 |
1529286 | 1529286 | 2021-07-18 | Sullivan | New Hampshire | 33019 | 1894 | 27 |
1526039 | 1526039 | 2021-07-17 | Sullivan | New Hampshire | 33019 | 1894 | 27 |
1522792 | 1522792 | 2021-07-16 | Sullivan | New Hampshire | 33019 | 1894 | 27 |
1519543 | 1519543 | 2021-07-15 | Sullivan | New Hampshire | 33019 | 1893 | 27 |
1516296 | 1516296 | 2021-07-14 | Sullivan | New Hampshire | 33019 | 1893 | 27 |
1513049 | 1513049 | 2021-07-13 | Sullivan | New Hampshire | 33019 | 1891 | 27 |
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);