h2h_record
220 rows where team_a_id = 108
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2940 | Mauritius 108 | Réunion 109 | 1947-05-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.458494 | 2026-06-07 07:03:18.458494 | 1 | International Results CSV 1 | h2h://108:109/1947-05-15 | |||||
| 3122 | Mauritius 108 | Réunion 109 | 1948-07-19 | 1 | 1 | 0 | 0 | 2 | 1 | 1947-05-15 | W | 2026-06-07 07:03:18.460086 | 2026-06-07 07:03:18.460086 | 1 | International Results CSV 1 | h2h://108:109/1948-07-19 | |||
| 3297 | Mauritius 108 | Réunion 109 | 1949-10-07 | 2 | 2 | 0 | 0 | 7 | 2 | 1948-07-19 | L | 2026-06-07 07:03:18.461592 | 2026-06-07 07:03:18.461592 | 1 | International Results CSV 1 | h2h://109:108/1949-10-07 | |||
| 3353 | Mauritius 108 | Réunion 109 | 1950-04-14 | 3 | 3 | 0 | 0 | 13 | 2 | 1949-10-07 | W | 2026-06-07 07:03:18.462114 | 2026-06-07 07:03:18.462114 | 1 | International Results CSV 1 | h2h://108:109/1950-04-14 | |||
| 3524 | Mauritius 108 | Réunion 109 | 1951-07-21 | 4 | 4 | 0 | 0 | 28 | 4 | 1950-04-14 | W | 2026-06-07 07:03:18.463576 | 2026-06-07 07:03:18.463576 | 1 | International Results CSV 1 | h2h://108:109/1951-07-21 | |||
| 3643 | Mauritius 108 | Réunion 109 | 1952-07-27 | 5 | 5 | 0 | 0 | 38 | 6 | 1951-07-21 | L | 2026-06-07 07:03:18.464633 | 2026-06-07 07:03:18.464633 | 1 | International Results CSV 1 | h2h://109:108/1952-07-27 | |||
| 3789 | Mauritius 108 | Réunion 109 | 1953-07-13 | 6 | 6 | 0 | 0 | 44 | 6 | 1952-07-27 | W | 2026-06-07 07:03:18.465887 | 2026-06-07 07:03:18.465887 | 1 | International Results CSV 1 | h2h://108:109/1953-07-13 | |||
| 3980 | Mauritius 108 | Réunion 109 | 1954-07-18 | 7 | 7 | 0 | 0 | 53 | 10 | 1953-07-13 | W | 2026-06-07 07:03:18.467536 | 2026-06-07 07:03:18.467536 | 1 | International Results CSV 1 | h2h://108:109/1954-07-18 | |||
| 4103 | Mauritius 108 | Réunion 109 | 1955-07-07 | 8 | 8 | 0 | 0 | 64 | 10 | 1954-07-18 | L | 2026-06-07 07:03:18.468681 | 2026-06-07 07:03:18.468681 | 1 | International Results CSV 1 | h2h://109:108/1955-07-07 | |||
| 4288 | Mauritius 108 | Réunion 109 | 1956-06-30 | 9 | 9 | 0 | 0 | 67 | 11 | 1955-07-07 | W | 2026-06-07 07:03:18.470337 | 2026-06-07 07:03:18.470337 | 1 | International Results CSV 1 | h2h://108:109/1956-06-30 | |||
| 4438 | Mauritius 108 | Réunion 109 | 1957-04-17 | 10 | 10 | 0 | 0 | 75 | 14 | 1956-06-30 | W | 2026-06-07 07:03:18.471699 | 2026-06-07 07:03:18.471699 | 1 | International Results CSV 1 | h2h://108:109/1957-04-17 | |||
| 4587 | Mauritius 108 | Réunion 109 | 1957-10-27 | 11 | 11 | 0 | 0 | 76 | 14 | 1957-04-17 | W | 2026-06-07 07:03:18.472993 | 2026-06-07 07:03:18.472993 | 1 | International Results CSV 1 | h2h://108:109/1957-10-27 | |||
| 4770 | Mauritius 108 | Réunion 109 | 1958-10-16 | 12 | 12 | 0 | 0 | 77 | 14 | 1957-10-27 | L | 2026-06-07 07:03:18.474590 | 2026-06-07 07:03:18.474590 | 1 | International Results CSV 1 | h2h://109:108/1958-10-16 | |||
| 5901 | Mauritius 108 | Réunion 109 | 1963-09-08 | 13 | 13 | 0 | 0 | 79 | 14 | 1958-10-16 | W | 2026-06-07 07:03:19.048941 | 2026-06-07 07:03:19.048941 | 1 | International Results CSV 1 | h2h://108:109/1963-09-08 | |||
| 7245 | Mauritius 108 | Ethiopia 112 | 1967-12-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.304146 | 2026-06-07 07:03:19.304147 | 1 | International Results CSV 1 | h2h://108:112/1967-12-06 | |||||
| 8098 | Mauritius 108 | Malawi 154 | 1970-07-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.468183 | 2026-06-07 07:03:19.468184 | 1 | International Results CSV 1 | h2h://154:108/1970-07-06 | |||||
| 8100 | Mauritius 108 | Malawi 154 | 1970-07-09 | 1 | 0 | 1 | 0 | 0 | 1 | 1970-07-06 | W | 2026-06-07 07:03:19.468571 | 2026-06-07 07:03:19.468571 | 1 | International Results CSV 1 | h2h://154:108/1970-07-09 | |||
| 9229 | Mauritius 108 | Lesotho 191 | 1973-04-08 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.691250 | 2026-06-07 07:03:19.691251 | 1 | International Results CSV 1 | h2h://191:108/1973-04-08 | |||||
| 9243 | Mauritius 108 | Lesotho 191 | 1973-04-22 | 1 | 0 | 0 | 1 | 0 | 0 | 1973-04-08 | D | 2026-06-07 07:03:19.694155 | 2026-06-07 07:03:19.694156 | 1 | International Results CSV 1 | h2h://108:191/1973-04-22 | |||
| 9357 | Mauritius 108 | Malawi 154 | 1973-07-06 | 2 | 0 | 1 | 1 | 0 | 1 | 1970-07-09 | D | 2026-06-07 07:03:19.716998 | 2026-06-07 07:03:19.716998 | 1 | International Results CSV 1 | h2h://154:108/1973-07-06 | |||
| 9358 | Mauritius 108 | Malawi 154 | 1973-07-08 | 3 | 0 | 2 | 1 | 1 | 5 | 1973-07-06 | W | 2026-06-07 07:03:19.717199 | 2026-06-07 07:03:19.717199 | 1 | International Results CSV 1 | h2h://154:108/1973-07-08 | |||
| 9366 | Mauritius 108 | Réunion 109 | 1973-07-15 | 14 | 13 | 1 | 0 | 79 | 16 | 1963-09-08 | L | 2026-06-07 07:03:19.718801 | 2026-06-07 07:03:19.718801 | 1 | International Results CSV 1 | h2h://108:109/1973-07-15 | |||
| 9615 | Mauritius 108 | Malawi 154 | 1974-01-13 | 4 | 0 | 3 | 1 | 1 | 6 | 1973-07-08 | L | 2026-06-07 07:03:19.768183 | 2026-06-07 07:03:19.768184 | 1 | International Results CSV 1 | h2h://108:154/1974-01-13 | |||
| 9616 | Mauritius 108 | Malawi 154 | 1974-01-17 | 5 | 1 | 3 | 1 | 5 | 7 | 1974-01-13 | W | 2026-06-07 07:03:19.768380 | 2026-06-07 07:03:19.768380 | 1 | International Results CSV 1 | h2h://108:154/1974-01-17 | |||
| 9620 | Mauritius 108 | Malawi 154 | 1974-01-20 | 6 | 2 | 3 | 1 | 7 | 8 | 1974-01-17 | W | 2026-06-07 07:03:19.769175 | 2026-06-07 07:03:19.769176 | 1 | International Results CSV 1 | h2h://108:154/1974-01-20 | |||
| 9644 | Mauritius 108 | Congo Republic 161 | 1974-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.773885 | 2026-06-07 07:03:19.773885 | 1 | International Results CSV 1 | h2h://161:108/1974-03-03 | |||||
| 9649 | Mauritius 108 | Guinea 172 | 1974-03-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.774872 | 2026-06-07 07:03:19.774872 | 1 | International Results CSV 1 | h2h://172:108/1974-03-05 | |||||
| 9655 | Mauritius 108 | DR Congo 113 | 1974-03-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.776046 | 2026-06-07 07:03:19.776046 | 1 | International Results CSV 1 | h2h://108:113/1974-03-07 | |||||
| 10003 | Mauritius 108 | Malawi 154 | 1975-01-29 | 7 | 2 | 3 | 2 | 9 | 10 | 1974-01-20 | D | 2026-06-07 07:03:20.152847 | 2026-06-07 07:03:20.152848 | 1 | International Results CSV 1 | h2h://154:108/1975-01-29 | |||
| 10005 | Mauritius 108 | Malawi 154 | 1975-01-31 | 8 | 2 | 4 | 2 | 9 | 11 | 1975-01-29 | W | 2026-06-07 07:03:20.153253 | 2026-06-07 07:03:20.153253 | 1 | International Results CSV 1 | h2h://154:108/1975-01-31 | |||
| 10007 | Mauritius 108 | Malawi 154 | 1975-02-02 | 9 | 2 | 4 | 3 | 10 | 12 | 1975-01-31 | D | 2026-06-07 07:03:20.153649 | 2026-06-07 07:03:20.153649 | 1 | International Results CSV 1 | h2h://154:108/1975-02-02 | |||
| 10580 | Mauritius 108 | Réunion 109 | 1976-07-02 | 15 | 13 | 1 | 1 | 80 | 17 | 1973-07-15 | D | 2026-06-07 07:03:20.264052 | 2026-06-07 07:03:20.264052 | 1 | International Results CSV 1 | h2h://109:108/1976-07-02 | |||
| 10686 | Mauritius 108 | Ethiopia 112 | 1976-10-10 | 1 | 0 | 1 | 0 | 0 | 2 | 1967-12-06 | W | 2026-06-07 07:03:20.284352 | 2026-06-07 07:03:20.284352 | 1 | International Results CSV 1 | h2h://112:108/1976-10-10 | |||
| 10712 | Mauritius 108 | Malawi 154 | 1976-10-24 | 10 | 2 | 5 | 3 | 10 | 15 | 1975-02-02 | W | 2026-06-07 07:03:20.289325 | 2026-06-07 07:03:20.289326 | 1 | International Results CSV 1 | h2h://154:108/1976-10-24 | |||
| 10809 | Mauritius 108 | Malawi 154 | 1977-01-28 | 11 | 2 | 5 | 4 | 11 | 16 | 1976-10-24 | D | 2026-06-07 07:03:20.307735 | 2026-06-07 07:03:20.307735 | 1 | International Results CSV 1 | h2h://108:154/1977-01-28 | |||
| 10841 | Mauritius 108 | Ethiopia 112 | 1977-02-17 | 2 | 0 | 2 | 0 | 0 | 5 | 1976-10-10 | L | 2026-06-07 07:03:20.313835 | 2026-06-07 07:03:20.313836 | 1 | International Results CSV 1 | h2h://108:112/1977-02-17 | |||
| 10891 | Mauritius 108 | Ethiopia 112 | 1977-03-13 | 3 | 0 | 3 | 0 | 2 | 8 | 1977-02-17 | W | 2026-06-07 07:03:20.323326 | 2026-06-07 07:03:20.323326 | 1 | International Results CSV 1 | h2h://112:108/1977-03-13 | |||
| 11098 | Mauritius 108 | Réunion 109 | 1977-09-18 | 16 | 14 | 1 | 1 | 82 | 17 | 1976-07-02 | L | 2026-06-07 07:03:20.362874 | 2026-06-07 07:03:20.362874 | 1 | International Results CSV 1 | h2h://109:108/1977-09-18 | |||
| 11102 | Mauritius 108 | Seychelles 201 | 1977-09-21 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.363669 | 2026-06-07 07:03:20.363670 | 1 | International Results CSV 1 | h2h://108:201/1977-09-21 | |||||
| 11347 | Mauritius 108 | Seychelles 201 | 1978-05-15 | 1 | 1 | 0 | 0 | 2 | 1 | 1977-09-21 | W | 2026-06-07 07:03:20.412311 | 2026-06-07 07:03:20.412311 | 1 | International Results CSV 1 | h2h://108:201/1978-05-15 | |||
| 11352 | Mauritius 108 | Réunion 109 | 1978-05-18 | 17 | 15 | 1 | 1 | 84 | 17 | 1977-09-18 | L | 2026-06-07 07:03:20.413324 | 2026-06-07 07:03:20.413324 | 1 | International Results CSV 1 | h2h://109:108/1978-05-18 | |||
| 11517 | Mauritius 108 | Réunion 109 | 1978-09-23 | 18 | 15 | 2 | 1 | 87 | 22 | 1978-05-18 | W | 2026-06-07 07:03:20.445978 | 2026-06-07 07:03:20.445978 | 1 | International Results CSV 1 | h2h://109:108/1978-09-23 | |||
| 11588 | Mauritius 108 | Lesotho 191 | 1978-12-03 | 2 | 1 | 0 | 1 | 5 | 1 | 1973-04-22 | W | 2026-06-07 07:03:20.460041 | 2026-06-07 07:03:20.460041 | 1 | International Results CSV 1 | h2h://108:191/1978-12-03 | |||
| 11610 | Mauritius 108 | Lesotho 191 | 1978-12-17 | 3 | 1 | 1 | 1 | 5 | 2 | 1978-12-03 | W | 2026-06-07 07:03:20.464384 | 2026-06-07 07:03:20.464384 | 1 | International Results CSV 1 | h2h://191:108/1978-12-17 | |||
| 11887 | Mauritius 108 | Comoros 213 | 1979-08-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.519286 | 2026-06-07 07:03:20.519286 | 1 | International Results CSV 1 | h2h://108:213/1979-08-26 | |||||
| 11891 | Mauritius 108 | Comoros 213 | 1979-08-28 | 1 | 1 | 0 | 0 | 3 | 0 | 1979-08-26 | L | 2026-06-07 07:03:20.520060 | 2026-06-07 07:03:20.520060 | 1 | International Results CSV 1 | h2h://213:108/1979-08-28 | |||
| 11909 | Mauritius 108 | Seychelles 201 | 1979-08-31 | 2 | 2 | 0 | 0 | 4 | 1 | 1978-05-15 | L | 2026-06-07 07:03:20.523557 | 2026-06-07 07:03:20.523557 | 1 | International Results CSV 1 | h2h://201:108/1979-08-31 | |||
| 12866 | Mauritius 108 | Réunion 109 | 1981-07-19 | 19 | 16 | 2 | 1 | 89 | 22 | 1978-09-23 | L | 2026-06-07 07:03:20.713556 | 2026-06-07 07:03:20.713557 | 1 | International Results CSV 1 | h2h://109:108/1981-07-19 | |||
| 13376 | Mauritius 108 | Réunion 109 | 1982-09-05 | 20 | 17 | 2 | 1 | 91 | 23 | 1981-07-19 | L | 2026-06-07 07:03:20.814912 | 2026-06-07 07:03:20.814913 | 1 | International Results CSV 1 | h2h://109:108/1982-09-05 | |||
| 13584 | Mauritius 108 | Ethiopia 112 | 1983-04-10 | 4 | 0 | 4 | 0 | 2 | 9 | 1977-03-13 | W | 2026-06-07 07:03:20.855982 | 2026-06-07 07:03:20.855982 | 1 | International Results CSV 1 | h2h://112:108/1983-04-10 | |||
| 13607 | Mauritius 108 | Ethiopia 112 | 1983-04-24 | 5 | 0 | 5 | 0 | 2 | 10 | 1983-04-10 | L | 2026-06-07 07:03:20.860502 | 2026-06-07 07:03:20.860502 | 1 | International Results CSV 1 | h2h://108:112/1983-04-24 | |||
| 13713 | Mauritius 108 | Seychelles 201 | 1983-07-03 | 3 | 2 | 0 | 1 | 5 | 2 | 1979-08-31 | D | 2026-06-07 07:03:20.881755 | 2026-06-07 07:03:20.881756 | 1 | International Results CSV 1 | h2h://201:108/1983-07-03 | |||
| 13723 | Mauritius 108 | Réunion 109 | 1983-07-16 | 21 | 17 | 2 | 2 | 92 | 24 | 1982-09-05 | D | 2026-06-07 07:03:20.883760 | 2026-06-07 07:03:20.883761 | 1 | International Results CSV 1 | h2h://109:108/1983-07-16 | |||
| 14187 | Mauritius 108 | Malawi 154 | 1984-07-15 | 12 | 3 | 5 | 4 | 14 | 18 | 1977-01-28 | W | 2026-06-07 07:03:20.975776 | 2026-06-07 07:03:20.975776 | 1 | International Results CSV 1 | h2h://108:154/1984-07-15 | |||
| 14200 | Mauritius 108 | Malawi 154 | 1984-07-28 | 13 | 3 | 6 | 4 | 14 | 19 | 1984-07-15 | W | 2026-06-07 07:03:20.978398 | 2026-06-07 07:03:20.978399 | 1 | International Results CSV 1 | h2h://154:108/1984-07-28 | |||
| 14285 | Mauritius 108 | Mozambique 203 | 1984-09-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.995133 | 2026-06-07 07:03:20.995139 | 1 | International Results CSV 1 | h2h://108:203/1984-09-16 | |||||
| 14311 | Mauritius 108 | Mozambique 203 | 1984-09-30 | 1 | 0 | 0 | 1 | 0 | 0 | 1984-09-16 | D | 2026-06-07 07:03:21.000321 | 2026-06-07 07:03:21.000321 | 1 | International Results CSV 1 | h2h://203:108/1984-09-30 | |||
| 14930 | Mauritius 108 | Seychelles 201 | 1985-08-27 | 4 | 3 | 0 | 1 | 7 | 3 | 1983-07-03 | W | 2026-06-07 07:03:21.122795 | 2026-06-07 07:03:21.122796 | 1 | International Results CSV 1 | h2h://108:201/1985-08-27 | |||
| 14939 | Mauritius 108 | Réunion 109 | 1985-08-31 | 22 | 17 | 2 | 3 | 93 | 25 | 1983-07-16 | D | 2026-06-07 07:03:21.124568 | 2026-06-07 07:03:21.124568 | 1 | International Results CSV 1 | h2h://108:109/1985-08-31 | |||
| 15325 | Mauritius 108 | Réunion 109 | 1986-06-06 | 23 | 17 | 2 | 4 | 97 | 29 | 1985-08-31 | D | 2026-06-07 07:03:21.513548 | 2026-06-07 07:03:21.513549 | 1 | International Results CSV 1 | h2h://108:109/1986-06-06 | |||
| 15345 | Mauritius 108 | Réunion 109 | 1986-06-13 | 24 | 17 | 3 | 4 | 97 | 30 | 1986-06-06 | W | 2026-06-07 07:03:21.517307 | 2026-06-07 07:03:21.517307 | 1 | International Results CSV 1 | h2h://109:108/1986-06-13 | |||
| 15619 | Mauritius 108 | Botswana 189 | 1987-03-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.569384 | 2026-06-07 07:03:21.569385 | 1 | International Results CSV 1 | h2h://189:108/1987-03-28 | |||||
| 16314 | Mauritius 108 | Seychelles 201 | 1988-10-02 | 5 | 4 | 0 | 1 | 10 | 4 | 1985-08-27 | W | 2026-06-07 07:03:21.702322 | 2026-06-07 07:03:21.702322 | 1 | International Results CSV 1 | h2h://108:201/1988-10-02 | |||
| 16328 | Mauritius 108 | Seychelles 201 | 1988-10-16 | 6 | 5 | 0 | 1 | 13 | 4 | 1988-10-02 | L | 2026-06-07 07:03:21.704991 | 2026-06-07 07:03:21.704991 | 1 | International Results CSV 1 | h2h://201:108/1988-10-16 | |||
| 17307 | Mauritius 108 | Namibia 231 | 1990-06-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.892866 | 2026-06-07 07:03:21.892867 | 1 | International Results CSV 1 | h2h://231:108/1990-06-07 | |||||
| 17312 | Mauritius 108 | Botswana 189 | 1990-06-10 | 1 | 0 | 0 | 1 | 0 | 0 | 1987-03-28 | D | 2026-06-07 07:03:21.893824 | 2026-06-07 07:03:21.893825 | 1 | International Results CSV 1 | h2h://189:108/1990-06-10 | |||
| 17412 | Mauritius 108 | Seychelles 201 | 1990-08-25 | 7 | 5 | 1 | 1 | 13 | 5 | 1988-10-16 | L | 2026-06-07 07:03:21.912999 | 2026-06-07 07:03:21.912999 | 1 | International Results CSV 1 | h2h://108:201/1990-08-25 | |||
| 17415 | Mauritius 108 | Comoros 213 | 1990-08-27 | 2 | 2 | 0 | 0 | 6 | 1 | 1979-08-28 | W | 2026-06-07 07:03:21.913568 | 2026-06-07 07:03:21.913568 | 1 | International Results CSV 1 | h2h://108:213/1990-08-27 | |||
| 17957 | Mauritius 108 | Tunisia 152 | 1991-09-22 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.017608 | 2026-06-07 07:03:22.017608 | 1 | International Results CSV 1 | h2h://108:152/1991-09-22 | |||||
| 17961 | Mauritius 108 | Mali 162 | 1991-09-24 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.018373 | 2026-06-07 07:03:22.018373 | 1 | International Results CSV 1 | h2h://162:108/1991-09-24 | |||||
| 17969 | Mauritius 108 | Cameroon 140 | 1991-09-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.019889 | 2026-06-07 07:03:22.019890 | 1 | International Results CSV 1 | h2h://140:108/1991-09-26 | |||||
| 18378 | Mauritius 108 | Lesotho 191 | 1992-08-08 | 4 | 2 | 1 | 1 | 7 | 3 | 1978-12-17 | L | 2026-06-07 07:03:22.101584 | 2026-06-07 07:03:22.101584 | 1 | International Results CSV 1 | h2h://191:108/1992-08-08 | |||
| 18380 | Mauritius 108 | Lesotho 191 | 1992-08-09 | 5 | 2 | 2 | 1 | 7 | 4 | 1992-08-08 | W | 2026-06-07 07:03:22.101973 | 2026-06-07 07:03:22.101973 | 1 | International Results CSV 1 | h2h://191:108/1992-08-09 | |||
| 19298 | Mauritius 108 | Comoros 213 | 1993-08-22 | 3 | 3 | 0 | 0 | 10 | 1 | 1990-08-27 | W | 2026-06-07 07:03:22.284520 | 2026-06-07 07:03:22.284520 | 1 | International Results CSV 1 | h2h://108:213/1993-08-22 | |||
| 19305 | Mauritius 108 | Réunion 109 | 1993-08-26 | 25 | 17 | 3 | 5 | 97 | 30 | 1986-06-13 | D | 2026-06-07 07:03:22.285907 | 2026-06-07 07:03:22.285907 | 1 | International Results CSV 1 | h2h://109:108/1993-08-26 | |||
| 19306 | Mauritius 108 | Seychelles 201 | 1993-08-28 | 8 | 6 | 1 | 1 | 15 | 5 | 1990-08-25 | L | 2026-06-07 07:03:22.286105 | 2026-06-07 07:03:22.286105 | 1 | International Results CSV 1 | h2h://201:108/1993-08-28 | |||
| 20003 | Mauritius 108 | Gabon 160 | 1994-11-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.746510 | 2026-06-07 07:03:22.746510 | 1 | International Results CSV 1 | h2h://160:108/1994-11-13 | |||||
| 20347 | Mauritius 108 | Gabon 160 | 1995-06-04 | 1 | 0 | 1 | 0 | 0 | 3 | 1994-11-13 | L | 2026-06-07 07:03:22.812168 | 2026-06-07 07:03:22.812168 | 1 | International Results CSV 1 | h2h://108:160/1995-06-04 | |||
| 21071 | Mauritius 108 | DR Congo 113 | 1996-06-02 | 1 | 0 | 1 | 0 | 1 | 4 | 1974-03-07 | L | 2026-06-07 07:03:22.950485 | 2026-06-07 07:03:22.950485 | 1 | International Results CSV 1 | h2h://108:113/1996-06-02 | |||
| 21131 | Mauritius 108 | DR Congo 113 | 1996-06-16 | 2 | 0 | 2 | 0 | 2 | 9 | 1996-06-02 | W | 2026-06-07 07:03:22.961917 | 2026-06-07 07:03:22.961917 | 1 | International Results CSV 1 | h2h://113:108/1996-06-16 | |||
| 21229 | Mauritius 108 | Seychelles 201 | 1996-08-11 | 9 | 7 | 1 | 1 | 21 | 7 | 1993-08-28 | W | 2026-06-07 07:03:22.980663 | 2026-06-07 07:03:22.980664 | 1 | International Results CSV 1 | h2h://108:201/1996-08-11 | |||
| 21253 | Mauritius 108 | Seychelles 201 | 1996-08-24 | 10 | 8 | 1 | 1 | 22 | 7 | 1996-08-11 | L | 2026-06-07 07:03:22.985271 | 2026-06-07 07:03:22.985271 | 1 | International Results CSV 1 | h2h://201:108/1996-08-24 | |||
| 21387 | Mauritius 108 | Malawi 154 | 1996-10-06 | 14 | 3 | 7 | 4 | 14 | 23 | 1984-07-28 | L | 2026-06-07 07:03:23.010960 | 2026-06-07 07:03:23.010960 | 1 | International Results CSV 1 | h2h://108:154/1996-10-06 | |||
| 21646 | Mauritius 108 | Mozambique 203 | 1997-01-26 | 2 | 0 | 1 | 1 | 0 | 3 | 1984-09-30 | W | 2026-06-07 07:03:23.060903 | 2026-06-07 07:03:23.060903 | 1 | International Results CSV 1 | h2h://203:108/1997-01-26 | |||
| 22084 | Mauritius 108 | Malawi 154 | 1997-06-21 | 15 | 3 | 8 | 4 | 15 | 25 | 1996-10-06 | W | 2026-06-07 07:03:23.145118 | 2026-06-07 07:03:23.145118 | 1 | International Results CSV 1 | h2h://154:108/1997-06-21 | |||
| 22171 | Mauritius 108 | Mozambique 203 | 1997-07-13 | 3 | 0 | 2 | 1 | 0 | 6 | 1997-01-26 | L | 2026-06-07 07:03:23.161920 | 2026-06-07 07:03:23.161921 | 1 | International Results CSV 1 | h2h://108:203/1997-07-13 | |||
| 22424 | Mauritius 108 | Eswatini 188 | 1997-11-02 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.210995 | 2026-06-07 07:03:23.210996 | 1 | International Results CSV 1 | h2h://188:108/1997-11-02 | |||||
| 22932 | Mauritius 108 | Lesotho 191 | 1998-08-02 | 6 | 2 | 2 | 2 | 9 | 6 | 1992-08-09 | D | 2026-06-07 07:03:23.308032 | 2026-06-07 07:03:23.308032 | 1 | International Results CSV 1 | h2h://191:108/1998-08-02 | |||
| 22938 | Mauritius 108 | Réunion 109 | 1998-08-07 | 26 | 17 | 4 | 5 | 97 | 31 | 1993-08-26 | W | 2026-06-07 07:03:23.309178 | 2026-06-07 07:03:23.309179 | 1 | International Results CSV 1 | h2h://109:108/1998-08-07 | |||
| 22943 | Mauritius 108 | Réunion 109 | 1998-08-11 | 27 | 17 | 5 | 5 | 97 | 35 | 1998-08-07 | W | 2026-06-07 07:03:23.310121 | 2026-06-07 07:03:23.310121 | 1 | International Results CSV 1 | h2h://109:108/1998-08-11 | |||
| 22954 | Mauritius 108 | Seychelles 201 | 1998-08-15 | 11 | 8 | 1 | 2 | 23 | 8 | 1996-08-24 | D | 2026-06-07 07:03:23.312214 | 2026-06-07 07:03:23.312215 | 1 | International Results CSV 1 | h2h://108:201/1998-08-15 | |||
| 22980 | Mauritius 108 | Lesotho 191 | 1998-08-23 | 7 | 2 | 2 | 3 | 10 | 7 | 1998-08-02 | D | 2026-06-07 07:03:23.317097 | 2026-06-07 07:03:23.317097 | 1 | International Results CSV 1 | h2h://108:191/1998-08-23 | |||
| 23095 | Mauritius 108 | Gabon 160 | 1998-10-04 | 2 | 0 | 2 | 0 | 0 | 6 | 1995-06-04 | W | 2026-06-07 07:03:23.338901 | 2026-06-07 07:03:23.338901 | 1 | International Results CSV 1 | h2h://160:108/1998-10-04 | |||
| 23348 | Mauritius 108 | Angola 205 | 1999-02-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.386914 | 2026-06-07 07:03:23.386915 | 1 | International Results CSV 1 | h2h://205:108/1999-02-28 | |||||
| 23452 | Mauritius 108 | Angola 205 | 1999-04-10 | 1 | 1 | 0 | 0 | 2 | 0 | 1999-02-28 | W | 2026-06-07 07:03:23.406661 | 2026-06-07 07:03:23.406661 | 1 | International Results CSV 1 | h2h://108:205/1999-04-10 | |||
| 23530 | Mauritius 108 | Lesotho 191 | 1999-05-30 | 8 | 3 | 2 | 3 | 13 | 8 | 1998-08-23 | L | 2026-06-07 07:03:23.421485 | 2026-06-07 07:03:23.421486 | 1 | International Results CSV 1 | h2h://191:108/1999-05-30 | |||
| 23635 | Mauritius 108 | Gabon 160 | 1999-06-20 | 3 | 0 | 3 | 0 | 0 | 8 | 1998-10-04 | L | 2026-06-07 07:03:23.441413 | 2026-06-07 07:03:23.441413 | 1 | International Results CSV 1 | h2h://108:160/1999-06-20 | |||
| 23931 | Mauritius 108 | Hong Kong 134 | 1999-10-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.499982 | 2026-06-07 07:03:23.499982 | 1 | International Results CSV 1 | h2h://134:108/1999-10-12 | |||||
| 24860 | Mauritius 108 | Liberia 169 | 2000-09-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.682891 | 2026-06-07 07:03:23.682891 | 1 | International Results CSV 1 | h2h://169:108/2000-09-03 | |||||
| 24936 | Mauritius 108 | Congo Republic 161 | 2000-10-08 | 1 | 0 | 1 | 0 | 0 | 2 | 1974-03-03 | L | 2026-06-07 07:03:23.697952 | 2026-06-07 07:03:23.697952 | 1 | International Results CSV 1 | h2h://108:161/2000-10-08 |
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)
);