most_recent_snapshot (view)

34 rows

View and edit SQL

id latitude longitude outage estCustAffected lastUpdateTime hazardFlag region cause crewCurrentStatus outage_url currentEtor autoEtor
1576668625:744697 35.39905 -118.99249 744697 1 December 18, 2019 - 05:16:17 UTC 1 Bakersfield 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/outage/744697    
1576668625:744791 36.31812 -121.86406 744791 1 December 18, 2019 - 08:04:32 UTC 1 Big sur 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/outage/744791 December 18, 2019 - 15:00:00 UTC  
1576668625:745063 40.49751 -123.60802 745063 1 December 18, 2019 - 10:09:56 UTC 1 Bridgeville 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/outage/745063 December 18, 2019 - 23:30:00 UTC  
1576668625:745090 35.55058 -121.07596 745090 5 December 18, 2019 - 10:49:04 UTC 0 Cambria 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/outage/745090 December 18, 2019 - 13:30:00 UTC December 18, 2019 - 13:30:00 UTC
1576668625:745024 37.10466 -120.28044 745024 5 December 18, 2019 - 09:59:22 UTC 0 Chowchilla 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/outage/745024 December 18, 2019 - 17:00:00 UTC  
1576668625:745099 39.15762 -123.70408 745099 1 December 18, 2019 - 11:21:05 UTC 0 Elk 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/outage/745099    
1576668625:745087 37.76215 -120.99583 745087 297 December 18, 2019 - 11:20:13 UTC 0 Escalon 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/outage/745087 December 18, 2019 - 13:30:00 UTC December 18, 2019 - 13:30:00 UTC
1576668625:745097 37.05114 -122.07404 745097 1 December 18, 2019 - 10:57:20 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/outage/745097 December 18, 2019 - 15:30:00 UTC December 18, 2019 - 15:30:00 UTC
1576668625:745066 37.05114 -122.07404 745066 3 December 18, 2019 - 07:18:43 UTC 0 Felton 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/outage/745066 December 18, 2019 - 14:00:00 UTC  
1576668625:744993 35.12527 -120.62684 744993 22 December 18, 2019 - 11:10:27 UTC 0 Grover Beach 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/outage/744993 December 18, 2019 - 12:00:00 UTC  
1576668625:745084 39.66421 -123.47713 745084 4 December 18, 2019 - 11:15:46 UTC 0 Laytonville 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/outage/745084 December 18, 2019 - 14:15:00 UTC December 18, 2019 - 14:15:00 UTC
1576668625:731381 39.1915 -121.57043 731381 1 December 06, 2019 - 17:52:48 UTC 0 Marysville 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/outage/731381 December 21, 2019 - 02:00:00 UTC  
1576668625:744916 37.90879 -122.5475 744916 131 December 18, 2019 - 09:04:54 UTC 3 Mill Valley Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is en route to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/744916 December 18, 2019 - 12:00:00 UTC  
1576668625:745007 37.90879 -122.5475 745007 268 December 18, 2019 - 09:16:59 UTC 0 Mill 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/outage/745007 December 18, 2019 - 12:00:00 UTC  
1576668625:745096 40.22597 -123.79081 745096 15 December 18, 2019 - 11:07:32 UTC 0 Myers Flat 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/outage/745096    
1576668625:745075 37.84928 -122.2336 745075 46 December 18, 2019 - 10:54:25 UTC 0 Oakland 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/outage/745075 December 18, 2019 - 12:00:00 UTC  
1576668625:745080 37.68964 -121.87861 745080 31 December 18, 2019 - 10:02:08 UTC 0 Pleasanton 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/outage/745080 December 18, 2019 - 13:15:00 UTC December 18, 2019 - 13:15:00 UTC
1576668625:744701 37.68965 -121.87864 744701 0 December 18, 2019 - 09:32:07 UTC 0 Pleasanton 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/outage/744701 December 18, 2019 - 13:00:00 UTC  
1576668625:744948 35.36273 -119.17943 744948 1 December 18, 2019 - 08:19:45 UTC 1 Rosedale 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/outage/744948 December 18, 2019 - 13:00:00 UTC  
1576668625:744357 37.99926 -122.57435 744357 10 December 18, 2019 - 08:24:47 UTC 0 San Anselmo 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/outage/744357 December 18, 2019 - 14:00:00 UTC  
1576668625:745082 37.99908 -122.57322 745082 11 December 18, 2019 - 10:43:03 UTC 0 San Anselmo 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/outage/745082 December 18, 2019 - 14:00:00 UTC  
1576668625:745094 37.33175 -121.79706 745094 17 December 18, 2019 - 10:20:51 UTC 0 San Jose 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/outage/745094 December 18, 2019 - 13:45:00 UTC December 18, 2019 - 13:45:00 UTC
1576668625:744973 37.26904 -121.80782 744973 14 December 18, 2019 - 10:00:07 UTC 0 San Jose 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/outage/744973 December 18, 2019 - 15:00:00 UTC  
1576668625:744974 37.26905 -121.80564 744974 1 December 18, 2019 - 10:00:19 UTC 0 San Jose 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/outage/744974 December 18, 2019 - 15:00:00 UTC  
1576668625:745065 37.33727 -121.89468 745065 1 December 18, 2019 - 06:48:00 UTC 0 San Jose 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/outage/745065 December 18, 2019 - 13:00:00 UTC  
1576668625:744665 36.98825 -122.01353 744665 1 December 18, 2019 - 03:18:47 UTC 0 Santa Cruz 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/outage/744665 December 18, 2019 - 20:00:00 UTC  
1576668625:744349 38.55399 -122.72062 744349 35 December 18, 2019 - 00:45:10 UTC 0 Santa Rosa 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/outage/744349 December 18, 2019 - 00:30:00 UTC  
1576668625:745077 40.4551 -124.06042 745077 8 December 18, 2019 - 11:24:13 UTC 0 Scotia 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/outage/745077 December 18, 2019 - 12:15:00 UTC December 18, 2019 - 12:15:00 UTC
1576668625:744956 37.06603 -121.99688 744956 59 December 18, 2019 - 06:17:41 UTC 0 Scotts Valley 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/outage/744956 December 18, 2019 - 15:00:00 UTC  
1576668625:744159 38.40746 -122.9058 744159 1 December 17, 2019 - 16:10:54 UTC 0 Sebastopol 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/outage/744159 December 18, 2019 - 00:00:00 UTC  
1576668625:734331 38.00595 -121.39269 734331 2 December 16, 2019 - 15:52:06 UTC 0 Stockton 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/outage/734331 December 20, 2019 - 23:30:00 UTC  
1576668625:745044 38.03697 -121.28601 745044 10 December 18, 2019 - 10:36:49 UTC 0 Stockton 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/outage/745044 December 18, 2019 - 17:30:00 UTC  
1576668625:745095 38.07576 -122.23056 745095 573 December 18, 2019 - 11:24:11 UTC 2 Vallejo 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/outage/745095 December 18, 2019 - 14:15:00 UTC December 18, 2019 - 14:15:00 UTC
1576668625:745092 37.38605 -120.61356 745092 221 December 18, 2019 - 11:25:55 UTC 0 Winton 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/outage/745092 December 18, 2019 - 13:15:00 UTC December 18, 2019 - 13:15:00 UTC

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/outage/' || 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)
Powered by Datasette · Query took 6203.836ms · About: About this site