home / football

h2h_record

157 rows where team_a_id = 104

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_b_id, 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
6091 Iceland 104 Bermuda 180 1964-08-10 0 0 0 0 0 0         2026-06-07 07:03:19.085326 2026-06-07 07:03:19.085326 1   International Results CSV 1 h2h://104:180/1964-08-10
7705 Iceland 104 Bermuda 180 1969-06-23 1 1 0 0 4 3 1964-08-10 W     2026-06-07 07:03:19.391528 2026-06-07 07:03:19.391528 1   International Results CSV 1 h2h://104:180/1969-06-23
7885 Iceland 104 Bermuda 180 1969-11-11 2 2 0 0 6 4 1969-06-23 L     2026-06-07 07:03:19.426150 2026-06-07 07:03:19.426151 1   International Results CSV 1 h2h://180:104/1969-11-11
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
9368 Iceland 104 German DR 131 1973-07-17 0 0 0 0 0 0         2026-06-07 07:03:19.719382 2026-06-07 07:03:19.719382 1   International Results CSV 1 h2h://104:131/1973-07-17
9370 Iceland 104 German DR 131 1973-07-19 1 0 1 0 1 2 1973-07-17 L     2026-06-07 07:03:19.719777 2026-06-07 07:03:19.719777 1   International Results CSV 1 h2h://104:131/1973-07-19
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
9905 Iceland 104 German DR 131 1974-10-12 2 0 2 0 1 4 1973-07-19 W     2026-06-07 07:03:19.825419 2026-06-07 07:03:19.825419 1   International Results CSV 1 h2h://131:104/1974-10-12
10128 Iceland 104 German DR 131 1975-06-05 3 0 2 1 2 5 1974-10-12 D     2026-06-07 07:03:20.177459 2026-06-07 07:03:20.177459 1   International Results CSV 1 h2h://104:131/1975-06-05
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
11523 Iceland 104 German DR 131 1978-10-04 4 1 2 1 4 6 1975-06-05 L     2026-06-07 07:03:20.447158 2026-06-07 07:03:20.447158 1   International Results CSV 1 h2h://131:104/1978-10-04
11942 Iceland 104 German DR 131 1979-09-12 5 1 3 1 5 9 1978-10-04 L     2026-06-07 07:03:20.530052 2026-06-07 07:03:20.530052 1   International Results CSV 1 h2h://104:131/1979-09-12
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
12291 Iceland 104 Greenland 219 1980-07-03 0 0 0 0 0 0         2026-06-07 07:03:20.599376 2026-06-07 07:03:20.599377 1   International Results CSV 1 h2h://104:219/1980-07-03
12895 Iceland 104 Nigeria 120 1981-08-22 0 0 0 0 0 0         2026-06-07 07:03:20.719349 2026-06-07 07:03:20.719349 1   International Results CSV 1 h2h://104:120/1981-08-22
13176 Iceland 104 Kuwait 174 1982-03-14 0 0 0 0 0 0         2026-06-07 07:03:20.775182 2026-06-07 07:03:20.775183 1   International Results CSV 1 h2h://174:104/1982-03-14
13276 Iceland 104 Malta 151 1982-06-05 0 0 0 0 0 0         2026-06-07 07:03:20.795168 2026-06-07 07:03:20.795169 1   International Results CSV 1 h2h://151:104/1982-06-05
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
13379 Iceland 104 German DR 131 1982-09-08 6 1 4 1 5 12 1979-09-12 L     2026-06-07 07:03:20.815511 2026-06-07 07:03:20.815512 1   International Results CSV 1 h2h://104:131/1982-09-08
13675 Iceland 104 Malta 151 1983-06-05 1 0 1 0 1 2 1982-06-05 L     2026-06-07 07:03:20.874161 2026-06-07 07:03:20.874161 1   International Results CSV 1 h2h://104:151/1983-06-05
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
14215 Iceland 104 Greenland 219 1984-08-03 1 1 0 0 4 1 1980-07-03 L     2026-06-07 07:03:20.981384 2026-06-07 07:03:20.981384 1   International Results CSV 1 h2h://219:104/1984-08-03
14301 Iceland 104 Saudi Arabia 179 1984-09-25 0 0 0 0 0 0         2026-06-07 07:03:20.998260 2026-06-07 07:03:20.998260 1   International Results CSV 1 h2h://179:104/1984-09-25
14681 Iceland 104 Kuwait 174 1985-03-31 1 0 0 1 0 0 1982-03-14 D     2026-06-07 07:03:21.073404 2026-06-07 07:03:21.073405 1   International Results CSV 1 h2h://174:104/1985-03-31
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
15201 Iceland 104 Bahrain 183 1986-03-11 0 0 0 0 0 0         2026-06-07 07:03:21.489927 2026-06-07 07:03:21.489927 1   International Results CSV 1 h2h://183:104/1986-03-11
15213 Iceland 104 Bahrain 183 1986-03-15 1 0 1 0 1 2 1986-03-11 W     2026-06-07 07:03:21.492237 2026-06-07 07:03:21.492237 1   International Results CSV 1 h2h://183:104/1986-03-15
15218 Iceland 104 Kuwait 174 1986-03-19 2 0 0 2 1 1 1985-03-31 D     2026-06-07 07:03:21.493183 2026-06-07 07:03:21.493183 1   International Results CSV 1 h2h://174:104/1986-03-19
15502 Iceland 104 German DR 131 1986-10-29 7 1 5 1 5 13 1982-09-08 W     2026-06-07 07:03:21.547241 2026-06-07 07:03:21.547242 1   International Results CSV 1 h2h://131:104/1986-10-29
15586 Iceland 104 Kuwait 174 1987-02-26 3 0 1 2 1 2 1986-03-19 W     2026-06-07 07:03:21.563143 2026-06-07 07:03:21.563143 1   International Results CSV 1 h2h://174:104/1987-02-26
15591 Iceland 104 Kuwait 174 1987-02-28 4 0 1 3 2 3 1987-02-26 D     2026-06-07 07:03:21.564074 2026-06-07 07:03:21.564074 1   International Results CSV 1 h2h://174:104/1987-02-28
15693 Iceland 104 German DR 131 1987-06-03 8 1 6 1 5 15 1986-10-29 L     2026-06-07 07:03:21.583585 2026-06-07 07:03:21.583586 1   International Results CSV 1 h2h://104:131/1987-06-03
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
16339 Iceland 104 German DR 131 1988-10-19 9 1 7 1 5 21 1987-06-03 W     2026-06-07 07:03:21.707097 2026-06-07 07:03:21.707098 1   International Results CSV 1 h2h://131:104/1988-10-19
16944 Iceland 104 German DR 131 1989-09-06 10 1 8 1 5 23 1988-10-19 L     2026-06-07 07:03:21.823435 2026-06-07 07:03:21.823436 1   International Results CSV 1 h2h://104:131/1989-09-06
17212 Iceland 104 Bermuda 180 1990-04-03 3 2 1 0 8 7 1969-11-11 W     2026-06-07 07:03:21.874653 2026-06-07 07:03:21.874653 1   International Results CSV 1 h2h://180:104/1990-04-03
17292 Iceland 104 Albania 105 1990-05-30 0 0 0 0 0 0         2026-06-07 07:03:21.889986 2026-06-07 07:03:21.889986 1   International Results CSV 1 h2h://104:105/1990-05-30
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
17713 Iceland 104 Malta 151 1991-05-07 2 1 1 0 2 2 1983-06-05 L     2026-06-07 07:03:21.970634 2026-06-07 07:03:21.970634 1   International Results CSV 1 h2h://151:104/1991-05-07
17752 Iceland 104 Albania 105 1991-05-26 1 1 0 0 2 0 1990-05-30 L     2026-06-07 07:03:21.978056 2026-06-07 07:03:21.978057 1   International Results CSV 1 h2h://105:104/1991-05-26
17988 Iceland 104 Cyprus 118 1991-10-16 0 0 0 0 0 0         2026-06-07 07:03:22.023509 2026-06-07 07:03:22.023509 1   International Results CSV 1 h2h://118:104/1991-10-16
18126 Iceland 104 Malta 151 1992-02-10 3 2 1 0 6 3 1991-05-07 L     2026-06-07 07:03:22.051256 2026-06-07 07:03:22.051256 1   International Results CSV 1 h2h://151:104/1992-02-10
18141 Iceland 104 United Arab Emirates 196 1992-03-02 0 0 0 0 0 0         2026-06-07 07:03:22.054259 2026-06-07 07:03:22.054259 1   International Results CSV 1 h2h://196:104/1992-03-02
19383 Iceland 104 Tunisia 152 1993-10-17 0 0 0 0 0 0         2026-06-07 07:03:22.301388 2026-06-07 07:03:22.301388 1   International Results CSV 1 h2h://152:104/1993-10-17
19651 Iceland 104 Saudi Arabia 179 1994-04-20 1 1 0 0 2 1 1984-09-25 W     2026-06-07 07:03:22.354678 2026-06-07 07:03:22.354678 1   International Results CSV 1 h2h://104:179/1994-04-20
19844 Iceland 104 United Arab Emirates 196 1994-08-30 1 1 0 0 1 0 1992-03-02 W     2026-06-07 07:03:22.393272 2026-06-07 07:03:22.393272 1   International Results CSV 1 h2h://104:196/1994-08-30
19982 Iceland 104 Kuwait 174 1994-10-29 5 1 1 3 3 3 1987-02-28 L     2026-06-07 07:03:22.420580 2026-06-07 07:03:22.420581 1   International Results CSV 1 h2h://174:104/1994-10-29
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
20838 Iceland 104 Slovenia 238 1996-02-07 0 0 0 0 0 0         2026-06-07 07:03:22.905981 2026-06-07 07:03:22.905981 1   International Results CSV 1 h2h://104:238/1996-02-07
20847 Iceland 104 Malta 151 1996-02-11 4 2 2 0 6 4 1992-02-10 W     2026-06-07 07:03:22.907698 2026-06-07 07:03:22.907698 1   International Results CSV 1 h2h://151:104/1996-02-11
21052 Iceland 104 North Macedonia 246 1996-06-01 0 0 0 0 0 0         2026-06-07 07:03:22.946869 2026-06-07 07:03:22.946869 1   International Results CSV 1 h2h://104:246/1996-06-01
21089 Iceland 104 Cyprus 118 1996-06-05 1 0 0 1 1 1 1991-10-16 D     2026-06-07 07:03:22.953917 2026-06-07 07:03:22.953918 1   International Results CSV 1 h2h://104:118/1996-06-05
21237 Iceland 104 Malta 151 1996-08-14 5 3 2 0 10 5 1996-02-11 W     2026-06-07 07:03:22.982208 2026-06-07 07:03:22.982208 1   International Results CSV 1 h2h://104:151/1996-08-14
21299 Iceland 104 Czech Republic 247 1996-09-04 0 0 0 0 0 0         2026-06-07 07:03:22.994045 2026-06-07 07:03:22.994045 1   International Results CSV 1 h2h://247:104/1996-09-04
22000 Iceland 104 North Macedonia 246 1997-06-07 1 0 0 1 1 1 1996-06-01 D     2026-06-07 07:03:23.128916 2026-06-07 07:03:23.128916 1   International Results CSV 1 h2h://246:104/1997-06-07
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
22232 Iceland 104 Liechtenstein 220 1997-08-20 0 0 0 0 0 0         2026-06-07 07:03:23.173693 2026-06-07 07:03:23.173693 1   International Results CSV 1 h2h://220:104/1997-08-20
22366 Iceland 104 Liechtenstein 220 1997-10-11 1 1 0 0 4 0 1997-08-20 W     2026-06-07 07:03:23.199799 2026-06-07 07:03:23.199799 1   International Results CSV 1 h2h://104:220/1997-10-11
22477 Iceland 104 Saudi Arabia 179 1997-12-07 2 1 1 0 2 3 1994-04-20 W     2026-06-07 07:03:23.221222 2026-06-07 07:03:23.221222 1   International Results CSV 1 h2h://179:104/1997-12-07
22562 Iceland 104 Slovenia 238 1998-02-05 1 0 1 0 1 7 1996-02-07 L     2026-06-07 07:03:23.237398 2026-06-07 07:03:23.237398 1   International Results CSV 1 h2h://104:238/1998-02-05
22735 Iceland 104 Saudi Arabia 179 1998-05-13 3 1 1 1 2 3 1997-12-07 D     2026-06-07 07:03:23.270458 2026-06-07 07:03:23.270459 1   International Results CSV 1 h2h://104:179/1998-05-13
23103 Iceland 104 Armenia 209 1998-10-10 0 0 0 0 0 0         2026-06-07 07:03:23.340435 2026-06-07 07:03:23.340436 1   International Results CSV 1 h2h://209:104/1998-10-10
23405 Iceland 104 Andorra 250 1999-03-27 0 0 0 0 0 0         2026-06-07 07:03:23.397727 2026-06-07 07:03:23.397727 1   International Results CSV 1 h2h://250:104/1999-03-27
23489 Iceland 104 Malta 151 1999-04-28 6 4 2 0 12 6 1996-08-14 L     2026-06-07 07:03:23.413731 2026-06-07 07:03:23.413731 1   International Results CSV 1 h2h://151:104/1999-04-28
23555 Iceland 104 Armenia 209 1999-06-05 1 0 0 1 0 0 1998-10-10 D     2026-06-07 07:03:23.426217 2026-06-07 07:03:23.426217 1   International Results CSV 1 h2h://104:209/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
23834 Iceland 104 Andorra 250 1999-09-04 1 1 0 0 2 0 1999-03-27 W     2026-06-07 07:03:23.480335 2026-06-07 07:03:23.480335 1   International Results CSV 1 h2h://104:250/1999-09-04
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
24757 Iceland 104 Malta 151 2000-07-27 7 5 2 0 14 7 1999-04-28 W     2026-06-07 07:03:23.662312 2026-06-07 07:03:23.662312 1   International Results CSV 1 h2h://104:151/2000-07-27
24904 Iceland 104 Czech Republic 247 2000-10-07 1 0 1 0 1 2 1996-09-04 W     2026-06-07 07:03:23.691610 2026-06-07 07:03:23.691611 1   International Results CSV 1 h2h://247:104/2000-10-07
25472 Iceland 104 Malta 151 2001-04-25 8 6 2 0 19 7 2000-07-27 L     2026-06-07 07:03:24.128847 2026-06-07 07:03:24.128847 1   International Results CSV 1 h2h://151:104/2001-04-25
25607 Iceland 104 Malta 151 2001-06-02 9 7 2 0 23 8 2001-04-25 W     2026-06-07 07:03:24.154572 2026-06-07 07:03:24.154572 1   International Results CSV 1 h2h://104:151/2001-06-02
25890 Iceland 104 Czech Republic 247 2001-09-01 2 0 2 0 1 6 2000-10-07 L     2026-06-07 07:03:24.208664 2026-06-07 07:03:24.208664 1   International Results CSV 1 h2h://104:247/2001-09-01
26130 Iceland 104 Kuwait 174 2002-01-08 6 2 1 3 4 3 1994-10-29 L     2026-06-07 07:03:24.254630 2026-06-07 07:03:24.254631 1   International Results CSV 1 h2h://174:104/2002-01-08
26136 Iceland 104 Saudi Arabia 179 2002-01-10 4 1 1 2 3 4 1998-05-13 D     2026-06-07 07:03:24.255757 2026-06-07 07:03:24.255757 1   International Results CSV 1 h2h://179:104/2002-01-10
26564 Iceland 104 Andorra 250 2002-08-21 2 2 0 0 5 0 1999-09-04 W     2026-06-07 07:03:24.337853 2026-06-07 07:03:24.337854 1   International Results CSV 1 h2h://104:250/2002-08-21
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
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
28017 Iceland 104 Albania 105 2004-03-31 2 1 1 0 2 1 1991-05-26 W     2026-06-07 07:03:24.616968 2026-06-07 07:03:24.616969 1   International Results CSV 1 h2h://105:104/2004-03-31
28650 Iceland 104 Malta 151 2004-10-09 10 8 2 0 26 8 2001-06-02 L     2026-06-07 07:03:24.738178 2026-06-07 07:03:24.738178 1   International Results CSV 1 h2h://151:104/2004-10-09
29231 Iceland 104 Malta 151 2005-06-08 11 8 2 1 26 8 2004-10-09 D     2026-06-07 07:03:24.849366 2026-06-07 07:03:24.849366 1   International Results CSV 1 h2h://104:151/2005-06-08
30846 Iceland 104 Liechtenstein 220 2007-06-02 2 2 0 0 8 0 1997-10-11 W     2026-06-07 07:03:25.491311 2026-06-07 07:03:25.491311 1   International Results CSV 1 h2h://104:220/2007-06-02
31363 Iceland 104 Liechtenstein 220 2007-10-17 3 2 0 1 9 1 2007-06-02 D     2026-06-07 07:03:25.590340 2026-06-07 07:03:25.590340 1   International Results CSV 1 h2h://220:104/2007-10-17
31628 Iceland 104 Malta 151 2008-02-04 12 9 2 1 30 9 2005-06-08 L     2026-06-07 07:03:25.641656 2026-06-07 07:03:25.641656 1   International Results CSV 1 h2h://151:104/2008-02-04
31630 Iceland 104 Armenia 209 2008-02-06 2 1 0 1 2 0 1999-06-05 L     2026-06-07 07:03:25.642040 2026-06-07 07:03:25.642040 1   International Results CSV 1 h2h://209:104/2008-02-06
31699 Iceland 104 Faroe Islands 197 2008-03-16 20 19 0 1 63 11 2003-08-20 W     2026-06-07 07:03:25.655537 2026-06-07 07:03:25.655538 1   International Results CSV 1 h2h://104:197/2008-03-16
32213 Iceland 104 Azerbaijan 211 2008-08-20 0 0 0 0 0 0         2026-06-07 07:03:25.755527 2026-06-07 07:03:25.755527 1   International Results CSV 1 h2h://104:211/2008-08-20
32482 Iceland 104 North Macedonia 246 2008-10-15 2 0 1 1 1 2 1997-06-07 L     2026-06-07 07:03:25.807311 2026-06-07 07:03:25.807311 1   International Results CSV 1 h2h://104:246/2008-10-15
32570 Iceland 104 Malta 151 2008-11-19 13 9 3 1 30 10 2008-02-04 W     2026-06-07 07:03:25.824271 2026-06-07 07:03:25.824271 1   International Results CSV 1 h2h://151:104/2008-11-19
32764 Iceland 104 Liechtenstein 220 2009-02-11 4 2 1 1 9 4 2007-10-17 W     2026-06-07 07:03:25.861953 2026-06-07 07:03:25.861953 1   International Results CSV 1 h2h://220:104/2009-02-11
32803 Iceland 104 Faroe Islands 197 2009-03-22 21 20 0 1 66 11 2008-03-16 W     2026-06-07 07:03:25.869517 2026-06-07 07:03:25.869517 1   International Results CSV 1 h2h://104:197/2009-03-22
33024 Iceland 104 North Macedonia 246 2009-06-10 3 1 1 1 2 2 2008-10-15 L     2026-06-07 07:03:25.912007 2026-06-07 07:03:25.912008 1   International Results CSV 1 h2h://246:104/2009-06-10
33288 Iceland 104 Georgia 210 2009-09-09 0 0 0 0 0 0         2026-06-07 07:03:25.962377 2026-06-07 07:03:25.962378 1   International Results CSV 1 h2h://104:210/2009-09-09
33677 Iceland 104 Cyprus 118 2010-03-03 2 1 0 1 3 2 1996-06-05 L     2026-06-07 07:03:26.036648 2026-06-07 07:03:26.036648 1   International Results CSV 1 h2h://118:104/2010-03-03
33721 Iceland 104 Faroe Islands 197 2010-03-21 22 20 1 1 67 13 2009-03-22 L     2026-06-07 07:03:26.045095 2026-06-07 07:03:26.045095 1   International Results CSV 1 h2h://104:197/2010-03-21

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