ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
806 rows where fips = 53033 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
761244 | 761244 | 2020-11-23 | King | Washington | 53033 | 40084 | 878 |
757999 | 757999 | 2020-11-22 | King | Washington | 53033 | 38691 | 866 |
754752 | 754752 | 2020-11-21 | King | Washington | 53033 | 38031 | 866 |
751506 | 751506 | 2020-11-20 | King | Washington | 53033 | 37454 | 866 |
748260 | 748260 | 2020-11-19 | King | Washington | 53033 | 36816 | 865 |
745014 | 745014 | 2020-11-18 | King | Washington | 53033 | 36012 | 864 |
741767 | 741767 | 2020-11-17 | King | Washington | 53033 | 35729 | 864 |
738520 | 738520 | 2020-11-16 | King | Washington | 53033 | 35228 | 857 |
735276 | 735276 | 2020-11-15 | King | Washington | 53033 | 34556 | 855 |
732030 | 732030 | 2020-11-14 | King | Washington | 53033 | 34014 | 855 |
728785 | 728785 | 2020-11-13 | King | Washington | 53033 | 33387 | 855 |
725542 | 725542 | 2020-11-12 | King | Washington | 53033 | 32589 | 857 |
722299 | 722299 | 2020-11-11 | King | Washington | 53033 | 31967 | 848 |
719056 | 719056 | 2020-11-10 | King | Washington | 53033 | 31595 | 848 |
715813 | 715813 | 2020-11-09 | King | Washington | 53033 | 31263 | 845 |
712569 | 712569 | 2020-11-08 | King | Washington | 53033 | 30885 | 841 |
709325 | 709325 | 2020-11-07 | King | Washington | 53033 | 30434 | 841 |
706081 | 706081 | 2020-11-06 | King | Washington | 53033 | 30016 | 841 |
702838 | 702838 | 2020-11-05 | King | Washington | 53033 | 29484 | 841 |
699595 | 699595 | 2020-11-04 | King | Washington | 53033 | 28967 | 841 |
696351 | 696351 | 2020-11-03 | King | Washington | 53033 | 28408 | 840 |
693109 | 693109 | 2020-11-02 | King | Washington | 53033 | 28281 | 836 |
689865 | 689865 | 2020-11-01 | King | Washington | 53033 | 27986 | 834 |
686620 | 686620 | 2020-10-31 | King | Washington | 53033 | 27776 | 834 |
683377 | 683377 | 2020-10-30 | King | Washington | 53033 | 27442 | 834 |
680134 | 680134 | 2020-10-29 | King | Washington | 53033 | 27057 | 833 |
676891 | 676891 | 2020-10-28 | King | Washington | 53033 | 26836 | 833 |
673648 | 673648 | 2020-10-27 | King | Washington | 53033 | 26640 | 828 |
670406 | 670406 | 2020-10-26 | King | Washington | 53033 | 26540 | 828 |
667163 | 667163 | 2020-10-25 | King | Washington | 53033 | 26360 | 817 |
663918 | 663918 | 2020-10-24 | King | Washington | 53033 | 26200 | 817 |
660674 | 660674 | 2020-10-23 | King | Washington | 53033 | 25988 | 817 |
657430 | 657430 | 2020-10-22 | King | Washington | 53033 | 25759 | 817 |
654185 | 654185 | 2020-10-21 | King | Washington | 53033 | 25559 | 819 |
650940 | 650940 | 2020-10-20 | King | Washington | 53033 | 25386 | 819 |
647696 | 647696 | 2020-10-19 | King | Washington | 53033 | 25288 | 813 |
644450 | 644450 | 2020-10-18 | King | Washington | 53033 | 25116 | 812 |
641202 | 641202 | 2020-10-17 | King | Washington | 53033 | 25011 | 812 |
637955 | 637955 | 2020-10-16 | King | Washington | 53033 | 24792 | 811 |
634710 | 634710 | 2020-10-15 | King | Washington | 53033 | 24668 | 810 |
631465 | 631465 | 2020-10-14 | King | Washington | 53033 | 24519 | 809 |
628221 | 628221 | 2020-10-13 | King | Washington | 53033 | 24349 | 807 |
624978 | 624978 | 2020-10-12 | King | Washington | 53033 | 24224 | 803 |
621735 | 621735 | 2020-10-11 | King | Washington | 53033 | 24072 | 803 |
618492 | 618492 | 2020-10-10 | King | Washington | 53033 | 23898 | 803 |
615250 | 615250 | 2020-10-09 | King | Washington | 53033 | 23755 | 803 |
612009 | 612009 | 2020-10-08 | King | Washington | 53033 | 23605 | 801 |
608767 | 608767 | 2020-10-07 | King | Washington | 53033 | 23438 | 799 |
605524 | 605524 | 2020-10-06 | King | Washington | 53033 | 23287 | 794 |
602282 | 602282 | 2020-10-05 | King | Washington | 53033 | 23168 | 790 |
599039 | 599039 | 2020-10-04 | King | Washington | 53033 | 23042 | 786 |
595796 | 595796 | 2020-10-03 | King | Washington | 53033 | 22960 | 786 |
592554 | 592554 | 2020-10-02 | King | Washington | 53033 | 22807 | 786 |
589314 | 589314 | 2020-10-01 | King | Washington | 53033 | 22579 | 778 |
586073 | 586073 | 2020-09-30 | King | Washington | 53033 | 22419 | 780 |
582833 | 582833 | 2020-09-29 | King | Washington | 53033 | 22282 | 780 |
579594 | 579594 | 2020-09-28 | King | Washington | 53033 | 22231 | 787 |
576353 | 576353 | 2020-09-27 | King | Washington | 53033 | 22137 | 787 |
573109 | 573109 | 2020-09-26 | King | Washington | 53033 | 22019 | 787 |
569867 | 569867 | 2020-09-25 | King | Washington | 53033 | 21915 | 787 |
566626 | 566626 | 2020-09-24 | King | Washington | 53033 | 21822 | 778 |
563385 | 563385 | 2020-09-23 | King | Washington | 53033 | 21696 | 778 |
560146 | 560146 | 2020-09-22 | King | Washington | 53033 | 21609 | 776 |
556910 | 556910 | 2020-09-21 | King | Washington | 53033 | 21552 | 772 |
553673 | 553673 | 2020-09-20 | King | Washington | 53033 | 21478 | 770 |
550434 | 550434 | 2020-09-19 | King | Washington | 53033 | 21418 | 770 |
547195 | 547195 | 2020-09-18 | King | Washington | 53033 | 21323 | 770 |
543958 | 543958 | 2020-09-17 | King | Washington | 53033 | 21215 | 769 |
540722 | 540722 | 2020-09-16 | King | Washington | 53033 | 21177 | 768 |
537485 | 537485 | 2020-09-15 | King | Washington | 53033 | 21032 | 767 |
534249 | 534249 | 2020-09-14 | King | Washington | 53033 | 20950 | 766 |
531014 | 531014 | 2020-09-13 | King | Washington | 53033 | 20887 | 763 |
527777 | 527777 | 2020-09-12 | King | Washington | 53033 | 20819 | 763 |
524541 | 524541 | 2020-09-11 | King | Washington | 53033 | 20718 | 763 |
521305 | 521305 | 2020-09-10 | King | Washington | 53033 | 20585 | 763 |
518068 | 518068 | 2020-09-09 | King | Washington | 53033 | 20459 | 762 |
514833 | 514833 | 2020-09-08 | King | Washington | 53033 | 20345 | 755 |
511600 | 511600 | 2020-09-07 | King | Washington | 53033 | 20339 | 755 |
508367 | 508367 | 2020-09-06 | King | Washington | 53033 | 20283 | 755 |
505135 | 505135 | 2020-09-05 | King | Washington | 53033 | 20184 | 754 |
501901 | 501901 | 2020-09-04 | King | Washington | 53033 | 20092 | 754 |
498667 | 498667 | 2020-09-03 | King | Washington | 53033 | 19934 | 751 |
495434 | 495434 | 2020-09-02 | King | Washington | 53033 | 19838 | 750 |
492200 | 492200 | 2020-09-01 | King | Washington | 53033 | 19730 | 747 |
488967 | 488967 | 2020-08-31 | King | Washington | 53033 | 19684 | 742 |
485734 | 485734 | 2020-08-30 | King | Washington | 53033 | 19573 | 742 |
482499 | 482499 | 2020-08-29 | King | Washington | 53033 | 19499 | 742 |
479265 | 479265 | 2020-08-28 | King | Washington | 53033 | 19380 | 742 |
476032 | 476032 | 2020-08-27 | King | Washington | 53033 | 19196 | 741 |
472799 | 472799 | 2020-08-26 | King | Washington | 53033 | 19068 | 738 |
469567 | 469567 | 2020-08-25 | King | Washington | 53033 | 18896 | 734 |
466338 | 466338 | 2020-08-24 | King | Washington | 53033 | 18843 | 735 |
463109 | 463109 | 2020-08-23 | King | Washington | 53033 | 18697 | 732 |
459880 | 459880 | 2020-08-22 | King | Washington | 53033 | 18589 | 731 |
456653 | 456653 | 2020-08-21 | King | Washington | 53033 | 18437 | 729 |
453425 | 453425 | 2020-08-20 | King | Washington | 53033 | 18332 | 726 |
450197 | 450197 | 2020-08-19 | King | Washington | 53033 | 18149 | 720 |
446969 | 446969 | 2020-08-18 | King | Washington | 53033 | 18008 | 717 |
443742 | 443742 | 2020-08-17 | King | Washington | 53033 | 17843 | 713 |
440516 | 440516 | 2020-08-16 | King | Washington | 53033 | 17662 | 713 |
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);