h2h_record
177 rows where team_b_id = 167
This data as json, CSV (advanced)
Suggested facets: team_a_id, total_matches, wins_a, wins_b, draws, goals_b, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5407 | Vietnam Republic 144 | Laos 167 | 1961-12-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.953985 | 2026-06-07 07:03:18.953985 | 1 | International Results CSV 1 | h2h://144:167/1961-12-12 | |||||
| 5410 | Thailand 143 | Laos 167 | 1961-12-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.954549 | 2026-06-07 07:03:18.954549 | 1 | International Results CSV 1 | h2h://143:167/1961-12-13 | |||||
| 5953 | North Vietnam 147 | Laos 167 | 1963-11-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.058998 | 2026-06-07 07:03:19.058998 | 1 | International Results CSV 1 | h2h://167:147/1963-11-13 | |||||
| 5955 | Egypt 42 | Laos 167 | 1963-11-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.059369 | 2026-06-07 07:03:19.059369 | 1 | International Results CSV 1 | h2h://42:167/1963-11-15 | |||||
| 7251 | Vietnam Republic 144 | Laos 167 | 1967-12-11 | 1 | 1 | 0 | 0 | 7 | 0 | 1961-12-12 | L | 2026-06-07 07:03:19.305301 | 2026-06-07 07:03:19.305302 | 1 | International Results CSV 1 | h2h://167:144/1967-12-11 | |||
| 7254 | Myanmar 125 | Laos 167 | 1967-12-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.305860 | 2026-06-07 07:03:19.305860 | 1 | International Results CSV 1 | h2h://125:167/1967-12-14 | |||||
| 7256 | Thailand 143 | Laos 167 | 1967-12-15 | 1 | 1 | 0 | 0 | 5 | 2 | 1961-12-13 | W | 2026-06-07 07:03:19.306240 | 2026-06-07 07:03:19.306240 | 1 | International Results CSV 1 | h2h://143:167/1967-12-15 | |||
| 7515 | Myanmar 125 | Laos 167 | 1968-11-20 | 1 | 1 | 0 | 0 | 2 | 0 | 1967-12-14 | W | 2026-06-07 07:03:19.355372 | 2026-06-07 07:03:19.355373 | 1 | International Results CSV 1 | h2h://125:167/1968-11-20 | |||
| 7522 | Thailand 143 | Laos 167 | 1968-11-22 | 2 | 2 | 0 | 0 | 10 | 4 | 1967-12-15 | W | 2026-06-07 07:03:19.356698 | 2026-06-07 07:03:19.356698 | 1 | International Results CSV 1 | h2h://143:167/1968-11-22 | |||
| 7529 | Malaysia 136 | Laos 167 | 1968-11-24 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.358009 | 2026-06-07 07:03:19.358009 | 1 | International Results CSV 1 | h2h://167:136/1968-11-24 | |||||
| 7899 | South Korea 114 | Laos 167 | 1969-11-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.428885 | 2026-06-07 07:03:19.428885 | 1 | International Results CSV 1 | h2h://114:167/1969-11-19 | |||||
| 7904 | Thailand 143 | Laos 167 | 1969-11-21 | 3 | 3 | 0 | 0 | 11 | 4 | 1968-11-22 | W | 2026-06-07 07:03:19.429869 | 2026-06-07 07:03:19.429869 | 1 | International Results CSV 1 | h2h://143:167/1969-11-21 | |||
| 7909 | Malaysia 136 | Laos 167 | 1969-11-23 | 1 | 1 | 0 | 0 | 5 | 0 | 1968-11-24 | L | 2026-06-07 07:03:19.430846 | 2026-06-07 07:03:19.430847 | 1 | International Results CSV 1 | h2h://167:136/1969-11-23 | |||
| 7915 | Indonesia 83 | Laos 167 | 1969-11-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.432020 | 2026-06-07 07:03:19.432020 | 1 | International Results CSV 1 | h2h://83:167/1969-11-26 | |||||
| 7922 | Vietnam Republic 144 | Laos 167 | 1969-11-28 | 2 | 2 | 0 | 0 | 12 | 0 | 1967-12-11 | L | 2026-06-07 07:03:19.433411 | 2026-06-07 07:03:19.433412 | 1 | International Results CSV 1 | h2h://167:144/1969-11-28 | |||
| 7937 | Malaysia 136 | Laos 167 | 1969-12-06 | 2 | 1 | 0 | 1 | 6 | 1 | 1969-11-23 | D | 2026-06-07 07:03:19.436343 | 2026-06-07 07:03:19.436344 | 1 | International Results CSV 1 | h2h://136:167/1969-12-06 | |||
| 7944 | Vietnam Republic 144 | Laos 167 | 1969-12-09 | 3 | 3 | 0 | 0 | 19 | 0 | 1969-11-28 | L | 2026-06-07 07:03:19.437722 | 2026-06-07 07:03:19.437722 | 1 | International Results CSV 1 | h2h://167:144/1969-12-09 | |||
| 7947 | Myanmar 125 | Laos 167 | 1969-12-11 | 2 | 2 | 0 | 0 | 5 | 0 | 1968-11-20 | W | 2026-06-07 07:03:19.438319 | 2026-06-07 07:03:19.438319 | 1 | International Results CSV 1 | h2h://125:167/1969-12-11 | |||
| 8217 | Thailand 143 | Laos 167 | 1970-11-08 | 4 | 3 | 1 | 0 | 14 | 8 | 1969-11-21 | L | 2026-06-07 07:03:19.491745 | 2026-06-07 07:03:19.491745 | 1 | International Results CSV 1 | h2h://143:167/1970-11-08 | |||
| 8230 | South Korea 114 | Laos 167 | 1970-11-12 | 1 | 1 | 0 | 0 | 2 | 0 | 1969-11-19 | W | 2026-06-07 07:03:19.494265 | 2026-06-07 07:03:19.494266 | 1 | International Results CSV 1 | h2h://114:167/1970-11-12 | |||
| 8234 | Singapore 135 | Laos 167 | 1970-11-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.495039 | 2026-06-07 07:03:19.495039 | 1 | International Results CSV 1 | h2h://167:135/1970-11-14 | |||||
| 8245 | Hong Kong 134 | Laos 167 | 1970-11-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.497227 | 2026-06-07 07:03:19.497227 | 1 | International Results CSV 1 | h2h://134:167/1970-11-16 | |||||
| 8682 | Malaysia 136 | Laos 167 | 1971-12-12 | 3 | 2 | 0 | 1 | 8 | 2 | 1969-12-06 | W | 2026-06-07 07:03:19.583506 | 2026-06-07 07:03:19.583506 | 1 | International Results CSV 1 | h2h://136:167/1971-12-12 | |||
| 8687 | Cambodia 142 | Laos 167 | 1971-12-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.584478 | 2026-06-07 07:03:19.584479 | 1 | International Results CSV 1 | h2h://167:142/1971-12-14 | |||||
| 8692 | Thailand 143 | Laos 167 | 1971-12-15 | 5 | 4 | 1 | 0 | 15 | 8 | 1970-11-08 | W | 2026-06-07 07:03:19.585462 | 2026-06-07 07:03:19.585463 | 1 | International Results CSV 1 | h2h://143:167/1971-12-15 | |||
| 8865 | Malaysia 136 | Laos 167 | 1972-06-09 | 4 | 3 | 0 | 1 | 13 | 2 | 1971-12-12 | L | 2026-06-07 07:03:19.619421 | 2026-06-07 07:03:19.619421 | 1 | International Results CSV 1 | h2h://167:136/1972-06-09 | |||
| 8869 | Myanmar 125 | Laos 167 | 1972-06-11 | 3 | 3 | 0 | 0 | 9 | 0 | 1969-12-11 | W | 2026-06-07 07:03:19.620218 | 2026-06-07 07:03:19.620218 | 1 | International Results CSV 1 | h2h://125:167/1972-06-11 | |||
| 8874 | Sri Lanka 130 | Laos 167 | 1972-06-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.621178 | 2026-06-07 07:03:19.621178 | 1 | International Results CSV 1 | h2h://167:130/1972-06-13 | |||||
| 9462 | Myanmar 125 | Laos 167 | 1973-09-02 | 4 | 4 | 0 | 0 | 15 | 1 | 1972-06-11 | W | 2026-06-07 07:03:19.737868 | 2026-06-07 07:03:19.737868 | 1 | International Results CSV 1 | h2h://125:167/1973-09-02 | |||
| 9465 | Vietnam Republic 144 | Laos 167 | 1973-09-04 | 4 | 3 | 0 | 1 | 19 | 0 | 1969-12-09 | D | 2026-06-07 07:03:19.738459 | 2026-06-07 07:03:19.738459 | 1 | International Results CSV 1 | h2h://144:167/1973-09-04 | |||
| 9595 | Singapore 135 | Laos 167 | 1973-12-15 | 1 | 0 | 1 | 0 | 0 | 3 | 1970-11-14 | W | 2026-06-07 07:03:19.764243 | 2026-06-07 07:03:19.764243 | 1 | International Results CSV 1 | h2h://167:135/1973-12-15 | |||
| 9600 | Thailand 143 | Laos 167 | 1973-12-17 | 6 | 5 | 1 | 0 | 18 | 8 | 1971-12-15 | W | 2026-06-07 07:03:19.765228 | 2026-06-07 07:03:19.765228 | 1 | International Results CSV 1 | h2h://143:167/1973-12-17 | |||
| 9603 | Myanmar 125 | Laos 167 | 1973-12-19 | 5 | 5 | 0 | 0 | 23 | 1 | 1973-09-02 | W | 2026-06-07 07:03:19.765814 | 2026-06-07 07:03:19.765815 | 1 | International Results CSV 1 | h2h://125:167/1973-12-19 | |||
| 9919 | Vietnam Republic 144 | Laos 167 | 1974-11-01 | 5 | 4 | 0 | 1 | 24 | 1 | 1973-09-04 | W | 2026-06-07 07:03:19.828171 | 2026-06-07 07:03:19.828171 | 1 | International Results CSV 1 | h2h://144:167/1974-11-01 | |||
| 9920 | Malaysia 136 | Laos 167 | 1974-11-02 | 5 | 4 | 0 | 1 | 15 | 3 | 1972-06-09 | L | 2026-06-07 07:03:19.828369 | 2026-06-07 07:03:19.828369 | 1 | International Results CSV 1 | h2h://167:136/1974-11-02 | |||
| 9927 | Taiwan 123 | Laos 167 | 1974-11-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.829740 | 2026-06-07 07:03:19.829740 | 1 | International Results CSV 1 | h2h://167:123/1974-11-05 | |||||
| 9964 | Singapore 135 | Laos 167 | 1974-12-10 | 2 | 0 | 2 | 0 | 2 | 6 | 1973-12-15 | W | 2026-06-07 07:03:19.837061 | 2026-06-07 07:03:19.837061 | 1 | International Results CSV 1 | h2h://167:135/1974-12-10 | |||
| 9969 | Thailand 143 | Laos 167 | 1974-12-12 | 7 | 6 | 1 | 0 | 23 | 8 | 1973-12-17 | W | 2026-06-07 07:03:19.838043 | 2026-06-07 07:03:19.838043 | 1 | International Results CSV 1 | h2h://143:167/1974-12-12 | |||
| 9971 | Malaysia 136 | Laos 167 | 1974-12-14 | 6 | 4 | 0 | 2 | 15 | 3 | 1974-11-02 | D | 2026-06-07 07:03:19.838434 | 2026-06-07 07:03:19.838434 | 1 | International Results CSV 1 | h2h://167:136/1974-12-14 | |||
| 19102 | Myanmar 125 | Laos 167 | 1993-06-09 | 6 | 6 | 0 | 0 | 25 | 2 | 1973-12-19 | W | 2026-06-07 07:03:22.245328 | 2026-06-07 07:03:22.245329 | 1 | International Results CSV 1 | h2h://125:167/1993-06-09 | |||
| 19111 | Malaysia 136 | Laos 167 | 1993-06-11 | 7 | 4 | 0 | 3 | 17 | 5 | 1974-12-14 | D | 2026-06-07 07:03:22.247148 | 2026-06-07 07:03:22.247148 | 1 | International Results CSV 1 | h2h://136:167/1993-06-11 | |||
| 19122 | Thailand 143 | Laos 167 | 1993-06-13 | 8 | 7 | 1 | 0 | 29 | 9 | 1974-12-12 | W | 2026-06-07 07:03:22.249344 | 2026-06-07 07:03:22.249344 | 1 | International Results CSV 1 | h2h://143:167/1993-06-13 | |||
| 20718 | Philippines 32 | Laos 167 | 1995-12-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.883122 | 2026-06-07 07:03:22.883122 | 1 | International Results CSV 1 | h2h://167:32/1995-12-06 | |||||
| 20731 | Singapore 135 | Laos 167 | 1995-12-10 | 3 | 1 | 2 | 0 | 4 | 6 | 1974-12-10 | W | 2026-06-07 07:03:22.885645 | 2026-06-07 07:03:22.885645 | 1 | International Results CSV 1 | h2h://135:167/1995-12-10 | |||
| 20738 | Myanmar 125 | Laos 167 | 1995-12-12 | 7 | 7 | 0 | 0 | 32 | 3 | 1993-06-09 | W | 2026-06-07 07:03:22.886971 | 2026-06-07 07:03:22.886972 | 1 | International Results CSV 1 | h2h://125:167/1995-12-12 | |||
| 21297 | Indonesia 83 | Laos 167 | 1996-09-02 | 1 | 1 | 0 | 0 | 3 | 1 | 1969-11-26 | L | 2026-06-07 07:03:22.993666 | 2026-06-07 07:03:22.993667 | 1 | International Results CSV 1 | h2h://167:83/1996-09-02 | |||
| 21306 | Vietnam 115 | Laos 167 | 1996-09-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.995396 | 2026-06-07 07:03:22.995397 | 1 | International Results CSV 1 | h2h://167:115/1996-09-05 | |||||
| 21316 | Cambodia 142 | Laos 167 | 1996-09-09 | 1 | 1 | 0 | 0 | 2 | 0 | 1971-12-14 | L | 2026-06-07 07:03:22.997337 | 2026-06-07 07:03:22.997338 | 1 | International Results CSV 1 | h2h://167:142/1996-09-09 | |||
| 21320 | Myanmar 125 | Laos 167 | 1996-09-11 | 8 | 8 | 0 | 0 | 33 | 3 | 1995-12-12 | L | 2026-06-07 07:03:22.998099 | 2026-06-07 07:03:22.998099 | 1 | International Results CSV 1 | h2h://167:125/1996-09-11 | |||
| 22341 | Indonesia 83 | Laos 167 | 1997-10-05 | 2 | 2 | 0 | 0 | 8 | 2 | 1996-09-02 | W | 2026-06-07 07:03:23.195043 | 2026-06-07 07:03:23.195044 | 1 | International Results CSV 1 | h2h://83:167/1997-10-05 | |||
| 22351 | Philippines 32 | Laos 167 | 1997-10-09 | 1 | 0 | 1 | 0 | 0 | 1 | 1995-12-06 | W | 2026-06-07 07:03:23.196946 | 2026-06-07 07:03:23.196947 | 1 | International Results CSV 1 | h2h://167:32/1997-10-09 | |||
| 22388 | Vietnam 115 | Laos 167 | 1997-10-12 | 1 | 0 | 0 | 1 | 1 | 1 | 1996-09-05 | D | 2026-06-07 07:03:23.204063 | 2026-06-07 07:03:23.204064 | 1 | International Results CSV 1 | h2h://115:167/1997-10-12 | |||
| 22392 | Malaysia 136 | Laos 167 | 1997-10-14 | 8 | 5 | 0 | 3 | 26 | 5 | 1993-06-11 | L | 2026-06-07 07:03:23.204830 | 2026-06-07 07:03:23.204830 | 1 | International Results CSV 1 | h2h://167:136/1997-10-14 | |||
| 22657 | Myanmar 125 | Laos 167 | 1998-03-18 | 9 | 9 | 0 | 0 | 37 | 5 | 1996-09-11 | W | 2026-06-07 07:03:23.255548 | 2026-06-07 07:03:23.255548 | 1 | International Results CSV 1 | h2h://125:167/1998-03-18 | |||
| 22983 | Vietnam 115 | Laos 167 | 1998-08-26 | 2 | 1 | 0 | 1 | 3 | 2 | 1997-10-12 | W | 2026-06-07 07:03:23.317680 | 2026-06-07 07:03:23.317680 | 1 | International Results CSV 1 | h2h://115:167/1998-08-26 | |||
| 22986 | Malaysia 136 | Laos 167 | 1998-08-28 | 9 | 5 | 1 | 3 | 26 | 6 | 1997-10-14 | L | 2026-06-07 07:03:23.318261 | 2026-06-07 07:03:23.318262 | 1 | International Results CSV 1 | h2h://136:167/1998-08-28 | |||
| 22992 | Singapore 135 | Laos 167 | 1998-08-30 | 4 | 1 | 2 | 1 | 4 | 6 | 1995-12-10 | D | 2026-06-07 07:03:23.319401 | 2026-06-07 07:03:23.319401 | 1 | International Results CSV 1 | h2h://135:167/1998-08-30 | |||
| 23230 | Iran 99 | Laos 167 | 1998-12-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.364491 | 2026-06-07 07:03:23.364492 | 1 | International Results CSV 1 | h2h://99:167/1998-12-05 | |||||
| 23749 | Vietnam 115 | Laos 167 | 1999-07-30 | 3 | 2 | 0 | 1 | 7 | 3 | 1998-08-26 | W | 2026-06-07 07:03:23.463518 | 2026-06-07 07:03:23.463519 | 1 | International Results CSV 1 | h2h://115:167/1999-07-30 | |||
| 23758 | Thailand 143 | Laos 167 | 1999-08-01 | 9 | 8 | 1 | 0 | 33 | 10 | 1993-06-13 | L | 2026-06-07 07:03:23.465314 | 2026-06-07 07:03:23.465314 | 1 | International Results CSV 1 | h2h://167:143/1999-08-01 | |||
| 23767 | Philippines 32 | Laos 167 | 1999-08-03 | 2 | 0 | 2 | 0 | 1 | 5 | 1997-10-09 | L | 2026-06-07 07:03:23.467044 | 2026-06-07 07:03:23.467045 | 1 | International Results CSV 1 | h2h://32:167/1999-08-03 | |||
| 23773 | Myanmar 125 | Laos 167 | 1999-08-05 | 10 | 10 | 0 | 0 | 40 | 5 | 1998-03-18 | L | 2026-06-07 07:03:23.468205 | 2026-06-07 07:03:23.468205 | 1 | International Results CSV 1 | h2h://167:125/1999-08-05 | |||
| 24336 | South Korea 114 | Laos 167 | 2000-04-05 | 2 | 2 | 0 | 0 | 6 | 0 | 1970-11-12 | W | 2026-06-07 07:03:23.580631 | 2026-06-07 07:03:23.580632 | 1 | International Results CSV 1 | h2h://114:167/2000-04-05 | |||
| 24341 | Myanmar 125 | Laos 167 | 2000-04-07 | 11 | 10 | 0 | 1 | 40 | 5 | 1999-08-05 | D | 2026-06-07 07:03:23.581574 | 2026-06-07 07:03:23.581574 | 1 | International Results CSV 1 | h2h://125:167/2000-04-07 | |||
| 24368 | Mongolia 100 | Laos 167 | 2000-04-09 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.586695 | 2026-06-07 07:03:23.586695 | 1 | International Results CSV 1 | h2h://167:100/2000-04-09 | |||||
| 25014 | Malaysia 136 | Laos 167 | 2000-11-07 | 10 | 5 | 1 | 4 | 26 | 6 | 1998-08-28 | D | 2026-06-07 07:03:24.041569 | 2026-06-07 07:03:24.041569 | 1 | International Results CSV 1 | h2h://167:136/2000-11-07 | |||
| 25017 | Singapore 135 | Laos 167 | 2000-11-09 | 5 | 2 | 2 | 1 | 8 | 7 | 1998-08-30 | W | 2026-06-07 07:03:24.042150 | 2026-06-07 07:03:24.042150 | 1 | International Results CSV 1 | h2h://135:167/2000-11-09 | |||
| 25019 | Cambodia 142 | Laos 167 | 2000-11-11 | 2 | 1 | 1 | 0 | 2 | 1 | 1996-09-09 | L | 2026-06-07 07:03:24.042550 | 2026-06-07 07:03:24.042551 | 1 | International Results CSV 1 | h2h://142:167/2000-11-11 | |||
| 25024 | Vietnam 115 | Laos 167 | 2000-11-13 | 4 | 3 | 0 | 1 | 16 | 3 | 1999-07-30 | L | 2026-06-07 07:03:24.043526 | 2026-06-07 07:03:24.043527 | 1 | International Results CSV 1 | h2h://167:115/2000-11-13 | |||
| 25522 | Syria 121 | Laos 167 | 2001-05-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.138344 | 2026-06-07 07:03:24.138344 | 1 | International Results CSV 1 | h2h://121:167/2001-05-07 | |||||
| 25529 | Syria 121 | Laos 167 | 2001-05-11 | 1 | 1 | 0 | 0 | 11 | 0 | 2001-05-07 | W | 2026-06-07 07:03:24.139699 | 2026-06-07 07:03:24.139699 | 1 | International Results CSV 1 | h2h://121:167/2001-05-11 | |||
| 25551 | Philippines 32 | Laos 167 | 2001-05-19 | 3 | 0 | 3 | 0 | 3 | 8 | 1999-08-03 | W | 2026-06-07 07:03:24.143884 | 2026-06-07 07:03:24.143885 | 1 | International Results CSV 1 | h2h://167:32/2001-05-19 | |||
| 25574 | Philippines 32 | Laos 167 | 2001-05-26 | 4 | 0 | 4 | 0 | 3 | 10 | 2001-05-19 | L | 2026-06-07 07:03:24.148280 | 2026-06-07 07:03:24.148280 | 1 | International Results CSV 1 | h2h://32:167/2001-05-26 | |||
| 26852 | Thailand 143 | Laos 167 | 2002-12-18 | 10 | 9 | 1 | 0 | 37 | 11 | 1999-08-01 | W | 2026-06-07 07:03:24.393600 | 2026-06-07 07:03:24.393600 | 1 | International Results CSV 1 | h2h://143:167/2002-12-18 | |||
| 26858 | Singapore 135 | Laos 167 | 2002-12-20 | 6 | 3 | 2 | 1 | 11 | 7 | 2000-11-09 | W | 2026-06-07 07:03:24.394746 | 2026-06-07 07:03:24.394747 | 1 | International Results CSV 1 | h2h://135:167/2002-12-20 | |||
| 26865 | Malaysia 136 | Laos 167 | 2002-12-22 | 11 | 6 | 1 | 4 | 31 | 6 | 2000-11-07 | W | 2026-06-07 07:03:24.396119 | 2026-06-07 07:03:24.396119 | 1 | International Results CSV 1 | h2h://136:167/2002-12-22 | |||
| 27029 | Hong Kong 134 | Laos 167 | 2003-03-25 | 1 | 1 | 0 | 0 | 4 | 2 | 1970-11-16 | W | 2026-06-07 07:03:24.427933 | 2026-06-07 07:03:24.427933 | 1 | International Results CSV 1 | h2h://134:167/2003-03-25 | |||
| 27779 | Sri Lanka 130 | Laos 167 | 2003-11-29 | 1 | 1 | 0 | 0 | 3 | 1 | 1972-06-13 | L | 2026-06-07 07:03:24.571473 | 2026-06-07 07:03:24.571473 | 1 | International Results CSV 1 | h2h://167:130/2003-11-29 | |||
| 27791 | Sri Lanka 130 | Laos 167 | 2003-12-03 | 2 | 1 | 0 | 1 | 3 | 1 | 2003-11-29 | D | 2026-06-07 07:03:24.573702 | 2026-06-07 07:03:24.573703 | 1 | International Results CSV 1 | h2h://130:167/2003-12-03 | |||
| 28033 | Iran 99 | Laos 167 | 2004-03-31 | 1 | 1 | 0 | 0 | 6 | 1 | 1998-12-05 | L | 2026-06-07 07:03:24.620026 | 2026-06-07 07:03:24.620027 | 1 | International Results CSV 1 | h2h://167:99/2004-03-31 | |||
| 28770 | Iran 99 | Laos 167 | 2004-11-17 | 2 | 2 | 0 | 0 | 13 | 1 | 2004-03-31 | W | 2026-06-07 07:03:24.761034 | 2026-06-07 07:03:24.761034 | 1 | International Results CSV 1 | h2h://99:167/2004-11-17 | |||
| 28837 | Indonesia 83 | Laos 167 | 2004-12-07 | 3 | 3 | 0 | 0 | 13 | 4 | 1997-10-05 | L | 2026-06-07 07:03:24.773791 | 2026-06-07 07:03:24.773791 | 1 | International Results CSV 1 | h2h://167:83/2004-12-07 | |||
| 28849 | Cambodia 142 | Laos 167 | 2004-12-11 | 3 | 2 | 1 | 0 | 5 | 1 | 2000-11-11 | L | 2026-06-07 07:03:24.776103 | 2026-06-07 07:03:24.776103 | 1 | International Results CSV 1 | h2h://167:142/2004-12-11 | |||
| 28865 | Singapore 135 | Laos 167 | 2004-12-13 | 7 | 4 | 2 | 1 | 13 | 8 | 2002-12-20 | W | 2026-06-07 07:03:24.779187 | 2026-06-07 07:03:24.779187 | 1 | International Results CSV 1 | h2h://135:167/2004-12-13 | |||
| 28878 | Vietnam 115 | Laos 167 | 2004-12-15 | 5 | 4 | 0 | 1 | 21 | 3 | 2000-11-13 | W | 2026-06-07 07:03:24.781711 | 2026-06-07 07:03:24.781712 | 1 | International Results CSV 1 | h2h://115:167/2004-12-15 | |||
| 30420 | Philippines 32 | Laos 167 | 2006-11-12 | 5 | 0 | 4 | 1 | 4 | 11 | 2001-05-26 | D | 2026-06-07 07:03:25.409682 | 2026-06-07 07:03:25.409682 | 1 | International Results CSV 1 | h2h://32:167/2006-11-12 | |||
| 30423 | Cambodia 142 | Laos 167 | 2006-11-14 | 4 | 2 | 2 | 0 | 6 | 3 | 2004-12-11 | L | 2026-06-07 07:03:25.410248 | 2026-06-07 07:03:25.410249 | 1 | International Results CSV 1 | h2h://142:167/2006-11-14 | |||
| 30571 | Indonesia 83 | Laos 167 | 2007-01-13 | 4 | 4 | 0 | 0 | 19 | 4 | 2004-12-07 | W | 2026-06-07 07:03:25.438266 | 2026-06-07 07:03:25.438266 | 1 | International Results CSV 1 | h2h://83:167/2007-01-13 | |||
| 30580 | Singapore 135 | Laos 167 | 2007-01-15 | 8 | 5 | 2 | 1 | 19 | 10 | 2004-12-13 | W | 2026-06-07 07:03:25.439982 | 2026-06-07 07:03:25.439983 | 1 | International Results CSV 1 | h2h://135:167/2007-01-15 | |||
| 30591 | Vietnam 115 | Laos 167 | 2007-01-17 | 6 | 5 | 0 | 1 | 24 | 3 | 2004-12-15 | W | 2026-06-07 07:03:25.442159 | 2026-06-07 07:03:25.442160 | 1 | International Results CSV 1 | h2h://115:167/2007-01-17 | |||
| 31165 | Myanmar 125 | Laos 167 | 2007-08-25 | 12 | 11 | 0 | 1 | 44 | 5 | 2000-04-07 | W | 2026-06-07 07:03:25.552335 | 2026-06-07 07:03:25.552335 | 1 | International Results CSV 1 | h2h://125:167/2007-08-25 | |||
| 32503 | Cambodia 142 | Laos 167 | 2008-10-17 | 5 | 2 | 2 | 1 | 8 | 5 | 2006-11-14 | D | 2026-06-07 07:03:25.811319 | 2026-06-07 07:03:25.811319 | 1 | International Results CSV 1 | h2h://142:167/2008-10-17 | |||
| 32511 | Philippines 32 | Laos 167 | 2008-10-21 | 6 | 0 | 5 | 1 | 5 | 13 | 2006-11-12 | L | 2026-06-07 07:03:25.812868 | 2026-06-07 07:03:25.812869 | 1 | International Results CSV 1 | h2h://32:167/2008-10-21 | |||
| 32609 | Malaysia 136 | Laos 167 | 2008-12-06 | 12 | 6 | 1 | 5 | 32 | 7 | 2002-12-22 | D | 2026-06-07 07:03:25.831790 | 2026-06-07 07:03:25.831790 | 1 | International Results CSV 1 | h2h://136:167/2008-12-06 | |||
| 32618 | Thailand 143 | Laos 167 | 2008-12-08 | 11 | 10 | 1 | 0 | 42 | 12 | 2002-12-18 | W | 2026-06-07 07:03:25.833549 | 2026-06-07 07:03:25.833550 | 1 | International Results CSV 1 | h2h://143:167/2008-12-08 | |||
| 32622 | Vietnam 115 | Laos 167 | 2008-12-10 | 7 | 6 | 0 | 1 | 33 | 3 | 2007-01-17 | W | 2026-06-07 07:03:25.834357 | 2026-06-07 07:03:25.834358 | 1 | International Results CSV 1 | h2h://115:167/2008-12-10 | |||
| 34261 | Cambodia 142 | Laos 167 | 2010-10-22 | 6 | 3 | 2 | 1 | 11 | 7 | 2008-10-17 | L | 2026-06-07 07:03:26.148047 | 2026-06-07 07:03:26.148048 | 1 | International Results CSV 1 | h2h://167:142/2010-10-22 | |||
| 34266 | Philippines 32 | Laos 167 | 2010-10-24 | 7 | 0 | 6 | 1 | 6 | 15 | 2008-10-21 | W | 2026-06-07 07:03:26.149005 | 2026-06-07 07:03:26.149005 | 1 | International Results CSV 1 | h2h://167:32/2010-10-24 | |||
| 34358 | Singapore 135 | Laos 167 | 2010-11-26 | 9 | 6 | 2 | 1 | 30 | 10 | 2007-01-15 | W | 2026-06-07 07:03:26.166637 | 2026-06-07 07:03:26.166637 | 1 | International Results CSV 1 | h2h://135:167/2010-11-26 | |||
| 34384 | Thailand 143 | Laos 167 | 2010-12-01 | 12 | 11 | 1 | 0 | 48 | 12 | 2008-12-08 | W | 2026-06-07 07:03:26.171687 | 2026-06-07 07:03:26.171687 | 1 | International Results CSV 1 | h2h://143:167/2010-12-01 |
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)
);