outage_snapshots

32 rows where snapshot = 45

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569939629:629455 629455 629455 2019-10-01 07:20:29-07:00 45 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
1569939629:629993 629993 629993 2019-10-01 07:20:29-07:00 45 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
1569939629:630055 630055 630055 2019-10-01 07:20:29-07:00 45 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
1569939629:631014 631014 631014 2019-10-01 07:20:29-07:00 45 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
1569939629:631133 631133 631133 2019-10-01 07:20:29-07:00 45 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
1569939629:632633 632633 632633 2019-10-01 07:20:29-07:00 45 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
1569939629:633373 633373 633373 2019-10-01 07:20:29-07:00 45 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
1569939629:633433 633433 633433 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:03:16 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
1569939629:633481 633481 633481 2019-10-01 07:20:29-07:00 45 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
1569939629:633488 633488 633488 2019-10-01 07:20:29-07:00 45 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
1569939629:633505 633505 633505 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:15:23 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
1569939629:633516 633516 633516 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:59:21 UTC October 01, 2019 - 22:59:00 UTC   41 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
1569939629:633524 633524 633524 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:06:37 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1569939629:633530 633530 633530 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:43:05 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.10504 -119.59209 Friant 44 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569939629:633532 633532 633532 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:10:18 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 assessment crew is en route to the outage. 5
1569939629:633538 633538 633538 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 12:46:27 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
1569939629:633540 633540 633540 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 12:57:48 UTC October 01, 2019 - 21:00:00 UTC   19 0 35.58976 -120.83334 Paso Robles 48 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
1569939629:633541 633541 633541 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:50:08 UTC October 01, 2019 - 16:00:00 UTC October 01, 2019 - 16:00:00 UTC 36 0 37.86079 -122.29415 Berkeley 47 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569939629:633542 633542 633542 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:01:30 UTC October 01, 2019 - 16:15:00 UTC October 01, 2019 - 16:15:00 UTC 14 0 36.99019 -121.73674 Watsonville 49 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569939629:633543 633543 633543 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:36:59 UTC     1 1 37.75363 -122.50554 San Francisco 25 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569939629:633545 633545 633545 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:07:00 UTC October 01, 2019 - 21:30:00 UTC   4 0 35.64097 -120.84891 Paso Robles 48 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
1569939629:633546 633546 633546 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:45:56 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569939629:633547 633547 633547 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:49:00 UTC October 01, 2019 - 23:00:00 UTC   4 0 41.17032 -121.68866 Burney 50 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
1569939629:633548 633548 633548 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:57:58 UTC October 01, 2019 - 17:45:00 UTC October 01, 2019 - 17:45:00 UTC 1 0 34.93489 -120.45556 Santa Maria 52 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569939629:633549 633549 633549 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:43:48 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 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
1569939629:633550 633550 633550 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:51:02 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13872 -120.12345 Huron 51 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
1569939629:633551 633551 633551 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:49:28 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13871 -120.12345 Huron 51 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
1569939629:633552 633552 633552 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 13:50:22 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13868 -120.12345 Huron 51 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
1569939629:633554 633554 633554 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:14:09 UTC October 01, 2019 - 17:45:00 UTC October 01, 2019 - 17:45:00 UTC 54 0 40.54673 -122.23841 Palo Cedro 54 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569939629:633558 633558 633558 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:11:49 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 8 0 37.92406 -121.912 Clayton 53 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569939629:633559 633559 633559 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:07:05 UTC October 01, 2019 - 15:30:00 UTC October 01, 2019 - 15:30:00 UTC 1 0 37.61449 -122.40357 San Bruno 55 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569939629:633560 633560 633560 2019-10-01 07:20:29-07:00 45 October 01, 2019 - 14:14:03 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 40.38603 -122.26401 Cottonwood 56 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 4151.525ms · About: About this site