outages
10 rows where regionName = 191
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
CREATE TABLE [outages] ( [id] INTEGER PRIMARY KEY, [outageStartTime] INTEGER, [latitude] TEXT, [longitude] TEXT, [regionName] INTEGER REFERENCES [regionName]([id]), [outageDevices] TEXT );