home / football

match

316 rows where away_team_id = 158 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home_score, away_score, result, round_stage, is_neutral, created_at, date (date), created_at (date), updated_at (date)

match_id season_id date ▲ kickoff home_team_id away_team_id home_score away_score result round_stage matchday venue city country referee attendance is_neutral is_postponed is_cancelled created_at updated_at created_by_run_id updated_by_run_id source_id source_raw_key
49395 2026 1937 2026-06-25   Curaçao 63 Ivory Coast 158       FIFA World Cup   Philadelphia Philadelphia United States     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.884771 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49395
49371 2026 1937 2026-06-20   Germany 22 Ivory Coast 158       FIFA World Cup   Toronto Toronto Canada     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.872658 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49371
49309 2026 1929 2026-06-04   France 13 Ivory Coast 158 1 2 A Friendly   Nantes Nantes France     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.841257 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49309
49104 2026 1928 2026-01-10   Egypt 42 Ivory Coast 158 3 2 H African Cup of Nations   Agadir Agadir Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.737412 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49104
49091 2025 1927 2025-12-31   Gabon 160 Ivory Coast 158 2 3 A African Cup of Nations   Marrakesh Marrakesh Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.730810 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49091
48965 2025 1906 2025-11-18   Oman 184 Ivory Coast 158 0 2 A Friendly   Seeb Seeb Oman     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.613506 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48965
48902 2025 1906 2025-11-14   Saudi Arabia 179 Ivory Coast 158 1 0 H Friendly   Jeddah Jeddah Saudi Arabia     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.582957 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48902
48747 2025 1907 2025-10-10   Seychelles 201 Ivory Coast 158 0 7 A FIFA World Cup qualification   Saint Pierre Saint Pierre Mauritius     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.507807 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48747
48663 2025 1907 2025-09-09   Gabon 160 Ivory Coast 158 0 0 D FIFA World Cup qualification   Franceville Franceville Gabon     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.466959 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48663
48456 2025 1913 2025-06-10   Canada 6 Ivory Coast 158 0 0 D Canadian Shield   Toronto Toronto Canada     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.365691 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48456
48179 2025 1907 2025-03-21   Burundi 139 Ivory Coast 158 0 1 A FIFA World Cup qualification   Meknes Meknes Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.230765 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48179
47928 2024 1880 2024-11-15   Zambia 103 Ivory Coast 158 1 0 H African Cup of Nations qualification   Ndola Ndola Zambia     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:11.065108 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47928
47816 2024 1880 2024-10-15   Sierra Leone 119 Ivory Coast 158 1 0 H African Cup of Nations qualification   Monrovia Monrovia Liberia     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:11.010644 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47816
47630 2024 1880 2024-09-10   Chad 170 Ivory Coast 158 0 2 A African Cup of Nations qualification   Yaounde Yaounde Cameroon     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.919902 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47630
47339 2024 1886 2024-06-11   Kenya 68 Ivory Coast 158 0 0 D FIFA World Cup qualification   Lilongwe Lilongwe Malawi     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.750602 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47339
46769 2023 1872 2023-11-20   Gambia 133 Ivory Coast 158 0 2 A FIFA World Cup qualification   Dar es Salaam Dar es Salaam Tanzania     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.419669 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46769
46116 2023 1858 2023-06-17   Zambia 103 Ivory Coast 158 3 0 H African Cup of Nations qualification   Ndola Ndola Zambia     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.102121 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46116
46010 2023 1858 2023-03-28   Comoros 213 Ivory Coast 158 0 2 A African Cup of Nations qualification   Moroni Moroni Comoros     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.050807 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46010
45311 2022 1835 2022-06-09   Lesotho 191 Ivory Coast 158 0 0 D African Cup of Nations qualification   Soweto Soweto South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.666686 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45311
45094 2022 1832 2022-03-29   England 2 Ivory Coast 158 3 0 H Friendly   London London England     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.560858 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45094
45016 2022 1832 2022-03-25   France 13 Ivory Coast 158 2 1 H Friendly   Marseille Marseille France     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.522809 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45016
44854 2022 1833 2022-01-12   Equatorial Guinea 202 Ivory Coast 158 0 1 A African Cup of Nations   Douala Douala Cameroon     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.360936 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44854
44744 2021 1813 2021-11-16   Cameroon 140 Ivory Coast 158 1 0 H FIFA World Cup qualification   Douala Douala Cameroon     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.307581 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44744
44514 2021 1813 2021-10-08   Malawi 154 Ivory Coast 158 0 3 A FIFA World Cup qualification   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.195613 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44514
44351 2021 1813 2021-09-03   Mozambique 203 Ivory Coast 158 0 0 D FIFA World Cup qualification   Maputo Maputo Mozambique     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.116354 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44351
44103 2021 1812 2021-06-12   Ghana 124 Ivory Coast 158 0 0 D Friendly   Cape Coast Cape Coast Ghana     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.995419 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44103
43806 2021 1814 2021-03-26   Niger 171 Ivory Coast 158 0 3 A African Cup of Nations qualification   Lomé Lomé Togo     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.796950 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43806
43699 2020 1811 2020-11-17   Madagascar 107 Ivory Coast 158 1 1 D African Cup of Nations qualification   Toamasina Toamasina Madagascar     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.745160 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43699
43529 2020 1807 2020-10-13   Japan 36 Ivory Coast 158 1 0 H Friendly   Utrecht Utrecht Netherlands     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.662036 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43529
43454 2020 1807 2020-10-08   Belgium 12 Ivory Coast 158 1 1 D Friendly   Brussels Brussels Belgium     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.625606 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43454
43310 2019 1787 2019-11-19   Ethiopia 112 Ivory Coast 158 2 1 H African Cup of Nations qualification   Ethiopia Ethiopia Ethiopia     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.555504 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43310
42735 2019 1797 2019-07-08   Mali 162 Ivory Coast 158 0 1 A African Cup of Nations   Suez Suez Egypt     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.215598 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42735
42714 2019 1797 2019-07-01   Namibia 231 Ivory Coast 158 1 4 A African Cup of Nations   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.204431 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42714
42695 2019 1797 2019-06-28   Morocco 155 Ivory Coast 158 1 0 H African Cup of Nations   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.194746 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42695
42129 2018 1778 2018-11-18   Guinea 172 Ivory Coast 158 1 1 D African Cup of Nations qualification   Conakry Conakry Guinea     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.910089 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42129
42015 2018 1778 2018-10-16   Central African Republic 163 Ivory Coast 158 0 0 D African Cup of Nations qualification   Bangui Bangui Central African Republic     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.854540 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42015
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
41429 2018 1765 2018-03-27   Moldova 146 Ivory Coast 158 1 2 A Friendly   Beauvais Beauvais France     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.472677 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41429
41041 2017 1747 2017-10-06   Mali 162 Ivory Coast 158 0 0 D FIFA World Cup qualification   Bamako Bamako Mali     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.275398 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41041
40934 2017 1747 2017-09-02   Gabon 160 Ivory Coast 158 0 3 A FIFA World Cup qualification   Franceville Franceville Gabon     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.168584 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40934
40611 2017 1743 2017-06-04   Netherlands 18 Ivory Coast 158 5 0 H Friendly   Rotterdam Rotterdam Netherlands     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.004225 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40611
40491 2017 1743 2017-03-24   Russia 28 Ivory Coast 158 0 2 A Friendly   Krasnodar Krasnodar Russia     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.945017 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40491
40424 2017 1745 2017-01-24   Morocco 155 Ivory Coast 158 1 0 H African Cup of Nations   Oyem Oyem Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.912412 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40424
40325 2016 1719 2016-11-15   France 13 Ivory Coast 158 0 0 D Friendly   Lens Lens France     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.864343 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40325
40286 2016 1724 2016-11-12   Morocco 155 Ivory Coast 158 0 0 D FIFA World Cup qualification   Marrakech Marrakech Morocco     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.845372 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40286
39656 2016 1719 2016-05-20   Hungary 10 Ivory Coast 158 0 0 D Friendly   Budapest Budapest Hungary     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.455657 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39656
39637 2016 1723 2016-03-29   Sudan 150 Ivory Coast 158 1 1 D African Cup of Nations qualification   Omdurman Omdurman Sudan     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.446443 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39637
39322 2015 1700 2015-11-13   Liberia 169 Ivory Coast 158 0 1 A FIFA World Cup qualification   Monrovia Monrovia Liberia     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.292785 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39322
39181 2015 1696 2015-10-09   Morocco 155 Ivory Coast 158 0 1 A Friendly   Agadir Agadir Morocco     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.224184 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39181
39076 2015 1709 2015-09-06   Sierra Leone 119 Ivory Coast 158 0 0 D African Cup of Nations qualification   Port Harcourt Port Harcourt Nigeria     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.173123 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39076
38814 2015 1696 2015-06-14   Gabon 160 Ivory Coast 158 0 0 D Friendly   Libreville Libreville Gabon     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:05.991970 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38814
38501 2015 1698 2015-02-04   DR Congo 113 Ivory Coast 158 1 3 A African Cup of Nations   Bata Bata Equatorial Guinea     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.839468 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38501
38487 2015 1698 2015-01-28   Cameroon 140 Ivory Coast 158 0 1 A African Cup of Nations   Malabo Malabo Equatorial Guinea     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.832684 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38487
38443 2015 1696 2015-01-15   Sweden 23 Ivory Coast 158 2 0 H Friendly   Abu Dhabi Abu Dhabi United Arab Emirates     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.811382 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38443
38429 2015 1696 2015-01-11   Nigeria 120 Ivory Coast 158 0 1 A Friendly   Abu Dhabi Abu Dhabi United Arab Emirates     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.804541 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38429
38395 2014 1675 2014-11-30   South Africa 21 Ivory Coast 158 2 0 H Friendly   Nelspruit Nelspruit South Africa     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.788053 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38395
38240 2014 1675 2014-10-25   Zambia 103 Ivory Coast 158 1 1 D Friendly   Lusaka Lusaka Zambia     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.712804 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38240
38148 2014 1678 2014-10-11   DR Congo 113 Ivory Coast 158 1 2 A African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.668057 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38148
38084 2014 1678 2014-09-10   Cameroon 140 Ivory Coast 158 4 1 H African Cup of Nations qualification   Yaoundé Yaoundé Cameroon     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.636961 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38084
37901 2014 1685 2014-06-24   Greece 39 Ivory Coast 158 2 1 H FIFA World Cup   Fortaleza Fortaleza Brazil     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.498130 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37901
37882 2014 1685 2014-06-19   Colombia 86 Ivory Coast 158 2 1 H FIFA World Cup   Brasília Brasília Brazil     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.488915 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37882
37813 2014 1675 2014-06-04   El Salvador 47 Ivory Coast 158 1 2 A Friendly   Frisco Frisco United States     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.455399 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37813
37748 2014 1675 2014-05-30   Bosnia and Herzegovina 248 Ivory Coast 158 2 1 H Friendly   St. Louis St. Louis United States     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.423730 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37748
37589 2014 1675 2014-03-05   Belgium 12 Ivory Coast 158 2 2 D Friendly   Brussels Brussels Belgium     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.345755 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37589
37467 2013 1655 2013-11-16   Senegal 166 Ivory Coast 158 1 1 D FIFA World Cup qualification   Casablanca Casablanca Morocco     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.286301 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37467
37166 2013 1650 2013-08-14   Mexico 57 Ivory Coast 158 4 1 H Friendly   East Rutherford East Rutherford United States     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.139485 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37166
37042 2013 1655 2013-06-16   Tanzania 101 Ivory Coast 158 2 4 A FIFA World Cup qualification   Dar es Salaam Dar es Salaam Tanzania     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.078888 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37042
37018 2013 1650 2013-06-14   Ghana 124 Ivory Coast 158 1 1 D Friendly   Obuasi Obuasi Ghana     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.067177 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37018
37015 2013 1650 2013-06-12   Ghana 124 Ivory Coast 158 2 1 H Friendly   Kumasi Kumasi Ghana     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.065709 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37015
36979 2013 1655 2013-06-08   Gambia 133 Ivory Coast 158 0 3 A FIFA World Cup qualification   Bakau Bakau Gambia     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.966836 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36979
36674 2013 1653 2013-01-30   Algeria 173 Ivory Coast 158 2 2 D African Cup of Nations   Rustenburg Rustenburg South Africa     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.817938 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36674
36427 2012 1623 2012-11-14   Austria 9 Ivory Coast 158 0 3 A Friendly   Linz Linz Austria     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.697801 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36427
36339 2012 1624 2012-10-13   Senegal 166 Ivory Coast 158 0 2 A African Cup of Nations qualification   Dakar Dakar Senegal     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.655073 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36339
36094 2012 1623 2012-08-15   Russia 28 Ivory Coast 158 1 1 D Friendly   Moscow Moscow Russia     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.536253 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36094
35940 2012 1627 2012-06-09   Morocco 155 Ivory Coast 158 2 2 D FIFA World Cup qualification   Marrakech Marrakech Morocco     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.407998 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35940
35626 2012 1626 2012-02-12   Zambia 103 Ivory Coast 158 0 0 D African Cup of Nations   Libreville Libreville Gabon     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.254927 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35626
35623 2012 1626 2012-02-08   Mali 162 Ivory Coast 158 0 1 A African Cup of Nations   Libreville Libreville Gabon     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.253467 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35623
35619 2012 1626 2012-02-04   Equatorial Guinea 202 Ivory Coast 158 0 3 A African Cup of Nations   Malabo Malabo Equatorial Guinea     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.251527 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35619
35576 2012 1623 2012-01-13   Tunisia 152 Ivory Coast 158 0 2 A Friendly   Abu Dhabi Abu Dhabi United Arab Emirates     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.230563 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35576
35439 2011 1599 2011-11-12   South Africa 21 Ivory Coast 158 1 1 D Friendly   Port Elizabeth Port Elizabeth South Africa     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.163901 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35439
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
35017 2011 1599 2011-08-10   Israel 82 Ivory Coast 158 3 4 A Friendly   Geneva Geneva Switzerland     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.958371 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35017
34778 2011 1608 2011-06-05   Benin 156 Ivory Coast 158 2 6 A African Cup of Nations qualification   Cotonou Cotonou Benin     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.788120 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34778
34525 2011 1599 2011-02-08   Mali 162 Ivory Coast 158 0 1 A Friendly   Valence Valence France     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.664853 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34525
34349 2010 1575 2010-11-17   Poland 49 Ivory Coast 158 3 1 H Friendly   Poznań Poznań Poland     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.579031 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34349
34191 2010 1586 2010-10-09   Burundi 139 Ivory Coast 158 0 1 A African Cup of Nations qualification   Bujumbura Bujumbura Burundi     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.501919 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34191
33943 2010 1575 2010-08-10   Italy 26 Ivory Coast 158 0 1 A Friendly   London London England     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.296532 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33943
33915 2010 1584 2010-06-25   North Korea 149 Ivory Coast 158 0 3 A FIFA World Cup   Nelspruit Nelspruit South Africa     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.282946 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33915
33894 2010 1584 2010-06-20   Brazil 34 Ivory Coast 158 3 1 H FIFA World Cup   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.272778 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33894
33842 2010 1575 2010-06-04   Japan 36 Ivory Coast 158 0 2 A Friendly   Sion Sion Switzerland     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.246725 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33842
33817 2010 1575 2010-05-30   Paraguay 37 Ivory Coast 158 2 2 D Friendly   Thonon-les-Bains Thonon-les-Bains France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.234142 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33817
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
33594 2010 1575 2010-01-04   Tanzania 101 Ivory Coast 158 0 1 A Friendly   Dar es Salaam Dar es Salaam Tanzania     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.125736 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33594
33519 2009 1557 2009-11-18   Germany 22 Ivory Coast 158 2 2 D Friendly   Gelsenkirchen Gelsenkirchen Germany     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.089310 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33519
33365 2009 1562 2009-10-10   Malawi 154 Ivory Coast 158 1 1 D FIFA World Cup qualification   Blantyre Blantyre Malawi     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.014309 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33365
33216 2009 1557 2009-08-12   Tunisia 152 Ivory Coast 158 0 0 D Friendly   Sousse Sousse Tunisia     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.941578 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33216
33063 2009 1562 2009-06-20   Burkina Faso 159 Ivory Coast 158 2 3 A FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.867156 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33063
33012 2009 1562 2009-06-07   Guinea 172 Ivory Coast 158 1 2 A FIFA World Cup qualification   Conakry Conakry Guinea     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.842583 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33012
32795 2009 1557 2009-02-11   Turkey 61 Ivory Coast 158 1 1 D Friendly   İzmir İzmir Turkey     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.680286 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32795
32581 2008 1529 2008-11-19   Israel 82 Ivory Coast 158 2 2 D Friendly   Ramat Gan Ramat Gan Israel     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.572401 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32581

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE match (
            match_id INTEGER NOT NULL,
            season_id INTEGER NOT NULL,
            date DATE NOT NULL,
            kickoff DATETIME,
            home_team_id INTEGER NOT NULL,
            away_team_id INTEGER NOT NULL,
            home_score INTEGER,
            away_score INTEGER,
            result VARCHAR(1),
            round_stage VARCHAR(64),
            matchday INTEGER,
            venue VARCHAR(256),
            city VARCHAR(128),
            country VARCHAR(128),
            referee VARCHAR(128),
            attendance INTEGER,
            is_neutral BOOLEAN NOT NULL,
            is_postponed BOOLEAN NOT NULL,
            is_cancelled BOOLEAN NOT NULL,
            created_at DATETIME NOT NULL,
            updated_at DATETIME NOT NULL,
            created_by_run_id INTEGER,
            updated_by_run_id INTEGER,
            source_id INTEGER,
            source_raw_key VARCHAR(512),
            CONSTRAINT pk_match PRIMARY KEY (match_id),
            CONSTRAINT fk_match_season FOREIGN KEY(season_id) REFERENCES season (season_id),
            CONSTRAINT fk_match_home_team FOREIGN KEY(home_team_id) REFERENCES team (team_id),
            CONSTRAINT fk_match_away_team FOREIGN KEY(away_team_id) REFERENCES team (team_id),
            CONSTRAINT fk_match_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
            CONSTRAINT fk_match_created_by_run FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id),
            CONSTRAINT fk_match_updated_by_run FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id)
        );
CREATE INDEX ix_match_away_team_id ON match (away_team_id);
CREATE INDEX ix_match_created_by_run_id ON match (created_by_run_id);
CREATE INDEX ix_match_source_id ON match (source_id);
CREATE INDEX ix_match_updated_by_run_id ON match (updated_by_run_id);
CREATE INDEX ix_match_date ON match (date);
CREATE INDEX ix_match_season_id ON match (season_id);
CREATE INDEX ix_match_source_raw_key ON match (source_raw_key);
CREATE INDEX ix_match_home_team_id ON match (home_team_id);
CREATE UNIQUE INDEX ux_match_season_date_teams ON match(season_id, date, home_team_id, away_team_id);
Powered by Datasette · Queries took 43.753ms