ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
844 rows where fips = 53061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280632 | 1280632 | 2021-05-02 | Snohomish | Washington | 53061 | 36093 | 566 |
1277385 | 1277385 | 2021-05-01 | Snohomish | Washington | 53061 | 36093 | 566 |
1274138 | 1274138 | 2021-04-30 | Snohomish | Washington | 53061 | 35942 | 566 |
1270891 | 1270891 | 2021-04-29 | Snohomish | Washington | 53061 | 35792 | 567 |
1267644 | 1267644 | 2021-04-28 | Snohomish | Washington | 53061 | 35643 | 565 |
1264397 | 1264397 | 2021-04-27 | Snohomish | Washington | 53061 | 35482 | 564 |
1261150 | 1261150 | 2021-04-26 | Snohomish | Washington | 53061 | 35313 | 564 |
1257903 | 1257903 | 2021-04-25 | Snohomish | Washington | 53061 | 35132 | 563 |
1254656 | 1254656 | 2021-04-24 | Snohomish | Washington | 53061 | 35132 | 563 |
1251409 | 1251409 | 2021-04-23 | Snohomish | Washington | 53061 | 35019 | 563 |
1248162 | 1248162 | 2021-04-22 | Snohomish | Washington | 53061 | 34859 | 563 |
1244915 | 1244915 | 2021-04-21 | Snohomish | Washington | 53061 | 34718 | 563 |
1241668 | 1241668 | 2021-04-20 | Snohomish | Washington | 53061 | 34523 | 563 |
1238421 | 1238421 | 2021-04-19 | Snohomish | Washington | 53061 | 34336 | 563 |
1235174 | 1235174 | 2021-04-18 | Snohomish | Washington | 53061 | 34236 | 564 |
1231926 | 1231926 | 2021-04-17 | Snohomish | Washington | 53061 | 34236 | 564 |
1228678 | 1228678 | 2021-04-16 | Snohomish | Washington | 53061 | 34114 | 564 |
1225430 | 1225430 | 2021-04-15 | Snohomish | Washington | 53061 | 34114 | 564 |
1222183 | 1222183 | 2021-04-14 | Snohomish | Washington | 53061 | 34114 | 564 |
1218935 | 1218935 | 2021-04-13 | Snohomish | Washington | 53061 | 34114 | 564 |
1215687 | 1215687 | 2021-04-12 | Snohomish | Washington | 53061 | 34114 | 564 |
1212440 | 1212440 | 2021-04-11 | Snohomish | Washington | 53061 | 33277 | 563 |
1209191 | 1209191 | 2021-04-10 | Snohomish | Washington | 53061 | 33277 | 563 |
1205943 | 1205943 | 2021-04-09 | Snohomish | Washington | 53061 | 33271 | 563 |
1202695 | 1202695 | 2021-04-08 | Snohomish | Washington | 53061 | 33271 | 563 |
1199447 | 1199447 | 2021-04-07 | Snohomish | Washington | 53061 | 33271 | 563 |
1196198 | 1196198 | 2021-04-06 | Snohomish | Washington | 53061 | 33271 | 563 |
1192950 | 1192950 | 2021-04-05 | Snohomish | Washington | 53061 | 33271 | 563 |
1189700 | 1189700 | 2021-04-04 | Snohomish | Washington | 53061 | 32600 | 558 |
1186453 | 1186453 | 2021-04-03 | Snohomish | Washington | 53061 | 32600 | 558 |
1183206 | 1183206 | 2021-04-02 | Snohomish | Washington | 53061 | 32600 | 558 |
1179959 | 1179959 | 2021-04-01 | Snohomish | Washington | 53061 | 32600 | 558 |
1176712 | 1176712 | 2021-03-31 | Snohomish | Washington | 53061 | 32600 | 558 |
1173465 | 1173465 | 2021-03-30 | Snohomish | Washington | 53061 | 32600 | 558 |
1170218 | 1170218 | 2021-03-29 | Snohomish | Washington | 53061 | 32600 | 558 |
1166970 | 1166970 | 2021-03-28 | Snohomish | Washington | 53061 | 32426 | 558 |
1163722 | 1163722 | 2021-03-27 | Snohomish | Washington | 53061 | 32426 | 558 |
1160474 | 1160474 | 2021-03-26 | Snohomish | Washington | 53061 | 32426 | 558 |
1157226 | 1157226 | 2021-03-25 | Snohomish | Washington | 53061 | 32336 | 558 |
1153979 | 1153979 | 2021-03-24 | Snohomish | Washington | 53061 | 32242 | 554 |
1150732 | 1150732 | 2021-03-23 | Snohomish | Washington | 53061 | 32195 | 554 |
1147485 | 1147485 | 2021-03-22 | Snohomish | Washington | 53061 | 32145 | 553 |
1144238 | 1144238 | 2021-03-21 | Snohomish | Washington | 53061 | 31962 | 552 |
1140991 | 1140991 | 2021-03-20 | Snohomish | Washington | 53061 | 31962 | 552 |
1137745 | 1137745 | 2021-03-19 | Snohomish | Washington | 53061 | 31962 | 552 |
1134499 | 1134499 | 2021-03-18 | Snohomish | Washington | 53061 | 31912 | 552 |
1131251 | 1131251 | 2021-03-17 | Snohomish | Washington | 53061 | 31848 | 550 |
1128004 | 1128004 | 2021-03-16 | Snohomish | Washington | 53061 | 31775 | 550 |
1124758 | 1124758 | 2021-03-15 | Snohomish | Washington | 53061 | 31736 | 548 |
1121512 | 1121512 | 2021-03-14 | Snohomish | Washington | 53061 | 31617 | 548 |
1118265 | 1118265 | 2021-03-13 | Snohomish | Washington | 53061 | 31617 | 548 |
1115018 | 1115018 | 2021-03-12 | Snohomish | Washington | 53061 | 31617 | 548 |
1111772 | 1111772 | 2021-03-11 | Snohomish | Washington | 53061 | 31558 | 548 |
1108526 | 1108526 | 2021-03-10 | Snohomish | Washington | 53061 | 31510 | 548 |
1105280 | 1105280 | 2021-03-09 | Snohomish | Washington | 53061 | 31477 | 547 |
1102034 | 1102034 | 2021-03-08 | Snohomish | Washington | 53061 | 31439 | 545 |
1098788 | 1098788 | 2021-03-07 | Snohomish | Washington | 53061 | 31299 | 546 |
1095540 | 1095540 | 2021-03-06 | Snohomish | Washington | 53061 | 31299 | 546 |
1092294 | 1092294 | 2021-03-05 | Snohomish | Washington | 53061 | 31299 | 546 |
1089048 | 1089048 | 2021-03-04 | Snohomish | Washington | 53061 | 31182 | 546 |
1085803 | 1085803 | 2021-03-03 | Snohomish | Washington | 53061 | 31131 | 541 |
1082557 | 1082557 | 2021-03-02 | Snohomish | Washington | 53061 | 31081 | 540 |
1079311 | 1079311 | 2021-03-01 | Snohomish | Washington | 53061 | 30957 | 539 |
1076066 | 1076066 | 2021-02-28 | Snohomish | Washington | 53061 | 30828 | 538 |
1072820 | 1072820 | 2021-02-27 | Snohomish | Washington | 53061 | 30828 | 538 |
1069574 | 1069574 | 2021-02-26 | Snohomish | Washington | 53061 | 30828 | 538 |
1066329 | 1066329 | 2021-02-25 | Snohomish | Washington | 53061 | 30754 | 538 |
1063084 | 1063084 | 2021-02-24 | Snohomish | Washington | 53061 | 30680 | 538 |
1059839 | 1059839 | 2021-02-23 | Snohomish | Washington | 53061 | 30607 | 530 |
1056593 | 1056593 | 2021-02-22 | Snohomish | Washington | 53061 | 30474 | 530 |
1053347 | 1053347 | 2021-02-21 | Snohomish | Washington | 53061 | 30297 | 526 |
1050100 | 1050100 | 2021-02-20 | Snohomish | Washington | 53061 | 30297 | 526 |
1046853 | 1046853 | 2021-02-19 | Snohomish | Washington | 53061 | 30297 | 526 |
1043608 | 1043608 | 2021-02-18 | Snohomish | Washington | 53061 | 30230 | 523 |
1040363 | 1040363 | 2021-02-17 | Snohomish | Washington | 53061 | 30130 | 520 |
1037118 | 1037118 | 2021-02-16 | Snohomish | Washington | 53061 | 30055 | 519 |
1033873 | 1033873 | 2021-02-15 | Snohomish | Washington | 53061 | 29705 | 516 |
1030627 | 1030627 | 2021-02-14 | Snohomish | Washington | 53061 | 29705 | 516 |
1027380 | 1027380 | 2021-02-13 | Snohomish | Washington | 53061 | 29705 | 516 |
1024135 | 1024135 | 2021-02-12 | Snohomish | Washington | 53061 | 29705 | 516 |
1020890 | 1020890 | 2021-02-11 | Snohomish | Washington | 53061 | 29578 | 512 |
1017645 | 1017645 | 2021-02-10 | Snohomish | Washington | 53061 | 29556 | 512 |
1014400 | 1014400 | 2021-02-09 | Snohomish | Washington | 53061 | 29489 | 504 |
1011155 | 1011155 | 2021-02-08 | Snohomish | Washington | 53061 | 29431 | 495 |
1007909 | 1007909 | 2021-02-07 | Snohomish | Washington | 53061 | 29177 | 494 |
1004663 | 1004663 | 2021-02-06 | Snohomish | Washington | 53061 | 29177 | 494 |
1001417 | 1001417 | 2021-02-05 | Snohomish | Washington | 53061 | 29177 | 494 |
998171 | 998171 | 2021-02-04 | Snohomish | Washington | 53061 | 29062 | 494 |
994925 | 994925 | 2021-02-03 | Snohomish | Washington | 53061 | 28894 | 493 |
991679 | 991679 | 2021-02-02 | Snohomish | Washington | 53061 | 28767 | 489 |
988433 | 988433 | 2021-02-01 | Snohomish | Washington | 53061 | 28691 | 489 |
985186 | 985186 | 2021-01-31 | Snohomish | Washington | 53061 | 28373 | 488 |
981939 | 981939 | 2021-01-30 | Snohomish | Washington | 53061 | 28373 | 488 |
978693 | 978693 | 2021-01-29 | Snohomish | Washington | 53061 | 28373 | 488 |
975448 | 975448 | 2021-01-28 | Snohomish | Washington | 53061 | 28328 | 483 |
972203 | 972203 | 2021-01-27 | Snohomish | Washington | 53061 | 28174 | 478 |
968958 | 968958 | 2021-01-26 | Snohomish | Washington | 53061 | 28058 | 472 |
965714 | 965714 | 2021-01-25 | Snohomish | Washington | 53061 | 27995 | 470 |
962469 | 962469 | 2021-01-24 | Snohomish | Washington | 53061 | 27650 | 469 |
959224 | 959224 | 2021-01-23 | Snohomish | Washington | 53061 | 27650 | 469 |
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);