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 |
---|---|---|---|---|---|---|---|
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 |
871599 | 871599 | 2020-12-27 | Snohomish | Washington | 53061 | 21795 | 372 |
868354 | 868354 | 2020-12-26 | Snohomish | Washington | 53061 | 21795 | 372 |
865109 | 865109 | 2020-12-25 | Snohomish | Washington | 53061 | 21795 | 372 |
861864 | 861864 | 2020-12-24 | Snohomish | Washington | 53061 | 21795 | 372 |
858619 | 858619 | 2020-12-23 | Snohomish | Washington | 53061 | 21573 | 364 |
855374 | 855374 | 2020-12-22 | Snohomish | Washington | 53061 | 21329 | 362 |
852129 | 852129 | 2020-12-21 | Snohomish | Washington | 53061 | 21179 | 355 |
848884 | 848884 | 2020-12-20 | Snohomish | Washington | 53061 | 20679 | 344 |
845639 | 845639 | 2020-12-19 | Snohomish | Washington | 53061 | 20679 | 344 |
842393 | 842393 | 2020-12-18 | Snohomish | Washington | 53061 | 20679 | 344 |
839148 | 839148 | 2020-12-17 | Snohomish | Washington | 53061 | 20401 | 344 |
835902 | 835902 | 2020-12-16 | Snohomish | Washington | 53061 | 20095 | 344 |
832656 | 832656 | 2020-12-15 | Snohomish | Washington | 53061 | 19839 | 339 |
829409 | 829409 | 2020-12-14 | Snohomish | Washington | 53061 | 19696 | 329 |
826163 | 826163 | 2020-12-13 | Snohomish | Washington | 53061 | 18941 | 324 |
822916 | 822916 | 2020-12-12 | Snohomish | Washington | 53061 | 18941 | 324 |
819670 | 819670 | 2020-12-11 | Snohomish | Washington | 53061 | 18941 | 324 |
816424 | 816424 | 2020-12-10 | Snohomish | Washington | 53061 | 18681 | 323 |
813178 | 813178 | 2020-12-09 | Snohomish | Washington | 53061 | 18315 | 330 |
809934 | 809934 | 2020-12-08 | Snohomish | Washington | 53061 | 18148 | 323 |
806689 | 806689 | 2020-12-07 | Snohomish | Washington | 53061 | 17880 | 319 |
803444 | 803444 | 2020-12-06 | Snohomish | Washington | 53061 | 16894 | 315 |
800199 | 800199 | 2020-12-05 | Snohomish | Washington | 53061 | 16894 | 315 |
796954 | 796954 | 2020-12-04 | Snohomish | Washington | 53061 | 16894 | 315 |
793709 | 793709 | 2020-12-03 | Snohomish | Washington | 53061 | 16678 | 314 |
790464 | 790464 | 2020-12-02 | Snohomish | Washington | 53061 | 16523 | 311 |
787219 | 787219 | 2020-12-01 | Snohomish | Washington | 53061 | 16234 | 305 |
783975 | 783975 | 2020-11-30 | Snohomish | Washington | 53061 | 15973 | 301 |
780730 | 780730 | 2020-11-29 | Snohomish | Washington | 53061 | 14925 | 287 |
777484 | 777484 | 2020-11-28 | Snohomish | Washington | 53061 | 14925 | 287 |
774239 | 774239 | 2020-11-27 | Snohomish | Washington | 53061 | 14925 | 287 |
770994 | 770994 | 2020-11-26 | Snohomish | Washington | 53061 | 14925 | 287 |
767748 | 767748 | 2020-11-25 | Snohomish | Washington | 53061 | 14925 | 287 |
764503 | 764503 | 2020-11-24 | Snohomish | Washington | 53061 | 14715 | 288 |
761258 | 761258 | 2020-11-23 | Snohomish | Washington | 53061 | 14443 | 279 |
758013 | 758013 | 2020-11-22 | Snohomish | Washington | 53061 | 13639 | 272 |
754766 | 754766 | 2020-11-21 | Snohomish | Washington | 53061 | 13639 | 272 |
751520 | 751520 | 2020-11-20 | Snohomish | Washington | 53061 | 13639 | 272 |
748274 | 748274 | 2020-11-19 | Snohomish | Washington | 53061 | 13428 | 269 |
745028 | 745028 | 2020-11-18 | Snohomish | Washington | 53061 | 13269 | 269 |
741781 | 741781 | 2020-11-17 | Snohomish | Washington | 53061 | 13111 | 263 |
738534 | 738534 | 2020-11-16 | Snohomish | Washington | 53061 | 12965 | 263 |
735290 | 735290 | 2020-11-15 | Snohomish | Washington | 53061 | 12301 | 258 |
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);