match
41 rows where away_team_id = 206 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_id, home_team_id, home_score, away_score, result, round_stage, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48748 | 2025 1907 | 2025-10-10 | Tunisia 152 | São Tomé & Príncipe 206 | 6 | 0 | H | FIFA World Cup qualification | Radès | Radès | Tunisia | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.508293 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48748 | ||||
| 48665 | 2025 1907 | 2025-09-09 | Namibia 231 | São Tomé & Príncipe 206 | 3 | 0 | H | FIFA World Cup qualification | Francistown | Francistown | Botswana | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.467930 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48665 | ||||
| 48221 | 2025 1907 | 2025-03-24 | Liberia 169 | São Tomé & Príncipe 206 | 2 | 1 | H | FIFA World Cup qualification | Monrovia | Monrovia | Liberia | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.251380 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48221 | ||||
| 48182 | 2025 1907 | 2025-03-21 | Equatorial Guinea 202 | São Tomé & Príncipe 206 | 2 | 0 | H | FIFA World Cup qualification | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.232285 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48182 | ||||
| 47224 | 2024 1886 | 2024-06-06 | Malawi 154 | São Tomé & Príncipe 206 | 3 | 1 | H | FIFA World Cup qualification | Lilongwe | Lilongwe | Malawi | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.694771 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47224 | ||||
| 47171 | 2024 1880 | 2024-03-26 | South Sudan 295 | São Tomé & Príncipe 206 | 0 | 0 | D | African Cup of Nations qualification | Berkane | Berkane | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.668992 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47171 | ||||
| 46716 | 2023 1872 | 2023-11-17 | Tunisia 152 | São Tomé & Príncipe 206 | 4 | 0 | H | FIFA World Cup qualification | Radès | Radès | Tunisia | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.393802 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46716 | ||||
| 46402 | 2023 1858 | 2023-09-10 | Nigeria 120 | São Tomé & Príncipe 206 | 6 | 0 | H | African Cup of Nations qualification | Uyo | Uyo | Nigeria | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.241247 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46402 | ||||
| 46056 | 2023 1858 | 2023-06-14 | Guinea-Bissau 137 | São Tomé & Príncipe 206 | 1 | 0 | H | African Cup of Nations qualification | Bissau | Bissau | Guinea-Bissau | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.073032 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46056 | ||||
| 45855 | 2023 1858 | 2023-03-22 | Sierra Leone 119 | São Tomé & Príncipe 206 | 2 | 2 | D | African Cup of Nations qualification | Agadir | Agadir | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.931052 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45855 | ||||
| 45305 | 2022 1835 | 2022-06-09 | Guinea-Bissau 137 | São Tomé & Príncipe 206 | 5 | 1 | H | African Cup of Nations qualification | Agadir | Agadir | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.663782 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45305 | ||||
| 45060 | 2022 1835 | 2022-03-27 | Mauritius 108 | São Tomé & Príncipe 206 | 3 | 3 | D | African Cup of Nations qualification | Belle Vue Harel | Belle Vue Harel | Mauritius | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.544298 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45060 | ||||
| 45004 | 2022 1835 | 2022-03-24 | Mauritius 108 | São Tomé & Príncipe 206 | 3 | 0 | H | African Cup of Nations qualification | Saint Pierre | Saint Pierre | Mauritius | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.516899 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45004 | ||||
| 43852 | 2021 1814 | 2021-03-28 | Ghana 124 | São Tomé & Príncipe 206 | 3 | 1 | H | African Cup of Nations qualification | Cape Coast | Cape Coast | Ghana | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.819378 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43852 | ||||
| 43666 | 2020 1811 | 2020-11-16 | South Africa 21 | São Tomé & Príncipe 206 | 4 | 2 | H | African Cup of Nations qualification | Port Elizabeth | Port Elizabeth | South Africa | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.729085 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43666 | ||||
| 43617 | 2020 1811 | 2020-11-13 | South Africa 21 | São Tomé & Príncipe 206 | 2 | 0 | H | African Cup of Nations qualification | Durban | Durban | South Africa | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.704862 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43617 | ||||
| 43172 | 2019 1787 | 2019-11-13 | Sudan 150 | São Tomé & Príncipe 206 | 4 | 0 | H | African Cup of Nations qualification | Omdurman | Omdurman | Sudan | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.488241 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43172 | ||||
| 42999 | 2019 1787 | 2019-10-09 | Mauritius 108 | São Tomé & Príncipe 206 | 1 | 3 | A | African Cup of Nations qualification | Belle Vue Harel | Belle Vue Harel | Mauritius | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.350167 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42999 | ||||
| 42981 | 2019 1793 | 2019-09-10 | Guinea-Bissau 137 | São Tomé & Príncipe 206 | 2 | 1 | H | FIFA World Cup qualification | Bissau | Bissau | Guinea-Bissau | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.340950 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42981 | ||||
| 41383 | 2018 1765 | 2018-03-24 | Uganda 69 | São Tomé & Príncipe 206 | 3 | 1 | H | Friendly | Kampala | Kampala | Uganda | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.449303 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41383 | ||||
| 40516 | 2017 1746 | 2017-03-26 | Madagascar 107 | São Tomé & Príncipe 206 | 3 | 2 | H | African Cup of Nations qualification | Antananarivo | Antananarivo | Madagascar | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:06.957202 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40516 | ||||
| 40037 | 2016 1723 | 2016-09-04 | Morocco 155 | São Tomé & Príncipe 206 | 2 | 0 | H | African Cup of Nations qualification | Rabat | Rabat | Morocco | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.724190 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40037 | ||||
| 39582 | 2016 1723 | 2016-03-28 | Libya 153 | São Tomé & Príncipe 206 | 4 | 0 | H | African Cup of Nations qualification | Cairo | Cairo | Egypt | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.419321 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39582 | ||||
| 39206 | 2015 1700 | 2015-10-11 | Ethiopia 112 | São Tomé & Príncipe 206 | 3 | 0 | H | FIFA World Cup qualification | Addis Ababa | Addis Ababa | Ethiopia | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.236269 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39206 | ||||
| 38788 | 2015 1709 | 2015-06-13 | Cape Verde 157 | São Tomé & Príncipe 206 | 7 | 1 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.979227 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38788 | ||||
| 37777 | 2014 1678 | 2014-06-01 | Benin 156 | São Tomé & Príncipe 206 | 2 | 0 | H | African Cup of Nations qualification | Porto-Novo | Porto-Novo | Benin | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.437857 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37777 | ||||
| 35998 | 2012 1624 | 2012-06-16 | Sierra Leone 119 | São Tomé & Príncipe 206 | 4 | 2 | H | African Cup of Nations qualification | Freetown | Freetown | Sierra Leone | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.436219 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35998 | ||||
| 35594 | 2012 1624 | 2012-01-22 | Lesotho 191 | São Tomé & Príncipe 206 | 0 | 0 | D | African Cup of Nations qualification | Maseru | Maseru | Lesotho | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.239310 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35594 | ||||
| 35454 | 2011 1613 | 2011-11-15 | Congo Republic 161 | São Tomé & Príncipe 206 | 1 | 1 | D | FIFA World Cup qualification | Pointe-Noire | Pointe-Noire | Congo | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.171181 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35454 | ||||
| 27747 | 2003 1432 | 2003-11-16 | Libya 153 | São Tomé & Príncipe 206 | 8 | 0 | H | FIFA World Cup qualification | Benghazi | Benghazi | Libya | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.883740 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27747 | ||||
| 27706 | 2003 1411 | 2003-11-12 | Equatorial Guinea 202 | São Tomé & Príncipe 206 | 3 | 1 | H | Friendly | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.863762 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27706 | ||||
| 24733 | 2000 1353 | 2000-07-15 | Gabon 160 | São Tomé & Príncipe 206 | 4 | 1 | H | African Cup of Nations qualification | Libreville | Libreville | Gabon | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.222212 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24733 | ||||
| 24422 | 2000 1340 | 2000-04-22 | Sierra Leone 119 | São Tomé & Príncipe 206 | 4 | 0 | H | FIFA World Cup qualification | Freetown | Freetown | Sierra Leone | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.065102 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24422 | ||||
| 23983 | 1999 1330 | 1999-11-13 | Central African Republic 163 | São Tomé & Príncipe 206 | 3 | 0 | H | UNIFFAC Cup | Libreville | Libreville | Gabon | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.765390 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23983 | ||||
| 23981 | 1999 1330 | 1999-11-12 | Congo Republic 161 | São Tomé & Príncipe 206 | 1 | 0 | H | UNIFFAC Cup | Libreville | Libreville | Gabon | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.764421 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23981 | ||||
| 23980 | 1999 1330 | 1999-11-11 | Gabon 160 | São Tomé & Príncipe 206 | 1 | 0 | H | UNIFFAC Cup | Libreville | Libreville | Gabon | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.763932 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23980 | ||||
| 23975 | 1999 1330 | 1999-11-10 | Chad 170 | São Tomé & Príncipe 206 | 5 | 0 | H | UNIFFAC Cup | Libreville | Libreville | Gabon | 1 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.761494 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23975 | ||||
| 22980 | 1998 1293 | 1998-08-18 | Togo 148 | São Tomé & Príncipe 206 | 2 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.222558 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22980 | ||||
| 14881 | 1985 952 | 1985-06-30 | Angola 205 | São Tomé & Príncipe 206 | 3 | 2 | H | Friendly | Praia | Praia | Cape Verde | 1 | 0 | 0 | 2026-06-07 06:58:40 | 2026-06-07 21:03:52.742121 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:14881 | ||||
| 12794 | 1981 867 | 1981-06-01 | Equatorial Guinea 202 | São Tomé & Príncipe 206 | 1 | 1 | D | Friendly | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:58:39 | 2026-06-07 21:03:51.574049 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:12794 | ||||
| 10526 | 1976 752 | 1976-05-02 | Gabon 160 | São Tomé & Príncipe 206 | 6 | 1 | H | Friendly | Libreville | Libreville | Gabon | 0 | 0 | 0 | 2026-06-07 06:58:37 | 2026-06-07 21:03:50.356779 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:10526 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);