most_recent_snapshot (view)
2 rows
This data as json, CSV (advanced)
id | latitude | longitude | outage | estCustAffected | cluster | cause | crewCurrentStatus | comments | outage_url | currentEtor |
---|---|---|---|---|---|---|---|---|---|---|
1729577309:24142747 | 38.21637 | -85.65111 | 24142747 | 8 | 0 | Trees or limbs in lines | 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/24142747 | ||
1729577309:24046886 | 38.07617 | -84.48941 | 24046886 | 4 | 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/24046886 |
Advanced export
JSON shape: default, array, newline-delimited
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);