home / football

match

132 rows where home_team_id = 188 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
48688 2025 1907 2025-10-08   Eswatini 188 Angola 205 2 2 D FIFA World Cup qualification   Lobamba Lobamba Eswatini     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.479078 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48688
48214 2025 1907 2025-03-23   Eswatini 188 Mauritius 108 3 3 D FIFA World Cup qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.247940 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48214
48115 2025 1907 2025-03-19   Eswatini 188 Cameroon 140 0 0 D FIFA World Cup qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.199491 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48115
47929 2024 1880 2024-11-15   Eswatini 188 Guinea-Bissau 137 1 1 D African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:11.065595 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47929
47782 2024 1880 2024-10-14   Eswatini 188 Mozambique 203 0 3 A African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.994106 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47782
47633 2024 1880 2024-09-10   Eswatini 188 Mali 162 0 1 A African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.921376 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47633
47169 2024 1880 2024-03-26   Eswatini 188 Somalia 178 2 2 D African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.668021 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47169
46821 2023 1872 2023-11-21   Eswatini 188 Cape Verde 157 0 2 A FIFA World Cup qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.445116 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46821
46710 2023 1872 2023-11-17   Eswatini 188 Libya 153 0 1 A FIFA World Cup qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.390892 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46710
46231 2023 1868 2023-07-05   Eswatini 188 Botswana 189 0 1 A COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.158092 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46231
46133 2023 1858 2023-06-18   Eswatini 188 Togo 148 0 2 A African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.110360 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46133
46004 2023 1858 2023-03-28   Eswatini 188 Cape Verde 157 0 1 A African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.047868 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46004
45454 2022 1845 2022-07-10   Eswatini 188 Lesotho 191 2 0 H COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.736142 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45454
45268 2022 1835 2022-06-07   Eswatini 188 Burkina Faso 159 1 3 A African Cup of Nations qualification   Johannesburg Johannesburg South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.645828 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45268
45059 2022 1835 2022-03-27   Eswatini 188 Somalia 178 2 1 H African Cup of Nations qualification   Mbombela Mbombela South Africa     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.543805 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45059
44266 2021 1822 2021-07-18   Eswatini 188 Mozambique 203 1 1 D COSAFA Cup   Port Elizabeth Port Elizabeth South Africa     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.075143 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44266
44253 2021 1822 2021-07-14   Eswatini 188 Botswana 189 1 1 D COSAFA Cup   Port Elizabeth Port Elizabeth South Africa     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.068861 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44253
44224 2021 1822 2021-07-06   Eswatini 188 Lesotho 191 3 1 H COSAFA Cup   Port Elizabeth Port Elizabeth South Africa     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.054783 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44224
43804 2021 1814 2021-03-26   Eswatini 188 Guinea-Bissau 137 1 3 A African Cup of Nations qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.795979 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43804
43671 2020 1811 2020-11-16   Eswatini 188 Congo Republic 161 0 0 D African Cup of Nations qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.731512 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43671
43268 2019 1787 2019-11-17   Eswatini 188 Senegal 166 1 4 A African Cup of Nations qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.535035 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43268
42987 2019 1793 2019-09-10   Eswatini 188 Djibouti 111 0 0 D FIFA World Cup qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.343992 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42987
42436 2019 1789 2019-05-27   Eswatini 188 Comoros 213 2 2 D COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.062580 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42436
42431 2019 1789 2019-05-25   Eswatini 188 Mauritius 108 2 2 D COSAFA Cup   Durban Durban South Africa     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.060045 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42431
42141 2018 1778 2018-11-18   Eswatini 188 Niger 171 1 2 A African Cup of Nations qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.915919 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42141
42017 2018 1778 2018-10-16   Eswatini 188 Egypt 42 0 2 A African Cup of Nations qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.855516 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42017
41824 2018 1778 2018-09-09   Eswatini 188 Tunisia 152 0 2 A African Cup of Nations qualification   Manzini Manzini Eswatini     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.673319 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41824
41580 2018 1768 2018-06-05   Eswatini 188 Botswana 189 0 2 A COSAFA Cup   Polokwane Polokwane South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.549488 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41580
40829 2017 1755 2017-07-02   Eswatini 188 Zimbabwe 102 1 2 A COSAFA Cup   Rustenburg Rustenburg South Africa     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.115362 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40829
39933 2016 1734 2016-06-25   Eswatini 188 DR Congo 113 1 0 H COSAFA Cup   Windhoek Windhoek Namibia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.618678 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39933
39889 2016 1734 2016-06-15   Eswatini 188 Madagascar 107 1 0 H COSAFA Cup   Windhoek Windhoek Namibia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.596958 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39889
39878 2016 1734 2016-06-13   Eswatini 188 Seychelles 201 4 0 H COSAFA Cup   Windhoek Windhoek Namibia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.591570 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39878
39815 2016 1723 2016-06-05   Eswatini 188 Guinea 172 1 0 H African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.560801 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39815
39548 2016 1723 2016-03-25   Eswatini 188 Zimbabwe 102 1 1 D African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.402784 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39548
39334 2015 1700 2015-11-13   Eswatini 188 Nigeria 120 0 0 D FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.298603 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39334
39270 2015 1700 2015-10-17   Eswatini 188 Djibouti 111 2 1 H FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.267414 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39270
39077 2015 1709 2015-09-06   Eswatini 188 Malawi 154 2 2 D African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.173673 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39077
38539 2015 1696 2015-03-25   Eswatini 188 South Africa 21 1 3 A Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.857916 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38539
38326 2014 1675 2014-11-16   Eswatini 188 Tanzania 101 1 1 D Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.754579 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38326
38229 2014 1675 2014-10-15   Eswatini 188 Zimbabwe 102 0 2 A Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.707484 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38229
37684 2014 1678 2014-05-18   Eswatini 188 Sierra Leone 119 1 1 D African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.392483 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37684
37453 2013 1650 2013-11-15   Eswatini 188 South Africa 21 0 3 A Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.279488 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37453
36629 2013 1650 2013-01-17   Eswatini 188 Burkina Faso 159 0 3 A Friendly   Nelspruit Nelspruit South Africa     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.795974 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36629
36421 2012 1623 2012-11-11   Eswatini 188 Lesotho 191 0 0 D Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.694819 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36421
35426 2011 1613 2011-11-11   Eswatini 188 DR Congo 113 1 3 A FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.157578 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35426
35308 2011 1608 2011-10-08   Eswatini 188 Congo Republic 161 0 1 A African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.100260 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35308
34988 2011 1599 2011-07-31   Eswatini 188 Botswana 189 0 2 A Friendly   Pretoria Pretoria South Africa     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.890793 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34988
34791 2011 1608 2011-06-05   Eswatini 188 Sudan 150 1 2 A African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.794511 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34791
34731 2011 1599 2011-05-29   Eswatini 188 Malawi 154 1 1 D Friendly   Mhlume Mhlume Swaziland     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.765279 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34731
34716 2011 1599 2011-05-25   Eswatini 188 Botswana 189 0 0 D Friendly   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.757916 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34716
34568 2011 1599 2011-02-09   Eswatini 188 Zambia 103 0 4 A Friendly   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.685735 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34568
34060 2010 1586 2010-09-05   Eswatini 188 Ghana 124 0 3 A African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.437811 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34060
33437 2009 1572 2009-10-22   Eswatini 188 Comoros 213 3 0 H COSAFA Cup   Bulawayo Bulawayo Zimbabwe     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.049388 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33437
33429 2009 1572 2009-10-18   Eswatini 188 Seychelles 201 2 1 H COSAFA Cup   Bulawayo Bulawayo Zimbabwe     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.045496 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33429
33073 2009 1557 2009-06-21   Eswatini 188 Lesotho 191 1 1 D Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.872021 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33073
33062 2009 1557 2009-06-19   Eswatini 188 Lesotho 191 1 1 D Friendly   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.866673 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33062
32065 2008 1532 2008-06-15   Eswatini 188 Zambia 103 0 0 D FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.315203 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32065
31997 2008 1532 2008-06-08   Eswatini 188 Togo 148 2 1 H FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.228584 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31997
31836 2008 1529 2008-05-23   Eswatini 188 Lesotho 191 1 1 D Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.121818 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31836
31696 2008 1529 2008-02-10   Eswatini 188 Lesotho 191 2 2 D Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.052012 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31696
31693 2008 1529 2008-02-09   Eswatini 188 Botswana 189 1 4 A Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.050495 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31693
31469 2007 1502 2007-11-18   Eswatini 188 Malawi 154 0 3 A Friendly   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.936973 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31469
31258 2007 1511 2007-09-09   Eswatini 188 Eritrea 243 0 0 D African Cup of Nations qualification   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.830709 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31258
30894 2007 1511 2007-06-03   Eswatini 188 Kenya 68 0 0 D African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.603307 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30894
30832 2007 1513 2007-05-27   Eswatini 188 Malawi 154 1 0 H COSAFA Cup   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.572104 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30832
30825 2007 1513 2007-05-26   Eswatini 188 Mauritius 108 0 0 D COSAFA Cup   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.568694 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30825
30701 2007 1502 2007-03-18   Eswatini 188 Lesotho 191 0 1 A Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.507794 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30701
30244 2006 1494 2006-09-03   Eswatini 188 Angola 205 0 2 A African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.285606 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30244
30187 2006 1479 2006-08-26   Eswatini 188 Lesotho 191 3 1 H Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.257850 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30187
30092 2006 1479 2006-06-25   Eswatini 188 Zimbabwe 102 1 2 A Friendly   Maputo Maputo Mozambique     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.211969 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30092
28377 2004 1439 2004-06-27   Eswatini 188 Zimbabwe 102 0 5 A COSAFA Cup   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.241305 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28377
27660 2003 1432 2003-10-12   Eswatini 188 Cape Verde 157 1 1 D FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.841437 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27660
27524 2003 1411 2003-09-06   Eswatini 188 Botswana 189 0 3 A Friendly   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.775266 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27524
27421 2003 1418 2003-07-13   Eswatini 188 Madagascar 107 2 0 H COSAFA Cup   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.725151 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27421
27319 2003 1423 2003-06-22   Eswatini 188 Botswana 189 3 2 H African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.675724 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27319
27113 2003 1423 2003-03-30   Eswatini 188 DR Congo 113 1 1 D African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.575344 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27113
27029 2003 1411 2003-03-19   Eswatini 188 Lesotho 191 1 0 H Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.534414 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27029
26726 2002 1405 2002-10-13   Eswatini 188 Libya 153 2 1 H African Cup of Nations qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.333337 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26726
26681 2002 1386 2002-10-06   Eswatini 188 Lesotho 191 0 0 D Friendly   Big Bend Big Bend Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.311350 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26681
26556 2002 1386 2002-08-03   Eswatini 188 Mauritius 108 0 0 D Friendly   Big Bend Big Bend Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.250394 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26556
26553 2002 1386 2002-08-01   Eswatini 188 Mauritius 108 0 1 A Friendly   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.248932 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26553
26372 2002 1396 2002-04-21   Eswatini 188 Namibia 231 2 1 H COSAFA Cup   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.160660 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26372
26336 2002 1386 2002-03-31   Eswatini 188 Mozambique 203 1 1 D Friendly   Big Bend Big Bend Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.142563 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26336
26335 2002 1386 2002-03-30   Eswatini 188 Mozambique 203 1 2 A Friendly   Mhlume Mhlume Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.142000 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26335
26283 2002 1386 2002-03-10   Eswatini 188 Lesotho 191 1 0 H Friendly   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:59.115740 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:26283
25201 2001 1369 2001-02-11   Eswatini 188 Zambia 103 0 0 D COSAFA Cup   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.505446 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25201
25110 2001 1359 2001-01-09   Eswatini 188 Lesotho 191 2 2 D Friendly   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.461094 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25110
25107 2001 1359 2001-01-07   Eswatini 188 Namibia 231 2 1 H Friendly   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.459648 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25107
25105 2001 1359 2001-01-06   Eswatini 188 Angola 205 1 0 H Friendly   Manzini Manzini Swaziland     0 0 0 2026-06-07 06:58:47 2026-06-07 21:03:58.458676 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:25105
24711 2000 1353 2000-07-02   Eswatini 188 Kenya 68 3 2 H African Cup of Nations qualification   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:58.211064 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24711
24588 2000 1331 2000-06-04   Eswatini 188 Mozambique 203 1 1 D Friendly   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:58.149083 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24588
24558 2000 1331 2000-06-02   Eswatini 188 Botswana 189 0 0 D Friendly   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:58.133898 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24558
24552 2000 1331 2000-06-01   Eswatini 188 Lesotho 191 0 1 A Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:58.130858 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24552
24388 2000 1340 2000-04-09   Eswatini 188 Angola 205 0 1 A FIFA World Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:58.047945 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:24388
23737 1999 1321 1999-07-18   Eswatini 188 Zimbabwe 102 1 1 D COSAFA Cup   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:57.645738 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23737
23530 1999 1303 1999-05-16   Eswatini 188 Botswana 189 2 1 H Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:57.545015 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23530
23528 1999 1307 1999-05-09   Eswatini 188 Mozambique 203 3 1 H COSAFA Cup qualification   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:57.544045 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23528
23490 1999 1303 1999-04-25   Eswatini 188 Lesotho 191 4 1 H Friendly   Lobamba Lobamba Swaziland     0 0 0 2026-06-07 06:58:46 2026-06-07 21:03:57.525517 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23490
23464 1999 1303 1999-04-03   Eswatini 188 Namibia 231 1 1 D Friendly   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.512846 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23464
23050 1998 1272 1998-09-06   Eswatini 188 Ghana 124 0 1 A Friendly   Mbabane Mbabane Swaziland     0 0 0 2026-06-07 06:58:45 2026-06-07 21:03:57.311203 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:23050

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