home / football

form_record

854 rows where team_id = 803

✎ 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
100455 Sampdoria 803 1995-08-27 5 1.0 1.0 1.0     0.0 1.0 0.0   2026-06-11 10:24:16.762188 2026-06-11 10:24:16.762188     International Results CSV 1 form://803/1995-08-27/5
100590 Sampdoria 803 1995-09-10 5 1.0 0.5 0.5     0.0 1.0 0.0   2026-06-11 10:24:16.763269 2026-06-11 10:24:16.763269     International Results CSV 1 form://803/1995-09-10/5
100670 Sampdoria 803 1995-09-17 5 1.6666666666666667 1.3333333333333333 0.3333333333333333     0.3333333333333333 0.6666666666666666 0.0   2026-06-11 10:24:16.763820 2026-06-11 10:24:16.763820     International Results CSV 1 form://803/1995-09-17/5
100750 Sampdoria 803 1995-09-24 5 1.5 1.25 0.5     0.25 0.75 0.0   2026-06-11 10:24:16.764409 2026-06-11 10:24:16.764409     International Results CSV 1 form://803/1995-09-24/5
100824 Sampdoria 803 1995-10-01 5 1.2 1.2 0.8     0.2 0.6 0.2   2026-06-11 10:24:16.764955 2026-06-11 10:24:16.764956     International Results CSV 1 form://803/1995-10-01/5
100967 Sampdoria 803 1995-10-15 5 1.0 1.4 1.2     0.2 0.4 0.4   2026-06-11 10:24:16.766157 2026-06-11 10:24:16.766157     International Results CSV 1 form://803/1995-10-15/5
101021 Sampdoria 803 1995-10-22 5 1.4 1.8 1.4     0.4 0.2 0.4   2026-06-11 10:24:16.766605 2026-06-11 10:24:16.766605     International Results CSV 1 form://803/1995-10-22/5
101119 Sampdoria 803 1995-10-29 5 1.0 1.4 1.6     0.2 0.4 0.4   2026-06-11 10:24:16.767347 2026-06-11 10:24:16.767347     International Results CSV 1 form://803/1995-10-29/5
101199 Sampdoria 803 1995-11-05 5 1.0 1.2 1.4     0.2 0.4 0.4   2026-06-11 10:24:16.767953 2026-06-11 10:24:16.767953     International Results CSV 1 form://803/1995-11-05/5
101289 Sampdoria 803 1995-11-19 5 1.0 1.4 1.6     0.2 0.4 0.4   2026-06-11 10:24:16.768834 2026-06-11 10:24:16.768834     International Results CSV 1 form://803/1995-11-19/5
101379 Sampdoria 803 1995-11-26 5 1.6 1.2 1.0     0.4 0.4 0.2   2026-06-11 10:24:16.769588 2026-06-11 10:24:16.769588     International Results CSV 1 form://803/1995-11-26/5
101460 Sampdoria 803 1995-12-03 5 1.6 1.4 1.0     0.4 0.4 0.2   2026-06-11 10:24:16.770335 2026-06-11 10:24:16.770335     International Results CSV 1 form://803/1995-12-03/5
101542 Sampdoria 803 1995-12-10 5 2.0 1.6 0.8     0.6 0.2 0.2   2026-06-11 10:24:16.771061 2026-06-11 10:24:16.771061     International Results CSV 1 form://803/1995-12-10/5
101597 Sampdoria 803 1995-12-17 5 1.8 2.2 2.0     0.6 0.0 0.4   2026-06-11 10:24:16.771550 2026-06-11 10:24:16.771550     International Results CSV 1 form://803/1995-12-17/5
101659 Sampdoria 803 1995-12-23 5 2.0 2.2 1.8     0.6 0.2 0.2   2026-06-11 10:24:16.772049 2026-06-11 10:24:16.772049     International Results CSV 1 form://803/1995-12-23/5
101766 Sampdoria 803 1996-01-07 5 1.4 2.0 2.4     0.4 0.2 0.4   2026-06-11 10:24:16.772906 2026-06-11 10:24:16.772907     International Results CSV 1 form://803/1996-01-07/5
101852 Sampdoria 803 1996-01-14 5 1.0 1.8 2.6     0.2 0.4 0.4   2026-06-11 10:24:16.773614 2026-06-11 10:24:16.773614     International Results CSV 1 form://803/1996-01-14/5
101885 Sampdoria 803 1996-01-21 5 0.4 1.6 3.2     0.0 0.4 0.6   2026-06-11 10:24:16.773958 2026-06-11 10:24:16.773958     International Results CSV 1 form://803/1996-01-21/5
101946 Sampdoria 803 1996-01-28 5 1.0 1.4 2.0     0.2 0.4 0.4   2026-06-11 10:24:16.774488 2026-06-11 10:24:16.774488     International Results CSV 1 form://803/1996-01-28/5
102017 Sampdoria 803 1996-02-04 5 0.8 1.0 1.8     0.2 0.2 0.6   2026-06-11 10:24:16.775089 2026-06-11 10:24:16.775089     International Results CSV 1 form://803/1996-02-04/5
102074 Sampdoria 803 1996-02-11 5 1.4 1.2 1.2     0.4 0.2 0.4   2026-06-11 10:24:16.775594 2026-06-11 10:24:16.775594     International Results CSV 1 form://803/1996-02-11/5
102126 Sampdoria 803 1996-02-18 5 1.2 0.8 1.4     0.4 0.0 0.6   2026-06-11 10:24:16.776011 2026-06-11 10:24:16.776011     International Results CSV 1 form://803/1996-02-18/5
102229 Sampdoria 803 1996-02-25 5 1.8 1.2 0.8     0.6 0.0 0.4   2026-06-11 10:24:16.776829 2026-06-11 10:24:16.776829     International Results CSV 1 form://803/1996-02-25/5
102289 Sampdoria 803 1996-03-03 5 1.4 1.2 1.2     0.4 0.2 0.4   2026-06-11 10:24:16.777296 2026-06-11 10:24:16.777296     International Results CSV 1 form://803/1996-03-03/5
102379 Sampdoria 803 1996-03-10 5 2.0 1.8 1.2     0.6 0.2 0.2   2026-06-11 10:24:16.777986 2026-06-11 10:24:16.777986     International Results CSV 1 form://803/1996-03-10/5
102506 Sampdoria 803 1996-03-24 5 1.4 2.0 1.8     0.4 0.2 0.4   2026-06-11 10:24:16.778992 2026-06-11 10:24:16.778992     International Results CSV 1 form://803/1996-03-24/5
102599 Sampdoria 803 1996-03-31 5 2.0 2.8 1.6     0.6 0.2 0.2   2026-06-11 10:24:16.779824 2026-06-11 10:24:16.779824     International Results CSV 1 form://803/1996-03-31/5
102651 Sampdoria 803 1996-04-06 5 2.0 2.6 1.6     0.6 0.2 0.2   2026-06-11 10:24:16.780206 2026-06-11 10:24:16.780206     International Results CSV 1 form://803/1996-04-06/5
102757 Sampdoria 803 1996-04-10 5 2.4 2.6 1.2     0.8 0.0 0.2   2026-06-11 10:24:16.780982 2026-06-11 10:24:16.780982     International Results CSV 1 form://803/1996-04-10/5
102810 Sampdoria 803 1996-04-14 5 2.4 2.6 1.0     0.8 0.0 0.2   2026-06-11 10:24:16.781373 2026-06-11 10:24:16.781373     International Results CSV 1 form://803/1996-04-14/5
102884 Sampdoria 803 1996-04-21 5 2.6 2.8 1.0     0.8 0.2 0.0   2026-06-11 10:24:16.781944 2026-06-11 10:24:16.781944     International Results CSV 1 form://803/1996-04-21/5
102960 Sampdoria 803 1996-04-28 5 2.0 2.0 0.8     0.6 0.2 0.2   2026-06-11 10:24:16.782671 2026-06-11 10:24:16.782671     International Results CSV 1 form://803/1996-04-28/5
103062 Sampdoria 803 1996-05-05 5 2.0 2.2 0.8     0.6 0.2 0.2   2026-06-11 10:24:16.783460 2026-06-11 10:24:16.783461     International Results CSV 1 form://803/1996-05-05/5
103148 Sampdoria 803 1996-05-12 5 1.6 2.2 1.2     0.4 0.4 0.2   2026-06-11 10:24:16.784161 2026-06-11 10:24:16.784162     International Results CSV 1 form://803/1996-05-12/5
103435 Sampdoria 803 1996-09-08 5 1.0 1.6 1.4     0.2 0.4 0.4   2026-06-11 10:24:16.788067 2026-06-11 10:24:16.788067     International Results CSV 1 form://803/1996-09-08/5
103505 Sampdoria 803 1996-09-15 5 1.4 1.4 1.0     0.4 0.2 0.4   2026-06-11 10:24:16.788667 2026-06-11 10:24:16.788667     International Results CSV 1 form://803/1996-09-15/5
103595 Sampdoria 803 1996-09-22 5 2.0 2.2 1.0     0.6 0.2 0.2   2026-06-11 10:24:17.381432 2026-06-11 10:24:17.381432     International Results CSV 1 form://803/1996-09-22/5
103663 Sampdoria 803 1996-09-29 5 1.4 1.6 1.2     0.4 0.2 0.4   2026-06-11 10:24:17.390829 2026-06-11 10:24:17.390830     International Results CSV 1 form://803/1996-09-29/5
103779 Sampdoria 803 1996-10-13 5 1.2 1.4 1.2     0.4 0.0 0.6   2026-06-11 10:24:17.411494 2026-06-11 10:24:17.411494     International Results CSV 1 form://803/1996-10-13/5
103867 Sampdoria 803 1996-10-20 5 1.8 1.8 1.0     0.6 0.0 0.4   2026-06-11 10:24:17.421581 2026-06-11 10:24:17.421581     International Results CSV 1 form://803/1996-10-20/5
103978 Sampdoria 803 1996-10-27 5 1.4 1.6 1.0     0.4 0.2 0.4   2026-06-11 10:24:17.434174 2026-06-11 10:24:17.434174     International Results CSV 1 form://803/1996-10-27/5
104049 Sampdoria 803 1996-11-03 5 1.4 1.4 0.8     0.4 0.2 0.4   2026-06-11 10:24:17.442932 2026-06-11 10:24:17.442933     International Results CSV 1 form://803/1996-11-03/5
104134 Sampdoria 803 1996-11-17 5 1.6 1.6 0.8     0.4 0.4 0.2   2026-06-11 10:24:17.460863 2026-06-11 10:24:17.460864     International Results CSV 1 form://803/1996-11-17/5
104206 Sampdoria 803 1996-11-24 5 1.8 1.6 0.6     0.4 0.6 0.0   2026-06-11 10:24:17.471023 2026-06-11 10:24:17.471023     International Results CSV 1 form://803/1996-11-24/5
104286 Sampdoria 803 1996-12-01 5 1.4 1.4 0.8     0.2 0.8 0.0   2026-06-11 10:24:17.480347 2026-06-11 10:24:17.480347     International Results CSV 1 form://803/1996-12-01/5
104364 Sampdoria 803 1996-12-08 5 1.2 1.2 0.8     0.2 0.6 0.2   2026-06-11 10:24:17.490011 2026-06-11 10:24:17.490011     International Results CSV 1 form://803/1996-12-08/5
104415 Sampdoria 803 1996-12-15 5 1.2 1.4 1.4     0.2 0.6 0.2   2026-06-11 10:24:17.500182 2026-06-11 10:24:17.500182     International Results CSV 1 form://803/1996-12-15/5
104479 Sampdoria 803 1996-12-22 5 1.6 1.6 1.4     0.4 0.4 0.2   2026-06-11 10:24:17.508674 2026-06-11 10:24:17.508674     International Results CSV 1 form://803/1996-12-22/5
104551 Sampdoria 803 1997-01-05 5 2.0 2.4 2.0     0.6 0.2 0.2   2026-06-11 10:24:17.516903 2026-06-11 10:24:17.516903     International Results CSV 1 form://803/1997-01-05/5
104601 Sampdoria 803 1997-01-12 5 2.4 3.0 2.0     0.8 0.0 0.2   2026-06-11 10:24:17.524982 2026-06-11 10:24:17.524983     International Results CSV 1 form://803/1997-01-12/5
104649 Sampdoria 803 1997-01-19 5 2.6 3.2 2.0     0.8 0.2 0.0   2026-06-11 10:24:17.530608 2026-06-11 10:24:17.530608     International Results CSV 1 form://803/1997-01-19/5
104699 Sampdoria 803 1997-01-26 5 2.6 3.4 1.8     0.8 0.2 0.0   2026-06-11 10:24:17.538842 2026-06-11 10:24:17.538842     International Results CSV 1 form://803/1997-01-26/5
104771 Sampdoria 803 1997-02-02 5 2.6 3.6 2.0     0.8 0.2 0.0   2026-06-11 10:24:17.546183 2026-06-11 10:24:17.546184     International Results CSV 1 form://803/1997-02-02/5
104850 Sampdoria 803 1997-02-16 5 2.0 2.8 1.6     0.6 0.2 0.2   2026-06-11 10:24:17.558763 2026-06-11 10:24:17.558763     International Results CSV 1 form://803/1997-02-16/5
104955 Sampdoria 803 1997-02-23 5 1.6 2.2 1.6     0.4 0.4 0.2   2026-06-11 10:24:17.573584 2026-06-11 10:24:17.573584     International Results CSV 1 form://803/1997-02-23/5
105041 Sampdoria 803 1997-03-02 5 1.4 2.2 1.8     0.4 0.2 0.4   2026-06-11 10:24:17.585153 2026-06-11 10:24:17.585154     International Results CSV 1 form://803/1997-03-02/5
105113 Sampdoria 803 1997-03-09 5 0.8 1.2 2.2     0.2 0.2 0.6   2026-06-11 10:24:17.592843 2026-06-11 10:24:17.592843     International Results CSV 1 form://803/1997-03-09/5
105247 Sampdoria 803 1997-03-16 5 0.8 1.2 1.8     0.2 0.2 0.6   2026-06-11 10:24:17.608021 2026-06-11 10:24:17.608022     International Results CSV 1 form://803/1997-03-16/5
105326 Sampdoria 803 1997-03-23 5 1.0 1.4 1.8     0.2 0.4 0.4   2026-06-11 10:24:17.618045 2026-06-11 10:24:17.618045     International Results CSV 1 form://803/1997-03-23/5
105421 Sampdoria 803 1997-04-06 5 0.8 1.2 2.2     0.2 0.2 0.6   2026-06-11 10:24:17.640046 2026-06-11 10:24:17.640046     International Results CSV 1 form://803/1997-04-06/5
105511 Sampdoria 803 1997-04-13 5 1.4 1.2 1.8     0.4 0.2 0.4   2026-06-11 10:24:17.650587 2026-06-11 10:24:17.650587     International Results CSV 1 form://803/1997-04-13/5
105615 Sampdoria 803 1997-04-20 5 1.6 1.2 1.0     0.4 0.4 0.2   2026-06-11 10:24:17.662620 2026-06-11 10:24:17.662620     International Results CSV 1 form://803/1997-04-20/5
105723 Sampdoria 803 1997-05-04 5 1.2 0.6 1.0     0.2 0.6 0.2   2026-06-11 10:24:17.683262 2026-06-11 10:24:17.683263     International Results CSV 1 form://803/1997-05-04/5
105833 Sampdoria 803 1997-05-11 5 1.0 0.4 1.0     0.2 0.4 0.4   2026-06-11 10:24:17.695668 2026-06-11 10:24:17.695668     International Results CSV 1 form://803/1997-05-11/5
105857 Sampdoria 803 1997-05-15 5 1.2 0.6 0.6     0.2 0.6 0.2   2026-06-11 10:24:17.698561 2026-06-11 10:24:17.698561     International Results CSV 1 form://803/1997-05-15/5
105885 Sampdoria 803 1997-05-18 5 1.2 1.2 0.6     0.2 0.6 0.2   2026-06-11 10:24:17.702211 2026-06-11 10:24:17.702212     International Results CSV 1 form://803/1997-05-18/5
105943 Sampdoria 803 1997-05-25 5 1.6 2.0 1.2     0.4 0.4 0.2   2026-06-11 10:24:17.709615 2026-06-11 10:24:17.709616     International Results CSV 1 form://803/1997-05-25/5
106000 Sampdoria 803 1997-06-01 5 1.6 2.2 1.4     0.4 0.4 0.2   2026-06-11 10:24:17.718239 2026-06-11 10:24:17.718239     International Results CSV 1 form://803/1997-06-01/5
106277 Sampdoria 803 1997-08-31 5 2.2 2.4 1.2     0.6 0.4 0.0   2026-06-11 10:24:17.793714 2026-06-11 10:24:17.793714     International Results CSV 1 form://803/1997-08-31/5
106346 Sampdoria 803 1997-09-13 5 2.2 2.8 1.6     0.6 0.4 0.0   2026-06-11 10:24:17.810552 2026-06-11 10:24:17.810553     International Results CSV 1 form://803/1997-09-13/5
106417 Sampdoria 803 1997-09-21 5 2.2 2.4 1.6     0.6 0.4 0.0   2026-06-11 10:24:17.819347 2026-06-11 10:24:17.819347     International Results CSV 1 form://803/1997-09-21/5
106471 Sampdoria 803 1997-09-27 5 1.8 1.8 1.2     0.4 0.6 0.0   2026-06-11 10:24:17.826849 2026-06-11 10:24:17.826849     International Results CSV 1 form://803/1997-09-27/5
106578 Sampdoria 803 1997-10-05 5 1.6 2.0 1.6     0.4 0.4 0.2   2026-06-11 10:24:17.840304 2026-06-11 10:24:17.840304     International Results CSV 1 form://803/1997-10-05/5
106711 Sampdoria 803 1997-10-19 5 1.6 2.2 1.6     0.4 0.4 0.2   2026-06-11 10:24:17.864320 2026-06-11 10:24:17.864320     International Results CSV 1 form://803/1997-10-19/5
106825 Sampdoria 803 1997-11-02 5 1.4 1.6 1.6     0.4 0.2 0.4   2026-06-11 10:24:17.879375 2026-06-11 10:24:17.879375     International Results CSV 1 form://803/1997-11-02/5
106891 Sampdoria 803 1997-11-09 5 0.8 1.2 2.2     0.2 0.2 0.6   2026-06-11 10:24:17.887289 2026-06-11 10:24:17.887289     International Results CSV 1 form://803/1997-11-09/5
107030 Sampdoria 803 1997-11-23 5 1.2 1.2 2.0     0.4 0.0 0.6   2026-06-11 10:24:17.904853 2026-06-11 10:24:17.904854     International Results CSV 1 form://803/1997-11-23/5
107099 Sampdoria 803 1997-11-30 5 1.4 1.2 1.8     0.4 0.2 0.4   2026-06-11 10:24:17.913078 2026-06-11 10:24:17.913078     International Results CSV 1 form://803/1997-11-30/5
107165 Sampdoria 803 1997-12-06 5 1.0 0.8 1.8     0.2 0.4 0.4   2026-06-11 10:24:17.921128 2026-06-11 10:24:17.921129     International Results CSV 1 form://803/1997-12-06/5
107251 Sampdoria 803 1997-12-14 5 1.0 1.0 2.0     0.2 0.4 0.4   2026-06-11 10:24:17.930779 2026-06-11 10:24:17.930779     International Results CSV 1 form://803/1997-12-14/5
107344 Sampdoria 803 1997-12-21 5 1.6 2.2 2.0     0.4 0.4 0.2   2026-06-11 10:24:17.942783 2026-06-11 10:24:17.942784     International Results CSV 1 form://803/1997-12-21/5
107420 Sampdoria 803 1998-01-04 5 1.2 2.2 2.2     0.2 0.6 0.2   2026-06-11 10:24:17.952080 2026-06-11 10:24:17.952080     International Results CSV 1 form://803/1998-01-04/5
107481 Sampdoria 803 1998-01-11 5 1.6 2.8 2.2     0.4 0.4 0.2   2026-06-11 10:24:17.959032 2026-06-11 10:24:17.959032     International Results CSV 1 form://803/1998-01-11/5
107537 Sampdoria 803 1998-01-18 5 2.0 3.2 2.2     0.6 0.2 0.2   2026-06-11 10:24:17.965282 2026-06-11 10:24:17.965282     International Results CSV 1 form://803/1998-01-18/5
107577 Sampdoria 803 1998-01-25 5 2.2 3.2 1.6     0.6 0.4 0.0   2026-06-11 10:24:17.970789 2026-06-11 10:24:17.970790     International Results CSV 1 form://803/1998-01-25/5
107670 Sampdoria 803 1998-02-01 5 1.8 2.2 1.2     0.4 0.6 0.0   2026-06-11 10:24:17.983626 2026-06-11 10:24:17.983627     International Results CSV 1 form://803/1998-02-01/5
107744 Sampdoria 803 1998-02-08 5 2.2 2.4 1.2     0.6 0.4 0.0   2026-06-11 10:24:17.995647 2026-06-11 10:24:17.995647     International Results CSV 1 form://803/1998-02-08/5
107758 Sampdoria 803 1998-02-11 5 2.2 1.8 0.8     0.6 0.4 0.0   2026-06-11 10:24:17.999741 2026-06-11 10:24:17.999741     International Results CSV 1 form://803/1998-02-11/5
107806 Sampdoria 803 1998-02-15 5 1.6 1.2 1.2     0.4 0.4 0.2   2026-06-11 10:24:18.006336 2026-06-11 10:24:18.006336     International Results CSV 1 form://803/1998-02-15/5
107863 Sampdoria 803 1998-02-22 5 1.4 1.0 1.6     0.4 0.2 0.4   2026-06-11 10:24:18.015159 2026-06-11 10:24:18.015160     International Results CSV 1 form://803/1998-02-22/5
107955 Sampdoria 803 1998-03-01 5 1.2 0.8 1.6     0.4 0.0 0.6   2026-06-11 10:24:18.026160 2026-06-11 10:24:18.026160     International Results CSV 1 form://803/1998-03-01/5
107998 Sampdoria 803 1998-03-08 5 0.6 0.4 1.6     0.2 0.0 0.8   2026-06-11 10:24:18.032736 2026-06-11 10:24:18.032736     International Results CSV 1 form://803/1998-03-08/5
108052 Sampdoria 803 1998-03-14 5 0.0 0.0 2.4     0.0 0.0 1.0   2026-06-11 10:24:18.039193 2026-06-11 10:24:18.039193     International Results CSV 1 form://803/1998-03-14/5
108135 Sampdoria 803 1998-03-22 5 0.6 0.2 1.8     0.2 0.0 0.8   2026-06-11 10:24:18.049267 2026-06-11 10:24:18.049267     International Results CSV 1 form://803/1998-03-22/5
108212 Sampdoria 803 1998-03-29 5 0.6 0.6 1.8     0.2 0.0 0.8   2026-06-11 10:24:18.060123 2026-06-11 10:24:18.060124     International Results CSV 1 form://803/1998-03-29/5
108308 Sampdoria 803 1998-04-05 5 0.6 0.6 2.2     0.2 0.0 0.8   2026-06-11 10:24:18.070783 2026-06-11 10:24:18.070783     International Results CSV 1 form://803/1998-04-05/5
108333 Sampdoria 803 1998-04-11 5 1.2 1.2 2.0     0.4 0.0 0.6   2026-06-11 10:24:18.073442 2026-06-11 10:24:18.073442     International Results CSV 1 form://803/1998-04-11/5
108453 Sampdoria 803 1998-04-19 5 1.8 1.6 1.2     0.6 0.0 0.4   2026-06-11 10:24:18.086745 2026-06-11 10:24:18.086745     International Results CSV 1 form://803/1998-04-19/5
108522 Sampdoria 803 1998-04-26 5 1.8 1.8 1.2     0.6 0.0 0.4   2026-06-11 10:24:18.097623 2026-06-11 10:24:18.097624     International Results CSV 1 form://803/1998-04-26/5
108619 Sampdoria 803 1998-05-03 5 2.0 1.8 1.0     0.6 0.2 0.2   2026-06-11 10:24:18.492193 2026-06-11 10:24:18.492193     International Results CSV 1 form://803/1998-05-03/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 1383.931ms