home / football

h2h_record

24 rows where team_a_id = 1276

✎ View and edit SQL

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
50713 Wimbledon 1276 Middlesbrough 1277 1995-11-18 0 0 0 0 0 0         2026-06-11 10:24:41.207948 2026-06-11 10:24:41.207948     International Results CSV 1 h2h://1276:1277/1995-11-18
51484 Wimbledon 1276 Middlesbrough 1277 1996-04-13 1 0 0 1 0 0 1995-11-18 D     2026-06-11 10:24:41.215032 2026-06-11 10:24:41.215032     International Results CSV 1 h2h://1277:1276/1996-04-13
51916 Wimbledon 1276 Derby 1278 1996-09-28 0 0 0 0 0 0         2026-06-11 10:24:41.220768 2026-06-11 10:24:41.220768     International Results CSV 1 h2h://1278:1276/1996-09-28
52065 Wimbledon 1276 Middlesbrough 1277 1996-10-26 2 1 0 1 2 1 1996-04-13 L     2026-06-11 10:24:41.222300 2026-06-11 10:24:41.222300     International Results CSV 1 h2h://1277:1276/1996-10-26
52276 Wimbledon 1276 Sunderland 1279 1996-12-07 0 0 0 0 0 0         2026-06-11 10:24:41.224479 2026-06-11 10:24:41.224479     International Results CSV 1 h2h://1279:1276/1996-12-07
52400 Wimbledon 1276 Derby 1278 1997-01-11 1 1 0 0 2 0 1996-09-28 W     2026-06-11 10:24:41.225811 2026-06-11 10:24:41.225811     International Results CSV 1 h2h://1276:1278/1997-01-11
52487 Wimbledon 1276 Middlesbrough 1277 1997-02-01 3 1 0 2 2 1 1996-10-26 D     2026-06-11 10:24:41.226740 2026-06-11 10:24:41.226740     International Results CSV 1 h2h://1276:1277/1997-02-01
53023 Wimbledon 1276 Sunderland 1279 1997-05-11 1 1 0 0 3 1 1996-12-07 W     2026-06-11 10:24:41.232612 2026-06-11 10:24:41.232613     International Results CSV 1 h2h://1276:1279/1997-05-11
53484 Wimbledon 1276 Derby 1278 1997-10-22 2 1 0 1 3 1 1997-01-11 D     2026-06-11 10:24:41.238983 2026-06-11 10:24:41.238983     International Results CSV 1 h2h://1278:1276/1997-10-22
53896 Wimbledon 1276 Derby 1278 1998-01-17 3 1 0 2 4 2 1997-10-22 D     2026-06-11 10:24:41.242909 2026-06-11 10:24:41.242909     International Results CSV 1 h2h://1276:1278/1998-01-17
54581 Wimbledon 1276 Derby 1278 1998-08-22 4 1 0 3 4 2 1998-01-17 D     2026-06-11 10:24:41.943881 2026-06-11 10:24:41.943881     International Results CSV 1 h2h://1278:1276/1998-08-22
54893 Wimbledon 1276 Middlesbrough 1277 1998-10-24 4 1 0 3 3 2 1997-02-01 D     2026-06-11 10:24:42.031955 2026-06-11 10:24:42.031955     International Results CSV 1 h2h://1276:1277/1998-10-24
55333 Wimbledon 1276 Charlton 1280 1998-12-26 0 0 0 0 0 0         2026-06-11 10:24:42.131191 2026-06-11 10:24:42.131191     International Results CSV 1 h2h://1276:1280/1998-12-26
55372 Wimbledon 1276 Derby 1278 1999-01-09 5 1 0 4 4 2 1998-08-22 D     2026-06-11 10:24:42.138770 2026-06-11 10:24:42.138770     International Results CSV 1 h2h://1276:1278/1999-01-09
55525 Wimbledon 1276 Charlton 1280 1999-02-08 1 1 0 0 2 1 1998-12-26 L     2026-06-11 10:24:42.173334 2026-06-11 10:24:42.173334     International Results CSV 1 h2h://1280:1276/1999-02-08
55825 Wimbledon 1276 Middlesbrough 1277 1999-04-05 5 1 0 4 5 4 1998-10-24 D     2026-06-11 10:24:42.251454 2026-06-11 10:24:42.251455     International Results CSV 1 h2h://1277:1276/1999-04-05
56237 Wimbledon 1276 Middlesbrough 1277 1999-08-10 6 1 1 4 6 7 1999-04-05 L     2026-06-11 10:24:42.384826 2026-06-11 10:24:42.384826     International Results CSV 1 h2h://1276:1277/1999-08-10
56385 Wimbledon 1276 Derby 1278 1999-09-11 6 2 0 4 6 3 1999-01-09 W     2026-06-11 10:24:42.427765 2026-06-11 10:24:42.427765     International Results CSV 1 h2h://1276:1278/1999-09-11
56593 Wimbledon 1276 Bradford 1281 1999-10-16 0 0 0 0 0 0         2026-06-11 10:24:42.477417 2026-06-11 10:24:42.477417     International Results CSV 1 h2h://1276:1281/1999-10-16
56825 Wimbledon 1276 Middlesbrough 1277 1999-11-27 7 1 2 4 8 10 1999-08-10 W     2026-06-11 10:24:42.532784 2026-06-11 10:24:42.532785     International Results CSV 1 h2h://1277:1276/1999-11-27
57035 Wimbledon 1276 Sunderland 1279 2000-01-03 2 2 0 0 4 1 1997-05-11 W     2026-06-11 10:24:42.576223 2026-06-11 10:24:42.576223     International Results CSV 1 h2h://1276:1279/2000-01-03
57379 Wimbledon 1276 Derby 1278 2000-03-04 7 2 0 5 8 5 1999-09-11 D     2026-06-11 10:24:42.670697 2026-06-11 10:24:42.670697     International Results CSV 1 h2h://1278:1276/2000-03-04
57599 Wimbledon 1276 Sunderland 1279 2000-04-08 3 3 0 0 5 1 2000-01-03 L     2026-06-11 10:24:42.732342 2026-06-11 10:24:42.732342     International Results CSV 1 h2h://1279:1276/2000-04-08
57765 Wimbledon 1276 Bradford 1281 2000-04-30 1 1 0 0 3 2 1999-10-16 L     2026-06-11 10:24:42.780151 2026-06-11 10:24:42.780152     International Results CSV 1 h2h://1281:1276/2000-04-30

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 727.009ms