ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,982 rows where state = "Hawaii" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Hawaii · 3,982 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
421894 | 421894 | 2020-08-11 | Unknown | Hawaii | 0 | 2 | |
1580014 | 1580014 | 2021-08-03 | Unknown | Hawaii | 0 | 1 | |
1583264 | 1583264 | 2021-08-04 | Unknown | Hawaii | 0 | 1 | |
1586514 | 1586514 | 2021-08-05 | Unknown | Hawaii | 0 | 1 | |
1589763 | 1589763 | 2021-08-06 | Unknown | Hawaii | 0 | 1 | |
1593012 | 1593012 | 2021-08-07 | Unknown | Hawaii | 0 | 1 | |
1596261 | 1596261 | 2021-08-08 | Unknown | Hawaii | 0 | 1 | |
1635239 | 1635239 | 2021-08-20 | Unknown | Hawaii | 0 | 1 | |
1638489 | 1638489 | 2021-08-21 | Unknown | Hawaii | 0 | 1 | |
1641739 | 1641739 | 2021-08-22 | Unknown | Hawaii | 0 | 2 | |
1674219 | 1674219 | 2021-09-01 | Unknown | Hawaii | 0 | 1 | |
1677466 | 1677466 | 2021-09-02 | Unknown | Hawaii | 0 | 1 | |
1680714 | 1680714 | 2021-09-03 | Unknown | Hawaii | 0 | 1 | |
1683965 | 1683965 | 2021-09-04 | Unknown | Hawaii | 0 | 1 | |
1687215 | 1687215 | 2021-09-05 | Unknown | Hawaii | 0 | 2 | |
1690465 | 1690465 | 2021-09-06 | Unknown | Hawaii | 0 | 1 | |
1693714 | 1693714 | 2021-09-07 | Unknown | Hawaii | 0 | 1 | |
1696962 | 1696962 | 2021-09-08 | Unknown | Hawaii | 0 | 1 | |
1700211 | 1700211 | 2021-09-09 | Unknown | Hawaii | 0 | 1 | |
1703461 | 1703461 | 2021-09-10 | Unknown | Hawaii | 0 | 2 | |
1706709 | 1706709 | 2021-09-11 | Unknown | Hawaii | 0 | 2 | |
1709956 | 1709956 | 2021-09-12 | Unknown | Hawaii | 0 | 3 | |
1713203 | 1713203 | 2021-09-13 | Unknown | Hawaii | 0 | 2 | |
1716449 | 1716449 | 2021-09-14 | Unknown | Hawaii | 0 | 2 | |
1719697 | 1719697 | 2021-09-15 | Unknown | Hawaii | 0 | 2 | |
1722946 | 1722946 | 2021-09-16 | Unknown | Hawaii | 0 | 2 | |
1726195 | 1726195 | 2021-09-17 | Unknown | Hawaii | 0 | 3 | |
1729445 | 1729445 | 2021-09-18 | Unknown | Hawaii | 0 | 3 | |
1732695 | 1732695 | 2021-09-19 | Unknown | Hawaii | 0 | 3 | |
1735945 | 1735945 | 2021-09-20 | Unknown | Hawaii | 0 | 2 | |
1739194 | 1739194 | 2021-09-21 | Unknown | Hawaii | 0 | 2 | |
1742443 | 1742443 | 2021-09-22 | Unknown | Hawaii | 0 | 2 | |
1745692 | 1745692 | 2021-09-23 | Unknown | Hawaii | 0 | 4 | |
1748942 | 1748942 | 2021-09-24 | Unknown | Hawaii | 0 | 4 | |
1752191 | 1752191 | 2021-09-25 | Unknown | Hawaii | 0 | 4 | |
1755439 | 1755439 | 2021-09-26 | Unknown | Hawaii | 0 | 4 | |
1758687 | 1758687 | 2021-09-27 | Unknown | Hawaii | 0 | 2 | |
1761935 | 1761935 | 2021-09-28 | Unknown | Hawaii | 0 | 2 | |
1765184 | 1765184 | 2021-09-29 | Unknown | Hawaii | 0 | 2 | |
1768433 | 1768433 | 2021-09-30 | Unknown | Hawaii | 0 | 2 | |
1771682 | 1771682 | 2021-10-01 | Unknown | Hawaii | 0 | 2 | |
1774932 | 1774932 | 2021-10-02 | Unknown | Hawaii | 0 | 3 | |
1778182 | 1778182 | 2021-10-03 | Unknown | Hawaii | 0 | 3 | |
1781432 | 1781432 | 2021-10-04 | Unknown | Hawaii | 0 | 2 | |
1784681 | 1784681 | 2021-10-05 | Unknown | Hawaii | 0 | 2 | |
1787930 | 1787930 | 2021-10-06 | Unknown | Hawaii | 0 | 2 | |
1791179 | 1791179 | 2021-10-07 | Unknown | Hawaii | 0 | 2 | |
1794427 | 1794427 | 2021-10-08 | Unknown | Hawaii | 0 | 2 | |
1797676 | 1797676 | 2021-10-09 | Unknown | Hawaii | 0 | 2 | |
1800925 | 1800925 | 2021-10-10 | Unknown | Hawaii | 0 | 2 | |
1804174 | 1804174 | 2021-10-11 | Unknown | Hawaii | 0 | 2 | |
1807425 | 1807425 | 2021-10-12 | Unknown | Hawaii | 0 | 2 | |
1810674 | 1810674 | 2021-10-13 | Unknown | Hawaii | 0 | 2 | |
1813923 | 1813923 | 2021-10-14 | Unknown | Hawaii | 0 | 2 | |
1817171 | 1817171 | 2021-10-15 | Unknown | Hawaii | 0 | 2 | |
1820420 | 1820420 | 2021-10-16 | Unknown | Hawaii | 0 | 2 | |
1823669 | 1823669 | 2021-10-17 | Unknown | Hawaii | 0 | 2 | |
1826918 | 1826918 | 2021-10-18 | Unknown | Hawaii | 0 | 2 | |
1830167 | 1830167 | 2021-10-19 | Unknown | Hawaii | 0 | 2 | |
1833416 | 1833416 | 2021-10-20 | Unknown | Hawaii | 0 | 2 | |
1836665 | 1836665 | 2021-10-21 | Unknown | Hawaii | 0 | 2 | |
1839914 | 1839914 | 2021-10-22 | Unknown | Hawaii | 0 | 2 | |
1843164 | 1843164 | 2021-10-23 | Unknown | Hawaii | 0 | 2 | |
1846414 | 1846414 | 2021-10-24 | Unknown | Hawaii | 0 | 3 | |
1849664 | 1849664 | 2021-10-25 | Unknown | Hawaii | 0 | 2 | |
1852913 | 1852913 | 2021-10-26 | Unknown | Hawaii | 0 | 2 | |
1856162 | 1856162 | 2021-10-27 | Unknown | Hawaii | 0 | 2 | |
1859411 | 1859411 | 2021-10-28 | Unknown | Hawaii | 0 | 2 | |
1862660 | 1862660 | 2021-10-29 | Unknown | Hawaii | 0 | 3 | |
1865909 | 1865909 | 2021-10-30 | Unknown | Hawaii | 0 | 4 | |
1869158 | 1869158 | 2021-10-31 | Unknown | Hawaii | 0 | 5 | |
1872407 | 1872407 | 2021-11-01 | Unknown | Hawaii | 0 | 5 | |
1875656 | 1875656 | 2021-11-02 | Unknown | Hawaii | 0 | 5 | |
1878905 | 1878905 | 2021-11-03 | Unknown | Hawaii | 0 | 5 | |
1882154 | 1882154 | 2021-11-04 | Unknown | Hawaii | 0 | 5 | |
1885403 | 1885403 | 2021-11-05 | Unknown | Hawaii | 0 | 5 | |
1888653 | 1888653 | 2021-11-06 | Unknown | Hawaii | 0 | 6 | |
1891903 | 1891903 | 2021-11-07 | Unknown | Hawaii | 0 | 7 | |
1895153 | 1895153 | 2021-11-08 | Unknown | Hawaii | 0 | 7 | |
1898403 | 1898403 | 2021-11-09 | Unknown | Hawaii | 0 | 7 | |
1901653 | 1901653 | 2021-11-10 | Unknown | Hawaii | 0 | 7 | |
1904903 | 1904903 | 2021-11-11 | Unknown | Hawaii | 0 | 7 | |
1908152 | 1908152 | 2021-11-12 | Unknown | Hawaii | 0 | 7 | |
1911401 | 1911401 | 2021-11-13 | Unknown | Hawaii | 0 | 7 | |
1914651 | 1914651 | 2021-11-14 | Unknown | Hawaii | 0 | 7 | |
1917901 | 1917901 | 2021-11-15 | Unknown | Hawaii | 0 | 7 | |
1921151 | 1921151 | 2021-11-16 | Unknown | Hawaii | 0 | 7 | |
1924400 | 1924400 | 2021-11-17 | Unknown | Hawaii | 0 | 8 | |
1927650 | 1927650 | 2021-11-18 | Unknown | Hawaii | 0 | 8 | |
1930900 | 1930900 | 2021-11-19 | Unknown | Hawaii | 0 | 8 | |
1934152 | 1934152 | 2021-11-20 | Unknown | Hawaii | 0 | 8 | |
1937402 | 1937402 | 2021-11-21 | Unknown | Hawaii | 0 | 8 | |
1940652 | 1940652 | 2021-11-22 | Unknown | Hawaii | 0 | 8 | |
1943902 | 1943902 | 2021-11-23 | Unknown | Hawaii | 0 | 8 | |
1947153 | 1947153 | 2021-11-24 | Unknown | Hawaii | 0 | 8 | |
1950404 | 1950404 | 2021-11-25 | Unknown | Hawaii | 0 | 8 | |
1953655 | 1953655 | 2021-11-26 | Unknown | Hawaii | 0 | 8 | |
1956906 | 1956906 | 2021-11-27 | Unknown | Hawaii | 0 | 8 | |
1960157 | 1960157 | 2021-11-28 | Unknown | Hawaii | 0 | 8 | |
1963408 | 1963408 | 2021-11-29 | Unknown | Hawaii | 0 | 8 |
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);