home / football

h2h_record

34 rows where team_b_id = 7

✎ View and edit SQL

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
919 United States 5 Uruguay 7 1924-05-29 0 0 0 0 0 0         2026-06-07 07:03:18.439890 2026-06-07 07:03:18.439890 1   International Results CSV 1 h2h://7:5/1924-05-29
3773 England 2 Uruguay 7 1953-05-31 0 0 0 0 0 0         2026-06-07 07:03:18.465762 2026-06-07 07:03:18.465762 1   International Results CSV 1 h2h://7:2/1953-05-31
3962 Scotland 1 Uruguay 7 1954-06-19 0 0 0 0 0 0         2026-06-07 07:03:18.467384 2026-06-07 07:03:18.467384 1   International Results CSV 1 h2h://1:7/1954-06-19
3969 England 2 Uruguay 7 1954-06-26 1 0 1 0 1 2 1953-05-31 L     2026-06-07 07:03:18.467441 2026-06-07 07:03:18.467442 1   International Results CSV 1 h2h://2:7/1954-06-26
5472 Scotland 1 Uruguay 7 1962-05-02 1 0 1 0 0 7 1954-06-19 L     2026-06-07 07:03:18.966306 2026-06-07 07:03:18.966307 1   International Results CSV 1 h2h://1:7/1962-05-02
6036 Northern Ireland 4 Uruguay 7 1964-04-29 0 0 0 0 0 0         2026-06-07 07:03:19.074766 2026-06-07 07:03:19.074767 1   International Results CSV 1 h2h://4:7/1964-04-29
6040 England 2 Uruguay 7 1964-05-06 2 0 2 0 3 6 1954-06-26 L     2026-06-07 07:03:19.075532 2026-06-07 07:03:19.075532 1   International Results CSV 1 h2h://2:7/1964-05-06
6691 England 2 Uruguay 7 1966-07-11 3 1 2 0 5 7 1964-05-06 W     2026-06-07 07:03:19.199124 2026-06-07 07:03:19.199125 1   International Results CSV 1 h2h://2:7/1966-07-11
7693 England 2 Uruguay 7 1969-06-08 4 1 2 1 5 7 1966-07-11 D     2026-06-07 07:03:19.389247 2026-06-07 07:03:19.389248 1   International Results CSV 1 h2h://7:2/1969-06-08
11010 England 2 Uruguay 7 1977-06-15 5 2 2 1 7 8 1969-06-08 L     2026-06-07 07:03:20.346063 2026-06-07 07:03:20.346064 1   International Results CSV 1 h2h://7:2/1977-06-15
13852 Scotland 1 Uruguay 7 1983-09-21 2 0 2 0 2 10 1962-05-02 L     2026-06-07 07:03:20.909363 2026-06-07 07:03:20.909363 1   International Results CSV 1 h2h://1:7/1983-09-21
14150 England 2 Uruguay 7 1984-06-13 6 2 2 2 7 8 1977-06-15 D     2026-06-07 07:03:20.968470 2026-06-07 07:03:20.968471 1   International Results CSV 1 h2h://7:2/1984-06-13
15129 Canada 6 Uruguay 7 1986-02-02 0 0 0 0 0 0         2026-06-07 07:03:21.476389 2026-06-07 07:03:21.476389 1   International Results CSV 1 h2h://6:7/1986-02-02
15257 Wales 3 Uruguay 7 1986-04-21 0 0 0 0 0 0         2026-06-07 07:03:21.500621 2026-06-07 07:03:21.500621 1   International Results CSV 1 h2h://3:7/1986-04-21
15346 Scotland 1 Uruguay 7 1986-06-13 3 1 2 0 4 10 1983-09-21 W     2026-06-07 07:03:21.517496 2026-06-07 07:03:21.517496 1   International Results CSV 1 h2h://1:7/1986-06-13
17261 Northern Ireland 4 Uruguay 7 1990-05-18 1 1 0 0 3 0 1964-04-29 W     2026-06-07 07:03:21.884063 2026-06-07 07:03:21.884063 1   International Results CSV 1 h2h://4:7/1990-05-18
17270 England 2 Uruguay 7 1990-05-22 7 2 3 2 7 10 1984-06-13 L     2026-06-07 07:03:21.885753 2026-06-07 07:03:21.885754 1   International Results CSV 1 h2h://2:7/1990-05-22
17710 United States 5 Uruguay 7 1991-05-05 1 0 1 0 0 3 1924-05-29 L     2026-06-07 07:03:21.970043 2026-06-07 07:03:21.970044 1   International Results CSV 1 h2h://5:7/1991-05-05
19138 United States 5 Uruguay 7 1993-06-16 2 1 1 0 1 3 1991-05-05 L     2026-06-07 07:03:22.252523 2026-06-07 07:03:22.252523 1   International Results CSV 1 h2h://7:5/1993-06-16
20190 United States 5 Uruguay 7 1995-03-25 3 1 2 0 1 4 1993-06-16 L     2026-06-07 07:03:22.782263 2026-06-07 07:03:22.782263 1   International Results CSV 1 h2h://5:7/1995-03-25
20201 England 2 Uruguay 7 1995-03-29 8 2 4 2 8 12 1990-05-22 L     2026-06-07 07:03:22.784350 2026-06-07 07:03:22.784350 1   International Results CSV 1 h2h://2:7/1995-03-29
26373 United States 5 Uruguay 7 2002-05-12 4 1 2 1 3 6 1995-03-25 D     2026-06-07 07:03:24.301182 2026-06-07 07:03:24.301182 1   International Results CSV 1 h2h://5:7/2002-05-12
29828 England 2 Uruguay 7 2006-03-01 9 2 4 3 8 12 1995-03-29 D     2026-06-07 07:03:24.963442 2026-06-07 07:03:24.963442 1   International Results CSV 1 h2h://2:7/2006-03-01
29929 Northern Ireland 4 Uruguay 7 2006-05-21 2 2 0 0 4 0 1990-05-18 W     2026-06-07 07:03:24.982557 2026-06-07 07:03:24.982557 1   International Results CSV 1 h2h://4:7/2006-05-21
37744 Northern Ireland 4 Uruguay 7 2014-05-30 3 2 1 0 4 1 2006-05-21 W     2026-06-07 07:03:27.174208 2026-06-07 07:03:27.174208 1   International Results CSV 1 h2h://7:4/2014-05-30
37869 England 2 Uruguay 7 2014-06-19 10 3 4 3 10 13 2006-03-01 L     2026-06-07 07:03:27.198893 2026-06-07 07:03:27.198893 1   International Results CSV 1 h2h://7:2/2014-06-19
41387 Wales 3 Uruguay 7 2018-03-26 1 0 0 1 0 0 1986-04-21 D     2026-06-07 07:03:28.236115 2026-06-07 07:03:28.236115 1   International Results CSV 1 h2h://3:7/2018-03-26
42935 United States 5 Uruguay 7 2019-09-10 5 2 2 1 5 7 2002-05-12 W     2026-06-07 07:03:28.538296 2026-06-07 07:03:28.538296 1   International Results CSV 1 h2h://5:7/2019-09-10
45235 United States 5 Uruguay 7 2022-06-05 6 2 2 2 6 8 2019-09-10 D     2026-06-07 07:03:29.354187 2026-06-07 07:03:29.354187 1   International Results CSV 1 h2h://5:7/2022-06-05
45566 Canada 6 Uruguay 7 2022-09-27 1 0 1 0 1 3 1986-02-02 L     2026-06-07 07:03:29.417105 2026-06-07 07:03:29.417105 1   International Results CSV 1 h2h://6:7/2022-09-27
47435 United States 5 Uruguay 7 2024-07-01 7 2 2 3 6 8 2022-06-05 D     2026-06-07 07:03:29.777417 2026-06-07 07:03:29.777418 1   International Results CSV 1 h2h://5:7/2024-07-01
47453 Canada 6 Uruguay 7 2024-07-13 2 0 2 0 1 5 2022-09-27 L     2026-06-07 07:03:29.780943 2026-06-07 07:03:29.780944 1   International Results CSV 1 h2h://6:7/2024-07-13
48978 United States 5 Uruguay 7 2025-11-18 8 2 3 3 6 9 2024-07-01 L     2026-06-07 07:03:30.073072 2026-06-07 07:03:30.073072 1   International Results CSV 1 h2h://5:7/2025-11-18
49133 England 2 Uruguay 7 2026-03-27 11 3 5 3 11 15 2014-06-19 L     2026-06-07 07:03:30.102703 2026-06-07 07:03:30.102704 1   International Results CSV 1 h2h://2:7/2026-03-27

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Queries took 825.104ms