home / football

match

204 rows where home_team_id = 102 sorted by date descending

✎ View and edit SQL

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
49273 2026 1935 2026-05-30   Zimbabwe 102 India 92 1 0 H Unity Cup   London London England     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.822978 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49273
49084 2025 1927 2025-12-29   Zimbabwe 102 South Africa 21 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.727246 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49084
48656 2025 1907 2025-09-09   Zimbabwe 102 Rwanda 207 0 1 A FIFA World Cup qualification   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.463571 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48656
48354 2025 1906 2025-06-06   Zimbabwe 102 Burkina Faso 159 0 2 A Friendly   Mohammédia Mohammédia Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.316109 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48354
48149 2025 1907 2025-03-20   Zimbabwe 102 Benin 156 2 2 D FIFA World Cup qualification   Durban Durban South Africa     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.216151 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48149
47931 2024 1880 2024-11-15   Zimbabwe 102 Kenya 68 1 1 D African Cup of Nations qualification   Polokwane Polokwane South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:11.066564 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47931
47784 2024 1880 2024-10-14   Zimbabwe 102 Namibia 231 3 1 H African Cup of Nations qualification   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.995078 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47784
47668 2024 1880 2024-09-10   Zimbabwe 102 Cameroon 140 0 0 D African Cup of Nations qualification   Kampala Kampala Uganda     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.938462 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47668
47261 2024 1886 2024-06-07   Zimbabwe 102 Lesotho 191 0 2 A FIFA World Cup qualification   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.712722 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47261
46750 2023 1872 2023-11-19   Zimbabwe 102 Nigeria 120 1 1 D FIFA World Cup qualification   Butare Butare Rwanda     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.410362 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46750
44876 2022 1833 2022-01-18   Zimbabwe 102 Guinea 172 2 1 H African Cup of Nations   Yaoundé Yaoundé Cameroon     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.371616 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44876
44702 2021 1813 2021-11-14   Zimbabwe 102 Ethiopia 112 1 1 D FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.287196 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44702
44602 2021 1813 2021-10-12   Zimbabwe 102 Ghana 124 0 1 A FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.238450 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44602
44353 2021 1813 2021-09-03   Zimbabwe 102 South Africa 21 0 0 D FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.117329 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44353
43868 2021 1814 2021-03-29   Zimbabwe 102 Zambia 103 0 2 A African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.827132 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43868
43669 2020 1811 2020-11-16   Zimbabwe 102 Algeria 173 2 2 D African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.730545 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43669
43223 2019 1787 2019-11-15   Zimbabwe 102 Botswana 189 0 0 D African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.513183 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43223
42989 2019 1793 2019-09-10   Zimbabwe 102 Somalia 178 3 1 H FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.345012 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42989
42707 2019 1797 2019-06-30   Zimbabwe 102 DR Congo 113 0 4 A African Cup of Nations   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.200858 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42707
42475 2019 1789 2019-06-05   Zimbabwe 102 Zambia 103 0 0 D COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.082498 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42475
42447 2019 1789 2019-06-01   Zimbabwe 102 Comoros 213 2 0 H COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.068166 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42447
42380 2019 1787 2019-03-24   Zimbabwe 102 Congo Republic 161 2 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.034026 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42380
42030 2018 1778 2018-10-16   Zimbabwe 102 DR Congo 113 1 1 D African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.861876 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42030
41558 2018 1768 2018-06-03   Zimbabwe 102 Botswana 189 1 1 D COSAFA Cup   Polokwane Polokwane South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.538287 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41558
41456 2018 1765 2018-04-18   Zimbabwe 102 Botswana 189 0 1 A Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.486391 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41456
40818 2017 1755 2017-06-30   Zimbabwe 102 Seychelles 201 6 0 H COSAFA Cup   Rustenburg Rustenburg South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.109769 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40818
40804 2017 1755 2017-06-28   Zimbabwe 102 Madagascar 107 0 0 D COSAFA Cup   Rustenburg Rustenburg South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.102641 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40804
40719 2017 1746 2017-06-11   Zimbabwe 102 Liberia 169 3 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.059391 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40719
40523 2017 1743 2017-03-26   Zimbabwe 102 Zambia 103 0 0 D Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.960594 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40523
40423 2017 1745 2017-01-23   Zimbabwe 102 Tunisia 152 2 4 A African Cup of Nations   Libreville Libreville Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.911925 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40423
40310 2016 1719 2016-11-13   Zimbabwe 102 Tanzania 101 3 0 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.856993 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40310
40228 2016 1719 2016-11-05   Zimbabwe 102 Zambia 103 1 0 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.817198 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40228
39890 2016 1734 2016-06-15   Zimbabwe 102 Seychelles 201 5 0 H COSAFA Cup   Windhoek Windhoek Namibia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.597464 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39890
39864 2016 1734 2016-06-11   Zimbabwe 102 Eswatini 188 2 2 D COSAFA Cup   Windhoek Windhoek Namibia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.584750 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39864
39820 2016 1723 2016-06-05   Zimbabwe 102 Malawi 154 3 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.563241 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39820
39720 2016 1719 2016-05-31   Zimbabwe 102 Uganda 69 2 0 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.514210 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39720
39562 2016 1723 2016-03-26   Zimbabwe 102 Eswatini 188 4 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.409588 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39562
39078 2015 1709 2015-09-06   Zimbabwe 102 Guinea 172 1 1 D African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.174163 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39078
38656 2015 1706 2015-05-17   Zimbabwe 102 Mauritius 108 2 0 H COSAFA Cup   Moruleng-Saulspoort Moruleng-Saulspoort South Africa     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.915090 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38656
37789 2014 1678 2014-06-01   Zimbabwe 102 Tanzania 101 2 2 D African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.443671 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37789
37565 2014 1675 2014-01-07   Zimbabwe 102 Gabon 160 2 0 H Friendly   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.334097 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37565
37269 2013 1655 2013-09-08   Zimbabwe 102 Mozambique 203 1 1 D FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.189671 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37269
37116 2013 1664 2013-07-17   Zimbabwe 102 Lesotho 191 2 1 H COSAFA Cup   Ndola Ndola Zambia     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.115064 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37116
37100 2013 1664 2013-07-13   Zimbabwe 102 Malawi 154 1 1 D COSAFA Cup   Lusaka Lusaka Zambia     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.107264 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37100
36992 2013 1655 2013-06-09   Zimbabwe 102 Egypt 42 2 4 A FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.973140 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36992
36734 2013 1650 2013-02-06   Zimbabwe 102 Botswana 189 2 1 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.847170 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36734
36184 2012 1624 2012-09-09   Zimbabwe 102 Angola 205 3 1 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.579889 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36184
36044 2012 1623 2012-07-17   Zimbabwe 102 Lesotho 191 5 3 H Friendly   Molepolole Molepolole Botswana     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.512063 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36044
36006 2012 1624 2012-06-17   Zimbabwe 102 Burundi 139 1 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.493576 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36006
35884 2012 1627 2012-06-03   Zimbabwe 102 Guinea 172 0 1 A FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.380284 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35884
35517 2011 1620 2011-11-27   Zimbabwe 102 Djibouti 111 2 0 H CECAFA Cup   Dar es Salaam Dar es Salaam Tanzania     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.201845 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35517
35501 2011 1599 2011-11-15   Zimbabwe 102 South Africa 21 2 1 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.194081 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35501
35168 2011 1608 2011-09-04   Zimbabwe 102 Liberia 169 3 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.032081 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35168
35044 2011 1599 2011-08-10   Zimbabwe 102 Zambia 103 2 0 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.971429 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35044
34793 2011 1608 2011-06-05   Zimbabwe 102 Mali 162 2 1 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.795488 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34793
34219 2010 1586 2010-10-10   Zimbabwe 102 Cape Verde 157 0 0 D African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.515558 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34219
33835 2010 1575 2010-06-02   Zimbabwe 102 Brazil 34 0 3 A Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.243217 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33835
33730 2010 1575 2010-03-03   Zimbabwe 102 Malawi 154 2 1 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.191710 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33730
33452 2009 1572 2009-11-01   Zimbabwe 102 Zambia 103 3 1 H COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.056695 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33452
33445 2009 1572 2009-10-28   Zimbabwe 102 South Africa 21 1 1 D COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.053258 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33445
33442 2009 1572 2009-10-26   Zimbabwe 102 Botswana 189 1 0 H COSAFA Cup   Bulawayo Bulawayo Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.051803 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33442
33430 2009 1572 2009-10-19   Zimbabwe 102 Lesotho 191 2 2 D COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.045977 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33430
33427 2009 1572 2009-10-17   Zimbabwe 102 Mauritius 108 3 0 H COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.044520 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33427
33218 2009 1557 2009-08-12   Zimbabwe 102 Lesotho 191 1 1 D Friendly   Bulawayo Bulawayo Zimbabwe     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.942554 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33218
32341 2008 1532 2008-09-07   Zimbabwe 102 Guinea 172 0 0 D FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.451427 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32341
32257 2008 1529 2008-08-20   Zimbabwe 102 Botswana 189 1 0 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.409057 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32257
32129 2008 1532 2008-06-22   Zimbabwe 102 Kenya 68 0 0 D FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.346415 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32129
31999 2008 1532 2008-06-08   Zimbabwe 102 Namibia 231 2 0 H FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.229566 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31999
31260 2007 1511 2007-09-09   Zimbabwe 102 Malawi 154 3 1 H African Cup of Nations qualification   Bulawayo Bulawayo Zimbabwe     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.831711 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31260
31187 2007 1522 2007-08-27   Zimbabwe 102 Myanmar 125 1 3 A Merdeka Tournament   Petaling Jaya Petaling Jaya Malaysia     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.795616 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31187
31179 2007 1522 2007-08-25   Zimbabwe 102 Bangladesh 200 2 1 H Merdeka Tournament   Petaling Jaya Petaling Jaya Malaysia     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.791720 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31179
30835 2007 1502 2007-05-29   Zimbabwe 102 Burkina Faso 159 1 1 D Friendly   Masvingo Masvingo Zimbabwe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.573575 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30835
30820 2007 1502 2007-05-25   Zimbabwe 102 Lesotho 191 1 1 D Friendly   Masvingo Masvingo Zimbabwe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.566247 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30820
30764 2007 1511 2007-03-25   Zimbabwe 102 Morocco 155 1 1 D African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.538789 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30764
30483 2006 1479 2006-11-15   Zimbabwe 102 Namibia 231 3 2 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.401860 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30483
30298 2006 1487 2006-09-17   Zimbabwe 102 Angola 205 1 2 A COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.311944 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30298
29757 2006 1480 2006-01-23   Zimbabwe 102 Senegal 166 0 2 A African Cup of Nations   Port Said Port Said Egypt     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:00.995176 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29757
29477 2005 1462 2005-09-04   Zimbabwe 102 Rwanda 207 3 1 H FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.858815 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29477
29429 2005 1459 2005-08-28   Zimbabwe 102 Mozambique 203 0 0 D Friendly   Mutare Mutare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.835496 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29429
29232 2005 1462 2005-06-05   Zimbabwe 102 Gabon 160 1 0 H FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.739829 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29232
29108 2005 1462 2005-03-27   Zimbabwe 102 Angola 205 2 0 H FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.679353 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29108
29052 2005 1459 2005-03-16   Zimbabwe 102 Botswana 189 1 1 D Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.652034 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29052
28744 2004 1439 2004-10-24   Zimbabwe 102 Zambia 103 0 0 D COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.419369 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28744
28578 2004 1443 2004-09-05   Zimbabwe 102 Nigeria 120 0 3 A FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.338762 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28578
28519 2004 1438 2004-08-22   Zimbabwe 102 Uganda 69 2 0 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.310149 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28519
28513 2004 1438 2004-08-18   Zimbabwe 102 Botswana 189 2 0 H Friendly   Bulawayo Bulawayo Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.307244 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28513
28357 2004 1443 2004-06-20   Zimbabwe 102 Algeria 173 1 1 D FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.231534 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28357
28151 2004 1438 2004-05-16   Zimbabwe 102 Zambia 103 0 0 D Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.131638 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28151
27885 2004 1441 2004-01-25   Zimbabwe 102 Egypt 42 1 2 A African Cup of Nations   Sfax Sfax Tunisia     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.950683 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27885
27661 2003 1432 2003-10-12   Zimbabwe 102 Mauritania 168 3 0 H FIFA World Cup qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.841920 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27661
27594 2003 1418 2003-10-05   Zimbabwe 102 Malawi 154 2 0 H COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.809392 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27594
27493 2003 1418 2003-08-31   Zimbabwe 102 Eswatini 188 2 0 H COSAFA Cup   Bulawayo Bulawayo Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.760236 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27493
27390 2003 1423 2003-07-05   Zimbabwe 102 Eritrea 243 2 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.710169 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27390
27141 2003 1418 2003-04-20   Zimbabwe 102 Angola 205 1 0 H COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.589042 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27141
27116 2003 1423 2003-03-30   Zimbabwe 102 Seychelles 201 3 1 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.576806 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27116
27025 2003 1411 2003-03-16   Zimbabwe 102 Malawi 154 0 0 D Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.532466 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27025
26676 2002 1386 2002-09-28   Zimbabwe 102 Zambia 103 0 0 D Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.308918 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26676
26666 2002 1405 2002-09-08   Zimbabwe 102 Mali 162 1 0 H African Cup of Nations qualification   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.304076 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26666
26608 2002 1386 2002-08-30   Zimbabwe 102 Lesotho 191 2 0 H Friendly   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.275734 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26608
26378 2002 1396 2002-05-05   Zimbabwe 102 Eswatini 188 0 2 A COSAFA Cup   Harare Harare Zimbabwe     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.163606 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26378

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.669ms