ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Umatilla" and deaths = 82 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 |
---|---|---|---|---|---|---|---|
1192117 | 1192117 | 2021-04-05 | Umatilla | Oregon | 41059 | 7884 | 82 |
1188868 | 1188868 | 2021-04-04 | Umatilla | Oregon | 41059 | 7884 | 82 |
1185621 | 1185621 | 2021-04-03 | Umatilla | Oregon | 41059 | 7884 | 82 |
1182374 | 1182374 | 2021-04-02 | Umatilla | Oregon | 41059 | 7878 | 82 |
1179127 | 1179127 | 2021-04-01 | Umatilla | Oregon | 41059 | 7871 | 82 |
1175880 | 1175880 | 2021-03-31 | Umatilla | Oregon | 41059 | 7871 | 82 |
1172633 | 1172633 | 2021-03-30 | Umatilla | Oregon | 41059 | 7868 | 82 |
1169386 | 1169386 | 2021-03-29 | Umatilla | Oregon | 41059 | 7859 | 82 |
1166138 | 1166138 | 2021-03-28 | Umatilla | Oregon | 41059 | 7859 | 82 |
1162890 | 1162890 | 2021-03-27 | Umatilla | Oregon | 41059 | 7859 | 82 |
1159641 | 1159641 | 2021-03-26 | Umatilla | Oregon | 41059 | 7851 | 82 |
1156394 | 1156394 | 2021-03-25 | Umatilla | Oregon | 41059 | 7844 | 82 |
1149900 | 1149900 | 2021-03-23 | Umatilla | Oregon | 41059 | 7826 | 82 |
1146653 | 1146653 | 2021-03-22 | Umatilla | Oregon | 41059 | 7816 | 82 |
1143406 | 1143406 | 2021-03-21 | Umatilla | Oregon | 41059 | 7816 | 82 |
1140159 | 1140159 | 2021-03-20 | Umatilla | Oregon | 41059 | 7816 | 82 |
1136913 | 1136913 | 2021-03-19 | Umatilla | Oregon | 41059 | 7809 | 82 |
1133667 | 1133667 | 2021-03-18 | Umatilla | Oregon | 41059 | 7795 | 82 |
1130419 | 1130419 | 2021-03-17 | Umatilla | Oregon | 41059 | 7788 | 82 |
1127172 | 1127172 | 2021-03-16 | Umatilla | Oregon | 41059 | 7775 | 82 |
1123926 | 1123926 | 2021-03-15 | Umatilla | Oregon | 41059 | 7757 | 82 |
1120680 | 1120680 | 2021-03-14 | Umatilla | Oregon | 41059 | 7757 | 82 |
1117433 | 1117433 | 2021-03-13 | Umatilla | Oregon | 41059 | 7757 | 82 |
1114186 | 1114186 | 2021-03-12 | Umatilla | Oregon | 41059 | 7748 | 82 |
1110940 | 1110940 | 2021-03-11 | Umatilla | Oregon | 41059 | 7745 | 82 |
1107694 | 1107694 | 2021-03-10 | Umatilla | Oregon | 41059 | 7732 | 82 |
1104448 | 1104448 | 2021-03-09 | Umatilla | Oregon | 41059 | 7726 | 82 |
1101202 | 1101202 | 2021-03-08 | Umatilla | Oregon | 41059 | 7709 | 82 |
1097956 | 1097956 | 2021-03-07 | Umatilla | Oregon | 41059 | 7709 | 82 |
1094708 | 1094708 | 2021-03-06 | Umatilla | Oregon | 41059 | 7709 | 82 |
1091462 | 1091462 | 2021-03-05 | Umatilla | Oregon | 41059 | 7707 | 82 |
1088216 | 1088216 | 2021-03-04 | Umatilla | Oregon | 41059 | 7696 | 82 |
1084971 | 1084971 | 2021-03-03 | Umatilla | Oregon | 41059 | 7678 | 82 |
1081725 | 1081725 | 2021-03-02 | Umatilla | Oregon | 41059 | 7671 | 82 |
1078479 | 1078479 | 2021-03-01 | Umatilla | Oregon | 41059 | 7660 | 82 |
1075234 | 1075234 | 2021-02-28 | Umatilla | Oregon | 41059 | 7659 | 82 |
1071988 | 1071988 | 2021-02-27 | Umatilla | Oregon | 41059 | 7651 | 82 |
1068742 | 1068742 | 2021-02-26 | Umatilla | Oregon | 41059 | 7639 | 82 |
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);