ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
279 rows where county = "Klickitat", deaths = 3 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
949477 | 949477 | 2021-01-20 | Klickitat | Washington | 53039 | 577 | 3 |
946231 | 946231 | 2021-01-19 | Klickitat | Washington | 53039 | 569 | 3 |
942984 | 942984 | 2021-01-18 | Klickitat | Washington | 53039 | 569 | 3 |
939739 | 939739 | 2021-01-17 | Klickitat | Washington | 53039 | 569 | 3 |
936494 | 936494 | 2021-01-16 | Klickitat | Washington | 53039 | 557 | 3 |
933249 | 933249 | 2021-01-15 | Klickitat | Washington | 53039 | 557 | 3 |
930004 | 930004 | 2021-01-14 | Klickitat | Washington | 53039 | 554 | 3 |
926759 | 926759 | 2021-01-13 | Klickitat | Washington | 53039 | 550 | 3 |
923513 | 923513 | 2021-01-12 | Klickitat | Washington | 53039 | 550 | 3 |
920268 | 920268 | 2021-01-11 | Klickitat | Washington | 53039 | 540 | 3 |
917023 | 917023 | 2021-01-10 | Klickitat | Washington | 53039 | 540 | 3 |
913778 | 913778 | 2021-01-09 | Klickitat | Washington | 53039 | 540 | 3 |
910533 | 910533 | 2021-01-08 | Klickitat | Washington | 53039 | 529 | 3 |
907288 | 907288 | 2021-01-07 | Klickitat | Washington | 53039 | 506 | 3 |
904042 | 904042 | 2021-01-06 | Klickitat | Washington | 53039 | 502 | 3 |
900797 | 900797 | 2021-01-05 | Klickitat | Washington | 53039 | 498 | 3 |
897552 | 897552 | 2021-01-04 | Klickitat | Washington | 53039 | 491 | 3 |
894306 | 894306 | 2021-01-03 | Klickitat | Washington | 53039 | 491 | 3 |
891060 | 891060 | 2021-01-02 | Klickitat | Washington | 53039 | 476 | 3 |
887813 | 887813 | 2021-01-01 | Klickitat | Washington | 53039 | 476 | 3 |
884568 | 884568 | 2020-12-31 | Klickitat | Washington | 53039 | 476 | 3 |
881323 | 881323 | 2020-12-30 | Klickitat | Washington | 53039 | 443 | 3 |
878078 | 878078 | 2020-12-29 | Klickitat | Washington | 53039 | 441 | 3 |
874833 | 874833 | 2020-12-28 | Klickitat | Washington | 53039 | 437 | 3 |
871588 | 871588 | 2020-12-27 | Klickitat | Washington | 53039 | 434 | 3 |
868343 | 868343 | 2020-12-26 | Klickitat | Washington | 53039 | 434 | 3 |
865098 | 865098 | 2020-12-25 | Klickitat | Washington | 53039 | 422 | 3 |
861853 | 861853 | 2020-12-24 | Klickitat | Washington | 53039 | 422 | 3 |
858608 | 858608 | 2020-12-23 | Klickitat | Washington | 53039 | 420 | 3 |
855363 | 855363 | 2020-12-22 | Klickitat | Washington | 53039 | 418 | 3 |
852118 | 852118 | 2020-12-21 | Klickitat | Washington | 53039 | 419 | 3 |
848873 | 848873 | 2020-12-20 | Klickitat | Washington | 53039 | 416 | 3 |
845628 | 845628 | 2020-12-19 | Klickitat | Washington | 53039 | 416 | 3 |
842382 | 842382 | 2020-12-18 | Klickitat | Washington | 53039 | 402 | 3 |
839137 | 839137 | 2020-12-17 | Klickitat | Washington | 53039 | 387 | 3 |
835891 | 835891 | 2020-12-16 | Klickitat | Washington | 53039 | 336 | 3 |
832645 | 832645 | 2020-12-15 | Klickitat | Washington | 53039 | 336 | 3 |
829398 | 829398 | 2020-12-14 | Klickitat | Washington | 53039 | 333 | 3 |
826152 | 826152 | 2020-12-13 | Klickitat | Washington | 53039 | 330 | 3 |
822905 | 822905 | 2020-12-12 | Klickitat | Washington | 53039 | 330 | 3 |
819659 | 819659 | 2020-12-11 | Klickitat | Washington | 53039 | 326 | 3 |
816413 | 816413 | 2020-12-10 | Klickitat | Washington | 53039 | 315 | 3 |
813167 | 813167 | 2020-12-09 | Klickitat | Washington | 53039 | 306 | 3 |
809923 | 809923 | 2020-12-08 | Klickitat | Washington | 53039 | 300 | 3 |
806678 | 806678 | 2020-12-07 | Klickitat | Washington | 53039 | 298 | 3 |
803433 | 803433 | 2020-12-06 | Klickitat | Washington | 53039 | 293 | 3 |
800188 | 800188 | 2020-12-05 | Klickitat | Washington | 53039 | 292 | 3 |
796943 | 796943 | 2020-12-04 | Klickitat | Washington | 53039 | 288 | 3 |
793698 | 793698 | 2020-12-03 | Klickitat | Washington | 53039 | 281 | 3 |
790453 | 790453 | 2020-12-02 | Klickitat | Washington | 53039 | 278 | 3 |
787208 | 787208 | 2020-12-01 | Klickitat | Washington | 53039 | 275 | 3 |
783964 | 783964 | 2020-11-30 | Klickitat | Washington | 53039 | 267 | 3 |
780719 | 780719 | 2020-11-29 | Klickitat | Washington | 53039 | 264 | 3 |
777473 | 777473 | 2020-11-28 | Klickitat | Washington | 53039 | 263 | 3 |
774228 | 774228 | 2020-11-27 | Klickitat | Washington | 53039 | 260 | 3 |
770983 | 770983 | 2020-11-26 | Klickitat | Washington | 53039 | 254 | 3 |
767737 | 767737 | 2020-11-25 | Klickitat | Washington | 53039 | 254 | 3 |
764492 | 764492 | 2020-11-24 | Klickitat | Washington | 53039 | 253 | 3 |
761247 | 761247 | 2020-11-23 | Klickitat | Washington | 53039 | 244 | 3 |
758002 | 758002 | 2020-11-22 | Klickitat | Washington | 53039 | 239 | 3 |
754755 | 754755 | 2020-11-21 | Klickitat | Washington | 53039 | 239 | 3 |
751509 | 751509 | 2020-11-20 | Klickitat | Washington | 53039 | 239 | 3 |
748263 | 748263 | 2020-11-19 | Klickitat | Washington | 53039 | 237 | 3 |
745017 | 745017 | 2020-11-18 | Klickitat | Washington | 53039 | 237 | 3 |
741770 | 741770 | 2020-11-17 | Klickitat | Washington | 53039 | 236 | 3 |
738523 | 738523 | 2020-11-16 | Klickitat | Washington | 53039 | 235 | 3 |
735279 | 735279 | 2020-11-15 | Klickitat | Washington | 53039 | 234 | 3 |
732033 | 732033 | 2020-11-14 | Klickitat | Washington | 53039 | 234 | 3 |
728788 | 728788 | 2020-11-13 | Klickitat | Washington | 53039 | 230 | 3 |
725545 | 725545 | 2020-11-12 | Klickitat | Washington | 53039 | 226 | 3 |
722302 | 722302 | 2020-11-11 | Klickitat | Washington | 53039 | 225 | 3 |
719059 | 719059 | 2020-11-10 | Klickitat | Washington | 53039 | 225 | 3 |
715816 | 715816 | 2020-11-09 | Klickitat | Washington | 53039 | 222 | 3 |
712572 | 712572 | 2020-11-08 | Klickitat | Washington | 53039 | 220 | 3 |
709328 | 709328 | 2020-11-07 | Klickitat | Washington | 53039 | 219 | 3 |
706084 | 706084 | 2020-11-06 | Klickitat | Washington | 53039 | 219 | 3 |
702841 | 702841 | 2020-11-05 | Klickitat | Washington | 53039 | 215 | 3 |
699598 | 699598 | 2020-11-04 | Klickitat | Washington | 53039 | 215 | 3 |
696354 | 696354 | 2020-11-03 | Klickitat | Washington | 53039 | 211 | 3 |
693112 | 693112 | 2020-11-02 | Klickitat | Washington | 53039 | 213 | 3 |
689868 | 689868 | 2020-11-01 | Klickitat | Washington | 53039 | 214 | 3 |
686623 | 686623 | 2020-10-31 | Klickitat | Washington | 53039 | 213 | 3 |
683380 | 683380 | 2020-10-30 | Klickitat | Washington | 53039 | 211 | 3 |
680137 | 680137 | 2020-10-29 | Klickitat | Washington | 53039 | 208 | 3 |
676894 | 676894 | 2020-10-28 | Klickitat | Washington | 53039 | 208 | 3 |
673651 | 673651 | 2020-10-27 | Klickitat | Washington | 53039 | 208 | 3 |
670409 | 670409 | 2020-10-26 | Klickitat | Washington | 53039 | 208 | 3 |
667166 | 667166 | 2020-10-25 | Klickitat | Washington | 53039 | 208 | 3 |
663921 | 663921 | 2020-10-24 | Klickitat | Washington | 53039 | 208 | 3 |
660677 | 660677 | 2020-10-23 | Klickitat | Washington | 53039 | 207 | 3 |
657433 | 657433 | 2020-10-22 | Klickitat | Washington | 53039 | 206 | 3 |
654188 | 654188 | 2020-10-21 | Klickitat | Washington | 53039 | 206 | 3 |
650943 | 650943 | 2020-10-20 | Klickitat | Washington | 53039 | 205 | 3 |
647699 | 647699 | 2020-10-19 | Klickitat | Washington | 53039 | 204 | 3 |
644453 | 644453 | 2020-10-18 | Klickitat | Washington | 53039 | 204 | 3 |
641205 | 641205 | 2020-10-17 | Klickitat | Washington | 53039 | 203 | 3 |
637958 | 637958 | 2020-10-16 | Klickitat | Washington | 53039 | 202 | 3 |
634713 | 634713 | 2020-10-15 | Klickitat | Washington | 53039 | 202 | 3 |
631468 | 631468 | 2020-10-14 | Klickitat | Washington | 53039 | 202 | 3 |
628224 | 628224 | 2020-10-13 | Klickitat | Washington | 53039 | 202 | 3 |
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);