outage_snapshots

27 rows where snapshot = 30

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569930614:629455 629455 629455 2019-10-01 04:50:14-07:00 30 September 30, 2019 - 19:29:15 UTC October 02, 2019 - 05:00:00 UTC   1 0 40.55785 -124.14553 Fortuna 9 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
1569930614:629993 629993 629993 2019-10-01 04:50:14-07:00 30 September 30, 2019 - 16:05:44 UTC October 01, 2019 - 00:00:00 UTC   1 0 38.50277 -122.71038 Santa Rosa 30 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
1569930614:630055 630055 630055 2019-10-01 04:50:14-07:00 30 September 30, 2019 - 15:29:50 UTC October 02, 2019 - 23:00:00 UTC   1 0 38.12243 -121.83043 Rio Vista 21 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
1569930614:630855 630855 630855 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 02:50:34 UTC October 01, 2019 - 00:00:00 UTC   4 0 37.73454 -122.13937 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
1569930614:631014 631014 631014 2019-10-01 04:50:14-07:00 30 September 30, 2019 - 17:04:42 UTC October 03, 2019 - 21:30:00 UTC   1 0 39.0775 -121.52568 Olivehurst 17 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is assessing the cause at the outage location. 4
1569930614:631133 631133 631133 2019-10-01 04:50:14-07:00 30 September 30, 2019 - 23:06:01 UTC September 30, 2019 - 20:45:00 UTC September 30, 2019 - 20:45:00 UTC 1 0 38.17765 -121.71222 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569930614:631354 631354 631354 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 10:31:07 UTC October 01, 2019 - 17:00:00 UTC   1 0 35.30441 -120.77233 San Luis Obispo 28 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569930614:632633 632633 632633 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 03:18:39 UTC October 02, 2019 - 01:00:00 UTC   1 1 38.37341 -121.54748 Clarksburg 5 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
1569930614:633373 633373 633373 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 05:47:15 UTC October 01, 2019 - 23:46:00 UTC   1 0 38.36723 -121.54198 Clarksburg 5 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E is sending a repair crew to the outage location. 3
1569930614:633394 633394 633394 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 08:30:21 UTC October 01, 2019 - 18:00:00 UTC   1 0 36.45004 -121.35438 Soledad 31 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
1569930614:633433 633433 633433 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 Woodland 34 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
1569930614:633463 633463 633463 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 10:08:28 UTC October 01, 2019 - 13:00:00 UTC   296 0 37.75335 -122.42778 San Francisco 25 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
1569930614:633467 633467 633467 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 10:13:53 UTC October 01, 2019 - 12:00:00 UTC   48 0 37.76364 -122.38797 San Francisco 25 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
1569930614:633470 633470 633470 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 04:37:06 UTC     97 0 37.75354 -122.42749 San Francisco 25 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is sending a repair crew to the outage location. 3
1569930614:633477 633477 633477 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 05:15:44 UTC     100 0 37.75326 -122.42691 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569930614:633479 633479 633479 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 05:04:31 UTC October 01, 2019 - 13:00:00 UTC   45 0 37.75334 -122.42578 San Francisco 25 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1569930614:633480 633480 633480 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 11:07:12 UTC October 01, 2019 - 13:16:00 UTC   1 1 37.70999 -122.17583 San Leandro 27 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
1569930614:633481 633481 633481 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 Castro Valley 4 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
1569930614:633483 633483 633483 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 San Carlos 24 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E is assessing the cause at the outage location. 4
1569930614:633484 633484 633484 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 06:04:23 UTC     1 0 37.75475 -122.42896 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569930614:633488 633488 633488 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 11:09:46 UTC October 01, 2019 - 14:15:00 UTC   27 1 35.99202 -119.57146 Kettleman City 10 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1569930614:633505 633505 633505 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 10:42:12 UTC     1 0 37.66473 -121.92102 Pleasanton 36 Unknown - PG&E will be assessing the cause. 1 PG&E is unable to access the affected equipment. 6
1569930614:633516 633516 633516 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 11:46:04 UTC October 01, 2019 - 14:00:00 UTC October 01, 2019 - 14:00:00 UTC 969 1 35.52131 -120.71256 Atascadero 40 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569930614:633518 633518 633518 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 11:31:38 UTC October 01, 2019 - 14:00:00 UTC October 01, 2019 - 14:00:00 UTC 1 1 39.73895 -121.85833 Chico 41 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569930614:633524 633524 633524 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 11:38:29 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569930614:633526 633526 633526 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 11:28:16 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29066 -121.95854 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569930614:633528 633528 633528 2019-10-01 04:50:14-07:00 30 October 01, 2019 - 11:40:22 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29 -121.9594 Campbell 43 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])
)
Powered by Datasette · Query took 4861.906ms · About: About this site