most_recent_snapshot (view)

16 rows

View and edit SQL

id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1611167778:21003632 38.31367 -85.49699 21003632 18 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/21003632  
1611167778:21003620 38.34027 -85.59669 21003620 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/21003620  
1611167778:21003647 38.20246 -85.5771 21003647 29 0 Working to determine cause   We are aware of outages in this area and will provide an estimated time of restoration as soon as possible. https://lgeku-outages.herokuapp.com/outages/outages/21003647  
1611167778:21003617 38.18632 -85.44522 21003617 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/21003617  
1611167778:21003612 38.24758 -85.81383 21003612 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/21003612  
1611167778:21003574 38.23936 -85.72805 21003574 11 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/21003574  
1611167778:21003551 38.23497 -85.74106 21003551 21 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/21003551  
1611167778:21003637 38.20608 -85.63404 21003637 7 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/21003637  
1611167778:21003587 38.02673 -84.48589 21003587 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/21003587  
1611167778:21003628 38.02407 -84.54971 21003628 9 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/21003628  
1611167778:21003570 37.98891 -84.47794 21003570 12 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/21003570  
1611167778:21003563 37.97184 -84.47671 21003563 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/21003563  
1611167778:21003638 37.99601 -84.19498 21003638 8 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/21003638  
1611167778:21003645 38.55058 -83.82778 21003645 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/21003645  
1611167778:21003636 38.73743 -85.05773 21003636 5 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. https://lgeku-outages.herokuapp.com/outages/outages/21003636  
1611167778:21003634 36.60586 -83.71728 21003634 12 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/21003634  

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