home / football

h2h_record

273 rows where team_b_id = 150

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_a_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
4368 Ethiopia 112 Sudan 150 1956-11-16 0 0 0 0 0 0         2026-06-07 07:03:18.471088 2026-06-07 07:03:18.471089 1   International Results CSV 1 h2h://112:150/1956-11-16
4395 Egypt 42 Sudan 150 1957-02-10 0 0 0 0 0 0         2026-06-07 07:03:18.471312 2026-06-07 07:03:18.471313 1   International Results CSV 1 h2h://150:42/1957-02-10
4399 Egypt 42 Sudan 150 1957-02-17 1 1 0 0 2 1 1957-02-10 L     2026-06-07 07:03:18.471341 2026-06-07 07:03:18.471341 1   International Results CSV 1 h2h://150:42/1957-02-17
4403 Syria 121 Sudan 150 1957-03-08 0 0 0 0 0 0         2026-06-07 07:03:18.471370 2026-06-07 07:03:18.471370 1   International Results CSV 1 h2h://150:121/1957-03-08
4463 Syria 121 Sudan 150 1957-05-24 1 0 1 0 0 1 1957-03-08 L     2026-06-07 07:03:18.471923 2026-06-07 07:03:18.471923 1   International Results CSV 1 h2h://121:150/1957-05-24
4510 China 33 Sudan 150 1957-07-21 0 0 0 0 0 0         2026-06-07 07:03:18.472344 2026-06-07 07:03:18.472344 1   International Results CSV 1 h2h://33:150/1957-07-21
4866 Ethiopia 112 Sudan 150 1959-05-25 1 1 0 0 2 1 1956-11-16 W     2026-06-07 07:03:18.475483 2026-06-07 07:03:18.475483 1   International Results CSV 1 h2h://112:150/1959-05-25
4869 Egypt 42 Sudan 150 1959-05-29 2 2 0 0 6 4 1957-02-17 W     2026-06-07 07:03:18.475505 2026-06-07 07:03:18.475505 1   International Results CSV 1 h2h://42:150/1959-05-29
5847 Kenya 68 Sudan 150 1963-06-01 0 0 0 0 0 0         2026-06-07 07:03:19.038696 2026-06-07 07:03:19.038696 1   International Results CSV 1 h2h://68:150/1963-06-01
5859 Ethiopia 112 Sudan 150 1963-06-16 2 1 1 0 2 2 1959-05-25 L     2026-06-07 07:03:19.041006 2026-06-07 07:03:19.041006 1   International Results CSV 1 h2h://112:150/1963-06-16
5864 Kenya 68 Sudan 150 1963-06-30 1 0 1 0 0 1 1963-06-01 W     2026-06-07 07:03:19.041955 2026-06-07 07:03:19.041955 1   International Results CSV 1 h2h://150:68/1963-06-30
5905 Bulgaria 64 Sudan 150 1963-09-18 0 0 0 0 0 0         2026-06-07 07:03:19.049720 2026-06-07 07:03:19.049720 1   International Results CSV 1 h2h://64:150/1963-09-18
5967 Egypt 42 Sudan 150 1963-11-26 3 3 0 0 8 5 1959-05-29 W     2026-06-07 07:03:19.061635 2026-06-07 07:03:19.061636 1   International Results CSV 1 h2h://42:150/1963-11-26
5971 Nigeria 120 Sudan 150 1963-11-28 0 0 0 0 0 0         2026-06-07 07:03:19.062385 2026-06-07 07:03:19.062385 1   International Results CSV 1 h2h://120:150/1963-11-28
5973 Ghana 124 Sudan 150 1963-12-01 0 0 0 0 0 0         2026-06-07 07:03:19.062757 2026-06-07 07:03:19.062758 1   International Results CSV 1 h2h://124:150/1963-12-01
6236 Ethiopia 112 Sudan 150 1965-03-27 3 2 1 0 6 2 1963-06-16 L     2026-06-07 07:03:19.112907 2026-06-07 07:03:19.112907 1   International Results CSV 1 h2h://150:112/1965-03-27
6263 Ethiopia 112 Sudan 150 1965-04-18 4 2 2 0 7 4 1965-03-27 L     2026-06-07 07:03:19.118013 2026-06-07 07:03:19.118013 1   International Results CSV 1 h2h://112:150/1965-04-18
6276 Uganda 69 Sudan 150 1965-05-01 0 0 0 0 0 0         2026-06-07 07:03:19.120475 2026-06-07 07:03:19.120475 1   International Results CSV 1 h2h://69:150/1965-05-01
6415 Uganda 69 Sudan 150 1965-08-22 1 0 1 0 1 3 1965-05-01 W     2026-06-07 07:03:19.146716 2026-06-07 07:03:19.146717 1   International Results CSV 1 h2h://150:69/1965-08-22
6690 Ethiopia 112 Sudan 150 1966-07-10 5 3 2 0 8 4 1965-04-18 W     2026-06-07 07:03:19.198940 2026-06-07 07:03:19.198941 1   International Results CSV 1 h2h://112:150/1966-07-10
6707 Uganda 69 Sudan 150 1966-07-18 2 0 2 0 2 7 1965-08-22 W     2026-06-07 07:03:19.202171 2026-06-07 07:03:19.202172 1   International Results CSV 1 h2h://150:69/1966-07-18
6858 Kenya 68 Sudan 150 1966-12-10 2 0 2 0 0 6 1963-06-30 L     2026-06-07 07:03:19.230806 2026-06-07 07:03:19.230806 1   International Results CSV 1 h2h://68:150/1966-12-10
6867 Kenya 68 Sudan 150 1966-12-12 3 0 3 0 0 7 1966-12-10 L     2026-06-07 07:03:19.232503 2026-06-07 07:03:19.232504 1   International Results CSV 1 h2h://68:150/1966-12-12
6934 German DR 131 Sudan 150 1967-01-29 0 0 0 0 0 0         2026-06-07 07:03:19.245202 2026-06-07 07:03:19.245203 1   International Results CSV 1 h2h://150:131/1967-01-29
6955 Tanzania 101 Sudan 150 1967-02-21 0 0 0 0 0 0         2026-06-07 07:03:19.249196 2026-06-07 07:03:19.249197 1   International Results CSV 1 h2h://150:101/1967-02-21
6959 Ethiopia 112 Sudan 150 1967-02-24 6 3 2 1 9 5 1966-07-10 D     2026-06-07 07:03:19.249939 2026-06-07 07:03:19.249939 1   International Results CSV 1 h2h://150:112/1967-02-24
6963 Ethiopia 112 Sudan 150 1967-02-26 7 3 2 2 10 6 1967-02-24 D     2026-06-07 07:03:19.250694 2026-06-07 07:03:19.250694 1   International Results CSV 1 h2h://150:112/1967-02-26
6964 Ethiopia 112 Sudan 150 1967-02-28 8 3 3 2 13 11 1967-02-26 L     2026-06-07 07:03:19.250880 2026-06-07 07:03:19.250880 1   International Results CSV 1 h2h://112:150/1967-02-28
6989 DR Congo 113 Sudan 150 1967-03-18 0 0 0 0 0 0         2026-06-07 07:03:19.255589 2026-06-07 07:03:19.255589 1   International Results CSV 1 h2h://113:150/1967-03-18
7006 DR Congo 113 Sudan 150 1967-04-02 1 1 0 0 3 2 1967-03-18 L     2026-06-07 07:03:19.258794 2026-06-07 07:03:19.258794 1   International Results CSV 1 h2h://150:113/1967-04-02
7094 DR Congo 113 Sudan 150 1967-08-13 2 1 1 0 3 3 1967-04-02 L     2026-06-07 07:03:19.275495 2026-06-07 07:03:19.275495 1   International Results CSV 1 h2h://113:150/1967-08-13
7493 Zambia 103 Sudan 150 1968-10-27 0 0 0 0 0 0         2026-06-07 07:03:19.351194 2026-06-07 07:03:19.351194 1   International Results CSV 1 h2h://103:150/1968-10-27
7503 Zambia 103 Sudan 150 1968-11-08 1 1 0 0 4 2 1968-10-27 L     2026-06-07 07:03:19.353063 2026-06-07 07:03:19.353063 1   International Results CSV 1 h2h://150:103/1968-11-08
7559 Kenya 68 Sudan 150 1968-12-12 4 1 3 0 3 9 1966-12-12 W     2026-06-07 07:03:19.363673 2026-06-07 07:03:19.363673 1   International Results CSV 1 h2h://68:150/1968-12-12
7581 Kenya 68 Sudan 150 1969-01-08 5 1 3 1 4 10 1968-12-12 D     2026-06-07 07:03:19.367794 2026-06-07 07:03:19.367795 1   International Results CSV 1 h2h://68:150/1969-01-08
7582 Tanzania 101 Sudan 150 1969-01-10 1 0 1 0 0 1 1967-02-21 W     2026-06-07 07:03:19.367981 2026-06-07 07:03:19.367981 1   International Results CSV 1 h2h://150:101/1969-01-10
7585 Ethiopia 112 Sudan 150 1969-01-12 9 4 3 2 15 12 1967-02-28 W     2026-06-07 07:03:19.368553 2026-06-07 07:03:19.368553 1   International Results CSV 1 h2h://112:150/1969-01-12
7654 Ethiopia 112 Sudan 150 1969-05-04 10 4 4 2 15 13 1969-01-12 L     2026-06-07 07:03:19.381753 2026-06-07 07:03:19.381753 1   International Results CSV 1 h2h://112:150/1969-05-04
7668 Ethiopia 112 Sudan 150 1969-05-11 11 4 4 3 16 14 1969-05-04 D     2026-06-07 07:03:19.384489 2026-06-07 07:03:19.384490 1   International Results CSV 1 h2h://150:112/1969-05-11
7788 Nigeria 120 Sudan 150 1969-09-13 1 0 1 0 0 4 1963-11-28 L     2026-06-07 07:03:19.407455 2026-06-07 07:03:19.407455 1   International Results CSV 1 h2h://120:150/1969-09-13
7812 Nigeria 120 Sudan 150 1969-10-03 2 0 1 1 2 6 1969-09-13 D     2026-06-07 07:03:19.412088 2026-06-07 07:03:19.412088 1   International Results CSV 1 h2h://150:120/1969-10-03
7859 Egypt 42 Sudan 150 1969-11-02 4 3 0 1 10 7 1963-11-26 D     2026-06-07 07:03:19.420964 2026-06-07 07:03:19.420965 1   International Results CSV 1 h2h://42:150/1969-11-02
7958 Ethiopia 112 Sudan 150 1970-02-06 12 4 5 3 17 17 1969-05-11 W     2026-06-07 07:03:19.440452 2026-06-07 07:03:19.440452 1   International Results CSV 1 h2h://150:112/1970-02-06
7968 Cameroon 140 Sudan 150 1970-02-10 0 0 0 0 0 0         2026-06-07 07:03:19.442411 2026-06-07 07:03:19.442411 1   International Results CSV 1 h2h://150:140/1970-02-10
7974 Egypt 42 Sudan 150 1970-02-14 5 4 0 1 13 8 1969-11-02 L     2026-06-07 07:03:19.443580 2026-06-07 07:03:19.443580 1   International Results CSV 1 h2h://150:42/1970-02-14
7977 Ghana 124 Sudan 150 1970-02-16 1 1 0 0 3 0 1963-12-01 L     2026-06-07 07:03:19.444163 2026-06-07 07:03:19.444163 1   International Results CSV 1 h2h://150:124/1970-02-16
8097 DR Congo 113 Sudan 150 1970-06-30 3 2 1 0 5 4 1967-08-13 W     2026-06-07 07:03:19.467987 2026-06-07 07:03:19.467987 1   International Results CSV 1 h2h://113:150/1970-06-30
8441 Kenya 68 Sudan 150 1971-06-24 6 1 4 1 4 11 1969-01-08 L     2026-06-07 07:03:19.535771 2026-06-07 07:03:19.535771 1   International Results CSV 1 h2h://68:150/1971-06-24
8753 DR Congo 113 Sudan 150 1972-02-25 4 3 1 0 8 4 1970-06-30 L     2026-06-07 07:03:19.597330 2026-06-07 07:03:19.597331 1   International Results CSV 1 h2h://150:113/1972-02-25
8920 Tanzania 101 Sudan 150 1972-07-04 2 0 2 0 0 4 1969-01-10 L     2026-06-07 07:03:19.630278 2026-06-07 07:03:19.630278 1   International Results CSV 1 h2h://101:150/1972-07-04
8930 Uganda 69 Sudan 150 1972-07-09 3 0 3 0 3 9 1966-07-18 L     2026-06-07 07:03:19.632274 2026-06-07 07:03:19.632274 1   International Results CSV 1 h2h://69:150/1972-07-09
8942 Kenya 68 Sudan 150 1972-07-16 7 1 4 2 7 14 1971-06-24 D     2026-06-07 07:03:19.634624 2026-06-07 07:03:19.634624 1   International Results CSV 1 h2h://68:150/1972-07-16
8955 Kenya 68 Sudan 150 1972-07-23 8 2 4 2 9 14 1972-07-16 L     2026-06-07 07:03:19.637176 2026-06-07 07:03:19.637176 1   International Results CSV 1 h2h://150:68/1972-07-23
9198 Ethiopia 112 Sudan 150 1973-03-10 13 4 6 3 17 20 1970-02-06 W     2026-06-07 07:03:19.685172 2026-06-07 07:03:19.685173 1   International Results CSV 1 h2h://150:112/1973-03-10
9232 Nigeria 120 Sudan 150 1973-04-13 3 0 1 2 5 9 1969-10-03 D     2026-06-07 07:03:19.692015 2026-06-07 07:03:19.692016 1   International Results CSV 1 h2h://150:120/1973-04-13
9241 Nigeria 120 Sudan 150 1973-04-21 4 0 1 3 6 10 1973-04-13 D     2026-06-07 07:03:19.693769 2026-06-07 07:03:19.693769 1   International Results CSV 1 h2h://120:150/1973-04-21
10040 Kenya 68 Sudan 150 1975-03-23 9 2 5 2 9 15 1972-07-23 W     2026-06-07 07:03:20.160262 2026-06-07 07:03:20.160263 1   International Results CSV 1 h2h://150:68/1975-03-23
10380 Egypt 42 Sudan 150 1975-12-26 6 4 1 1 14 10 1970-02-14 L     2026-06-07 07:03:20.225672 2026-06-07 07:03:20.225673 1   International Results CSV 1 h2h://42:150/1975-12-26
10385 Syria 121 Sudan 150 1975-12-28 2 0 1 1 1 2 1957-05-24 D     2026-06-07 07:03:20.226619 2026-06-07 07:03:20.226619 1   International Results CSV 1 h2h://150:121/1975-12-28
10436 Nigeria 120 Sudan 150 1976-03-04 5 1 1 3 8 11 1973-04-21 W     2026-06-07 07:03:20.236373 2026-06-07 07:03:20.236374 1   International Results CSV 1 h2h://120:150/1976-03-04
10440 DR Congo 113 Sudan 150 1976-03-06 5 3 1 1 9 5 1972-02-25 D     2026-06-07 07:03:20.237123 2026-06-07 07:03:20.237123 1   International Results CSV 1 h2h://150:113/1976-03-06
11248 Kenya 68 Sudan 150 1978-01-26 11 2 7 2 9 18 1975-03-23 W     2026-06-07 07:03:20.392680 2026-06-07 07:03:20.392680 1   International Results CSV 1 h2h://150:68/1978-01-26
11934 South Korea 114 Sudan 150 1979-09-08 0 0 0 0 0 0         2026-06-07 07:03:20.528478 2026-06-07 07:03:20.528478 1   International Results CSV 1 h2h://114:150/1979-09-08
11950 Sri Lanka 130 Sudan 150 1979-09-16 0 0 0 0 0 0         2026-06-07 07:03:20.531633 2026-06-07 07:03:20.531634 1   International Results CSV 1 h2h://130:150/1979-09-16
12030 Zanzibar 110 Sudan 150 1979-11-09 0 0 0 0 0 0         2026-06-07 07:03:20.547776 2026-06-07 07:03:20.547776 1   International Results CSV 1 h2h://150:110/1979-11-09
12493 Tanzania 101 Sudan 150 1980-11-14 3 1 2 0 3 4 1972-07-04 L     2026-06-07 07:03:20.639398 2026-06-07 07:03:20.639399 1   International Results CSV 1 h2h://150:101/1980-11-14
12529 Tanzania 101 Sudan 150 1980-11-28 4 2 2 0 4 4 1980-11-14 L     2026-06-07 07:03:20.646539 2026-06-07 07:03:20.646540 1   International Results CSV 1 h2h://150:101/1980-11-28
12709 Ethiopia 112 Sudan 150 1981-04-19 14 4 7 3 17 21 1973-03-10 L     2026-06-07 07:03:20.682125 2026-06-07 07:03:20.682126 1   International Results CSV 1 h2h://112:150/1981-04-19
12716 Ethiopia 112 Sudan 150 1981-04-21 15 4 7 4 18 22 1981-04-19 D     2026-06-07 07:03:20.683511 2026-06-07 07:03:20.683511 1   International Results CSV 1 h2h://112:150/1981-04-21
13034 Uganda 69 Sudan 150 1981-11-15 4 1 3 0 7 9 1972-07-09 L     2026-06-07 07:03:20.747037 2026-06-07 07:03:20.747037 1   International Results CSV 1 h2h://150:69/1981-11-15
13040 Zimbabwe 102 Sudan 150 1981-11-17 0 0 0 0 0 0         2026-06-07 07:03:20.748254 2026-06-07 07:03:20.748255 1   International Results CSV 1 h2h://150:102/1981-11-17
13056 Zambia 103 Sudan 150 1981-11-21 2 1 1 0 6 6 1968-11-08 W     2026-06-07 07:03:20.751439 2026-06-07 07:03:20.751439 1   International Results CSV 1 h2h://150:103/1981-11-21
13435 Kenya 68 Sudan 150 1982-11-14 12 2 8 2 9 21 1978-01-26 L     2026-06-07 07:03:20.826599 2026-06-07 07:03:20.826599 1   International Results CSV 1 h2h://68:150/1982-11-14
13450 Zanzibar 110 Sudan 150 1982-11-18 1 0 0 1 1 1 1979-11-09 D     2026-06-07 07:03:20.829546 2026-06-07 07:03:20.829547 1   International Results CSV 1 h2h://150:110/1982-11-18
13588 Zambia 103 Sudan 150 1983-04-10 3 2 1 0 8 6 1981-11-21 L     2026-06-07 07:03:20.856762 2026-06-07 07:03:20.856762 1   International Results CSV 1 h2h://150:103/1983-04-10
13612 Zambia 103 Sudan 150 1983-04-24 4 2 2 0 9 8 1983-04-10 L     2026-06-07 07:03:20.861481 2026-06-07 07:03:20.861481 1   International Results CSV 1 h2h://103:150/1983-04-24
13687 New Zealand 52 Sudan 150 1983-06-09 0 0 0 0 0 0         2026-06-07 07:03:20.876544 2026-06-07 07:03:20.876544 1   International Results CSV 1 h2h://52:150/1983-06-09
13695 Ghana 124 Sudan 150 1983-06-13 2 1 1 0 3 1 1970-02-16 L     2026-06-07 07:03:20.878184 2026-06-07 07:03:20.878184 1   International Results CSV 1 h2h://124:150/1983-06-13
13776 Cameroon 140 Sudan 150 1983-08-14 1 0 1 0 1 2 1970-02-10 L     2026-06-07 07:03:20.894279 2026-06-07 07:03:20.894279 1   International Results CSV 1 h2h://140:150/1983-08-14
13810 Cameroon 140 Sudan 150 1983-08-28 2 1 1 0 6 2 1983-08-14 L     2026-06-07 07:03:20.900971 2026-06-07 07:03:20.900971 1   International Results CSV 1 h2h://150:140/1983-08-28
13910 Uganda 69 Sudan 150 1983-11-14 5 1 3 1 9 11 1981-11-15 D     2026-06-07 07:03:20.920968 2026-06-07 07:03:20.920968 1   International Results CSV 1 h2h://150:69/1983-11-14
13921 Tanzania 101 Sudan 150 1983-11-16 5 2 3 0 4 5 1980-11-28 W     2026-06-07 07:03:20.923145 2026-06-07 07:03:20.923146 1   International Results CSV 1 h2h://150:101/1983-11-16
13929 Ethiopia 112 Sudan 150 1983-11-19 16 5 7 4 20 22 1981-04-21 W     2026-06-07 07:03:20.924755 2026-06-07 07:03:20.924755 1   International Results CSV 1 h2h://112:150/1983-11-19
13936 Kenya 68 Sudan 150 1983-11-21 13 3 8 2 11 21 1982-11-14 W     2026-06-07 07:03:20.926131 2026-06-07 07:03:20.926131 1   International Results CSV 1 h2h://68:150/1983-11-21
14333 Tanzania 101 Sudan 150 1984-10-13 6 2 4 0 4 6 1983-11-16 L     2026-06-07 07:03:21.004628 2026-06-07 07:03:21.004628 1   International Results CSV 1 h2h://101:150/1984-10-13
14373 Tanzania 101 Sudan 150 1984-10-27 7 2 4 1 5 7 1984-10-13 D     2026-06-07 07:03:21.012492 2026-06-07 07:03:21.012493 1   International Results CSV 1 h2h://150:101/1984-10-27
15628 Tanzania 101 Sudan 150 1987-03-29 8 2 4 2 5 7 1984-10-27 D     2026-06-07 07:03:21.571140 2026-06-07 07:03:21.571140 1   International Results CSV 1 h2h://150:101/1987-03-29
15646 Tanzania 101 Sudan 150 1987-04-11 9 2 5 2 5 8 1987-03-29 L     2026-06-07 07:03:21.574582 2026-06-07 07:03:21.574583 1   International Results CSV 1 h2h://101:150/1987-04-11
15734 Cameroon 140 Sudan 150 1987-07-05 3 1 2 0 6 4 1983-08-28 L     2026-06-07 07:03:21.591477 2026-06-07 07:03:21.591477 1   International Results CSV 1 h2h://140:150/1987-07-05
15747 Cameroon 140 Sudan 150 1987-07-18 4 2 2 0 8 4 1987-07-05 L     2026-06-07 07:03:21.593982 2026-06-07 07:03:21.593983 1   International Results CSV 1 h2h://150:140/1987-07-18
16615 Kenya 68 Sudan 150 1989-04-07 14 4 8 2 12 21 1983-11-21 L     2026-06-07 07:03:21.760108 2026-06-07 07:03:21.760108 1   International Results CSV 1 h2h://150:68/1989-04-07
16648 Kenya 68 Sudan 150 1989-04-23 15 4 9 2 12 22 1989-04-07 L     2026-06-07 07:03:21.766429 2026-06-07 07:03:21.766429 1   International Results CSV 1 h2h://68:150/1989-04-23
17560 Kenya 68 Sudan 150 1990-12-12 16 5 9 2 13 22 1989-04-23 W     2026-06-07 07:03:21.941282 2026-06-07 07:03:21.941283 1   International Results CSV 1 h2h://68:150/1990-12-12
17565 Uganda 69 Sudan 150 1990-12-14 6 2 3 1 11 12 1983-11-14 L     2026-06-07 07:03:21.942236 2026-06-07 07:03:21.942236 1   International Results CSV 1 h2h://150:69/1990-12-14
17573 Zanzibar 110 Sudan 150 1990-12-17 2 1 0 1 2 1 1982-11-18 W     2026-06-07 07:03:21.943753 2026-06-07 07:03:21.943753 1   International Results CSV 1 h2h://110:150/1990-12-17
17582 Uganda 69 Sudan 150 1990-12-20 7 2 3 2 13 14 1990-12-14 D     2026-06-07 07:03:21.945496 2026-06-07 07:03:21.945496 1   International Results CSV 1 h2h://150:69/1990-12-20
17634 Uganda 69 Sudan 150 1991-03-09 8 3 3 2 15 14 1990-12-20 W     2026-06-07 07:03:21.955470 2026-06-07 07:03:21.955470 1   International Results CSV 1 h2h://69:150/1991-03-09
17659 Uganda 69 Sudan 150 1991-04-07 9 3 4 2 15 15 1991-03-09 W     2026-06-07 07:03:21.960272 2026-06-07 07:03:21.960272 1   International Results CSV 1 h2h://150:69/1991-04-07
17670 Kenya 68 Sudan 150 1991-04-14 17 5 10 2 14 24 1990-12-12 W     2026-06-07 07:03:21.962384 2026-06-07 07:03:21.962384 1   International Results CSV 1 h2h://150:68/1991-04-14
17901 Kenya 68 Sudan 150 1991-07-28 18 5 11 2 14 25 1991-04-14 L     2026-06-07 07:03:22.006824 2026-06-07 07:03:22.006824 1   International Results CSV 1 h2h://68:150/1991-07-28

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Queries took 916.829ms