most_recent_snapshot (view)

4 rows

View and edit SQL

Suggested facets: cause, comments

estCustAffected

  • 4 4
id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1591250490:20050413 38.21829 -85.54007 20050413 4 0 Scheduled maintenance   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20050413  
1591250490:20050394 38.19174 -85.77929 20050394 4 0 Scheduled maintenance   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/20050394  
1591250490:20050416 38.16273 -85.83494 20050416 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/20050416  
1591250490:20050407 38.25985 -85.78708 20050407 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/20050407  

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 1632.797ms