most_recent_snapshot (view)

4 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1761415696:25134159 38.23178 -85.74944 25134159 8 0 Motor vehicle accident   The previous estimated time of restoration has expired and we are re-evaluating the situation. A revised estimate will be provided as soon as possible. https://lgeku-outages.herokuapp.com/outages/outages/25134159  
1761415696:25134171 38.29266 -85.64556 25134171 21 0 Working to determine cause   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/25134171  
1761415696:25134135 37.86591 -84.66329 25134135 25 0 Working to determine cause   This estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/25134135  
1761415696:25134144 38.04837 -84.63541 25134144 14 0 Working to determine cause   This estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/25134144  

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);