blocker

7 rows where train_id = 2

✎ 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
35 2 2 1619711481 1619703849 Lars Wirzenius Lars Wirzenius 1 1 281480 https://phabricator.wikimedia.org/T281480 resolved 1 1
36 2 2 1619687997 1619697711 Lars Wirzenius Lars Wirzenius 1 0 281451 https://phabricator.wikimedia.org/T281451 open 0 0
37 2 2 1619615480 1619682249 Lars Wirzenius Jakob Warkotsch 0 1 281361 https://phabricator.wikimedia.org/T281361 resolved 1 0
38 2 2 1619639154 1619656988 Jeena Huneidi Tim Starling 0 1 281405 https://phabricator.wikimedia.org/T281405 resolved 1 0
39 2 2 1619513924 1619555308 Lars Wirzenius Jeena Huneidi 0 1 281226 https://phabricator.wikimedia.org/T281226 resolved -1 0
40 2 2 1619457324 1619471747 Urbanecm Bartosz Dziewoński 0 1 281180 https://phabricator.wikimedia.org/T281180 resolved -1 -1
41 2 2 1619459711 1619467588 Bartosz Dziewoński Taavi Väänänen 0 1 281184 https://phabricator.wikimedia.org/T281184 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)
        );