ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27,784 rows where state = "Oregon" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips 37
- 41067 806
- 41029 798
- 41035 798
- 41019 797
- 41047 797
- 41051 795
- 41017 794
- 41043 794
- 41053 794
- 41059 794
- 41005 793
- 41071 790
- 41003 789
- 41039 788
- 41023 785
- 41061 785
- 41033 784
- 41027 782
- 41007 781
- 41041 780
- 41057 779
- 41065 779
- 41009 778
- 41049 778
- 41045 774
- 41063 774
- 41013 771
- 41055 769
- 41015 768
- 41011 763
- 41031 760
- 41025 746
- 41001 738
- 41037 717
- 41021 679
- 41069 580
- - 7
county 37
- Washington 806
- Jackson 798
- Klamath 798
- Douglas 797
- Marion 797
- Multnomah 795
- Deschutes 794
- Linn 794
- Polk 794
- Umatilla 794
- Clackamas 793
- Yamhill 790
- Benton 789
- Lane 788
- Grant 785
- Union 785
- Josephine 784
- Hood River 782
- Clatsop 781
- Lincoln 780
- Tillamook 779
- Wasco 779
- Columbia 778
- Morrow 778
- Malheur 774
- Wallowa 774
- Crook 771
- Sherman 769
- Curry 768
- Coos 763
- Jefferson 760
- Harney 746
- Baker 738
- Lake 717
- Gilliam 679
- Wheeler 580
- Unknown 7
state 1
- Oregon · 27,784 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
370 | 370 | 2020-02-28 | Washington | Oregon | 41067 | 1 | 0 |
392 | 392 | 2020-02-29 | Washington | Oregon | 41067 | 1 | 0 |
724 | 724 | 2020-03-07 | Klamath | Oregon | 41035 | 1 | 0 |
830 | 830 | 2020-03-08 | Douglas | Oregon | 41019 | 1 | 0 |
832 | 832 | 2020-03-08 | Klamath | Oregon | 41035 | 1 | 0 |
833 | 833 | 2020-03-08 | Marion | Oregon | 41047 | 1 | 0 |
958 | 958 | 2020-03-09 | Douglas | Oregon | 41019 | 1 | 0 |
960 | 960 | 2020-03-09 | Klamath | Oregon | 41035 | 1 | 0 |
961 | 961 | 2020-03-09 | Marion | Oregon | 41047 | 1 | 0 |
1109 | 1109 | 2020-03-10 | Douglas | Oregon | 41019 | 1 | 0 |
1111 | 1111 | 2020-03-10 | Klamath | Oregon | 41035 | 1 | 0 |
1112 | 1112 | 2020-03-10 | Marion | Oregon | 41047 | 1 | 0 |
1113 | 1113 | 2020-03-10 | Multnomah | Oregon | 41051 | 1 | 0 |
1298 | 1298 | 2020-03-11 | Deschutes | Oregon | 41017 | 1 | 0 |
1299 | 1299 | 2020-03-11 | Douglas | Oregon | 41019 | 1 | 0 |
1301 | 1301 | 2020-03-11 | Klamath | Oregon | 41035 | 1 | 0 |
1304 | 1304 | 2020-03-11 | Multnomah | Oregon | 41051 | 1 | 0 |
1305 | 1305 | 2020-03-11 | Polk | Oregon | 41053 | 1 | 0 |
1306 | 1306 | 2020-03-11 | Umatilla | Oregon | 41059 | 1 | 0 |
1541 | 1541 | 2020-03-12 | Clackamas | Oregon | 41005 | 1 | 0 |
1542 | 1542 | 2020-03-12 | Deschutes | Oregon | 41017 | 1 | 0 |
1543 | 1543 | 2020-03-12 | Douglas | Oregon | 41019 | 1 | 0 |
1545 | 1545 | 2020-03-12 | Klamath | Oregon | 41035 | 1 | 0 |
1548 | 1548 | 2020-03-12 | Multnomah | Oregon | 41051 | 1 | 0 |
1549 | 1549 | 2020-03-12 | Polk | Oregon | 41053 | 1 | 0 |
1837 | 1837 | 2020-03-13 | Clackamas | Oregon | 41005 | 1 | 0 |
1838 | 1838 | 2020-03-13 | Deschutes | Oregon | 41017 | 1 | 0 |
1839 | 1839 | 2020-03-13 | Douglas | Oregon | 41019 | 1 | 0 |
1841 | 1841 | 2020-03-13 | Klamath | Oregon | 41035 | 1 | 0 |
1844 | 1844 | 2020-03-13 | Multnomah | Oregon | 41051 | 1 | 0 |
1845 | 1845 | 2020-03-13 | Polk | Oregon | 41053 | 1 | 0 |
2198 | 2198 | 2020-03-14 | Clackamas | Oregon | 41005 | 1 | 0 |
2200 | 2200 | 2020-03-14 | Douglas | Oregon | 41019 | 1 | 0 |
2202 | 2202 | 2020-03-14 | Klamath | Oregon | 41035 | 1 | 0 |
2205 | 2205 | 2020-03-14 | Multnomah | Oregon | 41051 | 1 | 1 |
2206 | 2206 | 2020-03-14 | Polk | Oregon | 41053 | 1 | 0 |
2617 | 2617 | 2020-03-15 | Clackamas | Oregon | 41005 | 1 | 0 |
2619 | 2619 | 2020-03-15 | Douglas | Oregon | 41019 | 1 | 0 |
2621 | 2621 | 2020-03-15 | Klamath | Oregon | 41035 | 1 | 0 |
2624 | 2624 | 2020-03-15 | Multnomah | Oregon | 41051 | 1 | 1 |
2625 | 2625 | 2020-03-15 | Polk | Oregon | 41053 | 1 | 0 |
2628 | 2628 | 2020-03-15 | Yamhill | Oregon | 41071 | 1 | 0 |
3081 | 3081 | 2020-03-16 | Benton | Oregon | 41003 | 1 | 0 |
3084 | 3084 | 2020-03-16 | Douglas | Oregon | 41019 | 1 | 0 |
3086 | 3086 | 2020-03-16 | Klamath | Oregon | 41035 | 1 | 0 |
3090 | 3090 | 2020-03-16 | Polk | Oregon | 41053 | 1 | 0 |
3093 | 3093 | 2020-03-16 | Yamhill | Oregon | 41071 | 1 | 0 |
3609 | 3609 | 2020-03-17 | Benton | Oregon | 41003 | 1 | 0 |
3612 | 3612 | 2020-03-17 | Douglas | Oregon | 41019 | 1 | 0 |
3614 | 3614 | 2020-03-17 | Klamath | Oregon | 41035 | 1 | 0 |
3619 | 3619 | 2020-03-17 | Polk | Oregon | 41053 | 1 | 0 |
3622 | 3622 | 2020-03-17 | Yamhill | Oregon | 41071 | 1 | 0 |
4227 | 4227 | 2020-03-18 | Douglas | Oregon | 41019 | 1 | 0 |
4229 | 4229 | 2020-03-18 | Klamath | Oregon | 41035 | 1 | 0 |
4234 | 4234 | 2020-03-18 | Polk | Oregon | 41053 | 1 | 0 |
4966 | 4966 | 2020-03-19 | Douglas | Oregon | 41019 | 1 | 0 |
4968 | 4968 | 2020-03-19 | Klamath | Oregon | 41035 | 1 | 0 |
4973 | 4973 | 2020-03-19 | Polk | Oregon | 41053 | 1 | 0 |
5833 | 5833 | 2020-03-20 | Douglas | Oregon | 41019 | 1 | 0 |
5834 | 5834 | 2020-03-20 | Grant | Oregon | 41023 | 1 | 0 |
5836 | 5836 | 2020-03-20 | Klamath | Oregon | 41035 | 1 | 0 |
5841 | 5841 | 2020-03-20 | Polk | Oregon | 41053 | 1 | 0 |
5843 | 5843 | 2020-03-20 | Union | Oregon | 41061 | 1 | 0 |
6834 | 6834 | 2020-03-21 | Douglas | Oregon | 41019 | 1 | 0 |
6835 | 6835 | 2020-03-21 | Grant | Oregon | 41023 | 1 | 0 |
6837 | 6837 | 2020-03-21 | Josephine | Oregon | 41033 | 1 | 0 |
6838 | 6838 | 2020-03-21 | Klamath | Oregon | 41035 | 1 | 0 |
6843 | 6843 | 2020-03-21 | Polk | Oregon | 41053 | 1 | 0 |
6845 | 6845 | 2020-03-21 | Union | Oregon | 41061 | 1 | 0 |
7949 | 7949 | 2020-03-22 | Douglas | Oregon | 41019 | 1 | 0 |
7950 | 7950 | 2020-03-22 | Grant | Oregon | 41023 | 1 | 0 |
7952 | 7952 | 2020-03-22 | Josephine | Oregon | 41033 | 1 | 0 |
7953 | 7953 | 2020-03-22 | Klamath | Oregon | 41035 | 1 | 0 |
7958 | 7958 | 2020-03-22 | Polk | Oregon | 41053 | 1 | 0 |
7960 | 7960 | 2020-03-22 | Union | Oregon | 41061 | 1 | 0 |
9158 | 9158 | 2020-03-23 | Douglas | Oregon | 41019 | 1 | 0 |
9159 | 9159 | 2020-03-23 | Grant | Oregon | 41023 | 1 | 0 |
9160 | 9160 | 2020-03-23 | Hood River | Oregon | 41027 | 1 | 0 |
9162 | 9162 | 2020-03-23 | Josephine | Oregon | 41033 | 1 | 0 |
9163 | 9163 | 2020-03-23 | Klamath | Oregon | 41035 | 1 | 0 |
9170 | 9170 | 2020-03-23 | Union | Oregon | 41061 | 1 | 0 |
10475 | 10475 | 2020-03-24 | Clatsop | Oregon | 41007 | 1 | 0 |
10477 | 10477 | 2020-03-24 | Douglas | Oregon | 41019 | 1 | 0 |
10478 | 10478 | 2020-03-24 | Grant | Oregon | 41023 | 1 | 0 |
10479 | 10479 | 2020-03-24 | Hood River | Oregon | 41027 | 1 | 0 |
10481 | 10481 | 2020-03-24 | Josephine | Oregon | 41033 | 1 | 0 |
10482 | 10482 | 2020-03-24 | Klamath | Oregon | 41035 | 1 | 0 |
10489 | 10489 | 2020-03-24 | Union | Oregon | 41061 | 1 | 0 |
11936 | 11936 | 2020-03-25 | Clatsop | Oregon | 41007 | 1 | 0 |
11939 | 11939 | 2020-03-25 | Grant | Oregon | 41023 | 1 | 0 |
11940 | 11940 | 2020-03-25 | Hood River | Oregon | 41027 | 1 | 0 |
11943 | 11943 | 2020-03-25 | Klamath | Oregon | 41035 | 1 | 0 |
11945 | 11945 | 2020-03-25 | Lincoln | Oregon | 41041 | 1 | 0 |
11951 | 11951 | 2020-03-25 | Union | Oregon | 41061 | 1 | 0 |
13555 | 13555 | 2020-03-26 | Grant | Oregon | 41023 | 1 | 0 |
13556 | 13556 | 2020-03-26 | Hood River | Oregon | 41027 | 1 | 0 |
13559 | 13559 | 2020-03-26 | Klamath | Oregon | 41035 | 1 | 0 |
13561 | 13561 | 2020-03-26 | Lincoln | Oregon | 41041 | 1 | 0 |
13566 | 13566 | 2020-03-26 | Tillamook | Oregon | 41057 | 1 | 0 |
13568 | 13568 | 2020-03-26 | Union | Oregon | 41061 | 1 | 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);