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 |
---|---|---|---|---|---|---|---|
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 |
732044 | 732044 | 2020-11-14 | Snohomish | Washington | 53061 | 12301 | 258 |
728799 | 728799 | 2020-11-13 | Snohomish | Washington | 53061 | 12301 | 258 |
725556 | 725556 | 2020-11-12 | Snohomish | Washington | 53061 | 12013 | 259 |
722313 | 722313 | 2020-11-11 | Snohomish | Washington | 53061 | 11747 | 259 |
719070 | 719070 | 2020-11-10 | Snohomish | Washington | 53061 | 11747 | 259 |
715827 | 715827 | 2020-11-09 | Snohomish | Washington | 53061 | 11609 | 256 |
712583 | 712583 | 2020-11-08 | Snohomish | Washington | 53061 | 11129 | 251 |
709339 | 709339 | 2020-11-07 | Snohomish | Washington | 53061 | 11129 | 251 |
706095 | 706095 | 2020-11-06 | Snohomish | Washington | 53061 | 11129 | 251 |
702852 | 702852 | 2020-11-05 | Snohomish | Washington | 53061 | 10877 | 251 |
699609 | 699609 | 2020-11-04 | Snohomish | Washington | 53061 | 10723 | 248 |
696365 | 696365 | 2020-11-03 | Snohomish | Washington | 53061 | 10587 | 246 |
693123 | 693123 | 2020-11-02 | Snohomish | Washington | 53061 | 10505 | 245 |
689879 | 689879 | 2020-11-01 | Snohomish | Washington | 53061 | 10219 | 244 |
686634 | 686634 | 2020-10-31 | Snohomish | Washington | 53061 | 10219 | 244 |
683391 | 683391 | 2020-10-30 | Snohomish | Washington | 53061 | 10219 | 244 |
680148 | 680148 | 2020-10-29 | Snohomish | Washington | 53061 | 10126 | 243 |
676905 | 676905 | 2020-10-28 | Snohomish | Washington | 53061 | 10025 | 245 |
673662 | 673662 | 2020-10-27 | Snohomish | Washington | 53061 | 9948 | 241 |
670420 | 670420 | 2020-10-26 | Snohomish | Washington | 53061 | 9891 | 241 |
667177 | 667177 | 2020-10-25 | Snohomish | Washington | 53061 | 9659 | 239 |
663932 | 663932 | 2020-10-24 | Snohomish | Washington | 53061 | 9659 | 239 |
660688 | 660688 | 2020-10-23 | Snohomish | Washington | 53061 | 9659 | 239 |
657444 | 657444 | 2020-10-22 | Snohomish | Washington | 53061 | 9562 | 239 |
654199 | 654199 | 2020-10-21 | Snohomish | Washington | 53061 | 9478 | 238 |
650954 | 650954 | 2020-10-20 | Snohomish | Washington | 53061 | 9402 | 236 |
647710 | 647710 | 2020-10-19 | Snohomish | Washington | 53061 | 9322 | 234 |
644464 | 644464 | 2020-10-18 | Snohomish | Washington | 53061 | 9125 | 231 |
641216 | 641216 | 2020-10-17 | Snohomish | Washington | 53061 | 9125 | 231 |
637969 | 637969 | 2020-10-16 | Snohomish | Washington | 53061 | 9125 | 231 |
634724 | 634724 | 2020-10-15 | Snohomish | Washington | 53061 | 9047 | 230 |
631479 | 631479 | 2020-10-14 | Snohomish | Washington | 53061 | 8951 | 229 |
628235 | 628235 | 2020-10-13 | Snohomish | Washington | 53061 | 8869 | 229 |
624992 | 624992 | 2020-10-12 | Snohomish | Washington | 53061 | 8813 | 229 |
621749 | 621749 | 2020-10-11 | Snohomish | Washington | 53061 | 8595 | 229 |
618506 | 618506 | 2020-10-10 | Snohomish | Washington | 53061 | 8595 | 229 |
615264 | 615264 | 2020-10-09 | Snohomish | Washington | 53061 | 8595 | 229 |
612023 | 612023 | 2020-10-08 | Snohomish | Washington | 53061 | 8525 | 228 |
608781 | 608781 | 2020-10-07 | Snohomish | Washington | 53061 | 8482 | 225 |
605538 | 605538 | 2020-10-06 | Snohomish | Washington | 53061 | 8435 | 225 |
602296 | 602296 | 2020-10-05 | Snohomish | Washington | 53061 | 8372 | 225 |
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);