h2h_record
180 rows where team_b_id = 153
This data as json, CSV (advanced)
Suggested facets: total_matches, wins_a, wins_b, draws, goals_a, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4473 | Tunisia 152 | Libya 153 | 1957-06-02 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.471992 | 2026-06-07 07:03:18.471992 | 1 | International Results CSV 1 | h2h://152:153/1957-06-02 | |||||
| 4650 | Tunisia 152 | Libya 153 | 1958-05-09 | 1 | 1 | 0 | 0 | 4 | 2 | 1957-06-02 | W | 2026-06-07 07:03:18.473621 | 2026-06-07 07:03:18.473621 | 1 | International Results CSV 1 | h2h://152:153/1958-05-09 | |||
| 5445 | Tunisia 152 | Libya 153 | 1962-03-11 | 2 | 2 | 0 | 0 | 8 | 3 | 1958-05-09 | L | 2026-06-07 07:03:18.961145 | 2026-06-07 07:03:18.961146 | 1 | International Results CSV 1 | h2h://153:152/1962-03-11 | |||
| 5513 | Tunisia 152 | Libya 153 | 1962-06-03 | 3 | 2 | 1 | 0 | 11 | 9 | 1962-03-11 | L | 2026-06-07 07:03:18.974093 | 2026-06-07 07:03:18.974094 | 1 | International Results CSV 1 | h2h://152:153/1962-06-03 | |||
| 6013 | Lebanon 96 | Libya 153 | 1964-03-08 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.070334 | 2026-06-07 07:03:19.070334 | 1 | International Results CSV 1 | h2h://153:96/1964-03-08 | |||||
| 6016 | Malta 151 | Libya 153 | 1964-03-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.070899 | 2026-06-07 07:03:19.070899 | 1 | International Results CSV 1 | h2h://153:151/1964-03-15 | |||||
| 6162 | Lebanon 96 | Libya 153 | 1964-11-14 | 1 | 1 | 0 | 0 | 1 | 0 | 1964-03-08 | L | 2026-06-07 07:03:19.098893 | 2026-06-07 07:03:19.098893 | 1 | International Results CSV 1 | h2h://153:96/1964-11-14 | |||
| 6546 | Malta 151 | Libya 153 | 1966-02-13 | 1 | 0 | 0 | 1 | 2 | 2 | 1964-03-15 | D | 2026-06-07 07:03:19.171537 | 2026-06-07 07:03:19.171538 | 1 | International Results CSV 1 | h2h://151:153/1966-02-13 | |||
| 6565 | Malta 151 | Libya 153 | 1966-03-27 | 2 | 1 | 0 | 1 | 3 | 2 | 1966-02-13 | L | 2026-06-07 07:03:19.175126 | 2026-06-07 07:03:19.175126 | 1 | International Results CSV 1 | h2h://153:151/1966-03-27 | |||
| 6578 | Syria 121 | Libya 153 | 1966-04-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.177605 | 2026-06-07 07:03:19.177606 | 1 | International Results CSV 1 | h2h://153:121/1966-04-04 | |||||
| 6594 | Lebanon 96 | Libya 153 | 1966-04-10 | 2 | 1 | 1 | 0 | 2 | 2 | 1964-11-14 | W | 2026-06-07 07:03:19.180606 | 2026-06-07 07:03:19.180606 | 1 | International Results CSV 1 | h2h://153:96/1966-04-10 | |||
| 6626 | Lithuania 60 | Libya 153 | 1966-05-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.186695 | 2026-06-07 07:03:19.186696 | 1 | International Results CSV 1 | h2h://60:153/1966-05-25 | |||||
| 6856 | Egypt 42 | Libya 153 | 1966-12-09 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.230437 | 2026-06-07 07:03:19.230437 | 1 | International Results CSV 1 | h2h://153:42/1966-12-09 | |||||
| 6950 | Greece 39 | Libya 153 | 1967-02-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.248257 | 2026-06-07 07:03:19.248257 | 1 | International Results CSV 1 | h2h://39:153/1967-02-15 | |||||
| 6972 | Sudan 150 | Libya 153 | 1967-03-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.252386 | 2026-06-07 07:03:19.252387 | 1 | International Results CSV 1 | h2h://153:150/1967-03-07 | |||||
| 7000 | Egypt 42 | Libya 153 | 1967-03-24 | 1 | 0 | 0 | 1 | 2 | 2 | 1966-12-09 | D | 2026-06-07 07:03:19.257665 | 2026-06-07 07:03:19.257666 | 1 | International Results CSV 1 | h2h://42:153/1967-03-24 | |||
| 7594 | Ethiopia 112 | Libya 153 | 1969-01-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.370241 | 2026-06-07 07:03:19.370242 | 1 | International Results CSV 1 | h2h://153:112/1969-01-26 | |||||
| 7603 | Ethiopia 112 | Libya 153 | 1969-02-09 | 1 | 0 | 1 | 0 | 0 | 2 | 1969-01-26 | L | 2026-06-07 07:03:19.372114 | 2026-06-07 07:03:19.372115 | 1 | International Results CSV 1 | h2h://112:153/1969-02-09 | |||
| 8151 | Tunisia 152 | Libya 153 | 1970-09-01 | 4 | 2 | 1 | 1 | 13 | 11 | 1962-06-03 | D | 2026-06-07 07:03:19.478636 | 2026-06-07 07:03:19.478636 | 1 | International Results CSV 1 | h2h://153:152/1970-09-01 | |||
| 8153 | Tunisia 152 | Libya 153 | 1970-09-04 | 5 | 2 | 1 | 2 | 15 | 13 | 1970-09-01 | D | 2026-06-07 07:03:19.479030 | 2026-06-07 07:03:19.479031 | 1 | International Results CSV 1 | h2h://153:152/1970-09-04 | |||
| 8164 | Tunisia 152 | Libya 153 | 1970-09-24 | 6 | 2 | 2 | 2 | 17 | 16 | 1970-09-04 | L | 2026-06-07 07:03:19.481206 | 2026-06-07 07:03:19.481206 | 1 | International Results CSV 1 | h2h://152:153/1970-09-24 | |||
| 8299 | Egypt 42 | Libya 153 | 1970-12-27 | 2 | 1 | 0 | 1 | 5 | 4 | 1967-03-24 | L | 2026-06-07 07:03:19.507837 | 2026-06-07 07:03:19.507837 | 1 | International Results CSV 1 | h2h://153:42/1970-12-27 | |||
| 8302 | Egypt 42 | Libya 153 | 1971-01-03 | 3 | 2 | 0 | 1 | 6 | 4 | 1970-12-27 | W | 2026-06-07 07:03:19.508420 | 2026-06-07 07:03:19.508420 | 1 | International Results CSV 1 | h2h://42:153/1971-01-03 | |||
| 8453 | Syria 121 | Libya 153 | 1971-07-09 | 1 | 0 | 0 | 1 | 0 | 0 | 1966-04-04 | D | 2026-06-07 07:03:19.538178 | 2026-06-07 07:03:19.538178 | 1 | International Results CSV 1 | h2h://153:121/1971-07-09 | |||
| 8459 | Egypt 42 | Libya 153 | 1971-07-13 | 4 | 3 | 0 | 1 | 8 | 5 | 1971-01-03 | L | 2026-06-07 07:03:19.539351 | 2026-06-07 07:03:19.539352 | 1 | International Results CSV 1 | h2h://153:42/1971-07-13 | |||
| 8465 | Sudan 150 | Libya 153 | 1971-07-16 | 1 | 0 | 0 | 1 | 1 | 1 | 1967-03-07 | D | 2026-06-07 07:03:19.540563 | 2026-06-07 07:03:19.540563 | 1 | International Results CSV 1 | h2h://153:150/1971-07-16 | |||
| 8467 | Egypt 42 | Libya 153 | 1971-07-18 | 5 | 4 | 0 | 1 | 10 | 5 | 1971-07-13 | L | 2026-06-07 07:03:19.540954 | 2026-06-07 07:03:19.540955 | 1 | International Results CSV 1 | h2h://153:42/1971-07-18 | |||
| 8720 | Egypt 42 | Libya 153 | 1972-01-07 | 6 | 4 | 1 | 1 | 10 | 7 | 1971-07-18 | L | 2026-06-07 07:03:19.590936 | 2026-06-07 07:03:19.590937 | 1 | International Results CSV 1 | h2h://42:153/1972-01-07 | |||
| 9823 | Malta 151 | Libya 153 | 1974-08-24 | 3 | 2 | 0 | 1 | 4 | 2 | 1966-03-27 | W | 2026-06-07 07:03:19.809292 | 2026-06-07 07:03:19.809292 | 1 | International Results CSV 1 | h2h://151:153/1974-08-24 | |||
| 9836 | Malta 151 | Libya 153 | 1974-09-04 | 4 | 2 | 1 | 1 | 4 | 3 | 1974-08-24 | W | 2026-06-07 07:03:19.811841 | 2026-06-07 07:03:19.811842 | 1 | International Results CSV 1 | h2h://153:151/1974-09-04 | |||
| 9849 | DR Congo 113 | Libya 153 | 1974-09-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:19.814400 | 2026-06-07 07:03:19.814400 | 1 | International Results CSV 1 | h2h://153:113/1974-09-06 | |||||
| 9893 | Sudan 150 | Libya 153 | 1974-10-04 | 2 | 1 | 0 | 1 | 7 | 5 | 1971-07-16 | L | 2026-06-07 07:03:19.823016 | 2026-06-07 07:03:19.823016 | 1 | International Results CSV 1 | h2h://153:150/1974-10-04 | |||
| 9935 | Tunisia 152 | Libya 153 | 1974-11-10 | 7 | 3 | 2 | 2 | 19 | 16 | 1970-09-24 | W | 2026-06-07 07:03:19.831349 | 2026-06-07 07:03:19.831349 | 1 | International Results CSV 1 | h2h://152:153/1974-11-10 | |||
| 9949 | Tunisia 152 | Libya 153 | 1974-11-22 | 8 | 4 | 2 | 2 | 20 | 16 | 1974-11-10 | L | 2026-06-07 07:03:19.834096 | 2026-06-07 07:03:19.834096 | 1 | International Results CSV 1 | h2h://153:152/1974-11-22 | |||
| 10368 | Syria 121 | Libya 153 | 1975-12-21 | 2 | 0 | 1 | 1 | 1 | 2 | 1971-07-09 | W | 2026-06-07 07:03:20.223401 | 2026-06-07 07:03:20.223401 | 1 | International Results CSV 1 | h2h://153:121/1975-12-21 | |||
| 10375 | Syria 121 | Libya 153 | 1975-12-23 | 3 | 1 | 1 | 1 | 4 | 4 | 1975-12-21 | L | 2026-06-07 07:03:20.224731 | 2026-06-07 07:03:20.224731 | 1 | International Results CSV 1 | h2h://153:121/1975-12-23 | |||
| 10389 | Sudan 150 | Libya 153 | 1976-01-01 | 3 | 2 | 0 | 1 | 10 | 6 | 1974-10-04 | L | 2026-06-07 07:03:20.227382 | 2026-06-07 07:03:20.227382 | 1 | International Results CSV 1 | h2h://153:150/1976-01-01 | |||
| 10445 | Malta 151 | Libya 153 | 1976-03-10 | 5 | 2 | 1 | 2 | 4 | 3 | 1974-09-04 | D | 2026-06-07 07:03:20.238066 | 2026-06-07 07:03:20.238066 | 1 | International Results CSV 1 | h2h://151:153/1976-03-10 | |||
| 10727 | Tunisia 152 | Libya 153 | 1976-11-04 | 9 | 4 | 3 | 2 | 20 | 17 | 1974-11-22 | L | 2026-06-07 07:03:20.292164 | 2026-06-07 07:03:20.292164 | 1 | International Results CSV 1 | h2h://152:153/1976-11-04 | |||
| 10983 | Cuba 77 | Libya 153 | 1977-06-03 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.340857 | 2026-06-07 07:03:20.340857 | 1 | International Results CSV 1 | h2h://153:77/1977-06-03 | |||||
| 11040 | South Korea 114 | Libya 153 | 1977-07-17 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.351759 | 2026-06-07 07:03:20.351759 | 1 | International Results CSV 1 | h2h://114:153/1977-07-17 | |||||
| 11048 | Malaysia 136 | Libya 153 | 1977-07-21 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.353286 | 2026-06-07 07:03:20.353287 | 1 | International Results CSV 1 | h2h://136:153/1977-07-21 | |||||
| 11049 | Thailand 143 | Libya 153 | 1977-07-23 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.353472 | 2026-06-07 07:03:20.353472 | 1 | International Results CSV 1 | h2h://153:143/1977-07-23 | |||||
| 11058 | Myanmar 125 | Libya 153 | 1977-07-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.355214 | 2026-06-07 07:03:20.355215 | 1 | International Results CSV 1 | h2h://125:153/1977-07-27 | |||||
| 11111 | Malta 151 | Libya 153 | 1977-09-24 | 6 | 2 | 1 | 3 | 6 | 5 | 1976-03-10 | D | 2026-06-07 07:03:20.365448 | 2026-06-07 07:03:20.365449 | 1 | International Results CSV 1 | h2h://153:151/1977-09-24 | |||
| 11117 | Cyprus 118 | Libya 153 | 1977-09-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.366634 | 2026-06-07 07:03:20.366635 | 1 | International Results CSV 1 | h2h://153:118/1977-09-28 | |||||
| 11345 | Malta 151 | Libya 153 | 1978-05-14 | 7 | 2 | 2 | 3 | 6 | 6 | 1977-09-24 | W | 2026-06-07 07:03:20.411915 | 2026-06-07 07:03:20.411915 | 1 | International Results CSV 1 | h2h://153:151/1978-05-14 | |||
| 11458 | Egypt 42 | Libya 153 | 1978-07-22 | 7 | 4 | 1 | 2 | 11 | 8 | 1972-01-07 | D | 2026-06-07 07:03:20.434392 | 2026-06-07 07:03:20.434393 | 1 | International Results CSV 1 | h2h://42:153/1978-07-22 | |||
| 11662 | Greece 39 | Libya 153 | 1979-02-07 | 1 | 1 | 0 | 0 | 4 | 0 | 1967-02-15 | L | 2026-06-07 07:03:20.474634 | 2026-06-07 07:03:20.474635 | 1 | International Results CSV 1 | h2h://153:39/1979-02-07 | |||
| 11667 | Poland 49 | Libya 153 | 1979-02-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.475617 | 2026-06-07 07:03:20.475617 | 1 | International Results CSV 1 | h2h://153:49/1979-02-16 | |||||
| 11725 | Ethiopia 112 | Libya 153 | 1979-04-15 | 2 | 1 | 1 | 0 | 5 | 3 | 1969-02-09 | L | 2026-06-07 07:03:20.487047 | 2026-06-07 07:03:20.487047 | 1 | International Results CSV 1 | h2h://153:112/1979-04-15 | |||
| 11736 | Ethiopia 112 | Libya 153 | 1979-04-29 | 3 | 1 | 2 | 0 | 6 | 5 | 1979-04-15 | L | 2026-06-07 07:03:20.489230 | 2026-06-07 07:03:20.489230 | 1 | International Results CSV 1 | h2h://112:153/1979-04-29 | |||
| 11880 | Poland 49 | Libya 153 | 1979-08-19 | 1 | 0 | 1 | 0 | 0 | 1 | 1979-02-16 | L | 2026-06-07 07:03:20.517891 | 2026-06-07 07:03:20.517891 | 1 | International Results CSV 1 | h2h://49:153/1979-08-19 | |||
| 12189 | Malta 151 | Libya 153 | 1980-04-27 | 8 | 2 | 3 | 3 | 6 | 7 | 1978-05-14 | L | 2026-06-07 07:03:20.579091 | 2026-06-07 07:03:20.579092 | 1 | International Results CSV 1 | h2h://151:153/1980-04-27 | |||
| 12198 | Gambia 133 | Libya 153 | 1980-05-08 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.580861 | 2026-06-07 07:03:20.580861 | 1 | International Results CSV 1 | h2h://153:133/1980-05-08 | |||||
| 12293 | Gambia 133 | Libya 153 | 1980-07-06 | 1 | 0 | 1 | 0 | 1 | 2 | 1980-05-08 | L | 2026-06-07 07:03:20.599772 | 2026-06-07 07:03:20.599773 | 1 | International Results CSV 1 | h2h://133:153/1980-07-06 | |||
| 12407 | Turkey 61 | Libya 153 | 1980-10-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.622337 | 2026-06-07 07:03:20.622338 | 1 | International Results CSV 1 | h2h://61:153/1980-10-01 | |||||
| 13157 | Ghana 124 | Libya 153 | 1982-03-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.771458 | 2026-06-07 07:03:20.771458 | 1 | International Results CSV 1 | h2h://153:124/1982-03-05 | |||||
| 13164 | Tunisia 152 | Libya 153 | 1982-03-09 | 10 | 5 | 3 | 2 | 23 | 17 | 1976-11-04 | L | 2026-06-07 07:03:20.772828 | 2026-06-07 07:03:20.772828 | 1 | International Results CSV 1 | h2h://153:152/1982-03-09 | |||
| 13172 | Cameroon 140 | Libya 153 | 1982-03-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.774400 | 2026-06-07 07:03:20.774401 | 1 | International Results CSV 1 | h2h://153:140/1982-03-12 | |||||
| 13178 | Zambia 103 | Libya 153 | 1982-03-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.775577 | 2026-06-07 07:03:20.775577 | 1 | International Results CSV 1 | h2h://153:103/1982-03-16 | |||||
| 13180 | Ghana 124 | Libya 153 | 1982-03-19 | 1 | 0 | 0 | 1 | 2 | 2 | 1982-03-05 | D | 2026-06-07 07:03:20.775965 | 2026-06-07 07:03:20.775966 | 1 | International Results CSV 1 | h2h://153:124/1982-03-19 | |||
| 13624 | Ghana 124 | Libya 153 | 1983-04-28 | 2 | 0 | 0 | 2 | 3 | 3 | 1982-03-19 | D | 2026-06-07 07:03:20.863863 | 2026-06-07 07:03:20.863863 | 1 | International Results CSV 1 | h2h://124:153/1983-04-28 | |||
| 13627 | Ethiopia 112 | Libya 153 | 1983-05-01 | 4 | 1 | 2 | 1 | 7 | 6 | 1979-04-29 | D | 2026-06-07 07:03:20.864457 | 2026-06-07 07:03:20.864457 | 1 | International Results CSV 1 | h2h://112:153/1983-05-01 | |||
| 13631 | Ethiopia 112 | Libya 153 | 1983-05-03 | 5 | 2 | 2 | 1 | 8 | 6 | 1983-05-01 | W | 2026-06-07 07:03:20.865276 | 2026-06-07 07:03:20.865276 | 1 | International Results CSV 1 | h2h://112:153/1983-05-03 | |||
| 13787 | Greece 39 | Libya 153 | 1983-08-20 | 2 | 1 | 0 | 1 | 6 | 2 | 1979-02-07 | D | 2026-06-07 07:03:20.896466 | 2026-06-07 07:03:20.896467 | 1 | International Results CSV 1 | h2h://39:153/1983-08-20 | |||
| 13801 | Turkey 61 | Libya 153 | 1983-08-24 | 1 | 0 | 1 | 0 | 1 | 2 | 1980-10-01 | L | 2026-06-07 07:03:20.899214 | 2026-06-07 07:03:20.899214 | 1 | International Results CSV 1 | h2h://61:153/1983-08-24 | |||
| 13813 | Zimbabwe 102 | Libya 153 | 1983-08-29 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:20.901561 | 2026-06-07 07:03:20.901561 | 1 | International Results CSV 1 | h2h://153:102/1983-08-29 | |||||
| 13872 | Malta 151 | Libya 153 | 1983-10-09 | 9 | 2 | 4 | 3 | 6 | 10 | 1980-04-27 | W | 2026-06-07 07:03:20.913353 | 2026-06-07 07:03:20.913353 | 1 | International Results CSV 1 | h2h://153:151/1983-10-09 | |||
| 14588 | Sudan 150 | Libya 153 | 1985-02-22 | 4 | 2 | 1 | 1 | 10 | 7 | 1976-01-01 | L | 2026-06-07 07:03:21.054901 | 2026-06-07 07:03:21.054901 | 1 | International Results CSV 1 | h2h://150:153/1985-02-22 | |||
| 14621 | Sudan 150 | Libya 153 | 1985-03-08 | 5 | 2 | 1 | 2 | 10 | 7 | 1985-02-22 | D | 2026-06-07 07:03:21.061416 | 2026-06-07 07:03:21.061417 | 1 | International Results CSV 1 | h2h://153:150/1985-03-08 | |||
| 14669 | Tunisia 152 | Libya 153 | 1985-03-29 | 11 | 5 | 4 | 2 | 23 | 19 | 1982-03-09 | W | 2026-06-07 07:03:21.071032 | 2026-06-07 07:03:21.071032 | 1 | International Results CSV 1 | h2h://153:152/1985-03-29 | |||
| 14724 | Tunisia 152 | Libya 153 | 1985-04-14 | 12 | 5 | 5 | 2 | 23 | 21 | 1985-03-29 | L | 2026-06-07 07:03:21.081871 | 2026-06-07 07:03:21.081871 | 1 | International Results CSV 1 | h2h://152:153/1985-04-14 | |||
| 14899 | Ghana 124 | Libya 153 | 1985-07-14 | 3 | 1 | 0 | 2 | 4 | 3 | 1983-04-28 | W | 2026-06-07 07:03:21.116663 | 2026-06-07 07:03:21.116664 | 1 | International Results CSV 1 | h2h://124:153/1985-07-14 | |||
| 14903 | Ghana 124 | Libya 153 | 1985-07-26 | 4 | 1 | 0 | 3 | 4 | 3 | 1985-07-14 | D | 2026-06-07 07:03:21.117447 | 2026-06-07 07:03:21.117447 | 1 | International Results CSV 1 | h2h://153:124/1985-07-26 | |||
| 14993 | Mexico 57 | Libya 153 | 1985-10-11 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.135394 | 2026-06-07 07:03:21.135394 | 1 | International Results CSV 1 | h2h://153:57/1985-10-11 | |||||
| 16015 | Malta 151 | Libya 153 | 1988-03-10 | 10 | 2 | 5 | 3 | 6 | 14 | 1983-10-09 | W | 2026-06-07 07:03:21.645098 | 2026-06-07 07:03:21.645098 | 1 | International Results CSV 1 | h2h://153:151/1988-03-10 | |||
| 18040 | Malta 151 | Libya 153 | 1991-11-27 | 11 | 2 | 6 | 3 | 6 | 15 | 1988-03-10 | L | 2026-06-07 07:03:22.033988 | 2026-06-07 07:03:22.033988 | 1 | International Results CSV 1 | h2h://151:153/1991-11-27 | |||
| 21893 | Lebanon 96 | Libya 153 | 1997-04-27 | 3 | 1 | 2 | 0 | 3 | 8 | 1966-04-10 | L | 2026-06-07 07:03:23.108335 | 2026-06-07 07:03:23.108335 | 1 | International Results CSV 1 | h2h://96:153/1997-04-27 | |||
| 21922 | Syria 121 | Libya 153 | 1997-04-30 | 4 | 1 | 2 | 1 | 4 | 5 | 1975-12-23 | L | 2026-06-07 07:03:23.113929 | 2026-06-07 07:03:23.113930 | 1 | International Results CSV 1 | h2h://121:153/1997-04-30 | |||
| 23996 | Togo 148 | Libya 153 | 1999-11-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.512983 | 2026-06-07 07:03:23.512983 | 1 | International Results CSV 1 | h2h://153:148/1999-11-19 | |||||
| 24014 | Zimbabwe 102 | Libya 153 | 1999-11-27 | 1 | 0 | 1 | 0 | 1 | 3 | 1983-08-29 | L | 2026-06-07 07:03:23.516544 | 2026-06-07 07:03:23.516544 | 1 | International Results CSV 1 | h2h://102:153/1999-11-27 | |||
| 24045 | Togo 148 | Libya 153 | 1999-12-29 | 1 | 0 | 1 | 0 | 1 | 2 | 1999-11-19 | W | 2026-06-07 07:03:23.522733 | 2026-06-07 07:03:23.522733 | 1 | International Results CSV 1 | h2h://153:148/1999-12-29 | |||
| 24083 | Uganda 69 | Libya 153 | 2000-01-26 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.530299 | 2026-06-07 07:03:23.530299 | 1 | International Results CSV 1 | h2h://69:153/2000-01-26 | |||||
| 24631 | Cameroon 140 | Libya 153 | 2000-06-18 | 1 | 0 | 0 | 1 | 0 | 0 | 1982-03-12 | D | 2026-06-07 07:03:23.637219 | 2026-06-07 07:03:23.637219 | 1 | International Results CSV 1 | h2h://153:140/2000-06-18 | |||
| 24874 | Sudan 150 | Libya 153 | 2000-09-10 | 6 | 2 | 2 | 2 | 10 | 11 | 1985-03-08 | W | 2026-06-07 07:03:23.685663 | 2026-06-07 07:03:23.685663 | 1 | International Results CSV 1 | h2h://153:150/2000-09-10 | |||
| 25110 | Egypt 42 | Libya 153 | 2001-01-14 | 8 | 5 | 1 | 2 | 12 | 8 | 1978-07-22 | W | 2026-06-07 07:03:24.060044 | 2026-06-07 07:03:24.060045 | 1 | International Results CSV 1 | h2h://42:153/2001-01-14 | |||
| 25215 | Togo 148 | Libya 153 | 2001-02-23 | 2 | 0 | 2 | 0 | 1 | 4 | 1999-12-29 | W | 2026-06-07 07:03:24.080000 | 2026-06-07 07:03:24.080001 | 1 | International Results CSV 1 | h2h://153:148/2001-02-23 | |||
| 25278 | Zambia 103 | Libya 153 | 2001-03-10 | 1 | 0 | 1 | 0 | 1 | 2 | 1982-03-16 | L | 2026-06-07 07:03:24.092014 | 2026-06-07 07:03:24.092014 | 1 | International Results CSV 1 | h2h://103:153/2001-03-10 | |||
| 25302 | Egypt 42 | Libya 153 | 2001-03-23 | 9 | 6 | 1 | 2 | 16 | 8 | 2001-01-14 | L | 2026-06-07 07:03:24.096643 | 2026-06-07 07:03:24.096644 | 1 | International Results CSV 1 | h2h://153:42/2001-03-23 | |||
| 25438 | Cameroon 140 | Libya 153 | 2001-04-22 | 2 | 1 | 0 | 1 | 3 | 0 | 2000-06-18 | W | 2026-06-07 07:03:24.122382 | 2026-06-07 07:03:24.122383 | 1 | International Results CSV 1 | h2h://140:153/2001-04-22 | |||
| 25697 | Sudan 150 | Libya 153 | 2001-06-17 | 7 | 2 | 3 | 2 | 10 | 12 | 2000-09-10 | L | 2026-06-07 07:03:24.171702 | 2026-06-07 07:03:24.171702 | 1 | International Results CSV 1 | h2h://150:153/2001-06-17 | |||
| 25785 | Togo 148 | Libya 153 | 2001-07-15 | 3 | 0 | 2 | 1 | 4 | 7 | 2001-02-23 | D | 2026-06-07 07:03:24.188540 | 2026-06-07 07:03:24.188540 | 1 | International Results CSV 1 | h2h://148:153/2001-07-15 | |||
| 25810 | Zambia 103 | Libya 153 | 2001-07-27 | 2 | 1 | 1 | 0 | 3 | 2 | 2001-03-10 | L | 2026-06-07 07:03:24.193337 | 2026-06-07 07:03:24.193337 | 1 | International Results CSV 1 | h2h://153:103/2001-07-27 | |||
| 26589 | Egypt 42 | Libya 153 | 2002-08-27 | 10 | 6 | 2 | 2 | 16 | 10 | 2001-03-23 | L | 2026-06-07 07:03:24.342729 | 2026-06-07 07:03:24.342729 | 1 | International Results CSV 1 | h2h://42:153/2002-08-27 | |||
| 26600 | Togo 148 | Libya 153 | 2002-09-02 | 4 | 1 | 2 | 1 | 6 | 7 | 2001-07-15 | L | 2026-06-07 07:03:24.344860 | 2026-06-07 07:03:24.344860 | 1 | International Results CSV 1 | h2h://153:148/2002-09-02 | |||
| 26646 | DR Congo 113 | Libya 153 | 2002-09-08 | 1 | 1 | 0 | 0 | 2 | 0 | 1974-09-06 | L | 2026-06-07 07:03:24.353734 | 2026-06-07 07:03:24.353734 | 1 | International Results CSV 1 | h2h://153:113/2002-09-08 | |||
| 26942 | Canada 6 | Libya 153 | 2003-02-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.411085 | 2026-06-07 07:03:24.411085 | 1 | International Results CSV 1 | h2h://153:6/2003-02-12 | |||||
| 27152 | Argentina 8 | Libya 153 | 2003-04-30 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.451488 | 2026-06-07 07:03:24.451488 | 1 | International Results CSV 1 | h2h://153:8/2003-04-30 | |||||
| 27199 | Uganda 69 | Libya 153 | 2003-06-03 | 1 | 1 | 0 | 0 | 3 | 2 | 2000-01-26 | W | 2026-06-07 07:03:24.460693 | 2026-06-07 07:03:24.460693 | 1 | International Results CSV 1 | h2h://69:153/2003-06-03 |
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)
);