outage_snapshots

30 rows where snapshot = 36

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569934216:629455 629455 629455 2019-10-01 05:50:16-07:00 36 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
1569934216:629993 629993 629993 2019-10-01 05:50:16-07:00 36 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
1569934216:630055 630055 630055 2019-10-01 05:50:16-07:00 36 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
1569934216:630855 630855 630855 2019-10-01 05:50:16-07:00 36 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
1569934216:631014 631014 631014 2019-10-01 05:50:16-07:00 36 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
1569934216:631133 631133 631133 2019-10-01 05:50:16-07:00 36 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
1569934216:631354 631354 631354 2019-10-01 05:50:16-07:00 36 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
1569934216:632633 632633 632633 2019-10-01 05:50:16-07:00 36 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
1569934216:633373 633373 633373 2019-10-01 05:50:16-07:00 36 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
1569934216:633394 633394 633394 2019-10-01 05:50:16-07:00 36 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
1569934216:633433 633433 633433 2019-10-01 05:50:16-07:00 36 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
1569934216:633463 633463 633463 2019-10-01 05:50:16-07:00 36 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
1569934216:633467 633467 633467 2019-10-01 05:50:16-07:00 36 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
1569934216:633470 633470 633470 2019-10-01 05:50:16-07:00 36 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
1569934216:633477 633477 633477 2019-10-01 05:50:16-07:00 36 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
1569934216:633479 633479 633479 2019-10-01 05:50:16-07:00 36 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
1569934216:633481 633481 633481 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16: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
1569934216:633483 633483 633483 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:32:33 UTC October 01, 2019 - 14:30: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
1569934216:633484 633484 633484 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:37:09 UTC     20 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
1569934216:633488 633488 633488 2019-10-01 05:50:16-07:00 36 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
1569934216:633505 633505 633505 2019-10-01 05:50:16-07:00 36 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
1569934216:633516 633516 633516 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:41:25 UTC October 01, 2019 - 14:00:00 UTC October 01, 2019 - 14:00:00 UTC 176 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
1569934216:633524 633524 633524 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:45:31 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569934216:633529 633529 633529 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:28:18 UTC October 01, 2019 - 15:15:00 UTC October 01, 2019 - 15:15:00 UTC 1 0 37.33543 -121.84029 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569934216:633530 633530 633530 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:10:47 UTC October 01, 2019 - 13:45:00 UTC October 01, 2019 - 13:45:00 UTC 1 0 37.10504 -119.59209 Friant 44 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569934216:633532 633532 633532 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:27:07 UTC October 01, 2019 - 15:45:00 UTC October 01, 2019 - 15:45:00 UTC 1 1 37.79305 -122.18292 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569934216:633534 633534 633534 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:44:45 UTC October 01, 2019 - 16:00:00 UTC October 01, 2019 - 16:00:00 UTC 11 0 37.29078 -121.97536 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569934216:633535 633535 633535 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:33:42 UTC October 01, 2019 - 16:00:00 UTC October 01, 2019 - 16:00:00 UTC 1 1 38.4844 -121.78781 Dixon 45 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569934216:633537 633537 633537 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:45:44 UTC October 01, 2019 - 16:00:00 UTC October 01, 2019 - 16:00:00 UTC 1 0 37.29243 -121.96658 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569934216:633538 633538 633538 2019-10-01 05:50:16-07:00 36 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 1 0 37.95276 -121.95995 Concord 46 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])
)
Powered by Datasette · Query took 3988.594ms · About: About this site