most_recent_snapshot (view)

1 row

View and edit SQL

id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1582869677:20017082 38.11895 -85.67736 20017082 14 0 Motor vehicle accident   The above estimated time of restoration is based on an evaluation of the situation by our technicians.  

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