match
143 rows where away_team_id = 169 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: home_score, away_score, result, round_stage, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48915 | 2025 1906 | 2025-11-15 | Guinea 172 | Liberia 169 | 2 | 0 | H | Friendly | Casablanca | Casablanca | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.589249 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48915 | ||||
| 48796 | 2025 1907 | 2025-10-13 | Equatorial Guinea 202 | Liberia 169 | 1 | 1 | D | FIFA World Cup qualification | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.531556 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48796 | ||||
| 48625 | 2025 1907 | 2025-09-08 | Malawi 154 | Liberia 169 | 2 | 2 | D | FIFA World Cup qualification | Lilongwe | Lilongwe | Malawi | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.448099 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48625 | ||||
| 48543 | 2025 1907 | 2025-09-04 | Tunisia 152 | Liberia 169 | 3 | 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.407998 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48543 | ||||
| 47962 | 2024 1880 | 2024-11-17 | Algeria 173 | Liberia 169 | 5 | 1 | H | African Cup of Nations qualification | Tizi Ouzou | Tizi Ouzou | Algeria | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.081591 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47962 | ||||
| 47718 | 2024 1880 | 2024-10-11 | Equatorial Guinea 202 | Liberia 169 | 1 | 0 | H | African Cup of Nations qualification | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.962879 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47718 | ||||
| 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 | ||||
| 47300 | 2024 1886 | 2024-06-09 | São Tomé & Príncipe 206 | Liberia 169 | 0 | 1 | A | FIFA World Cup qualification | Oujda | Oujda | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.731630 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47300 | ||||
| 47206 | 2024 1886 | 2024-06-05 | Namibia 231 | Liberia 169 | 1 | 1 | D | FIFA World Cup qualification | Johannesburg | Johannesburg | South Africa | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.685969 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47206 | ||||
| 47014 | 2024 1880 | 2024-03-20 | Djibouti 111 | Liberia 169 | 0 | 2 | A | African Cup of Nations qualification | Marrakech | Marrakech | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.592741 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47014 | ||||
| 46639 | 2023 1858 | 2023-10-17 | Morocco 155 | Liberia 169 | 3 | 0 | H | African Cup of Nations qualification | Agadir | Agadir | Morocco | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.356444 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46639 | ||||
| 46450 | 2023 1856 | 2023-09-12 | Ghana 124 | Liberia 169 | 3 | 1 | H | Friendly | Accra | Accra | Ghana | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.264628 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46450 | ||||
| 45903 | 2023 1858 | 2023-03-24 | South Africa 21 | Liberia 169 | 2 | 2 | D | African Cup of Nations qualification | Johannesburg | Johannesburg | South Africa | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.954367 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45903 | ||||
| 45585 | 2022 1832 | 2022-09-27 | Egypt 42 | Liberia 169 | 3 | 0 | H | Friendly | Alexandria | Alexandria | Egypt | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.799986 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45585 | ||||
| 45553 | 2022 1832 | 2022-09-25 | Niger 171 | Liberia 169 | 0 | 0 | D | Friendly | Cairo | Cairo | Egypt | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.784475 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45553 | ||||
| 45395 | 2022 1835 | 2022-06-13 | Morocco 155 | Liberia 169 | 2 | 0 | H | African Cup of Nations qualification | Casablanca | Casablanca | Morocco | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.707505 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45395 | ||||
| 44550 | 2021 1813 | 2021-10-10 | Cape Verde 157 | Liberia 169 | 1 | 0 | H | FIFA World Cup qualification | Mindelo | Mindelo | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.213127 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44550 | ||||
| 44463 | 2021 1812 | 2021-09-30 | Egypt 42 | Liberia 169 | 2 | 0 | H | Friendly | Alexandria | Alexandria | Egypt | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.170704 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44463 | ||||
| 44350 | 2021 1813 | 2021-09-03 | Nigeria 120 | Liberia 169 | 2 | 0 | H | FIFA World Cup qualification | Lagos | Lagos | Nigeria | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.115861 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44350 | ||||
| 44153 | 2021 1812 | 2021-06-17 | Algeria 173 | Liberia 169 | 5 | 1 | H | Friendly | Oran | Oran | Algeria | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.020061 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44153 | ||||
| 44117 | 2021 1812 | 2021-06-14 | Libya 153 | Liberia 169 | 0 | 1 | A | Friendly | Tunis | Tunis | Tunisia | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.002351 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44117 | ||||
| 44095 | 2021 1812 | 2021-06-11 | Mauritania 168 | Liberia 169 | 1 | 0 | H | Friendly | Tunis | Tunis | Tunisia | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.991521 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44095 | ||||
| 43162 | 2019 1782 | 2019-11-07 | Egypt 42 | Liberia 169 | 1 | 0 | H | Friendly | Alexandria | Alexandria | Egypt | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.483401 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43162 | ||||
| 43086 | 2019 1787 | 2019-10-13 | Chad 170 | Liberia 169 | 1 | 0 | H | African Cup of Nations qualification | N'Djamena | N'Djamena | Chad | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.446489 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43086 | ||||
| 42992 | 2019 1782 | 2019-09-30 | Botswana 189 | Liberia 169 | 0 | 0 | D | Friendly | Gaborone | Gaborone | Botswana | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.346547 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42992 | ||||
| 42920 | 2019 1793 | 2019-09-08 | Sierra Leone 119 | Liberia 169 | 1 | 0 | H | FIFA World Cup qualification | Freetown | Freetown | Sierra Leone | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.309832 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42920 | ||||
| 42778 | 2019 1782 | 2019-07-21 | Equatorial Guinea 202 | Liberia 169 | 1 | 1 | D | Friendly | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.237495 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42778 | ||||
| 42410 | 2019 1782 | 2019-03-26 | Ivory Coast 158 | Liberia 169 | 1 | 0 | H | Friendly | Abidjan | Abidjan | Ivory Coast | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.049362 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42410 | ||||
| 42390 | 2019 1787 | 2019-03-24 | DR Congo 113 | Liberia 169 | 1 | 0 | H | African Cup of Nations qualification | Kinshasa | Kinshasa | DR Congo | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.039099 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42390 | ||||
| 41897 | 2018 1778 | 2018-10-11 | Congo Republic 161 | Liberia 169 | 3 | 1 | H | African Cup of Nations qualification | Brazzaville | Brazzaville | Congo | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.710329 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41897 | ||||
| 40719 | 2017 1746 | 2017-06-11 | Zimbabwe 102 | Liberia 169 | 3 | 0 | H | African Cup of Nations qualification | Harare | Harare | Zimbabwe | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.059391 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40719 | ||||
| 40331 | 2016 1719 | 2016-11-15 | Kenya 68 | Liberia 169 | 1 | 0 | H | Friendly | Nairobi | Nairobi | Kenya | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:06.867262 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40331 | ||||
| 40045 | 2016 1723 | 2016-09-04 | Tunisia 152 | Liberia 169 | 4 | 1 | H | African Cup of Nations qualification | Monastir | Monastir | Tunisia | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.728066 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40045 | ||||
| 39503 | 2016 1723 | 2016-03-24 | Djibouti 111 | Liberia 169 | 0 | 1 | A | African Cup of Nations qualification | Djibouti | Djibouti | Djibouti | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.380828 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39503 | ||||
| 39381 | 2015 1700 | 2015-11-17 | Ivory Coast 158 | Liberia 169 | 3 | 0 | H | FIFA World Cup qualification | Abidjan | Abidjan | Ivory Coast | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.321539 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39381 | ||||
| 39242 | 2015 1700 | 2015-10-13 | Guinea-Bissau 137 | Liberia 169 | 1 | 3 | A | FIFA World Cup qualification | Bissau | Bissau | Guinea-Bissau | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.253843 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39242 | ||||
| 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 | ||||
| 37784 | 2014 1678 | 2014-06-01 | Lesotho 191 | Liberia 169 | 2 | 0 | H | African Cup of Nations qualification | Maseru | Maseru | Lesotho | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.441256 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37784 | ||||
| 37249 | 2013 1655 | 2013-09-07 | Angola 205 | Liberia 169 | 4 | 1 | H | FIFA World Cup qualification | Lubango | Lubango | Angola | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.179906 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37249 | ||||
| 36984 | 2013 1655 | 2013-06-08 | Uganda 69 | Liberia 169 | 1 | 0 | H | FIFA World Cup qualification | Kampala | Kampala | Uganda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.969263 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36984 | ||||
| 36901 | 2013 1650 | 2013-05-27 | Iraq 164 | Liberia 169 | 0 | 1 | A | Friendly | Baghdad | Baghdad | Iraq | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.928932 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36901 | ||||
| 36335 | 2012 1624 | 2012-10-13 | Nigeria 120 | Liberia 169 | 6 | 1 | H | African Cup of Nations qualification | Calabar | Calabar | Nigeria | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.653151 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36335 | ||||
| 36072 | 2012 1623 | 2012-08-15 | Equatorial Guinea 202 | Liberia 169 | 1 | 0 | H | Friendly | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.525530 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36072 | ||||
| 36002 | 2012 1624 | 2012-06-16 | Namibia 231 | Liberia 169 | 0 | 0 | D | African Cup of Nations qualification | Windhoek | Windhoek | Namibia | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.491607 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36002 | ||||
| 35859 | 2012 1627 | 2012-06-02 | Senegal 166 | Liberia 169 | 3 | 1 | H | FIFA World Cup qualification | Dakar | Dakar | Senegal | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.368126 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35859 | ||||
| 35168 | 2011 1608 | 2011-09-04 | Zimbabwe 102 | Liberia 169 | 3 | 0 | H | African Cup of Nations qualification | Harare | Harare | Zimbabwe | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.032081 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35168 | ||||
| 34622 | 2011 1608 | 2011-03-26 | Cape Verde 157 | Liberia 169 | 4 | 2 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.712073 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34622 | ||||
| 34199 | 2010 1586 | 2010-10-09 | Mali 162 | Liberia 169 | 2 | 1 | H | African Cup of Nations qualification | Bamako | Bamako | Mali | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.505805 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34199 | ||||
| 32295 | 2008 1532 | 2008-09-06 | Gambia 133 | Liberia 169 | 3 | 0 | H | FIFA World Cup qualification | Bakau | Bakau | Gambia | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.428255 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32295 | ||||
| 32097 | 2008 1532 | 2008-06-21 | Senegal 166 | Liberia 169 | 3 | 1 | H | FIFA World Cup qualification | Dakar | Dakar | Senegal | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.330811 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32097 | ||||
| 31948 | 2008 1532 | 2008-06-06 | Algeria 173 | Liberia 169 | 3 | 0 | H | FIFA World Cup qualification | Blida | Blida | Algeria | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.204493 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31948 | ||||
| 31864 | 2008 1529 | 2008-05-27 | Libya 153 | Liberia 169 | 4 | 2 | H | Friendly | Tripoli | Tripoli | Libya | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.163166 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31864 | ||||
| 31800 | 2008 1529 | 2008-04-24 | Oman 184 | Liberia 169 | 1 | 0 | H | Friendly | Muscat | Muscat | Oman | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.104313 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31800 | ||||
| 31777 | 2008 1529 | 2008-03-26 | Sudan 150 | Liberia 169 | 0 | 2 | A | Friendly | Khartoum | Khartoum | Sudan | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.093097 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31777 | ||||
| 31237 | 2007 1511 | 2007-09-08 | Rwanda 207 | Liberia 169 | 4 | 0 | H | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.820120 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31237 | ||||
| 30710 | 2007 1511 | 2007-03-24 | Cameroon 140 | Liberia 169 | 3 | 1 | H | African Cup of Nations qualification | Yaoundé | Yaoundé | Cameroon | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.512186 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30710 | ||||
| 30235 | 2006 1494 | 2006-09-03 | Equatorial Guinea 202 | Liberia 169 | 2 | 1 | H | African Cup of Nations qualification | Malabo | Malabo | Equatorial Guinea | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.281163 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30235 | ||||
| 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 | ||||
| 29265 | 2005 1459 | 2005-06-10 | Sierra Leone 119 | Liberia 169 | 2 | 0 | H | Friendly | Freetown | Freetown | Sierra Leone | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.755804 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29265 | ||||
| 29229 | 2005 1462 | 2005-06-05 | Mali 162 | Liberia 169 | 4 | 1 | H | FIFA World Cup qualification | Ségou | Ségou | Mali | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.738371 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29229 | ||||
| 29090 | 2005 1462 | 2005-03-26 | Senegal 166 | Liberia 169 | 6 | 1 | H | FIFA World Cup qualification | Dakar | Dakar | Senegal | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.670571 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29090 | ||||
| 28563 | 2004 1443 | 2004-09-04 | Zambia 103 | Liberia 169 | 1 | 0 | H | FIFA World Cup qualification | Lusaka | Lusaka | Zambia | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.331501 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28563 | ||||
| 28343 | 2004 1443 | 2004-06-20 | Congo Republic 161 | Liberia 169 | 3 | 0 | H | FIFA World Cup qualification | Brazzaville | Brazzaville | Congo | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.224736 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28343 | ||||
| 27654 | 2003 1432 | 2003-10-12 | Gambia 133 | Liberia 169 | 2 | 0 | H | FIFA World Cup qualification | Bakau | Bakau | Gambia | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.838528 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27654 | ||||
| 27385 | 2003 1423 | 2003-07-05 | Niger 171 | Liberia 169 | 1 | 0 | H | African Cup of Nations qualification | Niamey | Niamey | Niger | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.707743 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27385 | ||||
| 27102 | 2003 1423 | 2003-03-30 | Ethiopia 112 | Liberia 169 | 1 | 0 | H | African Cup of Nations qualification | Addis Ababa | Addis Ababa | Ethiopia | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.569970 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27102 | ||||
| 26658 | 2002 1405 | 2002-09-08 | Guinea 172 | Liberia 169 | 3 | 0 | H | African Cup of Nations qualification | Conakry | Conakry | Guinea | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.300185 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26658 | ||||
| 26170 | 2002 1389 | 2002-01-19 | Mali 162 | Liberia 169 | 1 | 1 | D | African Cup of Nations | Bamako | Bamako | Mali | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.058552 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26170 | ||||
| 26132 | 2001 1359 | 2001-12-30 | Tunisia 152 | Liberia 169 | 7 | 2 | H | Friendly | Tunis | Tunis | Tunisia | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.039263 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26132 | ||||
| 25888 | 2001 1359 | 2001-08-23 | Mexico 57 | Liberia 169 | 5 | 4 | H | Friendly | Veracruz | Veracruz | Mexico | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.840250 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25888 | ||||
| 25844 | 2001 1359 | 2001-08-04 | Colombia 86 | Liberia 169 | 2 | 1 | H | Friendly | East Rutherford | East Rutherford | United States | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.818273 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25844 | ||||
| 25792 | 2001 1360 | 2001-07-14 | Sierra Leone 119 | Liberia 169 | 0 | 1 | A | FIFA World Cup qualification | Freetown | Freetown | Sierra Leone | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.792590 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25792 | ||||
| 25701 | 2001 1362 | 2001-06-16 | Mauritius 108 | Liberia 169 | 0 | 2 | A | African Cup of Nations qualification | Belle Vue Harel | Belle Vue Harel | Mauritius | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.748374 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25701 | ||||
| 25524 | 2001 1360 | 2001-05-05 | Nigeria 120 | Liberia 169 | 2 | 0 | H | FIFA World Cup qualification | Port Harcourt | Port Harcourt | Nigeria | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.662381 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25524 | ||||
| 25417 | 2001 1359 | 2001-04-08 | Mali 162 | Liberia 169 | 3 | 0 | H | Friendly | Bamako | Bamako | Mali | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.610391 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25417 | ||||
| 25355 | 2001 1362 | 2001-03-25 | Congo Republic 161 | Liberia 169 | 0 | 1 | A | African Cup of Nations qualification | Pointe-Noire | Pointe-Noire | Congo | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.580257 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25355 | ||||
| 25164 | 2001 1360 | 2001-01-28 | Ghana 124 | Liberia 169 | 1 | 3 | A | FIFA World Cup qualification | Accra | Accra | Ghana | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.487390 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25164 | ||||
| 25096 | 2000 1353 | 2000-12-16 | South Africa 21 | Liberia 169 | 2 | 1 | H | African Cup of Nations qualification | Johannesburg | Johannesburg | South Africa | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.454345 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25096 | ||||
| 24650 | 2000 1340 | 2000-06-18 | Sudan 150 | Liberia 169 | 2 | 0 | H | FIFA World Cup qualification | Omdurman | Omdurman | Sudan | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.180350 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24650 | ||||
| 24376 | 2000 1340 | 2000-04-09 | Chad 170 | Liberia 169 | 0 | 1 | A | FIFA World Cup qualification | N'Djamena | N'Djamena | Chad | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.041839 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24376 | ||||
| 23582 | 1999 1304 | 1999-06-05 | Uganda 69 | Liberia 169 | 1 | 0 | H | African Cup of Nations qualification | Kampala | Kampala | Uganda | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.570347 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23582 | ||||
| 23465 | 1999 1304 | 1999-04-09 | Algeria 173 | Liberia 169 | 4 | 1 | H | African Cup of Nations qualification | Annaba | Annaba | Algeria | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.513337 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23465 | ||||
| 23115 | 1998 1293 | 1998-10-04 | Tunisia 152 | Liberia 169 | 2 | 1 | H | African Cup of Nations qualification | Tunis | Tunis | Tunisia | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.342803 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23115 | ||||
| 22949 | 1998 1293 | 1998-08-02 | Niger 171 | Liberia 169 | 2 | 1 | H | African Cup of Nations qualification | Niamey | Niamey | Niger | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.207461 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22949 | ||||
| 22230 | 1997 1246 | 1997-08-17 | Egypt 42 | Liberia 169 | 5 | 0 | H | FIFA World Cup qualification | Cairo | Cairo | Egypt | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.849772 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22230 | ||||
| 22187 | 1997 1248 | 1997-07-13 | Togo 148 | Liberia 169 | 4 | 0 | H | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.828909 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22187 | ||||
| 21909 | 1997 1246 | 1997-04-27 | Tunisia 152 | Liberia 169 | 2 | 0 | H | FIFA World Cup qualification | Tunis | Tunis | Tunisia | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.627658 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:21909 | ||||
| 21724 | 1997 1248 | 1997-02-23 | Tanzania 101 | Liberia 169 | 1 | 1 | D | African Cup of Nations qualification | Dar es Salaam | Dar es Salaam | Tanzania | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.534240 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:21724 | ||||
| 21624 | 1997 1246 | 1997-01-11 | Namibia 231 | Liberia 169 | 0 | 0 | D | FIFA World Cup qualification | Windhoek | Windhoek | Namibia | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.485270 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:21624 | ||||
| 21396 | 1996 1238 | 1996-10-06 | DR Congo 113 | Liberia 169 | 0 | 0 | D | African Cup of Nations qualification | Kinshasa | Kinshasa | Zaïre | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.374380 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:21396 | ||||
| 21063 | 1996 1228 | 1996-06-01 | Gambia 133 | Liberia 169 | 2 | 1 | H | FIFA World Cup qualification | Banjul | Banjul | Gambia | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.211750 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:21063 | ||||
| 20804 | 1996 1223 | 1996-01-16 | Gabon 160 | Liberia 169 | 1 | 2 | A | African Cup of Nations | Durban | Durban | South Africa | 1 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:56.000841 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20804 | ||||
| 20785 | 1996 1221 | 1996-01-06 | Sierra Leone 119 | Liberia 169 | 2 | 1 | H | Friendly | Freetown | Freetown | Sierra Leone | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.991581 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20785 | ||||
| 20772 | 1995 1191 | 1995-12-24 | Cameroon 140 | Liberia 169 | 1 | 0 | H | Friendly | Yaoundé | Yaoundé | Cameroon | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.985259 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20772 | ||||
| 20761 | 1995 1191 | 1995-12-17 | Sierra Leone 119 | Liberia 169 | 1 | 0 | H | Friendly | Freetown | Freetown | Sierra Leone | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.979923 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20761 | ||||
| 20506 | 1995 1193 | 1995-07-30 | Senegal 166 | Liberia 169 | 3 | 0 | H | African Cup of Nations qualification | Dakar | Dakar | Senegal | 0 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.855701 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20506 | ||||
| 20340 | 1995 1191 | 1995-05-28 | Ivory Coast 158 | Liberia 169 | 1 | 1 | D | Friendly | Abidjan | Abidjan | Ivory Coast | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.774890 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20340 | ||||
| 20258 | 1995 1193 | 1995-04-09 | Togo 148 | Liberia 169 | 0 | 0 | D | African Cup of Nations qualification | Lomé | Lomé | Togo | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.735089 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20258 | ||||
| 20155 | 1995 1193 | 1995-02-10 | Tunisia 152 | Liberia 169 | 0 | 0 | D | African Cup of Nations qualification | Tunis | Tunis | Tunisia | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.685020 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20155 | ||||
| 20012 | 1994 1185 | 1994-11-11 | Mauritania 168 | Liberia 169 | 1 | 1 | D | African Cup of Nations qualification | Nouakchott | Nouakchott | Mauritania | 0 | 0 | 0 | 2026-06-07 06:58:43 | 2026-06-07 21:03:55.615545 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20012 |
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);