ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where county = "Unknown" and state = "Washington" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
366497 | 366497 | 2020-07-24 | Unknown | Washington | 2 | 2 | |
369706 | 369706 | 2020-07-25 | Unknown | Washington | 2 | 2 | |
372918 | 372918 | 2020-07-26 | Unknown | Washington | 2 | 2 | |
376132 | 376132 | 2020-07-27 | Unknown | Washington | 2 | 2 | |
379348 | 379348 | 2020-07-28 | Unknown | Washington | 2 | 2 | |
382565 | 382565 | 2020-07-29 | Unknown | Washington | 2 | 2 | |
385783 | 385783 | 2020-07-30 | Unknown | Washington | 2 | 2 | |
389000 | 389000 | 2020-07-31 | Unknown | Washington | 2 | 2 | |
392217 | 392217 | 2020-08-01 | Unknown | Washington | 2 | 2 | |
395433 | 395433 | 2020-08-02 | Unknown | Washington | 2 | 2 | |
398649 | 398649 | 2020-08-03 | Unknown | Washington | 2 | 2 | |
401865 | 401865 | 2020-08-04 | Unknown | Washington | 2 | 2 | |
405083 | 405083 | 2020-08-05 | Unknown | Washington | 2 | 2 | |
408303 | 408303 | 2020-08-06 | Unknown | Washington | 2 | 2 | |
411522 | 411522 | 2020-08-07 | Unknown | Washington | 2 | 2 | |
414742 | 414742 | 2020-08-08 | Unknown | Washington | 2 | 2 | |
417963 | 417963 | 2020-08-09 | Unknown | Washington | 2 | 2 | |
421184 | 421184 | 2020-08-10 | Unknown | Washington | 2 | 2 | |
424405 | 424405 | 2020-08-11 | Unknown | Washington | 2 | 2 | |
427629 | 427629 | 2020-08-12 | Unknown | Washington | 2 | 2 | |
430857 | 430857 | 2020-08-13 | Unknown | Washington | 2 | 2 | |
434082 | 434082 | 2020-08-14 | Unknown | Washington | 2 | 2 | |
437308 | 437308 | 2020-08-15 | Unknown | Washington | 2 | 2 | |
440534 | 440534 | 2020-08-16 | Unknown | Washington | 2 | 2 | |
443760 | 443760 | 2020-08-17 | Unknown | Washington | 2 | 2 | |
446987 | 446987 | 2020-08-18 | Unknown | Washington | 2 | 2 | |
450215 | 450215 | 2020-08-19 | Unknown | Washington | 2 | 2 | |
453443 | 453443 | 2020-08-20 | Unknown | Washington | 2 | 2 | |
456671 | 456671 | 2020-08-21 | Unknown | Washington | 2 | 2 | |
459898 | 459898 | 2020-08-22 | Unknown | Washington | 2 | 2 | |
463127 | 463127 | 2020-08-23 | Unknown | Washington | 2 | 2 | |
466356 | 466356 | 2020-08-24 | Unknown | Washington | 2 | 2 | |
469585 | 469585 | 2020-08-25 | Unknown | Washington | 2 | 2 | |
472817 | 472817 | 2020-08-26 | Unknown | Washington | 2 | 2 | |
476050 | 476050 | 2020-08-27 | Unknown | Washington | 2 | 2 | |
479283 | 479283 | 2020-08-28 | Unknown | Washington | 2 | 2 | |
482517 | 482517 | 2020-08-29 | Unknown | Washington | 2 | 2 | |
485752 | 485752 | 2020-08-30 | Unknown | Washington | 2 | 2 | |
488985 | 488985 | 2020-08-31 | Unknown | Washington | 2 | 2 | |
492218 | 492218 | 2020-09-01 | Unknown | Washington | 2 | 2 | |
495452 | 495452 | 2020-09-02 | Unknown | Washington | 2 | 2 | |
498685 | 498685 | 2020-09-03 | Unknown | Washington | 2 | 2 | |
501919 | 501919 | 2020-09-04 | Unknown | Washington | 2 | 2 | |
505153 | 505153 | 2020-09-05 | Unknown | Washington | 2 | 2 | |
508385 | 508385 | 2020-09-06 | Unknown | Washington | 2 | 2 | |
511618 | 511618 | 2020-09-07 | Unknown | Washington | 2 | 2 | |
514851 | 514851 | 2020-09-08 | Unknown | Washington | 2 | 2 | |
518086 | 518086 | 2020-09-09 | Unknown | Washington | 2 | 2 | |
521323 | 521323 | 2020-09-10 | Unknown | Washington | 2 | 2 | |
524559 | 524559 | 2020-09-11 | Unknown | Washington | 2 | 2 | |
527795 | 527795 | 2020-09-12 | Unknown | Washington | 2 | 2 | |
531032 | 531032 | 2020-09-13 | Unknown | Washington | 2 | 2 | |
534267 | 534267 | 2020-09-14 | Unknown | Washington | 2 | 2 | |
537503 | 537503 | 2020-09-15 | Unknown | Washington | 2 | 2 | |
540740 | 540740 | 2020-09-16 | Unknown | Washington | 2 | 2 | |
543976 | 543976 | 2020-09-17 | Unknown | Washington | 2 | 2 | |
547213 | 547213 | 2020-09-18 | Unknown | Washington | 2 | 2 | |
550452 | 550452 | 2020-09-19 | Unknown | Washington | 2 | 2 | |
553691 | 553691 | 2020-09-20 | Unknown | Washington | 2 | 2 | |
556928 | 556928 | 2020-09-21 | Unknown | Washington | 2 | 2 | |
560164 | 560164 | 2020-09-22 | Unknown | Washington | 2 | 2 | |
563403 | 563403 | 2020-09-23 | Unknown | Washington | 2 | 2 | |
566644 | 566644 | 2020-09-24 | Unknown | Washington | 2 | 2 | |
569885 | 569885 | 2020-09-25 | Unknown | Washington | 2 | 2 | |
573127 | 573127 | 2020-09-26 | Unknown | Washington | 2 | 2 | |
576371 | 576371 | 2020-09-27 | Unknown | Washington | 2 | 2 | |
579612 | 579612 | 2020-09-28 | Unknown | Washington | 2 | 2 | |
582851 | 582851 | 2020-09-29 | Unknown | Washington | 2 | 2 | |
586091 | 586091 | 2020-09-30 | Unknown | Washington | 2 | 2 | |
589332 | 589332 | 2020-10-01 | Unknown | Washington | 2 | 2 | |
592572 | 592572 | 2020-10-02 | Unknown | Washington | 2 | 2 | |
595814 | 595814 | 2020-10-03 | Unknown | Washington | 2 | 2 | |
599057 | 599057 | 2020-10-04 | Unknown | Washington | 2 | 2 | |
602300 | 602300 | 2020-10-05 | Unknown | Washington | 2 | 2 | |
605542 | 605542 | 2020-10-06 | Unknown | Washington | 2 | 2 | |
608785 | 608785 | 2020-10-07 | Unknown | Washington | 2 | 2 | |
612027 | 612027 | 2020-10-08 | Unknown | Washington | 2 | 2 | |
615268 | 615268 | 2020-10-09 | Unknown | Washington | 2 | 2 | |
618510 | 618510 | 2020-10-10 | Unknown | Washington | 2 | 2 | |
621753 | 621753 | 2020-10-11 | Unknown | Washington | 2 | 2 | |
624996 | 624996 | 2020-10-12 | Unknown | Washington | 2 | 2 | |
628239 | 628239 | 2020-10-13 | Unknown | Washington | 2 | 2 | |
631483 | 631483 | 2020-10-14 | Unknown | Washington | 2 | 2 | |
634728 | 634728 | 2020-10-15 | Unknown | Washington | 2 | 2 | |
637973 | 637973 | 2020-10-16 | Unknown | Washington | 2 | 2 | |
641220 | 641220 | 2020-10-17 | Unknown | Washington | 2 | 2 | |
644468 | 644468 | 2020-10-18 | Unknown | Washington | 2 | 2 | |
647714 | 647714 | 2020-10-19 | Unknown | Washington | 2 | 2 | |
650958 | 650958 | 2020-10-20 | Unknown | Washington | 2 | 2 | |
654203 | 654203 | 2020-10-21 | Unknown | Washington | 2 | 2 | |
657448 | 657448 | 2020-10-22 | Unknown | Washington | 2 | 2 | |
660692 | 660692 | 2020-10-23 | Unknown | Washington | 2 | 2 | |
663936 | 663936 | 2020-10-24 | Unknown | Washington | 2 | 2 | |
667181 | 667181 | 2020-10-25 | Unknown | Washington | 2 | 2 | |
670424 | 670424 | 2020-10-26 | Unknown | Washington | 2 | 2 | |
673666 | 673666 | 2020-10-27 | Unknown | Washington | 2 | 2 | |
676909 | 676909 | 2020-10-28 | Unknown | Washington | 2 | 2 | |
680152 | 680152 | 2020-10-29 | Unknown | Washington | 2 | 2 | |
683395 | 683395 | 2020-10-30 | Unknown | Washington | 2 | 2 | |
686638 | 686638 | 2020-10-31 | Unknown | Washington | 2 | 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);