match
123 rows where home_team_id = 157 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49401 | 2026 1937 | 2026-06-26 | Cape Verde 157 | Saudi Arabia 179 | FIFA World Cup | Houston | Houston | United States | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.887767 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49401 | |||||||
| 49276 | 2026 1929 | 2026-05-31 | Cape Verde 157 | Serbia 122 | 3 | 0 | H | Friendly | Lisbon | Lisbon | Portugal | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.824498 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49276 | ||||
| 49207 | 2026 1930 | 2026-03-30 | Cape Verde 157 | Finland 29 | 1 | 1 | D | FIFA Series | Auckland | Auckland | New Zealand | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.789533 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49207 | ||||
| 48961 | 2025 1923 | 2025-11-17 | Cape Verde 157 | Egypt 42 | 1 | 1 | D | Al Ain International Cup | Al Ain | Al Ain | United Arab Emirates | 1 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.611558 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48961 | ||||
| 48793 | 2025 1907 | 2025-10-13 | Cape Verde 157 | Eswatini 188 | 3 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.530102 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48793 | ||||
| 48659 | 2025 1907 | 2025-09-09 | Cape Verde 157 | Cameroon 140 | 1 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.465021 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48659 | ||||
| 48150 | 2025 1907 | 2025-03-20 | Cape Verde 157 | Mauritius 108 | 1 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:02 | 2026-06-07 21:04:11.216641 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48150 | ||||
| 47926 | 2024 1880 | 2024-11-15 | Cape Verde 157 | Egypt 42 | 1 | 1 | D | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:11.064145 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47926 | ||||
| 47675 | 2024 1880 | 2024-10-10 | Cape Verde 157 | Botswana 189 | 0 | 1 | A | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.941862 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47675 | ||||
| 47625 | 2024 1880 | 2024-09-10 | Cape Verde 157 | Mauritania 168 | 2 | 0 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.917453 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47625 | ||||
| 47334 | 2024 1886 | 2024-06-11 | Cape Verde 157 | Libya 153 | 1 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.748177 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47334 | ||||
| 47108 | 2024 1882 | 2024-03-25 | Cape Verde 157 | Equatorial Guinea 202 | 1 | 0 | H | FIFA Series | Jeddah | Jeddah | Saudi Arabia | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.638262 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47108 | ||||
| 47018 | 2024 1882 | 2024-03-21 | Cape Verde 157 | Guyana 19 | 1 | 0 | H | FIFA Series | Jeddah | Jeddah | Saudi Arabia | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.594683 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47018 | ||||
| 46998 | 2024 1879 | 2024-02-03 | Cape Verde 157 | South Africa 21 | 0 | 0 | D | African Cup of Nations | Yamoussoukro | Yamoussoukro | Ivory Coast | 1 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.531330 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46998 | ||||
| 46984 | 2024 1879 | 2024-01-29 | Cape Verde 157 | Mauritania 168 | 1 | 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.524547 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46984 | ||||
| 46956 | 2024 1879 | 2024-01-22 | Cape Verde 157 | Egypt 42 | 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.510826 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46956 | ||||
| 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 | ||||
| 46688 | 2023 1872 | 2023-11-16 | Cape Verde 157 | Angola 205 | 0 | 0 | D | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.380253 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46688 | ||||
| 46623 | 2023 1856 | 2023-10-17 | Cape Verde 157 | Comoros 213 | 1 | 2 | A | Friendly | Fos-sur-Mer | Fos-sur-Mer | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:01 | 2026-06-07 21:04:10.348689 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46623 | ||||
| 46132 | 2023 1858 | 2023-06-18 | Cape Verde 157 | Burkina Faso 159 | 3 | 1 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:10.109872 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46132 | ||||
| 45892 | 2023 1858 | 2023-03-24 | Cape Verde 157 | Eswatini 188 | 0 | 0 | D | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.949047 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45892 | ||||
| 45269 | 2022 1835 | 2022-06-07 | Cape Verde 157 | Togo 148 | 2 | 0 | H | African Cup of Nations qualification | Marrakech | Marrakech | Morocco | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.646318 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45269 | ||||
| 45062 | 2022 1832 | 2022-03-28 | Cape Verde 157 | San Marino 236 | 2 | 0 | H | Friendly | San Pedro del Pinatar | San Pedro del Pinatar | Spain | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.545277 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45062 | ||||
| 45013 | 2022 1832 | 2022-03-25 | Cape Verde 157 | Liechtenstein 220 | 6 | 0 | H | Friendly | San Pedro del Pinatar | San Pedro del Pinatar | Spain | 1 | 0 | 0 | 2026-06-07 06:59:00 | 2026-06-07 21:04:09.521348 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45013 | ||||
| 44858 | 2022 1833 | 2022-01-13 | Cape Verde 157 | Burkina Faso 159 | 0 | 1 | A | African Cup of Nations | Yaoundé | Yaoundé | Cameroon | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.362879 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44858 | ||||
| 44688 | 2021 1813 | 2021-11-13 | Cape Verde 157 | Central African Republic 163 | 2 | 1 | H | FIFA World Cup qualification | Mindelo | Mindelo | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.280448 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44688 | ||||
| 44550 | 2021 1813 | 2021-10-10 | Cape Verde 157 | Liberia 169 | 1 | 0 | H | FIFA World Cup qualification | Mindelo | Mindelo | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.213127 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44550 | ||||
| 44412 | 2021 1813 | 2021-09-07 | Cape Verde 157 | Nigeria 120 | 1 | 2 | A | FIFA World Cup qualification | Mindelo | Mindelo | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:09.145909 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44412 | ||||
| 43803 | 2021 1814 | 2021-03-26 | Cape Verde 157 | Cameroon 140 | 3 | 1 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.795500 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43803 | ||||
| 43604 | 2020 1811 | 2020-11-12 | Cape Verde 157 | Rwanda 207 | 0 | 0 | D | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.698537 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43604 | ||||
| 43488 | 2020 1807 | 2020-10-10 | Cape Verde 157 | Guinea 172 | 1 | 2 | A | Friendly | Faro-Loulé | Faro-Loulé | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:59 | 2026-06-07 21:04:08.642082 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43488 | ||||
| 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 | ||||
| 43015 | 2019 1782 | 2019-10-10 | Cape Verde 157 | Togo 148 | 2 | 1 | H | Friendly | Fos-sur-Mer | Fos-sur-Mer | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:08.411874 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43015 | ||||
| 42391 | 2019 1787 | 2019-03-24 | Cape Verde 157 | Lesotho 191 | 0 | 0 | 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.039610 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42391 | ||||
| 41920 | 2018 1778 | 2018-10-12 | Cape Verde 157 | Tanzania 101 | 3 | 0 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:58 | 2026-06-07 21:04:07.721944 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41920 | ||||
| 41052 | 2017 1747 | 2017-10-07 | Cape Verde 157 | Senegal 166 | 0 | 2 | A | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.280927 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41052 | ||||
| 40912 | 2017 1747 | 2017-09-01 | Cape Verde 157 | South Africa 21 | 2 | 1 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.157410 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40912 | ||||
| 40705 | 2017 1746 | 2017-06-11 | Cape Verde 157 | Uganda 69 | 0 | 1 | A | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:57 | 2026-06-07 21:04:07.052231 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40705 | ||||
| 40278 | 2016 1724 | 2016-11-12 | Cape Verde 157 | Burkina Faso 159 | 0 | 2 | A | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.841496 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40278 | ||||
| 40016 | 2016 1723 | 2016-09-03 | Cape Verde 157 | Libya 153 | 0 | 1 | A | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.713990 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40016 | ||||
| 39560 | 2016 1723 | 2016-03-26 | Cape Verde 157 | Morocco 155 | 0 | 1 | A | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.408619 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39560 | ||||
| 39368 | 2015 1700 | 2015-11-17 | Cape Verde 157 | Kenya 68 | 2 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:56 | 2026-06-07 21:04:06.315093 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39368 | ||||
| 38788 | 2015 1709 | 2015-06-13 | Cape Verde 157 | São Tomé & Príncipe 206 | 7 | 1 | 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.979227 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38788 | ||||
| 38481 | 2015 1698 | 2015-01-26 | Cape Verde 157 | Zambia 103 | 0 | 0 | D | African Cup of Nations | Ebebiyín | Ebebiyín | Equatorial Guinea | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.829786 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38481 | ||||
| 38469 | 2015 1698 | 2015-01-22 | Cape Verde 157 | DR Congo 113 | 0 | 0 | D | African Cup of Nations | Ebebiyín | Ebebiyín | Equatorial Guinea | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.823971 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38469 | ||||
| 38424 | 2015 1696 | 2015-01-10 | Cape Verde 157 | Congo Republic 161 | 3 | 2 | H | Friendly | Dakar | Dakar | Senegal | 1 | 0 | 0 | 2026-06-07 06:58:55 | 2026-06-07 21:04:05.802118 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38424 | ||||
| 38295 | 2014 1678 | 2014-11-15 | Cape Verde 157 | Niger 171 | 3 | 1 | 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.739565 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38295 | ||||
| 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 | ||||
| 38085 | 2014 1678 | 2014-09-10 | Cape Verde 157 | Zambia 103 | 2 | 1 | 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.637448 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38085 | ||||
| 37024 | 2013 1655 | 2013-06-15 | Cape Verde 157 | Sierra Leone 119 | 1 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:05.070111 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37024 | ||||
| 36976 | 2013 1655 | 2013-06-08 | Cape Verde 157 | Equatorial Guinea 202 | 3 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.965379 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36976 | ||||
| 36665 | 2013 1653 | 2013-01-27 | Cape Verde 157 | Angola 205 | 2 | 1 | H | African Cup of Nations | Port Elizabeth | Port Elizabeth | South Africa | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.813547 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36665 | ||||
| 36607 | 2013 1650 | 2013-01-09 | Cape Verde 157 | Nigeria 120 | 0 | 0 | D | Friendly | Faro | Faro | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.785254 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36607 | ||||
| 36431 | 2012 1623 | 2012-11-14 | Cape Verde 157 | Ghana 124 | 0 | 1 | A | Friendly | Lisbon | Lisbon | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.699742 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36431 | ||||
| 36173 | 2012 1624 | 2012-09-08 | Cape Verde 157 | Cameroon 140 | 2 | 0 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.574560 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36173 | ||||
| 36001 | 2012 1624 | 2012-06-16 | Cape Verde 157 | Madagascar 107 | 3 | 1 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.491101 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36001 | ||||
| 35933 | 2012 1627 | 2012-06-09 | Cape Verde 157 | Tunisia 152 | 1 | 2 | A | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:54 | 2026-06-07 21:04:04.404592 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35933 | ||||
| 35296 | 2011 1608 | 2011-10-08 | Cape Verde 157 | Zimbabwe 102 | 2 | 1 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:04.094442 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35296 | ||||
| 34622 | 2011 1608 | 2011-03-26 | Cape Verde 157 | Liberia 169 | 4 | 2 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.712073 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34622 | ||||
| 34536 | 2011 1599 | 2011-02-09 | Cape Verde 157 | Burkina Faso 159 | 1 | 0 | H | Friendly | Óbidos | Óbidos | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.670206 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34536 | ||||
| 34310 | 2010 1575 | 2010-11-16 | Cape Verde 157 | Guinea-Bissau 137 | 2 | 1 | H | Friendly | Lisbon | Lisbon | Portugal | 1 | 0 | 0 | 2026-06-07 06:58:53 | 2026-06-07 21:04:03.559988 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34310 | ||||
| 34036 | 2010 1586 | 2010-09-04 | Cape Verde 157 | Mali 162 | 1 | 0 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:03.426079 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34036 | ||||
| 32829 | 2009 1557 | 2009-03-28 | Cape Verde 157 | Equatorial Guinea 202 | 5 | 0 | H | Friendly | Espargos | Espargos | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:52 | 2026-06-07 21:04:02.697421 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32829 | ||||
| 32288 | 2008 1532 | 2008-09-06 | Cape Verde 157 | Cameroon 140 | 1 | 2 | A | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.424732 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32288 | ||||
| 32106 | 2008 1532 | 2008-06-22 | Cape Verde 157 | Mauritius 108 | 3 | 1 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.335177 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32106 | ||||
| 31957 | 2008 1532 | 2008-06-07 | Cape Verde 157 | Tanzania 101 | 1 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:02.208950 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31957 | ||||
| 31524 | 2007 1526 | 2007-12-03 | Cape Verde 157 | Gambia 133 | 0 | 0 | D | Amílcar Cabral Cup | Bissau | Bissau | Guinea-Bissau | 1 | 0 | 0 | 2026-06-07 06:58:51 | 2026-06-07 21:04:01.964649 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31524 | ||||
| 30954 | 2007 1511 | 2007-06-16 | Cape Verde 157 | Gambia 133 | 0 | 0 | D | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.633884 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30954 | ||||
| 30850 | 2007 1511 | 2007-06-02 | Cape Verde 157 | Algeria 173 | 2 | 2 | D | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.580964 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30850 | ||||
| 30334 | 2006 1494 | 2006-10-07 | Cape Verde 157 | Guinea 172 | 1 | 0 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:50 | 2026-06-07 21:04:01.329446 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30334 | ||||
| 29523 | 2005 1462 | 2005-10-08 | Cape Verde 157 | Ghana 124 | 0 | 4 | A | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.881130 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29523 | ||||
| 29194 | 2005 1462 | 2005-06-04 | Cape Verde 157 | South Africa 21 | 1 | 2 | A | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.721291 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29194 | ||||
| 28647 | 2004 1443 | 2004-10-09 | Cape Verde 157 | Burkina Faso 159 | 1 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.372290 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28647 | ||||
| 28382 | 2004 1443 | 2004-07-03 | Cape Verde 157 | DR Congo 113 | 1 | 1 | D | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.243728 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28382 | ||||
| 28330 | 2004 1443 | 2004-06-19 | Cape Verde 157 | Uganda 69 | 1 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.218448 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28330 | ||||
| 28305 | 2004 1438 | 2004-06-13 | Cape Verde 157 | Senegal 166 | 1 | 3 | A | Friendly | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:49 | 2026-06-07 21:04:00.206354 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28305 | ||||
| 27738 | 2003 1432 | 2003-11-16 | Cape Verde 157 | Eswatini 188 | 3 | 0 | H | FIFA World Cup qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.879386 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27738 | ||||
| 27304 | 2003 1423 | 2003-06-21 | Cape Verde 157 | Mauritania 168 | 3 | 0 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.668432 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27304 | ||||
| 27069 | 2003 1423 | 2003-03-29 | Cape Verde 157 | Togo 148 | 2 | 1 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.553917 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27069 | ||||
| 26699 | 2002 1405 | 2002-10-12 | Cape Verde 157 | Kenya 68 | 0 | 1 | A | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:48 | 2026-06-07 21:03:59.320197 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26699 | ||||
| 26040 | 2001 1383 | 2001-11-07 | Cape Verde 157 | Gambia 133 | 1 | 1 | D | Amílcar Cabral Cup | Sikasso | Sikasso | Mali | 1 | 0 | 0 | 2026-06-07 06:58:47 | 2026-06-07 21:03:58.967675 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26040 | ||||
| 24717 | 2000 1331 | 2000-07-06 | Cape Verde 157 | Angola 205 | 1 | 1 | D | Friendly | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.214086 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24717 | ||||
| 24503 | 2000 1345 | 2000-05-14 | Cape Verde 157 | Senegal 166 | 1 | 0 | H | Amílcar Cabral Cup | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.106043 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24503 | ||||
| 24500 | 2000 1345 | 2000-05-11 | Cape Verde 157 | Guinea 172 | 2 | 0 | H | Amílcar Cabral Cup | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.104535 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24500 | ||||
| 24494 | 2000 1345 | 2000-05-08 | Cape Verde 157 | Senegal 166 | 2 | 2 | D | Amílcar Cabral Cup | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.101516 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24494 | ||||
| 24484 | 2000 1345 | 2000-05-06 | Cape Verde 157 | Sierra Leone 119 | 1 | 0 | H | Amílcar Cabral Cup | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.096480 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24484 | ||||
| 24479 | 2000 1345 | 2000-05-04 | Cape Verde 157 | Gambia 133 | 1 | 1 | D | Amílcar Cabral Cup | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.093942 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24479 | ||||
| 24375 | 2000 1340 | 2000-04-09 | Cape Verde 157 | Algeria 173 | 0 | 0 | D | FIFA World Cup qualification | Mindelo | Mindelo | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:46 | 2026-06-07 21:03:58.041339 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24375 | ||||
| 22972 | 1998 1293 | 1998-08-16 | Cape Verde 157 | Mali 162 | 0 | 0 | D | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:57.218659 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22972 | ||||
| 22483 | 1997 1270 | 1997-12-02 | Cape Verde 157 | Mauritania 168 | 2 | 2 | D | Amílcar Cabral Cup | Banjul | Banjul | Gambia | 1 | 0 | 0 | 2026-06-07 06:58:45 | 2026-06-07 21:03:56.972796 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:22483 | ||||
| 20694 | 1995 1214 | 1995-11-27 | Cape Verde 157 | Guinea-Bissau 137 | 1 | 0 | H | Amílcar Cabral Cup | Nouakchott | Nouakchott | Mauritania | 1 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.947427 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20694 | ||||
| 20667 | 1995 1214 | 1995-11-17 | Cape Verde 157 | Mali 162 | 1 | 0 | H | Amílcar Cabral Cup | Nouakchott | Nouakchott | Mauritania | 1 | 0 | 0 | 2026-06-07 06:58:44 | 2026-06-07 21:03:55.934212 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:20667 | ||||
| 18337 | 1992 1131 | 1992-06-28 | Cape Verde 157 | Guinea-Bissau 137 | 1 | 0 | H | African Cup of Nations qualification | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.690221 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:18337 | ||||
| 18067 | 1991 1117 | 1991-11-30 | Cape Verde 157 | Sierra Leone 119 | 0 | 0 | D | Amílcar Cabral Cup | Dakar | Dakar | Senegal | 1 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.558546 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:18067 | ||||
| 18040 | 1991 1117 | 1991-11-22 | Cape Verde 157 | Guinea-Bissau 137 | 2 | 1 | H | Amílcar Cabral Cup | Dakar | Dakar | Senegal | 1 | 0 | 0 | 2026-06-07 06:58:42 | 2026-06-07 21:03:54.545359 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:18040 | ||||
| 16760 | 1989 1064 | 1989-06-03 | Cape Verde 157 | Sierra Leone 119 | 1 | 0 | H | Amílcar Cabral Cup | Bamako | Bamako | Mali | 1 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.780481 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16760 | ||||
| 16758 | 1989 1064 | 1989-06-02 | Cape Verde 157 | Guinea 172 | 0 | 1 | A | Amílcar Cabral Cup | Bamako | Bamako | Mali | 1 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.779497 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16758 | ||||
| 16745 | 1989 1064 | 1989-05-30 | Cape Verde 157 | Senegal 166 | 2 | 1 | H | Amílcar Cabral Cup | Bamako | Bamako | Mali | 1 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.773151 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16745 | ||||
| 16736 | 1989 1064 | 1989-05-27 | Cape Verde 157 | Guinea-Bissau 137 | 2 | 3 | A | Amílcar Cabral Cup | Bamako | Bamako | Mali | 1 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.768772 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16736 | ||||
| 16421 | 1988 1021 | 1988-11-19 | Cape Verde 157 | Angola 205 | 2 | 3 | A | Friendly | Praia | Praia | Cape Verde | 0 | 0 | 0 | 2026-06-07 06:58:41 | 2026-06-07 21:03:53.614643 | 1 1 | 6 6 | International Results CSV 1 | csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:16421 |
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);