season

5 rows where competition_id = 90 sorted by season_name descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at, updated_at, start_date (date), end_date (date), created_at (date), updated_at (date)

season_id competition_id season_name ▲ start_date end_date is_active teams_expected created_at updated_at created_by_run_id updated_by_run_id source_id source_raw_key
1143 Merlion Cup 90 1992 1992-01-01 1992-12-31 0   2026-06-07 06:58:42 2026-06-07 06:58:42 1 1   International Results CSV 1  
992 Merlion Cup 90 1986 1986-01-01 1986-12-31 0   2026-06-07 06:58:40 2026-06-07 06:58:40 1 1   International Results CSV 1  
970 Merlion Cup 90 1985 1985-01-01 1985-12-31 0   2026-06-07 06:58:40 2026-06-07 06:58:40 1 1   International Results CSV 1  
929 Merlion Cup 90 1983 1983-01-01 1983-12-31 0   2026-06-07 06:58:39 2026-06-07 06:58:39 1 1   International Results CSV 1  
904 Merlion Cup 90 1982 1982-01-01 1982-12-31 0   2026-06-07 06:58:39 2026-06-07 06:58:39 1 1   International Results CSV 1  

Advanced export

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

CSV options: 

CREATE TABLE season (
	season_id INTEGER NOT NULL, 
	competition_id INTEGER NOT NULL, 
	season_name VARCHAR(32) NOT NULL, 
	start_date DATE, 
	end_date DATE, 
	is_active BOOLEAN NOT NULL, 
	teams_expected 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), 
	PRIMARY KEY (season_id), 
	CONSTRAINT uq_season_competition_name UNIQUE (competition_id, season_name), 
	FOREIGN KEY(competition_id) REFERENCES competition (competition_id), 
	FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(source_id) REFERENCES data_source (source_id)
);
CREATE INDEX ix_season_updated_by_run_id ON season (updated_by_run_id);
CREATE INDEX ix_season_source_raw_key ON season (source_raw_key);
CREATE INDEX ix_season_competition_id ON season (competition_id);
CREATE INDEX ix_season_created_by_run_id ON season (created_by_run_id);
CREATE INDEX ix_season_source_id ON season (source_id);
CREATE INDEX ix_season_season_name ON season (season_name);