train: blocker: 14 rows where status = "declined"

14 rows where status = "declined"

descending

id ▼	train_id	blocked	unblocked	blocker	unblocker	removed	resolved	task	url	status	group_blocked	group_unblocked
129	18 18	1606934334	1606937108	Antoine "hashar" Musso	Timo Tijhof	0	1	269278	https://phabricator.wikimedia.org/T269278	declined	1	1
428	79 79	1563989852	1563989867	Lars Wirzenius	Lars Wirzenius	1	0	228911	https://phabricator.wikimedia.org/T228911	declined	1	1
442	80 80	1564438162	1564448778	Timo Tijhof	Tyler Cipriani	1	1	229285	https://phabricator.wikimedia.org/T229285	declined	-1	-1
467	83 83	1566491760	1566937308	Željko Filipin	Max Semenik	1	0	231029	https://phabricator.wikimedia.org/T231029	declined	-1	0
572	105 105	1553555750	1553557028	Alex Monk	Alex Monk	1	0	219242	https://phabricator.wikimedia.org/T219242	declined	-1	-1
721	138 138	1518724835	1518725136	Mukunda Modell	Mukunda Modell	1	0	187492	https://phabricator.wikimedia.org/T187492	declined	1	1
731	143 143	1521669515	1522095307	Timo Tijhof	Timo Tijhof	1	0	190260	https://phabricator.wikimedia.org/T190260	declined	1	2
733	144 144	1522261654	1522709222	Mukunda Modell	Mukunda Modell	1	0	190954	https://phabricator.wikimedia.org/T190954	declined	0	2
740	145 145	1522709222	1522869753	Mukunda Modell	Mukunda Modell	1	0	190954	https://phabricator.wikimedia.org/T190954	declined	-1	1
767	161 161	1458204556	1458245262	Legoktm	Greg Grossmeier	1	0	121793	https://phabricator.wikimedia.org/T121793	declined	1	1
768	162 162	1458245227	1628285621	Timo Tijhof	Jon Robson	0	1	121793	https://phabricator.wikimedia.org/T121793	declined	-1	-1
790	170 170	1463598270	1463675450	Timo Tijhof	Bartosz Dziewoński	1	0	121793	https://phabricator.wikimedia.org/T121793	declined	-1	-1
814	176 176	1467797308	1467797308	Antoine "hashar" Musso	Antoine "hashar" Musso	1	1	139447	https://phabricator.wikimedia.org/T139447	declined	0	0
1363	319 319	1692891577	1692895024	Tyler Cipriani	Urbanecm	0	1	344929	https://phabricator.wikimedia.org/T344929	declined	1	1

Advanced export

JSON shape: default, array, newline-delimited, object

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