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 |
---|---|---|---|---|---|---|---|
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 |
955978 | 955978 | 2021-01-22 | Snohomish | Washington | 53061 | 27650 | 469 |
952733 | 952733 | 2021-01-21 | Snohomish | Washington | 53061 | 27582 | 466 |
949488 | 949488 | 2021-01-20 | Snohomish | Washington | 53061 | 27462 | 457 |
946242 | 946242 | 2021-01-19 | Snohomish | Washington | 53061 | 27339 | 457 |
942995 | 942995 | 2021-01-18 | Snohomish | Washington | 53061 | 26706 | 444 |
939750 | 939750 | 2021-01-17 | Snohomish | Washington | 53061 | 26706 | 444 |
936505 | 936505 | 2021-01-16 | Snohomish | Washington | 53061 | 26706 | 444 |
933260 | 933260 | 2021-01-15 | Snohomish | Washington | 53061 | 26706 | 444 |
930015 | 930015 | 2021-01-14 | Snohomish | Washington | 53061 | 26574 | 442 |
926770 | 926770 | 2021-01-13 | Snohomish | Washington | 53061 | 26435 | 440 |
923524 | 923524 | 2021-01-12 | Snohomish | Washington | 53061 | 26304 | 439 |
920279 | 920279 | 2021-01-11 | Snohomish | Washington | 53061 | 26136 | 427 |
917034 | 917034 | 2021-01-10 | Snohomish | Washington | 53061 | 25217 | 421 |
913789 | 913789 | 2021-01-09 | Snohomish | Washington | 53061 | 25217 | 421 |
910544 | 910544 | 2021-01-08 | Snohomish | Washington | 53061 | 25217 | 421 |
907299 | 907299 | 2021-01-07 | Snohomish | Washington | 53061 | 24939 | 420 |
904053 | 904053 | 2021-01-06 | Snohomish | Washington | 53061 | 24619 | 416 |
900808 | 900808 | 2021-01-05 | Snohomish | Washington | 53061 | 24464 | 405 |
897563 | 897563 | 2021-01-04 | Snohomish | Washington | 53061 | 24162 | 402 |
894317 | 894317 | 2021-01-03 | Snohomish | Washington | 53061 | 23189 | 393 |
891071 | 891071 | 2021-01-02 | Snohomish | Washington | 53061 | 23189 | 393 |
887824 | 887824 | 2021-01-01 | Snohomish | Washington | 53061 | 23189 | 393 |
884579 | 884579 | 2020-12-31 | Snohomish | Washington | 53061 | 23189 | 393 |
881334 | 881334 | 2020-12-30 | Snohomish | Washington | 53061 | 22801 | 387 |
878089 | 878089 | 2020-12-29 | Snohomish | Washington | 53061 | 22654 | 382 |
874844 | 874844 | 2020-12-28 | Snohomish | Washington | 53061 | 22484 | 379 |
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);