season

5 rows where competition_id = 21 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
179 Peace Cup 21 1925 1925-01-01 1925-12-31 0   2026-06-07 06:58:31 2026-06-07 06:58:31 1 1   International Results CSV 1  
170 Peace Cup 21 1924 1924-01-01 1924-12-31 0   2026-06-07 06:58:31 2026-06-07 06:58:31 1 1   International Results CSV 1  
158 Peace Cup 21 1923 1923-01-01 1923-12-31 0   2026-06-07 06:58:31 2026-06-07 06:58:31 1 1   International Results CSV 1  
149 Peace Cup 21 1922 1922-01-01 1922-12-31 0   2026-06-07 06:58:30 2026-06-07 06:58:30 1 1   International Results CSV 1  
141 Peace Cup 21 1921 1921-01-01 1921-12-31 0   2026-06-07 06:58:30 2026-06-07 06:58:30 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);