ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 53063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
745029 | 745029 | 2020-11-18 | Spokane | Washington | 53063 | 13441 | 235 |
741782 | 741782 | 2020-11-17 | Spokane | Washington | 53063 | 13279 | 233 |
738535 | 738535 | 2020-11-16 | Spokane | Washington | 53063 | 13047 | 229 |
735291 | 735291 | 2020-11-15 | Spokane | Washington | 53063 | 12449 | 229 |
732045 | 732045 | 2020-11-14 | Spokane | Washington | 53063 | 12114 | 229 |
728800 | 728800 | 2020-11-13 | Spokane | Washington | 53063 | 12114 | 229 |
725557 | 725557 | 2020-11-12 | Spokane | Washington | 53063 | 11904 | 224 |
722314 | 722314 | 2020-11-11 | Spokane | Washington | 53063 | 11537 | 223 |
719071 | 719071 | 2020-11-10 | Spokane | Washington | 53063 | 11537 | 223 |
715828 | 715828 | 2020-11-09 | Spokane | Washington | 53063 | 11402 | 223 |
712584 | 712584 | 2020-11-08 | Spokane | Washington | 53063 | 10921 | 219 |
709340 | 709340 | 2020-11-07 | Spokane | Washington | 53063 | 10742 | 219 |
706096 | 706096 | 2020-11-06 | Spokane | Washington | 53063 | 10699 | 219 |
702853 | 702853 | 2020-11-05 | Spokane | Washington | 53063 | 10515 | 216 |
699610 | 699610 | 2020-11-04 | Spokane | Washington | 53063 | 10403 | 215 |
696366 | 696366 | 2020-11-03 | Spokane | Washington | 53063 | 10310 | 214 |
693124 | 693124 | 2020-11-02 | Spokane | Washington | 53063 | 10209 | 209 |
689880 | 689880 | 2020-11-01 | Spokane | Washington | 53063 | 9894 | 206 |
686635 | 686635 | 2020-10-31 | Spokane | Washington | 53063 | 9894 | 206 |
683392 | 683392 | 2020-10-30 | Spokane | Washington | 53063 | 9894 | 206 |
680149 | 680149 | 2020-10-29 | Spokane | Washington | 53063 | 9727 | 206 |
676906 | 676906 | 2020-10-28 | Spokane | Washington | 53063 | 9623 | 202 |
673663 | 673663 | 2020-10-27 | Spokane | Washington | 53063 | 9493 | 201 |
670421 | 670421 | 2020-10-26 | Spokane | Washington | 53063 | 9382 | 202 |
667178 | 667178 | 2020-10-25 | Spokane | Washington | 53063 | 9158 | 198 |
663933 | 663933 | 2020-10-24 | Spokane | Washington | 53063 | 9099 | 198 |
660689 | 660689 | 2020-10-23 | Spokane | Washington | 53063 | 9099 | 198 |
657445 | 657445 | 2020-10-22 | Spokane | Washington | 53063 | 9025 | 196 |
654200 | 654200 | 2020-10-21 | Spokane | Washington | 53063 | 8922 | 194 |
650955 | 650955 | 2020-10-20 | Spokane | Washington | 53063 | 8820 | 194 |
647711 | 647711 | 2020-10-19 | Spokane | Washington | 53063 | 8774 | 189 |
644465 | 644465 | 2020-10-18 | Spokane | Washington | 53063 | 8599 | 188 |
641217 | 641217 | 2020-10-17 | Spokane | Washington | 53063 | 8599 | 188 |
637970 | 637970 | 2020-10-16 | Spokane | Washington | 53063 | 8599 | 188 |
634725 | 634725 | 2020-10-15 | Spokane | Washington | 53063 | 8499 | 186 |
631480 | 631480 | 2020-10-14 | Spokane | Washington | 53063 | 8373 | 184 |
628236 | 628236 | 2020-10-13 | Spokane | Washington | 53063 | 8254 | 184 |
624993 | 624993 | 2020-10-12 | Spokane | Washington | 53063 | 7960 | 181 |
621750 | 621750 | 2020-10-11 | Spokane | Washington | 53063 | 7960 | 181 |
618507 | 618507 | 2020-10-10 | Spokane | Washington | 53063 | 7960 | 181 |
615265 | 615265 | 2020-10-09 | Spokane | Washington | 53063 | 7960 | 181 |
612024 | 612024 | 2020-10-08 | Spokane | Washington | 53063 | 7868 | 180 |
608782 | 608782 | 2020-10-07 | Spokane | Washington | 53063 | 7730 | 180 |
605539 | 605539 | 2020-10-06 | Spokane | Washington | 53063 | 7484 | 178 |
602297 | 602297 | 2020-10-05 | Spokane | Washington | 53063 | 7416 | 176 |
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);