h2h_record
49 rows where team_a_id = 180
This data as json, CSV (advanced)
Suggested facets: team_b_id, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17220 | Bermuda 180 | Antigua & Barbuda 199 | 1990-04-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.876212 | 2026-06-07 07:03:21.876212 | 1 | International Results CSV 1 | h2h://180:199/1990-04-14 | |||||
| 17222 | Bermuda 180 | Antigua & Barbuda 199 | 1990-04-16 | 1 | 0 | 0 | 1 | 2 | 2 | 1990-04-14 | D | 2026-06-07 07:03:21.876586 | 2026-06-07 07:03:21.876586 | 1 | International Results CSV 1 | h2h://180:199/1990-04-16 | |||
| 18286 | Bermuda 180 | Antigua & Barbuda 199 | 1992-06-14 | 2 | 1 | 0 | 1 | 5 | 2 | 1990-04-16 | L | 2026-06-07 07:03:22.083339 | 2026-06-07 07:03:22.083339 | 1 | International Results CSV 1 | h2h://199:180/1992-06-14 | |||
| 18331 | Bermuda 180 | Antigua & Barbuda 199 | 1992-07-04 | 3 | 2 | 0 | 1 | 8 | 2 | 1992-06-14 | W | 2026-06-07 07:03:22.092227 | 2026-06-07 07:03:22.092227 | 1 | International Results CSV 1 | h2h://180:199/1992-07-04 | |||
| 21897 | Bermuda 180 | Saint Martin 235 | 1997-04-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.109096 | 2026-06-07 07:03:23.109096 | 1 | International Results CSV 1 | h2h://180:235/1997-04-28 | |||||
| 22734 | Bermuda 180 | Cayman Islands 226 | 1998-05-10 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.270271 | 2026-06-07 07:03:23.270272 | 1 | International Results CSV 1 | h2h://226:180/1998-05-10 | |||||
| 23275 | Bermuda 180 | Antigua & Barbuda 199 | 1999-01-12 | 4 | 3 | 0 | 1 | 10 | 3 | 1992-07-04 | W | 2026-06-07 07:03:23.373028 | 2026-06-07 07:03:23.373028 | 1 | International Results CSV 1 | h2h://180:199/1999-01-12 | |||
| 23277 | Bermuda 180 | Antigua & Barbuda 199 | 1999-01-14 | 5 | 4 | 0 | 1 | 11 | 3 | 1999-01-12 | W | 2026-06-07 07:03:23.373412 | 2026-06-07 07:03:23.373413 | 1 | International Results CSV 1 | h2h://180:199/1999-01-14 | |||
| 23501 | Bermuda 180 | Bahamas 192 | 1999-05-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.416028 | 2026-06-07 07:03:23.416028 | 1 | International Results CSV 1 | h2h://180:192/1999-05-05 | |||||
| 23506 | Bermuda 180 | Cayman Islands 226 | 1999-05-07 | 1 | 0 | 1 | 0 | 0 | 2 | 1998-05-10 | L | 2026-06-07 07:03:23.416963 | 2026-06-07 07:03:23.416964 | 1 | International Results CSV 1 | h2h://180:226/1999-05-07 | |||
| 23875 | Bermuda 180 | Cayman Islands 226 | 1999-09-09 | 2 | 1 | 1 | 0 | 4 | 3 | 1999-05-07 | W | 2026-06-07 07:03:23.488819 | 2026-06-07 07:03:23.488819 | 1 | International Results CSV 1 | h2h://180:226/1999-09-09 | |||
| 23877 | Bermuda 180 | Cayman Islands 226 | 1999-09-11 | 3 | 2 | 1 | 0 | 7 | 4 | 1999-09-09 | W | 2026-06-07 07:03:23.489221 | 2026-06-07 07:03:23.489222 | 1 | International Results CSV 1 | h2h://180:226/1999-09-11 | |||
| 24236 | Bermuda 180 | British Virgin Islands 228 | 2000-03-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.560820 | 2026-06-07 07:03:23.560821 | 1 | International Results CSV 1 | h2h://228:180/2000-03-05 | |||||
| 24266 | Bermuda 180 | British Virgin Islands 228 | 2000-03-19 | 1 | 1 | 0 | 0 | 5 | 1 | 2000-03-05 | W | 2026-06-07 07:03:23.566735 | 2026-06-07 07:03:23.566736 | 1 | International Results CSV 1 | h2h://180:228/2000-03-19 | |||
| 24390 | Bermuda 180 | Antigua & Barbuda 199 | 2000-04-16 | 6 | 4 | 1 | 1 | 11 | 4 | 1999-01-14 | W | 2026-06-07 07:03:23.590854 | 2026-06-07 07:03:23.590854 | 1 | International Results CSV 1 | h2h://199:180/2000-04-16 | |||
| 24413 | Bermuda 180 | Antigua & Barbuda 199 | 2000-04-23 | 7 | 4 | 1 | 2 | 11 | 4 | 2000-04-16 | D | 2026-06-07 07:03:23.595187 | 2026-06-07 07:03:23.595187 | 1 | International Results CSV 1 | h2h://180:199/2000-04-23 | |||
| 27982 | Bermuda 180 | Montserrat 237 | 2004-02-29 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.610298 | 2026-06-07 07:03:24.610298 | 1 | International Results CSV 1 | h2h://180:237/2004-02-29 | |||||
| 28000 | Bermuda 180 | Montserrat 237 | 2004-03-21 | 1 | 1 | 0 | 0 | 13 | 0 | 2004-02-29 | L | 2026-06-07 07:03:24.613728 | 2026-06-07 07:03:24.613728 | 1 | International Results CSV 1 | h2h://237:180/2004-03-21 | |||
| 28804 | Bermuda 180 | Cayman Islands 226 | 2004-11-24 | 4 | 3 | 1 | 0 | 8 | 4 | 1999-09-11 | L | 2026-06-07 07:03:24.767526 | 2026-06-07 07:03:24.767526 | 1 | International Results CSV 1 | h2h://226:180/2004-11-24 | |||
| 28815 | Bermuda 180 | British Virgin Islands 228 | 2004-11-28 | 2 | 2 | 0 | 0 | 14 | 1 | 2000-03-19 | W | 2026-06-07 07:03:24.769597 | 2026-06-07 07:03:24.769597 | 1 | International Results CSV 1 | h2h://180:228/2004-11-28 | |||
| 30298 | Bermuda 180 | United States Virgin Islands 253 | 2006-09-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.386377 | 2026-06-07 07:03:25.386377 | 1 | International Results CSV 1 | h2h://253:180/2006-09-27 | |||||
| 30488 | Bermuda 180 | Bahamas 192 | 2006-11-21 | 1 | 1 | 0 | 0 | 6 | 0 | 1999-05-05 | L | 2026-06-07 07:03:25.422543 | 2026-06-07 07:03:25.422543 | 1 | International Results CSV 1 | h2h://192:180/2006-11-21 | |||
| 31007 | Bermuda 180 | Ynys Môn 232 | 2007-06-30 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.522045 | 2026-06-07 07:03:25.522046 | 1 | International Results CSV 1 | h2h://180:232/2007-06-30 | |||||
| 31014 | Bermuda 180 | Åland Islands 234 | 2007-07-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.523389 | 2026-06-07 07:03:25.523389 | 1 | International Results CSV 1 | h2h://234:180/2007-07-01 | |||||
| 31034 | Bermuda 180 | Gibraltar 244 | 2007-07-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.527249 | 2026-06-07 07:03:25.527249 | 1 | International Results CSV 1 | h2h://244:180/2007-07-04 | |||||
| 31042 | Bermuda 180 | Western Isles 273 | 2007-07-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.528784 | 2026-06-07 07:03:25.528784 | 1 | International Results CSV 1 | h2h://180:273/2007-07-05 | |||||
| 31622 | Bermuda 180 | Cayman Islands 226 | 2008-02-03 | 5 | 4 | 1 | 0 | 10 | 5 | 2004-11-24 | W | 2026-06-07 07:03:25.640489 | 2026-06-07 07:03:25.640490 | 1 | International Results CSV 1 | h2h://180:226/2008-02-03 | |||
| 31773 | Bermuda 180 | Cayman Islands 226 | 2008-03-30 | 6 | 4 | 1 | 1 | 11 | 6 | 2008-02-03 | D | 2026-06-07 07:03:25.669917 | 2026-06-07 07:03:25.669917 | 1 | International Results CSV 1 | h2h://226:180/2008-03-30 | |||
| 32248 | Bermuda 180 | Antigua & Barbuda 199 | 2008-08-27 | 8 | 4 | 1 | 3 | 12 | 5 | 2000-04-23 | D | 2026-06-07 07:03:25.762326 | 2026-06-07 07:03:25.762326 | 1 | International Results CSV 1 | h2h://180:199/2008-08-27 | |||
| 32256 | Bermuda 180 | Saint Martin 235 | 2008-08-30 | 1 | 1 | 0 | 0 | 2 | 1 | 1997-04-28 | L | 2026-06-07 07:03:25.763886 | 2026-06-07 07:03:25.763886 | 1 | International Results CSV 1 | h2h://235:180/2008-08-30 | |||
| 32259 | Bermuda 180 | Cayman Islands 226 | 2008-08-31 | 7 | 5 | 1 | 1 | 14 | 7 | 2008-03-30 | L | 2026-06-07 07:03:25.764475 | 2026-06-07 07:03:25.764475 | 1 | International Results CSV 1 | h2h://226:180/2008-08-31 | |||
| 36218 | Bermuda 180 | Saint Martin 235 | 2012-09-11 | 2 | 2 | 0 | 0 | 9 | 1 | 2008-08-30 | L | 2026-06-07 07:03:26.871986 | 2026-06-07 07:03:26.871986 | 1 | International Results CSV 1 | h2h://235:180/2012-09-11 | |||
| 37090 | Bermuda 180 | Greenland 219 | 2013-07-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.042663 | 2026-06-07 07:03:27.042664 | 1 | International Results CSV 1 | h2h://180:219/2013-07-14 | |||||
| 37094 | Bermuda 180 | Falkland Islands 264 | 2013-07-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.043483 | 2026-06-07 07:03:27.043483 | 1 | International Results CSV 1 | h2h://180:264/2013-07-15 | |||||
| 37103 | Bermuda 180 | Frøya 251 | 2013-07-17 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.045301 | 2026-06-07 07:03:27.045301 | 1 | International Results CSV 1 | h2h://180:251/2013-07-17 | |||||
| 37105 | Bermuda 180 | Greenland 219 | 2013-07-18 | 1 | 1 | 0 | 0 | 3 | 0 | 2013-07-14 | W | 2026-06-07 07:03:27.045688 | 2026-06-07 07:03:27.045689 | 1 | International Results CSV 1 | h2h://180:219/2013-07-18 | |||
| 38525 | Bermuda 180 | Bahamas 192 | 2015-03-25 | 2 | 2 | 0 | 0 | 10 | 0 | 2006-11-21 | L | 2026-06-07 07:03:27.329457 | 2026-06-07 07:03:27.329457 | 1 | International Results CSV 1 | h2h://192:180/2015-03-25 | |||
| 38572 | Bermuda 180 | Bahamas 192 | 2015-03-29 | 3 | 3 | 0 | 0 | 15 | 0 | 2015-03-25 | W | 2026-06-07 07:03:27.338750 | 2026-06-07 07:03:27.338751 | 1 | International Results CSV 1 | h2h://180:192/2015-03-29 | |||
| 41301 | Bermuda 180 | Antigua & Barbuda 199 | 2018-03-21 | 9 | 4 | 2 | 3 | 12 | 9 | 2008-08-27 | W | 2026-06-07 07:03:28.219570 | 2026-06-07 07:03:28.219570 | 1 | International Results CSV 1 | h2h://199:180/2018-03-21 | |||
| 41910 | Bermuda 180 | Sint Maarten 230 | 2018-10-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.337225 | 2026-06-07 07:03:28.337225 | 1 | International Results CSV 1 | h2h://180:230/2018-10-12 | |||||
| 44046 | Bermuda 180 | Cayman Islands 226 | 2021-06-08 | 8 | 5 | 1 | 2 | 14 | 7 | 2008-08-31 | D | 2026-06-07 07:03:28.759727 | 2026-06-07 07:03:28.759728 | 1 | International Results CSV 1 | h2h://180:226/2021-06-08 | |||
| 45346 | Bermuda 180 | Montserrat 237 | 2022-06-11 | 2 | 2 | 0 | 0 | 20 | 0 | 2004-03-21 | L | 2026-06-07 07:03:29.375139 | 2026-06-07 07:03:29.375139 | 1 | International Results CSV 1 | h2h://237:180/2022-06-11 | |||
| 46508 | Bermuda 180 | Belize 225 | 2023-10-13 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.597563 | 2026-06-07 07:03:29.597564 | 1 | International Results CSV 1 | h2h://225:180/2023-10-13 | |||||
| 46583 | Bermuda 180 | Belize 225 | 2023-10-17 | 1 | 1 | 0 | 0 | 1 | 0 | 2023-10-13 | W | 2026-06-07 07:03:29.612020 | 2026-06-07 07:03:29.612020 | 1 | International Results CSV 1 | h2h://180:225/2023-10-17 | |||
| 47046 | Bermuda 180 | Brunei 193 | 2024-03-22 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.702230 | 2026-06-07 07:03:29.702230 | 1 | International Results CSV 1 | h2h://193:180/2024-03-22 | |||||
| 47194 | Bermuda 180 | Antigua & Barbuda 199 | 2024-06-05 | 10 | 4 | 3 | 3 | 14 | 12 | 2018-03-21 | W | 2026-06-07 07:03:29.730899 | 2026-06-07 07:03:29.730899 | 1 | International Results CSV 1 | h2h://199:180/2024-06-05 | |||
| 47626 | Bermuda 180 | Antigua & Barbuda 199 | 2024-09-10 | 11 | 4 | 3 | 4 | 15 | 13 | 2024-06-05 | D | 2026-06-07 07:03:29.814087 | 2026-06-07 07:03:29.814087 | 1 | International Results CSV 1 | h2h://199:180/2024-09-10 | |||
| 47927 | Bermuda 180 | Antigua & Barbuda 199 | 2024-11-16 | 12 | 5 | 3 | 4 | 16 | 13 | 2024-09-10 | W | 2026-06-07 07:03:29.871683 | 2026-06-07 07:03:29.871683 | 1 | International Results CSV 1 | h2h://180:199/2024-11-16 | |||
| 48298 | Bermuda 180 | Cayman Islands 226 | 2025-06-04 | 9 | 5 | 1 | 3 | 15 | 8 | 2021-06-08 | D | 2026-06-07 07:03:29.942780 | 2026-06-07 07:03:29.942780 | 1 | International Results CSV 1 | h2h://180:226/2025-06-04 |
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)
);