outage_snapshots

100 rows where snapshot = 100

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569972627:630055 630055 630055 2019-10-01 16:30:27-07:00 100 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
1569972627:631014 631014 631014 2019-10-01 16:30:27-07:00 100 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
1569972627:633488 633488 633488 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 16:14:10 UTC October 02, 2019 - 01:00:00 UTC   27 1 35.99202 -119.57146 Kettleman City 10 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
1569972627:633524 633524 633524 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:15:51 UTC October 02, 2019 - 01:15:00 UTC   94 0 37.29072 -121.95844 Campbell 43 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
1569972627:633542 633542 633542 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 19:34:33 UTC October 02, 2019 - 03:00:00 UTC   14 0 36.99019 -121.73674 Watsonville 49 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
1569972627:633546 633546 633546 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:11:46 UTC October 02, 2019 - 03:00:00 UTC   9 0 37.87055 -122.03021 Walnut Creek 33 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
1569972627:633549 633549 633549 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:15:51 UTC October 02, 2019 - 01:15:00 UTC   3 0 37.29066 -121.95854 Campbell 43 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
1569972627:633550 633550 633550 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 14:22:00 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
1569972627:633551 633551 633551 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 14:22:00 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
1569972627:633552 633552 633552 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 14:22:00 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
1569972627:633572 633572 633572 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:01:08 UTC October 02, 2019 - 04:01:00 UTC   1 0 37.72031 -122.38494 San Francisco 25 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
1569972627:633573 633573 633573 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:22:08 UTC October 01, 2019 - 23:00:00 UTC   28 0 38.84408 -122.20342 Guinda 59 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
1569972627:633599 633599 633599 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 Bakersfield 2 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
1569972627:633602 633602 633602 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 20:08:52 UTC October 02, 2019 - 03:00:00 UTC   116 0 35.15721 -120.66906 Pismo Beach 18 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
1569972627:633624 633624 633624 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 15:26:57 UTC October 01, 2019 - 23:00:00 UTC   9 0 34.95908 -120.51911 Santa Maria 52 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
1569972627:633635 633635 633635 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:23:29 UTC October 02, 2019 - 01:00:00 UTC   42 0 37.74341 -122.46635 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
1569972627:633649 633649 633649 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:52:55 UTC October 02, 2019 - 01:00:00 UTC   4 1 38.40058 -122.51294 Glen Ellen 90 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
1569972627:633753 633753 633753 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 20:42:43 UTC October 01, 2019 - 23:00:00 UTC   43 0 38.21709 -122.63594 Petaluma 96 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
1569972627:633774 633774 633774 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 20:26:41 UTC October 01, 2019 - 21:00:00 UTC   1 0 38.64604 -120.97578 Cameron Park 101 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
1569972627:633785 633785 633785 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:07:16 UTC October 01, 2019 - 21:30:00 UTC   34 0 39.21671 -120.79452 Alta 105 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
1569972627:633797 633797 633797 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 16:05:51 UTC October 02, 2019 - 00:00:00 UTC   11 0 40.50248 -124.28154 Ferndale 112 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
1569972627:633801 633801 633801 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 16:10:48 UTC October 02, 2019 - 00:00:00 UTC   43 0 37.95149 -122.32156 East Richmond Heights 111 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
1569972627:633804 633804 633804 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 19:13:13 UTC October 02, 2019 - 03:00:00 UTC   5 0 40.38922 -122.26397 Cottonwood 56 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
1569972627:633805 633805 633805 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:22:46 UTC October 02, 2019 - 03:00:00 UTC   1 0 40.38934 -122.264 Cottonwood 56 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:633825 633825 633825 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 16:21:41 UTC October 02, 2019 - 00:00:00 UTC   23 0 37.70608 -122.47673 Daly City 124 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
1569972627:633827 633827 633827 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:07:53 UTC October 02, 2019 - 00:00:00 UTC   4 0 37.38808 -122.26323 Woodside 130 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
1569972627:633839 633839 633839 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 16:32:29 UTC October 01, 2019 - 23:00:00 UTC   25 0 36.61702 -119.27635 Orange Cove 136 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
1569972627:633849 633849 633849 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:10:56 UTC October 02, 2019 - 06:59:00 UTC   19 0 36.82228 -119.80053 Fresno 35 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
1569972627:633862 633862 633862 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:39:42 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 Castro Valley 4 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
1569972627:633866 633866 633866 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 20:47:25 UTC October 02, 2019 - 03:21:00 UTC   7 0 38.01599 -120.225 Twain Harte 145 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
1569972627:633867 633867 633867 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 18:00:05 UTC October 01, 2019 - 23:00:00 UTC   3 0 36.61702 -119.27686 Orange Cove 136 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
1569972627:633869 633869 633869 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:02:27 UTC October 01, 2019 - 22:00:00 UTC   1 0 40.51095 -124.01787 Carlotta 139 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
1569972627:633886 633886 633886 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 16:58:34 UTC October 01, 2019 - 23:00:00 UTC   4 0 38.38715 -122.97488 Occidental 148 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
1569972627:633903 633903 633903 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 17:24:30 UTC October 02, 2019 - 00:00:00 UTC   28 0 37.84959 -122.21253 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
1569972627:633940 633940 633940 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 18:59:43 UTC October 01, 2019 - 23:00:00 UTC   1 0 38.10863 -122.23096 Vallejo 154 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1569972627:633950 633950 633950 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 20:02:44 UTC October 02, 2019 - 05:30:00 UTC   1 0 37.65995 -122.38797 South San Francisco 156 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:633962 633962 633962 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:53:42 UTC October 02, 2019 - 04:00:00 UTC   15 1 37.54962 -122.33508 San Mateo 29 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
1569972627:633964 633964 633964 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:48:26 UTC October 01, 2019 - 22:58:00 UTC   2 0 37.57104 -121.99067 Fremont 140 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
1569972627:633965 633965 633965 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:32:18 UTC October 02, 2019 - 02:00:00 UTC   1 0 35.32583 -119.35054 Buttonwillow 162 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
1569972627:633971 633971 633971 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 20:50:03 UTC October 02, 2019 - 03:00:00 UTC   5 2 39.66681 -121.73549 Paradise 167 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
1569972627:633989 633989 633989 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:17:24 UTC October 02, 2019 - 05:30:00 UTC   1 0 37.59193 -122.41318 Millbrae 173 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634093 634093 634093 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:09:34 UTC October 01, 2019 - 23:00:00 UTC   2 1 40.61849 -122.47477 Keswick 180 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
1569972627:634434 634434 634434 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:33:07 UTC October 02, 2019 - 01:30:00 UTC   1 0 36.52389 -119.61108 Selma 100 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
1569972627:634514 634514 634514 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:01:18 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 35.59666 -119.76676 Lost Hills 126 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634613 634613 634613 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:18:30 UTC October 02, 2019 - 02:00:00 UTC   1 0 36.38594 -119.65496 Hanford 73 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:634713 634713 634713 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:57:01 UTC     1 0 37.717 -122.44714 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:634814 634814 634814 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:06:58 UTC October 02, 2019 - 06:59:00 UTC   1 1 38.69436 -121.93466 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634818 634818 634818 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:634830 634830 634830 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:45:06 UTC October 02, 2019 - 03:00:00 UTC   73 0 37.97436 -121.75807 Antioch 42 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
1569972627:634832 634832 634832 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:15:47 UTC October 01, 2019 - 22:00:00 UTC   10 0 38.64148 -120.51459 Grizzly Flats 150 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
1569972627:634837 634837 634837 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:37:27 UTC October 02, 2019 - 01:04:00 UTC   20 0 37.53355 -121.97215 Fremont 140 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
1569972627:634839 634839 634839 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 21:09:57 UTC     25 0 37.73528 -122.4484 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:634841 634841 634841 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:18:44 UTC October 02, 2019 - 00:30:00 UTC   2 0 39.06359 -121.01819 Grass Valley 113 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
1569972627:634842 634842 634842 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:24:12 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 37.96776 -121.6848 Brentwood 95 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634852 634852 634852 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:02:33 UTC October 02, 2019 - 01:00:00 UTC   1 0 37.97909 -122.49745 San Rafael 144 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
1569972627:634854 634854 634854 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:54:17 UTC October 02, 2019 - 00:00:00 UTC October 02, 2019 - 00:00:00 UTC 1 0 37.58335 -122.34946 Burlingame 203 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634855 634855 634855 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:19:15 UTC October 02, 2019 - 03:00:00 UTC October 02, 2019 - 03:00:00 UTC 1 1 40.20866 -123.49266 Zenia 205 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:634859 634859 634859 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:15:42 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 38.88155 -120.88162 Garden Valley 207 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634863 634863 634863 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:03:45 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 1 38.00148 -120.33263 Phoenix Lake 209 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634865 634865 634865 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:07:45 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 0 38.78533 -120.75834 Placerville 19 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634868 634868 634868 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:17:55 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 1 37.79484 -121.2339 Manteca 210 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634869 634869 634869 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:06:13 UTC October 02, 2019 - 00:45:00 UTC October 02, 2019 - 00:45:00 UTC 1 1 38.29614 -122.22878 Napa 15 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:634870 634870 634870 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:48:25 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 0 38.00994 -121.872 Pittsburg 204 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634872 634872 634872 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:24:53 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 0 38.0338 -121.24225 Morada 212 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634873 634873 634873 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:26:08 UTC October 02, 2019 - 00:45:00 UTC October 02, 2019 - 00:45:00 UTC 1 0 37.69531 -122.49179 Daly City 124 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:634876 634876 634876 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:41:42 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 1 37.55112 -120.00113 Midpines 211 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:634893 634893 634893 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:59:56 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 0 37.66824 -121.77716 Livermore 12 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634913 634913 634913 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:27:29 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 1 37.81696 -122.00282 Danville 213 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:634954 634954 634954 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:50:40 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 95 0 38.01109 -122.70231 Lagunitas-Forest Knolls 216 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1569972627:634959 634959 634959 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:55:01 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 0 38.49153 -122.89425 Forestville 214 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634975 634975 634975 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:02:26 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 1 37.96736 -122.33266 Richmond 220 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:634993 634993 634993 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:38:22 UTC October 02, 2019 - 02:45:00 UTC October 02, 2019 - 02:45:00 UTC 1 1 40.08537 -123.81121 Garberville 218 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635013 635013 635013 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:38:59 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 0 37.27552 -121.84904 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635014 635014 635014 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:12:24 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 1 36.82842 -119.77457 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:635053 635053 635053 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:40:59 UTC October 02, 2019 - 00:15:00 UTC October 02, 2019 - 00:15:00 UTC 1 0 37.51137 -121.99651 Newark 225 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:635097 635097 635097 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:24:19 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 0 38.03281 -122.57546 Lucas Valley-Marinwood 224 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635098 635098 635098 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:42:32 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 0 36.9922 -121.59684 Gilroy 223 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635100 635100 635100 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:54:59 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 38.48203 -122.9453 Forestville 214 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635101 635101 635101 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:24:59 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 1 35.36461 -118.94261 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:635113 635113 635113 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 22:49:00 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 0 37.30889 -121.90237 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635114 635114 635114 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:21:45 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 0 37.75459 -122.17765 Oakland 16 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:635153 635153 635153 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:12:39 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 0 37.98855 -122.58514 Fairfax 226 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:635173 635173 635173 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:03:12 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 36.82121 -119.77569 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635193 635193 635193 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:16:23 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 1 37.26993 -121.90571 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:635213 635213 635213 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:23:48 UTC October 02, 2019 - 02:15:00 UTC October 02, 2019 - 02:15:00 UTC 1 1 38.23746 -122.63683 Petaluma 96 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635254 635254 635254 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:11:16 UTC October 02, 2019 - 00:45:00 UTC October 02, 2019 - 00:45:00 UTC 1 0 36.81185 -119.80442 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635255 635255 635255 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:25:49 UTC October 02, 2019 - 02:15:00 UTC October 02, 2019 - 02:15:00 UTC 714 0 38.60921 -120.70246 Somerset 221 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569972627:635256 635256 635256 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:07:59 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 1 37.66599 -122.41433 South San Francisco 156 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635293 635293 635293 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:08:38 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 Merced 13 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635294 635294 635294 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:10:35 UTC October 02, 2019 - 02:30:00 UTC October 02, 2019 - 02:30:00 UTC 0 1 39.74013 -121.63659 Paradise 167 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635296 635296 635296 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:13:50 UTC October 02, 2019 - 02:15:00 UTC October 02, 2019 - 02:15:00 UTC 1 0 37.4134 -121.85578 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635313 635313 635313 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:25:05 UTC     1 1 37.73795 -122.42855 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569972627:635314 635314 635314 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:21:16 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 13 0 39.14448 -121.59644 Marysville 198 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635333 635333 635333 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:21:23 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 0 37.46513 -122.15177 Menlo Park 141 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635334 635334 635334 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:25:58 UTC October 02, 2019 - 02:45:00 UTC October 02, 2019 - 02:45:00 UTC 1 0 35.50799 -120.64293 Templeton 60 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635335 635335 635335 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:25:39 UTC October 02, 2019 - 02:45:00 UTC October 02, 2019 - 02:45:00 UTC 1 0 35.44264 -120.60529 Atascadero 40 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635336 635336 635336 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:25:51 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 37.30035 -121.97786 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635337 635337 635337 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:26:00 UTC October 02, 2019 - 02:15:00 UTC October 02, 2019 - 02:15:00 UTC 3 0 36.35719 -120.09399 Huron 51 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635338 635338 635338 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:26:02 UTC October 02, 2019 - 02:30:00 UTC October 02, 2019 - 02:30:00 UTC 1 0 37.54683 -121.95151 Fremont 140 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569972627:635339 635339 635339 2019-10-01 16:30:27-07:00 100 October 01, 2019 - 23:26:02 UTC October 02, 2019 - 02:30:00 UTC October 02, 2019 - 02:30:00 UTC 1 0 37.54638 -121.94938 Fremont 140 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 4004.591ms · About: About this site