football
Queries
Tables
audit_log
audit_id, timestamp, operator_id, run_id, table_name, record_pk, action, column_name, old_value, new_value, reason
0 rows
competition
competition_id, name, slug, type, region, tier, is_active, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
205 rows
elo_record
elo_id, team_id, date, rating, k_factor, delta, source_match_id, is_tournament, competition_id, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
Many rows
form_record
form_id, team_id, date, window_matches, pts_avg, gf_avg, ga_avg, xg_for_avg, xg_against_avg, win_pct, draw_pct, loss_pct, competition_id, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
Many rows
h2h_record
h2h_id, team_a_id, team_b_id, date, total_matches, wins_a, wins_b, draws, goals_a, goals_b, last_match_date, last_result, last_match_id, competition_id, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
Many rows
ingestion_run
run_id, source_id, operator_id, target_table, status, raw_file_path, api_endpoint, checksum_md5, rows_inserted, rows_updated, rows_skipped, rows_failed, started_at, ended_at, duration_ms, extra
24 rows
match
match_id, season_id, date, kickoff, home_team_id, away_team_id, home_score, away_score, result, round_stage, matchday, venue, city, country, referee, attendance, is_neutral, is_postponed, is_cancelled, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
101,682 rows
match_event
event_id, match_id, event_type, minute, minute_extra, half, team_id, player_id, player2_id, detail, xg_value, description, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
Many rows
match_stats
match_stats_id, match_id, possession_home, possession_away, ppda_home, ppda_away, shots_home, shots_away, shots_on_target_home, shots_on_target_away, shots_blocked_home, shots_blocked_away, big_chances_home, big_chances_away, big_chances_missed_home, big_chances_missed_away, xg_home, xg_away, npxg_home, npxg_away, total_passes_home, total_passes_away, pass_accuracy_home, pass_accuracy_away, key_passes_home, key_passes_away, corners_home, corners_away, free_kicks_home, free_kicks_away, yellow_cards_home, yellow_cards_away, red_cards_home, red_cards_away, fouls_home, fouls_away, offsides_home, offsides_away, saves_home, saves_away, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
11,763 rows
odds
odds_id, match_id, bookmaker, market, selection, value, value_open, implied_probability, recorded_at, is_closing, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
435,912 rows
player
player_id, full_name, display_name, date_of_birth, nationality, position, foot, height_cm, weight_kg, current_team_id, is_active, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
38,279 rows
player_match
player_match_id, match_id, player_id, team_id, minutes_played, is_starter, is_substituted_out, is_substituted_in, goals, assists, own_goals, penalties_scored, penalties_missed, xg, npxg, xa, key_passes, big_chances_created, big_chances_missed, total_passes, accurate_passes, pass_accuracy, progressive_passes, tackles, interceptions, clearances, aerial_duels_won, ground_duels_won, fouls_committed, fouls_drawn, yellow_card, red_card, saves, goals_conceded, clean_sheet, rating, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
0 rows
player_season
player_id, team_id, season_name, apps, goals, assists, minutes, created_at, updated_at
Many rows
season
season_id, competition_id, season_name, start_date, end_date, is_active, teams_expected, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
2,084 rows
team
team_id, name, short_name, country_code, continent, team_type, founded_year, is_active, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key
1,299 rows
team_alias
alias_id, team_id, raw_name, source_id, confidence, created_at, updated_at, created_by_run_id, updated_by_run_id, source_raw_key
1,261 rows