h2h_record
262 rows where team_a_id = 107
This data as json, CSV (advanced)
Suggested facets: wins_a, wins_b, draws, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2916 | Madagascar 107 | Mauritius 108 | 1947-02-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.458260 | 2026-06-07 07:03:18.458260 | 1 | International Results CSV 1 | h2h://107:108/1947-02-15 | |||||
| 2950 | Madagascar 107 | Réunion 109 | 1947-06-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.458570 | 2026-06-07 07:03:18.458570 | 1 | International Results CSV 1 | h2h://107:109/1947-06-06 | |||||
| 3120 | Madagascar 107 | Réunion 109 | 1948-07-15 | 1 | 1 | 0 | 0 | 4 | 2 | 1947-06-06 | W | 2026-06-07 07:03:18.460072 | 2026-06-07 07:03:18.460072 | 1 | International Results CSV 1 | h2h://107:109/1948-07-15 | |||
| 3121 | Madagascar 107 | Mauritius 108 | 1948-07-17 | 1 | 0 | 1 | 0 | 1 | 2 | 1947-02-15 | W | 2026-06-07 07:03:18.460079 | 2026-06-07 07:03:18.460079 | 1 | International Results CSV 1 | h2h://108:107/1948-07-17 | |||
| 3260 | Madagascar 107 | Mauritius 108 | 1949-06-16 | 2 | 0 | 2 | 0 | 2 | 6 | 1948-07-17 | L | 2026-06-07 07:03:18.461278 | 2026-06-07 07:03:18.461278 | 1 | International Results CSV 1 | h2h://107:108/1949-06-16 | |||
| 3301 | Madagascar 107 | Réunion 109 | 1949-10-10 | 2 | 2 | 0 | 0 | 6 | 3 | 1948-07-15 | L | 2026-06-07 07:03:18.461621 | 2026-06-07 07:03:18.461621 | 1 | International Results CSV 1 | h2h://109:107/1949-10-10 | |||
| 3408 | Madagascar 107 | Réunion 109 | 1950-07-11 | 3 | 3 | 0 | 0 | 9 | 4 | 1949-10-10 | W | 2026-06-07 07:03:18.462580 | 2026-06-07 07:03:18.462580 | 1 | International Results CSV 1 | h2h://107:109/1950-07-11 | |||
| 3409 | Madagascar 107 | Mauritius 108 | 1950-07-11 | 3 | 0 | 3 | 0 | 3 | 9 | 1949-06-16 | L | 2026-06-07 07:03:18.462587 | 2026-06-07 07:03:18.462587 | 1 | International Results CSV 1 | h2h://107:108/1950-07-11 | |||
| 3522 | Madagascar 107 | Réunion 109 | 1951-07-14 | 4 | 3 | 1 | 0 | 11 | 7 | 1950-07-11 | L | 2026-06-07 07:03:18.463561 | 2026-06-07 07:03:18.463561 | 1 | International Results CSV 1 | h2h://107:109/1951-07-14 | |||
| 3523 | Madagascar 107 | Mauritius 108 | 1951-07-19 | 4 | 0 | 4 | 0 | 4 | 14 | 1950-07-11 | W | 2026-06-07 07:03:18.463568 | 2026-06-07 07:03:18.463568 | 1 | International Results CSV 1 | h2h://108:107/1951-07-19 | |||
| 3641 | Madagascar 107 | Réunion 109 | 1952-07-24 | 5 | 4 | 1 | 0 | 14 | 8 | 1951-07-14 | L | 2026-06-07 07:03:18.464616 | 2026-06-07 07:03:18.464616 | 1 | International Results CSV 1 | h2h://109:107/1952-07-24 | |||
| 3644 | Madagascar 107 | Mauritius 108 | 1952-07-31 | 5 | 0 | 5 | 0 | 5 | 21 | 1951-07-19 | L | 2026-06-07 07:03:18.464641 | 2026-06-07 07:03:18.464642 | 1 | International Results CSV 1 | h2h://107:108/1952-07-31 | |||
| 3790 | Madagascar 107 | Réunion 109 | 1953-07-16 | 6 | 5 | 1 | 0 | 15 | 8 | 1952-07-24 | W | 2026-06-07 07:03:18.465895 | 2026-06-07 07:03:18.465895 | 1 | International Results CSV 1 | h2h://107:109/1953-07-16 | |||
| 3792 | Madagascar 107 | Mauritius 108 | 1953-07-20 | 6 | 0 | 6 | 0 | 5 | 28 | 1952-07-31 | L | 2026-06-07 07:03:18.465909 | 2026-06-07 07:03:18.465909 | 1 | International Results CSV 1 | h2h://107:108/1953-07-20 | |||
| 3978 | Madagascar 107 | Réunion 109 | 1954-07-11 | 7 | 6 | 1 | 0 | 21 | 12 | 1953-07-16 | W | 2026-06-07 07:03:18.467520 | 2026-06-07 07:03:18.467520 | 1 | International Results CSV 1 | h2h://107:109/1954-07-11 | |||
| 3979 | Madagascar 107 | Mauritius 108 | 1954-07-14 | 7 | 0 | 7 | 0 | 7 | 31 | 1953-07-20 | W | 2026-06-07 07:03:18.467528 | 2026-06-07 07:03:18.467528 | 1 | International Results CSV 1 | h2h://108:107/1954-07-14 | |||
| 4104 | Madagascar 107 | Réunion 109 | 1955-07-10 | 8 | 6 | 2 | 0 | 23 | 18 | 1954-07-11 | W | 2026-06-07 07:03:18.468689 | 2026-06-07 07:03:18.468689 | 1 | International Results CSV 1 | h2h://109:107/1955-07-10 | |||
| 4106 | Madagascar 107 | Mauritius 108 | 1955-07-14 | 8 | 0 | 8 | 0 | 8 | 35 | 1954-07-14 | L | 2026-06-07 07:03:18.468705 | 2026-06-07 07:03:18.468705 | 1 | International Results CSV 1 | h2h://107:108/1955-07-14 | |||
| 4293 | Madagascar 107 | Réunion 109 | 1956-07-05 | 9 | 7 | 2 | 0 | 27 | 20 | 1955-07-10 | W | 2026-06-07 07:03:18.470393 | 2026-06-07 07:03:18.470393 | 1 | International Results CSV 1 | h2h://107:109/1956-07-05 | |||
| 4295 | Madagascar 107 | Mauritius 108 | 1956-07-08 | 9 | 1 | 8 | 0 | 10 | 36 | 1955-07-14 | W | 2026-06-07 07:03:18.470412 | 2026-06-07 07:03:18.470413 | 1 | International Results CSV 1 | h2h://107:108/1956-07-08 | |||
| 4578 | Madagascar 107 | Réunion 109 | 1957-10-20 | 10 | 8 | 2 | 0 | 31 | 22 | 1956-07-05 | W | 2026-06-07 07:03:18.472917 | 2026-06-07 07:03:18.472917 | 1 | International Results CSV 1 | h2h://107:109/1957-10-20 | |||
| 4581 | Madagascar 107 | Mauritius 108 | 1957-10-24 | 10 | 1 | 8 | 1 | 13 | 39 | 1956-07-08 | D | 2026-06-07 07:03:18.472940 | 2026-06-07 07:03:18.472940 | 1 | International Results CSV 1 | h2h://108:107/1957-10-24 | |||
| 4772 | Madagascar 107 | Réunion 109 | 1958-10-19 | 11 | 8 | 3 | 0 | 31 | 23 | 1957-10-20 | W | 2026-06-07 07:03:18.474616 | 2026-06-07 07:03:18.474616 | 1 | International Results CSV 1 | h2h://109:107/1958-10-19 | |||
| 4774 | Madagascar 107 | Mauritius 108 | 1958-10-23 | 11 | 1 | 9 | 1 | 13 | 43 | 1957-10-24 | L | 2026-06-07 07:03:18.474631 | 2026-06-07 07:03:18.474632 | 1 | International Results CSV 1 | h2h://107:108/1958-10-23 | |||
| 5025 | Madagascar 107 | Burkina Faso 159 | 1960-04-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.880960 | 2026-06-07 07:03:18.880960 | 1 | International Results CSV 1 | h2h://107:159/1960-04-15 | |||||
| 5029 | Madagascar 107 | Congo Republic 161 | 1960-04-18 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.881728 | 2026-06-07 07:03:18.881729 | 1 | International Results CSV 1 | h2h://107:161/1960-04-18 | |||||
| 5420 | Madagascar 107 | Mauritania 168 | 1961-12-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.956466 | 2026-06-07 07:03:18.956466 | 1 | International Results CSV 1 | h2h://107:168/1961-12-25 | |||||
| 5428 | Madagascar 107 | Benin 156 | 1961-12-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.957953 | 2026-06-07 07:03:18.957953 | 1 | International Results CSV 1 | h2h://156:107/1961-12-27 | |||||
| 5678 | Madagascar 107 | Congo Republic 161 | 1962-12-24 | 1 | 1 | 0 | 0 | 8 | 1 | 1960-04-18 | L | 2026-06-07 07:03:19.006516 | 2026-06-07 07:03:19.006516 | 1 | International Results CSV 1 | h2h://161:107/1962-12-24 | |||
| 5680 | Madagascar 107 | Central African Republic 163 | 1962-12-31 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.006886 | 2026-06-07 07:03:19.006886 | 1 | International Results CSV 1 | h2h://163:107/1962-12-31 | |||||
| 5782 | Madagascar 107 | Benin 156 | 1963-04-12 | 1 | 0 | 1 | 0 | 1 | 3 | 1961-12-27 | L | 2026-06-07 07:03:19.026430 | 2026-06-07 07:03:19.026431 | 1 | International Results CSV 1 | h2h://107:156/1963-04-12 | |||
| 5794 | Madagascar 107 | Chad 170 | 1963-04-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.028675 | 2026-06-07 07:03:19.028675 | 1 | International Results CSV 1 | h2h://107:170/1963-04-14 | |||||
| 5804 | Madagascar 107 | Liberia 169 | 1963-04-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.030571 | 2026-06-07 07:03:19.030571 | 1 | International Results CSV 1 | h2h://107:169/1963-04-16 | |||||
| 5811 | Madagascar 107 | Tunisia 152 | 1963-04-18 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.031876 | 2026-06-07 07:03:19.031876 | 1 | International Results CSV 1 | h2h://152:107/1963-04-18 | |||||
| 5903 | Madagascar 107 | Réunion 109 | 1963-09-15 | 12 | 9 | 3 | 0 | 34 | 24 | 1958-10-19 | W | 2026-06-07 07:03:19.049331 | 2026-06-07 07:03:19.049331 | 1 | International Results CSV 1 | h2h://107:109/1963-09-15 | |||
| 6348 | Madagascar 107 | DR Congo 113 | 1965-07-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.134116 | 2026-06-07 07:03:19.134116 | 1 | International Results CSV 1 | h2h://107:113/1965-07-19 | |||||
| 6353 | Madagascar 107 | Ivory Coast 158 | 1965-07-20 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.135045 | 2026-06-07 07:03:19.135045 | 1 | International Results CSV 1 | h2h://158:107/1965-07-20 | |||||
| 6359 | Madagascar 107 | Algeria 173 | 1965-07-21 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.136172 | 2026-06-07 07:03:19.136173 | 1 | International Results CSV 1 | h2h://173:107/1965-07-21 | |||||
| 6372 | Madagascar 107 | Togo 148 | 1965-07-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.138601 | 2026-06-07 07:03:19.138602 | 1 | International Results CSV 1 | h2h://148:107/1965-07-26 | |||||
| 6689 | Madagascar 107 | Malawi 154 | 1966-07-09 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.198756 | 2026-06-07 07:03:19.198756 | 1 | International Results CSV 1 | h2h://154:107/1966-07-09 | |||||
| 7713 | Madagascar 107 | Malawi 154 | 1969-07-01 | 1 | 1 | 0 | 0 | 6 | 1 | 1966-07-09 | W | 2026-06-07 07:03:19.393216 | 2026-06-07 07:03:19.393217 | 1 | International Results CSV 1 | h2h://107:154/1969-07-01 | |||
| 8242 | Madagascar 107 | Mauritius 108 | 1970-11-15 | 12 | 2 | 9 | 1 | 16 | 45 | 1958-10-23 | W | 2026-06-07 07:03:19.496627 | 2026-06-07 07:03:19.496628 | 1 | International Results CSV 1 | h2h://107:108/1970-11-15 | |||
| 8265 | Madagascar 107 | Mauritius 108 | 1970-11-29 | 13 | 3 | 9 | 1 | 18 | 46 | 1970-11-15 | L | 2026-06-07 07:03:19.501181 | 2026-06-07 07:03:19.501182 | 1 | International Results CSV 1 | h2h://108:107/1970-11-29 | |||
| 8324 | Madagascar 107 | Liberia 169 | 1971-03-01 | 1 | 1 | 0 | 0 | 3 | 1 | 1963-04-16 | W | 2026-06-07 07:03:19.512733 | 2026-06-07 07:03:19.512733 | 1 | International Results CSV 1 | h2h://107:169/1971-03-01 | |||
| 8327 | Madagascar 107 | Lesotho 191 | 1971-03-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.513320 | 2026-06-07 07:03:19.513320 | 1 | International Results CSV 1 | h2h://191:107/1971-03-07 | |||||
| 8336 | Madagascar 107 | Mauritius 108 | 1971-03-28 | 14 | 3 | 10 | 1 | 19 | 50 | 1970-11-29 | L | 2026-06-07 07:03:19.515089 | 2026-06-07 07:03:19.515090 | 1 | International Results CSV 1 | h2h://107:108/1971-03-28 | |||
| 8443 | Madagascar 107 | Mauritius 108 | 1971-06-27 | 15 | 4 | 10 | 1 | 22 | 50 | 1971-03-28 | W | 2026-06-07 07:03:19.536173 | 2026-06-07 07:03:19.536174 | 1 | International Results CSV 1 | h2h://107:108/1971-06-27 | |||
| 11587 | Madagascar 107 | Malawi 154 | 1978-12-03 | 2 | 2 | 0 | 0 | 9 | 1 | 1969-07-01 | W | 2026-06-07 07:03:20.459846 | 2026-06-07 07:03:20.459847 | 1 | International Results CSV 1 | h2h://107:154/1978-12-03 | |||
| 11611 | Madagascar 107 | Malawi 154 | 1978-12-17 | 3 | 3 | 0 | 0 | 11 | 2 | 1978-12-03 | L | 2026-06-07 07:03:20.464578 | 2026-06-07 07:03:20.464578 | 1 | International Results CSV 1 | h2h://154:107/1978-12-17 | |||
| 12362 | Madagascar 107 | Mauritius 108 | 1980-09-14 | 16 | 4 | 10 | 2 | 23 | 51 | 1971-06-27 | D | 2026-06-07 07:03:20.613450 | 2026-06-07 07:03:20.613450 | 1 | International Results CSV 1 | h2h://107:108/1980-09-14 | |||
| 12400 | Madagascar 107 | Mauritius 108 | 1980-09-28 | 17 | 4 | 10 | 3 | 23 | 51 | 1980-09-14 | D | 2026-06-07 07:03:20.620949 | 2026-06-07 07:03:20.620949 | 1 | International Results CSV 1 | h2h://108:107/1980-09-28 | |||
| 12500 | Madagascar 107 | DR Congo 113 | 1980-11-16 | 1 | 0 | 1 | 0 | 0 | 7 | 1965-07-19 | L | 2026-06-07 07:03:20.640766 | 2026-06-07 07:03:20.640766 | 1 | International Results CSV 1 | h2h://107:113/1980-11-16 | |||
| 12569 | Madagascar 107 | DR Congo 113 | 1980-12-21 | 2 | 0 | 1 | 1 | 1 | 8 | 1980-11-16 | D | 2026-06-07 07:03:20.654396 | 2026-06-07 07:03:20.654397 | 1 | International Results CSV 1 | h2h://113:107/1980-12-21 | |||
| 12847 | Madagascar 107 | Réunion 109 | 1981-07-12 | 13 | 10 | 3 | 0 | 40 | 25 | 1963-09-15 | L | 2026-06-07 07:03:20.709778 | 2026-06-07 07:03:20.709778 | 1 | International Results CSV 1 | h2h://109:107/1981-07-12 | |||
| 12848 | Madagascar 107 | Réunion 109 | 1981-07-13 | 14 | 11 | 3 | 0 | 43 | 27 | 1981-07-12 | L | 2026-06-07 07:03:20.709987 | 2026-06-07 07:03:20.709987 | 1 | International Results CSV 1 | h2h://109:107/1981-07-13 | |||
| 12852 | Madagascar 107 | Mauritius 108 | 1981-07-14 | 18 | 4 | 10 | 4 | 24 | 52 | 1980-09-28 | D | 2026-06-07 07:03:20.710780 | 2026-06-07 07:03:20.710780 | 1 | International Results CSV 1 | h2h://107:108/1981-07-14 | |||
| 12889 | Madagascar 107 | Cameroon 140 | 1981-08-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.718158 | 2026-06-07 07:03:20.718159 | 1 | International Results CSV 1 | h2h://140:107/1981-08-16 | |||||
| 12903 | Madagascar 107 | Cameroon 140 | 1981-08-30 | 1 | 0 | 1 | 0 | 1 | 5 | 1981-08-16 | L | 2026-06-07 07:03:20.720931 | 2026-06-07 07:03:20.720931 | 1 | International Results CSV 1 | h2h://107:140/1981-08-30 | |||
| 13717 | Madagascar 107 | Mauritius 108 | 1983-07-10 | 19 | 4 | 10 | 5 | 24 | 52 | 1981-07-14 | D | 2026-06-07 07:03:20.882549 | 2026-06-07 07:03:20.882549 | 1 | International Results CSV 1 | h2h://107:108/1983-07-10 | |||
| 13719 | Madagascar 107 | Réunion 109 | 1983-07-13 | 15 | 12 | 3 | 0 | 46 | 27 | 1981-07-13 | L | 2026-06-07 07:03:20.882941 | 2026-06-07 07:03:20.882942 | 1 | International Results CSV 1 | h2h://109:107/1983-07-13 | |||
| 13778 | Madagascar 107 | Malawi 154 | 1983-08-14 | 4 | 3 | 1 | 0 | 12 | 7 | 1978-12-17 | L | 2026-06-07 07:03:20.894671 | 2026-06-07 07:03:20.894671 | 1 | International Results CSV 1 | h2h://107:154/1983-08-14 | |||
| 13808 | Madagascar 107 | Malawi 154 | 1983-08-28 | 5 | 3 | 2 | 0 | 12 | 8 | 1983-08-14 | W | 2026-06-07 07:03:20.900587 | 2026-06-07 07:03:20.900587 | 1 | International Results CSV 1 | h2h://154:107/1983-08-28 | |||
| 14935 | Madagascar 107 | Seychelles 201 | 1985-08-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.123771 | 2026-06-07 07:03:21.123772 | 1 | International Results CSV 1 | h2h://107:201/1985-08-28 | |||||
| 14936 | Madagascar 107 | Mauritius 108 | 1985-08-29 | 20 | 4 | 10 | 6 | 25 | 53 | 1983-07-10 | D | 2026-06-07 07:03:21.123974 | 2026-06-07 07:03:21.123975 | 1 | International Results CSV 1 | h2h://108:107/1985-08-29 | |||
| 15712 | Madagascar 107 | Seychelles 201 | 1987-06-18 | 1 | 1 | 0 | 0 | 1 | 0 | 1985-08-28 | W | 2026-06-07 07:03:21.587226 | 2026-06-07 07:03:21.587227 | 1 | International Results CSV 1 | h2h://107:201/1987-06-18 | |||
| 15719 | Madagascar 107 | Congo Republic 161 | 1987-06-21 | 2 | 1 | 1 | 0 | 9 | 7 | 1962-12-24 | L | 2026-06-07 07:03:21.588593 | 2026-06-07 07:03:21.588593 | 1 | International Results CSV 1 | h2h://107:161/1987-06-21 | |||
| 15757 | Madagascar 107 | Cameroon 140 | 1987-08-01 | 2 | 1 | 1 | 0 | 3 | 6 | 1981-08-30 | L | 2026-06-07 07:03:21.595861 | 2026-06-07 07:03:21.595862 | 1 | International Results CSV 1 | h2h://140:107/1987-08-01 | |||
| 15761 | Madagascar 107 | Tunisia 152 | 1987-08-03 | 1 | 0 | 1 | 0 | 1 | 2 | 1963-04-18 | W | 2026-06-07 07:03:21.596609 | 2026-06-07 07:03:21.596609 | 1 | International Results CSV 1 | h2h://152:107/1987-08-03 | |||
| 15772 | Madagascar 107 | Ivory Coast 158 | 1987-08-08 | 1 | 0 | 1 | 0 | 0 | 5 | 1965-07-20 | W | 2026-06-07 07:03:21.598682 | 2026-06-07 07:03:21.598683 | 1 | International Results CSV 1 | h2h://158:107/1987-08-08 | |||
| 17398 | Madagascar 107 | Angola 205 | 1990-08-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.910304 | 2026-06-07 07:03:21.910305 | 1 | International Results CSV 1 | h2h://205:107/1990-08-19 | |||||
| 17404 | Madagascar 107 | Comoros 213 | 1990-08-21 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.911445 | 2026-06-07 07:03:21.911445 | 1 | International Results CSV 1 | h2h://107:213/1990-08-21 | |||||
| 17411 | Madagascar 107 | Réunion 109 | 1990-08-25 | 16 | 13 | 3 | 0 | 49 | 27 | 1983-07-13 | W | 2026-06-07 07:03:21.912811 | 2026-06-07 07:03:21.912811 | 1 | International Results CSV 1 | h2h://107:109/1990-08-25 | |||
| 17416 | Madagascar 107 | Seychelles 201 | 1990-08-27 | 2 | 2 | 0 | 0 | 3 | 0 | 1987-06-18 | W | 2026-06-07 07:03:21.913756 | 2026-06-07 07:03:21.913756 | 1 | International Results CSV 1 | h2h://107:201/1990-08-27 | |||
| 17422 | Madagascar 107 | Mauritius 108 | 1990-08-30 | 21 | 4 | 11 | 6 | 26 | 56 | 1985-08-29 | L | 2026-06-07 07:03:21.914898 | 2026-06-07 07:03:21.914898 | 1 | International Results CSV 1 | h2h://107:108/1990-08-30 | |||
| 17671 | Madagascar 107 | Eswatini 188 | 1991-04-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.962571 | 2026-06-07 07:03:21.962571 | 1 | International Results CSV 1 | h2h://188:107/1991-04-14 | |||||
| 17707 | Madagascar 107 | Angola 205 | 1991-05-04 | 1 | 1 | 0 | 0 | 1 | 0 | 1990-08-19 | W | 2026-06-07 07:03:21.969470 | 2026-06-07 07:03:21.969470 | 1 | International Results CSV 1 | h2h://107:205/1991-05-04 | |||
| 18520 | Madagascar 107 | Namibia 231 | 1992-10-11 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.129721 | 2026-06-07 07:03:22.129721 | 1 | International Results CSV 1 | h2h://107:231/1992-10-11 | |||||
| 18712 | Madagascar 107 | Namibia 231 | 1993-01-17 | 1 | 1 | 0 | 0 | 3 | 0 | 1992-10-11 | L | 2026-06-07 07:03:22.167952 | 2026-06-07 07:03:22.167953 | 1 | International Results CSV 1 | h2h://231:107/1993-01-17 | |||
| 19292 | Madagascar 107 | Comoros 213 | 1993-08-20 | 1 | 1 | 0 | 0 | 1 | 0 | 1990-08-21 | W | 2026-06-07 07:03:22.283327 | 2026-06-07 07:03:22.283328 | 1 | International Results CSV 1 | h2h://107:213/1993-08-20 | |||
| 19300 | Madagascar 107 | Mauritius 108 | 1993-08-24 | 22 | 5 | 11 | 6 | 31 | 57 | 1990-08-30 | L | 2026-06-07 07:03:22.284918 | 2026-06-07 07:03:22.284918 | 1 | International Results CSV 1 | h2h://108:107/1993-08-24 | |||
| 19304 | Madagascar 107 | Seychelles 201 | 1993-08-26 | 3 | 3 | 0 | 0 | 9 | 0 | 1990-08-27 | L | 2026-06-07 07:03:22.285703 | 2026-06-07 07:03:22.285704 | 1 | International Results CSV 1 | h2h://201:107/1993-08-26 | |||
| 19311 | Madagascar 107 | Réunion 109 | 1993-08-29 | 17 | 13 | 3 | 1 | 49 | 27 | 1990-08-25 | D | 2026-06-07 07:03:22.287117 | 2026-06-07 07:03:22.287117 | 1 | International Results CSV 1 | h2h://107:109/1993-08-29 | |||
| 21016 | Madagascar 107 | Mauritius 108 | 1996-05-25 | 23 | 6 | 11 | 6 | 33 | 58 | 1993-08-24 | L | 2026-06-07 07:03:22.940001 | 2026-06-07 07:03:22.940001 | 1 | International Results CSV 1 | h2h://108:107/1996-05-25 | |||
| 22936 | Madagascar 107 | Eswatini 188 | 1998-08-02 | 1 | 1 | 0 | 0 | 1 | 0 | 1991-04-14 | L | 2026-06-07 07:03:23.308791 | 2026-06-07 07:03:23.308791 | 1 | International Results CSV 1 | h2h://188:107/1998-08-02 | |||
| 22939 | Madagascar 107 | Comoros 213 | 1998-08-07 | 2 | 2 | 0 | 0 | 6 | 0 | 1993-08-20 | W | 2026-06-07 07:03:23.309367 | 2026-06-07 07:03:23.309368 | 1 | International Results CSV 1 | h2h://107:213/1998-08-07 | |||
| 22944 | Madagascar 107 | Seychelles 201 | 1998-08-11 | 4 | 4 | 0 | 0 | 11 | 1 | 1993-08-26 | W | 2026-06-07 07:03:23.310315 | 2026-06-07 07:03:23.310315 | 1 | International Results CSV 1 | h2h://107:201/1998-08-11 | |||
| 22946 | Madagascar 107 | Mauritius 108 | 1998-08-13 | 24 | 6 | 11 | 7 | 33 | 58 | 1996-05-25 | D | 2026-06-07 07:03:23.310698 | 2026-06-07 07:03:23.310698 | 1 | International Results CSV 1 | h2h://107:108/1998-08-13 | |||
| 22955 | Madagascar 107 | Réunion 109 | 1998-08-15 | 18 | 14 | 3 | 1 | 50 | 27 | 1993-08-29 | L | 2026-06-07 07:03:23.312407 | 2026-06-07 07:03:23.312408 | 1 | International Results CSV 1 | h2h://109:107/1998-08-15 | |||
| 22981 | Madagascar 107 | Eswatini 188 | 1998-08-23 | 2 | 2 | 0 | 0 | 3 | 1 | 1998-08-02 | W | 2026-06-07 07:03:23.317290 | 2026-06-07 07:03:23.317290 | 1 | International Results CSV 1 | h2h://107:188/1998-08-23 | |||
| 23357 | Madagascar 107 | DR Congo 113 | 1999-02-28 | 3 | 0 | 2 | 1 | 3 | 11 | 1980-12-21 | L | 2026-06-07 07:03:23.388643 | 2026-06-07 07:03:23.388643 | 1 | International Results CSV 1 | h2h://107:113/1999-02-28 | |||
| 23456 | Madagascar 107 | DR Congo 113 | 1999-04-11 | 4 | 1 | 2 | 1 | 6 | 12 | 1999-02-28 | L | 2026-06-07 07:03:23.407422 | 2026-06-07 07:03:23.407422 | 1 | International Results CSV 1 | h2h://113:107/1999-04-11 | |||
| 24349 | Madagascar 107 | Gabon 160 | 2000-04-08 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.583078 | 2026-06-07 07:03:23.583078 | 1 | International Results CSV 1 | h2h://107:160/2000-04-08 | |||||
| 24402 | Madagascar 107 | Gabon 160 | 2000-04-22 | 1 | 1 | 0 | 0 | 2 | 0 | 2000-04-08 | L | 2026-06-07 07:03:23.593124 | 2026-06-07 07:03:23.593124 | 1 | International Results CSV 1 | h2h://160:107/2000-04-22 | |||
| 24622 | Madagascar 107 | DR Congo 113 | 2000-06-17 | 5 | 1 | 3 | 1 | 6 | 14 | 1999-04-11 | L | 2026-06-07 07:03:23.635435 | 2026-06-07 07:03:23.635436 | 1 | International Results CSV 1 | h2h://107:113/2000-06-17 | |||
| 24641 | Madagascar 107 | Mauritius 108 | 2000-06-20 | 25 | 7 | 11 | 7 | 35 | 58 | 1998-08-13 | W | 2026-06-07 07:03:23.639191 | 2026-06-07 07:03:23.639192 | 1 | International Results CSV 1 | h2h://107:108/2000-06-20 | |||
| 24654 | Madagascar 107 | Mauritius 108 | 2000-06-24 | 26 | 7 | 11 | 8 | 36 | 59 | 2000-06-20 | D | 2026-06-07 07:03:23.641758 | 2026-06-07 07:03:23.641758 | 1 | International Results CSV 1 | h2h://107:108/2000-06-24 | |||
| 24677 | Madagascar 107 | Botswana 189 | 2000-07-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.646352 | 2026-06-07 07:03:23.646353 | 1 | International Results CSV 1 | h2h://189:107/2000-07-01 | |||||
| 24706 | Madagascar 107 | Tunisia 152 | 2000-07-08 | 2 | 1 | 1 | 0 | 4 | 2 | 1987-08-03 | L | 2026-06-07 07:03:23.652168 | 2026-06-07 07:03:23.652168 | 1 | International Results CSV 1 | h2h://152:107/2000-07-08 | |||
| 24720 | Madagascar 107 | Botswana 189 | 2000-07-15 | 1 | 0 | 1 | 0 | 0 | 1 | 2000-07-01 | L | 2026-06-07 07:03:23.654945 | 2026-06-07 07:03:23.654946 | 1 | International Results CSV 1 | h2h://107:189/2000-07-15 | |||
| 24913 | Madagascar 107 | Nigeria 120 | 2000-10-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.693366 | 2026-06-07 07:03:23.693366 | 1 | International Results CSV 1 | h2h://107:120/2000-10-07 |
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)
);