blocker

16 rows where train_id = 78

✎ 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
412 78 78 1563821513 1563939932 Timo Tijhof Tim Starling 0 1 228462 https://phabricator.wikimedia.org/T228462 resolved 2 2
413 78 78 1563482342 1563771104 Aaron Schulz Tim Starling 0 1 228465 https://phabricator.wikimedia.org/T228465 resolved 1 1
414 78 78 1563485754 1563769045 Timo Tijhof Tim Starling 0 1 227772 https://phabricator.wikimedia.org/T227772 resolved 1 1
415 78 78 1563482164 1563552537 Aaron Schulz James D. Forrester 1 0 225103 https://phabricator.wikimedia.org/T225103 resolved 1 1
416 78 78 1563469187 1563472132 Timo Tijhof Timo Tijhof 1 1 228303 https://phabricator.wikimedia.org/T228303 resolved 1 1
417 78 78 1563463463 1563480923 Antoine "hashar" Musso Aaron Schulz 0 0 228436 https://phabricator.wikimedia.org/T228436 duplicate 2 1
418 78 78 1563458788 1563460273 Lars Wirzenius Lars Wirzenius 1 0 228425 https://phabricator.wikimedia.org/T228425 resolved 1 1
419 78 78 1563450064 1563456022 Lars Wirzenius Lars Wirzenius 1 0 228406 https://phabricator.wikimedia.org/T228406 duplicate 0 0
420 78 78 1563452384 1563455089 Lars Wirzenius Lars Wirzenius 1 0 228417 https://phabricator.wikimedia.org/T228417 resolved 0 0
421 78 78 1563399711 1563448986 Greg Grossmeier Adam Roses Wight 1 0 221812 https://phabricator.wikimedia.org/T221812 resolved 0 0
422 78 78 1563378249 1563448442 Timo Tijhof Filippo Giunchedi 1 0 228292 https://phabricator.wikimedia.org/T228292 open 1 0
423 78 78 1563377632 1563400034 James D. Forrester James D. Forrester 1 1 228290 https://phabricator.wikimedia.org/T228290 resolved 1 0
424 78 78 1563374090 1563382678 Lars Wirzenius David Causse 0 1 228283 https://phabricator.wikimedia.org/T228283 resolved 1 1
425 78 78 1563368906 1563372316 Lars Wirzenius Lars Wirzenius 0 1 228276 https://phabricator.wikimedia.org/T228276 resolved 0 0
426 78 78 1563288599 1563303252 Lars Wirzenius James D. Forrester 1 0 228171 https://phabricator.wikimedia.org/T228171 resolved 0 0
427 78 78 1562884944 1563277928 Greg Grossmeier Timo Tijhof 1 0 227700 https://phabricator.wikimedia.org/T227700 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)
        );