home / football

form_record

892 rows where team_id = 387

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pts_avg, gf_avg, win_pct, draw_pct, loss_pct, created_by_run_id, source_id, 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
49102 AS Monaco 387 2000-06-11 5 0.0 0.0 5.0     0.0 0.0 1.0   2026-06-07 07:03:09.442835 2026-06-07 07:03:09.442835 1   International Results CSV 1 form://260/2000-06-11/5
51445 AS Monaco 387 2001-07-14 5 1.5 1.0 3.0     0.5 0.0 0.5   2026-06-07 07:03:09.950753 2026-06-07 07:03:09.950753 1   International Results CSV 1 form://260/2001-07-14/5
52416 AS Monaco 387 2002-02-18 5 1.3333333333333333 1.3333333333333333 2.6666666666666665     0.3333333333333333 0.3333333333333333 0.3333333333333333   2026-06-07 07:03:10.046575 2026-06-07 07:03:10.046575 1   International Results CSV 1 form://260/2002-02-18/5
53479 AS Monaco 387 2002-11-23 5 1.25 1.0 2.0     0.25 0.5 0.25   2026-06-07 07:03:10.150368 2026-06-07 07:03:10.150368 1   International Results CSV 1 form://260/2002-11-23/5
57884 AS Monaco 387 2005-02-12 5 1.2 0.8 1.6     0.2 0.6 0.2   2026-06-07 07:03:10.860657 2026-06-07 07:03:10.860657 1   International Results CSV 1 form://260/2005-02-12/5
58177 AS Monaco 387 2005-05-17 5 1.4 1.0 0.8     0.2 0.8 0.0   2026-06-07 07:03:10.889291 2026-06-07 07:03:10.889291 1   International Results CSV 1 form://260/2005-05-17/5
58194 AS Monaco 387 2005-05-27 5 0.8 0.6 1.4     0.0 0.8 0.2   2026-06-07 07:03:10.890848 2026-06-07 07:03:10.890848 1   International Results CSV 1 form://260/2005-05-27/5
59296 AS Monaco 387 2005-12-17 5 1.2 0.6 1.2     0.2 0.6 0.2   2026-06-07 07:03:10.998182 2026-06-07 07:03:10.998182 1   International Results CSV 1 form://260/2005-12-17/5
59485 AS Monaco 387 2006-02-18 5 1.6 3.2 1.4     0.4 0.4 0.2   2026-06-07 07:03:11.016663 2026-06-07 07:03:11.016663 1   International Results CSV 1 form://260/2006-02-18/5
59698 AS Monaco 387 2006-04-22 5 1.4 3.4 2.8     0.4 0.2 0.4   2026-06-07 07:03:11.037288 2026-06-07 07:03:11.037288 1   International Results CSV 1 form://260/2006-04-22/5
60859 AS Monaco 387 2006-11-20 5 1.8 3.8 2.6     0.6 0.0 0.4   2026-06-07 07:03:11.435661 2026-06-07 07:03:11.435661 1   International Results CSV 1 form://260/2006-11-20/5
60876 AS Monaco 387 2006-11-21 5 2.4 4.4 2.2     0.8 0.0 0.2   2026-06-07 07:03:11.437222 2026-06-07 07:03:11.437222 1   International Results CSV 1 form://260/2006-11-21/5
60890 AS Monaco 387 2006-11-23 5 1.8 4.0 4.8     0.6 0.0 0.4   2026-06-07 07:03:11.438574 2026-06-07 07:03:11.438574 1   International Results CSV 1 form://260/2006-11-23/5
60902 AS Monaco 387 2006-11-24 5 1.2 1.6 8.8     0.4 0.0 0.6   2026-06-07 07:03:11.439740 2026-06-07 07:03:11.439740 1   International Results CSV 1 form://260/2006-11-24/5
64962 AS Monaco 387 2008-11-08 5 1.4 1.8 7.8     0.4 0.2 0.4   2026-06-07 07:03:11.837041 2026-06-07 07:03:11.837041 1   International Results CSV 1 form://260/2008-11-08/5
65163 AS Monaco 387 2008-12-20 5 0.8 1.6 8.4     0.2 0.2 0.6   2026-06-07 07:03:12.151755 2026-06-07 07:03:12.151756 1   International Results CSV 1 form://260/2008-12-20/5
67352 AS Monaco 387 2010-04-03 5 0.2 1.2 9.0     0.0 0.2 0.8   2026-06-07 07:03:12.366513 2026-06-07 07:03:12.366513 1   International Results CSV 1 form://260/2010-04-03/5
69278 AS Monaco 387 2011-05-07 5 0.8 1.6 6.4     0.2 0.2 0.6   2026-06-07 07:03:12.561323 2026-06-07 07:03:12.561323 1   International Results CSV 1 form://260/2011-05-07/5
71796 AS Monaco 387 2012-06-10 5 0.8 1.6 2.6     0.2 0.2 0.6   2026-06-07 07:03:13.106756 2026-06-07 07:03:13.106757 1   International Results CSV 1 form://260/2012-06-10/5
73343 AS Monaco 387 2013-02-13 5 0.6 1.4 3.4     0.2 0.0 0.8   2026-06-07 07:03:13.257656 2026-06-07 07:03:13.257656 1   International Results CSV 1 form://260/2013-02-13/5
73974 AS Monaco 387 2013-06-22 5 1.2 1.4 2.8     0.4 0.0 0.6   2026-06-07 07:03:13.319007 2026-06-07 07:03:13.319007 1   International Results CSV 1 form://260/2013-06-22/5
75167 AS Monaco 387 2014-04-06 5 1.2 1.2 3.8     0.4 0.0 0.6   2026-06-07 07:03:13.733539 2026-06-07 07:03:13.733539 1   International Results CSV 1 form://260/2014-04-06/5
75189 AS Monaco 387 2014-05-10 5 1.2 1.2 3.6     0.4 0.0 0.6   2026-06-07 07:03:13.735781 2026-06-07 07:03:13.735781 1   International Results CSV 1 form://260/2014-05-10/5
81015 AS Monaco 387 2017-04-29 5 1.4 1.0 3.2     0.4 0.2 0.4   2026-06-07 07:03:14.626875 2026-06-07 07:03:14.626875 1   International Results CSV 1 form://260/2017-04-29/5
108760 AS Monaco 387 1998-08-07 5 3.0 2.0 1.0     1.0 0.0 0.0   2026-06-11 10:24:18.542932 2026-06-11 10:24:18.542933     International Results CSV 1 form://387/1998-08-07/5
108789 AS Monaco 387 1998-08-15 5 3.0 3.0 1.0     1.0 0.0 0.0   2026-06-11 10:24:18.548542 2026-06-11 10:24:18.548542     International Results CSV 1 form://387/1998-08-15/5
108852 AS Monaco 387 1998-08-22 5 2.3333333333333335 2.0 0.6666666666666666     0.6666666666666666 0.3333333333333333 0.0   2026-06-11 10:24:18.558273 2026-06-11 10:24:18.558273     International Results CSV 1 form://387/1998-08-22/5
108892 AS Monaco 387 1998-08-29 5 2.0 1.75 0.75     0.5 0.5 0.0   2026-06-11 10:24:18.563899 2026-06-11 10:24:18.563899     International Results CSV 1 form://387/1998-08-29/5
109001 AS Monaco 387 1998-09-12 5 2.2 1.8 0.6     0.6 0.4 0.0   2026-06-11 10:24:18.585155 2026-06-11 10:24:18.585155     International Results CSV 1 form://387/1998-09-12/5
109123 AS Monaco 387 1998-09-20 5 1.6 1.4 0.6     0.4 0.4 0.2   2026-06-11 10:24:18.598426 2026-06-11 10:24:18.598426     International Results CSV 1 form://387/1998-09-20/5
109177 AS Monaco 387 1998-09-25 5 1.6 1.2 0.4     0.4 0.4 0.2   2026-06-11 10:24:18.605208 2026-06-11 10:24:18.605208     International Results CSV 1 form://387/1998-09-25/5
109276 AS Monaco 387 1998-10-03 5 1.4 1.4 0.8     0.4 0.2 0.4   2026-06-11 10:24:18.618183 2026-06-11 10:24:18.618183     International Results CSV 1 form://387/1998-10-03/5
109363 AS Monaco 387 1998-10-17 5 1.8 1.6 0.6     0.6 0.0 0.4   2026-06-11 10:24:18.636446 2026-06-11 10:24:18.636446     International Results CSV 1 form://387/1998-10-17/5
109456 AS Monaco 387 1998-10-24 5 1.2 1.2 0.8     0.4 0.0 0.6   2026-06-11 10:24:18.646421 2026-06-11 10:24:18.646421     International Results CSV 1 form://387/1998-10-24/5
109539 AS Monaco 387 1998-10-29 5 1.8 1.8 0.8     0.6 0.0 0.4   2026-06-11 10:24:18.654547 2026-06-11 10:24:18.654547     International Results CSV 1 form://387/1998-10-29/5
109626 AS Monaco 387 1998-11-06 5 1.2 1.2 1.0     0.4 0.0 0.6   2026-06-11 10:24:18.664673 2026-06-11 10:24:18.664673     International Results CSV 1 form://387/1998-11-06/5
109729 AS Monaco 387 1998-11-11 5 1.8 1.6 1.0     0.6 0.0 0.4   2026-06-11 10:24:18.675708 2026-06-11 10:24:18.675708     International Results CSV 1 form://387/1998-11-11/5
109752 AS Monaco 387 1998-11-14 5 1.2 1.4 1.6     0.4 0.0 0.6   2026-06-11 10:24:18.678100 2026-06-11 10:24:18.678100     International Results CSV 1 form://387/1998-11-14/5
109842 AS Monaco 387 1998-11-19 5 1.2 1.4 1.8     0.4 0.0 0.6   2026-06-11 10:24:18.690419 2026-06-11 10:24:18.690420     International Results CSV 1 form://387/1998-11-19/5
109951 AS Monaco 387 1998-11-28 5 0.8 1.0 1.8     0.2 0.2 0.6   2026-06-11 10:24:18.701783 2026-06-11 10:24:18.701783     International Results CSV 1 form://387/1998-11-28/5
110031 AS Monaco 387 1998-12-03 5 1.4 1.6 1.6     0.4 0.2 0.4   2026-06-11 10:24:18.712238 2026-06-11 10:24:18.712238     International Results CSV 1 form://387/1998-12-03/5
110220 AS Monaco 387 1998-12-16 5 1.0 1.2 1.4     0.2 0.4 0.4   2026-06-11 10:24:18.737068 2026-06-11 10:24:18.737068     International Results CSV 1 form://387/1998-12-16/5
110246 AS Monaco 387 1998-12-19 5 1.0 1.0 1.0     0.2 0.4 0.4   2026-06-11 10:24:18.739827 2026-06-11 10:24:18.739827     International Results CSV 1 form://387/1998-12-19/5
110463 AS Monaco 387 1999-01-16 5 1.2 1.2 0.8     0.2 0.6 0.2   2026-06-11 10:24:18.762813 2026-06-11 10:24:18.762813     International Results CSV 1 form://387/1999-01-16/5
110572 AS Monaco 387 1999-01-29 5 1.6 1.4 0.8     0.4 0.4 0.2   2026-06-11 10:24:18.776973 2026-06-11 10:24:18.776973     International Results CSV 1 form://387/1999-01-29/5
110645 AS Monaco 387 1999-02-06 5 1.6 1.2 1.0     0.4 0.4 0.2   2026-06-11 10:24:18.785878 2026-06-11 10:24:18.785879     International Results CSV 1 form://387/1999-02-06/5
110726 AS Monaco 387 1999-02-13 5 2.0 1.8 1.2     0.6 0.2 0.2   2026-06-11 10:24:18.797435 2026-06-11 10:24:18.797435     International Results CSV 1 form://387/1999-02-13/5
110857 AS Monaco 387 1999-02-25 5 2.6 2.4 1.4     0.8 0.2 0.0   2026-06-11 10:24:18.812443 2026-06-11 10:24:18.812444     International Results CSV 1 form://387/1999-02-25/5
111023 AS Monaco 387 1999-03-10 5 2.6 2.2 1.2     0.8 0.2 0.0   2026-06-11 10:24:18.834468 2026-06-11 10:24:18.834469     International Results CSV 1 form://387/1999-03-10/5
111089 AS Monaco 387 1999-03-14 5 2.2 2.0 1.2     0.6 0.4 0.0   2026-06-11 10:24:18.842003 2026-06-11 10:24:18.842003     International Results CSV 1 form://387/1999-03-14/5
111122 AS Monaco 387 1999-03-19 5 2.2 1.8 1.0     0.6 0.4 0.0   2026-06-11 10:24:18.846715 2026-06-11 10:24:18.846716     International Results CSV 1 form://387/1999-03-19/5
111207 AS Monaco 387 1999-04-02 5 1.6 1.2 1.0     0.4 0.4 0.2   2026-06-11 10:24:18.864152 2026-06-11 10:24:18.864152     International Results CSV 1 form://387/1999-04-02/5
111403 AS Monaco 387 1999-04-14 5 1.6 1.2 0.6     0.4 0.4 0.2   2026-06-11 10:24:18.885128 2026-06-11 10:24:18.885129     International Results CSV 1 form://387/1999-04-14/5
111517 AS Monaco 387 1999-04-24 5 1.6 1.4 0.8     0.4 0.4 0.2   2026-06-11 10:24:18.897775 2026-06-11 10:24:18.897775     International Results CSV 1 form://387/1999-04-24/5
111600 AS Monaco 387 1999-04-30 5 2.0 1.4 0.6     0.6 0.2 0.2   2026-06-11 10:24:18.909565 2026-06-11 10:24:18.909565     International Results CSV 1 form://387/1999-04-30/5
111708 AS Monaco 387 1999-05-05 5 2.0 1.6 0.8     0.6 0.2 0.2   2026-06-11 10:24:18.920979 2026-06-11 10:24:18.920979     International Results CSV 1 form://387/1999-05-05/5
111900 AS Monaco 387 1999-05-22 5 2.6 1.8 0.6     0.8 0.2 0.0   2026-06-11 10:24:18.942272 2026-06-11 10:24:18.942273     International Results CSV 1 form://387/1999-05-22/5
111969 AS Monaco 387 1999-05-29 5 2.6 1.4 0.6     0.8 0.2 0.0   2026-06-11 10:24:18.950187 2026-06-11 10:24:18.950188     International Results CSV 1 form://387/1999-05-29/5
112056 AS Monaco 387 1999-07-30 5 2.6 1.6 0.8     0.8 0.2 0.0   2026-06-11 10:24:18.997183 2026-06-11 10:24:18.997184     International Results CSV 1 form://387/1999-07-30/5
112079 AS Monaco 387 1999-08-06 5 2.0 1.4 1.0     0.6 0.2 0.2   2026-06-11 10:24:19.003982 2026-06-11 10:24:19.003982     International Results CSV 1 form://387/1999-08-06/5
112134 AS Monaco 387 1999-08-14 5 2.0 1.8 0.8     0.6 0.2 0.2   2026-06-11 10:24:19.011952 2026-06-11 10:24:19.011952     International Results CSV 1 form://387/1999-08-14/5
112187 AS Monaco 387 1999-08-20 5 2.0 2.0 1.0     0.6 0.2 0.2   2026-06-11 10:24:19.021176 2026-06-11 10:24:19.021176     International Results CSV 1 form://387/1999-08-20/5
112322 AS Monaco 387 1999-08-29 5 2.0 2.4 1.0     0.6 0.2 0.2   2026-06-11 10:24:19.035244 2026-06-11 10:24:19.035244     International Results CSV 1 form://387/1999-08-29/5
112429 AS Monaco 387 1999-09-12 5 1.8 2.2 1.0     0.6 0.0 0.4   2026-06-11 10:24:19.055365 2026-06-11 10:24:19.055365     International Results CSV 1 form://387/1999-09-12/5
112509 AS Monaco 387 1999-09-19 5 2.0 2.6 1.2     0.6 0.2 0.2   2026-06-11 10:24:19.063156 2026-06-11 10:24:19.063157     International Results CSV 1 form://387/1999-09-19/5
112570 AS Monaco 387 1999-09-25 5 2.0 2.4 1.2     0.6 0.2 0.2   2026-06-11 10:24:19.069040 2026-06-11 10:24:19.069040     International Results CSV 1 form://387/1999-09-25/5
112693 AS Monaco 387 1999-10-03 5 2.0 2.0 0.8     0.6 0.2 0.2   2026-06-11 10:24:19.083076 2026-06-11 10:24:19.083076     International Results CSV 1 form://387/1999-10-03/5
112757 AS Monaco 387 1999-10-13 5 1.4 1.8 1.4     0.4 0.2 0.4   2026-06-11 10:24:19.096026 2026-06-11 10:24:19.096026     International Results CSV 1 form://387/1999-10-13/5
112792 AS Monaco 387 1999-10-16 5 2.0 2.2 1.0     0.6 0.2 0.2   2026-06-11 10:24:19.099715 2026-06-11 10:24:19.099716     International Results CSV 1 form://387/1999-10-16/5
112875 AS Monaco 387 1999-10-20 5 2.4 2.4 0.6     0.8 0.0 0.2   2026-06-11 10:24:19.107905 2026-06-11 10:24:19.107905     International Results CSV 1 form://387/1999-10-20/5
113105 AS Monaco 387 1999-11-07 5 2.0 2.0 0.8     0.6 0.2 0.2   2026-06-11 10:24:19.133620 2026-06-11 10:24:19.133620     International Results CSV 1 form://387/1999-11-07/5
113170 AS Monaco 387 1999-11-10 5 2.0 2.2 1.0     0.6 0.2 0.2   2026-06-11 10:24:19.140735 2026-06-11 10:24:19.140735     International Results CSV 1 form://387/1999-11-10/5
113189 AS Monaco 387 1999-11-20 5 2.6 2.2 0.6     0.8 0.2 0.0   2026-06-11 10:24:19.149608 2026-06-11 10:24:19.149608     International Results CSV 1 form://387/1999-11-20/5
113268 AS Monaco 387 1999-11-27 5 2.6 2.4 0.8     0.8 0.2 0.0   2026-06-11 10:24:19.160314 2026-06-11 10:24:19.160314     International Results CSV 1 form://387/1999-11-27/5
113354 AS Monaco 387 1999-12-01 5 2.6 2.2 0.8     0.8 0.2 0.0   2026-06-11 10:24:19.169993 2026-06-11 10:24:19.169994     International Results CSV 1 form://387/1999-12-01/5
113376 AS Monaco 387 1999-12-04 5 3.0 2.4 0.6     1.0 0.0 0.0   2026-06-11 10:24:19.172512 2026-06-11 10:24:19.172512     International Results CSV 1 form://387/1999-12-04/5
113483 AS Monaco 387 1999-12-12 5 2.4 2.0 0.6     0.8 0.0 0.2   2026-06-11 10:24:19.183521 2026-06-11 10:24:19.183521     International Results CSV 1 form://387/1999-12-12/5
113557 AS Monaco 387 1999-12-18 5 2.4 1.8 0.4     0.8 0.0 0.2   2026-06-11 10:24:19.559128 2026-06-11 10:24:19.559128     International Results CSV 1 form://387/1999-12-18/5
113802 AS Monaco 387 2000-01-12 5 2.4 1.8 0.4     0.8 0.0 0.2   2026-06-11 10:24:19.585535 2026-06-11 10:24:19.585535     International Results CSV 1 form://387/2000-01-12/5
113809 AS Monaco 387 2000-01-15 5 2.4 2.0 0.6     0.8 0.0 0.2   2026-06-11 10:24:19.586616 2026-06-11 10:24:19.586616     International Results CSV 1 form://387/2000-01-15/5
113941 AS Monaco 387 2000-01-25 5 2.0 1.8 0.8     0.6 0.2 0.2   2026-06-11 10:24:19.602573 2026-06-11 10:24:19.602573     International Results CSV 1 form://387/2000-01-25/5
114002 AS Monaco 387 2000-02-01 5 2.6 2.0 0.6     0.8 0.2 0.0   2026-06-11 10:24:19.613049 2026-06-11 10:24:19.613050     International Results CSV 1 form://387/2000-02-01/5
114073 AS Monaco 387 2000-02-06 5 2.0 2.0 1.0     0.6 0.2 0.2   2026-06-11 10:24:19.624147 2026-06-11 10:24:19.624147     International Results CSV 1 form://387/2000-02-06/5
114219 AS Monaco 387 2000-02-16 5 2.0 1.4 0.8     0.6 0.2 0.2   2026-06-11 10:24:19.646463 2026-06-11 10:24:19.646464     International Results CSV 1 form://387/2000-02-16/5
114340 AS Monaco 387 2000-02-27 5 1.4 1.2 1.2     0.4 0.2 0.4   2026-06-11 10:24:19.665827 2026-06-11 10:24:19.665828     International Results CSV 1 form://387/2000-02-27/5
114508 AS Monaco 387 2000-03-12 5 1.8 1.4 1.0     0.6 0.0 0.4   2026-06-11 10:24:19.686185 2026-06-11 10:24:19.686185     International Results CSV 1 form://387/2000-03-12/5
114703 AS Monaco 387 2000-03-26 5 1.8 1.6 1.0     0.6 0.0 0.4   2026-06-11 10:24:19.710509 2026-06-11 10:24:19.710509     International Results CSV 1 form://387/2000-03-26/5
114798 AS Monaco 387 2000-04-07 5 1.8 1.8 1.4     0.6 0.0 0.4   2026-06-11 10:24:19.729312 2026-06-11 10:24:19.729313     International Results CSV 1 form://387/2000-04-07/5
114921 AS Monaco 387 2000-04-15 5 1.4 2.0 1.8     0.4 0.2 0.4   2026-06-11 10:24:19.748889 2026-06-11 10:24:19.748889     International Results CSV 1 form://387/2000-04-15/5
115101 AS Monaco 387 2000-04-29 5 1.4 1.8 1.6     0.4 0.2 0.4   2026-06-11 10:24:19.778050 2026-06-11 10:24:19.778050     International Results CSV 1 form://387/2000-04-29/5
115197 AS Monaco 387 2000-05-04 5 1.4 2.4 2.0     0.4 0.2 0.4   2026-06-11 10:24:19.788495 2026-06-11 10:24:19.788496     International Results CSV 1 form://387/2000-05-04/5
115280 AS Monaco 387 2000-05-13 5 0.8 2.2 2.6     0.2 0.2 0.6   2026-06-11 10:24:19.800009 2026-06-11 10:24:19.800009     International Results CSV 1 form://387/2000-05-13/5
115407 AS Monaco 387 2000-07-29 5 0.8 1.6 2.6     0.2 0.2 0.6   2026-06-11 10:24:19.860286 2026-06-11 10:24:19.860287     International Results CSV 1 form://387/2000-07-29/5
115416 AS Monaco 387 2000-08-04 5 0.8 1.8 3.2     0.2 0.2 0.6   2026-06-11 10:24:19.861232 2026-06-11 10:24:19.861233     International Results CSV 1 form://387/2000-08-04/5
115443 AS Monaco 387 2000-08-12 5 0.8 1.4 3.0     0.2 0.2 0.6   2026-06-11 10:24:19.865429 2026-06-11 10:24:19.865429     International Results CSV 1 form://387/2000-08-12/5
115484 AS Monaco 387 2000-08-20 5 1.4 1.4 2.4     0.4 0.2 0.4   2026-06-11 10:24:19.876307 2026-06-11 10:24:19.876307     International Results CSV 1 form://387/2000-08-20/5
115515 AS Monaco 387 2000-08-26 5 1.6 1.6 1.6     0.4 0.4 0.2   2026-06-11 10:24:19.879465 2026-06-11 10:24:19.879465     International Results CSV 1 form://387/2000-08-26/5
115544 AS Monaco 387 2000-09-05 5 1.4 1.4 1.8     0.4 0.2 0.4   2026-06-11 10:24:19.892681 2026-06-11 10:24:19.892682     International Results CSV 1 form://387/2000-09-05/5
115593 AS Monaco 387 2000-09-09 5 1.4 1.0 1.0     0.4 0.2 0.4   2026-06-11 10:24:19.897307 2026-06-11 10:24:19.897307     International Results CSV 1 form://387/2000-09-09/5
115648 AS Monaco 387 2000-09-16 5 1.4 1.0 0.8     0.4 0.2 0.4   2026-06-11 10:24:19.902792 2026-06-11 10:24:19.902792     International Results CSV 1 form://387/2000-09-16/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 1372.883ms