outage_snapshots

4,714,351 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569913215:629455 629455 629455 2019-10-01 00:00:15-07:00 1 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
1569913215:629544 629544 629544 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 04:30:45 UTC October 01, 2019 - 10:00: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
1569913215:629993 629993 629993 2019-10-01 00:00:15-07:00 1 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
1569913215:630055 630055 630055 2019-10-01 00:00:15-07:00 1 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
1569913215:630855 630855 630855 2019-10-01 00:00:15-07:00 1 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
1569913215:631014 631014 631014 2019-10-01 00:00:15-07:00 1 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
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:631174 631174 631174 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:49:43 UTC October 01, 2019 - 09:00:00 UTC   30 0 37.84695 -122.21344 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
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:631639 631639 631639 2019-10-01 00:00:15-07:00 1 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
1569913215:631794 631794 631794 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 Riverdale 22 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
1569913215:632115 632115 632115 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:40:57 UTC October 01, 2019 - 12:00:00 UTC   1 1 37.56994 -122.31673 San Mateo 29 Our preliminary determination is that your outage was caused by a car that hit a pole. 5 PG&E repair crew is on-site working to restore power. 2
1569913215:632117 632117 632117 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:23:44 UTC October 01, 2019 - 11:00:00 UTC   8 0 35.54847 -121.08542 Cambria 3 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
1569913215:632153 632153 632153 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09: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
1569913215:632414 632414 632414 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:00:53 UTC October 01, 2019 - 09: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
1569913215:632474 632474 632474 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:22:33 UTC October 01, 2019 - 08:00:00 UTC   1 0 36.29815 -119.76184 Lemoore 11 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
1569913215:632633 632633 632633 2019-10-01 00:00:15-07:00 1 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
1569913215:632634 632634 632634 2019-10-01 00:00:15-07:00 1 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
1569913215:633157 633157 633157 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 03:40:21 UTC October 01, 2019 - 10:00:00 UTC   3 0 36.61393 -121.56663 Salinas 23 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
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:633373 633373 633373 2019-10-01 00:00:15-07:00 1 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
1569913215:633394 633394 633394 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:59:37 UTC October 01, 2019 - 09: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
1569913215:633410 633410 633410 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:51:59 UTC October 01, 2019 - 09:00:00 UTC   6 0 37.83977 -122.12694 Moraga 14 Our preliminary determination is that your outage was caused by a car that hit a pole. 5 PG&E repair crew is on-site working to restore power. 2
1569913215:633433 633433 633433 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:33: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
1569913215:633435 633435 633435 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:20:48 UTC October 01, 2019 - 10: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
1569913215:633444 633444 633444 2019-10-01 00:00:15-07:00 1 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
1569913215:633451 633451 633451 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 03:16:59 UTC October 01, 2019 - 11:00:00 UTC   33 0 37.66234 -121.69662 Livermore 12 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
1569913215:633458 633458 633458 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 03:36:05 UTC October 01, 2019 - 10:00:00 UTC   5 0 40.78042 -124.18235 Eureka 6 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
1569913215:633460 633460 633460 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 05:46:28 UTC October 01, 2019 - 12:00:00 UTC   1 0 38.69685 -120.77764 Placerville 19 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
1569913215:633461 633461 633461 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:50:28 UTC October 01, 2019 - 11:00:00 UTC   1 0 35.15723 -120.672 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569913215:633463 633463 633463 2019-10-01 00:00:15-07:00 1 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
1569913215:633467 633467 633467 2019-10-01 00:00:15-07:00 1 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
1569913215:633470 633470 633470 2019-10-01 00:00:15-07:00 1 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
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:633478 633478 633478 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:34:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45: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 is sending a repair crew to the outage location. 3
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:633480 633480 633480 2019-10-01 00:00:15-07:00 1 October 01, 2019 - 06:40:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45:00 UTC 1 1 37.70999 -122.17583 San Leandro 27 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569913215:633481 633481 633481 2019-10-01 00:00:15-07:00 1 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
1569913215:633483 633483 633483 2019-10-01 00:00:15-07:00 1 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
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:633485 633485 633485 2019-10-01 00:00:15-07:00 1 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
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:629455 629455 629455 2019-10-01 00:10:38-07:00 2 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
1569913838:629544 629544 629544 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 04:30:45 UTC October 01, 2019 - 10:00: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
1569913838:629993 629993 629993 2019-10-01 00:10:38-07:00 2 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
1569913838:630055 630055 630055 2019-10-01 00:10:38-07:00 2 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
1569913838:630855 630855 630855 2019-10-01 00:10:38-07:00 2 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
1569913838:631014 631014 631014 2019-10-01 00:10:38-07:00 2 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
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:631174 631174 631174 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 07:04:26 UTC October 01, 2019 - 09:00:00 UTC   30 0 37.84695 -122.21344 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
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:631639 631639 631639 2019-10-01 00:10:38-07:00 2 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
1569913838:631794 631794 631794 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 Riverdale 22 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
1569913838:632115 632115 632115 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:40:57 UTC October 01, 2019 - 12:00:00 UTC   1 1 37.56994 -122.31673 San Mateo 29 Our preliminary determination is that your outage was caused by a car that hit a pole. 5 PG&E repair crew is on-site working to restore power. 2
1569913838:632117 632117 632117 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:23:44 UTC October 01, 2019 - 11:00:00 UTC   8 0 35.54847 -121.08542 Cambria 3 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
1569913838:632153 632153 632153 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09: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
1569913838:632414 632414 632414 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:00:53 UTC October 01, 2019 - 09: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
1569913838:632474 632474 632474 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:22:33 UTC October 01, 2019 - 08:00:00 UTC   1 0 36.29815 -119.76184 Lemoore 11 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
1569913838:632633 632633 632633 2019-10-01 00:10:38-07:00 2 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
1569913838:632634 632634 632634 2019-10-01 00:10:38-07:00 2 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
1569913838:633157 633157 633157 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 03:40:21 UTC October 01, 2019 - 10:00:00 UTC   3 0 36.61393 -121.56663 Salinas 23 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
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:633373 633373 633373 2019-10-01 00:10:38-07:00 2 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
1569913838:633394 633394 633394 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:59:37 UTC October 01, 2019 - 09: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
1569913838:633410 633410 633410 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:51:59 UTC October 01, 2019 - 09:00:00 UTC   6 0 37.83977 -122.12694 Moraga 14 Our preliminary determination is that your outage was caused by a car that hit a pole. 5 PG&E repair crew is on-site working to restore power. 2
1569913838:633433 633433 633433 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:33: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
1569913838:633435 633435 633435 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:20:48 UTC October 01, 2019 - 10: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
1569913838:633444 633444 633444 2019-10-01 00:10:38-07:00 2 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
1569913838:633451 633451 633451 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 03:16:59 UTC October 01, 2019 - 11:00:00 UTC   33 0 37.66234 -121.69662 Livermore 12 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
1569913838:633458 633458 633458 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 03:36:05 UTC October 01, 2019 - 10:00:00 UTC   5 0 40.78042 -124.18235 Eureka 6 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
1569913838:633460 633460 633460 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 05:46:28 UTC October 01, 2019 - 12:00:00 UTC   1 0 38.69685 -120.77764 Placerville 19 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
1569913838:633461 633461 633461 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:50:28 UTC October 01, 2019 - 11:00:00 UTC   1 0 35.15723 -120.672 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569913838:633463 633463 633463 2019-10-01 00:10:38-07:00 2 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
1569913838:633467 633467 633467 2019-10-01 00:10:38-07:00 2 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
1569913838:633470 633470 633470 2019-10-01 00:10:38-07:00 2 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
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:633478 633478 633478 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:34:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45: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 is sending a repair crew to the outage location. 3
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:633480 633480 633480 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 06:40:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45:00 UTC 1 1 37.70999 -122.17583 San Leandro 27 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569913838:633481 633481 633481 2019-10-01 00:10:38-07:00 2 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
1569913838:633483 633483 633483 2019-10-01 00:10:38-07:00 2 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
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:633485 633485 633485 2019-10-01 00:10:38-07:00 2 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
1569913838:633488 633488 633488 2019-10-01 00:10:38-07:00 2 October 01, 2019 - 07:06:10 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 27 1 35.99202 -119.57146 Kettleman City 10 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
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:629455 629455 629455 2019-10-01 00:20:14-07:00 3 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
1569914414:629544 629544 629544 2019-10-01 00:20:14-07:00 3 October 01, 2019 - 04:30:45 UTC October 01, 2019 - 10:00: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
1569914414:629993 629993 629993 2019-10-01 00:20:14-07:00 3 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
1569914414:630055 630055 630055 2019-10-01 00:20:14-07:00 3 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
1569914414:630855 630855 630855 2019-10-01 00:20:14-07:00 3 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
1569914414:631014 631014 631014 2019-10-01 00:20:14-07:00 3 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
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:631639 631639 631639 2019-10-01 00:20:14-07:00 3 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
1569914414:631794 631794 631794 2019-10-01 00:20:14-07:00 3 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 Riverdale 22 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
1569914414:632115 632115 632115 2019-10-01 00:20:14-07:00 3 October 01, 2019 - 06:40:57 UTC October 01, 2019 - 12:00:00 UTC   1 1 37.56994 -122.31673 San Mateo 29 Our preliminary determination is that your outage was caused by a car that hit a pole. 5 PG&E repair crew is on-site working to restore power. 2

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