h2h_record
57 rows where team_b_id = 227
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17733 | Saint Lucia 85 | Anguilla 227 | 1991-05-16 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:21.974441 | 2026-06-07 07:03:21.974441 | 1 | International Results CSV 1 | h2h://85:227/1991-05-16 | |||||
| 18207 | Cuba 77 | Anguilla 227 | 1992-05-02 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.067526 | 2026-06-07 07:03:22.067527 | 1 | International Results CSV 1 | h2h://227:77/1992-05-02 | |||||
| 18215 | Cuba 77 | Anguilla 227 | 1992-05-09 | 1 | 1 | 0 | 0 | 3 | 0 | 1992-05-02 | W | 2026-06-07 07:03:22.069127 | 2026-06-07 07:03:22.069127 | 1 | International Results CSV 1 | h2h://77:227/1992-05-09 | |||
| 18851 | Antigua & Barbuda 199 | Anguilla 227 | 1993-04-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.195541 | 2026-06-07 07:03:22.195542 | 1 | International Results CSV 1 | h2h://227:199/1993-04-04 | |||||
| 19565 | Guadeloupe 81 | Anguilla 227 | 1994-03-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.337538 | 2026-06-07 07:03:22.337538 | 1 | International Results CSV 1 | h2h://81:227/1994-03-04 | |||||
| 19570 | Saint Vincent and the Grenadines 165 | Anguilla 227 | 1994-03-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.338512 | 2026-06-07 07:03:22.338512 | 1 | International Results CSV 1 | h2h://165:227/1994-03-06 | |||||
| 20919 | Saint Kitts and Nevis 90 | Anguilla 227 | 1996-03-27 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.921473 | 2026-06-07 07:03:22.921473 | 1 | International Results CSV 1 | h2h://90:227/1996-03-27 | |||||
| 21834 | Dominica 79 | Anguilla 227 | 1997-04-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.096970 | 2026-06-07 07:03:23.096970 | 1 | International Results CSV 1 | h2h://79:227/1997-04-06 | |||||
| 22694 | Grenada 91 | Anguilla 227 | 1998-04-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.262669 | 2026-06-07 07:03:23.262669 | 1 | International Results CSV 1 | h2h://91:227/1998-04-15 | |||||
| 22700 | Guyana 19 | Anguilla 227 | 1998-04-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.263799 | 2026-06-07 07:03:23.263799 | 1 | International Results CSV 1 | h2h://19:227/1998-04-19 | |||||
| 24233 | Bahamas 192 | Anguilla 227 | 2000-03-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:23.560231 | 2026-06-07 07:03:23.560232 | 1 | International Results CSV 1 | h2h://227:192/2000-03-05 | |||||
| 24264 | Bahamas 192 | Anguilla 227 | 2000-03-19 | 1 | 1 | 0 | 0 | 3 | 1 | 2000-03-05 | W | 2026-06-07 07:03:23.566353 | 2026-06-07 07:03:23.566353 | 1 | International Results CSV 1 | h2h://192:227/2000-03-19 | |||
| 27996 | Dominican Republic 117 | Anguilla 227 | 2004-03-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:24.612981 | 2026-06-07 07:03:24.612982 | 1 | International Results CSV 1 | h2h://117:227/2004-03-19 | |||||
| 27999 | Dominican Republic 117 | Anguilla 227 | 2004-03-21 | 1 | 0 | 0 | 1 | 0 | 0 | 2004-03-19 | D | 2026-06-07 07:03:24.613545 | 2026-06-07 07:03:24.613545 | 1 | International Results CSV 1 | h2h://117:227/2004-03-21 | |||
| 30284 | Antigua & Barbuda 199 | Anguilla 227 | 2006-09-20 | 1 | 1 | 0 | 0 | 4 | 0 | 1993-04-04 | W | 2026-06-07 07:03:25.383706 | 2026-06-07 07:03:25.383707 | 1 | International Results CSV 1 | h2h://199:227/2006-09-20 | |||
| 30288 | Saint Kitts and Nevis 90 | Anguilla 227 | 2006-09-22 | 1 | 1 | 0 | 0 | 8 | 0 | 1996-03-27 | L | 2026-06-07 07:03:25.384466 | 2026-06-07 07:03:25.384466 | 1 | International Results CSV 1 | h2h://227:90/2006-09-22 | |||
| 30293 | Barbados 75 | Anguilla 227 | 2006-09-24 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.385414 | 2026-06-07 07:03:25.385415 | 1 | International Results CSV 1 | h2h://75:227/2006-09-24 | |||||
| 31641 | El Salvador 47 | Anguilla 227 | 2008-02-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.644169 | 2026-06-07 07:03:25.644170 | 1 | International Results CSV 1 | h2h://47:227/2008-02-06 | |||||
| 31713 | El Salvador 47 | Anguilla 227 | 2008-03-26 | 1 | 1 | 0 | 0 | 12 | 0 | 2008-02-06 | L | 2026-06-07 07:03:25.658251 | 2026-06-07 07:03:25.658251 | 1 | International Results CSV 1 | h2h://227:47/2008-03-26 | |||
| 32373 | Martinique 78 | Anguilla 227 | 2008-09-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.786395 | 2026-06-07 07:03:25.786396 | 1 | International Results CSV 1 | h2h://78:227/2008-09-19 | |||||
| 34130 | Puerto Rico 97 | Anguilla 227 | 2010-10-02 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.123139 | 2026-06-07 07:03:26.123139 | 1 | International Results CSV 1 | h2h://97:227/2010-10-02 | |||||
| 34133 | Cayman Islands 226 | Anguilla 227 | 2010-10-04 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.123716 | 2026-06-07 07:03:26.123717 | 1 | International Results CSV 1 | h2h://226:227/2010-10-04 | |||||
| 34900 | Dominican Republic 117 | Anguilla 227 | 2011-07-08 | 2 | 1 | 0 | 1 | 6 | 0 | 2004-03-21 | W | 2026-06-07 07:03:26.270598 | 2026-06-07 07:03:26.270598 | 1 | International Results CSV 1 | h2h://117:227/2011-07-08 | |||
| 34911 | Dominican Republic 117 | Anguilla 227 | 2011-07-10 | 3 | 2 | 0 | 1 | 8 | 0 | 2011-07-08 | W | 2026-06-07 07:03:26.272731 | 2026-06-07 07:03:26.272731 | 1 | International Results CSV 1 | h2h://117:227/2011-07-10 | |||
| 36291 | French Guiana 84 | Anguilla 227 | 2012-10-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.886026 | 2026-06-07 07:03:26.886026 | 1 | International Results CSV 1 | h2h://84:227/2012-10-12 | |||||
| 36328 | Trinidad & Tobago 20 | Anguilla 227 | 2012-10-14 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.893179 | 2026-06-07 07:03:26.893180 | 1 | International Results CSV 1 | h2h://20:227/2012-10-14 | |||||
| 38001 | Saint Vincent and the Grenadines 165 | Anguilla 227 | 2014-09-05 | 1 | 1 | 0 | 0 | 2 | 0 | 1994-03-06 | W | 2026-06-07 07:03:27.225159 | 2026-06-07 07:03:27.225159 | 1 | International Results CSV 1 | h2h://165:227/2014-09-05 | |||
| 38511 | Nicaragua 76 | Anguilla 227 | 2015-03-23 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.326661 | 2026-06-07 07:03:27.326662 | 1 | International Results CSV 1 | h2h://76:227/2015-03-23 | |||||
| 38571 | Nicaragua 76 | Anguilla 227 | 2015-03-29 | 1 | 1 | 0 | 0 | 5 | 0 | 2015-03-23 | L | 2026-06-07 07:03:27.338557 | 2026-06-07 07:03:27.338558 | 1 | International Results CSV 1 | h2h://227:76/2015-03-29 | |||
| 39536 | Puerto Rico 97 | Anguilla 227 | 2016-03-26 | 1 | 1 | 0 | 0 | 3 | 1 | 2010-10-02 | L | 2026-06-07 07:03:27.530603 | 2026-06-07 07:03:27.530603 | 1 | International Results CSV 1 | h2h://227:97/2016-03-26 | |||
| 41757 | French Guiana 84 | Anguilla 227 | 2018-09-07 | 1 | 1 | 0 | 0 | 4 | 1 | 2012-10-12 | L | 2026-06-07 07:03:28.307517 | 2026-06-07 07:03:28.307517 | 1 | International Results CSV 1 | h2h://227:84/2018-09-07 | |||
| 41955 | Nicaragua 76 | Anguilla 227 | 2018-10-14 | 2 | 2 | 0 | 0 | 8 | 0 | 2015-03-29 | W | 2026-06-07 07:03:28.345853 | 2026-06-07 07:03:28.345853 | 1 | International Results CSV 1 | h2h://76:227/2018-10-14 | |||
| 42118 | Bahamas 192 | Anguilla 227 | 2018-11-18 | 2 | 2 | 0 | 0 | 5 | 2 | 2000-03-19 | W | 2026-06-07 07:03:28.377395 | 2026-06-07 07:03:28.377395 | 1 | International Results CSV 1 | h2h://192:227/2018-11-18 | |||
| 42831 | Guatemala 48 | Anguilla 227 | 2019-09-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.516841 | 2026-06-07 07:03:28.516841 | 1 | International Results CSV 1 | h2h://48:227/2019-09-05 | |||||
| 43060 | Guatemala 48 | Anguilla 227 | 2019-10-12 | 1 | 1 | 0 | 0 | 10 | 0 | 2019-09-05 | L | 2026-06-07 07:03:28.563276 | 2026-06-07 07:03:28.563276 | 1 | International Results CSV 1 | h2h://227:48/2019-10-12 | |||
| 43129 | Puerto Rico 97 | Anguilla 227 | 2019-10-15 | 2 | 2 | 0 | 0 | 7 | 1 | 2016-03-26 | L | 2026-06-07 07:03:28.577021 | 2026-06-07 07:03:28.577022 | 1 | International Results CSV 1 | h2h://227:97/2019-10-15 | |||
| 43153 | Trinidad & Tobago 20 | Anguilla 227 | 2019-11-10 | 1 | 1 | 0 | 0 | 10 | 0 | 2012-10-14 | W | 2026-06-07 07:03:28.581790 | 2026-06-07 07:03:28.581791 | 1 | International Results CSV 1 | h2h://20:227/2019-11-10 | |||
| 43313 | Puerto Rico 97 | Anguilla 227 | 2019-11-19 | 3 | 3 | 0 | 0 | 10 | 3 | 2019-10-15 | W | 2026-06-07 07:03:28.613558 | 2026-06-07 07:03:28.613559 | 1 | International Results CSV 1 | h2h://97:227/2019-11-19 | |||
| 43799 | Dominican Republic 117 | Anguilla 227 | 2021-03-27 | 4 | 3 | 0 | 1 | 12 | 0 | 2011-07-10 | L | 2026-06-07 07:03:28.710715 | 2026-06-07 07:03:28.710715 | 1 | International Results CSV 1 | h2h://227:117/2021-03-27 | |||
| 43862 | Barbados 75 | Anguilla 227 | 2021-03-30 | 1 | 1 | 0 | 0 | 7 | 1 | 2006-09-24 | W | 2026-06-07 07:03:28.723173 | 2026-06-07 07:03:28.723173 | 1 | International Results CSV 1 | h2h://75:227/2021-03-30 | |||
| 43941 | Dominica 79 | Anguilla 227 | 2021-06-02 | 1 | 1 | 0 | 0 | 5 | 0 | 1997-04-06 | W | 2026-06-07 07:03:28.738745 | 2026-06-07 07:03:28.738745 | 1 | International Results CSV 1 | h2h://79:227/2021-06-02 | |||
| 43998 | Panama 87 | Anguilla 227 | 2021-06-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:28.750131 | 2026-06-07 07:03:28.750131 | 1 | International Results CSV 1 | h2h://87:227/2021-06-05 | |||||
| 45156 | Dominica 79 | Anguilla 227 | 2022-06-02 | 2 | 2 | 0 | 0 | 8 | 0 | 2021-06-02 | L | 2026-06-07 07:03:29.339055 | 2026-06-07 07:03:29.339055 | 1 | International Results CSV 1 | h2h://227:79/2022-06-02 | |||
| 45221 | Dominica 79 | Anguilla 227 | 2022-06-05 | 3 | 2 | 0 | 1 | 8 | 0 | 2022-06-02 | D | 2026-06-07 07:03:29.351496 | 2026-06-07 07:03:29.351496 | 1 | International Results CSV 1 | h2h://79:227/2022-06-05 | |||
| 45365 | Saint Lucia 85 | Anguilla 227 | 2022-06-12 | 1 | 1 | 0 | 0 | 6 | 0 | 1991-05-16 | W | 2026-06-07 07:03:29.378743 | 2026-06-07 07:03:29.378744 | 1 | International Results CSV 1 | h2h://85:227/2022-06-12 | |||
| 45902 | Saint Lucia 85 | Anguilla 227 | 2023-03-24 | 2 | 2 | 0 | 0 | 8 | 0 | 2022-06-12 | L | 2026-06-07 07:03:29.481527 | 2026-06-07 07:03:29.481527 | 1 | International Results CSV 1 | h2h://227:85/2023-03-24 | |||
| 47276 | Suriname 44 | Anguilla 227 | 2024-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.746582 | 2026-06-07 07:03:29.746582 | 1 | International Results CSV 1 | h2h://227:44/2024-06-08 | |||||
| 47352 | Puerto Rico 97 | Anguilla 227 | 2024-06-11 | 4 | 4 | 0 | 0 | 13 | 3 | 2019-11-19 | W | 2026-06-07 07:03:29.761235 | 2026-06-07 07:03:29.761236 | 1 | International Results CSV 1 | h2h://97:227/2024-06-11 | |||
| 47628 | Belize 225 | Anguilla 227 | 2024-09-10 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:29.814466 | 2026-06-07 07:03:29.814467 | 1 | International Results CSV 1 | h2h://225:227/2024-09-10 | |||||
| 47656 | Belize 225 | Anguilla 227 | 2024-10-09 | 1 | 1 | 0 | 0 | 1 | 0 | 2024-09-10 | W | 2026-06-07 07:03:29.819854 | 2026-06-07 07:03:29.819854 | 1 | International Results CSV 1 | h2h://225:227/2024-10-09 | |||
| 48280 | Saint Kitts and Nevis 90 | Anguilla 227 | 2025-05-25 | 2 | 2 | 0 | 0 | 14 | 1 | 2006-09-22 | L | 2026-06-07 07:03:29.939329 | 2026-06-07 07:03:29.939329 | 1 | International Results CSV 1 | h2h://227:90/2025-05-25 | |||
| 48290 | Grenada 91 | Anguilla 227 | 2025-06-01 | 1 | 1 | 0 | 0 | 14 | 1 | 1998-04-15 | W | 2026-06-07 07:03:29.941237 | 2026-06-07 07:03:29.941237 | 1 | International Results CSV 1 | h2h://91:227/2025-06-01 | |||
| 48303 | Saint Vincent and the Grenadines 165 | Anguilla 227 | 2025-06-04 | 2 | 2 | 0 | 0 | 6 | 0 | 2014-09-05 | W | 2026-06-07 07:03:29.943719 | 2026-06-07 07:03:29.943719 | 1 | International Results CSV 1 | h2h://165:227/2025-06-04 | |||
| 48374 | El Salvador 47 | Anguilla 227 | 2025-06-07 | 2 | 2 | 0 | 0 | 16 | 0 | 2008-03-26 | L | 2026-06-07 07:03:29.957273 | 2026-06-07 07:03:29.957273 | 1 | International Results CSV 1 | h2h://227:47/2025-06-07 | |||
| 48849 | Bahamas 192 | Anguilla 227 | 2025-11-12 | 3 | 2 | 0 | 1 | 6 | 3 | 2018-11-18 | D | 2026-06-07 07:03:30.047928 | 2026-06-07 07:03:30.047928 | 1 | International Results CSV 1 | h2h://192:227/2025-11-12 | |||
| 48923 | Cayman Islands 226 | Anguilla 227 | 2025-11-15 | 1 | 1 | 0 | 0 | 4 | 1 | 2010-10-04 | W | 2026-06-07 07:03:30.062444 | 2026-06-07 07:03:30.062444 | 1 | International Results CSV 1 | h2h://226:227/2025-11-15 | |||
| 49128 | Bahamas 192 | Anguilla 227 | 2026-03-26 | 4 | 2 | 1 | 1 | 7 | 5 | 2025-11-12 | L | 2026-06-07 07:03:30.101724 | 2026-06-07 07:03:30.101725 | 1 | International Results CSV 1 | h2h://192:227/2026-03-26 |
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)
);