h2h_record
223 rows where team_a_id = 179
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8003 | Saudi Arabia 179 | Bahrain 183 | 1970-03-30 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.449278 | 2026-06-07 07:03:19.449278 | 1 | International Results CSV 1 | h2h://183:179/1970-03-30 | |||||
| 8006 | Saudi Arabia 179 | Qatar 190 | 1970-04-02 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.449854 | 2026-06-07 07:03:19.449854 | 1 | International Results CSV 1 | h2h://179:190/1970-04-02 | |||||
| 8773 | Saudi Arabia 179 | United Arab Emirates 196 | 1972-03-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.601221 | 2026-06-07 07:03:19.601221 | 1 | International Results CSV 1 | h2h://179:196/1972-03-19 | |||||
| 8776 | Saudi Arabia 179 | Qatar 190 | 1972-03-24 | 1 | 0 | 0 | 1 | 1 | 1 | 1970-04-02 | D | 2026-06-07 07:03:19.601804 | 2026-06-07 07:03:19.601805 | 1 | International Results CSV 1 | h2h://179:190/1972-03-24 | |||
| 8779 | Saudi Arabia 179 | Bahrain 183 | 1972-03-28 | 1 | 0 | 0 | 1 | 0 | 0 | 1970-03-30 | D | 2026-06-07 07:03:19.602390 | 2026-06-07 07:03:19.602391 | 1 | International Results CSV 1 | h2h://179:183/1972-03-28 | |||
| 9667 | Saudi Arabia 179 | Qatar 190 | 1974-03-16 | 2 | 1 | 0 | 1 | 5 | 1 | 1972-03-24 | L | 2026-06-07 07:03:19.778404 | 2026-06-07 07:03:19.778404 | 1 | International Results CSV 1 | h2h://190:179/1974-03-16 | |||
| 9670 | Saudi Arabia 179 | Bahrain 183 | 1974-03-21 | 2 | 1 | 0 | 1 | 2 | 1 | 1972-03-28 | L | 2026-06-07 07:03:19.778984 | 2026-06-07 07:03:19.778985 | 1 | International Results CSV 1 | h2h://183:179/1974-03-21 | |||
| 9674 | Saudi Arabia 179 | United Arab Emirates 196 | 1974-03-23 | 1 | 1 | 0 | 0 | 4 | 0 | 1972-03-19 | W | 2026-06-07 07:03:19.779764 | 2026-06-07 07:03:19.779765 | 1 | International Results CSV 1 | h2h://179:196/1974-03-23 | |||
| 9678 | Saudi Arabia 179 | Qatar 190 | 1974-03-26 | 3 | 2 | 0 | 1 | 7 | 1 | 1974-03-16 | L | 2026-06-07 07:03:19.780541 | 2026-06-07 07:03:19.780542 | 1 | International Results CSV 1 | h2h://190:179/1974-03-26 | |||
| 10064 | Saudi Arabia 179 | Qatar 190 | 1975-04-04 | 4 | 3 | 0 | 1 | 10 | 2 | 1974-03-26 | W | 2026-06-07 07:03:20.165059 | 2026-06-07 07:03:20.165060 | 1 | International Results CSV 1 | h2h://179:190/1975-04-04 | |||
| 10079 | Saudi Arabia 179 | Qatar 190 | 1975-04-14 | 5 | 4 | 0 | 1 | 12 | 3 | 1975-04-04 | W | 2026-06-07 07:03:20.167882 | 2026-06-07 07:03:20.167882 | 1 | International Results CSV 1 | h2h://179:190/1975-04-14 | |||
| 10372 | Saudi Arabia 179 | Yemen DPR 195 | 1975-12-21 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.224165 | 2026-06-07 07:03:20.224166 | 1 | International Results CSV 1 | h2h://179:195/1975-12-21 | |||||
| 10461 | Saudi Arabia 179 | Qatar 190 | 1976-03-26 | 6 | 4 | 1 | 1 | 12 | 4 | 1975-04-14 | W | 2026-06-07 07:03:20.241119 | 2026-06-07 07:03:20.241120 | 1 | International Results CSV 1 | h2h://190:179/1976-03-26 | |||
| 10470 | Saudi Arabia 179 | United Arab Emirates 196 | 1976-03-29 | 2 | 2 | 0 | 0 | 6 | 0 | 1974-03-23 | W | 2026-06-07 07:03:20.242847 | 2026-06-07 07:03:20.242847 | 1 | International Results CSV 1 | h2h://179:196/1976-03-29 | |||
| 10479 | Saudi Arabia 179 | Oman 184 | 1976-04-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.244547 | 2026-06-07 07:03:20.244547 | 1 | International Results CSV 1 | h2h://184:179/1976-04-04 | |||||
| 10488 | Saudi Arabia 179 | Bahrain 183 | 1976-04-08 | 3 | 2 | 0 | 1 | 6 | 2 | 1974-03-21 | L | 2026-06-07 07:03:20.246291 | 2026-06-07 07:03:20.246291 | 1 | International Results CSV 1 | h2h://183:179/1976-04-08 | |||
| 11597 | Saudi Arabia 179 | Qatar 190 | 1978-12-12 | 7 | 4 | 2 | 1 | 12 | 5 | 1976-03-26 | W | 2026-06-07 07:03:20.461829 | 2026-06-07 07:03:20.461829 | 1 | International Results CSV 1 | h2h://190:179/1978-12-12 | |||
| 11687 | Saudi Arabia 179 | United Arab Emirates 196 | 1979-03-24 | 3 | 3 | 0 | 0 | 8 | 0 | 1976-03-29 | W | 2026-06-07 07:03:20.479555 | 2026-06-07 07:03:20.479556 | 1 | International Results CSV 1 | h2h://179:196/1979-03-24 | |||
| 11696 | Saudi Arabia 179 | Oman 184 | 1979-03-28 | 1 | 1 | 0 | 0 | 3 | 1 | 1976-04-04 | W | 2026-06-07 07:03:20.481331 | 2026-06-07 07:03:20.481332 | 1 | International Results CSV 1 | h2h://179:184/1979-03-28 | |||
| 11704 | Saudi Arabia 179 | Bahrain 183 | 1979-04-02 | 4 | 2 | 1 | 1 | 7 | 4 | 1976-04-08 | L | 2026-06-07 07:03:20.482894 | 2026-06-07 07:03:20.482895 | 1 | International Results CSV 1 | h2h://179:183/1979-04-02 | |||
| 11710 | Saudi Arabia 179 | Qatar 190 | 1979-04-04 | 8 | 4 | 2 | 2 | 14 | 7 | 1978-12-12 | D | 2026-06-07 07:03:20.484088 | 2026-06-07 07:03:20.484089 | 1 | International Results CSV 1 | h2h://179:190/1979-04-04 | |||
| 12405 | Saudi Arabia 179 | Northern Cyprus 208 | 1980-09-30 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.621928 | 2026-06-07 07:03:20.621928 | 1 | International Results CSV 1 | h2h://208:179/1980-09-30 | |||||
| 12673 | Saudi Arabia 179 | Bahrain 183 | 1981-03-28 | 5 | 2 | 1 | 2 | 8 | 5 | 1979-04-02 | D | 2026-06-07 07:03:20.674945 | 2026-06-07 07:03:20.674946 | 1 | International Results CSV 1 | h2h://179:183/1981-03-28 | |||
| 12676 | Saudi Arabia 179 | Qatar 190 | 1981-03-31 | 9 | 5 | 2 | 2 | 21 | 7 | 1979-04-04 | W | 2026-06-07 07:03:20.675544 | 2026-06-07 07:03:20.675544 | 1 | International Results CSV 1 | h2h://179:190/1981-03-31 | |||
| 13186 | Saudi Arabia 179 | United Arab Emirates 196 | 1982-03-21 | 4 | 4 | 0 | 0 | 10 | 1 | 1979-03-24 | L | 2026-06-07 07:03:20.777166 | 2026-06-07 07:03:20.777166 | 1 | International Results CSV 1 | h2h://196:179/1982-03-21 | |||
| 13203 | Saudi Arabia 179 | Qatar 190 | 1982-03-29 | 10 | 6 | 2 | 2 | 22 | 7 | 1981-03-31 | W | 2026-06-07 07:03:20.780566 | 2026-06-07 07:03:20.780567 | 1 | International Results CSV 1 | h2h://179:190/1982-03-29 | |||
| 13206 | Saudi Arabia 179 | Oman 184 | 1982-03-31 | 2 | 2 | 0 | 0 | 7 | 1 | 1979-03-28 | W | 2026-06-07 07:03:20.781163 | 2026-06-07 07:03:20.781163 | 1 | International Results CSV 1 | h2h://179:184/1982-03-31 | |||
| 13208 | Saudi Arabia 179 | Bahrain 183 | 1982-04-02 | 6 | 3 | 1 | 2 | 9 | 5 | 1981-03-28 | L | 2026-06-07 07:03:20.781555 | 2026-06-07 07:03:20.781556 | 1 | International Results CSV 1 | h2h://183:179/1982-04-02 | |||
| 14051 | Saudi Arabia 179 | Qatar 190 | 1984-03-10 | 11 | 7 | 2 | 2 | 23 | 7 | 1982-03-29 | W | 2026-06-07 07:03:20.948783 | 2026-06-07 07:03:20.948783 | 1 | International Results CSV 1 | h2h://179:190/1984-03-10 | |||
| 14063 | Saudi Arabia 179 | Oman 184 | 1984-03-15 | 3 | 3 | 0 | 0 | 10 | 1 | 1982-03-31 | L | 2026-06-07 07:03:20.951159 | 2026-06-07 07:03:20.951160 | 1 | International Results CSV 1 | h2h://184:179/1984-03-15 | |||
| 14077 | Saudi Arabia 179 | United Arab Emirates 196 | 1984-03-23 | 5 | 4 | 1 | 0 | 10 | 2 | 1982-03-21 | L | 2026-06-07 07:03:20.953931 | 2026-06-07 07:03:20.953931 | 1 | International Results CSV 1 | h2h://179:196/1984-03-23 | |||
| 14081 | Saudi Arabia 179 | Bahrain 183 | 1984-03-26 | 7 | 3 | 1 | 3 | 11 | 7 | 1982-04-02 | D | 2026-06-07 07:03:20.954723 | 2026-06-07 07:03:20.954723 | 1 | International Results CSV 1 | h2h://183:179/1984-03-26 | |||
| 14358 | Saudi Arabia 179 | Nepal 198 | 1984-10-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.009564 | 2026-06-07 07:03:21.009564 | 1 | International Results CSV 1 | h2h://179:198/1984-10-19 | |||||
| 14365 | Saudi Arabia 179 | United Arab Emirates 196 | 1984-10-22 | 6 | 5 | 1 | 0 | 12 | 2 | 1984-03-23 | W | 2026-06-07 07:03:21.010925 | 2026-06-07 07:03:21.010925 | 1 | International Results CSV 1 | h2h://179:196/1984-10-22 | |||
| 14371 | Saudi Arabia 179 | Oman 184 | 1984-10-26 | 4 | 4 | 0 | 0 | 13 | 2 | 1984-03-15 | W | 2026-06-07 07:03:21.012099 | 2026-06-07 07:03:21.012099 | 1 | International Results CSV 1 | h2h://179:184/1984-10-26 | |||
| 14467 | Saudi Arabia 179 | Qatar 190 | 1984-12-08 | 12 | 7 | 3 | 2 | 24 | 9 | 1984-03-10 | W | 2026-06-07 07:03:21.031024 | 2026-06-07 07:03:21.031024 | 1 | International Results CSV 1 | h2h://190:179/1984-12-08 | |||
| 14716 | Saudi Arabia 179 | United Arab Emirates 196 | 1985-04-12 | 7 | 6 | 1 | 0 | 13 | 2 | 1984-10-22 | W | 2026-06-07 07:03:21.080304 | 2026-06-07 07:03:21.080304 | 1 | International Results CSV 1 | h2h://179:196/1985-04-12 | |||
| 14737 | Saudi Arabia 179 | United Arab Emirates 196 | 1985-04-19 | 8 | 6 | 1 | 1 | 13 | 2 | 1985-04-12 | D | 2026-06-07 07:03:21.084464 | 2026-06-07 07:03:21.084465 | 1 | International Results CSV 1 | h2h://196:179/1985-04-19 | |||
| 14882 | Saudi Arabia 179 | Qatar 190 | 1985-07-07 | 13 | 7 | 3 | 3 | 25 | 10 | 1984-12-08 | D | 2026-06-07 07:03:21.113334 | 2026-06-07 07:03:21.113335 | 1 | International Results CSV 1 | h2h://179:190/1985-07-07 | |||
| 14896 | Saudi Arabia 179 | Qatar 190 | 1985-07-12 | 14 | 8 | 3 | 3 | 26 | 10 | 1985-07-07 | W | 2026-06-07 07:03:21.116075 | 2026-06-07 07:03:21.116075 | 1 | International Results CSV 1 | h2h://179:190/1985-07-12 | |||
| 15225 | Saudi Arabia 179 | Bahrain 183 | 1986-03-25 | 8 | 4 | 1 | 3 | 13 | 7 | 1984-03-26 | L | 2026-06-07 07:03:21.494507 | 2026-06-07 07:03:21.494508 | 1 | International Results CSV 1 | h2h://183:179/1986-03-25 | |||
| 15236 | Saudi Arabia 179 | Oman 184 | 1986-03-28 | 5 | 5 | 0 | 0 | 19 | 2 | 1984-10-26 | W | 2026-06-07 07:03:21.496577 | 2026-06-07 07:03:21.496578 | 1 | International Results CSV 1 | h2h://179:184/1986-03-28 | |||
| 15244 | Saudi Arabia 179 | United Arab Emirates 196 | 1986-04-02 | 9 | 6 | 2 | 1 | 13 | 3 | 1985-04-19 | L | 2026-06-07 07:03:21.498113 | 2026-06-07 07:03:21.498113 | 1 | International Results CSV 1 | h2h://179:196/1986-04-02 | |||
| 15247 | Saudi Arabia 179 | Qatar 190 | 1986-04-05 | 15 | 8 | 3 | 4 | 26 | 10 | 1985-07-12 | D | 2026-06-07 07:03:21.498695 | 2026-06-07 07:03:21.498696 | 1 | International Results CSV 1 | h2h://190:179/1986-04-05 | |||
| 15464 | Saudi Arabia 179 | Qatar 190 | 1986-09-29 | 16 | 9 | 3 | 4 | 28 | 10 | 1986-04-05 | L | 2026-06-07 07:03:21.539972 | 2026-06-07 07:03:21.539973 | 1 | International Results CSV 1 | h2h://190:179/1986-09-29 | |||
| 16003 | Saudi Arabia 179 | Oman 184 | 1988-03-02 | 6 | 6 | 0 | 0 | 22 | 3 | 1986-03-28 | W | 2026-06-07 07:03:21.642829 | 2026-06-07 07:03:21.642829 | 1 | International Results CSV 1 | h2h://179:184/1988-03-02 | |||
| 16009 | Saudi Arabia 179 | Qatar 190 | 1988-03-05 | 17 | 10 | 3 | 4 | 29 | 10 | 1986-09-29 | W | 2026-06-07 07:03:21.643965 | 2026-06-07 07:03:21.643965 | 1 | International Results CSV 1 | h2h://179:190/1988-03-05 | |||
| 16014 | Saudi Arabia 179 | Bahrain 183 | 1988-03-09 | 9 | 4 | 2 | 3 | 14 | 9 | 1986-03-25 | L | 2026-06-07 07:03:21.644909 | 2026-06-07 07:03:21.644909 | 1 | International Results CSV 1 | h2h://179:183/1988-03-09 | |||
| 16024 | Saudi Arabia 179 | United Arab Emirates 196 | 1988-03-13 | 10 | 6 | 3 | 1 | 13 | 5 | 1986-04-02 | L | 2026-06-07 07:03:21.646842 | 2026-06-07 07:03:21.646842 | 1 | International Results CSV 1 | h2h://179:196/1988-03-13 | |||
| 16452 | Saudi Arabia 179 | Bahrain 183 | 1988-12-09 | 10 | 5 | 2 | 3 | 15 | 9 | 1988-03-09 | W | 2026-06-07 07:03:21.728899 | 2026-06-07 07:03:21.728899 | 1 | International Results CSV 1 | h2h://179:183/1988-12-09 | |||
| 16584 | Saudi Arabia 179 | Yemen 182 | 1989-03-20 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.754177 | 2026-06-07 07:03:21.754178 | 1 | International Results CSV 1 | h2h://182:179/1989-03-20 | |||||
| 16614 | Saudi Arabia 179 | Yemen 182 | 1989-04-05 | 1 | 1 | 0 | 0 | 1 | 0 | 1989-03-20 | W | 2026-06-07 07:03:21.759917 | 2026-06-07 07:03:21.759917 | 1 | International Results CSV 1 | h2h://179:182/1989-04-05 | |||
| 16994 | Saudi Arabia 179 | Qatar 190 | 1989-10-16 | 18 | 10 | 3 | 5 | 29 | 10 | 1988-03-05 | D | 2026-06-07 07:03:21.833017 | 2026-06-07 07:03:21.833017 | 1 | International Results CSV 1 | h2h://190:179/1989-10-16 | |||
| 16999 | Saudi Arabia 179 | United Arab Emirates 196 | 1989-10-21 | 11 | 6 | 3 | 2 | 15 | 7 | 1988-03-13 | D | 2026-06-07 07:03:21.833967 | 2026-06-07 07:03:21.833968 | 1 | International Results CSV 1 | h2h://179:196/1989-10-21 | |||
| 17460 | Saudi Arabia 179 | Bangladesh 200 | 1990-09-24 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.922158 | 2026-06-07 07:03:21.922159 | 1 | International Results CSV 1 | h2h://179:200/1990-09-24 | |||||
| 18472 | Saudi Arabia 179 | Palestine 181 | 1992-09-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.120227 | 2026-06-07 07:03:22.120227 | 1 | International Results CSV 1 | h2h://179:181/1992-09-13 | |||||
| 18578 | Saudi Arabia 179 | Qatar 190 | 1992-10-31 | 19 | 10 | 3 | 6 | 30 | 11 | 1989-10-16 | D | 2026-06-07 07:03:22.141197 | 2026-06-07 07:03:22.141197 | 1 | International Results CSV 1 | h2h://179:190/1992-10-31 | |||
| 18589 | Saudi Arabia 179 | United Arab Emirates 196 | 1992-11-06 | 12 | 6 | 3 | 3 | 15 | 7 | 1989-10-21 | D | 2026-06-07 07:03:22.143368 | 2026-06-07 07:03:22.143368 | 1 | International Results CSV 1 | h2h://179:196/1992-11-06 | |||
| 18647 | Saudi Arabia 179 | Bahrain 183 | 1992-11-28 | 11 | 5 | 2 | 4 | 16 | 10 | 1988-12-09 | D | 2026-06-07 07:03:22.155005 | 2026-06-07 07:03:22.155006 | 1 | International Results CSV 1 | h2h://179:183/1992-11-28 | |||
| 18653 | Saudi Arabia 179 | United Arab Emirates 196 | 1992-12-01 | 13 | 7 | 3 | 3 | 17 | 7 | 1992-11-06 | W | 2026-06-07 07:03:22.156202 | 2026-06-07 07:03:22.156202 | 1 | International Results CSV 1 | h2h://179:196/1992-12-01 | |||
| 18660 | Saudi Arabia 179 | Oman 184 | 1992-12-04 | 7 | 7 | 0 | 0 | 24 | 3 | 1988-03-02 | L | 2026-06-07 07:03:22.157603 | 2026-06-07 07:03:22.157603 | 1 | International Results CSV 1 | h2h://184:179/1992-12-04 | |||
| 18671 | Saudi Arabia 179 | Qatar 190 | 1992-12-10 | 20 | 10 | 3 | 7 | 31 | 12 | 1992-10-31 | D | 2026-06-07 07:03:22.159802 | 2026-06-07 07:03:22.159802 | 1 | International Results CSV 1 | h2h://190:179/1992-12-10 | |||
| 19901 | Saudi Arabia 179 | Uzbekistan 242 | 1994-10-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.404506 | 2026-06-07 07:03:22.404507 | 1 | International Results CSV 1 | h2h://179:242/1994-10-01 | |||||
| 19986 | Saudi Arabia 179 | Oman 184 | 1994-11-04 | 8 | 8 | 0 | 0 | 26 | 3 | 1992-12-04 | L | 2026-06-07 07:03:22.421387 | 2026-06-07 07:03:22.421388 | 1 | International Results CSV 1 | h2h://184:179/1994-11-04 | |||
| 19988 | Saudi Arabia 179 | United Arab Emirates 196 | 1994-11-06 | 14 | 7 | 4 | 3 | 17 | 8 | 1992-12-01 | W | 2026-06-07 07:03:22.421789 | 2026-06-07 07:03:22.421789 | 1 | International Results CSV 1 | h2h://196:179/1994-11-06 | |||
| 19995 | Saudi Arabia 179 | Bahrain 183 | 1994-11-10 | 12 | 5 | 3 | 4 | 17 | 12 | 1992-11-28 | L | 2026-06-07 07:03:22.423202 | 2026-06-07 07:03:22.423202 | 1 | International Results CSV 1 | h2h://179:183/1994-11-10 | |||
| 19998 | Saudi Arabia 179 | Qatar 190 | 1994-11-12 | 21 | 11 | 3 | 7 | 32 | 12 | 1992-12-10 | L | 2026-06-07 07:03:22.423792 | 2026-06-07 07:03:22.423793 | 1 | International Results CSV 1 | h2h://190:179/1994-11-12 | |||
| 20765 | Saudi Arabia 179 | Kazakhstan 212 | 1995-12-29 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.892105 | 2026-06-07 07:03:22.892105 | 1 | International Results CSV 1 | h2h://179:212/1995-12-29 | |||||
| 20820 | Saudi Arabia 179 | Yemen 182 | 1996-01-28 | 2 | 2 | 0 | 0 | 2 | 0 | 1989-04-05 | W | 2026-06-07 07:03:22.902566 | 2026-06-07 07:03:22.902567 | 1 | International Results CSV 1 | h2h://179:182/1996-01-28 | |||
| 20835 | Saudi Arabia 179 | Yemen 182 | 1996-02-04 | 3 | 3 | 0 | 0 | 6 | 0 | 1996-01-28 | W | 2026-06-07 07:03:22.905418 | 2026-06-07 07:03:22.905418 | 1 | International Results CSV 1 | h2h://179:182/1996-02-04 | |||
| 21422 | Saudi Arabia 179 | Oman 184 | 1996-10-15 | 9 | 9 | 0 | 0 | 28 | 4 | 1994-11-04 | L | 2026-06-07 07:03:23.017635 | 2026-06-07 07:03:23.017635 | 1 | International Results CSV 1 | h2h://184:179/1996-10-15 | |||
| 21431 | Saudi Arabia 179 | Qatar 190 | 1996-10-19 | 22 | 12 | 3 | 7 | 34 | 13 | 1994-11-12 | L | 2026-06-07 07:03:23.019378 | 2026-06-07 07:03:23.019378 | 1 | International Results CSV 1 | h2h://190:179/1996-10-19 | |||
| 21434 | Saudi Arabia 179 | Bahrain 183 | 1996-10-21 | 13 | 6 | 3 | 4 | 20 | 13 | 1994-11-10 | W | 2026-06-07 07:03:23.019960 | 2026-06-07 07:03:23.019961 | 1 | International Results CSV 1 | h2h://179:183/1996-10-21 | |||
| 21444 | Saudi Arabia 179 | United Arab Emirates 196 | 1996-10-27 | 15 | 7 | 4 | 4 | 18 | 9 | 1994-11-06 | D | 2026-06-07 07:03:23.021886 | 2026-06-07 07:03:23.021886 | 1 | International Results CSV 1 | h2h://196:179/1996-10-27 | |||
| 21593 | Saudi Arabia 179 | United Arab Emirates 196 | 1996-12-21 | 16 | 7 | 4 | 5 | 20 | 11 | 1996-10-27 | D | 2026-06-07 07:03:23.050612 | 2026-06-07 07:03:23.050612 | 1 | International Results CSV 1 | h2h://196:179/1996-12-21 | |||
| 21759 | Saudi Arabia 179 | Bangladesh 200 | 1997-03-20 | 1 | 1 | 0 | 0 | 4 | 0 | 1990-09-24 | L | 2026-06-07 07:03:23.082643 | 2026-06-07 07:03:23.082644 | 1 | International Results CSV 1 | h2h://200:179/1997-03-20 | |||
| 21773 | Saudi Arabia 179 | Bangladesh 200 | 1997-03-27 | 2 | 2 | 0 | 0 | 8 | 1 | 1997-03-20 | W | 2026-06-07 07:03:23.085295 | 2026-06-07 07:03:23.085295 | 1 | International Results CSV 1 | h2h://179:200/1997-03-27 | |||
| 22375 | Saudi Arabia 179 | Qatar 190 | 1997-10-11 | 23 | 12 | 3 | 8 | 36 | 15 | 1996-10-19 | D | 2026-06-07 07:03:23.201518 | 2026-06-07 07:03:23.201518 | 1 | International Results CSV 1 | h2h://179:190/1997-10-11 | |||
| 22438 | Saudi Arabia 179 | Qatar 190 | 1997-11-12 | 24 | 13 | 3 | 8 | 37 | 15 | 1997-10-11 | L | 2026-06-07 07:03:23.213680 | 2026-06-07 07:03:23.213680 | 1 | International Results CSV 1 | h2h://190:179/1997-11-12 | |||
| 22744 | Saudi Arabia 179 | Namibia 231 | 1998-05-17 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.272131 | 2026-06-07 07:03:23.272131 | 1 | International Results CSV 1 | h2h://179:231/1998-05-17 | |||||
| 23087 | Saudi Arabia 179 | Qatar 190 | 1998-10-01 | 25 | 14 | 3 | 8 | 38 | 15 | 1997-11-12 | L | 2026-06-07 07:03:23.337373 | 2026-06-07 07:03:23.337373 | 1 | International Results CSV 1 | h2h://190:179/1998-10-01 | |||
| 23162 | Saudi Arabia 179 | Bahrain 183 | 1998-11-02 | 14 | 7 | 3 | 4 | 23 | 14 | 1996-10-21 | L | 2026-06-07 07:03:23.351583 | 2026-06-07 07:03:23.351583 | 1 | International Results CSV 1 | h2h://183:179/1998-11-02 | |||
| 23166 | Saudi Arabia 179 | Oman 184 | 1998-11-05 | 10 | 10 | 0 | 0 | 29 | 4 | 1996-10-15 | L | 2026-06-07 07:03:23.352361 | 2026-06-07 07:03:23.352361 | 1 | International Results CSV 1 | h2h://184:179/1998-11-05 | |||
| 23172 | Saudi Arabia 179 | United Arab Emirates 196 | 1998-11-08 | 17 | 7 | 4 | 6 | 20 | 11 | 1996-12-21 | D | 2026-06-07 07:03:23.353505 | 2026-06-07 07:03:23.353505 | 1 | International Results CSV 1 | h2h://179:196/1998-11-08 | |||
| 23176 | Saudi Arabia 179 | Qatar 190 | 1998-11-11 | 26 | 15 | 3 | 8 | 41 | 16 | 1998-10-01 | L | 2026-06-07 07:03:23.354264 | 2026-06-07 07:03:23.354264 | 1 | International Results CSV 1 | h2h://190:179/1998-11-11 | |||
| 24554 | Saudi Arabia 179 | Slovenia 238 | 2000-06-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.622057 | 2026-06-07 07:03:23.622057 | 1 | International Results CSV 1 | h2h://238:179/2000-06-03 | |||||
| 24884 | Saudi Arabia 179 | United Arab Emirates 196 | 2000-09-28 | 18 | 8 | 4 | 6 | 21 | 11 | 1998-11-08 | W | 2026-06-07 07:03:23.687665 | 2026-06-07 07:03:23.687665 | 1 | International Results CSV 1 | h2h://179:196/2000-09-28 | |||
| 24919 | Saudi Arabia 179 | Kazakhstan 212 | 2000-10-07 | 1 | 1 | 0 | 0 | 3 | 0 | 1995-12-29 | W | 2026-06-07 07:03:23.694548 | 2026-06-07 07:03:23.694548 | 1 | International Results CSV 1 | h2h://179:212/2000-10-07 | |||
| 24982 | Saudi Arabia 179 | Qatar 190 | 2000-10-17 | 27 | 15 | 3 | 9 | 41 | 16 | 1998-11-11 | D | 2026-06-07 07:03:23.707044 | 2026-06-07 07:03:23.707044 | 1 | International Results CSV 1 | h2h://179:190/2000-10-17 | |||
| 24988 | Saudi Arabia 179 | Uzbekistan 242 | 2000-10-20 | 1 | 0 | 1 | 0 | 1 | 4 | 1994-10-01 | L | 2026-06-07 07:03:23.708272 | 2026-06-07 07:03:23.708272 | 1 | International Results CSV 1 | h2h://179:242/2000-10-20 | |||
| 25182 | Saudi Arabia 179 | Bangladesh 200 | 2001-02-10 | 3 | 3 | 0 | 0 | 11 | 1 | 1997-03-27 | W | 2026-06-07 07:03:24.073790 | 2026-06-07 07:03:24.073791 | 1 | International Results CSV 1 | h2h://179:200/2001-02-10 | |||
| 25203 | Saudi Arabia 179 | Bangladesh 200 | 2001-02-17 | 4 | 4 | 0 | 0 | 14 | 1 | 2001-02-10 | W | 2026-06-07 07:03:24.077738 | 2026-06-07 07:03:24.077739 | 1 | International Results CSV 1 | h2h://179:200/2001-02-17 | |||
| 25825 | Saudi Arabia 179 | North Macedonia 246 | 2001-08-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.196194 | 2026-06-07 07:03:24.196195 | 1 | International Results CSV 1 | h2h://179:246/2001-08-01 | |||||
| 25833 | Saudi Arabia 179 | Qatar 190 | 2001-08-05 | 28 | 15 | 3 | 10 | 41 | 16 | 2000-10-17 | D | 2026-06-07 07:03:24.197734 | 2026-06-07 07:03:24.197735 | 1 | International Results CSV 1 | h2h://179:190/2001-08-05 | |||
| 25835 | Saudi Arabia 179 | United Arab Emirates 196 | 2001-08-08 | 19 | 9 | 4 | 6 | 27 | 12 | 2000-09-28 | L | 2026-06-07 07:03:24.198119 | 2026-06-07 07:03:24.198119 | 1 | International Results CSV 1 | h2h://196:179/2001-08-08 | |||
| 25869 | Saudi Arabia 179 | Bahrain 183 | 2001-08-17 | 15 | 7 | 3 | 5 | 24 | 15 | 1998-11-02 | D | 2026-06-07 07:03:24.204675 | 2026-06-07 07:03:24.204675 | 1 | International Results CSV 1 | h2h://179:183/2001-08-17 | |||
| 25941 | Saudi Arabia 179 | United Arab Emirates 196 | 2001-09-07 | 20 | 10 | 4 | 6 | 28 | 12 | 2001-08-08 | W | 2026-06-07 07:03:24.218421 | 2026-06-07 07:03:24.218421 | 1 | International Results CSV 1 | h2h://179:196/2001-09-07 | |||
| 25951 | Saudi Arabia 179 | Bahrain 183 | 2001-09-21 | 16 | 7 | 3 | 6 | 25 | 16 | 2001-08-17 | D | 2026-06-07 07:03:24.220329 | 2026-06-07 07:03:24.220329 | 1 | International Results CSV 1 | h2h://183:179/2001-09-21 | |||
| 26163 | Saudi Arabia 179 | Bahrain 183 | 2002-01-20 | 17 | 8 | 3 | 6 | 29 | 16 | 2001-09-21 | W | 2026-06-07 07:03:24.260949 | 2026-06-07 07:03:24.260950 | 1 | International Results CSV 1 | h2h://179:183/2002-01-20 | |||
| 26180 | Saudi Arabia 179 | United Arab Emirates 196 | 2002-01-24 | 21 | 10 | 5 | 6 | 28 | 14 | 2001-09-07 | L | 2026-06-07 07:03:24.264198 | 2026-06-07 07:03:24.264198 | 1 | International Results CSV 1 | h2h://179:196/2002-01-24 |
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)
);