ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 25 and state = "Oregon" 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 |
---|---|---|---|---|---|---|---|
1237594 | 1237594 | 2021-04-19 | Wheeler | Oregon | 41069 | 25 | 1 |
1234347 | 1234347 | 2021-04-18 | Wheeler | Oregon | 41069 | 25 | 1 |
1231099 | 1231099 | 2021-04-17 | Wheeler | Oregon | 41069 | 25 | 1 |
1227851 | 1227851 | 2021-04-16 | Wheeler | Oregon | 41069 | 25 | 1 |
1224603 | 1224603 | 2021-04-15 | Wheeler | Oregon | 41069 | 25 | 1 |
1221356 | 1221356 | 2021-04-14 | Wheeler | Oregon | 41069 | 25 | 1 |
1218108 | 1218108 | 2021-04-13 | Wheeler | Oregon | 41069 | 25 | 1 |
1214860 | 1214860 | 2021-04-12 | Wheeler | Oregon | 41069 | 25 | 1 |
1211613 | 1211613 | 2021-04-11 | Wheeler | Oregon | 41069 | 25 | 1 |
1208364 | 1208364 | 2021-04-10 | Wheeler | Oregon | 41069 | 25 | 1 |
1205116 | 1205116 | 2021-04-09 | Wheeler | Oregon | 41069 | 25 | 1 |
1201868 | 1201868 | 2021-04-08 | Wheeler | Oregon | 41069 | 25 | 1 |
1198619 | 1198619 | 2021-04-07 | Wheeler | Oregon | 41069 | 25 | 1 |
1195370 | 1195370 | 2021-04-06 | Wheeler | Oregon | 41069 | 25 | 1 |
1192122 | 1192122 | 2021-04-05 | Wheeler | Oregon | 41069 | 25 | 1 |
1188873 | 1188873 | 2021-04-04 | Wheeler | Oregon | 41069 | 25 | 1 |
1185626 | 1185626 | 2021-04-03 | Wheeler | Oregon | 41069 | 25 | 1 |
1182379 | 1182379 | 2021-04-02 | Wheeler | Oregon | 41069 | 25 | 1 |
1179132 | 1179132 | 2021-04-01 | Wheeler | Oregon | 41069 | 25 | 1 |
1175885 | 1175885 | 2021-03-31 | Wheeler | Oregon | 41069 | 25 | 1 |
1172638 | 1172638 | 2021-03-30 | Wheeler | Oregon | 41069 | 25 | 1 |
1169391 | 1169391 | 2021-03-29 | Wheeler | Oregon | 41069 | 25 | 1 |
1166143 | 1166143 | 2021-03-28 | Wheeler | Oregon | 41069 | 25 | 1 |
1162895 | 1162895 | 2021-03-27 | Wheeler | Oregon | 41069 | 25 | 1 |
1159646 | 1159646 | 2021-03-26 | Wheeler | Oregon | 41069 | 25 | 1 |
1156399 | 1156399 | 2021-03-25 | Wheeler | Oregon | 41069 | 25 | 1 |
1153152 | 1153152 | 2021-03-24 | Wheeler | Oregon | 41069 | 25 | 1 |
1149905 | 1149905 | 2021-03-23 | Wheeler | Oregon | 41069 | 25 | 1 |
1146658 | 1146658 | 2021-03-22 | Wheeler | Oregon | 41069 | 25 | 1 |
1143411 | 1143411 | 2021-03-21 | Wheeler | Oregon | 41069 | 25 | 1 |
1140164 | 1140164 | 2021-03-20 | Wheeler | Oregon | 41069 | 25 | 1 |
1136918 | 1136918 | 2021-03-19 | Wheeler | Oregon | 41069 | 25 | 1 |
1133672 | 1133672 | 2021-03-18 | Wheeler | Oregon | 41069 | 25 | 1 |
1130424 | 1130424 | 2021-03-17 | Wheeler | Oregon | 41069 | 25 | 1 |
825312 | 825312 | 2020-12-13 | Gilliam | Oregon | 41021 | 25 | 1 |
822065 | 822065 | 2020-12-12 | Gilliam | Oregon | 41021 | 25 | 1 |
818819 | 818819 | 2020-12-11 | Gilliam | Oregon | 41021 | 25 | 1 |
815573 | 815573 | 2020-12-10 | Gilliam | Oregon | 41021 | 25 | 1 |
815590 | 815590 | 2020-12-10 | Sherman | Oregon | 41055 | 25 | 0 |
812327 | 812327 | 2020-12-09 | Gilliam | Oregon | 41021 | 25 | 1 |
809083 | 809083 | 2020-12-08 | Gilliam | Oregon | 41021 | 25 | 1 |
702004 | 702004 | 2020-11-05 | Grant | Oregon | 41023 | 25 | 0 |
526941 | 526941 | 2020-09-12 | Curry | Oregon | 41015 | 25 | 0 |
523705 | 523705 | 2020-09-11 | Curry | Oregon | 41015 | 25 | 0 |
384925 | 384925 | 2020-07-30 | Baker | Oregon | 41001 | 25 | 0 |
186692 | 186692 | 2020-05-28 | Douglas | Oregon | 41019 | 25 | 0 |
186697 | 186697 | 2020-05-28 | Jefferson | Oregon | 41031 | 25 | 0 |
186698 | 186698 | 2020-05-28 | Josephine | Oregon | 41033 | 25 | 1 |
183635 | 183635 | 2020-05-27 | Douglas | Oregon | 41019 | 25 | 0 |
183641 | 183641 | 2020-05-27 | Josephine | Oregon | 41033 | 25 | 1 |
180586 | 180586 | 2020-05-26 | Douglas | Oregon | 41019 | 25 | 0 |
180592 | 180592 | 2020-05-26 | Josephine | Oregon | 41033 | 25 | 1 |
177543 | 177543 | 2020-05-25 | Douglas | Oregon | 41019 | 25 | 0 |
174499 | 174499 | 2020-05-24 | Douglas | Oregon | 41019 | 25 | 0 |
174504 | 174504 | 2020-05-24 | Jefferson | Oregon | 41031 | 25 | 0 |
174505 | 174505 | 2020-05-24 | Josephine | Oregon | 41033 | 25 | 1 |
171457 | 171457 | 2020-05-23 | Douglas | Oregon | 41019 | 25 | 0 |
171462 | 171462 | 2020-05-23 | Jefferson | Oregon | 41031 | 25 | 0 |
171463 | 171463 | 2020-05-23 | Josephine | Oregon | 41033 | 25 | 1 |
168418 | 168418 | 2020-05-22 | Douglas | Oregon | 41019 | 25 | 0 |
168423 | 168423 | 2020-05-22 | Jefferson | Oregon | 41031 | 25 | 0 |
168424 | 168424 | 2020-05-22 | Josephine | Oregon | 41033 | 25 | 1 |
165382 | 165382 | 2020-05-21 | Douglas | Oregon | 41019 | 25 | 0 |
165387 | 165387 | 2020-05-21 | Jefferson | Oregon | 41031 | 25 | 0 |
165388 | 165388 | 2020-05-21 | Josephine | Oregon | 41033 | 25 | 1 |
162353 | 162353 | 2020-05-20 | Douglas | Oregon | 41019 | 25 | 0 |
159326 | 159326 | 2020-05-19 | Douglas | Oregon | 41019 | 25 | 0 |
159332 | 159332 | 2020-05-19 | Josephine | Oregon | 41033 | 25 | 1 |
156305 | 156305 | 2020-05-18 | Douglas | Oregon | 41019 | 25 | 0 |
156311 | 156311 | 2020-05-18 | Josephine | Oregon | 41033 | 25 | 1 |
153288 | 153288 | 2020-05-17 | Douglas | Oregon | 41019 | 25 | 0 |
153294 | 153294 | 2020-05-17 | Josephine | Oregon | 41033 | 25 | 1 |
150283 | 150283 | 2020-05-16 | Josephine | Oregon | 41033 | 25 | 1 |
147270 | 147270 | 2020-05-15 | Douglas | Oregon | 41019 | 25 | 0 |
147276 | 147276 | 2020-05-15 | Josephine | Oregon | 41033 | 25 | 1 |
144275 | 144275 | 2020-05-14 | Josephine | Oregon | 41033 | 25 | 1 |
141279 | 141279 | 2020-05-13 | Josephine | Oregon | 41033 | 25 | 1 |
138283 | 138283 | 2020-05-12 | Josephine | Oregon | 41033 | 25 | 1 |
111629 | 111629 | 2020-05-03 | Coos | Oregon | 41011 | 25 | 0 |
69332 | 69332 | 2020-04-18 | Umatilla | Oregon | 41059 | 25 | 0 |
61077 | 61077 | 2020-04-15 | Benton | Oregon | 41003 | 25 | 3 |
55673 | 55673 | 2020-04-13 | Klamath | Oregon | 41035 | 25 | 0 |
52988 | 52988 | 2020-04-12 | Klamath | Oregon | 41035 | 25 | 0 |
50315 | 50315 | 2020-04-11 | Klamath | Oregon | 41035 | 25 | 0 |
42471 | 42471 | 2020-04-08 | Yamhill | Oregon | 41071 | 25 | 5 |
39911 | 39911 | 2020-04-07 | Yamhill | Oregon | 41071 | 25 | 3 |
37390 | 37390 | 2020-04-06 | Yamhill | Oregon | 41071 | 25 | 3 |
21133 | 21133 | 2020-03-30 | Deschutes | Oregon | 41017 | 25 | 0 |
11946 | 11946 | 2020-03-25 | Linn | Oregon | 41043 | 25 | 1 |
10486 | 10486 | 2020-03-24 | Multnomah | Oregon | 41051 | 25 | 2 |
4975 | 4975 | 2020-03-19 | Washington | Oregon | 41067 | 25 | 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);