30 rows where snapshot = 979

View and edit SQL

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570510820:645732 645732 645732 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 01:50:17 UTC     6 1 37.57056 -119.94187 Midpines 211 Unknown - PG&E will be assessing the cause. 1 PG&E is assessing the cause at the outage location. 4
1570510820:645866 645866 645866 2019-10-07 22:00:20-07:00 979 October 07, 2019 - 21:41:45 UTC October 08, 2019 - 03:56:00 UTC   1 0 37.6971 -122.13217 San Leandro 27 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:645873 645873 645873 2019-10-07 22:00:20-07:00 979 October 07, 2019 - 15:46:59 UTC October 17, 2019 - 20:00:00 UTC   2 0 38.44571 -121.7909 Dixon 45 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570510820:646029 646029 646029 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:31:14 UTC October 08, 2019 - 06:00:00 UTC   1 0 36.91323 -121.83982 La Selva Beach 421 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:646413 646413 646413 2019-10-07 22:00:20-07:00 979 October 07, 2019 - 23:49:19 UTC October 08, 2019 - 01:00:00 UTC October 08, 2019 - 01:00:00 UTC 1 0 34.96049 -120.42321 Santa Maria 52 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570510820:646776 646776 646776 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:25:31 UTC October 08, 2019 - 06:48:00 UTC   1 0 37.99292 -121.18468 Stockton 78 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:646828 646828 646828 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 03:46:18 UTC October 08, 2019 - 19:00:00 UTC   1 0 36.61614 -121.91931 Pacific Grove 247 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570510820:646864 646864 646864 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 01:38:46 UTC October 08, 2019 - 06:59:00 UTC   0 0 37.75711 -122.38679 San Francisco 25 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570510820:646893 646893 646893 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:25:43 UTC October 08, 2019 - 06:48:00 UTC   1 1 37.94266 -121.30742 Stockton 78 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570510820:646904 646904 646904 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:48:29 UTC October 08, 2019 - 06:48:00 UTC   1 1 37.76384 -122.21052 Oakland 16 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570510820:646921 646921 646921 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:35:56 UTC October 08, 2019 - 06:35:00 UTC   1 1 36.97749 -121.9476 Capitola 253 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570510820:646923 646923 646923 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 02:26:46 UTC October 08, 2019 - 06:26:00 UTC   1 1 38.02247 -121.3291 Stockton 78 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:646956 646956 646956 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 03:43:24 UTC October 08, 2019 - 09:00:00 UTC   1 1 38.01967 -121.23072 Stockton 78 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
1570510820:646960 646960 646960 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 03:13:17 UTC October 08, 2019 - 09:00:00 UTC   157 2 37.71084 -120.67422 Waterford 554 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
1570510820:646973 646973 646973 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:48:59 UTC October 08, 2019 - 06:57:00 UTC   1 1 37.97188 -121.30558 Stockton 78 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:646975 646975 646975 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:35:31 UTC     56 0 37.57056 -119.94187 Midpines 211 Unknown - PG&E will be assessing the cause. 1 PG&E is unable to access the affected equipment. 6
1570510820:646978 646978 646978 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 03:33:28 UTC October 08, 2019 - 06:33:00 UTC   1 0 37.77052 -122.19174 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:646979 646979 646979 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:33:34 UTC October 08, 2019 - 13:00:00 UTC   41 3 36.08674 -119.55857 Corcoran 317 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
1570510820:646980 646980 646980 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 02:03:53 UTC October 08, 2019 - 05:45:00 UTC October 08, 2019 - 05:45:00 UTC 12 0 36.95666 -121.87627 Rio del Mar 490 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:646983 646983 646983 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 03:18:07 UTC October 08, 2019 - 09:00:00 UTC   1 1 37.39097 -122.10831 Los Altos 151 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
1570510820:646989 646989 646989 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 03:12:32 UTC October 08, 2019 - 05:45:00 UTC October 08, 2019 - 05:45:00 UTC 1 0 38.2239 -122.45563 Sonoma 324 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570510820:646991 646991 646991 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:01:54 UTC October 08, 2019 - 05:45:00 UTC October 08, 2019 - 05:45:00 UTC 28 0 40.98366 -124.09421 McKinleyville 333 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570510820:646996 646996 646996 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 02:55:01 UTC October 08, 2019 - 05:54:00 UTC   12 0 37.23704 -121.94383 Los Gatos 121 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E repair crew is on-site working to restore power. 2
1570510820:647010 647010 647010 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:17:50 UTC October 08, 2019 - 06:30:00 UTC October 08, 2019 - 06:30:00 UTC 1 1 39.19183 -120.99945 Grass Valley 113 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570510820:647013 647013 647013 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:25:42 UTC October 08, 2019 - 12:00:00 UTC   75 0 37.7842 -122.22433 Oakland 16 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570510820:647015 647015 647015 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:10:33 UTC October 08, 2019 - 07:15:00 UTC October 08, 2019 - 07:15:00 UTC 1 1 38.80102 -122.99083 Cloverdale 81 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:647016 647016 647016 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570510820:647017 647017 647017 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:15:51 UTC October 08, 2019 - 08:00:00 UTC October 08, 2019 - 08:00:00 UTC 1 0 38.3411 -123.05377 Bodega Bay 107 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:647020 647020 647020 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:43:35 UTC October 08, 2019 - 08:00:00 UTC October 08, 2019 - 08:00:00 UTC 1 0 38.08795 -121.2774 Lodi 364 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570510820:647023 647023 647023 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:46:54 UTC October 08, 2019 - 08:15:00 UTC October 08, 2019 - 08:15:00 UTC 7 1 37.75632 -121.24298 Manteca 210 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5

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