home / football

match

215 rows where home_team_id = 159 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home_score, away_score, result, round_stage, 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
49220 2026 1929 2026-03-31   Burkina Faso 159 Guinea-Bissau 137 1 1 D Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.796178 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49220
49176 2026 1929 2026-03-28   Burkina Faso 159 Guinea-Bissau 137 5 0 H Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.773879 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49176
49065 2025 1927 2025-12-24   Burkina Faso 159 Equatorial Guinea 202 2 1 H African Cup of Nations   Casablanca Casablanca Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.717595 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49065
48900 2025 1906 2025-11-14   Burkina Faso 159 Niger 171 3 2 H Friendly   Mohammedia Mohammedia Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.581995 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48900
48774 2025 1907 2025-10-12   Burkina Faso 159 Ethiopia 112 3 1 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.520921 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48774
48652 2025 1907 2025-09-09   Burkina Faso 159 Egypt 42 0 0 D FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.461621 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48652
48173 2025 1907 2025-03-21   Burkina Faso 159 Djibouti 111 4 1 H FIFA World Cup qualification   El Jadida El Jadida Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.227834 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48173
48094 2025 1904 2025-01-04   Burkina Faso 159 Kenya 68 1 1 D Mapinduzi Cup   Gombani Gombani Zanzibar     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.189313 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48094
47899 2024 1880 2024-11-14   Burkina Faso 159 Senegal 166 0 1 A African Cup of Nations qualification   Bamako Bamako Mali     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:11.051052 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47899
47680 2024 1880 2024-10-10   Burkina Faso 159 Burundi 139 4 1 H African Cup of Nations qualification   Ebimpé Ebimpé Ivory Coast     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.944278 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47680
47636 2024 1880 2024-09-10   Burkina Faso 159 Malawi 154 3 1 H African Cup of Nations qualification   Bamako Bamako Mali     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.922887 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47636
47312 2024 1886 2024-06-10   Burkina Faso 159 Sierra Leone 119 2 2 D FIFA World Cup qualification   Bamako Bamako Mali     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.737479 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47312
47069 2024 1877 2024-03-22   Burkina Faso 159 Libya 153 1 2 A Friendly   Casablanca Casablanca Morocco     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.619361 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47069
46920 2024 1879 2024-01-16   Burkina Faso 159 Mauritania 168 1 0 H African Cup of Nations   Bouaké Bouaké Ivory Coast     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.493304 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46920
46709 2023 1872 2023-11-17   Burkina Faso 159 Guinea-Bissau 137 1 1 D FIFA World Cup qualification   Marrakech Marrakech Morocco     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.390405 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46709
46622 2023 1856 2023-10-17   Burkina Faso 159 Mauritania 168 2 1 H Friendly   Casablanca Casablanca Morocco     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.348208 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46622
46365 2023 1858 2023-09-08   Burkina Faso 159 Eswatini 188 0 0 D African Cup of Nations qualification   Marrakech Marrakech Morocco     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.223319 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46365
45893 2023 1858 2023-03-24   Burkina Faso 159 Togo 148 1 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.949535 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45893
45580 2022 1832 2022-09-27   Burkina Faso 159 Comoros 213 2 1 H Friendly   Casablanca Casablanca Morocco     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.797567 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45580
45188 2022 1835 2022-06-03   Burkina Faso 159 Cape Verde 157 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.606675 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45188
44945 2022 1833 2022-02-02   Burkina Faso 159 Senegal 166 1 3 A African Cup of Nations   Yaoundé Yaoundé Cameroon     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.405186 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44945
44920 2022 1833 2022-01-29   Burkina Faso 159 Tunisia 152 1 0 H African Cup of Nations   Garoua Garoua Cameroon     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.393018 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44920
44889 2022 1833 2022-01-23   Burkina Faso 159 Gabon 160 1 1 D African Cup of Nations   Limbé Limbé Cameroon     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.377903 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44889
44872 2022 1833 2022-01-17   Burkina Faso 159 Ethiopia 112 1 1 D African Cup of Nations   Bafoussam Bafoussam Cameroon     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.369659 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44872
44662 2021 1813 2021-11-12   Burkina Faso 159 Niger 171 1 1 D FIFA World Cup qualification   Marrakech Marrakech Morocco     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.267884 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44662
44575 2021 1813 2021-10-11   Burkina Faso 159 Djibouti 111 2 0 H FIFA World Cup qualification   Marrakech Marrakech Morocco     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.225238 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44575
44409 2021 1813 2021-09-07   Burkina Faso 159 Algeria 173 1 1 D FIFA World Cup qualification   Marrakech Marrakech Morocco     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.144463 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44409
43861 2021 1814 2021-03-29   Burkina Faso 159 South Sudan 295 1 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.823734 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43861
43600 2020 1811 2020-11-12   Burkina Faso 159 Malawi 154 3 1 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.696574 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43600
43516 2020 1807 2020-10-12   Burkina Faso 159 Madagascar 107 2 1 H Friendly   El Jadida El Jadida Morocco     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.655747 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43516
43470 2020 1807 2020-10-09   Burkina Faso 159 DR Congo 113 3 0 H Friendly   Mohammedia Mohammedia Morocco     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.633332 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43470
43171 2019 1787 2019-11-13   Burkina Faso 159 Uganda 69 0 0 D African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.487757 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43171
42336 2019 1787 2019-03-22   Burkina Faso 159 Mauritania 168 1 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.011666 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42336
41953 2018 1778 2018-10-13   Burkina Faso 159 Botswana 189 3 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.739128 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41953
41327 2018 1765 2018-03-22   Burkina Faso 159 Guinea-Bissau 137 2 0 H Friendly   Limeil-Brévannes Limeil-Brévannes France     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.420706 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41327
41196 2017 1747 2017-11-14   Burkina Faso 159 Cape Verde 157 4 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.353996 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41196
40974 2017 1747 2017-09-05   Burkina Faso 159 Senegal 166 2 2 D FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.188758 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40974
40861 2017 1759 2017-07-16   Burkina Faso 159 North Korea 149 3 3 D King's Cup   Bangkok Bangkok Thailand     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.131504 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40861
40677 2017 1746 2017-06-10   Burkina Faso 159 Angola 205 3 1 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.038008 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40677
40577 2017 1743 2017-05-04   Burkina Faso 159 Benin 156 1 1 D Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.986844 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40577
40437 2017 1745 2017-02-04   Burkina Faso 159 Ghana 124 1 0 H African Cup of Nations   Port-Gentil Port-Gentil Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.918706 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40437
40435 2017 1745 2017-02-01   Burkina Faso 159 Egypt 42 1 1 D African Cup of Nations   Libreville Libreville Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.917743 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40435
40430 2017 1745 2017-01-28   Burkina Faso 159 Tunisia 152 2 0 H African Cup of Nations   Libreville Libreville Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.915327 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40430
40391 2017 1745 2017-01-14   Burkina Faso 159 Cameroon 140 1 1 D African Cup of Nations   Libreville Libreville Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.896414 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40391
40378 2017 1743 2017-01-07   Burkina Faso 159 Mali 162 2 1 H Friendly   Marrakech Marrakech Morocco     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.890046 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40378
40141 2016 1724 2016-10-08   Burkina Faso 159 South Africa 21 1 1 D FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.774810 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40141
40026 2016 1723 2016-09-04   Burkina Faso 159 Botswana 189 2 1 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.718840 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40026
39557 2016 1723 2016-03-26   Burkina Faso 159 Uganda 69 1 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.407166 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39557
39364 2015 1700 2015-11-17   Burkina Faso 159 Benin 156 2 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.313153 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39364
39173 2015 1696 2015-10-09   Burkina Faso 159 Mali 162 1 4 A Friendly   Troyes Troyes France     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.220294 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39173
38787 2015 1709 2015-06-13   Burkina Faso 159 Comoros 213 2 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.978738 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38787
38707 2015 1696 2015-06-06   Burkina Faso 159 Cameroon 140 2 3 A Friendly   Colombes Colombes France     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.939882 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38707
38448 2015 1698 2015-01-17   Burkina Faso 159 Gabon 160 0 2 A African Cup of Nations   Bata Bata Equatorial Guinea     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.813799 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38448
38422 2015 1696 2015-01-10   Burkina Faso 159 Eswatini 188 5 1 H Friendly   Nelspruit Nelspruit South Africa     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.801154 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38422
38361 2014 1678 2014-11-19   Burkina Faso 159 Angola 205 1 1 D African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.771519 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38361
38220 2014 1678 2014-10-15   Burkina Faso 159 Gabon 160 1 1 D African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.703107 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38220
38019 2014 1678 2014-09-06   Burkina Faso 159 Lesotho 191 2 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.605443 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38019
37697 2014 1675 2014-05-21   Burkina Faso 159 Senegal 166 1 1 D Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.398797 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37697
37593 2014 1675 2014-03-05   Burkina Faso 159 Comoros 213 1 1 D Friendly   Martigues Martigues France     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.347686 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37593
37362 2013 1655 2013-10-12   Burkina Faso 159 Algeria 173 3 2 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.235088 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37362
37251 2013 1655 2013-09-07   Burkina Faso 159 Gabon 160 1 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.180883 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37251
36822 2013 1655 2013-03-23   Burkina Faso 159 Niger 171 4 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.889983 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36822
36688 2013 1653 2013-02-06   Burkina Faso 159 Ghana 124 1 1 D African Cup of Nations   Nelspruit Nelspruit South Africa     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.824749 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36688
36682 2013 1653 2013-02-03   Burkina Faso 159 Togo 148 1 0 H African Cup of Nations   Nelspruit Nelspruit South Africa     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.821828 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36682
36671 2013 1653 2013-01-29   Burkina Faso 159 Zambia 103 0 0 D African Cup of Nations   Nelspruit Nelspruit South Africa     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.816476 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36671
36656 2013 1653 2013-01-25   Burkina Faso 159 Ethiopia 112 4 0 H African Cup of Nations   Nelspruit Nelspruit South Africa     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.809087 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36656
36351 2012 1624 2012-10-14   Burkina Faso 159 Central African Republic 163 3 1 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.660878 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36351
36052 2012 1623 2012-08-14   Burkina Faso 159 Togo 148 3 0 H Friendly   Saint-Leu-la-Forêt Saint-Leu-la-Forêt France     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.515890 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36052
35844 2012 1627 2012-06-02   Burkina Faso 159 Congo Republic 161 0 3 A FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.360893 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35844
35783 2012 1623 2012-05-26   Burkina Faso 159 Benin 156 2 2 D Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.331289 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35783
35590 2012 1626 2012-01-22   Burkina Faso 159 Angola 205 1 2 A African Cup of Nations   Malabo Malabo Equatorial Guinea     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.237352 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35590
35387 2011 1599 2011-11-11   Burkina Faso 159 Mali 162 1 1 D Friendly   Saint-Leu-la-Forêt Saint-Leu-la-Forêt France     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.138648 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35387
35140 2011 1599 2011-09-03   Burkina Faso 159 Equatorial Guinea 202 1 0 H Friendly   Bobo Dioulasso Bobo Dioulasso Burkina Faso     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.018398 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35140
34621 2011 1608 2011-03-26   Burkina Faso 159 Namibia 231 4 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.711591 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34621
34319 2010 1575 2010-11-17   Burkina Faso 159 Guinea 172 2 1 H Friendly   Mantes-la-Ville Mantes-la-Ville France     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.564414 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34319
34190 2010 1586 2010-10-09   Burkina Faso 159 Gambia 133 3 1 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.501423 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34190
34062 2010 1575 2010-09-06   Burkina Faso 159 Gabon 160 1 1 D Friendly   Cannes Cannes France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.438786 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34062
33953 2010 1575 2010-08-11   Burkina Faso 159 Congo Republic 161 3 0 H Friendly   Senlis Senlis France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.301388 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33953
33631 2010 1577 2010-01-19   Burkina Faso 159 Ghana 124 0 1 A African Cup of Nations   Luanda Luanda Angola     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.143644 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33631
33467 2009 1562 2009-11-14   Burkina Faso 159 Malawi 154 1 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.063986 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33467
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
32828 2009 1562 2009-03-28   Burkina Faso 159 Guinea 172 4 2 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.696913 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32828
32760 2009 1557 2009-02-11   Burkina Faso 159 Togo 148 1 1 D Friendly   Le Petit-Quevilly Le Petit-Quevilly France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.662680 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32760
32287 2008 1532 2008-09-06   Burkina Faso 159 Tunisia 152 0 0 D FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.424228 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32287
32089 2008 1532 2008-06-21   Burkina Faso 159 Seychelles 201 4 1 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.326912 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32089
31956 2008 1532 2008-06-07   Burkina Faso 159 Burundi 139 2 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.208463 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31956
31837 2008 1529 2008-05-24   Burkina Faso 159 Cape Verde 157 0 1 A Friendly   Alcochete Alcochete Portugal     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.122317 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31837
30952 2007 1511 2007-06-16   Burkina Faso 159 Tanzania 101 0 1 A African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.632869 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30952
30930 2007 1502 2007-06-09   Burkina Faso 159 Mali 162 0 1 A Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.621677 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30930
30709 2007 1511 2007-03-24   Burkina Faso 159 Mozambique 203 1 1 D African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.511668 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30709
30332 2006 1494 2006-10-07   Burkina Faso 159 Senegal 166 1 0 H African Cup of Nations qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.328468 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30332
29437 2005 1462 2005-09-03   Burkina Faso 159 South Africa 21 3 1 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.839379 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29437
29281 2005 1462 2005-06-18   Burkina Faso 159 DR Congo 113 2 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.763612 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29281
29069 2005 1462 2005-03-26   Burkina Faso 159 Cape Verde 157 1 2 A FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.660375 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29069
28537 2004 1443 2004-09-04   Burkina Faso 159 Uganda 69 2 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.318916 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28537
28303 2004 1438 2004-06-13   Burkina Faso 159 Benin 156 4 2 H Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.205392 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28303
28244 2004 1443 2004-06-05   Burkina Faso 159 Ghana 124 1 0 H FIFA World Cup qualification   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.176689 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28244
28201 2004 1438 2004-05-30   Burkina Faso 159 Libya 153 3 2 H Friendly   Ouagadougou Ouagadougou Burkina Faso     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.155772 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28201
27911 2004 1441 2004-02-02   Burkina Faso 159 Kenya 68 0 3 A African Cup of Nations   Bizerte Bizerte Tunisia     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.963255 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27911
27901 2004 1441 2004-01-30   Burkina Faso 159 Mali 162 1 3 A African Cup of Nations   Tunis Tunis Tunisia     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.958421 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27901

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