ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where deaths = 2 and fips = 53035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
350458 | 350458 | 2020-07-19 | Kitsap | Washington | 53035 | 389 | 2 |
347257 | 347257 | 2020-07-18 | Kitsap | Washington | 53035 | 362 | 2 |
344057 | 344057 | 2020-07-17 | Kitsap | Washington | 53035 | 353 | 2 |
340858 | 340858 | 2020-07-16 | Kitsap | Washington | 53035 | 338 | 2 |
337662 | 337662 | 2020-07-15 | Kitsap | Washington | 53035 | 316 | 2 |
334467 | 334467 | 2020-07-14 | Kitsap | Washington | 53035 | 312 | 2 |
331274 | 331274 | 2020-07-13 | Kitsap | Washington | 53035 | 306 | 2 |
328088 | 328088 | 2020-07-12 | Kitsap | Washington | 53035 | 291 | 2 |
324902 | 324902 | 2020-07-11 | Kitsap | Washington | 53035 | 277 | 2 |
321721 | 321721 | 2020-07-10 | Kitsap | Washington | 53035 | 277 | 2 |
318542 | 318542 | 2020-07-09 | Kitsap | Washington | 53035 | 269 | 2 |
315369 | 315369 | 2020-07-08 | Kitsap | Washington | 53035 | 261 | 2 |
312194 | 312194 | 2020-07-07 | Kitsap | Washington | 53035 | 251 | 2 |
309025 | 309025 | 2020-07-06 | Kitsap | Washington | 53035 | 248 | 2 |
305857 | 305857 | 2020-07-05 | Kitsap | Washington | 53035 | 243 | 2 |
302693 | 302693 | 2020-07-04 | Kitsap | Washington | 53035 | 241 | 2 |
299529 | 299529 | 2020-07-03 | Kitsap | Washington | 53035 | 239 | 2 |
296367 | 296367 | 2020-07-02 | Kitsap | Washington | 53035 | 230 | 2 |
293212 | 293212 | 2020-07-01 | Kitsap | Washington | 53035 | 225 | 2 |
290059 | 290059 | 2020-06-30 | Kitsap | Washington | 53035 | 221 | 2 |
286909 | 286909 | 2020-06-29 | Kitsap | Washington | 53035 | 212 | 2 |
283763 | 283763 | 2020-06-28 | Kitsap | Washington | 53035 | 213 | 2 |
280617 | 280617 | 2020-06-27 | Kitsap | Washington | 53035 | 211 | 2 |
277469 | 277469 | 2020-06-26 | Kitsap | Washington | 53035 | 205 | 2 |
274321 | 274321 | 2020-06-25 | Kitsap | Washington | 53035 | 200 | 2 |
271181 | 271181 | 2020-06-24 | Kitsap | Washington | 53035 | 198 | 2 |
268047 | 268047 | 2020-06-23 | Kitsap | Washington | 53035 | 195 | 2 |
264918 | 264918 | 2020-06-22 | Kitsap | Washington | 53035 | 191 | 2 |
261789 | 261789 | 2020-06-21 | Kitsap | Washington | 53035 | 190 | 2 |
258662 | 258662 | 2020-06-20 | Kitsap | Washington | 53035 | 189 | 2 |
255535 | 255535 | 2020-06-19 | Kitsap | Washington | 53035 | 185 | 2 |
252416 | 252416 | 2020-06-18 | Kitsap | Washington | 53035 | 182 | 2 |
249301 | 249301 | 2020-06-17 | Kitsap | Washington | 53035 | 180 | 2 |
246189 | 246189 | 2020-06-16 | Kitsap | Washington | 53035 | 178 | 2 |
243076 | 243076 | 2020-06-15 | Kitsap | Washington | 53035 | 178 | 2 |
239965 | 239965 | 2020-06-14 | Kitsap | Washington | 53035 | 176 | 2 |
236857 | 236857 | 2020-06-13 | Kitsap | Washington | 53035 | 176 | 2 |
233750 | 233750 | 2020-06-12 | Kitsap | Washington | 53035 | 173 | 2 |
230645 | 230645 | 2020-06-11 | Kitsap | Washington | 53035 | 172 | 2 |
227541 | 227541 | 2020-06-10 | Kitsap | Washington | 53035 | 172 | 2 |
224441 | 224441 | 2020-06-09 | Kitsap | Washington | 53035 | 170 | 2 |
221345 | 221345 | 2020-06-08 | Kitsap | Washington | 53035 | 165 | 2 |
218253 | 218253 | 2020-06-07 | Kitsap | Washington | 53035 | 165 | 2 |
215163 | 215163 | 2020-06-06 | Kitsap | Washington | 53035 | 165 | 2 |
212076 | 212076 | 2020-06-05 | Kitsap | Washington | 53035 | 164 | 2 |
208991 | 208991 | 2020-06-04 | Kitsap | Washington | 53035 | 163 | 2 |
205909 | 205909 | 2020-06-03 | Kitsap | Washington | 53035 | 163 | 2 |
202830 | 202830 | 2020-06-02 | Kitsap | Washington | 53035 | 162 | 2 |
199754 | 199754 | 2020-06-01 | Kitsap | Washington | 53035 | 162 | 2 |
196681 | 196681 | 2020-05-31 | Kitsap | Washington | 53035 | 161 | 2 |
193611 | 193611 | 2020-05-30 | Kitsap | Washington | 53035 | 161 | 2 |
190545 | 190545 | 2020-05-29 | Kitsap | Washington | 53035 | 161 | 2 |
187481 | 187481 | 2020-05-28 | Kitsap | Washington | 53035 | 161 | 2 |
184424 | 184424 | 2020-05-27 | Kitsap | Washington | 53035 | 161 | 2 |
181373 | 181373 | 2020-05-26 | Kitsap | Washington | 53035 | 161 | 2 |
178329 | 178329 | 2020-05-25 | Kitsap | Washington | 53035 | 161 | 2 |
175284 | 175284 | 2020-05-24 | Kitsap | Washington | 53035 | 161 | 2 |
172241 | 172241 | 2020-05-23 | Kitsap | Washington | 53035 | 161 | 2 |
169200 | 169200 | 2020-05-22 | Kitsap | Washington | 53035 | 160 | 2 |
166164 | 166164 | 2020-05-21 | Kitsap | Washington | 53035 | 161 | 2 |
163135 | 163135 | 2020-05-20 | Kitsap | Washington | 53035 | 161 | 2 |
160107 | 160107 | 2020-05-19 | Kitsap | Washington | 53035 | 161 | 2 |
157083 | 157083 | 2020-05-18 | Kitsap | Washington | 53035 | 160 | 2 |
154066 | 154066 | 2020-05-17 | Kitsap | Washington | 53035 | 159 | 2 |
151055 | 151055 | 2020-05-16 | Kitsap | Washington | 53035 | 159 | 2 |
148046 | 148046 | 2020-05-15 | Kitsap | Washington | 53035 | 157 | 2 |
145043 | 145043 | 2020-05-14 | Kitsap | Washington | 53035 | 157 | 2 |
142046 | 142046 | 2020-05-13 | Kitsap | Washington | 53035 | 157 | 2 |
139050 | 139050 | 2020-05-12 | Kitsap | Washington | 53035 | 156 | 2 |
136059 | 136059 | 2020-05-11 | Kitsap | Washington | 53035 | 156 | 2 |
133069 | 133069 | 2020-05-10 | Kitsap | Washington | 53035 | 155 | 2 |
130079 | 130079 | 2020-05-09 | Kitsap | Washington | 53035 | 155 | 2 |
127089 | 127089 | 2020-05-08 | Kitsap | Washington | 53035 | 154 | 2 |
124104 | 124104 | 2020-05-07 | Kitsap | Washington | 53035 | 154 | 2 |
121124 | 121124 | 2020-05-06 | Kitsap | Washington | 53035 | 152 | 2 |
118160 | 118160 | 2020-05-05 | Kitsap | Washington | 53035 | 152 | 2 |
115201 | 115201 | 2020-05-04 | Kitsap | Washington | 53035 | 152 | 2 |
112318 | 112318 | 2020-05-03 | Kitsap | Washington | 53035 | 152 | 2 |
109444 | 109444 | 2020-05-02 | Kitsap | Washington | 53035 | 152 | 2 |
106575 | 106575 | 2020-05-01 | Kitsap | Washington | 53035 | 152 | 2 |
103711 | 103711 | 2020-04-30 | Kitsap | Washington | 53035 | 151 | 2 |
100856 | 100856 | 2020-04-29 | Kitsap | Washington | 53035 | 148 | 2 |
98006 | 98006 | 2020-04-28 | Kitsap | Washington | 53035 | 148 | 2 |
95161 | 95161 | 2020-04-27 | Kitsap | Washington | 53035 | 148 | 2 |
92332 | 92332 | 2020-04-26 | Kitsap | Washington | 53035 | 146 | 2 |
89515 | 89515 | 2020-04-25 | Kitsap | Washington | 53035 | 146 | 2 |
86700 | 86700 | 2020-04-24 | Kitsap | Washington | 53035 | 144 | 2 |
83893 | 83893 | 2020-04-23 | Kitsap | Washington | 53035 | 144 | 2 |
81092 | 81092 | 2020-04-22 | Kitsap | Washington | 53035 | 140 | 2 |
78299 | 78299 | 2020-04-21 | Kitsap | Washington | 53035 | 140 | 2 |
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);