outages

10 rows where regionName = 191

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ outageStartTime latitude longitude regionName outageDevices
634593 October 01, 2019 - 20:03:41 UTC 36.8781 -119.76435 Fort Washington 191 []
720596 November 27, 2019 - 16:20:53 UTC 36.87911 -119.7578 Fort Washington 191 []
738447 December 13, 2019 - 18:25:57 UTC 36.87891 -119.76514 Fort Washington 191 []
789673 February 12, 2020 - 21:39:56 UTC 36.87911 -119.7573 Fort Washington 191 []
1079054 September 17, 2020 - 21:44:46 UTC 36.8781 -119.76354 Fort Washington 191 []
1123612 October 22, 2020 - 21:29:10 UTC 36.88097 -119.76514 Fort Washington 191 []
1138748 November 07, 2020 - 21:10:21 UTC 36.87911 -119.75972 Fort Washington 191 []
1204429 January 05, 2021 - 17:01:20 UTC 36.87808 -119.75998 Fort Washington 191 [{"latitude": "36.87807", "longitude": "-119.7587"}, {"latitude": "36.87807", "longitude": "-119.75705"}, {"latitude": "36.87911", "longitude": "-119.7573"}, {"latitude": "36.87911", "longitude": "-119.75878"}, {"latitude": "36.87911", "longitude": "-119.75972"}, {"latitude": "36.87807", "longitude": "-119.75973"}]
1220633 January 22, 2021 - 17:41:32 UTC 36.87836 -119.76116 Fort Washington 191 [{"latitude": "36.87807", "longitude": "-119.7587"}, {"latitude": "36.87807", "longitude": "-119.75705"}, {"latitude": "36.87911", "longitude": "-119.7573"}, {"latitude": "36.87911", "longitude": "-119.75878"}, {"latitude": "36.87911", "longitude": "-119.75972"}, {"latitude": "36.87807", "longitude": "-119.7605"}]
1253261 February 12, 2021 - 00:45:51 UTC 36.87828 -119.76514 Fort Washington 191 []

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
);