ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 53063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177289 | 2177289 | 2022-02-02 | Spokane | Washington | 53063 | 116250 | 1218 |
2174036 | 2174036 | 2022-02-01 | Spokane | Washington | 53063 | 115136 | 1214 |
2170784 | 2170784 | 2022-01-31 | Spokane | Washington | 53063 | 115136 | 1214 |
2167531 | 2167531 | 2022-01-30 | Spokane | Washington | 53063 | 110883 | 1209 |
2164276 | 2164276 | 2022-01-29 | Spokane | Washington | 53063 | 110883 | 1209 |
2161021 | 2161021 | 2022-01-28 | Spokane | Washington | 53063 | 110883 | 1209 |
2157765 | 2157765 | 2022-01-27 | Spokane | Washington | 53063 | 108028 | 1197 |
2154512 | 2154512 | 2022-01-26 | Spokane | Washington | 53063 | 108028 | 1197 |
2151259 | 2151259 | 2022-01-25 | Spokane | Washington | 53063 | 103644 | 1191 |
2148007 | 2148007 | 2022-01-24 | Spokane | Washington | 53063 | 102835 | 1191 |
2144755 | 2144755 | 2022-01-23 | Spokane | Washington | 53063 | 98265 | 1187 |
2141500 | 2141500 | 2022-01-22 | Spokane | Washington | 53063 | 98265 | 1187 |
2138244 | 2138244 | 2022-01-21 | Spokane | Washington | 53063 | 98265 | 1187 |
2134989 | 2134989 | 2022-01-20 | Spokane | Washington | 53063 | 96575 | 1181 |
2131737 | 2131737 | 2022-01-19 | Spokane | Washington | 53063 | 95510 | 1177 |
2128483 | 2128483 | 2022-01-18 | Spokane | Washington | 53063 | 94894 | 1174 |
2125230 | 2125230 | 2022-01-17 | Spokane | Washington | 53063 | 91203 | 1171 |
2121978 | 2121978 | 2022-01-16 | Spokane | Washington | 53063 | 91203 | 1171 |
2118726 | 2118726 | 2022-01-15 | Spokane | Washington | 53063 | 91203 | 1171 |
2115474 | 2115474 | 2022-01-14 | Spokane | Washington | 53063 | 91203 | 1171 |
2112222 | 2112222 | 2022-01-13 | Spokane | Washington | 53063 | 90347 | 1168 |
2108970 | 2108970 | 2022-01-12 | Spokane | Washington | 53063 | 89500 | 1167 |
2105719 | 2105719 | 2022-01-11 | Spokane | Washington | 53063 | 88261 | 1163 |
2102468 | 2102468 | 2022-01-10 | Spokane | Washington | 53063 | 87355 | 1163 |
2099217 | 2099217 | 2022-01-09 | Spokane | Washington | 53063 | 85246 | 1161 |
2095966 | 2095966 | 2022-01-08 | Spokane | Washington | 53063 | 85246 | 1161 |
2092714 | 2092714 | 2022-01-07 | Spokane | Washington | 53063 | 85246 | 1161 |
2089462 | 2089462 | 2022-01-06 | Spokane | Washington | 53063 | 84403 | 1157 |
2086211 | 2086211 | 2022-01-05 | Spokane | Washington | 53063 | 83538 | 1156 |
2082959 | 2082959 | 2022-01-04 | Spokane | Washington | 53063 | 82917 | 1156 |
2079707 | 2079707 | 2022-01-03 | Spokane | Washington | 53063 | 82199 | 1153 |
2076455 | 2076455 | 2022-01-02 | Spokane | Washington | 53063 | 81271 | 1152 |
2073204 | 2073204 | 2022-01-01 | Spokane | Washington | 53063 | 81271 | 1152 |
2069953 | 2069953 | 2021-12-31 | Spokane | Washington | 53063 | 81271 | 1152 |
2066702 | 2066702 | 2021-12-30 | Spokane | Washington | 53063 | 81271 | 1152 |
2063452 | 2063452 | 2021-12-29 | Spokane | Washington | 53063 | 81066 | 1151 |
2060202 | 2060202 | 2021-12-28 | Spokane | Washington | 53063 | 80796 | 1150 |
2056953 | 2056953 | 2021-12-27 | Spokane | Washington | 53063 | 80615 | 1146 |
2053704 | 2053704 | 2021-12-26 | Spokane | Washington | 53063 | 80124 | 1142 |
2050454 | 2050454 | 2021-12-25 | Spokane | Washington | 53063 | 80124 | 1142 |
2047204 | 2047204 | 2021-12-24 | Spokane | Washington | 53063 | 80124 | 1142 |
2043954 | 2043954 | 2021-12-23 | Spokane | Washington | 53063 | 80124 | 1142 |
2040705 | 2040705 | 2021-12-22 | Spokane | Washington | 53063 | 80124 | 1142 |
2037455 | 2037455 | 2021-12-21 | Spokane | Washington | 53063 | 80068 | 1137 |
2034205 | 2034205 | 2021-12-20 | Spokane | Washington | 53063 | 80001 | 1135 |
2030955 | 2030955 | 2021-12-19 | Spokane | Washington | 53063 | 79802 | 1132 |
2027704 | 2027704 | 2021-12-18 | Spokane | Washington | 53063 | 79802 | 1132 |
2024453 | 2024453 | 2021-12-17 | Spokane | Washington | 53063 | 79802 | 1132 |
2021202 | 2021202 | 2021-12-16 | Spokane | Washington | 53063 | 79732 | 1130 |
2017951 | 2017951 | 2021-12-15 | Spokane | Washington | 53063 | 79633 | 1127 |
2014701 | 2014701 | 2021-12-14 | Spokane | Washington | 53063 | 79565 | 1125 |
2011450 | 2011450 | 2021-12-13 | Spokane | Washington | 53063 | 79475 | 1122 |
2008199 | 2008199 | 2021-12-12 | Spokane | Washington | 53063 | 79251 | 1121 |
2004948 | 2004948 | 2021-12-11 | Spokane | Washington | 53063 | 79251 | 1121 |
2001697 | 2001697 | 2021-12-10 | Spokane | Washington | 53063 | 79251 | 1121 |
1998447 | 1998447 | 2021-12-09 | Spokane | Washington | 53063 | 79166 | 1119 |
1995196 | 1995196 | 2021-12-08 | Spokane | Washington | 53063 | 79050 | 1115 |
1991945 | 1991945 | 2021-12-07 | Spokane | Washington | 53063 | 78960 | 1110 |
1988694 | 1988694 | 2021-12-06 | Spokane | Washington | 53063 | 78811 | 1109 |
1985444 | 1985444 | 2021-12-05 | Spokane | Washington | 53063 | 78576 | 1105 |
1982194 | 1982194 | 2021-12-04 | Spokane | Washington | 53063 | 78576 | 1105 |
1978944 | 1978944 | 2021-12-03 | Spokane | Washington | 53063 | 78576 | 1105 |
1975694 | 1975694 | 2021-12-02 | Spokane | Washington | 53063 | 78463 | 1099 |
1972445 | 1972445 | 2021-12-01 | Spokane | Washington | 53063 | 78307 | 1098 |
1969195 | 1969195 | 2021-11-30 | Spokane | Washington | 53063 | 78085 | 1093 |
1965945 | 1965945 | 2021-11-29 | Spokane | Washington | 53063 | 77869 | 1092 |
1962693 | 1962693 | 2021-11-28 | Spokane | Washington | 53063 | 77492 | 1078 |
1959442 | 1959442 | 2021-11-27 | Spokane | Washington | 53063 | 77492 | 1078 |
1956191 | 1956191 | 2021-11-26 | Spokane | Washington | 53063 | 77492 | 1078 |
1952940 | 1952940 | 2021-11-25 | Spokane | Washington | 53063 | 77492 | 1078 |
1949689 | 1949689 | 2021-11-24 | Spokane | Washington | 53063 | 77492 | 1078 |
1946438 | 1946438 | 2021-11-23 | Spokane | Washington | 53063 | 77420 | 1079 |
1943187 | 1943187 | 2021-11-22 | Spokane | Washington | 53063 | 77332 | 1072 |
1939937 | 1939937 | 2021-11-21 | Spokane | Washington | 53063 | 76947 | 1070 |
1936687 | 1936687 | 2021-11-20 | Spokane | Washington | 53063 | 76947 | 1070 |
1933437 | 1933437 | 2021-11-19 | Spokane | Washington | 53063 | 76947 | 1070 |
1930185 | 1930185 | 2021-11-18 | Spokane | Washington | 53063 | 76803 | 1067 |
1926935 | 1926935 | 2021-11-17 | Spokane | Washington | 53063 | 76604 | 1062 |
1923685 | 1923685 | 2021-11-16 | Spokane | Washington | 53063 | 76401 | 1050 |
1920436 | 1920436 | 2021-11-15 | Spokane | Washington | 53063 | 75811 | 1048 |
1917186 | 1917186 | 2021-11-14 | Spokane | Washington | 53063 | 75811 | 1038 |
1913936 | 1913936 | 2021-11-13 | Spokane | Washington | 53063 | 75811 | 1038 |
1910686 | 1910686 | 2021-11-12 | Spokane | Washington | 53063 | 75811 | 1038 |
1907437 | 1907437 | 2021-11-11 | Spokane | Washington | 53063 | 75357 | 1030 |
1904188 | 1904188 | 2021-11-10 | Spokane | Washington | 53063 | 75357 | 1030 |
1900938 | 1900938 | 2021-11-09 | Spokane | Washington | 53063 | 75233 | 1030 |
1897688 | 1897688 | 2021-11-08 | Spokane | Washington | 53063 | 75019 | 1024 |
1894438 | 1894438 | 2021-11-07 | Spokane | Washington | 53063 | 74458 | 1019 |
1891188 | 1891188 | 2021-11-06 | Spokane | Washington | 53063 | 74458 | 1019 |
1887938 | 1887938 | 2021-11-05 | Spokane | Washington | 53063 | 74458 | 1019 |
1884688 | 1884688 | 2021-11-04 | Spokane | Washington | 53063 | 74280 | 1016 |
1881439 | 1881439 | 2021-11-03 | Spokane | Washington | 53063 | 74105 | 1007 |
1878190 | 1878190 | 2021-11-02 | Spokane | Washington | 53063 | 73808 | 1003 |
1874941 | 1874941 | 2021-11-01 | Spokane | Washington | 53063 | 73642 | 1002 |
1871692 | 1871692 | 2021-10-31 | Spokane | Washington | 53063 | 72851 | 999 |
1868443 | 1868443 | 2021-10-30 | Spokane | Washington | 53063 | 72851 | 999 |
1865194 | 1865194 | 2021-10-29 | Spokane | Washington | 53063 | 72851 | 999 |
1861945 | 1861945 | 2021-10-28 | Spokane | Washington | 53063 | 72642 | 993 |
1858696 | 1858696 | 2021-10-27 | Spokane | Washington | 53063 | 72282 | 990 |
1855447 | 1855447 | 2021-10-26 | Spokane | Washington | 53063 | 71968 | 986 |
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);