ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 15001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174747 | 2174747 | 2022-02-02 | Hawaii | Hawaii | 15001 | 23680 | 164 |
2171494 | 2171494 | 2022-02-01 | Hawaii | Hawaii | 15001 | 23606 | 164 |
2168241 | 2168241 | 2022-01-31 | Hawaii | Hawaii | 15001 | 23466 | 164 |
2164986 | 2164986 | 2022-01-30 | Hawaii | Hawaii | 15001 | 23307 | 164 |
2161731 | 2161731 | 2022-01-29 | Hawaii | Hawaii | 15001 | 22913 | 163 |
2158475 | 2158475 | 2022-01-28 | Hawaii | Hawaii | 15001 | 22620 | 163 |
2155222 | 2155222 | 2022-01-27 | Hawaii | Hawaii | 15001 | 22388 | 163 |
2151969 | 2151969 | 2022-01-26 | Hawaii | Hawaii | 15001 | 22013 | 161 |
2148717 | 2148717 | 2022-01-25 | Hawaii | Hawaii | 15001 | 21863 | 161 |
2145465 | 2145465 | 2022-01-24 | Hawaii | Hawaii | 15001 | 21721 | 161 |
2142210 | 2142210 | 2022-01-23 | Hawaii | Hawaii | 15001 | 21418 | 161 |
2138955 | 2138955 | 2022-01-22 | Hawaii | Hawaii | 15001 | 21047 | 160 |
2135699 | 2135699 | 2022-01-21 | Hawaii | Hawaii | 15001 | 20563 | 160 |
2132447 | 2132447 | 2022-01-20 | Hawaii | Hawaii | 15001 | 20056 | 159 |
2129194 | 2129194 | 2022-01-19 | Hawaii | Hawaii | 15001 | 19489 | 159 |
2125940 | 2125940 | 2022-01-18 | Hawaii | Hawaii | 15001 | 19249 | 159 |
2122688 | 2122688 | 2022-01-17 | Hawaii | Hawaii | 15001 | 18415 | 159 |
2119436 | 2119436 | 2022-01-16 | Hawaii | Hawaii | 15001 | 18161 | 159 |
2116184 | 2116184 | 2022-01-15 | Hawaii | Hawaii | 15001 | 17576 | 159 |
2112933 | 2112933 | 2022-01-14 | Hawaii | Hawaii | 15001 | 16856 | 159 |
2109681 | 2109681 | 2022-01-13 | Hawaii | Hawaii | 15001 | 16759 | 159 |
2106430 | 2106430 | 2022-01-12 | Hawaii | Hawaii | 15001 | 16597 | 157 |
2103179 | 2103179 | 2022-01-11 | Hawaii | Hawaii | 15001 | 16307 | 157 |
2099928 | 2099928 | 2022-01-10 | Hawaii | Hawaii | 15001 | 16099 | 157 |
2096677 | 2096677 | 2022-01-09 | Hawaii | Hawaii | 15001 | 15751 | 157 |
2093425 | 2093425 | 2022-01-08 | Hawaii | Hawaii | 15001 | 15387 | 155 |
2090173 | 2090173 | 2022-01-07 | Hawaii | Hawaii | 15001 | 14979 | 155 |
2086922 | 2086922 | 2022-01-06 | Hawaii | Hawaii | 15001 | 14693 | 153 |
2083670 | 2083670 | 2022-01-05 | Hawaii | Hawaii | 15001 | 14185 | 153 |
2080418 | 2080418 | 2022-01-04 | Hawaii | Hawaii | 15001 | 14029 | 153 |
2077166 | 2077166 | 2022-01-03 | Hawaii | Hawaii | 15001 | 13909 | 153 |
2073915 | 2073915 | 2022-01-02 | Hawaii | Hawaii | 15001 | 13550 | 153 |
2070664 | 2070664 | 2022-01-01 | Hawaii | Hawaii | 15001 | 13312 | 153 |
2067413 | 2067413 | 2021-12-31 | Hawaii | Hawaii | 15001 | 13117 | 152 |
2064162 | 2064162 | 2021-12-30 | Hawaii | Hawaii | 15001 | 12861 | 152 |
2060912 | 2060912 | 2021-12-29 | Hawaii | Hawaii | 15001 | 12619 | 152 |
2057663 | 2057663 | 2021-12-28 | Hawaii | Hawaii | 15001 | 12593 | 151 |
2054414 | 2054414 | 2021-12-27 | Hawaii | Hawaii | 15001 | 12543 | 151 |
2051164 | 2051164 | 2021-12-26 | Hawaii | Hawaii | 15001 | 12440 | 151 |
2047914 | 2047914 | 2021-12-25 | Hawaii | Hawaii | 15001 | 12322 | 151 |
2044664 | 2044664 | 2021-12-24 | Hawaii | Hawaii | 15001 | 12245 | 151 |
2041415 | 2041415 | 2021-12-23 | Hawaii | Hawaii | 15001 | 12154 | 150 |
2038165 | 2038165 | 2021-12-22 | Hawaii | Hawaii | 15001 | 12088 | 148 |
2034915 | 2034915 | 2021-12-21 | Hawaii | Hawaii | 15001 | 12067 | 147 |
2031665 | 2031665 | 2021-12-20 | Hawaii | Hawaii | 15001 | 12058 | 147 |
2028414 | 2028414 | 2021-12-19 | Hawaii | Hawaii | 15001 | 12032 | 147 |
2025163 | 2025163 | 2021-12-18 | Hawaii | Hawaii | 15001 | 12003 | 147 |
2021912 | 2021912 | 2021-12-17 | Hawaii | Hawaii | 15001 | 11981 | 147 |
2018661 | 2018661 | 2021-12-16 | Hawaii | Hawaii | 15001 | 11952 | 146 |
2015411 | 2015411 | 2021-12-15 | Hawaii | Hawaii | 15001 | 11897 | 146 |
2012160 | 2012160 | 2021-12-14 | Hawaii | Hawaii | 15001 | 11892 | 145 |
2008909 | 2008909 | 2021-12-13 | Hawaii | Hawaii | 15001 | 11869 | 145 |
2005658 | 2005658 | 2021-12-12 | Hawaii | Hawaii | 15001 | 11859 | 145 |
2002407 | 2002407 | 2021-12-11 | Hawaii | Hawaii | 15001 | 11843 | 144 |
1999157 | 1999157 | 2021-12-10 | Hawaii | Hawaii | 15001 | 11833 | 143 |
1995906 | 1995906 | 2021-12-09 | Hawaii | Hawaii | 15001 | 11823 | 142 |
1992655 | 1992655 | 2021-12-08 | Hawaii | Hawaii | 15001 | 11810 | 141 |
1989404 | 1989404 | 2021-12-07 | Hawaii | Hawaii | 15001 | 11802 | 140 |
1986154 | 1986154 | 2021-12-06 | Hawaii | Hawaii | 15001 | 11795 | 140 |
1982904 | 1982904 | 2021-12-05 | Hawaii | Hawaii | 15001 | 11783 | 140 |
1979654 | 1979654 | 2021-12-04 | Hawaii | Hawaii | 15001 | 11765 | 140 |
1976404 | 1976404 | 2021-12-03 | Hawaii | Hawaii | 15001 | 11739 | 140 |
1973155 | 1973155 | 2021-12-02 | Hawaii | Hawaii | 15001 | 11725 | 139 |
1969905 | 1969905 | 2021-12-01 | Hawaii | Hawaii | 15001 | 11708 | 139 |
1966655 | 1966655 | 2021-11-30 | Hawaii | Hawaii | 15001 | 11705 | 138 |
1963403 | 1963403 | 2021-11-29 | Hawaii | Hawaii | 15001 | 11703 | 138 |
1960152 | 1960152 | 2021-11-28 | Hawaii | Hawaii | 15001 | 11700 | 138 |
1956901 | 1956901 | 2021-11-27 | Hawaii | Hawaii | 15001 | 11678 | 136 |
1953650 | 1953650 | 2021-11-26 | Hawaii | Hawaii | 15001 | 11655 | 136 |
1950399 | 1950399 | 2021-11-25 | Hawaii | Hawaii | 15001 | 11653 | 136 |
1947148 | 1947148 | 2021-11-24 | Hawaii | Hawaii | 15001 | 11637 | 132 |
1943897 | 1943897 | 2021-11-23 | Hawaii | Hawaii | 15001 | 11623 | 132 |
1940647 | 1940647 | 2021-11-22 | Hawaii | Hawaii | 15001 | 11609 | 132 |
1937397 | 1937397 | 2021-11-21 | Hawaii | Hawaii | 15001 | 11596 | 132 |
1934147 | 1934147 | 2021-11-20 | Hawaii | Hawaii | 15001 | 11584 | 132 |
1930895 | 1930895 | 2021-11-19 | Hawaii | Hawaii | 15001 | 11534 | 130 |
1927645 | 1927645 | 2021-11-18 | Hawaii | Hawaii | 15001 | 11492 | 127 |
1924395 | 1924395 | 2021-11-17 | Hawaii | Hawaii | 15001 | 11435 | 126 |
1921146 | 1921146 | 2021-11-16 | Hawaii | Hawaii | 15001 | 11420 | 126 |
1917896 | 1917896 | 2021-11-15 | Hawaii | Hawaii | 15001 | 11406 | 126 |
1914646 | 1914646 | 2021-11-14 | Hawaii | Hawaii | 15001 | 11381 | 126 |
1911396 | 1911396 | 2021-11-13 | Hawaii | Hawaii | 15001 | 11373 | 126 |
1908147 | 1908147 | 2021-11-12 | Hawaii | Hawaii | 15001 | 11363 | 126 |
1904898 | 1904898 | 2021-11-11 | Hawaii | Hawaii | 15001 | 11334 | 125 |
1901648 | 1901648 | 2021-11-10 | Hawaii | Hawaii | 15001 | 11307 | 125 |
1898398 | 1898398 | 2021-11-09 | Hawaii | Hawaii | 15001 | 11279 | 125 |
1895148 | 1895148 | 2021-11-08 | Hawaii | Hawaii | 15001 | 11258 | 125 |
1891898 | 1891898 | 2021-11-07 | Hawaii | Hawaii | 15001 | 11241 | 125 |
1888648 | 1888648 | 2021-11-06 | Hawaii | Hawaii | 15001 | 11215 | 123 |
1885398 | 1885398 | 2021-11-05 | Hawaii | Hawaii | 15001 | 11193 | 122 |
1882149 | 1882149 | 2021-11-04 | Hawaii | Hawaii | 15001 | 11171 | 120 |
1878900 | 1878900 | 2021-11-03 | Hawaii | Hawaii | 15001 | 11143 | 118 |
1875651 | 1875651 | 2021-11-02 | Hawaii | Hawaii | 15001 | 11122 | 118 |
1872402 | 1872402 | 2021-11-01 | Hawaii | Hawaii | 15001 | 11109 | 118 |
1869153 | 1869153 | 2021-10-31 | Hawaii | Hawaii | 15001 | 11097 | 118 |
1865904 | 1865904 | 2021-10-30 | Hawaii | Hawaii | 15001 | 11064 | 117 |
1862655 | 1862655 | 2021-10-29 | Hawaii | Hawaii | 15001 | 11032 | 113 |
1859406 | 1859406 | 2021-10-28 | Hawaii | Hawaii | 15001 | 11002 | 113 |
1856157 | 1856157 | 2021-10-27 | Hawaii | Hawaii | 15001 | 10964 | 113 |
1852908 | 1852908 | 2021-10-26 | Hawaii | Hawaii | 15001 | 10933 | 112 |
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);