Basketball Club Analytics Set (EU)
SPTBBC902· 609K records · 61 tables · v1.1.0 · Updated 2026-08-12
Sports & Athlete Performance Professional Basketball Dataset API
Overview
A club-scale European basketball analytics warehouse centred on the modelled Monteluz Basket Club in Spain from 2015/16 through 2025/26. Sixty-one linked tables combine a full 18-club domestic game spine with detailed focal-club possessions, play-by-play, shot coordinates, lineups, rotations, timeouts and playbook execution. The athlete layer follows season rosters, contracts, movements, salaries, equipment, daily wellness, nutrition, workload, availability, injuries, rehabilitation and fitness. The media library uses plain royal-blue player jerseys and plain white shorts with no crest, maker mark, sponsor, text, jersey number or shorts number; club crests are delivered separately. Leakage-safe prediction features, Elo, standings, attendance, travel, recovery, sponsorship, merchandising and reconciled club finance make the package suitable for performance analysis, strategy, forecasting and operational planning.
Squad and Performance
Four players from the squad, with the career numbers the dataset records for them. Every value below is read from the packaged tables.
Aleix MonrealPGPoint Guard
SpainAge 27Height 187 cmShoots Right
200Games
12.2Points per game
5.6Assists per game
62Rating
By season2017/18 22 games, 31.8 points2018/19 47 games, 8.7 points2019/20 33 games, 23 points2020/21 20 games, 9.2 points2021/22 26 games, 29 points2022/23 34 games, 9.7 points
RatingAvg 62
1 / 5
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| basketball_seasons | 11 |
| basketball_competitions | 4 |
| basketball_clubs | 30 |
| basketball_club_media | 30 |
| basketball_arenas | 30 |
| basketball_officials | 24 |
| basketball_players | 65 |
| basketball_equipment_profiles | 65 |
| basketball_player_history | 65 |
| basketball_coaches | 7 |
| basketball_coach_spells | 11 |
| basketball_tactical_profiles | 11 |
| basketball_technical_staff | 88 |
| basketball_player_registrations | 165 |
| basketball_player_media | 165 |
| basketball_player_contracts | 165 |
| basketball_player_season_equipment | 165 |
| basketball_player_salary_history | 165 |
| basketball_academy_players | 56 |
| basketball_player_movements | 65 |
| basketball_playbook_actions | 24 |
| basketball_games | 3,471 |
| basketball_elo_ratings | 6,942 |
| basketball_game_officials | 10,413 |
| basketball_game_rosters | 5,748 |
| basketball_shots | 68,657 |
| basketball_play_by_play | 114,409 |
| basketball_possessions | 71,700 |
| basketball_lineup_stints | 4,790 |
| basketball_rotations | 6,706 |
| basketball_timeout_events | 2,395 |
| basketball_tactical_plans | 958 |
| basketball_play_executions | 8,622 |
| basketball_game_player_stats | 5,748 |
| basketball_recovery_sessions | 479 |
| basketball_travel_schedule | 233 |
| basketball_game_attendance | 3,471 |
| basketball_game_team_stats | 6,942 |
| basketball_standings_snapshots | 6,732 |
| basketball_training_sessions | 1,716 |
| basketball_training_participation | 25,740 |
| basketball_physical_output | 23,628 |
| basketball_wellness_daily | 55,155 |
| basketball_load_monitoring | 55,155 |
| basketball_availability_daily | 55,155 |
| basketball_nutrition_monitoring | 55,155 |
| basketball_fitness_tests | 660 |
| basketball_player_season_aggregates | 165 |
| basketball_injuries | 41 |
| basketball_medical_treatments | 208 |
| basketball_rehabilitation_milestones | 205 |
| basketball_team_season_aggregates | 11 |
| basketball_game_prediction_features | 479 |
| basketball_market_odds | 2,395 |
| basketball_scouting_reports | 195 |
| basketball_financial_transactions | 1,848 |
| basketball_operating_expenses | 1,056 |
| basketball_season_financials | 11 |
| basketball_sponsorship_contracts | 44 |
| basketball_merchandise_sales | 132 |
| basketball_community_engagement | 154 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
basketball_seasons· Rows: 11
| Column | Type | Description |
|---|---|---|
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| season_label | varchar(16) | Season label for the basketball record. |
| start_date | date | start date as an ISO 8601 calendar date. |
| end_date | date | end date as an ISO 8601 calendar date. |
| host_country_code | varchar(8) | Stable code for host country; its companion description carries the meaning. |
| host_country_name | varchar(16) | Human-readable host country name. All people and organisations are modelled. |
| league_team_count | integer | League team count for the basketball record. |
+6 more columns in basketball_seasons. The full schema ships with the download.
basketball_competitions· Rows: 4
| Column | Type | Description |
|---|---|---|
| competition_id | varchar(16) | Stable identifier for competition; use it for declared joins. |
| competition_name | varchar(48) | Human-readable competition name. All people and organisations are modelled. |
| competition_type | varchar(32) | Competition type for the basketball record. |
| region | varchar(16) | Region for the basketball record. |
| regulation_minutes | integer | regulation minutes in minutes. |
| period_count | integer | Period count for the basketball record. |
| period_minutes | integer | period minutes in minutes. |
+4 more columns in basketball_competitions. The full schema ships with the download.
basketball_clubs· Rows: 30
| Column | Type | Description |
|---|---|---|
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| club_name | varchar(32) | Human-readable club name. All people and organisations are modelled. |
| club_code | varchar(8) | Stable code for club; its companion description carries the meaning. |
| city | varchar(16) | City for the basketball record. |
| administrative_area | varchar(24) | Administrative area for the basketball record. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| country_name | varchar(16) | Human-readable country name. All people and organisations are modelled. |
+7 more columns in basketball_clubs. The full schema ships with the download.
basketball_club_media· Rows: 30
| Column | Type | Description |
|---|---|---|
| club_media_id | varchar(16) | Stable identifier for club media; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| crest_svg_file | varchar(32) | Crest svg file for the basketball record. |
| crest_png_file | varchar(32) | Crest png file for the basketball record. |
| media_usage | varchar(24) | Media usage for the basketball record. |
| transparent_background_flag | boolean | Boolean indicator for transparent background. |
basketball_arenas· Rows: 30
| Column | Type | Description |
|---|---|---|
| arena_id | varchar(16) | Stable identifier for arena; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| arena_name | varchar(32) | Human-readable arena name. All people and organisations are modelled. |
| city | varchar(16) | City for the basketball record. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| capacity | integer | Capacity for the basketball record. |
| court_length_m | integer | court length in metres. |
+5 more columns in basketball_arenas. The full schema ships with the download.
basketball_officials· Rows: 24
| Column | Type | Description |
|---|---|---|
| official_id | varchar(16) | Stable identifier for official; use it for declared joins. |
| full_name | varchar(24) | Human-readable full name. All people and organisations are modelled. |
| country_code | varchar(8) | Stable code for country; its companion description carries the meaning. |
| experience_years | integer | Experience years for the basketball record. |
| foul_calls_per_game_prior | numeric(6,2) | Foul calls per game prior for the basketball record. |
| technical_fouls_per_game_prior | numeric(6,3) | Technical fouls per game prior for the basketball record. |
basketball_players· Rows: 65
| Column | Type | Description |
|---|---|---|
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| full_name | varchar(24) | Human-readable full name. All people and organisations are modelled. |
| date_of_birth | date | Date of birth for the basketball record. |
| nationality_code | varchar(8) | Stable code for nationality; its companion description carries the meaning. |
| nationality_name | varchar(32) | Human-readable nationality name. All people and organisations are modelled. |
| birth_country_code | varchar(8) | Stable code for birth country; its companion description carries the meaning. |
| birth_country_name | varchar(32) | Human-readable birth country name. All people and organisations are modelled. |
+12 more columns in basketball_players. The full schema ships with the download.
basketball_equipment_profiles· Rows: 65
| Column | Type | Description |
|---|---|---|
| equipment_profile_id | varchar(16) | Stable identifier for equipment profile; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| shoe_brand | varchar(16) | Shoe brand for the basketball record. |
| shoe_model | varchar(16) | Shoe model for the basketball record. |
| shoe_colorway | varchar(32) | Shoe colorway for the basketball record. |
| shoe_primary_colour | varchar(16) | Shoe primary colour for the basketball record. |
| shoe_cut | varchar(16) | Shoe cut for the basketball record. |
+8 more columns in basketball_equipment_profiles. The full schema ships with the download.
basketball_player_history· Rows: 65
| Column | Type | Description |
|---|---|---|
| player_history_id | varchar(16) | Stable identifier for player history; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| entry_season_id | varchar(16) | Stable identifier for entry season; use it for declared joins. |
| exit_season_id | varchar(16) | Stable identifier for exit season; use it for declared joins. |
| joined_on | date | joined on as an ISO 8601 calendar date. |
| left_on | date | left on as an ISO 8601 calendar date. |
+8 more columns in basketball_player_history. The full schema ships with the download.
basketball_coaches· Rows: 7
| Column | Type | Description |
|---|---|---|
| coach_id | varchar(16) | Stable identifier for coach; use it for declared joins. |
| full_name | varchar(24) | Human-readable full name. All people and organisations are modelled. |
| nationality_code | varchar(8) | Stable code for nationality; its companion description carries the meaning. |
| date_of_birth | date | Date of birth for the basketball record. |
| coaching_license_level | varchar(24) | Coaching license level for the basketball record. |
| preferred_pace_band | varchar(16) | Preferred pace band for the basketball record. |
basketball_coach_spells· Rows: 11
| Column | Type | Description |
|---|---|---|
| coach_spell_id | varchar(16) | Stable identifier for coach spell; use it for declared joins. |
| coach_id | varchar(16) | Stable identifier for coach; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| starts_on | date | starts on as an ISO 8601 calendar date. |
| ends_on | date | ends on as an ISO 8601 calendar date. |
| appointment_type | varchar(24) | Appointment type for the basketball record. |
+2 more columns in basketball_coach_spells. The full schema ships with the download.
basketball_tactical_profiles· Rows: 11
| Column | Type | Description |
|---|---|---|
| tactical_profile_id | varchar(16) | Stable identifier for tactical profile; use it for declared joins. |
| coach_spell_id | varchar(16) | Stable identifier for coach spell; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| primary_offensive_scheme | varchar(24) | Primary offensive scheme for the basketball record. |
| secondary_offensive_scheme | varchar(24) | Secondary offensive scheme for the basketball record. |
| primary_defensive_scheme | varchar(24) | Primary defensive scheme for the basketball record. |
+6 more columns in basketball_tactical_profiles. The full schema ships with the download.
basketball_technical_staff· Rows: 88
| Column | Type | Description |
|---|---|---|
| staff_id | varchar(16) | Stable identifier for staff; use it for declared joins. |
| coach_spell_id | varchar(16) | Stable identifier for coach spell; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| staff_name | varchar(24) | Human-readable staff name. All people and organisations are modelled. |
| role_code | varchar(32) | Stable code for role; its companion description carries the meaning. |
| full_time_equivalent | numeric(4,1) | Full time equivalent for the basketball record. |
+2 more columns in basketball_technical_staff. The full schema ships with the download.
basketball_player_registrations· Rows: 165
| Column | Type | Description |
|---|---|---|
| registration_id | varchar(16) | Stable identifier for registration; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| squad_number | varchar(8) | Squad number for the basketball record. |
| age_at_season_start | integer | age at season start as an ISO 8601 calendar date. |
| roster_role | varchar(16) | Roster role for the basketball record. |
+7 more columns in basketball_player_registrations. The full schema ships with the download.
basketball_player_media· Rows: 165
| Column | Type | Description |
|---|---|---|
| player_media_id | varchar(16) | Stable identifier for player media; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| registration_id | varchar(16) | Stable identifier for registration; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| squad_number | varchar(8) | Squad number for the basketball record. |
| captain_flag | boolean | Boolean indicator for captain. |
+5 more columns in basketball_player_media. The full schema ships with the download.
basketball_player_contracts· Rows: 165
| Column | Type | Description |
|---|---|---|
| contract_id | varchar(16) | Stable identifier for contract; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| contract_start | date | contract start as an ISO 8601 calendar date. |
| contract_end | date | contract end as an ISO 8601 calendar date. |
| contract_status | varchar(24) | Contract status for the basketball record. |
+6 more columns in basketball_player_contracts. The full schema ships with the download.
basketball_player_season_equipment· Rows: 165
| Column | Type | Description |
|---|---|---|
| player_season_equipment_id | varchar(16) | Stable identifier for player season equipment; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| equipment_profile_id | varchar(16) | Stable identifier for equipment profile; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| jersey_maker | varchar(16) | Jersey maker for the basketball record. |
| jersey_primary_colour | varchar(16) | Jersey primary colour for the basketball record. |
+6 more columns in basketball_player_season_equipment. The full schema ships with the download.
basketball_player_salary_history· Rows: 165
| Column | Type | Description |
|---|---|---|
| salary_id | varchar(16) | Stable identifier for salary; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| contract_id | varchar(16) | Stable identifier for contract; use it for declared joins. |
| annual_gross_salary_eur | integer | annual gross salary in euros. |
| estimated_variable_pay_eur | integer | estimated variable pay in euros. |
| estimated_employer_cost_eur | integer | estimated employer cost in euros. |
+3 more columns in basketball_player_salary_history. The full schema ships with the download.
basketball_academy_players· Rows: 56
| Column | Type | Description |
|---|---|---|
| academy_record_id | varchar(16) | Stable identifier for academy record; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| pathway_stage | varchar(40) | Pathway stage for the basketball record. |
| joined_program_on | date | joined program on as an ISO 8601 calendar date. |
| scholarship_flag | boolean | Boolean indicator for scholarship. |
+3 more columns in basketball_academy_players. The full schema ships with the download.
basketball_player_movements· Rows: 65
| Column | Type | Description |
|---|---|---|
| movement_id | varchar(16) | Stable identifier for movement; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| movement_date | date | movement date as an ISO 8601 calendar date. |
| movement_direction | varchar(16) | Movement direction for the basketball record. |
| movement_type | varchar(24) | Movement type for the basketball record. |
+6 more columns in basketball_player_movements. The full schema ships with the download.
basketball_playbook_actions· Rows: 24
| Column | Type | Description |
|---|---|---|
| playbook_action_id | varchar(16) | Stable identifier for playbook action; use it for declared joins. |
| action_name | varchar(16) | Human-readable action name. All people and organisations are modelled. |
| action_family | varchar(24) | Action family for the basketball record. |
| starting_alignment | varchar(24) | Starting alignment for the basketball record. |
| primary_read | varchar(16) | Primary read for the basketball record. |
| counter_read | varchar(24) | Counter read for the basketball record. |
| target_position_code | varchar(8) | Stable code for target position; its companion description carries the meaning. |
+2 more columns in basketball_playbook_actions. The full schema ships with the download.
basketball_games· Rows: 3,471
| Column | Type | Description |
|---|---|---|
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| competition_id | varchar(16) | Stable identifier for competition; use it for declared joins. |
| competition_phase | varchar(24) | Competition phase for the basketball record. |
| round_no | varchar(8) | Round no for the basketball record. |
| game_date | date | game date as an ISO 8601 calendar date. |
| tipoff_local_time | varchar(16) | Tipoff local time for the basketball record. |
+10 more columns in basketball_games. The full schema ships with the download.
basketball_elo_ratings· Rows: 6,942
| Column | Type | Description |
|---|---|---|
| elo_rating_id | varchar(16) | Stable identifier for elo rating; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| opponent_club_id | varchar(16) | Stable identifier for opponent club; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| rating_date | date | rating date as an ISO 8601 calendar date. |
| rating_before | numeric(8,2) | rating before in the declared modelled rating system. |
+6 more columns in basketball_elo_ratings. The full schema ships with the download.
basketball_game_officials· Rows: 10,413
| Column | Type | Description |
|---|---|---|
| game_official_id | varchar(16) | Stable identifier for game official; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| official_id | varchar(16) | Stable identifier for official; use it for declared joins. |
| role_code | varchar(16) | Stable code for role; its companion description carries the meaning. |
basketball_game_rosters· Rows: 5,748
| Column | Type | Description |
|---|---|---|
| game_roster_id | varchar(16) | Stable identifier for game roster; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| squad_number | varchar(8) | Squad number for the basketball record. |
| starter_flag | boolean | Boolean indicator for starter. |
+4 more columns in basketball_game_rosters. The full schema ships with the download.
basketball_shots· Rows: 68,657
| Column | Type | Description |
|---|---|---|
| shot_id | varchar(16) | Stable identifier for shot; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| sequence_no | varchar(8) | Sequence no for the basketball record. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| period | integer | Match period: 1 for first half and 2 for second half. |
+15 more columns in basketball_shots. The full schema ships with the download.
basketball_play_by_play· Rows: 114,409
| Column | Type | Description |
|---|---|---|
| play_event_id | varchar(16) | Stable identifier for play event; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| sequence_no | varchar(8) | Sequence no for the basketball record. |
| period | integer | Match period: 1 for first half and 2 for second half. |
| game_clock_seconds | integer | game clock in seconds. |
| event_type | varchar(16) | Event type for the basketball record. |
+10 more columns in basketball_play_by_play. The full schema ships with the download.
basketball_possessions· Rows: 71,700
| Column | Type | Description |
|---|---|---|
| possession_id | varchar(16) | Stable identifier for possession; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| possession_no | varchar(8) | Possession no for the basketball record. |
| period | integer | Match period: 1 for first half and 2 for second half. |
| offense_club_id | varchar(16) | Stable identifier for offense club; use it for declared joins. |
| defense_club_id | varchar(16) | Stable identifier for defense club; use it for declared joins. |
+9 more columns in basketball_possessions. The full schema ships with the download.
basketball_lineup_stints· Rows: 4,790
| Column | Type | Description |
|---|---|---|
| lineup_stint_id | varchar(16) | Stable identifier for lineup stint; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| stint_no | varchar(8) | Stint no for the basketball record. |
| start_period | integer | Start period for the basketball record. |
| start_clock_seconds | integer | start clock in seconds. |
+9 more columns in basketball_lineup_stints. The full schema ships with the download.
basketball_rotations· Rows: 6,706
| Column | Type | Description |
|---|---|---|
| rotation_event_id | varchar(16) | Stable identifier for rotation event; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| period | integer | Match period: 1 for first half and 2 for second half. |
| game_clock_seconds | integer | game clock in seconds. |
| player_out_id | varchar(16) | Stable identifier for player out; use it for declared joins. |
+4 more columns in basketball_rotations. The full schema ships with the download.
basketball_timeout_events· Rows: 2,395
| Column | Type | Description |
|---|---|---|
| timeout_event_id | varchar(16) | Stable identifier for timeout event; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| period | integer | Match period: 1 for first half and 2 for second half. |
| game_clock_seconds | integer | game clock in seconds. |
| score_margin_before | integer | Score margin before for the basketball record. |
+3 more columns in basketball_timeout_events. The full schema ships with the download.
basketball_tactical_plans· Rows: 958
| Column | Type | Description |
|---|---|---|
| tactical_plan_id | varchar(16) | Stable identifier for tactical plan; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| opponent_club_id | varchar(16) | Stable identifier for opponent club; use it for declared joins. |
| planned_pace | varchar(16) | Planned pace for the basketball record. |
| primary_offense | varchar(24) | Primary offense for the basketball record. |
+6 more columns in basketball_tactical_plans. The full schema ships with the download.
basketball_play_executions· Rows: 8,622
| Column | Type | Description |
|---|---|---|
| play_execution_id | varchar(16) | Stable identifier for play execution; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| playbook_action_id | varchar(16) | Stable identifier for playbook action; use it for declared joins. |
| period | integer | Match period: 1 for first half and 2 for second half. |
| game_clock_seconds | integer | game clock in seconds. |
+6 more columns in basketball_play_executions. The full schema ships with the download.
basketball_game_player_stats· Rows: 5,748
| Column | Type | Description |
|---|---|---|
| player_game_stat_id | varchar(16) | Stable identifier for player game stat; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| starter_flag | boolean | Boolean indicator for starter. |
| minutes | integer | minutes in minutes. |
+20 more columns in basketball_game_player_stats. The full schema ships with the download.
basketball_recovery_sessions· Rows: 479
| Column | Type | Description |
|---|---|---|
| recovery_session_id | varchar(16) | Stable identifier for recovery session; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| session_date | date | session date as an ISO 8601 calendar date. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| session_type | varchar(24) | Session type for the basketball record. |
| sleep_extension_target_hours | numeric(4,1) | sleep extension target in hours. |
+4 more columns in basketball_recovery_sessions. The full schema ships with the download.
basketball_travel_schedule· Rows: 233
| Column | Type | Description |
|---|---|---|
| travel_record_id | varchar(16) | Stable identifier for travel record; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| destination_city | varchar(16) | Destination city for the basketball record. |
| outbound_date | date | outbound date as an ISO 8601 calendar date. |
| return_date | date | return date as an ISO 8601 calendar date. |
+5 more columns in basketball_travel_schedule. The full schema ships with the download.
basketball_game_attendance· Rows: 3,471
| Column | Type | Description |
|---|---|---|
| attendance_id | varchar(16) | Stable identifier for attendance; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| tickets_issued | integer | Tickets issued for the basketball record. |
| turnstile_attendance | integer | turnstile attendance; zero is valid under a closed-doors restriction. |
| season_ticket_attendance | integer | season ticket attendance; zero is valid under a closed-doors restriction. |
| hospitality_attendance | integer | hospitality attendance; zero is valid under a closed-doors restriction. |
+5 more columns in basketball_game_attendance. The full schema ships with the download.
basketball_game_team_stats· Rows: 6,942
| Column | Type | Description |
|---|---|---|
| game_team_stat_id | varchar(16) | Stable identifier for game team stat; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| opponent_club_id | varchar(16) | Stable identifier for opponent club; use it for declared joins. |
| home_flag | boolean | Boolean indicator for home. |
| points | integer | points under three points for a win and one for a draw unless stated otherwise. |
+19 more columns in basketball_game_team_stats. The full schema ships with the download.
basketball_standings_snapshots· Rows: 6,732
| Column | Type | Description |
|---|---|---|
| standing_snapshot_id | varchar(16) | Stable identifier for standing snapshot; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| competition_id | varchar(16) | Stable identifier for competition; use it for declared joins. |
| round_no | varchar(8) | Round no for the basketball record. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| rank | integer | Rank for the basketball record. |
| games_played | integer | Games played for the basketball record. |
+7 more columns in basketball_standings_snapshots. The full schema ships with the download.
basketball_training_sessions· Rows: 1,716
| Column | Type | Description |
|---|---|---|
| training_session_id | varchar(16) | Stable identifier for training session; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| session_date | date | session date as an ISO 8601 calendar date. |
| session_type | varchar(32) | Session type for the basketball record. |
| microcycle_day | varchar(16) | Microcycle day for the basketball record. |
| planned_duration_min | integer | planned duration in minutes. |
| actual_duration_min | integer | actual duration in minutes. |
+5 more columns in basketball_training_sessions. The full schema ships with the download.
basketball_training_participation· Rows: 25,740
| Column | Type | Description |
|---|---|---|
| training_participation_id | varchar(16) | Stable identifier for training participation; use it for declared joins. |
| training_session_id | varchar(16) | Stable identifier for training session; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| participation_status | varchar(16) | Participation status for the basketball record. |
| modification_reason | varchar(24) | Modification reason for the basketball record. |
| duration_min | integer | duration in minutes. |
+3 more columns in basketball_training_participation. The full schema ships with the download.
basketball_physical_output· Rows: 23,628
| Column | Type | Description |
|---|---|---|
| physical_output_id | varchar(16) | Stable identifier for physical output; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| exposure_type | varchar(16) | Exposure type for the basketball record. |
| training_session_id | varchar(16) | Stable identifier for training session; use it for declared joins. |
| game_id | varchar(8) | Stable identifier for game; use it for declared joins. |
| exposure_date | date | exposure date as an ISO 8601 calendar date. |
+10 more columns in basketball_physical_output. The full schema ships with the download.
basketball_wellness_daily· Rows: 55,155
| Column | Type | Description |
|---|---|---|
| wellness_id | varchar(16) | Stable identifier for wellness; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| wellness_date | date | wellness date as an ISO 8601 calendar date. |
| submission_status | varchar(16) | Submission status for the basketball record. |
| sleep_hours | numeric(4,1) | sleep in hours. |
| sleep_quality_1_5 | integer | sleep quality self-report on a 1 to 5 scale. |
+8 more columns in basketball_wellness_daily. The full schema ships with the download.
basketball_load_monitoring· Rows: 55,155
| Column | Type | Description |
|---|---|---|
| load_monitoring_id | varchar(16) | Stable identifier for load monitoring; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| monitoring_date | date | monitoring date as an ISO 8601 calendar date. |
| daily_load_au | numeric(6,1) | Sum of session load and match-minute load for the player-day, in arbitrary units. |
| acute_load_7d_au | numeric(7,1) | Rolling sum of daily load over the current day and previous six days, in arbitrary units. |
| chronic_load_28d_au | numeric(6,1) | Rolling 28-day load divided by four to express a weekly-equivalent chronic load, in arbitrary units. |
+4 more columns in basketball_load_monitoring. The full schema ships with the download.
basketball_availability_daily· Rows: 55,155
| Column | Type | Description |
|---|---|---|
| availability_id | varchar(16) | Stable identifier for availability; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| availability_date | date | availability date as an ISO 8601 calendar date. |
| status_code | varchar(16) | Stable code for status; its companion description carries the meaning. |
| participation_cap_pct | integer | participation cap expressed as a percentage from 0 to 100. |
| reason_code | varchar(24) | Stable code for reason; its companion description carries the meaning. |
+3 more columns in basketball_availability_daily. The full schema ships with the download.
basketball_nutrition_monitoring· Rows: 55,155
| Column | Type | Description |
|---|---|---|
| nutrition_record_id | varchar(16) | Stable identifier for nutrition record; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| record_date | date | record date as an ISO 8601 calendar date. |
| energy_intake_kcal | integer | Energy intake kcal for the basketball record. |
| protein_g | integer | Protein g for the basketball record. |
| carbohydrate_g | integer | Carbohydrate g for the basketball record. |
+4 more columns in basketball_nutrition_monitoring. The full schema ships with the download.
basketball_fitness_tests· Rows: 660
| Column | Type | Description |
|---|---|---|
| fitness_test_id | varchar(16) | Stable identifier for fitness test; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| test_date | date | test date as an ISO 8601 calendar date. |
| test_code | varchar(32) | Stable code for test; its companion description carries the meaning. |
| value | numeric(8,2) | Value for the basketball record. |
| unit | varchar(16) | Unit for the basketball record. |
+3 more columns in basketball_fitness_tests. The full schema ships with the download.
basketball_player_season_aggregates· Rows: 165
| Column | Type | Description |
|---|---|---|
| player_season_aggregate_id | varchar(16) | Stable identifier for player season aggregate; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| games_available | integer | Games available for the basketball record. |
| games_played | integer | Games played for the basketball record. |
| starts | integer | Starts for the basketball record. |
+14 more columns in basketball_player_season_aggregates. The full schema ships with the download.
basketball_injuries· Rows: 41
| Column | Type | Description |
|---|---|---|
| injury_id | varchar(16) | Stable identifier for injury; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| onset_date | date | onset date as an ISO 8601 calendar date. |
| body_region_code | varchar(8) | Stable code for body region; its companion description carries the meaning. |
| body_region_name | varchar(24) | Human-readable body region name. All people and organisations are modelled. |
| diagnosis_description | varchar(40) | Human-readable meaning of diagnosis. |
+9 more columns in basketball_injuries. The full schema ships with the download.
basketball_medical_treatments· Rows: 208
| Column | Type | Description |
|---|---|---|
| treatment_id | varchar(16) | Stable identifier for treatment; use it for declared joins. |
| injury_id | varchar(16) | Stable identifier for injury; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| treatment_date | date | treatment date as an ISO 8601 calendar date. |
| modality_code | varchar(24) | Stable code for modality; its companion description carries the meaning. |
| duration_min | integer | duration in minutes. |
+3 more columns in basketball_medical_treatments. The full schema ships with the download.
basketball_rehabilitation_milestones· Rows: 205
| Column | Type | Description |
|---|---|---|
| rehabilitation_milestone_id | varchar(16) | Stable identifier for rehabilitation milestone; use it for declared joins. |
| injury_id | varchar(16) | Stable identifier for injury; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| stage_code | varchar(32) | Stable code for stage; its companion description carries the meaning. |
| planned_date | date | planned date as an ISO 8601 calendar date. |
| achieved_date | date | achieved date as an ISO 8601 calendar date. |
+2 more columns in basketball_rehabilitation_milestones. The full schema ships with the download.
basketball_team_season_aggregates· Rows: 11
| Column | Type | Description |
|---|---|---|
| team_season_aggregate_id | varchar(16) | Stable identifier for team season aggregate; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| competition_id | varchar(16) | Stable identifier for competition; use it for declared joins. |
| games | integer | Games for the basketball record. |
| wins | integer | Wins for the basketball record. |
| losses | integer | Losses for the basketball record. |
+7 more columns in basketball_team_season_aggregates. The full schema ships with the download.
basketball_game_prediction_features· Rows: 479
| Column | Type | Description |
|---|---|---|
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| club_id | varchar(16) | Stable identifier for club; use it for declared joins. |
| opponent_club_id | varchar(16) | Stable identifier for opponent club; use it for declared joins. |
| feature_source_cutoff | varchar(32) | Latest kickoff date used by any feature. Empty when no prior match exists and otherwise strictly earlier than kickoff_date. |
| feature_set_version | varchar(16) | Feature set version for the basketball record. |
+19 more columns in basketball_game_prediction_features. The full schema ships with the download.
basketball_market_odds· Rows: 2,395
| Column | Type | Description |
|---|---|---|
| market_odds_id | varchar(16) | Stable identifier for market odds; use it for declared joins. |
| game_id | varchar(16) | Stable identifier for game; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| market_code | varchar(16) | Stable code for market; its companion description carries the meaning. |
| selection_code | varchar(16) | Stable code for selection; its companion description carries the meaning. |
| opening_decimal_price | numeric(5,2) | Opening decimal price for the basketball record. |
| closing_decimal_price | numeric(5,2) | Closing decimal price for the basketball record. |
+3 more columns in basketball_market_odds. The full schema ships with the download.
basketball_scouting_reports· Rows: 195
| Column | Type | Description |
|---|---|---|
| scouting_report_id | varchar(16) | Stable identifier for scouting report; use it for declared joins. |
| player_id | varchar(16) | Stable identifier for player; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| report_date | date | report date as an ISO 8601 calendar date. |
| observation_context | varchar(32) | Observation context for the basketball record. |
| shooting_score_1_10 | integer | shooting score on a 1 to 10 scale. |
| passing_score_1_10 | integer | passing score on a 1 to 10 scale. |
+8 more columns in basketball_scouting_reports. The full schema ships with the download.
basketball_financial_transactions· Rows: 1,848
| Column | Type | Description |
|---|---|---|
| financial_transaction_id | varchar(16) | Stable identifier for financial transaction; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| posting_month | varchar(16) | Posting month for the basketball record. |
| transaction_category | varchar(32) | Transaction category for the basketball record. |
| revenue_expense_type | varchar(16) | Revenue expense type for the basketball record. |
| amount_eur | integer | amount in euros. |
| cash_non_cash | varchar(16) | Cash non cash for the basketball record. |
+2 more columns in basketball_financial_transactions. The full schema ships with the download.
basketball_operating_expenses· Rows: 1,056
| Column | Type | Description |
|---|---|---|
| operating_expense_id | varchar(16) | Stable identifier for operating expense; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| expense_month | varchar(16) | Expense month for the basketball record. |
| cost_centre_code | varchar(24) | Stable code for cost centre; its companion description carries the meaning. |
| amount_eur | integer | amount in euros. |
| budget_variance_eur | integer | budget variance in euros. |
| capitalised_flag | boolean | Boolean indicator for capitalised. |
+1 more columns in basketball_operating_expenses. The full schema ships with the download.
basketball_season_financials· Rows: 11
| Column | Type | Description |
|---|---|---|
| season_financial_id | varchar(16) | Stable identifier for season financial; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| currency | varchar(16) | Currency for the basketball record. |
| total_revenue_eur | integer | total revenue in euros. |
| total_operating_expense_eur | integer | total operating expense in euros. |
| operating_profit_loss_eur | integer | operating profit loss in euros. |
| player_payroll_cost_eur | integer | player payroll cost in euros. |
+6 more columns in basketball_season_financials. The full schema ships with the download.
basketball_sponsorship_contracts· Rows: 44
| Column | Type | Description |
|---|---|---|
| sponsorship_contract_id | varchar(16) | Stable identifier for sponsorship contract; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| partner_name | varchar(32) | Human-readable partner name. All people and organisations are modelled. |
| contract_type | varchar(24) | Contract type for the basketball record. |
| starts_on | date | starts on as an ISO 8601 calendar date. |
| ends_on | date | ends on as an ISO 8601 calendar date. |
| guaranteed_value_eur | integer | guaranteed value in euros. |
+3 more columns in basketball_sponsorship_contracts. The full schema ships with the download.
basketball_merchandise_sales· Rows: 132
| Column | Type | Description |
|---|---|---|
| merchandise_sales_id | varchar(16) | Stable identifier for merchandise sales; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| product_category | varchar(16) | Product category for the basketball record. |
| sales_channel | varchar(24) | Sales channel for the basketball record. |
| units_sold | integer | Units sold for the basketball record. |
| gross_sales_eur | integer | gross sales in euros. |
| returns_units | integer | Returns units for the basketball record. |
+1 more columns in basketball_merchandise_sales. The full schema ships with the download.
basketball_community_engagement· Rows: 154
| Column | Type | Description |
|---|---|---|
| community_event_id | varchar(16) | Stable identifier for community event; use it for declared joins. |
| season_id | varchar(16) | Stable identifier for season; use it for declared joins. |
| event_date | date | event date as an ISO 8601 calendar date. |
| programme_code | varchar(32) | Stable code for programme; its companion description carries the meaning. |
| city | varchar(16) | City for the basketball record. |
| participants | integer | Participants for the basketball record. |
| player_appearances | integer | Player appearances for the basketball record. |
+3 more columns in basketball_community_engagement. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| game_id | season_id | player_id | minutes | points | three_point_made | offensive_rebounds | defensive_rebounds | assists | plus_minus | performance_index_rating |
|---|---|---|---|---|---|---|---|---|---|---|
| BGM000001 | BSE2015 | BPLY0001 | 21 | 12 | 3 | 0 | 1 | 5 | -7 | 12 |
| BGM000001 | BSE2015 | BPLY0002 | 23 | 8 | 1 | 0 | 2 | 5 | -10 | 15 |
| BGM000001 | BSE2015 | BPLY0003 | 22 | 16 | 2 | 0 | 2 | 1 | -9 | 14 |
Version History
| v1.1.0 | 2026-08-12 | Rating release. Player ratings move to the 50 to 100 whole-number scale on both grains: the per-game performance index rating is 50 plus the classic index computed from the row, floored at 50 and capped at 100, and the season player efficiency rating is the same construction over the season counting columns per game played, floor division. Both recompute exactly from their own rows. Everything else unchanged. |
Related Datasets
Football Club Analytics Set (EU)
Sports & Athlete PerformanceA complete synthetic Italian football-club data warehouse covering eleven seasons of matches, tactics, players, training, medical load, predictions, salaries and club finance.
$349one time
View details Sprint Running Athlete Analytics Set (WW)
Sports & Athlete PerformanceA complete worldwide sprint athlete warehouse for short sprint, half-lap and full-lap races, with starts, splits, weather, training, health and prediction.
$169one time
View details Swimming Athlete Analytics Set (WW)
Sports & Athlete PerformanceA complete worldwide swimming athlete warehouse covering races, laps, starts, turns, training, condition, health, finance and prediction.
$169one time
View details