ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where deaths = 59 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 |
---|---|---|---|---|---|---|---|
2348828 | 2348828 | 2022-03-27 | Wasco | Oregon | 41065 | 5109 | 59 |
2345575 | 2345575 | 2022-03-26 | Wasco | Oregon | 41065 | 5109 | 59 |
2342322 | 2342322 | 2022-03-25 | Wasco | Oregon | 41065 | 5109 | 59 |
2339069 | 2339069 | 2022-03-24 | Wasco | Oregon | 41065 | 5109 | 59 |
2326052 | 2326052 | 2022-03-20 | Tillamook | Oregon | 41057 | 3622 | 59 |
2322799 | 2322799 | 2022-03-19 | Tillamook | Oregon | 41057 | 3622 | 59 |
2319545 | 2319545 | 2022-03-18 | Tillamook | Oregon | 41057 | 3622 | 59 |
2316291 | 2316291 | 2022-03-17 | Tillamook | Oregon | 41057 | 3613 | 59 |
2313038 | 2313038 | 2022-03-16 | Tillamook | Oregon | 41057 | 3613 | 59 |
2221964 | 2221964 | 2022-02-16 | Benton | Oregon | 41003 | 14471 | 59 |
2218713 | 2218713 | 2022-02-15 | Benton | Oregon | 41003 | 14408 | 59 |
2215462 | 2215462 | 2022-02-14 | Benton | Oregon | 41003 | 14377 | 59 |
2212211 | 2212211 | 2022-02-13 | Benton | Oregon | 41003 | 14218 | 59 |
2208958 | 2208958 | 2022-02-12 | Benton | Oregon | 41003 | 14218 | 59 |
2205705 | 2205705 | 2022-02-11 | Benton | Oregon | 41003 | 14218 | 59 |
2202452 | 2202452 | 2022-02-10 | Benton | Oregon | 41003 | 14159 | 59 |
2199198 | 2199198 | 2022-02-09 | Benton | Oregon | 41003 | 14056 | 59 |
2108128 | 2108128 | 2022-01-12 | Lincoln | Oregon | 41041 | 4511 | 59 |
2104877 | 2104877 | 2022-01-11 | Lincoln | Oregon | 41041 | 4302 | 59 |
2101626 | 2101626 | 2022-01-10 | Lincoln | Oregon | 41041 | 4254 | 59 |
2098375 | 2098375 | 2022-01-09 | Lincoln | Oregon | 41041 | 4189 | 59 |
2095123 | 2095123 | 2022-01-08 | Lincoln | Oregon | 41041 | 4189 | 59 |
2091871 | 2091871 | 2022-01-07 | Lincoln | Oregon | 41041 | 4189 | 59 |
2033373 | 2033373 | 2021-12-20 | Union | Oregon | 41061 | 3470 | 59 |
2030123 | 2030123 | 2021-12-19 | Union | Oregon | 41061 | 3469 | 59 |
2026872 | 2026872 | 2021-12-18 | Union | Oregon | 41061 | 3469 | 59 |
2023621 | 2023621 | 2021-12-17 | Union | Oregon | 41061 | 3469 | 59 |
2020370 | 2020370 | 2021-12-16 | Union | Oregon | 41061 | 3468 | 59 |
2017119 | 2017119 | 2021-12-15 | Union | Oregon | 41061 | 3467 | 59 |
2013845 | 2013845 | 2021-12-14 | Crook | Oregon | 41013 | 3514 | 59 |
2010592 | 2010592 | 2021-12-13 | Columbia | Oregon | 41009 | 4502 | 59 |
1283035 | 1283035 | 2021-05-03 | Klamath | Oregon | 41035 | 4098 | 59 |
1279788 | 1279788 | 2021-05-02 | Klamath | Oregon | 41035 | 4097 | 59 |
1276541 | 1276541 | 2021-05-01 | Klamath | Oregon | 41035 | 4062 | 59 |
1273294 | 1273294 | 2021-04-30 | Klamath | Oregon | 41035 | 4007 | 59 |
1270047 | 1270047 | 2021-04-29 | Klamath | Oregon | 41035 | 3929 | 59 |
1270052 | 1270052 | 2021-04-29 | Malheur | Oregon | 41045 | 3456 | 59 |
1266800 | 1266800 | 2021-04-28 | Klamath | Oregon | 41035 | 3905 | 59 |
1266805 | 1266805 | 2021-04-28 | Malheur | Oregon | 41045 | 3453 | 59 |
1263553 | 1263553 | 2021-04-27 | Klamath | Oregon | 41035 | 3850 | 59 |
1263558 | 1263558 | 2021-04-27 | Malheur | Oregon | 41045 | 3448 | 59 |
1260306 | 1260306 | 2021-04-26 | Klamath | Oregon | 41035 | 3805 | 59 |
1260311 | 1260311 | 2021-04-26 | Malheur | Oregon | 41045 | 3440 | 59 |
1257059 | 1257059 | 2021-04-25 | Klamath | Oregon | 41035 | 3805 | 59 |
1257064 | 1257064 | 2021-04-25 | Malheur | Oregon | 41045 | 3440 | 59 |
1253812 | 1253812 | 2021-04-24 | Klamath | Oregon | 41035 | 3768 | 59 |
1253817 | 1253817 | 2021-04-24 | Malheur | Oregon | 41045 | 3439 | 59 |
1250565 | 1250565 | 2021-04-23 | Klamath | Oregon | 41035 | 3728 | 59 |
1250570 | 1250570 | 2021-04-23 | Malheur | Oregon | 41045 | 3438 | 59 |
1247318 | 1247318 | 2021-04-22 | Klamath | Oregon | 41035 | 3625 | 59 |
1244071 | 1244071 | 2021-04-21 | Klamath | Oregon | 41035 | 3571 | 59 |
1240824 | 1240824 | 2021-04-20 | Klamath | Oregon | 41035 | 3537 | 59 |
1237577 | 1237577 | 2021-04-19 | Klamath | Oregon | 41035 | 3490 | 59 |
1234330 | 1234330 | 2021-04-18 | Klamath | Oregon | 41035 | 3490 | 59 |
1231082 | 1231082 | 2021-04-17 | Klamath | Oregon | 41035 | 3452 | 59 |
1227834 | 1227834 | 2021-04-16 | Klamath | Oregon | 41035 | 3408 | 59 |
1182361 | 1182361 | 2021-04-02 | Josephine | Oregon | 41033 | 2829 | 59 |
1179114 | 1179114 | 2021-04-01 | Josephine | Oregon | 41033 | 2818 | 59 |
1175867 | 1175867 | 2021-03-31 | Josephine | Oregon | 41033 | 2789 | 59 |
1172613 | 1172613 | 2021-03-30 | Douglas | Oregon | 41019 | 2879 | 59 |
1172620 | 1172620 | 2021-03-30 | Josephine | Oregon | 41033 | 2772 | 59 |
1169366 | 1169366 | 2021-03-29 | Douglas | Oregon | 41019 | 2861 | 59 |
1169373 | 1169373 | 2021-03-29 | Josephine | Oregon | 41033 | 2766 | 59 |
1166118 | 1166118 | 2021-03-28 | Douglas | Oregon | 41019 | 2849 | 59 |
1166125 | 1166125 | 2021-03-28 | Josephine | Oregon | 41033 | 2759 | 59 |
1162870 | 1162870 | 2021-03-27 | Douglas | Oregon | 41019 | 2837 | 59 |
1162877 | 1162877 | 2021-03-27 | Josephine | Oregon | 41033 | 2748 | 59 |
1159621 | 1159621 | 2021-03-26 | Douglas | Oregon | 41019 | 2826 | 59 |
1159628 | 1159628 | 2021-03-26 | Josephine | Oregon | 41033 | 2729 | 59 |
1159633 | 1159633 | 2021-03-26 | Linn | Oregon | 41043 | 3779 | 59 |
1156381 | 1156381 | 2021-03-25 | Josephine | Oregon | 41033 | 2714 | 59 |
1156386 | 1156386 | 2021-03-25 | Linn | Oregon | 41043 | 3768 | 59 |
1153134 | 1153134 | 2021-03-24 | Josephine | Oregon | 41033 | 2691 | 59 |
1153139 | 1153139 | 2021-03-24 | Linn | Oregon | 41043 | 3751 | 59 |
1149887 | 1149887 | 2021-03-23 | Josephine | Oregon | 41033 | 2677 | 59 |
1149892 | 1149892 | 2021-03-23 | Linn | Oregon | 41043 | 3742 | 59 |
1146640 | 1146640 | 2021-03-22 | Josephine | Oregon | 41033 | 2660 | 59 |
1146645 | 1146645 | 2021-03-22 | Linn | Oregon | 41043 | 3738 | 59 |
1143393 | 1143393 | 2021-03-21 | Josephine | Oregon | 41033 | 2650 | 59 |
1143398 | 1143398 | 2021-03-21 | Linn | Oregon | 41043 | 3734 | 59 |
1140146 | 1140146 | 2021-03-20 | Josephine | Oregon | 41033 | 2636 | 59 |
1140151 | 1140151 | 2021-03-20 | Linn | Oregon | 41043 | 3722 | 59 |
1136900 | 1136900 | 2021-03-19 | Josephine | Oregon | 41033 | 2612 | 59 |
1136905 | 1136905 | 2021-03-19 | Linn | Oregon | 41043 | 3706 | 59 |
1133654 | 1133654 | 2021-03-18 | Josephine | Oregon | 41033 | 2581 | 59 |
1133659 | 1133659 | 2021-03-18 | Linn | Oregon | 41043 | 3696 | 59 |
1130406 | 1130406 | 2021-03-17 | Josephine | Oregon | 41033 | 2555 | 59 |
1078458 | 1078458 | 2021-03-01 | Deschutes | Oregon | 41017 | 5956 | 59 |
1075213 | 1075213 | 2021-02-28 | Deschutes | Oregon | 41017 | 5952 | 59 |
1071967 | 1071967 | 2021-02-27 | Deschutes | Oregon | 41017 | 5946 | 59 |
1068721 | 1068721 | 2021-02-26 | Deschutes | Oregon | 41017 | 5934 | 59 |
1065476 | 1065476 | 2021-02-25 | Deschutes | Oregon | 41017 | 5922 | 59 |
1007083 | 1007083 | 2021-02-07 | Yamhill | Oregon | 41071 | 3549 | 59 |
1003837 | 1003837 | 2021-02-06 | Yamhill | Oregon | 41071 | 3533 | 59 |
1000591 | 1000591 | 2021-02-05 | Yamhill | Oregon | 41071 | 3515 | 59 |
906467 | 906467 | 2021-01-07 | Umatilla | Oregon | 41059 | 6146 | 59 |
569056 | 569056 | 2020-09-25 | Washington | Oregon | 41067 | 4468 | 59 |
565815 | 565815 | 2020-09-24 | Washington | Oregon | 41067 | 4417 | 59 |
562574 | 562574 | 2020-09-23 | Washington | Oregon | 41067 | 4369 | 59 |
533408 | 533408 | 2020-09-14 | Clackamas | Oregon | 41005 | 2168 | 59 |
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);