match
182 rows where home_team_id = 148 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48740 | 2025 1907 | 2025-10-10 | Togo 148 | DR Congo 113 | 0 | 1 | A | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.504403 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48740 | ||||
| 48653 | 2025 1907 | 2025-09-09 | Togo 148 | Sudan 150 | 1 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.462105 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48653 | ||||
| 48192 | 2025 1907 | 2025-03-22 | Togo 148 | Mauritania 168 | 2 | 2 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.237170 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48192 | ||||
| 47963 | 2024 1880 | 2024-11-17 | Togo 148 | Equatorial Guinea 202 | 3 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.082070 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47963 | ||||
| 47781 | 2024 1880 | 2024-10-14 | Togo 148 | Algeria 173 | 0 | 1 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.993622 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47781 | ||||
| 47529 | 2024 1880 | 2024-09-06 | Togo 148 | Liberia 169 | 1 | 1 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.870496 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47529 | ||||
| 47205 | 2024 1886 | 2024-06-05 | Togo 148 | South Sudan 295 | 1 | 1 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.685490 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47205 | ||||
| 46869 | 2024 1877 | 2024-01-05 | Togo 148 | Algeria 173 | 0 | 3 | A | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.468493 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46869 | ||||
| 46818 | 2023 1872 | 2023-11-21 | Togo 148 | Senegal 166 | 0 | 0 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.443661 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46818 | ||||
| 46403 | 2023 1858 | 2023-09-10 | Togo 148 | Cape Verde 157 | 3 | 2 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.241729 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46403 | ||||
| 46049 | 2023 1856 | 2023-06-14 | Togo 148 | Lesotho 191 | 2 | 0 | H | Friendly | Johannesburg | Johannesburg | South Africa | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.069663 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46049 | ||||
| 46005 | 2023 1858 | 2023-03-28 | Togo 148 | Burkina Faso 159 | 1 | 1 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.048362 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46005 | ||||
| 45187 | 2022 1835 | 2022-06-03 | Togo 148 | Eswatini 188 | 2 | 2 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.606190 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45187 | ||||
| 45111 | 2022 1832 | 2022-03-29 | Togo 148 | Benin 156 | 1 | 1 | D | Friendly | Antalya | Antalya | Turkey | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.569097 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45111 | ||||
| 45001 | 2022 1832 | 2022-03-24 | Togo 148 | Sierra Leone 119 | 3 | 0 | H | Friendly | Antalya | Antalya | Turkey | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.515392 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45001 | ||||
| 44639 | 2021 1813 | 2021-11-11 | Togo 148 | Senegal 166 | 1 | 1 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.256351 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44639 | ||||
| 44534 | 2021 1813 | 2021-10-09 | Togo 148 | Congo Republic 161 | 1 | 1 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.205380 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44534 | ||||
| 44378 | 2021 1813 | 2021-09-05 | Togo 148 | Namibia 231 | 0 | 1 | A | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.129528 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44378 | ||||
| 43865 | 2021 1814 | 2021-03-29 | Togo 148 | Kenya 68 | 1 | 2 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.825678 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43865 | ||||
| 43696 | 2020 1811 | 2020-11-17 | Togo 148 | Egypt 42 | 1 | 3 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.743705 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43696 | ||||
| 43518 | 2020 1807 | 2020-10-12 | Togo 148 | Sudan 150 | 1 | 1 | D | Friendly | Tunis | Tunis | Tunisia | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.656714 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43518 | ||||
| 43185 | 2019 1787 | 2019-11-14 | Togo 148 | Comoros 213 | 0 | 1 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.494555 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43185 | ||||
| 42988 | 2019 1793 | 2019-09-10 | Togo 148 | Comoros 213 | 2 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.344504 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42988 | ||||
| 42137 | 2018 1778 | 2018-11-18 | Togo 148 | Algeria 173 | 1 | 4 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.913972 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42137 | ||||
| 41916 | 2018 1778 | 2018-10-12 | Togo 148 | Gambia 133 | 1 | 1 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.719916 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41916 | ||||
| 41821 | 2018 1778 | 2018-09-09 | Togo 148 | Benin 156 | 0 | 0 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.671799 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41821 | ||||
| 41180 | 2017 1743 | 2017-11-12 | Togo 148 | Mauritius 108 | 6 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.345884 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41180 | ||||
| 40612 | 2017 1743 | 2017-06-04 | Togo 148 | Comoros 213 | 2 | 0 | H | Friendly | Marseille | Marseille | France | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.004728 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40612 | ||||
| 40425 | 2017 1745 | 2017-01-24 | Togo 148 | DR Congo 113 | 1 | 3 | A | African Cup of Nations | Port-Gentil | Port-Gentil | Gabon | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:06.912892 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40425 | ||||
| 40272 | 2016 1719 | 2016-11-11 | Togo 148 | Comoros 213 | 2 | 2 | D | Friendly | Tunis | Tunis | Tunisia | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.838574 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40272 | ||||
| 40171 | 2016 1719 | 2016-10-09 | Togo 148 | Mozambique 203 | 2 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.789419 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40171 | ||||
| 40095 | 2016 1719 | 2016-10-04 | Togo 148 | Uganda 69 | 1 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.752397 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40095 | ||||
| 40044 | 2016 1723 | 2016-09-04 | Togo 148 | Djibouti 111 | 5 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.727581 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40044 | ||||
| 39674 | 2016 1719 | 2016-05-27 | Togo 148 | Zambia 103 | 1 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.464361 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39674 | ||||
| 39642 | 2016 1723 | 2016-03-29 | Togo 148 | Tunisia 152 | 0 | 0 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.448866 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39642 | ||||
| 39309 | 2015 1700 | 2015-11-12 | Togo 148 | Uganda 69 | 0 | 1 | A | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.286433 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39309 | ||||
| 38825 | 2015 1709 | 2015-06-14 | Togo 148 | Liberia 169 | 2 | 1 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:05.997401 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38825 | ||||
| 38312 | 2014 1678 | 2014-11-15 | Togo 148 | Guinea 172 | 1 | 4 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.747797 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38312 | ||||
| 38230 | 2014 1678 | 2014-10-15 | Togo 148 | Uganda 69 | 1 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.707965 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38230 | ||||
| 38093 | 2014 1678 | 2014-09-10 | Togo 148 | Ghana 124 | 2 | 3 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.641320 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38093 | ||||
| 37268 | 2013 1655 | 2013-09-08 | Togo 148 | DR Congo 113 | 2 | 1 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.189186 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37268 | ||||
| 36991 | 2013 1655 | 2013-06-09 | Togo 148 | Cameroon 140 | 0 | 3 | A | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.972656 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36991 | ||||
| 36676 | 2013 1653 | 2013-01-30 | Togo 148 | Tunisia 152 | 1 | 1 | D | African Cup of Nations | Nelspruit | Nelspruit | South Africa | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.818910 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36676 | ||||
| 36624 | 2013 1650 | 2013-01-13 | Togo 148 | Niger 171 | 2 | 1 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.793538 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36624 | ||||
| 36350 | 2012 1624 | 2012-10-14 | Togo 148 | Gabon 160 | 2 | 1 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.660398 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36350 | ||||
| 36007 | 2012 1624 | 2012-06-17 | Togo 148 | Kenya 68 | 1 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.494060 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36007 | ||||
| 35881 | 2012 1627 | 2012-06-03 | Togo 148 | Libya 153 | 1 | 1 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.378821 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35881 | ||||
| 35496 | 2011 1613 | 2011-11-15 | Togo 148 | Guinea-Bissau 137 | 1 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.191667 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35496 | ||||
| 35167 | 2011 1608 | 2011-09-04 | Togo 148 | Botswana 189 | 1 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.031600 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35167 | ||||
| 34359 | 2010 1586 | 2010-11-17 | Togo 148 | Chad 170 | 0 | 0 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.583873 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34359 | ||||
| 34218 | 2010 1586 | 2010-10-10 | Togo 148 | Tunisia 152 | 1 | 2 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.515069 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34218 | ||||
| 33937 | 2010 1586 | 2010-07-09 | Togo 148 | Malawi 154 | 1 | 1 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.293624 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33937 | ||||
| 33500 | 2009 1562 | 2009-11-14 | Togo 148 | Gabon 160 | 1 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.080031 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33500 | ||||
| 33287 | 2009 1562 | 2009-09-06 | Togo 148 | Morocco 155 | 1 | 1 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.976176 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33287 | ||||
| 33214 | 2009 1557 | 2009-08-12 | Togo 148 | Angola 205 | 0 | 2 | A | Friendly | Lisbon | Lisbon | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.940597 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33214 | ||||
| 32863 | 2009 1562 | 2009-03-28 | Togo 148 | Cameroon 140 | 1 | 0 | H | FIFA World Cup qualification | Accra | Accra | Ghana | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.714473 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32863 | ||||
| 32605 | 2008 1529 | 2008-11-19 | Togo 148 | Rwanda 207 | 1 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.584506 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32605 | ||||
| 32459 | 2008 1532 | 2008-10-11 | Togo 148 | Eswatini 188 | 6 | 0 | H | FIFA World Cup qualification | Accra | Accra | Ghana | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.510924 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32459 | ||||
| 31902 | 2008 1532 | 2008-05-31 | Togo 148 | Zambia 103 | 1 | 0 | H | FIFA World Cup qualification | Accra | Accra | Ghana | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.181826 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31902 | ||||
| 31725 | 2008 1529 | 2008-03-25 | Togo 148 | Guinea 172 | 0 | 2 | A | Friendly | Paris | Paris | France | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.066624 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31725 | ||||
| 31315 | 2007 1511 | 2007-10-12 | Togo 148 | Mali 162 | 0 | 2 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.859382 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31315 | ||||
| 31173 | 2007 1502 | 2007-08-22 | Togo 148 | Zambia 103 | 3 | 1 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.788780 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31173 | ||||
| 30744 | 2007 1511 | 2007-03-24 | Togo 148 | Sierra Leone 119 | 3 | 1 | H | African Cup of Nations qualification | Woumé | Woumé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.528683 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30744 | ||||
| 30673 | 2007 1502 | 2007-02-07 | Togo 148 | Cameroon 140 | 2 | 2 | D | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.494117 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30673 | ||||
| 30245 | 2006 1494 | 2006-09-03 | Togo 148 | Benin 156 | 2 | 1 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.286088 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30245 | ||||
| 30193 | 2006 1479 | 2006-08-29 | Togo 148 | Niger 171 | 1 | 1 | D | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.260783 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30193 | ||||
| 30083 | 2006 1490 | 2006-06-23 | Togo 148 | France 13 | 0 | 2 | A | FIFA World Cup | Cologne | Cologne | Germany | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.207615 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30083 | ||||
| 30068 | 2006 1490 | 2006-06-19 | Togo 148 | Switzerland 14 | 0 | 2 | A | FIFA World Cup | Dortmund | Dortmund | Germany | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.200349 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30068 | ||||
| 29751 | 2006 1480 | 2006-01-21 | Togo 148 | DR Congo 113 | 0 | 2 | A | African Cup of Nations | Cairo | Cairo | Egypt | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.992271 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29751 | ||||
| 29475 | 2005 1462 | 2005-09-04 | Togo 148 | Liberia 169 | 3 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.857846 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29475 | ||||
| 29231 | 2005 1462 | 2005-06-05 | Togo 148 | Zambia 103 | 4 | 1 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.739346 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29231 | ||||
| 29176 | 2005 1459 | 2005-05-29 | Togo 148 | Burkina Faso 159 | 1 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.712568 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29176 | ||||
| 28686 | 2004 1443 | 2004-10-10 | Togo 148 | Mali 162 | 1 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.391218 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28686 | ||||
| 28576 | 2004 1443 | 2004-09-05 | Togo 148 | Congo Republic 161 | 2 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.337797 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28576 | ||||
| 28355 | 2004 1443 | 2004-06-20 | Togo 148 | Senegal 166 | 3 | 1 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.230568 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28355 | ||||
| 28169 | 2004 1438 | 2004-05-23 | Togo 148 | Benin 156 | 1 | 1 | D | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.140336 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28169 | ||||
| 27753 | 2003 1432 | 2003-11-16 | Togo 148 | Equatorial Guinea 202 | 2 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.886654 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27753 | ||||
| 27321 | 2003 1423 | 2003-06-22 | Togo 148 | Kenya 68 | 2 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.676691 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27321 | ||||
| 27260 | 2003 1423 | 2003-06-08 | Togo 148 | Cape Verde 157 | 5 | 2 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.647008 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27260 | ||||
| 27199 | 2003 1411 | 2003-05-25 | Togo 148 | Benin 156 | 3 | 1 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.617227 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27199 | ||||
| 26713 | 2002 1405 | 2002-10-12 | Togo 148 | Mauritania 168 | 1 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.327012 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26713 | ||||
| 26184 | 2002 1389 | 2002-01-21 | Togo 148 | Ivory Coast 158 | 0 | 0 | D | African Cup of Nations | Sikasso | Sikasso | Mali | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.065606 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26184 | ||||
| 26117 | 2001 1359 | 2001-12-22 | Togo 148 | Burkina Faso 159 | 1 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.031711 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26117 | ||||
| 25800 | 2001 1360 | 2001-07-15 | Togo 148 | Libya 153 | 2 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.796479 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25800 | ||||
| 25713 | 2001 1362 | 2001-06-17 | Togo 148 | Senegal 166 | 1 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.754185 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25713 | ||||
| 25534 | 2001 1360 | 2001-05-06 | Togo 148 | Zambia 103 | 3 | 2 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.667242 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25534 | ||||
| 25300 | 2001 1360 | 2001-03-11 | Togo 148 | Angola 205 | 1 | 1 | D | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.553652 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25300 | ||||
| 25168 | 2001 1360 | 2001-01-28 | Togo 148 | Cameroon 140 | 0 | 2 | A | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.489337 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25168 | ||||
| 25108 | 2001 1359 | 2001-01-07 | Togo 148 | Burkina Faso 159 | 1 | 1 | D | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.460128 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25108 | ||||
| 24957 | 2000 1353 | 2000-10-08 | Togo 148 | Uganda 69 | 3 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.333272 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24957 | ||||
| 24882 | 2000 1353 | 2000-09-03 | Togo 148 | Sierra Leone 119 | 2 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.296594 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24882 | ||||
| 24441 | 2000 1340 | 2000-04-23 | Togo 148 | Guinea-Bissau 137 | 3 | 0 | H | FIFA World Cup qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.074744 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24441 | ||||
| 24078 | 2000 1331 | 2000-01-19 | Togo 148 | Egypt 42 | 1 | 0 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.894800 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24078 | ||||
| 23373 | 1999 1304 | 1999-02-28 | Togo 148 | Morocco 155 | 2 | 3 | A | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.468576 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23373 | ||||
| 23114 | 1998 1293 | 1998-10-04 | Togo 148 | Guinea 172 | 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.342321 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23114 | ||||
| 23078 | 1998 1272 | 1998-09-20 | Togo 148 | Mali 162 | 0 | 1 | A | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.324838 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23078 | ||||
| 23051 | 1998 1272 | 1998-09-06 | Togo 148 | Benin 156 | 0 | 1 | A | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.311685 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23051 | ||||
| 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 | ||||
| 22568 | 1998 1272 | 1998-02-01 | Togo 148 | Mali 162 | 0 | 4 | A | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.014754 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22568 | ||||
| 22559 | 1998 1272 | 1998-01-29 | Togo 148 | Mali 162 | 2 | 1 | H | Friendly | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.010132 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22559 |
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);