113 rows where snapshot = 93 sorted by crewCurrentStatus

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus ▼
1569968422:634593 634593 634593 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:15:11 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 36.8781 -119.76435 Fort Washington 191 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634694 634694 634694 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:52:17 UTC October 01, 2019 - 22:45:00 UTC October 01, 2019 - 22:45:00 UTC 1 0 36.9708 -120.05688 Madera 76 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634695 634695 634695 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:14:19 UTC October 01, 2019 - 23:30:00 UTC October 01, 2019 - 23:30:00 UTC 1 0 38.04554 -121.63728 Bethel Island 66 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634753 634753 634753 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:00:11 UTC October 01, 2019 - 23:45:00 UTC October 01, 2019 - 23:45:00 UTC 1 0 36.61242 -119.89452 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634814 634814 634814 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:24:16 UTC October 02, 2019 - 00:15:00 UTC October 02, 2019 - 00:15:00 UTC 1 1 38.69436 -121.93466 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634833 634833 634833 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:58:07 UTC October 02, 2019 - 03:30:00 UTC October 02, 2019 - 03:30:00 UTC 1 0 35.28337 -119.63854 Fellows 195 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634835 634835 634835 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:41:40 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 37.81369 -121.28245 Lathrop 199 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634843 634843 634843 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:23:02 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 2 39.31515 -122.01282 Colusa 132 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1569968422:634848 634848 634848 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:10:15 UTC October 01, 2019 - 23:45:00 UTC October 01, 2019 - 23:45:00 UTC 1 0 39.14739 -121.57565 Marysville 198 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569968422:634007 634007 634007 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 20:18:55 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 1 37.34889 -122.04992 Sunnyvale 129 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634013 634013 634013 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634847 634847 634847 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:35:24 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 1 36.71806 -119.55262 Sanger 189 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634854 634854 634854 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 21:48:28 UTC October 02, 2019 - 00:00:00 UTC October 02, 2019 - 00:00:00 UTC 1 0 37.58335 -122.34946 Burlingame 203 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634858 634858 634858 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:06:22 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 37.88844 -122.2615 Berkeley 47 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634862 634862 634862 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:01:19 UTC October 01, 2019 - 23:30:00 UTC October 01, 2019 - 23:30:00 UTC 1 0 37.97076 -121.34596 Country Club 206 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634864 634864 634864 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:00:20 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 1 38.93724 -121.04828 Auburn 181 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634865 634865 634865 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:00:55 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 0 38.78533 -120.75834 Placerville 19 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:634866 634866 634866 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:04:26 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 38.44864 -121.83079 Dixon 45 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569968422:633582 633582 633582 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:14:01 UTC October 02, 2019 - 01:33:00 UTC   1 0 38.72181 -121.83119 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1569968422:634852 634852 634852 2019-10-01 15:20:22-07:00 93 October 01, 2019 - 22:05:02 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 37.97909 -122.49745 San Rafael 144 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7

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