home / football

form_record

228 rows where team_id = 250

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pts_avg, gf_avg, ga_avg, win_pct, draw_pct, loss_pct, date (date), 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
42909 Andorra 250 1996-11-13 5 0.0 1.0 6.0     0.0 0.0 1.0   2026-06-07 07:03:08.547819 2026-06-07 07:03:08.547819 1   International Results CSV 1 form://250/1996-11-13/5
44095 Andorra 250 1997-06-22 5 0.0 1.0 5.0     0.0 0.0 1.0   2026-06-07 07:03:08.663089 2026-06-07 07:03:08.663089 1   International Results CSV 1 form://250/1997-06-22/5
44121 Andorra 250 1997-06-25 5 0.0 1.0 4.666666666666667     0.0 0.0 1.0   2026-06-07 07:03:08.665618 2026-06-07 07:03:08.665618 1   International Results CSV 1 form://250/1997-06-25/5
45467 Andorra 250 1998-06-03 5 0.0 0.75 4.25     0.0 0.0 1.0   2026-06-07 07:03:09.071339 2026-06-07 07:03:09.071339 1   International Results CSV 1 form://250/1998-06-03/5
45582 Andorra 250 1998-06-22 5 0.0 0.8 3.8     0.0 0.0 1.0   2026-06-07 07:03:09.082946 2026-06-07 07:03:09.082946 1   International Results CSV 1 form://250/1998-06-22/5
45593 Andorra 250 1998-06-24 5 0.2 0.6 2.6     0.0 0.2 0.8   2026-06-07 07:03:09.084163 2026-06-07 07:03:09.084164 1   International Results CSV 1 form://250/1998-06-24/5
45622 Andorra 250 1998-06-26 5 0.2 0.4 2.2     0.0 0.2 0.8   2026-06-07 07:03:09.087039 2026-06-07 07:03:09.087039 1   International Results CSV 1 form://250/1998-06-26/5
45640 Andorra 250 1998-06-29 5 0.2 0.2 2.2     0.0 0.2 0.8   2026-06-07 07:03:09.088862 2026-06-07 07:03:09.088862 1   International Results CSV 1 form://250/1998-06-29/5
45914 Andorra 250 1998-09-05 5 0.2 0.4 2.2     0.0 0.2 0.8   2026-06-07 07:03:09.116712 2026-06-07 07:03:09.116713 1   International Results CSV 1 form://250/1998-09-05/5
46103 Andorra 250 1998-10-10 5 0.2 0.2 2.2     0.0 0.2 0.8   2026-06-07 07:03:09.136160 2026-06-07 07:03:09.136160 1   International Results CSV 1 form://250/1998-10-10/5
46158 Andorra 250 1998-10-14 5 0.0 0.2 2.6     0.0 0.0 1.0   2026-06-07 07:03:09.141685 2026-06-07 07:03:09.141685 1   International Results CSV 1 form://250/1998-10-14/5
46709 Andorra 250 1999-03-27 5 0.0 0.2 2.6     0.0 0.0 1.0   2026-06-07 07:03:09.198926 2026-06-07 07:03:09.198927 1   International Results CSV 1 form://250/1999-03-27/5
46784 Andorra 250 1999-03-31 5 0.0 0.4 3.0     0.0 0.0 1.0   2026-06-07 07:03:09.206560 2026-06-07 07:03:09.206560 1   International Results CSV 1 form://250/1999-03-31/5
47036 Andorra 250 1999-06-05 5 0.0 0.2 3.2     0.0 0.0 1.0   2026-06-07 07:03:09.232558 2026-06-07 07:03:09.232558 1   International Results CSV 1 form://250/1999-06-05/5
47075 Andorra 250 1999-06-09 5 0.0 0.2 3.0     0.0 0.0 1.0   2026-06-07 07:03:09.236674 2026-06-07 07:03:09.236674 1   International Results CSV 1 form://250/1999-06-09/5
47514 Andorra 250 1999-08-18 5 0.0 0.2 3.4     0.0 0.0 1.0   2026-06-07 07:03:09.281674 2026-06-07 07:03:09.281674 1   International Results CSV 1 form://250/1999-08-18/5
47566 Andorra 250 1999-09-04 5 0.0 0.2 3.6     0.0 0.0 1.0   2026-06-07 07:03:09.286955 2026-06-07 07:03:09.286955 1   International Results CSV 1 form://250/1999-09-04/5
47595 Andorra 250 1999-09-08 5 0.0 0.2 2.8     0.0 0.0 1.0   2026-06-07 07:03:09.289999 2026-06-07 07:03:09.289999 1   International Results CSV 1 form://250/1999-09-08/5
47707 Andorra 250 1999-10-09 5 0.0 0.2 2.6     0.0 0.0 1.0   2026-06-07 07:03:09.301401 2026-06-07 07:03:09.301401 1   International Results CSV 1 form://250/1999-10-09/5
48146 Andorra 250 2000-02-06 5 0.0 0.2 3.0     0.0 0.0 1.0   2026-06-07 07:03:09.345877 2026-06-07 07:03:09.345877 1   International Results CSV 1 form://250/2000-02-06/5
48170 Andorra 250 2000-02-08 5 0.2 0.4 2.4     0.0 0.2 0.8   2026-06-07 07:03:09.348312 2026-06-07 07:03:09.348312 1   International Results CSV 1 form://250/2000-02-08/5
48183 Andorra 250 2000-02-10 5 0.4 0.4 1.8     0.0 0.4 0.6   2026-06-07 07:03:09.349740 2026-06-07 07:03:09.349740 1   International Results CSV 1 form://250/2000-02-10/5
48755 Andorra 250 2000-04-26 5 1.0 0.6 1.4     0.2 0.4 0.4   2026-06-07 07:03:09.407742 2026-06-07 07:03:09.407742 1   International Results CSV 1 form://250/2000-04-26/5
49470 Andorra 250 2000-08-16 5 1.0 0.6 1.0     0.2 0.4 0.4   2026-06-07 07:03:09.480073 2026-06-07 07:03:09.480073 1   International Results CSV 1 form://250/2000-08-16/5
49537 Andorra 250 2000-09-02 5 1.0 1.0 1.0     0.2 0.4 0.4   2026-06-07 07:03:09.486978 2026-06-07 07:03:09.486978 1   International Results CSV 1 form://250/2000-09-02/5
49690 Andorra 250 2000-10-07 5 0.8 1.0 1.2     0.2 0.2 0.6   2026-06-07 07:03:09.502626 2026-06-07 07:03:09.502627 1   International Results CSV 1 form://250/2000-10-07/5
49965 Andorra 250 2000-11-15 5 0.6 1.0 2.2     0.2 0.0 0.8   2026-06-07 07:03:09.530377 2026-06-07 07:03:09.530377 1   International Results CSV 1 form://250/2000-11-15/5
50406 Andorra 250 2001-02-28 5 0.0 0.6 2.8     0.0 0.0 1.0   2026-06-07 07:03:09.848766 2026-06-07 07:03:09.848766 1   International Results CSV 1 form://250/2001-02-28/5
50503 Andorra 250 2001-03-24 5 0.0 0.6 3.6     0.0 0.0 1.0   2026-06-07 07:03:09.858281 2026-06-07 07:03:09.858281 1   International Results CSV 1 form://250/2001-03-24/5
50595 Andorra 250 2001-03-28 5 0.0 0.2 3.6     0.0 0.0 1.0   2026-06-07 07:03:09.867371 2026-06-07 07:03:09.867371 1   International Results CSV 1 form://250/2001-03-28/5
50826 Andorra 250 2001-04-25 5 0.0 0.2 3.8     0.0 0.0 1.0   2026-06-07 07:03:09.889923 2026-06-07 07:03:09.889923 1   International Results CSV 1 form://250/2001-04-25/5
51659 Andorra 250 2001-09-01 5 0.0 0.4 4.2     0.0 0.0 1.0   2026-06-07 07:03:09.972068 2026-06-07 07:03:09.972068 1   International Results CSV 1 form://250/2001-09-01/5
51852 Andorra 250 2001-10-06 5 0.0 0.4 4.4     0.0 0.0 1.0   2026-06-07 07:03:09.991084 2026-06-07 07:03:09.991084 1   International Results CSV 1 form://250/2001-10-06/5
52512 Andorra 250 2002-03-27 5 0.2 0.6 3.6     0.0 0.2 0.8   2026-06-07 07:03:10.056053 2026-06-07 07:03:10.056054 1   International Results CSV 1 form://250/2002-03-27/5
52549 Andorra 250 2002-04-17 5 0.8 1.0 3.0     0.2 0.2 0.6   2026-06-07 07:03:10.059749 2026-06-07 07:03:10.059750 1   International Results CSV 1 form://250/2002-04-17/5
52779 Andorra 250 2002-06-07 5 0.8 0.8 2.8     0.2 0.2 0.6   2026-06-07 07:03:10.082234 2026-06-07 07:03:10.082234 1   International Results CSV 1 form://250/2002-06-07/5
53024 Andorra 250 2002-08-21 5 0.8 0.6 2.0     0.2 0.2 0.6   2026-06-07 07:03:10.105998 2026-06-07 07:03:10.105998 1   International Results CSV 1 form://250/2002-08-21/5
53239 Andorra 250 2002-10-12 5 0.8 0.6 1.4     0.2 0.2 0.6   2026-06-07 07:03:10.127073 2026-06-07 07:03:10.127073 1   International Results CSV 1 form://250/2002-10-12/5
53324 Andorra 250 2002-10-16 5 0.6 0.6 1.6     0.2 0.0 0.8   2026-06-07 07:03:10.135227 2026-06-07 07:03:10.135227 1   International Results CSV 1 form://250/2002-10-16/5
54104 Andorra 250 2003-04-02 5 0.0 0.2 2.0     0.0 0.0 1.0   2026-06-07 07:03:10.210881 2026-06-07 07:03:10.210881 1   International Results CSV 1 form://250/2003-04-02/5
54169 Andorra 250 2003-04-30 5 0.0 0.2 2.0     0.0 0.0 1.0   2026-06-07 07:03:10.217307 2026-06-07 07:03:10.217307 1   International Results CSV 1 form://250/2003-04-30/5
54312 Andorra 250 2003-06-07 5 0.0 0.2 1.8     0.0 0.0 1.0   2026-06-07 07:03:10.231151 2026-06-07 07:03:10.231151 1   International Results CSV 1 form://250/2003-06-07/5
54398 Andorra 250 2003-06-11 5 0.0 0.2 2.2     0.0 0.0 1.0   2026-06-07 07:03:10.239481 2026-06-07 07:03:10.239482 1   International Results CSV 1 form://250/2003-06-11/5
54439 Andorra 250 2003-06-13 5 0.0 0.0 2.2     0.0 0.0 1.0   2026-06-07 07:03:10.243542 2026-06-07 07:03:10.243542 1   International Results CSV 1 form://250/2003-06-13/5
54869 Andorra 250 2003-09-06 5 0.0 0.0 2.4     0.0 0.0 1.0   2026-06-07 07:03:10.285405 2026-06-07 07:03:10.285406 1   International Results CSV 1 form://250/2003-09-06/5
54941 Andorra 250 2003-09-10 5 0.0 0.0 2.6     0.0 0.0 1.0   2026-06-07 07:03:10.292368 2026-06-07 07:03:10.292368 1   International Results CSV 1 form://250/2003-09-10/5
56033 Andorra 250 2004-04-14 5 0.2 0.0 2.2     0.0 0.2 0.8   2026-06-07 07:03:10.678506 2026-06-07 07:03:10.678506 1   International Results CSV 1 form://250/2004-04-14/5
56238 Andorra 250 2004-05-28 5 0.2 0.0 2.4     0.0 0.2 0.8   2026-06-07 07:03:10.698439 2026-06-07 07:03:10.698439 1   International Results CSV 1 form://250/2004-05-28/5
56380 Andorra 250 2004-06-05 5 0.2 0.0 2.8     0.0 0.2 0.8   2026-06-07 07:03:10.712414 2026-06-07 07:03:10.712414 1   International Results CSV 1 form://250/2004-06-05/5
56950 Andorra 250 2004-09-04 5 0.2 0.0 2.8     0.0 0.2 0.8   2026-06-07 07:03:10.768941 2026-06-07 07:03:10.768941 1   International Results CSV 1 form://250/2004-09-04/5
57023 Andorra 250 2004-09-08 5 0.2 0.2 3.2     0.0 0.2 0.8   2026-06-07 07:03:10.776282 2026-06-07 07:03:10.776282 1   International Results CSV 1 form://250/2004-09-08/5
57251 Andorra 250 2004-10-13 5 0.6 0.4 3.2     0.2 0.0 0.8   2026-06-07 07:03:10.798851 2026-06-07 07:03:10.798852 1   International Results CSV 1 form://250/2004-10-13/5
57401 Andorra 250 2004-11-17 5 0.6 0.4 3.0     0.2 0.0 0.8   2026-06-07 07:03:10.813539 2026-06-07 07:03:10.813539 1   International Results CSV 1 form://250/2004-11-17/5
57854 Andorra 250 2005-02-09 5 0.8 0.4 2.2     0.2 0.2 0.6   2026-06-07 07:03:10.857747 2026-06-07 07:03:10.857748 1   International Results CSV 1 form://250/2005-02-09/5
57994 Andorra 250 2005-03-26 5 0.8 0.6 2.0     0.2 0.2 0.6   2026-06-07 07:03:10.871372 2026-06-07 07:03:10.871372 1   International Results CSV 1 form://250/2005-03-26/5
58089 Andorra 250 2005-03-30 5 0.8 0.4 1.8     0.2 0.2 0.6   2026-06-07 07:03:10.880739 2026-06-07 07:03:10.880739 1   International Results CSV 1 form://250/2005-03-30/5
58260 Andorra 250 2005-06-04 5 0.2 0.4 3.4     0.0 0.2 0.8   2026-06-07 07:03:10.897275 2026-06-07 07:03:10.897275 1   International Results CSV 1 form://250/2005-06-04/5
58702 Andorra 250 2005-08-17 5 0.2 0.4 3.2     0.0 0.2 0.8   2026-06-07 07:03:10.940227 2026-06-07 07:03:10.940227 1   International Results CSV 1 form://250/2005-08-17/5
58729 Andorra 250 2005-09-03 5 0.2 0.4 3.2     0.0 0.2 0.8   2026-06-07 07:03:10.942935 2026-06-07 07:03:10.942935 1   International Results CSV 1 form://250/2005-09-03/5
58868 Andorra 250 2005-09-07 5 0.2 0.2 3.6     0.0 0.2 0.8   2026-06-07 07:03:10.956438 2026-06-07 07:03:10.956439 1   International Results CSV 1 form://250/2005-09-07/5
59003 Andorra 250 2005-10-12 5 0.2 0.2 3.4     0.0 0.2 0.8   2026-06-07 07:03:10.969606 2026-06-07 07:03:10.969606 1   International Results CSV 1 form://250/2005-10-12/5
60158 Andorra 250 2006-08-16 5 0.2 0.0 2.4     0.0 0.2 0.8   2026-06-07 07:03:11.367295 2026-06-07 07:03:11.367295 1   International Results CSV 1 form://250/2006-08-16/5
60276 Andorra 250 2006-09-02 5 0.2 0.0 3.0     0.0 0.2 0.8   2026-06-07 07:03:11.378827 2026-06-07 07:03:11.378827 1   International Results CSV 1 form://250/2006-09-02/5
60398 Andorra 250 2006-09-06 5 0.0 0.2 3.8     0.0 0.0 1.0   2026-06-07 07:03:11.390674 2026-06-07 07:03:11.390674 1   International Results CSV 1 form://250/2006-09-06/5
60538 Andorra 250 2006-10-07 5 0.0 0.2 4.4     0.0 0.0 1.0   2026-06-07 07:03:11.404272 2026-06-07 07:03:11.404272 1   International Results CSV 1 form://250/2006-10-07/5
60627 Andorra 250 2006-10-11 5 0.0 0.2 4.4     0.0 0.0 1.0   2026-06-07 07:03:11.413008 2026-06-07 07:03:11.413008 1   International Results CSV 1 form://250/2006-10-11/5
61165 Andorra 250 2007-02-07 5 0.2 0.2 3.8     0.0 0.2 0.8   2026-06-07 07:03:11.465422 2026-06-07 07:03:11.465423 1   International Results CSV 1 form://250/2007-02-07/5
61403 Andorra 250 2007-03-28 5 0.2 0.2 3.4     0.0 0.2 0.8   2026-06-07 07:03:11.488876 2026-06-07 07:03:11.488876 1   International Results CSV 1 form://250/2007-03-28/5
61608 Andorra 250 2007-06-02 5 0.2 0.0 3.4     0.0 0.2 0.8   2026-06-07 07:03:11.509151 2026-06-07 07:03:11.509151 1   International Results CSV 1 form://250/2007-06-02/5
61667 Andorra 250 2007-06-06 5 0.2 0.0 2.4     0.0 0.2 0.8   2026-06-07 07:03:11.515155 2026-06-07 07:03:11.515155 1   International Results CSV 1 form://250/2007-06-06/5
62156 Andorra 250 2007-08-22 5 0.2 0.2 2.2     0.0 0.2 0.8   2026-06-07 07:03:11.563338 2026-06-07 07:03:11.563338 1   International Results CSV 1 form://250/2007-08-22/5
62397 Andorra 250 2007-09-12 5 0.0 0.2 3.4     0.0 0.0 1.0   2026-06-07 07:03:11.587181 2026-06-07 07:03:11.587181 1   International Results CSV 1 form://250/2007-09-12/5
62626 Andorra 250 2007-10-17 5 0.0 0.2 3.4     0.0 0.0 1.0   2026-06-07 07:03:11.609582 2026-06-07 07:03:11.609582 1   International Results CSV 1 form://250/2007-10-17/5
62729 Andorra 250 2007-11-17 5 0.0 0.2 3.0     0.0 0.0 1.0   2026-06-07 07:03:11.619737 2026-06-07 07:03:11.619738 1   International Results CSV 1 form://250/2007-11-17/5
62827 Andorra 250 2007-11-21 5 0.0 0.2 2.8     0.0 0.0 1.0   2026-06-07 07:03:11.629362 2026-06-07 07:03:11.629363 1   International Results CSV 1 form://250/2007-11-21/5
63319 Andorra 250 2008-03-26 5 0.0 0.0 3.0     0.0 0.0 1.0   2026-06-07 07:03:11.677291 2026-06-07 07:03:11.677292 1   International Results CSV 1 form://250/2008-03-26/5
63737 Andorra 250 2008-06-04 5 0.0 0.2 2.2     0.0 0.0 1.0   2026-06-07 07:03:11.717885 2026-06-07 07:03:11.717885 1   International Results CSV 1 form://250/2008-06-04/5
64328 Andorra 250 2008-08-20 5 0.0 0.2 2.2     0.0 0.0 1.0   2026-06-07 07:03:11.775303 2026-06-07 07:03:11.775303 1   International Results CSV 1 form://250/2008-08-20/5
64427 Andorra 250 2008-09-06 5 0.0 0.2 2.2     0.0 0.0 1.0   2026-06-07 07:03:11.785015 2026-06-07 07:03:11.785015 1   International Results CSV 1 form://250/2008-09-06/5
64555 Andorra 250 2008-09-10 5 0.0 0.4 2.6     0.0 0.0 1.0   2026-06-07 07:03:11.797467 2026-06-07 07:03:11.797467 1   International Results CSV 1 form://250/2008-09-10/5
64840 Andorra 250 2008-10-15 5 0.0 0.4 2.8     0.0 0.0 1.0   2026-06-07 07:03:11.825093 2026-06-07 07:03:11.825093 1   International Results CSV 1 form://250/2008-10-15/5
65377 Andorra 250 2009-02-11 5 0.0 0.4 3.0     0.0 0.0 1.0   2026-06-07 07:03:12.172582 2026-06-07 07:03:12.172583 1   International Results CSV 1 form://250/2009-02-11/5
65623 Andorra 250 2009-04-01 5 0.0 0.4 2.8     0.0 0.0 1.0   2026-06-07 07:03:12.196510 2026-06-07 07:03:12.196510 1   International Results CSV 1 form://250/2009-04-01/5
65822 Andorra 250 2009-06-06 5 0.0 0.6 3.4     0.0 0.0 1.0   2026-06-07 07:03:12.215805 2026-06-07 07:03:12.215805 1   International Results CSV 1 form://250/2009-06-06/5
65926 Andorra 250 2009-06-10 5 0.0 0.4 4.0     0.0 0.0 1.0   2026-06-07 07:03:12.225944 2026-06-07 07:03:12.225944 1   International Results CSV 1 form://250/2009-06-10/5
66424 Andorra 250 2009-09-05 5 0.0 0.4 4.2     0.0 0.0 1.0   2026-06-07 07:03:12.274871 2026-06-07 07:03:12.274871 1   International Results CSV 1 form://250/2009-09-05/5
66445 Andorra 250 2009-09-09 5 0.0 0.4 4.2     0.0 0.0 1.0   2026-06-07 07:03:12.277074 2026-06-07 07:03:12.277074 1   International Results CSV 1 form://250/2009-09-09/5
66641 Andorra 250 2009-10-14 5 0.0 0.4 5.0     0.0 0.0 1.0   2026-06-07 07:03:12.296538 2026-06-07 07:03:12.296539 1   International Results CSV 1 form://250/2009-10-14/5
67464 Andorra 250 2010-05-29 5 0.0 0.2 4.8     0.0 0.0 1.0   2026-06-07 07:03:12.377507 2026-06-07 07:03:12.377507 1   International Results CSV 1 form://250/2010-05-29/5
67521 Andorra 250 2010-06-02 5 0.0 0.2 3.8     0.0 0.0 1.0   2026-06-07 07:03:12.383130 2026-06-07 07:03:12.383131 1   International Results CSV 1 form://250/2010-06-02/5
67777 Andorra 250 2010-08-11 5 0.0 0.2 3.0     0.0 0.0 1.0   2026-06-07 07:03:12.408664 2026-06-07 07:03:12.408665 1   International Results CSV 1 form://250/2010-08-11/5
67874 Andorra 250 2010-09-03 5 0.0 0.0 2.8     0.0 0.0 1.0   2026-06-07 07:03:12.418605 2026-06-07 07:03:12.418606 1   International Results CSV 1 form://250/2010-09-03/5
68025 Andorra 250 2010-09-07 5 0.0 0.2 2.2     0.0 0.0 1.0   2026-06-07 07:03:12.433866 2026-06-07 07:03:12.433867 1   International Results CSV 1 form://250/2010-09-07/5
68175 Andorra 250 2010-10-08 5 0.0 0.2 1.8     0.0 0.0 1.0   2026-06-07 07:03:12.449359 2026-06-07 07:03:12.449359 1   International Results CSV 1 form://250/2010-10-08/5
68308 Andorra 250 2010-10-12 5 0.0 0.2 2.4     0.0 0.0 1.0   2026-06-07 07:03:12.462792 2026-06-07 07:03:12.462792 1   International Results CSV 1 form://250/2010-10-12/5
68920 Andorra 250 2011-02-09 5 0.0 0.4 2.6     0.0 0.0 1.0   2026-06-07 07:03:12.525022 2026-06-07 07:03:12.525022 1   International Results CSV 1 form://250/2011-02-09/5
69096 Andorra 250 2011-03-26 5 0.0 0.4 2.4     0.0 0.0 1.0   2026-06-07 07:03:12.542874 2026-06-07 07:03:12.542875 1   International Results CSV 1 form://250/2011-03-26/5
69407 Andorra 250 2011-06-04 5 0.0 0.2 2.0     0.0 0.0 1.0   2026-06-07 07:03:12.574245 2026-06-07 07:03:12.574245 1   International Results CSV 1 form://250/2011-06-04/5
70038 Andorra 250 2011-09-02 5 0.0 0.2 2.2     0.0 0.0 1.0   2026-06-07 07:03:12.934585 2026-06-07 07:03:12.934585 1   International Results CSV 1 form://250/2011-09-02/5
70275 Andorra 250 2011-09-06 5 0.0 0.2 1.6     0.0 0.0 1.0   2026-06-07 07:03:12.957866 2026-06-07 07:03:12.957867 1   International Results CSV 1 form://250/2011-09-06/5

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Queries took 1297.183ms