home / football

match

15 rows where season_id = 1855 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, home_team_id, away_team_id, home_score, 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
45834 2023 1855 2023-01-19   Iraq 164 Oman 184 3 2 H Gulf Cup   Basra Basra Iraq     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.920904 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45834
45832 2023 1855 2023-01-16   Bahrain 183 Oman 184 0 1 A Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.919938 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45832
45831 2023 1855 2023-01-16   Iraq 164 Qatar 190 2 1 H Gulf Cup   Basra Basra Iraq     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.919452 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45831
45829 2023 1855 2023-01-13   Qatar 190 United Arab Emirates 196 1 1 D Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.918486 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45829
45828 2023 1855 2023-01-13   Bahrain 183 Kuwait 174 1 1 D Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.918000 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45828
45827 2023 1855 2023-01-12   Saudi Arabia 179 Oman 184 1 2 A Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.917521 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45827
45826 2023 1855 2023-01-12   Iraq 164 Yemen 182 5 0 H Gulf Cup   Basra Basra Iraq     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.917034 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45826
45821 2023 1855 2023-01-10   United Arab Emirates 196 Kuwait 174 0 1 A Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.914612 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45821
45822 2023 1855 2023-01-10   Qatar 190 Bahrain 183 1 2 A Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.915094 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45822
45818 2023 1855 2023-01-09   Oman 184 Yemen 182 3 2 H Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.913159 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45818
45819 2023 1855 2023-01-09   Iraq 164 Saudi Arabia 179 2 0 H Gulf Cup   Basra Basra Iraq     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.913641 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45819
45813 2023 1855 2023-01-07   Bahrain 183 United Arab Emirates 196 2 1 H Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.910722 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45813
45814 2023 1855 2023-01-07   Kuwait 174 Qatar 190 0 2 A Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.911215 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45814
45811 2023 1855 2023-01-06   Yemen 182 Saudi Arabia 179 0 2 A Gulf Cup   Basra Basra Iraq     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.909752 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45811
45810 2023 1855 2023-01-06   Iraq 164 Oman 184 0 0 D Gulf Cup   Basra Basra Iraq     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.909265 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45810

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);
Powered by Datasette · Queries took 26.354ms