outages

25 rows where regionName = 63

View and edit SQL

Suggested facets: outageStartTime, latitude, longitude, outageDevices

id outageStartTime latitude longitude regionName outageDevices
633585 October 01, 2019 - 14:39:08 UTC 36.81547 -121.70108 Elkhorn 63 []
643411 October 04, 2019 - 17:34:30 UTC 36.80532 -121.72272 Elkhorn 63 []
675173 October 21, 2019 - 15:30:00 UTC 36.81506 -121.7075 Elkhorn 63 [{"latitude": "36.81552", "longitude": "-121.70703"}, {"latitude": "36.81698", "longitude": "-121.70381"}, {"latitude": "36.81766", "longitude": "-121.70415"}, {"latitude": "36.81739", "longitude": "-121.70576"}, {"latitude": "36.81728", "longitude": "-121.70636"}, {"latitude": "36.81612", "longitude": "-121.70746"}]
689760 October 27, 2019 - 22:02:26 UTC 36.80763 -121.71498 Elkhorn 63 []
690591 October 27, 2019 - 22:02:26 UTC 36.80051 -121.72162 Elkhorn 63 []
700050 November 05, 2019 - 19:08:24 UTC 36.80763 -121.71498 Elkhorn 63 []
711967 November 21, 2019 - 14:55:17 UTC 36.81287 -121.71662 Elkhorn 63 []
711970 November 21, 2019 - 14:58:49 UTC 36.81245 -121.71555 Elkhorn 63 []
711972 November 21, 2019 - 14:57:38 UTC 36.81287 -121.71662 Elkhorn 63 []
718738 November 27, 2019 - 04:53:43 UTC 36.79807 -121.72068 Elkhorn 63 [{"latitude": "36.78451", "longitude": "-121.73232"}, {"latitude": "36.78521", "longitude": "-121.72669"}, {"latitude": "36.78898", "longitude": "-121.69806"}, {"latitude": "36.8089", "longitude": "-121.67823"}, {"latitude": "36.82008", "longitude": "-121.67776"}, {"latitude": "36.82268", "longitude": "-121.6777"}, {"latitude": "36.81695", "longitude": "-121.70866"}, {"latitude": "36.81579", "longitude": "-121.71263"}, {"latitude": "36.79302", "longitude": "-121.73212"}, {"latitude": "36.78507", "longitude": "-121.73654"}]
718741 November 27, 2019 - 04:53:43 UTC 36.80051 -121.72162 Elkhorn 63 [{"latitude": "36.79934", "longitude": "-121.70606"}, {"latitude": "36.83235", "longitude": "-121.69223"}, {"latitude": "36.83731", "longitude": "-121.69748"}, {"latitude": "36.83859", "longitude": "-121.69968"}, {"latitude": "36.84002", "longitude": "-121.70345"}, {"latitude": "36.85415", "longitude": "-121.74413"}, {"latitude": "36.85454", "longitude": "-121.74743"}, {"latitude": "36.85278", "longitude": "-121.7537"}, {"latitude": "36.80454", "longitude": "-121.72992"}, {"latitude": "36.80307", "longitude": "-121.72678"}, {"latitude": "36.80111", "longitude": "-121.72186"}]
718746 November 27, 2019 - 04:53:44 UTC 36.79747 -121.7282 Elkhorn 63 [{"latitude": "36.79552", "longitude": "-121.72688"}, {"latitude": "36.79592", "longitude": "-121.72671"}, {"latitude": "36.79672", "longitude": "-121.72859"}, {"latitude": "36.79558", "longitude": "-121.7288"}]
718754 November 27, 2019 - 04:54:15 UTC 36.79929 -121.72222 Elkhorn 63 []
718755 November 27, 2019 - 04:54:15 UTC 36.7975 -121.72816 Elkhorn 63 []
718758 November 27, 2019 - 04:54:15 UTC 36.79869 -121.72712 Elkhorn 63 [{"latitude": "36.79896", "longitude": "-121.72719"}, {"latitude": "36.80059", "longitude": "-121.72784"}, {"latitude": "36.80172", "longitude": "-121.72873"}, {"latitude": "36.80252", "longitude": "-121.73087"}, {"latitude": "36.80062", "longitude": "-121.72995"}]
720223 November 27, 2019 - 14:28:26 UTC 36.80265 -121.7032 Elkhorn 63 []
720755 November 27, 2019 - 17:02:37 UTC 36.80532 -121.72272 Elkhorn 63 []
721035 November 27, 2019 - 18:12:22 UTC 36.81863 -121.72951 Elkhorn 63 []
721735 November 27, 2019 - 22:13:51 UTC 36.79781 -121.73856 Elkhorn 63 []
731274 December 06, 2019 - 16:50:01 UTC 36.8141 -121.70611 Elkhorn 63 []
738394 December 13, 2019 - 17:39:26 UTC 36.80227 -121.73561 Elkhorn 63 []
739171 December 14, 2019 - 16:13:49 UTC 36.80532 -121.72272 Elkhorn 63 []
778242 February 05, 2020 - 15:58:52 UTC 36.8213 -121.68154 Elkhorn 63 []
779561 February 06, 2020 - 23:36:57 UTC 36.8213 -121.68154 Elkhorn 63 []
1094641 September 27, 2020 - 00:18:12 UTC 36.80622 -121.71392 Elkhorn 63 []

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [outages] (
   [id] INTEGER PRIMARY KEY,
   [outageStartTime] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [outageDevices] TEXT
)
Powered by Datasette · Query took 307.373ms · About: About this site