ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Jefferson" and fips = 53031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952718 | 952718 | 2021-01-21 | Jefferson | Washington | 53031 | 277 | 2 |
949473 | 949473 | 2021-01-20 | Jefferson | Washington | 53031 | 276 | 2 |
946227 | 946227 | 2021-01-19 | Jefferson | Washington | 53031 | 273 | 2 |
942980 | 942980 | 2021-01-18 | Jefferson | Washington | 53031 | 273 | 2 |
939735 | 939735 | 2021-01-17 | Jefferson | Washington | 53031 | 273 | 2 |
936490 | 936490 | 2021-01-16 | Jefferson | Washington | 53031 | 267 | 2 |
933245 | 933245 | 2021-01-15 | Jefferson | Washington | 53031 | 267 | 2 |
930000 | 930000 | 2021-01-14 | Jefferson | Washington | 53031 | 261 | 2 |
926755 | 926755 | 2021-01-13 | Jefferson | Washington | 53031 | 259 | 2 |
923509 | 923509 | 2021-01-12 | Jefferson | Washington | 53031 | 258 | 2 |
920264 | 920264 | 2021-01-11 | Jefferson | Washington | 53031 | 256 | 2 |
917019 | 917019 | 2021-01-10 | Jefferson | Washington | 53031 | 254 | 2 |
913774 | 913774 | 2021-01-09 | Jefferson | Washington | 53031 | 254 | 2 |
910529 | 910529 | 2021-01-08 | Jefferson | Washington | 53031 | 252 | 2 |
907284 | 907284 | 2021-01-07 | Jefferson | Washington | 53031 | 246 | 1 |
904038 | 904038 | 2021-01-06 | Jefferson | Washington | 53031 | 238 | 1 |
900793 | 900793 | 2021-01-05 | Jefferson | Washington | 53031 | 238 | 1 |
897548 | 897548 | 2021-01-04 | Jefferson | Washington | 53031 | 233 | 1 |
894302 | 894302 | 2021-01-03 | Jefferson | Washington | 53031 | 229 | 1 |
891056 | 891056 | 2021-01-02 | Jefferson | Washington | 53031 | 220 | 1 |
887809 | 887809 | 2021-01-01 | Jefferson | Washington | 53031 | 220 | 1 |
884564 | 884564 | 2020-12-31 | Jefferson | Washington | 53031 | 220 | 1 |
881319 | 881319 | 2020-12-30 | Jefferson | Washington | 53031 | 219 | 1 |
878074 | 878074 | 2020-12-29 | Jefferson | Washington | 53031 | 218 | 1 |
874829 | 874829 | 2020-12-28 | Jefferson | Washington | 53031 | 216 | 1 |
871584 | 871584 | 2020-12-27 | Jefferson | Washington | 53031 | 214 | 1 |
868339 | 868339 | 2020-12-26 | Jefferson | Washington | 53031 | 214 | 1 |
865094 | 865094 | 2020-12-25 | Jefferson | Washington | 53031 | 211 | 1 |
861849 | 861849 | 2020-12-24 | Jefferson | Washington | 53031 | 211 | 1 |
858604 | 858604 | 2020-12-23 | Jefferson | Washington | 53031 | 209 | 1 |
855359 | 855359 | 2020-12-22 | Jefferson | Washington | 53031 | 207 | 1 |
852114 | 852114 | 2020-12-21 | Jefferson | Washington | 53031 | 205 | 1 |
848869 | 848869 | 2020-12-20 | Jefferson | Washington | 53031 | 204 | 1 |
845624 | 845624 | 2020-12-19 | Jefferson | Washington | 53031 | 204 | 1 |
842378 | 842378 | 2020-12-18 | Jefferson | Washington | 53031 | 204 | 1 |
839133 | 839133 | 2020-12-17 | Jefferson | Washington | 53031 | 201 | 1 |
835887 | 835887 | 2020-12-16 | Jefferson | Washington | 53031 | 198 | 1 |
832641 | 832641 | 2020-12-15 | Jefferson | Washington | 53031 | 198 | 1 |
829394 | 829394 | 2020-12-14 | Jefferson | Washington | 53031 | 196 | 1 |
826148 | 826148 | 2020-12-13 | Jefferson | Washington | 53031 | 195 | 1 |
822901 | 822901 | 2020-12-12 | Jefferson | Washington | 53031 | 193 | 1 |
819655 | 819655 | 2020-12-11 | Jefferson | Washington | 53031 | 191 | 1 |
816409 | 816409 | 2020-12-10 | Jefferson | Washington | 53031 | 188 | 1 |
813163 | 813163 | 2020-12-09 | Jefferson | Washington | 53031 | 186 | 1 |
809919 | 809919 | 2020-12-08 | Jefferson | Washington | 53031 | 180 | 1 |
806674 | 806674 | 2020-12-07 | Jefferson | Washington | 53031 | 180 | 1 |
803429 | 803429 | 2020-12-06 | Jefferson | Washington | 53031 | 176 | 1 |
800184 | 800184 | 2020-12-05 | Jefferson | Washington | 53031 | 176 | 1 |
796939 | 796939 | 2020-12-04 | Jefferson | Washington | 53031 | 171 | 1 |
793694 | 793694 | 2020-12-03 | Jefferson | Washington | 53031 | 170 | 1 |
790449 | 790449 | 2020-12-02 | Jefferson | Washington | 53031 | 169 | 1 |
787204 | 787204 | 2020-12-01 | Jefferson | Washington | 53031 | 167 | 1 |
783960 | 783960 | 2020-11-30 | Jefferson | Washington | 53031 | 164 | 1 |
780715 | 780715 | 2020-11-29 | Jefferson | Washington | 53031 | 164 | 1 |
777469 | 777469 | 2020-11-28 | Jefferson | Washington | 53031 | 161 | 1 |
774224 | 774224 | 2020-11-27 | Jefferson | Washington | 53031 | 159 | 1 |
770979 | 770979 | 2020-11-26 | Jefferson | Washington | 53031 | 152 | 1 |
767733 | 767733 | 2020-11-25 | Jefferson | Washington | 53031 | 152 | 1 |
764488 | 764488 | 2020-11-24 | Jefferson | Washington | 53031 | 149 | 0 |
761243 | 761243 | 2020-11-23 | Jefferson | Washington | 53031 | 146 | 0 |
757998 | 757998 | 2020-11-22 | Jefferson | Washington | 53031 | 139 | 0 |
754751 | 754751 | 2020-11-21 | Jefferson | Washington | 53031 | 139 | 0 |
751505 | 751505 | 2020-11-20 | Jefferson | Washington | 53031 | 134 | 0 |
748259 | 748259 | 2020-11-19 | Jefferson | Washington | 53031 | 128 | 0 |
745013 | 745013 | 2020-11-18 | Jefferson | Washington | 53031 | 123 | 0 |
741766 | 741766 | 2020-11-17 | Jefferson | Washington | 53031 | 122 | 0 |
738519 | 738519 | 2020-11-16 | Jefferson | Washington | 53031 | 115 | 0 |
735275 | 735275 | 2020-11-15 | Jefferson | Washington | 53031 | 114 | 0 |
732029 | 732029 | 2020-11-14 | Jefferson | Washington | 53031 | 112 | 0 |
728784 | 728784 | 2020-11-13 | Jefferson | Washington | 53031 | 106 | 0 |
725541 | 725541 | 2020-11-12 | Jefferson | Washington | 53031 | 103 | 0 |
722298 | 722298 | 2020-11-11 | Jefferson | Washington | 53031 | 94 | 0 |
719055 | 719055 | 2020-11-10 | Jefferson | Washington | 53031 | 94 | 0 |
715812 | 715812 | 2020-11-09 | Jefferson | Washington | 53031 | 93 | 0 |
712568 | 712568 | 2020-11-08 | Jefferson | Washington | 53031 | 92 | 0 |
709324 | 709324 | 2020-11-07 | Jefferson | Washington | 53031 | 91 | 0 |
706080 | 706080 | 2020-11-06 | Jefferson | Washington | 53031 | 91 | 0 |
702837 | 702837 | 2020-11-05 | Jefferson | Washington | 53031 | 90 | 0 |
699594 | 699594 | 2020-11-04 | Jefferson | Washington | 53031 | 90 | 0 |
696350 | 696350 | 2020-11-03 | Jefferson | Washington | 53031 | 89 | 0 |
693108 | 693108 | 2020-11-02 | Jefferson | Washington | 53031 | 89 | 0 |
689864 | 689864 | 2020-11-01 | Jefferson | Washington | 53031 | 88 | 0 |
686619 | 686619 | 2020-10-31 | Jefferson | Washington | 53031 | 88 | 0 |
683376 | 683376 | 2020-10-30 | Jefferson | Washington | 53031 | 88 | 0 |
680133 | 680133 | 2020-10-29 | Jefferson | Washington | 53031 | 87 | 0 |
676890 | 676890 | 2020-10-28 | Jefferson | Washington | 53031 | 87 | 0 |
673647 | 673647 | 2020-10-27 | Jefferson | Washington | 53031 | 87 | 0 |
670405 | 670405 | 2020-10-26 | Jefferson | Washington | 53031 | 86 | 0 |
667162 | 667162 | 2020-10-25 | Jefferson | Washington | 53031 | 86 | 0 |
663917 | 663917 | 2020-10-24 | Jefferson | Washington | 53031 | 86 | 0 |
660673 | 660673 | 2020-10-23 | Jefferson | Washington | 53031 | 84 | 0 |
657429 | 657429 | 2020-10-22 | Jefferson | Washington | 53031 | 82 | 0 |
654184 | 654184 | 2020-10-21 | Jefferson | Washington | 53031 | 81 | 0 |
650939 | 650939 | 2020-10-20 | Jefferson | Washington | 53031 | 81 | 0 |
647695 | 647695 | 2020-10-19 | Jefferson | Washington | 53031 | 81 | 0 |
644449 | 644449 | 2020-10-18 | Jefferson | Washington | 53031 | 81 | 0 |
641201 | 641201 | 2020-10-17 | Jefferson | Washington | 53031 | 81 | 0 |
637954 | 637954 | 2020-10-16 | Jefferson | Washington | 53031 | 80 | 0 |
634709 | 634709 | 2020-10-15 | Jefferson | Washington | 53031 | 80 | 0 |
631464 | 631464 | 2020-10-14 | Jefferson | Washington | 53031 | 80 | 0 |
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);