blocker
557 rows where group_blocked = "-1"
This data as json, CSV (advanced)
Suggested facets: removed, resolved, status, group_unblocked
| id ▼ | train_id | blocked | unblocked | blocker | unblocker | removed | resolved | task | url | status | group_blocked | group_unblocked |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 150 150 | 1621362742 | 1621393445 | Ahmon Dancy | Sam Reed | 0 | 1 | 283099 | https://phabricator.wikimedia.org/T283099 | resolved | -1 | -1 |
| 2 | 150 150 | 1621362742 | 1621393409 | Ahmon Dancy | Sam Reed | 0 | 1 | 283098 | https://phabricator.wikimedia.org/T283098 | resolved | -1 | -1 |
| 19 | 1 1 | 1618261727 | 1618347360 | Bartosz Dziewoński | Urbanecm | 1 | 0 | 279604 | https://phabricator.wikimedia.org/T279604 | resolved | -1 | 0 |
| 20 | 1 1 | 1618246933 | 1618261727 | Urbanecm | Bartosz Dziewoński | 1 | 0 | 279949 | https://phabricator.wikimedia.org/T279949 | duplicate | -1 | -1 |
| 21 | 1 1 | 1617836796 | 1617927590 | Dan Duvall | Elena | 0 | 1 | 279113 | https://phabricator.wikimedia.org/T279113 | resolved | -1 | -1 |
| 22 | 1 1 | 1617644389 | 1617734180 | Jon Robson | Jon Robson | 0 | 1 | 279008 | https://phabricator.wikimedia.org/T279008 | resolved | -1 | -1 |
| 24 | 151 151 | 1623162601 | 1623342842 | Bartosz Dziewoński | Peter Pelberg | 0 | 1 | 284567 | https://phabricator.wikimedia.org/T284567 | resolved | -1 | 1 |
| 27 | 151 151 | 1623097391 | 1623171894 | Bartosz Dziewoński | Jon Robson | 1 | 0 | 284496 | https://phabricator.wikimedia.org/T284496 | resolved | -1 | -1 |
| 30 | 152 152 | 1623376972 | 1624388512 | Sam Reed | Dan Duvall | 1 | 0 | 271011 | https://phabricator.wikimedia.org/T271011 | open | -1 | -1 |
| 31 | 152 152 | 1623978068 | 1624386627 | Timo Tijhof | Dan Duvall | 1 | 0 | 285118 | https://phabricator.wikimedia.org/T285118 | resolved | -1 | -1 |
| 32 | 152 152 | 1623352746 | 1624269580 | Jeena Huneidi | Amir Sarabadani (WMDE) | 0 | 1 | 284777 | https://phabricator.wikimedia.org/T284777 | resolved | -1 | -1 |
| 33 | 152 152 | 1623999533 | 1624032721 | Amir Sarabadani (WMDE) | Zabe | 1 | 0 | 285125 | https://phabricator.wikimedia.org/T285125 | duplicate | -1 | -1 |
| 34 | 152 152 | 1624001329 | 1624031938 | AlexisJazz | Zabe | 0 | 1 | 285127 | https://phabricator.wikimedia.org/T285127 | resolved | -1 | -1 |
| 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 |
| 48 | 3 3 | 1619808761 | 1620229595 | Jon Robson | Brennen Bearnes | 1 | 0 | 281595 | https://phabricator.wikimedia.org/T281595 | resolved | -1 | 0 |
| 49 | 3 3 | 1619635682 | 1620229539 | Tyler Cipriani | Brennen Bearnes | 1 | 0 | 281401 | https://phabricator.wikimedia.org/T281401 | resolved | -1 | 0 |
| 50 | 3 3 | 1619687316 | 1619695978 | Taavi Väänänen | Marius Hoch | 0 | 1 | 281450 | https://phabricator.wikimedia.org/T281450 | resolved | -1 | -1 |
| 56 | 148 148 | 1620666571 | 1620692677 | Urbanecm | Ahmon Dancy | 0 | 1 | 282206 | https://phabricator.wikimedia.org/T282206 | resolved | -1 | -1 |
| 57 | 148 148 | 1620359734 | 1620688237 | Timo Tijhof | James D. Forrester | 0 | 1 | 282207 | https://phabricator.wikimedia.org/T282207 | resolved | -1 | -1 |
| 58 | 148 148 | 1620239172 | 1620341549 | Eric Gardner | Timo Tijhof | 1 | 1 | 282038 | https://phabricator.wikimedia.org/T282038 | resolved | -1 | -1 |
| 63 | 149 149 | 1621273110 | 1621279696 | James D. Forrester | Jon Robson | 1 | 0 | 283014 | https://phabricator.wikimedia.org/T283014 | resolved | -1 | -1 |
| 64 | 149 149 | 1620937214 | 1621014350 | Ahmon Dancy | Umherirrender | 0 | 1 | 282825 | https://phabricator.wikimedia.org/T282825 | resolved | -1 | -1 |
| 77 | 6 6 | 1595959797 | 1595962623 | Brennen Bearnes | James D. Forrester | 0 | 1 | 259023 | https://phabricator.wikimedia.org/T259023 | resolved | -1 | -1 |
| 78 | 7 7 | 1597157332 | 1597168113 | Antoine "hashar" Musso | Tyler Cipriani | 0 | 1 | 260145 | https://phabricator.wikimedia.org/T260145 | resolved | -1 | 0 |
| 80 | 7 7 | 1596713504 | 1596876820 | Lucas Werkmeister (WMDE) | Taavi Väänänen | 1 | 0 | 259744 | https://phabricator.wikimedia.org/T259744 | resolved | -1 | -1 |
| 82 | 10 10 | 1599522787 | 1599591145 | Sam Reed | Sam Reed | 1 | 0 | 262213 | https://phabricator.wikimedia.org/T262213 | resolved | -1 | -1 |
| 86 | 11 11 | 1600159716 | 1600251334 | Lars Wirzenius | Lars Wirzenius | 0 | 1 | 262900 | https://phabricator.wikimedia.org/T262900 | resolved | -1 | -1 |
| 87 | 11 11 | 1600199369 | 1600199389 | Timo Tijhof | Timo Tijhof | 0 | 1 | 258001 | https://phabricator.wikimedia.org/T258001 | resolved | -1 | -1 |
| 93 | 12 12 | 1600253549 | 1600634879 | James D. Forrester | DannyS712 | 1 | 1 | 263014 | https://phabricator.wikimedia.org/T263014 | resolved | -1 | -1 |
| 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 |
| 99 | 13 13 | 1601416178 | 1601580359 | Mukunda Modell | Mukunda Modell | 1 | 0 | 260349 | https://phabricator.wikimedia.org/T260349 | resolved | -1 | -1 |
| 108 | 14 14 | 1602192151 | 1602619164 | Antoine "hashar" Musso | Dan Duvall | 1 | 1 | 263177 | https://phabricator.wikimedia.org/T263177 | resolved | -1 | 0 |
| 113 | 15 15 | 1602781750 | 1603148107 | Jon Robson | Jon Robson | 1 | 0 | 256173 | https://phabricator.wikimedia.org/T256173 | open | -1 | -1 |
| 116 | 16 16 | 1604600545 | 1604610157 | C. Scott Ananian | Brennen Bearnes | 0 | 1 | 267362 | https://phabricator.wikimedia.org/T267362 | resolved | -1 | 0 |
| 117 | 16 16 | 1604386322 | 1604586763 | Niklas Laxström | C. Scott Ananian | 0 | 1 | 267091 | https://phabricator.wikimedia.org/T267091 | resolved | -1 | -1 |
| 118 | 16 16 | 1604341128 | 1604597941 | Timo Tijhof | Brennen Bearnes | 1 | 0 | 267033 | https://phabricator.wikimedia.org/T267033 | resolved | -1 | -1 |
| 119 | 16 16 | 1604448553 | 1604448596 | Timo Tijhof | Timo Tijhof | 1 | 1 | 266311 | https://phabricator.wikimedia.org/T266311 | resolved | -1 | -1 |
| 120 | 16 16 | 1603900069 | 1604517679 | James D. Forrester | Brennen Bearnes | 1 | 0 | 266677 | https://phabricator.wikimedia.org/T266677 | resolved | -1 | -1 |
| 121 | 16 16 | 1604341713 | 1604371409 | Timo Tijhof | Peter Pelberg | 0 | 1 | 267035 | https://phabricator.wikimedia.org/T267035 | resolved | -1 | -1 |
| 122 | 16 16 | 1603289769 | 1603350821 | Niklas Laxström | Niklas Laxström | 0 | 1 | 266135 | https://phabricator.wikimedia.org/T266135 | resolved | -1 | -1 |
| 125 | 18 18 | 1607175103 | 1607179288 | Urbanecm | Urbanecm | 1 | 0 | 269497 | https://phabricator.wikimedia.org/T269497 | open | -1 | -1 |
| 130 | 18 18 | 1605894843 | 1606152253 | Umherirrender | Umherirrender | 0 | 1 | 268360 | https://phabricator.wikimedia.org/T268360 | resolved | -1 | -1 |
| 134 | 20 20 | 1607981028 | 1608057121 | Timo Tijhof | Timo Tijhof | 1 | 0 | 249826 | https://phabricator.wikimedia.org/T249826 | resolved | -1 | -1 |
| 139 | 21 21 | 1609811971 | 1609815689 | James D. Forrester | Legoktm | 0 | 1 | 271182 | https://phabricator.wikimedia.org/T271182 | resolved | -1 | -1 |
| 140 | 21 21 | 1609236263 | 1609243183 | DannyS712 | Taavi Väänänen | 1 | 0 | 270902 | https://phabricator.wikimedia.org/T270902 | resolved | -1 | -1 |
| 141 | 21 21 | 1609236263 | 1608792846 | DannyS712 | Amir Sarabadani (WMDE) | 0 | 0 | 270769 | https://phabricator.wikimedia.org/T270769 | resolved | -1 | -1 |
| 146 | 22 22 | 1610453403 | 1610543450 | Lars Wirzenius | ariel | 0 | 1 | 271804 | https://phabricator.wikimedia.org/T271804 | resolved | -1 | 0 |
| 150 | 23 23 | 1611093601 | 1611150190 | Brennen Bearnes | Niklas Laxström | 0 | 1 | 272428 | https://phabricator.wikimedia.org/T272428 | resolved | -1 | -1 |
| 151 | 23 23 | 1610926769 | 1610927897 | James D. Forrester | Daimona | 0 | 1 | 272248 | https://phabricator.wikimedia.org/T272248 | resolved | -1 | -1 |
| 157 | 24 24 | 1611697459 | 1611784288 | Ahmon Dancy | Aaron Schulz | 0 | 1 | 273006 | https://phabricator.wikimedia.org/T273006 | resolved | -1 | -1 |
| 158 | 24 24 | 1611695713 | 1611705150 | Ahmon Dancy | Ahmon Dancy | 1 | 0 | 273007 | https://phabricator.wikimedia.org/T273007 | resolved | -1 | -1 |
| 159 | 24 24 | 1611697459 | 1611698847 | Ahmon Dancy | Ahmon Dancy | 1 | 0 | 265720 | https://phabricator.wikimedia.org/T265720 | resolved | -1 | -1 |
| 160 | 24 24 | 1611169732 | 1611599562 | Amir Sarabadani (WMDE) | Leszek Manicki | 1 | 1 | 260349 | https://phabricator.wikimedia.org/T260349 | resolved | -1 | -1 |
| 161 | 25 25 | 1612212378 | 1612988669 | Ahmon Dancy | Amir Sarabadani (WMDE) | 0 | 1 | 273242 | https://phabricator.wikimedia.org/T273242 | resolved | -1 | -1 |
| 163 | 25 25 | 1612212378 | 1612346734 | Ahmon Dancy | Antoine "hashar" Musso | 1 | 0 | 273479 | https://phabricator.wikimedia.org/T273479 | open | -1 | -1 |
| 164 | 25 25 | 1612213240 | 1612297223 | Ahmon Dancy | Antoine "hashar" Musso | 1 | 0 | 273249 | https://phabricator.wikimedia.org/T273249 | resolved | -1 | -1 |
| 165 | 25 25 | 1612280145 | 1612296071 | Lucas Werkmeister (WMDE) | Lucas Werkmeister (WMDE) | 0 | 1 | 273622 | https://phabricator.wikimedia.org/T273622 | resolved | -1 | -1 |
| 166 | 25 25 | 1612212378 | 1612220967 | Ahmon Dancy | Urbanecm | 0 | 1 | 273101 | https://phabricator.wikimedia.org/T273101 | resolved | -1 | -1 |
| 167 | 25 25 | 1611953367 | 1612186851 | Ahmon Dancy | Taavi Väänänen | 1 | 0 | 273317 | https://phabricator.wikimedia.org/T273317 | resolved | -1 | -1 |
| 168 | 25 25 | 1611953367 | 1612136843 | Ahmon Dancy | Urbanecm | 1 | 0 | 273296 | https://phabricator.wikimedia.org/T273296 | resolved | -1 | -1 |
| 172 | 26 26 | 1612915497 | 1612988669 | Mukunda Modell | Amir Sarabadani (WMDE) | 0 | 1 | 273242 | https://phabricator.wikimedia.org/T273242 | resolved | -1 | 1 |
| 173 | 26 26 | 1612915448 | 1612988482 | Mukunda Modell | Mukunda Modell | 0 | 1 | 264391 | https://phabricator.wikimedia.org/T264391 | resolved | -1 | 1 |
| 175 | 27 27 | 1613488184 | 1613764199 | Mukunda Modell | Dan Duvall | 1 | 0 | 274589 | https://phabricator.wikimedia.org/T274589 | open | -1 | 2 |
| 176 | 27 27 | 1613488030 | 1613518992 | Mukunda Modell | Jon Robson | 1 | 0 | 274889 | https://phabricator.wikimedia.org/T274889 | resolved | -1 | 0 |
| 177 | 27 27 | 1613080177 | 1613164092 | Timo Tijhof | cwhite | 0 | 1 | 274593 | https://phabricator.wikimedia.org/T274593 | resolved | -1 | -1 |
| 179 | 28 28 | 1613764199 | 1613764790 | Dan Duvall | Dan Duvall | 1 | 0 | 274589 | https://phabricator.wikimedia.org/T274589 | open | -1 | -1 |
| 186 | 30 30 | 1614785344 | 1615247851 | Urbanecm | Brennen Bearnes | 1 | 0 | 276316 | https://phabricator.wikimedia.org/T276316 | resolved | -1 | -1 |
| 187 | 30 30 | 1614979806 | 1614981752 | Lucas Werkmeister (WMDE) | Lucas Werkmeister (WMDE) | 0 | 1 | 276619 | https://phabricator.wikimedia.org/T276619 | resolved | -1 | -1 |
| 189 | 31 31 | 1615924827 | 1615939567 | Amir Sarabadani (WMDE) | Amir Sarabadani (WMDE) | 0 | 1 | 277362 | https://phabricator.wikimedia.org/T277362 | resolved | -1 | -1 |
| 190 | 31 31 | 1615924569 | 1615924827 | Brennen Bearnes | Amir Sarabadani (WMDE) | 1 | 0 | 277593 | https://phabricator.wikimedia.org/T277593 | duplicate | -1 | -1 |
| 191 | 31 31 | 1615848351 | 1615919036 | Timo Tijhof | Ahmon Dancy | 1 | 0 | 277056 | https://phabricator.wikimedia.org/T277056 | resolved | -1 | -1 |
| 192 | 31 31 | 1615802716 | 1615816071 | Daimona | Daimona | 1 | 1 | 277302 | https://phabricator.wikimedia.org/T277302 | resolved | -1 | -1 |
| 193 | 31 31 | 1615472064 | 1615854879 | Timo Tijhof | Roan Kattouw | 1 | 0 | 277161 | https://phabricator.wikimedia.org/T277161 | resolved | -1 | -1 |
| 194 | 31 31 | 1615482990 | 1615568911 | Brennen Bearnes | Jon Robson | 0 | 1 | 277094 | https://phabricator.wikimedia.org/T277094 | resolved | -1 | -1 |
| 195 | 31 31 | 1615452999 | 1615468704 | Lucas Werkmeister (WMDE) | Lucas Werkmeister (WMDE) | 0 | 1 | 277061 | https://phabricator.wikimedia.org/T277061 | resolved | -1 | -1 |
| 196 | 32 32 | 1616173633 | 1617139311 | Ahmon Dancy | Pchelolo | 0 | 1 | 277795 | https://phabricator.wikimedia.org/T277795 | resolved | -1 | 2 |
| 205 | 32 32 | 1616023182 | 1616076457 | Tyler Cipriani | Amir Sarabadani (WMDE) | 0 | 1 | 277722 | https://phabricator.wikimedia.org/T277722 | resolved | -1 | -1 |
| 210 | 33 33 | 1616617480 | 1616619542 | Pchelolo | Antoine "hashar" Musso | 1 | 0 | 278376 | https://phabricator.wikimedia.org/T278376 | open | -1 | -1 |
| 211 | 33 33 | 1617149122 | 1617205662 | DannyS712 | James D. Forrester | 1 | 0 | 278904 | https://phabricator.wikimedia.org/T278904 | resolved | -1 | -1 |
| 212 | 34 34 | 1617318501 | 1617836796 | Jon Robson | Dan Duvall | 1 | 0 | 279113 | https://phabricator.wikimedia.org/T279113 | resolved | -1 | 1 |
| 214 | 34 34 | 1617222189 | 1617644389 | Jon Robson | Jon Robson | 1 | 0 | 279008 | https://phabricator.wikimedia.org/T279008 | resolved | -1 | -1 |
| 219 | 36 36 | 1570898933 | 1571061723 | Timo Tijhof | Sam Reed | 0 | 1 | 235316 | https://phabricator.wikimedia.org/T235316 | resolved | -1 | -1 |
| 232 | 41 41 | 1575978794 | 1576019233 | Amir Sarabadani (WMDE) | Agustín Bou | 0 | 1 | 240316 | https://phabricator.wikimedia.org/T240316 | resolved | -1 | 0 |
| 233 | 41 41 | 1576001770 | 1576016564 | James D. Forrester | James D. Forrester | 0 | 1 | 240345 | https://phabricator.wikimedia.org/T240345 | resolved | -1 | 0 |
| 234 | 41 41 | 1576001782 | 1576001927 | James D. Forrester | James D. Forrester | 0 | 1 | 240248 | https://phabricator.wikimedia.org/T240248 | resolved | -1 | -1 |
| 241 | 44 44 | 1578958542 | 1578960383 | Timo Tijhof | Jon Robson | 1 | 0 | 237050 | https://phabricator.wikimedia.org/T237050 | resolved | -1 | -1 |
| 245 | 45 45 | 1579354413 | 1579512133 | Daimona | Leszek Manicki | 0 | 1 | 243122 | https://phabricator.wikimedia.org/T243122 | resolved | -1 | -1 |
| 247 | 46 46 | 1581098165 | 1581345637 | Timo Tijhof | Michael Holloway | 0 | 1 | 244591 | https://phabricator.wikimedia.org/T244591 | resolved | -1 | -1 |
| 249 | 46 46 | 1580473005 | 1580926941 | Lucas Werkmeister (WMDE) | James D. Forrester | 1 | 0 | 244019 | https://phabricator.wikimedia.org/T244019 | open | -1 | 0 |
| 257 | 47 47 | 1581071238 | 1581092689 | Adam_WMDE | Adam_WMDE | 0 | 1 | 244562 | https://phabricator.wikimedia.org/T244562 | resolved | -1 | -1 |
| 258 | 47 47 | 1580994578 | 1581003455 | Timo Tijhof | Anomie | 1 | 1 | 244440 | https://phabricator.wikimedia.org/T244440 | resolved | -1 | -1 |
| 260 | 48 48 | 1581625555 | 1581708557 | Dan Duvall | James D. Forrester | 0 | 1 | 245062 | https://phabricator.wikimedia.org/T245062 | resolved | -1 | -1 |
| 261 | 49 49 | 1582211759 | 1582298393 | Timo Tijhof | Jason Linehan | 0 | 1 | 235189 | https://phabricator.wikimedia.org/T235189 | resolved | -1 | -1 |
| 264 | 50 50 | 1583146314 | 1583163171 | Michael Große (WMDE) | Lucas Werkmeister (WMDE) | 0 | 1 | 246643 | https://phabricator.wikimedia.org/T246643 | resolved | -1 | -1 |
| 276 | 52 52 | 1584556124 | 1584576993 | Niklas Laxström | James D. Forrester | 0 | 1 | 248010 | https://phabricator.wikimedia.org/T248010 | resolved | -1 | 0 |
| 278 | 52 52 | 1584555181 | 1584568427 | Niklas Laxström | Antoine "hashar" Musso | 1 | 0 | 248003 | https://phabricator.wikimedia.org/T248003 | resolved | -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)
);