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 |
---|---|---|---|---|---|---|---|
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 |
599054 | 599054 | 2020-10-04 | Spokane | Washington | 53063 | 7359 | 175 |
595811 | 595811 | 2020-10-03 | Spokane | Washington | 53063 | 7261 | 175 |
592569 | 592569 | 2020-10-02 | Spokane | Washington | 53063 | 7242 | 175 |
589329 | 589329 | 2020-10-01 | Spokane | Washington | 53063 | 7242 | 173 |
586088 | 586088 | 2020-09-30 | Spokane | Washington | 53063 | 7132 | 173 |
582848 | 582848 | 2020-09-29 | Spokane | Washington | 53063 | 7057 | 172 |
579609 | 579609 | 2020-09-28 | Spokane | Washington | 53063 | 6996 | 170 |
576368 | 576368 | 2020-09-27 | Spokane | Washington | 53063 | 6808 | 168 |
573124 | 573124 | 2020-09-26 | Spokane | Washington | 53063 | 6808 | 168 |
569882 | 569882 | 2020-09-25 | Spokane | Washington | 53063 | 6808 | 168 |
566641 | 566641 | 2020-09-24 | Spokane | Washington | 53063 | 6700 | 166 |
563400 | 563400 | 2020-09-23 | Spokane | Washington | 53063 | 6589 | 165 |
560161 | 560161 | 2020-09-22 | Spokane | Washington | 53063 | 6467 | 162 |
556925 | 556925 | 2020-09-21 | Spokane | Washington | 53063 | 6418 | 156 |
553688 | 553688 | 2020-09-20 | Spokane | Washington | 53063 | 6228 | 153 |
550449 | 550449 | 2020-09-19 | Spokane | Washington | 53063 | 6190 | 153 |
547210 | 547210 | 2020-09-18 | Spokane | Washington | 53063 | 6190 | 153 |
543973 | 543973 | 2020-09-17 | Spokane | Washington | 53063 | 6120 | 153 |
540737 | 540737 | 2020-09-16 | Spokane | Washington | 53063 | 6047 | 151 |
537500 | 537500 | 2020-09-15 | Spokane | Washington | 53063 | 5985 | 150 |
534264 | 534264 | 2020-09-14 | Spokane | Washington | 53063 | 5947 | 150 |
531029 | 531029 | 2020-09-13 | Spokane | Washington | 53063 | 5831 | 146 |
527792 | 527792 | 2020-09-12 | Spokane | Washington | 53063 | 5818 | 146 |
524556 | 524556 | 2020-09-11 | Spokane | Washington | 53063 | 5764 | 146 |
521320 | 521320 | 2020-09-10 | Spokane | Washington | 53063 | 5764 | 145 |
518083 | 518083 | 2020-09-09 | Spokane | Washington | 53063 | 5687 | 144 |
514848 | 514848 | 2020-09-08 | Spokane | Washington | 53063 | 5659 | 141 |
511615 | 511615 | 2020-09-07 | Spokane | Washington | 53063 | 5542 | 141 |
508382 | 508382 | 2020-09-06 | Spokane | Washington | 53063 | 5542 | 141 |
505150 | 505150 | 2020-09-05 | Spokane | Washington | 53063 | 5533 | 141 |
501916 | 501916 | 2020-09-04 | Spokane | Washington | 53063 | 5533 | 141 |
498682 | 498682 | 2020-09-03 | Spokane | Washington | 53063 | 5492 | 141 |
495449 | 495449 | 2020-09-02 | Spokane | Washington | 53063 | 5457 | 141 |
492215 | 492215 | 2020-09-01 | Spokane | Washington | 53063 | 5396 | 139 |
488982 | 488982 | 2020-08-31 | Spokane | Washington | 53063 | 5364 | 138 |
485749 | 485749 | 2020-08-30 | Spokane | Washington | 53063 | 5293 | 134 |
482514 | 482514 | 2020-08-29 | Spokane | Washington | 53063 | 5265 | 134 |
479280 | 479280 | 2020-08-28 | Spokane | Washington | 53063 | 5215 | 134 |
476047 | 476047 | 2020-08-27 | Spokane | Washington | 53063 | 5165 | 131 |
472814 | 472814 | 2020-08-26 | Spokane | Washington | 53063 | 5124 | 131 |
469582 | 469582 | 2020-08-25 | Spokane | Washington | 53063 | 5080 | 130 |
466353 | 466353 | 2020-08-24 | Spokane | Washington | 53063 | 5051 | 127 |
463124 | 463124 | 2020-08-23 | Spokane | Washington | 53063 | 5018 | 126 |
459895 | 459895 | 2020-08-22 | Spokane | Washington | 53063 | 4989 | 125 |
456668 | 456668 | 2020-08-21 | Spokane | Washington | 53063 | 4949 | 123 |
453440 | 453440 | 2020-08-20 | Spokane | Washington | 53063 | 4915 | 121 |
450212 | 450212 | 2020-08-19 | Spokane | Washington | 53063 | 4860 | 119 |
446984 | 446984 | 2020-08-18 | Spokane | Washington | 53063 | 4843 | 117 |
443757 | 443757 | 2020-08-17 | Spokane | Washington | 53063 | 4813 | 112 |
440531 | 440531 | 2020-08-16 | Spokane | Washington | 53063 | 4798 | 109 |
437305 | 437305 | 2020-08-15 | Spokane | Washington | 53063 | 4730 | 104 |
434079 | 434079 | 2020-08-14 | Spokane | Washington | 53063 | 4674 | 98 |
430854 | 430854 | 2020-08-13 | Spokane | Washington | 53063 | 4674 | 98 |
427626 | 427626 | 2020-08-12 | Spokane | Washington | 53063 | 4674 | 93 |
424402 | 424402 | 2020-08-11 | Spokane | Washington | 53063 | 4511 | 93 |
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);