home / football

match

198 rows where away_team_id = 203 sorted by date descending

✎ View and edit SQL

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
49098 2026 1928 2026-01-05   Nigeria 120 Mozambique 203 4 0 H African Cup of Nations   Fez Fez Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.734371 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49098
49079 2025 1927 2025-12-28   Gabon 160 Mozambique 203 2 3 A African Cup of Nations   Agadir Agadir Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.724707 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49079
49067 2025 1927 2025-12-24   Ivory Coast 158 Mozambique 203 1 0 H African Cup of Nations   Marrakesh Marrakesh Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.718603 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49067
48896 2025 1906 2025-11-14   Morocco 155 Mozambique 203 1 0 H Friendly   Tangier Tangier Morocco     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.580066 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48896
48831 2025 1907 2025-10-14   Somalia 178 Mozambique 203 0 1 A FIFA World Cup qualification   Bir El Djir Bir El Djir Algeria     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.548553 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48831
48574 2025 1907 2025-09-05   Uganda 69 Mozambique 203 4 0 H FIFA World Cup qualification   Kampala Kampala Uganda     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.423185 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48574
48432 2025 1906 2025-06-10   South Africa 21 Mozambique 203 2 0 H Friendly   Polokwane Polokwane South Africa     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.354001 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48432
48284 2025 1907 2025-03-25   Algeria 173 Mozambique 203 5 1 H FIFA World Cup qualification   Tizi Ouzou Tizi Ouzou Algeria     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.282071 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48284
48036 2024 1880 2024-11-19   Guinea-Bissau 137 Mozambique 203 1 2 A African Cup of Nations qualification   Bissau Bissau Guinea-Bissau     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.161093 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48036
47782 2024 1880 2024-10-14   Eswatini 188 Mozambique 203 0 3 A African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.994106 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47782
47533 2024 1880 2024-09-06   Mali 162 Mozambique 203 1 1 D African Cup of Nations qualification   Bamako Bamako Mali     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.872514 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47533
47316 2024 1886 2024-06-10   Guinea 172 Mozambique 203 0 1 A FIFA World Cup qualification   El Jadida El Jadida Morocco     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.739425 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47316
46937 2024 1879 2024-01-19   Cape Verde 157 Mozambique 203 3 0 H African Cup of Nations   Abidjan Abidjan Ivory Coast     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.501549 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46937
46910 2024 1879 2024-01-14   Egypt 42 Mozambique 203 2 2 D African Cup of Nations   Abidjan Abidjan Ivory Coast     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.488421 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46910
46881 2024 1877 2024-01-08   Botswana 189 Mozambique 203 1 1 D Friendly   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.474299 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46881
46691 2023 1872 2023-11-16   Botswana 189 Mozambique 203 2 3 A FIFA World Cup qualification   Francistown Francistown Botswana     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.381696 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46691
46542 2023 1856 2023-10-13   Angola 205 Mozambique 203 1 1 D Friendly   Albufeira Albufeira Portugal     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.309397 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46542
46275 2023 1868 2023-07-12   Mauritius 108 Mozambique 203 0 1 A COSAFA Cup   KwaMashu KwaMashu South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.179402 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46275
46139 2023 1858 2023-06-18   Rwanda 207 Mozambique 203 0 2 A African Cup of Nations qualification   Butare Butare Rwanda     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.113355 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46139
45904 2023 1858 2023-03-24   Senegal 166 Mozambique 203 5 1 H African Cup of Nations qualification   Diamniadio Diamniadio Senegal     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.954845 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45904
45676 2022 1832 2022-11-17   South Africa 21 Mozambique 203 2 1 H Friendly   Mbombela Mbombela South Africa     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.844326 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45676
45461 2022 1845 2022-07-15   Namibia 231 Mozambique 203 1 0 H COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.739782 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45461
45457 2022 1845 2022-07-13   South Africa 21 Mozambique 203 0 0 D COSAFA Cup   KwaMashu KwaMashu South Africa     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.737840 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45457
45300 2022 1835 2022-06-08   Benin 156 Mozambique 203 0 1 A African Cup of Nations qualification   Cotonou Cotonou Benin     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.661361 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45300
45038 2022 1832 2022-03-26   Mauritania 168 Mozambique 203 2 1 H Friendly   Nouakchott Nouakchott Mauritania     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.533505 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45038
44691 2021 1813 2021-11-13   Ivory Coast 158 Mozambique 203 3 0 H FIFA World Cup qualification   Cotonou Cotonou Benin     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.281896 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44691
44515 2021 1813 2021-10-08   Cameroon 140 Mozambique 203 3 1 H FIFA World Cup qualification   Douala Douala Cameroon     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.196096 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44515
44413 2021 1813 2021-09-07   Malawi 154 Mozambique 203 1 0 H FIFA World Cup qualification   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.146397 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44413
44266 2021 1822 2021-07-18   Eswatini 188 Mozambique 203 1 1 D COSAFA Cup   Port Elizabeth Port Elizabeth South Africa     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.075143 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44266
44261 2021 1822 2021-07-16   South Africa 21 Mozambique 203 3 0 H COSAFA Cup   Port Elizabeth Port Elizabeth South Africa     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.072716 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44261
44233 2021 1822 2021-07-09   Senegal 166 Mozambique 203 1 0 H COSAFA Cup   Port Elizabeth Port Elizabeth South Africa     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.059156 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44233
43764 2021 1814 2021-03-24   Rwanda 207 Mozambique 203 1 0 H African Cup of Nations qualification   Kigali Kigali Rwanda     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.776648 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43764
43605 2020 1811 2020-11-12   Cameroon 140 Mozambique 203 4 1 H African Cup of Nations qualification   Douala Douala Cameroon     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.699020 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43605
43287 2019 1787 2019-11-18   Cape Verde 157 Mozambique 203 2 2 D African Cup of Nations qualification   Praia Praia Cape Verde     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.544293 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43287
43094 2019 1782 2019-10-13   Kenya 68 Mozambique 203 0 1 A Friendly   Kenya Kenya Kenya     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.450352 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43094
42820 2019 1793 2019-09-04   Mauritius 108 Mozambique 203 0 1 A FIFA World Cup qualification   Belle Vue Maurel Belle Vue Maurel Mauritius     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.258881 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42820
42437 2019 1789 2019-05-28   Seychelles 201 Mozambique 203 0 0 D COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.063085 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42437
42363 2019 1787 2019-03-23   Guinea-Bissau 137 Mozambique 203 2 2 D African Cup of Nations qualification   Bissau Bissau Guinea-Bissau     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.025383 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42363
42033 2018 1778 2018-10-16   Namibia 231 Mozambique 203 1 0 H African Cup of Nations qualification   Windhoek Windhoek Namibia     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.863343 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42033
41496 2018 1768 2018-05-29   Comoros 213 Mozambique 203 0 3 A COSAFA Cup   Polokwane Polokwane South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.506738 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41496
41475 2018 1768 2018-05-27   Madagascar 107 Mozambique 203 2 1 H COSAFA Cup   Polokwane Polokwane South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.496038 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41475
40802 2017 1755 2017-06-28   Seychelles 201 Mozambique 203 1 2 A COSAFA Cup   Rustenburg Rustenburg South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.101625 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40802
40699 2017 1746 2017-06-10   Zambia 103 Mozambique 203 0 1 A African Cup of Nations qualification   Ndola Ndola Zambia     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.049196 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40699
40282 2016 1719 2016-11-12   Kenya 68 Mozambique 203 1 0 H Friendly   Nairobi Nairobi Kenya     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.843439 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40282
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
39918 2016 1734 2016-06-21   Namibia 231 Mozambique 203 3 0 H COSAFA Cup   Windhoek Windhoek Namibia     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.611291 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39918
39908 2016 1734 2016-06-19   DR Congo 113 Mozambique 203 1 0 H COSAFA Cup   Windhoek Windhoek Namibia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.606365 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39908
39789 2016 1723 2016-06-04   Rwanda 207 Mozambique 203 2 3 A African Cup of Nations qualification   Kigali Kigali Rwanda     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.548080 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39789
39506 2016 1723 2016-03-24   Ghana 124 Mozambique 203 3 1 H African Cup of Nations qualification   Accra Accra Ghana     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.382284 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39506
39344 2015 1700 2015-11-14   Gabon 160 Mozambique 203 1 0 H FIFA World Cup qualification   Libreville Libreville Gabon     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.303459 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39344
39074 2015 1709 2015-09-06   Mauritius 108 Mozambique 203 1 0 H African Cup of Nations qualification   Curepipe Curepipe Mauritius     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.172160 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39074
38686 2015 1706 2015-05-30   Namibia 231 Mozambique 203 2 0 H COSAFA Cup   Moruleng-Saulspoort Moruleng-Saulspoort South Africa     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.929694 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38686
38676 2015 1706 2015-05-28   Botswana 189 Mozambique 203 1 2 A COSAFA Cup   Moruleng-Saulspoort Moruleng-Saulspoort South Africa     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.924837 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38676
38588 2015 1696 2015-03-29   Botswana 189 Mozambique 203 1 2 A Friendly   Lobatse Lobatse Botswana     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.881687 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38588
38370 2014 1678 2014-11-19   Niger 171 Mozambique 203 1 1 D African Cup of Nations qualification   Niamey Niamey Niger     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.775931 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38370
38222 2014 1678 2014-10-15   Cape Verde 157 Mozambique 203 1 0 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.704078 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38222
38033 2014 1678 2014-09-06   Zambia 103 Mozambique 203 0 0 D African Cup of Nations qualification   Ndola Ndola Zambia     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.612223 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38033
37944 2014 1678 2014-07-20   Tanzania 101 Mozambique 203 2 2 D African Cup of Nations qualification   Dar es Salaam Dar es Salaam Tanzania     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.519051 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37944
37927 2014 1675 2014-07-06   Malawi 154 Mozambique 203 1 1 D Friendly   Lilongwe Lilongwe Malawi     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.510762 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37927
37756 2014 1678 2014-05-30   South Sudan 295 Mozambique 203 0 0 D African Cup of Nations qualification   Khartoum Khartoum Sudan     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.427616 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37756
37498 2013 1650 2013-11-19   Namibia 231 Mozambique 203 0 0 D Friendly   Windhoek Windhoek Namibia     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.301436 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37498
37269 2013 1655 2013-09-08   Zimbabwe 102 Mozambique 203 1 1 D FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.189671 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37269
37121 2013 1664 2013-07-18   Angola 205 Mozambique 203 0 1 A COSAFA Cup   Kitwe Kitwe Zambia     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.117520 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37121
37112 2013 1664 2013-07-16   Namibia 231 Mozambique 203 0 1 A COSAFA Cup   Kitwe Kitwe Zambia     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.113107 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37112
37103 2013 1664 2013-07-14   Zambia 103 Mozambique 203 3 1 H COSAFA Cup   Kitwe Kitwe Zambia     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.108719 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37103
36988 2013 1655 2013-06-09   Guinea 172 Mozambique 203 6 1 H FIFA World Cup qualification   Conakry Conakry Guinea     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.971206 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36988
36337 2012 1624 2012-10-13   Morocco 155 Mozambique 203 4 0 H African Cup of Nations qualification   Marrakech Marrakech Morocco     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.654110 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36337
36232 2012 1623 2012-09-11   South Africa 21 Mozambique 203 2 0 H Friendly   Nelspruit Nelspruit South Africa     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.603221 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36232
36056 2012 1623 2012-08-15   Angola 205 Mozambique 203 2 0 H Friendly   Benguela Benguela Angola     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.517810 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36056
35828 2012 1627 2012-06-01   Egypt 42 Mozambique 203 2 0 H FIFA World Cup qualification   Alexandria Alexandria Egypt     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.353129 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35828
35751 2012 1623 2012-05-02   Iran 99 Mozambique 203 3 0 H Friendly   Karaj Karaj Iran     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.315713 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35751
35712 2012 1624 2012-02-29   Tanzania 101 Mozambique 203 1 1 D African Cup of Nations qualification   Dar es Salaam Dar es Salaam Tanzania     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.296790 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35712
35391 2011 1613 2011-11-11   Comoros 213 Mozambique 203 0 1 A FIFA World Cup qualification   Mitsamiouli Mitsamiouli Comoros     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.140592 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35391
35147 2011 1608 2011-09-03   Libya 153 Mozambique 203 1 0 H African Cup of Nations qualification   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.021794 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35147
34775 2011 1608 2011-06-04   Zambia 103 Mozambique 203 3 0 H African Cup of Nations qualification   Lusaka Lusaka Zambia     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.786668 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34775
34193 2010 1586 2010-10-09   Comoros 213 Mozambique 203 0 1 A African Cup of Nations qualification   Mitsamiouli Mitsamiouli Comoros     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.502892 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34193
33634 2010 1577 2010-01-20   Nigeria 120 Mozambique 203 3 0 H African Cup of Nations   Lubango Lubango Angola     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.145093 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33634
33622 2010 1577 2010-01-16   Egypt 42 Mozambique 203 2 0 H African Cup of Nations   Benguela Benguela Angola     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.139273 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33622
33599 2010 1575 2010-01-06   Gabon 160 Mozambique 203 2 0 H Friendly   Bloemfontein Bloemfontein South Africa     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.128151 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33599
33449 2009 1572 2009-10-31   South Africa 21 Mozambique 203 0 1 A COSAFA Cup   Bulawayo Bulawayo Zimbabwe     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.055190 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33449
33439 2009 1572 2009-10-25   Malawi 154 Mozambique 203 0 1 A COSAFA Cup   Harare Harare Zimbabwe     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.050355 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33439
33383 2009 1562 2009-10-11   Nigeria 120 Mozambique 203 1 0 H FIFA World Cup qualification   Abuja Abuja Nigeria     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.023102 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33383
33065 2009 1562 2009-06-20   Kenya 68 Mozambique 203 2 1 H FIFA World Cup qualification   Nairobi Nairobi Kenya     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.868115 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33065
33004 2009 1562 2009-06-06   Tunisia 152 Mozambique 203 2 0 H FIFA World Cup qualification   Radès Radès Tunisia     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.838697 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33004
32604 2008 1529 2008-11-19   Tanzania 101 Mozambique 203 1 0 H Friendly   Dar es Salaam Dar es Salaam Tanzania     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.584004 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32604
32415 2008 1532 2008-10-11   Botswana 189 Mozambique 203 0 1 A FIFA World Cup qualification   Gaborone Gaborone Botswana     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.488787 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32415
32185 2008 1544 2008-08-03   South Africa 21 Mozambique 203 2 1 H COSAFA Cup   Bushbuckridge Bushbuckridge South Africa     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.373781 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32185
32171 2008 1544 2008-07-30   Madagascar 107 Mozambique 203 1 2 A COSAFA Cup   Bushbuckridge Bushbuckridge South Africa     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.366944 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32171
32166 2008 1544 2008-07-27   Botswana 189 Mozambique 203 0 2 A COSAFA Cup   Secunda Secunda South Africa     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.364490 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32166
32061 2008 1532 2008-06-15   Madagascar 107 Mozambique 203 1 1 D FIFA World Cup qualification   Antananarivo Antananarivo Madagascar     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.313263 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32061
31914 2008 1532 2008-06-01   Ivory Coast 158 Mozambique 203 1 0 H FIFA World Cup qualification   Abidjan Abidjan Ivory Coast     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.187751 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31914
31694 2008 1529 2008-02-10   Botswana 189 Mozambique 203 1 0 H Friendly   Lobamba Lobamba Swaziland     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.050998 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31694
31692 2008 1529 2008-02-09   Lesotho 191 Mozambique 203 0 1 A Friendly   Lobamba Lobamba Swaziland     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.049987 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31692
31577 2008 1529 2008-01-13   South Africa 21 Mozambique 203 2 0 H Friendly   Durban Durban South Africa     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.991372 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31577
31244 2007 1511 2007-09-08   Tanzania 101 Mozambique 203 0 1 A African Cup of Nations qualification   Dar es Salaam Dar es Salaam Tanzania     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.823709 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31244
30709 2007 1511 2007-03-24   Burkina Faso 159 Mozambique 203 1 1 D African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.511668 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30709
30223 2006 1494 2006-09-02   Senegal 166 Mozambique 203 2 0 H African Cup of Nations qualification   Dakar Dakar Senegal     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.275339 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30223
29922 2006 1487 2006-04-30   Mauritius 108 Mozambique 203 0 0 D COSAFA Cup   Maseru Maseru Lesotho     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.075927 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29922
29920 2006 1487 2006-04-29   Lesotho 191 Mozambique 203 0 0 D COSAFA Cup   Maseru Maseru Lesotho     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.074952 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29920
29429 2005 1459 2005-08-28   Zimbabwe 102 Mozambique 203 0 0 D Friendly   Mutare Mutare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.835496 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29429

Next page

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