ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Douglas" and fips = 53017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388974 | 388974 | 2020-07-31 | Douglas | Washington | 53017 | 747 | 8 |
385757 | 385757 | 2020-07-30 | Douglas | Washington | 53017 | 727 | 8 |
382539 | 382539 | 2020-07-29 | Douglas | Washington | 53017 | 707 | 7 |
379322 | 379322 | 2020-07-28 | Douglas | Washington | 53017 | 682 | 7 |
376106 | 376106 | 2020-07-27 | Douglas | Washington | 53017 | 666 | 7 |
372892 | 372892 | 2020-07-26 | Douglas | Washington | 53017 | 639 | 7 |
369680 | 369680 | 2020-07-25 | Douglas | Washington | 53017 | 619 | 7 |
366471 | 366471 | 2020-07-24 | Douglas | Washington | 53017 | 598 | 6 |
363265 | 363265 | 2020-07-23 | Douglas | Washington | 53017 | 581 | 4 |
360059 | 360059 | 2020-07-22 | Douglas | Washington | 53017 | 576 | 4 |
356854 | 356854 | 2020-07-21 | Douglas | Washington | 53017 | 544 | 4 |
353651 | 353651 | 2020-07-20 | Douglas | Washington | 53017 | 530 | 4 |
350449 | 350449 | 2020-07-19 | Douglas | Washington | 53017 | 491 | 4 |
347248 | 347248 | 2020-07-18 | Douglas | Washington | 53017 | 457 | 4 |
344048 | 344048 | 2020-07-17 | Douglas | Washington | 53017 | 432 | 4 |
340849 | 340849 | 2020-07-16 | Douglas | Washington | 53017 | 422 | 3 |
337653 | 337653 | 2020-07-15 | Douglas | Washington | 53017 | 408 | 3 |
334458 | 334458 | 2020-07-14 | Douglas | Washington | 53017 | 400 | 3 |
331265 | 331265 | 2020-07-13 | Douglas | Washington | 53017 | 396 | 3 |
328079 | 328079 | 2020-07-12 | Douglas | Washington | 53017 | 380 | 3 |
324894 | 324894 | 2020-07-11 | Douglas | Washington | 53017 | 351 | 3 |
321713 | 321713 | 2020-07-10 | Douglas | Washington | 53017 | 351 | 3 |
318534 | 318534 | 2020-07-09 | Douglas | Washington | 53017 | 334 | 3 |
315361 | 315361 | 2020-07-08 | Douglas | Washington | 53017 | 325 | 3 |
312186 | 312186 | 2020-07-07 | Douglas | Washington | 53017 | 310 | 3 |
309017 | 309017 | 2020-07-06 | Douglas | Washington | 53017 | 303 | 3 |
305849 | 305849 | 2020-07-05 | Douglas | Washington | 53017 | 279 | 3 |
302685 | 302685 | 2020-07-04 | Douglas | Washington | 53017 | 273 | 3 |
299521 | 299521 | 2020-07-03 | Douglas | Washington | 53017 | 265 | 3 |
296359 | 296359 | 2020-07-02 | Douglas | Washington | 53017 | 253 | 3 |
293204 | 293204 | 2020-07-01 | Douglas | Washington | 53017 | 245 | 3 |
290051 | 290051 | 2020-06-30 | Douglas | Washington | 53017 | 239 | 3 |
286901 | 286901 | 2020-06-29 | Douglas | Washington | 53017 | 233 | 3 |
283755 | 283755 | 2020-06-28 | Douglas | Washington | 53017 | 230 | 3 |
280609 | 280609 | 2020-06-27 | Douglas | Washington | 53017 | 223 | 3 |
277461 | 277461 | 2020-06-26 | Douglas | Washington | 53017 | 216 | 3 |
274313 | 274313 | 2020-06-25 | Douglas | Washington | 53017 | 210 | 3 |
271173 | 271173 | 2020-06-24 | Douglas | Washington | 53017 | 205 | 3 |
268039 | 268039 | 2020-06-23 | Douglas | Washington | 53017 | 199 | 3 |
264910 | 264910 | 2020-06-22 | Douglas | Washington | 53017 | 196 | 3 |
261781 | 261781 | 2020-06-21 | Douglas | Washington | 53017 | 193 | 3 |
258654 | 258654 | 2020-06-20 | Douglas | Washington | 53017 | 190 | 3 |
255527 | 255527 | 2020-06-19 | Douglas | Washington | 53017 | 190 | 3 |
252408 | 252408 | 2020-06-18 | Douglas | Washington | 53017 | 189 | 3 |
249293 | 249293 | 2020-06-17 | Douglas | Washington | 53017 | 187 | 3 |
246181 | 246181 | 2020-06-16 | Douglas | Washington | 53017 | 187 | 3 |
243068 | 243068 | 2020-06-15 | Douglas | Washington | 53017 | 183 | 3 |
239957 | 239957 | 2020-06-14 | Douglas | Washington | 53017 | 185 | 3 |
236849 | 236849 | 2020-06-13 | Douglas | Washington | 53017 | 181 | 3 |
233742 | 233742 | 2020-06-12 | Douglas | Washington | 53017 | 181 | 3 |
230637 | 230637 | 2020-06-11 | Douglas | Washington | 53017 | 181 | 3 |
227533 | 227533 | 2020-06-10 | Douglas | Washington | 53017 | 181 | 3 |
224433 | 224433 | 2020-06-09 | Douglas | Washington | 53017 | 181 | 3 |
221337 | 221337 | 2020-06-08 | Douglas | Washington | 53017 | 180 | 3 |
218245 | 218245 | 2020-06-07 | Douglas | Washington | 53017 | 180 | 3 |
215155 | 215155 | 2020-06-06 | Douglas | Washington | 53017 | 180 | 3 |
212068 | 212068 | 2020-06-05 | Douglas | Washington | 53017 | 180 | 3 |
208983 | 208983 | 2020-06-04 | Douglas | Washington | 53017 | 176 | 3 |
205901 | 205901 | 2020-06-03 | Douglas | Washington | 53017 | 174 | 3 |
202822 | 202822 | 2020-06-02 | Douglas | Washington | 53017 | 173 | 3 |
199746 | 199746 | 2020-06-01 | Douglas | Washington | 53017 | 173 | 3 |
196673 | 196673 | 2020-05-31 | Douglas | Washington | 53017 | 172 | 3 |
193603 | 193603 | 2020-05-30 | Douglas | Washington | 53017 | 170 | 3 |
190537 | 190537 | 2020-05-29 | Douglas | Washington | 53017 | 168 | 3 |
187473 | 187473 | 2020-05-28 | Douglas | Washington | 53017 | 164 | 3 |
184416 | 184416 | 2020-05-27 | Douglas | Washington | 53017 | 162 | 3 |
181365 | 181365 | 2020-05-26 | Douglas | Washington | 53017 | 159 | 3 |
178321 | 178321 | 2020-05-25 | Douglas | Washington | 53017 | 159 | 3 |
175276 | 175276 | 2020-05-24 | Douglas | Washington | 53017 | 157 | 3 |
172233 | 172233 | 2020-05-23 | Douglas | Washington | 53017 | 147 | 3 |
169192 | 169192 | 2020-05-22 | Douglas | Washington | 53017 | 141 | 3 |
166156 | 166156 | 2020-05-21 | Douglas | Washington | 53017 | 138 | 3 |
163127 | 163127 | 2020-05-20 | Douglas | Washington | 53017 | 131 | 3 |
160099 | 160099 | 2020-05-19 | Douglas | Washington | 53017 | 131 | 3 |
157075 | 157075 | 2020-05-18 | Douglas | Washington | 53017 | 131 | 3 |
154058 | 154058 | 2020-05-17 | Douglas | Washington | 53017 | 127 | 3 |
151047 | 151047 | 2020-05-16 | Douglas | Washington | 53017 | 127 | 3 |
148038 | 148038 | 2020-05-15 | Douglas | Washington | 53017 | 126 | 3 |
145035 | 145035 | 2020-05-14 | Douglas | Washington | 53017 | 123 | 3 |
142038 | 142038 | 2020-05-13 | Douglas | Washington | 53017 | 120 | 3 |
139042 | 139042 | 2020-05-12 | Douglas | Washington | 53017 | 117 | 2 |
136051 | 136051 | 2020-05-11 | Douglas | Washington | 53017 | 117 | 2 |
133061 | 133061 | 2020-05-10 | Douglas | Washington | 53017 | 117 | 2 |
130071 | 130071 | 2020-05-09 | Douglas | Washington | 53017 | 107 | 2 |
127081 | 127081 | 2020-05-08 | Douglas | Washington | 53017 | 102 | 2 |
124096 | 124096 | 2020-05-07 | Douglas | Washington | 53017 | 98 | 2 |
121116 | 121116 | 2020-05-06 | Douglas | Washington | 53017 | 95 | 2 |
118152 | 118152 | 2020-05-05 | Douglas | Washington | 53017 | 84 | 2 |
115193 | 115193 | 2020-05-04 | Douglas | Washington | 53017 | 84 | 1 |
112310 | 112310 | 2020-05-03 | Douglas | Washington | 53017 | 82 | 1 |
109436 | 109436 | 2020-05-02 | Douglas | Washington | 53017 | 82 | 1 |
106567 | 106567 | 2020-05-01 | Douglas | Washington | 53017 | 79 | 1 |
103703 | 103703 | 2020-04-30 | Douglas | Washington | 53017 | 78 | 1 |
100848 | 100848 | 2020-04-29 | Douglas | Washington | 53017 | 77 | 1 |
97998 | 97998 | 2020-04-28 | Douglas | Washington | 53017 | 75 | 1 |
95153 | 95153 | 2020-04-27 | Douglas | Washington | 53017 | 75 | 1 |
92324 | 92324 | 2020-04-26 | Douglas | Washington | 53017 | 72 | 1 |
89507 | 89507 | 2020-04-25 | Douglas | Washington | 53017 | 70 | 1 |
86692 | 86692 | 2020-04-24 | Douglas | Washington | 53017 | 69 | 1 |
83885 | 83885 | 2020-04-23 | Douglas | Washington | 53017 | 63 | 1 |
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);