match
120 rows where away_team_id = 139 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49260 | 2026 1929 | 2026-05-26 | Morocco 155 | Burundi 139 | 5 | 0 | H | Friendly | Salé | Salé | Morocco | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.816405 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49260 | ||||
| 48828 | 2025 1907 | 2025-10-14 | Gabon 160 | Burundi 139 | 2 | 0 | H | FIFA World Cup qualification | Franceville | Franceville | Gabon | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.547096 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48828 | ||||
| 48664 | 2025 1907 | 2025-09-09 | Gambia 133 | Burundi 139 | 2 | 0 | H | FIFA World Cup qualification | Nairobi | Nairobi | Kenya | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.467447 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48664 | ||||
| 48572 | 2025 1907 | 2025-09-05 | Ivory Coast 158 | Burundi 139 | 1 | 0 | H | FIFA World Cup qualification | Abidjan | Abidjan | Ivory Coast | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.422213 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48572 | ||||
| 48041 | 2024 1880 | 2024-11-19 | Senegal 166 | Burundi 139 | 2 | 0 | H | African Cup of Nations qualification | Dakar | Dakar | Senegal | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.163533 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48041 | ||||
| 47680 | 2024 1880 | 2024-10-10 | Burkina Faso 159 | Burundi 139 | 4 | 1 | H | African Cup of Nations qualification | Ebimpé | Ebimpé | Ivory Coast | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.944278 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47680 | ||||
| 47499 | 2024 1880 | 2024-09-05 | Malawi 154 | Burundi 139 | 2 | 3 | A | African Cup of Nations qualification | Lilongwe | Lilongwe | Malawi | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.855799 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47499 | ||||
| 47341 | 2024 1886 | 2024-06-11 | Seychelles 201 | Burundi 139 | 1 | 3 | A | FIFA World Cup qualification | Berkane | Berkane | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.751573 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47341 | ||||
| 47265 | 2024 1886 | 2024-06-07 | Kenya 68 | Burundi 139 | 1 | 1 | D | FIFA World Cup qualification | Lilongwe | Lilongwe | Malawi | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.714661 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47265 | ||||
| 46464 | 2023 1858 | 2023-09-12 | Cameroon 140 | Burundi 139 | 3 | 0 | H | African Cup of Nations qualification | Garoua | Garoua | Cameroon | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.271434 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46464 | ||||
| 45992 | 2023 1856 | 2023-03-28 | Indonesia 83 | Burundi 139 | 2 | 2 | D | Friendly | Bekasi | Bekasi | Indonesia | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.997496 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45992 | ||||
| 45923 | 2023 1856 | 2023-03-25 | Indonesia 83 | Burundi 139 | 3 | 1 | H | Friendly | Bekasi | Bekasi | Indonesia | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.964059 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45923 | ||||
| 45646 | 2022 1832 | 2022-11-16 | Ivory Coast 158 | Burundi 139 | 4 | 0 | H | Friendly | Marrakech | Marrakech | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.829707 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45646 | ||||
| 45206 | 2022 1835 | 2022-06-04 | Namibia 231 | Burundi 139 | 1 | 1 | D | African Cup of Nations qualification | Johannesburg | Johannesburg | South Africa | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.615521 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45206 | ||||
| 45099 | 2022 1832 | 2022-03-29 | Liberia 169 | Burundi 139 | 1 | 2 | A | Friendly | Antalya | Antalya | Turkey | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.563277 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45099 | ||||
| 45029 | 2022 1832 | 2022-03-26 | Bahrain 183 | Burundi 139 | 1 | 0 | H | Friendly | Arad | Arad | Iran | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.529148 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45029 | ||||
| 44407 | 2021 1812 | 2021-09-07 | Comoros 213 | Burundi 139 | 1 | 0 | H | Friendly | Moroni | Moroni | Comoros | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.143493 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44407 | ||||
| 43893 | 2021 1814 | 2021-03-30 | Morocco 155 | Burundi 139 | 1 | 0 | H | African Cup of Nations qualification | Rabat | Rabat | Morocco | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.839359 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43893 | ||||
| 43582 | 2020 1811 | 2020-11-11 | Mauritania 168 | Burundi 139 | 1 | 1 | D | African Cup of Nations qualification | Nouakchott | Nouakchott | Mauritania | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.687756 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43582 | ||||
| 43515 | 2020 1807 | 2020-10-11 | Tanzania 101 | Burundi 139 | 0 | 1 | A | Friendly | Dar es Salaam | Dar es Salaam | Tanzania | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.655260 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43515 | ||||
| 43174 | 2019 1787 | 2019-11-13 | Central African Republic 163 | Burundi 139 | 2 | 0 | H | African Cup of Nations qualification | Bangui | Bangui | Central African Republic | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.489210 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43174 | ||||
| 42921 | 2019 1793 | 2019-09-08 | Tanzania 101 | Burundi 139 | 1 | 1 | D | FIFA World Cup qualification | Dar es Salaam | Dar es Salaam | Tanzania | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.310345 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42921 | ||||
| 42691 | 2019 1797 | 2019-06-27 | Madagascar 107 | Burundi 139 | 1 | 0 | H | African Cup of Nations | Alexandria | Alexandria | Egypt | 1 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.192702 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42691 | ||||
| 42661 | 2019 1797 | 2019-06-22 | Nigeria 120 | Burundi 139 | 1 | 0 | H | African Cup of Nations | Alexandria | Alexandria | Egypt | 1 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.177335 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42661 | ||||
| 42631 | 2019 1782 | 2019-06-17 | Tunisia 152 | Burundi 139 | 2 | 1 | H | Friendly | Radès | Radès | Tunisia | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.162014 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42631 | ||||
| 42581 | 2019 1782 | 2019-06-11 | Algeria 173 | Burundi 139 | 1 | 1 | D | Friendly | Doha | Doha | Qatar | 1 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.136497 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42581 | ||||
| 42087 | 2018 1778 | 2018-11-16 | South Sudan 295 | Burundi 139 | 2 | 5 | A | African Cup of Nations qualification | Juba | Juba | South Sudan | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.889624 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42087 | ||||
| 41927 | 2018 1778 | 2018-10-12 | Mali 162 | Burundi 139 | 0 | 0 | D | African Cup of Nations qualification | Bamako | Bamako | Mali | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.725493 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41927 | ||||
| 41785 | 2018 1778 | 2018-09-08 | Gabon 160 | Burundi 139 | 1 | 1 | D | African Cup of Nations qualification | Libreville | Libreville | Gabon | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.653550 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41785 | ||||
| 41721 | 2018 1765 | 2018-09-02 | Ethiopia 112 | Burundi 139 | 1 | 1 | D | Friendly | Hawassa | Hawassa | Ethiopia | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.621061 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41721 | ||||
| 41273 | 2017 1761 | 2017-12-14 | Kenya 68 | Burundi 139 | 1 | 0 | H | CECAFA Cup | Kisumu | Kisumu | Kenya | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.393109 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41273 | ||||
| 41267 | 2017 1761 | 2017-12-11 | South Sudan 295 | Burundi 139 | 0 | 0 | D | CECAFA Cup | Kakamega | Kakamega | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.390040 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41267 | ||||
| 41243 | 2017 1761 | 2017-12-04 | Uganda 69 | Burundi 139 | 0 | 0 | D | CECAFA Cup | Kakamega | Kakamega | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.377863 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41243 | ||||
| 40569 | 2017 1743 | 2017-03-28 | Tanzania 101 | Burundi 139 | 2 | 1 | H | Friendly | Dar es Salaam | Dar es Salaam | Tanzania | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:06.982966 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40569 | ||||
| 40038 | 2016 1723 | 2016-09-04 | Niger 171 | Burundi 139 | 3 | 1 | H | African Cup of Nations qualification | Niamey | Niamey | Niger | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.724672 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40038 | ||||
| 39625 | 2016 1723 | 2016-03-29 | Namibia 231 | Burundi 139 | 1 | 3 | A | African Cup of Nations qualification | Windhoek | Windhoek | Namibia | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.440614 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39625 | ||||
| 39426 | 2015 1716 | 2015-11-28 | Uganda 69 | Burundi 139 | 1 | 0 | H | CECAFA Cup | Hawassa | Hawassa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.343370 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39426 | ||||
| 39418 | 2015 1716 | 2015-11-25 | Kenya 68 | Burundi 139 | 1 | 1 | D | CECAFA Cup | Hawassa | Hawassa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.339476 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39418 | ||||
| 39350 | 2015 1700 | 2015-11-15 | DR Congo 113 | Burundi 139 | 3 | 0 | H | FIFA World Cup qualification | Kinshasa | Kinshasa | DR Congo | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.306366 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39350 | ||||
| 39136 | 2015 1700 | 2015-10-07 | Seychelles 201 | Burundi 139 | 0 | 1 | A | FIFA World Cup qualification | Roche Caiman | Roche Caiman | Seychelles | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.202303 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39136 | ||||
| 38798 | 2015 1709 | 2015-06-13 | Senegal 166 | Burundi 139 | 3 | 1 | H | African Cup of Nations qualification | Dakar | Dakar | Senegal | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.984083 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38798 | ||||
| 38536 | 2015 1696 | 2015-03-25 | Mauritius 108 | Burundi 139 | 2 | 2 | D | Friendly | Curepipe | Curepipe | Mauritius | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.856477 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38536 | ||||
| 37936 | 2014 1675 | 2014-07-15 | Kenya 68 | Burundi 139 | 0 | 0 | D | Friendly | Nairobi | Nairobi | Kenya | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.515192 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37936 | ||||
| 37778 | 2014 1678 | 2014-06-01 | Botswana 189 | Burundi 139 | 1 | 0 | H | African Cup of Nations qualification | Lobatse | Lobatse | Botswana | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.438345 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37778 | ||||
| 37658 | 2014 1675 | 2014-04-26 | Tanzania 101 | Burundi 139 | 0 | 3 | A | Friendly | Dar es Salaam | Dar es Salaam | Tanzania | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.379381 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37658 | ||||
| 37540 | 2013 1672 | 2013-12-08 | Zambia 103 | Burundi 139 | 4 | 3 | H | CECAFA Cup | Mombasa | Mombasa | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.321928 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37540 | ||||
| 37534 | 2013 1672 | 2013-12-04 | Tanzania 101 | Burundi 139 | 1 | 0 | H | CECAFA Cup | Nakuru | Nakuru | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.319004 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37534 | ||||
| 37528 | 2013 1672 | 2013-12-01 | Zambia 103 | Burundi 139 | 1 | 0 | H | CECAFA Cup | Nairobi | Nairobi | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.316024 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37528 | ||||
| 36522 | 2012 1646 | 2012-12-01 | Sudan 150 | Burundi 139 | 0 | 1 | A | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.744012 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36522 | ||||
| 36507 | 2012 1646 | 2012-11-28 | Tanzania 101 | Burundi 139 | 0 | 1 | A | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.736718 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36507 | ||||
| 36006 | 2012 1624 | 2012-06-17 | Zimbabwe 102 | Burundi 139 | 1 | 0 | H | African Cup of Nations qualification | Harare | Harare | Zimbabwe | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.493576 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36006 | ||||
| 35516 | 2011 1620 | 2011-11-27 | Zanzibar 110 | Burundi 139 | 0 | 0 | D | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.201362 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35516 | ||||
| 35410 | 2011 1613 | 2011-11-11 | Lesotho 191 | Burundi 139 | 1 | 0 | H | FIFA World Cup qualification | Maseru | Maseru | Lesotho | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.149807 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35410 | ||||
| 35315 | 2011 1608 | 2011-10-09 | Ivory Coast 158 | Burundi 139 | 2 | 1 | H | African Cup of Nations qualification | Abidjan | Abidjan | Ivory Coast | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.103642 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35315 | ||||
| 34641 | 2011 1608 | 2011-03-26 | Rwanda 207 | Burundi 139 | 3 | 1 | H | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.721338 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34641 | ||||
| 34471 | 2011 1600 | 2011-01-11 | Egypt 42 | Burundi 139 | 3 | 0 | H | Nile Basin Tournament | Ismailia | Ismailia | Egypt | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.638557 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34471 | ||||
| 34465 | 2011 1600 | 2011-01-08 | Tanzania 101 | Burundi 139 | 1 | 1 | D | Nile Basin Tournament | Cairo | Cairo | Egypt | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.635637 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34465 | ||||
| 34459 | 2011 1600 | 2011-01-05 | Uganda 69 | Burundi 139 | 3 | 1 | H | Nile Basin Tournament | Cairo | Cairo | Egypt | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.632663 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34459 | ||||
| 34394 | 2010 1597 | 2010-11-30 | Zambia 103 | Burundi 139 | 0 | 0 | D | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.600981 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34394 | ||||
| 34052 | 2010 1586 | 2010-09-05 | Benin 156 | Burundi 139 | 1 | 1 | D | African Cup of Nations qualification | Cotonou | Cotonou | Benin | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.433895 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34052 | ||||
| 33553 | 2009 1555 | 2009-12-04 | Tanzania 101 | Burundi 139 | 1 | 0 | H | CECAFA Cup | Mumias | Mumias | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.105843 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33553 | ||||
| 32696 | 2009 1555 | 2009-01-13 | Tanzania 101 | Burundi 139 | 3 | 2 | H | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.630393 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32696 | ||||
| 32694 | 2009 1555 | 2009-01-11 | Uganda 69 | Burundi 139 | 5 | 0 | H | CECAFA Cup | Kampala | Kampala | Uganda | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.629396 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32694 | ||||
| 32672 | 2009 1555 | 2009-01-04 | Zambia 103 | Burundi 139 | 1 | 1 | D | CECAFA Cup | Jinja | Jinja | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.618271 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32672 | ||||
| 32665 | 2009 1555 | 2009-01-02 | Djibouti 111 | Burundi 139 | 0 | 4 | A | CECAFA Cup | Jinja | Jinja | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.614761 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32665 | ||||
| 32319 | 2008 1532 | 2008-09-06 | Seychelles 201 | Burundi 139 | 1 | 2 | A | FIFA World Cup qualification | Victoria | Victoria | Seychelles | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.440318 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32319 | ||||
| 32100 | 2008 1532 | 2008-06-21 | Tunisia 152 | Burundi 139 | 2 | 1 | H | FIFA World Cup qualification | Radès | Radès | Tunisia | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.332269 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32100 | ||||
| 31956 | 2008 1532 | 2008-06-07 | Burkina Faso 159 | Burundi 139 | 2 | 0 | H | FIFA World Cup qualification | Ouagadougou | Ouagadougou | Burkina Faso | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.208463 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31956 | ||||
| 31543 | 2007 1527 | 2007-12-15 | Tanzania 101 | Burundi 139 | 0 | 0 | D | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.974287 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31543 | ||||
| 31535 | 2007 1527 | 2007-12-12 | Kenya 68 | Burundi 139 | 0 | 1 | A | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.970199 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31535 | ||||
| 31531 | 2007 1527 | 2007-12-10 | Somalia 178 | Burundi 139 | 0 | 3 | A | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.968182 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31531 | ||||
| 31335 | 2007 1511 | 2007-10-13 | Mauritania 168 | Burundi 139 | 2 | 1 | H | African Cup of Nations qualification | Nouakchott | Nouakchott | Mauritania | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.869444 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31335 | ||||
| 30831 | 2007 1502 | 2007-05-27 | Rwanda 207 | Burundi 139 | 1 | 0 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.571620 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30831 | ||||
| 30750 | 2007 1511 | 2007-03-25 | Botswana 189 | Burundi 139 | 1 | 0 | H | African Cup of Nations qualification | Gaborone | Gaborone | Botswana | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.531586 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30750 | ||||
| 30533 | 2006 1499 | 2006-11-29 | Zanzibar 110 | Burundi 139 | 0 | 0 | D | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.426160 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30533 | ||||
| 30204 | 2006 1494 | 2006-09-02 | Egypt 42 | Burundi 139 | 4 | 1 | H | African Cup of Nations qualification | Alexandria | Alexandria | Egypt | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.266113 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30204 | ||||
| 29684 | 2005 1475 | 2005-12-04 | Rwanda 207 | Burundi 139 | 2 | 0 | H | CECAFA Cup | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.959568 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29684 | ||||
| 28921 | 2004 1457 | 2004-12-25 | Ethiopia 112 | Burundi 139 | 3 | 0 | H | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.505141 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28921 | ||||
| 28918 | 2004 1457 | 2004-12-22 | Sudan 150 | Burundi 139 | 1 | 2 | A | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.503688 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28918 | ||||
| 28892 | 2004 1457 | 2004-12-15 | Tanzania 101 | Burundi 139 | 0 | 2 | A | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.491041 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28892 | ||||
| 28863 | 2004 1457 | 2004-12-11 | Ethiopia 112 | Burundi 139 | 2 | 1 | H | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.477007 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28863 | ||||
| 27721 | 2003 1432 | 2003-11-15 | Gabon 160 | Burundi 139 | 4 | 1 | H | FIFA World Cup qualification | Libreville | Libreville | Gabon | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.871054 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27721 | ||||
| 27255 | 2003 1423 | 2003-06-08 | Ivory Coast 158 | Burundi 139 | 6 | 1 | H | African Cup of Nations qualification | Abidjan | Abidjan | Ivory Coast | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.644570 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27255 | ||||
| 27022 | 2003 1411 | 2003-03-15 | Rwanda 207 | Burundi 139 | 4 | 2 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.530989 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27022 | ||||
| 26837 | 2002 1407 | 2002-12-07 | Sudan 150 | Burundi 139 | 2 | 1 | H | CECAFA Cup | Mwanza | Mwanza | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.387638 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26837 | ||||
| 26830 | 2002 1407 | 2002-12-05 | Tanzania 101 | Burundi 139 | 2 | 0 | H | CECAFA Cup | Mwanza | Mwanza | Tanzania | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.384216 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26830 | ||||
| 26826 | 2002 1407 | 2002-12-03 | Kenya 68 | Burundi 139 | 1 | 1 | D | CECAFA Cup | Mwanza | Mwanza | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.382266 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26826 | ||||
| 26717 | 2002 1405 | 2002-10-13 | South Africa 21 | Burundi 139 | 2 | 0 | H | African Cup of Nations qualification | Bloemfontein | Bloemfontein | South Africa | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.328952 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26717 | ||||
| 26113 | 2001 1359 | 2001-12-18 | Ethiopia 112 | Burundi 139 | 2 | 2 | D | Friendly | Kigali | Kigali | Rwanda | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.029706 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26113 | ||||
| 26106 | 2001 1384 | 2001-12-14 | Uganda 69 | Burundi 139 | 0 | 2 | A | CECAFA Cup | Kigali | Kigali | Rwanda | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:59.026179 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26106 | ||||
| 25706 | 2001 1362 | 2001-06-17 | Angola 205 | Burundi 139 | 2 | 1 | H | African Cup of Nations qualification | Cabinda | Cabinda | Angola | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.750793 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25706 | ||||
| 25112 | 2001 1362 | 2001-01-12 | Algeria 173 | Burundi 139 | 2 | 1 | H | African Cup of Nations qualification | Algiers | Algiers | Algeria | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.462069 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25112 | ||||
| 25087 | 2000 1358 | 2000-11-27 | Ethiopia 112 | Burundi 139 | 1 | 0 | H | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.449983 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25087 | ||||
| 25081 | 2000 1358 | 2000-11-23 | Djibouti 111 | Burundi 139 | 2 | 4 | A | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.447085 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25081 | ||||
| 25076 | 2000 1358 | 2000-11-20 | Uganda 69 | Burundi 139 | 2 | 1 | H | CECAFA Cup | Kampala | Kampala | Uganda | 0 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.444657 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25076 | ||||
| 24916 | 2000 1353 | 2000-10-07 | Burkina Faso 159 | Burundi 139 | 1 | 0 | H | African Cup of Nations qualification | Ouagadougou | Ouagadougou | Burkina Faso | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.313014 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24916 | ||||
| 24905 | 2000 1331 | 2000-10-03 | Kenya 68 | Burundi 139 | 2 | 3 | A | Friendly | Nairobi | Nairobi | Kenya | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.307682 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24905 | ||||
| 24900 | 2000 1331 | 2000-09-30 | Kenya 68 | Burundi 139 | 1 | 0 | H | Friendly | Nairobi | Nairobi | Kenya | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.305275 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24900 | ||||
| 24691 | 2000 1353 | 2000-06-30 | Djibouti 111 | Burundi 139 | 1 | 3 | A | African Cup of Nations qualification | Djibouti | Djibouti | Djibouti | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.200978 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24691 | ||||
| 23794 | 1999 1303 | 1999-08-07 | Rwanda 207 | Burundi 139 | 0 | 0 | D | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:57.673457 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23794 |
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);