home / football

form_record

8 rows where team_id = 80

✎ 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
3577 Silesia 80 1933-10-04 5 0.0 1.0 2.0     0.0 0.0 1.0   2026-06-07 07:03:02.494101 2026-06-07 07:03:02.494101 1   International Results CSV 1 form://80/1933-10-04/5
4368 Silesia 80 1937-06-09 5 0.0 2.0 3.0     0.0 0.0 1.0   2026-06-07 07:03:02.499850 2026-06-07 07:03:02.499850 1   International Results CSV 1 form://80/1937-06-09/5
6134 Silesia 80 1948-04-20 5 1.0 2.0 2.3333333333333335     0.3333333333333333 0.0 0.6666666666666666   2026-06-07 07:03:03.107881 2026-06-07 07:03:03.107882 1   International Results CSV 1 form://80/1948-04-20/5
7248 Silesia 80 1952-08-24 5 1.5 2.75 2.0     0.5 0.0 0.5   2026-06-07 07:03:03.217504 2026-06-07 07:03:03.217505 1   International Results CSV 1 form://80/1952-08-24/5
7466 Silesia 80 1953-04-26 5 1.2 2.6 2.2     0.4 0.0 0.6   2026-06-07 07:03:03.238880 2026-06-07 07:03:03.238880 1   International Results CSV 1 form://80/1953-04-26/5
7574 Silesia 80 1953-09-13 5 1.4 3.0 2.4     0.4 0.2 0.4   2026-06-07 07:03:03.250189 2026-06-07 07:03:03.250189 1   International Results CSV 1 form://80/1953-09-13/5
19530 Silesia 80 1974-07-22 5 2.0 3.8 2.0     0.6 0.2 0.2   2026-06-07 07:03:04.933817 2026-06-07 07:03:04.933817 1   International Results CSV 1 form://80/1974-07-22/5
60963 Silesia 80 2006-12-09 5 1.6 3.6 2.0     0.4 0.4 0.2   2026-06-07 07:03:11.445747 2026-06-07 07:03:11.445747 1   International Results CSV 1 form://80/2006-12-09/5

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 1626.839ms