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

369 rows where fips = 53063 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

  • 53063 · 369 ✖

county

Link rowid date ▲ county state fips cases deaths
1069575 1069575 2021-02-26 Spokane Washington 53063 37197 579
1066330 1066330 2021-02-25 Spokane Washington 53063 37129 583
1063085 1063085 2021-02-24 Spokane Washington 53063 37049 582
1059840 1059840 2021-02-23 Spokane Washington 53063 36952 574
1056594 1056594 2021-02-22 Spokane Washington 53063 36870 571
1053348 1053348 2021-02-21 Spokane Washington 53063 36787 565
1050101 1050101 2021-02-20 Spokane Washington 53063 36701 565
1046854 1046854 2021-02-19 Spokane Washington 53063 36617 565
1043609 1043609 2021-02-18 Spokane Washington 53063 36524 564
1040364 1040364 2021-02-17 Spokane Washington 53063 36415 561
1037119 1037119 2021-02-16 Spokane Washington 53063 36293 556
1033874 1033874 2021-02-15 Spokane Washington 53063 36183 546
1030628 1030628 2021-02-14 Spokane Washington 53063 36131 546
1027381 1027381 2021-02-13 Spokane Washington 53063 36022 546
1024136 1024136 2021-02-12 Spokane Washington 53063 35943 546
1020891 1020891 2021-02-11 Spokane Washington 53063 35805 544
1017646 1017646 2021-02-10 Spokane Washington 53063 35784 541
1014401 1014401 2021-02-09 Spokane Washington 53063 35644 537
1011156 1011156 2021-02-08 Spokane Washington 53063 35574 531
1007910 1007910 2021-02-07 Spokane Washington 53063 35532 527
1004664 1004664 2021-02-06 Spokane Washington 53063 35368 523
1001418 1001418 2021-02-05 Spokane Washington 53063 35290 522
998172 998172 2021-02-04 Spokane Washington 53063 35147 519
994926 994926 2021-02-03 Spokane Washington 53063 35012 515
991680 991680 2021-02-02 Spokane Washington 53063 34872 511
988434 988434 2021-02-01 Spokane Washington 53063 34672 511
985187 985187 2021-01-31 Spokane Washington 53063 34497 504
981940 981940 2021-01-30 Spokane Washington 53063 34404 503
978694 978694 2021-01-29 Spokane Washington 53063 34234 503
975449 975449 2021-01-28 Spokane Washington 53063 33979 498
972204 972204 2021-01-27 Spokane Washington 53063 33472 490
968959 968959 2021-01-26 Spokane Washington 53063 33200 482
965715 965715 2021-01-25 Spokane Washington 53063 32969 478
962470 962470 2021-01-24 Spokane Washington 53063 32910 472
959225 959225 2021-01-23 Spokane Washington 53063 32782 472
955979 955979 2021-01-22 Spokane Washington 53063 32634 468
952734 952734 2021-01-21 Spokane Washington 53063 32276 462
949489 949489 2021-01-20 Spokane Washington 53063 32124 451
946243 946243 2021-01-19 Spokane Washington 53063 32031 450
942996 942996 2021-01-18 Spokane Washington 53063 31741 444
939751 939751 2021-01-17 Spokane Washington 53063 31648 442
936506 936506 2021-01-16 Spokane Washington 53063 31399 442
933261 933261 2021-01-15 Spokane Washington 53063 31252 443
930016 930016 2021-01-14 Spokane Washington 53063 31016 440
926771 926771 2021-01-13 Spokane Washington 53063 30674 433
923525 923525 2021-01-12 Spokane Washington 53063 30436 430
920280 920280 2021-01-11 Spokane Washington 53063 29953 424
917035 917035 2021-01-10 Spokane Washington 53063 29726 413
913790 913790 2021-01-09 Spokane Washington 53063 29471 412
910545 910545 2021-01-08 Spokane Washington 53063 29209 405
907300 907300 2021-01-07 Spokane Washington 53063 28604 399
904054 904054 2021-01-06 Spokane Washington 53063 28191 392
900809 900809 2021-01-05 Spokane Washington 53063 27922 382
897564 897564 2021-01-04 Spokane Washington 53063 27566 373
894318 894318 2021-01-03 Spokane Washington 53063 27377 372
891072 891072 2021-01-02 Spokane Washington 53063 27183 371
887825 887825 2021-01-01 Spokane Washington 53063 26174 370
884580 884580 2020-12-31 Spokane Washington 53063 26174 370
881335 881335 2020-12-30 Spokane Washington 53063 25949 365
878090 878090 2020-12-29 Spokane Washington 53063 25802 357
874845 874845 2020-12-28 Spokane Washington 53063 25525 355
871600 871600 2020-12-27 Spokane Washington 53063 25358 353
868355 868355 2020-12-26 Spokane Washington 53063 25271 353
865110 865110 2020-12-25 Spokane Washington 53063 24495 338
861865 861865 2020-12-24 Spokane Washington 53063 24495 338
858620 858620 2020-12-23 Spokane Washington 53063 24495 338
855375 855375 2020-12-22 Spokane Washington 53063 24154 335
852130 852130 2020-12-21 Spokane Washington 53063 24008 334
848885 848885 2020-12-20 Spokane Washington 53063 23866 329
845640 845640 2020-12-19 Spokane Washington 53063 23596 328
842394 842394 2020-12-18 Spokane Washington 53063 23442 327
839149 839149 2020-12-17 Spokane Washington 53063 22653 317
835903 835903 2020-12-16 Spokane Washington 53063 22007 317
832657 832657 2020-12-15 Spokane Washington 53063 21881 314
829410 829410 2020-12-14 Spokane Washington 53063 21661 311
826164 826164 2020-12-13 Spokane Washington 53063 21371 305
822917 822917 2020-12-12 Spokane Washington 53063 21137 303
819671 819671 2020-12-11 Spokane Washington 53063 20714 302
816425 816425 2020-12-10 Spokane Washington 53063 20388 300
813179 813179 2020-12-09 Spokane Washington 53063 20182 298
809935 809935 2020-12-08 Spokane Washington 53063 19957 296
806690 806690 2020-12-07 Spokane Washington 53063 19325 291
803445 803445 2020-12-06 Spokane Washington 53063 18954 284
800200 800200 2020-12-05 Spokane Washington 53063 18563 284
796955 796955 2020-12-04 Spokane Washington 53063 18386 284
793710 793710 2020-12-03 Spokane Washington 53063 18077 278
790465 790465 2020-12-02 Spokane Washington 53063 17787 273
787220 787220 2020-12-01 Spokane Washington 53063 17535 270
783976 783976 2020-11-30 Spokane Washington 53063 17214 265
780731 780731 2020-11-29 Spokane Washington 53063 16613 257
777485 777485 2020-11-28 Spokane Washington 53063 16415 257
774240 774240 2020-11-27 Spokane Washington 53063 16365 257
770995 770995 2020-11-26 Spokane Washington 53063 15752 254
767749 767749 2020-11-25 Spokane Washington 53063 15752 254
764504 764504 2020-11-24 Spokane Washington 53063 15344 253
761259 761259 2020-11-23 Spokane Washington 53063 15081 245
758014 758014 2020-11-22 Spokane Washington 53063 14067 241
754767 754767 2020-11-21 Spokane Washington 53063 14067 241
751521 751521 2020-11-20 Spokane Washington 53063 14067 241
748275 748275 2020-11-19 Spokane Washington 53063 13846 239

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