most_recent_snapshot (view)

9 rows sorted by id descending

View and edit SQL

id ▲ latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1594447296:20068925 38.28284 -85.6631 20068925 4 0 Working to determine cause   This estimated time of restoration is based on historical averages of the time required to make similar repairs in this area. We will update the estimate as more information becomes available. Please check back for updates. https://lgeku-outages.herokuapp.com/outages/outages/20068925  
1594447296:20068924 38.06994 -85.66494 20068924 4 0 Damaged equipment   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068924  
1594447296:20068923 36.62934 -83.7046 20068923 14 0 Damaged equipment   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068923  
1594447296:20068921 37.10898 -84.58777 20068921 13 0 Trees or limbs in lines   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068921  
1594447296:20068919 36.92628 -82.48259 20068919 6 0 Trees or limbs in lines   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068919  
1594447296:20068910 36.63063 -83.70489 20068910 4 0 Damaged equipment   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068910  
1594447296:20068845 38.31665 -85.54519 20068845 51 0 Motor vehicle accident   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068845  
1594447296:20068838 38.32074 -85.54612 20068838 219 0 Motor vehicle accident   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068838  
1594447296:20068487 38.17496 -85.73559 20068487 4 0 Working to determine cause   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20068487  

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);
Powered by Datasette · Query took 1997.289ms