blocker

6 rows where status = "progress"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: train_id, blocker, unblocker, resolved, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
1133 249 249 1646914423 1646941303 Xiplus Ahmon Dancy 1 0 303509 https://phabricator.wikimedia.org/T303509 progress 1 1
1282 288 288 1672907072 1672922251 AmandaNP Amir Sarabadani 1 0 326293 https://phabricator.wikimedia.org/T326293 progress 1 1
1336 312 312 1687546754 1687889122 James D. Forrester Brennen Bearnes 1 0 315036 https://phabricator.wikimedia.org/T315036 progress -1 -1
1337 312 312 1687841756 1687888719 Antoine Musso Brennen Bearnes 1 0 250720 https://phabricator.wikimedia.org/T250720 progress -1 -1
1414 337 337 1705511935 1705569215 James D. Forrester WBrown (WMF) 1 0 355243 https://phabricator.wikimedia.org/T355243 progress 1 1
1421 340 340 1707419005 1707419476 Chris Danis cwhite 1 1 357050 https://phabricator.wikimedia.org/T357050 progress 0 0

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)
        );