ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where county = "Jefferson", deaths = 1, fips = 53031 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 |
---|---|---|---|---|---|---|---|
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 |
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);