form_record
91 rows where team_id = 227
This data as json, CSV (advanced)
Suggested facets: pts_avg, gf_avg, win_pct, draw_pct, loss_pct, created_at (date), updated_at (date)
| form_id ▼ | team_id | date | window_matches | pts_avg | gf_avg | ga_avg | xg_for_avg | xg_against_avg | win_pct | draw_pct | loss_pct | competition_id | created_at | updated_at | created_by_run_id | updated_by_run_id | source_id | source_raw_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29981 | Anguilla 227 | 1985-11-05 | 5 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:06.476497 | 2026-06-07 07:03:06.476497 | 1 | International Results CSV 1 | form://227/1985-11-05/5 | ||||
| 35360 | Anguilla 227 | 1991-05-14 | 5 | 0.5 | 0.5 | 1.0 | 0.0 | 0.5 | 0.5 | 2026-06-07 07:03:07.531130 | 2026-06-07 07:03:07.531130 | 1 | International Results CSV 1 | form://227/1991-05-14/5 | ||||
| 35375 | Anguilla 227 | 1991-05-16 | 5 | 0.3333333333333333 | 0.3333333333333333 | 2.6666666666666665 | 0.0 | 0.3333333333333333 | 0.6666666666666666 | 2026-06-07 07:03:07.532502 | 2026-06-07 07:03:07.532502 | 1 | International Results CSV 1 | form://227/1991-05-16/5 | ||||
| 36322 | Anguilla 227 | 1992-05-02 | 5 | 0.25 | 0.25 | 2.75 | 0.0 | 0.25 | 0.75 | 2026-06-07 07:03:07.625286 | 2026-06-07 07:03:07.625286 | 1 | International Results CSV 1 | form://227/1992-05-02/5 | ||||
| 36339 | Anguilla 227 | 1992-05-09 | 5 | 0.2 | 0.2 | 3.2 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:07.626873 | 2026-06-07 07:03:07.626874 | 1 | International Results CSV 1 | form://227/1992-05-09/5 | ||||
| 37610 | Anguilla 227 | 1993-04-04 | 5 | 0.2 | 0.2 | 3.8 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:07.752378 | 2026-06-07 07:03:07.752378 | 1 | International Results CSV 1 | form://227/1993-04-04/5 | ||||
| 37622 | Anguilla 227 | 1993-04-06 | 5 | 0.0 | 0.0 | 3.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:07.753548 | 2026-06-07 07:03:07.753548 | 1 | International Results CSV 1 | form://227/1993-04-06/5 | ||||
| 39037 | Anguilla 227 | 1994-03-04 | 5 | 0.0 | 0.0 | 4.4 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:07.891550 | 2026-06-07 07:03:07.891551 | 1 | International Results CSV 1 | form://227/1994-03-04/5 | ||||
| 39047 | Anguilla 227 | 1994-03-06 | 5 | 0.0 | 0.0 | 4.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:07.892515 | 2026-06-07 07:03:07.892516 | 1 | International Results CSV 1 | form://227/1994-03-06/5 | ||||
| 40292 | Anguilla 227 | 1995-03-26 | 5 | 0.0 | 0.4 | 3.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:08.288787 | 2026-06-07 07:03:08.288788 | 1 | International Results CSV 1 | form://227/1995-03-26/5 | ||||
| 40355 | Anguilla 227 | 1995-04-02 | 5 | 0.0 | 0.4 | 3.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:08.295101 | 2026-06-07 07:03:08.295101 | 1 | International Results CSV 1 | form://227/1995-04-02/5 | ||||
| 41744 | Anguilla 227 | 1996-03-27 | 5 | 0.0 | 0.4 | 4.6 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:08.433245 | 2026-06-07 07:03:08.433245 | 1 | International Results CSV 1 | form://227/1996-03-27/5 | ||||
| 41750 | Anguilla 227 | 1996-03-29 | 5 | 0.0 | 0.4 | 3.6 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:08.433828 | 2026-06-07 07:03:08.433829 | 1 | International Results CSV 1 | form://227/1996-03-29/5 | ||||
| 43540 | Anguilla 227 | 1997-04-02 | 5 | 0.0 | 0.4 | 3.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:08.609039 | 2026-06-07 07:03:08.609039 | 1 | International Results CSV 1 | form://227/1997-04-02/5 | ||||
| 43554 | Anguilla 227 | 1997-04-04 | 5 | 0.0 | 0.4 | 4.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:08.610407 | 2026-06-07 07:03:08.610407 | 1 | International Results CSV 1 | form://227/1997-04-04/5 | ||||
| 43574 | Anguilla 227 | 1997-04-06 | 5 | 0.0 | 0.4 | 4.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:08.612353 | 2026-06-07 07:03:08.612353 | 1 | International Results CSV 1 | form://227/1997-04-06/5 | ||||
| 45288 | Anguilla 227 | 1998-04-15 | 5 | 0.0 | 0.6 | 6.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:09.053033 | 2026-06-07 07:03:09.053033 | 1 | International Results CSV 1 | form://227/1998-04-15/5 | ||||
| 45300 | Anguilla 227 | 1998-04-19 | 5 | 0.0 | 0.6 | 8.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:09.054255 | 2026-06-07 07:03:09.054255 | 1 | International Results CSV 1 | form://227/1998-04-19/5 | ||||
| 48340 | Anguilla 227 | 2000-02-25 | 5 | 0.6 | 1.4 | 8.0 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:09.365604 | 2026-06-07 07:03:09.365604 | 1 | International Results CSV 1 | form://227/2000-02-25/5 | ||||
| 48346 | Anguilla 227 | 2000-02-27 | 5 | 0.6 | 1.0 | 8.2 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:09.366214 | 2026-06-07 07:03:09.366214 | 1 | International Results CSV 1 | form://227/2000-02-27/5 | ||||
| 48363 | Anguilla 227 | 2000-03-05 | 5 | 0.6 | 1.2 | 7.8 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:09.368032 | 2026-06-07 07:03:09.368033 | 1 | International Results CSV 1 | form://227/2000-03-05/5 | ||||
| 48426 | Anguilla 227 | 2000-03-19 | 5 | 0.6 | 1.2 | 5.4 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:09.374337 | 2026-06-07 07:03:09.374337 | 1 | International Results CSV 1 | form://227/2000-03-19/5 | ||||
| 50241 | Anguilla 227 | 2001-02-08 | 5 | 1.2 | 2.0 | 2.8 | 0.4 | 0.0 | 0.6 | 2026-06-07 07:03:09.832797 | 2026-06-07 07:03:09.832797 | 1 | International Results CSV 1 | form://227/2001-02-08/5 | ||||
| 50262 | Anguilla 227 | 2001-02-10 | 5 | 0.6 | 1.4 | 2.8 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:09.834749 | 2026-06-07 07:03:09.834749 | 1 | International Results CSV 1 | form://227/2001-02-10/5 | ||||
| 52778 | Anguilla 227 | 2002-06-06 | 5 | 0.6 | 1.6 | 2.2 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:10.082041 | 2026-06-07 07:03:10.082041 | 1 | International Results CSV 1 | form://227/2002-06-06/5 | ||||
| 52868 | Anguilla 227 | 2002-06-23 | 5 | 0.6 | 1.4 | 1.8 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:10.090836 | 2026-06-07 07:03:10.090836 | 1 | International Results CSV 1 | form://227/2002-06-23/5 | ||||
| 52890 | Anguilla 227 | 2002-07-06 | 5 | 0.6 | 1.4 | 1.8 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:10.092980 | 2026-06-07 07:03:10.092980 | 1 | International Results CSV 1 | form://227/2002-07-06/5 | ||||
| 55888 | Anguilla 227 | 2004-03-19 | 5 | 0.2 | 0.6 | 1.6 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:10.664250 | 2026-06-07 07:03:10.664251 | 1 | International Results CSV 1 | form://227/2004-03-19/5 | ||||
| 55894 | Anguilla 227 | 2004-03-21 | 5 | 0.2 | 0.4 | 2.2 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:10.664836 | 2026-06-07 07:03:10.664836 | 1 | International Results CSV 1 | form://227/2004-03-21/5 | ||||
| 60464 | Anguilla 227 | 2006-09-20 | 5 | 0.2 | 0.8 | 2.8 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:11.397055 | 2026-06-07 07:03:11.397055 | 1 | International Results CSV 1 | form://227/2006-09-20/5 | ||||
| 60471 | Anguilla 227 | 2006-09-22 | 5 | 0.2 | 1.0 | 3.8 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:11.397830 | 2026-06-07 07:03:11.397830 | 1 | International Results CSV 1 | form://227/2006-09-22/5 | ||||
| 60482 | Anguilla 227 | 2006-09-24 | 5 | 0.2 | 1.0 | 4.8 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:11.398805 | 2026-06-07 07:03:11.398805 | 1 | International Results CSV 1 | form://227/2006-09-24/5 | ||||
| 63178 | Anguilla 227 | 2008-02-06 | 5 | 0.0 | 1.0 | 7.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:11.663432 | 2026-06-07 07:03:11.663432 | 1 | International Results CSV 1 | form://227/2008-02-06/5 | ||||
| 63321 | Anguilla 227 | 2008-03-26 | 5 | 0.0 | 1.0 | 6.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:11.677484 | 2026-06-07 07:03:11.677484 | 1 | International Results CSV 1 | form://227/2008-03-26/5 | ||||
| 64642 | Anguilla 227 | 2008-09-19 | 5 | 0.0 | 0.6 | 6.4 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:11.805855 | 2026-06-07 07:03:11.805855 | 1 | International Results CSV 1 | form://227/2008-09-19/5 | ||||
| 67746 | Anguilla 227 | 2010-08-08 | 5 | 0.0 | 0.6 | 5.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:12.405614 | 2026-06-07 07:03:12.405614 | 1 | International Results CSV 1 | form://227/2010-08-08/5 | ||||
| 68081 | Anguilla 227 | 2010-09-18 | 5 | 0.0 | 0.6 | 4.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:12.439807 | 2026-06-07 07:03:12.439807 | 1 | International Results CSV 1 | form://227/2010-09-18/5 | ||||
| 68154 | Anguilla 227 | 2010-10-02 | 5 | 0.0 | 0.8 | 3.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:12.447126 | 2026-06-07 07:03:12.447126 | 1 | International Results CSV 1 | form://227/2010-10-02/5 | ||||
| 68160 | Anguilla 227 | 2010-10-04 | 5 | 0.0 | 1.0 | 3.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:12.447737 | 2026-06-07 07:03:12.447737 | 1 | International Results CSV 1 | form://227/2010-10-04/5 | ||||
| 68165 | Anguilla 227 | 2010-10-06 | 5 | 0.6 | 1.2 | 2.6 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:12.448343 | 2026-06-07 07:03:12.448343 | 1 | International Results CSV 1 | form://227/2010-10-06/5 | ||||
| 69542 | Anguilla 227 | 2011-06-19 | 5 | 0.8 | 1.0 | 2.0 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:12.587983 | 2026-06-07 07:03:12.587984 | 1 | International Results CSV 1 | form://227/2011-06-19/5 | ||||
| 69693 | Anguilla 227 | 2011-07-08 | 5 | 0.8 | 0.8 | 2.0 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:12.603262 | 2026-06-07 07:03:12.603263 | 1 | International Results CSV 1 | form://227/2011-07-08/5 | ||||
| 69715 | Anguilla 227 | 2011-07-10 | 5 | 0.8 | 0.6 | 2.2 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:12.605475 | 2026-06-07 07:03:12.605475 | 1 | International Results CSV 1 | form://227/2011-07-10/5 | ||||
| 71935 | Anguilla 227 | 2012-07-07 | 5 | 0.8 | 0.4 | 1.6 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:13.120243 | 2026-06-07 07:03:13.120244 | 1 | International Results CSV 1 | form://227/2012-07-07/5 | ||||
| 72475 | Anguilla 227 | 2012-10-12 | 5 | 0.2 | 0.2 | 2.2 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:13.173361 | 2026-06-07 07:03:13.173361 | 1 | International Results CSV 1 | form://227/2012-10-12/5 | ||||
| 72549 | Anguilla 227 | 2012-10-14 | 5 | 0.0 | 0.2 | 4.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:13.180548 | 2026-06-07 07:03:13.180548 | 1 | International Results CSV 1 | form://227/2012-10-14/5 | ||||
| 75895 | Anguilla 227 | 2014-09-05 | 5 | 0.0 | 0.2 | 4.6 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:13.807475 | 2026-06-07 07:03:13.807475 | 1 | International Results CSV 1 | form://227/2014-09-05/5 | ||||
| 76915 | Anguilla 227 | 2015-03-23 | 5 | 0.0 | 0.2 | 4.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:13.911970 | 2026-06-07 07:03:13.911970 | 1 | International Results CSV 1 | form://227/2015-03-23/5 | ||||
| 77034 | Anguilla 227 | 2015-03-29 | 5 | 0.0 | 0.2 | 5.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:13.924293 | 2026-06-07 07:03:13.924293 | 1 | International Results CSV 1 | form://227/2015-03-29/5 | ||||
| 78817 | Anguilla 227 | 2016-03-13 | 5 | 0.0 | 0.0 | 4.8 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:14.107635 | 2026-06-07 07:03:14.107635 | 1 | International Results CSV 1 | form://227/2016-03-13/5 | ||||
| 78964 | Anguilla 227 | 2016-03-26 | 5 | 0.0 | 0.0 | 3.6 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:14.122020 | 2026-06-07 07:03:14.122020 | 1 | International Results CSV 1 | form://227/2016-03-26/5 | ||||
| 83273 | Anguilla 227 | 2018-07-27 | 5 | 0.6 | 0.4 | 3.0 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:14.848711 | 2026-06-07 07:03:14.848711 | 1 | International Results CSV 1 | form://227/2018-07-27/5 | ||||
| 83291 | Anguilla 227 | 2018-08-22 | 5 | 0.8 | 0.6 | 2.2 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:14.850468 | 2026-06-07 07:03:14.850468 | 1 | International Results CSV 1 | form://227/2018-08-22/5 | ||||
| 83292 | Anguilla 227 | 2018-08-25 | 5 | 0.8 | 0.8 | 2.0 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:14.850655 | 2026-06-07 07:03:14.850656 | 1 | International Results CSV 1 | form://227/2018-08-25/5 | ||||
| 83406 | Anguilla 227 | 2018-09-07 | 5 | 0.8 | 0.8 | 2.6 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:14.861800 | 2026-06-07 07:03:14.861800 | 1 | International Results CSV 1 | form://227/2018-09-07/5 | ||||
| 83803 | Anguilla 227 | 2018-10-14 | 5 | 0.8 | 0.8 | 3.0 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:14.900423 | 2026-06-07 07:03:14.900423 | 1 | International Results CSV 1 | form://227/2018-10-14/5 | ||||
| 84129 | Anguilla 227 | 2018-11-18 | 5 | 0.4 | 0.6 | 3.0 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:14.932230 | 2026-06-07 07:03:14.932230 | 1 | International Results CSV 1 | form://227/2018-11-18/5 | ||||
| 84518 | Anguilla 227 | 2019-03-22 | 5 | 0.2 | 0.4 | 3.4 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:14.970477 | 2026-06-07 07:03:14.970477 | 1 | International Results CSV 1 | form://227/2019-03-22/5 | ||||
| 85555 | Anguilla 227 | 2019-09-05 | 5 | 0.2 | 0.2 | 5.0 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:15.381043 | 2026-06-07 07:03:15.381044 | 1 | International Results CSV 1 | form://227/2019-09-05/5 | ||||
| 86012 | Anguilla 227 | 2019-10-12 | 5 | 0.2 | 0.2 | 5.0 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:15.425854 | 2026-06-07 07:03:15.425854 | 1 | International Results CSV 1 | form://227/2019-10-12/5 | ||||
| 86150 | Anguilla 227 | 2019-10-15 | 5 | 0.2 | 0.6 | 4.4 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:15.439351 | 2026-06-07 07:03:15.439351 | 1 | International Results CSV 1 | form://227/2019-10-15/5 | ||||
| 86199 | Anguilla 227 | 2019-11-10 | 5 | 0.0 | 0.4 | 7.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:15.444086 | 2026-06-07 07:03:15.444086 | 1 | International Results CSV 1 | form://227/2019-11-10/5 | ||||
| 86519 | Anguilla 227 | 2019-11-19 | 5 | 0.0 | 0.4 | 7.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:15.475638 | 2026-06-07 07:03:15.475638 | 1 | International Results CSV 1 | form://227/2019-11-19/5 | ||||
| 87490 | Anguilla 227 | 2021-03-27 | 5 | 0.0 | 0.4 | 6.4 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:15.571795 | 2026-06-07 07:03:15.571795 | 1 | International Results CSV 1 | form://227/2021-03-27/5 | ||||
| 87617 | Anguilla 227 | 2021-03-30 | 5 | 0.0 | 0.4 | 5.6 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:15.584130 | 2026-06-07 07:03:15.584130 | 1 | International Results CSV 1 | form://227/2021-03-30/5 | ||||
| 87775 | Anguilla 227 | 2021-06-02 | 5 | 0.0 | 0.0 | 5.6 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:15.599564 | 2026-06-07 07:03:15.599564 | 1 | International Results CSV 1 | form://227/2021-06-02/5 | ||||
| 87889 | Anguilla 227 | 2021-06-05 | 5 | 0.0 | 0.0 | 5.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:15.610689 | 2026-06-07 07:03:15.610689 | 1 | International Results CSV 1 | form://227/2021-06-05/5 | ||||
| 90204 | Anguilla 227 | 2022-06-02 | 5 | 0.2 | 0.0 | 4.6 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:16.150880 | 2026-06-07 07:03:16.150881 | 1 | International Results CSV 1 | form://227/2022-06-02/5 | ||||
| 90335 | Anguilla 227 | 2022-06-05 | 5 | 0.4 | 0.2 | 3.6 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:16.163525 | 2026-06-07 07:03:16.163525 | 1 | International Results CSV 1 | form://227/2022-06-05/5 | ||||
| 90623 | Anguilla 227 | 2022-06-12 | 5 | 0.4 | 0.2 | 3.8 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:16.191610 | 2026-06-07 07:03:16.191610 | 1 | International Results CSV 1 | form://227/2022-06-12/5 | ||||
| 91696 | Anguilla 227 | 2023-03-24 | 5 | 0.4 | 0.4 | 3.6 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:16.297123 | 2026-06-07 07:03:16.297123 | 1 | International Results CSV 1 | form://227/2023-03-24/5 | ||||
| 92506 | Anguilla 227 | 2023-09-07 | 5 | 0.4 | 0.4 | 2.2 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:16.376878 | 2026-06-07 07:03:16.376878 | 1 | International Results CSV 1 | form://227/2023-09-07/5 | ||||
| 92833 | Anguilla 227 | 2023-10-12 | 5 | 0.2 | 0.4 | 2.6 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:16.408692 | 2026-06-07 07:03:16.408692 | 1 | International Results CSV 1 | form://227/2023-10-12/5 | ||||
| 93023 | Anguilla 227 | 2023-10-16 | 5 | 0.0 | 0.2 | 4.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:16.427248 | 2026-06-07 07:03:16.427248 | 1 | International Results CSV 1 | form://227/2023-10-16/5 | ||||
| 93324 | Anguilla 227 | 2023-11-18 | 5 | 0.0 | 0.2 | 4.2 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:16.456605 | 2026-06-07 07:03:16.456605 | 1 | International Results CSV 1 | form://227/2023-11-18/5 | ||||
| 93990 | Anguilla 227 | 2024-03-22 | 5 | 0.2 | 0.0 | 3.8 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:16.521367 | 2026-06-07 07:03:16.521368 | 1 | International Results CSV 1 | form://227/2024-03-22/5 | ||||
| 94151 | Anguilla 227 | 2024-03-26 | 5 | 0.4 | 0.2 | 2.8 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:16.536949 | 2026-06-07 07:03:16.536949 | 1 | International Results CSV 1 | form://227/2024-03-26/5 | ||||
| 94444 | Anguilla 227 | 2024-06-08 | 5 | 0.4 | 0.2 | 3.2 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:16.565572 | 2026-06-07 07:03:16.565572 | 1 | International Results CSV 1 | form://227/2024-06-08/5 | ||||
| 94597 | Anguilla 227 | 2024-06-11 | 5 | 0.4 | 0.2 | 3.2 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:16.580368 | 2026-06-07 07:03:16.580368 | 1 | International Results CSV 1 | form://227/2024-06-11/5 | ||||
| 94834 | Anguilla 227 | 2024-09-04 | 5 | 1.0 | 0.6 | 2.6 | 0.2 | 0.4 | 0.4 | 2026-06-07 07:03:16.603697 | 2026-06-07 07:03:16.603697 | 1 | International Results CSV 1 | form://227/2024-09-04/5 | ||||
| 95148 | Anguilla 227 | 2024-09-10 | 5 | 0.8 | 0.6 | 2.8 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:16.955484 | 2026-06-07 07:03:16.955484 | 1 | International Results CSV 1 | form://227/2024-09-10/5 | ||||
| 95204 | Anguilla 227 | 2024-10-09 | 5 | 0.6 | 0.4 | 2.8 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:16.960991 | 2026-06-07 07:03:16.960991 | 1 | International Results CSV 1 | form://227/2024-10-09/5 | ||||
| 95370 | Anguilla 227 | 2024-10-12 | 5 | 0.6 | 0.6 | 2.4 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:16.977088 | 2026-06-07 07:03:16.977088 | 1 | International Results CSV 1 | form://227/2024-10-12/5 | ||||
| 96451 | Anguilla 227 | 2025-05-25 | 5 | 0.6 | 1.0 | 1.6 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:17.086477 | 2026-06-07 07:03:17.086477 | 1 | International Results CSV 1 | form://227/2025-05-25/5 | ||||
| 96471 | Anguilla 227 | 2025-06-01 | 5 | 0.0 | 0.6 | 2.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:17.088554 | 2026-06-07 07:03:17.088554 | 1 | International Results CSV 1 | form://227/2025-06-01/5 | ||||
| 96497 | Anguilla 227 | 2025-06-04 | 5 | 0.0 | 0.6 | 3.0 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:17.091255 | 2026-06-07 07:03:17.091255 | 1 | International Results CSV 1 | form://227/2025-06-04/5 | ||||
| 96638 | Anguilla 227 | 2025-06-07 | 5 | 0.0 | 0.6 | 3.4 | 0.0 | 0.0 | 1.0 | 2026-06-07 07:03:17.106048 | 2026-06-07 07:03:17.106048 | 1 | International Results CSV 1 | form://227/2025-06-07/5 | ||||
| 97589 | Anguilla 227 | 2025-11-12 | 5 | 0.6 | 0.8 | 3.2 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:17.203537 | 2026-06-07 07:03:17.203537 | 1 | International Results CSV 1 | form://227/2025-11-12/5 | ||||
| 97737 | Anguilla 227 | 2025-11-15 | 5 | 0.6 | 0.4 | 3.2 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:17.218588 | 2026-06-07 07:03:17.218588 | 1 | International Results CSV 1 | form://227/2025-11-15/5 | ||||
| 98147 | Anguilla 227 | 2026-03-26 | 5 | 1.2 | 1.0 | 3.0 | 0.4 | 0.0 | 0.6 | 2026-06-07 07:03:17.260227 | 2026-06-07 07:03:17.260227 | 1 | International Results CSV 1 | form://227/2026-03-26/5 | ||||
| 98261 | Anguilla 227 | 2026-03-29 | 5 | 1.2 | 1.0 | 2.6 | 0.4 | 0.0 | 0.6 | 2026-06-07 07:03:17.271802 | 2026-06-07 07:03:17.271802 | 1 | International Results CSV 1 | form://227/2026-03-29/5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE form_record (
form_id INTEGER NOT NULL,
team_id INTEGER NOT NULL,
date DATE NOT NULL,
window_matches INTEGER NOT NULL,
pts_avg FLOAT NOT NULL,
gf_avg FLOAT NOT NULL,
ga_avg FLOAT NOT NULL,
xg_for_avg FLOAT,
xg_against_avg FLOAT,
win_pct FLOAT,
draw_pct FLOAT,
loss_pct FLOAT,
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_form_record PRIMARY KEY (form_id),
CONSTRAINT fk_form_record_team FOREIGN KEY(team_id) REFERENCES team (team_id),
CONSTRAINT fk_form_record_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
CONSTRAINT fk_form_record_competition FOREIGN KEY(competition_id) REFERENCES competition (competition_id)
);