match
146 rows where home_team_id = 207 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: home_score, away_score, result, round_stage, venue, city, country, is_neutral, created_at, date (date), created_at (date), updated_at (date)
| match_id | season_id | date ▲ | kickoff | home_team_id | away_team_id | home_score | away_score | result | round_stage | matchday | venue | city | country | referee | attendance | is_neutral | is_postponed | is_cancelled | created_at | updated_at | created_by_run_id | updated_by_run_id | source_id | source_raw_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49210 | 2026 1930 | 2026-03-30 | Rwanda 207 | Estonia 43 | 2 | 0 | H | FIFA Series | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.791045 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49210 | ||||
| 49171 | 2026 1930 | 2026-03-27 | Rwanda 207 | Grenada 91 | 4 | 0 | H | FIFA Series | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.771351 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49171 | ||||
| 48744 | 2025 1907 | 2025-10-10 | Rwanda 207 | Benin 156 | 0 | 1 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.506351 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48744 | ||||
| 48277 | 2025 1907 | 2025-03-25 | Rwanda 207 | Lesotho 191 | 1 | 1 | D | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.278661 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48277 | ||||
| 48176 | 2025 1907 | 2025-03-21 | Rwanda 207 | Nigeria 120 | 0 | 2 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.229305 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48176 | ||||
| 47893 | 2024 1880 | 2024-11-14 | Rwanda 207 | Libya 153 | 0 | 1 | A | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.048129 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47893 | ||||
| 47812 | 2024 1880 | 2024-10-15 | Rwanda 207 | Benin 156 | 2 | 1 | H | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.008702 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47812 | ||||
| 47626 | 2024 1880 | 2024-09-10 | Rwanda 207 | Nigeria 120 | 0 | 0 | D | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.917940 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47626 | ||||
| 46820 | 2023 1872 | 2023-11-21 | Rwanda 207 | South Africa 21 | 2 | 0 | H | FIFA World Cup qualification | Butare | Butare | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.444631 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46820 | ||||
| 46652 | 2023 1872 | 2023-11-15 | Rwanda 207 | Zimbabwe 102 | 0 | 0 | D | FIFA World Cup qualification | Butare | Butare | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.362730 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46652 | ||||
| 46388 | 2023 1858 | 2023-09-09 | Rwanda 207 | Senegal 166 | 1 | 1 | D | African Cup of Nations qualification | Butare | Butare | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.234464 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46388 | ||||
| 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 | ||||
| 46029 | 2023 1858 | 2023-03-29 | Rwanda 207 | Benin 156 | 1 | 1 | D | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.060021 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46029 | ||||
| 45693 | 2022 1832 | 2022-11-19 | Rwanda 207 | Sudan 150 | 1 | 0 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.852587 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45693 | ||||
| 45675 | 2022 1832 | 2022-11-17 | Rwanda 207 | Sudan 150 | 0 | 0 | D | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.843836 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45675 | ||||
| 45516 | 2022 1832 | 2022-09-23 | Rwanda 207 | Equatorial Guinea 202 | 0 | 0 | D | Friendly | Berrechid | Berrechid | Egypt | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.766471 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45516 | ||||
| 44843 | 2022 1832 | 2022-01-06 | Rwanda 207 | Guinea 172 | 0 | 2 | A | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.355571 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44843 | ||||
| 44840 | 2022 1832 | 2022-01-03 | Rwanda 207 | Guinea 172 | 3 | 0 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.354125 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44840 | ||||
| 44635 | 2021 1813 | 2021-11-11 | Rwanda 207 | Mali 162 | 0 | 3 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.254419 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44635 | ||||
| 44488 | 2021 1813 | 2021-10-07 | Rwanda 207 | Uganda 69 | 0 | 1 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.182851 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44488 | ||||
| 44376 | 2021 1813 | 2021-09-05 | Rwanda 207 | Kenya 68 | 1 | 1 | D | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.128562 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44376 | ||||
| 44030 | 2021 1812 | 2021-06-07 | Rwanda 207 | Central African Republic 163 | 5 | 0 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.959906 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44030 | ||||
| 43986 | 2021 1812 | 2021-06-04 | Rwanda 207 | Central African Republic 163 | 2 | 0 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.884473 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43986 | ||||
| 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 | ||||
| 43695 | 2020 1811 | 2020-11-17 | Rwanda 207 | Cape Verde 157 | 0 | 0 | D | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.743223 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43695 | ||||
| 43266 | 2019 1787 | 2019-11-17 | Rwanda 207 | Cameroon 140 | 0 | 1 | A | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.534057 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43266 | ||||
| 43113 | 2019 1782 | 2019-10-14 | Rwanda 207 | Tanzania 101 | 0 | 0 | D | Friendly | Rwanda | Rwanda | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.459541 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43113 | ||||
| 42985 | 2019 1793 | 2019-09-10 | Rwanda 207 | Seychelles 201 | 7 | 0 | H | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.342976 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42985 | ||||
| 42139 | 2018 1778 | 2018-11-18 | Rwanda 207 | Central African Republic 163 | 2 | 2 | D | African Cup of Nations qualification | Butare | Butare | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.914941 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42139 | ||||
| 42029 | 2018 1778 | 2018-10-16 | Rwanda 207 | Guinea 172 | 1 | 1 | D | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.861393 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42029 | ||||
| 41812 | 2018 1778 | 2018-09-09 | Rwanda 207 | Ivory Coast 158 | 1 | 2 | A | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.667240 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41812 | ||||
| 41261 | 2017 1761 | 2017-12-09 | Rwanda 207 | Tanzania 101 | 2 | 1 | H | CECAFA Cup | Machakos | Machakos | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.386986 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41261 | ||||
| 41254 | 2017 1761 | 2017-12-07 | Rwanda 207 | Libya 153 | 0 | 0 | D | CECAFA Cup | Machakos | Machakos | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.383439 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41254 | ||||
| 40874 | 2017 1743 | 2017-08-07 | Rwanda 207 | Sudan 150 | 2 | 1 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.138088 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40874 | ||||
| 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 | ||||
| 39684 | 2016 1719 | 2016-05-28 | Rwanda 207 | Senegal 166 | 0 | 2 | A | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.496391 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39684 | ||||
| 39633 | 2016 1723 | 2016-03-29 | Rwanda 207 | Mauritius 108 | 5 | 0 | H | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.444500 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39633 | ||||
| 39459 | 2016 1719 | 2016-01-10 | Rwanda 207 | DR Congo 113 | 1 | 0 | H | Friendly | Gisenyi | Gisenyi | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.359482 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39459 | ||||
| 39454 | 2016 1719 | 2016-01-06 | Rwanda 207 | Cameroon 140 | 1 | 1 | D | Friendly | Gisenyi | Gisenyi | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.357045 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39454 | ||||
| 39432 | 2015 1716 | 2015-12-03 | Rwanda 207 | Sudan 150 | 1 | 1 | D | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.346302 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39432 | ||||
| 39429 | 2015 1716 | 2015-12-01 | Rwanda 207 | Kenya 68 | 0 | 0 | D | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.344823 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39429 | ||||
| 39422 | 2015 1716 | 2015-11-27 | Rwanda 207 | Somalia 178 | 3 | 0 | H | CECAFA Cup | Hawassa | Hawassa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.341418 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39422 | ||||
| 39415 | 2015 1716 | 2015-11-24 | Rwanda 207 | Tanzania 101 | 1 | 2 | A | CECAFA Cup | Hawassa | Hawassa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.338009 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39415 | ||||
| 39393 | 2015 1700 | 2015-11-17 | Rwanda 207 | Libya 153 | 1 | 3 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.327369 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39393 | ||||
| 39130 | 2015 1696 | 2015-09-12 | Rwanda 207 | Gabon 160 | 0 | 1 | A | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.199406 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39130 | ||||
| 39051 | 2015 1709 | 2015-09-05 | Rwanda 207 | Ghana 124 | 0 | 1 | A | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.160993 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39051 | ||||
| 38976 | 2015 1696 | 2015-08-28 | Rwanda 207 | Ethiopia 112 | 3 | 1 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.071044 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38976 | ||||
| 38724 | 2015 1696 | 2015-06-07 | Rwanda 207 | Tanzania 101 | 2 | 0 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.948104 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38724 | ||||
| 38714 | 2015 1696 | 2015-06-06 | Rwanda 207 | Kenya 68 | 0 | 0 | D | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.943281 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38714 | ||||
| 37954 | 2014 1678 | 2014-08-02 | Rwanda 207 | Congo Republic 161 | 2 | 0 | H | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.523894 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37954 | ||||
| 37932 | 2014 1675 | 2014-07-12 | Rwanda 207 | Gabon 160 | 1 | 0 | H | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.513237 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37932 | ||||
| 37773 | 2014 1678 | 2014-05-31 | Rwanda 207 | Libya 153 | 3 | 0 | H | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.435901 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37773 | ||||
| 37535 | 2013 1672 | 2013-12-05 | Rwanda 207 | Eritrea 243 | 1 | 0 | H | CECAFA Cup | Nakuru | Nakuru | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.319492 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37535 | ||||
| 37173 | 2013 1650 | 2013-08-14 | Rwanda 207 | Malawi 154 | 0 | 1 | A | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.142889 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37173 | ||||
| 37040 | 2013 1655 | 2013-06-16 | Rwanda 207 | Algeria 173 | 0 | 1 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.077912 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37040 | ||||
| 36842 | 2013 1655 | 2013-03-24 | Rwanda 207 | Mali 162 | 1 | 2 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.899738 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36842 | ||||
| 36773 | 2013 1650 | 2013-03-20 | Rwanda 207 | Libya 153 | 0 | 1 | A | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.866068 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36773 | ||||
| 36721 | 2013 1650 | 2013-02-06 | Rwanda 207 | Uganda 69 | 2 | 2 | D | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.840790 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36721 | ||||
| 36526 | 2012 1646 | 2012-12-03 | Rwanda 207 | Tanzania 101 | 0 | 2 | A | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.745948 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36526 | ||||
| 36510 | 2012 1646 | 2012-11-29 | Rwanda 207 | Zanzibar 110 | 1 | 2 | A | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.738167 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36510 | ||||
| 36498 | 2012 1646 | 2012-11-26 | Rwanda 207 | Malawi 154 | 2 | 0 | H | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.732275 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36498 | ||||
| 36467 | 2012 1623 | 2012-11-14 | Rwanda 207 | Namibia 231 | 2 | 2 | D | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.717247 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36467 | ||||
| 35961 | 2012 1627 | 2012-06-10 | Rwanda 207 | Benin 156 | 1 | 1 | D | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.418202 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35961 | ||||
| 35703 | 2012 1624 | 2012-02-29 | Rwanda 207 | Nigeria 120 | 0 | 0 | D | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.292417 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35703 | ||||
| 35558 | 2011 1620 | 2011-12-10 | Rwanda 207 | Uganda 69 | 2 | 2 | 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.221830 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35558 | ||||
| 35545 | 2011 1620 | 2011-12-05 | Rwanda 207 | Zanzibar 110 | 2 | 1 | H | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.215556 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35545 | ||||
| 35532 | 2011 1620 | 2011-12-02 | Rwanda 207 | Djibouti 111 | 5 | 2 | H | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.209247 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35532 | ||||
| 35522 | 2011 1620 | 2011-11-29 | Rwanda 207 | Zimbabwe 102 | 2 | 0 | H | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.204367 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35522 | ||||
| 35490 | 2011 1613 | 2011-11-15 | Rwanda 207 | Eritrea 243 | 3 | 1 | H | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.188754 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35490 | ||||
| 35152 | 2011 1608 | 2011-09-03 | Rwanda 207 | Ivory Coast 158 | 0 | 5 | A | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.024227 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35152 | ||||
| 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 | ||||
| 34408 | 2010 1597 | 2010-12-03 | Rwanda 207 | Zanzibar 110 | 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.607785 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34408 | ||||
| 34201 | 2010 1586 | 2010-10-09 | Rwanda 207 | Benin 156 | 0 | 3 | A | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.506775 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34201 | ||||
| 33607 | 2010 1575 | 2010-01-07 | Rwanda 207 | Ivory Coast 158 | 0 | 2 | A | Friendly | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.132007 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33607 | ||||
| 33549 | 2009 1555 | 2009-12-03 | Rwanda 207 | Eritrea 243 | 2 | 1 | H | CECAFA Cup | Nairobi | Nairobi | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.103897 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33549 | ||||
| 33542 | 2009 1555 | 2009-11-29 | Rwanda 207 | Somalia 178 | 1 | 0 | H | CECAFA Cup | Nairobi | Nairobi | Kenya | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.100479 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33542 | ||||
| 33492 | 2009 1562 | 2009-11-14 | Rwanda 207 | Zambia 103 | 0 | 0 | D | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.076164 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33492 | ||||
| 33272 | 2009 1562 | 2009-09-05 | Rwanda 207 | Egypt 42 | 0 | 1 | A | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.968847 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33272 | ||||
| 33208 | 2009 1557 | 2009-08-12 | Rwanda 207 | Tanzania 101 | 1 | 2 | A | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.937671 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33208 | ||||
| 32856 | 2009 1562 | 2009-03-28 | Rwanda 207 | Algeria 173 | 0 | 0 | D | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.710945 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32856 | ||||
| 32681 | 2009 1555 | 2009-01-07 | Rwanda 207 | Tanzania 101 | 0 | 2 | A | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.622857 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32681 | ||||
| 32673 | 2009 1555 | 2009-01-05 | Rwanda 207 | Somalia 178 | 3 | 0 | H | CECAFA Cup | Kampala | Kampala | Uganda | 1 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.618774 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32673 | ||||
| 32036 | 2008 1532 | 2008-06-14 | Rwanda 207 | Morocco 155 | 3 | 1 | H | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.301124 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32036 | ||||
| 31898 | 2008 1532 | 2008-05-31 | Rwanda 207 | Mauritania 168 | 3 | 0 | H | FIFA World Cup qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.179855 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31898 | ||||
| 31534 | 2007 1527 | 2007-12-11 | Rwanda 207 | Uganda 69 | 0 | 2 | 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.969689 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31534 | ||||
| 31528 | 2007 1527 | 2007-12-09 | Rwanda 207 | Eritrea 243 | 2 | 1 | H | CECAFA Cup | Dar es Salaam | Dar es Salaam | Tanzania | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.966664 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31528 | ||||
| 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 | ||||
| 30872 | 2007 1511 | 2007-06-02 | Rwanda 207 | Equatorial Guinea 202 | 2 | 0 | H | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.591981 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30872 | ||||
| 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 | ||||
| 30550 | 2006 1499 | 2006-12-10 | Rwanda 207 | Uganda 69 | 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.434483 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30550 | ||||
| 30546 | 2006 1499 | 2006-12-08 | Rwanda 207 | Zambia 103 | 0 | 1 | A | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.432544 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30546 | ||||
| 30534 | 2006 1499 | 2006-11-30 | Rwanda 207 | Uganda 69 | 0 | 1 | A | CECAFA Cup | Addis Ababa | Addis Ababa | Ethiopia | 1 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.426645 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30534 | ||||
| 30240 | 2006 1494 | 2006-09-03 | Rwanda 207 | Cameroon 140 | 0 | 3 | A | African Cup of Nations qualification | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.283657 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30240 | ||||
| 30121 | 2006 1479 | 2006-07-26 | Rwanda 207 | Uganda 69 | 1 | 1 | D | Friendly | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.225929 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30121 | ||||
| 29701 | 2005 1475 | 2005-12-10 | Rwanda 207 | Ethiopia 112 | 0 | 1 | A | CECAFA Cup | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.967804 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29701 | ||||
| 29695 | 2005 1475 | 2005-12-08 | Rwanda 207 | Uganda 69 | 1 | 0 | H | CECAFA Cup | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.964903 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29695 | ||||
| 29689 | 2005 1475 | 2005-12-06 | Rwanda 207 | Tanzania 101 | 3 | 1 | H | CECAFA Cup | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.961994 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29689 | ||||
| 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 | ||||
| 29671 | 2005 1475 | 2005-11-30 | Rwanda 207 | Eritrea 243 | 3 | 2 | H | CECAFA Cup | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.953254 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29671 | ||||
| 29663 | 2005 1475 | 2005-11-26 | Rwanda 207 | Zanzibar 110 | 0 | 1 | A | CECAFA Cup | Kigali | Kigali | Rwanda | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:00.949316 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29663 |
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);