ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Island" and state = "Washington" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
255532 | 255532 | 2020-06-19 | Island | Washington | 53029 | 186 | 12 |
258659 | 258659 | 2020-06-20 | Island | Washington | 53029 | 188 | 12 |
261786 | 261786 | 2020-06-21 | Island | Washington | 53029 | 188 | 12 |
264915 | 264915 | 2020-06-22 | Island | Washington | 53029 | 187 | 12 |
268044 | 268044 | 2020-06-23 | Island | Washington | 53029 | 187 | 12 |
271178 | 271178 | 2020-06-24 | Island | Washington | 53029 | 188 | 12 |
274318 | 274318 | 2020-06-25 | Island | Washington | 53029 | 191 | 12 |
277466 | 277466 | 2020-06-26 | Island | Washington | 53029 | 191 | 12 |
280614 | 280614 | 2020-06-27 | Island | Washington | 53029 | 192 | 12 |
283760 | 283760 | 2020-06-28 | Island | Washington | 53029 | 192 | 12 |
286906 | 286906 | 2020-06-29 | Island | Washington | 53029 | 192 | 12 |
290056 | 290056 | 2020-06-30 | Island | Washington | 53029 | 192 | 12 |
293209 | 293209 | 2020-07-01 | Island | Washington | 53029 | 195 | 12 |
296364 | 296364 | 2020-07-02 | Island | Washington | 53029 | 195 | 12 |
299526 | 299526 | 2020-07-03 | Island | Washington | 53029 | 196 | 12 |
302690 | 302690 | 2020-07-04 | Island | Washington | 53029 | 197 | 12 |
305854 | 305854 | 2020-07-05 | Island | Washington | 53029 | 198 | 12 |
309022 | 309022 | 2020-07-06 | Island | Washington | 53029 | 198 | 12 |
312191 | 312191 | 2020-07-07 | Island | Washington | 53029 | 198 | 12 |
315366 | 315366 | 2020-07-08 | Island | Washington | 53029 | 201 | 12 |
318539 | 318539 | 2020-07-09 | Island | Washington | 53029 | 202 | 12 |
321718 | 321718 | 2020-07-10 | Island | Washington | 53029 | 203 | 12 |
324899 | 324899 | 2020-07-11 | Island | Washington | 53029 | 203 | 12 |
328085 | 328085 | 2020-07-12 | Island | Washington | 53029 | 206 | 12 |
331271 | 331271 | 2020-07-13 | Island | Washington | 53029 | 206 | 12 |
334464 | 334464 | 2020-07-14 | Island | Washington | 53029 | 206 | 12 |
337659 | 337659 | 2020-07-15 | Island | Washington | 53029 | 211 | 12 |
340855 | 340855 | 2020-07-16 | Island | Washington | 53029 | 211 | 12 |
344054 | 344054 | 2020-07-17 | Island | Washington | 53029 | 214 | 12 |
347254 | 347254 | 2020-07-18 | Island | Washington | 53029 | 214 | 12 |
350455 | 350455 | 2020-07-19 | Island | Washington | 53029 | 215 | 12 |
353657 | 353657 | 2020-07-20 | Island | Washington | 53029 | 217 | 12 |
356860 | 356860 | 2020-07-21 | Island | Washington | 53029 | 217 | 12 |
360065 | 360065 | 2020-07-22 | Island | Washington | 53029 | 221 | 12 |
363271 | 363271 | 2020-07-23 | Island | Washington | 53029 | 221 | 12 |
411502 | 411502 | 2020-08-07 | Island | Washington | 53029 | 251 | 14 |
414722 | 414722 | 2020-08-08 | Island | Washington | 53029 | 251 | 14 |
417943 | 417943 | 2020-08-09 | Island | Washington | 53029 | 252 | 14 |
421164 | 421164 | 2020-08-10 | Island | Washington | 53029 | 251 | 14 |
424385 | 424385 | 2020-08-11 | Island | Washington | 53029 | 252 | 14 |
427609 | 427609 | 2020-08-12 | Island | Washington | 53029 | 252 | 14 |
430837 | 430837 | 2020-08-13 | Island | Washington | 53029 | 252 | 14 |
434062 | 434062 | 2020-08-14 | Island | Washington | 53029 | 253 | 14 |
366477 | 366477 | 2020-07-24 | Island | Washington | 53029 | 228 | 15 |
369686 | 369686 | 2020-07-25 | Island | Washington | 53029 | 228 | 15 |
372898 | 372898 | 2020-07-26 | Island | Washington | 53029 | 228 | 15 |
376112 | 376112 | 2020-07-27 | Island | Washington | 53029 | 234 | 15 |
379328 | 379328 | 2020-07-28 | Island | Washington | 53029 | 234 | 15 |
382545 | 382545 | 2020-07-29 | Island | Washington | 53029 | 235 | 15 |
385763 | 385763 | 2020-07-30 | Island | Washington | 53029 | 237 | 15 |
388980 | 388980 | 2020-07-31 | Island | Washington | 53029 | 239 | 15 |
392197 | 392197 | 2020-08-01 | Island | Washington | 53029 | 240 | 15 |
395413 | 395413 | 2020-08-02 | Island | Washington | 53029 | 242 | 15 |
398629 | 398629 | 2020-08-03 | Island | Washington | 53029 | 242 | 15 |
401845 | 401845 | 2020-08-04 | Island | Washington | 53029 | 244 | 15 |
405063 | 405063 | 2020-08-05 | Island | Washington | 53029 | 244 | 15 |
408283 | 408283 | 2020-08-06 | Island | Washington | 53029 | 244 | 15 |
443740 | 443740 | 2020-08-17 | Island | Washington | 53029 | 257 | 15 |
446967 | 446967 | 2020-08-18 | Island | Washington | 53029 | 257 | 15 |
450195 | 450195 | 2020-08-19 | Island | Washington | 53029 | 261 | 15 |
453423 | 453423 | 2020-08-20 | Island | Washington | 53029 | 262 | 15 |
456651 | 456651 | 2020-08-21 | Island | Washington | 53029 | 267 | 15 |
459878 | 459878 | 2020-08-22 | Island | Washington | 53029 | 267 | 15 |
463107 | 463107 | 2020-08-23 | Island | Washington | 53029 | 267 | 15 |
466336 | 466336 | 2020-08-24 | Island | Washington | 53029 | 268 | 15 |
469565 | 469565 | 2020-08-25 | Island | Washington | 53029 | 270 | 15 |
472797 | 472797 | 2020-08-26 | Island | Washington | 53029 | 271 | 15 |
476030 | 476030 | 2020-08-27 | Island | Washington | 53029 | 271 | 15 |
479263 | 479263 | 2020-08-28 | Island | Washington | 53029 | 272 | 15 |
482497 | 482497 | 2020-08-29 | Island | Washington | 53029 | 272 | 15 |
485732 | 485732 | 2020-08-30 | Island | Washington | 53029 | 273 | 15 |
488965 | 488965 | 2020-08-31 | Island | Washington | 53029 | 275 | 15 |
492198 | 492198 | 2020-09-01 | Island | Washington | 53029 | 275 | 15 |
495432 | 495432 | 2020-09-02 | Island | Washington | 53029 | 275 | 15 |
498665 | 498665 | 2020-09-03 | Island | Washington | 53029 | 275 | 15 |
501899 | 501899 | 2020-09-04 | Island | Washington | 53029 | 276 | 15 |
505133 | 505133 | 2020-09-05 | Island | Washington | 53029 | 276 | 15 |
508365 | 508365 | 2020-09-06 | Island | Washington | 53029 | 277 | 15 |
511598 | 511598 | 2020-09-07 | Island | Washington | 53029 | 277 | 15 |
514831 | 514831 | 2020-09-08 | Island | Washington | 53029 | 277 | 15 |
518066 | 518066 | 2020-09-09 | Island | Washington | 53029 | 277 | 15 |
521303 | 521303 | 2020-09-10 | Island | Washington | 53029 | 277 | 15 |
524539 | 524539 | 2020-09-11 | Island | Washington | 53029 | 280 | 15 |
527775 | 527775 | 2020-09-12 | Island | Washington | 53029 | 281 | 15 |
531012 | 531012 | 2020-09-13 | Island | Washington | 53029 | 281 | 15 |
534247 | 534247 | 2020-09-14 | Island | Washington | 53029 | 285 | 15 |
537483 | 537483 | 2020-09-15 | Island | Washington | 53029 | 285 | 15 |
540720 | 540720 | 2020-09-16 | Island | Washington | 53029 | 290 | 15 |
543956 | 543956 | 2020-09-17 | Island | Washington | 53029 | 290 | 15 |
547193 | 547193 | 2020-09-18 | Island | Washington | 53029 | 294 | 15 |
550432 | 550432 | 2020-09-19 | Island | Washington | 53029 | 295 | 15 |
553671 | 553671 | 2020-09-20 | Island | Washington | 53029 | 295 | 15 |
556908 | 556908 | 2020-09-21 | Island | Washington | 53029 | 300 | 15 |
560144 | 560144 | 2020-09-22 | Island | Washington | 53029 | 302 | 15 |
563383 | 563383 | 2020-09-23 | Island | Washington | 53029 | 310 | 15 |
566624 | 566624 | 2020-09-24 | Island | Washington | 53029 | 310 | 15 |
569865 | 569865 | 2020-09-25 | Island | Washington | 53029 | 318 | 15 |
573107 | 573107 | 2020-09-26 | Island | Washington | 53029 | 318 | 15 |
576351 | 576351 | 2020-09-27 | Island | Washington | 53029 | 318 | 15 |
579592 | 579592 | 2020-09-28 | Island | Washington | 53029 | 319 | 15 |
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);