ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923504 | 923504 | 2021-01-12 | Franklin | Washington | 53021 | 9477 | 87 |
920259 | 920259 | 2021-01-11 | Franklin | Washington | 53021 | 9432 | 86 |
917014 | 917014 | 2021-01-10 | Franklin | Washington | 53021 | 9321 | 86 |
913769 | 913769 | 2021-01-09 | Franklin | Washington | 53021 | 9321 | 86 |
910524 | 910524 | 2021-01-08 | Franklin | Washington | 53021 | 9267 | 86 |
907279 | 907279 | 2021-01-07 | Franklin | Washington | 53021 | 9156 | 86 |
904033 | 904033 | 2021-01-06 | Franklin | Washington | 53021 | 9082 | 86 |
900788 | 900788 | 2021-01-05 | Franklin | Washington | 53021 | 9040 | 84 |
897543 | 897543 | 2021-01-04 | Franklin | Washington | 53021 | 9001 | 83 |
894297 | 894297 | 2021-01-03 | Franklin | Washington | 53021 | 8939 | 83 |
891051 | 891051 | 2021-01-02 | Franklin | Washington | 53021 | 8772 | 83 |
887804 | 887804 | 2021-01-01 | Franklin | Washington | 53021 | 8772 | 83 |
884559 | 884559 | 2020-12-31 | Franklin | Washington | 53021 | 8772 | 83 |
881314 | 881314 | 2020-12-30 | Franklin | Washington | 53021 | 8649 | 83 |
878069 | 878069 | 2020-12-29 | Franklin | Washington | 53021 | 8623 | 82 |
874824 | 874824 | 2020-12-28 | Franklin | Washington | 53021 | 8586 | 79 |
871579 | 871579 | 2020-12-27 | Franklin | Washington | 53021 | 8531 | 79 |
868334 | 868334 | 2020-12-26 | Franklin | Washington | 53021 | 8531 | 79 |
865089 | 865089 | 2020-12-25 | Franklin | Washington | 53021 | 8432 | 79 |
861844 | 861844 | 2020-12-24 | Franklin | Washington | 53021 | 8432 | 79 |
858599 | 858599 | 2020-12-23 | Franklin | Washington | 53021 | 8378 | 78 |
855354 | 855354 | 2020-12-22 | Franklin | Washington | 53021 | 8343 | 77 |
852109 | 852109 | 2020-12-21 | Franklin | Washington | 53021 | 8293 | 76 |
848864 | 848864 | 2020-12-20 | Franklin | Washington | 53021 | 8161 | 76 |
845619 | 845619 | 2020-12-19 | Franklin | Washington | 53021 | 8161 | 76 |
842373 | 842373 | 2020-12-18 | Franklin | Washington | 53021 | 8120 | 76 |
839128 | 839128 | 2020-12-17 | Franklin | Washington | 53021 | 7997 | 76 |
835882 | 835882 | 2020-12-16 | Franklin | Washington | 53021 | 7926 | 78 |
832636 | 832636 | 2020-12-15 | Franklin | Washington | 53021 | 7926 | 78 |
829389 | 829389 | 2020-12-14 | Franklin | Washington | 53021 | 7870 | 77 |
826143 | 826143 | 2020-12-13 | Franklin | Washington | 53021 | 7792 | 76 |
822896 | 822896 | 2020-12-12 | Franklin | Washington | 53021 | 7723 | 76 |
819650 | 819650 | 2020-12-11 | Franklin | Washington | 53021 | 7615 | 76 |
816404 | 816404 | 2020-12-10 | Franklin | Washington | 53021 | 7536 | 75 |
813158 | 813158 | 2020-12-09 | Franklin | Washington | 53021 | 7445 | 77 |
809914 | 809914 | 2020-12-08 | Franklin | Washington | 53021 | 7334 | 77 |
806669 | 806669 | 2020-12-07 | Franklin | Washington | 53021 | 7250 | 77 |
803424 | 803424 | 2020-12-06 | Franklin | Washington | 53021 | 6950 | 76 |
800179 | 800179 | 2020-12-05 | Franklin | Washington | 53021 | 6934 | 76 |
796934 | 796934 | 2020-12-04 | Franklin | Washington | 53021 | 6916 | 76 |
793689 | 793689 | 2020-12-03 | Franklin | Washington | 53021 | 6894 | 76 |
790444 | 790444 | 2020-12-02 | Franklin | Washington | 53021 | 6818 | 77 |
787199 | 787199 | 2020-12-01 | Franklin | Washington | 53021 | 6755 | 76 |
783955 | 783955 | 2020-11-30 | Franklin | Washington | 53021 | 6699 | 75 |
780710 | 780710 | 2020-11-29 | Franklin | Washington | 53021 | 6633 | 73 |
777464 | 777464 | 2020-11-28 | Franklin | Washington | 53021 | 6557 | 73 |
774219 | 774219 | 2020-11-27 | Franklin | Washington | 53021 | 6507 | 73 |
770974 | 770974 | 2020-11-26 | Franklin | Washington | 53021 | 6316 | 73 |
767728 | 767728 | 2020-11-25 | Franklin | Washington | 53021 | 6316 | 73 |
764483 | 764483 | 2020-11-24 | Franklin | Washington | 53021 | 6213 | 73 |
761238 | 761238 | 2020-11-23 | Franklin | Washington | 53021 | 6129 | 72 |
757993 | 757993 | 2020-11-22 | Franklin | Washington | 53021 | 5950 | 71 |
754746 | 754746 | 2020-11-21 | Franklin | Washington | 53021 | 5950 | 71 |
751500 | 751500 | 2020-11-20 | Franklin | Washington | 53021 | 5890 | 71 |
748254 | 748254 | 2020-11-19 | Franklin | Washington | 53021 | 5820 | 71 |
745008 | 745008 | 2020-11-18 | Franklin | Washington | 53021 | 5782 | 71 |
741761 | 741761 | 2020-11-17 | Franklin | Washington | 53021 | 5716 | 71 |
738514 | 738514 | 2020-11-16 | Franklin | Washington | 53021 | 5658 | 71 |
735270 | 735270 | 2020-11-15 | Franklin | Washington | 53021 | 5607 | 70 |
732024 | 732024 | 2020-11-14 | Franklin | Washington | 53021 | 5491 | 70 |
728779 | 728779 | 2020-11-13 | Franklin | Washington | 53021 | 5454 | 70 |
725536 | 725536 | 2020-11-12 | Franklin | Washington | 53021 | 5438 | 70 |
722293 | 722293 | 2020-11-11 | Franklin | Washington | 53021 | 5358 | 70 |
719050 | 719050 | 2020-11-10 | Franklin | Washington | 53021 | 5358 | 70 |
715807 | 715807 | 2020-11-09 | Franklin | Washington | 53021 | 5308 | 70 |
712563 | 712563 | 2020-11-08 | Franklin | Washington | 53021 | 5279 | 70 |
709319 | 709319 | 2020-11-07 | Franklin | Washington | 53021 | 5239 | 70 |
706075 | 706075 | 2020-11-06 | Franklin | Washington | 53021 | 5197 | 70 |
702832 | 702832 | 2020-11-05 | Franklin | Washington | 53021 | 5183 | 70 |
699589 | 699589 | 2020-11-04 | Franklin | Washington | 53021 | 5168 | 70 |
696345 | 696345 | 2020-11-03 | Franklin | Washington | 53021 | 5142 | 70 |
693103 | 693103 | 2020-11-02 | Franklin | Washington | 53021 | 5117 | 69 |
689859 | 689859 | 2020-11-01 | Franklin | Washington | 53021 | 5085 | 69 |
686614 | 686614 | 2020-10-31 | Franklin | Washington | 53021 | 5055 | 69 |
683371 | 683371 | 2020-10-30 | Franklin | Washington | 53021 | 5022 | 69 |
680128 | 680128 | 2020-10-29 | Franklin | Washington | 53021 | 5006 | 68 |
676885 | 676885 | 2020-10-28 | Franklin | Washington | 53021 | 4995 | 68 |
673642 | 673642 | 2020-10-27 | Franklin | Washington | 53021 | 4968 | 69 |
670400 | 670400 | 2020-10-26 | Franklin | Washington | 53021 | 4942 | 68 |
667157 | 667157 | 2020-10-25 | Franklin | Washington | 53021 | 4924 | 68 |
663912 | 663912 | 2020-10-24 | Franklin | Washington | 53021 | 4891 | 68 |
660668 | 660668 | 2020-10-23 | Franklin | Washington | 53021 | 4858 | 68 |
657424 | 657424 | 2020-10-22 | Franklin | Washington | 53021 | 4854 | 68 |
654179 | 654179 | 2020-10-21 | Franklin | Washington | 53021 | 4840 | 68 |
650934 | 650934 | 2020-10-20 | Franklin | Washington | 53021 | 4809 | 68 |
647690 | 647690 | 2020-10-19 | Franklin | Washington | 53021 | 4796 | 68 |
644444 | 644444 | 2020-10-18 | Franklin | Washington | 53021 | 4774 | 68 |
641196 | 641196 | 2020-10-17 | Franklin | Washington | 53021 | 4767 | 68 |
637949 | 637949 | 2020-10-16 | Franklin | Washington | 53021 | 4739 | 68 |
634704 | 634704 | 2020-10-15 | Franklin | Washington | 53021 | 4726 | 68 |
631459 | 631459 | 2020-10-14 | Franklin | Washington | 53021 | 4707 | 68 |
628215 | 628215 | 2020-10-13 | Franklin | Washington | 53021 | 4691 | 68 |
624972 | 624972 | 2020-10-12 | Franklin | Washington | 53021 | 4613 | 67 |
621729 | 621729 | 2020-10-11 | Franklin | Washington | 53021 | 4613 | 67 |
618486 | 618486 | 2020-10-10 | Franklin | Washington | 53021 | 4613 | 67 |
615244 | 615244 | 2020-10-09 | Franklin | Washington | 53021 | 4603 | 67 |
612003 | 612003 | 2020-10-08 | Franklin | Washington | 53021 | 4590 | 67 |
608761 | 608761 | 2020-10-07 | Franklin | Washington | 53021 | 4574 | 67 |
605518 | 605518 | 2020-10-06 | Franklin | Washington | 53021 | 4546 | 67 |
602276 | 602276 | 2020-10-05 | Franklin | Washington | 53021 | 4538 | 67 |
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);