h2h_record
263 rows where team_a_id = 158
This data as json, CSV (advanced)
Suggested facets: team_b_id, wins_a, wins_b, draws, goals_b, last_result, date (date), last_match_date (date), created_at (date), updated_at (date)
| h2h_id ▼ | team_a_id | team_b_id | date | total_matches | wins_a | wins_b | draws | goals_a | goals_b | last_match_date | last_result | last_match_id | competition_id | created_at | updated_at | created_by_run_id | updated_by_run_id | source_id | source_raw_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5027 | Ivory Coast 158 | Congo Republic 161 | 1960-04-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.881341 | 2026-06-07 07:03:18.881341 | 1 | International Results CSV 1 | h2h://161:158/1960-04-15 | |||||
| 5422 | Ivory Coast 158 | Burkina Faso 159 | 1961-12-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.956837 | 2026-06-07 07:03:18.956837 | 1 | International Results CSV 1 | h2h://158:159/1961-12-25 | |||||
| 5426 | Ivory Coast 158 | Liberia 169 | 1961-12-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.957586 | 2026-06-07 07:03:18.957587 | 1 | International Results CSV 1 | h2h://158:169/1961-12-26 | |||||
| 5430 | Ivory Coast 158 | Central African Republic 163 | 1961-12-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.958330 | 2026-06-07 07:03:18.958330 | 1 | International Results CSV 1 | h2h://158:163/1961-12-27 | |||||
| 5432 | Ivory Coast 158 | Senegal 166 | 1961-12-29 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.958699 | 2026-06-07 07:03:18.958699 | 1 | International Results CSV 1 | h2h://158:166/1961-12-29 | |||||
| 5441 | Ivory Coast 158 | Mali 162 | 1962-02-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.960392 | 2026-06-07 07:03:18.960392 | 1 | International Results CSV 1 | h2h://162:158/1962-02-04 | |||||
| 5442 | Ivory Coast 158 | Mali 162 | 1962-02-06 | 1 | 0 | 1 | 0 | 0 | 4 | 1962-02-04 | W | 2026-06-07 07:03:18.960578 | 2026-06-07 07:03:18.960578 | 1 | International Results CSV 1 | h2h://162:158/1962-02-06 | |||
| 5663 | Ivory Coast 158 | Senegal 166 | 1962-11-30 | 1 | 0 | 0 | 1 | 1 | 1 | 1961-12-29 | D | 2026-06-07 07:03:19.003662 | 2026-06-07 07:03:19.003662 | 1 | International Results CSV 1 | h2h://166:158/1962-11-30 | |||
| 5786 | Ivory Coast 158 | Congo Republic 161 | 1963-04-12 | 1 | 0 | 1 | 0 | 2 | 3 | 1960-04-15 | W | 2026-06-07 07:03:19.027177 | 2026-06-07 07:03:19.027177 | 1 | International Results CSV 1 | h2h://161:158/1963-04-12 | |||
| 5797 | Ivory Coast 158 | Mauritania 168 | 1963-04-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.029235 | 2026-06-07 07:03:19.029235 | 1 | International Results CSV 1 | h2h://158:168/1963-04-14 | |||||
| 6015 | Ivory Coast 158 | Mali 162 | 1964-03-15 | 2 | 1 | 1 | 0 | 2 | 4 | 1962-02-06 | W | 2026-06-07 07:03:19.070714 | 2026-06-07 07:03:19.070714 | 1 | International Results CSV 1 | h2h://158:162/1964-03-15 | |||
| 6315 | Ivory Coast 158 | Liberia 169 | 1965-05-29 | 1 | 1 | 0 | 0 | 5 | 0 | 1961-12-26 | L | 2026-06-07 07:03:19.127844 | 2026-06-07 07:03:19.127844 | 1 | International Results CSV 1 | h2h://169:158/1965-05-29 | |||
| 6347 | Ivory Coast 158 | Algeria 173 | 1965-07-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.133930 | 2026-06-07 07:03:19.133931 | 1 | International Results CSV 1 | h2h://158:173/1965-07-19 | |||||
| 6362 | Ivory Coast 158 | Congo Republic 161 | 1965-07-23 | 2 | 0 | 2 | 0 | 4 | 6 | 1963-04-12 | W | 2026-06-07 07:03:19.136727 | 2026-06-07 07:03:19.136728 | 1 | International Results CSV 1 | h2h://161:158/1965-07-23 | |||
| 6367 | Ivory Coast 158 | Algeria 173 | 1965-07-25 | 1 | 1 | 0 | 0 | 1 | 0 | 1965-07-19 | W | 2026-06-07 07:03:19.137671 | 2026-06-07 07:03:19.137671 | 1 | International Results CSV 1 | h2h://158:173/1965-07-25 | |||
| 6446 | Ivory Coast 158 | Liberia 169 | 1965-09-21 | 2 | 2 | 0 | 0 | 6 | 0 | 1965-05-29 | W | 2026-06-07 07:03:19.152589 | 2026-06-07 07:03:19.152589 | 1 | International Results CSV 1 | h2h://158:169/1965-09-21 | |||
| 6508 | Ivory Coast 158 | Senegal 166 | 1965-11-21 | 2 | 0 | 0 | 2 | 2 | 2 | 1962-11-30 | D | 2026-06-07 07:03:19.164361 | 2026-06-07 07:03:19.164361 | 1 | International Results CSV 1 | h2h://158:166/1965-11-21 | |||
| 6513 | Ivory Coast 158 | Congo Republic 161 | 1965-11-23 | 3 | 0 | 3 | 0 | 4 | 7 | 1965-07-23 | W | 2026-06-07 07:03:19.165338 | 2026-06-07 07:03:19.165338 | 1 | International Results CSV 1 | h2h://161:158/1965-11-23 | |||
| 6518 | Ivory Coast 158 | Mali 162 | 1965-11-25 | 3 | 1 | 1 | 1 | 3 | 5 | 1964-03-15 | D | 2026-06-07 07:03:19.166293 | 2026-06-07 07:03:19.166293 | 1 | International Results CSV 1 | h2h://158:162/1965-11-25 | |||
| 6967 | Ivory Coast 158 | Liberia 169 | 1967-03-05 | 3 | 3 | 0 | 0 | 10 | 0 | 1965-09-21 | W | 2026-06-07 07:03:19.251447 | 2026-06-07 07:03:19.251447 | 1 | International Results CSV 1 | h2h://158:169/1967-03-05 | |||
| 7003 | Ivory Coast 158 | Gabon 160 | 1967-03-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.258233 | 2026-06-07 07:03:19.258233 | 1 | International Results CSV 1 | h2h://160:158/1967-03-28 | |||||
| 7229 | Ivory Coast 158 | Burkina Faso 159 | 1967-11-26 | 1 | 1 | 0 | 0 | 2 | 1 | 1961-12-25 | L | 2026-06-07 07:03:19.301106 | 2026-06-07 07:03:19.301106 | 1 | International Results CSV 1 | h2h://159:158/1967-11-26 | |||
| 7268 | Ivory Coast 158 | Algeria 173 | 1968-01-12 | 2 | 2 | 0 | 0 | 3 | 0 | 1965-07-25 | L | 2026-06-07 07:03:19.308488 | 2026-06-07 07:03:19.308488 | 1 | International Results CSV 1 | h2h://173:158/1968-01-12 | |||
| 7749 | Ivory Coast 158 | Congo Republic 161 | 1969-08-15 | 4 | 1 | 3 | 0 | 5 | 7 | 1965-11-23 | L | 2026-06-07 07:03:19.400021 | 2026-06-07 07:03:19.400021 | 1 | International Results CSV 1 | h2h://161:158/1969-08-15 | |||
| 7823 | Ivory Coast 158 | Mali 162 | 1969-10-12 | 4 | 1 | 2 | 1 | 4 | 8 | 1965-11-25 | W | 2026-06-07 07:03:19.414185 | 2026-06-07 07:03:19.414185 | 1 | International Results CSV 1 | h2h://162:158/1969-10-12 | |||
| 7848 | Ivory Coast 158 | Mali 162 | 1969-10-26 | 5 | 1 | 2 | 2 | 4 | 8 | 1969-10-12 | D | 2026-06-07 07:03:19.418896 | 2026-06-07 07:03:19.418896 | 1 | International Results CSV 1 | h2h://158:162/1969-10-26 | |||
| 7998 | Ivory Coast 158 | Guinea 172 | 1970-03-22 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.448313 | 2026-06-07 07:03:19.448313 | 1 | International Results CSV 1 | h2h://172:158/1970-03-22 | |||||
| 8107 | Ivory Coast 158 | Guinea 172 | 1970-07-26 | 1 | 0 | 1 | 0 | 2 | 4 | 1970-03-22 | L | 2026-06-07 07:03:19.469939 | 2026-06-07 07:03:19.469940 | 1 | International Results CSV 1 | h2h://158:172/1970-07-26 | |||
| 8193 | Ivory Coast 158 | Senegal 166 | 1970-10-18 | 3 | 1 | 0 | 2 | 3 | 2 | 1965-11-21 | W | 2026-06-07 07:03:19.487027 | 2026-06-07 07:03:19.487028 | 1 | International Results CSV 1 | h2h://158:166/1970-10-18 | |||
| 8214 | Ivory Coast 158 | Gabon 160 | 1970-11-08 | 1 | 1 | 0 | 0 | 3 | 0 | 1967-03-28 | L | 2026-06-07 07:03:19.491171 | 2026-06-07 07:03:19.491171 | 1 | International Results CSV 1 | h2h://160:158/1970-11-08 | |||
| 8258 | Ivory Coast 158 | Gabon 160 | 1970-11-22 | 2 | 2 | 0 | 0 | 5 | 1 | 1970-11-08 | W | 2026-06-07 07:03:19.499804 | 2026-06-07 07:03:19.499804 | 1 | International Results CSV 1 | h2h://158:160/1970-11-22 | |||
| 8584 | Ivory Coast 158 | Congo Republic 161 | 1971-10-13 | 5 | 1 | 3 | 1 | 6 | 8 | 1969-08-15 | D | 2026-06-07 07:03:19.564234 | 2026-06-07 07:03:19.564234 | 1 | International Results CSV 1 | h2h://158:161/1971-10-13 | |||
| 8597 | Ivory Coast 158 | Congo Republic 161 | 1971-10-27 | 6 | 2 | 3 | 1 | 9 | 10 | 1971-10-13 | L | 2026-06-07 07:03:19.566789 | 2026-06-07 07:03:19.566789 | 1 | International Results CSV 1 | h2h://161:158/1971-10-27 | |||
| 9224 | Ivory Coast 158 | Central African Republic 163 | 1973-04-08 | 1 | 1 | 0 | 0 | 1 | 0 | 1961-12-27 | L | 2026-06-07 07:03:19.690281 | 2026-06-07 07:03:19.690282 | 1 | International Results CSV 1 | h2h://163:158/1973-04-08 | |||
| 9382 | Ivory Coast 158 | Central African Republic 163 | 1973-07-29 | 2 | 1 | 1 | 0 | 3 | 4 | 1973-04-08 | L | 2026-06-07 07:03:19.722133 | 2026-06-07 07:03:19.722133 | 1 | International Results CSV 1 | h2h://158:163/1973-07-29 | |||
| 10050 | Ivory Coast 158 | Congo Republic 161 | 1975-03-30 | 7 | 2 | 4 | 1 | 9 | 12 | 1971-10-27 | W | 2026-06-07 07:03:20.162369 | 2026-06-07 07:03:20.162370 | 1 | International Results CSV 1 | h2h://161:158/1975-03-30 | |||
| 10074 | Ivory Coast 158 | Congo Republic 161 | 1975-04-13 | 8 | 2 | 5 | 1 | 9 | 13 | 1975-03-30 | L | 2026-06-07 07:03:20.166939 | 2026-06-07 07:03:20.166939 | 1 | International Results CSV 1 | h2h://158:161/1975-04-13 | |||
| 10091 | Ivory Coast 158 | Senegal 166 | 1975-04-26 | 4 | 1 | 1 | 2 | 3 | 3 | 1970-10-18 | W | 2026-06-07 07:03:20.170138 | 2026-06-07 07:03:20.170139 | 1 | International Results CSV 1 | h2h://166:158/1975-04-26 | |||
| 10455 | Ivory Coast 158 | Senegal 166 | 1976-03-21 | 5 | 1 | 2 | 2 | 3 | 4 | 1975-04-26 | L | 2026-06-07 07:03:20.239957 | 2026-06-07 07:03:20.239957 | 1 | International Results CSV 1 | h2h://158:166/1976-03-21 | |||
| 10466 | Ivory Coast 158 | Gabon 160 | 1976-03-28 | 3 | 3 | 0 | 0 | 6 | 1 | 1970-11-22 | L | 2026-06-07 07:03:20.242086 | 2026-06-07 07:03:20.242087 | 1 | International Results CSV 1 | h2h://160:158/1976-03-28 | |||
| 10497 | Ivory Coast 158 | Gabon 160 | 1976-04-19 | 4 | 4 | 0 | 0 | 9 | 1 | 1976-03-28 | W | 2026-06-07 07:03:20.248000 | 2026-06-07 07:03:20.248001 | 1 | International Results CSV 1 | h2h://158:160/1976-04-19 | |||
| 10633 | Ivory Coast 158 | Burkina Faso 159 | 1976-09-04 | 2 | 1 | 1 | 0 | 4 | 4 | 1967-11-26 | W | 2026-06-07 07:03:20.274249 | 2026-06-07 07:03:20.274250 | 1 | International Results CSV 1 | h2h://159:158/1976-09-04 | |||
| 10672 | Ivory Coast 158 | Burkina Faso 159 | 1976-09-26 | 3 | 1 | 1 | 1 | 5 | 5 | 1976-09-04 | D | 2026-06-07 07:03:20.281684 | 2026-06-07 07:03:20.281684 | 1 | International Results CSV 1 | h2h://158:159/1976-09-26 | |||
| 10832 | Ivory Coast 158 | Congo Republic 161 | 1977-02-13 | 9 | 3 | 5 | 1 | 11 | 14 | 1975-04-13 | W | 2026-06-07 07:03:20.312126 | 2026-06-07 07:03:20.312126 | 1 | International Results CSV 1 | h2h://158:161/1977-02-13 | |||
| 10853 | Ivory Coast 158 | Congo Republic 161 | 1977-02-27 | 10 | 4 | 5 | 1 | 14 | 16 | 1977-02-13 | L | 2026-06-07 07:03:20.316105 | 2026-06-07 07:03:20.316105 | 1 | International Results CSV 1 | h2h://161:158/1977-02-27 | |||
| 10905 | Ivory Coast 158 | Burkina Faso 159 | 1977-03-20 | 4 | 2 | 1 | 1 | 7 | 5 | 1976-09-26 | L | 2026-06-07 07:03:20.325975 | 2026-06-07 07:03:20.325975 | 1 | International Results CSV 1 | h2h://159:158/1977-03-20 | |||
| 10925 | Ivory Coast 158 | Burkina Faso 159 | 1977-03-27 | 5 | 3 | 1 | 1 | 8 | 5 | 1977-03-20 | W | 2026-06-07 07:03:20.329798 | 2026-06-07 07:03:20.329798 | 1 | International Results CSV 1 | h2h://158:159/1977-03-27 | |||
| 11715 | Ivory Coast 158 | Gabon 160 | 1979-04-08 | 5 | 4 | 1 | 0 | 10 | 4 | 1976-04-19 | W | 2026-06-07 07:03:20.485073 | 2026-06-07 07:03:20.485074 | 1 | International Results CSV 1 | h2h://160:158/1979-04-08 | |||
| 12080 | Ivory Coast 158 | Congo Republic 161 | 1980-01-19 | 11 | 5 | 5 | 1 | 17 | 17 | 1977-02-27 | L | 2026-06-07 07:03:20.557642 | 2026-06-07 07:03:20.557642 | 1 | International Results CSV 1 | h2h://161:158/1980-01-19 | |||
| 12081 | Ivory Coast 158 | Congo Republic 161 | 1980-01-20 | 12 | 5 | 6 | 1 | 17 | 19 | 1980-01-19 | W | 2026-06-07 07:03:20.557838 | 2026-06-07 07:03:20.557839 | 1 | International Results CSV 1 | h2h://161:158/1980-01-20 | |||
| 12176 | Ivory Coast 158 | Gabon 160 | 1980-04-06 | 6 | 4 | 2 | 0 | 11 | 6 | 1979-04-08 | L | 2026-06-07 07:03:20.576530 | 2026-06-07 07:03:20.576531 | 1 | International Results CSV 1 | h2h://158:160/1980-04-06 | |||
| 13137 | Ivory Coast 158 | Niger 171 | 1982-02-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.767476 | 2026-06-07 07:03:20.767476 | 1 | International Results CSV 1 | h2h://158:171/1982-02-19 | |||||
| 13144 | Ivory Coast 158 | Burkina Faso 159 | 1982-02-22 | 6 | 4 | 1 | 1 | 12 | 6 | 1977-03-27 | W | 2026-06-07 07:03:20.768856 | 2026-06-07 07:03:20.768856 | 1 | International Results CSV 1 | h2h://158:159/1982-02-22 | |||
| 13507 | Ivory Coast 158 | Mali 162 | 1983-01-09 | 6 | 2 | 2 | 2 | 8 | 8 | 1969-10-26 | W | 2026-06-07 07:03:20.840748 | 2026-06-07 07:03:20.840748 | 1 | International Results CSV 1 | h2h://158:162/1983-01-09 | |||
| 13535 | Ivory Coast 158 | Guinea 172 | 1983-02-23 | 2 | 1 | 1 | 0 | 5 | 6 | 1970-07-26 | W | 2026-06-07 07:03:20.846324 | 2026-06-07 07:03:20.846325 | 1 | International Results CSV 1 | h2h://158:172/1983-02-23 | |||
| 13597 | Ivory Coast 158 | Mali 162 | 1983-04-17 | 7 | 2 | 3 | 2 | 8 | 9 | 1983-01-09 | W | 2026-06-07 07:03:20.858521 | 2026-06-07 07:03:20.858521 | 1 | International Results CSV 1 | h2h://162:158/1983-04-17 | |||
| 13803 | Ivory Coast 158 | Algeria 173 | 1983-08-25 | 3 | 3 | 0 | 0 | 6 | 0 | 1968-01-12 | L | 2026-06-07 07:03:20.899605 | 2026-06-07 07:03:20.899606 | 1 | International Results CSV 1 | h2h://173:158/1983-08-25 | |||
| 13856 | Ivory Coast 158 | Liberia 169 | 1983-09-25 | 4 | 3 | 0 | 1 | 11 | 1 | 1967-03-05 | D | 2026-06-07 07:03:20.910156 | 2026-06-07 07:03:20.910156 | 1 | International Results CSV 1 | h2h://158:169/1983-09-25 | |||
| 13865 | Ivory Coast 158 | Liberia 169 | 1983-10-02 | 5 | 3 | 0 | 2 | 11 | 1 | 1983-09-25 | D | 2026-06-07 07:03:20.911951 | 2026-06-07 07:03:20.911951 | 1 | International Results CSV 1 | h2h://158:169/1983-10-02 | |||
| 13962 | Ivory Coast 158 | Mali 162 | 1983-12-15 | 8 | 3 | 3 | 2 | 10 | 10 | 1983-04-17 | W | 2026-06-07 07:03:20.931232 | 2026-06-07 07:03:20.931232 | 1 | International Results CSV 1 | h2h://158:162/1983-12-15 | |||
| 13988 | Ivory Coast 158 | Guinea 172 | 1984-01-22 | 3 | 2 | 1 | 0 | 8 | 8 | 1983-02-23 | W | 2026-06-07 07:03:20.936324 | 2026-06-07 07:03:20.936324 | 1 | International Results CSV 1 | h2h://158:172/1984-01-22 | |||
| 13992 | Ivory Coast 158 | Mali 162 | 1984-01-29 | 9 | 3 | 3 | 3 | 11 | 11 | 1983-12-15 | D | 2026-06-07 07:03:20.937103 | 2026-06-07 07:03:20.937103 | 1 | International Results CSV 1 | h2h://158:162/1984-01-29 | |||
| 13995 | Ivory Coast 158 | Senegal 166 | 1984-01-31 | 6 | 2 | 2 | 2 | 7 | 5 | 1976-03-21 | W | 2026-06-07 07:03:20.937699 | 2026-06-07 07:03:20.937699 | 1 | International Results CSV 1 | h2h://158:166/1984-01-31 | |||
| 13997 | Ivory Coast 158 | Liberia 169 | 1984-02-02 | 6 | 4 | 0 | 2 | 13 | 2 | 1983-10-02 | W | 2026-06-07 07:03:20.938087 | 2026-06-07 07:03:20.938087 | 1 | International Results CSV 1 | h2h://158:169/1984-02-02 | |||
| 14000 | Ivory Coast 158 | Senegal 166 | 1984-02-05 | 7 | 3 | 2 | 2 | 8 | 5 | 1984-01-31 | W | 2026-06-07 07:03:20.938678 | 2026-06-07 07:03:20.938678 | 1 | International Results CSV 1 | h2h://158:166/1984-02-05 | |||
| 14004 | Ivory Coast 158 | Congo Republic 161 | 1984-02-08 | 13 | 6 | 6 | 1 | 19 | 19 | 1980-01-20 | L | 2026-06-07 07:03:20.939460 | 2026-06-07 07:03:20.939460 | 1 | International Results CSV 1 | h2h://161:158/1984-02-08 | |||
| 14299 | Ivory Coast 158 | Niger 171 | 1984-09-23 | 1 | 0 | 0 | 1 | 1 | 1 | 1982-02-19 | D | 2026-06-07 07:03:20.997865 | 2026-06-07 07:03:20.997866 | 1 | International Results CSV 1 | h2h://171:158/1984-09-23 | |||
| 14326 | Ivory Coast 158 | Liberia 169 | 1984-10-11 | 7 | 5 | 0 | 2 | 17 | 3 | 1984-02-02 | W | 2026-06-07 07:03:21.003266 | 2026-06-07 07:03:21.003266 | 1 | International Results CSV 1 | h2h://158:169/1984-10-11 | |||
| 14413 | Ivory Coast 158 | Burkina Faso 159 | 1984-11-20 | 7 | 4 | 1 | 2 | 13 | 7 | 1982-02-22 | D | 2026-06-07 07:03:21.020333 | 2026-06-07 07:03:21.020333 | 1 | International Results CSV 1 | h2h://159:158/1984-11-20 | |||
| 14430 | Ivory Coast 158 | Burkina Faso 159 | 1984-11-28 | 8 | 4 | 1 | 3 | 15 | 9 | 1984-11-20 | D | 2026-06-07 07:03:21.023704 | 2026-06-07 07:03:21.023704 | 1 | International Results CSV 1 | h2h://159:158/1984-11-28 | |||
| 14473 | Ivory Coast 158 | Guinea 172 | 1984-12-09 | 4 | 3 | 1 | 0 | 11 | 8 | 1984-01-22 | W | 2026-06-07 07:03:21.032202 | 2026-06-07 07:03:21.032202 | 1 | International Results CSV 1 | h2h://158:172/1984-12-09 | |||
| 14515 | Ivory Coast 158 | Algeria 173 | 1985-01-01 | 4 | 3 | 1 | 0 | 6 | 3 | 1983-08-25 | L | 2026-06-07 07:03:21.040460 | 2026-06-07 07:03:21.040460 | 1 | International Results CSV 1 | h2h://158:173/1985-01-01 | |||
| 14582 | Ivory Coast 158 | Congo Republic 161 | 1985-02-20 | 14 | 7 | 6 | 1 | 22 | 21 | 1984-02-08 | W | 2026-06-07 07:03:21.053721 | 2026-06-07 07:03:21.053721 | 1 | International Results CSV 1 | h2h://158:161/1985-02-20 | |||
| 14680 | Ivory Coast 158 | Mali 162 | 1985-03-31 | 10 | 4 | 3 | 3 | 15 | 12 | 1984-01-29 | W | 2026-06-07 07:03:21.073210 | 2026-06-07 07:03:21.073210 | 1 | International Results CSV 1 | h2h://158:162/1985-03-31 | |||
| 14721 | Ivory Coast 158 | Mali 162 | 1985-04-14 | 11 | 5 | 3 | 3 | 21 | 12 | 1985-03-31 | L | 2026-06-07 07:03:21.081288 | 2026-06-07 07:03:21.081288 | 1 | International Results CSV 1 | h2h://162:158/1985-04-14 | |||
| 15068 | Ivory Coast 158 | Congo Republic 161 | 1985-11-27 | 15 | 8 | 6 | 1 | 24 | 22 | 1985-02-20 | L | 2026-06-07 07:03:21.464862 | 2026-06-07 07:03:21.464862 | 1 | International Results CSV 1 | h2h://161:158/1985-11-27 | |||
| 15069 | Ivory Coast 158 | Congo Republic 161 | 1985-11-29 | 16 | 8 | 7 | 1 | 25 | 24 | 1985-11-27 | W | 2026-06-07 07:03:21.465050 | 2026-06-07 07:03:21.465051 | 1 | International Results CSV 1 | h2h://161:158/1985-11-29 | |||
| 15113 | Ivory Coast 158 | Guinea 172 | 1985-12-27 | 5 | 3 | 1 | 1 | 13 | 10 | 1984-12-09 | D | 2026-06-07 07:03:21.473386 | 2026-06-07 07:03:21.473386 | 1 | International Results CSV 1 | h2h://158:172/1985-12-27 | |||
| 15114 | Ivory Coast 158 | Senegal 166 | 1985-12-29 | 8 | 4 | 2 | 2 | 12 | 8 | 1984-02-05 | L | 2026-06-07 07:03:21.473573 | 2026-06-07 07:03:21.473573 | 1 | International Results CSV 1 | h2h://166:158/1985-12-29 | |||
| 15194 | Ivory Coast 158 | Mozambique 203 | 1986-03-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.488614 | 2026-06-07 07:03:21.488615 | 1 | International Results CSV 1 | h2h://158:203/1986-03-07 | |||||
| 15208 | Ivory Coast 158 | Senegal 166 | 1986-03-13 | 9 | 4 | 3 | 2 | 12 | 10 | 1985-12-29 | L | 2026-06-07 07:03:21.491248 | 2026-06-07 07:03:21.491248 | 1 | International Results CSV 1 | h2h://158:166/1986-03-13 | |||
| 15374 | Ivory Coast 158 | Guinea 172 | 1986-07-28 | 6 | 4 | 1 | 1 | 14 | 10 | 1985-12-27 | L | 2026-06-07 07:03:21.522895 | 2026-06-07 07:03:21.522896 | 1 | International Results CSV 1 | h2h://172:158/1986-07-28 | |||
| 15377 | Ivory Coast 158 | Liberia 169 | 1986-07-30 | 8 | 6 | 0 | 2 | 20 | 3 | 1984-10-11 | L | 2026-06-07 07:03:21.523479 | 2026-06-07 07:03:21.523479 | 1 | International Results CSV 1 | h2h://169:158/1986-07-30 | |||
| 15532 | Ivory Coast 158 | Algeria 173 | 1986-12-11 | 5 | 3 | 1 | 1 | 7 | 4 | 1985-01-01 | D | 2026-06-07 07:03:21.552941 | 2026-06-07 07:03:21.552941 | 1 | International Results CSV 1 | h2h://173:158/1986-12-11 | |||
| 15538 | Ivory Coast 158 | Algeria 173 | 1986-12-14 | 6 | 3 | 2 | 1 | 8 | 6 | 1986-12-11 | W | 2026-06-07 07:03:21.554075 | 2026-06-07 07:03:21.554076 | 1 | International Results CSV 1 | h2h://173:158/1986-12-14 | |||
| 15560 | Ivory Coast 158 | Niger 171 | 1987-02-04 | 2 | 1 | 0 | 1 | 4 | 2 | 1984-09-23 | L | 2026-06-07 07:03:21.558221 | 2026-06-07 07:03:21.558221 | 1 | International Results CSV 1 | h2h://171:158/1987-02-04 | |||
| 15624 | Ivory Coast 158 | Congo Republic 161 | 1987-03-29 | 17 | 9 | 7 | 1 | 26 | 24 | 1985-11-29 | W | 2026-06-07 07:03:21.570321 | 2026-06-07 07:03:21.570322 | 1 | International Results CSV 1 | h2h://158:161/1987-03-29 | |||
| 15637 | Ivory Coast 158 | Congo Republic 161 | 1987-04-05 | 18 | 10 | 7 | 1 | 28 | 24 | 1987-03-29 | L | 2026-06-07 07:03:21.572861 | 2026-06-07 07:03:21.572862 | 1 | International Results CSV 1 | h2h://161:158/1987-04-05 | |||
| 15639 | Ivory Coast 158 | Gabon 160 | 1987-04-08 | 7 | 5 | 2 | 0 | 15 | 7 | 1980-04-06 | L | 2026-06-07 07:03:21.573247 | 2026-06-07 07:03:21.573248 | 1 | International Results CSV 1 | h2h://160:158/1987-04-08 | |||
| 15768 | Ivory Coast 158 | Senegal 166 | 1987-08-06 | 10 | 5 | 3 | 2 | 13 | 10 | 1986-03-13 | W | 2026-06-07 07:03:21.597927 | 2026-06-07 07:03:21.597928 | 1 | International Results CSV 1 | h2h://158:166/1987-08-06 | |||
| 15925 | Ivory Coast 158 | Senegal 166 | 1987-12-19 | 11 | 6 | 3 | 2 | 14 | 10 | 1987-08-06 | W | 2026-06-07 07:03:21.628047 | 2026-06-07 07:03:21.628048 | 1 | International Results CSV 1 | h2h://158:166/1987-12-19 | |||
| 15934 | Ivory Coast 158 | Liberia 169 | 1987-12-23 | 9 | 7 | 0 | 2 | 22 | 3 | 1986-07-30 | L | 2026-06-07 07:03:21.629771 | 2026-06-07 07:03:21.629771 | 1 | International Results CSV 1 | h2h://169:158/1987-12-23 | |||
| 16020 | Ivory Coast 158 | Algeria 173 | 1988-03-13 | 7 | 3 | 3 | 1 | 9 | 8 | 1986-12-14 | W | 2026-06-07 07:03:21.646043 | 2026-06-07 07:03:21.646043 | 1 | International Results CSV 1 | h2h://173:158/1988-03-13 | |||
| 16616 | Ivory Coast 158 | Angola 205 | 1989-04-09 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.760298 | 2026-06-07 07:03:21.760299 | 1 | International Results CSV 1 | h2h://205:158/1989-04-09 | |||||
| 16647 | Ivory Coast 158 | Angola 205 | 1989-04-23 | 1 | 1 | 0 | 0 | 2 | 0 | 1989-04-09 | W | 2026-06-07 07:03:21.766237 | 2026-06-07 07:03:21.766237 | 1 | International Results CSV 1 | h2h://158:205/1989-04-23 | |||
| 16776 | Ivory Coast 158 | Algeria 173 | 1989-06-11 | 8 | 3 | 3 | 2 | 10 | 9 | 1988-03-13 | D | 2026-06-07 07:03:21.791042 | 2026-06-07 07:03:21.791043 | 1 | International Results CSV 1 | h2h://158:173/1989-06-11 | |||
| 16868 | Ivory Coast 158 | Mali 162 | 1989-07-16 | 12 | 5 | 3 | 4 | 22 | 13 | 1985-04-14 | D | 2026-06-07 07:03:21.808774 | 2026-06-07 07:03:21.808775 | 1 | International Results CSV 1 | h2h://162:158/1989-07-16 | |||
| 16879 | Ivory Coast 158 | Mali 162 | 1989-07-30 | 13 | 5 | 3 | 5 | 24 | 15 | 1989-07-16 | D | 2026-06-07 07:03:21.810918 | 2026-06-07 07:03:21.810918 | 1 | International Results CSV 1 | h2h://158:162/1989-07-30 | |||
| 16915 | Ivory Coast 158 | Algeria 173 | 1989-08-25 | 9 | 3 | 3 | 3 | 10 | 9 | 1989-06-11 | D | 2026-06-07 07:03:21.817833 | 2026-06-07 07:03:21.817833 | 1 | International Results CSV 1 | h2h://173:158/1989-08-25 | |||
| 17118 | Ivory Coast 158 | Liberia 169 | 1990-01-27 | 10 | 8 | 0 | 2 | 24 | 4 | 1987-12-23 | W | 2026-06-07 07:03:21.856779 | 2026-06-07 07:03:21.856779 | 1 | International Results CSV 1 | h2h://158:169/1990-01-27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE h2h_record (
h2h_id INTEGER NOT NULL,
team_a_id INTEGER NOT NULL,
team_b_id INTEGER NOT NULL,
date DATE NOT NULL,
total_matches INTEGER NOT NULL,
wins_a INTEGER NOT NULL,
wins_b INTEGER NOT NULL,
draws INTEGER NOT NULL,
goals_a INTEGER NOT NULL,
goals_b INTEGER NOT NULL,
last_match_date DATE,
last_result VARCHAR(1),
last_match_id INTEGER,
competition_id INTEGER,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL,
created_by_run_id INTEGER,
updated_by_run_id INTEGER,
source_id INTEGER NOT NULL,
source_raw_key VARCHAR(512),
CONSTRAINT pk_h2h_record PRIMARY KEY (h2h_id),
CONSTRAINT fk_h2h_record_team_a FOREIGN KEY(team_a_id) REFERENCES team (team_id),
CONSTRAINT fk_h2h_record_team_b FOREIGN KEY(team_b_id) REFERENCES team (team_id),
CONSTRAINT fk_h2h_record_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
CONSTRAINT fk_h2h_record_match FOREIGN KEY(last_match_id) REFERENCES match (match_id),
CONSTRAINT fk_h2h_record_competition FOREIGN KEY(competition_id) REFERENCES competition (competition_id)
);