home / football

h2h_record

218 rows where team_b_id = 197

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
8932 Iceland 104 Faroe Islands 197 1972-07-12 0 0 0 0 0 0         2026-06-07 07:03:19.632660 2026-06-07 07:03:19.632661 1   International Results CSV 1 h2h://104:197/1972-07-12
9327 Iceland 104 Faroe Islands 197 1973-06-08 1 1 0 0 3 0 1972-07-12 L     2026-06-07 07:03:19.711047 2026-06-07 07:03:19.711048 1   International Results CSV 1 h2h://197:104/1973-06-08
9790 Iceland 104 Faroe Islands 197 1974-07-03 2 2 0 0 7 0 1973-06-08 L     2026-06-07 07:03:19.802708 2026-06-07 07:03:19.802708 1   International Results CSV 1 h2h://197:104/1974-07-03
10158 Iceland 104 Faroe Islands 197 1975-06-23 3 3 0 0 10 2 1974-07-03 W     2026-06-07 07:03:20.183165 2026-06-07 07:03:20.183165 1   International Results CSV 1 h2h://104:197/1975-06-23
10568 Iceland 104 Faroe Islands 197 1976-06-16 4 4 0 0 16 2 1975-06-23 L     2026-06-07 07:03:20.261741 2026-06-07 07:03:20.261741 1   International Results CSV 1 h2h://197:104/1976-06-16
12286 Iceland 104 Faroe Islands 197 1980-06-30 5 5 0 0 22 3 1976-06-16 W     2026-06-07 07:03:20.598399 2026-06-07 07:03:20.598400 1   International Results CSV 1 h2h://104:197/1980-06-30
13348 Iceland 104 Faroe Islands 197 1982-08-01 6 6 0 0 24 4 1980-06-30 L     2026-06-07 07:03:20.809373 2026-06-07 07:03:20.809374 1   International Results CSV 1 h2h://197:104/1982-08-01
13349 Iceland 104 Faroe Islands 197 1982-08-02 7 7 0 0 28 5 1982-08-01 L     2026-06-07 07:03:20.809571 2026-06-07 07:03:20.809571 1   International Results CSV 1 h2h://197:104/1982-08-02
13767 Iceland 104 Faroe Islands 197 1983-08-08 8 8 0 0 32 5 1982-08-02 W     2026-06-07 07:03:20.892496 2026-06-07 07:03:20.892497 1   International Results CSV 1 h2h://104:197/1983-08-08
14211 Iceland 104 Faroe Islands 197 1984-08-01 9 9 0 0 38 5 1983-08-08 L     2026-06-07 07:03:20.980573 2026-06-07 07:03:20.980573 1   International Results CSV 1 h2h://197:104/1984-08-01
14889 Iceland 104 Faroe Islands 197 1985-07-10 10 9 0 1 38 5 1984-08-01 D     2026-06-07 07:03:21.114702 2026-06-07 07:03:21.114702 1   International Results CSV 1 h2h://104:197/1985-07-10
14895 Iceland 104 Faroe Islands 197 1985-07-12 11 10 0 1 47 5 1985-07-10 W     2026-06-07 07:03:21.115880 2026-06-07 07:03:21.115880 1   International Results CSV 1 h2h://104:197/1985-07-12
16274 Iceland 104 Faroe Islands 197 1988-08-24 12 11 0 1 48 5 1985-07-12 W     2026-06-07 07:03:21.694550 2026-06-07 07:03:21.694550 1   International Results CSV 1 h2h://104:197/1988-08-24
16633 Canada 6 Faroe Islands 197 1989-04-14 0 0 0 0 0 0         2026-06-07 07:03:21.763540 2026-06-07 07:03:21.763541 1   International Results CSV 1 h2h://197:6/1989-04-14
16637 Canada 6 Faroe Islands 197 1989-04-16 1 0 1 0 0 1 1989-04-14 W     2026-06-07 07:03:21.764309 2026-06-07 07:03:21.764310 1   International Results CSV 1 h2h://197:6/1989-04-16
17378 Iceland 104 Faroe Islands 197 1990-08-08 13 12 0 1 49 5 1988-08-24 L     2026-06-07 07:03:21.906494 2026-06-07 07:03:21.906494 1   International Results CSV 1 h2h://197:104/1990-08-08
17445 Austria 9 Faroe Islands 197 1990-09-12 0 0 0 0 0 0         2026-06-07 07:03:21.919299 2026-06-07 07:03:21.919299 1   International Results CSV 1 h2h://197:9/1990-09-12
17490 Denmark 25 Faroe Islands 197 1990-10-10 0 0 0 0 0 0         2026-06-07 07:03:21.927900 2026-06-07 07:03:21.927901 1   International Results CSV 1 h2h://25:197/1990-10-10
17700 Northern Ireland 4 Faroe Islands 197 1991-05-01 0 0 0 0 0 0         2026-06-07 07:03:21.968107 2026-06-07 07:03:21.968108 1   International Results CSV 1 h2h://4:197/1991-05-01
17734 Yugoslavia 40 Faroe Islands 197 1991-05-16 0 0 0 0 0 0         2026-06-07 07:03:21.974627 2026-06-07 07:03:21.974627 1   International Results CSV 1 h2h://40:197/1991-05-16
17741 Austria 9 Faroe Islands 197 1991-05-22 1 0 1 0 0 1 1990-09-12 L     2026-06-07 07:03:21.975967 2026-06-07 07:03:21.975967 1   International Results CSV 1 h2h://9:197/1991-05-22
17819 Jersey 17 Faroe Islands 197 1991-06-26 0 0 0 0 0 0         2026-06-07 07:03:21.990890 2026-06-07 07:03:21.990890 1   International Results CSV 1 h2h://197:17/1991-06-26
17883 Turkey 61 Faroe Islands 197 1991-07-15 0 0 0 0 0 0         2026-06-07 07:03:22.003326 2026-06-07 07:03:22.003326 1   International Results CSV 1 h2h://197:61/1991-07-15
17930 Northern Ireland 4 Faroe Islands 197 1991-09-11 1 0 0 1 1 1 1991-05-01 D     2026-06-07 07:03:22.012457 2026-06-07 07:03:22.012457 1   International Results CSV 1 h2h://197:4/1991-09-11
17964 Denmark 25 Faroe Islands 197 1991-09-25 1 1 0 0 4 1 1990-10-10 L     2026-06-07 07:03:22.018939 2026-06-07 07:03:22.018939 1   International Results CSV 1 h2h://197:25/1991-09-25
17991 Yugoslavia 40 Faroe Islands 197 1991-10-16 1 1 0 0 7 0 1991-05-16 L     2026-06-07 07:03:22.024077 2026-06-07 07:03:22.024077 1   International Results CSV 1 h2h://197:40/1991-10-16
18210 Romania 38 Faroe Islands 197 1992-05-06 0 0 0 0 0 0         2026-06-07 07:03:22.068150 2026-06-07 07:03:22.068151 1   International Results CSV 1 h2h://38:197/1992-05-06
18220 Norway 24 Faroe Islands 197 1992-05-13 0 0 0 0 0 0         2026-06-07 07:03:22.070118 2026-06-07 07:03:22.070119 1   International Results CSV 1 h2h://24:197/1992-05-13
18262 Belgium 12 Faroe Islands 197 1992-06-03 0 0 0 0 0 0         2026-06-07 07:03:22.078548 2026-06-07 07:03:22.078549 1   International Results CSV 1 h2h://197:12/1992-06-03
18294 Cyprus 118 Faroe Islands 197 1992-06-16 0 0 0 0 0 0         2026-06-07 07:03:22.084927 2026-06-07 07:03:22.084927 1   International Results CSV 1 h2h://197:118/1992-06-16
18375 Israel 82 Faroe Islands 197 1992-08-05 0 0 0 0 0 0         2026-06-07 07:03:22.100986 2026-06-07 07:03:22.100986 1   International Results CSV 1 h2h://197:82/1992-08-05
18466 Wales 3 Faroe Islands 197 1992-09-09 0 0 0 0 0 0         2026-06-07 07:03:22.119045 2026-06-07 07:03:22.119046 1   International Results CSV 1 h2h://3:197/1992-09-09
18484 Czechoslovakia 11 Faroe Islands 197 1992-09-23 0 0 0 0 0 0         2026-06-07 07:03:22.122603 2026-06-07 07:03:22.122603 1   International Results CSV 1 h2h://11:197/1992-09-23
18930 Cyprus 118 Faroe Islands 197 1993-04-25 1 1 0 0 2 0 1992-06-16 W     2026-06-07 07:03:22.211206 2026-06-07 07:03:22.211206 1   International Results CSV 1 h2h://118:197/1993-04-25
19027 Belgium 12 Faroe Islands 197 1993-05-22 1 1 0 0 3 0 1992-06-03 W     2026-06-07 07:03:22.230441 2026-06-07 07:03:22.230441 1   International Results CSV 1 h2h://12:197/1993-05-22
19081 Wales 3 Faroe Islands 197 1993-06-06 1 1 0 0 6 0 1992-09-09 L     2026-06-07 07:03:22.241162 2026-06-07 07:03:22.241163 1   International Results CSV 1 h2h://197:3/1993-06-06
19133 Czechoslovakia 11 Faroe Islands 197 1993-06-16 1 1 0 0 4 0 1992-09-23 L     2026-06-07 07:03:22.251545 2026-06-07 07:03:22.251545 1   International Results CSV 1 h2h://197:11/1993-06-16
19284 Norway 24 Faroe Islands 197 1993-08-11 1 1 0 0 2 0 1992-05-13 L     2026-06-07 07:03:22.281702 2026-06-07 07:03:22.281702 1   International Results CSV 1 h2h://197:24/1993-08-11
19322 Romania 38 Faroe Islands 197 1993-09-08 1 1 0 0 7 0 1992-05-06 L     2026-06-07 07:03:22.289277 2026-06-07 07:03:22.289278 1   International Results CSV 1 h2h://197:38/1993-09-08
19866 Greece 39 Faroe Islands 197 1994-09-07 0 0 0 0 0 0         2026-06-07 07:03:22.397611 2026-06-07 07:03:22.397612 1   International Results CSV 1 h2h://197:39/1994-09-07
19957 Scotland 1 Faroe Islands 197 1994-10-12 0 0 0 0 0 0         2026-06-07 07:03:22.415679 2026-06-07 07:03:22.415680 1   International Results CSV 1 h2h://1:197/1994-10-12
20024 Finland 29 Faroe Islands 197 1994-11-16 0 0 0 0 0 0         2026-06-07 07:03:22.750587 2026-06-07 07:03:22.750587 1   International Results CSV 1 h2h://29:197/1994-11-16
20270 Finland 29 Faroe Islands 197 1995-04-26 1 1 0 0 5 0 1994-11-16 L     2026-06-07 07:03:22.797480 2026-06-07 07:03:22.797480 1   International Results CSV 1 h2h://197:29/1995-04-26
20288 Russia 28 Faroe Islands 197 1995-05-06 0 0 0 0 0 0         2026-06-07 07:03:22.800906 2026-06-07 07:03:22.800906 1   International Results CSV 1 h2h://28:197/1995-05-06
20355 Scotland 1 Faroe Islands 197 1995-06-07 1 1 0 0 5 1 1994-10-12 L     2026-06-07 07:03:22.813680 2026-06-07 07:03:22.813681 1   International Results CSV 1 h2h://197:1/1995-06-07
20408 Iceland 104 Faroe Islands 197 1995-07-02 14 13 0 1 52 7 1990-08-08 W     2026-06-07 07:03:22.823796 2026-06-07 07:03:22.823796 1   International Results CSV 1 h2h://104:197/1995-07-02
20544 Russia 28 Faroe Islands 197 1995-09-06 1 1 0 0 3 0 1995-05-06 L     2026-06-07 07:03:22.849754 2026-06-07 07:03:22.849755 1   International Results CSV 1 h2h://197:28/1995-09-06
20638 Greece 39 Faroe Islands 197 1995-11-15 1 1 0 0 5 1 1994-09-07 W     2026-06-07 07:03:22.867728 2026-06-07 07:03:22.867729 1   International Results CSV 1 h2h://39:197/1995-11-15
20866 Estonia 43 Faroe Islands 197 1996-02-24 0 0 0 0 0 0         2026-06-07 07:03:22.911346 2026-06-07 07:03:22.911346 1   International Results CSV 1 h2h://43:197/1996-02-24
20957 Serbia 122 Faroe Islands 197 1996-04-24 0 0 0 0 0 0         2026-06-07 07:03:22.928735 2026-06-07 07:03:22.928735 1   International Results CSV 1 h2h://122:197/1996-04-24
21274 Slovakia 93 Faroe Islands 197 1996-08-31 0 0 0 0 0 0         2026-06-07 07:03:22.989250 2026-06-07 07:03:22.989251 1   International Results CSV 1 h2h://197:93/1996-08-31
21300 Spain 41 Faroe Islands 197 1996-09-04 0 0 0 0 0 0         2026-06-07 07:03:22.994238 2026-06-07 07:03:22.994238 1   International Results CSV 1 h2h://197:41/1996-09-04
21383 Serbia 122 Faroe Islands 197 1996-10-06 1 1 0 0 3 1 1996-04-24 L     2026-06-07 07:03:23.010190 2026-06-07 07:03:23.010190 1   International Results CSV 1 h2h://197:122/1996-10-06
21437 Slovakia 93 Faroe Islands 197 1996-10-23 1 1 0 0 2 1 1996-08-31 W     2026-06-07 07:03:23.020537 2026-06-07 07:03:23.020537 1   International Results CSV 1 h2h://93:197/1996-10-23
21913 Malta 151 Faroe Islands 197 1997-04-30 0 0 0 0 0 0         2026-06-07 07:03:23.112169 2026-06-07 07:03:23.112169 1   International Results CSV 1 h2h://151:197/1997-04-30
22016 Malta 151 Faroe Islands 197 1997-06-08 1 0 1 0 1 2 1997-04-30 W     2026-06-07 07:03:23.132004 2026-06-07 07:03:23.132005 1   International Results CSV 1 h2h://197:151/1997-06-08
22187 Iceland 104 Faroe Islands 197 1997-07-27 15 14 0 1 54 7 1995-07-02 W     2026-06-07 07:03:23.165011 2026-06-07 07:03:23.165011 1   International Results CSV 1 h2h://104:197/1997-07-27
22195 Estonia 43 Faroe Islands 197 1997-08-06 1 0 0 1 2 2 1996-02-24 D     2026-06-07 07:03:23.166548 2026-06-07 07:03:23.166548 1   International Results CSV 1 h2h://43:197/1997-08-06
22378 Spain 41 Faroe Islands 197 1997-10-11 1 1 0 0 6 2 1996-09-04 W     2026-06-07 07:03:23.202080 2026-06-07 07:03:23.202080 1   International Results CSV 1 h2h://41:197/1997-10-11
22794 Estonia 43 Faroe Islands 197 1998-06-04 2 0 1 1 2 4 1997-08-06 L     2026-06-07 07:03:23.281732 2026-06-07 07:03:23.281732 1   International Results CSV 1 h2h://43:197/1998-06-04
23112 Lithuania 60 Faroe Islands 197 1998-10-10 0 0 0 0 0 0         2026-06-07 07:03:23.342141 2026-06-07 07:03:23.342142 1   International Results CSV 1 h2h://60:197/1998-10-10
23141 Scotland 1 Faroe Islands 197 1998-10-14 2 2 0 0 7 1 1995-06-07 W     2026-06-07 07:03:23.347624 2026-06-07 07:03:23.347624 1   International Results CSV 1 h2h://1:197/1998-10-14
23550 Scotland 1 Faroe Islands 197 1999-06-05 3 3 0 0 9 2 1998-10-14 L     2026-06-07 07:03:23.425272 2026-06-07 07:03:23.425272 1   International Results CSV 1 h2h://197:1/1999-06-05
23801 Iceland 104 Faroe Islands 197 1999-08-18 16 15 0 1 55 7 1997-07-27 L     2026-06-07 07:03:23.473624 2026-06-07 07:03:23.473624 1   International Results CSV 1 h2h://197:104/1999-08-18
23832 Estonia 43 Faroe Islands 197 1999-09-04 3 1 1 1 7 4 1998-06-04 L     2026-06-07 07:03:23.479807 2026-06-07 07:03:23.479808 1   International Results CSV 1 h2h://197:43/1999-09-04
23853 Lithuania 60 Faroe Islands 197 1999-09-08 1 0 0 1 0 0 1998-10-10 D     2026-06-07 07:03:23.484314 2026-06-07 07:03:23.484314 1   International Results CSV 1 h2h://197:60/1999-09-08
24099 Finland 29 Faroe Islands 197 2000-01-31 2 2 0 0 9 0 1995-04-26 L     2026-06-07 07:03:23.533470 2026-06-07 07:03:23.533470 1   International Results CSV 1 h2h://197:29/2000-01-31
24117 Iceland 104 Faroe Islands 197 2000-02-04 17 16 0 1 56 7 1999-08-18 L     2026-06-07 07:03:23.537052 2026-06-07 07:03:23.537052 1   International Results CSV 1 h2h://197:104/2000-02-04
24787 Denmark 25 Faroe Islands 197 2000-08-16 2 2 0 0 8 1 1991-09-25 L     2026-06-07 07:03:23.668315 2026-06-07 07:03:23.668315 1   International Results CSV 1 h2h://197:25/2000-08-16
24923 Switzerland 14 Faroe Islands 197 2000-10-07 0 0 0 0 0 0         2026-06-07 07:03:23.695326 2026-06-07 07:03:23.695327 1   International Results CSV 1 h2h://14:197/2000-10-07
25160 Sweden 23 Faroe Islands 197 2001-01-31 0 0 0 0 0 0         2026-06-07 07:03:24.069539 2026-06-07 07:03:24.069539 1   International Results CSV 1 h2h://23:197/2001-01-31
25318 Luxembourg 30 Faroe Islands 197 2001-03-24 0 0 0 0 0 0         2026-06-07 07:03:24.099611 2026-06-07 07:03:24.099611 1   International Results CSV 1 h2h://30:197/2001-03-24
25368 Russia 28 Faroe Islands 197 2001-03-28 2 2 0 0 8 2 1995-09-06 W     2026-06-07 07:03:24.109096 2026-06-07 07:03:24.109096 1   International Results CSV 1 h2h://28:197/2001-03-28
25602 Switzerland 14 Faroe Islands 197 2001-06-02 1 1 0 0 5 1 2000-10-07 L     2026-06-07 07:03:24.153618 2026-06-07 07:03:24.153618 1   International Results CSV 1 h2h://197:14/2001-06-02
25652 Serbia 122 Faroe Islands 197 2001-06-06 2 2 0 0 11 2 1996-10-06 L     2026-06-07 07:03:24.163189 2026-06-07 07:03:24.163189 1   International Results CSV 1 h2h://197:122/2001-06-06
25862 Serbia 122 Faroe Islands 197 2001-08-15 3 3 0 0 17 2 2001-06-06 W     2026-06-07 07:03:24.203349 2026-06-07 07:03:24.203349 1   International Results CSV 1 h2h://122:197/2001-08-15
25887 Luxembourg 30 Faroe Islands 197 2001-09-01 1 0 1 0 0 2 2001-03-24 W     2026-06-07 07:03:24.208083 2026-06-07 07:03:24.208084 1   International Results CSV 1 h2h://197:30/2001-09-01
25920 Russia 28 Faroe Islands 197 2001-09-05 3 3 0 0 9 2 2001-03-28 L     2026-06-07 07:03:24.214440 2026-06-07 07:03:24.214441 1   International Results CSV 1 h2h://197:28/2001-09-05
26222 Poland 49 Faroe Islands 197 2002-02-10 0 0 0 0 0 0         2026-06-07 07:03:24.272310 2026-06-07 07:03:24.272311 1   International Results CSV 1 h2h://197:49/2002-02-10
26619 Scotland 1 Faroe Islands 197 2002-09-07 4 3 0 1 10 3 1999-06-05 D     2026-06-07 07:03:24.348510 2026-06-07 07:03:24.348510 1   International Results CSV 1 h2h://197:1/2002-09-07
26681 Lithuania 60 Faroe Islands 197 2002-10-12 2 1 0 1 1 0 1999-09-08 W     2026-06-07 07:03:24.360497 2026-06-07 07:03:24.360498 1   International Results CSV 1 h2h://60:197/2002-10-12
26719 Germany 22 Faroe Islands 197 2002-10-16 0 0 0 0 0 0         2026-06-07 07:03:24.367750 2026-06-07 07:03:24.367751 1   International Results CSV 1 h2h://22:197/2002-10-16
27211 Iceland 104 Faroe Islands 197 2003-06-07 18 17 0 1 59 9 2000-02-04 W     2026-06-07 07:03:24.462993 2026-06-07 07:03:24.462993 1   International Results CSV 1 h2h://104:197/2003-06-07
27256 Germany 22 Faroe Islands 197 2003-06-11 1 1 0 0 2 1 2002-10-16 L     2026-06-07 07:03:24.471529 2026-06-07 07:03:24.471529 1   International Results CSV 1 h2h://197:22/2003-06-11
27451 Iceland 104 Faroe Islands 197 2003-08-20 19 18 0 1 61 10 2003-06-07 L     2026-06-07 07:03:24.508842 2026-06-07 07:03:24.508843 1   International Results CSV 1 h2h://197:104/2003-08-20
27507 Scotland 1 Faroe Islands 197 2003-09-06 5 3 0 2 12 5 2002-09-07 D     2026-06-07 07:03:24.519564 2026-06-07 07:03:24.519564 1   International Results CSV 1 h2h://1:197/2003-09-06
27530 Lithuania 60 Faroe Islands 197 2003-09-10 3 2 0 1 3 0 2002-10-12 L     2026-06-07 07:03:24.523954 2026-06-07 07:03:24.523955 1   International Results CSV 1 h2h://197:60/2003-09-10
27974 Poland 49 Faroe Islands 197 2004-02-21 1 1 0 0 2 1 2002-02-10 W     2026-06-07 07:03:24.608776 2026-06-07 07:03:24.608776 1   International Results CSV 1 h2h://49:197/2004-02-21
27978 Luxembourg 30 Faroe Islands 197 2004-02-24 2 0 2 0 0 3 2001-09-01 W     2026-06-07 07:03:24.609536 2026-06-07 07:03:24.609536 1   International Results CSV 1 h2h://197:30/2004-02-24
28205 Netherlands 18 Faroe Islands 197 2004-06-01 0 0 0 0 0 0         2026-06-07 07:03:24.652872 2026-06-07 07:03:24.652872 1   International Results CSV 1 h2h://18:197/2004-06-01
28473 Malta 151 Faroe Islands 197 2004-08-18 2 0 2 0 2 4 1997-06-08 W     2026-06-07 07:03:24.704275 2026-06-07 07:03:24.704275 1   International Results CSV 1 h2h://197:151/2004-08-18
28545 Switzerland 14 Faroe Islands 197 2004-09-04 2 2 0 0 6 1 2001-06-02 W     2026-06-07 07:03:24.718042 2026-06-07 07:03:24.718043 1   International Results CSV 1 h2h://14:197/2004-09-04
28570 France 13 Faroe Islands 197 2004-09-08 0 0 0 0 0 0         2026-06-07 07:03:24.722810 2026-06-07 07:03:24.722810 1   International Results CSV 1 h2h://197:13/2004-09-08
28636 Cyprus 118 Faroe Islands 197 2004-10-09 2 2 0 0 5 1 1993-04-25 W     2026-06-07 07:03:24.735469 2026-06-07 07:03:24.735469 1   International Results CSV 1 h2h://118:197/2004-10-09
28691 Republic of Ireland 65 Faroe Islands 197 2004-10-13 0 0 0 0 0 0         2026-06-07 07:03:24.746029 2026-06-07 07:03:24.746029 1   International Results CSV 1 h2h://65:197/2004-10-13
29185 Switzerland 14 Faroe Islands 197 2005-06-04 3 3 0 0 12 1 2004-09-04 L     2026-06-07 07:03:24.840458 2026-06-07 07:03:24.840459 1   International Results CSV 1 h2h://197:14/2005-06-04
29227 Republic of Ireland 65 Faroe Islands 197 2005-06-08 1 1 0 0 2 0 2004-10-13 L     2026-06-07 07:03:24.848595 2026-06-07 07:03:24.848596 1   International Results CSV 1 h2h://197:65/2005-06-08
29379 Cyprus 118 Faroe Islands 197 2005-08-17 3 2 0 1 7 3 2004-10-09 D     2026-06-07 07:03:24.877609 2026-06-07 07:03:24.877609 1   International Results CSV 1 h2h://197:118/2005-08-17
29424 France 13 Faroe Islands 197 2005-09-03 1 1 0 0 2 0 2004-09-08 W     2026-06-07 07:03:24.886176 2026-06-07 07:03:24.886176 1   International Results CSV 1 h2h://13:197/2005-09-03
29472 Israel 82 Faroe Islands 197 2005-09-07 1 0 0 1 1 1 1992-08-05 D     2026-06-07 07:03:24.895401 2026-06-07 07:03:24.895402 1   International Results CSV 1 h2h://197:82/2005-09-07

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 1003.809ms