blocker
501 rows where group_unblocked = "-1"
This data as json, CSV (advanced)
Suggested facets: removed, resolved, status, group_blocked
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 113 | 15 15 | 1602781750 | 1603148107 | Jon Robson | Jon Robson | 1 | 0 | 256173 | https://phabricator.wikimedia.org/T256173 | open | -1 | -1 |
| 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 |
| 137 | 21 21 | 1609882669 | 1609888612 | skizzerz | Amir Sarabadani (WMDE) | 0 | 1 | 271259 | https://phabricator.wikimedia.org/T271259 | resolved | 0 | -1 |
| 138 | 21 21 | 1609883137 | 1609887961 | Samuel | Sam Reed | 0 | 1 | 271266 | https://phabricator.wikimedia.org/T271266 | resolved | 0 | -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 |
| 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 |
| 152 | 24 24 | 1612212821 | 1612297223 | Ahmon Dancy | Antoine "hashar" Musso | 1 | 0 | 273249 | https://phabricator.wikimedia.org/T273249 | 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 |
| 162 | 25 25 | 1612883617 | 1612988483 | Antoine "hashar" Musso | Mukunda Modell | 0 | 1 | 264391 | https://phabricator.wikimedia.org/T264391 | 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 |
| 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 |
| 205 | 32 32 | 1616023182 | 1616076457 | Tyler Cipriani | Amir Sarabadani (WMDE) | 0 | 1 | 277722 | https://phabricator.wikimedia.org/T277722 | resolved | -1 | -1 |
| 207 | 33 33 | 1617356433 | 1617358630 | Antoine "hashar" Musso | Amir Sarabadani (WMDE) | 1 | 0 | 279127 | https://phabricator.wikimedia.org/T279127 | duplicate | 2 | -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 |
| 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 |
| 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 |
| 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 |
| 272 | 52 52 | 1584684554 | 1587411298 | Manuel Aróstegui | Aaron Schulz | 0 | 1 | 248147 | https://phabricator.wikimedia.org/T248147 | resolved | 2 | -1 |
| 278 | 52 52 | 1584555181 | 1584568427 | Niklas Laxström | Antoine "hashar" Musso | 1 | 0 | 248003 | https://phabricator.wikimedia.org/T248003 | resolved | -1 | -1 |
| 279 | 52 52 | 1584552501 | 1584560258 | Antoine "hashar" Musso | Antoine "hashar" Musso | 1 | 0 | 248006 | https://phabricator.wikimedia.org/T248006 | resolved | -1 | -1 |
| 280 | 52 52 | 1584399962 | 1584542802 | Tyler Cipriani | Antoine "hashar" Musso | 0 | 1 | 233871 | https://phabricator.wikimedia.org/T233871 | resolved | -1 | -1 |
| 287 | 55 55 | 1586221972 | 1586286152 | James D. Forrester | James D. Forrester | 1 | 0 | 249565 | https://phabricator.wikimedia.org/T249565 | resolved | -1 | -1 |
| 288 | 55 55 | 1585856419 | 1586161479 | James D. Forrester | Niklas Laxström | 0 | 1 | 249258 | https://phabricator.wikimedia.org/T249258 | resolved | -1 | -1 |
| 289 | 55 55 | 1586221972 | 1586237887 | James D. Forrester | Amir Sarabadani (WMDE) | 0 | 1 | 249533 | https://phabricator.wikimedia.org/T249533 | resolved | -1 | -1 |
| 306 | 58 58 | 1588156615 | 1588169033 | Niklas Laxström | DannyS712 | 0 | 1 | 251386 | https://phabricator.wikimedia.org/T251386 | resolved | -1 | -1 |
| 314 | 59 59 | 1589296968 | 1589297124 | Tyler Cipriani | James D. Forrester | 1 | 0 | 249963 | https://phabricator.wikimedia.org/T249963 | resolved | -1 | -1 |
| 315 | 59 59 | 1588853633 | 1589268949 | Adam_WMDE | Adam_WMDE | 1 | 0 | 252079 | https://phabricator.wikimedia.org/T252079 | resolved | -1 | -1 |
| 333 | 62 62 | 1591717399 | 1591727871 | Brennen Bearnes | Brennen Bearnes | 0 | 1 | 254824 | https://phabricator.wikimedia.org/T254824 | resolved | -1 | -1 |
| 334 | 62 62 | 1591720112 | 1591724661 | Pchelolo | Pchelolo | 0 | 1 | 254912 | https://phabricator.wikimedia.org/T254912 | resolved | -1 | -1 |
| 335 | 62 62 | 1591651789 | 1591723247 | DannyS712 | Urbanecm | 0 | 1 | 254822 | https://phabricator.wikimedia.org/T254822 | 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)
);