blocker

9 rows where train_id = 13

✎ 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
94 13 13 1601890183 1602619127 Antoine "hashar" Musso Dan Duvall 1 0 264369 https://phabricator.wikimedia.org/T264369 resolved -1 2
95 13 13 1601590739 1601890421 Urbanecm Antoine "hashar" Musso 1 1 264370 https://phabricator.wikimedia.org/T264370 resolved -1 -1
96 13 13 1602193114 1602294892 Antoine "hashar" Musso Gergő Tisza 0 1 264799 https://phabricator.wikimedia.org/T264799 resolved -1 -1
97 13 13 1601586516 1601625595 Timo Tijhof Daniel Kinzler 0 1 264363 https://phabricator.wikimedia.org/T264363 resolved 1 -1
98 13 13 1601510286 1601580681 Timo Tijhof Pchelolo 0 1 264257 https://phabricator.wikimedia.org/T264257 resolved 1 -1
99 13 13 1601416178 1601580359 Mukunda Modell Mukunda Modell 1 0 260349 https://phabricator.wikimedia.org/T260349 resolved -1 -1
100 13 13 1601500162 1601578854 Mukunda Modell Mukunda Modell 0 1 264243 https://phabricator.wikimedia.org/T264243 duplicate 1 -1
101 13 13 1601510240 1601510322 Timo Tijhof Timo Tijhof 1 0 263851 https://phabricator.wikimedia.org/T263851 open 1 1
102 13 13 1601500181 1601503601 Mukunda Modell Chris Danis 0 0 264241 https://phabricator.wikimedia.org/T264241 duplicate 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)
        );