h2h_record
216 rows where team_a_id = 126
This data as json, CSV (advanced)
Suggested facets: team_b_id, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3815 | New Caledonia 126 | Tahiti 132 | 1953-09-20 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.466103 | 2026-06-07 07:03:18.466103 | 1 | International Results CSV 1 | h2h://126:132/1953-09-20 | |||||
| 3817 | New Caledonia 126 | Tahiti 132 | 1953-09-23 | 1 | 1 | 0 | 0 | 5 | 0 | 1953-09-20 | W | 2026-06-07 07:03:18.466117 | 2026-06-07 07:03:18.466117 | 1 | International Results CSV 1 | h2h://126:132/1953-09-23 | |||
| 3819 | New Caledonia 126 | Tahiti 132 | 1953-09-26 | 2 | 2 | 0 | 0 | 9 | 1 | 1953-09-23 | W | 2026-06-07 07:03:18.466131 | 2026-06-07 07:03:18.466131 | 1 | International Results CSV 1 | h2h://126:132/1953-09-26 | |||
| 4105 | New Caledonia 126 | Tahiti 132 | 1955-07-12 | 3 | 3 | 0 | 0 | 13 | 2 | 1953-09-26 | L | 2026-06-07 07:03:18.468697 | 2026-06-07 07:03:18.468697 | 1 | International Results CSV 1 | h2h://132:126/1955-07-12 | |||
| 4553 | New Caledonia 126 | Tahiti 132 | 1957-09-15 | 4 | 3 | 0 | 1 | 14 | 3 | 1955-07-12 | D | 2026-06-07 07:03:18.472669 | 2026-06-07 07:03:18.472669 | 1 | International Results CSV 1 | h2h://126:132/1957-09-15 | |||
| 4556 | New Caledonia 126 | Tahiti 132 | 1957-09-18 | 5 | 3 | 1 | 1 | 16 | 7 | 1957-09-15 | L | 2026-06-07 07:03:18.472696 | 2026-06-07 07:03:18.472696 | 1 | International Results CSV 1 | h2h://126:132/1957-09-18 | |||
| 4563 | New Caledonia 126 | Tahiti 132 | 1957-09-27 | 6 | 4 | 1 | 1 | 18 | 8 | 1957-09-18 | W | 2026-06-07 07:03:18.472761 | 2026-06-07 07:03:18.472761 | 1 | International Results CSV 1 | h2h://126:132/1957-09-27 | |||
| 4885 | New Caledonia 126 | Tahiti 132 | 1959-07-21 | 7 | 5 | 1 | 1 | 20 | 8 | 1957-09-27 | L | 2026-06-07 07:03:18.475635 | 2026-06-07 07:03:18.475635 | 1 | International Results CSV 1 | h2h://132:126/1959-07-21 | |||
| 4886 | New Caledonia 126 | Tahiti 132 | 1959-07-22 | 8 | 6 | 1 | 1 | 24 | 10 | 1959-07-21 | L | 2026-06-07 07:03:18.475643 | 2026-06-07 07:03:18.475643 | 1 | International Results CSV 1 | h2h://132:126/1959-07-22 | |||
| 5324 | New Caledonia 126 | Tahiti 132 | 1961-09-05 | 9 | 6 | 2 | 1 | 25 | 13 | 1959-07-22 | L | 2026-06-07 07:03:18.938108 | 2026-06-07 07:03:18.938108 | 1 | International Results CSV 1 | h2h://126:132/1961-09-05 | |||
| 5325 | New Caledonia 126 | Tahiti 132 | 1961-09-08 | 10 | 6 | 2 | 2 | 27 | 15 | 1961-09-05 | D | 2026-06-07 07:03:18.938303 | 2026-06-07 07:03:18.938303 | 1 | International Results CSV 1 | h2h://126:132/1961-09-08 | |||
| 5330 | New Caledonia 126 | Tahiti 132 | 1961-09-22 | 11 | 7 | 2 | 2 | 30 | 15 | 1961-09-08 | W | 2026-06-07 07:03:18.939257 | 2026-06-07 07:03:18.939257 | 1 | International Results CSV 1 | h2h://126:132/1961-09-22 | |||
| 5894 | New Caledonia 126 | Tahiti 132 | 1963-09-01 | 12 | 8 | 2 | 2 | 32 | 16 | 1961-09-22 | W | 2026-06-07 07:03:19.047629 | 2026-06-07 07:03:19.047629 | 1 | International Results CSV 1 | h2h://126:132/1963-09-01 | |||
| 5900 | New Caledonia 126 | Fiji 128 | 1963-09-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.048751 | 2026-06-07 07:03:19.048752 | 1 | International Results CSV 1 | h2h://128:126/1963-09-06 | |||||
| 6114 | New Caledonia 126 | Tahiti 132 | 1964-09-10 | 13 | 9 | 2 | 2 | 34 | 17 | 1963-09-01 | L | 2026-06-07 07:03:19.089679 | 2026-06-07 07:03:19.089680 | 1 | International Results CSV 1 | h2h://132:126/1964-09-10 | |||
| 6123 | New Caledonia 126 | Tahiti 132 | 1964-09-27 | 14 | 10 | 2 | 2 | 36 | 17 | 1964-09-10 | L | 2026-06-07 07:03:19.091414 | 2026-06-07 07:03:19.091414 | 1 | International Results CSV 1 | h2h://132:126/1964-09-27 | |||
| 6436 | New Caledonia 126 | Tahiti 132 | 1965-09-11 | 15 | 10 | 3 | 2 | 37 | 21 | 1964-09-27 | L | 2026-06-07 07:03:19.150702 | 2026-06-07 07:03:19.150703 | 1 | International Results CSV 1 | h2h://126:132/1965-09-11 | |||
| 6438 | New Caledonia 126 | Tahiti 132 | 1965-09-13 | 16 | 11 | 3 | 2 | 41 | 22 | 1965-09-11 | W | 2026-06-07 07:03:19.151078 | 2026-06-07 07:03:19.151078 | 1 | International Results CSV 1 | h2h://126:132/1965-09-13 | |||
| 6868 | New Caledonia 126 | Vanuatu 127 | 1966-12-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.232689 | 2026-06-07 07:03:19.232689 | 1 | International Results CSV 1 | h2h://126:127/1966-12-12 | |||||
| 6869 | New Caledonia 126 | Solomon Islands 177 | 1966-12-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.232874 | 2026-06-07 07:03:19.232874 | 1 | International Results CSV 1 | h2h://126:177/1966-12-12 | |||||
| 6881 | New Caledonia 126 | Papua New Guinea 176 | 1966-12-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.235123 | 2026-06-07 07:03:19.235123 | 1 | International Results CSV 1 | h2h://126:176/1966-12-15 | |||||
| 6887 | New Caledonia 126 | Tahiti 132 | 1966-12-17 | 17 | 12 | 3 | 2 | 43 | 23 | 1965-09-13 | W | 2026-06-07 07:03:19.236260 | 2026-06-07 07:03:19.236261 | 1 | International Results CSV 1 | h2h://126:132/1966-12-17 | |||
| 7443 | New Caledonia 126 | Fiji 128 | 1968-09-19 | 1 | 1 | 0 | 0 | 8 | 2 | 1963-09-06 | W | 2026-06-07 07:03:19.341702 | 2026-06-07 07:03:19.341703 | 1 | International Results CSV 1 | h2h://126:128/1968-09-19 | |||
| 7552 | New Caledonia 126 | Tahiti 132 | 1968-12-09 | 18 | 12 | 4 | 2 | 43 | 25 | 1966-12-17 | L | 2026-06-07 07:03:19.362362 | 2026-06-07 07:03:19.362362 | 1 | International Results CSV 1 | h2h://126:132/1968-12-09 | |||
| 7563 | New Caledonia 126 | Tahiti 132 | 1968-12-15 | 19 | 12 | 5 | 2 | 43 | 26 | 1968-12-09 | L | 2026-06-07 07:03:19.364424 | 2026-06-07 07:03:19.364424 | 1 | International Results CSV 1 | h2h://126:132/1968-12-15 | |||
| 7748 | New Caledonia 126 | Papua New Guinea 176 | 1969-08-14 | 1 | 1 | 0 | 0 | 4 | 0 | 1966-12-15 | L | 2026-06-07 07:03:19.399832 | 2026-06-07 07:03:19.399832 | 1 | International Results CSV 1 | h2h://176:126/1969-08-14 | |||
| 7750 | New Caledonia 126 | Solomon Islands 177 | 1969-08-15 | 1 | 1 | 0 | 0 | 8 | 0 | 1966-12-12 | W | 2026-06-07 07:03:19.400214 | 2026-06-07 07:03:19.400214 | 1 | International Results CSV 1 | h2h://126:177/1969-08-15 | |||
| 7755 | New Caledonia 126 | Vanuatu 127 | 1969-08-16 | 1 | 1 | 0 | 0 | 5 | 0 | 1966-12-12 | W | 2026-06-07 07:03:19.401150 | 2026-06-07 07:03:19.401151 | 1 | International Results CSV 1 | h2h://126:127/1969-08-16 | |||
| 7759 | New Caledonia 126 | Fiji 128 | 1969-08-18 | 2 | 2 | 0 | 0 | 10 | 3 | 1968-09-19 | L | 2026-06-07 07:03:19.401909 | 2026-06-07 07:03:19.401909 | 1 | International Results CSV 1 | h2h://128:126/1969-08-18 | |||
| 7766 | New Caledonia 126 | Tahiti 132 | 1969-08-22 | 20 | 12 | 5 | 3 | 44 | 27 | 1968-12-15 | D | 2026-06-07 07:03:19.403239 | 2026-06-07 07:03:19.403239 | 1 | International Results CSV 1 | h2h://126:132/1969-08-22 | |||
| 8102 | New Caledonia 126 | Tahiti 132 | 1970-07-11 | 21 | 13 | 5 | 3 | 46 | 28 | 1969-08-22 | L | 2026-06-07 07:03:19.468960 | 2026-06-07 07:03:19.468960 | 1 | International Results CSV 1 | h2h://132:126/1970-07-11 | |||
| 8103 | New Caledonia 126 | Tahiti 132 | 1970-07-18 | 22 | 13 | 6 | 3 | 47 | 31 | 1970-07-11 | W | 2026-06-07 07:03:19.469161 | 2026-06-07 07:03:19.469161 | 1 | International Results CSV 1 | h2h://132:126/1970-07-18 | |||
| 8535 | New Caledonia 126 | Fiji 128 | 1971-09-09 | 3 | 3 | 0 | 0 | 21 | 3 | 1969-08-18 | L | 2026-06-07 07:03:19.554405 | 2026-06-07 07:03:19.554405 | 1 | International Results CSV 1 | h2h://128:126/1971-09-09 | |||
| 8543 | New Caledonia 126 | Vanuatu 127 | 1971-09-13 | 2 | 2 | 0 | 0 | 7 | 0 | 1969-08-16 | W | 2026-06-07 07:03:19.555963 | 2026-06-07 07:03:19.555964 | 1 | International Results CSV 1 | h2h://126:127/1971-09-13 | |||
| 8548 | New Caledonia 126 | Papua New Guinea 176 | 1971-09-16 | 2 | 2 | 0 | 0 | 8 | 1 | 1969-08-14 | W | 2026-06-07 07:03:19.556939 | 2026-06-07 07:03:19.556939 | 1 | International Results CSV 1 | h2h://126:176/1971-09-16 | |||
| 8553 | New Caledonia 126 | Vanuatu 127 | 1971-09-18 | 3 | 2 | 0 | 1 | 7 | 0 | 1971-09-13 | D | 2026-06-07 07:03:19.557916 | 2026-06-07 07:03:19.557916 | 1 | International Results CSV 1 | h2h://126:127/1971-09-18 | |||
| 9173 | New Caledonia 126 | Tahiti 132 | 1973-02-17 | 23 | 14 | 6 | 3 | 49 | 31 | 1970-07-18 | W | 2026-06-07 07:03:19.680239 | 2026-06-07 07:03:19.680239 | 1 | International Results CSV 1 | h2h://126:132/1973-02-17 | |||
| 9177 | New Caledonia 126 | Vanuatu 127 | 1973-02-18 | 4 | 3 | 0 | 1 | 14 | 1 | 1971-09-18 | W | 2026-06-07 07:03:19.681003 | 2026-06-07 07:03:19.681003 | 1 | International Results CSV 1 | h2h://126:127/1973-02-18 | |||
| 9179 | New Caledonia 126 | Fiji 128 | 1973-02-20 | 4 | 4 | 0 | 0 | 26 | 4 | 1971-09-09 | L | 2026-06-07 07:03:19.681399 | 2026-06-07 07:03:19.681399 | 1 | International Results CSV 1 | h2h://128:126/1973-02-20 | |||
| 9187 | New Caledonia 126 | Vanuatu 127 | 1973-02-24 | 5 | 4 | 0 | 1 | 18 | 2 | 1973-02-18 | W | 2026-06-07 07:03:19.682964 | 2026-06-07 07:03:19.682964 | 1 | International Results CSV 1 | h2h://126:127/1973-02-24 | |||
| 9630 | New Caledonia 126 | Tahiti 132 | 1974-02-17 | 24 | 14 | 7 | 3 | 50 | 33 | 1973-02-17 | W | 2026-06-07 07:03:19.771148 | 2026-06-07 07:03:19.771148 | 1 | International Results CSV 1 | h2h://132:126/1974-02-17 | |||
| 9632 | New Caledonia 126 | Tahiti 132 | 1974-02-20 | 25 | 15 | 7 | 3 | 52 | 34 | 1974-02-17 | L | 2026-06-07 07:03:19.771541 | 2026-06-07 07:03:19.771541 | 1 | International Results CSV 1 | h2h://132:126/1974-02-20 | |||
| 10215 | New Caledonia 126 | Tahiti 132 | 1975-08-02 | 26 | 15 | 7 | 4 | 54 | 36 | 1974-02-20 | D | 2026-06-07 07:03:20.194168 | 2026-06-07 07:03:20.194168 | 1 | International Results CSV 1 | h2h://126:132/1975-08-02 | |||
| 10224 | New Caledonia 126 | Vanuatu 127 | 1975-08-04 | 6 | 5 | 0 | 1 | 20 | 3 | 1973-02-24 | W | 2026-06-07 07:03:20.195864 | 2026-06-07 07:03:20.195864 | 1 | International Results CSV 1 | h2h://126:127/1975-08-04 | |||
| 10228 | New Caledonia 126 | Papua New Guinea 176 | 1975-08-05 | 3 | 3 | 0 | 0 | 12 | 1 | 1971-09-16 | W | 2026-06-07 07:03:20.196622 | 2026-06-07 07:03:20.196623 | 1 | International Results CSV 1 | h2h://126:176/1975-08-05 | |||
| 10241 | New Caledonia 126 | Solomon Islands 177 | 1975-08-07 | 2 | 1 | 0 | 1 | 9 | 1 | 1969-08-15 | D | 2026-06-07 07:03:20.199084 | 2026-06-07 07:03:20.199085 | 1 | International Results CSV 1 | h2h://126:177/1975-08-07 | |||
| 10247 | New Caledonia 126 | Tahiti 132 | 1975-08-09 | 27 | 16 | 7 | 4 | 57 | 36 | 1975-08-02 | W | 2026-06-07 07:03:20.200243 | 2026-06-07 07:03:20.200243 | 1 | International Results CSV 1 | h2h://126:132/1975-08-09 | |||
| 11478 | New Caledonia 126 | Tahiti 132 | 1978-08-13 | 28 | 16 | 8 | 4 | 58 | 38 | 1975-08-09 | L | 2026-06-07 07:03:20.438312 | 2026-06-07 07:03:20.438312 | 1 | International Results CSV 1 | h2h://126:132/1978-08-13 | |||
| 11481 | New Caledonia 126 | Tahiti 132 | 1978-08-20 | 29 | 17 | 8 | 4 | 60 | 38 | 1978-08-13 | W | 2026-06-07 07:03:20.438912 | 2026-06-07 07:03:20.438913 | 1 | International Results CSV 1 | h2h://126:132/1978-08-20 | |||
| 11903 | New Caledonia 126 | Guam 204 | 1979-08-30 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.522401 | 2026-06-07 07:03:20.522401 | 1 | International Results CSV 1 | h2h://204:126/1979-08-30 | |||||
| 11908 | New Caledonia 126 | Vanuatu 127 | 1979-08-31 | 7 | 6 | 0 | 1 | 23 | 4 | 1975-08-04 | W | 2026-06-07 07:03:20.523365 | 2026-06-07 07:03:20.523365 | 1 | International Results CSV 1 | h2h://126:127/1979-08-31 | |||
| 11916 | New Caledonia 126 | Tuvalu 217 | 1979-09-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.524917 | 2026-06-07 07:03:20.524917 | 1 | International Results CSV 1 | h2h://126:217/1979-09-03 | |||||
| 11919 | New Caledonia 126 | Tahiti 132 | 1979-09-04 | 30 | 17 | 9 | 4 | 63 | 42 | 1978-08-20 | L | 2026-06-07 07:03:20.525509 | 2026-06-07 07:03:20.525509 | 1 | International Results CSV 1 | h2h://126:132/1979-09-04 | |||
| 11932 | New Caledonia 126 | Solomon Islands 177 | 1979-09-07 | 3 | 2 | 0 | 1 | 13 | 1 | 1975-08-07 | W | 2026-06-07 07:03:20.528083 | 2026-06-07 07:03:20.528083 | 1 | International Results CSV 1 | h2h://126:177/1979-09-07 | |||
| 12118 | New Caledonia 126 | Vanuatu 127 | 1980-02-26 | 8 | 7 | 0 | 1 | 26 | 4 | 1979-08-31 | W | 2026-06-07 07:03:20.565144 | 2026-06-07 07:03:20.565144 | 1 | International Results CSV 1 | h2h://126:127/1980-02-26 | |||
| 12127 | New Caledonia 126 | Papua New Guinea 176 | 1980-02-28 | 4 | 4 | 0 | 0 | 17 | 2 | 1975-08-05 | W | 2026-06-07 07:03:20.566893 | 2026-06-07 07:03:20.566893 | 1 | International Results CSV 1 | h2h://126:176/1980-02-28 | |||
| 12132 | New Caledonia 126 | Fiji 128 | 1980-03-01 | 5 | 5 | 0 | 0 | 28 | 4 | 1973-02-20 | W | 2026-06-07 07:03:20.567861 | 2026-06-07 07:03:20.567861 | 1 | International Results CSV 1 | h2h://126:128/1980-03-01 | |||
| 12830 | New Caledonia 126 | Tahiti 132 | 1981-07-07 | 31 | 17 | 10 | 4 | 65 | 45 | 1979-09-04 | W | 2026-06-07 07:03:20.706411 | 2026-06-07 07:03:20.706412 | 1 | International Results CSV 1 | h2h://132:126/1981-07-07 | |||
| 12834 | New Caledonia 126 | Vanuatu 127 | 1981-07-08 | 9 | 8 | 0 | 1 | 30 | 7 | 1980-02-26 | L | 2026-06-07 07:03:20.707207 | 2026-06-07 07:03:20.707207 | 1 | International Results CSV 1 | h2h://127:126/1981-07-08 | |||
| 12836 | New Caledonia 126 | Solomon Islands 177 | 1981-07-09 | 4 | 2 | 1 | 1 | 14 | 4 | 1979-09-07 | W | 2026-06-07 07:03:20.707600 | 2026-06-07 07:03:20.707600 | 1 | International Results CSV 1 | h2h://177:126/1981-07-09 | |||
| 12842 | New Caledonia 126 | Papua New Guinea 176 | 1981-07-10 | 5 | 5 | 0 | 0 | 25 | 2 | 1980-02-28 | W | 2026-06-07 07:03:20.708789 | 2026-06-07 07:03:20.708790 | 1 | International Results CSV 1 | h2h://126:176/1981-07-10 | |||
| 12850 | New Caledonia 126 | Fiji 128 | 1981-07-13 | 6 | 6 | 0 | 0 | 30 | 5 | 1980-03-01 | W | 2026-06-07 07:03:20.710385 | 2026-06-07 07:03:20.710385 | 1 | International Results CSV 1 | h2h://126:128/1981-07-13 | |||
| 12854 | New Caledonia 126 | Samoa 218 | 1981-07-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.711173 | 2026-06-07 07:03:20.711173 | 1 | International Results CSV 1 | h2h://126:218/1981-07-14 | |||||
| 12859 | New Caledonia 126 | Tahiti 132 | 1981-07-15 | 32 | 17 | 11 | 4 | 65 | 46 | 1981-07-07 | W | 2026-06-07 07:03:20.712168 | 2026-06-07 07:03:20.712169 | 1 | International Results CSV 1 | h2h://132:126/1981-07-15 | |||
| 13832 | New Caledonia 126 | Vanuatu 127 | 1983-09-11 | 10 | 8 | 0 | 2 | 32 | 9 | 1981-07-08 | D | 2026-06-07 07:03:20.905404 | 2026-06-07 07:03:20.905404 | 1 | International Results CSV 1 | h2h://126:127/1983-09-11 | |||
| 13833 | New Caledonia 126 | Solomon Islands 177 | 1983-09-11 | 5 | 2 | 1 | 2 | 15 | 5 | 1981-07-09 | D | 2026-06-07 07:03:20.905600 | 2026-06-07 07:03:20.905601 | 1 | International Results CSV 1 | h2h://126:177/1983-09-11 | |||
| 13834 | New Caledonia 126 | Fiji 128 | 1983-09-13 | 7 | 7 | 0 | 0 | 33 | 5 | 1981-07-13 | L | 2026-06-07 07:03:20.905796 | 2026-06-07 07:03:20.905796 | 1 | International Results CSV 1 | h2h://128:126/1983-09-13 | |||
| 13836 | New Caledonia 126 | Fiji 128 | 1983-09-14 | 8 | 7 | 1 | 0 | 34 | 10 | 1983-09-13 | W | 2026-06-07 07:03:20.906203 | 2026-06-07 07:03:20.906204 | 1 | International Results CSV 1 | h2h://128:126/1983-09-14 | |||
| 13838 | New Caledonia 126 | Wallis Islands and Futuna 185 | 1983-09-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.906594 | 2026-06-07 07:03:20.906594 | 1 | International Results CSV 1 | h2h://126:185/1983-09-14 | |||||
| 13842 | New Caledonia 126 | Papua New Guinea 176 | 1983-09-15 | 6 | 6 | 0 | 0 | 30 | 3 | 1981-07-10 | W | 2026-06-07 07:03:20.907375 | 2026-06-07 07:03:20.907375 | 1 | International Results CSV 1 | h2h://126:176/1983-09-15 | |||
| 15673 | New Caledonia 126 | Tahiti 132 | 1987-05-12 | 33 | 17 | 12 | 4 | 65 | 47 | 1981-07-15 | L | 2026-06-07 07:03:21.579773 | 2026-06-07 07:03:21.579774 | 1 | International Results CSV 1 | h2h://126:132/1987-05-12 | |||
| 15883 | New Caledonia 126 | American Samoa 224 | 1987-12-09 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.620008 | 2026-06-07 07:03:21.620009 | 1 | International Results CSV 1 | h2h://126:224/1987-12-09 | |||||
| 15891 | New Caledonia 126 | Papua New Guinea 176 | 1987-12-10 | 7 | 7 | 0 | 0 | 32 | 4 | 1983-09-15 | W | 2026-06-07 07:03:21.621505 | 2026-06-07 07:03:21.621505 | 1 | International Results CSV 1 | h2h://126:176/1987-12-10 | |||
| 15897 | New Caledonia 126 | Tahiti 132 | 1987-12-12 | 34 | 17 | 12 | 5 | 65 | 47 | 1987-05-12 | D | 2026-06-07 07:03:21.622645 | 2026-06-07 07:03:21.622646 | 1 | International Results CSV 1 | h2h://126:132/1987-12-12 | |||
| 15909 | New Caledonia 126 | Wallis Islands and Futuna 185 | 1987-12-15 | 1 | 1 | 0 | 0 | 4 | 0 | 1983-09-14 | W | 2026-06-07 07:03:21.624916 | 2026-06-07 07:03:21.624916 | 1 | International Results CSV 1 | h2h://126:185/1987-12-15 | |||
| 15921 | New Caledonia 126 | Vanuatu 127 | 1987-12-17 | 11 | 9 | 0 | 2 | 38 | 11 | 1983-09-11 | W | 2026-06-07 07:03:21.627274 | 2026-06-07 07:03:21.627275 | 1 | International Results CSV 1 | h2h://126:127/1987-12-17 | |||
| 15926 | New Caledonia 126 | Tahiti 132 | 1987-12-19 | 35 | 17 | 13 | 5 | 67 | 50 | 1987-12-12 | L | 2026-06-07 07:03:21.628244 | 2026-06-07 07:03:21.628245 | 1 | International Results CSV 1 | h2h://126:132/1987-12-19 | |||
| 16352 | New Caledonia 126 | Vanuatu 127 | 1988-10-23 | 12 | 10 | 0 | 2 | 44 | 11 | 1987-12-17 | W | 2026-06-07 07:03:21.709580 | 2026-06-07 07:03:21.709581 | 1 | International Results CSV 1 | h2h://126:127/1988-10-23 | |||
| 16354 | New Caledonia 126 | Solomon Islands 177 | 1988-10-24 | 6 | 3 | 1 | 2 | 16 | 5 | 1983-09-11 | L | 2026-06-07 07:03:21.709960 | 2026-06-07 07:03:21.709960 | 1 | International Results CSV 1 | h2h://177:126/1988-10-24 | |||
| 16356 | New Caledonia 126 | Fiji 128 | 1988-10-25 | 9 | 7 | 2 | 0 | 36 | 13 | 1983-09-14 | W | 2026-06-07 07:03:21.710365 | 2026-06-07 07:03:21.710365 | 1 | International Results CSV 1 | h2h://128:126/1988-10-25 | |||
| 16359 | New Caledonia 126 | Vanuatu 127 | 1988-10-26 | 13 | 11 | 0 | 2 | 50 | 12 | 1988-10-23 | W | 2026-06-07 07:03:21.710947 | 2026-06-07 07:03:21.710947 | 1 | International Results CSV 1 | h2h://126:127/1988-10-26 | |||
| 17027 | New Caledonia 126 | Solomon Islands 177 | 1989-10-30 | 7 | 3 | 2 | 2 | 16 | 6 | 1988-10-24 | L | 2026-06-07 07:03:21.839305 | 2026-06-07 07:03:21.839305 | 1 | International Results CSV 1 | h2h://126:177/1989-10-30 | |||
| 17028 | New Caledonia 126 | Fiji 128 | 1989-10-31 | 10 | 7 | 3 | 0 | 36 | 15 | 1988-10-25 | W | 2026-06-07 07:03:21.839495 | 2026-06-07 07:03:21.839496 | 1 | International Results CSV 1 | h2h://128:126/1989-10-31 | |||
| 17036 | New Caledonia 126 | Vanuatu 127 | 1989-11-03 | 14 | 11 | 1 | 2 | 50 | 13 | 1988-10-26 | L | 2026-06-07 07:03:21.841021 | 2026-06-07 07:03:21.841022 | 1 | International Results CSV 1 | h2h://126:127/1989-11-03 | |||
| 17041 | New Caledonia 126 | Papua New Guinea 176 | 1989-11-04 | 8 | 8 | 0 | 0 | 34 | 4 | 1987-12-10 | W | 2026-06-07 07:03:21.841967 | 2026-06-07 07:03:21.841967 | 1 | International Results CSV 1 | h2h://126:176/1989-11-04 | |||
| 17517 | New Caledonia 126 | Vanuatu 127 | 1990-11-01 | 15 | 12 | 1 | 2 | 55 | 14 | 1989-11-03 | W | 2026-06-07 07:03:21.933087 | 2026-06-07 07:03:21.933087 | 1 | International Results CSV 1 | h2h://126:127/1990-11-01 | |||
| 17519 | New Caledonia 126 | Papua New Guinea 176 | 1990-11-03 | 9 | 9 | 0 | 0 | 36 | 5 | 1989-11-04 | W | 2026-06-07 07:03:21.933471 | 2026-06-07 07:03:21.933471 | 1 | International Results CSV 1 | h2h://126:176/1990-11-03 | |||
| 17521 | New Caledonia 126 | Fiji 128 | 1990-11-05 | 11 | 7 | 4 | 0 | 36 | 18 | 1989-10-31 | L | 2026-06-07 07:03:21.933852 | 2026-06-07 07:03:21.933852 | 1 | International Results CSV 1 | h2h://126:128/1990-11-05 | |||
| 17527 | New Caledonia 126 | Solomon Islands 177 | 1990-11-08 | 8 | 4 | 2 | 2 | 18 | 6 | 1989-10-30 | W | 2026-06-07 07:03:21.934986 | 2026-06-07 07:03:21.934986 | 1 | International Results CSV 1 | h2h://126:177/1990-11-08 | |||
| 17927 | New Caledonia 126 | Fiji 128 | 1991-09-10 | 12 | 7 | 4 | 1 | 36 | 18 | 1990-11-05 | D | 2026-06-07 07:03:22.011884 | 2026-06-07 07:03:22.011885 | 1 | International Results CSV 1 | h2h://128:126/1991-09-10 | |||
| 17934 | New Caledonia 126 | Tahiti 132 | 1991-09-11 | 36 | 18 | 13 | 5 | 68 | 50 | 1987-12-19 | W | 2026-06-07 07:03:22.013233 | 2026-06-07 07:03:22.013233 | 1 | International Results CSV 1 | h2h://126:132/1991-09-11 | |||
| 17945 | New Caledonia 126 | Guam 204 | 1991-09-15 | 1 | 1 | 0 | 0 | 10 | 1 | 1979-08-30 | L | 2026-06-07 07:03:22.015333 | 2026-06-07 07:03:22.015333 | 1 | International Results CSV 1 | h2h://204:126/1991-09-15 | |||
| 17948 | New Caledonia 126 | Solomon Islands 177 | 1991-09-17 | 9 | 5 | 2 | 2 | 21 | 7 | 1990-11-08 | W | 2026-06-07 07:03:22.015902 | 2026-06-07 07:03:22.015902 | 1 | International Results CSV 1 | h2h://126:177/1991-09-17 | |||
| 17952 | New Caledonia 126 | Vanuatu 127 | 1991-09-20 | 16 | 12 | 2 | 2 | 55 | 15 | 1990-11-01 | L | 2026-06-07 07:03:22.016664 | 2026-06-07 07:03:22.016664 | 1 | International Results CSV 1 | h2h://126:127/1991-09-20 | |||
| 18349 | New Caledonia 126 | Tahiti 132 | 1992-07-12 | 37 | 18 | 13 | 6 | 70 | 52 | 1991-09-11 | D | 2026-06-07 07:03:22.095794 | 2026-06-07 07:03:22.095794 | 1 | International Results CSV 1 | h2h://126:132/1992-07-12 | |||
| 18355 | New Caledonia 126 | Tahiti 132 | 1992-07-22 | 38 | 18 | 14 | 6 | 70 | 53 | 1992-07-12 | L | 2026-06-07 07:03:22.097007 | 2026-06-07 07:03:22.097007 | 1 | International Results CSV 1 | h2h://126:132/1992-07-22 | |||
| 18358 | New Caledonia 126 | Vanuatu 127 | 1992-07-25 | 17 | 13 | 2 | 2 | 58 | 16 | 1991-09-20 | L | 2026-06-07 07:03:22.097610 | 2026-06-07 07:03:22.097610 | 1 | International Results CSV 1 | h2h://127:126/1992-07-25 | |||
| 18363 | New Caledonia 126 | Fiji 128 | 1992-07-28 | 13 | 7 | 5 | 1 | 37 | 21 | 1991-09-10 | W | 2026-06-07 07:03:22.098604 | 2026-06-07 07:03:22.098604 | 1 | International Results CSV 1 | h2h://128:126/1992-07-28 | |||
| 18365 | New Caledonia 126 | Solomon Islands 177 | 1992-07-30 | 10 | 5 | 3 | 2 | 22 | 11 | 1991-09-17 | L | 2026-06-07 07:03:22.098993 | 2026-06-07 07:03:22.098993 | 1 | International Results CSV 1 | h2h://126:177/1992-07-30 | |||
| 19457 | New Caledonia 126 | Papua New Guinea 176 | 1993-12-08 | 10 | 10 | 0 | 0 | 38 | 6 | 1990-11-03 | W | 2026-06-07 07:03:22.316125 | 2026-06-07 07:03:22.316125 | 1 | International Results CSV 1 | h2h://126:176/1993-12-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)
);