115 rows where snapshot = 9059

View and edit SQL

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1575591039:730821 730821 730821 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:55:35 UTC December 06, 2019 - 01:30:00 UTC December 06, 2019 - 01:30:00 UTC 1 0 37.93048 -121.25876 Stockton 78 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730822 730822 730822 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:59:27 UTC     1 1 40.98328 -124.10317 McKinleyville 333 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730824 730824 730824 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:49:12 UTC December 06, 2019 - 03:00:00 UTC December 06, 2019 - 03:00:00 UTC 1 0 38.79484 -120.14943 Kyburz 574 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730825 730825 730825 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:56:36 UTC December 06, 2019 - 03:00:00 UTC December 06, 2019 - 03:00:00 UTC 1 1 37.88808 -122.10133 Lafayette 155 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730826 730826 730826 2019-12-05 16:10:39-08:00 9059 December 06, 2019 - 00:05:39 UTC December 06, 2019 - 03:00:00 UTC December 06, 2019 - 03:00:00 UTC 1 0 37.66362 -122.06256 Hayward 170 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575591039:730827 730827 730827 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:52:02 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 1 0 37.5483 -122.2892 San Mateo 29 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575591039:730829 730829 730829 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:52:50 UTC December 06, 2019 - 03:00:00 UTC December 06, 2019 - 03:00:00 UTC 1 0 35.39078 -118.98644 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730830 730830 730830 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:55:02 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 0 37.3928 -122.26362 Woodside 130 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730831 730831 730831 2019-12-05 16:10:39-08:00 9059 December 05, 2019 - 23:59:23 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 0 38.0545 -122.15951 Benicia 748 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730832 730832 730832 2019-12-05 16:10:39-08:00 9059 December 06, 2019 - 00:02:18 UTC December 06, 2019 - 03:00:00 UTC December 06, 2019 - 03:00:00 UTC 1 1 37.28769 -121.92266 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730833 730833 730833 2019-12-05 16:10:39-08:00 9059 December 06, 2019 - 00:02:00 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 37.30837 -121.971 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730834 730834 730834 2019-12-05 16:10:39-08:00 9059 December 06, 2019 - 00:03:46 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 37.89645 -122.27858 Berkeley 47 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730836 730836 730836 2019-12-05 16:10:39-08:00 9059 December 06, 2019 - 00:05:10 UTC December 06, 2019 - 03:15:00 UTC December 06, 2019 - 03:15:00 UTC 1 1 38.78314 -120.79476 Placerville 19 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730838 730838 730838 2019-12-05 16:10:39-08:00 9059 December 06, 2019 - 00:06:05 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 37.80864 -122.23765 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575591039:730839 730839 730839 2019-12-05 16:10:39-08:00 9059 December 06, 2019 - 00:06:08 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 37.95933 -122.3678 North Richmond 737 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1

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