most_recent_snapshot (view)

1 row sorted by outage

View and edit SQL

id latitude longitude outage ▼ estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1606479859:20115497 37.34674 -87.48032 20115497 10 0 Scheduled maintenance   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.  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW most_recent_snapshot as
select, latitude, longitude, outage, estCustAffected, cluster, as cause, as crewCurrentStatus, as comments,
    '' || outage as outage_url, currentEtor
from outage_snapshots
    left join cause on outage_snapshots.cause =
    left join comments on outage_snapshots.comments =
    left join crewCurrentStatus on outage_snapshots.crewCurrentStatus =
    snapshot in (select id from snapshots order by id desc limit 1);
Powered by Datasette · Query took 1833.069ms