home / football

h2h_record

74 rows where team_a_id = 918

✎ 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
86954 Everton FC 918 Stoke City 919 2017-08-12 0 0 0 0 0 0         2026-06-11 10:25:14.630255 2026-06-11 10:25:14.630255     International Results CSV 1 h2h://918:919/2017-08-12
87142 Everton FC 918 Manchester U 924 2017-09-17 0 0 0 0 0 0         2026-06-11 10:25:14.691250 2026-06-11 10:25:14.691251     International Results CSV 1 h2h://924:918/2017-09-17
87197 Everton FC 918 AFC Bournemouth 923 2017-09-23 0 0 0 0 0 0         2026-06-11 10:25:14.702485 2026-06-11 10:25:14.702486     International Results CSV 1 h2h://918:923/2017-09-23
87572 Everton FC 918 Southampton FC 920 2017-11-26 0 0 0 0 0 0         2026-06-11 10:25:14.810501 2026-06-11 10:25:14.810502     International Results CSV 1 h2h://920:918/2017-11-26
87781 Everton FC 918 Swansea City 921 2017-12-18 0 0 0 0 0 0         2026-06-11 10:25:14.859178 2026-06-11 10:25:14.859178     International Results CSV 1 h2h://918:921/2017-12-18
87819 Everton FC 918 West Bromwich 922 2017-12-26 0 0 0 0 0 0         2026-06-11 10:25:14.867810 2026-06-11 10:25:14.867811     International Results CSV 1 h2h://922:918/2017-12-26
87824 Everton FC 918 AFC Bournemouth 923 2017-12-30 1 1 0 0 2 1 2017-09-23 L     2026-06-11 10:25:14.869460 2026-06-11 10:25:14.869460     International Results CSV 1 h2h://923:918/2017-12-30
87846 Everton FC 918 Manchester U 924 2018-01-01 1 0 1 0 0 4 2017-09-17 L     2026-06-11 10:25:14.873482 2026-06-11 10:25:14.873483     International Results CSV 1 h2h://918:924/2018-01-01
87937 Everton FC 918 West Bromwich 922 2018-01-20 1 0 0 1 0 0 2017-12-26 D     2026-06-11 10:25:14.891675 2026-06-11 10:25:14.891675     International Results CSV 1 h2h://918:922/2018-01-20
88321 Everton FC 918 Stoke City 919 2018-03-17 1 1 0 0 1 0 2017-08-12 L     2026-06-11 10:25:14.965405 2026-06-11 10:25:14.965405     International Results CSV 1 h2h://919:918/2018-03-17
88470 Everton FC 918 Swansea City 921 2018-04-14 1 1 0 0 3 1 2017-12-18 L     2026-06-11 10:25:15.018025 2026-06-11 10:25:15.018025     International Results CSV 1 h2h://921:918/2018-04-14
88641 Everton FC 918 Southampton FC 920 2018-05-05 1 0 1 0 1 4 2017-11-26 L     2026-06-11 10:25:15.051037 2026-06-11 10:25:15.051038     International Results CSV 1 h2h://918:920/2018-05-05
88789 Everton FC 918 Southampton FC 920 2018-08-18 2 0 1 1 2 5 2018-05-05 D     2026-06-11 10:25:15.124057 2026-06-11 10:25:15.124057     International Results CSV 1 h2h://918:920/2018-08-18
88829 Everton FC 918 AFC Bournemouth 923 2018-08-25 2 1 1 0 3 3 2017-12-30 W     2026-06-11 10:25:15.131929 2026-06-11 10:25:15.131929     International Results CSV 1 h2h://923:918/2018-08-25
89067 Everton FC 918 Fulham FC 926 2018-09-29 0 0 0 0 0 0         2026-06-11 10:25:15.204879 2026-06-11 10:25:15.204879     International Results CSV 1 h2h://918:926/2018-09-29
89233 Everton FC 918 Manchester U 924 2018-10-28 2 0 2 0 0 6 2018-01-01 W     2026-06-11 10:25:15.265582 2026-06-11 10:25:15.265583     International Results CSV 1 h2h://924:918/2018-10-28
89358 Everton FC 918 Cardiff City 925 2018-11-24 0 0 0 0 0 0         2026-06-11 10:25:15.719891 2026-06-11 10:25:15.719892     International Results CSV 1 h2h://918:925/2018-11-24
89694 Everton FC 918 AFC Bournemouth 923 2019-01-13 3 1 1 1 5 5 2018-08-25 D     2026-06-11 10:25:15.793899 2026-06-11 10:25:15.793900     International Results CSV 1 h2h://918:923/2019-01-13
89720 Everton FC 918 Southampton FC 920 2019-01-19 3 1 1 1 4 6 2018-08-18 L     2026-06-11 10:25:15.801108 2026-06-11 10:25:15.801108     International Results CSV 1 h2h://920:918/2019-01-19
89993 Everton FC 918 Cardiff City 925 2019-02-26 1 1 0 0 1 0 2018-11-24 L     2026-06-11 10:25:15.855814 2026-06-11 10:25:15.855815     International Results CSV 1 h2h://925:918/2019-02-26
90275 Everton FC 918 Fulham FC 926 2019-04-13 1 1 0 0 3 0 2018-09-29 L     2026-06-11 10:25:15.934987 2026-06-11 10:25:15.934987     International Results CSV 1 h2h://926:918/2019-04-13
90352 Everton FC 918 Manchester U 924 2019-04-21 3 0 3 0 1 8 2018-10-28 L     2026-06-11 10:25:15.949505 2026-06-11 10:25:15.949505     International Results CSV 1 h2h://918:924/2019-04-21
90657 Everton FC 918 Southampton FC 920 2019-07-09 4 1 2 1 5 8 2019-01-19 L     2026-06-11 10:25:16.064236 2026-06-11 10:25:16.064237     International Results CSV 1 h2h://918:920/2019-07-09
90774 Everton FC 918 AFC Bournemouth 923 2019-07-26 4 2 1 1 7 5 2019-01-13 W     2026-06-11 10:25:16.094113 2026-06-11 10:25:16.094113     International Results CSV 1 h2h://918:923/2019-07-26
90994 Everton FC 918 AFC Bournemouth 923 2019-09-15 5 2 2 1 8 8 2019-07-26 W     2026-06-11 10:25:16.172425 2026-06-11 10:25:16.172426     International Results CSV 1 h2h://923:918/2019-09-15
91354 Everton FC 918 Southampton FC 920 2019-11-09 5 1 2 2 6 9 2019-07-09 D     2026-06-11 10:25:16.271013 2026-06-11 10:25:16.271013     International Results CSV 1 h2h://920:918/2019-11-09
91407 Everton FC 918 Norwich City 927 2019-11-23 0 0 0 0 0 0         2026-06-11 10:25:16.314031 2026-06-11 10:25:16.314032     International Results CSV 1 h2h://918:927/2019-11-23
91575 Everton FC 918 Manchester U 924 2019-12-15 4 1 3 0 5 8 2019-04-21 L     2026-06-11 10:25:16.348837 2026-06-11 10:25:16.348838     International Results CSV 1 h2h://924:918/2019-12-15
92026 Everton FC 918 Manchester U 924 2020-03-01 5 1 3 1 6 9 2019-12-15 D     2026-06-11 10:25:16.433171 2026-06-11 10:25:16.433172     International Results CSV 1 h2h://918:924/2020-03-01
92209 Everton FC 918 Norwich City 927 2020-06-24 1 0 1 0 0 2 2019-11-23 W     2026-06-11 10:25:16.466634 2026-06-11 10:25:16.466635     International Results CSV 1 h2h://927:918/2020-06-24
92312 Everton FC 918 West Bromwich 922 2020-09-19 2 0 0 2 1 1 2018-01-20 D     2026-06-11 10:25:16.495351 2026-06-11 10:25:16.495351     International Results CSV 1 h2h://918:922/2020-09-19
92530 Everton FC 918 Southampton FC 920 2020-10-25 6 2 2 2 8 10 2019-11-09 L     2026-06-11 10:25:16.559206 2026-06-11 10:25:16.559206     International Results CSV 1 h2h://920:918/2020-10-25
92610 Everton FC 918 Manchester U 924 2020-11-07 6 1 3 2 7 10 2020-03-01 D     2026-06-11 10:25:16.574925 2026-06-11 10:25:16.574925     International Results CSV 1 h2h://918:924/2020-11-07
92679 Everton FC 918 Fulham FC 926 2020-11-22 2 1 1 0 3 2 2019-04-13 W     2026-06-11 10:25:16.617319 2026-06-11 10:25:16.617319     International Results CSV 1 h2h://926:918/2020-11-22
93254 Everton FC 918 Manchester U 924 2021-02-06 7 1 4 2 8 13 2020-11-07 W     2026-06-11 10:25:16.729825 2026-06-11 10:25:16.729826     International Results CSV 1 h2h://924:918/2021-02-06
93316 Everton FC 918 Fulham FC 926 2021-02-14 3 2 1 0 6 4 2020-11-22 W     2026-06-11 10:25:16.741829 2026-06-11 10:25:16.741829     International Results CSV 1 h2h://918:926/2021-02-14
93429 Everton FC 918 Southampton FC 920 2021-03-01 7 2 3 2 8 12 2020-10-25 L     2026-06-11 10:25:16.764773 2026-06-11 10:25:16.764774     International Results CSV 1 h2h://918:920/2021-03-01
93443 Everton FC 918 West Bromwich 922 2021-03-04 3 1 0 2 6 3 2020-09-19 L     2026-06-11 10:25:16.767586 2026-06-11 10:25:16.767586     International Results CSV 1 h2h://922:918/2021-03-04
94025 Everton FC 918 Southampton FC 920 2021-08-14 8 3 3 2 9 12 2021-03-01 W     2026-06-11 10:25:16.984876 2026-06-11 10:25:16.984876     International Results CSV 1 h2h://918:920/2021-08-14
94286 Everton FC 918 Norwich City 927 2021-09-25 2 1 1 0 1 2 2020-06-24 W     2026-06-11 10:25:17.070837 2026-06-11 10:25:17.070837     International Results CSV 1 h2h://918:927/2021-09-25
94334 Everton FC 918 Manchester U 924 2021-10-02 8 1 4 3 11 16 2021-02-06 D     2026-06-11 10:25:17.473604 2026-06-11 10:25:17.473605     International Results CSV 1 h2h://924:918/2021-10-02
94673 Everton FC 918 Brentford FC 928 2021-11-28 0 0 0 0 0 0         2026-06-11 10:25:17.591815 2026-06-11 10:25:17.591815     International Results CSV 1 h2h://928:918/2021-11-28
94971 Everton FC 918 Norwich City 927 2022-01-15 3 2 1 0 3 2 2021-09-25 L     2026-06-11 10:25:17.664052 2026-06-11 10:25:17.664052     International Results CSV 1 h2h://927:918/2022-01-15
95174 Everton FC 918 Southampton FC 920 2022-02-19 9 4 3 2 12 13 2021-08-14 L     2026-06-11 10:25:17.717265 2026-06-11 10:25:17.717265     International Results CSV 1 h2h://920:918/2022-02-19
95467 Everton FC 918 Manchester U 924 2022-04-09 9 1 4 4 12 17 2021-10-02 D     2026-06-11 10:25:17.802066 2026-06-11 10:25:17.802066     International Results CSV 1 h2h://918:924/2022-04-09
95771 Everton FC 918 Brentford FC 928 2022-05-15 1 0 1 0 0 1 2021-11-28 L     2026-06-11 10:25:17.860504 2026-06-11 10:25:17.860504     International Results CSV 1 h2h://918:928/2022-05-15
95968 Everton FC 918 Brentford FC 928 2022-08-27 2 0 2 0 2 4 2022-05-15 W     2026-06-11 10:25:17.957621 2026-06-11 10:25:17.957622     International Results CSV 1 h2h://928:918/2022-08-27
96182 Everton FC 918 Southampton FC 920 2022-10-01 10 4 4 2 12 15 2022-02-19 W     2026-06-11 10:25:18.024750 2026-06-11 10:25:18.024750     International Results CSV 1 h2h://920:918/2022-10-01
96254 Everton FC 918 Manchester U 924 2022-10-09 10 2 4 4 13 17 2022-04-09 W     2026-06-11 10:25:18.038544 2026-06-11 10:25:18.038544     International Results CSV 1 h2h://918:924/2022-10-09
96398 Everton FC 918 Fulham FC 926 2022-10-29 4 2 2 0 6 6 2021-02-14 W     2026-06-11 10:25:18.066935 2026-06-11 10:25:18.066935     International Results CSV 1 h2h://926:918/2022-10-29
96520 Everton FC 918 AFC Bournemouth 923 2022-11-12 6 2 3 1 9 11 2019-09-15 W     2026-06-11 10:25:18.092808 2026-06-11 10:25:18.092808     International Results CSV 1 h2h://923:918/2022-11-12
96672 Everton FC 918 Southampton FC 920 2023-01-14 11 5 4 2 14 16 2022-10-01 W     2026-06-11 10:25:18.158837 2026-06-11 10:25:18.158837     International Results CSV 1 h2h://918:920/2023-01-14
97047 Everton FC 918 Brentford FC 928 2023-03-11 3 0 2 1 3 5 2022-08-27 D     2026-06-11 10:25:18.232481 2026-06-11 10:25:18.232481     International Results CSV 1 h2h://918:928/2023-03-11
97199 Everton FC 918 Manchester U 924 2023-04-08 11 2 5 4 14 19 2022-10-09 W     2026-06-11 10:25:18.295854 2026-06-11 10:25:18.295854     International Results CSV 1 h2h://924:918/2023-04-08
97250 Everton FC 918 Fulham FC 926 2023-04-15 5 2 2 1 6 6 2022-10-29 D     2026-06-11 10:25:18.305489 2026-06-11 10:25:18.305489     International Results CSV 1 h2h://918:926/2023-04-15
97619 Everton FC 918 AFC Bournemouth 923 2023-05-28 7 2 4 1 9 14 2022-11-12 L     2026-06-11 10:25:18.375970 2026-06-11 10:25:18.375970     International Results CSV 1 h2h://918:923/2023-05-28
97667 Everton FC 918 Fulham FC 926 2023-08-12 6 2 3 1 7 9 2023-04-15 L     2026-06-11 10:25:18.434458 2026-06-11 10:25:18.434458     International Results CSV 1 h2h://918:926/2023-08-12
97887 Everton FC 918 Brentford FC 928 2023-09-23 4 1 2 1 4 5 2023-03-11 L     2026-06-11 10:25:18.509813 2026-06-11 10:25:18.509813     International Results CSV 1 h2h://928:918/2023-09-23
98003 Everton FC 918 AFC Bournemouth 923 2023-10-07 8 3 4 1 10 14 2023-05-28 W     2026-06-11 10:25:18.532107 2026-06-11 10:25:18.532108     International Results CSV 1 h2h://918:923/2023-10-07
98262 Everton FC 918 Manchester U 924 2023-11-26 12 2 6 4 14 21 2023-04-08 L     2026-06-11 10:25:18.651380 2026-06-11 10:25:18.651381     International Results CSV 1 h2h://918:924/2023-11-26
98641 Everton FC 918 Fulham FC 926 2024-01-30 7 2 4 1 7 10 2023-08-12 W     2026-06-11 10:25:18.749947 2026-06-11 10:25:18.749947     International Results CSV 1 h2h://926:918/2024-01-30
98903 Everton FC 918 Manchester U 924 2024-03-09 13 2 7 4 14 24 2023-11-26 W     2026-06-11 10:25:18.803820 2026-06-11 10:25:18.803820     International Results CSV 1 h2h://924:918/2024-03-09
98992 Everton FC 918 AFC Bournemouth 923 2024-03-30 9 4 4 1 13 14 2023-10-07 L     2026-06-11 10:25:18.851050 2026-06-11 10:25:18.851050     International Results CSV 1 h2h://923:918/2024-03-30
99193 Everton FC 918 Brentford FC 928 2024-04-27 5 2 2 1 7 6 2023-09-23 W     2026-06-11 10:25:18.891248 2026-06-11 10:25:18.891248     International Results CSV 1 h2h://918:928/2024-04-27
99499 Everton FC 918 AFC Bournemouth 923 2024-08-31 10 4 5 1 14 16 2024-03-30 L     2026-06-11 10:25:19.412218 2026-06-11 10:25:19.412218     International Results CSV 1 h2h://918:923/2024-08-31
99747 Everton FC 918 Fulham FC 926 2024-10-26 8 2 4 2 7 10 2024-01-30 D     2026-06-11 10:25:19.526201 2026-06-11 10:25:19.526202     International Results CSV 1 h2h://918:926/2024-10-26
99794 Everton FC 918 Southampton FC 920 2024-11-02 12 5 5 2 15 18 2023-01-14 W     2026-06-11 10:25:19.534909 2026-06-11 10:25:19.534909     International Results CSV 1 h2h://920:918/2024-11-02
99869 Everton FC 918 Brentford FC 928 2024-11-23 6 3 2 1 8 6 2024-04-27 W     2026-06-11 10:25:19.583155 2026-06-11 10:25:19.583155     International Results CSV 1 h2h://918:928/2024-11-23
99920 Everton FC 918 Manchester U 924 2024-12-01 14 2 8 4 14 26 2024-03-09 W     2026-06-11 10:25:19.592515 2026-06-11 10:25:19.592516     International Results CSV 1 h2h://924:918/2024-12-01
100095 Everton FC 918 AFC Bournemouth 923 2025-01-04 11 4 6 1 16 19 2024-08-31 W     2026-06-11 10:25:19.634609 2026-06-11 10:25:19.634609     International Results CSV 1 h2h://923:918/2025-01-04
100356 Everton FC 918 Manchester U 924 2025-02-22 15 2 9 4 14 30 2024-12-01 L     2026-06-11 10:25:19.688441 2026-06-11 10:25:19.688442     International Results CSV 1 h2h://918:924/2025-02-22
100390 Everton FC 918 Brentford FC 928 2025-02-26 7 3 2 2 8 6 2024-11-23 D     2026-06-11 10:25:19.694895 2026-06-11 10:25:19.694895     International Results CSV 1 h2h://928:918/2025-02-26
100744 Everton FC 918 Fulham FC 926 2025-05-10 9 2 4 3 8 11 2024-10-26 D     2026-06-11 10:25:19.795318 2026-06-11 10:25:19.795318     International Results CSV 1 h2h://926:918/2025-05-10
100797 Everton FC 918 Southampton FC 920 2025-05-18 13 5 6 2 15 19 2024-11-02 L     2026-06-11 10:25:19.805972 2026-06-11 10:25:19.805973     International Results CSV 1 h2h://918:920/2025-05-18

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