outages
14 rows where regionName = 195
This data as json, CSV (advanced)
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
CREATE TABLE [outages] ( [id] INTEGER PRIMARY KEY, [outageStartTime] INTEGER, [latitude] TEXT, [longitude] TEXT, [regionName] INTEGER REFERENCES [regionName]([id]), [outageDevices] TEXT );