home / football

h2h_record

293 rows where team_b_id = 420

✎ 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, source_id, 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
49460 Manchester United 338 Angers 420 1993-10-30 0 0 0 0 0 0         2026-06-11 10:24:41.192076 2026-06-11 10:24:41.192076     International Results CSV 1 h2h://338:420/1993-10-30
49614 Manchester United 338 Angers 420 1994-02-05 1 1 0 0 2 1 1993-10-30 L     2026-06-11 10:24:41.193833 2026-06-11 10:24:41.193833     International Results CSV 1 h2h://420:338/1994-02-05
49791 Manchester United 338 Angers 420 1994-08-20 2 2 0 0 5 3 1994-02-05 W     2026-06-11 10:24:41.196875 2026-06-11 10:24:41.196875     International Results CSV 1 h2h://338:420/1994-08-20
49976 Manchester United 338 Angers 420 1994-12-10 3 3 0 0 7 3 1994-08-20 L     2026-06-11 10:24:41.199510 2026-06-11 10:24:41.199510     International Results CSV 1 h2h://420:338/1994-12-10
50932 Manchester United 338 Angers 420 1995-12-30 4 4 0 0 10 5 1994-12-10 W     2026-06-11 10:24:41.210095 2026-06-11 10:24:41.210096     International Results CSV 1 h2h://338:420/1995-12-30
51290 Manchester United 338 Angers 420 1996-03-16 5 5 0 0 12 6 1995-12-30 L     2026-06-11 10:24:41.213360 2026-06-11 10:24:41.213360     International Results CSV 1 h2h://420:338/1996-03-16
77136 Manchester United 338 Angers 420 2011-12-18 6 5 0 1 13 7 1996-03-16 D     2026-06-11 10:25:11.346623 2026-06-11 10:25:11.346623     International Results CSV 1 h2h://420:338/2011-12-18
77859 Manchester United 338 Angers 420 2012-04-08 7 6 0 1 15 7 2011-12-18 W     2026-06-11 10:25:11.355594 2026-06-11 10:25:11.355594     International Results CSV 1 h2h://338:420/2012-04-08
78807 Manchester United 338 Angers 420 2012-11-24 8 7 0 1 17 7 2012-04-08 W     2026-06-11 10:25:11.372640 2026-06-11 10:25:11.372640     International Results CSV 1 h2h://338:420/2012-11-24
79398 Manchester United 338 Angers 420 2013-02-23 9 8 0 1 20 8 2012-11-24 L     2026-06-11 10:25:12.070504 2026-06-11 10:25:12.070504     International Results CSV 1 h2h://420:338/2013-02-23
81999 Manchester United 338 Angers 420 2014-09-14 10 9 0 1 22 8 2013-02-23 W     2026-06-11 10:25:12.790300 2026-06-11 10:25:12.790300     International Results CSV 1 h2h://338:420/2014-09-14
82772 Manchester United 338 Angers 420 2015-01-17 11 10 0 1 26 8 2014-09-14 L     2026-06-11 10:25:12.996583 2026-06-11 10:25:12.996583     International Results CSV 1 h2h://420:338/2015-01-17
83663 Montpellier HSC 382 Angers 420 2015-08-08 0 0 0 0 0 0         2026-06-11 10:25:13.253592 2026-06-11 10:25:13.253592     RSSSF Historical Results 8 h2h://382:420/2015-08-08
83673 FC Nantes 388 Angers 420 2015-08-15 0 0 0 0 0 0         2026-06-11 10:25:13.255857 2026-06-11 10:25:13.255858     RSSSF Historical Results 8 h2h://420:388/2015-08-15
83694 Ajaccio 410 Angers 420 2015-08-22 0 0 0 0 0 0         2026-06-11 10:25:13.260072 2026-06-11 10:25:13.260072     RSSSF Historical Results 8 h2h://410:420/2015-08-22
83732 OGC Nice 381 Angers 420 2015-08-29 0 0 0 0 0 0         2026-06-11 10:25:13.268800 2026-06-11 10:25:13.268800     RSSSF Historical Results 8 h2h://420:381/2015-08-29
83772 Lorient 369 Angers 420 2015-09-12 0 0 0 0 0 0         2026-06-11 10:25:13.302770 2026-06-11 10:25:13.302770     RSSSF Historical Results 8 h2h://369:420/2015-09-12
83810 Troyes 406 Angers 420 2015-09-19 0 0 0 0 0 0         2026-06-11 10:25:13.309829 2026-06-11 10:25:13.309830     RSSSF Historical Results 8 h2h://420:406/2015-09-19
83845 Stade de Reims 384 Angers 420 2015-09-22 0 0 0 0 0 0         2026-06-11 10:25:13.316310 2026-06-11 10:25:13.316310     RSSSF Historical Results 8 h2h://420:384/2015-09-22
83904 Olympique de Marseille 342 Angers 420 2015-09-27 0 0 0 0 0 0         2026-06-11 10:25:13.327212 2026-06-11 10:25:13.327212     RSSSF Historical Results 8 h2h://342:420/2015-09-27
83927 SC Bastia 415 Angers 420 2015-10-03 0 0 0 0 0 0         2026-06-11 10:25:13.331983 2026-06-11 10:25:13.331984     RSSSF Historical Results 8 h2h://420:415/2015-10-03
83968 Toulouse 373 Angers 420 2015-10-17 0 0 0 0 0 0         2026-06-11 10:25:13.364077 2026-06-11 10:25:13.364078     RSSSF Historical Results 8 h2h://373:420/2015-10-17
84005 EA Guingamp 419 Angers 420 2015-10-24 0 0 0 0 0 0         2026-06-11 10:25:13.370968 2026-06-11 10:25:13.370968     RSSSF Historical Results 8 h2h://420:419/2015-10-24
84072 AS Monaco 387 Angers 420 2015-11-01 0 0 0 0 0 0         2026-06-11 10:25:13.383451 2026-06-11 10:25:13.383452     RSSSF Historical Results 8 h2h://387:420/2015-11-01
84089 Stade Rennais FC 391 Angers 420 2015-11-06 0 0 0 0 0 0         2026-06-11 10:25:13.387270 2026-06-11 10:25:13.387270     RSSSF Historical Results 8 h2h://420:391/2015-11-06
84148 Caen 417 Angers 420 2015-11-22 0 0 0 0 0 0         2026-06-11 10:25:13.422995 2026-06-11 10:25:13.422995     RSSSF Historical Results 8 h2h://417:420/2015-11-22
84171 Lille OSC 344 Angers 420 2015-11-28 0 0 0 0 0 0         2026-06-11 10:25:13.429683 2026-06-11 10:25:13.429683     RSSSF Historical Results 8 h2h://420:344/2015-11-28
84206 Paris Saint-Germain 337 Angers 420 2015-12-01 0 0 0 0 0 0         2026-06-11 10:25:13.436829 2026-06-11 10:25:13.436829     RSSSF Historical Results 8 h2h://420:337/2015-12-01
84219 Olympique Lyonnais 343 Angers 420 2015-12-05 0 0 0 0 0 0         2026-06-11 10:25:13.439941 2026-06-11 10:25:13.439942     RSSSF Historical Results 8 h2h://343:420/2015-12-05
84278 FC Girondins de Bordeaux 404 Angers 420 2015-12-13 0 0 0 0 0 0         2026-06-11 10:25:13.451219 2026-06-11 10:25:13.451219     RSSSF Historical Results 8 h2h://420:404/2015-12-13
84312 AS Saint-Étienne 396 Angers 420 2015-12-20 0 0 0 0 0 0         2026-06-11 10:25:13.458057 2026-06-11 10:25:13.458057     RSSSF Historical Results 8 h2h://396:420/2015-12-20
84363 Caen 417 Angers 420 2016-01-09 1 0 0 1 0 0 2015-11-22 D     2026-06-11 10:25:13.866637 2026-06-11 10:25:13.866637     RSSSF Historical Results 8 h2h://420:417/2016-01-09
84391 OGC Nice 381 Angers 420 2016-01-15 1 0 0 1 1 1 2015-08-29 D     2026-06-11 10:25:13.873078 2026-06-11 10:25:13.873078     RSSSF Historical Results 8 h2h://381:420/2016-01-15
84425 Paris Saint-Germain 337 Angers 420 2016-01-23 1 0 0 1 0 0 2015-12-01 D     2026-06-11 10:25:13.879730 2026-06-11 10:25:13.879730     RSSSF Historical Results 8 h2h://337:420/2016-01-23
84463 AS Monaco 387 Angers 420 2016-01-30 1 1 0 0 1 0 2015-11-01 L     2026-06-11 10:25:13.887663 2026-06-11 10:25:13.887664     RSSSF Historical Results 8 h2h://420:387/2016-01-30
84508 Stade de Reims 384 Angers 420 2016-02-03 1 0 0 1 0 0 2015-09-22 D     2026-06-11 10:25:13.896201 2026-06-11 10:25:13.896201     RSSSF Historical Results 8 h2h://384:420/2016-02-03
84523 Olympique Lyonnais 343 Angers 420 2016-02-06 1 0 1 0 0 2 2015-12-05 W     2026-06-11 10:25:13.899351 2026-06-11 10:25:13.899351     RSSSF Historical Results 8 h2h://420:343/2016-02-06
84560 Stade Rennais FC 391 Angers 420 2016-02-12 1 1 0 0 2 0 2015-11-06 W     2026-06-11 10:25:13.906254 2026-06-11 10:25:13.906254     RSSSF Historical Results 8 h2h://391:420/2016-02-12
84604 Montpellier HSC 382 Angers 420 2016-02-20 1 0 1 0 0 2 2015-08-08 W     2026-06-11 10:25:13.914586 2026-06-11 10:25:13.914586     RSSSF Historical Results 8 h2h://420:382/2016-02-20
84641 EA Guingamp 419 Angers 420 2016-02-27 1 0 0 1 0 0 2015-10-24 D     2026-06-11 10:25:13.921992 2026-06-11 10:25:13.921992     RSSSF Historical Results 8 h2h://419:420/2016-02-27
84697 AS Saint-Étienne 396 Angers 420 2016-03-05 1 1 0 0 1 0 2015-12-20 L     2026-06-11 10:25:13.932391 2026-06-11 10:25:13.932391     RSSSF Historical Results 8 h2h://420:396/2016-03-05
84758 FC Nantes 388 Angers 420 2016-03-13 1 0 0 1 0 0 2015-08-15 D     2026-06-11 10:25:13.943974 2026-06-11 10:25:13.943974     RSSSF Historical Results 8 h2h://388:420/2016-03-13
84778 Lorient 369 Angers 420 2016-03-19 1 1 0 0 3 1 2015-09-12 L     2026-06-11 10:25:13.948077 2026-06-11 10:25:13.948077     RSSSF Historical Results 8 h2h://420:369/2016-03-19
84818 Troyes 406 Angers 420 2016-04-02 1 0 1 0 0 1 2015-09-19 L     2026-06-11 10:25:13.986596 2026-06-11 10:25:13.986596     RSSSF Historical Results 8 h2h://406:420/2016-04-02
84856 Ajaccio 410 Angers 420 2016-04-09 1 0 1 0 0 2 2015-08-22 W     2026-06-11 10:25:13.993792 2026-06-11 10:25:13.993793     RSSSF Historical Results 8 h2h://420:410/2016-04-09
84898 FC Girondins de Bordeaux 404 Angers 420 2016-04-16 1 0 0 1 1 1 2015-12-13 D     2026-06-11 10:25:14.001693 2026-06-11 10:25:14.001694     RSSSF Historical Results 8 h2h://404:420/2016-04-16
84908 SC Bastia 415 Angers 420 2016-04-16 1 0 1 0 0 1 2015-10-03 L     2026-06-11 10:25:14.003572 2026-06-11 10:25:14.003572     RSSSF Historical Results 8 h2h://415:420/2016-04-16
84964 Toulouse 373 Angers 420 2016-04-23 1 0 1 0 1 2 2015-10-17 W     2026-06-11 10:25:14.014781 2026-06-11 10:25:14.014782     RSSSF Historical Results 8 h2h://420:373/2016-04-23
85007 Lille OSC 344 Angers 420 2016-04-27 1 0 1 0 0 2 2015-11-28 L     2026-06-11 10:25:14.023668 2026-06-11 10:25:14.023668     RSSSF Historical Results 8 h2h://344:420/2016-04-27
85032 Olympique de Marseille 342 Angers 420 2016-05-01 1 0 1 0 1 2 2015-09-27 W     2026-06-11 10:25:14.028764 2026-06-11 10:25:14.028764     RSSSF Historical Results 8 h2h://420:342/2016-05-01
85112 Montpellier HSC 382 Angers 420 2016-08-13 2 1 1 0 3 4 2016-02-20 W     2026-06-11 10:25:14.102724 2026-06-11 10:25:14.102724 1   FBref 2 h2h://382:420/2016-08-13
85130 OGC Nice 381 Angers 420 2016-08-20 2 1 0 1 3 2 2016-01-15 L     2026-06-11 10:25:14.106459 2026-06-11 10:25:14.106459 1   FBref 2 h2h://420:381/2016-08-20
85172 Metz 376 Angers 420 2016-08-27 0 0 0 0 0 0         2026-06-11 10:25:14.116088 2026-06-11 10:25:14.116088 1   FBref 2 h2h://376:420/2016-08-27
85218 Dijon 413 Angers 420 2016-09-10 0 0 0 0 0 0         2026-06-11 10:25:14.147235 2026-06-11 10:25:14.147235 1   FBref 2 h2h://420:413/2016-09-10
85268 FC Girondins de Bordeaux 404 Angers 420 2016-09-17 2 0 1 1 2 4 2016-04-16 L     2026-06-11 10:25:14.156929 2026-06-11 10:25:14.156929 1   FBref 2 h2h://404:420/2016-09-17
85321 Caen 417 Angers 420 2016-09-21 2 0 1 1 0 2 2016-01-09 W     2026-06-11 10:25:14.167379 2026-06-11 10:25:14.167379 1   FBref 2 h2h://420:417/2016-09-21
85358 AS Monaco 387 Angers 420 2016-09-24 2 1 1 0 1 3 2016-01-30 L     2026-06-11 10:25:14.174618 2026-06-11 10:25:14.174619 1   FBref 2 h2h://387:420/2016-09-24
85427 Olympique de Marseille 342 Angers 420 2016-10-02 2 1 1 0 2 2 2016-05-01 L     2026-06-11 10:25:14.188408 2026-06-11 10:25:14.188408 1   FBref 2 h2h://420:342/2016-10-02
85453 SC Bastia 415 Angers 420 2016-10-15 2 1 1 0 1 1 2016-04-16 W     2026-06-11 10:25:14.216846 2026-06-11 10:25:14.216846 1   FBref 2 h2h://415:420/2016-10-15
85501 Toulouse 373 Angers 420 2016-10-22 2 1 1 0 4 4 2016-04-23 L     2026-06-11 10:25:14.226854 2026-06-11 10:25:14.226854 1   FBref 2 h2h://420:373/2016-10-22
85561 EA Guingamp 419 Angers 420 2016-10-29 2 0 0 2 2 2 2016-02-27 D     2026-06-11 10:25:14.238375 2026-06-11 10:25:14.238375 1   FBref 2 h2h://419:420/2016-10-29
85609 Lille OSC 344 Angers 420 2016-11-05 2 0 1 1 0 2 2016-04-27 D     2026-06-11 10:25:14.248806 2026-06-11 10:25:14.248806 1   FBref 2 h2h://420:344/2016-11-05
85662 Stade Rennais FC 391 Angers 420 2016-11-19 2 2 0 0 3 0 2016-02-12 W     2026-06-11 10:25:14.281826 2026-06-11 10:25:14.281826 1   FBref 2 h2h://391:420/2016-11-19
85731 AS Saint-Étienne 396 Angers 420 2016-11-27 2 1 0 1 1 0 2016-03-05 D     2026-06-11 10:25:14.297573 2026-06-11 10:25:14.297573 1   FBref 2 h2h://420:396/2016-11-27
85760 Paris Saint-Germain 337 Angers 420 2016-11-30 2 1 0 1 5 1 2016-01-23 W     2026-06-11 10:25:14.303191 2026-06-11 10:25:14.303191 1   FBref 2 h2h://337:420/2016-11-30
85766 Lorient 369 Angers 420 2016-12-03 2 1 1 0 4 6 2016-03-19 W     2026-06-11 10:25:14.304538 2026-06-11 10:25:14.304539 1   FBref 2 h2h://420:369/2016-12-03
85817 AS Nancy-Lorraine 403 Angers 420 2016-12-10 0 0 0 0 0 0         2026-06-11 10:25:14.315186 2026-06-11 10:25:14.315187 1   FBref 2 h2h://403:420/2016-12-10
85870 FC Nantes 388 Angers 420 2016-12-16 2 1 0 1 2 0 2016-03-13 L     2026-06-11 10:25:14.325597 2026-06-11 10:25:14.325598 1   FBref 2 h2h://420:388/2016-12-16
85927 Olympique Lyonnais 343 Angers 420 2016-12-21 2 1 1 0 3 2 2016-02-06 W     2026-06-11 10:25:14.336774 2026-06-11 10:25:14.336775 1   FBref 2 h2h://343:420/2016-12-21
85995 FC Girondins de Bordeaux 404 Angers 420 2017-01-14 3 0 2 1 2 5 2016-09-17 W     2026-06-11 10:25:14.354751 2026-06-11 10:25:14.354752 1   FBref 2 h2h://420:404/2017-01-14
86064 AS Saint-Étienne 396 Angers 420 2017-01-22 3 2 0 1 3 1 2016-11-27 W     2026-06-11 10:25:14.372968 2026-06-11 10:25:14.372969 1   FBref 2 h2h://396:420/2017-01-22
86086 Metz 376 Angers 420 2017-01-28 1 1 0 0 2 0 2016-08-27 L     2026-06-11 10:25:14.379292 2026-06-11 10:25:14.379292 1   FBref 2 h2h://420:376/2017-01-28
86162 Toulouse 373 Angers 420 2017-02-05 3 1 1 1 4 4 2016-10-22 D     2026-06-11 10:25:14.395275 2026-06-11 10:25:14.395275 1   FBref 2 h2h://373:420/2017-02-05
86183 Stade Rennais FC 391 Angers 420 2017-02-08 3 2 0 1 4 1 2016-11-19 D     2026-06-11 10:25:14.399487 2026-06-11 10:25:14.399487 1   FBref 2 h2h://420:391/2017-02-08
86197 Lille OSC 344 Angers 420 2017-02-11 3 0 2 1 0 3 2016-11-05 L     2026-06-11 10:25:14.402182 2026-06-11 10:25:14.402183 1   FBref 2 h2h://344:420/2017-02-11
86244 AS Nancy-Lorraine 403 Angers 420 2017-02-18 1 1 0 0 2 0 2016-12-10 L     2026-06-11 10:25:14.411288 2026-06-11 10:25:14.411289 1   FBref 2 h2h://420:403/2017-02-18
86285 SC Bastia 415 Angers 420 2017-02-25 3 1 2 0 2 3 2016-10-15 W     2026-06-11 10:25:14.419448 2026-06-11 10:25:14.419449 1   FBref 2 h2h://420:415/2017-02-25
86343 Caen 417 Angers 420 2017-03-04 3 0 2 1 1 4 2016-09-21 L     2026-06-11 10:25:14.430642 2026-06-11 10:25:14.430643 1   FBref 2 h2h://417:420/2017-03-04
86390 Olympique de Marseille 342 Angers 420 2017-03-10 3 1 1 1 3 3 2016-10-02 D     2026-06-11 10:25:14.440089 2026-06-11 10:25:14.440089 1   FBref 2 h2h://342:420/2017-03-10
86437 EA Guingamp 419 Angers 420 2017-03-18 3 1 0 2 3 2 2016-10-29 L     2026-06-11 10:25:14.450080 2026-06-11 10:25:14.450080 1   FBref 2 h2h://420:419/2017-03-18
86509 FC Nantes 388 Angers 420 2017-04-02 3 2 0 1 4 0 2016-12-16 W     2026-06-11 10:25:14.487462 2026-06-11 10:25:14.487462 1   FBref 2 h2h://388:420/2017-04-02
86562 AS Monaco 387 Angers 420 2017-04-08 3 2 1 0 3 4 2016-09-24 L     2026-06-11 10:25:14.497821 2026-06-11 10:25:14.497821 1   FBref 2 h2h://420:387/2017-04-08
86608 Paris Saint-Germain 337 Angers 420 2017-04-14 3 2 0 1 7 1 2016-11-30 L     2026-06-11 10:25:14.506685 2026-06-11 10:25:14.506685 1   FBref 2 h2h://420:337/2017-04-14
86663 Dijon 413 Angers 420 2017-04-22 1 0 1 0 1 3 2016-09-10 L     2026-06-11 10:25:14.517226 2026-06-11 10:25:14.517226 1   FBref 2 h2h://413:420/2017-04-22
86718 Olympique Lyonnais 343 Angers 420 2017-04-28 3 2 1 0 5 2 2016-12-21 L     2026-06-11 10:25:14.528273 2026-06-11 10:25:14.528274 1   FBref 2 h2h://420:343/2017-04-28
86774 Lorient 369 Angers 420 2017-05-06 3 1 1 1 6 8 2016-12-03 D     2026-06-11 10:25:14.539375 2026-06-11 10:25:14.539375 1   FBref 2 h2h://369:420/2017-05-06
86846 OGC Nice 381 Angers 420 2017-05-14 3 2 0 1 4 2 2016-08-20 W     2026-06-11 10:25:14.554375 2026-06-11 10:25:14.554375 1   FBref 2 h2h://381:420/2017-05-14
86875 Montpellier HSC 382 Angers 420 2017-05-20 3 2 1 0 4 4 2016-08-13 L     2026-06-11 10:25:14.560286 2026-06-11 10:25:14.560286 1   FBref 2 h2h://420:382/2017-05-20
86941 FC Girondins de Bordeaux 404 Angers 420 2017-08-06 4 0 2 2 3 6 2017-01-14 D     2026-06-11 10:25:14.627593 2026-06-11 10:25:14.627593     RSSSF Historical Results 8 h2h://420:404/2017-08-06
86947 Amiens 409 Angers 420 2017-08-12 0 0 0 0 0 0         2026-06-11 10:25:14.628933 2026-06-11 10:25:14.628934     RSSSF Historical Results 8 h2h://409:420/2017-08-12
86992 Olympique de Marseille 342 Angers 420 2017-08-20 4 2 1 1 6 3 2017-03-10 W     2026-06-11 10:25:14.637775 2026-06-11 10:25:14.637775     RSSSF Historical Results 8 h2h://342:420/2017-08-20
87042 Lille OSC 344 Angers 420 2017-08-27 4 0 3 1 1 5 2017-02-11 W     2026-06-11 10:25:14.648328 2026-06-11 10:25:14.648328     RSSSF Historical Results 8 h2h://420:344/2017-08-27
87088 AS Saint-Étienne 396 Angers 420 2017-09-10 4 3 0 1 5 2 2017-01-22 W     2026-06-11 10:25:14.680958 2026-06-11 10:25:14.680959     RSSSF Historical Results 8 h2h://396:420/2017-09-10
87138 Metz 376 Angers 420 2017-09-17 2 1 1 0 3 2 2017-01-28 W     2026-06-11 10:25:14.690480 2026-06-11 10:25:14.690480     RSSSF Historical Results 8 h2h://420:376/2017-09-17
87187 OGC Nice 381 Angers 420 2017-09-22 4 2 1 1 4 4 2017-05-14 L     2026-06-11 10:25:14.700632 2026-06-11 10:25:14.700632     RSSSF Historical Results 8 h2h://381:420/2017-09-22
87263 Olympique Lyonnais 343 Angers 420 2017-10-01 4 3 1 0 7 3 2017-04-28 L     2026-06-11 10:25:14.714415 2026-06-11 10:25:14.714416     RSSSF Historical Results 8 h2h://420:343/2017-10-01
87291 Caen 417 Angers 420 2017-10-14 4 0 3 1 3 7 2017-03-04 L     2026-06-11 10:25:14.740105 2026-06-11 10:25:14.740105     RSSSF Historical Results 8 h2h://417:420/2017-10-14
87338 Toulouse 373 Angers 420 2017-10-21 4 2 1 1 8 4 2017-02-05 L     2026-06-11 10:25:14.748860 2026-06-11 10:25:14.748860     RSSSF Historical Results 8 h2h://420:373/2017-10-21
87398 RC Strasbourg Alsace 393 Angers 420 2017-10-28 0 0 0 0 0 0         2026-06-11 10:25:14.759985 2026-06-11 10:25:14.759985     RSSSF Historical Results 8 h2h://393:420/2017-10-28
87444 Paris Saint-Germain 337 Angers 420 2017-11-04 4 3 0 1 9 1 2017-04-14 L     2026-06-11 10:25:14.768342 2026-06-11 10:25:14.768343     RSSSF Historical Results 8 h2h://420:337/2017-11-04

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