h2h_record
6 rows where team_b_id = 51
This data as json, CSV (advanced)
Suggested facets: team_a_id, total_matches, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 712 | Luxembourg 30 | Brittany 51 | 1922-03-12 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.438097 | 2026-06-07 07:03:18.438097 | 1 | International Results CSV 1 | h2h://51:30/1922-03-12 | |||||
| 788 | Luxembourg 30 | Brittany 51 | 1923-02-11 | 1 | 0 | 1 | 0 | 0 | 1 | 1922-03-12 | L | 2026-06-07 07:03:18.438734 | 2026-06-07 07:03:18.438734 | 1 | International Results CSV 1 | h2h://30:51/1923-02-11 | |||
| 858 | Norway 24 | Brittany 51 | 1923-11-01 | 0 | 0 | 0 | 0 | 0 | 0 | 2026-06-07 07:03:18.439382 | 2026-06-07 07:03:18.439382 | 1 | International Results CSV 1 | h2h://51:24/1923-11-01 | |||||
| 886 | Luxembourg 30 | Brittany 51 | 1924-03-23 | 2 | 0 | 2 | 0 | 1 | 5 | 1923-02-11 | W | 2026-06-07 07:03:18.439621 | 2026-06-07 07:03:18.439621 | 1 | International Results CSV 1 | h2h://51:30/1924-03-23 | |||
| 984 | Luxembourg 30 | Brittany 51 | 1925-02-22 | 3 | 0 | 2 | 1 | 2 | 6 | 1924-03-23 | D | 2026-06-07 07:03:18.440415 | 2026-06-07 07:03:18.440415 | 1 | International Results CSV 1 | h2h://30:51/1925-02-22 | |||
| 2444 | Luxembourg 30 | Brittany 51 | 1939-04-23 | 4 | 0 | 2 | 2 | 3 | 7 | 1925-02-22 | D | 2026-06-07 07:03:18.453393 | 2026-06-07 07:03:18.453393 | 1 | International Results CSV 1 | h2h://51:30/1939-04-23 |
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)
);