outage_snapshots
153,876 rows where cause = 1
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [outage_snapshots] ( [id] TEXT PRIMARY KEY, [outage] INTEGER REFERENCES [outages]([id]), [snapshot] INTEGER REFERENCES [snapshots]([id]), [cluster] INTEGER, [currentEtor] INTEGER, [estCustAffected] INTEGER, [latitude] TEXT, [longitude] TEXT, [comments] INTEGER REFERENCES [comments]([id]), [cause] INTEGER REFERENCES [cause]([id]), [crewCurrentStatus] INTEGER REFERENCES [crewCurrentStatus]([id]), [source] TEXT );