blocker

12 rows where status = "invalid"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ train_id blocked unblocked blocker unblocker removed resolved task url status group_blocked group_unblocked
67 5 5 1596474434 1596475521 Brennen Bearnes Brennen Bearnes 1 0 259536 https://phabricator.wikimedia.org/T259536 invalid 1 1
347 67 67 1594917925 1594925492 DannyS712 James D. Forrester 1 0 258203 https://phabricator.wikimedia.org/T258203 invalid 2 2
398 76 76 1561577987 1561607144 Andre Klapper (WMF) James D. Forrester 0 1 226662 https://phabricator.wikimedia.org/T226662 invalid 1 1
521 93 93 1544536334 1544536567 Željko Filipin Željko Filipin 0 1 211689 https://phabricator.wikimedia.org/T211689 invalid -1 -1
551 104 104 1553202135 1553259888 Timo Tijhof Adam_WMDE 0 1 218950 https://phabricator.wikimedia.org/T218950 invalid 2 2
580 106 106 1553875509 1553884064 Roan Kattouw Roan Kattouw 0 1 219644 https://phabricator.wikimedia.org/T219644 invalid -1 -1
671 128 128 1539788520 1540395278 Klaas Skelte van der Werf Mukunda Modell 0 1 207288 https://phabricator.wikimedia.org/T207288 invalid -1 2
679 128 128 1538599139 1538599176 Mukunda Modell Mukunda Modell 0 1 206167 https://phabricator.wikimedia.org/T206167 invalid -1 -1
769 163 163 1458922417 1459278070 Greg Grossmeier Greg Grossmeier 0 1 130896 https://phabricator.wikimedia.org/T130896 invalid -1 -1
931 209 209 1492020412 1492023699 Timo Tijhof Jon Robson 1 1 162824 https://phabricator.wikimedia.org/T162824 invalid 0 0
1002 228 228 1630014419 1630019917 Brennen Bearnes AlexisJazz 1 1 289792 https://phabricator.wikimedia.org/T289792 invalid -1 -1
1255 278 278 1664516991 1664526653 Rohat Bakay Andre Klapper (WMF) 1 1 318997 https://phabricator.wikimedia.org/T318997 invalid 2 2

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)
        );