ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

411 rows where fips = 53061 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

  • 53061 · 411 ✖

county

Link rowid date ▲ county state fips cases deaths
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);