3,506,563 rows where crewCurrentStatus = 1

View and edit SQL

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569913215:631074 631074 631074 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:29:18 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.29857 -121.97725 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569913215:631133 631133 631133 2019-10-01 00:00:15-07:00 1 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
1569913215:631354 631354 631354 2019-10-01 00:00:15-07:00 1 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
1569913215:633233 633233 633233 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569913215:633477 633477 633477 2019-10-01 00:00:15-07:00 1 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
1569913215:633479 633479 633479 2019-10-01 00:00:15-07:00 1 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
1569913215:633484 633484 633484 2019-10-01 00:00:15-07:00 1 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
1569913215:633488 633488 633488 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:55:32 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 27 0 35.99202 -119.57146 Kettleman City 10 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569913215:633492 633492 633492 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:49:17 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 274 0 37.09211 -119.55301 Auberry 1 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569913838:631074 631074 631074 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:29:18 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.29857 -121.97725 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569913838:631133 631133 631133 2019-10-01 00:10:38-07:00 2 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
1569913838:631354 631354 631354 2019-10-01 00:10:38-07:00 2 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
1569913838:633233 633233 633233 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569913838:633477 633477 633477 2019-10-01 00:10:38-07:00 2 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
1569913838:633479 633479 633479 2019-10-01 00:10:38-07:00 2 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
1569913838:633484 633484 633484 2019-10-01 00:10:38-07:00 2 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
1569913838:633492 633492 633492 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 07:04:42 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 0 0 37.09211 -119.55301 Auberry 1 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569913838:633503 633503 633503 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 07:02:31 UTC October 01, 2019 - 09:45:00 UTC October 01, 2019 - 09:45:00 UTC 1 1 36.76072 -119.7904 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569914414:631133 631133 631133 2019-10-01 00:20:14-07:00 3 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
1569914414:631354 631354 631354 2019-10-01 00:20:14-07:00 3 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
1569914414:633233 633233 633233 2019-10-01 00:20:14-07:00 3 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569914414:633477 633477 633477 2019-10-01 00:20:14-07:00 3 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
1569914414:633479 633479 633479 2019-10-01 00:20:14-07:00 3 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
1569914414:633484 633484 633484 2019-10-01 00:20:14-07:00 3 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
1569914414:633492 633492 633492 2019-10-01 00:20:14-07:00 3 October 01, 2019 - 07:04:42 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 0 0 37.09211 -119.55301 Auberry 1 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569914414:633504 633504 633504 2019-10-01 00:20:14-07:00 3 October 01, 2019 - 07:07:05 UTC October 01, 2019 - 10:00:00 UTC October 01, 2019 - 10:00:00 UTC 1 0 37.25754 -120.4345 Merced 13 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569914414:633505 633505 633505 2019-10-01 00:20:14-07:00 3 October 01, 2019 - 07:15:23 UTC October 01, 2019 - 11:30:00 UTC October 01, 2019 - 11:30:00 UTC 1 0 37.66473 -121.92102 Pleasanton 36 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569915019:631133 631133 631133 2019-10-01 00:30:19-07:00 4 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
1569915019:631354 631354 631354 2019-10-01 00:30:19-07:00 4 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
1569915019:633233 633233 633233 2019-10-01 00:30:19-07:00 4 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569915019:633477 633477 633477 2019-10-01 00:30:19-07:00 4 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
1569915019:633479 633479 633479 2019-10-01 00:30:19-07:00 4 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
1569915019:633484 633484 633484 2019-10-01 00:30:19-07:00 4 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
1569915019:633492 633492 633492 2019-10-01 00:30:19-07:00 4 October 01, 2019 - 07:04:42 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 0 0 37.09211 -119.55301 Auberry 1 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569915019:633505 633505 633505 2019-10-01 00:30:19-07:00 4 October 01, 2019 - 07:15:23 UTC October 01, 2019 - 11:30:00 UTC October 01, 2019 - 11:30:00 UTC 1 0 37.66473 -121.92102 Pleasanton 36 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569915624:631133 631133 631133 2019-10-01 00:40:24-07:00 5 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
1569915624:631354 631354 631354 2019-10-01 00:40:24-07:00 5 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
1569915624:633233 633233 633233 2019-10-01 00:40:24-07:00 5 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569915624:633477 633477 633477 2019-10-01 00:40:24-07:00 5 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
1569915624:633479 633479 633479 2019-10-01 00:40:24-07:00 5 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
1569915624:633484 633484 633484 2019-10-01 00:40:24-07:00 5 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
1569915624:633505 633505 633505 2019-10-01 00:40:24-07:00 5 October 01, 2019 - 07:15:23 UTC October 01, 2019 - 11:30:00 UTC October 01, 2019 - 11:30:00 UTC 1 0 37.66473 -121.92102 Pleasanton 36 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569915624:633506 633506 633506 2019-10-01 00:40:24-07:00 5 October 01, 2019 - 07:30:28 UTC October 01, 2019 - 10:45:00 UTC October 01, 2019 - 10:45:00 UTC 1 0 37.95652 -122.11536 Martinez 37 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569915624:633507 633507 633507 2019-10-01 00:40:24-07:00 5 October 01, 2019 - 07:30:38 UTC October 01, 2019 - 10:45:00 UTC October 01, 2019 - 10:45:00 UTC 1 0 37.95491 -122.11647 Martinez 37 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569916231:631133 631133 631133 2019-10-01 00:50:31-07:00 6 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
1569916231:631354 631354 631354 2019-10-01 00:50:31-07:00 6 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
1569916231:633233 633233 633233 2019-10-01 00:50:31-07:00 6 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569916231:633477 633477 633477 2019-10-01 00:50:31-07:00 6 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
1569916231:633479 633479 633479 2019-10-01 00:50:31-07:00 6 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
1569916231:633484 633484 633484 2019-10-01 00:50:31-07:00 6 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
1569916231:633505 633505 633505 2019-10-01 00:50:31-07:00 6 October 01, 2019 - 07:15:23 UTC October 01, 2019 - 11:30:00 UTC October 01, 2019 - 11:30:00 UTC 1 0 37.66473 -121.92102 Pleasanton 36 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569916231:633506 633506 633506 2019-10-01 00:50:31-07:00 6 October 01, 2019 - 07:43:51 UTC October 01, 2019 - 10:45:00 UTC October 01, 2019 - 10:45:00 UTC 1 0 37.95652 -122.11536 Martinez 37 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569916231:633507 633507 633507 2019-10-01 00:50:31-07:00 6 October 01, 2019 - 07:40:34 UTC October 01, 2019 - 10:45:00 UTC October 01, 2019 - 10:45:00 UTC 1 0 37.95491 -122.11647 Martinez 37 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569916815:631133 631133 631133 2019-10-01 01:00:15-07:00 7 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
1569916815:631354 631354 631354 2019-10-01 01:00:15-07:00 7 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
1569916815:633477 633477 633477 2019-10-01 01:00:15-07:00 7 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
1569916815:633479 633479 633479 2019-10-01 01:00:15-07:00 7 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
1569916815:633484 633484 633484 2019-10-01 01:00:15-07:00 7 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
1569916815:633508 633508 633508 2019-10-01 01:00:15-07:00 7 October 01, 2019 - 07:49:17 UTC October 01, 2019 - 11:15:00 UTC October 01, 2019 - 11:15:00 UTC 4 0 37.77156 -121.42335 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569917417:631133 631133 631133 2019-10-01 01:10:17-07:00 8 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
1569917417:631354 631354 631354 2019-10-01 01:10:17-07:00 8 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
1569917417:633477 633477 633477 2019-10-01 01:10:17-07:00 8 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
1569917417:633479 633479 633479 2019-10-01 01:10:17-07:00 8 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
1569917417:633484 633484 633484 2019-10-01 01:10:17-07:00 8 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
1569917417:633508 633508 633508 2019-10-01 01:10:17-07:00 8 October 01, 2019 - 07:59:36 UTC October 01, 2019 - 11:15:00 UTC October 01, 2019 - 11:15:00 UTC 4 0 37.77156 -121.42335 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569917417:633509 633509 633509 2019-10-01 01:10:17-07:00 8 October 01, 2019 - 07:59:38 UTC October 01, 2019 - 11:15:00 UTC October 01, 2019 - 11:15:00 UTC 11 0 37.95498 -122.11657 Martinez 37 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569917417:633510 633510 633510 2019-10-01 01:10:17-07:00 8 October 01, 2019 - 08:00:21 UTC October 01, 2019 - 11:00:00 UTC October 01, 2019 - 11:00:00 UTC 21 0 37.95855 -122.11232 Martinez 37 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569918012:631133 631133 631133 2019-10-01 01:20:12-07:00 9 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
1569918012:631354 631354 631354 2019-10-01 01:20:12-07:00 9 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
1569918012:633477 633477 633477 2019-10-01 01:20:12-07:00 9 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
1569918012:633479 633479 633479 2019-10-01 01:20:12-07:00 9 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
1569918012:633484 633484 633484 2019-10-01 01:20:12-07:00 9 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
1569918645:631133 631133 631133 2019-10-01 01:30:45-07:00 10 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
1569918645:631354 631354 631354 2019-10-01 01:30:45-07:00 10 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
1569918645:633477 633477 633477 2019-10-01 01:30:45-07:00 10 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
1569918645:633478 633478 633478 2019-10-01 01:30:45-07:00 10 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 has assigned a crew to assess the outage. 1
1569918645:633479 633479 633479 2019-10-01 01:30:45-07:00 10 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
1569918645:633484 633484 633484 2019-10-01 01:30:45-07:00 10 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
1569919223:631133 631133 631133 2019-10-01 01:40:23-07:00 11 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
1569919223:631354 631354 631354 2019-10-01 01:40:23-07:00 11 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
1569919223:633477 633477 633477 2019-10-01 01:40:23-07:00 11 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
1569919223:633478 633478 633478 2019-10-01 01:40:23-07:00 11 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 has assigned a crew to assess the outage. 1
1569919223:633479 633479 633479 2019-10-01 01:40:23-07:00 11 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
1569919223:633484 633484 633484 2019-10-01 01:40:23-07:00 11 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
1569919823:631133 631133 631133 2019-10-01 01:50:23-07:00 12 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
1569919823:631354 631354 631354 2019-10-01 01:50:23-07:00 12 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
1569919823:633477 633477 633477 2019-10-01 01:50:23-07:00 12 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
1569919823:633478 633478 633478 2019-10-01 01:50:23-07:00 12 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 has assigned a crew to assess the outage. 1
1569919823:633479 633479 633479 2019-10-01 01:50:23-07:00 12 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
1569919823:633484 633484 633484 2019-10-01 01:50:23-07:00 12 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
1569920421:631133 631133 631133 2019-10-01 02:00:21-07:00 13 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
1569920421:631354 631354 631354 2019-10-01 02:00:21-07:00 13 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
1569920421:633477 633477 633477 2019-10-01 02:00:21-07:00 13 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
1569920421:633479 633479 633479 2019-10-01 02:00:21-07:00 13 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
1569920421:633484 633484 633484 2019-10-01 02:00:21-07:00 13 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
1569921023:631133 631133 631133 2019-10-01 02:10:23-07:00 14 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
1569921023:631354 631354 631354 2019-10-01 02:10:23-07:00 14 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
1569921023:633477 633477 633477 2019-10-01 02:10:23-07:00 14 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
1569921023:633479 633479 633479 2019-10-01 02:10:23-07:00 14 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
1569921023:633484 633484 633484 2019-10-01 02:10:23-07:00 14 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

Next page

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