This dataset is composed of five tables that capture professional men's tennis performance, split into player dimensions and match-level facts. Below is a data dictionary detailing the columns, their data types, and their meanings across the tables. ### 1. Player Dimension Tables **`players_man_`** (Player-level summary) * **`name`** (`VARCHAR`): The player's full name. * **`number_of_matches`** (`BIGINT`): The total number of matches the player has played. * **`playing_years`** (`VARCHAR`): A list of years the player was active on the tour. **`players_tournament_man_`** (Player participation by tournament) * **`name`** (`VARCHAR`): The player's full name. * **`year`** (`BIGINT`): The year of the tournament. * **`tournament`** (`VARCHAR`): The name of the tournament. * **`rounds`** (`VARCHAR`): A list of the rounds the player reached or played in that specific tournament. ### 2. Match Performance Tables The three performance tables (`raw_kaggle`, `return_kaggle`, and `serve_kaggle`) share a common set of match-identifying columns, but each focuses on a different aspect of the match statistics. **Common Match Identifiers (Found in all three performance tables)** * **`Name`** (`VARCHAR`): The player's name. * **`Date`** (`VARCHAR`): The date of the match. * **`Tournament` / `Tournment`** (`VARCHAR`): The name of the tournament. * **`Surface`** (`VARCHAR`): The court surface (e.g., Hard, Clay, Grass). * **`Rd`** (`VARCHAR`): The round of the tournament (e.g., SF for Semi-Final, F for Final). * **`Rk`** (`DOUBLE`): The player's world ranking at the time of the match. * **`vRk`** (`DOUBLE`): The opponent's world ranking. * **`against`** (`VARCHAR`): The opponent's name. * **`Score`** (`VARCHAR`): The final match score. * **`Time`** (`VARCHAR`): The duration of the match. **`raw_kaggle`** (Raw match statistics) * **`TP`** (`DOUBLE`): Total points played in the match. * **`Aces`** (`DOUBLE`): Total number of aces hit by the player. * **`DFs`** (`DOUBLE`): Total number of double faults hit by the player. * **`SP`** (`DOUBLE`): Total serve points played by the player. * **`1SP`** (`DOUBLE`): Total first serve points played. * **`2SP`** (`DOUBLE`): Total second serve points played. * **`vA`** (`DOUBLE`): Total number of aces hit by the opponent. **`serve_kaggle`** (Serve-specific performance metrics) * **`Dr`** (`VARCHAR`): Dominance ratio (return points won divided by serve points lost). * **`A%`** (`VARCHAR`): Ace percentage (aces divided by total serve points). * **`Df%`** (`VARCHAR`): Double fault percentage. * **`1stIn`** (`VARCHAR`): First serve in percentage. * **`1st%`** (`VARCHAR`): First serve points won percentage. * **`2nd%`** (`VARCHAR`): Second serve points won percentage. * **`Bpsvd`** (`VARCHAR`): Break points saved (formatted as successful saves / total faced, e.g., "9/9"). **`return_kaggle`** (Return-specific performance metrics) * **`DR`** (`VARCHAR`): Dominance ratio. * **`TPW`** (`VARCHAR`): Total points won percentage. * **`RPW`** (`VARCHAR`): Return points won percentage. * **`vA%`** (`VARCHAR`): Opponent's ace percentage. * **`v1st%`** (`VARCHAR`): Opponent's first serve points won percentage (effectively the player's first serve return points lost). * **`v2nd%`** (`VARCHAR`): Opponent's second serve points won percentage. * **`BPCnv`** (`VARCHAR`): Break points converted (formatted as successful conversions / total opportunities). ### 3. System Metadata Columns Every table in the dataset also includes four system-generated columns used for data tracking and ingestion: * **`_ingestion_timestamp`** (`TIMESTAMP`): When the data was loaded into the system. * **`_batch_id`** (`VARCHAR`): The specific ingestion batch identifier. * **`_source_file`** (`VARCHAR`): The original file path the data was extracted from. * **`_source_system`** (`VARCHAR`): The system that provided the data (e.g., API).