h2h_record
339 rows where team_a_id = 32
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 386 | Philippines 32 | China 33 | 1913-02-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.435229 | 2026-06-07 07:03:18.435229 | 1 | International Results CSV 1 | h2h://32:33/1913-02-04 | |||||
| 460 | Philippines 32 | China 33 | 1915-05-18 | 1 | 1 | 0 | 0 | 2 | 1 | 1913-02-04 | L | 2026-06-07 07:03:18.435883 | 2026-06-07 07:03:18.435883 | 1 | International Results CSV 1 | h2h://33:32/1915-05-18 | |||
| 461 | Philippines 32 | China 33 | 1915-05-19 | 2 | 1 | 0 | 1 | 2 | 1 | 1915-05-18 | D | 2026-06-07 07:03:18.435890 | 2026-06-07 07:03:18.435890 | 1 | International Results CSV 1 | h2h://33:32/1915-05-19 | |||
| 501 | Philippines 32 | Japan 36 | 1917-05-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.436267 | 2026-06-07 07:03:18.436267 | 1 | International Results CSV 1 | h2h://36:32/1917-05-07 | |||||
| 503 | Philippines 32 | Japan 36 | 1917-05-10 | 1 | 1 | 0 | 0 | 15 | 2 | 1917-05-07 | L | 2026-06-07 07:03:18.436281 | 2026-06-07 07:03:18.436281 | 1 | International Results CSV 1 | h2h://36:32/1917-05-10 | |||
| 504 | Philippines 32 | China 33 | 1917-05-11 | 3 | 1 | 1 | 1 | 2 | 2 | 1915-05-19 | W | 2026-06-07 07:03:18.436288 | 2026-06-07 07:03:18.436289 | 1 | International Results CSV 1 | h2h://33:32/1917-05-11 | |||
| 549 | Philippines 32 | China 33 | 1919-05-12 | 4 | 1 | 2 | 1 | 2 | 5 | 1917-05-11 | W | 2026-06-07 07:03:18.436713 | 2026-06-07 07:03:18.436713 | 1 | International Results CSV 1 | h2h://33:32/1919-05-12 | |||
| 551 | Philippines 32 | China 33 | 1919-05-13 | 5 | 1 | 3 | 1 | 2 | 7 | 1919-05-12 | W | 2026-06-07 07:03:18.436733 | 2026-06-07 07:03:18.436733 | 1 | International Results CSV 1 | h2h://33:32/1919-05-13 | |||
| 553 | Philippines 32 | China 33 | 1919-05-15 | 6 | 2 | 3 | 1 | 4 | 8 | 1919-05-13 | L | 2026-06-07 07:03:18.436748 | 2026-06-07 07:03:18.436748 | 1 | International Results CSV 1 | h2h://33:32/1919-05-15 | |||
| 674 | Philippines 32 | Japan 36 | 1921-05-30 | 2 | 2 | 0 | 0 | 30 | 4 | 1917-05-10 | L | 2026-06-07 07:03:18.437793 | 2026-06-07 07:03:18.437793 | 1 | International Results CSV 1 | h2h://36:32/1921-05-30 | |||
| 675 | Philippines 32 | China 33 | 1921-05-31 | 7 | 2 | 4 | 1 | 5 | 10 | 1919-05-15 | W | 2026-06-07 07:03:18.437806 | 2026-06-07 07:03:18.437806 | 1 | International Results CSV 1 | h2h://33:32/1921-05-31 | |||
| 812 | Philippines 32 | China 33 | 1923-05-22 | 8 | 2 | 5 | 1 | 5 | 11 | 1921-05-31 | W | 2026-06-07 07:03:18.438967 | 2026-06-07 07:03:18.438968 | 1 | International Results CSV 1 | h2h://33:32/1923-05-22 | |||
| 813 | Philippines 32 | Japan 36 | 1923-05-23 | 4 | 4 | 0 | 0 | 36 | 5 | 1921-05-30 | L | 2026-06-07 07:03:18.438976 | 2026-06-07 07:03:18.438976 | 1 | International Results CSV 1 | h2h://36:32/1923-05-23 | |||
| 1007 | Philippines 32 | Japan 36 | 1925-05-18 | 5 | 5 | 0 | 0 | 38 | 6 | 1923-05-23 | W | 2026-06-07 07:03:18.440621 | 2026-06-07 07:03:18.440621 | 1 | International Results CSV 1 | h2h://32:36/1925-05-18 | |||
| 1011 | Philippines 32 | China 33 | 1925-05-22 | 9 | 2 | 6 | 1 | 5 | 14 | 1923-05-22 | L | 2026-06-07 07:03:18.440655 | 2026-06-07 07:03:18.440655 | 1 | International Results CSV 1 | h2h://32:33/1925-05-22 | |||
| 1208 | Philippines 32 | Japan 36 | 1927-08-29 | 6 | 6 | 0 | 0 | 42 | 6 | 1925-05-18 | L | 2026-06-07 07:03:18.442316 | 2026-06-07 07:03:18.442316 | 1 | International Results CSV 1 | h2h://36:32/1927-08-29 | |||
| 1210 | Philippines 32 | China 33 | 1927-08-31 | 10 | 2 | 7 | 1 | 6 | 19 | 1925-05-22 | W | 2026-06-07 07:03:18.442340 | 2026-06-07 07:03:18.442341 | 1 | International Results CSV 1 | h2h://33:32/1927-08-31 | |||
| 1467 | Philippines 32 | Japan 36 | 1930-05-25 | 7 | 6 | 1 | 0 | 43 | 8 | 1927-08-29 | W | 2026-06-07 07:03:18.444624 | 2026-06-07 07:03:18.444624 | 1 | International Results CSV 1 | h2h://36:32/1930-05-25 | |||
| 1468 | Philippines 32 | China 33 | 1930-05-27 | 11 | 2 | 8 | 1 | 7 | 22 | 1927-08-31 | W | 2026-06-07 07:03:18.444632 | 2026-06-07 07:03:18.444632 | 1 | International Results CSV 1 | h2h://33:32/1930-05-27 | |||
| 1862 | Philippines 32 | China 33 | 1934-05-12 | 12 | 2 | 9 | 1 | 7 | 27 | 1930-05-27 | L | 2026-06-07 07:03:18.448215 | 2026-06-07 07:03:18.448216 | 1 | International Results CSV 1 | h2h://32:33/1934-05-12 | |||
| 1865 | Philippines 32 | Japan 36 | 1934-05-15 | 8 | 6 | 2 | 0 | 45 | 15 | 1930-05-25 | L | 2026-06-07 07:03:18.448237 | 2026-06-07 07:03:18.448237 | 1 | International Results CSV 1 | h2h://32:36/1934-05-15 | |||
| 1867 | Philippines 32 | Indonesia 83 | 1934-05-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.448250 | 2026-06-07 07:03:18.448250 | 1 | International Results CSV 1 | h2h://32:83/1934-05-19 | |||||
| 2532 | Philippines 32 | Japan 36 | 1940-06-16 | 9 | 6 | 3 | 0 | 48 | 19 | 1934-05-15 | W | 2026-06-07 07:03:18.454163 | 2026-06-07 07:03:18.454164 | 1 | International Results CSV 1 | h2h://36:32/1940-06-16 | |||
| 3781 | Philippines 32 | Singapore 135 | 1953-06-20 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.465819 | 2026-06-07 07:03:18.465819 | 1 | International Results CSV 1 | h2h://135:32/1953-06-20 | |||||
| 3912 | Philippines 32 | Vietnam 115 | 1954-05-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.466966 | 2026-06-07 07:03:18.466966 | 1 | International Results CSV 1 | h2h://32:115/1954-05-03 | |||||
| 3921 | Philippines 32 | Taiwan 123 | 1954-05-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.467033 | 2026-06-07 07:03:18.467033 | 1 | International Results CSV 1 | h2h://32:123/1954-05-06 | |||||
| 4212 | Philippines 32 | South Korea 114 | 1956-02-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.469681 | 2026-06-07 07:03:18.469682 | 1 | International Results CSV 1 | h2h://32:114/1956-02-25 | |||||
| 4249 | Philippines 32 | South Korea 114 | 1956-04-21 | 1 | 0 | 1 | 0 | 0 | 2 | 1956-02-25 | W | 2026-06-07 07:03:18.469997 | 2026-06-07 07:03:18.469998 | 1 | International Results CSV 1 | h2h://114:32/1956-04-21 | |||
| 4649 | Philippines 32 | Indonesia 83 | 1958-05-09 | 1 | 1 | 0 | 0 | 3 | 2 | 1934-05-19 | W | 2026-06-07 07:03:18.473614 | 2026-06-07 07:03:18.473614 | 1 | International Results CSV 1 | h2h://32:83/1958-05-09 | |||
| 4654 | Philippines 32 | Indonesia 83 | 1958-05-13 | 2 | 1 | 1 | 0 | 4 | 4 | 1958-05-09 | L | 2026-06-07 07:03:18.473652 | 2026-06-07 07:03:18.473652 | 1 | International Results CSV 1 | h2h://32:83/1958-05-13 | |||
| 4668 | Philippines 32 | Hong Kong 134 | 1958-05-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.473750 | 2026-06-07 07:03:18.473750 | 1 | International Results CSV 1 | h2h://134:32/1958-05-25 | |||||
| 4671 | Philippines 32 | Japan 36 | 1958-05-26 | 10 | 6 | 4 | 0 | 48 | 20 | 1940-06-16 | W | 2026-06-07 07:03:18.473776 | 2026-06-07 07:03:18.473776 | 1 | International Results CSV 1 | h2h://36:32/1958-05-26 | |||
| 4682 | Philippines 32 | Indonesia 83 | 1958-05-30 | 3 | 1 | 2 | 0 | 4 | 7 | 1958-05-13 | W | 2026-06-07 07:03:18.473854 | 2026-06-07 07:03:18.473854 | 1 | International Results CSV 1 | h2h://83:32/1958-05-30 | |||
| 4830 | Philippines 32 | Hong Kong 134 | 1959-03-29 | 1 | 0 | 1 | 0 | 1 | 4 | 1958-05-25 | L | 2026-06-07 07:03:18.475145 | 2026-06-07 07:03:18.475145 | 1 | International Results CSV 1 | h2h://32:134/1959-03-29 | |||
| 4832 | Philippines 32 | Taiwan 123 | 1959-03-31 | 1 | 0 | 1 | 0 | 0 | 4 | 1954-05-06 | L | 2026-06-07 07:03:18.475178 | 2026-06-07 07:03:18.475178 | 1 | International Results CSV 1 | h2h://32:123/1959-03-31 | |||
| 5557 | Philippines 32 | Malaysia 136 | 1962-08-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.983438 | 2026-06-07 07:03:18.983438 | 1 | International Results CSV 1 | h2h://136:32/1962-08-26 | |||||
| 5559 | Philippines 32 | Indonesia 83 | 1962-08-27 | 4 | 1 | 3 | 0 | 6 | 12 | 1958-05-30 | W | 2026-06-07 07:03:18.983816 | 2026-06-07 07:03:18.983816 | 1 | International Results CSV 1 | h2h://83:32/1962-08-27 | |||
| 5565 | Philippines 32 | Vietnam Republic 144 | 1962-08-30 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.984946 | 2026-06-07 07:03:18.984946 | 1 | International Results CSV 1 | h2h://144:32/1962-08-30 | |||||
| 5580 | Philippines 32 | Indonesia 83 | 1962-09-12 | 5 | 1 | 4 | 0 | 6 | 18 | 1962-08-27 | W | 2026-06-07 07:03:18.987810 | 2026-06-07 07:03:18.987810 | 1 | International Results CSV 1 | h2h://83:32/1962-09-12 | |||
| 5583 | Philippines 32 | Singapore 135 | 1962-09-13 | 1 | 0 | 1 | 0 | 1 | 3 | 1953-06-20 | L | 2026-06-07 07:03:18.988380 | 2026-06-07 07:03:18.988381 | 1 | International Results CSV 1 | h2h://32:135/1962-09-13 | |||
| 5592 | Philippines 32 | Vietnam Republic 144 | 1962-09-16 | 1 | 0 | 1 | 0 | 0 | 6 | 1962-08-30 | L | 2026-06-07 07:03:18.990096 | 2026-06-07 07:03:18.990096 | 1 | International Results CSV 1 | h2h://32:144/1962-09-16 | |||
| 5990 | Philippines 32 | Taiwan 123 | 1963-12-16 | 2 | 0 | 2 | 0 | 4 | 11 | 1959-03-31 | L | 2026-06-07 07:03:19.065998 | 2026-06-07 07:03:19.065998 | 1 | International Results CSV 1 | h2h://32:123/1963-12-16 | |||
| 7081 | Philippines 32 | Japan 36 | 1967-08-03 | 11 | 7 | 4 | 0 | 49 | 20 | 1958-05-26 | L | 2026-06-07 07:03:19.272985 | 2026-06-07 07:03:19.272985 | 1 | International Results CSV 1 | h2h://36:32/1967-08-03 | |||
| 7083 | Philippines 32 | South Korea 114 | 1967-08-05 | 2 | 0 | 2 | 0 | 0 | 5 | 1956-04-21 | W | 2026-06-07 07:03:19.273368 | 2026-06-07 07:03:19.273368 | 1 | International Results CSV 1 | h2h://114:32/1967-08-05 | |||
| 7084 | Philippines 32 | Indonesia 83 | 1967-08-07 | 6 | 1 | 5 | 0 | 6 | 27 | 1962-09-12 | W | 2026-06-07 07:03:19.273554 | 2026-06-07 07:03:19.273555 | 1 | International Results CSV 1 | h2h://83:32/1967-08-07 | |||
| 8486 | Philippines 32 | India 92 | 1971-08-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.544753 | 2026-06-07 07:03:19.544754 | 1 | International Results CSV 1 | h2h://92:32/1971-08-05 | |||||
| 8495 | Philippines 32 | Hong Kong 134 | 1971-08-09 | 2 | 0 | 2 | 0 | 1 | 11 | 1959-03-29 | W | 2026-06-07 07:03:19.546538 | 2026-06-07 07:03:19.546538 | 1 | International Results CSV 1 | h2h://134:32/1971-08-09 | |||
| 8499 | Philippines 32 | Indonesia 83 | 1971-08-11 | 7 | 1 | 6 | 0 | 6 | 33 | 1967-08-07 | W | 2026-06-07 07:03:19.547329 | 2026-06-07 07:03:19.547329 | 1 | International Results CSV 1 | h2h://83:32/1971-08-11 | |||
| 8502 | Philippines 32 | Myanmar 125 | 1971-08-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.547914 | 2026-06-07 07:03:19.547914 | 1 | International Results CSV 1 | h2h://125:32/1971-08-13 | |||||
| 8510 | Philippines 32 | Singapore 135 | 1971-08-15 | 2 | 0 | 2 | 0 | 1 | 8 | 1962-09-13 | L | 2026-06-07 07:03:19.549468 | 2026-06-07 07:03:19.549468 | 1 | International Results CSV 1 | h2h://32:135/1971-08-15 | |||
| 8511 | Philippines 32 | Thailand 143 | 1971-08-17 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.549657 | 2026-06-07 07:03:19.549658 | 1 | International Results CSV 1 | h2h://32:143/1971-08-17 | |||||
| 8521 | Philippines 32 | Thailand 143 | 1971-08-24 | 1 | 1 | 0 | 0 | 3 | 1 | 1971-08-17 | W | 2026-06-07 07:03:19.551614 | 2026-06-07 07:03:19.551614 | 1 | International Results CSV 1 | h2h://32:143/1971-08-24 | |||
| 8863 | Philippines 32 | Singapore 135 | 1972-06-08 | 3 | 0 | 2 | 1 | 5 | 12 | 1971-08-15 | D | 2026-06-07 07:03:19.619025 | 2026-06-07 07:03:19.619026 | 1 | International Results CSV 1 | h2h://32:135/1972-06-08 | |||
| 8873 | Philippines 32 | Thailand 143 | 1972-06-12 | 2 | 1 | 1 | 0 | 3 | 2 | 1971-08-24 | L | 2026-06-07 07:03:19.620981 | 2026-06-07 07:03:19.620981 | 1 | International Results CSV 1 | h2h://32:143/1972-06-12 | |||
| 8936 | Philippines 32 | Malaysia 136 | 1972-07-14 | 1 | 0 | 1 | 0 | 1 | 15 | 1962-08-26 | W | 2026-06-07 07:03:19.633452 | 2026-06-07 07:03:19.633453 | 1 | International Results CSV 1 | h2h://136:32/1972-07-14 | |||
| 8939 | Philippines 32 | Cambodia 142 | 1972-07-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.634036 | 2026-06-07 07:03:19.634036 | 1 | International Results CSV 1 | h2h://142:32/1972-07-16 | |||||
| 8945 | Philippines 32 | Japan 36 | 1972-07-18 | 12 | 7 | 5 | 0 | 49 | 22 | 1967-08-03 | W | 2026-06-07 07:03:19.635215 | 2026-06-07 07:03:19.635215 | 1 | International Results CSV 1 | h2h://36:32/1972-07-18 | |||
| 8949 | Philippines 32 | Sri Lanka 130 | 1972-07-20 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.635992 | 2026-06-07 07:03:19.635992 | 1 | International Results CSV 1 | h2h://32:130/1972-07-20 | |||||
| 8960 | Philippines 32 | Thailand 143 | 1972-07-29 | 3 | 2 | 1 | 0 | 4 | 2 | 1972-06-12 | W | 2026-06-07 07:03:19.638161 | 2026-06-07 07:03:19.638161 | 1 | International Results CSV 1 | h2h://32:143/1972-07-29 | |||
| 8962 | Philippines 32 | Indonesia 83 | 1972-08-02 | 8 | 1 | 7 | 0 | 7 | 36 | 1971-08-11 | W | 2026-06-07 07:03:19.638555 | 2026-06-07 07:03:19.638555 | 1 | International Results CSV 1 | h2h://83:32/1972-08-02 | |||
| 8966 | Philippines 32 | Japan 36 | 1972-08-04 | 13 | 7 | 6 | 0 | 50 | 27 | 1972-07-18 | W | 2026-06-07 07:03:19.639338 | 2026-06-07 07:03:19.639339 | 1 | International Results CSV 1 | h2h://36:32/1972-08-04 | |||
| 8996 | Philippines 32 | Myanmar 125 | 1972-09-21 | 1 | 0 | 1 | 0 | 0 | 2 | 1971-08-13 | W | 2026-06-07 07:03:19.645337 | 2026-06-07 07:03:19.645337 | 1 | International Results CSV 1 | h2h://125:32/1972-09-21 | |||
| 9000 | Philippines 32 | Singapore 135 | 1972-09-23 | 4 | 1 | 2 | 1 | 7 | 12 | 1972-06-08 | W | 2026-06-07 07:03:19.646130 | 2026-06-07 07:03:19.646130 | 1 | International Results CSV 1 | h2h://32:135/1972-09-23 | |||
| 9004 | Philippines 32 | Cambodia 142 | 1972-09-27 | 1 | 0 | 0 | 1 | 2 | 2 | 1972-07-16 | D | 2026-06-07 07:03:19.646927 | 2026-06-07 07:03:19.646927 | 1 | International Results CSV 1 | h2h://142:32/1972-09-27 | |||
| 9054 | Philippines 32 | Australia 53 | 1972-10-29 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.656798 | 2026-06-07 07:03:19.656798 | 1 | International Results CSV 1 | h2h://32:53/1972-10-29 | |||||
| 9831 | Philippines 32 | Japan 36 | 1974-09-03 | 14 | 7 | 7 | 0 | 51 | 31 | 1972-08-04 | W | 2026-06-07 07:03:19.810869 | 2026-06-07 07:03:19.810869 | 1 | International Results CSV 1 | h2h://36:32/1974-09-03 | |||
| 9845 | Philippines 32 | Israel 82 | 1974-09-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.813620 | 2026-06-07 07:03:19.813621 | 1 | International Results CSV 1 | h2h://82:32/1974-09-05 | |||||
| 9854 | Philippines 32 | Malaysia 136 | 1974-09-07 | 2 | 0 | 2 | 0 | 1 | 16 | 1972-07-14 | W | 2026-06-07 07:03:19.815371 | 2026-06-07 07:03:19.815371 | 1 | International Results CSV 1 | h2h://136:32/1974-09-07 | |||
| 11205 | Philippines 32 | Brunei 193 | 1977-11-20 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.384057 | 2026-06-07 07:03:20.384057 | 1 | International Results CSV 1 | h2h://32:193/1977-11-20 | |||||
| 11207 | Philippines 32 | Malaysia 136 | 1977-11-21 | 3 | 0 | 3 | 0 | 1 | 27 | 1974-09-07 | W | 2026-06-07 07:03:20.384460 | 2026-06-07 07:03:20.384460 | 1 | International Results CSV 1 | h2h://136:32/1977-11-21 | |||
| 11211 | Philippines 32 | Indonesia 83 | 1977-11-23 | 9 | 1 | 8 | 0 | 7 | 39 | 1972-08-02 | L | 2026-06-07 07:03:20.385297 | 2026-06-07 07:03:20.385297 | 1 | International Results CSV 1 | h2h://32:83/1977-11-23 | |||
| 11631 | Philippines 32 | China 33 | 1978-12-25 | 13 | 2 | 10 | 1 | 7 | 29 | 1934-05-12 | L | 2026-06-07 07:03:20.468531 | 2026-06-07 07:03:20.468532 | 1 | International Results CSV 1 | h2h://32:33/1978-12-25 | |||
| 11633 | Philippines 32 | South Korea 114 | 1978-12-27 | 3 | 0 | 3 | 0 | 0 | 12 | 1967-08-05 | L | 2026-06-07 07:03:20.468919 | 2026-06-07 07:03:20.468919 | 1 | International Results CSV 1 | h2h://32:114/1978-12-27 | |||
| 12887 | Philippines 32 | Indonesia 83 | 1981-08-14 | 10 | 1 | 8 | 1 | 8 | 40 | 1977-11-23 | D | 2026-06-07 07:03:20.717757 | 2026-06-07 07:03:20.717757 | 1 | International Results CSV 1 | h2h://83:32/1981-08-14 | |||
| 13075 | Philippines 32 | Singapore 135 | 1981-12-09 | 5 | 1 | 3 | 1 | 7 | 17 | 1972-09-23 | L | 2026-06-07 07:03:20.755222 | 2026-06-07 07:03:20.755222 | 1 | International Results CSV 1 | h2h://32:135/1981-12-09 | |||
| 13077 | Philippines 32 | Indonesia 83 | 1981-12-11 | 11 | 1 | 9 | 1 | 8 | 43 | 1981-08-14 | L | 2026-06-07 07:03:20.755621 | 2026-06-07 07:03:20.755621 | 1 | International Results CSV 1 | h2h://32:83/1981-12-11 | |||
| 13243 | Philippines 32 | Singapore 135 | 1982-05-06 | 6 | 1 | 4 | 1 | 7 | 21 | 1981-12-09 | L | 2026-06-07 07:03:20.788566 | 2026-06-07 07:03:20.788567 | 1 | International Results CSV 1 | h2h://32:135/1982-05-06 | |||
| 13658 | Philippines 32 | Malaysia 136 | 1983-05-30 | 4 | 0 | 4 | 0 | 1 | 32 | 1977-11-21 | L | 2026-06-07 07:03:20.870692 | 2026-06-07 07:03:20.870692 | 1 | International Results CSV 1 | h2h://32:136/1983-05-30 | |||
| 13667 | Philippines 32 | Singapore 135 | 1983-06-01 | 7 | 1 | 5 | 1 | 7 | 22 | 1982-05-06 | W | 2026-06-07 07:03:20.872538 | 2026-06-07 07:03:20.872538 | 1 | International Results CSV 1 | h2h://135:32/1983-06-01 | |||
| 14224 | Philippines 32 | Syria 121 | 1984-08-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.983145 | 2026-06-07 07:03:20.983145 | 1 | International Results CSV 1 | h2h://121:32/1984-08-07 | |||||
| 14229 | Philippines 32 | Thailand 143 | 1984-08-09 | 4 | 2 | 2 | 0 | 4 | 6 | 1972-07-29 | W | 2026-06-07 07:03:20.984115 | 2026-06-07 07:03:20.984116 | 1 | International Results CSV 1 | h2h://143:32/1984-08-09 | |||
| 14231 | Philippines 32 | Indonesia 83 | 1984-08-11 | 12 | 1 | 10 | 1 | 8 | 45 | 1981-12-11 | W | 2026-06-07 07:03:20.984521 | 2026-06-07 07:03:20.984521 | 1 | International Results CSV 1 | h2h://83:32/1984-08-11 | |||
| 14235 | Philippines 32 | Bangladesh 200 | 1984-08-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.985311 | 2026-06-07 07:03:20.985311 | 1 | International Results CSV 1 | h2h://200:32/1984-08-13 | |||||
| 14239 | Philippines 32 | Iran 99 | 1984-08-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.986079 | 2026-06-07 07:03:20.986079 | 1 | International Results CSV 1 | h2h://99:32/1984-08-15 | |||||
| 14650 | Philippines 32 | Brunei 193 | 1985-03-24 | 1 | 1 | 0 | 0 | 4 | 1 | 1977-11-20 | L | 2026-06-07 07:03:21.067226 | 2026-06-07 07:03:21.067226 | 1 | International Results CSV 1 | h2h://193:32/1985-03-24 | |||
| 15084 | Philippines 32 | Malaysia 136 | 1985-12-10 | 5 | 0 | 4 | 1 | 1 | 32 | 1983-05-30 | D | 2026-06-07 07:03:21.467885 | 2026-06-07 07:03:21.467886 | 1 | International Results CSV 1 | h2h://136:32/1985-12-10 | |||
| 15090 | Philippines 32 | Thailand 143 | 1985-12-12 | 5 | 2 | 3 | 0 | 4 | 9 | 1984-08-09 | W | 2026-06-07 07:03:21.469009 | 2026-06-07 07:03:21.469009 | 1 | International Results CSV 1 | h2h://143:32/1985-12-12 | |||
| 16904 | Philippines 32 | Malaysia 136 | 1989-08-21 | 6 | 0 | 5 | 1 | 1 | 38 | 1985-12-10 | W | 2026-06-07 07:03:21.815712 | 2026-06-07 07:03:21.815712 | 1 | International Results CSV 1 | h2h://136:32/1989-08-21 | |||
| 16913 | Philippines 32 | Indonesia 83 | 1989-08-23 | 13 | 1 | 11 | 1 | 8 | 46 | 1984-08-11 | W | 2026-06-07 07:03:21.817446 | 2026-06-07 07:03:21.817446 | 1 | International Results CSV 1 | h2h://83:32/1989-08-23 | |||
| 16916 | Philippines 32 | Brunei 193 | 1989-08-25 | 2 | 1 | 1 | 0 | 5 | 5 | 1985-03-24 | W | 2026-06-07 07:03:21.818019 | 2026-06-07 07:03:21.818020 | 1 | International Results CSV 1 | h2h://193:32/1989-08-25 | |||
| 17806 | Philippines 32 | Brunei 193 | 1991-06-22 | 3 | 1 | 2 | 0 | 5 | 7 | 1989-08-25 | L | 2026-06-07 07:03:21.988436 | 2026-06-07 07:03:21.988437 | 1 | International Results CSV 1 | h2h://32:193/1991-06-22 | |||
| 18038 | Philippines 32 | Vietnam 115 | 1991-11-26 | 1 | 0 | 1 | 0 | 2 | 3 | 1954-05-03 | L | 2026-06-07 07:03:22.033589 | 2026-06-07 07:03:22.033589 | 1 | International Results CSV 1 | h2h://32:115/1991-11-26 | |||
| 18050 | Philippines 32 | Malaysia 136 | 1991-11-28 | 7 | 0 | 6 | 1 | 1 | 41 | 1989-08-21 | L | 2026-06-07 07:03:22.036006 | 2026-06-07 07:03:22.036006 | 1 | International Results CSV 1 | h2h://32:136/1991-11-28 | |||
| 18056 | Philippines 32 | Indonesia 83 | 1991-11-30 | 14 | 1 | 12 | 1 | 9 | 51 | 1989-08-23 | L | 2026-06-07 07:03:22.037238 | 2026-06-07 07:03:22.037238 | 1 | International Results CSV 1 | h2h://32:83/1991-11-30 | |||
| 18060 | Philippines 32 | Thailand 143 | 1991-12-02 | 6 | 2 | 4 | 0 | 4 | 16 | 1985-12-12 | L | 2026-06-07 07:03:22.038035 | 2026-06-07 07:03:22.038035 | 1 | International Results CSV 1 | h2h://32:143/1991-12-02 | |||
| 18067 | Philippines 32 | Singapore 135 | 1991-12-04 | 8 | 1 | 6 | 1 | 7 | 27 | 1983-06-01 | L | 2026-06-07 07:03:22.039459 | 2026-06-07 07:03:22.039460 | 1 | International Results CSV 1 | h2h://32:135/1991-12-04 | |||
| 19099 | Philippines 32 | Singapore 135 | 1993-06-09 | 9 | 1 | 7 | 1 | 7 | 29 | 1991-12-04 | W | 2026-06-07 07:03:22.244732 | 2026-06-07 07:03:22.244732 | 1 | International Results CSV 1 | h2h://135:32/1993-06-09 | |||
| 19110 | Philippines 32 | Vietnam 115 | 1993-06-11 | 2 | 0 | 1 | 1 | 4 | 5 | 1991-11-26 | D | 2026-06-07 07:03:22.246946 | 2026-06-07 07:03:22.246947 | 1 | International Results CSV 1 | h2h://115:32/1993-06-11 | |||
| 19128 | Philippines 32 | Indonesia 83 | 1993-06-15 | 15 | 1 | 13 | 1 | 10 | 53 | 1991-11-30 | W | 2026-06-07 07:03:22.250532 | 2026-06-07 07:03:22.250533 | 1 | International Results CSV 1 | h2h://83:32/1993-06-15 | |||
| 20711 | Philippines 32 | Myanmar 125 | 1995-12-04 | 2 | 0 | 2 | 0 | 0 | 6 | 1972-09-21 | W | 2026-06-07 07:03:22.881765 | 2026-06-07 07:03:22.881765 | 1 | International Results CSV 1 | h2h://125:32/1995-12-04 |
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)
);