home / football

h2h_record

212 rows where team_b_id = 951

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_a_id, total_matches, wins_a, wins_b, draws, 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
87000 Bologna 783 Torino FC 951 2017-08-20 0 0 0 0 0 0         2026-06-11 10:25:14.639351 2026-06-11 10:25:14.639351     International Results CSV 1 h2h://783:951/2017-08-20
87052 Sassuolo 804 Torino FC 951 2017-08-27 0 0 0 0 0 0         2026-06-11 10:25:14.650188 2026-06-11 10:25:14.650188     International Results CSV 1 h2h://951:804/2017-08-27
87151 Sampdoria 803 Torino FC 951 2017-09-17 0 0 0 0 0 0         2026-06-11 10:25:14.692986 2026-06-11 10:25:14.692986     International Results CSV 1 h2h://951:803/2017-09-17
87178 Udinese 798 Torino FC 951 2017-09-20 0 0 0 0 0 0         2026-06-11 10:25:14.699013 2026-06-11 10:25:14.699013     International Results CSV 1 h2h://798:951/2017-09-20
87209 Juventus 341 Torino FC 951 2017-09-23 0 0 0 0 0 0         2026-06-11 10:25:14.704649 2026-06-11 10:25:14.704649     International Results CSV 1 h2h://341:951/2017-09-23
87278 Hellas 949 Torino FC 951 2017-10-01 0 0 0 0 0 0         2026-06-11 10:25:14.717055 2026-06-11 10:25:14.717056     International Results CSV 1 h2h://951:949/2017-10-01
87374 Roma 796 Torino FC 951 2017-10-22 0 0 0 0 0 0         2026-06-11 10:25:14.755309 2026-06-11 10:25:14.755309     International Results CSV 1 h2h://951:796/2017-10-22
87388 Fiorentina 787 Torino FC 951 2017-10-25 0 0 0 0 0 0         2026-06-11 10:25:14.757975 2026-06-11 10:25:14.757975     International Results CSV 1 h2h://787:951/2017-10-25
87434 Cagliari 784 Torino FC 951 2017-10-29 0 0 0 0 0 0         2026-06-11 10:25:14.766559 2026-06-11 10:25:14.766559     International Results CSV 1 h2h://951:784/2017-10-29
87579 Milan 792 Torino FC 951 2017-11-26 0 0 0 0 0 0         2026-06-11 10:25:14.811769 2026-06-11 10:25:14.811769     International Results CSV 1 h2h://792:951/2017-11-26
87631 Atalanta 782 Torino FC 951 2017-12-02 0 0 0 0 0 0         2026-06-11 10:25:14.822529 2026-06-11 10:25:14.822529     International Results CSV 1 h2h://951:782/2017-12-02
87755 Napoli 794 Torino FC 951 2017-12-16 0 0 0 0 0 0         2026-06-11 10:25:14.853755 2026-06-11 10:25:14.853755     International Results CSV 1 h2h://951:794/2017-12-16
87837 Genoa 788 Torino FC 951 2017-12-30 0 0 0 0 0 0         2026-06-11 10:25:14.871850 2026-06-11 10:25:14.871850     International Results CSV 1 h2h://951:788/2017-12-30
87859 Bologna 783 Torino FC 951 2018-01-06 1 0 0 1 1 1 2017-08-20 D     2026-06-11 10:25:14.876408 2026-06-11 10:25:14.876408     International Results CSV 1 h2h://951:783/2018-01-06
87958 Sassuolo 804 Torino FC 951 2018-01-21 1 0 1 0 0 3 2017-08-27 L     2026-06-11 10:25:14.895558 2026-06-11 10:25:14.895559     International Results CSV 1 h2h://804:951/2018-01-21
88041 Sampdoria 803 Torino FC 951 2018-02-03 1 0 0 1 2 2 2017-09-17 D     2026-06-11 10:25:14.912226 2026-06-11 10:25:14.912226     International Results CSV 1 h2h://803:951/2018-02-03
88113 Udinese 798 Torino FC 951 2018-02-11 1 0 1 0 2 3 2017-09-20 W     2026-06-11 10:25:14.926373 2026-06-11 10:25:14.926374     International Results CSV 1 h2h://951:798/2018-02-11
88147 Juventus 341 Torino FC 951 2018-02-18 1 1 0 0 4 0 2017-09-23 L     2026-06-11 10:25:14.932622 2026-06-11 10:25:14.932622     International Results CSV 1 h2h://951:341/2018-02-18
88198 Hellas 949 Torino FC 951 2018-02-25 1 0 0 1 2 2 2017-10-01 D     2026-06-11 10:25:14.942056 2026-06-11 10:25:14.942056     International Results CSV 1 h2h://949:951/2018-02-25
88262 Roma 796 Torino FC 951 2018-03-09 1 1 0 0 1 0 2017-10-22 W     2026-06-11 10:25:14.954268 2026-06-11 10:25:14.954268     International Results CSV 1 h2h://796:951/2018-03-09
88348 Fiorentina 787 Torino FC 951 2018-03-18 1 1 0 0 3 0 2017-10-25 L     2026-06-11 10:25:14.970374 2026-06-11 10:25:14.970374     International Results CSV 1 h2h://951:787/2018-03-18
88369 Cagliari 784 Torino FC 951 2018-03-31 1 0 1 0 1 2 2017-10-29 L     2026-06-11 10:25:14.998995 2026-06-11 10:25:14.998995     International Results CSV 1 h2h://784:951/2018-03-31
88523 Milan 792 Torino FC 951 2018-04-18 1 0 0 1 0 0 2017-11-26 D     2026-06-11 10:25:15.028340 2026-06-11 10:25:15.028340     International Results CSV 1 h2h://951:792/2018-04-18
88563 Atalanta 782 Torino FC 951 2018-04-22 1 0 0 1 1 1 2017-12-02 D     2026-06-11 10:25:15.035751 2026-06-11 10:25:15.035752     International Results CSV 1 h2h://782:951/2018-04-22
88676 Napoli 794 Torino FC 951 2018-05-06 1 1 0 0 3 1 2017-12-16 W     2026-06-11 10:25:15.057790 2026-06-11 10:25:15.057791     International Results CSV 1 h2h://794:951/2018-05-06
88750 Genoa 788 Torino FC 951 2018-05-20 1 0 0 1 0 0 2017-12-30 D     2026-06-11 10:25:15.072753 2026-06-11 10:25:15.072753     International Results CSV 1 h2h://788:951/2018-05-20
88808 Roma 796 Torino FC 951 2018-08-19 2 2 0 0 4 0 2018-03-09 L     2026-06-11 10:25:15.127531 2026-06-11 10:25:15.127531     International Results CSV 1 h2h://951:796/2018-08-19
88955 Udinese 798 Torino FC 951 2018-09-16 2 0 2 0 2 5 2018-02-11 L     2026-06-11 10:25:15.183962 2026-06-11 10:25:15.183962     International Results CSV 1 h2h://798:951/2018-09-16
89005 Napoli 794 Torino FC 951 2018-09-23 2 1 0 1 5 3 2018-05-06 D     2026-06-11 10:25:15.193170 2026-06-11 10:25:15.193170     International Results CSV 1 h2h://951:794/2018-09-23
89037 Atalanta 782 Torino FC 951 2018-09-26 2 1 0 1 3 2 2018-04-22 W     2026-06-11 10:25:15.199261 2026-06-11 10:25:15.199261     International Results CSV 1 h2h://782:951/2018-09-26
89104 Frosinone 806 Torino FC 951 2018-10-05 0 0 0 0 0 0         2026-06-11 10:25:15.212110 2026-06-11 10:25:15.212111     International Results CSV 1 h2h://951:806/2018-10-05
89189 Bologna 783 Torino FC 951 2018-10-21 2 0 1 1 1 4 2018-01-06 L     2026-06-11 10:25:15.257433 2026-06-11 10:25:15.257433     International Results CSV 1 h2h://783:951/2018-10-21
89222 Fiorentina 787 Torino FC 951 2018-10-27 2 2 0 0 5 1 2018-03-18 L     2026-06-11 10:25:15.263542 2026-06-11 10:25:15.263542     International Results CSV 1 h2h://951:787/2018-10-27
89292 Sampdoria 803 Torino FC 951 2018-11-04 2 0 0 2 3 3 2018-02-03 D     2026-06-11 10:25:15.276857 2026-06-11 10:25:15.276857     International Results CSV 1 h2h://803:951/2018-11-04
89396 Cagliari 784 Torino FC 951 2018-11-26 2 0 2 0 1 6 2018-03-31 L     2026-06-11 10:25:15.727535 2026-06-11 10:25:15.727535     International Results CSV 1 h2h://784:951/2018-11-26
89438 Genoa 788 Torino FC 951 2018-12-02 2 0 1 1 1 2 2018-05-20 W     2026-06-11 10:25:15.735838 2026-06-11 10:25:15.735839     International Results CSV 1 h2h://951:788/2018-12-02
89504 Milan 792 Torino FC 951 2018-12-09 2 0 0 2 1 1 2018-04-18 D     2026-06-11 10:25:15.748604 2026-06-11 10:25:15.748604     International Results CSV 1 h2h://792:951/2018-12-09
89524 Juventus 341 Torino FC 951 2018-12-15 2 2 0 0 5 0 2018-02-18 L     2026-06-11 10:25:15.752809 2026-06-11 10:25:15.752809     International Results CSV 1 h2h://951:341/2018-12-15
89592 Sassuolo 804 Torino FC 951 2018-12-22 2 0 1 1 1 4 2018-01-21 D     2026-06-11 10:25:15.766307 2026-06-11 10:25:15.766307     International Results CSV 1 h2h://804:951/2018-12-22
89627 Empoli 786 Torino FC 951 2018-12-26 0 0 0 0 0 0         2026-06-11 10:25:15.773903 2026-06-11 10:25:15.773903     International Results CSV 1 h2h://951:786/2018-12-26
89726 Roma 796 Torino FC 951 2019-01-19 3 3 0 0 5 0 2018-08-19 W     2026-06-11 10:25:15.802206 2026-06-11 10:25:15.802206     International Results CSV 1 h2h://796:951/2019-01-19
89898 Udinese 798 Torino FC 951 2019-02-10 3 0 2 1 3 6 2018-09-16 D     2026-06-11 10:25:15.837486 2026-06-11 10:25:15.837486     International Results CSV 1 h2h://951:798/2019-02-10
89939 Napoli 794 Torino FC 951 2019-02-17 3 2 0 1 8 4 2018-09-23 W     2026-06-11 10:25:15.845191 2026-06-11 10:25:15.845191     International Results CSV 1 h2h://794:951/2019-02-17
89965 Atalanta 782 Torino FC 951 2019-02-23 3 1 0 2 3 2 2018-09-26 D     2026-06-11 10:25:15.850485 2026-06-11 10:25:15.850486     International Results CSV 1 h2h://951:782/2019-02-23
90090 Frosinone 806 Torino FC 951 2019-03-10 1 0 1 0 2 3 2018-10-05 L     2026-06-11 10:25:15.874952 2026-06-11 10:25:15.874952     International Results CSV 1 h2h://806:951/2019-03-10
90118 Bologna 783 Torino FC 951 2019-03-16 3 0 1 2 3 6 2018-10-21 D     2026-06-11 10:25:15.880524 2026-06-11 10:25:15.880524     International Results CSV 1 h2h://951:783/2019-03-16
90183 Fiorentina 787 Torino FC 951 2019-03-31 3 2 0 1 6 2 2018-10-27 D     2026-06-11 10:25:15.917869 2026-06-11 10:25:15.917870     International Results CSV 1 h2h://787:951/2019-03-31
90212 Sampdoria 803 Torino FC 951 2019-04-03 3 0 1 2 4 7 2018-11-04 W     2026-06-11 10:25:15.923301 2026-06-11 10:25:15.923301     International Results CSV 1 h2h://951:803/2019-04-03
90301 Cagliari 784 Torino FC 951 2019-04-14 3 0 2 1 1 6 2018-11-26 D     2026-06-11 10:25:15.939878 2026-06-11 10:25:15.939879     International Results CSV 1 h2h://951:784/2019-04-14
90337 Genoa 788 Torino FC 951 2019-04-20 3 0 2 1 2 4 2018-12-02 L     2026-06-11 10:25:15.946688 2026-06-11 10:25:15.946689     International Results CSV 1 h2h://788:951/2019-04-20
90420 Milan 792 Torino FC 951 2019-04-28 3 0 0 3 1 1 2018-12-09 D     2026-06-11 10:25:15.962174 2026-06-11 10:25:15.962174     International Results CSV 1 h2h://951:792/2019-04-28
90431 Juventus 341 Torino FC 951 2019-05-03 3 3 0 0 6 0 2018-12-15 W     2026-06-11 10:25:15.964232 2026-06-11 10:25:15.964232     International Results CSV 1 h2h://341:951/2019-05-03
90518 Sassuolo 804 Torino FC 951 2019-05-12 3 0 1 2 2 5 2018-12-22 D     2026-06-11 10:25:15.980949 2026-06-11 10:25:15.980950     International Results CSV 1 h2h://951:804/2019-05-12
90559 Empoli 786 Torino FC 951 2019-05-19 1 0 1 0 0 3 2018-12-26 L     2026-06-11 10:25:15.988659 2026-06-11 10:25:15.988659     International Results CSV 1 h2h://786:951/2019-05-19
90615 Juventus 341 Torino FC 951 2019-07-04 4 3 0 1 7 1 2019-05-03 D     2026-06-11 10:25:16.053006 2026-06-11 10:25:16.053006     International Results CSV 1 h2h://341:951/2019-07-04
90723 Genoa 788 Torino FC 951 2019-07-16 4 0 3 1 2 5 2019-04-20 W     2026-06-11 10:25:16.080671 2026-06-11 10:25:16.080671     International Results CSV 1 h2h://951:788/2019-07-16
90744 Fiorentina 787 Torino FC 951 2019-07-19 4 2 0 2 7 3 2019-03-31 D     2026-06-11 10:25:16.086546 2026-06-11 10:25:16.086547     International Results CSV 1 h2h://787:951/2019-07-19
90795 Roma 796 Torino FC 951 2019-07-29 4 4 0 0 8 2 2019-01-19 L     2026-06-11 10:25:16.098278 2026-06-11 10:25:16.098278     International Results CSV 1 h2h://951:796/2019-07-29
90802 Bologna 783 Torino FC 951 2019-08-02 4 1 1 2 6 8 2019-03-16 W     2026-06-11 10:25:16.100329 2026-06-11 10:25:16.100329     International Results CSV 1 h2h://783:951/2019-08-02
90904 Sassuolo 804 Torino FC 951 2019-08-25 4 0 2 2 4 8 2019-05-12 W     2026-06-11 10:25:16.122278 2026-06-11 10:25:16.122278     International Results CSV 1 h2h://951:804/2019-08-25
90948 Atalanta 782 Torino FC 951 2019-09-01 4 1 1 2 3 4 2019-02-23 L     2026-06-11 10:25:16.131837 2026-06-11 10:25:16.131838     International Results CSV 1 h2h://782:951/2019-09-01
91052 Sampdoria 803 Torino FC 951 2019-09-22 4 0 2 2 5 9 2019-04-03 L     2026-06-11 10:25:16.183269 2026-06-11 10:25:16.183269     International Results CSV 1 h2h://803:951/2019-09-22
91077 Milan 792 Torino FC 951 2019-09-26 4 0 1 3 1 3 2019-04-28 W     2026-06-11 10:25:16.187875 2026-06-11 10:25:16.187875     International Results CSV 1 h2h://951:792/2019-09-26
91166 Napoli 794 Torino FC 951 2019-10-06 4 2 0 2 8 4 2019-02-17 D     2026-06-11 10:25:16.205688 2026-06-11 10:25:16.205688     International Results CSV 1 h2h://951:794/2019-10-06
91219 Udinese 798 Torino FC 951 2019-10-20 4 0 3 1 3 7 2019-02-10 L     2026-06-11 10:25:16.245233 2026-06-11 10:25:16.245233     International Results CSV 1 h2h://798:951/2019-10-20
91267 Cagliari 784 Torino FC 951 2019-10-27 4 0 2 2 2 7 2019-04-14 D     2026-06-11 10:25:16.254032 2026-06-11 10:25:16.254032     International Results CSV 1 h2h://951:784/2019-10-27
91315 Juventus 341 Torino FC 951 2019-11-02 5 4 0 1 11 2 2019-07-04 L     2026-06-11 10:25:16.262954 2026-06-11 10:25:16.262955     International Results CSV 1 h2h://951:341/2019-11-02
91462 Genoa 788 Torino FC 951 2019-11-30 5 0 4 1 2 8 2019-07-16 L     2026-06-11 10:25:16.325697 2026-06-11 10:25:16.325698     International Results CSV 1 h2h://788:951/2019-11-30
91537 Fiorentina 787 Torino FC 951 2019-12-08 5 3 0 2 9 3 2019-07-19 L     2026-06-11 10:25:16.340942 2026-06-11 10:25:16.340942     International Results CSV 1 h2h://951:787/2019-12-08
91708 Roma 796 Torino FC 951 2020-01-05 5 5 0 0 11 4 2019-07-29 W     2026-06-11 10:25:16.373906 2026-06-11 10:25:16.373906     International Results CSV 1 h2h://796:951/2020-01-05
91739 Bologna 783 Torino FC 951 2020-01-12 5 1 1 3 7 9 2019-08-02 D     2026-06-11 10:25:16.380326 2026-06-11 10:25:16.380327     International Results CSV 1 h2h://951:783/2020-01-12
91766 Sassuolo 804 Torino FC 951 2020-01-18 5 0 3 2 5 10 2019-08-25 L     2026-06-11 10:25:16.385433 2026-06-11 10:25:16.385434     International Results CSV 1 h2h://804:951/2020-01-18
91817 Atalanta 782 Torino FC 951 2020-01-25 5 1 2 2 5 7 2019-09-01 W     2026-06-11 10:25:16.394902 2026-06-11 10:25:16.394903     International Results CSV 1 h2h://951:782/2020-01-25
91909 Sampdoria 803 Torino FC 951 2020-02-08 5 1 2 2 6 9 2019-09-22 L     2026-06-11 10:25:16.411874 2026-06-11 10:25:16.411874     International Results CSV 1 h2h://951:803/2020-02-08
91970 Milan 792 Torino FC 951 2020-02-17 5 0 2 3 2 5 2019-09-26 L     2026-06-11 10:25:16.423011 2026-06-11 10:25:16.423011     International Results CSV 1 h2h://792:951/2020-02-17
92020 Napoli 794 Torino FC 951 2020-02-29 5 2 0 3 8 4 2019-10-06 D     2026-06-11 10:25:16.432083 2026-06-11 10:25:16.432083     International Results CSV 1 h2h://794:951/2020-02-29
92206 Udinese 798 Torino FC 951 2020-06-23 5 1 3 1 4 7 2019-10-20 L     2026-06-11 10:25:16.466083 2026-06-11 10:25:16.466083     International Results CSV 1 h2h://951:798/2020-06-23
92231 Cagliari 784 Torino FC 951 2020-06-27 5 0 2 3 3 8 2019-10-27 D     2026-06-11 10:25:16.470638 2026-06-11 10:25:16.470638     International Results CSV 1 h2h://784:951/2020-06-27
92319 Fiorentina 787 Torino FC 951 2020-09-19 6 3 1 2 10 5 2019-12-08 L     2026-06-11 10:25:16.496607 2026-06-11 10:25:16.496607     International Results CSV 1 h2h://787:951/2020-09-19
92360 Atalanta 782 Torino FC 951 2020-09-26 6 2 2 2 12 7 2020-01-25 L     2026-06-11 10:25:16.504123 2026-06-11 10:25:16.504123     International Results CSV 1 h2h://951:782/2020-09-26
92493 Cagliari 784 Torino FC 951 2020-10-18 6 1 2 3 7 10 2020-06-27 L     2026-06-11 10:25:16.552086 2026-06-11 10:25:16.552086     International Results CSV 1 h2h://951:784/2020-10-18
92504 Sassuolo 804 Torino FC 951 2020-10-23 6 1 3 2 7 11 2020-01-18 W     2026-06-11 10:25:16.554128 2026-06-11 10:25:16.554129     International Results CSV 1 h2h://804:951/2020-10-23
92596 Genoa 788 Torino FC 951 2020-11-04 6 0 5 1 2 9 2019-11-30 L     2026-06-11 10:25:16.571867 2026-06-11 10:25:16.571867     International Results CSV 1 h2h://788:951/2020-11-04
92744 Sampdoria 803 Torino FC 951 2020-11-30 6 2 2 2 9 10 2020-02-08 L     2026-06-11 10:25:16.629833 2026-06-11 10:25:16.629833     International Results CSV 1 h2h://951:803/2020-11-30
92765 Juventus 341 Torino FC 951 2020-12-05 6 5 0 1 12 2 2019-11-02 W     2026-06-11 10:25:16.634000 2026-06-11 10:25:16.634001     International Results CSV 1 h2h://341:951/2020-12-05
92813 Udinese 798 Torino FC 951 2020-12-12 6 1 4 1 4 8 2020-06-23 W     2026-06-11 10:25:16.643389 2026-06-11 10:25:16.643389     International Results CSV 1 h2h://951:798/2020-12-12
92869 Roma 796 Torino FC 951 2020-12-17 6 5 1 0 11 6 2020-01-05 L     2026-06-11 10:25:16.654145 2026-06-11 10:25:16.654146     International Results CSV 1 h2h://796:951/2020-12-17
92906 Bologna 783 Torino FC 951 2020-12-20 6 1 2 3 7 10 2020-01-12 W     2026-06-11 10:25:16.661164 2026-06-11 10:25:16.661164     International Results CSV 1 h2h://951:783/2020-12-20
92933 Napoli 794 Torino FC 951 2020-12-23 6 3 0 3 10 5 2020-02-29 W     2026-06-11 10:25:16.666327 2026-06-11 10:25:16.666328     International Results CSV 1 h2h://794:951/2020-12-23
93045 Milan 792 Torino FC 951 2021-01-09 6 1 2 3 3 5 2020-02-17 W     2026-06-11 10:25:16.687746 2026-06-11 10:25:16.687747     International Results CSV 1 h2h://792:951/2021-01-09
93182 Fiorentina 787 Torino FC 951 2021-01-29 7 4 1 2 11 5 2020-09-19 L     2026-06-11 10:25:16.715338 2026-06-11 10:25:16.715338     International Results CSV 1 h2h://951:787/2021-01-29
93259 Atalanta 782 Torino FC 951 2021-02-06 7 3 2 2 16 9 2020-09-26 W     2026-06-11 10:25:16.730770 2026-06-11 10:25:16.730771     International Results CSV 1 h2h://782:951/2021-02-06
93305 Genoa 788 Torino FC 951 2021-02-13 7 0 6 1 3 11 2020-11-04 W     2026-06-11 10:25:16.739709 2026-06-11 10:25:16.739709     International Results CSV 1 h2h://951:788/2021-02-13
93339 Cagliari 784 Torino FC 951 2021-02-19 7 2 2 3 10 12 2020-10-18 W     2026-06-11 10:25:16.746872 2026-06-11 10:25:16.746872     International Results CSV 1 h2h://784:951/2021-02-19
93545 Sassuolo 804 Torino FC 951 2021-03-17 7 1 3 3 10 14 2020-10-23 D     2026-06-11 10:25:16.787969 2026-06-11 10:25:16.787969     International Results CSV 1 h2h://951:804/2021-03-17
93579 Sampdoria 803 Torino FC 951 2021-03-21 7 2 2 3 11 12 2020-11-30 D     2026-06-11 10:25:16.794737 2026-06-11 10:25:16.794737     International Results CSV 1 h2h://803:951/2021-03-21
93618 Juventus 341 Torino FC 951 2021-04-03 7 6 0 1 14 3 2020-12-05 L     2026-06-11 10:25:16.836365 2026-06-11 10:25:16.836365     International Results CSV 1 h2h://951:341/2021-04-03
93663 Udinese 798 Torino FC 951 2021-04-10 7 2 4 1 7 10 2020-12-12 W     2026-06-11 10:25:16.845205 2026-06-11 10:25:16.845205     International Results CSV 1 h2h://798:951/2021-04-10
93726 Roma 796 Torino FC 951 2021-04-18 7 6 1 0 14 7 2020-12-17 L     2026-06-11 10:25:16.857470 2026-06-11 10:25:16.857471     International Results CSV 1 h2h://951:796/2021-04-18
93746 Bologna 783 Torino FC 951 2021-04-21 7 1 2 4 8 11 2020-12-20 D     2026-06-11 10:25:16.861318 2026-06-11 10:25:16.861318     International Results CSV 1 h2h://783:951/2021-04-21

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