188 rows

View and edit SQL

id latitude longitude outage estCustAffected lastUpdateTime hazardFlag region cause crewCurrentStatus outage_url currentEtor autoEtor
1619033153:1327021 37.87035 -122.04662 1327021 1 April 21, 2021 - 19:17:54 UTC 1 Alamo Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1327021 April 21, 2021 - 23:30:00 UTC April 21, 2021 - 23:30:00 UTC
1619033153:1326878 37.88891 -122.30309 1326878 12 April 21, 2021 - 19:20:22 UTC 0 Albany PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326878 April 21, 2021 - 21:00:00 UTC April 21, 2021 - 21:00:00 UTC
1619033153:1326936 37.88784 -122.30275 1326936 14 April 21, 2021 - 18:45:03 UTC 0 Albany Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326936 April 21, 2021 - 21:30:00 UTC April 21, 2021 - 21:30:00 UTC
1619033153:1326934 38.92932 -122.08453 1326934 1 April 21, 2021 - 19:02:38 UTC 0 Arbuckle PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326934 April 21, 2021 - 22:15:00 UTC April 21, 2021 - 22:15:00 UTC
1619033153:1326642 37.44699 -122.20091 1326642 1 April 21, 2021 - 16:13:37 UTC 0 Atherton Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326642 April 22, 2021 - 00:00:00 UTC  
1619033153:1326637 37.44705 -122.20103 1326637 5 April 21, 2021 - 16:17:18 UTC 0 Atherton Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326637 April 22, 2021 - 00:00:00 UTC  
1619033153:1326998 38.99251 -121.06341 1326998 1 April 21, 2021 - 19:11:05 UTC 0 Auburn Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326998 April 21, 2021 - 21:30:00 UTC April 21, 2021 - 21:30:00 UTC
1619033153:1326979 35.39302 -118.95194 1326979 1 April 21, 2021 - 18:56:17 UTC 0 Bakersfield Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326979 April 21, 2021 - 22:00:00 UTC April 21, 2021 - 22:00:00 UTC
1619033153:1326858 35.34965 -119.01338 1326858 1 April 21, 2021 - 18:54:44 UTC 1 Bakersfield PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326858 April 21, 2021 - 21:15:00 UTC April 21, 2021 - 21:15:00 UTC
1619033153:1326502 35.17984 -119.10986 1326502 5 April 21, 2021 - 15:45:03 UTC 0 Bakersfield Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326502 April 22, 2021 - 01:00:00 UTC  
1619033153:1326624 35.18052 -119.10994 1326624 3 April 21, 2021 - 16:15:55 UTC 0 Bakersfield Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326624 April 22, 2021 - 01:00:00 UTC  
1619033153:1326879 37.52019 -122.29995 1326879 1 April 21, 2021 - 18:22:03 UTC 0 Belmont Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326879 April 21, 2021 - 21:15:00 UTC April 21, 2021 - 21:15:00 UTC
1619033153:1326462 37.08006 -122.07142 1326462 6 April 21, 2021 - 17:20:46 UTC 0 Ben Lomond Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326462 April 22, 2021 - 00:30:00 UTC  
1619033153:1326917 37.07072 -122.08074 1326917 10 April 21, 2021 - 18:29:28 UTC 0 Ben Lomond Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326917 April 22, 2021 - 00:00:00 UTC  
1619033153:1326940 37.05858 -122.1207 1326940 1 April 21, 2021 - 18:54:05 UTC 1 Bonny Doon Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326940 April 21, 2021 - 23:30:00 UTC April 21, 2021 - 23:30:00 UTC
1619033153:1326489 37.4679 -119.89568 1326489 2 April 21, 2021 - 18:18:31 UTC 0 Bootjack Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326489 April 21, 2021 - 20:30:00 UTC  
1619033153:1326490 37.46782 -119.89506 1326490 1 April 21, 2021 - 15:37:15 UTC 0 Bootjack Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326490 April 21, 2021 - 20:30:00 UTC  
1619033153:1326702 37.17624 -122.06012 1326702 1 April 21, 2021 - 16:54:54 UTC 1 Boulder Creek Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326702 April 21, 2021 - 21:00:00 UTC April 21, 2021 - 21:00:00 UTC
1619033153:1326643 37.12693 -122.1291 1326643 14 April 21, 2021 - 16:19:45 UTC 0 Boulder Creek Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326643 April 22, 2021 - 00:00:00 UTC  
1619033153:1326939 37.10144 -122.08598 1326939 1 April 21, 2021 - 18:53:39 UTC 1 Brookdale Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326939 April 21, 2021 - 23:30:00 UTC April 21, 2021 - 23:30:00 UTC
1619033153:1326631 39.32414 -121.25035 1326631 151 April 21, 2021 - 16:30:20 UTC 0 Browns Valley Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326631 April 21, 2021 - 23:00:00 UTC  
1619033153:1326975 37.57749 -122.39794 1326975 1 April 21, 2021 - 18:51:41 UTC 0 Burlingame Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326975 April 21, 2021 - 23:30:00 UTC April 21, 2021 - 23:30:00 UTC
1619033153:1326458 38.56778 -122.63382 1326458 2 April 21, 2021 - 15:17:25 UTC 0 Calistoga Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326458 April 21, 2021 - 22:00:00 UTC  
1619033153:1326996 37.28237 -121.92466 1326996 1 April 21, 2021 - 19:00:48 UTC 1 Campbell Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326996 April 21, 2021 - 22:00:00 UTC April 21, 2021 - 22:00:00 UTC
1619033153:1326542 37.29413 -121.94309 1326542 3 April 21, 2021 - 15:59:32 UTC 0 Campbell Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326542 April 22, 2021 - 01:00:00 UTC  
1619033153:1326426 38.05961 -120.26822 1326426 3 April 21, 2021 - 15:08:15 UTC 0 Cedar Ridge Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326426 April 21, 2021 - 23:00:00 UTC  
1619033153:1326463 39.72663 -121.84418 1326463 10 April 21, 2021 - 15:21:32 UTC 0 Chico Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326463 April 21, 2021 - 23:00:00 UTC  
1619033153:1326791 39.72562 -121.84567 1326791 1 April 21, 2021 - 18:15:25 UTC 0 Chico Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326791 April 21, 2021 - 23:00:00 UTC  
1619033153:1326805 39.7758 -121.84559 1326805 5 April 21, 2021 - 18:33:10 UTC 0 Chico PG&E is investigating the cause of your outage. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326805 April 21, 2021 - 20:30:00 UTC April 21, 2021 - 20:30:00 UTC
1619033153:1326755 39.71255 -121.81796 1326755 1 April 21, 2021 - 18:22:32 UTC 0 Chico PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326755 April 21, 2021 - 20:00:00 UTC April 21, 2021 - 20:00:00 UTC
1619033153:1326782 38.3766 -121.58396 1326782 1 April 21, 2021 - 17:16:56 UTC 0 Clarksburg Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326782 April 21, 2021 - 19:00:00 UTC  
1619033153:1326821 37.95306 -121.91687 1326821 14 April 21, 2021 - 19:21:03 UTC 0 Clayton Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326821 April 21, 2021 - 21:00:00 UTC  
1619033153:1327023 37.95312 -121.91834 1327023 14 April 21, 2021 - 19:16:12 UTC 0 Clayton Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1327023 April 21, 2021 - 22:45:00 UTC April 21, 2021 - 22:45:00 UTC
1619033153:1327018 39.00299 -122.70551 1327018 3 April 21, 2021 - 19:10:29 UTC 0 Clearlake Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1327018 April 21, 2021 - 23:00:00 UTC  
1619033153:1326434 39.0229 -122.71242 1326434 2 April 21, 2021 - 16:15:07 UTC 0 Clearlake Oaks Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326434 April 21, 2021 - 19:00:00 UTC  
1619033153:1326435 39.02287 -122.71214 1326435 2 April 21, 2021 - 15:10:53 UTC 0 Clearlake Oaks Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326435 April 21, 2021 - 19:00:00 UTC  
1619033153:1326417 38.82601 -123.00027 1326417 106 April 21, 2021 - 15:08:12 UTC 0 Cloverdale Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326417 April 21, 2021 - 23:30:00 UTC  
1619033153:1326630 39.00012 -120.97927 1326630 2 April 21, 2021 - 16:13:25 UTC 0 Colfax Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326630 April 21, 2021 - 20:00:00 UTC  
1619033153:1326199 36.99077 -121.80635 1326199 2 April 21, 2021 - 17:17:58 UTC 0 Corralitos Our preliminary determination is that your outage was caused by an equipment issue. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326199 April 21, 2021 - 22:00:00 UTC  
1619033153:1326546 37.91396 -122.51308 1326546 15 April 21, 2021 - 19:13:10 UTC 0 Corte Madera Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326546 April 21, 2021 - 23:00:00 UTC  
1619033153:1326419 40.39049 -122.20145 1326419 1 April 21, 2021 - 15:11:21 UTC 0 Cottonwood Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326419 April 21, 2021 - 22:00:00 UTC  
1619033153:1326809 38.05428 -122.22285 1326809 13 April 21, 2021 - 19:14:33 UTC 1 Crockett PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326809 April 21, 2021 - 21:15:00 UTC  
1619033153:1326777 37.70065 -122.49412 1326777 1 April 21, 2021 - 18:30:29 UTC 0 Daly City PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326777 April 21, 2021 - 20:30:00 UTC April 21, 2021 - 20:30:00 UTC
1619033153:1326928 37.67501 -122.48162 1326928 1 April 21, 2021 - 18:36:31 UTC 1 Daly City Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326928 April 21, 2021 - 22:00:00 UTC April 21, 2021 - 22:00:00 UTC
1619033153:1326619 37.81953 -121.97538 1326619 1 April 21, 2021 - 16:05:58 UTC 0 Danville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326619 April 21, 2021 - 21:00:00 UTC  
1619033153:1326808 38.57906 -121.76308 1326808 1 April 21, 2021 - 18:08:54 UTC 0 Davis Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326808 April 21, 2021 - 21:00:00 UTC April 21, 2021 - 21:00:00 UTC
1619033153:1326813 38.50338 -121.7053 1326813 1 April 21, 2021 - 18:19:19 UTC 0 Dixon Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326813 April 21, 2021 - 21:00:00 UTC April 21, 2021 - 21:00:00 UTC
1619033153:1326875 39.93518 -120.92462 1326875 1 April 21, 2021 - 18:21:44 UTC 0 East Quincy Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326875 April 21, 2021 - 22:15:00 UTC April 21, 2021 - 22:15:00 UTC
1619033153:1326999 36.65663 -119.77291 1326999 12 April 21, 2021 - 19:19:53 UTC 0 Easton Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326999 April 21, 2021 - 22:00:00 UTC April 21, 2021 - 22:00:00 UTC
1619033153:1326595 38.73387 -121.07523 1326595 4 April 21, 2021 - 16:07:32 UTC 0 El Dorado Hills Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326595 April 22, 2021 - 00:00:00 UTC  
1619033153:1326319 36.81751 -121.69757 1326319 2 April 21, 2021 - 18:47:48 UTC 0 Elkhorn Our preliminary determination is that your outage was caused by an equipment issue. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326319 April 22, 2021 - 06:46:00 UTC  
1619033153:1326943 38.75131 -121.49372 1326943 1 April 21, 2021 - 18:48:11 UTC 1 Elverta Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326943 April 21, 2021 - 20:30:00 UTC April 21, 2021 - 20:30:00 UTC
1619033153:1326978 40.76581 -124.06723 1326978 20 April 21, 2021 - 18:58:18 UTC 0 Eureka Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326978 April 21, 2021 - 21:00:00 UTC  
1619033153:1326938 38.31419 -122.12531 1326938 1 April 21, 2021 - 18:44:16 UTC 0 Fairfield Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326938 April 21, 2021 - 22:30:00 UTC  
1619033153:1326629 38.49901 -120.75945 1326629 1 April 21, 2021 - 16:09:00 UTC 0 Fiddletown Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326629 April 21, 2021 - 18:00:00 UTC  
1619033153:1326796 36.79944 -120.28272 1326796 1 April 21, 2021 - 17:25:44 UTC 0 Firebaugh Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326796 April 21, 2021 - 23:00:00 UTC  
1619033153:1326797 37.49104 -121.90563 1326797 18 April 21, 2021 - 19:20:16 UTC 0 Fremont PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326797 April 21, 2021 - 20:30:00 UTC April 21, 2021 - 20:30:00 UTC
1619033153:1327030 36.76907 -119.79941 1327030 1 April 21, 2021 - 19:19:04 UTC 1 Fresno Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1327030 April 21, 2021 - 22:15:00 UTC April 21, 2021 - 22:15:00 UTC
1619033153:1326492 40.10656 -123.78107 1326492 130 April 21, 2021 - 17:23:59 UTC 0 Garberville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326492 April 21, 2021 - 23:30:00 UTC  
1619033153:1326464 37.96152 -121.23952 1326464 26 April 21, 2021 - 15:27:50 UTC 0 Garden Acres Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326464 April 21, 2021 - 23:00:00 UTC  
1619033153:1326704 36.97315 -121.50869 1326704 1 April 21, 2021 - 16:46:09 UTC 0 Gilroy Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326704 April 21, 2021 - 20:15:00 UTC April 21, 2021 - 20:15:00 UTC
1619033153:1326501 36.98588 -121.51516 1326501 1 April 21, 2021 - 18:58:58 UTC 0 Gilroy PG&E is investigating the cause of your outage. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326501 April 21, 2021 - 21:30:00 UTC  
1619033153:1326513 38.34059 -120.60876 1326513 3 April 21, 2021 - 15:51:22 UTC 0 Glencoe Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326513 April 21, 2021 - 23:30:00 UTC  
1619033153:1326437 38.4432 -122.86608 1326437 220 April 21, 2021 - 16:17:18 UTC 0 Graton Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326437 April 21, 2021 - 23:00:00 UTC  
1619033153:1326976 35.39 -119.1168 1326976 1 April 21, 2021 - 19:14:28 UTC 1 Greenacres PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326976 April 21, 2021 - 22:00:00 UTC April 21, 2021 - 22:00:00 UTC
1619033153:1326495 38.50497 -123.01577 1326495 5 April 21, 2021 - 15:42:45 UTC 0 Guerneville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326495 April 21, 2021 - 23:00:00 UTC  
1619033153:1326661 37.66168 -122.10276 1326661 18 April 21, 2021 - 16:27:19 UTC 0 Hayward Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326661 April 21, 2021 - 20:00:00 UTC April 21, 2021 - 20:00:00 UTC
1619033153:1326694 37.66234 -122.10339 1326694 26 April 21, 2021 - 16:48:16 UTC 0 Hayward Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326694 April 21, 2021 - 20:15:00 UTC April 21, 2021 - 20:15:00 UTC
1619033153:1326500 37.51132 -122.339 1326500 2 April 21, 2021 - 15:44:37 UTC 0 Highlands-Baywood Park Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326500 April 21, 2021 - 23:00:00 UTC  
1619033153:1326824 37.56014 -122.35526 1326824 1 April 21, 2021 - 18:57:49 UTC 1 Hillsborough PG&E is investigating the cause of your outage. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326824 April 21, 2021 - 22:00:00 UTC April 21, 2021 - 22:00:00 UTC
1619033153:1326814 37.55896 -122.35632 1326814 1 April 21, 2021 - 17:57:51 UTC 0 Hillsborough Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326814 April 21, 2021 - 21:45:00 UTC April 21, 2021 - 21:45:00 UTC
1619033153:1326491 41.05471 -123.67205 1326491 2 April 21, 2021 - 18:47:55 UTC 0 Hoopa Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326491 April 21, 2021 - 22:30:00 UTC  
1619033153:1326504 36.25779 -120.08553 1326504 1 April 21, 2021 - 17:23:10 UTC 0 Huron Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326504 April 21, 2021 - 20:30:00 UTC  
1619033153:1326423 38.06534 -122.82505 1326423 4 April 21, 2021 - 15:24:14 UTC 0 Inverness Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326423 April 21, 2021 - 23:00:00 UTC  
1619033153:1326375 37.82165 -121.27757 1326375 10 April 21, 2021 - 19:08:35 UTC 0 Lathrop PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326375 April 21, 2021 - 21:30:00 UTC  
1619033153:1327016 36.30185 -119.79344 1327016 1 April 21, 2021 - 19:11:48 UTC 1 Lemoore Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1327016 April 21, 2021 - 22:15:00 UTC April 21, 2021 - 22:15:00 UTC
1619033153:1327020 36.99258 -121.98202 1327020 690 April 21, 2021 - 19:20:53 UTC 0 Live Oak-Santa Cruz Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1327020 April 21, 2021 - 22:45:00 UTC April 21, 2021 - 22:45:00 UTC
1619033153:1326666 37.31269 -120.76043 1326666 1 April 21, 2021 - 16:34:50 UTC 0 Livingston Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326666 April 22, 2021 - 01:00:00 UTC  
1619033153:1326660 37.3097 -120.76056 1326660 5 April 21, 2021 - 16:25:49 UTC 0 Livingston Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326660 April 22, 2021 - 01:00:00 UTC  
1619033153:1326677 37.31565 -120.76038 1326677 1 April 21, 2021 - 16:36:08 UTC 0 Livingston Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326677 April 22, 2021 - 01:00:00 UTC  
1619033153:1325954 37.11129 -122.06122 1325954 1 April 21, 2021 - 18:29:31 UTC 0 Lompico Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1325954 April 22, 2021 - 20:00:00 UTC  
1619033153:1326536 37.06909 -120.86129 1326536 6 April 21, 2021 - 15:53:40 UTC 0 Los Banos Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326536 April 21, 2021 - 23:00:00 UTC  
1619033153:1326559 37.06772 -120.84602 1326559 108 April 21, 2021 - 19:03:42 UTC 0 Los Banos Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326559 April 21, 2021 - 18:45:00 UTC April 21, 2021 - 18:45:00 UTC
1619033153:1326615 37.06773 -120.84666 1326615 1 April 21, 2021 - 16:05:30 UTC 0 Los Banos Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326615 April 21, 2021 - 18:45:00 UTC April 21, 2021 - 18:45:00 UTC
1619033153:1326670 37.23605 -121.93564 1326670 2 April 21, 2021 - 16:29:56 UTC 0 Los Gatos Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326670 April 22, 2021 - 00:00:00 UTC  
1619033153:1327022 35.2087 -120.62529 1327022 132 April 21, 2021 - 19:19:52 UTC 0 Los Ranchos Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1327022 April 21, 2021 - 23:00:00 UTC April 21, 2021 - 23:00:00 UTC
1619033153:1326812 37.34629 -122.08984 1326812 1 April 21, 2021 - 18:35:53 UTC 1 Loyola PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326812 April 21, 2021 - 21:00:00 UTC April 21, 2021 - 21:00:00 UTC
1619033153:1326644 36.84135 -120.06397 1326644 1 April 21, 2021 - 19:12:13 UTC 0 Madera PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326644 April 21, 2021 - 21:30:00 UTC  
1619033153:1320635 37.78039 -121.29818 1320635 1 April 17, 2021 - 19:48:59 UTC 0 Manteca Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1320635 April 17, 2021 - 23:00:00 UTC  
1619033153:1326465 37.79207 -121.22658 1326465 1 April 21, 2021 - 18:20:49 UTC 0 Manteca PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326465 April 21, 2021 - 22:00:00 UTC  
1619033153:1326929 37.44842 -119.93277 1326929 2 April 21, 2021 - 18:36:50 UTC 0 Mariposa Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326929 April 21, 2021 - 20:00:00 UTC  
1619033153:1326416 39.13567 -121.59151 1326416 2 April 21, 2021 - 18:56:40 UTC 0 Marysville Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326416 April 21, 2021 - 20:00:00 UTC  
1619033153:1326477 35.29099 -119.76561 1326477 7 April 21, 2021 - 17:55:29 UTC 0 Mc Kittrick Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326477 April 22, 2021 - 01:50:00 UTC  
1619033153:1326784 40.93342 -124.12016 1326784 8 April 21, 2021 - 19:19:19 UTC 0 McKinleyville PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326784 April 21, 2021 - 22:00:00 UTC  
1619033153:1326995 36.74974 -120.38571 1326995 1 April 21, 2021 - 19:00:59 UTC 0 Mendota Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326995 April 21, 2021 - 22:00:00 UTC April 21, 2021 - 22:00:00 UTC
1619033153:1326925 36.75102 -120.38548 1326925 270 April 21, 2021 - 19:09:49 UTC 0 Mendota Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326925 April 21, 2021 - 21:30:00 UTC April 21, 2021 - 21:30:00 UTC
1619033153:1326980 37.45162 -122.1687 1326980 61 April 21, 2021 - 19:08:05 UTC 0 Menlo Park Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326980 April 21, 2021 - 22:45:00 UTC April 21, 2021 - 22:45:00 UTC
1619033153:1326941 37.45166 -122.17046 1326941 10 April 21, 2021 - 18:56:40 UTC 0 Menlo Park Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1326941 April 21, 2021 - 22:30:00 UTC April 21, 2021 - 22:30:00 UTC
1619033153:1326955 37.45211 -122.16895 1326955 10 April 21, 2021 - 19:19:22 UTC 2 Menlo Park PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1326955 April 21, 2021 - 22:30:00 UTC April 21, 2021 - 22:30:00 UTC
1619033153:1326170 40.36879 -121.51211 1326170 1 April 21, 2021 - 17:27:29 UTC 0 Mineral Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1326170 April 21, 2021 - 23:00:00 UTC  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW most_recent_snapshot as
select
    outage_snapshots.id, latitude, longitude, outage, estCustAffected,
    lastUpdateTime, hazardFlag, regionName.name as region, cause.name as cause,
    crewCurrentStatus.name as crewCurrentStatus,
    'https://pge-outages.simonwillison.net/pge-outages/outages/' || outage as outage_url, currentEtor, autoEtor
from outage_snapshots
    join regionName on outage_snapshots.regionName = regionName.id
    join cause on outage_snapshots.cause = cause.id
    join crewCurrentStatus on outage_snapshots.crewCurrentStatus = crewCurrentStatus.id
where
    snapshot in (select id from snapshots order by id desc limit 1);