h2h_record
20 rows where team_a_id = 199
This data as json, CSV (advanced)
Suggested facets: team_b_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18178 | Antigua & Barbuda 199 | Montserrat 237 | 1992-04-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.061667 | 2026-06-07 07:03:22.061667 | 1 | International Results CSV 1 | h2h://199:237/1992-04-15 | |||||
| 18181 | Antigua & Barbuda 199 | British Virgin Islands 228 | 1992-04-17 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.062265 | 2026-06-07 07:03:22.062266 | 1 | International Results CSV 1 | h2h://199:228/1992-04-17 | |||||
| 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 | |||||
| 18856 | Antigua & Barbuda 199 | Sint Maarten 230 | 1993-04-05 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.196533 | 2026-06-07 07:03:22.196534 | 1 | International Results CSV 1 | h2h://199:230/1993-04-05 | |||||
| 19556 | Antigua & Barbuda 199 | Montserrat 237 | 1994-02-25 | 1 | 1 | 0 | 0 | 5 | 0 | 1992-04-15 | W | 2026-06-07 07:03:22.335757 | 2026-06-07 07:03:22.335757 | 1 | International Results CSV 1 | h2h://199:237/1994-02-25 | |||
| 20460 | Antigua & Barbuda 199 | Cayman Islands 226 | 1995-07-21 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:22.833794 | 2026-06-07 07:03:22.833795 | 1 | International Results CSV 1 | h2h://226:199/1995-07-21 | |||||
| 23350 | Antigua & Barbuda 199 | British Virgin Islands 228 | 1999-02-28 | 1 | 1 | 0 | 0 | 2 | 0 | 1992-04-17 | L | 2026-06-07 07:03:23.387295 | 2026-06-07 07:03:23.387296 | 1 | International Results CSV 1 | h2h://228:199/1999-02-28 | |||
| 24459 | Antigua & Barbuda 199 | British Virgin Islands 228 | 2000-04-30 | 2 | 2 | 0 | 0 | 4 | 0 | 1999-02-28 | L | 2026-06-07 07:03:23.603986 | 2026-06-07 07:03:23.603986 | 1 | International Results CSV 1 | h2h://228:199/2000-04-30 | |||
| 25145 | Antigua & Barbuda 199 | British Virgin Islands 228 | 2001-01-28 | 3 | 2 | 0 | 1 | 5 | 1 | 2000-04-30 | D | 2026-06-07 07:03:24.066710 | 2026-06-07 07:03:24.066711 | 1 | International Results CSV 1 | h2h://199:228/2001-01-28 | |||
| 28733 | Antigua & Barbuda 199 | Montserrat 237 | 2004-11-02 | 2 | 2 | 0 | 0 | 13 | 0 | 1994-02-25 | L | 2026-06-07 07:03:24.754016 | 2026-06-07 07:03:24.754016 | 1 | International Results CSV 1 | h2h://237:199/2004-11-02 | |||
| 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 | |||
| 32254 | Antigua & Barbuda 199 | Cayman Islands 226 | 2008-08-30 | 1 | 0 | 1 | 0 | 0 | 2 | 1995-07-21 | W | 2026-06-07 07:03:25.763493 | 2026-06-07 07:03:25.763493 | 1 | International Results CSV 1 | h2h://226:199/2008-08-30 | |||
| 32258 | Antigua & Barbuda 199 | Saint Martin 235 | 2008-08-31 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:25.764283 | 2026-06-07 07:03:25.764284 | 1 | International Results CSV 1 | h2h://199:235/2008-08-31 | |||||
| 35212 | Antigua & Barbuda 199 | United States Virgin Islands 253 | 2011-09-06 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.679203 | 2026-06-07 07:03:26.679203 | 1 | International Results CSV 1 | h2h://253:199/2011-09-06 | |||||
| 35304 | Antigua & Barbuda 199 | United States Virgin Islands 253 | 2011-10-11 | 1 | 1 | 0 | 0 | 8 | 1 | 2011-09-06 | W | 2026-06-07 07:03:26.696952 | 2026-06-07 07:03:26.696952 | 1 | International Results CSV 1 | h2h://199:253/2011-10-11 | |||
| 38494 | Antigua & Barbuda 199 | United States Virgin Islands 253 | 2015-03-08 | 2 | 2 | 0 | 0 | 18 | 1 | 2011-10-11 | W | 2026-06-07 07:03:27.323346 | 2026-06-07 07:03:27.323347 | 1 | International Results CSV 1 | h2h://199:253/2015-03-08 | |||
| 38508 | Antigua & Barbuda 199 | British Virgin Islands 228 | 2015-03-22 | 4 | 2 | 0 | 2 | 6 | 2 | 2001-01-28 | D | 2026-06-07 07:03:27.326081 | 2026-06-07 07:03:27.326081 | 1 | International Results CSV 1 | h2h://199:228/2015-03-22 | |||
| 43727 | Antigua & Barbuda 199 | Montserrat 237 | 2021-03-24 | 3 | 3 | 0 | 0 | 18 | 4 | 2004-11-02 | W | 2026-06-07 07:03:28.696371 | 2026-06-07 07:03:28.696371 | 1 | International Results CSV 1 | h2h://199:237/2021-03-24 | |||
| 43796 | Antigua & Barbuda 199 | United States Virgin Islands 253 | 2021-03-27 | 3 | 3 | 0 | 0 | 20 | 1 | 2015-03-08 | L | 2026-06-07 07:03:28.710119 | 2026-06-07 07:03:28.710119 | 1 | International Results CSV 1 | h2h://253:199/2021-03-27 | |||
| 47271 | Antigua & Barbuda 199 | Cayman Islands 226 | 2024-06-08 | 2 | 0 | 1 | 1 | 1 | 3 | 2008-08-30 | D | 2026-06-07 07:03:29.745628 | 2026-06-07 07:03:29.745628 | 1 | International Results CSV 1 | h2h://226:199/2024-06-08 |
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)
);