form_record
635 rows where team_id = 158
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9992 | Ivory Coast 158 | 1960-04-14 | 5 | 3.0 | 3.0 | 2.0 | 1.0 | 0.0 | 0.0 | 2026-06-07 07:03:03.498041 | 2026-06-07 07:03:03.498041 | 1 | International Results CSV 1 | form://158/1960-04-14/5 | ||||
| 10007 | Ivory Coast 158 | 1960-04-15 | 5 | 1.5 | 2.5 | 2.5 | 0.5 | 0.0 | 0.5 | 2026-06-07 07:03:03.746010 | 2026-06-07 07:03:03.746011 | 1 | International Results CSV 1 | form://158/1960-04-15/5 | ||||
| 10796 | Ivory Coast 158 | 1961-12-25 | 5 | 2.0 | 2.3333333333333335 | 2.0 | 0.6666666666666666 | 0.0 | 0.3333333333333333 | 2026-06-07 07:03:03.823420 | 2026-06-07 07:03:03.823421 | 1 | International Results CSV 1 | form://158/1961-12-25/5 | ||||
| 10804 | Ivory Coast 158 | 1961-12-26 | 5 | 2.25 | 3.0 | 1.5 | 0.75 | 0.0 | 0.25 | 2026-06-07 07:03:03.824234 | 2026-06-07 07:03:03.824235 | 1 | International Results CSV 1 | form://158/1961-12-26/5 | ||||
| 10812 | Ivory Coast 158 | 1961-12-27 | 5 | 2.4 | 2.6 | 1.2 | 0.8 | 0.0 | 0.2 | 2026-06-07 07:03:03.825010 | 2026-06-07 07:03:03.825011 | 1 | International Results CSV 1 | form://158/1961-12-27/5 | ||||
| 10816 | Ivory Coast 158 | 1961-12-29 | 5 | 2.0 | 2.2 | 1.0 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:03.825405 | 2026-06-07 07:03:03.825405 | 1 | International Results CSV 1 | form://158/1961-12-29/5 | ||||
| 10835 | Ivory Coast 158 | 1962-02-04 | 5 | 2.0 | 1.8 | 1.2 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:03.827168 | 2026-06-07 07:03:03.827168 | 1 | International Results CSV 1 | form://158/1962-02-04/5 | ||||
| 10837 | Ivory Coast 158 | 1962-02-06 | 5 | 2.0 | 1.8 | 1.0 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:03.827363 | 2026-06-07 07:03:03.827364 | 1 | International Results CSV 1 | form://158/1962-02-06/5 | ||||
| 11279 | Ivory Coast 158 | 1962-11-30 | 5 | 1.6 | 1.0 | 1.2 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:03.870629 | 2026-06-07 07:03:03.870629 | 1 | International Results CSV 1 | form://158/1962-11-30/5 | ||||
| 11384 | Ivory Coast 158 | 1963-03-10 | 5 | 1.6 | 1.4 | 1.2 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:03.880992 | 2026-06-07 07:03:03.880993 | 1 | International Results CSV 1 | form://158/1963-03-10/5 | ||||
| 11525 | Ivory Coast 158 | 1963-04-12 | 5 | 1.4 | 1.6 | 1.6 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:03.894749 | 2026-06-07 07:03:03.894749 | 1 | International Results CSV 1 | form://158/1963-04-12/5 | ||||
| 11531 | Ivory Coast 158 | 1963-04-13 | 5 | 1.4 | 1.8 | 1.4 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:03.895338 | 2026-06-07 07:03:03.895338 | 1 | International Results CSV 1 | form://158/1963-04-13/5 | ||||
| 11546 | Ivory Coast 158 | 1963-04-14 | 5 | 1.4 | 1.8 | 1.4 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:03.896899 | 2026-06-07 07:03:03.896900 | 1 | International Results CSV 1 | form://158/1963-04-14/5 | ||||
| 11552 | Ivory Coast 158 | 1963-04-15 | 5 | 1.8 | 1.8 | 1.2 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:03.897491 | 2026-06-07 07:03:03.897491 | 1 | International Results CSV 1 | form://158/1963-04-15/5 | ||||
| 11981 | Ivory Coast 158 | 1964-03-15 | 5 | 1.4 | 1.4 | 1.4 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:03.939643 | 2026-06-07 07:03:03.939644 | 1 | International Results CSV 1 | form://158/1964-03-15/5 | ||||
| 12327 | Ivory Coast 158 | 1965-01-17 | 5 | 2.0 | 1.4 | 0.8 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:03.973759 | 2026-06-07 07:03:03.973759 | 1 | International Results CSV 1 | form://158/1965-01-17/5 | ||||
| 12581 | Ivory Coast 158 | 1965-05-29 | 5 | 2.6 | 1.4 | 0.2 | 0.8 | 0.2 | 0.0 | 2026-06-07 07:03:03.998586 | 2026-06-07 07:03:03.998586 | 1 | International Results CSV 1 | form://158/1965-05-29/5 | ||||
| 12644 | Ivory Coast 158 | 1965-07-19 | 5 | 2.6 | 1.2 | 0.2 | 0.8 | 0.2 | 0.0 | 2026-06-07 07:03:04.004997 | 2026-06-07 07:03:04.004997 | 1 | International Results CSV 1 | form://158/1965-07-19/5 | ||||
| 12654 | Ivory Coast 158 | 1965-07-20 | 5 | 2.6 | 2.0 | 0.2 | 0.8 | 0.2 | 0.0 | 2026-06-07 07:03:04.006290 | 2026-06-07 07:03:04.006291 | 1 | International Results CSV 1 | form://158/1965-07-20/5 | ||||
| 12664 | Ivory Coast 158 | 1965-07-21 | 5 | 2.6 | 2.0 | 0.2 | 0.8 | 0.2 | 0.0 | 2026-06-07 07:03:04.007302 | 2026-06-07 07:03:04.007302 | 1 | International Results CSV 1 | form://158/1965-07-21/5 | ||||
| 12673 | Ivory Coast 158 | 1965-07-23 | 5 | 2.0 | 1.6 | 0.4 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.008110 | 2026-06-07 07:03:04.008110 | 1 | International Results CSV 1 | form://158/1965-07-23/5 | ||||
| 12682 | Ivory Coast 158 | 1965-07-25 | 5 | 2.0 | 1.8 | 0.4 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.009125 | 2026-06-07 07:03:04.009125 | 1 | International Results CSV 1 | form://158/1965-07-25/5 | ||||
| 12815 | Ivory Coast 158 | 1965-09-05 | 5 | 1.4 | 2.0 | 1.2 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:04.022662 | 2026-06-07 07:03:04.022663 | 1 | International Results CSV 1 | form://158/1965-09-05/5 | ||||
| 12840 | Ivory Coast 158 | 1965-09-21 | 5 | 1.4 | 1.8 | 1.2 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:04.025476 | 2026-06-07 07:03:04.025477 | 1 | International Results CSV 1 | form://158/1965-09-21/5 | ||||
| 12940 | Ivory Coast 158 | 1965-11-14 | 5 | 1.8 | 2.2 | 1.0 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.035701 | 2026-06-07 07:03:04.035701 | 1 | International Results CSV 1 | form://158/1965-11-14/5 | ||||
| 12952 | Ivory Coast 158 | 1965-11-19 | 5 | 1.8 | 2.4 | 1.6 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.036920 | 2026-06-07 07:03:04.036920 | 1 | International Results CSV 1 | form://158/1965-11-19/5 | ||||
| 12962 | Ivory Coast 158 | 1965-11-21 | 5 | 1.8 | 2.2 | 1.6 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.038147 | 2026-06-07 07:03:04.038148 | 1 | International Results CSV 1 | form://158/1965-11-21/5 | ||||
| 12973 | Ivory Coast 158 | 1965-11-23 | 5 | 2.4 | 2.0 | 0.8 | 0.8 | 0.0 | 0.2 | 2026-06-07 07:03:04.039190 | 2026-06-07 07:03:04.039190 | 1 | International Results CSV 1 | form://158/1965-11-23/5 | ||||
| 12982 | Ivory Coast 158 | 1965-11-25 | 5 | 1.8 | 1.4 | 1.4 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.040214 | 2026-06-07 07:03:04.040215 | 1 | International Results CSV 1 | form://158/1965-11-25/5 | ||||
| 13412 | Ivory Coast 158 | 1966-08-16 | 5 | 1.8 | 1.2 | 1.6 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.083970 | 2026-06-07 07:03:04.083970 | 1 | International Results CSV 1 | form://158/1966-08-16/5 | ||||
| 13546 | Ivory Coast 158 | 1966-11-01 | 5 | 2.0 | 1.2 | 1.0 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.097976 | 2026-06-07 07:03:04.097976 | 1 | International Results CSV 1 | form://158/1966-11-01/5 | ||||
| 13847 | Ivory Coast 158 | 1967-02-19 | 5 | 1.6 | 1.4 | 1.4 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:04.128702 | 2026-06-07 07:03:04.128703 | 1 | International Results CSV 1 | form://158/1967-02-19/5 | ||||
| 13874 | Ivory Coast 158 | 1967-03-05 | 5 | 1.2 | 1.4 | 1.6 | 0.2 | 0.6 | 0.2 | 2026-06-07 07:03:04.131563 | 2026-06-07 07:03:04.131563 | 1 | International Results CSV 1 | form://158/1967-03-05/5 | ||||
| 13909 | Ivory Coast 158 | 1967-03-12 | 5 | 1.4 | 1.2 | 1.0 | 0.2 | 0.8 | 0.0 | 2026-06-07 07:03:04.135012 | 2026-06-07 07:03:04.135012 | 1 | International Results CSV 1 | form://158/1967-03-12/5 | ||||
| 13947 | Ivory Coast 158 | 1967-03-28 | 5 | 1.4 | 1.4 | 0.8 | 0.2 | 0.8 | 0.0 | 2026-06-07 07:03:04.138861 | 2026-06-07 07:03:04.138861 | 1 | International Results CSV 1 | form://158/1967-03-28/5 | ||||
| 13984 | Ivory Coast 158 | 1967-04-30 | 5 | 1.8 | 1.8 | 0.6 | 0.4 | 0.6 | 0.0 | 2026-06-07 07:03:04.142685 | 2026-06-07 07:03:04.142685 | 1 | International Results CSV 1 | form://158/1967-04-30/5 | ||||
| 13990 | Ivory Coast 158 | 1967-05-07 | 5 | 2.2 | 1.8 | 0.2 | 0.6 | 0.4 | 0.0 | 2026-06-07 07:03:04.143300 | 2026-06-07 07:03:04.143300 | 1 | International Results CSV 1 | form://158/1967-05-07/5 | ||||
| 14149 | Ivory Coast 158 | 1967-08-16 | 5 | 2.6 | 2.0 | 0.0 | 0.8 | 0.2 | 0.0 | 2026-06-07 07:03:04.159586 | 2026-06-07 07:03:04.159586 | 1 | International Results CSV 1 | form://158/1967-08-16/5 | ||||
| 14396 | Ivory Coast 158 | 1967-11-26 | 5 | 2.4 | 2.4 | 0.6 | 0.8 | 0.0 | 0.2 | 2026-06-07 07:03:04.184828 | 2026-06-07 07:03:04.184828 | 1 | International Results CSV 1 | form://158/1967-11-26/5 | ||||
| 14474 | Ivory Coast 158 | 1968-01-12 | 5 | 2.4 | 2.4 | 0.6 | 0.8 | 0.0 | 0.2 | 2026-06-07 07:03:04.192767 | 2026-06-07 07:03:04.192767 | 1 | International Results CSV 1 | form://158/1968-01-12/5 | ||||
| 14488 | Ivory Coast 158 | 1968-01-14 | 5 | 1.8 | 1.8 | 0.8 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.194201 | 2026-06-07 07:03:04.194201 | 1 | International Results CSV 1 | form://158/1968-01-14/5 | ||||
| 14495 | Ivory Coast 158 | 1968-01-16 | 5 | 1.8 | 1.8 | 1.0 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.195009 | 2026-06-07 07:03:04.195009 | 1 | International Results CSV 1 | form://158/1968-01-16/5 | ||||
| 14500 | Ivory Coast 158 | 1968-01-19 | 5 | 1.2 | 2.0 | 1.8 | 0.4 | 0.0 | 0.6 | 2026-06-07 07:03:04.195443 | 2026-06-07 07:03:04.195443 | 1 | International Results CSV 1 | form://158/1968-01-19/5 | ||||
| 14504 | Ivory Coast 158 | 1968-01-21 | 5 | 1.8 | 1.8 | 1.2 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.195847 | 2026-06-07 07:03:04.195847 | 1 | International Results CSV 1 | form://158/1968-01-21/5 | ||||
| 14628 | Ivory Coast 158 | 1968-05-19 | 5 | 1.2 | 1.4 | 1.6 | 0.4 | 0.0 | 0.6 | 2026-06-07 07:03:04.208478 | 2026-06-07 07:03:04.208478 | 1 | International Results CSV 1 | form://158/1968-05-19/5 | ||||
| 15436 | Ivory Coast 158 | 1969-08-15 | 5 | 1.4 | 1.6 | 1.6 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:04.531210 | 2026-06-07 07:03:04.531210 | 1 | International Results CSV 1 | form://158/1969-08-15/5 | ||||
| 15584 | Ivory Coast 158 | 1969-10-12 | 5 | 1.0 | 1.2 | 1.4 | 0.2 | 0.4 | 0.4 | 2026-06-07 07:03:04.545670 | 2026-06-07 07:03:04.545671 | 1 | International Results CSV 1 | form://158/1969-10-12/5 | ||||
| 15633 | Ivory Coast 158 | 1969-10-26 | 5 | 1.6 | 1.4 | 0.6 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:04.550539 | 2026-06-07 07:03:04.550539 | 1 | International Results CSV 1 | form://158/1969-10-26/5 | ||||
| 15697 | Ivory Coast 158 | 1969-11-09 | 5 | 1.6 | 1.4 | 0.6 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:04.556952 | 2026-06-07 07:03:04.556952 | 1 | International Results CSV 1 | form://158/1969-11-09/5 | ||||
| 15850 | Ivory Coast 158 | 1970-02-06 | 5 | 1.6 | 1.6 | 0.8 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:04.571795 | 2026-06-07 07:03:04.571795 | 1 | International Results CSV 1 | form://158/1970-02-06/5 | ||||
| 15862 | Ivory Coast 158 | 1970-02-08 | 5 | 2.0 | 1.6 | 0.6 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.572956 | 2026-06-07 07:03:04.572957 | 1 | International Results CSV 1 | form://158/1970-02-08/5 | ||||
| 15870 | Ivory Coast 158 | 1970-02-10 | 5 | 2.4 | 2.8 | 0.8 | 0.8 | 0.0 | 0.2 | 2026-06-07 07:03:04.573737 | 2026-06-07 07:03:04.573737 | 1 | International Results CSV 1 | form://158/1970-02-10/5 | ||||
| 15880 | Ivory Coast 158 | 1970-02-14 | 5 | 1.8 | 2.2 | 1.2 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.574718 | 2026-06-07 07:03:04.574718 | 1 | International Results CSV 1 | form://158/1970-02-14/5 | ||||
| 15888 | Ivory Coast 158 | 1970-02-16 | 5 | 1.2 | 2.2 | 1.8 | 0.4 | 0.0 | 0.6 | 2026-06-07 07:03:04.575497 | 2026-06-07 07:03:04.575497 | 1 | International Results CSV 1 | form://158/1970-02-16/5 | ||||
| 15932 | Ivory Coast 158 | 1970-03-22 | 5 | 1.2 | 2.2 | 2.0 | 0.4 | 0.0 | 0.6 | 2026-06-07 07:03:04.579801 | 2026-06-07 07:03:04.579801 | 1 | International Results CSV 1 | form://158/1970-03-22/5 | ||||
| 15970 | Ivory Coast 158 | 1970-04-15 | 5 | 0.6 | 2.0 | 2.6 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:04.583499 | 2026-06-07 07:03:04.583499 | 1 | International Results CSV 1 | form://158/1970-04-15/5 | ||||
| 15978 | Ivory Coast 158 | 1970-04-19 | 5 | 0.2 | 1.0 | 2.6 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:04.584283 | 2026-06-07 07:03:04.584283 | 1 | International Results CSV 1 | form://158/1970-04-19/5 | ||||
| 16149 | Ivory Coast 158 | 1970-07-26 | 5 | 0.8 | 1.4 | 2.6 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:04.601001 | 2026-06-07 07:03:04.601001 | 1 | International Results CSV 1 | form://158/1970-07-26/5 | ||||
| 16321 | Ivory Coast 158 | 1970-10-18 | 5 | 0.8 | 1.2 | 2.2 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:04.617961 | 2026-06-07 07:03:04.617961 | 1 | International Results CSV 1 | form://158/1970-10-18/5 | ||||
| 16364 | Ivory Coast 158 | 1970-11-08 | 5 | 1.4 | 1.2 | 1.6 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:04.622162 | 2026-06-07 07:03:04.622162 | 1 | International Results CSV 1 | form://158/1970-11-08/5 | ||||
| 16451 | Ivory Coast 158 | 1970-11-22 | 5 | 2.0 | 1.4 | 1.0 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.630822 | 2026-06-07 07:03:04.630822 | 1 | International Results CSV 1 | form://158/1970-11-22/5 | ||||
| 16645 | Ivory Coast 158 | 1971-05-02 | 5 | 1.8 | 1.6 | 2.0 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.649930 | 2026-06-07 07:03:04.649930 | 1 | International Results CSV 1 | form://158/1971-05-02/5 | ||||
| 17102 | Ivory Coast 158 | 1971-10-13 | 5 | 1.8 | 1.6 | 2.0 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.695238 | 2026-06-07 07:03:04.695239 | 1 | International Results CSV 1 | form://158/1971-10-13/5 | ||||
| 17129 | Ivory Coast 158 | 1971-10-27 | 5 | 1.8 | 1.6 | 2.2 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.697796 | 2026-06-07 07:03:04.697796 | 1 | International Results CSV 1 | form://158/1971-10-27/5 | ||||
| 17517 | Ivory Coast 158 | 1972-04-19 | 5 | 1.8 | 1.6 | 2.2 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.736010 | 2026-06-07 07:03:04.736010 | 1 | International Results CSV 1 | form://158/1972-04-19/5 | ||||
| 18007 | Ivory Coast 158 | 1972-10-15 | 5 | 1.8 | 1.6 | 2.2 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.783836 | 2026-06-07 07:03:04.783837 | 1 | International Results CSV 1 | form://158/1972-10-15/5 | ||||
| 18038 | Ivory Coast 158 | 1972-10-29 | 5 | 2.4 | 1.6 | 1.0 | 0.8 | 0.0 | 0.2 | 2026-06-07 07:03:04.786931 | 2026-06-07 07:03:04.786931 | 1 | International Results CSV 1 | form://158/1972-10-29/5 | ||||
| 18259 | Ivory Coast 158 | 1973-02-11 | 5 | 2.0 | 1.2 | 0.8 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.808430 | 2026-06-07 07:03:04.808430 | 1 | International Results CSV 1 | form://158/1973-02-11/5 | ||||
| 18314 | Ivory Coast 158 | 1973-02-25 | 5 | 2.6 | 1.6 | 0.6 | 0.8 | 0.2 | 0.0 | 2026-06-07 07:03:04.813886 | 2026-06-07 07:03:04.813886 | 1 | International Results CSV 1 | form://158/1973-02-25/5 | ||||
| 18381 | Ivory Coast 158 | 1973-04-08 | 5 | 2.0 | 1.6 | 1.2 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.820397 | 2026-06-07 07:03:04.820398 | 1 | International Results CSV 1 | form://158/1973-04-08/5 | ||||
| 18522 | Ivory Coast 158 | 1973-05-20 | 5 | 1.6 | 1.6 | 1.4 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:04.834450 | 2026-06-07 07:03:04.834451 | 1 | International Results CSV 1 | form://158/1973-05-20/5 | ||||
| 18573 | Ivory Coast 158 | 1973-06-03 | 5 | 1.0 | 1.4 | 2.2 | 0.2 | 0.4 | 0.4 | 2026-06-07 07:03:04.839302 | 2026-06-07 07:03:04.839302 | 1 | International Results CSV 1 | form://158/1973-06-03/5 | ||||
| 18661 | Ivory Coast 158 | 1973-07-15 | 5 | 1.4 | 1.8 | 2.0 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:04.848082 | 2026-06-07 07:03:04.848082 | 1 | International Results CSV 1 | form://158/1973-07-15/5 | ||||
| 18696 | Ivory Coast 158 | 1973-07-29 | 5 | 1.4 | 2.4 | 2.0 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:04.851780 | 2026-06-07 07:03:04.851781 | 1 | International Results CSV 1 | form://158/1973-07-29/5 | ||||
| 19212 | Ivory Coast 158 | 1974-03-02 | 5 | 1.8 | 2.0 | 1.2 | 0.6 | 0.0 | 0.4 | 2026-06-07 07:03:04.902810 | 2026-06-07 07:03:04.902811 | 1 | International Results CSV 1 | form://158/1974-03-02/5 | ||||
| 19220 | Ivory Coast 158 | 1974-03-04 | 5 | 2.0 | 2.2 | 0.8 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:04.903593 | 2026-06-07 07:03:04.903593 | 1 | International Results CSV 1 | form://158/1974-03-04/5 | ||||
| 19227 | Ivory Coast 158 | 1974-03-06 | 5 | 1.4 | 1.6 | 1.2 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:04.904186 | 2026-06-07 07:03:04.904186 | 1 | International Results CSV 1 | form://158/1974-03-06/5 | ||||
| 19519 | Ivory Coast 158 | 1974-07-06 | 5 | 0.8 | 0.8 | 2.0 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:04.932627 | 2026-06-07 07:03:04.932628 | 1 | International Results CSV 1 | form://158/1974-07-06/5 | ||||
| 19529 | Ivory Coast 158 | 1974-07-14 | 5 | 0.2 | 0.6 | 2.4 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:04.933627 | 2026-06-07 07:03:04.933627 | 1 | International Results CSV 1 | form://158/1974-07-14/5 | ||||
| 19656 | Ivory Coast 158 | 1974-09-11 | 5 | 0.4 | 0.8 | 2.4 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:04.946053 | 2026-06-07 07:03:04.946053 | 1 | International Results CSV 1 | form://158/1974-09-11/5 | ||||
| 20027 | Ivory Coast 158 | 1975-03-30 | 5 | 0.2 | 0.4 | 2.2 | 0.0 | 0.2 | 0.8 | 2026-06-07 07:03:05.240416 | 2026-06-07 07:03:05.240416 | 1 | International Results CSV 1 | form://158/1975-03-30/5 | ||||
| 20074 | Ivory Coast 158 | 1975-04-13 | 5 | 0.8 | 0.8 | 2.0 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:05.245132 | 2026-06-07 07:03:05.245132 | 1 | International Results CSV 1 | form://158/1975-04-13/5 | ||||
| 20109 | Ivory Coast 158 | 1975-04-26 | 5 | 0.8 | 0.6 | 1.2 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:05.248488 | 2026-06-07 07:03:05.248488 | 1 | International Results CSV 1 | form://158/1975-04-26/5 | ||||
| 20112 | Ivory Coast 158 | 1975-04-27 | 5 | 0.8 | 0.6 | 1.4 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:05.248873 | 2026-06-07 07:03:05.248873 | 1 | International Results CSV 1 | form://158/1975-04-27/5 | ||||
| 20395 | Ivory Coast 158 | 1975-08-06 | 5 | 0.6 | 0.6 | 1.8 | 0.2 | 0.0 | 0.8 | 2026-06-07 07:03:05.276458 | 2026-06-07 07:03:05.276458 | 1 | International Results CSV 1 | form://158/1975-08-06/5 | ||||
| 20427 | Ivory Coast 158 | 1975-08-10 | 5 | 0.8 | 0.6 | 1.6 | 0.2 | 0.2 | 0.6 | 2026-06-07 07:03:05.279568 | 2026-06-07 07:03:05.279568 | 1 | International Results CSV 1 | form://158/1975-08-10/5 | ||||
| 20498 | Ivory Coast 158 | 1975-09-07 | 5 | 0.4 | 0.4 | 1.6 | 0.0 | 0.4 | 0.6 | 2026-06-07 07:03:05.286587 | 2026-06-07 07:03:05.286587 | 1 | International Results CSV 1 | form://158/1975-09-07/5 | ||||
| 20836 | Ivory Coast 158 | 1976-03-21 | 5 | 1.0 | 1.2 | 1.6 | 0.2 | 0.4 | 0.4 | 2026-06-07 07:03:05.319701 | 2026-06-07 07:03:05.319702 | 1 | International Results CSV 1 | form://158/1976-03-21/5 | ||||
| 20859 | Ivory Coast 158 | 1976-03-28 | 5 | 1.6 | 1.8 | 1.0 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:05.321872 | 2026-06-07 07:03:05.321872 | 1 | International Results CSV 1 | form://158/1976-03-28/5 | ||||
| 20920 | Ivory Coast 158 | 1976-04-19 | 5 | 1.6 | 1.8 | 1.0 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:05.327903 | 2026-06-07 07:03:05.327903 | 1 | International Results CSV 1 | form://158/1976-04-19/5 | ||||
| 21190 | Ivory Coast 158 | 1976-09-04 | 5 | 1.6 | 2.0 | 1.2 | 0.4 | 0.4 | 0.2 | 2026-06-07 07:03:05.354596 | 2026-06-07 07:03:05.354596 | 1 | International Results CSV 1 | form://158/1976-09-04/5 | ||||
| 21211 | Ivory Coast 158 | 1976-09-09 | 5 | 2.0 | 2.4 | 1.2 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:05.356786 | 2026-06-07 07:03:05.356786 | 1 | International Results CSV 1 | form://158/1976-09-09/5 | ||||
| 21267 | Ivory Coast 158 | 1976-09-26 | 5 | 2.0 | 2.0 | 1.0 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:05.362348 | 2026-06-07 07:03:05.362348 | 1 | International Results CSV 1 | form://158/1976-09-26/5 | ||||
| 21587 | Ivory Coast 158 | 1977-02-13 | 5 | 2.0 | 2.0 | 1.4 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:05.394004 | 2026-06-07 07:03:05.394005 | 1 | International Results CSV 1 | form://158/1977-02-13/5 | ||||
| 21630 | Ivory Coast 158 | 1977-02-27 | 5 | 2.6 | 2.4 | 1.0 | 0.8 | 0.2 | 0.0 | 2026-06-07 07:03:05.398156 | 2026-06-07 07:03:05.398156 | 1 | International Results CSV 1 | form://158/1977-02-27/5 | ||||
| 21734 | Ivory Coast 158 | 1977-03-20 | 5 | 3.0 | 2.4 | 0.8 | 1.0 | 0.0 | 0.0 | 2026-06-07 07:03:05.408526 | 2026-06-07 07:03:05.408526 | 1 | International Results CSV 1 | form://158/1977-03-20/5 | ||||
| 21773 | Ivory Coast 158 | 1977-03-27 | 5 | 3.0 | 2.6 | 0.8 | 1.0 | 0.0 | 0.0 | 2026-06-07 07:03:05.412472 | 2026-06-07 07:03:05.412472 | 1 | International Results CSV 1 | form://158/1977-03-27/5 | ||||
| 21988 | Ivory Coast 158 | 1977-07-10 | 5 | 2.4 | 2.2 | 1.6 | 0.8 | 0.0 | 0.2 | 2026-06-07 07:03:05.433577 | 2026-06-07 07:03:05.433577 | 1 | International Results CSV 1 | form://158/1977-07-10/5 | ||||
| 22031 | Ivory Coast 158 | 1977-07-25 | 5 | 2.0 | 2.0 | 1.6 | 0.6 | 0.2 | 0.2 | 2026-06-07 07:03:05.437974 | 2026-06-07 07:03:05.437974 | 1 | International Results CSV 1 | form://158/1977-07-25/5 | ||||
| 22444 | Ivory Coast 158 | 1978-02-19 | 5 | 1.4 | 1.6 | 2.0 | 0.4 | 0.2 | 0.4 | 2026-06-07 07:03:05.478393 | 2026-06-07 07:03:05.478394 | 1 | International Results CSV 1 | form://158/1978-02-19/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)
);