season

7 rows where competition_id = 61 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
955 Copa Artigas 61 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  
915 Copa Artigas 61 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  
782 Copa Artigas 61 1977 1977-01-01 1977-12-31 0   2026-06-07 06:58:37 2026-06-07 06:58:37 1 1   International Results CSV 1  
742 Copa Artigas 61 1975 1975-01-01 1975-12-31 0   2026-06-07 06:58:37 2026-06-07 06:58:37 1 1   International Results CSV 1  
603 Copa Artigas 61 1968 1968-01-01 1968-12-31 0   2026-06-07 06:58:35 2026-06-07 06:58:35 1 1   International Results CSV 1  
569 Copa Artigas 61 1966 1966-01-01 1966-12-31 0   2026-06-07 06:58:34 2026-06-07 06:58:34 1 1   International Results CSV 1  
554 Copa Artigas 61 1965 1965-01-01 1965-12-31 0   2026-06-07 06:58:34 2026-06-07 06:58:34 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);