blocker

10 rows where status = "progress"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: train_id, blocker, unblocker, removed, resolved, task, url, 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
1569 392 392 1741395101 1741701012 SecurityPatchBot Lucas Werkmeister (WMDE) 1 0 387691 https://phabricator.wikimedia.org/T387691 progress -1 -1
1579 394 394 1742604665 1743065091 SecurityPatchBot Andre Klapper (WMF) 1 0 389235 https://phabricator.wikimedia.org/T389235 progress -1 0
1583 395 395 1743069905 1743077668 SecurityPatchBot WBrown (WMF) 1 0 389235 https://phabricator.wikimedia.org/T389235 progress -1 -1
1604 402 402 1748044365 1748044365 SecurityPatchBot SecurityPatchBot 0 1 392341 https://phabricator.wikimedia.org/T392341 progress -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)
        );