ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
294 rows where county = "Unknown" and state = "Hawaii" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
8530 | 8530 | 2020-03-23 | Unknown | Hawaii | 5 | 0 | |
9791 | 9791 | 2020-03-24 | Unknown | Hawaii | 13 | 0 | |
11176 | 11176 | 2020-03-25 | Unknown | Hawaii | 4 | 0 | |
12729 | 12729 | 2020-03-26 | Unknown | Hawaii | 5 | 0 | |
14404 | 14404 | 2020-03-27 | Unknown | Hawaii | 5 | 0 | |
16195 | 16195 | 2020-03-28 | Unknown | Hawaii | 6 | 0 | |
18092 | 18092 | 2020-03-29 | Unknown | Hawaii | 12 | 0 | |
20088 | 20088 | 2020-03-30 | Unknown | Hawaii | 13 | 0 | |
22177 | 22177 | 2020-03-31 | Unknown | Hawaii | 15 | 0 | |
24343 | 24343 | 2020-04-01 | Unknown | Hawaii | 20 | 0 | |
26575 | 26575 | 2020-04-02 | Unknown | Hawaii | 20 | 0 | |
36101 | 36101 | 2020-04-06 | Unknown | Hawaii | 9 | 0 | |
38594 | 38594 | 2020-04-07 | Unknown | Hawaii | 7 | 0 | |
41138 | 41138 | 2020-04-08 | Unknown | Hawaii | 7 | 0 | |
43712 | 43712 | 2020-04-09 | Unknown | Hawaii | 3 | 0 | |
46314 | 46314 | 2020-04-10 | Unknown | Hawaii | 4 | 0 | |
48945 | 48945 | 2020-04-11 | Unknown | Hawaii | 3 | 0 | |
51607 | 51607 | 2020-04-12 | Unknown | Hawaii | 3 | 0 | |
54287 | 54287 | 2020-04-13 | Unknown | Hawaii | 3 | 0 | |
56979 | 56979 | 2020-04-14 | Unknown | Hawaii | 3 | 0 | |
59686 | 59686 | 2020-04-15 | Unknown | Hawaii | 1 | 0 | |
62406 | 62406 | 2020-04-16 | Unknown | Hawaii | 5 | 0 | |
287626 | 287626 | 2020-06-30 | Unknown | Hawaii | 1 | 0 | |
338384 | 338384 | 2020-07-16 | Unknown | Hawaii | 3 | 0 | |
344780 | 344780 | 2020-07-18 | Unknown | Hawaii | 3 | 0 | |
347980 | 347980 | 2020-07-19 | Unknown | Hawaii | 3 | 0 | |
28882 | 28882 | 2020-04-03 | Unknown | Hawaii | 11 | 1 | |
31243 | 31243 | 2020-04-04 | Unknown | Hawaii | 8 | 1 | |
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 | |
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 | |
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 | |
33650 | 33650 | 2020-04-05 | Unknown | Hawaii | 7 | 2 | |
421894 | 421894 | 2020-08-11 | Unknown | Hawaii | 0 | 2 | |
1641739 | 1641739 | 2021-08-22 | Unknown | Hawaii | 0 | 2 | |
1687215 | 1687215 | 2021-09-05 | Unknown | Hawaii | 0 | 2 | |
1703461 | 1703461 | 2021-09-10 | Unknown | Hawaii | 0 | 2 | |
1706709 | 1706709 | 2021-09-11 | Unknown | Hawaii | 0 | 2 | |
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 | |
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 | |
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 | |
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 | |
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 | |
1709956 | 1709956 | 2021-09-12 | Unknown | Hawaii | 0 | 3 | |
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 | |
1774932 | 1774932 | 2021-10-02 | Unknown | Hawaii | 0 | 3 | |
1778182 | 1778182 | 2021-10-03 | Unknown | Hawaii | 0 | 3 | |
1846414 | 1846414 | 2021-10-24 | Unknown | Hawaii | 0 | 3 | |
1862660 | 1862660 | 2021-10-29 | Unknown | Hawaii | 0 | 3 | |
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 | |
1865909 | 1865909 | 2021-10-30 | Unknown | Hawaii | 0 | 4 | |
1869158 | 1869158 | 2021-10-31 | Unknown | Hawaii | 0 | 5 |
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);