outage_snapshots

31 rows where snapshot = 18

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569923412:629455 629455 629455 2019-10-01 02:50:12-07:00 18 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
1569923412:629544 629544 629544 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 09:31:33 UTC October 01, 2019 - 15:30:00 UTC   31 0 37.25649 -121.94472 San Jose 26 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
1569923412:629993 629993 629993 2019-10-01 02:50:12-07:00 18 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
1569923412:630055 630055 630055 2019-10-01 02:50:12-07:00 18 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
1569923412:630855 630855 630855 2019-10-01 02:50:12-07:00 18 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
1569923412:631014 631014 631014 2019-10-01 02:50:12-07:00 18 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
1569923412:631133 631133 631133 2019-10-01 02:50:12-07:00 18 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
1569923412:631354 631354 631354 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 05:15:09 UTC October 01, 2019 - 11: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
1569923412:631639 631639 631639 2019-10-01 02:50:12-07:00 18 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 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
1569923412:632153 632153 632153 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 Walnut Creek 33 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
1569923412:632414 632414 632414 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 08:34:36 UTC October 01, 2019 - 15:00:00 UTC   1 0 38.31483 -122.33439 Napa 15 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
1569923412:632633 632633 632633 2019-10-01 02:50:12-07:00 18 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
1569923412:632634 632634 632634 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 03:20:04 UTC October 01, 2019 - 13:00:00 UTC   1 0 40.18335 -122.2206 Red Bluff 20 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
1569923412:633373 633373 633373 2019-10-01 02:50:12-07:00 18 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
1569923412:633394 633394 633394 2019-10-01 02:50:12-07:00 18 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
1569923412:633433 633433 633433 2019-10-01 02:50:12-07:00 18 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
1569923412:633435 633435 633435 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 09:31:13 UTC October 01, 2019 - 16:00:00 UTC   13 0 36.81337 -120.25931 Firebaugh 8 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
1569923412:633444 633444 633444 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 05:41:06 UTC October 01, 2019 - 12:00:00 UTC   5 0 37.04293 -122.09002 Felton 7 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
1569923412:633463 633463 633463 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 04:36:17 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
1569923412:633467 633467 633467 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 04:59:01 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
1569923412:633470 633470 633470 2019-10-01 02:50:12-07:00 18 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
1569923412:633477 633477 633477 2019-10-01 02:50:12-07:00 18 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
1569923412:633478 633478 633478 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 Merced 13 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E assessment crew is en route to the outage. 5
1569923412:633479 633479 633479 2019-10-01 02:50:12-07:00 18 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
1569923412:633480 633480 633480 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 08:17:01 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
1569923412:633481 633481 633481 2019-10-01 02:50:12-07:00 18 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
1569923412:633483 633483 633483 2019-10-01 02:50:12-07:00 18 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
1569923412:633484 633484 633484 2019-10-01 02:50:12-07:00 18 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
1569923412:633485 633485 633485 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 Valley Springs 32 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
1569923412:633488 633488 633488 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 08:20:37 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10: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 assessing the cause at the outage location. 4
1569923412:633505 633505 633505 2019-10-01 02:50:12-07:00 18 October 01, 2019 - 09:40:01 UTC October 01, 2019 - 11:30:00 UTC October 01, 2019 - 11:30:00 UTC 1 0 37.66473 -121.92102 Pleasanton 36 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4

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 4152.036ms · About: About this site