home / football

h2h_record

30 rows where team_a_id = 170

✎ 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
5424 Chad 170 Niger 171 1961-12-25 0 0 0 0 0 0         2026-06-07 07:03:18.957215 2026-06-07 07:03:18.957215 1   International Results CSV 1 h2h://170:171/1961-12-25
14492 Chad 170 Equatorial Guinea 202 1984-12-16 0 0 0 0 0 0         2026-06-07 07:03:21.035948 2026-06-07 07:03:21.035949 1   International Results CSV 1 h2h://170:202/1984-12-16
15082 Chad 170 Equatorial Guinea 202 1985-12-10 1 0 0 1 1 1 1984-12-16 D     2026-06-07 07:03:21.467509 2026-06-07 07:03:21.467510 1   International Results CSV 1 h2h://170:202/1985-12-10
15537 Chad 170 Equatorial Guinea 202 1986-12-13 2 0 0 2 2 2 1985-12-10 D     2026-06-07 07:03:21.553888 2026-06-07 07:03:21.553888 1   International Results CSV 1 h2h://202:170/1986-12-13
15908 Chad 170 Equatorial Guinea 202 1987-12-15 3 1 0 2 3 2 1986-12-13 W     2026-06-07 07:03:21.624729 2026-06-07 07:03:21.624729 1   International Results CSV 1 h2h://170:202/1987-12-15
17559 Chad 170 Equatorial Guinea 202 1990-12-12 4 2 0 2 7 2 1987-12-15 W     2026-06-07 07:03:21.941086 2026-06-07 07:03:21.941086 1   International Results CSV 1 h2h://170:202/1990-12-12
18323 Chad 170 Eritrea 243 1992-06-28 0 0 0 0 0 0         2026-06-07 07:03:22.090665 2026-06-07 07:03:22.090666 1   International Results CSV 1 h2h://170:243/1992-06-28
22320 Chad 170 Bahrain 183 1997-09-25 0 0 0 0 0 0         2026-06-07 07:03:23.190703 2026-06-07 07:03:23.190704 1   International Results CSV 1 h2h://183:170/1997-09-25
23960 Chad 170 São Tomé & Príncipe 206 1999-11-10 0 0 0 0 0 0         2026-06-07 07:03:23.505794 2026-06-07 07:03:23.505794 1   International Results CSV 1 h2h://170:206/1999-11-10
23969 Chad 170 Equatorial Guinea 202 1999-11-13 5 3 0 2 8 2 1990-12-12 W     2026-06-07 07:03:23.507570 2026-06-07 07:03:23.507570 1   International Results CSV 1 h2h://170:202/1999-11-13
26669 Chad 170 Algeria 173 2002-10-11 0 0 0 0 0 0         2026-06-07 07:03:24.358172 2026-06-07 07:03:24.358173 1   International Results CSV 1 h2h://173:170/2002-10-11
27084 Chad 170 Namibia 231 2003-03-30 0 0 0 0 0 0         2026-06-07 07:03:24.438425 2026-06-07 07:03:24.438425 1   International Results CSV 1 h2h://170:231/2003-03-30
27218 Chad 170 Namibia 231 2003-06-07 1 1 0 0 2 0 2003-03-30 L     2026-06-07 07:03:24.464320 2026-06-07 07:03:24.464321 1   International Results CSV 1 h2h://231:170/2003-06-07
27380 Chad 170 Algeria 173 2003-07-06 1 0 1 0 1 4 2002-10-11 L     2026-06-07 07:03:24.495073 2026-06-07 07:03:24.495073 1   International Results CSV 1 h2h://170:173/2003-07-06
27636 Chad 170 Angola 205 2003-10-12 0 0 0 0 0 0         2026-06-07 07:03:24.544233 2026-06-07 07:03:24.544233 1   International Results CSV 1 h2h://170:205/2003-10-12
27721 Chad 170 Angola 205 2003-11-16 1 1 0 0 3 1 2003-10-12 L     2026-06-07 07:03:24.560383 2026-06-07 07:03:24.560383 1   International Results CSV 1 h2h://205:170/2003-11-16
33877 Chad 170 Niger 171 2010-06-19 1 0 0 1 2 2 1961-12-25 D     2026-06-07 07:03:26.074753 2026-06-07 07:03:26.074754 1   International Results CSV 1 h2h://171:170/2010-06-19
33921 Chad 170 Botswana 189 2010-07-09 0 0 0 0 0 0         2026-06-07 07:03:26.083088 2026-06-07 07:03:26.083089 1   International Results CSV 1 h2h://189:170/2010-07-09
34608 Chad 170 Botswana 189 2011-03-26 1 0 1 0 0 1 2010-07-09 L     2026-06-07 07:03:26.214701 2026-06-07 07:03:26.214701 1   International Results CSV 1 h2h://170:189/2011-03-26
35801 Chad 170 Rwanda 207 2012-05-30 0 0 0 0 0 0         2026-06-07 07:03:26.791954 2026-06-07 07:03:26.791955 1   International Results CSV 1 h2h://170:207/2012-05-30
37640 Chad 170 Yemen 182 2014-04-15 0 0 0 0 0 0         2026-06-07 07:03:27.153531 2026-06-07 07:03:27.153531 1   International Results CSV 1 h2h://182:170/2014-04-15
38695 Chad 170 Guinea 172 2015-06-06 0 0 0 0 0 0         2026-06-07 07:03:27.363305 2026-06-07 07:03:27.363305 1   International Results CSV 1 h2h://172:170/2015-06-06
43154 Chad 170 Namibia 231 2019-11-13 2 1 1 0 3 2 2003-06-07 W     2026-06-07 07:03:28.581983 2026-06-07 07:03:28.581983 1   International Results CSV 1 h2h://231:170/2019-11-13
43476 Chad 170 Niger 171 2020-10-10 2 0 0 2 3 3 2010-06-19 D     2026-06-07 07:03:28.646282 2026-06-07 07:03:28.646282 1   International Results CSV 1 h2h://171:170/2020-10-10
43566 Chad 170 Guinea 172 2020-11-11 1 0 1 0 1 2 2015-06-06 W     2026-06-07 07:03:28.664326 2026-06-07 07:03:28.664326 1   International Results CSV 1 h2h://172:170/2020-11-11
43640 Chad 170 Guinea 172 2020-11-15 2 0 2 0 1 3 2020-11-11 L     2026-06-07 07:03:28.679086 2026-06-07 07:03:28.679086 1   International Results CSV 1 h2h://170:172/2020-11-15
43744 Chad 170 Namibia 231 2021-03-24 3 1 2 0 4 4 2019-11-13 L     2026-06-07 07:03:28.699715 2026-06-07 07:03:28.699715 1   International Results CSV 1 h2h://170:231/2021-03-24
47328 Chad 170 Comoros 213 2024-06-11 0 0 0 0 0 0         2026-06-07 07:03:29.756635 2026-06-07 07:03:29.756635 1   International Results CSV 1 h2h://170:213/2024-06-11
48270 Chad 170 Comoros 213 2025-03-25 1 0 1 0 0 2 2024-06-11 W     2026-06-07 07:03:29.937443 2026-06-07 07:03:29.937443 1   International Results CSV 1 h2h://213:170/2025-03-25
48935 Chad 170 Mozambique 203 2025-11-17 0 0 0 0 0 0         2026-06-07 07:03:30.064794 2026-06-07 07:03:30.064795 1   International Results CSV 1 h2h://203:170/2025-11-17

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