home / football

match

222 rows where home_team_id = 113 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home_score, away_score, result, round_stage, is_neutral, 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
49408 2026 1937 2026-06-27   DR Congo 113 Uzbekistan 242       FIFA World Cup   Atlanta Atlanta United States     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.891269 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49408
49298 2026 1929 2026-06-03   DR Congo 113 Denmark 25 0 0 D Friendly   Liège Liège Belgium     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.835666 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49298
49249 2026 1931 2026-03-31   DR Congo 113 Jamaica 67 1 0 H FIFA World Cup qualification   Zapopan Zapopan Mexico     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.810820 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49249
49063 2025 1927 2025-12-23   DR Congo 113 Benin 156 1 0 H African Cup of Nations   Rabat Rabat Morocco     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.716576 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:49063
48822 2025 1907 2025-10-14   DR Congo 113 Sudan 150 1 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.544183 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48822
48654 2025 1907 2025-09-09   DR Congo 113 Senegal 166 2 3 A FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.462596 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48654
48392 2025 1906 2025-06-08   DR Congo 113 Madagascar 107 3 1 H Friendly   Orléans Orléans France     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.334563 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48392
48323 2025 1906 2025-06-05   DR Congo 113 Mali 162 1 0 H Friendly   Orléans Orléans France     1 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.301083 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48323
48175 2025 1907 2025-03-21   DR Congo 113 South Sudan 295 1 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.228809 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48175
48033 2024 1880 2024-11-19   DR Congo 113 Ethiopia 112 1 2 A African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:02 2026-06-07 21:04:11.159639 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:48033
47678 2024 1880 2024-10-10   DR Congo 113 Tanzania 101 1 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.943313 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47678
47532 2024 1880 2024-09-06   DR Congo 113 Guinea 172 1 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.872020 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47532
47299 2024 1886 2024-06-09   DR Congo 113 Togo 148 1 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.731151 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:47299
46994 2024 1879 2024-02-02   DR Congo 113 Guinea 172 3 1 H African Cup of Nations   Ebimpé Ebimpé Ivory Coast     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.529394 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46994
46926 2024 1879 2024-01-17   DR Congo 113 Zambia 103 1 1 D African Cup of Nations   San-Pédro San-Pédro Ivory Coast     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.496222 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46926
46893 2024 1877 2024-01-10   DR Congo 113 Burkina Faso 159 1 2 A Friendly   Abu Dhabi Abu Dhabi United Arab Emirates     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.480105 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46893
46870 2024 1877 2024-01-06   DR Congo 113 Angola 205 0 0 D Friendly   Dubai Dubai United Arab Emirates     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.468971 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46870
46651 2023 1872 2023-11-15   DR Congo 113 Mauritania 168 2 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.362243 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46651
46524 2023 1856 2023-10-13   DR Congo 113 New Zealand 52 1 1 D Friendly   Murcia Murcia Spain     1 0 0 2026-06-07 06:59:01 2026-06-07 21:04:10.300657 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46524
46387 2023 1858 2023-09-09   DR Congo 113 Sudan 150 2 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.233976 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46387
46045 2023 1856 2023-06-14   DR Congo 113 Uganda 69 1 0 H Friendly   Douala Douala Cameroon     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:10.067742 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:46045
45900 2023 1858 2023-03-24   DR Congo 113 Mauritania 168 3 1 H African Cup of Nations qualification   Douala Douala Cameroon     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.952912 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45900
45582 2022 1832 2022-09-27   DR Congo 113 Sierra Leone 119 3 0 H Friendly   Casablanca Casablanca Morocco     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.798536 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45582
45507 2022 1832 2022-09-23   DR Congo 113 Burkina Faso 159 0 1 A Friendly   Casablanca Casablanca Morocco     1 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.762111 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45507
45212 2022 1835 2022-06-04   DR Congo 113 Gabon 160 0 1 A African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.618440 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45212
45006 2022 1834 2022-03-25   DR Congo 113 Morocco 155 1 1 D FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:59:00 2026-06-07 21:04:09.517889 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:45006
44705 2021 1813 2021-11-14   DR Congo 113 Benin 156 2 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.288646 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44705
44490 2021 1813 2021-10-07   DR Congo 113 Madagascar 107 2 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.183823 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44490
44319 2021 1813 2021-09-02   DR Congo 113 Tanzania 101 1 1 D FIFA World Cup qualification   Lubumbashi Lubumbashi DR Congo     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:09.100829 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44319
44092 2021 1812 2021-06-11   DR Congo 113 Mali 162 1 1 D Friendly   Radès Radès Tunisia     1 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.990060 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:44092
43864 2021 1814 2021-03-29   DR Congo 113 Gambia 133 1 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.825195 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43864
43633 2020 1811 2020-11-14   DR Congo 113 Angola 205 0 0 D African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:59 2026-06-07 21:04:08.712715 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43633
43182 2019 1787 2019-11-14   DR Congo 113 Gabon 160 0 0 D African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.493100 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:43182
42990 2019 1782 2019-09-18   DR Congo 113 Rwanda 207 2 3 A Friendly   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.345526 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42990
42660 2019 1797 2019-06-22   DR Congo 113 Uganda 69 0 2 A African Cup of Nations   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.176820 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42660
42545 2019 1782 2019-06-09   DR Congo 113 Burkina Faso 159 0 0 D Friendly   Marbella Marbella Spain     1 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.118191 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42545
42390 2019 1787 2019-03-24   DR Congo 113 Liberia 169 1 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:08.039099 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:42390
41952 2018 1778 2018-10-13   DR Congo 113 Zimbabwe 102 1 2 A African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:58 2026-06-07 21:04:07.738627 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41952
41159 2017 1747 2017-11-11   DR Congo 113 Guinea 172 3 1 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.335208 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:41159
40978 2017 1747 2017-09-05   DR Congo 113 Tunisia 152 2 2 D FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.190701 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40978
40680 2017 1746 2017-06-10   DR Congo 113 Congo Republic 161 3 1 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.039541 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40680
40615 2017 1743 2017-06-05   DR Congo 113 Botswana 189 2 0 H Friendly   Salé Salé Morocco     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:07.006270 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40615
40432 2017 1745 2017-01-29   DR Congo 113 Ghana 124 1 2 A African Cup of Nations   Oyem Oyem Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.916297 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40432
40400 2017 1745 2017-01-16   DR Congo 113 Morocco 155 1 0 H African Cup of Nations   Oyem Oyem Gabon     1 0 0 2026-06-07 06:58:57 2026-06-07 21:04:06.900802 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40400
40142 2016 1724 2016-10-08   DR Congo 113 Libya 153 4 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.775298 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40142
40094 2016 1719 2016-10-04   DR Congo 113 Kenya 68 0 1 A Friendly   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.751911 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40094
40028 2016 1723 2016-09-04   DR Congo 113 Central African Republic 163 4 1 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.719813 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:40028
39908 2016 1734 2016-06-19   DR Congo 113 Mozambique 203 1 0 H COSAFA Cup   Windhoek Windhoek Namibia     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.606365 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39908
39561 2016 1723 2016-03-26   DR Congo 113 Angola 205 2 1 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.409101 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39561
39350 2015 1700 2015-11-15   DR Congo 113 Burundi 139 3 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.306366 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39350
39274 2015 1696 2015-11-06   DR Congo 113 Zambia 103 3 0 H Friendly   Luanda Luanda Angola     1 0 0 2026-06-07 06:58:56 2026-06-07 21:04:06.269356 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:39274
38809 2015 1709 2015-06-14   DR Congo 113 Madagascar 107 2 1 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:56 2026-06-07 21:04:05.989449 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38809
38733 2015 1696 2015-06-09   DR Congo 113 Cameroon 140 1 1 D Friendly   Mons Mons Belgium     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.952520 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38733
38501 2015 1698 2015-02-04   DR Congo 113 Ivory Coast 158 1 3 A African Cup of Nations   Bata Bata Equatorial Guinea     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.839468 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38501
38482 2015 1698 2015-01-26   DR Congo 113 Tunisia 152 1 1 D African Cup of Nations   Bata Bata Equatorial Guinea     1 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.830273 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38482
38362 2014 1678 2014-11-19   DR Congo 113 Sierra Leone 119 3 1 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.771996 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38362
38148 2014 1678 2014-10-11   DR Congo 113 Ivory Coast 158 1 2 A African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.668057 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38148
38087 2014 1678 2014-09-10   DR Congo 113 Sierra Leone 119 2 0 H African Cup of Nations qualification   Lubumbashi Lubumbashi DR Congo     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.638413 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38087
38020 2014 1678 2014-09-06   DR Congo 113 Cameroon 140 0 2 A African Cup of Nations qualification   Lubumbashi Lubumbashi DR Congo     0 0 0 2026-06-07 06:58:55 2026-06-07 21:04:05.605925 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:38020
37031 2013 1655 2013-06-16   DR Congo 113 Cameroon 140 0 0 D FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:05.073531 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:37031
36833 2013 1655 2013-03-24   DR Congo 113 Libya 153 0 0 D FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.895323 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36833
36669 2013 1653 2013-01-28   DR Congo 113 Mali 162 1 1 D African Cup of Nations   Durban Durban South Africa     1 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.815506 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36669
36433 2012 1623 2012-11-14   DR Congo 113 Burkina Faso 159 0 1 A Friendly   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.700712 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36433
36188 2012 1624 2012-09-09   DR Congo 113 Equatorial Guinea 202 4 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.581820 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36188
36008 2012 1624 2012-06-17   DR Congo 113 Seychelles 201 3 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.494565 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:36008
35950 2012 1627 2012-06-10   DR Congo 113 Togo 148 2 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:54 2026-06-07 21:04:04.412859 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35950
35455 2011 1613 2011-11-15   DR Congo 113 Eswatini 188 5 1 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.171662 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35455
35263 2011 1608 2011-10-07   DR Congo 113 Cameroon 140 2 3 A African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:04.078368 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:35263
34650 2011 1608 2011-03-27   DR Congo 113 Mauritius 108 3 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.725729 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34650
34537 2011 1599 2011-02-09   DR Congo 113 Gabon 160 0 2 A Friendly   Rouen Rouen France     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.670690 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34537
34494 2011 1600 2011-01-17   DR Congo 113 Kenya 68 1 0 H Nile Basin Tournament   Ismailia Ismailia Egypt     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.649731 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34494
34481 2011 1600 2011-01-14   DR Congo 113 Uganda 69 0 1 A Nile Basin Tournament   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.643426 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34481
34470 2011 1600 2011-01-11   DR Congo 113 Sudan 150 2 1 H Nile Basin Tournament   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.638066 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34470
34462 2011 1600 2011-01-08   DR Congo 113 Kenya 68 1 0 H Nile Basin Tournament   Cairo Cairo Egypt     1 0 0 2026-06-07 06:58:53 2026-06-07 21:04:03.634182 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34462
34053 2010 1586 2010-09-05   DR Congo 113 Senegal 166 2 4 A African Cup of Nations qualification   Lubumbashi Lubumbashi DR Congo     0 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.434390 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:34053
33766 2010 1575 2010-05-21   DR Congo 113 Saudi Arabia 179 0 2 A Friendly   Schwaz Schwaz Austria     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:03.209258 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33766
33179 2009 1557 2009-08-12   DR Congo 113 Senegal 166 1 2 A Friendly   Blois Blois France     1 0 0 2026-06-07 06:58:52 2026-06-07 21:04:02.923569 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:33179
32336 2008 1532 2008-09-07   DR Congo 113 Egypt 42 0 1 A FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.448894 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32336
32216 2008 1529 2008-08-20   DR Congo 113 Togo 148 2 1 H Friendly   Dreux Dreux France     1 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.388966 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32216
32108 2008 1532 2008-06-22   DR Congo 113 Djibouti 111 5 1 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.336150 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:32108
31986 2008 1532 2008-06-08   DR Congo 113 Malawi 154 1 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:02.223185 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31986
31214 2007 1511 2007-09-08   DR Congo 113 Libya 153 1 1 D African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.808717 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31214
31139 2007 1502 2007-08-22   DR Congo 113 Angola 205 3 1 H Friendly   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:51 2026-06-07 21:04:01.772194 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:31139
30806 2007 1511 2007-04-29   DR Congo 113 Ethiopia 112 2 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.559383 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30806
30234 2006 1494 2006-09-03   DR Congo 113 Namibia 231 3 2 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:01.280676 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:30234
29704 2005 1459 2005-12-11   DR Congo 113 Zambia 103 1 1 D Friendly   Lubumbashi Lubumbashi DR Congo     0 0 0 2026-06-07 06:58:50 2026-06-07 21:04:00.969258 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29704
29613 2005 1459 2005-11-11   DR Congo 113 Tunisia 152 2 2 D Friendly   Paris Paris France     1 0 0 2026-06-07 06:58:50 2026-06-07 21:04:00.924980 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29613
29512 2005 1459 2005-09-27   DR Congo 113 Zambia 103 0 0 D Friendly   Lubumbashi Lubumbashi DR Congo     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.875752 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29512
29470 2005 1462 2005-09-04   DR Congo 113 Cape Verde 157 2 1 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.855431 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29470
29383 2005 1459 2005-08-16   DR Congo 113 Guinea 172 3 1 H Friendly   Colombes Colombes France     1 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.813093 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29383
29225 2005 1462 2005-06-05   DR Congo 113 Uganda 69 4 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.736426 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29225
29102 2005 1462 2005-03-27   DR Congo 113 Ghana 124 1 1 D FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.676420 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:29102
28568 2004 1443 2004-09-05   DR Congo 113 South Africa 21 1 0 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.333922 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28568
28481 2004 1438 2004-08-18   DR Congo 113 Mali 162 0 3 A Friendly   Colombes Colombes France     1 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.291707 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28481
28344 2004 1443 2004-06-20   DR Congo 113 Burkina Faso 159 3 2 H FIFA World Cup qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.225221 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28344
28167 2004 1438 2004-05-23   DR Congo 113 Angola 205 1 3 A Friendly   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:49 2026-06-07 21:04:00.139366 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:28167
27883 2004 1441 2004-01-25   DR Congo 113 Guinea 172 1 2 A African Cup of Nations   Tunis Tunis Tunisia     1 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.949712 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27883
27309 2003 1423 2003-06-22   DR Congo 113 Libya 153 2 1 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.670870 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27309
27251 2003 1423 2003-06-08   DR Congo 113 Eswatini 188 2 0 H African Cup of Nations qualification   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.642616 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27251
27014 2003 1411 2003-03-09   DR Congo 113 Congo Republic 161 3 0 H Friendly   Kinshasa Kinshasa DR Congo     0 0 0 2026-06-07 06:58:48 2026-06-07 21:03:59.527104 1 1 6 6 International Results CSV 1 csv:///home/nabaz/Projects/world-cup-2026-predictor/data/raw/international_results.csv:27014

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