ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Juneau City and Borough" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174270 | 2174270 | 2022-02-02 | Juneau City and Borough | Alaska | 2110 | 7166 | 16 |
2171018 | 2171018 | 2022-02-01 | Juneau City and Borough | Alaska | 2110 | 7039 | 16 |
2167765 | 2167765 | 2022-01-31 | Juneau City and Borough | Alaska | 2110 | 7039 | 16 |
2164510 | 2164510 | 2022-01-30 | Juneau City and Borough | Alaska | 2110 | 6868 | 16 |
2161255 | 2161255 | 2022-01-29 | Juneau City and Borough | Alaska | 2110 | 6868 | 16 |
2157999 | 2157999 | 2022-01-28 | Juneau City and Borough | Alaska | 2110 | 6868 | 16 |
2154746 | 2154746 | 2022-01-27 | Juneau City and Borough | Alaska | 2110 | 6700 | 16 |
2151493 | 2151493 | 2022-01-26 | Juneau City and Borough | Alaska | 2110 | 6700 | 16 |
2148241 | 2148241 | 2022-01-25 | Juneau City and Borough | Alaska | 2110 | 6541 | 16 |
2144989 | 2144989 | 2022-01-24 | Juneau City and Borough | Alaska | 2110 | 6541 | 16 |
2141734 | 2141734 | 2022-01-23 | Juneau City and Borough | Alaska | 2110 | 6305 | 16 |
2138478 | 2138478 | 2022-01-22 | Juneau City and Borough | Alaska | 2110 | 6305 | 16 |
2135223 | 2135223 | 2022-01-21 | Juneau City and Borough | Alaska | 2110 | 6305 | 16 |
2131971 | 2131971 | 2022-01-20 | Juneau City and Borough | Alaska | 2110 | 6103 | 16 |
2128717 | 2128717 | 2022-01-19 | Juneau City and Borough | Alaska | 2110 | 6103 | 16 |
2125464 | 2125464 | 2022-01-18 | Juneau City and Borough | Alaska | 2110 | 5595 | 13 |
2122212 | 2122212 | 2022-01-17 | Juneau City and Borough | Alaska | 2110 | 5595 | 13 |
2118960 | 2118960 | 2022-01-16 | Juneau City and Borough | Alaska | 2110 | 5595 | 13 |
2115708 | 2115708 | 2022-01-15 | Juneau City and Borough | Alaska | 2110 | 5595 | 13 |
2112456 | 2112456 | 2022-01-14 | Juneau City and Borough | Alaska | 2110 | 5595 | 13 |
2109204 | 2109204 | 2022-01-13 | Juneau City and Borough | Alaska | 2110 | 5354 | 13 |
2105953 | 2105953 | 2022-01-12 | Juneau City and Borough | Alaska | 2110 | 5354 | 13 |
2102702 | 2102702 | 2022-01-11 | Juneau City and Borough | Alaska | 2110 | 5178 | 13 |
2099451 | 2099451 | 2022-01-10 | Juneau City and Borough | Alaska | 2110 | 5178 | 13 |
2096200 | 2096200 | 2022-01-09 | Juneau City and Borough | Alaska | 2110 | 4967 | 13 |
2092948 | 2092948 | 2022-01-08 | Juneau City and Borough | Alaska | 2110 | 4967 | 13 |
2089696 | 2089696 | 2022-01-07 | Juneau City and Borough | Alaska | 2110 | 4967 | 13 |
2086445 | 2086445 | 2022-01-06 | Juneau City and Borough | Alaska | 2110 | 4759 | 13 |
2083193 | 2083193 | 2022-01-05 | Juneau City and Borough | Alaska | 2110 | 4636 | 13 |
2079941 | 2079941 | 2022-01-04 | Juneau City and Borough | Alaska | 2110 | 4636 | 13 |
2076689 | 2076689 | 2022-01-03 | Juneau City and Borough | Alaska | 2110 | 4636 | 13 |
2073438 | 2073438 | 2022-01-02 | Juneau City and Borough | Alaska | 2110 | 4448 | 13 |
2070187 | 2070187 | 2022-01-01 | Juneau City and Borough | Alaska | 2110 | 4448 | 13 |
2066936 | 2066936 | 2021-12-31 | Juneau City and Borough | Alaska | 2110 | 4448 | 13 |
2063686 | 2063686 | 2021-12-30 | Juneau City and Borough | Alaska | 2110 | 4448 | 13 |
2060436 | 2060436 | 2021-12-29 | Juneau City and Borough | Alaska | 2110 | 4448 | 13 |
2057187 | 2057187 | 2021-12-28 | Juneau City and Borough | Alaska | 2110 | 4370 | 13 |
2053938 | 2053938 | 2021-12-27 | Juneau City and Borough | Alaska | 2110 | 4370 | 13 |
2050688 | 2050688 | 2021-12-26 | Juneau City and Borough | Alaska | 2110 | 4302 | 13 |
2047438 | 2047438 | 2021-12-25 | Juneau City and Borough | Alaska | 2110 | 4302 | 13 |
2044188 | 2044188 | 2021-12-24 | Juneau City and Borough | Alaska | 2110 | 4302 | 13 |
2040939 | 2040939 | 2021-12-23 | Juneau City and Borough | Alaska | 2110 | 4302 | 13 |
2037689 | 2037689 | 2021-12-22 | Juneau City and Borough | Alaska | 2110 | 4302 | 13 |
2034439 | 2034439 | 2021-12-21 | Juneau City and Borough | Alaska | 2110 | 4292 | 13 |
2031189 | 2031189 | 2021-12-20 | Juneau City and Borough | Alaska | 2110 | 4292 | 13 |
2027938 | 2027938 | 2021-12-19 | Juneau City and Borough | Alaska | 2110 | 4272 | 13 |
2024687 | 2024687 | 2021-12-18 | Juneau City and Borough | Alaska | 2110 | 4272 | 13 |
2021436 | 2021436 | 2021-12-17 | Juneau City and Borough | Alaska | 2110 | 4272 | 13 |
2018185 | 2018185 | 2021-12-16 | Juneau City and Borough | Alaska | 2110 | 4257 | 12 |
2014935 | 2014935 | 2021-12-15 | Juneau City and Borough | Alaska | 2110 | 4257 | 12 |
2011684 | 2011684 | 2021-12-14 | Juneau City and Borough | Alaska | 2110 | 4237 | 12 |
2008433 | 2008433 | 2021-12-13 | Juneau City and Borough | Alaska | 2110 | 4237 | 12 |
2005182 | 2005182 | 2021-12-12 | Juneau City and Borough | Alaska | 2110 | 4213 | 12 |
2001931 | 2001931 | 2021-12-11 | Juneau City and Borough | Alaska | 2110 | 4213 | 12 |
1998681 | 1998681 | 2021-12-10 | Juneau City and Borough | Alaska | 2110 | 4213 | 12 |
1995430 | 1995430 | 2021-12-09 | Juneau City and Borough | Alaska | 2110 | 4188 | 12 |
1992179 | 1992179 | 2021-12-08 | Juneau City and Borough | Alaska | 2110 | 4188 | 12 |
1988928 | 1988928 | 2021-12-07 | Juneau City and Borough | Alaska | 2110 | 4174 | 12 |
1985678 | 1985678 | 2021-12-06 | Juneau City and Borough | Alaska | 2110 | 4174 | 12 |
1982428 | 1982428 | 2021-12-05 | Juneau City and Borough | Alaska | 2110 | 4151 | 12 |
1979178 | 1979178 | 2021-12-04 | Juneau City and Borough | Alaska | 2110 | 4151 | 12 |
1975928 | 1975928 | 2021-12-03 | Juneau City and Borough | Alaska | 2110 | 4151 | 12 |
1972679 | 1972679 | 2021-12-02 | Juneau City and Borough | Alaska | 2110 | 4140 | 12 |
1969429 | 1969429 | 2021-12-01 | Juneau City and Borough | Alaska | 2110 | 4127 | 12 |
1966179 | 1966179 | 2021-11-30 | Juneau City and Borough | Alaska | 2110 | 4121 | 12 |
1962927 | 1962927 | 2021-11-29 | Juneau City and Borough | Alaska | 2110 | 4117 | 12 |
1959676 | 1959676 | 2021-11-28 | Juneau City and Borough | Alaska | 2110 | 4098 | 12 |
1956425 | 1956425 | 2021-11-27 | Juneau City and Borough | Alaska | 2110 | 4098 | 12 |
1953174 | 1953174 | 2021-11-26 | Juneau City and Borough | Alaska | 2110 | 4098 | 12 |
1949923 | 1949923 | 2021-11-25 | Juneau City and Borough | Alaska | 2110 | 4083 | 12 |
1946672 | 1946672 | 2021-11-24 | Juneau City and Borough | Alaska | 2110 | 4083 | 12 |
1943421 | 1943421 | 2021-11-23 | Juneau City and Borough | Alaska | 2110 | 4064 | 12 |
1940171 | 1940171 | 2021-11-22 | Juneau City and Borough | Alaska | 2110 | 4058 | 12 |
1936921 | 1936921 | 2021-11-21 | Juneau City and Borough | Alaska | 2110 | 4047 | 12 |
1933671 | 1933671 | 2021-11-20 | Juneau City and Borough | Alaska | 2110 | 4047 | 12 |
1930419 | 1930419 | 2021-11-19 | Juneau City and Borough | Alaska | 2110 | 4047 | 12 |
1927169 | 1927169 | 2021-11-18 | Juneau City and Borough | Alaska | 2110 | 4011 | 12 |
1923919 | 1923919 | 2021-11-17 | Juneau City and Borough | Alaska | 2110 | 4009 | 12 |
1920670 | 1920670 | 2021-11-16 | Juneau City and Borough | Alaska | 2110 | 4009 | 12 |
1917420 | 1917420 | 2021-11-15 | Juneau City and Borough | Alaska | 2110 | 4007 | 11 |
1914170 | 1914170 | 2021-11-14 | Juneau City and Borough | Alaska | 2110 | 3994 | 11 |
1910920 | 1910920 | 2021-11-13 | Juneau City and Borough | Alaska | 2110 | 3994 | 11 |
1907671 | 1907671 | 2021-11-12 | Juneau City and Borough | Alaska | 2110 | 3994 | 11 |
1904422 | 1904422 | 2021-11-11 | Juneau City and Borough | Alaska | 2110 | 3988 | 11 |
1901172 | 1901172 | 2021-11-10 | Juneau City and Borough | Alaska | 2110 | 3988 | 11 |
1897922 | 1897922 | 2021-11-09 | Juneau City and Borough | Alaska | 2110 | 3980 | 11 |
1894672 | 1894672 | 2021-11-08 | Juneau City and Borough | Alaska | 2110 | 3973 | 10 |
1891422 | 1891422 | 2021-11-07 | Juneau City and Borough | Alaska | 2110 | 3952 | 10 |
1888172 | 1888172 | 2021-11-06 | Juneau City and Borough | Alaska | 2110 | 3952 | 10 |
1884922 | 1884922 | 2021-11-05 | Juneau City and Borough | Alaska | 2110 | 3952 | 10 |
1881673 | 1881673 | 2021-11-04 | Juneau City and Borough | Alaska | 2110 | 3935 | 10 |
1878424 | 1878424 | 2021-11-03 | Juneau City and Borough | Alaska | 2110 | 3919 | 10 |
1875175 | 1875175 | 2021-11-02 | Juneau City and Borough | Alaska | 2110 | 3905 | 10 |
1871926 | 1871926 | 2021-11-01 | Juneau City and Borough | Alaska | 2110 | 3897 | 10 |
1868677 | 1868677 | 2021-10-31 | Juneau City and Borough | Alaska | 2110 | 3864 | 10 |
1865428 | 1865428 | 2021-10-30 | Juneau City and Borough | Alaska | 2110 | 3864 | 10 |
1862179 | 1862179 | 2021-10-29 | Juneau City and Borough | Alaska | 2110 | 3864 | 10 |
1858930 | 1858930 | 2021-10-28 | Juneau City and Borough | Alaska | 2110 | 3834 | 10 |
1855681 | 1855681 | 2021-10-27 | Juneau City and Borough | Alaska | 2110 | 3803 | 9 |
1852432 | 1852432 | 2021-10-26 | Juneau City and Borough | Alaska | 2110 | 3788 | 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);