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 |
---|---|---|---|---|---|---|---|
1196184 | 1196184 | 2021-04-06 | King | Washington | 53033 | 92572 | 1477 |
1192936 | 1192936 | 2021-04-05 | King | Washington | 53033 | 92478 | 1475 |
1189686 | 1189686 | 2021-04-04 | King | Washington | 53033 | 91857 | 1472 |
1186439 | 1186439 | 2021-04-03 | King | Washington | 53033 | 91857 | 1472 |
1183192 | 1183192 | 2021-04-02 | King | Washington | 53033 | 91510 | 1472 |
1179945 | 1179945 | 2021-04-01 | King | Washington | 53033 | 91106 | 1470 |
1176698 | 1176698 | 2021-03-31 | King | Washington | 53033 | 90694 | 1467 |
1173451 | 1173451 | 2021-03-30 | King | Washington | 53033 | 90335 | 1466 |
1170204 | 1170204 | 2021-03-29 | King | Washington | 53033 | 90127 | 1463 |
1166956 | 1166956 | 2021-03-28 | King | Washington | 53033 | 89638 | 1460 |
1163708 | 1163708 | 2021-03-27 | King | Washington | 53033 | 89638 | 1460 |
1160460 | 1160460 | 2021-03-26 | King | Washington | 53033 | 89205 | 1460 |
1157212 | 1157212 | 2021-03-25 | King | Washington | 53033 | 88835 | 1462 |
1153965 | 1153965 | 2021-03-24 | King | Washington | 53033 | 88467 | 1460 |
1150718 | 1150718 | 2021-03-23 | King | Washington | 53033 | 88114 | 1454 |
1147471 | 1147471 | 2021-03-22 | King | Washington | 53033 | 88023 | 1453 |
1144224 | 1144224 | 2021-03-21 | King | Washington | 53033 | 87628 | 1451 |
1140977 | 1140977 | 2021-03-20 | King | Washington | 53033 | 87628 | 1451 |
1137731 | 1137731 | 2021-03-19 | King | Washington | 53033 | 87395 | 1451 |
1134485 | 1134485 | 2021-03-18 | King | Washington | 53033 | 87140 | 1451 |
1131237 | 1131237 | 2021-03-17 | King | Washington | 53033 | 86852 | 1444 |
1127990 | 1127990 | 2021-03-16 | King | Washington | 53033 | 86657 | 1445 |
1124744 | 1124744 | 2021-03-15 | King | Washington | 53033 | 86542 | 1442 |
1121498 | 1121498 | 2021-03-14 | King | Washington | 53033 | 86236 | 1441 |
1118251 | 1118251 | 2021-03-13 | King | Washington | 53033 | 86236 | 1441 |
1115004 | 1115004 | 2021-03-12 | King | Washington | 53033 | 86004 | 1441 |
1111758 | 1111758 | 2021-03-11 | King | Washington | 53033 | 85826 | 1437 |
1108512 | 1108512 | 2021-03-10 | King | Washington | 53033 | 85598 | 1435 |
1105266 | 1105266 | 2021-03-09 | King | Washington | 53033 | 85419 | 1429 |
1102020 | 1102020 | 2021-03-08 | King | Washington | 53033 | 85284 | 1427 |
1098774 | 1098774 | 2021-03-07 | King | Washington | 53033 | 85017 | 1417 |
1095526 | 1095526 | 2021-03-06 | King | Washington | 53033 | 85017 | 1417 |
1092280 | 1092280 | 2021-03-05 | King | Washington | 53033 | 84857 | 1417 |
1089034 | 1089034 | 2021-03-04 | King | Washington | 53033 | 84716 | 1415 |
1085789 | 1085789 | 2021-03-03 | King | Washington | 53033 | 84490 | 1408 |
1082543 | 1082543 | 2021-03-02 | King | Washington | 53033 | 84328 | 1399 |
1079297 | 1079297 | 2021-03-01 | King | Washington | 53033 | 84246 | 1396 |
1076052 | 1076052 | 2021-02-28 | King | Washington | 53033 | 84016 | 1396 |
1072806 | 1072806 | 2021-02-27 | King | Washington | 53033 | 84016 | 1396 |
1069560 | 1069560 | 2021-02-26 | King | Washington | 53033 | 83803 | 1396 |
1066315 | 1066315 | 2021-02-25 | King | Washington | 53033 | 83613 | 1392 |
1063070 | 1063070 | 2021-02-24 | King | Washington | 53033 | 83359 | 1382 |
1059825 | 1059825 | 2021-02-23 | King | Washington | 53033 | 83197 | 1373 |
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 |
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);