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 |
---|---|---|---|---|---|---|---|
923510 | 923510 | 2021-01-12 | King | Washington | 53033 | 70547 | 1124 |
920265 | 920265 | 2021-01-11 | King | Washington | 53033 | 70061 | 1107 |
917020 | 917020 | 2021-01-10 | King | Washington | 53033 | 68801 | 1107 |
913775 | 913775 | 2021-01-09 | King | Washington | 53033 | 68801 | 1107 |
910530 | 910530 | 2021-01-08 | King | Washington | 53033 | 67934 | 1107 |
907285 | 907285 | 2021-01-07 | King | Washington | 53033 | 67000 | 1095 |
904039 | 904039 | 2021-01-06 | King | Washington | 53033 | 66288 | 1087 |
900794 | 900794 | 2021-01-05 | King | Washington | 53033 | 65836 | 1070 |
897549 | 897549 | 2021-01-04 | King | Washington | 53033 | 65572 | 1054 |
894303 | 894303 | 2021-01-03 | King | Washington | 53033 | 65267 | 1051 |
891057 | 891057 | 2021-01-02 | King | Washington | 53033 | 62582 | 1052 |
887810 | 887810 | 2021-01-01 | King | Washington | 53033 | 62582 | 1052 |
884565 | 884565 | 2020-12-31 | King | Washington | 53033 | 62582 | 1052 |
881320 | 881320 | 2020-12-30 | King | Washington | 53033 | 61712 | 1039 |
878075 | 878075 | 2020-12-29 | King | Washington | 53033 | 61457 | 1024 |
874830 | 874830 | 2020-12-28 | King | Washington | 53033 | 61150 | 979 |
871585 | 871585 | 2020-12-27 | King | Washington | 53033 | 60695 | 978 |
868340 | 868340 | 2020-12-26 | King | Washington | 53033 | 60695 | 978 |
865095 | 865095 | 2020-12-25 | King | Washington | 53033 | 59896 | 978 |
861850 | 861850 | 2020-12-24 | King | Washington | 53033 | 59896 | 978 |
858605 | 858605 | 2020-12-23 | King | Washington | 53033 | 59385 | 976 |
855360 | 855360 | 2020-12-22 | King | Washington | 53033 | 58970 | 966 |
852115 | 852115 | 2020-12-21 | King | Washington | 53033 | 58749 | 958 |
848870 | 848870 | 2020-12-20 | King | Washington | 53033 | 57785 | 958 |
845625 | 845625 | 2020-12-19 | King | Washington | 53033 | 57785 | 958 |
842379 | 842379 | 2020-12-18 | King | Washington | 53033 | 57136 | 958 |
839134 | 839134 | 2020-12-17 | King | Washington | 53033 | 56270 | 970 |
835888 | 835888 | 2020-12-16 | King | Washington | 53033 | 55231 | 947 |
832642 | 832642 | 2020-12-15 | King | Washington | 53033 | 54868 | 947 |
829395 | 829395 | 2020-12-14 | King | Washington | 53033 | 54668 | 937 |
826149 | 826149 | 2020-12-13 | King | Washington | 53033 | 54036 | 931 |
822902 | 822902 | 2020-12-12 | King | Washington | 53033 | 53365 | 931 |
819656 | 819656 | 2020-12-11 | King | Washington | 53033 | 52594 | 931 |
816410 | 816410 | 2020-12-10 | King | Washington | 53033 | 51690 | 913 |
813164 | 813164 | 2020-12-09 | King | Washington | 53033 | 50989 | 963 |
809920 | 809920 | 2020-12-08 | King | Washington | 53033 | 50345 | 948 |
806675 | 806675 | 2020-12-07 | King | Washington | 53033 | 49758 | 947 |
803430 | 803430 | 2020-12-06 | King | Washington | 53033 | 47637 | 933 |
800185 | 800185 | 2020-12-05 | King | Washington | 53033 | 47274 | 933 |
796940 | 796940 | 2020-12-04 | King | Washington | 53033 | 46950 | 933 |
793695 | 793695 | 2020-12-03 | King | Washington | 53033 | 46192 | 924 |
790450 | 790450 | 2020-12-02 | King | Washington | 53033 | 45830 | 916 |
787205 | 787205 | 2020-12-01 | King | Washington | 53033 | 45157 | 906 |
783961 | 783961 | 2020-11-30 | King | Washington | 53033 | 44425 | 900 |
780716 | 780716 | 2020-11-29 | King | Washington | 53033 | 43856 | 885 |
777470 | 777470 | 2020-11-28 | King | Washington | 53033 | 43403 | 885 |
774225 | 774225 | 2020-11-27 | King | Washington | 53033 | 42922 | 885 |
770980 | 770980 | 2020-11-26 | King | Washington | 53033 | 42122 | 885 |
767734 | 767734 | 2020-11-25 | King | Washington | 53033 | 41519 | 885 |
764489 | 764489 | 2020-11-24 | King | Washington | 53033 | 40755 | 883 |
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 |
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);