johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
114 rows where country_or_region = "US", deaths = 87 and province_or_state = "Oregon" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 114 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
294626 | 294626 | 2022-11-15 | US | Oregon | Benton | 41003 | 20866 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-16 04:21:09 | Benton, Oregon, US | |
3599656 | 3599656 | 2022-11-14 | US | Oregon | Benton | 41003 | 20866 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-15 04:21:16 | Benton, Oregon, US | |
314514 | 314514 | 2022-11-13 | US | Oregon | Benton | 41003 | 20866 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-14 04:21:09 | Benton, Oregon, US | |
65675 | 65675 | 2022-11-12 | US | Oregon | Benton | 41003 | 20866 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-13 04:21:14 | Benton, Oregon, US | |
2929837 | 2929837 | 2022-11-11 | US | Oregon | Benton | 41003 | 20866 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-12 04:20:41 | Benton, Oregon, US | |
2508673 | 2508673 | 2022-11-10 | US | Oregon | Benton | 41003 | 20866 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-11 04:21:22 | Benton, Oregon, US | |
2433548 | 2433548 | 2022-11-09 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-10 04:21:16 | Benton, Oregon, US | |
482204 | 482204 | 2022-11-08 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-09 04:21:22 | Benton, Oregon, US | |
2441354 | 2441354 | 2022-11-07 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-08 04:21:21 | Benton, Oregon, US | |
1052452 | 1052452 | 2022-11-06 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-07 04:21:26 | Benton, Oregon, US | |
620476 | 620476 | 2022-11-05 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-06 04:21:24 | Benton, Oregon, US | |
1024980 | 1024980 | 2022-11-04 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-05 04:21:52 | Benton, Oregon, US | |
433971 | 433971 | 2022-11-03 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-04 04:22:11 | Benton, Oregon, US | |
852213 | 852213 | 2022-11-02 | US | Oregon | Benton | 41003 | 20782 | 87 | 0 | 44.49167306 | -123.4316987 | 2022-11-03 04:22:05 | Benton, Oregon, US | |
2325989 | 2325989 | 2022-08-24 | US | Oregon | Union | 41061 | 5529 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-25 04:21:13 | Union, Oregon, US | |
1253398 | 1253398 | 2022-08-23 | US | Oregon | Union | 41061 | 5527 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-24 04:20:46 | Union, Oregon, US | |
2855502 | 2855502 | 2022-08-22 | US | Oregon | Union | 41061 | 5524 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-23 04:20:56 | Union, Oregon, US | |
2405474 | 2405474 | 2022-08-21 | US | Oregon | Union | 41061 | 5514 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-22 04:20:38 | Union, Oregon, US | |
3800552 | 3800552 | 2022-08-20 | US | Oregon | Union | 41061 | 5514 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-21 04:20:44 | Union, Oregon, US | |
2366138 | 2366138 | 2022-08-19 | US | Oregon | Union | 41061 | 5514 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-20 04:21:01 | Union, Oregon, US | |
1163809 | 1163809 | 2022-08-18 | US | Oregon | Union | 41061 | 5511 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-19 04:20:54 | Union, Oregon, US | |
3953133 | 3953133 | 2022-08-17 | US | Oregon | Union | 41061 | 5505 | 87 | 0 | 45.30915495 | -118.0068979 | 2022-08-18 04:21:11 | Union, Oregon, US | |
3650199 | 3650199 | 2022-08-14 | US | Oregon | Crook | 41013 | 7131 | 87 | 0 | 44.14230227 | -120.356297 | 2022-08-15 04:20:59 | Crook, Oregon, US | |
1971205 | 1971205 | 2022-08-13 | US | Oregon | Crook | 41013 | 7131 | 87 | 0 | 44.14230227 | -120.356297 | 2022-08-14 04:20:55 | Crook, Oregon, US | |
2891014 | 2891014 | 2022-08-12 | US | Oregon | Crook | 41013 | 7131 | 87 | 0 | 44.14230227 | -120.356297 | 2022-08-13 04:20:52 | Crook, Oregon, US | |
3910619 | 3910619 | 2022-08-11 | US | Oregon | Crook | 41013 | 7122 | 87 | 0 | 44.14230227 | -120.356297 | 2022-08-12 04:20:54 | Crook, Oregon, US | |
1651008 | 1651008 | 2022-06-23 | US | Oregon | Lincoln | 41041 | 7765 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-24 04:20:58 | Lincoln, Oregon, US | |
2190243 | 2190243 | 2022-06-22 | US | Oregon | Lincoln | 41041 | 7735 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-23 04:20:55 | Lincoln, Oregon, US | |
168674 | 168674 | 2022-06-21 | US | Oregon | Lincoln | 41041 | 7715 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-22 04:20:54 | Lincoln, Oregon, US | |
1765957 | 1765957 | 2022-06-20 | US | Oregon | Lincoln | 41041 | 7684 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-21 04:20:56 | Lincoln, Oregon, US | |
3272143 | 3272143 | 2022-06-19 | US | Oregon | Lincoln | 41041 | 7684 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-20 04:21:01 | Lincoln, Oregon, US | |
3400055 | 3400055 | 2022-06-18 | US | Oregon | Lincoln | 41041 | 7684 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-19 04:20:51 | Lincoln, Oregon, US | |
2313932 | 2313932 | 2022-06-17 | US | Oregon | Lincoln | 41041 | 7684 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-18 04:21:10 | Lincoln, Oregon, US | |
561436 | 561436 | 2022-06-16 | US | Oregon | Lincoln | 41041 | 7671 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-17 04:20:56 | Lincoln, Oregon, US | |
3985238 | 3985238 | 2022-06-15 | US | Oregon | Lincoln | 41041 | 7660 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-16 04:20:55 | Lincoln, Oregon, US | |
949479 | 949479 | 2022-06-14 | US | Oregon | Lincoln | 41041 | 7641 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-15 04:20:54 | Lincoln, Oregon, US | |
2981887 | 2981887 | 2022-06-13 | US | Oregon | Lincoln | 41041 | 7630 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-14 04:20:52 | Lincoln, Oregon, US | |
2238013 | 2238013 | 2022-06-12 | US | Oregon | Lincoln | 41041 | 7592 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-13 04:21:14 | Lincoln, Oregon, US | |
3144211 | 3144211 | 2022-06-11 | US | Oregon | Lincoln | 41041 | 7592 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-12 04:20:53 | Lincoln, Oregon, US | |
1947127 | 1947127 | 2022-06-10 | US | Oregon | Lincoln | 41041 | 7592 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-11 04:21:01 | Lincoln, Oregon, US | |
3160266 | 3160266 | 2022-06-09 | US | Oregon | Lincoln | 41041 | 7573 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-10 04:20:55 | Lincoln, Oregon, US | |
1423733 | 1423733 | 2022-06-08 | US | Oregon | Lincoln | 41041 | 7561 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-09 04:20:54 | Lincoln, Oregon, US | |
3728847 | 3728847 | 2022-06-07 | US | Oregon | Lincoln | 41041 | 7539 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-08 04:20:55 | Lincoln, Oregon, US | |
3890249 | 3890249 | 2022-06-06 | US | Oregon | Lincoln | 41041 | 7533 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-07 04:21:08 | Lincoln, Oregon, US | |
3510018 | 3510018 | 2022-06-05 | US | Oregon | Lincoln | 41041 | 7510 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-06 04:20:57 | Lincoln, Oregon, US | |
3530095 | 3530095 | 2022-06-04 | US | Oregon | Lincoln | 41041 | 7510 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-05 04:20:55 | Lincoln, Oregon, US | |
3136181 | 3136181 | 2022-06-03 | US | Oregon | Lincoln | 41041 | 7510 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-04 04:20:58 | Lincoln, Oregon, US | |
3581256 | 3581256 | 2022-06-02 | US | Oregon | Lincoln | 41041 | 7506 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-03 04:20:58 | Lincoln, Oregon, US | |
973549 | 973549 | 2022-06-01 | US | Oregon | Lincoln | 41041 | 7489 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-02 05:20:39 | Lincoln, Oregon, US | |
231856 | 231856 | 2022-05-31 | US | Oregon | Lincoln | 41041 | 7464 | 87 | 0 | 44.64252874 | -123.869912 | 2022-06-01 04:20:55 | Lincoln, Oregon, US | |
1439207 | 1439207 | 2022-03-28 | US | Oregon | Jefferson | 41031 | 7206 | 87 | 0 | 44.62806839 | -121.17832 | 2022-03-29 04:20:46 | Jefferson, Oregon, US | |
3404071 | 3404071 | 2021-11-30 | US | Oregon | Malheur | 41045 | 5924 | 87 | 0 | 43.1937027 | -117.62273950000001 | 2021-12-01 04:22:29 | Malheur, Oregon, US | |
2003295 | 2003295 | 2021-11-07 | US | Oregon | Polk | 41053 | 7737 | 87 | 0 | 44.90322804 | -123.4128888 | 2021-11-08 04:21:43 | Polk, Oregon, US | |
498286 | 498286 | 2021-11-06 | US | Oregon | Polk | 41053 | 7737 | 87 | 0 | 44.90322804 | -123.4128888 | 2021-11-07 04:21:53 | Polk, Oregon, US | |
3124141 | 3124141 | 2021-11-05 | US | Oregon | Polk | 41053 | 7737 | 87 | 0 | 44.90322804 | -123.4128888 | 2021-11-06 04:21:51 | Polk, Oregon, US | |
3013961 | 3013961 | 2021-09-22 | US | Oregon | Linn | 41043 | 10632 | 87 | 0 | 44.48899494 | -122.53731540000001 | 2021-09-23 04:21:43 | Linn, Oregon, US | |
3760099 | 3760099 | 2021-09-21 | US | Oregon | Linn | 41043 | 10514 | 87 | 0 | 44.48899494 | -122.53731540000001 | 2021-09-22 04:21:45 | Linn, Oregon, US | |
1777997 | 1777997 | 2021-08-30 | US | Oregon | Yamhill | 41071 | 6326 | 87 | 0 | 45.23330449 | -123.3086963 | 2021-08-31 04:21:46 | Yamhill, Oregon, US | |
652578 | 652578 | 2021-08-09 | US | Oregon | Deschutes | 41017 | 11119 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-10 04:21:27 | Deschutes, Oregon, US | |
592240 | 592240 | 2021-08-08 | US | Oregon | Deschutes | 41017 | 10880 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-09 04:21:24 | Deschutes, Oregon, US | |
2206252 | 2206252 | 2021-08-07 | US | Oregon | Deschutes | 41017 | 10880 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-08 04:21:33 | Deschutes, Oregon, US | |
1120202 | 1120202 | 2021-08-06 | US | Oregon | Deschutes | 41017 | 10880 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-07 04:21:30 | Deschutes, Oregon, US | |
1959139 | 1959139 | 2021-08-05 | US | Oregon | Deschutes | 41017 | 10827 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-06 04:21:18 | Deschutes, Oregon, US | |
334518 | 334518 | 2021-08-04 | US | Oregon | Deschutes | 41017 | 10741 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-05 04:21:51 | Deschutes, Oregon, US | |
3470789 | 3470789 | 2021-08-03 | US | Oregon | Deschutes | 41017 | 10708 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-04 04:21:25 | Deschutes, Oregon, US | |
3686063 | 3686063 | 2021-08-02 | US | Oregon | Deschutes | 41017 | 10667 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-03 04:21:39 | Deschutes, Oregon, US | |
3017962 | 3017962 | 2021-08-01 | US | Oregon | Deschutes | 41017 | 10565 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-02 04:21:36 | Deschutes, Oregon, US | |
3906585 | 3906585 | 2021-07-31 | US | Oregon | Deschutes | 41017 | 10565 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-08-01 04:21:50 | Deschutes, Oregon, US | |
3298790 | 3298790 | 2021-07-30 | US | Oregon | Deschutes | 41017 | 10565 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-31 04:21:35 | Deschutes, Oregon, US | |
3388001 | 3388001 | 2021-07-29 | US | Oregon | Deschutes | 41017 | 10528 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-30 04:21:34 | Deschutes, Oregon, US | |
410906 | 410906 | 2021-07-28 | US | Oregon | Deschutes | 41017 | 10493 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-29 04:21:33 | Deschutes, Oregon, US | |
410907 | 410907 | 2021-07-28 | US | Oregon | Douglas | 41019 | 4407 | 87 | 0 | 43.27941273 | -123.167291 | 2021-07-29 04:21:33 | Douglas, Oregon, US | |
1308767 | 1308767 | 2021-07-27 | US | Oregon | Deschutes | 41017 | 10453 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-28 04:21:39 | Deschutes, Oregon, US | |
1308768 | 1308768 | 2021-07-27 | US | Oregon | Douglas | 41019 | 4358 | 87 | 0 | 43.27941273 | -123.167291 | 2021-07-28 04:21:39 | Douglas, Oregon, US | |
3220910 | 3220910 | 2021-07-26 | US | Oregon | Deschutes | 41017 | 10418 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-27 04:21:18 | Deschutes, Oregon, US | |
3220911 | 3220911 | 2021-07-26 | US | Oregon | Douglas | 41019 | 4295 | 87 | 0 | 43.27941273 | -123.167291 | 2021-07-27 04:21:18 | Douglas, Oregon, US | |
1381119 | 1381119 | 2021-07-25 | US | Oregon | Deschutes | 41017 | 10357 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-26 04:21:28 | Deschutes, Oregon, US | |
1381120 | 1381120 | 2021-07-25 | US | Oregon | Douglas | 41019 | 4235 | 87 | 0 | 43.27941273 | -123.167291 | 2021-07-26 04:21:28 | Douglas, Oregon, US | |
1332859 | 1332859 | 2021-07-24 | US | Oregon | Deschutes | 41017 | 10357 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-25 04:22:12 | Deschutes, Oregon, US | |
1332860 | 1332860 | 2021-07-24 | US | Oregon | Douglas | 41019 | 4235 | 87 | 0 | 43.27941273 | -123.167291 | 2021-07-25 04:22:12 | Douglas, Oregon, US | |
3140163 | 3140163 | 2021-07-23 | US | Oregon | Deschutes | 41017 | 10357 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-24 00:21:36 | Deschutes, Oregon, US | |
3140164 | 3140164 | 2021-07-23 | US | Oregon | Douglas | 41019 | 4235 | 87 | 0 | 43.27941273 | -123.167291 | 2021-07-24 00:21:36 | Douglas, Oregon, US | |
3478923 | 3478923 | 2021-07-22 | US | Oregon | Deschutes | 41017 | 10335 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-23 04:21:29 | Deschutes, Oregon, US | |
3478924 | 3478924 | 2021-07-22 | US | Oregon | Douglas | 41019 | 4207 | 87 | 0 | 43.27941273 | -123.167291 | 2021-07-23 04:21:29 | Douglas, Oregon, US | |
3334142 | 3334142 | 2021-07-21 | US | Oregon | Deschutes | 41017 | 10307 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-22 04:21:19 | Deschutes, Oregon, US | |
2374123 | 2374123 | 2021-07-20 | US | Oregon | Deschutes | 41017 | 10289 | 87 | 0 | 43.91570171 | -121.2289121 | 2021-07-21 04:21:40 | Deschutes, Oregon, US | |
2696321 | 2696321 | 2021-07-06 | US | Oregon | Umatilla | 41059 | 8720 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-07-07 04:21:20 | Umatilla, Oregon, US | |
1935070 | 1935070 | 2021-07-05 | US | Oregon | Umatilla | 41059 | 8707 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-07-06 04:21:32 | Umatilla, Oregon, US | |
1167801 | 1167801 | 2021-07-04 | US | Oregon | Umatilla | 41059 | 8707 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-07-05 04:21:28 | Umatilla, Oregon, US | |
1498235 | 1498235 | 2021-07-03 | US | Oregon | Umatilla | 41059 | 8707 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-07-04 04:21:38 | Umatilla, Oregon, US | |
2074550 | 2074550 | 2021-07-02 | US | Oregon | Umatilla | 41059 | 8707 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-07-03 04:21:37 | Umatilla, Oregon, US | |
2767566 | 2767566 | 2021-07-01 | US | Oregon | Umatilla | 41059 | 8700 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-07-02 04:21:47 | Umatilla, Oregon, US | |
1895774 | 1895774 | 2021-06-30 | US | Oregon | Umatilla | 41059 | 8689 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-07-01 04:21:19 | Umatilla, Oregon, US | |
402897 | 402897 | 2021-06-29 | US | Oregon | Umatilla | 41059 | 8666 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-06-30 04:21:41 | Umatilla, Oregon, US | |
3128140 | 3128140 | 2021-06-28 | US | Oregon | Umatilla | 41059 | 8645 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-06-29 04:21:28 | Umatilla, Oregon, US | |
2592635 | 2592635 | 2021-06-27 | US | Oregon | Umatilla | 41059 | 8645 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-06-28 04:21:29 | Umatilla, Oregon, US | |
3961139 | 3961139 | 2021-06-26 | US | Oregon | Umatilla | 41059 | 8645 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-06-27 04:21:39 | Umatilla, Oregon, US | |
1714958 | 1714958 | 2021-06-25 | US | Oregon | Umatilla | 41059 | 8641 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-06-26 04:21:43 | Umatilla, Oregon, US | |
2298083 | 2298083 | 2021-06-24 | US | Oregon | Umatilla | 41059 | 8627 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-06-25 04:21:33 | Umatilla, Oregon, US | |
2425522 | 2425522 | 2021-06-23 | US | Oregon | Umatilla | 41059 | 8616 | 87 | 0 | 45.59073056 | -118.7353826 | 2021-06-24 04:21:55 | Umatilla, Oregon, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);