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 |
---|---|---|---|---|---|---|---|
1056579 | 1056579 | 2021-02-22 | King | Washington | 53033 | 83073 | 1372 |
1053333 | 1053333 | 2021-02-21 | King | Washington | 53033 | 82837 | 1359 |
1050086 | 1050086 | 2021-02-20 | King | Washington | 53033 | 82837 | 1359 |
1046839 | 1046839 | 2021-02-19 | King | Washington | 53033 | 82617 | 1359 |
1043594 | 1043594 | 2021-02-18 | King | Washington | 53033 | 82404 | 1350 |
1040349 | 1040349 | 2021-02-17 | King | Washington | 53033 | 82203 | 1331 |
1037104 | 1037104 | 2021-02-16 | King | Washington | 53033 | 82024 | 1323 |
1033859 | 1033859 | 2021-02-15 | King | Washington | 53033 | 81543 | 1313 |
1030613 | 1030613 | 2021-02-14 | King | Washington | 53033 | 81543 | 1313 |
1027366 | 1027366 | 2021-02-13 | King | Washington | 53033 | 81543 | 1313 |
1024121 | 1024121 | 2021-02-12 | King | Washington | 53033 | 81332 | 1313 |
1020876 | 1020876 | 2021-02-11 | King | Washington | 53033 | 81084 | 1307 |
1017631 | 1017631 | 2021-02-10 | King | Washington | 53033 | 80798 | 1297 |
1014386 | 1014386 | 2021-02-09 | King | Washington | 53033 | 80596 | 1292 |
1011141 | 1011141 | 2021-02-08 | King | Washington | 53033 | 80417 | 1278 |
1007895 | 1007895 | 2021-02-07 | King | Washington | 53033 | 79701 | 1279 |
1004649 | 1004649 | 2021-02-06 | King | Washington | 53033 | 79701 | 1279 |
1001403 | 1001403 | 2021-02-05 | King | Washington | 53033 | 79633 | 1279 |
998157 | 998157 | 2021-02-04 | King | Washington | 53033 | 79342 | 1270 |
994911 | 994911 | 2021-02-03 | King | Washington | 53033 | 79063 | 1266 |
991665 | 991665 | 2021-02-02 | King | Washington | 53033 | 78680 | 1252 |
988419 | 988419 | 2021-02-01 | King | Washington | 53033 | 78391 | 1254 |
985172 | 985172 | 2021-01-31 | King | Washington | 53033 | 78012 | 1244 |
981925 | 981925 | 2021-01-30 | King | Washington | 53033 | 78012 | 1244 |
978679 | 978679 | 2021-01-29 | King | Washington | 53033 | 77693 | 1244 |
975434 | 975434 | 2021-01-28 | King | Washington | 53033 | 77069 | 1235 |
972189 | 972189 | 2021-01-27 | King | Washington | 53033 | 76561 | 1232 |
968944 | 968944 | 2021-01-26 | King | Washington | 53033 | 76148 | 1222 |
965700 | 965700 | 2021-01-25 | King | Washington | 53033 | 75905 | 1221 |
962455 | 962455 | 2021-01-24 | King | Washington | 53033 | 75435 | 1205 |
959210 | 959210 | 2021-01-23 | King | Washington | 53033 | 75435 | 1205 |
955964 | 955964 | 2021-01-22 | King | Washington | 53033 | 74953 | 1205 |
952719 | 952719 | 2021-01-21 | King | Washington | 53033 | 74502 | 1193 |
949474 | 949474 | 2021-01-20 | King | Washington | 53033 | 74079 | 1168 |
946228 | 946228 | 2021-01-19 | King | Washington | 53033 | 73669 | 1168 |
942981 | 942981 | 2021-01-18 | King | Washington | 53033 | 73017 | 1154 |
939736 | 939736 | 2021-01-17 | King | Washington | 53033 | 73017 | 1154 |
936491 | 936491 | 2021-01-16 | King | Washington | 53033 | 72255 | 1154 |
933246 | 933246 | 2021-01-15 | King | Washington | 53033 | 72255 | 1154 |
930001 | 930001 | 2021-01-14 | King | Washington | 53033 | 71648 | 1146 |
926756 | 926756 | 2021-01-13 | King | Washington | 53033 | 71108 | 1137 |
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 |
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);