outage_snapshots

59 rows where outage = 638393

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570054212:638393 638393 638393 2019-10-02 15:10:12-07:00 227 October 02, 2019 - 22:01:00 UTC October 03, 2019 - 01:00:00 UTC October 03, 2019 - 01:00:00 UTC 60 0 37.91811 -122.03487 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570054822:638393 638393 638393 2019-10-02 15:20:22-07:00 228 October 02, 2019 - 22:09:16 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570055428:638393 638393 638393 2019-10-02 15:30:28-07:00 229 October 02, 2019 - 22:09:16 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570056020:638393 638393 638393 2019-10-02 15:40:20-07:00 230 October 02, 2019 - 22:23:15 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570056622:638393 638393 638393 2019-10-02 15:50:22-07:00 231 October 02, 2019 - 22:37:10 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570057223:638393 638393 638393 2019-10-02 16:00:23-07:00 232 October 02, 2019 - 22:37:10 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570057821:638393 638393 638393 2019-10-02 16:10:21-07:00 233 October 02, 2019 - 22:37:10 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570058417:638393 638393 638393 2019-10-02 16:20:17-07:00 234 October 02, 2019 - 22:37:10 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570059023:638393 638393 638393 2019-10-02 16:30:23-07:00 235 October 02, 2019 - 22:37:10 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570059614:638393 638393 638393 2019-10-02 16:40:14-07:00 236 October 02, 2019 - 22:37:10 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570060219:638393 638393 638393 2019-10-02 16:50:19-07:00 237 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570060834:638393 638393 638393 2019-10-02 17:00:34-07:00 238 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570061433:638393 638393 638393 2019-10-02 17:10:33-07:00 239 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570062022:638393 638393 638393 2019-10-02 17:20:22-07:00 240 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570062631:638393 638393 638393 2019-10-02 17:30:31-07:00 241 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570063216:638393 638393 638393 2019-10-02 17:40:16-07:00 242 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570063816:638393 638393 638393 2019-10-02 17:50:16-07:00 243 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570064430:638393 638393 638393 2019-10-02 18:00:30-07:00 244 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570065022:638393 638393 638393 2019-10-02 18:10:22-07:00 245 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570065616:638393 638393 638393 2019-10-02 18:20:16-07:00 246 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570066217:638393 638393 638393 2019-10-02 18:30:17-07:00 247 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570066840:638393 638393 638393 2019-10-02 18:40:40-07:00 248 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570067419:638393 638393 638393 2019-10-02 18:50:19-07:00 249 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570068016:638393 638393 638393 2019-10-02 19:00:16-07:00 250 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570068627:638393 638393 638393 2019-10-02 19:10:27-07:00 251 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570069252:638393 638393 638393 2019-10-02 19:20:52-07:00 252 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570069819:638393 638393 638393 2019-10-02 19:30:19-07:00 253 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570070412:638393 638393 638393 2019-10-02 19:40:12-07:00 254 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570071019:638393 638393 638393 2019-10-02 19:50:19-07:00 255 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570071613:638393 638393 638393 2019-10-02 20:00:13-07:00 256 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570072225:638393 638393 638393 2019-10-02 20:10:25-07:00 257 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570072820:638393 638393 638393 2019-10-02 20:20:20-07:00 258 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570073421:638393 638393 638393 2019-10-02 20:30:21-07:00 259 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570074027:638393 638393 638393 2019-10-02 20:40:27-07:00 260 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570074639:638393 638393 638393 2019-10-02 20:50:39-07:00 261 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570075224:638393 638393 638393 2019-10-02 21:00:24-07:00 262 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570075827:638393 638393 638393 2019-10-02 21:10:27-07:00 263 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570076416:638393 638393 638393 2019-10-02 21:20:16-07:00 264 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570077025:638393 638393 638393 2019-10-02 21:30:25-07:00 265 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570077621:638393 638393 638393 2019-10-02 21:40:21-07:00 266 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570078212:638393 638393 638393 2019-10-02 21:50:12-07:00 267 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570078823:638393 638393 638393 2019-10-02 22:00:23-07:00 268 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570079436:638393 638393 638393 2019-10-02 22:10:36-07:00 269 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570080020:638393 638393 638393 2019-10-02 22:20:20-07:00 270 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570080625:638393 638393 638393 2019-10-02 22:30:25-07:00 271 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570081242:638393 638393 638393 2019-10-02 22:40:42-07:00 272 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570081825:638393 638393 638393 2019-10-02 22:50:25-07:00 273 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570082433:638393 638393 638393 2019-10-02 23:00:33-07:00 274 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570083018:638393 638393 638393 2019-10-02 23:10:18-07:00 275 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570083680:638393 638393 638393 2019-10-02 23:21:20-07:00 276 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570084233:638393 638393 638393 2019-10-02 23:30:33-07:00 277 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570084838:638393 638393 638393 2019-10-02 23:40:38-07:00 278 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570085416:638393 638393 638393 2019-10-02 23:50:16-07:00 279 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570086026:638393 638393 638393 2019-10-03 00:00:26-07:00 280 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570086627:638393 638393 638393 2019-10-03 00:10:27-07:00 281 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570087213:638393 638393 638393 2019-10-03 00:20:13-07:00 282 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570087824:638393 638393 638393 2019-10-03 00:30:24-07:00 283 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570088421:638393 638393 638393 2019-10-03 00:40:21-07:00 284 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570089020:638393 638393 638393 2019-10-03 00:50:20-07:00 285 October 02, 2019 - 23:36:18 UTC October 03, 2019 - 09:00:00 UTC   60 0 37.91811 -122.03487 Walnut Creek 33 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2

Advanced export

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

CSV options:

CREATE TABLE [outage_snapshots] (
   [id] TEXT PRIMARY KEY,
   [outage] INTEGER REFERENCES [outages]([id]),
   [snapshot] INTEGER REFERENCES [snapshots]([id]),
   [lastUpdateTime] INTEGER,
   [currentEtor] INTEGER,
   [autoEtor] INTEGER,
   [estCustAffected] INTEGER,
   [hazardFlag] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [cause] INTEGER REFERENCES [cause]([id]),
   [crewCurrentStatus] INTEGER REFERENCES [crewCurrentStatus]([id])
)
Powered by Datasette · Query took 3953.357ms · About: About this site