ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lewis" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177278 | 2177278 | 2022-02-02 | Lewis | Washington | 53041 | 16040 | 213 |
2174025 | 2174025 | 2022-02-01 | Lewis | Washington | 53041 | 15857 | 212 |
2170773 | 2170773 | 2022-01-31 | Lewis | Washington | 53041 | 15857 | 212 |
2167520 | 2167520 | 2022-01-30 | Lewis | Washington | 53041 | 15352 | 209 |
2164265 | 2164265 | 2022-01-29 | Lewis | Washington | 53041 | 15352 | 209 |
2161010 | 2161010 | 2022-01-28 | Lewis | Washington | 53041 | 15352 | 209 |
2157754 | 2157754 | 2022-01-27 | Lewis | Washington | 53041 | 15038 | 206 |
2154501 | 2154501 | 2022-01-26 | Lewis | Washington | 53041 | 15038 | 206 |
2151248 | 2151248 | 2022-01-25 | Lewis | Washington | 53041 | 14690 | 205 |
2147996 | 2147996 | 2022-01-24 | Lewis | Washington | 53041 | 14690 | 205 |
2144744 | 2144744 | 2022-01-23 | Lewis | Washington | 53041 | 14244 | 203 |
2141489 | 2141489 | 2022-01-22 | Lewis | Washington | 53041 | 14244 | 203 |
2138233 | 2138233 | 2022-01-21 | Lewis | Washington | 53041 | 14244 | 203 |
2134978 | 2134978 | 2022-01-20 | Lewis | Washington | 53041 | 14038 | 201 |
2131726 | 2131726 | 2022-01-19 | Lewis | Washington | 53041 | 13866 | 201 |
2128472 | 2128472 | 2022-01-18 | Lewis | Washington | 53041 | 13676 | 201 |
2125219 | 2125219 | 2022-01-17 | Lewis | Washington | 53041 | 13110 | 201 |
2121967 | 2121967 | 2022-01-16 | Lewis | Washington | 53041 | 13110 | 201 |
2118715 | 2118715 | 2022-01-15 | Lewis | Washington | 53041 | 13110 | 201 |
2115463 | 2115463 | 2022-01-14 | Lewis | Washington | 53041 | 13110 | 201 |
2112211 | 2112211 | 2022-01-13 | Lewis | Washington | 53041 | 13042 | 198 |
2108959 | 2108959 | 2022-01-12 | Lewis | Washington | 53041 | 12932 | 195 |
2105708 | 2105708 | 2022-01-11 | Lewis | Washington | 53041 | 12832 | 194 |
2102457 | 2102457 | 2022-01-10 | Lewis | Washington | 53041 | 12760 | 194 |
2099206 | 2099206 | 2022-01-09 | Lewis | Washington | 53041 | 12342 | 193 |
2095955 | 2095955 | 2022-01-08 | Lewis | Washington | 53041 | 12342 | 193 |
2092703 | 2092703 | 2022-01-07 | Lewis | Washington | 53041 | 12342 | 193 |
2089451 | 2089451 | 2022-01-06 | Lewis | Washington | 53041 | 12238 | 191 |
2086200 | 2086200 | 2022-01-05 | Lewis | Washington | 53041 | 12077 | 190 |
2082948 | 2082948 | 2022-01-04 | Lewis | Washington | 53041 | 11986 | 190 |
2079696 | 2079696 | 2022-01-03 | Lewis | Washington | 53041 | 11972 | 188 |
2076444 | 2076444 | 2022-01-02 | Lewis | Washington | 53041 | 11754 | 188 |
2073193 | 2073193 | 2022-01-01 | Lewis | Washington | 53041 | 11754 | 188 |
2069942 | 2069942 | 2021-12-31 | Lewis | Washington | 53041 | 11754 | 188 |
2066691 | 2066691 | 2021-12-30 | Lewis | Washington | 53041 | 11754 | 188 |
2063441 | 2063441 | 2021-12-29 | Lewis | Washington | 53041 | 11717 | 187 |
2060191 | 2060191 | 2021-12-28 | Lewis | Washington | 53041 | 11697 | 187 |
2056942 | 2056942 | 2021-12-27 | Lewis | Washington | 53041 | 11685 | 187 |
2053693 | 2053693 | 2021-12-26 | Lewis | Washington | 53041 | 11552 | 187 |
2050443 | 2050443 | 2021-12-25 | Lewis | Washington | 53041 | 11552 | 187 |
2047193 | 2047193 | 2021-12-24 | Lewis | Washington | 53041 | 11552 | 187 |
2043943 | 2043943 | 2021-12-23 | Lewis | Washington | 53041 | 11552 | 187 |
2040694 | 2040694 | 2021-12-22 | Lewis | Washington | 53041 | 11510 | 187 |
2037444 | 2037444 | 2021-12-21 | Lewis | Washington | 53041 | 11494 | 186 |
2034194 | 2034194 | 2021-12-20 | Lewis | Washington | 53041 | 11461 | 185 |
2030944 | 2030944 | 2021-12-19 | Lewis | Washington | 53041 | 11414 | 184 |
2027693 | 2027693 | 2021-12-18 | Lewis | Washington | 53041 | 11414 | 184 |
2024442 | 2024442 | 2021-12-17 | Lewis | Washington | 53041 | 11414 | 184 |
2021191 | 2021191 | 2021-12-16 | Lewis | Washington | 53041 | 11396 | 184 |
2017940 | 2017940 | 2021-12-15 | Lewis | Washington | 53041 | 11362 | 184 |
2014690 | 2014690 | 2021-12-14 | Lewis | Washington | 53041 | 11326 | 184 |
2011439 | 2011439 | 2021-12-13 | Lewis | Washington | 53041 | 11323 | 184 |
2008188 | 2008188 | 2021-12-12 | Lewis | Washington | 53041 | 11277 | 180 |
2004937 | 2004937 | 2021-12-11 | Lewis | Washington | 53041 | 11277 | 180 |
2001686 | 2001686 | 2021-12-10 | Lewis | Washington | 53041 | 11277 | 180 |
1998436 | 1998436 | 2021-12-09 | Lewis | Washington | 53041 | 11246 | 180 |
1995185 | 1995185 | 2021-12-08 | Lewis | Washington | 53041 | 11208 | 180 |
1991934 | 1991934 | 2021-12-07 | Lewis | Washington | 53041 | 11180 | 177 |
1988683 | 1988683 | 2021-12-06 | Lewis | Washington | 53041 | 11137 | 176 |
1985433 | 1985433 | 2021-12-05 | Lewis | Washington | 53041 | 11060 | 175 |
1982183 | 1982183 | 2021-12-04 | Lewis | Washington | 53041 | 11060 | 175 |
1978933 | 1978933 | 2021-12-03 | Lewis | Washington | 53041 | 11060 | 175 |
1975683 | 1975683 | 2021-12-02 | Lewis | Washington | 53041 | 11033 | 173 |
1972434 | 1972434 | 2021-12-01 | Lewis | Washington | 53041 | 10941 | 172 |
1969184 | 1969184 | 2021-11-30 | Lewis | Washington | 53041 | 10941 | 172 |
1965934 | 1965934 | 2021-11-29 | Lewis | Washington | 53041 | 10904 | 172 |
1962682 | 1962682 | 2021-11-28 | Lewis | Washington | 53041 | 10819 | 171 |
1959431 | 1959431 | 2021-11-27 | Lewis | Washington | 53041 | 10819 | 171 |
1956180 | 1956180 | 2021-11-26 | Lewis | Washington | 53041 | 10819 | 171 |
1952929 | 1952929 | 2021-11-25 | Lewis | Washington | 53041 | 10819 | 171 |
1949678 | 1949678 | 2021-11-24 | Lewis | Washington | 53041 | 10819 | 171 |
1946427 | 1946427 | 2021-11-23 | Lewis | Washington | 53041 | 10805 | 171 |
1943176 | 1943176 | 2021-11-22 | Lewis | Washington | 53041 | 10776 | 168 |
1939926 | 1939926 | 2021-11-21 | Lewis | Washington | 53041 | 10724 | 167 |
1936676 | 1936676 | 2021-11-20 | Lewis | Washington | 53041 | 10724 | 167 |
1933426 | 1933426 | 2021-11-19 | Lewis | Washington | 53041 | 10724 | 167 |
1930174 | 1930174 | 2021-11-18 | Lewis | Washington | 53041 | 10692 | 163 |
1926924 | 1926924 | 2021-11-17 | Lewis | Washington | 53041 | 10676 | 163 |
1923674 | 1923674 | 2021-11-16 | Lewis | Washington | 53041 | 10613 | 161 |
1920425 | 1920425 | 2021-11-15 | Lewis | Washington | 53041 | 10577 | 159 |
1917175 | 1917175 | 2021-11-14 | Lewis | Washington | 53041 | 10491 | 158 |
1913925 | 1913925 | 2021-11-13 | Lewis | Washington | 53041 | 10491 | 158 |
1910675 | 1910675 | 2021-11-12 | Lewis | Washington | 53041 | 10491 | 158 |
1907426 | 1907426 | 2021-11-11 | Lewis | Washington | 53041 | 10396 | 158 |
1904177 | 1904177 | 2021-11-10 | Lewis | Washington | 53041 | 10396 | 158 |
1900927 | 1900927 | 2021-11-09 | Lewis | Washington | 53041 | 10359 | 158 |
1897677 | 1897677 | 2021-11-08 | Lewis | Washington | 53041 | 10347 | 157 |
1894427 | 1894427 | 2021-11-07 | Lewis | Washington | 53041 | 10272 | 156 |
1891177 | 1891177 | 2021-11-06 | Lewis | Washington | 53041 | 10272 | 156 |
1887927 | 1887927 | 2021-11-05 | Lewis | Washington | 53041 | 10272 | 156 |
1884677 | 1884677 | 2021-11-04 | Lewis | Washington | 53041 | 10227 | 155 |
1881428 | 1881428 | 2021-11-03 | Lewis | Washington | 53041 | 10181 | 155 |
1878179 | 1878179 | 2021-11-02 | Lewis | Washington | 53041 | 10147 | 155 |
1874930 | 1874930 | 2021-11-01 | Lewis | Washington | 53041 | 10133 | 154 |
1871681 | 1871681 | 2021-10-31 | Lewis | Washington | 53041 | 10080 | 154 |
1868432 | 1868432 | 2021-10-30 | Lewis | Washington | 53041 | 10080 | 154 |
1865183 | 1865183 | 2021-10-29 | Lewis | Washington | 53041 | 10080 | 154 |
1861934 | 1861934 | 2021-10-28 | Lewis | Washington | 53041 | 10031 | 153 |
1858685 | 1858685 | 2021-10-27 | Lewis | Washington | 53041 | 9983 | 152 |
1855436 | 1855436 | 2021-10-26 | Lewis | Washington | 53041 | 9945 | 152 |
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);