most_recent_snapshot (view)

11 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1749256227:25076536 36.91638 -82.29308 25076536 4 0 Weather-related   This estimated time of restoration is based upon the time it usually takes to restore service for the type of outage reported. We will continue to update the estimate as more information becomes available. Please check back for updates. https://lgeku-outages.herokuapp.com/outages/outages/25076536  
1749256227:25076540 37.03364 -82.66896 25076540 5 0 Weather-related   This estimated time of restoration is based upon the time it usually takes to restore service for the type of outage reported. We will continue to update the estimate as more information becomes available. Please check back for updates. https://lgeku-outages.herokuapp.com/outages/outages/25076540  
1749256227:25076515 37.74534 -84.29932 25076515 7 0 Trees or limbs in lines   This estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/25076515  
1749256227:25076541 37.13928 -84.62705 25076541 35 0 Weather-related   We are aware of outages in this area and will provide an estimated time of restoration as soon as possible. https://lgeku-outages.herokuapp.com/outages/outages/25076541  
1749256227:25076534 37.77413 -84.85764 25076534 4 0 Weather-related   This estimated time of restoration is based upon the time it usually takes to restore service for the type of outage reported. We will continue to update the estimate as more information becomes available. Please check back for updates. https://lgeku-outages.herokuapp.com/outages/outages/25076534  
1749256227:25076539 37.98987 -84.51171 25076539 4 0 Weather-related   This estimated time of restoration is based upon the time it usually takes to restore service for the type of outage reported. We will continue to update the estimate as more information becomes available. Please check back for updates. https://lgeku-outages.herokuapp.com/outages/outages/25076539  
1749256227:25076543 38.19922 -85.6573 25076543 4 0 Weather-related   We are aware of outages in this area and will provide an estimated time of restoration as soon as possible. https://lgeku-outages.herokuapp.com/outages/outages/25076543  
1749256227:25076535 38.23638 -85.71464 25076535 12 0 Trees or limbs in lines   This estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/25076535  
1749256227:25076506 37.77867 -85.38246 25076506 4 0 Damaged equipment   This estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/25076506  
1749256227:25076524 37.18512 -87.54722 25076524 211 0 Weather-related   This estimated time of restoration is based upon the time it usually takes to restore service for the type of outage reported. We will continue to update the estimate as more information becomes available. Please check back for updates. https://lgeku-outages.herokuapp.com/outages/outages/25076524  
1749256227:25076503 37.55411 -87.98995 25076503 4 0 Weather-related   This estimated time of restoration is based upon the time it usually takes to restore service for the type of outage reported. We will continue to update the estimate as more information becomes available. Please check back for updates. https://lgeku-outages.herokuapp.com/outages/outages/25076503  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW most_recent_snapshot as
select
    outage_snapshots.id, latitude, longitude, outage, estCustAffected, cluster,
    cause.name as cause, crewCurrentStatus.name as crewCurrentStatus, comments.name as comments,
    'https://lgeku-outages.herokuapp.com/outages/outages/' || outage as outage_url, currentEtor
from outage_snapshots
    left join cause on outage_snapshots.cause = cause.id
    left join comments on outage_snapshots.comments = comments.id
    left join crewCurrentStatus on outage_snapshots.crewCurrentStatus = crewCurrentStatus.id
where
    snapshot in (select id from snapshots order by id desc limit 1);