ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Honolulu" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174748 | 2174748 | 2022-02-02 | Honolulu | Hawaii | 15003 | 155054 | 879 |
2171495 | 2171495 | 2022-02-01 | Honolulu | Hawaii | 15003 | 154279 | 873 |
2168242 | 2168242 | 2022-01-31 | Honolulu | Hawaii | 15003 | 153552 | 873 |
2164987 | 2164987 | 2022-01-30 | Honolulu | Hawaii | 15003 | 152596 | 872 |
2161732 | 2161732 | 2022-01-29 | Honolulu | Hawaii | 15003 | 150792 | 867 |
2158476 | 2158476 | 2022-01-28 | Honolulu | Hawaii | 15003 | 149620 | 858 |
2155223 | 2155223 | 2022-01-27 | Honolulu | Hawaii | 15003 | 148630 | 853 |
2151970 | 2151970 | 2022-01-26 | Honolulu | Hawaii | 15003 | 147206 | 846 |
2148718 | 2148718 | 2022-01-25 | Honolulu | Hawaii | 15003 | 145765 | 845 |
2145466 | 2145466 | 2022-01-24 | Honolulu | Hawaii | 15003 | 144320 | 845 |
2142211 | 2142211 | 2022-01-23 | Honolulu | Hawaii | 15003 | 142766 | 845 |
2138956 | 2138956 | 2022-01-22 | Honolulu | Hawaii | 15003 | 140688 | 842 |
2135700 | 2135700 | 2022-01-21 | Honolulu | Hawaii | 15003 | 138140 | 837 |
2132448 | 2132448 | 2022-01-20 | Honolulu | Hawaii | 15003 | 135017 | 837 |
2129195 | 2129195 | 2022-01-19 | Honolulu | Hawaii | 15003 | 131116 | 828 |
2125941 | 2125941 | 2022-01-18 | Honolulu | Hawaii | 15003 | 128090 | 828 |
2122689 | 2122689 | 2022-01-17 | Honolulu | Hawaii | 15003 | 124141 | 828 |
2119437 | 2119437 | 2022-01-16 | Honolulu | Hawaii | 15003 | 120462 | 828 |
2116185 | 2116185 | 2022-01-15 | Honolulu | Hawaii | 15003 | 118177 | 825 |
2112934 | 2112934 | 2022-01-14 | Honolulu | Hawaii | 15003 | 114192 | 819 |
2109682 | 2109682 | 2022-01-13 | Honolulu | Hawaii | 15003 | 111628 | 816 |
2106431 | 2106431 | 2022-01-12 | Honolulu | Hawaii | 15003 | 109185 | 815 |
2103180 | 2103180 | 2022-01-11 | Honolulu | Hawaii | 15003 | 106573 | 811 |
2099929 | 2099929 | 2022-01-10 | Honolulu | Hawaii | 15003 | 104574 | 811 |
2096678 | 2096678 | 2022-01-09 | Honolulu | Hawaii | 15003 | 101813 | 811 |
2093426 | 2093426 | 2022-01-08 | Honolulu | Hawaii | 15003 | 98601 | 811 |
2090174 | 2090174 | 2022-01-07 | Honolulu | Hawaii | 15003 | 95627 | 810 |
2086923 | 2086923 | 2022-01-06 | Honolulu | Hawaii | 15003 | 93240 | 809 |
2083671 | 2083671 | 2022-01-05 | Honolulu | Hawaii | 15003 | 89995 | 805 |
2080419 | 2080419 | 2022-01-04 | Honolulu | Hawaii | 15003 | 88061 | 805 |
2077167 | 2077167 | 2022-01-03 | Honolulu | Hawaii | 15003 | 86830 | 805 |
2073916 | 2073916 | 2022-01-02 | Honolulu | Hawaii | 15003 | 84664 | 805 |
2070665 | 2070665 | 2022-01-01 | Honolulu | Hawaii | 15003 | 82169 | 805 |
2067414 | 2067414 | 2021-12-31 | Honolulu | Hawaii | 15003 | 80084 | 803 |
2064163 | 2064163 | 2021-12-30 | Honolulu | Hawaii | 15003 | 77570 | 799 |
2060913 | 2060913 | 2021-12-29 | Honolulu | Hawaii | 15003 | 74890 | 799 |
2057664 | 2057664 | 2021-12-28 | Honolulu | Hawaii | 15003 | 73568 | 797 |
2054415 | 2054415 | 2021-12-27 | Honolulu | Hawaii | 15003 | 72955 | 797 |
2051165 | 2051165 | 2021-12-26 | Honolulu | Hawaii | 15003 | 71794 | 797 |
2047915 | 2047915 | 2021-12-25 | Honolulu | Hawaii | 15003 | 69953 | 797 |
2044665 | 2044665 | 2021-12-24 | Honolulu | Hawaii | 15003 | 68643 | 796 |
2041416 | 2041416 | 2021-12-23 | Honolulu | Hawaii | 15003 | 67096 | 796 |
2038166 | 2038166 | 2021-12-22 | Honolulu | Hawaii | 15003 | 65803 | 796 |
2034916 | 2034916 | 2021-12-21 | Honolulu | Hawaii | 15003 | 64937 | 796 |
2031666 | 2031666 | 2021-12-20 | Honolulu | Hawaii | 15003 | 64290 | 796 |
2028415 | 2028415 | 2021-12-19 | Honolulu | Hawaii | 15003 | 63548 | 796 |
2025164 | 2025164 | 2021-12-18 | Honolulu | Hawaii | 15003 | 62671 | 796 |
2021913 | 2021913 | 2021-12-17 | Honolulu | Hawaii | 15003 | 62049 | 793 |
2018662 | 2018662 | 2021-12-16 | Honolulu | Hawaii | 15003 | 61337 | 792 |
2015412 | 2015412 | 2021-12-15 | Honolulu | Hawaii | 15003 | 61042 | 790 |
2012161 | 2012161 | 2021-12-14 | Honolulu | Hawaii | 15003 | 60812 | 787 |
2008910 | 2008910 | 2021-12-13 | Honolulu | Hawaii | 15003 | 60643 | 787 |
2005659 | 2005659 | 2021-12-12 | Honolulu | Hawaii | 15003 | 60521 | 787 |
2002408 | 2002408 | 2021-12-11 | Honolulu | Hawaii | 15003 | 60356 | 783 |
1999158 | 1999158 | 2021-12-10 | Honolulu | Hawaii | 15003 | 60222 | 776 |
1995907 | 1995907 | 2021-12-09 | Honolulu | Hawaii | 15003 | 60104 | 772 |
1992656 | 1992656 | 2021-12-08 | Honolulu | Hawaii | 15003 | 60006 | 772 |
1989405 | 1989405 | 2021-12-07 | Honolulu | Hawaii | 15003 | 59955 | 767 |
1986155 | 1986155 | 2021-12-06 | Honolulu | Hawaii | 15003 | 59927 | 767 |
1982905 | 1982905 | 2021-12-05 | Honolulu | Hawaii | 15003 | 59882 | 767 |
1979655 | 1979655 | 2021-12-04 | Honolulu | Hawaii | 15003 | 59802 | 766 |
1976405 | 1976405 | 2021-12-03 | Honolulu | Hawaii | 15003 | 59744 | 762 |
1973156 | 1973156 | 2021-12-02 | Honolulu | Hawaii | 15003 | 59673 | 762 |
1969906 | 1969906 | 2021-12-01 | Honolulu | Hawaii | 15003 | 59621 | 761 |
1966656 | 1966656 | 2021-11-30 | Honolulu | Hawaii | 15003 | 59570 | 757 |
1963404 | 1963404 | 2021-11-29 | Honolulu | Hawaii | 15003 | 59534 | 757 |
1960153 | 1960153 | 2021-11-28 | Honolulu | Hawaii | 15003 | 59504 | 757 |
1956902 | 1956902 | 2021-11-27 | Honolulu | Hawaii | 15003 | 59397 | 756 |
1953651 | 1953651 | 2021-11-26 | Honolulu | Hawaii | 15003 | 59337 | 756 |
1950400 | 1950400 | 2021-11-25 | Honolulu | Hawaii | 15003 | 59333 | 755 |
1947149 | 1947149 | 2021-11-24 | Honolulu | Hawaii | 15003 | 59308 | 753 |
1943898 | 1943898 | 2021-11-23 | Honolulu | Hawaii | 15003 | 59255 | 747 |
1940648 | 1940648 | 2021-11-22 | Honolulu | Hawaii | 15003 | 59232 | 747 |
1937398 | 1937398 | 2021-11-21 | Honolulu | Hawaii | 15003 | 59184 | 747 |
1934148 | 1934148 | 2021-11-20 | Honolulu | Hawaii | 15003 | 59135 | 747 |
1930896 | 1930896 | 2021-11-19 | Honolulu | Hawaii | 15003 | 59013 | 745 |
1927646 | 1927646 | 2021-11-18 | Honolulu | Hawaii | 15003 | 58894 | 742 |
1924396 | 1924396 | 2021-11-17 | Honolulu | Hawaii | 15003 | 58778 | 736 |
1921147 | 1921147 | 2021-11-16 | Honolulu | Hawaii | 15003 | 58684 | 732 |
1917897 | 1917897 | 2021-11-15 | Honolulu | Hawaii | 15003 | 58651 | 732 |
1914647 | 1914647 | 2021-11-14 | Honolulu | Hawaii | 15003 | 58618 | 732 |
1911397 | 1911397 | 2021-11-13 | Honolulu | Hawaii | 15003 | 58576 | 731 |
1908148 | 1908148 | 2021-11-12 | Honolulu | Hawaii | 15003 | 58537 | 731 |
1904899 | 1904899 | 2021-11-11 | Honolulu | Hawaii | 15003 | 58476 | 727 |
1901649 | 1901649 | 2021-11-10 | Honolulu | Hawaii | 15003 | 58425 | 724 |
1898399 | 1898399 | 2021-11-09 | Honolulu | Hawaii | 15003 | 58356 | 718 |
1895149 | 1895149 | 2021-11-08 | Honolulu | Hawaii | 15003 | 58323 | 718 |
1891899 | 1891899 | 2021-11-07 | Honolulu | Hawaii | 15003 | 58284 | 718 |
1888649 | 1888649 | 2021-11-06 | Honolulu | Hawaii | 15003 | 58225 | 712 |
1885399 | 1885399 | 2021-11-05 | Honolulu | Hawaii | 15003 | 58182 | 710 |
1882150 | 1882150 | 2021-11-04 | Honolulu | Hawaii | 15003 | 58115 | 701 |
1878901 | 1878901 | 2021-11-03 | Honolulu | Hawaii | 15003 | 58058 | 690 |
1875652 | 1875652 | 2021-11-02 | Honolulu | Hawaii | 15003 | 57956 | 687 |
1872403 | 1872403 | 2021-11-01 | Honolulu | Hawaii | 15003 | 57942 | 687 |
1869154 | 1869154 | 2021-10-31 | Honolulu | Hawaii | 15003 | 57908 | 687 |
1865905 | 1865905 | 2021-10-30 | Honolulu | Hawaii | 15003 | 57852 | 679 |
1862656 | 1862656 | 2021-10-29 | Honolulu | Hawaii | 15003 | 57766 | 674 |
1859407 | 1859407 | 2021-10-28 | Honolulu | Hawaii | 15003 | 57694 | 670 |
1856158 | 1856158 | 2021-10-27 | Honolulu | Hawaii | 15003 | 57647 | 668 |
1852909 | 1852909 | 2021-10-26 | Honolulu | Hawaii | 15003 | 57548 | 668 |
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);