match

3 rows where season_id = 1687 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, away_score, result, is_neutral, date (date), created_at (date), updated_at (date)

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
38028 2014 1687 2014-09-06   Palestine 181 Taiwan 123 7 3 H Philippine Peace Cup   Manila Manila Philippines     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.609801 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38028
38029 2014 1687 2014-09-06   Philippines 32 Myanmar 125 2 3 A Philippine Peace Cup   Manila Manila Philippines     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.610285 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38029
37979 2014 1687 2014-09-03   Myanmar 125 Palestine 181 4 1 H Philippine Peace Cup   Manila Manila Philippines     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.536008 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37979

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE match (
            match_id INTEGER NOT NULL,
            season_id INTEGER NOT NULL,
            date DATE NOT NULL,
            kickoff DATETIME,
            home_team_id INTEGER NOT NULL,
            away_team_id INTEGER NOT NULL,
            home_score INTEGER,
            away_score INTEGER,
            result VARCHAR(1),
            round_stage VARCHAR(64),
            matchday INTEGER,
            venue VARCHAR(256),
            city VARCHAR(128),
            country VARCHAR(128),
            referee VARCHAR(128),
            attendance INTEGER,
            is_neutral BOOLEAN NOT NULL,
            is_postponed BOOLEAN NOT NULL,
            is_cancelled BOOLEAN NOT NULL,
            created_at DATETIME NOT NULL,
            updated_at DATETIME NOT NULL,
            created_by_run_id INTEGER,
            updated_by_run_id INTEGER,
            source_id INTEGER,
            source_raw_key VARCHAR(512),
            CONSTRAINT pk_match PRIMARY KEY (match_id),
            CONSTRAINT fk_match_season FOREIGN KEY(season_id) REFERENCES season (season_id),
            CONSTRAINT fk_match_home_team FOREIGN KEY(home_team_id) REFERENCES team (team_id),
            CONSTRAINT fk_match_away_team FOREIGN KEY(away_team_id) REFERENCES team (team_id),
            CONSTRAINT fk_match_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
            CONSTRAINT fk_match_created_by_run FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id),
            CONSTRAINT fk_match_updated_by_run FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id)
        );
CREATE INDEX ix_match_away_team_id ON match (away_team_id);
CREATE INDEX ix_match_created_by_run_id ON match (created_by_run_id);
CREATE INDEX ix_match_source_id ON match (source_id);
CREATE INDEX ix_match_updated_by_run_id ON match (updated_by_run_id);
CREATE INDEX ix_match_date ON match (date);
CREATE INDEX ix_match_season_id ON match (season_id);
CREATE INDEX ix_match_source_raw_key ON match (source_raw_key);
CREATE INDEX ix_match_home_team_id ON match (home_team_id);
CREATE UNIQUE INDEX ux_match_season_date_teams ON match(season_id, date, home_team_id, away_team_id);