blocker

9 rows where train_id = 3

✎ 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
42 3 3 1620358958 1620411604 Timo Tijhof James D. Forrester 0 1 282180 https://phabricator.wikimedia.org/T282180 resolved 0 0
43 3 3 1620358951 1620411585 Timo Tijhof James D. Forrester 0 1 282070 https://phabricator.wikimedia.org/T282070 resolved 0 0
44 3 3 1620345778 1620367970 Timo Tijhof Tim Starling 0 1 282122 https://phabricator.wikimedia.org/T282122 resolved 0 0
45 3 3 1620221880 1620248323 Antoine "hashar" Musso Brennen Bearnes 1 0 281981 https://phabricator.wikimedia.org/T281981 resolved 0 1
46 3 3 1620341725 1620341549 Timo Tijhof Timo Tijhof 0 0 282038 https://phabricator.wikimedia.org/T282038 resolved 2 2
47 3 3 1620341557 1620345805 Marius Hoch Timo Tijhof 0 0 282193 https://phabricator.wikimedia.org/T282193 duplicate 2 0
48 3 3 1619808761 1620229595 Jon Robson Brennen Bearnes 1 0 281595 https://phabricator.wikimedia.org/T281595 resolved -1 0
49 3 3 1619635682 1620229539 Tyler Cipriani Brennen Bearnes 1 0 281401 https://phabricator.wikimedia.org/T281401 resolved -1 0
50 3 3 1619687316 1619695978 Taavi Väänänen Marius Hoch 0 1 281450 https://phabricator.wikimedia.org/T281450 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)
        );