blocker

7 rows where train_id = 72

✎ 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
372 72 72 1558621427 1558621771 Antoine "hashar" Musso Antoine "hashar" Musso 1 0 224227 https://phabricator.wikimedia.org/T224227 duplicate 2 2
373 72 72 1558603378 1558605121 Antoine "hashar" Musso Antoine "hashar" Musso 0 1 224093 https://phabricator.wikimedia.org/T224093 resolved 1 1
374 72 72 1558536200 1558601519 Andre Klapper (WMF) Antoine "hashar" Musso 0 1 224124 https://phabricator.wikimedia.org/T224124 resolved 1 1
375 72 72 1558530936 1558601437 Antoine "hashar" Musso Antoine "hashar" Musso 0 1 224116 https://phabricator.wikimedia.org/T224116 resolved 1 1
376 72 72 1558516712 1558533399 Antoine "hashar" Musso Antoine "hashar" Musso 1 0 224095 https://phabricator.wikimedia.org/T224095 resolved 0 1
377 72 72 1558516499 1558523781 Antoine "hashar" Musso Antoine "hashar" Musso 1 0 224094 https://phabricator.wikimedia.org/T224094 duplicate 0 0
378 72 72 1558450960 1558459818 Antoine "hashar" Musso Sam Reed 0 1 224031 https://phabricator.wikimedia.org/T224031 resolved 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)
        );