ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 15009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174751 | 2174751 | 2022-02-02 | Maui | Hawaii | 15009 | 27758 | 114 |
2171498 | 2171498 | 2022-02-01 | Maui | Hawaii | 15009 | 27566 | 110 |
2168245 | 2168245 | 2022-01-31 | Maui | Hawaii | 15009 | 27407 | 110 |
2164990 | 2164990 | 2022-01-30 | Maui | Hawaii | 15009 | 27202 | 110 |
2161735 | 2161735 | 2022-01-29 | Maui | Hawaii | 15009 | 26934 | 109 |
2158479 | 2158479 | 2022-01-28 | Maui | Hawaii | 15009 | 26668 | 109 |
2155226 | 2155226 | 2022-01-27 | Maui | Hawaii | 15009 | 26317 | 109 |
2151973 | 2151973 | 2022-01-26 | Maui | Hawaii | 15009 | 25957 | 109 |
2148721 | 2148721 | 2022-01-25 | Maui | Hawaii | 15009 | 25626 | 108 |
2145469 | 2145469 | 2022-01-24 | Maui | Hawaii | 15009 | 25448 | 108 |
2142214 | 2142214 | 2022-01-23 | Maui | Hawaii | 15009 | 24963 | 108 |
2138959 | 2138959 | 2022-01-22 | Maui | Hawaii | 15009 | 24449 | 108 |
2135703 | 2135703 | 2022-01-21 | Maui | Hawaii | 15009 | 23870 | 108 |
2132451 | 2132451 | 2022-01-20 | Maui | Hawaii | 15009 | 23359 | 108 |
2129198 | 2129198 | 2022-01-19 | Maui | Hawaii | 15009 | 22292 | 108 |
2125944 | 2125944 | 2022-01-18 | Maui | Hawaii | 15009 | 21858 | 108 |
2122692 | 2122692 | 2022-01-17 | Maui | Hawaii | 15009 | 21008 | 108 |
2119440 | 2119440 | 2022-01-16 | Maui | Hawaii | 15009 | 20485 | 108 |
2116188 | 2116188 | 2022-01-15 | Maui | Hawaii | 15009 | 19729 | 108 |
2112937 | 2112937 | 2022-01-14 | Maui | Hawaii | 15009 | 18773 | 108 |
2109685 | 2109685 | 2022-01-13 | Maui | Hawaii | 15009 | 18437 | 108 |
2106434 | 2106434 | 2022-01-12 | Maui | Hawaii | 15009 | 17892 | 107 |
2103183 | 2103183 | 2022-01-11 | Maui | Hawaii | 15009 | 17492 | 107 |
2099932 | 2099932 | 2022-01-10 | Maui | Hawaii | 15009 | 16968 | 107 |
2096681 | 2096681 | 2022-01-09 | Maui | Hawaii | 15009 | 16384 | 107 |
2093429 | 2093429 | 2022-01-08 | Maui | Hawaii | 15009 | 15677 | 107 |
2090177 | 2090177 | 2022-01-07 | Maui | Hawaii | 15009 | 15096 | 107 |
2086926 | 2086926 | 2022-01-06 | Maui | Hawaii | 15009 | 14486 | 107 |
2083674 | 2083674 | 2022-01-05 | Maui | Hawaii | 15009 | 13752 | 107 |
2080422 | 2080422 | 2022-01-04 | Maui | Hawaii | 15009 | 13398 | 107 |
2077170 | 2077170 | 2022-01-03 | Maui | Hawaii | 15009 | 13291 | 107 |
2073919 | 2073919 | 2022-01-02 | Maui | Hawaii | 15009 | 13010 | 107 |
2070668 | 2070668 | 2022-01-01 | Maui | Hawaii | 15009 | 12755 | 107 |
2067417 | 2067417 | 2021-12-31 | Maui | Hawaii | 15009 | 12405 | 106 |
2064166 | 2064166 | 2021-12-30 | Maui | Hawaii | 15009 | 12076 | 105 |
2060916 | 2060916 | 2021-12-29 | Maui | Hawaii | 15009 | 11720 | 105 |
2057667 | 2057667 | 2021-12-28 | Maui | Hawaii | 15009 | 11572 | 105 |
2054418 | 2054418 | 2021-12-27 | Maui | Hawaii | 15009 | 11440 | 105 |
2051168 | 2051168 | 2021-12-26 | Maui | Hawaii | 15009 | 11367 | 105 |
2047918 | 2047918 | 2021-12-25 | Maui | Hawaii | 15009 | 11217 | 105 |
2044668 | 2044668 | 2021-12-24 | Maui | Hawaii | 15009 | 11076 | 105 |
2041419 | 2041419 | 2021-12-23 | Maui | Hawaii | 15009 | 10973 | 105 |
2038169 | 2038169 | 2021-12-22 | Maui | Hawaii | 15009 | 10872 | 105 |
2034919 | 2034919 | 2021-12-21 | Maui | Hawaii | 15009 | 10811 | 104 |
2031669 | 2031669 | 2021-12-20 | Maui | Hawaii | 15009 | 10785 | 104 |
2028418 | 2028418 | 2021-12-19 | Maui | Hawaii | 15009 | 10739 | 104 |
2025167 | 2025167 | 2021-12-18 | Maui | Hawaii | 15009 | 10701 | 103 |
2021916 | 2021916 | 2021-12-17 | Maui | Hawaii | 15009 | 10669 | 103 |
2018665 | 2018665 | 2021-12-16 | Maui | Hawaii | 15009 | 10646 | 103 |
2015415 | 2015415 | 2021-12-15 | Maui | Hawaii | 15009 | 10619 | 103 |
2012164 | 2012164 | 2021-12-14 | Maui | Hawaii | 15009 | 10589 | 102 |
2008913 | 2008913 | 2021-12-13 | Maui | Hawaii | 15009 | 10580 | 102 |
2005662 | 2005662 | 2021-12-12 | Maui | Hawaii | 15009 | 10577 | 102 |
2002411 | 2002411 | 2021-12-11 | Maui | Hawaii | 15009 | 10560 | 102 |
1999161 | 1999161 | 2021-12-10 | Maui | Hawaii | 15009 | 10536 | 102 |
1995910 | 1995910 | 2021-12-09 | Maui | Hawaii | 15009 | 10512 | 102 |
1992659 | 1992659 | 2021-12-08 | Maui | Hawaii | 15009 | 10491 | 102 |
1989408 | 1989408 | 2021-12-07 | Maui | Hawaii | 15009 | 10483 | 102 |
1986158 | 1986158 | 2021-12-06 | Maui | Hawaii | 15009 | 10480 | 102 |
1982908 | 1982908 | 2021-12-05 | Maui | Hawaii | 15009 | 10467 | 102 |
1979658 | 1979658 | 2021-12-04 | Maui | Hawaii | 15009 | 10449 | 102 |
1976408 | 1976408 | 2021-12-03 | Maui | Hawaii | 15009 | 10428 | 102 |
1973159 | 1973159 | 2021-12-02 | Maui | Hawaii | 15009 | 10413 | 102 |
1969909 | 1969909 | 2021-12-01 | Maui | Hawaii | 15009 | 10396 | 102 |
1966659 | 1966659 | 2021-11-30 | Maui | Hawaii | 15009 | 10371 | 99 |
1963407 | 1963407 | 2021-11-29 | Maui | Hawaii | 15009 | 10360 | 99 |
1960156 | 1960156 | 2021-11-28 | Maui | Hawaii | 15009 | 10339 | 99 |
1956905 | 1956905 | 2021-11-27 | Maui | Hawaii | 15009 | 10329 | 99 |
1953654 | 1953654 | 2021-11-26 | Maui | Hawaii | 15009 | 10307 | 99 |
1950403 | 1950403 | 2021-11-25 | Maui | Hawaii | 15009 | 10295 | 99 |
1947152 | 1947152 | 2021-11-24 | Maui | Hawaii | 15009 | 10264 | 99 |
1943901 | 1943901 | 2021-11-23 | Maui | Hawaii | 15009 | 10250 | 99 |
1940651 | 1940651 | 2021-11-22 | Maui | Hawaii | 15009 | 10245 | 99 |
1937401 | 1937401 | 2021-11-21 | Maui | Hawaii | 15009 | 10226 | 99 |
1934151 | 1934151 | 2021-11-20 | Maui | Hawaii | 15009 | 10202 | 99 |
1930899 | 1930899 | 2021-11-19 | Maui | Hawaii | 15009 | 10181 | 99 |
1927649 | 1927649 | 2021-11-18 | Maui | Hawaii | 15009 | 10163 | 99 |
1924399 | 1924399 | 2021-11-17 | Maui | Hawaii | 15009 | 10141 | 99 |
1921150 | 1921150 | 2021-11-16 | Maui | Hawaii | 15009 | 10130 | 98 |
1917900 | 1917900 | 2021-11-15 | Maui | Hawaii | 15009 | 10123 | 98 |
1914650 | 1914650 | 2021-11-14 | Maui | Hawaii | 15009 | 10107 | 98 |
1911400 | 1911400 | 2021-11-13 | Maui | Hawaii | 15009 | 10091 | 98 |
1908151 | 1908151 | 2021-11-12 | Maui | Hawaii | 15009 | 10075 | 98 |
1904902 | 1904902 | 2021-11-11 | Maui | Hawaii | 15009 | 10060 | 98 |
1901652 | 1901652 | 2021-11-10 | Maui | Hawaii | 15009 | 10040 | 98 |
1898402 | 1898402 | 2021-11-09 | Maui | Hawaii | 15009 | 10026 | 98 |
1895152 | 1895152 | 2021-11-08 | Maui | Hawaii | 15009 | 10021 | 98 |
1891902 | 1891902 | 2021-11-07 | Maui | Hawaii | 15009 | 10013 | 98 |
1888652 | 1888652 | 2021-11-06 | Maui | Hawaii | 15009 | 10002 | 96 |
1885402 | 1885402 | 2021-11-05 | Maui | Hawaii | 15009 | 9987 | 94 |
1882153 | 1882153 | 2021-11-04 | Maui | Hawaii | 15009 | 9975 | 94 |
1878904 | 1878904 | 2021-11-03 | Maui | Hawaii | 15009 | 9957 | 94 |
1875655 | 1875655 | 2021-11-02 | Maui | Hawaii | 15009 | 9944 | 94 |
1872406 | 1872406 | 2021-11-01 | Maui | Hawaii | 15009 | 9941 | 94 |
1869157 | 1869157 | 2021-10-31 | Maui | Hawaii | 15009 | 9932 | 94 |
1865908 | 1865908 | 2021-10-30 | Maui | Hawaii | 15009 | 9910 | 94 |
1862659 | 1862659 | 2021-10-29 | Maui | Hawaii | 15009 | 9898 | 94 |
1859410 | 1859410 | 2021-10-28 | Maui | Hawaii | 15009 | 9876 | 94 |
1856161 | 1856161 | 2021-10-27 | Maui | Hawaii | 15009 | 9853 | 94 |
1852912 | 1852912 | 2021-10-26 | Maui | Hawaii | 15009 | 9840 | 94 |
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);