14 rows where regionName = 195

View and edit SQL

Suggested facets: latitude, longitude

id ▼ outageStartTime latitude longitude regionName outageDevices
634833 October 01, 2019 - 20:55:15 UTC 35.28337 -119.63854 Fellows 195 []
677010 October 22, 2019 - 21:09:59 UTC 35.2309 -119.5979 Fellows 195 []
677015 October 22, 2019 - 21:04:00 UTC 35.22419 -119.59838 Fellows 195 [{"latitude": "35.18971", "longitude": "-119.76432"}, {"latitude": "35.2309", "longitude": "-119.5979"}, {"latitude": "35.23845", "longitude": "-119.58936"}, {"latitude": "35.24246", "longitude": "-119.62359"}, {"latitude": "35.19041", "longitude": "-119.86507"}]
708080 November 16, 2019 - 14:12:16 UTC 35.17968 -119.54281 Fellows 195 [{"latitude": "35.17253", "longitude": "-119.54308"}, {"latitude": "35.17511", "longitude": "-119.53997"}, {"latitude": "35.17647", "longitude": "-119.53909"}, {"latitude": "35.17921", "longitude": "-119.54121"}, {"latitude": "35.17964", "longitude": "-119.54281"}, {"latitude": "35.17899", "longitude": "-119.54479"}, {"latitude": "35.1769", "longitude": "-119.54564"}]
736227 December 11, 2019 - 16:47:00 UTC 35.23878 -119.62828 Fellows 195 [{"latitude": "35.18971", "longitude": "-119.76432"}, {"latitude": "35.23263", "longitude": "-119.66027"}, {"latitude": "35.23255", "longitude": "-119.6646"}, {"latitude": "35.19041", "longitude": "-119.86507"}]
790670 February 14, 2020 - 02:20:30 UTC 35.17968 -119.54281 Fellows 195 [{"latitude": "35.17253", "longitude": "-119.54308"}, {"latitude": "35.17511", "longitude": "-119.53997"}, {"latitude": "35.17647", "longitude": "-119.53909"}, {"latitude": "35.17921", "longitude": "-119.54121"}, {"latitude": "35.17964", "longitude": "-119.54281"}, {"latitude": "35.17899", "longitude": "-119.54479"}, {"latitude": "35.1769", "longitude": "-119.54564"}]
790742 February 14, 2020 - 08:53:51 UTC 35.1778 -119.54032 Fellows 195 []
1129933 October 27, 2020 - 18:26:02 UTC 35.17287 -119.52908 Fellows 195 []
1191409 December 16, 2020 - 21:59:46 UTC 35.20659 -119.48545 Fellows 195 []
1197026 December 22, 2020 - 16:30:32 UTC 35.1943 -119.54194 Fellows 195 []
1211616 January 16, 2021 - 21:02:35 UTC 35.19608 -119.56741 Fellows 195 []
1234899 January 27, 2021 - 18:38:18 UTC 35.27892 -119.56704 Fellows 195 []
1235234 January 27, 2021 - 19:35:58 UTC 35.17891 -119.54316 Fellows 195 []
1258133 February 20, 2021 - 00:05:41 UTC 35.28337 -119.63854 Fellows 195 []

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