Last active
July 19, 2018 13:28
-
-
Save PaulC91/4d5fb65b44ca0fc95a9681ad50fd1c5d to your computer and use it in GitHub Desktop.
Revisions
-
PaulC91 renamed this gist
Jun 13, 2018 . 1 changed file with 0 additions and 0 deletions.There are no files selected for viewing
File renamed without changes. -
PaulC91 renamed this gist
Jun 13, 2018 . 1 changed file with 0 additions and 0 deletions.There are no files selected for viewing
File renamed without changes. -
PaulC91 revised this gist
Jun 13, 2018 . 1 changed file with 737 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,737 @@ id,Player,Country,Club 1,Essam El-Hadary (captain),Egypt,Al-Taawoun 2,Ali Gabr,Egypt,West Bromwich Albion 3,Ahmed Elmohamady,Egypt,Aston Villa 4,Omar Gaber,Egypt,Los Angeles FC 5,Sam Morsy,Egypt,Wigan Athletic 6,Ahmed Hegazi,Egypt,West Bromwich Albion 7,Ahmed Fathy,Egypt,Al Ahly 8,Tarek Hamed,Egypt,Zamalek 9,Marwan Mohsen,Egypt,Al Ahly 10,Mohamed Salah,Egypt,Liverpool 11,Kahraba,Egypt,Al-Ittihad 12,Ayman Ashraf,Egypt,Al Ahly 13,Mohamed Abdel-Shafy,Egypt,Al-Fateh 14,Ramadan Sobhi,Egypt,Stoke City 15,Mahmoud Hamdy,Egypt,Zamalek 16,Sherif Ekramy,Egypt,Al Ahly 17,Mohamed Elneny,Egypt,Arsenal 18,Shikabala,Egypt,Al-Raed 19,Abdallah Said,Egypt,KuPS 20,Saad Samir,Egypt,Al Ahly 21,Trézéguet,Egypt,Kasımpaşa 22,Amr Warda,Egypt,Atromitos 23,Mohamed El-Shenawy,Egypt,Al Ahly 24,Igor Akinfeev (captain),Russia,CSKA Moscow 25,Mário Fernandes,Russia,CSKA Moscow 26,Ilya Kutepov,Russia,Spartak Moscow 27,Sergei Ignashevich,Russia,CSKA Moscow 28,Andrei Semyonov,Russia,Akhmat Grozny 29,Denis Cheryshev,Russia,Villarreal 30,Daler Kuzyayev,Russia,Zenit Saint Petersburg 31,Yury Gazinsky,Russia,Krasnodar 32,Alan Dzagoev,Russia,CSKA Moscow 33,Fyodor Smolov,Russia,Krasnodar 34,Roman Zobnin,Russia,Spartak Moscow 35,Andrey Lunyov,Russia,Zenit Saint Petersburg 36,Fyodor Kudryashov,Russia,Rubin Kazan 37,Vladimir Granat,Russia,Rubin Kazan 38,Aleksei Miranchuk,Russia,Lokomotiv Moscow 39,Anton Miranchuk,Russia,Lokomotiv Moscow 40,Aleksandr Golovin,Russia,CSKA Moscow 41,Yuri Zhirkov,Russia,Zenit Saint Petersburg 42,Aleksandr Samedov,Russia,Spartak Moscow 43,Vladimir Gabulov,Russia,Club Brugge 44,Aleksandr Yerokhin,Russia,Zenit Saint Petersburg 45,Artem Dzyuba,Russia,Arsenal Tula 46,Igor Smolnikov,Russia,Zenit Saint Petersburg 47,Abdullah Al-Mayouf,Saudi Arabia,Al-Hilal 48,Mansoor Al-Harbi,Saudi Arabia,Al-Ahli 49,Osama Hawsawi (captain),Saudi Arabia,Al-Hilal 50,Ali Al-Bulaihi,Saudi Arabia,Al-Hilal 51,Omar Hawsawi,Saudi Arabia,Al-Nassr 52,Mohammed Al-Breik,Saudi Arabia,Al-Hilal 53,Salman Al-Faraj,Saudi Arabia,Al-Hilal 54,Yahya Al-Shehri,Saudi Arabia,Leganés 55,Hattan Bahebri,Saudi Arabia,Al-Shabab 56,Mohammad Al-Sahlawi,Saudi Arabia,Al-Nassr 57,Abdulmalek Al-Khaibri,Saudi Arabia,Al-Hilal 58,Mohamed Kanno,Saudi Arabia,Al-Hilal 59,Yasser Al-Shahrani,Saudi Arabia,Al-Hilal 60,Abdullah Otayf,Saudi Arabia,Al-Hilal 61,Abdullah Al-Khaibari,Saudi Arabia,Al-Shabab 62,Housain Al-Mogahwi,Saudi Arabia,Al-Ahli 63,Taisir Al-Jassim,Saudi Arabia,Al-Ahli 64,Salem Al-Dawsari,Saudi Arabia,Villarreal 65,Fahad Al-Muwallad,Saudi Arabia,Levante 66,Muhannad Assiri,Saudi Arabia,Al-Ahli 67,Yasser Al-Mosailem,Saudi Arabia,Al-Ahli 68,Mohammed Al-Owais,Saudi Arabia,Al-Ahli 69,Motaz Hawsawi,Saudi Arabia,Al-Ahli 70,Fernando Muslera,Uruguay,Galatasaray 71,José Giménez,Uruguay,Atlético Madrid 72,Diego Godín (captain),Uruguay,Atlético Madrid 73,Guillermo Varela,Uruguay,Peñarol 74,Carlos Sánchez,Uruguay,Monterrey 75,Rodrigo Bentancur,Uruguay,Juventus 76,Cristian Rodríguez,Uruguay,Peñarol 77,Nahitan Nández,Uruguay,Boca Juniors 78,Luis Suárez,Uruguay,Barcelona 79,Giorgian De Arrascaeta,Uruguay,Cruzeiro 80,Cristhian Stuani,Uruguay,Girona 81,Martín Campaña,Uruguay,Independiente 82,Gastón Silva,Uruguay,Independiente 83,Lucas Torreira,Uruguay,Sampdoria 84,Matías Vecino,Uruguay,Inter Milan 85,Maxi Pereira,Uruguay,Porto 86,Diego Laxalt,Uruguay,Genoa 87,Maxi Gómez,Uruguay,Celta Vigo 88,Sebastián Coates,Uruguay,Sporting CP 89,Jonathan Urretaviscaya,Uruguay,Monterrey 90,Edinson Cavani,Uruguay,Paris Saint-Germain 91,Martín Cáceres,Uruguay,Lazio 92,Martín Silva,Uruguay,Vasco da Gama 93,Alireza Beiranvand,Iran,Persepolis 94,Mehdi Torabi,Iran,Saipa 95,Ehsan Hajsafi,Iran,Olympiacos 96,Rouzbeh Cheshmi,Iran,Esteghlal 97,Milad Mohammadi,Iran,Akhmat Grozny 98,Saeid Ezatolahi,Iran,Amkar Perm 99,Masoud Shojaei (captain),Iran,AEK Athens 100,Morteza Pouraliganji,Iran,Al-Sadd 101,Omid Ebrahimi,Iran,Esteghlal 102,Karim Ansarifard,Iran,Olympiacos 103,Vahid Amiri,Iran,Persepolis 104,Mohammad Rashid Mazaheri,Iran,Zob Ahan 105,Mohammad Reza Khanzadeh,Iran,Padideh 106,Saman Ghoddos,Iran,Östersund 107,Pejman Montazeri,Iran,Esteghlal 108,Reza Ghoochannejhad,Iran,Heerenveen 109,Mehdi Taremi,Iran,Al-Gharafa 110,Alireza Jahanbakhsh,Iran,AZ 111,Majid Hosseini,Iran,Esteghlal 112,Sardar Azmoun,Iran,Rubin Kazan 113,Ashkan Dejagah,Iran,Nottingham Forest 114,Amir Abedzadeh,Iran,Marítimo 115,Ramin Rezaeian,Iran,Oostende 116,Yassine Bounou,Morocco,Girona 117,Achraf Hakimi,Morocco,Real Madrid 118,Hamza Mendyl,Morocco,Lille 119,Manuel da Costa,Morocco,İstanbul Başakşehir 120,Medhi Benatia (captain),Morocco,Juventus 121,Romain Saïss,Morocco,Wolverhampton Wanderers 122,Hakim Ziyech,Morocco,Ajax 123,Karim El Ahmadi,Morocco,Feyenoord 124,Ayoub El Kaabi,Morocco,RS Berkane 125,Younès Belhanda,Morocco,Galatasaray 126,Fayçal Fajr,Morocco,Getafe 127,Munir Mohamedi,Morocco,Numancia 128,Khalid Boutaïb,Morocco,Yeni Malatyaspor 129,Mbark Boussoufa,Morocco,Al-Jazira 130,Youssef Aït Bennasser,Morocco,Caen 131,Nordin Amrabat,Morocco,Leganés 132,Nabil Dirar,Morocco,Fenerbahçe 133,Amine Harit,Morocco,Schalke 04 134,Youssef En-Nesyri,Morocco,Málaga 135,Aziz Bouhaddouz,Morocco,FC St. Pauli 136,Sofyan Amrabat,Morocco,Feyenoord 137,Ahmed Reda Tagnaouti,Morocco,IR Tanger 138,Mehdi Carcela,Morocco,Standard Liège 139,Rui Patrício,Portugal,Sporting CP 140,Bruno Alves,Portugal,Rangers 141,Pepe,Portugal,Beşiktaş 142,Manuel Fernandes,Portugal,Lokomotiv Moscow 143,Raphaël Guerreiro,Portugal,Borussia Dortmund 144,José Fonte,Portugal,Dalian Yifang 145,Cristiano Ronaldo (captain),Portugal,Real Madrid 146,João Moutinho,Portugal,Monaco 147,André Silva,Portugal,Milan 148,João Mário,Portugal,West Ham United 149,Bernardo Silva,Portugal,Manchester City 150,Anthony Lopes,Portugal,Lyon 151,Rúben Dias,Portugal,Benfica 152,William Carvalho,Portugal,Sporting CP 153,Ricardo Pereira,Portugal,Porto 154,Bruno Fernandes,Portugal,Sporting CP 155,Gonçalo Guedes,Portugal,Valencia 156,Gelson Martins,Portugal,Sporting CP 157,Mário Rui,Portugal,Napoli 158,Ricardo Quaresma,Portugal,Beşiktaş 159,Cédric,Portugal,Southampton 160,Beto,Portugal,Göztepe 161,Adrien Silva,Portugal,Leicester City 162,David de Gea,Spain,Manchester United 163,Dani Carvajal,Spain,Real Madrid 164,Gerard Piqué,Spain,Barcelona 165,Nacho,Spain,Real Madrid 166,Sergio Busquets,Spain,Barcelona 167,Andrés Iniesta,Spain,Barcelona 168,Saúl,Spain,Atlético Madrid 169,Koke,Spain,Atlético Madrid 170,Rodrigo,Spain,Valencia 171,Thiago,Spain,Bayern Munich 172,Lucas Vázquez,Spain,Real Madrid 173,Álvaro Odriozola,Spain,Real Sociedad 174,Kepa Arrizabalaga,Spain,Athletic Bilbao 175,César Azpilicueta,Spain,Chelsea 176,Sergio Ramos (captain),Spain,Real Madrid 177,Nacho Monreal,Spain,Arsenal 178,Iago Aspas,Spain,Celta Vigo 179,Jordi Alba,Spain,Barcelona 180,Diego Costa,Spain,Atlético Madrid 181,Marco Asensio,Spain,Real Madrid 182,David Silva,Spain,Manchester City 183,Isco,Spain,Real Madrid 184,Pepe Reina,Spain,Napoli 185,Mathew Ryan,Australia,Brighton & Hove Albion 186,Milos Degenek,Australia,Yokohama F. Marinos 187,James Meredith,Australia,Millwall 188,Tim Cahill,Australia,Millwall 189,Mark Milligan,Australia,Al-Ahli 190,Matthew Jurman,Australia,Suwon Samsung Bluewings 191,Mathew Leckie,Australia,Hertha BSC 192,Massimo Luongo,Australia,Queens Park Rangers 193,Tomi Juric,Australia,Luzern 194,Robbie Kruse,Australia,VfL Bochum 195,Andrew Nabbout,Australia,Urawa Red Diamonds 196,Brad Jones,Australia,Feyenoord 197,Aaron Mooy,Australia,Huddersfield Town 198,Jamie Maclaren,Australia,Hibernian 199,Mile Jedinak (captain),Australia,Aston Villa 200,Aziz Behich,Australia,Bursaspor 201,Daniel Arzani,Australia,Melbourne City 202,Danny Vukovic,Australia,Genk 203,Josh Risdon,Australia,Western Sydney Wanderers 204,Trent Sainsbury,Australia,Grasshoppers 205,Dimitri Petratos,Australia,Newcastle Jets 206,Jackson Irvine,Australia,Hull City 207,Tom Rogic,Australia,Celtic 208,Kasper Schmeichel,Denmark,Leicester City 209,Michael Krohn-Dehli,Denmark,Deportivo La Coruña 210,Jannik Vestergaard,Denmark,Borussia Mönchengladbach 211,Simon Kjær (captain),Denmark,Sevilla 212,Jonas Knudsen,Denmark,Ipswich Town 213,Andreas Christensen,Denmark,Chelsea 214,William Kvist,Denmark,Copenhagen 215,Thomas Delaney,Denmark,Werder Bremen 216,Nicolai Jørgensen,Denmark,Feyenoord 217,Christian Eriksen,Denmark,Tottenham Hotspur 218,Martin Braithwaite,Denmark,Bordeaux 219,Kasper Dolberg,Denmark,Ajax 220,Mathias Jørgensen,Denmark,Huddersfield Town 221,Henrik Dalsgaard,Denmark,Brentford 222,Viktor Fischer,Denmark,Copenhagen 223,Jonas Lössl,Denmark,Huddersfield Town 224,Jens Stryger Larsen,Denmark,Udinese 225,Lukas Lerager,Denmark,Bordeaux 226,Lasse Schöne,Denmark,Ajax 227,Yussuf Poulsen,Denmark,RB Leipzig 228,Andreas Cornelius,Denmark,Atalanta 229,Frederik Rønnow,Denmark,Brøndby 230,Pione Sisto,Denmark,Celta Vigo 231,Hugo Lloris (captain),France,Tottenham Hotspur 232,Benjamin Pavard,France,VfB Stuttgart 233,Presnel Kimpembe,France,Paris Saint-Germain 234,Raphaël Varane,France,Real Madrid 235,Samuel Umtiti,France,Barcelona 236,Paul Pogba,France,Manchester United 237,Antoine Griezmann,France,Atlético Madrid 238,Thomas Lemar,France,Monaco 239,Olivier Giroud,France,Chelsea 240,Kylian Mbappé,France,Paris Saint-Germain 241,Ousmane Dembélé,France,Barcelona 242,Corentin Tolisso,France,Bayern Munich 243,N'Golo Kanté,France,Chelsea 244,Blaise Matuidi,France,Juventus 245,Steven Nzonzi,France,Sevilla 246,Steve Mandanda,France,Marseille 247,Adil Rami,France,Marseille 248,Nabil Fekir,France,Lyon 249,Djibril Sidibé,France,Monaco 250,Florian Thauvin,France,Marseille 251,Lucas Hernández,France,Atlético Madrid 252,Benjamin Mendy,France,Manchester City 253,Alphonse Areola,France,Paris Saint-Germain 254,Pedro Gallese,Peru,Veracruz 255,Alberto Rodríguez,Peru,Atlético Junior 256,Aldo Corzo,Peru,Universitario 257,Anderson Santamaría,Peru,Puebla 258,Miguel Araujo,Peru,Alianza Lima 259,Miguel Trauco,Peru,Flamengo 260,Paolo Hurtado,Peru,Vitória de Guimarães 261,Christian Cueva,Peru,São Paulo 262,Paolo Guerrero (captain),Peru,Flamengo 263,Jefferson Farfán,Peru,Lokomotiv Moscow 264,Raúl Ruidíaz,Peru,Morelia 265,Carlos Cáceda,Peru,Deportivo Municipal 266,Renato Tapia,Peru,Feyenoord 267,Andy Polo,Peru,Portland Timbers 268,Christian Ramos,Peru,Veracruz 269,Wilder Cartagena,Peru,Veracruz 270,Luis Advíncula,Peru,Lobos BUAP 271,André Carrillo,Peru,Watford 272,Yoshimar Yotún,Peru,Orlando City 273,Edison Flores,Peru,AaB 274,José Carvallo,Peru,UTC 275,Nilson Loyola,Peru,Melgar 276,Pedro Aquino,Peru,Lobos BUAP 277,Nahuel Guzmán,Argentina,UANL 278,Gabriel Mercado,Argentina,Sevilla 279,Nicolás Tagliafico,Argentina,Ajax 280,Cristian Ansaldi,Argentina,Torino 281,Lucas Biglia,Argentina,Milan 282,Federico Fazio,Argentina,Roma 283,Éver Banega,Argentina,Sevilla 284,Marcos Acuña,Argentina,Sporting CP 285,Gonzalo Higuaín,Argentina,Juventus 286,Lionel Messi (captain),Argentina,Barcelona 287,Ángel Di María,Argentina,Paris Saint-Germain 288,Franco Armani,Argentina,River Plate 289,Maximiliano Meza,Argentina,Independiente 290,Javier Mascherano,Argentina,Hebei China Fortune 291,Enzo Pérez,Argentina,River Plate 292,Marcos Rojo,Argentina,Manchester United 293,Nicolás Otamendi,Argentina,Manchester City 294,Eduardo Salvio,Argentina,Benfica 295,Sergio Agüero,Argentina,Manchester City 296,Giovani Lo Celso,Argentina,Paris Saint-Germain 297,Paulo Dybala,Argentina,Juventus 298,Cristian Pavón,Argentina,Boca Juniors 299,Willy Caballero,Argentina,Chelsea 300,Dominik Livaković,Croatia,Dinamo Zagreb 301,Šime Vrsaljko,Croatia,Atlético Madrid 302,Ivan Strinić,Croatia,Sampdoria 303,Ivan Perišić,Croatia,Inter Milan 304,Vedran Ćorluka,Croatia,Lokomotiv Moscow 305,Dejan Lovren,Croatia,Liverpool 306,Ivan Rakitić,Croatia,Barcelona 307,Mateo Kovačić,Croatia,Real Madrid 308,Andrej Kramarić,Croatia,1899 Hoffenheim 309,Luka Modrić (captain),Croatia,Real Madrid 310,Marcelo Brozović,Croatia,Inter Milan 311,Lovre Kalinić,Croatia,Gent 312,Tin Jedvaj,Croatia,Bayer Leverkusen 313,Filip Bradarić,Croatia,Rijeka 314,Duje Ćaleta-Car,Croatia,Red Bull Salzburg 315,Nikola Kalinić,Croatia,Milan 316,Mario Mandžukić,Croatia,Juventus 317,Ante Rebić,Croatia,Eintracht Frankfurt 318,Milan Badelj,Croatia,Fiorentina 319,Marko Pjaca,Croatia,Schalke 04 320,Domagoj Vida,Croatia,Beşiktaş 321,Josip Pivarić,Croatia,Dynamo Kyiv 322,Danijel Subašić,Croatia,Monaco 323,Hannes Þór Halldórsson,Iceland,Randers 324,Birkir Már Sævarsson,Iceland,Valur 325,Samúel Friðjónsson,Iceland,Vålerenga 326,Albert Guðmundsson,Iceland,PSV Eindhoven 327,Sverrir Ingi Ingason,Iceland,Rostov 328,Ragnar Sigurðsson,Iceland,Rostov 329,Jóhann Berg Guðmundsson,Iceland,Burnley 330,Birkir Bjarnason,Iceland,Aston Villa 331,Björn Bergmann Sigurðarson,Iceland,Rostov 332,Gylfi Sigurðsson,Iceland,Everton 333,Alfreð Finnbogason,Iceland,FC Augsburg 334,Frederik Schram,Iceland,Roskilde 335,Rúnar Alex Rúnarsson,Iceland,Nordsjælland 336,Kári Árnason,Iceland,Aberdeen 337,Hólmar Örn Eyjólfsson,Iceland,Levski Sofia 338,Ólafur Ingi Skúlason,Iceland,Kardemir Karabükspor 339,Aron Gunnarsson (captain),Iceland,Cardiff City 340,Hörður Björgvin Magnússon,Iceland,Bristol City 341,Rúrik Gíslason,Iceland,SV Sandhausen 342,Emil Hallfreðsson,Iceland,Udinese 343,Arnór Ingvi Traustason,Iceland,Malmö 344,Jón Daði Böðvarsson,Iceland,Reading 345,Ari Freyr Skúlason,Iceland,Lokeren 346,Ikechukwu Ezenwa,Nigeria,Enyimba 347,Brian Idowu,Nigeria,Amkar Perm 348,Elderson Echiéjilé,Nigeria,Cercle Brugge 349,Wilfred Ndidi,Nigeria,Leicester City 350,William Troost-Ekong,Nigeria,Bursaspor 351,Leon Balogun,Nigeria,Mainz 05 352,Ahmed Musa,Nigeria,CSKA Moscow 353,Oghenekaro Etebo,Nigeria,Las Palmas 354,Odion Ighalo,Nigeria,Changchun Yatai 355,John Obi Mikel (captain),Nigeria,Tianjin TEDA 356,Victor Moses,Nigeria,Chelsea 357,Shehu Abdullahi,Nigeria,Bursaspor 358,Simeon Nwankwo,Nigeria,Crotone 359,Kelechi Iheanacho,Nigeria,Leicester City 360,Joel Obi,Nigeria,Torino 361,Daniel Akpeyi,Nigeria,Chippa United 362,Ogenyi Onazi,Nigeria,Trabzonspor 363,Alex Iwobi,Nigeria,Arsenal 364,John Ogu,Nigeria,Hapoel Be'er Sheva 365,Chidozie Awaziem,Nigeria,Nantes 366,Tyronne Ebuehi,Nigeria,ADO Den Haag 367,Kenneth Omeruo,Nigeria,Kasımpaşa 368,Francis Uzoho,Nigeria,Deportivo La Coruña 369,Alisson,Brazil,Roma 370,Thiago Silva,Brazil,Paris Saint-Germain 371,Miranda,Brazil,Inter Milan 372,Pedro Geromel,Brazil,Grêmio 373,Casemiro,Brazil,Real Madrid 374,Filipe Luís,Brazil,Atlético Madrid 375,Douglas Costa,Brazil,Juventus 376,Renato Augusto,Brazil,Beijing Sinobo Guoan 377,Gabriel Jesus,Brazil,Manchester City 378,Neymar (captain),Brazil,Paris Saint-Germain 379,Philippe Coutinho,Brazil,Barcelona 380,Marcelo,Brazil,Real Madrid 381,Marquinhos,Brazil,Paris Saint-Germain 382,Danilo,Brazil,Manchester City 383,Paulinho,Brazil,Barcelona 384,Cássio,Brazil,Corinthians 385,Fernandinho,Brazil,Manchester City 386,Fred,Brazil,Shakhtar Donetsk 387,Willian,Brazil,Chelsea 388,Roberto Firmino,Brazil,Liverpool 389,Taison,Brazil,Shakhtar Donetsk 390,Fagner,Brazil,Corinthians 391,Ederson,Brazil,Manchester City 392,Keylor Navas,Costa Rica,Real Madrid 393,Johnny Acosta,Costa Rica,Águilas Doradas 394,Giancarlo González,Costa Rica,Bologna 395,Ian Smith,Costa Rica,Norrköping 396,Celso Borges,Costa Rica,Deportivo La Coruña 397,Óscar Duarte,Costa Rica,Espanyol 398,Christian Bolaños,Costa Rica,Saprissa 399,Bryan Oviedo,Costa Rica,Sunderland 400,Daniel Colindres,Costa Rica,Saprissa 401,Bryan Ruiz (captain),Costa Rica,Sporting CP 402,Johan Venegas,Costa Rica,Saprissa 403,Joel Campbell,Costa Rica,Real Betis 404,Rodney Wallace,Costa Rica,New York City FC 405,Randall Azofeifa,Costa Rica,Herediano 406,Francisco Calvo,Costa Rica,Minnesota United 407,Cristian Gamboa,Costa Rica,Celtic 408,Yeltsin Tejeda,Costa Rica,Lausanne 409,Patrick Pemberton,Costa Rica,Alajuelense 410,Kendall Waston,Costa Rica,Vancouver Whitecaps FC 411,David Guzmán,Costa Rica,Portland Timbers 412,Marco Ureña,Costa Rica,Los Angeles FC 413,Rónald Matarrita,Costa Rica,New York City FC 414,Leonel Moreira,Costa Rica,Herediano 415,Vladimir Stojković,Serbia,Partizan 416,Antonio Rukavina,Serbia,Villarreal 417,Duško Tošić,Serbia,Beşiktaş 418,Luka Milivojević,Serbia,Crystal Palace 419,Uroš Spajić,Serbia,Anderlecht 420,Branislav Ivanović,Serbia,Zenit Saint Petersburg 421,Andrija Živković,Serbia,Benfica 422,Aleksandar Prijović,Serbia,PAOK 423,Aleksandar Mitrović,Serbia,Fulham 424,Dušan Tadić,Serbia,Southampton 425,Aleksandar Kolarov (captain),Serbia,Roma 426,Predrag Rajković,Serbia,Maccabi Tel Aviv 427,Miloš Veljković,Serbia,Werder Bremen 428,Milan Rodić,Serbia,Red Star Belgrade 429,Nikola Milenković,Serbia,Fiorentina 430,Marko Grujić,Serbia,Cardiff City 431,Filip Kostić,Serbia,Hamburger SV 432,Nemanja Radonjić,Serbia,Red Star Belgrade 433,Luka Jović,Serbia,Eintracht Frankfurt 434,Sergej Milinković-Savić,Serbia,Lazio 435,Nemanja Matić,Serbia,Manchester United 436,Adem Ljajić,Serbia,Torino 437,Marko Dmitrović,Serbia,Eibar 438,Yann Sommer,Switzerland,Borussia Mönchengladbach 439,Stephan Lichtsteiner (captain),Switzerland,Juventus 440,François Moubandje,Switzerland,Toulouse 441,Nico Elvedi,Switzerland,Borussia Mönchengladbach 442,Manuel Akanji,Switzerland,Borussia Dortmund 443,Michael Lang,Switzerland,Basel 444,Breel Embolo,Switzerland,Schalke 04 445,Remo Freuler,Switzerland,Atalanta 446,Haris Seferović,Switzerland,Benfica 447,Granit Xhaka,Switzerland,Arsenal 448,Valon Behrami,Switzerland,Udinese 449,Yvon Mvogo,Switzerland,RB Leipzig 450,Ricardo Rodríguez,Switzerland,Milan 451,Steven Zuber,Switzerland,1899 Hoffenheim 452,Blerim Džemaili,Switzerland,Bologna 453,Gelson Fernandes,Switzerland,Eintracht Frankfurt 454,Denis Zakaria,Switzerland,Borussia Mönchengladbach 455,Mario Gavranović,Switzerland,Dinamo Zagreb 456,Josip Drmić,Switzerland,Borussia Mönchengladbach 457,Johan Djourou,Switzerland,Antalyaspor 458,Roman Bürki,Switzerland,Borussia Dortmund 459,Fabian Schär,Switzerland,Deportivo La Coruña 460,Xherdan Shaqiri,Switzerland,Stoke City 461,Manuel Neuer (captain),Germany,Bayern Munich 462,Marvin Plattenhardt,Germany,Hertha BSC 463,Jonas Hector,Germany,1. FC Köln 464,Matthias Ginter,Germany,Borussia Mönchengladbach 465,Mats Hummels,Germany,Bayern Munich 466,Sami Khedira,Germany,Juventus 467,Julian Draxler,Germany,Paris Saint-Germain 468,Toni Kroos,Germany,Real Madrid 469,Timo Werner,Germany,RB Leipzig 470,Mesut Özil,Germany,Arsenal 471,Marco Reus,Germany,Borussia Dortmund 472,Kevin Trapp,Germany,Paris Saint-Germain 473,Thomas Müller,Germany,Bayern Munich 474,Leon Goretzka,Germany,Schalke 04 475,Niklas Süle,Germany,Bayern Munich 476,Antonio Rüdiger,Germany,Chelsea 477,Jérôme Boateng,Germany,Bayern Munich 478,Joshua Kimmich,Germany,Bayern Munich 479,Sebastian Rudy,Germany,Bayern Munich 480,Julian Brandt,Germany,Bayer Leverkusen 481,İlkay Gündoğan,Germany,Manchester City 482,Marc-André ter Stegen,Germany,Barcelona 483,Mario Gómez,Germany,VfB Stuttgart 484,José de Jesús Corona,Mexico,Cruz Azul 485,Hugo Ayala,Mexico,UANL 486,Carlos Salcedo,Mexico,Eintracht Frankfurt 487,Rafael Márquez,Mexico,Atlas 488,Érick Gutiérrez,Mexico,Pachuca 489,Jonathan dos Santos,Mexico,LA Galaxy 490,Miguel Layún,Mexico,Sevilla 491,Marco Fabián,Mexico,Eintracht Frankfurt 492,Raúl Jiménez,Mexico,Benfica 493,Giovani dos Santos,Mexico,LA Galaxy 494,Carlos Vela,Mexico,Los Angeles FC 495,Alfredo Talavera,Mexico,Toluca 496,Guillermo Ochoa,Mexico,Standard Liège 497,Javier Hernández,Mexico,West Ham United 498,Héctor Moreno,Mexico,Real Sociedad 499,Héctor Herrera,Mexico,Porto 500,Jesús Manuel Corona,Mexico,Porto 501,Andrés Guardado (captain),Mexico,Real Betis 502,Oribe Peralta,Mexico,América 503,Javier Aquino,Mexico,UANL 504,Edson Álvarez,Mexico,América 505,Hirving Lozano,Mexico,PSV Eindhoven 506,Jesús Gallardo,Mexico,UNAM 507,Kim Seung-gyu,South Korea,Vissel Kobe 508,Lee Yong,South Korea,Jeonbuk Hyundai Motors 509,Jung Seung-hyun,South Korea,Sagan Tosu 510,Oh Ban-suk,South Korea,Jeju United 511,Yun Young-sun,South Korea,Seongnam FC 512,Park Joo-ho,South Korea,Ulsan Hyundai 513,Son Heung-min,South Korea,Tottenham Hotspur 514,Ju Se-jong,South Korea,Asan Mugunghwa 515,Kim Shin-wook,South Korea,Jeonbuk Hyundai Motors 516,Lee Seung-woo,South Korea,Hellas Verona 517,Hwang Hee-chan,South Korea,Red Bull Salzburg 518,Kim Min-woo,South Korea,Sangju Sangmu 519,Koo Ja-cheol,South Korea,FC Augsburg 520,Hong Chul,South Korea,Sangju Sangmu 521,Jung Woo-young,South Korea,Vissel Kobe 522,Ki Sung-yueng (captain),South Korea,Swansea City 523,Lee Jae-sung,South Korea,Jeonbuk Hyundai Motors 524,Moon Seon-min,South Korea,Incheon United 525,Kim Young-gwon,South Korea,Guangzhou Evergrande 526,Jang Hyun-soo,South Korea,FC Tokyo 527,Kim Jin-hyeon,South Korea,Cerezo Osaka 528,Go Yo-han,South Korea,FC Seoul 529,Cho Hyun-woo,South Korea,Daegu FC 530,Robin Olsen,Sweden,Copenhagen 531,Mikael Lustig,Sweden,Celtic 532,Victor Lindelöf,Sweden,Manchester United 533,Andreas Granqvist (captain),Sweden,Krasnodar 534,Martin Olsson,Sweden,Swansea City 535,Ludwig Augustinsson,Sweden,Werder Bremen 536,Sebastian Larsson,Sweden,Hull City 537,Albin Ekdal,Sweden,Hamburger SV 538,Marcus Berg,Sweden,Al Ain 539,Emil Forsberg,Sweden,RB Leipzig 540,John Guidetti,Sweden,Alavés 541,Karl-Johan Johnsson,Sweden,Guingamp 542,Gustav Svensson,Sweden,Seattle Sounders FC 543,Filip Helander,Sweden,Bologna 544,Oscar Hiljemark,Sweden,Genoa 545,Emil Krafth,Sweden,Bologna 546,Viktor Claesson,Sweden,Krasnodar 547,Pontus Jansson,Sweden,Leeds United 548,Marcus Rohdén,Sweden,Crotone 549,Ola Toivonen,Sweden,Toulouse 550,Jimmy Durmaz,Sweden,Toulouse 551,Isaac Kiese Thelin,Sweden,Waasland-Beveren 552,Kristoffer Nordfeldt,Sweden,Swansea City 553,Thibaut Courtois,Belgium,Chelsea 554,Toby Alderweireld,Belgium,Tottenham Hotspur 555,Thomas Vermaelen,Belgium,Barcelona 556,Vincent Kompany,Belgium,Manchester City 557,Jan Vertonghen,Belgium,Tottenham Hotspur 558,Axel Witsel,Belgium,Tianjin Quanjian 559,Kevin De Bruyne,Belgium,Manchester City 560,Marouane Fellaini,Belgium,Manchester United 561,Romelu Lukaku,Belgium,Manchester United 562,Eden Hazard (captain),Belgium,Chelsea 563,Yannick Carrasco,Belgium,Dalian Yifang 564,Simon Mignolet,Belgium,Liverpool 565,Koen Casteels,Belgium,VfL Wolfsburg 566,Dries Mertens,Belgium,Napoli 567,Thomas Meunier,Belgium,Paris Saint-Germain 568,Thorgan Hazard,Belgium,Borussia Mönchengladbach 569,Youri Tielemans,Belgium,Monaco 570,Adnan Januzaj,Belgium,Real Sociedad 571,Mousa Dembélé,Belgium,Tottenham Hotspur 572,Dedryck Boyata,Belgium,Celtic 573,Michy Batshuayi,Belgium,Borussia Dortmund 574,Nacer Chadli,Belgium,West Bromwich Albion 575,Leander Dendoncker,Belgium,Anderlecht 576,Jordan Pickford,England,Everton 577,Kyle Walker,England,Manchester City 578,Danny Rose,England,Tottenham Hotspur 579,Eric Dier,England,Tottenham Hotspur 580,John Stones,England,Manchester City 581,Harry Maguire,England,Leicester City 582,Jesse Lingard,England,Manchester United 583,Jordan Henderson,England,Liverpool 584,Harry Kane (captain),England,Tottenham Hotspur 585,Raheem Sterling,England,Manchester City 586,Jamie Vardy,England,Leicester City 587,Kieran Trippier,England,Tottenham Hotspur 588,Jack Butland,England,Stoke City 589,Danny Welbeck,England,Arsenal 590,Gary Cahill,England,Chelsea 591,Phil Jones,England,Manchester United 592,Fabian Delph,England,Manchester City 593,Ashley Young,England,Manchester United 594,Marcus Rashford,England,Manchester United 595,Dele Alli,England,Tottenham Hotspur 596,Ruben Loftus-Cheek,England,Crystal Palace 597,Trent Alexander-Arnold,England,Liverpool 598,Nick Pope,England,Burnley 599,Jaime Penedo,Panama,Dinamo București 600,Michael Amir Murillo,Panama,New York Red Bulls 601,Harold Cummings,Panama,San Jose Earthquakes 602,Fidel Escobar,Panama,New York Red Bulls 603,Román Torres,Panama,Seattle Sounders FC 604,Gabriel Gómez,Panama,Atlético Bucaramanga 605,Blas Pérez,Panama,Municipal 606,Édgar Bárcenas,Panama,Tapachula 607,Gabriel Torres,Panama,Huachipato 608,Ismael Díaz,Panama,Deportivo Fabril 609,Armando Cooper,Panama,Universidad de Chile 610,José Calderón,Panama,Chorrillo 611,Adolfo Machado,Panama,Houston Dynamo 612,Valentín Pimentel,Panama,Plaza Amador 613,Erick Davis,Panama,Dunajská Streda 614,Abdiel Arroyo,Panama,Alajuelense 615,Luis Ovalle,Panama,CD Olimpia 616,Luis Tejada,Panama,Sport Boys 617,Ricardo Ávila,Panama,Gent 618,Aníbal Godoy,Panama,San Jose Earthquakes 619,José Luis Rodríguez,Panama,Gent 620,Álex Rodríguez,Panama,San Francisco 621,Felipe Baloy (captain),Panama,Municipal 622,Farouk Ben Mustapha,Tunisia,Al-Shabab 623,Syam Ben Youssef,Tunisia,Kasımpaşa 624,Yohan Benalouane,Tunisia,Leicester City 625,Yassine Meriah,Tunisia,CS Sfaxien 626,Oussama Haddadi,Tunisia,Dijon 627,Rami Bedoui,Tunisia,Étoile du Sahel 628,Saîf-Eddine Khaoui,Tunisia,Troyes 629,Fakhreddine Ben Youssef,Tunisia,Al-Ettifaq 630,Anice Badri,Tunisia,Espérance 631,Wahbi Khazri,Tunisia,Rennes 632,Dylan Bronn,Tunisia,Gent 633,Ali Maâloul,Tunisia,Al Ahly 634,Ferjani Sassi,Tunisia,Al-Nassr 635,Mohamed Amine Ben Amor,Tunisia,Al-Ahli 636,Ahmed Khalil,Tunisia,Club Africain 637,Aymen Mathlouthi (captain),Tunisia,Al-Batin 638,Ellyes Skhiri,Tunisia,Montpellier 639,Bassem Srarfi,Tunisia,Nice 640,Saber Khalifa,Tunisia,Club Africain 641,Ghailene Chaalali,Tunisia,Espérance 642,Hamdi Nagguez,Tunisia,Zamalek 643,Mouez Hassen,Tunisia,Châteauroux 644,Naïm Sliti,Tunisia,Dijon 645,David Ospina,Colombia,Arsenal 646,Cristián Zapata,Colombia,Milan 647,Óscar Murillo,Colombia,Pachuca 648,Santiago Arias,Colombia,PSV Eindhoven 649,Wílmar Barrios,Colombia,Boca Juniors 650,Carlos Sánchez,Colombia,Espanyol 651,Carlos Bacca,Colombia,Villarreal 652,Abel Aguilar,Colombia,Deportivo Cali 653,Radamel Falcao (captain),Colombia,Monaco 654,James Rodríguez,Colombia,Bayern Munich 655,Juan Cuadrado,Colombia,Juventus 656,Camilo Vargas,Colombia,Deportivo Cali 657,Yerry Mina,Colombia,Barcelona 658,Luis Muriel,Colombia,Sevilla 659,Mateus Uribe,Colombia,América 660,Jefferson Lerma,Colombia,Levante 661,Johan Mojica,Colombia,Girona 662,Farid Díaz,Colombia,Olimpia 663,Miguel Borja,Colombia,Palmeiras 664,Juan Fernando Quintero,Colombia,River Plate 665,José Izquierdo,Colombia,Brighton & Hove Albion 666,José Fernando Cuadrado,Colombia,Once Caldas 667,Dávinson Sánchez,Colombia,Tottenham Hotspur 668,Eiji Kawashima,Japan,Metz 669,Naomichi Ueda,Japan,Kashima Antlers 670,Gen Shoji,Japan,Kashima Antlers 671,Keisuke Honda,Japan,Pachuca 672,Yuto Nagatomo,Japan,Galatasaray 673,Wataru Endo,Japan,Urawa Red Diamonds 674,Gaku Shibasaki,Japan,Getafe 675,Genki Haraguchi,Japan,Fortuna Düsseldorf 676,Shinji Okazaki,Japan,Leicester City 677,Shinji Kagawa,Japan,Borussia Dortmund 678,Takashi Usami,Japan,Fortuna Düsseldorf 679,Masaaki Higashiguchi,Japan,Gamba Osaka 680,Yoshinori Muto,Japan,Mainz 05 681,Takashi Inui,Japan,Eibar 682,Yuya Osako,Japan,1. FC Köln 683,Hotaru Yamaguchi,Japan,Cerezo Osaka 684,Makoto Hasebe (captain),Japan,Eintracht Frankfurt 685,Ryota Oshima,Japan,Kawasaki Frontale 686,Hiroki Sakai,Japan,Marseille 687,Tomoaki Makino,Japan,Urawa Red Diamonds 688,Gōtoku Sakai,Japan,Hamburger SV 689,Maya Yoshida,Japan,Southampton 690,Kosuke Nakamura,Japan,Kashiwa Reysol 691,Wojciech Szczęsny,Poland,Juventus 692,Michał Pazdan,Poland,Legia Warsaw 693,Artur Jędrzejczyk,Poland,Legia Warsaw 694,Thiago Cionek,Poland,SPAL 695,Jan Bednarek,Poland,Southampton 696,Jacek Góralski,Poland,Ludogorets Razgrad 697,Arkadiusz Milik,Poland,Napoli 698,Karol Linetty,Poland,Sampdoria 699,Robert Lewandowski (captain),Poland,Bayern Munich 700,Grzegorz Krychowiak,Poland,West Bromwich Albion 701,Kamil Grosicki,Poland,Hull City 702,Bartosz Białkowski,Poland,Ipswich Town 703,Maciej Rybus,Poland,Lokomotiv Moscow 704,Łukasz Teodorczyk,Poland,Anderlecht 705,Kamil Glik,Poland,Monaco 706,Jakub Błaszczykowski,Poland,VfL Wolfsburg 707,Sławomir Peszko,Poland,Lechia Gdańsk 708,Bartosz Bereszyński,Poland,Sampdoria 709,Piotr Zieliński,Poland,Napoli 710,Łukasz Piszczek,Poland,Borussia Dortmund 711,Rafał Kurzawa,Poland,Górnik Zabrze 712,Łukasz Fabiański,Poland,Swansea City 713,Dawid Kownacki,Poland,Sampdoria 714,Abdoulaye Diallo,Senegal,Rennes 715,Saliou Ciss,Senegal,Valenciennes 716,Kalidou Koulibaly,Senegal,Napoli 717,Kara Mbodji,Senegal,Anderlecht 718,Idrissa Gueye,Senegal,Everton 719,Salif Sané,Senegal,Hannover 96 720,Moussa Sow,Senegal,Bursaspor 721,Cheikhou Kouyaté (captain),Senegal,West Ham United 722,Mame Biram Diouf,Senegal,Stoke City 723,Sadio Mané,Senegal,Liverpool 724,Cheikh N'Doye,Senegal,Birmingham City 725,Youssouf Sabaly,Senegal,Bordeaux 726,Alfred N'Diaye,Senegal,Wolverhampton Wanderers 727,Moussa Konaté,Senegal,Amiens 728,Diafra Sakho,Senegal,Rennes 729,Khadim N'Diaye,Senegal,Horoya 730,Badou Ndiaye,Senegal,Stoke City 731,Ismaïla Sarr,Senegal,Rennes 732,M'Baye Niang,Senegal,Torino 733,Keita Baldé,Senegal,Monaco 734,Lamine Gassama,Senegal,Alanyaspor 735,Moussa Wagué,Senegal,Eupen 736,Alfred Gomis,Senegal,SPAL -
PaulC91 revised this gist
Jun 13, 2018 . 1 changed file with 4 additions and 8 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -28,10 +28,6 @@ df <- df_network <- map_df(df$id, ~ { country <- filter(df, id == .x) %>% pull(Country) %>% unique() @@ -40,15 +36,15 @@ df_network <- pull(Club) %>% unique() country_teammates <- filter(df, Country == country, id != .x) club_teammates <- filter(df, Club == club, id != .x) bind_rows(country_teammates, club_teammates) %>% rename(to = id) %>% mutate(from = .x) %>% distinct() %>% select(from, to) }) -
PaulC91 revised this gist
Jun 13, 2018 . 1 changed file with 42 additions and 5 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -17,8 +17,45 @@ teams <- c("Egypt", "Russia", "Saudi Arabia", "Uruguay", "Belgium", "England", "Panama", "Tunisia", "Colombia", "Japan", "Poland", "Senegal") df <- map_df(1:32, ~ { tables[[.x]] %>% mutate(Country = teams[.x]) %>% select(Player, Country, Club) }) %>% rownames_to_column("id") df_network <- map_df(df$id, ~ { player <- filter(df, id == .x) %>% pull(Player) %>% unique() country <- filter(df, id == .x) %>% pull(Country) %>% unique() club <- filter(df, id == .x) %>% pull(Club) %>% unique() country_players <- filter(df, Country == country, id != .x) club_players <- filter(df, Club == club, id != .x) bind_rows(country_players, club_players) %>% rename(to = id) %>% mutate(from = .x) %>% distinct() %>% select(from, to, Player, Country, Club) }) wc_graph <- as_tbl_graph(df_network) %>% left_join(df, by = c("name" = "id")) ggraph(wc_graph) + geom_edge_fan(alpha = .25) + geom_node_point(aes(colour = Country)) + theme_graph() -
PaulC91 created this gist
Jun 13, 2018 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,24 @@ library(rvest) library(tidyverse) library(tidygraph) library(ggraph) wc_squads <- html("https://en.wikipedia.org/wiki/2018_FIFA_World_Cup_squads") tables <- wc_squads %>% html_table() teams <- c("Egypt", "Russia", "Saudi Arabia", "Uruguay", "Iran", "Morocco", "Portugal", "Spain", "Australia", "Denmark", "France", "Peru", "Argentina", "Croatia", "Iceland", "Nigeria", "Brazil", "Costa Rica", "Serbia", "Switzerland", "Germany", "Mexico", "South Korea", "Sweden", "Belgium", "England", "Panama", "Tunisia", "Colombia", "Japan", "Poland", "Senegal") df <- map_df(1:32, ~ { tables[[.x]] %>% mutate(Country = teams[.x]) %>% select(Player, Country, Club) })