home / football

h2h_record

106 rows where team_a_id = 915

✎ 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
86952 Chelsea FC 915 Burnley FC 916 2017-08-12 0 0 0 0 0 0         2026-06-11 10:25:14.629883 2026-06-11 10:25:14.629883     International Results CSV 1 h2h://915:916/2017-08-12
87044 Chelsea FC 915 Everton FC 918 2017-08-27 0 0 0 0 0 0         2026-06-11 10:25:14.648712 2026-06-11 10:25:14.648712     International Results CSV 1 h2h://915:918/2017-08-27
87200 Chelsea FC 915 Stoke City 919 2017-09-23 0 0 0 0 0 0         2026-06-11 10:25:14.703013 2026-06-11 10:25:14.703013     International Results CSV 1 h2h://919:915/2017-09-23
87406 Chelsea FC 915 AFC Bournemouth 923 2017-10-28 0 0 0 0 0 0         2026-06-11 10:25:14.761404 2026-06-11 10:25:14.761404     International Results CSV 1 h2h://923:915/2017-10-28
87473 Chelsea FC 915 Manchester U 924 2017-11-05 0 0 0 0 0 0         2026-06-11 10:25:14.773656 2026-06-11 10:25:14.773656     International Results CSV 1 h2h://915:924/2017-11-05
87504 Chelsea FC 915 West Bromwich 922 2017-11-18 0 0 0 0 0 0         2026-06-11 10:25:14.797224 2026-06-11 10:25:14.797224     International Results CSV 1 h2h://922:915/2017-11-18
87604 Chelsea FC 915 Swansea City 921 2017-11-29 0 0 0 0 0 0         2026-06-11 10:25:14.816524 2026-06-11 10:25:14.816525     International Results CSV 1 h2h://915:921/2017-11-29
87717 Chelsea FC 915 Huddersfield Town 917 2017-12-12 0 0 0 0 0 0         2026-06-11 10:25:14.845307 2026-06-11 10:25:14.845307     International Results CSV 1 h2h://917:915/2017-12-12
87747 Chelsea FC 915 Southampton FC 920 2017-12-16 0 0 0 0 0 0         2026-06-11 10:25:14.852303 2026-06-11 10:25:14.852304     International Results CSV 1 h2h://915:920/2017-12-16
87793 Chelsea FC 915 Everton FC 918 2017-12-23 1 1 0 0 2 0 2017-08-27 L     2026-06-11 10:25:14.862080 2026-06-11 10:25:14.862080     International Results CSV 1 h2h://918:915/2017-12-23
87825 Chelsea FC 915 Stoke City 919 2017-12-30 1 1 0 0 4 0 2017-09-23 W     2026-06-11 10:25:14.869638 2026-06-11 10:25:14.869638     International Results CSV 1 h2h://915:919/2017-12-30
88015 Chelsea FC 915 AFC Bournemouth 923 2018-01-31 1 1 0 0 1 0 2017-10-28 W     2026-06-11 10:25:14.907195 2026-06-11 10:25:14.907195     International Results CSV 1 h2h://915:923/2018-01-31
88117 Chelsea FC 915 West Bromwich 922 2018-02-12 1 1 0 0 4 0 2017-11-18 W     2026-06-11 10:25:14.927104 2026-06-11 10:25:14.927104     International Results CSV 1 h2h://915:922/2018-02-12
88191 Chelsea FC 915 Manchester U 924 2018-02-25 1 1 0 0 1 0 2017-11-05 L     2026-06-11 10:25:14.940768 2026-06-11 10:25:14.940768     International Results CSV 1 h2h://924:915/2018-02-25
88466 Chelsea FC 915 Southampton FC 920 2018-04-14 1 1 0 0 1 0 2017-12-16 L     2026-06-11 10:25:15.017306 2026-06-11 10:25:15.017307     International Results CSV 1 h2h://920:915/2018-04-14
88524 Chelsea FC 915 Burnley FC 916 2018-04-19 1 0 1 0 2 3 2017-08-12 W     2026-06-11 10:25:15.028520 2026-06-11 10:25:15.028521     International Results CSV 1 h2h://916:915/2018-04-19
88599 Chelsea FC 915 Swansea City 921 2018-04-28 1 1 0 0 1 0 2017-11-29 L     2026-06-11 10:25:15.042708 2026-06-11 10:25:15.042708     International Results CSV 1 h2h://921:915/2018-04-28
88686 Chelsea FC 915 Huddersfield Town 917 2018-05-09 1 1 0 0 3 1 2017-12-12 W     2026-06-11 10:25:15.059983 2026-06-11 10:25:15.059983     International Results CSV 1 h2h://915:917/2018-05-09
88770 Chelsea FC 915 Huddersfield Town 917 2018-08-11 2 1 0 1 4 2 2018-05-09 D     2026-06-11 10:25:15.119774 2026-06-11 10:25:15.119774     International Results CSV 1 h2h://917:915/2018-08-11
88880 Chelsea FC 915 AFC Bournemouth 923 2018-09-01 2 1 1 0 1 3 2018-01-31 L     2026-06-11 10:25:15.142444 2026-06-11 10:25:15.142444     International Results CSV 1 h2h://915:923/2018-09-01
88924 Chelsea FC 915 Cardiff City 925 2018-09-15 0 0 0 0 0 0         2026-06-11 10:25:15.178206 2026-06-11 10:25:15.178207     International Results CSV 1 h2h://915:925/2018-09-15
89134 Chelsea FC 915 Southampton FC 920 2018-10-07 2 2 0 0 4 2 2018-04-14 L     2026-06-11 10:25:15.217694 2026-06-11 10:25:15.217695     International Results CSV 1 h2h://920:915/2018-10-07
89159 Chelsea FC 915 Manchester U 924 2018-10-20 2 1 1 0 2 2 2018-02-25 L     2026-06-11 10:25:15.251681 2026-06-11 10:25:15.251682     International Results CSV 1 h2h://915:924/2018-10-20
89231 Chelsea FC 915 Burnley FC 916 2018-10-28 2 1 1 0 4 4 2018-04-19 L     2026-06-11 10:25:15.265223 2026-06-11 10:25:15.265224     International Results CSV 1 h2h://916:915/2018-10-28
89332 Chelsea FC 915 Everton FC 918 2018-11-11 2 1 0 1 2 0 2017-12-23 D     2026-06-11 10:25:15.686672 2026-06-11 10:25:15.686672     International Results CSV 1 h2h://915:918/2018-11-11
89428 Chelsea FC 915 Fulham FC 926 2018-12-02 0 0 0 0 0 0         2026-06-11 10:25:15.733995 2026-06-11 10:25:15.733996     International Results CSV 1 h2h://915:926/2018-12-02
89654 Chelsea FC 915 Southampton FC 920 2019-01-02 3 3 0 0 7 2 2018-10-07 W     2026-06-11 10:25:15.781476 2026-06-11 10:25:15.781476     International Results CSV 1 h2h://915:920/2019-01-02
89803 Chelsea FC 915 AFC Bournemouth 923 2019-01-30 3 2 1 0 3 3 2018-09-01 L     2026-06-11 10:25:15.819341 2026-06-11 10:25:15.819341     International Results CSV 1 h2h://923:915/2019-01-30
89817 Chelsea FC 915 Huddersfield Town 917 2019-02-02 3 2 0 1 7 2 2018-08-11 W     2026-06-11 10:25:15.822306 2026-06-11 10:25:15.822306     International Results CSV 1 h2h://915:917/2019-02-02
90035 Chelsea FC 915 Fulham FC 926 2019-03-03 1 1 0 0 2 0 2018-12-02 L     2026-06-11 10:25:15.864000 2026-06-11 10:25:15.864000     International Results CSV 1 h2h://926:915/2019-03-03
90129 Chelsea FC 915 Everton FC 918 2019-03-17 3 1 0 2 2 0 2018-11-11 D     2026-06-11 10:25:15.882821 2026-06-11 10:25:15.882821     International Results CSV 1 h2h://918:915/2019-03-17
90174 Chelsea FC 915 Cardiff City 925 2019-03-31 1 1 0 0 4 1 2018-09-15 L     2026-06-11 10:25:15.916221 2026-06-11 10:25:15.916221     International Results CSV 1 h2h://925:915/2019-03-31
90362 Chelsea FC 915 Burnley FC 916 2019-04-22 3 2 1 0 8 4 2018-10-28 W     2026-06-11 10:25:15.951388 2026-06-11 10:25:15.951388     International Results CSV 1 h2h://915:916/2019-04-22
90410 Chelsea FC 915 Manchester U 924 2019-04-28 3 1 1 1 4 4 2018-10-20 D     2026-06-11 10:25:15.960337 2026-06-11 10:25:15.960337     International Results CSV 1 h2h://924:915/2019-04-28
90696 Chelsea FC 915 Norwich City 927 2019-07-14 0 0 0 0 0 0         2026-06-11 10:25:16.074529 2026-06-11 10:25:16.074529     International Results CSV 1 h2h://915:927/2019-07-14
90823 Chelsea FC 915 Manchester U 924 2019-08-11 4 1 1 2 5 5 2019-04-28 D     2026-06-11 10:25:16.106846 2026-06-11 10:25:16.106846     International Results CSV 1 h2h://924:915/2019-08-11
90873 Chelsea FC 915 Norwich City 927 2019-08-24 1 1 0 0 1 0 2019-07-14 L     2026-06-11 10:25:16.116414 2026-06-11 10:25:16.116415     International Results CSV 1 h2h://927:915/2019-08-24
91155 Chelsea FC 915 Southampton FC 920 2019-10-06 4 3 0 1 7 2 2019-01-02 D     2026-06-11 10:25:16.203630 2026-06-11 10:25:16.203631     International Results CSV 1 h2h://920:915/2019-10-06
91243 Chelsea FC 915 Burnley FC 916 2019-10-26 4 2 1 1 10 6 2019-04-22 D     2026-06-11 10:25:16.249623 2026-06-11 10:25:16.249623     International Results CSV 1 h2h://916:915/2019-10-26
91509 Chelsea FC 915 Everton FC 918 2019-12-07 4 1 1 2 2 2 2019-03-17 W     2026-06-11 10:25:16.335414 2026-06-11 10:25:16.335414     International Results CSV 1 h2h://918:915/2019-12-07
91556 Chelsea FC 915 AFC Bournemouth 923 2019-12-14 4 2 2 0 3 7 2019-01-30 L     2026-06-11 10:25:16.345181 2026-06-11 10:25:16.345181     International Results CSV 1 h2h://915:923/2019-12-14
91651 Chelsea FC 915 Southampton FC 920 2019-12-26 5 4 0 1 11 3 2019-10-06 W     2026-06-11 10:25:16.363332 2026-06-11 10:25:16.363332     International Results CSV 1 h2h://915:920/2019-12-26
91725 Chelsea FC 915 Burnley FC 916 2020-01-11 5 3 1 1 14 8 2019-10-26 W     2026-06-11 10:25:16.377597 2026-06-11 10:25:16.377597     International Results CSV 1 h2h://915:916/2020-01-11
91969 Chelsea FC 915 Manchester U 924 2020-02-17 5 1 2 2 5 9 2019-08-11 L     2026-06-11 10:25:16.422832 2026-06-11 10:25:16.422833     International Results CSV 1 h2h://915:924/2020-02-17
92011 Chelsea FC 915 AFC Bournemouth 923 2020-02-29 5 2 3 0 3 8 2019-12-14 W     2026-06-11 10:25:16.430464 2026-06-11 10:25:16.430464     International Results CSV 1 h2h://923:915/2020-02-29
92056 Chelsea FC 915 Everton FC 918 2020-03-08 5 1 2 2 3 5 2019-12-07 L     2026-06-11 10:25:16.438636 2026-06-11 10:25:16.438636     International Results CSV 1 h2h://915:918/2020-03-08
92354 Chelsea FC 915 West Bromwich 922 2020-09-26 2 2 0 0 7 0 2018-02-12 L     2026-06-11 10:25:16.503036 2026-06-11 10:25:16.503037     International Results CSV 1 h2h://922:915/2020-09-26
92464 Chelsea FC 915 Southampton FC 920 2020-10-17 6 4 1 1 11 5 2019-12-26 L     2026-06-11 10:25:16.546528 2026-06-11 10:25:16.546529     International Results CSV 1 h2h://915:920/2020-10-17
92516 Chelsea FC 915 Manchester U 924 2020-10-24 6 1 3 2 5 11 2020-02-17 W     2026-06-11 10:25:16.556497 2026-06-11 10:25:16.556497     International Results CSV 1 h2h://924:915/2020-10-24
92561 Chelsea FC 915 Burnley FC 916 2020-10-31 6 4 1 1 17 8 2020-01-11 L     2026-06-11 10:25:16.565168 2026-06-11 10:25:16.565168     International Results CSV 1 h2h://916:915/2020-10-31
92807 Chelsea FC 915 Everton FC 918 2020-12-12 6 2 2 2 7 5 2020-03-08 L     2026-06-11 10:25:16.642260 2026-06-11 10:25:16.642261     International Results CSV 1 h2h://918:915/2020-12-12
93087 Chelsea FC 915 Fulham FC 926 2021-01-16 2 2 0 0 4 1 2019-03-03 L     2026-06-11 10:25:16.695938 2026-06-11 10:25:16.695939     International Results CSV 1 h2h://926:915/2021-01-16
93211 Chelsea FC 915 Burnley FC 916 2021-01-31 7 5 1 1 20 8 2020-10-31 W     2026-06-11 10:25:16.721195 2026-06-11 10:25:16.721195     International Results CSV 1 h2h://915:916/2021-01-31
93349 Chelsea FC 915 Southampton FC 920 2021-02-20 7 4 1 2 14 8 2020-10-17 D     2026-06-11 10:25:16.749024 2026-06-11 10:25:16.749024     International Results CSV 1 h2h://920:915/2021-02-20
93414 Chelsea FC 915 Manchester U 924 2021-02-28 7 1 3 3 5 11 2020-10-24 D     2026-06-11 10:25:16.761864 2026-06-11 10:25:16.761864     International Results CSV 1 h2h://915:924/2021-02-28
93490 Chelsea FC 915 Everton FC 918 2021-03-08 7 2 3 2 7 6 2020-12-12 L     2026-06-11 10:25:16.776679 2026-06-11 10:25:16.776679     International Results CSV 1 h2h://915:918/2021-03-08
93603 Chelsea FC 915 West Bromwich 922 2021-04-03 3 2 0 1 10 3 2020-09-26 D     2026-06-11 10:25:16.833466 2026-06-11 10:25:16.833466     International Results CSV 1 h2h://915:922/2021-04-03
93820 Chelsea FC 915 Fulham FC 926 2021-05-01 3 3 0 0 5 1 2021-01-16 W     2026-06-11 10:25:16.875655 2026-06-11 10:25:16.875656     International Results CSV 1 h2h://915:926/2021-05-01
94336 Chelsea FC 915 Southampton FC 920 2021-10-02 8 4 1 3 15 9 2021-02-20 D     2026-06-11 10:25:17.473968 2026-06-11 10:25:17.473968     International Results CSV 1 h2h://915:920/2021-10-02
94387 Chelsea FC 915 Brentford FC 928 2021-10-16 0 0 0 0 0 0         2026-06-11 10:25:17.512220 2026-06-11 10:25:17.512220     International Results CSV 1 h2h://928:915/2021-10-16
94432 Chelsea FC 915 Norwich City 927 2021-10-23 2 2 0 0 4 2 2019-08-24 W     2026-06-11 10:25:17.520478 2026-06-11 10:25:17.520478     International Results CSV 1 h2h://915:927/2021-10-23
94552 Chelsea FC 915 Burnley FC 916 2021-11-06 8 6 1 1 22 8 2021-01-31 W     2026-06-11 10:25:17.542976 2026-06-11 10:25:17.542976     International Results CSV 1 h2h://915:916/2021-11-06
94675 Chelsea FC 915 Manchester U 924 2021-11-28 8 1 3 4 5 11 2021-02-28 D     2026-06-11 10:25:17.592184 2026-06-11 10:25:17.592184     International Results CSV 1 h2h://915:924/2021-11-28
94830 Chelsea FC 915 Everton FC 918 2021-12-16 8 3 3 2 9 6 2021-03-08 W     2026-06-11 10:25:17.629917 2026-06-11 10:25:17.629917     International Results CSV 1 h2h://915:918/2021-12-16
95272 Chelsea FC 915 Burnley FC 916 2022-03-05 9 6 1 2 23 9 2021-11-06 D     2026-06-11 10:25:17.735210 2026-06-11 10:25:17.735210     International Results CSV 1 h2h://916:915/2022-03-05
95315 Chelsea FC 915 Norwich City 927 2022-03-10 3 3 0 0 11 2 2021-10-23 L     2026-06-11 10:25:17.743142 2026-06-11 10:25:17.743142     International Results CSV 1 h2h://927:915/2022-03-10
95416 Chelsea FC 915 Brentford FC 928 2022-04-02 1 1 0 0 1 0 2021-10-16 W     2026-06-11 10:25:17.792636 2026-06-11 10:25:17.792636     International Results CSV 1 h2h://915:928/2022-04-02
95469 Chelsea FC 915 Southampton FC 920 2022-04-09 9 5 1 3 18 10 2021-10-02 L     2026-06-11 10:25:17.802433 2026-06-11 10:25:17.802433     International Results CSV 1 h2h://920:915/2022-04-09
95625 Chelsea FC 915 Manchester U 924 2022-04-28 9 1 3 5 6 12 2021-11-28 D     2026-06-11 10:25:17.832256 2026-06-11 10:25:17.832257     International Results CSV 1 h2h://924:915/2022-04-28
95658 Chelsea FC 915 Everton FC 918 2022-05-01 9 3 3 3 10 7 2021-12-16 D     2026-06-11 10:25:17.838524 2026-06-11 10:25:17.838524     International Results CSV 1 h2h://918:915/2022-05-01
95842 Chelsea FC 915 Everton FC 918 2022-08-06 10 3 4 3 10 8 2022-05-01 W     2026-06-11 10:25:17.934208 2026-06-11 10:25:17.934208     International Results CSV 1 h2h://918:915/2022-08-06
96010 Chelsea FC 915 Southampton FC 920 2022-08-30 10 6 1 3 24 10 2022-04-09 L     2026-06-11 10:25:17.965302 2026-06-11 10:25:17.965302     International Results CSV 1 h2h://920:915/2022-08-30
96325 Chelsea FC 915 Brentford FC 928 2022-10-19 2 1 1 0 2 4 2022-04-02 W     2026-06-11 10:25:18.052181 2026-06-11 10:25:18.052181     International Results CSV 1 h2h://928:915/2022-10-19
96346 Chelsea FC 915 Manchester U 924 2022-10-22 10 1 3 6 7 13 2022-04-28 D     2026-06-11 10:25:18.056396 2026-06-11 10:25:18.056396     International Results CSV 1 h2h://915:924/2022-10-22
96580 Chelsea FC 915 AFC Bournemouth 923 2022-12-27 6 2 3 1 5 10 2020-02-29 D     2026-06-11 10:25:18.134999 2026-06-11 10:25:18.134999     International Results CSV 1 h2h://915:923/2022-12-27
96663 Chelsea FC 915 Fulham FC 926 2023-01-12 4 4 0 0 7 1 2021-05-01 L     2026-06-11 10:25:18.156487 2026-06-11 10:25:18.156488     International Results CSV 1 h2h://926:915/2023-01-12
96793 Chelsea FC 915 Fulham FC 926 2023-02-03 5 4 1 0 8 3 2023-01-12 L     2026-06-11 10:25:18.183034 2026-06-11 10:25:18.183034     International Results CSV 1 h2h://915:926/2023-02-03
96902 Chelsea FC 915 Southampton FC 920 2023-02-18 11 6 2 3 25 12 2022-08-30 L     2026-06-11 10:25:18.203704 2026-06-11 10:25:18.203704     International Results CSV 1 h2h://915:920/2023-02-18
97103 Chelsea FC 915 Everton FC 918 2023-03-18 11 4 4 3 11 8 2022-08-06 W     2026-06-11 10:25:18.243671 2026-06-11 10:25:18.243672     International Results CSV 1 h2h://915:918/2023-03-18
97364 Chelsea FC 915 Brentford FC 928 2023-04-26 3 1 1 1 2 4 2022-10-19 D     2026-06-11 10:25:18.327451 2026-06-11 10:25:18.327451     International Results CSV 1 h2h://915:928/2023-04-26
97454 Chelsea FC 915 AFC Bournemouth 923 2023-05-06 7 3 3 1 7 10 2022-12-27 L     2026-06-11 10:25:18.344522 2026-06-11 10:25:18.344522     International Results CSV 1 h2h://923:915/2023-05-06
97596 Chelsea FC 915 Manchester U 924 2023-05-25 11 1 3 7 8 14 2022-10-22 D     2026-06-11 10:25:18.371473 2026-06-11 10:25:18.371473     International Results CSV 1 h2h://924:915/2023-05-25
97860 Chelsea FC 915 AFC Bournemouth 923 2023-09-17 8 4 3 1 10 11 2023-05-06 L     2026-06-11 10:25:18.504656 2026-06-11 10:25:18.504656     International Results CSV 1 h2h://923:915/2023-09-17
97989 Chelsea FC 915 Fulham FC 926 2023-10-02 6 4 1 1 8 3 2023-02-03 D     2026-06-11 10:25:18.529406 2026-06-11 10:25:18.529406     International Results CSV 1 h2h://926:915/2023-10-02
98002 Chelsea FC 915 Burnley FC 916 2023-10-07 10 7 1 2 27 9 2022-03-05 L     2026-06-11 10:25:18.531912 2026-06-11 10:25:18.531912     International Results CSV 1 h2h://916:915/2023-10-07
98096 Chelsea FC 915 Brentford FC 928 2023-10-28 4 1 2 1 2 6 2023-04-26 L     2026-06-11 10:25:18.582589 2026-06-11 10:25:18.582589     International Results CSV 1 h2h://915:928/2023-10-28
98337 Chelsea FC 915 Manchester U 924 2023-12-06 12 1 4 7 9 18 2023-05-25 W     2026-06-11 10:25:18.667939 2026-06-11 10:25:18.667939     International Results CSV 1 h2h://924:915/2023-12-06
98370 Chelsea FC 915 Everton FC 918 2023-12-10 12 4 4 4 13 10 2023-03-18 D     2026-06-11 10:25:18.674268 2026-06-11 10:25:18.674268     International Results CSV 1 h2h://918:915/2023-12-10
98538 Chelsea FC 915 Fulham FC 926 2024-01-13 7 5 1 1 10 3 2023-10-02 W     2026-06-11 10:25:18.714919 2026-06-11 10:25:18.714919     International Results CSV 1 h2h://915:926/2024-01-13
98855 Chelsea FC 915 Brentford FC 928 2024-03-02 5 1 3 1 2 8 2023-10-28 W     2026-06-11 10:25:18.794436 2026-06-11 10:25:18.794436     International Results CSV 1 h2h://928:915/2024-03-02
98993 Chelsea FC 915 Burnley FC 916 2024-03-30 11 8 1 2 31 10 2023-10-07 W     2026-06-11 10:25:18.851244 2026-06-11 10:25:18.851245     International Results CSV 1 h2h://915:916/2024-03-30
99044 Chelsea FC 915 Manchester U 924 2024-04-04 13 1 5 7 10 20 2023-12-06 L     2026-06-11 10:25:18.860972 2026-06-11 10:25:18.860972     International Results CSV 1 h2h://915:924/2024-04-04
99124 Chelsea FC 915 Everton FC 918 2024-04-15 13 4 5 4 13 12 2023-12-10 L     2026-06-11 10:25:18.876973 2026-06-11 10:25:18.876974     International Results CSV 1 h2h://915:918/2024-04-15
99367 Chelsea FC 915 AFC Bournemouth 923 2024-05-19 9 4 3 2 10 11 2023-09-17 D     2026-06-11 10:25:19.334436 2026-06-11 10:25:19.334436     International Results CSV 1 h2h://915:923/2024-05-19
99542 Chelsea FC 915 AFC Bournemouth 923 2024-09-14 10 5 3 2 12 12 2024-05-19 L     2026-06-11 10:25:19.454756 2026-06-11 10:25:19.454757     International Results CSV 1 h2h://923:915/2024-09-14
99804 Chelsea FC 915 Manchester U 924 2024-11-03 14 2 5 7 14 23 2024-04-04 L     2026-06-11 10:25:19.536807 2026-06-11 10:25:19.536807     International Results CSV 1 h2h://924:915/2024-11-03
99939 Chelsea FC 915 Southampton FC 920 2024-12-04 12 6 3 3 25 13 2023-02-18 W     2026-06-11 10:25:19.596110 2026-06-11 10:25:19.596111     International Results CSV 1 h2h://920:915/2024-12-04
100007 Chelsea FC 915 Brentford FC 928 2024-12-15 6 1 3 2 4 10 2024-03-02 D     2026-06-11 10:25:19.612174 2026-06-11 10:25:19.612174     International Results CSV 1 h2h://915:928/2024-12-15
100046 Chelsea FC 915 Everton FC 918 2024-12-22 14 5 5 4 19 12 2024-04-15 L     2026-06-11 10:25:19.622250 2026-06-11 10:25:19.622250     International Results CSV 1 h2h://918:915/2024-12-22
100064 Chelsea FC 915 Fulham FC 926 2024-12-26 8 6 1 1 11 3 2024-01-13 W     2026-06-11 10:25:19.626472 2026-06-11 10:25:19.626472     International Results CSV 1 h2h://915:926/2024-12-26

Next page

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