blocker

10 rows where train_id = 32

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: blocker, unblocker, removed, resolved, status, group_blocked, group_unblocked

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
196 32 32 1616173633 1617139311 Ahmon Dancy Pchelolo 0 1 277795 https://phabricator.wikimedia.org/T277795 resolved -1 2
197 32 32 1616699833 1616754600 Antoine "hashar" Musso Ram202177 0 1 278478 https://phabricator.wikimedia.org/T278478 resolved 2 0
198 32 32 1616700626 1616953387 Timo Tijhof Urbanecm 0 1 278429 https://phabricator.wikimedia.org/T278429 resolved 2 0
199 32 32 1616775226 1616774857 Antoine "hashar" Musso Taavi Väänänen 0 0 278562 https://phabricator.wikimedia.org/T278562 resolved 0 0
200 32 32 1616629554 1616689293 Ahmon Dancy Antoine "hashar" Musso 0 1 278400 https://phabricator.wikimedia.org/T278400 resolved 1 1
201 32 32 1616614159 1616620672 Antoine "hashar" Musso Antoine "hashar" Musso 0 1 278379 https://phabricator.wikimedia.org/T278379 resolved 0 1
202 32 32 1616613700 1616620574 Antoine "hashar" Musso Antoine "hashar" Musso 0 1 278375 https://phabricator.wikimedia.org/T278375 resolved 0 1
203 32 32 1616613944 1616617481 Antoine "hashar" Musso Pchelolo 1 0 278376 https://phabricator.wikimedia.org/T278376 open 0 0
204 32 32 1616569158 1616570966 Amir Sarabadani (WMDE) Amir Sarabadani (WMDE) 1 0 278285 https://phabricator.wikimedia.org/T278285 open 0 0
205 32 32 1616023182 1616076457 Tyler Cipriani Amir Sarabadani (WMDE) 0 1 277722 https://phabricator.wikimedia.org/T277722 resolved -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)
        );