home / football

h2h_record

24 rows where team_b_id = 119

✎ 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
9071 Tanzania 101 Sierra Leone 119 1972-11-18 0 0 0 0 0 0         2026-06-07 07:03:19.660154 2026-06-07 07:03:19.660154 1   International Results CSV 1 h2h://119:101/1972-11-18
9713 China 33 Sierra Leone 119 1974-05-05 0 0 0 0 0 0         2026-06-07 07:03:19.787468 2026-06-07 07:03:19.787469 1   International Results CSV 1 h2h://33:119/1974-05-05
19606 Zambia 103 Sierra Leone 119 1994-03-29 0 0 0 0 0 0         2026-06-07 07:03:22.345752 2026-06-07 07:03:22.345752 1   International Results CSV 1 h2h://103:119/1994-03-29
20810 Zambia 103 Sierra Leone 119 1996-01-24 1 0 0 1 0 0 1994-03-29 D     2026-06-07 07:03:22.900686 2026-06-07 07:03:22.900687 1   International Results CSV 1 h2h://119:103/1996-01-24
32023 South Africa 21 Sierra Leone 119 2008-06-14 0 0 0 0 0 0         2026-06-07 07:03:25.718486 2026-06-07 07:03:25.718486 1   International Results CSV 1 h2h://119:21/2008-06-14
32083 South Africa 21 Sierra Leone 119 2008-06-21 1 0 1 0 0 1 2008-06-14 L     2026-06-07 07:03:25.730196 2026-06-07 07:03:25.730196 1   International Results CSV 1 h2h://21:119/2008-06-21
34039 Egypt 42 Sierra Leone 119 2010-09-05 0 0 0 0 0 0         2026-06-07 07:03:26.105669 2026-06-07 07:03:26.105669 1   International Results CSV 1 h2h://42:119/2010-09-05
34201 South Africa 21 Sierra Leone 119 2010-10-10 2 0 1 1 0 1 2008-06-21 D     2026-06-07 07:03:26.136622 2026-06-07 07:03:26.136622 1   International Results CSV 1 h2h://119:21/2010-10-10
35140 Egypt 42 Sierra Leone 119 2011-09-03 1 0 0 1 1 1 2010-09-05 D     2026-06-07 07:03:26.665476 2026-06-07 07:03:26.665476 1   International Results CSV 1 h2h://119:42/2011-09-03
35291 South Africa 21 Sierra Leone 119 2011-10-08 3 0 1 2 0 1 2010-10-10 D     2026-06-07 07:03:26.694443 2026-06-07 07:03:26.694443 1   International Results CSV 1 h2h://21:119/2011-10-08
38072 DR Congo 113 Sierra Leone 119 2014-09-10 0 0 0 0 0 0         2026-06-07 07:03:27.239203 2026-06-07 07:03:27.239204 1   International Results CSV 1 h2h://113:119/2014-09-10
38347 DR Congo 113 Sierra Leone 119 2014-11-19 1 1 0 0 2 0 2014-09-10 W     2026-06-07 07:03:27.293821 2026-06-07 07:03:27.293821 1   International Results CSV 1 h2h://113:119/2014-11-19
41299 Iran 99 Sierra Leone 119 2018-03-17 0 0 0 0 0 0         2026-06-07 07:03:28.219192 2026-06-07 07:03:28.219192 1   International Results CSV 1 h2h://99:119/2018-03-17
44271 Ethiopia 112 Sierra Leone 119 2021-08-26 0 0 0 0 0 0         2026-06-07 07:03:28.805386 2026-06-07 07:03:28.805386 1   International Results CSV 1 h2h://112:119/2021-08-26
45522 South Africa 21 Sierra Leone 119 2022-09-24 4 0 1 3 0 1 2011-10-08 D     2026-06-07 07:03:29.408681 2026-06-07 07:03:29.408682 1   International Results CSV 1 h2h://21:119/2022-09-24
45567 DR Congo 113 Sierra Leone 119 2022-09-27 2 2 0 0 5 1 2014-11-19 W     2026-06-07 07:03:29.417298 2026-06-07 07:03:29.417298 1   International Results CSV 1 h2h://113:119/2022-09-27
46635 Ethiopia 112 Sierra Leone 119 2023-11-15 1 0 0 1 0 0 2021-08-26 D     2026-06-07 07:03:29.622159 2026-06-07 07:03:29.622160 1   International Results CSV 1 h2h://112:119/2023-11-15
46733 Egypt 42 Sierra Leone 119 2023-11-19 2 0 1 1 2 3 2011-09-03 W     2026-06-07 07:03:29.641208 2026-06-07 07:03:29.641208 1   International Results CSV 1 h2h://119:42/2023-11-19
47189 Djibouti 111 Sierra Leone 119 2024-06-05 0 0 0 0 0 0         2026-06-07 07:03:29.729953 2026-06-07 07:03:29.729953 1   International Results CSV 1 h2h://119:111/2024-06-05
47614 Zambia 103 Sierra Leone 119 2024-09-10 2 1 0 1 4 0 1996-01-24 W     2026-06-07 07:03:29.811807 2026-06-07 07:03:29.811807 1   International Results CSV 1 h2h://103:119/2024-09-10
48017 Zambia 103 Sierra Leone 119 2024-11-19 3 2 0 1 7 2 2024-09-10 L     2026-06-07 07:03:29.888808 2026-06-07 07:03:29.888808 1   International Results CSV 1 h2h://119:103/2024-11-19
48256 Egypt 42 Sierra Leone 119 2025-03-25 3 1 1 1 4 3 2023-11-19 W     2026-06-07 07:03:29.934777 2026-06-07 07:03:29.934777 1   International Results CSV 1 h2h://42:119/2025-03-25
48636 Ethiopia 112 Sierra Leone 119 2025-09-09 2 0 0 2 0 0 2023-11-15 D     2026-06-07 07:03:30.007432 2026-06-07 07:03:30.007432 1   International Results CSV 1 h2h://119:112/2025-09-09
48760 Djibouti 111 Sierra Leone 119 2025-10-12 1 0 1 0 1 2 2024-06-05 L     2026-06-07 07:03:30.031046 2026-06-07 07:03:30.031047 1   International Results CSV 1 h2h://111:119/2025-10-12

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