h2h_record
78 rows where team_b_id = 295
This data as json, CSV (advanced)
Suggested facets: team_a_id, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36022 | Uganda 69 | South Sudan 295 | 2012-07-10 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.834343 | 2026-06-07 07:03:26.834343 | 1 | International Results CSV 1 | h2h://295:69/2012-07-10 | |||||
| 36474 | Ethiopia 112 | South Sudan 295 | 2012-11-24 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.921407 | 2026-06-07 07:03:26.921407 | 1 | International Results CSV 1 | h2h://112:295/2012-11-24 | |||||
| 36485 | Kenya 68 | South Sudan 295 | 2012-11-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.923571 | 2026-06-07 07:03:26.923571 | 1 | International Results CSV 1 | h2h://295:68/2012-11-27 | |||||
| 36499 | Uganda 69 | South Sudan 295 | 2012-11-30 | 1 | 0 | 0 | 1 | 2 | 2 | 2012-07-10 | D | 2026-06-07 07:03:26.926333 | 2026-06-07 07:03:26.926333 | 1 | International Results CSV 1 | h2h://69:295/2012-11-30 | |||
| 37502 | Zanzibar 110 | South Sudan 295 | 2013-11-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.125710 | 2026-06-07 07:03:27.125710 | 1 | International Results CSV 1 | h2h://110:295/2013-11-27 | |||||
| 37510 | Kenya 68 | South Sudan 295 | 2013-11-30 | 1 | 1 | 0 | 0 | 2 | 0 | 2012-11-27 | W | 2026-06-07 07:03:27.127334 | 2026-06-07 07:03:27.127334 | 1 | International Results CSV 1 | h2h://68:295/2013-11-30 | |||
| 37517 | Ethiopia 112 | South Sudan 295 | 2013-12-03 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-11-24 | L | 2026-06-07 07:03:27.128737 | 2026-06-07 07:03:27.128737 | 1 | International Results CSV 1 | h2h://295:112/2013-12-03 | |||
| 37576 | Botswana 189 | South Sudan 295 | 2014-03-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.140655 | 2026-06-07 07:03:27.140655 | 1 | International Results CSV 1 | h2h://189:295/2014-03-05 | |||||
| 37674 | Mozambique 203 | South Sudan 295 | 2014-05-18 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.160302 | 2026-06-07 07:03:27.160303 | 1 | International Results CSV 1 | h2h://203:295/2014-05-18 | |||||
| 37741 | Mozambique 203 | South Sudan 295 | 2014-05-30 | 1 | 1 | 0 | 0 | 5 | 0 | 2014-05-18 | L | 2026-06-07 07:03:27.173613 | 2026-06-07 07:03:27.173613 | 1 | International Results CSV 1 | h2h://295:203/2014-05-30 | |||
| 38707 | Kenya 68 | South Sudan 295 | 2015-06-07 | 2 | 2 | 0 | 0 | 5 | 1 | 2013-11-30 | W | 2026-06-07 07:03:27.365761 | 2026-06-07 07:03:27.365762 | 1 | International Results CSV 1 | h2h://68:295/2015-06-07 | |||
| 38780 | Mali 162 | South Sudan 295 | 2015-06-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.380287 | 2026-06-07 07:03:27.380288 | 1 | International Results CSV 1 | h2h://162:295/2015-06-13 | |||||
| 39040 | Equatorial Guinea 202 | South Sudan 295 | 2015-09-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.431987 | 2026-06-07 07:03:27.431987 | 1 | International Results CSV 1 | h2h://295:202/2015-09-05 | |||||
| 39122 | Mauritania 168 | South Sudan 295 | 2015-10-07 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.448160 | 2026-06-07 07:03:27.448160 | 1 | International Results CSV 1 | h2h://295:168/2015-10-07 | |||||
| 39239 | Mauritania 168 | South Sudan 295 | 2015-10-13 | 1 | 0 | 0 | 1 | 1 | 1 | 2015-10-07 | D | 2026-06-07 07:03:27.471407 | 2026-06-07 07:03:27.471407 | 1 | International Results CSV 1 | h2h://168:295/2015-10-13 | |||
| 39398 | Djibouti 111 | South Sudan 295 | 2015-11-23 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.503084 | 2026-06-07 07:03:27.503084 | 1 | International Results CSV 1 | h2h://295:111/2015-11-23 | |||||
| 39405 | Sudan 150 | South Sudan 295 | 2015-11-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.504474 | 2026-06-07 07:03:27.504475 | 1 | International Results CSV 1 | h2h://295:150/2015-11-25 | |||||
| 39408 | Malawi 154 | South Sudan 295 | 2015-11-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.505055 | 2026-06-07 07:03:27.505056 | 1 | International Results CSV 1 | h2h://295:154/2015-11-27 | |||||
| 39415 | Sudan 150 | South Sudan 295 | 2015-12-01 | 1 | 0 | 0 | 1 | 0 | 0 | 2015-11-25 | D | 2026-06-07 07:03:27.506464 | 2026-06-07 07:03:27.506464 | 1 | International Results CSV 1 | h2h://295:150/2015-12-01 | |||
| 39478 | Benin 156 | South Sudan 295 | 2016-03-23 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.518984 | 2026-06-07 07:03:27.518985 | 1 | International Results CSV 1 | h2h://295:156/2016-03-23 | |||||
| 39557 | Benin 156 | South Sudan 295 | 2016-03-27 | 1 | 1 | 0 | 0 | 2 | 1 | 2016-03-23 | W | 2026-06-07 07:03:27.534754 | 2026-06-07 07:03:27.534755 | 1 | International Results CSV 1 | h2h://156:295/2016-03-27 | |||
| 39779 | Mali 162 | South Sudan 295 | 2016-06-04 | 1 | 1 | 0 | 0 | 2 | 0 | 2015-06-13 | L | 2026-06-07 07:03:27.578803 | 2026-06-07 07:03:27.578803 | 1 | International Results CSV 1 | h2h://295:162/2016-06-04 | |||
| 40016 | Equatorial Guinea 202 | South Sudan 295 | 2016-09-04 | 1 | 0 | 1 | 0 | 0 | 1 | 2015-09-05 | L | 2026-06-07 07:03:27.972698 | 2026-06-07 07:03:27.972698 | 1 | International Results CSV 1 | h2h://202:295/2016-09-04 | |||
| 40439 | Djibouti 111 | South Sudan 295 | 2017-03-22 | 1 | 0 | 1 | 0 | 0 | 2 | 2015-11-23 | L | 2026-06-07 07:03:28.054241 | 2026-06-07 07:03:28.054242 | 1 | International Results CSV 1 | h2h://111:295/2017-03-22 | |||
| 40553 | Djibouti 111 | South Sudan 295 | 2017-03-28 | 2 | 1 | 1 | 0 | 2 | 2 | 2017-03-22 | L | 2026-06-07 07:03:28.076230 | 2026-06-07 07:03:28.076230 | 1 | International Results CSV 1 | h2h://295:111/2017-03-28 | |||
| 40663 | Burundi 139 | South Sudan 295 | 2017-06-10 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.097184 | 2026-06-07 07:03:28.097184 | 1 | International Results CSV 1 | h2h://139:295/2017-06-10 | |||||
| 41232 | Ethiopia 112 | South Sudan 295 | 2017-12-05 | 2 | 2 | 0 | 0 | 3 | 0 | 2013-12-03 | L | 2026-06-07 07:03:28.206026 | 2026-06-07 07:03:28.206026 | 1 | International Results CSV 1 | h2h://295:112/2017-12-05 | |||
| 41241 | Uganda 69 | South Sudan 295 | 2017-12-08 | 2 | 1 | 0 | 1 | 6 | 2 | 2012-11-30 | W | 2026-06-07 07:03:28.207763 | 2026-06-07 07:03:28.207764 | 1 | International Results CSV 1 | h2h://69:295/2017-12-08 | |||
| 41252 | Burundi 139 | South Sudan 295 | 2017-12-11 | 1 | 1 | 0 | 0 | 3 | 0 | 2017-06-10 | L | 2026-06-07 07:03:28.209910 | 2026-06-07 07:03:28.209910 | 1 | International Results CSV 1 | h2h://295:139/2017-12-11 | |||
| 41805 | Mali 162 | South Sudan 295 | 2018-09-09 | 2 | 2 | 0 | 0 | 5 | 0 | 2016-06-04 | L | 2026-06-07 07:03:28.316836 | 2026-06-07 07:03:28.316836 | 1 | International Results CSV 1 | h2h://295:162/2018-09-09 | |||
| 41900 | Gabon 160 | South Sudan 295 | 2018-10-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.335334 | 2026-06-07 07:03:28.335334 | 1 | International Results CSV 1 | h2h://160:295/2018-10-12 | |||||
| 42011 | Gabon 160 | South Sudan 295 | 2018-10-16 | 1 | 1 | 0 | 0 | 3 | 0 | 2018-10-12 | L | 2026-06-07 07:03:28.356714 | 2026-06-07 07:03:28.356714 | 1 | International Results CSV 1 | h2h://295:160/2018-10-16 | |||
| 42072 | Burundi 139 | South Sudan 295 | 2018-11-16 | 2 | 1 | 0 | 1 | 3 | 0 | 2017-12-11 | D | 2026-06-07 07:03:28.368519 | 2026-06-07 07:03:28.368520 | 1 | International Results CSV 1 | h2h://295:139/2018-11-16 | |||
| 42336 | Mali 162 | South Sudan 295 | 2019-03-23 | 3 | 3 | 0 | 0 | 8 | 0 | 2018-09-09 | W | 2026-06-07 07:03:28.419480 | 2026-06-07 07:03:28.419480 | 1 | International Results CSV 1 | h2h://162:295/2019-03-23 | |||
| 42807 | Equatorial Guinea 202 | South Sudan 295 | 2019-09-04 | 2 | 1 | 1 | 0 | 4 | 1 | 2016-09-04 | L | 2026-06-07 07:03:28.512041 | 2026-06-07 07:03:28.512042 | 1 | International Results CSV 1 | h2h://295:202/2019-09-04 | |||
| 42903 | Equatorial Guinea 202 | South Sudan 295 | 2019-09-08 | 3 | 1 | 1 | 1 | 5 | 2 | 2019-09-04 | D | 2026-06-07 07:03:28.531606 | 2026-06-07 07:03:28.531606 | 1 | International Results CSV 1 | h2h://202:295/2019-09-08 | |||
| 42985 | Seychelles 201 | South Sudan 295 | 2019-10-09 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.548307 | 2026-06-07 07:03:28.548307 | 1 | International Results CSV 1 | h2h://295:201/2019-10-09 | |||||
| 43073 | Seychelles 201 | South Sudan 295 | 2019-10-13 | 1 | 0 | 1 | 0 | 1 | 2 | 2019-10-09 | L | 2026-06-07 07:03:28.565846 | 2026-06-07 07:03:28.565846 | 1 | International Results CSV 1 | h2h://201:295/2019-10-13 | |||
| 43155 | Malawi 154 | South Sudan 295 | 2019-11-13 | 1 | 0 | 1 | 0 | 0 | 2 | 2015-11-27 | L | 2026-06-07 07:03:28.582186 | 2026-06-07 07:03:28.582186 | 1 | International Results CSV 1 | h2h://154:295/2019-11-13 | |||
| 43247 | Burkina Faso 159 | South Sudan 295 | 2019-11-17 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.600540 | 2026-06-07 07:03:28.600540 | 1 | International Results CSV 1 | h2h://295:159/2019-11-17 | |||||
| 43505 | Cameroon 140 | South Sudan 295 | 2020-10-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.652082 | 2026-06-07 07:03:28.652082 | 1 | International Results CSV 1 | h2h://140:295/2020-10-13 | |||||
| 43586 | Uganda 69 | South Sudan 295 | 2020-11-12 | 3 | 2 | 0 | 1 | 11 | 3 | 2017-12-08 | W | 2026-06-07 07:03:28.668327 | 2026-06-07 07:03:28.668328 | 1 | International Results CSV 1 | h2h://69:295/2020-11-12 | |||
| 43650 | Uganda 69 | South Sudan 295 | 2020-11-16 | 4 | 3 | 0 | 1 | 12 | 3 | 2020-11-12 | L | 2026-06-07 07:03:28.681065 | 2026-06-07 07:03:28.681065 | 1 | International Results CSV 1 | h2h://295:69/2020-11-16 | |||
| 43719 | Kenya 68 | South Sudan 295 | 2021-03-13 | 3 | 3 | 0 | 0 | 7 | 1 | 2015-06-07 | W | 2026-06-07 07:03:28.694769 | 2026-06-07 07:03:28.694769 | 1 | International Results CSV 1 | h2h://68:295/2021-03-13 | |||
| 43746 | Malawi 154 | South Sudan 295 | 2021-03-24 | 2 | 1 | 1 | 0 | 1 | 2 | 2019-11-13 | L | 2026-06-07 07:03:28.700117 | 2026-06-07 07:03:28.700117 | 1 | International Results CSV 1 | h2h://295:154/2021-03-24 | |||
| 43846 | Burkina Faso 159 | South Sudan 295 | 2021-03-29 | 1 | 1 | 0 | 0 | 2 | 1 | 2019-11-17 | W | 2026-06-07 07:03:28.719991 | 2026-06-07 07:03:28.719992 | 1 | International Results CSV 1 | h2h://159:295/2021-03-29 | |||
| 44457 | Sierra Leone 119 | South Sudan 295 | 2021-10-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.842769 | 2026-06-07 07:03:28.842770 | 1 | International Results CSV 1 | h2h://119:295/2021-10-06 | |||||
| 44594 | Gambia 133 | South Sudan 295 | 2021-10-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.870234 | 2026-06-07 07:03:28.870234 | 1 | International Results CSV 1 | h2h://295:133/2021-10-12 | |||||
| 44884 | Uzbekistan 242 | South Sudan 295 | 2022-01-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.928487 | 2026-06-07 07:03:28.928487 | 1 | International Results CSV 1 | h2h://242:295/2022-01-27 | |||||
| 44954 | Djibouti 111 | South Sudan 295 | 2022-03-23 | 3 | 1 | 2 | 0 | 2 | 8 | 2017-03-28 | L | 2026-06-07 07:03:28.942704 | 2026-06-07 07:03:28.942704 | 1 | International Results CSV 1 | h2h://111:295/2022-03-23 | |||
| 45042 | Djibouti 111 | South Sudan 295 | 2022-03-27 | 4 | 1 | 3 | 0 | 4 | 12 | 2022-03-23 | W | 2026-06-07 07:03:29.317102 | 2026-06-07 07:03:29.317102 | 1 | International Results CSV 1 | h2h://295:111/2022-03-27 | |||
| 45194 | Gambia 133 | South Sudan 295 | 2022-06-04 | 1 | 1 | 0 | 0 | 2 | 1 | 2021-10-12 | W | 2026-06-07 07:03:29.346348 | 2026-06-07 07:03:29.346348 | 1 | International Results CSV 1 | h2h://133:295/2022-06-04 | |||
| 45295 | Mali 162 | South Sudan 295 | 2022-06-09 | 4 | 4 | 0 | 0 | 11 | 0 | 2019-03-23 | L | 2026-06-07 07:03:29.365512 | 2026-06-07 07:03:29.365513 | 1 | International Results CSV 1 | h2h://295:162/2022-06-09 | |||
| 45852 | Congo Republic 161 | South Sudan 295 | 2023-03-23 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.472002 | 2026-06-07 07:03:29.472003 | 1 | International Results CSV 1 | h2h://161:295/2023-03-23 | |||||
| 45953 | Congo Republic 161 | South Sudan 295 | 2023-03-27 | 1 | 0 | 1 | 0 | 1 | 2 | 2023-03-23 | W | 2026-06-07 07:03:29.491176 | 2026-06-07 07:03:29.491176 | 1 | International Results CSV 1 | h2h://295:161/2023-03-27 | |||
| 46043 | Gambia 133 | South Sudan 295 | 2023-06-14 | 2 | 2 | 0 | 0 | 3 | 1 | 2022-06-04 | L | 2026-06-07 07:03:29.508277 | 2026-06-07 07:03:29.508277 | 1 | International Results CSV 1 | h2h://295:133/2023-06-14 | |||
| 46109 | Egypt 42 | South Sudan 295 | 2023-06-18 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.520833 | 2026-06-07 07:03:29.520833 | 1 | International Results CSV 1 | h2h://42:295/2023-06-18 | |||||
| 46352 | Mali 162 | South Sudan 295 | 2023-09-08 | 5 | 5 | 0 | 0 | 14 | 1 | 2022-06-09 | W | 2026-06-07 07:03:29.567503 | 2026-06-07 07:03:29.567504 | 1 | International Results CSV 1 | h2h://162:295/2023-09-08 | |||
| 46438 | Kenya 68 | South Sudan 295 | 2023-09-12 | 4 | 4 | 0 | 0 | 8 | 1 | 2021-03-13 | W | 2026-06-07 07:03:29.584042 | 2026-06-07 07:03:29.584042 | 1 | International Results CSV 1 | h2h://68:295/2023-09-12 | |||
| 46718 | Senegal 166 | South Sudan 295 | 2023-11-18 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.638274 | 2026-06-07 07:03:29.638274 | 1 | International Results CSV 1 | h2h://166:295/2023-11-18 | |||||
| 46802 | Mauritania 168 | South Sudan 295 | 2023-11-21 | 2 | 1 | 0 | 1 | 5 | 1 | 2015-10-13 | L | 2026-06-07 07:03:29.654677 | 2026-06-07 07:03:29.654677 | 1 | International Results CSV 1 | h2h://295:168/2023-11-21 | |||
| 47070 | São Tomé & Príncipe 206 | South Sudan 295 | 2024-03-22 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.706857 | 2026-06-07 07:03:29.706858 | 1 | International Results CSV 1 | h2h://206:295/2024-03-22 | |||||
| 47156 | São Tomé & Príncipe 206 | South Sudan 295 | 2024-03-26 | 1 | 0 | 0 | 1 | 1 | 1 | 2024-03-22 | D | 2026-06-07 07:03:29.723546 | 2026-06-07 07:03:29.723547 | 1 | International Results CSV 1 | h2h://295:206/2024-03-26 | |||
| 47190 | Togo 148 | South Sudan 295 | 2024-06-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.730143 | 2026-06-07 07:03:29.730143 | 1 | International Results CSV 1 | h2h://148:295/2024-06-05 | |||||
| 47316 | Sudan 150 | South Sudan 295 | 2024-06-11 | 2 | 0 | 0 | 2 | 0 | 0 | 2015-12-01 | D | 2026-06-07 07:03:29.754347 | 2026-06-07 07:03:29.754347 | 1 | International Results CSV 1 | h2h://295:150/2024-06-11 | |||
| 47483 | Congo Republic 161 | South Sudan 295 | 2024-09-05 | 2 | 1 | 1 | 0 | 2 | 2 | 2023-03-27 | W | 2026-06-07 07:03:29.786719 | 2026-06-07 07:03:29.786719 | 1 | International Results CSV 1 | h2h://161:295/2024-09-05 | |||
| 47620 | South Africa 21 | South Sudan 295 | 2024-09-10 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.812935 | 2026-06-07 07:03:29.812935 | 1 | International Results CSV 1 | h2h://295:21/2024-09-10 | |||||
| 47710 | Uganda 69 | South Sudan 295 | 2024-10-11 | 5 | 3 | 1 | 1 | 12 | 4 | 2020-11-16 | L | 2026-06-07 07:03:29.830186 | 2026-06-07 07:03:29.830186 | 1 | International Results CSV 1 | h2h://69:295/2024-10-11 | |||
| 47805 | Uganda 69 | South Sudan 295 | 2024-10-15 | 6 | 4 | 1 | 1 | 13 | 4 | 2024-10-11 | L | 2026-06-07 07:03:29.848236 | 2026-06-07 07:03:29.848236 | 1 | International Results CSV 1 | h2h://295:69/2024-10-15 | |||
| 47882 | Congo Republic 161 | South Sudan 295 | 2024-11-14 | 3 | 2 | 1 | 0 | 3 | 2 | 2024-09-05 | L | 2026-06-07 07:03:29.863119 | 2026-06-07 07:03:29.863119 | 1 | International Results CSV 1 | h2h://295:161/2024-11-14 | |||
| 48024 | South Africa 21 | South Sudan 295 | 2024-11-19 | 1 | 1 | 0 | 0 | 3 | 2 | 2024-09-10 | W | 2026-06-07 07:03:29.890129 | 2026-06-07 07:03:29.890129 | 1 | International Results CSV 1 | h2h://21:295/2024-11-19 | |||
| 48160 | DR Congo 113 | South Sudan 295 | 2025-03-21 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.916532 | 2026-06-07 07:03:29.916532 | 1 | International Results CSV 1 | h2h://113:295/2025-03-21 | |||||
| 48259 | Sudan 150 | South Sudan 295 | 2025-03-25 | 3 | 1 | 0 | 2 | 3 | 0 | 2024-06-11 | W | 2026-06-07 07:03:29.935353 | 2026-06-07 07:03:29.935353 | 1 | International Results CSV 1 | h2h://150:295/2025-03-25 | |||
| 48549 | DR Congo 113 | South Sudan 295 | 2025-09-05 | 1 | 1 | 0 | 0 | 1 | 0 | 2025-03-21 | L | 2026-06-07 07:03:29.990767 | 2026-06-07 07:03:29.990767 | 1 | International Results CSV 1 | h2h://295:113/2025-09-05 | |||
| 48640 | Mauritania 168 | South Sudan 295 | 2025-09-09 | 3 | 1 | 0 | 2 | 5 | 1 | 2023-11-21 | D | 2026-06-07 07:03:30.008193 | 2026-06-07 07:03:30.008193 | 1 | International Results CSV 1 | h2h://168:295/2025-09-09 | |||
| 48726 | Senegal 166 | South Sudan 295 | 2025-10-10 | 1 | 1 | 0 | 0 | 4 | 0 | 2023-11-18 | L | 2026-06-07 07:03:30.024571 | 2026-06-07 07:03:30.024572 | 1 | International Results CSV 1 | h2h://295:166/2025-10-10 | |||
| 48776 | Togo 148 | South Sudan 295 | 2025-10-13 | 1 | 0 | 0 | 1 | 1 | 1 | 2024-06-05 | D | 2026-06-07 07:03:30.034068 | 2026-06-07 07:03:30.034069 | 1 | International Results CSV 1 | h2h://295:148/2025-10-13 | |||
| 49005 | Syria 121 | South Sudan 295 | 2025-11-25 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:30.078263 | 2026-06-07 07:03:30.078263 | 1 | International Results CSV 1 | h2h://121:295/2025-11-25 |
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)
);