ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 15007 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174750 | 2174750 | 2022-02-02 | Kauai | Hawaii | 15007 | 9919 | 22 |
2171497 | 2171497 | 2022-02-01 | Kauai | Hawaii | 15007 | 9851 | 22 |
2168244 | 2168244 | 2022-01-31 | Kauai | Hawaii | 15007 | 9823 | 22 |
2164989 | 2164989 | 2022-01-30 | Kauai | Hawaii | 15007 | 9662 | 22 |
2161734 | 2161734 | 2022-01-29 | Kauai | Hawaii | 15007 | 9445 | 22 |
2158478 | 2158478 | 2022-01-28 | Kauai | Hawaii | 15007 | 9344 | 22 |
2155225 | 2155225 | 2022-01-27 | Kauai | Hawaii | 15007 | 9069 | 22 |
2151972 | 2151972 | 2022-01-26 | Kauai | Hawaii | 15007 | 8908 | 21 |
2148720 | 2148720 | 2022-01-25 | Kauai | Hawaii | 15007 | 8809 | 21 |
2145468 | 2145468 | 2022-01-24 | Kauai | Hawaii | 15007 | 8719 | 21 |
2142213 | 2142213 | 2022-01-23 | Kauai | Hawaii | 15007 | 8434 | 21 |
2138958 | 2138958 | 2022-01-22 | Kauai | Hawaii | 15007 | 8266 | 21 |
2135702 | 2135702 | 2022-01-21 | Kauai | Hawaii | 15007 | 7977 | 21 |
2132450 | 2132450 | 2022-01-20 | Kauai | Hawaii | 15007 | 7715 | 20 |
2129197 | 2129197 | 2022-01-19 | Kauai | Hawaii | 15007 | 7439 | 20 |
2125943 | 2125943 | 2022-01-18 | Kauai | Hawaii | 15007 | 7241 | 20 |
2122691 | 2122691 | 2022-01-17 | Kauai | Hawaii | 15007 | 6694 | 20 |
2119439 | 2119439 | 2022-01-16 | Kauai | Hawaii | 15007 | 6513 | 20 |
2116187 | 2116187 | 2022-01-15 | Kauai | Hawaii | 15007 | 6283 | 20 |
2112936 | 2112936 | 2022-01-14 | Kauai | Hawaii | 15007 | 6017 | 20 |
2109684 | 2109684 | 2022-01-13 | Kauai | Hawaii | 15007 | 5986 | 20 |
2106433 | 2106433 | 2022-01-12 | Kauai | Hawaii | 15007 | 5785 | 20 |
2103182 | 2103182 | 2022-01-11 | Kauai | Hawaii | 15007 | 5627 | 19 |
2099931 | 2099931 | 2022-01-10 | Kauai | Hawaii | 15007 | 5447 | 19 |
2096680 | 2096680 | 2022-01-09 | Kauai | Hawaii | 15007 | 5313 | 19 |
2093428 | 2093428 | 2022-01-08 | Kauai | Hawaii | 15007 | 5087 | 18 |
2090176 | 2090176 | 2022-01-07 | Kauai | Hawaii | 15007 | 4902 | 18 |
2086925 | 2086925 | 2022-01-06 | Kauai | Hawaii | 15007 | 4665 | 18 |
2083673 | 2083673 | 2022-01-05 | Kauai | Hawaii | 15007 | 4452 | 18 |
2080421 | 2080421 | 2022-01-04 | Kauai | Hawaii | 15007 | 4341 | 18 |
2077169 | 2077169 | 2022-01-03 | Kauai | Hawaii | 15007 | 4299 | 18 |
2073918 | 2073918 | 2022-01-02 | Kauai | Hawaii | 15007 | 4175 | 18 |
2070667 | 2070667 | 2022-01-01 | Kauai | Hawaii | 15007 | 4046 | 18 |
2067416 | 2067416 | 2021-12-31 | Kauai | Hawaii | 15007 | 3969 | 18 |
2064165 | 2064165 | 2021-12-30 | Kauai | Hawaii | 15007 | 3842 | 18 |
2060915 | 2060915 | 2021-12-29 | Kauai | Hawaii | 15007 | 3695 | 18 |
2057666 | 2057666 | 2021-12-28 | Kauai | Hawaii | 15007 | 3637 | 18 |
2054417 | 2054417 | 2021-12-27 | Kauai | Hawaii | 15007 | 3620 | 18 |
2051167 | 2051167 | 2021-12-26 | Kauai | Hawaii | 15007 | 3597 | 18 |
2047917 | 2047917 | 2021-12-25 | Kauai | Hawaii | 15007 | 3529 | 18 |
2044667 | 2044667 | 2021-12-24 | Kauai | Hawaii | 15007 | 3489 | 15 |
2041418 | 2041418 | 2021-12-23 | Kauai | Hawaii | 15007 | 3422 | 15 |
2038168 | 2038168 | 2021-12-22 | Kauai | Hawaii | 15007 | 3393 | 14 |
2034918 | 2034918 | 2021-12-21 | Kauai | Hawaii | 15007 | 3386 | 14 |
2031668 | 2031668 | 2021-12-20 | Kauai | Hawaii | 15007 | 3376 | 14 |
2028417 | 2028417 | 2021-12-19 | Kauai | Hawaii | 15007 | 3355 | 14 |
2025166 | 2025166 | 2021-12-18 | Kauai | Hawaii | 15007 | 3341 | 13 |
2021915 | 2021915 | 2021-12-17 | Kauai | Hawaii | 15007 | 3319 | 13 |
2018664 | 2018664 | 2021-12-16 | Kauai | Hawaii | 15007 | 3305 | 13 |
2015414 | 2015414 | 2021-12-15 | Kauai | Hawaii | 15007 | 3298 | 13 |
2012163 | 2012163 | 2021-12-14 | Kauai | Hawaii | 15007 | 3285 | 13 |
2008912 | 2008912 | 2021-12-13 | Kauai | Hawaii | 15007 | 3279 | 13 |
2005661 | 2005661 | 2021-12-12 | Kauai | Hawaii | 15007 | 3267 | 13 |
2002410 | 2002410 | 2021-12-11 | Kauai | Hawaii | 15007 | 3256 | 13 |
1999160 | 1999160 | 2021-12-10 | Kauai | Hawaii | 15007 | 3241 | 13 |
1995909 | 1995909 | 2021-12-09 | Kauai | Hawaii | 15007 | 3236 | 13 |
1992658 | 1992658 | 2021-12-08 | Kauai | Hawaii | 15007 | 3228 | 13 |
1989407 | 1989407 | 2021-12-07 | Kauai | Hawaii | 15007 | 3223 | 13 |
1986157 | 1986157 | 2021-12-06 | Kauai | Hawaii | 15007 | 3210 | 13 |
1982907 | 1982907 | 2021-12-05 | Kauai | Hawaii | 15007 | 3197 | 13 |
1979657 | 1979657 | 2021-12-04 | Kauai | Hawaii | 15007 | 3186 | 13 |
1976407 | 1976407 | 2021-12-03 | Kauai | Hawaii | 15007 | 3174 | 13 |
1973158 | 1973158 | 2021-12-02 | Kauai | Hawaii | 15007 | 3156 | 13 |
1969908 | 1969908 | 2021-12-01 | Kauai | Hawaii | 15007 | 3122 | 13 |
1966658 | 1966658 | 2021-11-30 | Kauai | Hawaii | 15007 | 3113 | 13 |
1963406 | 1963406 | 2021-11-29 | Kauai | Hawaii | 15007 | 3087 | 13 |
1960155 | 1960155 | 2021-11-28 | Kauai | Hawaii | 15007 | 3071 | 13 |
1956904 | 1956904 | 2021-11-27 | Kauai | Hawaii | 15007 | 3061 | 13 |
1953653 | 1953653 | 2021-11-26 | Kauai | Hawaii | 15007 | 3034 | 13 |
1950402 | 1950402 | 2021-11-25 | Kauai | Hawaii | 15007 | 3033 | 13 |
1947151 | 1947151 | 2021-11-24 | Kauai | Hawaii | 15007 | 3029 | 13 |
1943900 | 1943900 | 2021-11-23 | Kauai | Hawaii | 15007 | 3006 | 13 |
1940650 | 1940650 | 2021-11-22 | Kauai | Hawaii | 15007 | 2997 | 13 |
1937400 | 1937400 | 2021-11-21 | Kauai | Hawaii | 15007 | 2985 | 13 |
1934150 | 1934150 | 2021-11-20 | Kauai | Hawaii | 15007 | 2974 | 13 |
1930898 | 1930898 | 2021-11-19 | Kauai | Hawaii | 15007 | 2955 | 13 |
1927648 | 1927648 | 2021-11-18 | Kauai | Hawaii | 15007 | 2936 | 13 |
1924398 | 1924398 | 2021-11-17 | Kauai | Hawaii | 15007 | 2915 | 13 |
1921149 | 1921149 | 2021-11-16 | Kauai | Hawaii | 15007 | 2902 | 11 |
1917899 | 1917899 | 2021-11-15 | Kauai | Hawaii | 15007 | 2898 | 11 |
1914649 | 1914649 | 2021-11-14 | Kauai | Hawaii | 15007 | 2879 | 11 |
1911399 | 1911399 | 2021-11-13 | Kauai | Hawaii | 15007 | 2873 | 11 |
1908150 | 1908150 | 2021-11-12 | Kauai | Hawaii | 15007 | 2860 | 11 |
1904901 | 1904901 | 2021-11-11 | Kauai | Hawaii | 15007 | 2839 | 11 |
1901651 | 1901651 | 2021-11-10 | Kauai | Hawaii | 15007 | 2809 | 11 |
1898401 | 1898401 | 2021-11-09 | Kauai | Hawaii | 15007 | 2792 | 11 |
1895151 | 1895151 | 2021-11-08 | Kauai | Hawaii | 15007 | 2776 | 11 |
1891901 | 1891901 | 2021-11-07 | Kauai | Hawaii | 15007 | 2743 | 11 |
1888651 | 1888651 | 2021-11-06 | Kauai | Hawaii | 15007 | 2716 | 10 |
1885401 | 1885401 | 2021-11-05 | Kauai | Hawaii | 15007 | 2708 | 10 |
1882152 | 1882152 | 2021-11-04 | Kauai | Hawaii | 15007 | 2698 | 9 |
1878903 | 1878903 | 2021-11-03 | Kauai | Hawaii | 15007 | 2691 | 9 |
1875654 | 1875654 | 2021-11-02 | Kauai | Hawaii | 15007 | 2666 | 9 |
1872405 | 1872405 | 2021-11-01 | Kauai | Hawaii | 15007 | 2657 | 9 |
1869156 | 1869156 | 2021-10-31 | Kauai | Hawaii | 15007 | 2648 | 9 |
1865907 | 1865907 | 2021-10-30 | Kauai | Hawaii | 15007 | 2634 | 9 |
1862658 | 1862658 | 2021-10-29 | Kauai | Hawaii | 15007 | 2614 | 9 |
1859409 | 1859409 | 2021-10-28 | Kauai | Hawaii | 15007 | 2595 | 9 |
1856160 | 1856160 | 2021-10-27 | Kauai | Hawaii | 15007 | 2586 | 9 |
1852911 | 1852911 | 2021-10-26 | Kauai | Hawaii | 15007 | 2554 | 9 |
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);