h2h_record
4 rows where team_b_id = 292
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35742 | Mauritania 168 | Kurdistan 292 | 2012-05-15 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.780736 | 2026-06-07 07:03:26.780737 | 1 | International Results CSV 1 | h2h://292:168/2012-05-15 | |||||
| 35747 | Indonesia 83 | Kurdistan 292 | 2012-05-19 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:26.781684 | 2026-06-07 07:03:26.781684 | 1 | International Results CSV 1 | h2h://83:292/2012-05-19 | |||||
| 37045 | Western Sahara 261 | Kurdistan 292 | 2013-06-24 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.033566 | 2026-06-07 07:03:27.033566 | 1 | International Results CSV 1 | h2h://261:292/2013-06-24 | |||||
| 37052 | Provence 45 | Kurdistan 292 | 2013-06-28 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:27.034964 | 2026-06-07 07:03:27.034965 | 1 | International Results CSV 1 | h2h://45:292/2013-06-28 |
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)
);