daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where country_or_region = "US", deaths = 118 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 · 50 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-15 | US | Oregon | Malheur | 41045 | 9296 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-16 04:21:09 | Malheur, Oregon, US | |
2022-11-14 | US | Oregon | Malheur | 41045 | 9296 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-15 04:21:16 | Malheur, Oregon, US | |
2022-11-13 | US | Oregon | Malheur | 41045 | 9296 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-14 04:21:09 | Malheur, Oregon, US | |
2022-11-12 | US | Oregon | Malheur | 41045 | 9296 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-13 04:21:14 | Malheur, Oregon, US | |
2022-11-11 | US | Oregon | Malheur | 41045 | 9296 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-12 04:20:41 | Malheur, Oregon, US | |
2022-11-10 | US | Oregon | Malheur | 41045 | 9296 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-11 04:21:22 | Malheur, Oregon, US | |
2022-11-09 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-10 04:21:16 | Malheur, Oregon, US | |
2022-11-08 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-09 04:21:22 | Malheur, Oregon, US | |
2022-11-07 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-08 04:21:21 | Malheur, Oregon, US | |
2022-11-06 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-07 04:21:26 | Malheur, Oregon, US | |
2022-11-05 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-06 04:21:24 | Malheur, Oregon, US | |
2022-11-04 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-05 04:21:52 | Malheur, Oregon, US | |
2022-11-03 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-04 04:22:11 | Malheur, Oregon, US | |
2022-11-02 | US | Oregon | Malheur | 41045 | 9270 | 118 | 0 | 43.1937027 | -117.6227395 | 2022-11-03 04:22:05 | Malheur, Oregon, US | |
2022-02-22 | US | Oregon | Polk | 41053 | 14963 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-23 04:21:09 | Polk, Oregon, US | |
2022-02-21 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-22 04:21:01 | Polk, Oregon, US | |
2022-02-20 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-21 04:21:05 | Polk, Oregon, US | |
2022-02-19 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-20 04:21:00 | Polk, Oregon, US | |
2022-02-18 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-19 04:21:11 | Polk, Oregon, US | |
2022-02-17 | US | Oregon | Polk | 41053 | 14853 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-18 04:21:04 | Polk, Oregon, US | |
2022-02-16 | US | Oregon | Polk | 41053 | 14817 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-17 04:20:56 | Polk, Oregon, US | |
2022-02-15 | US | Oregon | Polk | 41053 | 14774 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-16 04:21:10 | Polk, Oregon, US | |
2022-02-14 | US | Oregon | Polk | 41053 | 14711 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-15 04:21:09 | Polk, Oregon, US | |
2022-02-13 | US | Oregon | Polk | 41053 | 14608 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-14 04:20:51 | Polk, Oregon, US | |
2022-02-12 | US | Oregon | Polk | 41053 | 14608 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-13 04:21:00 | Polk, Oregon, US | |
2022-02-11 | US | Oregon | Polk | 41053 | 14608 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-12 04:21:06 | Polk, Oregon, US | |
2022-02-10 | US | Oregon | Polk | 41053 | 14529 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-11 04:21:09 | Polk, Oregon, US | |
2021-12-28 | US | Oregon | Coos | 41011 | 6322 | 118 | 0 | 43.17406868 | -124.0594514 | 2021-12-29 03:21:43 | Coos, Oregon, US | |
2021-12-27 | US | Oregon | Coos | 41011 | 6227 | 118 | 0 | 43.17406868 | -124.0594514 | 2021-12-28 04:21:47 | Coos, Oregon, US | |
2021-12-26 | US | Oregon | Coos | 41011 | 6201 | 118 | 0 | 43.17406868 | -124.0594514 | 2021-12-27 04:21:58 | Coos, Oregon, US | |
2021-12-25 | US | Oregon | Coos | 41011 | 6201 | 118 | 0 | 43.17406868 | -124.0594514 | 2021-12-26 04:21:50 | Coos, Oregon, US | |
2021-12-24 | US | Oregon | Coos | 41011 | 6201 | 118 | 0 | 43.17406868 | -124.0594514 | 2021-12-25 04:21:37 | Coos, Oregon, US | |
2021-12-23 | US | Oregon | Coos | 41011 | 6201 | 118 | 0 | 43.17406868 | -124.0594514 | 2021-12-24 04:21:34 | Coos, Oregon, US | |
2021-12-22 | US | Oregon | Coos | 41011 | 6184 | 118 | 0 | 43.17406868 | -124.0594514 | 2021-12-23 04:21:21 | Coos, Oregon, US | |
2021-11-02 | US | Oregon | Yamhill | 41071 | 9051 | 118 | 0 | 45.23330449 | -123.3086963 | 2021-11-03 06:22:09 | Yamhill, Oregon, US | |
2021-11-01 | US | Oregon | Yamhill | 41071 | 8980 | 118 | 0 | 45.23330449 | -123.3086963 | 2021-11-02 04:22:03 | Yamhill, Oregon, US | |
2021-10-31 | US | Oregon | Yamhill | 41071 | 8933 | 118 | 0 | 45.23330449 | -123.3086963 | 2021-11-01 04:22:01 | Yamhill, Oregon, US | |
2021-10-30 | US | Oregon | Yamhill | 41071 | 8933 | 118 | 0 | 45.23330449 | -123.3086963 | 2021-10-31 04:22:08 | Yamhill, Oregon, US | |
2021-10-29 | US | Oregon | Yamhill | 41071 | 8933 | 118 | 0 | 45.23330449 | -123.3086963 | 2021-10-30 04:22:03 | Yamhill, Oregon, US | |
2021-10-21 | US | Oregon | Klamath | 41035 | 7965 | 118 | 0 | 42.68762984 | -121.64964609999998 | 2021-10-22 04:21:14 | Klamath, Oregon, US | |
2021-09-08 | US | Oregon | Umatilla | 41059 | 11999 | 118 | 0 | 45.59073056 | -118.7353826 | 2021-09-09 04:21:27 | Umatilla, Oregon, US | |
2021-09-07 | US | Oregon | Umatilla | 41059 | 11885 | 118 | 0 | 45.59073056 | -118.7353826 | 2021-09-08 04:21:31 | Umatilla, Oregon, US | |
2021-03-08 | US | Oregon | Jackson | 41029 | 8604 | 118 | 0 | 42.43201126 | -122.7289309 | 2021-03-09 05:28:19 | Jackson, Oregon, US | |
2021-03-07 | US | Oregon | Jackson | 41029 | 8582 | 118 | 0 | 42.43201126 | -122.7289309 | 2021-03-08 05:24:48 | Jackson, Oregon, US | |
2021-03-06 | US | Oregon | Jackson | 41029 | 8569 | 118 | 0 | 8451 | 42.43201126 | -122.7289309 | 2021-03-07 05:21:54 | Jackson, Oregon, US |
2021-03-05 | US | Oregon | Jackson | 41029 | 8543 | 118 | 0 | 8425 | 42.43201126 | -122.7289309 | 2021-03-06 04:23:41 | Jackson, Oregon, US |
2020-11-09 | US | Oregon | Marion | 41047 | 6878 | 118 | 0 | 6760 | 44.90287942 | -122.5815117 | 2020-11-10 05:40:07 | Marion, Oregon, US |
2020-08-31 | US | Oregon | Multnomah | 41051 | 6007 | 118 | 0 | 5889 | 45.54747959 | -122.4169351 | 2020-09-01 04:28:31 | Multnomah, Oregon, US |
2020-08-30 | US | Oregon | Multnomah | 41051 | 5975 | 118 | 0 | 5857 | 45.54747959 | -122.4169351 | 2020-08-31 04:28:27 | Multnomah, Oregon, US |
2020-08-29 | US | Oregon | Multnomah | 41051 | 5942 | 118 | 0 | 5824 | 45.54747959 | -122.4169351 | 2020-08-30 04:28:22 | Multnomah, Oregon, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;