Team Results by Season

6 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: won, tied

id ▼ season competition played won lost tied abandoned
1 2025 ALL 45 5 39 1 0
2 2025 Friendly 6 1 5 0 0
3 2025 WSL 13 2 11 0 0
4 2025 SCL 16 1 15 0 0
5 2025 NYCL 4 1 3 0 0
6 2025 PICF 5 0 4 1 0

Advanced export

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

CSV options: 

CREATE TABLE team_season_stats (
        id          INTEGER PRIMARY KEY AUTOINCREMENT,
        season      INTEGER NOT NULL,
        competition TEXT NOT NULL,   -- 'ALL', 'Friendly', 'WSL', 'SCL', 'NYCL', 'PICF'
        played      INTEGER DEFAULT 0,
        won         INTEGER DEFAULT 0,
        lost        INTEGER DEFAULT 0,
        tied        INTEGER DEFAULT 0,
        abandoned   INTEGER DEFAULT 0,
        UNIQUE(season, competition)
    );