181 rows

View and edit SQL

id latitude longitude outage estCustAffected lastUpdateTime hazardFlag region cause crewCurrentStatus outage_url currentEtor autoEtor
1611575987:1222659 40.21391 -123.59674 1222659 11 January 25, 2021 - 09:14:38 UTC 0 Alderpoint Our preliminary determination is that your outage was caused by the weather. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222659 January 26, 2021 - 00:00:00 UTC  
1611575987:1222831 39.10468 -121.06298 1222831 1 January 25, 2021 - 09:36:57 UTC 1 Alta Sierra 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/1222831 January 25, 2021 - 18:00:00 UTC  
1611575987:1223033 39.13977 -121.0574 1223033 7 January 25, 2021 - 10:52:12 UTC 1 Alta Sierra 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/1223033 January 25, 2021 - 12:45:00 UTC January 25, 2021 - 12:45:00 UTC
1611575987:1223051 39.13693 -121.04494 1223051 1 January 25, 2021 - 09:46:28 UTC 1 Alta Sierra 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/1223051 January 25, 2021 - 13:30:00 UTC January 25, 2021 - 13:30:00 UTC
1611575987:1223046 39.13626 -121.04204 1223046 1 January 25, 2021 - 11:43:15 UTC 1 Alta Sierra 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/1223046 January 25, 2021 - 13:15:00 UTC January 25, 2021 - 13:15:00 UTC
1611575987:1223007 39.13225 -121.06349 1223007 4 January 25, 2021 - 08:39:02 UTC 0 Alta Sierra 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/1223007 January 25, 2021 - 12:15:00 UTC January 25, 2021 - 12:15:00 UTC
1611575987:1223108 38.24647 -120.36424 1223108 442 January 25, 2021 - 11:03:15 UTC 0 Arnold 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/1223108    
1611575987:1222894 35.12377 -120.60605 1222894 13 January 25, 2021 - 10:58:30 UTC 0 Arroyo Grande 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/1222894 January 25, 2021 - 20:00:00 UTC  
1611575987:1223245 38.89315 -120.99658 1223245 287 January 25, 2021 - 11:41:45 UTC 0 Auburn Lake Trails 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/1223245 January 25, 2021 - 14:30:00 UTC January 25, 2021 - 14:30:00 UTC
1611575987:1223274 36.73983 -118.97653 1223274 1 January 25, 2021 - 11:44:16 UTC 0 Badger 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/1223274 January 25, 2021 - 16:30:00 UTC January 25, 2021 - 16:30:00 UTC
1611575987:1222839 37.33287 -119.57768 1222839 1 January 25, 2021 - 06:31:50 UTC 0 Bass Lake 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/1222839    
1611575987:1219685 37.32422 -119.56615 1219685 8 January 23, 2021 - 21:36:32 UTC 2 Bass Lake 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/1219685 January 28, 2021 - 04:00:00 UTC  
1611575987:1222847 37.32605 -119.56986 1222847 310 January 25, 2021 - 07:00:14 UTC 26 Bass Lake 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/1222847    
1611575987:1222828 37.33201 -119.5729 1222828 1 January 25, 2021 - 06:23:11 UTC 0 Bass Lake 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/1222828    
1611575987:1221916 37.32413 -119.54809 1221916 351 January 24, 2021 - 18:42:27 UTC 4 Bass Lake Our preliminary determination is that your outage was caused by an emergency issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1221916 January 26, 2021 - 03:06:00 UTC  
1611575987:1221956 37.30995 -119.55054 1221956 6 January 24, 2021 - 21:43:34 UTC 0 Bass Lake 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/1221956 January 26, 2021 - 03:07:00 UTC  
1611575987:1222928 37.28802 -119.52028 1222928 229 January 25, 2021 - 11:17:16 UTC 0 Bass Lake 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/1222928    
1611575987:1222033 38.47441 -120.02848 1222033 3 January 25, 2021 - 02:32:47 UTC 0 Bear Valley - Hwy 4 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/1222033    
1611575987:1222523 37.08785 -122.09014 1222523 1 January 25, 2021 - 11:31:45 UTC 0 Ben Lomond 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/1222523 January 25, 2021 - 15:00:00 UTC  
1611575987:1222794 37.07807 -122.13344 1222794 15 January 25, 2021 - 11:28:47 UTC 0 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/1222794 January 25, 2021 - 13:30:00 UTC  
1611575987:1220060 37.45851 -119.87352 1220060 1 January 24, 2021 - 05:22:01 UTC 1 Bootjack 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/1220060 January 26, 2021 - 04:00:00 UTC  
1611575987:1222742 37.14063 -122.15253 1222742 1 January 25, 2021 - 11:37:05 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/1222742 January 25, 2021 - 15:00:00 UTC  
1611575987:1222372 37.17474 -122.14281 1222372 1 January 24, 2021 - 23:43:11 UTC 0 Boulder Creek 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/1222372    
1611575987:1223039 37.96161 -121.69707 1223039 1 January 25, 2021 - 09:35:53 UTC 1 Brentwood 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/1223039 January 25, 2021 - 14:15:00 UTC January 25, 2021 - 14:15:00 UTC
1611575987:1222736 37.10522 -122.1064 1222736 23 January 25, 2021 - 11:30:36 UTC 0 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/1222736 January 25, 2021 - 15:00:00 UTC  
1611575987:1222786 37.0965 -122.09661 1222786 1 January 25, 2021 - 11:15:00 UTC 0 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/1222786 January 25, 2021 - 12:30:00 UTC  
1611575987:1222779 37.10597 -122.10757 1222779 1 January 25, 2021 - 11:37:38 UTC 0 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/1222779 January 25, 2021 - 15:00:00 UTC  
1611575987:1223277 38.45904 -120.52203 1223277 1 January 25, 2021 - 11:39:37 UTC 0 Buckhorn 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/1223277    
1611575987:1223050 39.14051 -120.93826 1223050 4 January 25, 2021 - 11:49:38 UTC 0 Colfax 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/1223050 January 25, 2021 - 14:30:00 UTC January 25, 2021 - 14:30:00 UTC
1611575987:1223044 39.08958 -120.96567 1223044 81 January 25, 2021 - 11:49:38 UTC 0 Colfax 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/1223044 January 25, 2021 - 14:15:00 UTC January 25, 2021 - 14:15:00 UTC
1611575987:1223276 39.09929 -120.94874 1223276 14 January 25, 2021 - 11:49:38 UTC 2 Colfax 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/1223276 January 25, 2021 - 16:30:00 UTC January 25, 2021 - 16:30:00 UTC
1611575987:1222970 39.06631 -120.94666 1222970 22 January 25, 2021 - 11:49:38 UTC 1 Colfax 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/1222970 January 25, 2021 - 13:00:00 UTC January 25, 2021 - 13:00:00 UTC
1611575987:1223162 39.14279 -120.91362 1223162 1 January 25, 2021 - 11:19:58 UTC 0 Colfax 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/1223162 January 25, 2021 - 16:15:00 UTC January 25, 2021 - 16:15:00 UTC
1611575987:1222999 39.03429 -120.97457 1222999 496 January 25, 2021 - 11:16:14 UTC 1 Colfax 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/1222999 January 25, 2021 - 18:00:00 UTC  
1611575987:1223019 39.08687 -120.96786 1223019 1 January 25, 2021 - 08:47:47 UTC 1 Colfax 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/1223019 January 25, 2021 - 13:30:00 UTC January 25, 2021 - 13:30:00 UTC
1611575987:1223025 37.33584 -122.04298 1223025 1317 January 25, 2021 - 11:00:38 UTC 10 Cupertino 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/1223025 January 25, 2021 - 13:00:00 UTC January 25, 2021 - 13:00:00 UTC
1611575987:1223151 34.9277 -119.62041 1223151 543 January 25, 2021 - 11:39:59 UTC 0 Cuyama 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/1223151 January 25, 2021 - 16:15:00 UTC January 25, 2021 - 16:15:00 UTC
1611575987:1222992 37.03119 -122.1882 1222992 337 January 25, 2021 - 11:45:39 UTC 2 Davenport 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/1222992 January 25, 2021 - 14:00:00 UTC January 25, 2021 - 14:00:00 UTC
1611575987:1223275 36.57478 -119.38637 1223275 1 January 25, 2021 - 11:38:39 UTC 1 Dinuba 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/1223275 January 25, 2021 - 14:30:00 UTC January 25, 2021 - 14:30:00 UTC
1611575987:1222739 37.46952 -122.2666 1222739 115 January 25, 2021 - 07:17:20 UTC 3 Emerald Lake Hills Our preliminary determination is that your outage was caused by the weather. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1222739 January 25, 2021 - 23:00:00 UTC  
1611575987:1222762 37.03255 -122.08688 1222762 1 January 25, 2021 - 11:33:36 UTC 0 Felton 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/1222762 January 25, 2021 - 15:00:00 UTC  
1611575987:1222667 40.5557 -124.16775 1222667 3 January 25, 2021 - 07:12:13 UTC 0 Ferndale 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/1222667 January 26, 2021 - 00:00:00 UTC  
1611575987:1221926 37.50647 -119.63499 1221926 1 January 25, 2021 - 00:47:43 UTC 0 Fish Camp To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1221926 January 28, 2021 - 01:00:00 UTC  
1611575987:1221924 37.48133 -119.63768 1221924 5 January 25, 2021 - 00:49:10 UTC 0 Fish Camp To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1221924 January 29, 2021 - 01:00:00 UTC  
1611575987:1223027 39.0001 -120.88689 1223027 1 January 25, 2021 - 09:03:14 UTC 0 Foresthill 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/1223027 January 25, 2021 - 12:30:00 UTC January 25, 2021 - 12:30:00 UTC
1611575987:1222721 37.51484 -121.96997 1222721 9 January 25, 2021 - 10:16:49 UTC 1 Fremont 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/1222721 January 25, 2021 - 12:20:00 UTC  
1611575987:1223052 36.74847 -119.81541 1223052 7 January 25, 2021 - 10:18:21 UTC 0 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/1223052 January 25, 2021 - 12:45:00 UTC January 25, 2021 - 12:45:00 UTC
1611575987:1223086 36.85867 -119.7656 1223086 81 January 25, 2021 - 10:12:10 UTC 0 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/1223086 January 25, 2021 - 13:15:00 UTC January 25, 2021 - 13:15:00 UTC
1611575987:1223085 36.74999 -119.77454 1223085 295 January 25, 2021 - 11:44:08 UTC 0 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/1223085 January 25, 2021 - 12:45:00 UTC January 25, 2021 - 12:45:00 UTC
1611575987:1223082 36.71972 -119.7643 1223082 1466 January 25, 2021 - 11:49:45 UTC 1 Fresno 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/1223082 January 25, 2021 - 12:45:00 UTC January 25, 2021 - 12:45:00 UTC
1611575987:1222714 36.72949 -119.82953 1222714 9 January 25, 2021 - 10:18:27 UTC 0 Fresno Our preliminary determination is that your outage was caused by an emergency issue. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1222714 January 25, 2021 - 15:00:00 UTC  
1611575987:1223145 36.7281 -119.77051 1223145 31 January 25, 2021 - 11:17:24 UTC 0 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/1223145 January 25, 2021 - 13:45:00 UTC January 25, 2021 - 13:45:00 UTC
1611575987:1223271 38.87089 -120.86906 1223271 1 January 25, 2021 - 11:33:38 UTC 0 Garden Valley 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/1223271 January 25, 2021 - 15:15:00 UTC January 25, 2021 - 15:15:00 UTC
1611575987:1222991 38.84536 -120.81227 1222991 1 January 25, 2021 - 08:43:28 UTC 0 Garden Valley 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/1222991 January 25, 2021 - 12:15:00 UTC January 25, 2021 - 12:15:00 UTC
1611575987:1223008 38.84632 -120.79492 1223008 93 January 25, 2021 - 11:07:27 UTC 0 Garden Valley 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/1223008 January 25, 2021 - 12:15:00 UTC January 25, 2021 - 12:15:00 UTC
1611575987:1222934 38.90198 -120.85858 1222934 42 January 25, 2021 - 11:16:11 UTC 0 Georgetown 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/1222934 January 25, 2021 - 15:00:00 UTC  
1611575987:1222849 38.90438 -120.83988 1222849 33 January 25, 2021 - 11:13:36 UTC 0 Georgetown 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/1222849 January 25, 2021 - 19:00:00 UTC  
1611575987:1223115 38.8819 -120.83031 1223115 55 January 25, 2021 - 11:15:38 UTC 0 Georgetown 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/1223115 January 25, 2021 - 14:30:00 UTC January 25, 2021 - 14:30:00 UTC
1611575987:1223104 38.86426 -120.83656 1223104 1 January 25, 2021 - 10:29:01 UTC 0 Georgetown 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/1223104 January 25, 2021 - 14:00:00 UTC January 25, 2021 - 14:00:00 UTC
1611575987:1222982 38.89929 -120.85457 1222982 149 January 25, 2021 - 11:04:48 UTC 2 Georgetown 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/1222982 January 25, 2021 - 18:00:00 UTC  
1611575987:1223020 39.15873 -120.96925 1223020 22 January 25, 2021 - 10:12:24 UTC 0 Grass Valley 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/1223020 January 25, 2021 - 12:30:00 UTC January 25, 2021 - 12:30:00 UTC
1611575987:1222950 39.12566 -121.08449 1222950 12 January 25, 2021 - 11:41:45 UTC 0 Grass Valley 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/1222950 January 25, 2021 - 16:00:00 UTC  
1611575987:1223045 39.1527 -121.03813 1223045 22 January 25, 2021 - 10:12:24 UTC 0 Grass Valley 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/1223045 January 25, 2021 - 13:15:00 UTC January 25, 2021 - 13:15:00 UTC
1611575987:1223230 38.89997 -120.90752 1223230 422 January 25, 2021 - 11:51:44 UTC 0 Greenwood 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/1223230 January 25, 2021 - 14:30:00 UTC January 25, 2021 - 14:30:00 UTC
1611575987:1223111 37.81726 -120.12848 1223111 62 January 25, 2021 - 11:49:41 UTC 0 Groveland 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/1223111    
1611575987:1223136 34.95965 -120.57461 1223136 11 January 25, 2021 - 11:39:26 UTC 0 Guadalupe Our preliminary determination is that your outage was caused by an equipment issue. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1223136 January 25, 2021 - 14:15:00 UTC January 25, 2021 - 14:15:00 UTC
1611575987:1222676 36.90297 -121.36352 1222676 9 January 25, 2021 - 05:41:32 UTC 1 Hollister 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/1222676 January 25, 2021 - 15:20:00 UTC  
1611575987:1223243 38.34973 -120.65906 1223243 17 January 25, 2021 - 11:23:55 UTC 0 Jackson 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/1223243    
1611575987:1222625 38.7863 -120.15556 1222625 1 January 25, 2021 - 07:08:42 UTC 1 Kyburz 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/1222625 January 25, 2021 - 16:00:00 UTC  
1611575987:1222683 39.28912 -123.79415 1222683 16 January 25, 2021 - 05:13:33 UTC 2 Little River 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/1222683    
1611575987:1222626 36.97412 -121.98502 1222626 1 January 25, 2021 - 10:02:17 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/1222626 January 25, 2021 - 12:30:00 UTC  
1611575987:1222543 37.10392 -122.04943 1222543 1 January 25, 2021 - 03:01:16 UTC 0 Lompico 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/1222543 January 25, 2021 - 15:00:00 UTC  
1611575987:1222942 37.37399 -122.14172 1222942 1 January 25, 2021 - 11:33:49 UTC 0 Los Altos Hills 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/1222942 January 25, 2021 - 15:00:00 UTC  
1611575987:1222935 37.17347 -122.06285 1222935 24 January 25, 2021 - 10:40:53 UTC 0 Los Gatos Our preliminary determination is that your outage was caused by an equipment issue. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222935 January 26, 2021 - 00:00:00 UTC  
1611575987:1222953 37.16735 -122.03631 1222953 16 January 25, 2021 - 10:44:26 UTC 0 Los Gatos Our preliminary determination is that your outage was caused by an equipment issue. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222953 January 26, 2021 - 00:00:00 UTC  
1611575987:1223011 37.11152 -121.94593 1223011 209 January 25, 2021 - 09:11:48 UTC 0 Los Gatos 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/1223011 January 25, 2021 - 13:00:00 UTC January 25, 2021 - 13:00:00 UTC
1611575987:1223183 38.14008 -120.36983 1223183 6382 January 25, 2021 - 11:48:26 UTC 0 MI Wuk Village 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/1223183    
1611575987:1222930 37.46574 -119.75619 1222930 398 January 25, 2021 - 07:23:26 UTC 0 Mariposa 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/1222930    
1611575987:1222837 37.48328 -119.74451 1222837 3 January 25, 2021 - 06:28:37 UTC 0 Mariposa 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/1222837    
1611575987:1222747 37.49141 -119.82742 1222747 30 January 25, 2021 - 04:47:00 UTC 7 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222747 January 27, 2021 - 04:00:00 UTC  
1611575987:1222746 37.49123 -119.82936 1222746 29 January 25, 2021 - 04:46:36 UTC 1 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222746 January 27, 2021 - 04:00:00 UTC  
1611575987:1222949 37.51635 -119.83542 1222949 223 January 25, 2021 - 11:07:20 UTC 0 Mariposa 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/1222949    
1611575987:1222498 37.49004 -119.81205 1222498 4 January 25, 2021 - 03:08:18 UTC 1 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222498 January 27, 2021 - 04:00:00 UTC  
1611575987:1222499 37.4851 -119.81116 1222499 13 January 25, 2021 - 03:07:18 UTC 3 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222499 January 27, 2021 - 04:00:00 UTC  
1611575987:1223102 37.49736 -119.83379 1223102 83 January 25, 2021 - 10:34:43 UTC 0 Mariposa 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/1223102    
1611575987:1222172 37.49928 -119.83789 1222172 2 January 25, 2021 - 00:09:18 UTC 2 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222172 January 27, 2021 - 04:00:00 UTC  
1611575987:1222171 37.49885 -119.84109 1222171 1 January 25, 2021 - 00:08:12 UTC 1 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222171 January 27, 2021 - 04:00:00 UTC  
1611575987:1222177 37.50156 -119.80196 1222177 2 January 24, 2021 - 17:21:39 UTC 0 Mariposa 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/1222177    
1611575987:1222166 37.46384 -119.76133 1222166 41 January 24, 2021 - 19:39:12 UTC 0 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1222166 January 25, 2021 - 23:00:00 UTC  
1611575987:1222508 37.46785 -119.8241 1222508 8 January 24, 2021 - 22:24:05 UTC 1 Mariposa Our preliminary determination is that your outage was caused by an emergency issue. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222508    
1611575987:1222504 37.47702 -119.8244 1222504 1 January 24, 2021 - 22:24:25 UTC 1 Mariposa Our preliminary determination is that your outage was caused by an emergency issue. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222504    
1611575987:1222506 37.47292 -119.82437 1222506 10 January 24, 2021 - 22:23:34 UTC 3 Mariposa Our preliminary determination is that your outage was caused by an emergency issue. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222506    
1611575987:1222160 37.48996 -119.79041 1222160 39 January 24, 2021 - 19:39:41 UTC 9 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1222160 January 25, 2021 - 23:00:00 UTC  
1611575987:1222162 37.48146 -119.77768 1222162 6 January 24, 2021 - 04:37:06 UTC 1 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222162 January 25, 2021 - 23:00:00 UTC  
1611575987:1222164 37.47461 -119.77278 1222164 7 January 24, 2021 - 04:39:09 UTC 2 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222164 January 25, 2021 - 23:00:00 UTC  
1611575987:1222165 37.46995 -119.76988 1222165 54 January 24, 2021 - 21:52:37 UTC 8 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222165 January 25, 2021 - 23:00:00 UTC  
1611575987:1222158 37.49776 -119.79792 1222158 12 January 24, 2021 - 04:33:43 UTC 1 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1222158 January 25, 2021 - 23:00:00 UTC  
1611575987:1222886 37.47704 -119.81558 1222886 1 January 25, 2021 - 07:12:36 UTC 0 Mariposa 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/1222886    
1611575987:1222357 37.50823 -119.90748 1222357 2 January 24, 2021 - 18:24:02 UTC 1 Mariposa 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/1222357    
1611575987:1222148 37.51362 -119.83044 1222148 27 January 25, 2021 - 00:07:02 UTC 10 Mariposa To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1222148 January 27, 2021 - 04: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);