Goalkeeper And Midfielder Statistics
Leveraging Statistical Data Of Goalkeepers and Midfielders
@kaggle.thedevastator_maximizing_player_performance_with_goalkeeper_an
Leveraging Statistical Data Of Goalkeepers and Midfielders
@kaggle.thedevastator_maximizing_player_performance_with_goalkeeper_an
By [source]
Welcome to Kaggle's dataset, where we provide rich and detailed insights into professional football players. Analyze player performance and team data with over 125 different metrics covering everything from goal involvement to tackles won, errors made and clean sheets kept. With the high levels of granularity included in our analysis, you can identify which players are underperforming or stand out from their peers for areas such as defense, shot stopping and key passes. Discover current trends in the game or uncover players' hidden value with this comprehensive dataset - a must-have resource for any aspiring football analyst!
For more datasets, click here.
- 🚨 Your notebook can be here! 🚨!
Define Performance: The first step of using this dataset is defining what type of performance you are measuring. Are you looking at total goals scored? Assists made? Shots on target? This will allow you to choose which metrics from the dataset best fit your criteria.
Descriptive Analysis: Once you have chosen your metric(s), it's time for descriptive analysis. This means analyzing the patterns within the data that contribute towards that metric(s). Does one team have more potential assist makers than another? What about shot accuracy or tackles won %? With descriptive analysis, we'll look for general trends across teams or specific players that influence performance in a meaningful way.
Predictive Analysis: Finally, we can move onto predictive analysis. This type of analysis seeks to answer two questions: what are factors that predict player performance? And which factors are most important when predicting performance? Utilizing various predictive models—ex – Logistic regression or Random forest -we can determine which variables in our dataset best explain a certain metric’s outcome—for example –expected goals per match -and build models that accurately predict future outcomes based on given input values associated with those factors.
By following these steps outlined here, you'll be able to get started in finding relationships between different metrics from this dataset and leveraging these insights into predictions about player performance!
- Creating an advanced predictive analytics model: By using the data in this dataset, it would be possible to create an advanced predictive analytics model that can analyze player performance and provide more accurate insights on which players are likely to have the most impact during a given season.
- Using Machine Learning algorithms to identify potential transfer targets: By using a variety of metrics included in this dataset, such as shots, shots on target and goals scored, it would be possible to use Machine Learning algorithms to identify potential transfer targets for a team.
- Analyzing positional differences between players: This dataset contains information about each player's position as well as their performance metrics across various aspects of the game (e.g., crosses attempted, defensive clearances). Thus it could be used for analyzing how certain positional groupings perform differently from one another in certain aspects of their play over different stretches of time or within one season or matchday in particular.
If you use this dataset in your research, please credit the original authors.
Data Source
License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.
File: DEF PerApp 2GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
File: FWD PerApp 2GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
File: FWD PerApp 3GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
File: FWD PerApp 4GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
File: FWD PerApp 5GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
File: GK PerApp 2GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
File: GK PerApp 3GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
File: MID PerApp 2GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
File: MID PerApp 3GWs.csv
Column name | Description |
---|---|
Name | Name of the player. (String) |
App. | Number of appearances. (Integer) |
Minutes | Number of minutes played. (Integer) |
Shots | Number of shots taken. (Integer) |
Shots on Target | Number of shots on target. (Integer) |
Shots in Box | Number of shots taken inside the box. (Integer) |
Headed Attempts | Number of headed attempts. (Integer) |
Big Chance | Number of big chances taken. (Integer) |
Big Chance Created | Number of big chances created. (Integer) |
Goals | Number of goals scored. (Integer) |
Headed Goal | Number of headed goals scored. (Integer) |
Goal Involvement | Number of goals involved in. (Integer) |
Key Pass | Number of key passes. (Integer) |
Big Chance Created.1 | Number of big chances created. (Integer) |
Assists | Number of assists. (Integer) |
Crosses (Tot.) | Total number of crosses. (Integer) |
Crosses (Succ.) | Number of successful crosses. (Integer) |
Crosses Succ. % | Percentage of successful crosses. (Float) |
Exp. Goals (xG) | Expected goals. (Float) |
Non Penalty xG (NPxG) | Non penalty expected goals. (Float) |
Exp. Assists (xA) | Expected assists. (Float) |
Exp. Att. Points (xATT) | Expected attacking points. (Float) |
Exp. Points (xPts) | Expected points. (Float) |
Exp. Involvement (xGI) | Expected involvement. (Float) |
Cost (ÂŁM) | Cost in millions. (Float) |
Bonus Points | Bonus points. (Integer) |
Baseline BPS | Baseline BPS rating. (Integer) |
Threat | Threat rating. (Integer) |
Creativity | Creativity rating. ( |
Final 3rd Pass % | Percentage of successful passes in the final third. (Float) |
Throughballs (Tot.) | Total number of throughballs. (Integer) |
Throughballs (Succ.) | Number of successful throughballs. (Integer) |
Touches (All) | Total number of touches. (Integer) |
Touches (Box) | Number of touches in the box. (Integer) |
Entries (Box) | Number of entries into the box. (Integer) |
Fouls Won (Final 3rd) | Number of fouls won in the final third. (Integer) |
Penalty Box Entries | Number of entries into the penalty box. (Integer) |
Fouls Won (Box) | Number of fouls won in the box. (Integer) |
Fouls Made | Number of fouls made. (Integer) |
Corners Taken | Number of corners taken |
Saves | Number of saves made. (Integer) |
Yellow Cards | Number of yellow cards received. (Integer) |
Second Yellows | Number of second yellow cards received. (Integer) |
Red Cards | Number of red cards received. (Integer) |
Errors (lead to Goal) | Number of errors that led to a goal. (Integer) |
Errors (lead to Shot) | Number of errors that led to a shot. (Integer) |
Own Goals | Number of own goals scored. (Integer) |
Position | Position of the player. (String) |
Team | Team of the player. (String) |
If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .
CREATE TABLE def_perapp_2gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_2gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_3gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_4gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_5gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE gk_perapp_2gws (
"name" VARCHAR,
"app" BIGINT,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" BIGINT,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE gk_perapp_3gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" BIGINT,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_2gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_3gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_4gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_5gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
Anyone who has the link will be able to view this.