home / football

match

17 rows where season_id = 1831 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, venue, city, country, is_neutral, created_at, 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
45805 2022 1831 2022-12-30   Singapore 135 Vietnam 115 0 0 D AFF Championship   Singapore Singapore Singapore     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.906781 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45805
45804 2022 1831 2022-12-30   Myanmar 125 Laos 167 2 2 D AFF Championship   Yangon Yangon Myanmar     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.906296 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45804
45799 2022 1831 2022-12-29   Cambodia 142 Brunei 193 5 1 H AFF Championship   Phnom Penh Phnom Penh Cambodia     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.903882 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45799
45800 2022 1831 2022-12-29   Indonesia 83 Thailand 143 1 1 D AFF Championship   Jakarta Jakarta Indonesia     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.904366 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45800
45797 2022 1831 2022-12-27   Laos 167 Singapore 135 0 2 A AFF Championship   Vientiane Vientiane Laos     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.902913 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45797
45798 2022 1831 2022-12-27   Vietnam 115 Malaysia 136 3 0 H AFF Championship   Hanoi Hanoi Vietnam     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.903401 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45798
45795 2022 1831 2022-12-26   Brunei 193 Indonesia 83 0 7 A AFF Championship   Kuala Lumpur Kuala Lumpur Malaysia     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.901947 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45795
45796 2022 1831 2022-12-26   Thailand 143 Philippines 32 4 0 H AFF Championship   Pathum Thani Pathum Thani Thailand     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.902434 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45796
45794 2022 1831 2022-12-24   Malaysia 136 Laos 167 5 0 H AFF Championship   Kuala Lumpur Kuala Lumpur Malaysia     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.901469 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45794
45793 2022 1831 2022-12-24   Singapore 135 Myanmar 125 3 2 H AFF Championship   Singapore Singapore Singapore     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.900982 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45793
45792 2022 1831 2022-12-23   Indonesia 83 Cambodia 142 2 1 H AFF Championship   Jakarta Jakarta Indonesia     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.900498 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45792
45791 2022 1831 2022-12-23   Philippines 32 Brunei 193 5 1 H AFF Championship   Manila Manila Philippines     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.900012 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45791
45789 2022 1831 2022-12-21   Laos 167 Vietnam 115 0 6 A AFF Championship   Vientiane Vientiane Laos     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.899047 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45789
45788 2022 1831 2022-12-21   Myanmar 125 Malaysia 136 0 1 A AFF Championship   Yangon Yangon Myanmar     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.898562 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45788
45787 2022 1831 2022-12-20   Brunei 193 Thailand 143 0 5 A AFF Championship   Kuala Lumpur Kuala Lumpur Malaysia     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.898066 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45787
45786 2022 1831 2022-12-20   Cambodia 142 Philippines 32 3 2 H AFF Championship   Phnom Penh Phnom Penh Cambodia     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.897581 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45786
44837 2022 1831 2022-01-01   Thailand 143 Indonesia 83 2 2 D AFF Championship   Kallang Kallang Singapore     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.352679 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44837

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 21.272ms