h2h_record
624 rows where team_b_id = 143
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4022 | Cambodia 142 | Thailand 143 | 1954-11-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.467925 | 2026-06-07 07:03:18.467925 | 1 | International Results CSV 1 | h2h://142:143/1954-11-01 | |||||
| 4527 | Indonesia 83 | Thailand 143 | 1957-08-31 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.472473 | 2026-06-07 07:03:18.472473 | 1 | International Results CSV 1 | h2h://83:143/1957-08-31 | |||||
| 4529 | Cambodia 142 | Thailand 143 | 1957-09-01 | 1 | 1 | 0 | 0 | 7 | 1 | 1954-11-01 | W | 2026-06-07 07:03:18.472486 | 2026-06-07 07:03:18.472486 | 1 | International Results CSV 1 | h2h://142:143/1957-09-01 | |||
| 4536 | Singapore 135 | Thailand 143 | 1957-09-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.472540 | 2026-06-07 07:03:18.472540 | 1 | International Results CSV 1 | h2h://135:143/1957-09-03 | |||||
| 4540 | Myanmar 125 | Thailand 143 | 1957-09-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.472570 | 2026-06-07 07:03:18.472570 | 1 | International Results CSV 1 | h2h://125:143/1957-09-05 | |||||
| 4970 | Malaysia 136 | Thailand 143 | 1959-12-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.476428 | 2026-06-07 07:03:18.476429 | 1 | International Results CSV 1 | h2h://143:136/1959-12-14 | |||||
| 4972 | Myanmar 125 | Thailand 143 | 1959-12-15 | 1 | 1 | 0 | 0 | 5 | 2 | 1957-09-05 | L | 2026-06-07 07:03:18.476443 | 2026-06-07 07:03:18.476443 | 1 | International Results CSV 1 | h2h://143:125/1959-12-15 | |||
| 5095 | Pakistan 129 | Thailand 143 | 1960-08-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.894448 | 2026-06-07 07:03:18.894448 | 1 | International Results CSV 1 | h2h://129:143/1960-08-05 | |||||
| 5098 | Malaysia 136 | Thailand 143 | 1960-08-07 | 1 | 0 | 1 | 0 | 1 | 3 | 1959-12-14 | L | 2026-06-07 07:03:18.895013 | 2026-06-07 07:03:18.895013 | 1 | International Results CSV 1 | h2h://136:143/1960-08-07 | |||
| 5105 | Japan 36 | Thailand 143 | 1960-08-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.896350 | 2026-06-07 07:03:18.896350 | 1 | International Results CSV 1 | h2h://36:143/1960-08-12 | |||||
| 5311 | Hong Kong 134 | Thailand 143 | 1961-08-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.935641 | 2026-06-07 07:03:18.935642 | 1 | International Results CSV 1 | h2h://134:143/1961-08-06 | |||||
| 5313 | Indonesia 83 | Thailand 143 | 1961-08-09 | 1 | 1 | 0 | 0 | 4 | 0 | 1957-08-31 | W | 2026-06-07 07:03:18.936018 | 2026-06-07 07:03:18.936018 | 1 | International Results CSV 1 | h2h://83:143/1961-08-09 | |||
| 5317 | Singapore 135 | Thailand 143 | 1961-08-12 | 1 | 1 | 0 | 0 | 6 | 0 | 1957-09-03 | W | 2026-06-07 07:03:18.936780 | 2026-06-07 07:03:18.936780 | 1 | International Results CSV 1 | h2h://135:143/1961-08-12 | |||
| 5412 | Malaysia 136 | Thailand 143 | 1961-12-14 | 2 | 1 | 1 | 0 | 9 | 5 | 1960-08-07 | W | 2026-06-07 07:03:18.954930 | 2026-06-07 07:03:18.954930 | 1 | International Results CSV 1 | h2h://136:143/1961-12-14 | |||
| 5546 | Taiwan 123 | Thailand 143 | 1962-07-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.981312 | 2026-06-07 07:03:18.981312 | 1 | International Results CSV 1 | h2h://143:123/1962-07-25 | |||||
| 5555 | Japan 36 | Thailand 143 | 1962-08-25 | 1 | 1 | 0 | 0 | 3 | 1 | 1960-08-12 | W | 2026-06-07 07:03:18.983050 | 2026-06-07 07:03:18.983050 | 1 | International Results CSV 1 | h2h://36:143/1962-08-25 | |||
| 5560 | South Korea 114 | Thailand 143 | 1962-08-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.984001 | 2026-06-07 07:03:18.984001 | 1 | International Results CSV 1 | h2h://114:143/1962-08-27 | |||||
| 5562 | India 92 | Thailand 143 | 1962-08-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.984384 | 2026-06-07 07:03:18.984384 | 1 | International Results CSV 1 | h2h://143:92/1962-08-28 | |||||
| 5627 | Malaysia 136 | Thailand 143 | 1962-10-27 | 3 | 1 | 1 | 1 | 11 | 7 | 1961-12-14 | D | 2026-06-07 07:03:18.996730 | 2026-06-07 07:03:18.996731 | 1 | International Results CSV 1 | h2h://136:143/1962-10-27 | |||
| 5633 | Indonesia 83 | Thailand 143 | 1962-10-30 | 2 | 2 | 0 | 0 | 6 | 1 | 1961-08-09 | W | 2026-06-07 07:03:18.997891 | 2026-06-07 07:03:18.997891 | 1 | International Results CSV 1 | h2h://83:143/1962-10-30 | |||
| 5650 | Sweden 23 | Thailand 143 | 1962-11-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.001169 | 2026-06-07 07:03:19.001170 | 1 | International Results CSV 1 | h2h://143:23/1962-11-16 | |||||
| 5875 | Japan 36 | Thailand 143 | 1963-08-10 | 2 | 2 | 0 | 0 | 6 | 2 | 1962-08-25 | L | 2026-06-07 07:03:19.044022 | 2026-06-07 07:03:19.044023 | 1 | International Results CSV 1 | h2h://143:36/1963-08-10 | |||
| 5876 | South Korea 114 | Thailand 143 | 1963-08-11 | 1 | 1 | 0 | 0 | 3 | 2 | 1962-08-27 | W | 2026-06-07 07:03:19.044218 | 2026-06-07 07:03:19.044219 | 1 | International Results CSV 1 | h2h://114:143/1963-08-11 | |||
| 5882 | Malaysia 136 | Thailand 143 | 1963-08-14 | 4 | 2 | 1 | 1 | 15 | 9 | 1962-10-27 | W | 2026-06-07 07:03:19.045347 | 2026-06-07 07:03:19.045347 | 1 | International Results CSV 1 | h2h://136:143/1963-08-14 | |||
| 5886 | Taiwan 123 | Thailand 143 | 1963-08-16 | 1 | 0 | 1 | 0 | 0 | 4 | 1962-07-25 | L | 2026-06-07 07:03:19.046125 | 2026-06-07 07:03:19.046125 | 1 | International Results CSV 1 | h2h://123:143/1963-08-16 | |||
| 5977 | Hong Kong 134 | Thailand 143 | 1963-12-07 | 1 | 1 | 0 | 0 | 2 | 1 | 1961-08-06 | W | 2026-06-07 07:03:19.063523 | 2026-06-07 07:03:19.063523 | 1 | International Results CSV 1 | h2h://134:143/1963-12-07 | |||
| 5982 | Malaysia 136 | Thailand 143 | 1963-12-11 | 5 | 2 | 1 | 2 | 17 | 11 | 1963-08-14 | D | 2026-06-07 07:03:19.064486 | 2026-06-07 07:03:19.064486 | 1 | International Results CSV 1 | h2h://136:143/1963-12-11 | |||
| 6094 | Malaysia 136 | Thailand 143 | 1964-08-22 | 6 | 3 | 1 | 2 | 20 | 12 | 1963-12-11 | W | 2026-06-07 07:03:19.085893 | 2026-06-07 07:03:19.085893 | 1 | International Results CSV 1 | h2h://136:143/1964-08-22 | |||
| 6101 | India 92 | Thailand 143 | 1964-08-29 | 1 | 1 | 0 | 0 | 4 | 1 | 1962-08-28 | W | 2026-06-07 07:03:19.087237 | 2026-06-07 07:03:19.087238 | 1 | International Results CSV 1 | h2h://92:143/1964-08-29 | |||
| 6104 | Cambodia 142 | Thailand 143 | 1964-09-01 | 2 | 1 | 1 | 0 | 7 | 4 | 1957-09-01 | L | 2026-06-07 07:03:19.087792 | 2026-06-07 07:03:19.087792 | 1 | International Results CSV 1 | h2h://142:143/1964-09-01 | |||
| 6109 | Malaysia 136 | Thailand 143 | 1964-09-05 | 7 | 4 | 1 | 2 | 23 | 12 | 1964-08-22 | W | 2026-06-07 07:03:19.088736 | 2026-06-07 07:03:19.088736 | 1 | International Results CSV 1 | h2h://136:143/1964-09-05 | |||
| 6303 | Norway 24 | Thailand 143 | 1965-05-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.125579 | 2026-06-07 07:03:19.125579 | 1 | International Results CSV 1 | h2h://24:143/1965-05-19 | |||||
| 6395 | South Korea 114 | Thailand 143 | 1965-08-14 | 2 | 2 | 0 | 0 | 8 | 3 | 1963-08-11 | W | 2026-06-07 07:03:19.142936 | 2026-06-07 07:03:19.142936 | 1 | International Results CSV 1 | h2h://114:143/1965-08-14 | |||
| 6408 | Taiwan 123 | Thailand 143 | 1965-08-20 | 2 | 0 | 1 | 1 | 2 | 6 | 1963-08-16 | D | 2026-06-07 07:03:19.145397 | 2026-06-07 07:03:19.145397 | 1 | International Results CSV 1 | h2h://143:123/1965-08-20 | |||
| 6413 | Myanmar 125 | Thailand 143 | 1965-08-22 | 2 | 1 | 1 | 0 | 7 | 7 | 1959-12-15 | L | 2026-06-07 07:03:19.146343 | 2026-06-07 07:03:19.146344 | 1 | International Results CSV 1 | h2h://125:143/1965-08-22 | |||
| 6420 | Japan 36 | Thailand 143 | 1965-08-24 | 3 | 3 | 0 | 0 | 10 | 3 | 1963-08-10 | W | 2026-06-07 07:03:19.147665 | 2026-06-07 07:03:19.147665 | 1 | International Results CSV 1 | h2h://36:143/1965-08-24 | |||
| 6424 | Hong Kong 134 | Thailand 143 | 1965-08-27 | 2 | 1 | 0 | 1 | 5 | 4 | 1963-12-07 | D | 2026-06-07 07:03:19.148418 | 2026-06-07 07:03:19.148418 | 1 | International Results CSV 1 | h2h://134:143/1965-08-27 | |||
| 6541 | Myanmar 125 | Thailand 143 | 1965-12-22 | 3 | 1 | 1 | 1 | 8 | 8 | 1965-08-22 | D | 2026-06-07 07:03:19.170608 | 2026-06-07 07:03:19.170609 | 1 | International Results CSV 1 | h2h://125:143/1965-12-22 | |||
| 6732 | Taiwan 123 | Thailand 143 | 1966-08-15 | 3 | 1 | 1 | 1 | 5 | 8 | 1965-08-20 | W | 2026-06-07 07:03:19.206876 | 2026-06-07 07:03:19.206876 | 1 | International Results CSV 1 | h2h://123:143/1966-08-15 | |||
| 6734 | Myanmar 125 | Thailand 143 | 1966-08-17 | 4 | 1 | 1 | 2 | 10 | 10 | 1965-12-22 | D | 2026-06-07 07:03:19.207254 | 2026-06-07 07:03:19.207254 | 1 | International Results CSV 1 | h2h://125:143/1966-08-17 | |||
| 6739 | Malaysia 136 | Thailand 143 | 1966-08-19 | 8 | 4 | 1 | 3 | 24 | 13 | 1964-09-05 | D | 2026-06-07 07:03:19.208203 | 2026-06-07 07:03:19.208204 | 1 | International Results CSV 1 | h2h://136:143/1966-08-19 | |||
| 6744 | South Korea 114 | Thailand 143 | 1966-08-21 | 3 | 2 | 1 | 0 | 10 | 6 | 1965-08-14 | L | 2026-06-07 07:03:19.209145 | 2026-06-07 07:03:19.209146 | 1 | International Results CSV 1 | h2h://114:143/1966-08-21 | |||
| 6749 | Hong Kong 134 | Thailand 143 | 1966-08-23 | 3 | 1 | 0 | 2 | 6 | 5 | 1965-08-27 | D | 2026-06-07 07:03:19.210087 | 2026-06-07 07:03:19.210088 | 1 | International Results CSV 1 | h2h://134:143/1966-08-23 | |||
| 6806 | Malaysia 136 | Thailand 143 | 1966-11-03 | 9 | 4 | 1 | 4 | 24 | 13 | 1966-08-19 | D | 2026-06-07 07:03:19.220950 | 2026-06-07 07:03:19.220950 | 1 | International Results CSV 1 | h2h://136:143/1966-11-03 | |||
| 6859 | South Korea 114 | Thailand 143 | 1966-12-10 | 4 | 3 | 1 | 0 | 12 | 7 | 1966-08-21 | L | 2026-06-07 07:03:19.230991 | 2026-06-07 07:03:19.230992 | 1 | International Results CSV 1 | h2h://143:114/1966-12-10 | |||
| 6877 | Myanmar 125 | Thailand 143 | 1966-12-14 | 5 | 2 | 1 | 2 | 13 | 10 | 1966-08-17 | L | 2026-06-07 07:03:19.234375 | 2026-06-07 07:03:19.234375 | 1 | International Results CSV 1 | h2h://143:125/1966-12-14 | |||
| 6883 | Singapore 135 | Thailand 143 | 1966-12-15 | 2 | 2 | 0 | 0 | 11 | 3 | 1961-08-12 | L | 2026-06-07 07:03:19.235506 | 2026-06-07 07:03:19.235506 | 1 | International Results CSV 1 | h2h://143:135/1966-12-15 | |||
| 6889 | Japan 36 | Thailand 143 | 1966-12-17 | 4 | 3 | 0 | 1 | 10 | 3 | 1965-08-24 | D | 2026-06-07 07:03:19.236637 | 2026-06-07 07:03:19.236638 | 1 | International Results CSV 1 | h2h://143:36/1966-12-17 | |||
| 7086 | Hong Kong 134 | Thailand 143 | 1967-08-10 | 4 | 1 | 0 | 3 | 8 | 7 | 1966-08-23 | D | 2026-06-07 07:03:19.273966 | 2026-06-07 07:03:19.273967 | 1 | International Results CSV 1 | h2h://134:143/1967-08-10 | |||
| 7092 | India 92 | Thailand 143 | 1967-08-12 | 2 | 2 | 0 | 0 | 6 | 2 | 1964-08-29 | W | 2026-06-07 07:03:19.275114 | 2026-06-07 07:03:19.275114 | 1 | International Results CSV 1 | h2h://92:143/1967-08-12 | |||
| 7114 | Malaysia 136 | Thailand 143 | 1967-08-20 | 10 | 4 | 1 | 5 | 25 | 14 | 1966-11-03 | D | 2026-06-07 07:03:19.279260 | 2026-06-07 07:03:19.279260 | 1 | International Results CSV 1 | h2h://136:143/1967-08-20 | |||
| 7183 | Malaysia 136 | Thailand 143 | 1967-11-04 | 11 | 5 | 1 | 5 | 26 | 14 | 1967-08-20 | W | 2026-06-07 07:03:19.292402 | 2026-06-07 07:03:19.292402 | 1 | International Results CSV 1 | h2h://136:143/1967-11-04 | |||
| 7191 | South Korea 114 | Thailand 143 | 1967-11-07 | 5 | 3 | 2 | 0 | 12 | 10 | 1966-12-10 | L | 2026-06-07 07:03:19.293941 | 2026-06-07 07:03:19.293941 | 1 | International Results CSV 1 | h2h://114:143/1967-11-07 | |||
| 7199 | Hong Kong 134 | Thailand 143 | 1967-11-10 | 5 | 2 | 0 | 3 | 9 | 7 | 1967-08-10 | W | 2026-06-07 07:03:19.295446 | 2026-06-07 07:03:19.295446 | 1 | International Results CSV 1 | h2h://134:143/1967-11-10 | |||
| 7249 | Malaysia 136 | Thailand 143 | 1967-12-10 | 12 | 6 | 1 | 5 | 29 | 16 | 1967-11-04 | L | 2026-06-07 07:03:19.304920 | 2026-06-07 07:03:19.304920 | 1 | International Results CSV 1 | h2h://143:136/1967-12-10 | |||
| 7252 | Myanmar 125 | Thailand 143 | 1967-12-12 | 6 | 2 | 1 | 3 | 14 | 11 | 1966-12-14 | D | 2026-06-07 07:03:19.305490 | 2026-06-07 07:03:19.305490 | 1 | International Results CSV 1 | h2h://143:125/1967-12-12 | |||
| 7396 | Hong Kong 134 | Thailand 143 | 1968-08-11 | 6 | 2 | 1 | 3 | 10 | 12 | 1967-11-10 | L | 2026-06-07 07:03:19.332789 | 2026-06-07 07:03:19.332789 | 1 | International Results CSV 1 | h2h://134:143/1968-08-11 | |||
| 7403 | Myanmar 125 | Thailand 143 | 1968-08-14 | 7 | 3 | 1 | 3 | 15 | 11 | 1967-12-12 | W | 2026-06-07 07:03:19.334111 | 2026-06-07 07:03:19.334111 | 1 | International Results CSV 1 | h2h://125:143/1968-08-14 | |||
| 7411 | Malaysia 136 | Thailand 143 | 1968-08-17 | 13 | 6 | 2 | 5 | 29 | 20 | 1967-12-10 | L | 2026-06-07 07:03:19.335631 | 2026-06-07 07:03:19.335631 | 1 | International Results CSV 1 | h2h://136:143/1968-08-17 | |||
| 7419 | India 92 | Thailand 143 | 1968-08-19 | 3 | 2 | 0 | 1 | 7 | 3 | 1967-08-12 | D | 2026-06-07 07:03:19.337146 | 2026-06-07 07:03:19.337146 | 1 | International Results CSV 1 | h2h://92:143/1968-08-19 | |||
| 7422 | South Korea 114 | Thailand 143 | 1968-08-21 | 6 | 4 | 2 | 0 | 15 | 11 | 1967-11-07 | W | 2026-06-07 07:03:19.337707 | 2026-06-07 07:03:19.337707 | 1 | International Results CSV 1 | h2h://114:143/1968-08-21 | |||
| 7471 | Ethiopia 112 | Thailand 143 | 1968-10-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.347019 | 2026-06-07 07:03:19.347019 | 1 | International Results CSV 1 | h2h://112:143/1968-10-15 | |||||
| 7494 | Nigeria 120 | Thailand 143 | 1968-10-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.351377 | 2026-06-07 07:03:19.351378 | 1 | International Results CSV 1 | h2h://120:143/1968-10-28 | |||||
| 7519 | Singapore 135 | Thailand 143 | 1968-11-20 | 3 | 3 | 0 | 0 | 13 | 3 | 1966-12-15 | L | 2026-06-07 07:03:19.356126 | 2026-06-07 07:03:19.356126 | 1 | International Results CSV 1 | h2h://143:135/1968-11-20 | |||
| 7533 | Malaysia 136 | Thailand 143 | 1968-11-26 | 14 | 7 | 2 | 5 | 33 | 21 | 1968-08-17 | L | 2026-06-07 07:03:19.358776 | 2026-06-07 07:03:19.358776 | 1 | International Results CSV 1 | h2h://143:136/1968-11-26 | |||
| 7537 | Myanmar 125 | Thailand 143 | 1968-11-29 | 8 | 3 | 1 | 4 | 15 | 11 | 1968-08-14 | D | 2026-06-07 07:03:19.359535 | 2026-06-07 07:03:19.359535 | 1 | International Results CSV 1 | h2h://143:125/1968-11-29 | |||
| 7542 | Malaysia 136 | Thailand 143 | 1968-12-01 | 15 | 7 | 3 | 5 | 33 | 24 | 1968-11-26 | W | 2026-06-07 07:03:19.360472 | 2026-06-07 07:03:19.360473 | 1 | International Results CSV 1 | h2h://143:136/1968-12-01 | |||
| 7851 | Malaysia 136 | Thailand 143 | 1969-10-30 | 16 | 7 | 4 | 5 | 33 | 30 | 1968-12-01 | L | 2026-06-07 07:03:19.419461 | 2026-06-07 07:03:19.419461 | 1 | International Results CSV 1 | h2h://136:143/1969-10-30 | |||
| 7855 | Indonesia 83 | Thailand 143 | 1969-11-01 | 3 | 3 | 0 | 0 | 13 | 1 | 1962-10-30 | W | 2026-06-07 07:03:19.420221 | 2026-06-07 07:03:19.420221 | 1 | International Results CSV 1 | h2h://83:143/1969-11-01 | |||
| 7872 | South Korea 114 | Thailand 143 | 1969-11-05 | 7 | 5 | 2 | 0 | 17 | 12 | 1968-08-21 | W | 2026-06-07 07:03:19.423578 | 2026-06-07 07:03:19.423579 | 1 | International Results CSV 1 | h2h://114:143/1969-11-05 | |||
| 7875 | India 92 | Thailand 143 | 1969-11-07 | 4 | 2 | 1 | 1 | 7 | 4 | 1968-08-19 | L | 2026-06-07 07:03:19.424184 | 2026-06-07 07:03:19.424185 | 1 | International Results CSV 1 | h2h://92:143/1969-11-07 | |||
| 7877 | South Korea 114 | Thailand 143 | 1969-11-07 | 8 | 6 | 2 | 0 | 20 | 12 | 1969-11-05 | W | 2026-06-07 07:03:19.424576 | 2026-06-07 07:03:19.424576 | 1 | International Results CSV 1 | h2h://114:143/1969-11-07 | |||
| 7900 | Malaysia 136 | Thailand 143 | 1969-11-19 | 17 | 8 | 4 | 5 | 34 | 30 | 1969-10-30 | L | 2026-06-07 07:03:19.429081 | 2026-06-07 07:03:19.429082 | 1 | International Results CSV 1 | h2h://143:136/1969-11-19 | |||
| 7910 | South Korea 114 | Thailand 143 | 1969-11-23 | 9 | 7 | 2 | 0 | 22 | 13 | 1969-11-07 | L | 2026-06-07 07:03:19.431045 | 2026-06-07 07:03:19.431045 | 1 | International Results CSV 1 | h2h://143:114/1969-11-23 | |||
| 7943 | Myanmar 125 | Thailand 143 | 1969-12-08 | 9 | 4 | 1 | 4 | 17 | 11 | 1968-11-29 | W | 2026-06-07 07:03:19.437527 | 2026-06-07 07:03:19.437527 | 1 | International Results CSV 1 | h2h://125:143/1969-12-08 | |||
| 7946 | Malaysia 136 | Thailand 143 | 1969-12-10 | 18 | 8 | 4 | 6 | 36 | 32 | 1969-11-19 | D | 2026-06-07 07:03:19.438118 | 2026-06-07 07:03:19.438119 | 1 | International Results CSV 1 | h2h://136:143/1969-12-10 | |||
| 7948 | Myanmar 125 | Thailand 143 | 1969-12-13 | 10 | 4 | 1 | 5 | 18 | 12 | 1969-12-08 | D | 2026-06-07 07:03:19.438514 | 2026-06-07 07:03:19.438514 | 1 | International Results CSV 1 | h2h://125:143/1969-12-13 | |||
| 8111 | South Korea 114 | Thailand 143 | 1970-07-31 | 10 | 7 | 2 | 1 | 22 | 13 | 1969-11-23 | D | 2026-06-07 07:03:19.470735 | 2026-06-07 07:03:19.470736 | 1 | International Results CSV 1 | h2h://114:143/1970-07-31 | |||
| 8117 | Hong Kong 134 | Thailand 143 | 1970-08-02 | 7 | 2 | 1 | 4 | 10 | 12 | 1968-08-11 | D | 2026-06-07 07:03:19.471927 | 2026-06-07 07:03:19.471927 | 1 | International Results CSV 1 | h2h://134:143/1970-08-02 | |||
| 8123 | Japan 36 | Thailand 143 | 1970-08-04 | 5 | 4 | 0 | 1 | 15 | 4 | 1966-12-17 | W | 2026-06-07 07:03:19.473106 | 2026-06-07 07:03:19.473107 | 1 | International Results CSV 1 | h2h://36:143/1970-08-04 | |||
| 8133 | Singapore 135 | Thailand 143 | 1970-08-08 | 4 | 3 | 1 | 0 | 13 | 6 | 1968-11-20 | L | 2026-06-07 07:03:19.475080 | 2026-06-07 07:03:19.475080 | 1 | International Results CSV 1 | h2h://135:143/1970-08-08 | |||
| 8138 | Indonesia 83 | Thailand 143 | 1970-08-10 | 4 | 4 | 0 | 0 | 17 | 1 | 1969-11-01 | W | 2026-06-07 07:03:19.476075 | 2026-06-07 07:03:19.476076 | 1 | International Results CSV 1 | h2h://83:143/1970-08-10 | |||
| 8202 | Indonesia 83 | Thailand 143 | 1970-10-29 | 5 | 5 | 0 | 0 | 23 | 4 | 1970-08-10 | W | 2026-06-07 07:03:19.488804 | 2026-06-07 07:03:19.488805 | 1 | International Results CSV 1 | h2h://83:143/1970-10-29 | |||
| 8206 | Malaysia 136 | Thailand 143 | 1970-10-31 | 19 | 8 | 5 | 6 | 36 | 35 | 1969-12-10 | L | 2026-06-07 07:03:19.489602 | 2026-06-07 07:03:19.489603 | 1 | International Results CSV 1 | h2h://136:143/1970-10-31 | |||
| 8222 | Singapore 135 | Thailand 143 | 1970-11-10 | 5 | 3 | 2 | 0 | 17 | 11 | 1970-08-08 | W | 2026-06-07 07:03:19.492715 | 2026-06-07 07:03:19.492715 | 1 | International Results CSV 1 | h2h://143:135/1970-11-10 | |||
| 8231 | Hong Kong 134 | Thailand 143 | 1970-11-12 | 8 | 3 | 1 | 4 | 12 | 12 | 1970-08-02 | L | 2026-06-07 07:03:19.494460 | 2026-06-07 07:03:19.494460 | 1 | International Results CSV 1 | h2h://143:134/1970-11-12 | |||
| 8235 | South Korea 114 | Thailand 143 | 1970-11-14 | 11 | 7 | 2 | 2 | 22 | 13 | 1970-07-31 | D | 2026-06-07 07:03:19.495244 | 2026-06-07 07:03:19.495244 | 1 | International Results CSV 1 | h2h://143:114/1970-11-14 | |||
| 8248 | Indonesia 83 | Thailand 143 | 1970-11-18 | 6 | 5 | 1 | 0 | 24 | 6 | 1970-10-29 | W | 2026-06-07 07:03:19.497809 | 2026-06-07 07:03:19.497809 | 1 | International Results CSV 1 | h2h://143:83/1970-11-18 | |||
| 8251 | South Korea 114 | Thailand 143 | 1970-11-20 | 12 | 7 | 2 | 3 | 22 | 13 | 1970-11-14 | D | 2026-06-07 07:03:19.498406 | 2026-06-07 07:03:19.498407 | 1 | International Results CSV 1 | h2h://143:114/1970-11-20 | |||
| 8270 | India 92 | Thailand 143 | 1970-12-10 | 5 | 2 | 2 | 1 | 7 | 5 | 1969-11-07 | W | 2026-06-07 07:03:19.502159 | 2026-06-07 07:03:19.502159 | 1 | International Results CSV 1 | h2h://143:92/1970-12-10 | |||
| 8286 | South Korea 114 | Thailand 143 | 1970-12-15 | 13 | 8 | 2 | 3 | 23 | 13 | 1970-11-20 | L | 2026-06-07 07:03:19.505314 | 2026-06-07 07:03:19.505315 | 1 | International Results CSV 1 | h2h://143:114/1970-12-15 | |||
| 8289 | Myanmar 125 | Thailand 143 | 1970-12-16 | 11 | 5 | 1 | 5 | 21 | 12 | 1969-12-13 | L | 2026-06-07 07:03:19.505894 | 2026-06-07 07:03:19.505895 | 1 | International Results CSV 1 | h2h://143:125/1970-12-16 | |||
| 8295 | Indonesia 83 | Thailand 143 | 1970-12-19 | 7 | 5 | 2 | 0 | 25 | 8 | 1970-11-18 | W | 2026-06-07 07:03:19.507058 | 2026-06-07 07:03:19.507058 | 1 | International Results CSV 1 | h2h://143:83/1970-12-19 | |||
| 8356 | South Korea 114 | Thailand 143 | 1971-05-02 | 14 | 9 | 2 | 3 | 25 | 14 | 1970-12-15 | W | 2026-06-07 07:03:19.519038 | 2026-06-07 07:03:19.519038 | 1 | International Results CSV 1 | h2h://114:143/1971-05-02 | |||
| 8359 | Cambodia 142 | Thailand 143 | 1971-05-05 | 3 | 1 | 2 | 0 | 7 | 5 | 1964-09-01 | L | 2026-06-07 07:03:19.519629 | 2026-06-07 07:03:19.519630 | 1 | International Results CSV 1 | h2h://142:143/1971-05-05 | |||
| 8364 | Malaysia 136 | Thailand 143 | 1971-05-08 | 20 | 8 | 6 | 6 | 37 | 39 | 1970-10-31 | L | 2026-06-07 07:03:19.520600 | 2026-06-07 07:03:19.520600 | 1 | International Results CSV 1 | h2h://136:143/1971-05-08 | |||
| 8378 | Malaysia 136 | Thailand 143 | 1971-05-15 | 21 | 9 | 6 | 6 | 41 | 40 | 1971-05-08 | W | 2026-06-07 07:03:19.523324 | 2026-06-07 07:03:19.523325 | 1 | International Results CSV 1 | h2h://136:143/1971-05-15 | |||
| 8389 | Cambodia 142 | Thailand 143 | 1971-05-21 | 4 | 1 | 3 | 0 | 10 | 9 | 1971-05-05 | W | 2026-06-07 07:03:19.525576 | 2026-06-07 07:03:19.525576 | 1 | International Results CSV 1 | h2h://143:142/1971-05-21 | |||
| 8402 | Indonesia 83 | Thailand 143 | 1971-05-26 | 8 | 6 | 2 | 0 | 26 | 8 | 1970-12-19 | L | 2026-06-07 07:03:19.528158 | 2026-06-07 07:03:19.528158 | 1 | International Results CSV 1 | h2h://143:83/1971-05-26 | |||
| 8408 | Malaysia 136 | Thailand 143 | 1971-05-30 | 22 | 9 | 7 | 6 | 41 | 43 | 1971-05-15 | W | 2026-06-07 07:03:19.529335 | 2026-06-07 07:03:19.529336 | 1 | International Results CSV 1 | h2h://143:136/1971-05-30 |
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)
);