blocker

2 rows where status = "stalled"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
1403 333 333 1702056045 1702073683 Jon Robson Jon Robson 1 0 353071 https://phabricator.wikimedia.org/T353071 stalled -1 -1
1442 344 344 1709545996 1709627498 Jaime Nuche Jaime Nuche 1 0 357101 https://phabricator.wikimedia.org/T357101 stalled -1 -1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE blocker (
            id INTEGER PRIMARY KEY,
            train_id INTEGER NOT NULL,
            blocked INTEGER NOT NULL,
            unblocked INTEGER,
            blocker TEXT NOT NULL,
            unblocker TEXT,
            removed INTEGER NOT NULL,
            resolved INTEGER NOT NULL,
            task INTEGER NOT NULL,
            url TEXT NOT NULL,
            status TEXT NOT NULL,
            group_blocked INTEGER NOT NULL,
            group_unblocked INTEGER,
            CHECK (removed IN (0, 1))
            CHECK (resolved IN (0, 1))
            UNIQUE(train_id,blocked,task)
            FOREIGN KEY(train_id) REFERENCES train(id)
        );