122 rows where outage = 730267 sorted by outage

View and edit SQL

id outage ▼ snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1575622843:730267 730267 730267 2019-12-06 01:00:43-08:00 9111 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575623431:730267 730267 730267 2019-12-06 01:10:31-08:00 9112 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575624029:730267 730267 730267 2019-12-06 01:20:29-08:00 9113 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575624659:730267 730267 730267 2019-12-06 01:30:59-08:00 9114 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575625215:730267 730267 730267 2019-12-06 01:40:15-08:00 9115 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575625825:730267 730267 730267 2019-12-06 01:50:25-08:00 9116 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575626433:730267 730267 730267 2019-12-06 02:00:33-08:00 9117 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575627022:730267 730267 730267 2019-12-06 02:10:22-08:00 9118 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575627620:730267 730267 730267 2019-12-06 02:20:20-08:00 9119 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575628241:730267 730267 730267 2019-12-06 02:30:41-08:00 9120 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575628819:730267 730267 730267 2019-12-06 02:40:19-08:00 9121 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575629420:730267 730267 730267 2019-12-06 02:50:20-08:00 9122 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575630053:730267 730267 730267 2019-12-06 03:00:53-08:00 9123 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575630624:730267 730267 730267 2019-12-06 03:10:24-08:00 9124 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575631227:730267 730267 730267 2019-12-06 03:20:27-08:00 9125 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575631823:730267 730267 730267 2019-12-06 03:30:23-08:00 9126 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575632418:730267 730267 730267 2019-12-06 03:40:18-08:00 9127 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575633018:730267 730267 730267 2019-12-06 03:50:18-08:00 9128 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575633634:730267 730267 730267 2019-12-06 04:00:34-08:00 9129 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575634214:730267 730267 730267 2019-12-06 04:10:14-08:00 9130 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575634824:730267 730267 730267 2019-12-06 04:20:24-08:00 9131 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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
1575635424:730267 730267 730267 2019-12-06 04:30:24-08:00 9132 December 06, 2019 - 04:23:24 UTC December 06, 2019 - 13:00:00 UTC   55 7 35.38864 -119.00425 Bakersfield 2 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])
);
CREATE INDEX [idx_outage_snapshots_outage]
    ON [outage_snapshots] ([outage]);