h2h_record
138 rows where team_a_id = 128
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5890 | Fiji 128 | Papua New Guinea 176 | 1963-08-29 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.046878 | 2026-06-07 07:03:19.046878 | 1 | International Results CSV 1 | h2h://128:176/1963-08-29 | |||||
| 5893 | Fiji 128 | Solomon Islands 177 | 1963-09-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.047440 | 2026-06-07 07:03:19.047440 | 1 | International Results CSV 1 | h2h://128:177/1963-09-01 | |||||
| 7746 | Fiji 128 | Solomon Islands 177 | 1969-08-14 | 1 | 1 | 0 | 0 | 5 | 0 | 1963-09-01 | W | 2026-06-07 07:03:19.399459 | 2026-06-07 07:03:19.399459 | 1 | International Results CSV 1 | h2h://128:177/1969-08-14 | |||
| 7753 | Fiji 128 | Tahiti 132 | 1969-08-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.400772 | 2026-06-07 07:03:19.400772 | 1 | International Results CSV 1 | h2h://128:132/1969-08-16 | |||||
| 7763 | Fiji 128 | Papua New Guinea 176 | 1969-08-20 | 1 | 1 | 0 | 0 | 3 | 1 | 1963-08-29 | L | 2026-06-07 07:03:19.402663 | 2026-06-07 07:03:19.402663 | 1 | International Results CSV 1 | h2h://176:128/1969-08-20 | |||
| 7767 | Fiji 128 | Papua New Guinea 176 | 1969-08-22 | 2 | 1 | 0 | 1 | 4 | 2 | 1969-08-20 | D | 2026-06-07 07:03:19.403429 | 2026-06-07 07:03:19.403430 | 1 | International Results CSV 1 | h2h://176:128/1969-08-22 | |||
| 8527 | Fiji 128 | Tahiti 132 | 1971-08-30 | 1 | 0 | 1 | 0 | 0 | 2 | 1969-08-16 | W | 2026-06-07 07:03:19.552804 | 2026-06-07 07:03:19.552805 | 1 | International Results CSV 1 | h2h://132:128/1971-08-30 | |||
| 8545 | Fiji 128 | Cook Islands 194 | 1971-09-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.556353 | 2026-06-07 07:03:19.556353 | 1 | International Results CSV 1 | h2h://194:128/1971-09-15 | |||||
| 9185 | Fiji 128 | Tahiti 132 | 1973-02-23 | 2 | 0 | 2 | 0 | 2 | 7 | 1971-08-30 | L | 2026-06-07 07:03:19.682573 | 2026-06-07 07:03:19.682573 | 1 | International Results CSV 1 | h2h://128:132/1973-02-23 | |||
| 10226 | Fiji 128 | Guam 204 | 1975-08-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.196247 | 2026-06-07 07:03:20.196248 | 1 | International Results CSV 1 | h2h://204:128/1975-08-04 | |||||
| 10230 | Fiji 128 | Solomon Islands 177 | 1975-08-05 | 2 | 2 | 0 | 0 | 10 | 1 | 1969-08-14 | W | 2026-06-07 07:03:20.196995 | 2026-06-07 07:03:20.196996 | 1 | International Results CSV 1 | h2h://128:177/1975-08-05 | |||
| 10238 | Fiji 128 | Tahiti 132 | 1975-08-07 | 3 | 0 | 3 | 0 | 2 | 11 | 1973-02-23 | L | 2026-06-07 07:03:20.198514 | 2026-06-07 07:03:20.198514 | 1 | International Results CSV 1 | h2h://128:132/1975-08-07 | |||
| 10244 | Fiji 128 | Solomon Islands 177 | 1975-08-08 | 3 | 2 | 0 | 1 | 11 | 2 | 1975-08-05 | D | 2026-06-07 07:03:20.199660 | 2026-06-07 07:03:20.199660 | 1 | International Results CSV 1 | h2h://128:177/1975-08-08 | |||
| 11900 | Fiji 128 | Papua New Guinea 176 | 1979-08-29 | 3 | 1 | 1 | 1 | 5 | 4 | 1969-08-22 | L | 2026-06-07 07:03:20.521826 | 2026-06-07 07:03:20.521826 | 1 | International Results CSV 1 | h2h://128:176/1979-08-29 | |||
| 11902 | Fiji 128 | Kiribati 216 | 1979-08-30 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.522211 | 2026-06-07 07:03:20.522211 | 1 | International Results CSV 1 | h2h://128:216/1979-08-30 | |||||
| 11914 | Fiji 128 | Wallis Islands and Futuna 185 | 1979-09-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.524529 | 2026-06-07 07:03:20.524529 | 1 | International Results CSV 1 | h2h://128:185/1979-09-03 | |||||
| 11920 | Fiji 128 | Solomon Islands 177 | 1979-09-04 | 4 | 2 | 1 | 1 | 13 | 5 | 1975-08-08 | L | 2026-06-07 07:03:20.525704 | 2026-06-07 07:03:20.525704 | 1 | International Results CSV 1 | h2h://128:177/1979-09-04 | |||
| 11933 | Fiji 128 | Tahiti 132 | 1979-09-07 | 4 | 0 | 4 | 0 | 2 | 14 | 1975-08-07 | L | 2026-06-07 07:03:20.528284 | 2026-06-07 07:03:20.528284 | 1 | International Results CSV 1 | h2h://128:132/1979-09-07 | |||
| 12113 | Fiji 128 | Solomon Islands 177 | 1980-02-25 | 5 | 3 | 1 | 1 | 15 | 5 | 1979-09-04 | W | 2026-06-07 07:03:20.564121 | 2026-06-07 07:03:20.564121 | 1 | International Results CSV 1 | h2h://128:177/1980-02-25 | |||
| 12128 | Fiji 128 | Tahiti 132 | 1980-02-29 | 5 | 0 | 5 | 0 | 2 | 17 | 1979-09-07 | L | 2026-06-07 07:03:20.567086 | 2026-06-07 07:03:20.567086 | 1 | International Results CSV 1 | h2h://128:132/1980-02-29 | |||
| 12299 | Fiji 128 | Tahiti 132 | 1980-07-10 | 6 | 0 | 6 | 0 | 5 | 23 | 1980-02-29 | L | 2026-06-07 07:03:20.600948 | 2026-06-07 07:03:20.600949 | 1 | International Results CSV 1 | h2h://128:132/1980-07-10 | |||
| 12640 | Fiji 128 | Tahiti 132 | 1981-03-02 | 7 | 0 | 6 | 1 | 6 | 24 | 1980-07-10 | D | 2026-06-07 07:03:20.668384 | 2026-06-07 07:03:20.668384 | 1 | International Results CSV 1 | h2h://132:128/1981-03-02 | |||
| 12647 | Fiji 128 | Tahiti 132 | 1981-03-10 | 8 | 0 | 7 | 1 | 6 | 25 | 1981-03-02 | W | 2026-06-07 07:03:20.669763 | 2026-06-07 07:03:20.669763 | 1 | International Results CSV 1 | h2h://132:128/1981-03-10 | |||
| 12829 | Fiji 128 | Solomon Islands 177 | 1981-07-07 | 6 | 4 | 1 | 1 | 18 | 6 | 1980-02-25 | L | 2026-06-07 07:03:20.706206 | 2026-06-07 07:03:20.706206 | 1 | International Results CSV 1 | h2h://177:128/1981-07-07 | |||
| 12833 | Fiji 128 | Papua New Guinea 176 | 1981-07-08 | 4 | 1 | 1 | 2 | 5 | 4 | 1979-08-29 | D | 2026-06-07 07:03:20.707001 | 2026-06-07 07:03:20.707002 | 1 | International Results CSV 1 | h2h://176:128/1981-07-08 | |||
| 12843 | Fiji 128 | Samoa 218 | 1981-07-11 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.708984 | 2026-06-07 07:03:20.708984 | 1 | International Results CSV 1 | h2h://128:218/1981-07-11 | |||||
| 12855 | Fiji 128 | Tahiti 132 | 1981-07-14 | 9 | 0 | 8 | 1 | 7 | 27 | 1981-03-10 | W | 2026-06-07 07:03:20.711368 | 2026-06-07 07:03:20.711369 | 1 | International Results CSV 1 | h2h://132:128/1981-07-14 | |||
| 13795 | Fiji 128 | Solomon Islands 177 | 1983-08-22 | 7 | 5 | 1 | 1 | 20 | 7 | 1981-07-07 | W | 2026-06-07 07:03:20.898024 | 2026-06-07 07:03:20.898024 | 1 | International Results CSV 1 | h2h://128:177/1983-08-22 | |||
| 13837 | Fiji 128 | Papua New Guinea 176 | 1983-09-14 | 5 | 1 | 2 | 2 | 7 | 7 | 1981-07-08 | L | 2026-06-07 07:03:20.906400 | 2026-06-07 07:03:20.906401 | 1 | International Results CSV 1 | h2h://128:176/1983-09-14 | |||
| 13841 | Fiji 128 | Tahiti 132 | 1983-09-15 | 10 | 0 | 9 | 1 | 7 | 33 | 1981-07-14 | L | 2026-06-07 07:03:20.907179 | 2026-06-07 07:03:20.907179 | 1 | International Results CSV 1 | h2h://128:132/1983-09-15 | |||
| 14875 | Fiji 128 | Tahiti 132 | 1985-07-04 | 11 | 0 | 10 | 1 | 7 | 34 | 1983-09-15 | L | 2026-06-07 07:03:21.111948 | 2026-06-07 07:03:21.111948 | 1 | International Results CSV 1 | h2h://128:132/1985-07-04 | |||
| 14892 | Fiji 128 | Tahiti 132 | 1985-07-11 | 12 | 0 | 11 | 1 | 7 | 35 | 1985-07-04 | L | 2026-06-07 07:03:21.115298 | 2026-06-07 07:03:21.115298 | 1 | International Results CSV 1 | h2h://128:132/1985-07-11 | |||
| 14898 | Fiji 128 | Tahiti 132 | 1985-07-14 | 13 | 0 | 12 | 1 | 7 | 36 | 1985-07-11 | L | 2026-06-07 07:03:21.116470 | 2026-06-07 07:03:21.116471 | 1 | International Results CSV 1 | h2h://128:132/1985-07-14 | |||
| 16349 | Fiji 128 | Solomon Islands 177 | 1988-10-21 | 8 | 6 | 1 | 1 | 30 | 7 | 1983-08-22 | L | 2026-06-07 07:03:21.709005 | 2026-06-07 07:03:21.709005 | 1 | International Results CSV 1 | h2h://177:128/1988-10-21 | |||
| 16360 | Fiji 128 | Solomon Islands 177 | 1988-10-26 | 9 | 6 | 1 | 2 | 31 | 8 | 1988-10-21 | D | 2026-06-07 07:03:21.711142 | 2026-06-07 07:03:21.711142 | 1 | International Results CSV 1 | h2h://177:128/1988-10-26 | |||
| 17019 | Fiji 128 | Papua New Guinea 176 | 1989-10-28 | 6 | 2 | 2 | 2 | 9 | 7 | 1983-09-14 | W | 2026-06-07 07:03:21.837783 | 2026-06-07 07:03:21.837784 | 1 | International Results CSV 1 | h2h://128:176/1989-10-28 | |||
| 17039 | Fiji 128 | Solomon Islands 177 | 1989-11-04 | 10 | 7 | 1 | 2 | 34 | 9 | 1988-10-26 | W | 2026-06-07 07:03:21.841592 | 2026-06-07 07:03:21.841592 | 1 | International Results CSV 1 | h2h://128:177/1989-11-04 | |||
| 17516 | Fiji 128 | Solomon Islands 177 | 1990-11-01 | 11 | 7 | 1 | 3 | 34 | 9 | 1989-11-04 | D | 2026-06-07 07:03:21.932894 | 2026-06-07 07:03:21.932895 | 1 | International Results CSV 1 | h2h://128:177/1990-11-01 | |||
| 17526 | Fiji 128 | Papua New Guinea 176 | 1990-11-08 | 7 | 3 | 2 | 2 | 11 | 8 | 1989-10-28 | L | 2026-06-07 07:03:21.934798 | 2026-06-07 07:03:21.934798 | 1 | International Results CSV 1 | h2h://176:128/1990-11-08 | |||
| 17940 | Fiji 128 | Guam 204 | 1991-09-12 | 1 | 1 | 0 | 0 | 11 | 0 | 1975-08-04 | W | 2026-06-07 07:03:22.014369 | 2026-06-07 07:03:22.014370 | 1 | International Results CSV 1 | h2h://128:204/1991-09-12 | |||
| 17942 | Fiji 128 | Tahiti 132 | 1991-09-14 | 14 | 0 | 13 | 1 | 8 | 38 | 1985-07-14 | L | 2026-06-07 07:03:22.014760 | 2026-06-07 07:03:22.014760 | 1 | International Results CSV 1 | h2h://128:132/1991-09-14 | |||
| 17951 | Fiji 128 | Solomon Islands 177 | 1991-09-20 | 12 | 7 | 1 | 4 | 34 | 9 | 1990-11-01 | D | 2026-06-07 07:03:22.016473 | 2026-06-07 07:03:22.016473 | 1 | International Results CSV 1 | h2h://128:177/1991-09-20 | |||
| 18357 | Fiji 128 | Solomon Islands 177 | 1992-07-25 | 13 | 7 | 1 | 5 | 35 | 10 | 1991-09-20 | D | 2026-06-07 07:03:22.097409 | 2026-06-07 07:03:22.097410 | 1 | International Results CSV 1 | h2h://128:177/1992-07-25 | |||
| 19444 | Fiji 128 | Tahiti 132 | 1993-11-30 | 15 | 1 | 13 | 1 | 11 | 38 | 1991-09-14 | L | 2026-06-07 07:03:22.313494 | 2026-06-07 07:03:22.313495 | 1 | International Results CSV 1 | h2h://132:128/1993-11-30 | |||
| 19456 | Fiji 128 | Solomon Islands 177 | 1993-12-07 | 14 | 8 | 1 | 5 | 37 | 11 | 1992-07-25 | W | 2026-06-07 07:03:22.315927 | 2026-06-07 07:03:22.315928 | 1 | International Results CSV 1 | h2h://128:177/1993-12-07 | |||
| 19458 | Fiji 128 | Tahiti 132 | 1993-12-09 | 16 | 1 | 14 | 1 | 11 | 41 | 1993-11-30 | W | 2026-06-07 07:03:22.316329 | 2026-06-07 07:03:22.316329 | 1 | International Results CSV 1 | h2h://132:128/1993-12-09 | |||
| 19466 | Fiji 128 | Guam 204 | 1993-12-13 | 2 | 2 | 0 | 0 | 25 | 1 | 1991-09-12 | W | 2026-06-07 07:03:22.317919 | 2026-06-07 07:03:22.317920 | 1 | International Results CSV 1 | h2h://128:204/1993-12-13 | |||
| 19473 | Fiji 128 | Tahiti 132 | 1993-12-16 | 17 | 1 | 15 | 1 | 11 | 42 | 1993-12-09 | W | 2026-06-07 07:03:22.319336 | 2026-06-07 07:03:22.319337 | 1 | International Results CSV 1 | h2h://132:128/1993-12-16 | |||
| 19696 | Fiji 128 | Tahiti 132 | 1994-05-23 | 18 | 1 | 16 | 1 | 11 | 45 | 1993-12-16 | L | 2026-06-07 07:03:22.363873 | 2026-06-07 07:03:22.363874 | 1 | International Results CSV 1 | h2h://128:132/1994-05-23 | |||
| 19702 | Fiji 128 | Tahiti 132 | 1994-05-25 | 19 | 1 | 16 | 2 | 13 | 47 | 1994-05-23 | D | 2026-06-07 07:03:22.365059 | 2026-06-07 07:03:22.365059 | 1 | International Results CSV 1 | h2h://128:132/1994-05-25 | |||
| 19800 | Fiji 128 | Papua New Guinea 176 | 1994-07-06 | 8 | 4 | 2 | 2 | 12 | 8 | 1990-11-08 | L | 2026-06-07 07:03:22.384545 | 2026-06-07 07:03:22.384545 | 1 | International Results CSV 1 | h2h://176:128/1994-07-06 | |||
| 19802 | Fiji 128 | Solomon Islands 177 | 1994-07-07 | 15 | 9 | 1 | 5 | 38 | 11 | 1993-12-07 | L | 2026-06-07 07:03:22.384943 | 2026-06-07 07:03:22.384943 | 1 | International Results CSV 1 | h2h://177:128/1994-07-07 | |||
| 19846 | Fiji 128 | Solomon Islands 177 | 1994-09-02 | 16 | 9 | 2 | 5 | 38 | 12 | 1994-07-07 | W | 2026-06-07 07:03:22.393667 | 2026-06-07 07:03:22.393667 | 1 | International Results CSV 1 | h2h://177:128/1994-09-02 | |||
| 20185 | Fiji 128 | Tahiti 132 | 1995-03-24 | 20 | 2 | 16 | 2 | 15 | 47 | 1994-05-25 | L | 2026-06-07 07:03:22.781317 | 2026-06-07 07:03:22.781317 | 1 | International Results CSV 1 | h2h://132:128/1995-03-24 | |||
| 20220 | Fiji 128 | Tahiti 132 | 1995-03-30 | 21 | 2 | 16 | 3 | 18 | 50 | 1995-03-24 | D | 2026-06-07 07:03:22.787979 | 2026-06-07 07:03:22.787979 | 1 | International Results CSV 1 | h2h://132:128/1995-03-30 | |||
| 20505 | Fiji 128 | Papua New Guinea 176 | 1995-08-16 | 9 | 5 | 2 | 2 | 13 | 8 | 1994-07-06 | W | 2026-06-07 07:03:22.842361 | 2026-06-07 07:03:22.842362 | 1 | International Results CSV 1 | h2h://128:176/1995-08-16 | |||
| 20522 | Fiji 128 | Guam 204 | 1995-08-20 | 3 | 3 | 0 | 0 | 37 | 1 | 1993-12-13 | W | 2026-06-07 07:03:22.845566 | 2026-06-07 07:03:22.845566 | 1 | International Results CSV 1 | h2h://128:204/1995-08-20 | |||
| 20532 | Fiji 128 | Solomon Islands 177 | 1995-08-24 | 17 | 9 | 3 | 5 | 38 | 13 | 1994-09-02 | L | 2026-06-07 07:03:22.847458 | 2026-06-07 07:03:22.847458 | 1 | International Results CSV 1 | h2h://128:177/1995-08-24 | |||
| 21684 | Fiji 128 | Solomon Islands 177 | 1997-02-17 | 18 | 9 | 3 | 6 | 41 | 16 | 1995-08-24 | D | 2026-06-07 07:03:23.068214 | 2026-06-07 07:03:23.068214 | 1 | International Results CSV 1 | h2h://128:177/1997-02-17 | |||
| 21692 | Fiji 128 | Solomon Islands 177 | 1997-02-21 | 19 | 9 | 4 | 6 | 42 | 18 | 1997-02-17 | L | 2026-06-07 07:03:23.069734 | 2026-06-07 07:03:23.069734 | 1 | International Results CSV 1 | h2h://128:177/1997-02-21 | |||
| 22061 | Fiji 128 | Papua New Guinea 176 | 1997-06-15 | 10 | 5 | 2 | 3 | 15 | 10 | 1995-08-16 | D | 2026-06-07 07:03:23.140660 | 2026-06-07 07:03:23.140660 | 1 | International Results CSV 1 | h2h://128:176/1997-06-15 | |||
| 22086 | Fiji 128 | Papua New Guinea 176 | 1997-06-21 | 11 | 6 | 2 | 3 | 18 | 11 | 1997-06-15 | L | 2026-06-07 07:03:23.145511 | 2026-06-07 07:03:23.145511 | 1 | International Results CSV 1 | h2h://176:128/1997-06-21 | |||
| 23046 | Fiji 128 | Papua New Guinea 176 | 1998-09-10 | 12 | 7 | 2 | 3 | 19 | 11 | 1997-06-21 | W | 2026-06-07 07:03:23.329630 | 2026-06-07 07:03:23.329630 | 1 | International Results CSV 1 | h2h://128:176/1998-09-10 | |||
| 23049 | Fiji 128 | Solomon Islands 177 | 1998-09-12 | 20 | 10 | 4 | 6 | 45 | 20 | 1997-02-21 | W | 2026-06-07 07:03:23.330206 | 2026-06-07 07:03:23.330206 | 1 | International Results CSV 1 | h2h://128:177/1998-09-12 | |||
| 23084 | Fiji 128 | Cook Islands 194 | 1998-09-30 | 1 | 1 | 0 | 0 | 15 | 1 | 1971-09-15 | W | 2026-06-07 07:03:23.336789 | 2026-06-07 07:03:23.336789 | 1 | International Results CSV 1 | h2h://128:194/1998-09-30 | |||
| 23098 | Fiji 128 | Tahiti 132 | 1998-10-04 | 22 | 2 | 17 | 3 | 18 | 53 | 1995-03-30 | W | 2026-06-07 07:03:23.339486 | 2026-06-07 07:03:23.339486 | 1 | International Results CSV 1 | h2h://132:128/1998-10-04 | |||
| 24347 | Fiji 128 | Papua New Guinea 176 | 2000-04-08 | 13 | 8 | 2 | 3 | 21 | 11 | 1998-09-10 | W | 2026-06-07 07:03:23.582707 | 2026-06-07 07:03:23.582707 | 1 | International Results CSV 1 | h2h://128:176/2000-04-08 | |||
| 24387 | Fiji 128 | Solomon Islands 177 | 2000-04-15 | 21 | 10 | 4 | 7 | 46 | 21 | 1998-09-12 | D | 2026-06-07 07:03:23.590288 | 2026-06-07 07:03:23.590288 | 1 | International Results CSV 1 | h2h://128:177/2000-04-15 | |||
| 25168 | Fiji 128 | Malaysia 136 | 2001-02-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.071148 | 2026-06-07 07:03:24.071149 | 1 | International Results CSV 1 | h2h://128:136/2001-02-05 | |||||
| 25172 | Fiji 128 | Malaysia 136 | 2001-02-07 | 1 | 1 | 0 | 0 | 4 | 1 | 2001-02-05 | W | 2026-06-07 07:03:24.071894 | 2026-06-07 07:03:24.071895 | 1 | International Results CSV 1 | h2h://128:136/2001-02-07 | |||
| 25177 | Fiji 128 | Malaysia 136 | 2001-02-09 | 2 | 2 | 0 | 0 | 6 | 1 | 2001-02-07 | W | 2026-06-07 07:03:24.072844 | 2026-06-07 07:03:24.072844 | 1 | International Results CSV 1 | h2h://128:136/2001-02-09 | |||
| 25392 | Fiji 128 | American Samoa 224 | 2001-04-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.113685 | 2026-06-07 07:03:24.113685 | 1 | International Results CSV 1 | h2h://128:224/2001-04-07 | |||||
| 25412 | Fiji 128 | Samoa 218 | 2001-04-11 | 1 | 1 | 0 | 0 | 4 | 0 | 1981-07-11 | L | 2026-06-07 07:03:24.117456 | 2026-06-07 07:03:24.117456 | 1 | International Results CSV 1 | h2h://218:128/2001-04-11 | |||
| 25430 | Fiji 128 | Tonga 215 | 2001-04-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.120858 | 2026-06-07 07:03:24.120858 | 1 | International Results CSV 1 | h2h://215:128/2001-04-16 | |||||
| 27169 | Fiji 128 | Tuvalu 217 | 2003-05-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.454793 | 2026-06-07 07:03:24.454794 | 1 | International Results CSV 1 | h2h://128:217/2003-05-01 | |||||
| 27333 | Fiji 128 | Tuvalu 217 | 2003-07-01 | 1 | 1 | 0 | 0 | 9 | 0 | 2003-05-01 | W | 2026-06-07 07:03:24.486172 | 2026-06-07 07:03:24.486172 | 1 | International Results CSV 1 | h2h://128:217/2003-07-01 | |||
| 27366 | Fiji 128 | Kiribati 216 | 2003-07-05 | 1 | 1 | 0 | 0 | 24 | 0 | 1979-08-30 | W | 2026-06-07 07:03:24.492430 | 2026-06-07 07:03:24.492431 | 1 | International Results CSV 1 | h2h://128:216/2003-07-05 | |||
| 27392 | Fiji 128 | Solomon Islands 177 | 2003-07-07 | 22 | 10 | 4 | 8 | 48 | 23 | 2000-04-15 | D | 2026-06-07 07:03:24.497372 | 2026-06-07 07:03:24.497372 | 1 | International Results CSV 1 | h2h://128:177/2003-07-07 | |||
| 27397 | Fiji 128 | Tahiti 132 | 2003-07-09 | 23 | 3 | 17 | 3 | 22 | 55 | 1998-10-04 | W | 2026-06-07 07:03:24.498332 | 2026-06-07 07:03:24.498332 | 1 | International Results CSV 1 | h2h://128:132/2003-07-09 | |||
| 28128 | Fiji 128 | Papua New Guinea 176 | 2004-05-12 | 14 | 9 | 2 | 3 | 26 | 11 | 2000-04-08 | W | 2026-06-07 07:03:24.638155 | 2026-06-07 07:03:24.638155 | 1 | International Results CSV 1 | h2h://128:176/2004-05-12 | |||
| 28131 | Fiji 128 | American Samoa 224 | 2004-05-15 | 1 | 1 | 0 | 0 | 13 | 0 | 2001-04-07 | W | 2026-06-07 07:03:24.638734 | 2026-06-07 07:03:24.638734 | 1 | International Results CSV 1 | h2h://128:224/2004-05-15 | |||
| 28139 | Fiji 128 | Samoa 218 | 2004-05-17 | 2 | 2 | 0 | 0 | 10 | 1 | 2001-04-11 | L | 2026-06-07 07:03:24.640255 | 2026-06-07 07:03:24.640255 | 1 | International Results CSV 1 | h2h://218:128/2004-05-17 | |||
| 28182 | Fiji 128 | Tahiti 132 | 2004-05-29 | 24 | 4 | 17 | 3 | 24 | 56 | 2003-07-09 | L | 2026-06-07 07:03:24.648519 | 2026-06-07 07:03:24.648519 | 1 | International Results CSV 1 | h2h://132:128/2004-05-29 | |||
| 28226 | Fiji 128 | Solomon Islands 177 | 2004-06-04 | 23 | 11 | 4 | 8 | 50 | 24 | 2003-07-07 | W | 2026-06-07 07:03:24.656902 | 2026-06-07 07:03:24.656903 | 1 | International Results CSV 1 | h2h://128:177/2004-06-04 | |||
| 31167 | Fiji 128 | Tuvalu 217 | 2007-08-25 | 2 | 2 | 0 | 0 | 13 | 0 | 2003-07-01 | W | 2026-06-07 07:03:25.552706 | 2026-06-07 07:03:25.552707 | 1 | International Results CSV 1 | h2h://128:217/2007-08-25 | |||
| 31173 | Fiji 128 | Cook Islands 194 | 2007-08-27 | 2 | 2 | 0 | 0 | 18 | 1 | 1998-09-30 | W | 2026-06-07 07:03:25.553839 | 2026-06-07 07:03:25.553839 | 1 | International Results CSV 1 | h2h://128:194/2007-08-27 | |||
| 31183 | Fiji 128 | Tahiti 132 | 2007-09-01 | 25 | 4 | 17 | 4 | 24 | 56 | 2004-05-29 | D | 2026-06-07 07:03:25.555737 | 2026-06-07 07:03:25.555737 | 1 | International Results CSV 1 | h2h://132:128/2007-09-01 | |||
| 35035 | Fiji 128 | Samoa 218 | 2011-08-17 | 3 | 3 | 0 | 0 | 14 | 1 | 2004-05-17 | W | 2026-06-07 07:03:26.645441 | 2026-06-07 07:03:26.645441 | 1 | International Results CSV 1 | h2h://128:218/2011-08-17 | |||
| 35037 | Fiji 128 | Samoa 218 | 2011-08-18 | 4 | 4 | 0 | 0 | 17 | 1 | 2011-08-17 | W | 2026-06-07 07:03:26.645820 | 2026-06-07 07:03:26.645821 | 1 | International Results CSV 1 | h2h://128:218/2011-08-18 | |||
| 35054 | Fiji 128 | Tahiti 132 | 2011-08-27 | 26 | 5 | 17 | 4 | 28 | 56 | 2007-09-01 | W | 2026-06-07 07:03:26.649079 | 2026-06-07 07:03:26.649079 | 1 | International Results CSV 1 | h2h://128:132/2011-08-27 | |||
| 35063 | Fiji 128 | Kiribati 216 | 2011-08-30 | 2 | 2 | 0 | 0 | 36 | 0 | 2003-07-05 | W | 2026-06-07 07:03:26.650790 | 2026-06-07 07:03:26.650790 | 1 | International Results CSV 1 | h2h://128:216/2011-08-30 | |||
| 35127 | Fiji 128 | Cook Islands 194 | 2011-09-03 | 3 | 3 | 0 | 0 | 22 | 1 | 2007-08-27 | L | 2026-06-07 07:03:26.663000 | 2026-06-07 07:03:26.663000 | 1 | International Results CSV 1 | h2h://194:128/2011-09-03 | |||
| 35160 | Fiji 128 | Papua New Guinea 176 | 2011-09-05 | 15 | 10 | 2 | 3 | 30 | 13 | 2004-05-12 | L | 2026-06-07 07:03:26.669263 | 2026-06-07 07:03:26.669264 | 1 | International Results CSV 1 | h2h://176:128/2011-09-05 | |||
| 35215 | Fiji 128 | Solomon Islands 177 | 2011-09-07 | 24 | 11 | 5 | 8 | 51 | 26 | 2004-06-04 | W | 2026-06-07 07:03:26.679786 | 2026-06-07 07:03:26.679786 | 1 | International Results CSV 1 | h2h://177:128/2011-09-07 | |||
| 35217 | Fiji 128 | Tahiti 132 | 2011-09-09 | 27 | 6 | 17 | 4 | 31 | 56 | 2011-08-27 | L | 2026-06-07 07:03:26.680171 | 2026-06-07 07:03:26.680172 | 1 | International Results CSV 1 | h2h://132:128/2011-09-09 | |||
| 35872 | Fiji 128 | Solomon Islands 177 | 2012-06-04 | 25 | 11 | 6 | 8 | 52 | 28 | 2011-09-07 | W | 2026-06-07 07:03:26.805583 | 2026-06-07 07:03:26.805583 | 1 | International Results CSV 1 | h2h://177:128/2012-06-04 | |||
| 35887 | Fiji 128 | Papua New Guinea 176 | 2012-06-06 | 16 | 11 | 2 | 3 | 32 | 13 | 2011-09-05 | L | 2026-06-07 07:03:26.808443 | 2026-06-07 07:03:26.808443 | 1 | International Results CSV 1 | h2h://176:128/2012-06-06 | |||
| 38955 | Fiji 128 | Tonga 215 | 2015-08-19 | 1 | 1 | 0 | 0 | 8 | 1 | 2001-04-16 | W | 2026-06-07 07:03:27.415263 | 2026-06-07 07:03:27.415263 | 1 | International Results CSV 1 | h2h://128:215/2015-08-19 | |||
| 38958 | Fiji 128 | American Samoa 224 | 2015-08-27 | 2 | 2 | 0 | 0 | 24 | 0 | 2004-05-15 | W | 2026-06-07 07:03:27.415844 | 2026-06-07 07:03:27.415845 | 1 | International Results CSV 1 | h2h://128:224/2015-08-27 | |||
| 39702 | Fiji 128 | Solomon Islands 177 | 2016-05-31 | 26 | 11 | 6 | 9 | 52 | 28 | 2012-06-04 | D | 2026-06-07 07:03:27.563548 | 2026-06-07 07:03:27.563549 | 1 | International Results CSV 1 | h2h://177:128/2016-05-31 |
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)
);