ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 53057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177286 | 2177286 | 2022-02-02 | Skagit | Washington | 53057 | 20631 | 170 |
2174033 | 2174033 | 2022-02-01 | Skagit | Washington | 53057 | 20355 | 167 |
2170781 | 2170781 | 2022-01-31 | Skagit | Washington | 53057 | 20355 | 167 |
2167528 | 2167528 | 2022-01-30 | Skagit | Washington | 53057 | 19800 | 164 |
2164273 | 2164273 | 2022-01-29 | Skagit | Washington | 53057 | 19800 | 164 |
2161018 | 2161018 | 2022-01-28 | Skagit | Washington | 53057 | 19800 | 164 |
2157762 | 2157762 | 2022-01-27 | Skagit | Washington | 53057 | 19443 | 164 |
2154509 | 2154509 | 2022-01-26 | Skagit | Washington | 53057 | 19443 | 164 |
2151256 | 2151256 | 2022-01-25 | Skagit | Washington | 53057 | 19009 | 160 |
2148004 | 2148004 | 2022-01-24 | Skagit | Washington | 53057 | 19009 | 160 |
2144752 | 2144752 | 2022-01-23 | Skagit | Washington | 53057 | 18349 | 160 |
2141497 | 2141497 | 2022-01-22 | Skagit | Washington | 53057 | 18349 | 160 |
2138241 | 2138241 | 2022-01-21 | Skagit | Washington | 53057 | 18349 | 160 |
2134986 | 2134986 | 2022-01-20 | Skagit | Washington | 53057 | 18001 | 160 |
2131734 | 2131734 | 2022-01-19 | Skagit | Washington | 53057 | 17689 | 159 |
2128480 | 2128480 | 2022-01-18 | Skagit | Washington | 53057 | 17521 | 159 |
2125227 | 2125227 | 2022-01-17 | Skagit | Washington | 53057 | 16867 | 159 |
2121975 | 2121975 | 2022-01-16 | Skagit | Washington | 53057 | 16867 | 159 |
2118723 | 2118723 | 2022-01-15 | Skagit | Washington | 53057 | 16867 | 159 |
2115471 | 2115471 | 2022-01-14 | Skagit | Washington | 53057 | 16867 | 159 |
2112219 | 2112219 | 2022-01-13 | Skagit | Washington | 53057 | 16621 | 159 |
2108967 | 2108967 | 2022-01-12 | Skagit | Washington | 53057 | 16351 | 159 |
2105716 | 2105716 | 2022-01-11 | Skagit | Washington | 53057 | 15924 | 156 |
2102465 | 2102465 | 2022-01-10 | Skagit | Washington | 53057 | 15768 | 156 |
2099214 | 2099214 | 2022-01-09 | Skagit | Washington | 53057 | 14969 | 156 |
2095963 | 2095963 | 2022-01-08 | Skagit | Washington | 53057 | 14969 | 156 |
2092711 | 2092711 | 2022-01-07 | Skagit | Washington | 53057 | 14969 | 156 |
2089459 | 2089459 | 2022-01-06 | Skagit | Washington | 53057 | 14828 | 155 |
2086208 | 2086208 | 2022-01-05 | Skagit | Washington | 53057 | 14671 | 153 |
2082956 | 2082956 | 2022-01-04 | Skagit | Washington | 53057 | 14522 | 153 |
2079704 | 2079704 | 2022-01-03 | Skagit | Washington | 53057 | 14419 | 152 |
2076452 | 2076452 | 2022-01-02 | Skagit | Washington | 53057 | 13991 | 152 |
2073201 | 2073201 | 2022-01-01 | Skagit | Washington | 53057 | 13991 | 152 |
2069950 | 2069950 | 2021-12-31 | Skagit | Washington | 53057 | 13991 | 152 |
2066699 | 2066699 | 2021-12-30 | Skagit | Washington | 53057 | 13991 | 152 |
2063449 | 2063449 | 2021-12-29 | Skagit | Washington | 53057 | 13886 | 151 |
2060199 | 2060199 | 2021-12-28 | Skagit | Washington | 53057 | 13820 | 150 |
2056950 | 2056950 | 2021-12-27 | Skagit | Washington | 53057 | 13784 | 150 |
2053701 | 2053701 | 2021-12-26 | Skagit | Washington | 53057 | 13591 | 149 |
2050451 | 2050451 | 2021-12-25 | Skagit | Washington | 53057 | 13591 | 149 |
2047201 | 2047201 | 2021-12-24 | Skagit | Washington | 53057 | 13591 | 149 |
2043951 | 2043951 | 2021-12-23 | Skagit | Washington | 53057 | 13591 | 149 |
2040702 | 2040702 | 2021-12-22 | Skagit | Washington | 53057 | 13519 | 148 |
2037452 | 2037452 | 2021-12-21 | Skagit | Washington | 53057 | 13462 | 148 |
2034202 | 2034202 | 2021-12-20 | Skagit | Washington | 53057 | 13429 | 147 |
2030952 | 2030952 | 2021-12-19 | Skagit | Washington | 53057 | 13339 | 148 |
2027701 | 2027701 | 2021-12-18 | Skagit | Washington | 53057 | 13339 | 148 |
2024450 | 2024450 | 2021-12-17 | Skagit | Washington | 53057 | 13339 | 148 |
2021199 | 2021199 | 2021-12-16 | Skagit | Washington | 53057 | 13295 | 147 |
2017948 | 2017948 | 2021-12-15 | Skagit | Washington | 53057 | 13270 | 147 |
2014698 | 2014698 | 2021-12-14 | Skagit | Washington | 53057 | 13245 | 145 |
2011447 | 2011447 | 2021-12-13 | Skagit | Washington | 53057 | 13223 | 144 |
2008196 | 2008196 | 2021-12-12 | Skagit | Washington | 53057 | 13157 | 144 |
2004945 | 2004945 | 2021-12-11 | Skagit | Washington | 53057 | 13157 | 144 |
2001694 | 2001694 | 2021-12-10 | Skagit | Washington | 53057 | 13157 | 144 |
1998444 | 1998444 | 2021-12-09 | Skagit | Washington | 53057 | 13134 | 142 |
1995193 | 1995193 | 2021-12-08 | Skagit | Washington | 53057 | 13109 | 141 |
1991942 | 1991942 | 2021-12-07 | Skagit | Washington | 53057 | 13071 | 139 |
1988691 | 1988691 | 2021-12-06 | Skagit | Washington | 53057 | 13048 | 139 |
1985441 | 1985441 | 2021-12-05 | Skagit | Washington | 53057 | 12954 | 138 |
1982191 | 1982191 | 2021-12-04 | Skagit | Washington | 53057 | 12954 | 138 |
1978941 | 1978941 | 2021-12-03 | Skagit | Washington | 53057 | 12954 | 138 |
1975691 | 1975691 | 2021-12-02 | Skagit | Washington | 53057 | 12916 | 137 |
1972442 | 1972442 | 2021-12-01 | Skagit | Washington | 53057 | 12832 | 134 |
1969192 | 1969192 | 2021-11-30 | Skagit | Washington | 53057 | 12832 | 134 |
1965942 | 1965942 | 2021-11-29 | Skagit | Washington | 53057 | 12788 | 132 |
1962690 | 1962690 | 2021-11-28 | Skagit | Washington | 53057 | 12674 | 127 |
1959439 | 1959439 | 2021-11-27 | Skagit | Washington | 53057 | 12674 | 127 |
1956188 | 1956188 | 2021-11-26 | Skagit | Washington | 53057 | 12674 | 127 |
1952937 | 1952937 | 2021-11-25 | Skagit | Washington | 53057 | 12674 | 127 |
1949686 | 1949686 | 2021-11-24 | Skagit | Washington | 53057 | 12674 | 127 |
1946435 | 1946435 | 2021-11-23 | Skagit | Washington | 53057 | 12642 | 127 |
1943184 | 1943184 | 2021-11-22 | Skagit | Washington | 53057 | 12613 | 126 |
1939934 | 1939934 | 2021-11-21 | Skagit | Washington | 53057 | 12477 | 126 |
1936684 | 1936684 | 2021-11-20 | Skagit | Washington | 53057 | 12477 | 126 |
1933434 | 1933434 | 2021-11-19 | Skagit | Washington | 53057 | 12477 | 126 |
1930182 | 1930182 | 2021-11-18 | Skagit | Washington | 53057 | 12436 | 126 |
1926932 | 1926932 | 2021-11-17 | Skagit | Washington | 53057 | 12380 | 126 |
1923682 | 1923682 | 2021-11-16 | Skagit | Washington | 53057 | 12357 | 126 |
1920433 | 1920433 | 2021-11-15 | Skagit | Washington | 53057 | 12322 | 123 |
1917183 | 1917183 | 2021-11-14 | Skagit | Washington | 53057 | 12170 | 117 |
1913933 | 1913933 | 2021-11-13 | Skagit | Washington | 53057 | 12170 | 117 |
1910683 | 1910683 | 2021-11-12 | Skagit | Washington | 53057 | 12170 | 117 |
1907434 | 1907434 | 2021-11-11 | Skagit | Washington | 53057 | 12036 | 116 |
1904185 | 1904185 | 2021-11-10 | Skagit | Washington | 53057 | 12036 | 116 |
1900935 | 1900935 | 2021-11-09 | Skagit | Washington | 53057 | 11963 | 116 |
1897685 | 1897685 | 2021-11-08 | Skagit | Washington | 53057 | 11923 | 115 |
1894435 | 1894435 | 2021-11-07 | Skagit | Washington | 53057 | 11696 | 115 |
1891185 | 1891185 | 2021-11-06 | Skagit | Washington | 53057 | 11696 | 115 |
1887935 | 1887935 | 2021-11-05 | Skagit | Washington | 53057 | 11696 | 115 |
1884685 | 1884685 | 2021-11-04 | Skagit | Washington | 53057 | 11614 | 115 |
1881436 | 1881436 | 2021-11-03 | Skagit | Washington | 53057 | 11549 | 113 |
1878187 | 1878187 | 2021-11-02 | Skagit | Washington | 53057 | 11492 | 111 |
1874938 | 1874938 | 2021-11-01 | Skagit | Washington | 53057 | 11434 | 111 |
1871689 | 1871689 | 2021-10-31 | Skagit | Washington | 53057 | 11259 | 111 |
1868440 | 1868440 | 2021-10-30 | Skagit | Washington | 53057 | 11259 | 111 |
1865191 | 1865191 | 2021-10-29 | Skagit | Washington | 53057 | 11259 | 111 |
1861942 | 1861942 | 2021-10-28 | Skagit | Washington | 53057 | 11188 | 110 |
1858693 | 1858693 | 2021-10-27 | Skagit | Washington | 53057 | 11096 | 110 |
1855444 | 1855444 | 2021-10-26 | Skagit | Washington | 53057 | 11022 | 110 |
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);