team_alias

2 rows where team_id = 748

✎ View and edit SQL

This data as json, CSV (advanced)

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

alias_id ▼ team_id raw_name source_id confidence created_at updated_at created_by_run_id updated_by_run_id source_raw_key
594 Manchester City 748 Man City International Results CSV 1 0.8 2026-06-11T09:27:43.815562 2026-06-11T09:27:43.815562      
1213 Manchester City 748 Manchester City International Results CSV 1 1.0 2026-06-11T16:05:36.860681 2026-06-11T16:05:36.860686      

Advanced export

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

CSV options: 

CREATE TABLE team_alias (
	alias_id INTEGER NOT NULL, 
	team_id INTEGER NOT NULL, 
	raw_name VARCHAR(128) NOT NULL, 
	source_id INTEGER NOT NULL, 
	confidence FLOAT NOT NULL, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	created_by_run_id INTEGER, 
	updated_by_run_id INTEGER, 
	source_raw_key VARCHAR(512), 
	PRIMARY KEY (alias_id), 
	CONSTRAINT uq_team_alias_raw_source UNIQUE (raw_name, source_id), 
	FOREIGN KEY(team_id) REFERENCES team (team_id), 
	FOREIGN KEY(source_id) REFERENCES data_source (source_id), 
	FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id)
);
CREATE INDEX ix_team_alias_created_by_run_id ON team_alias (created_by_run_id);
CREATE INDEX ix_team_alias_team_id ON team_alias (team_id);
CREATE INDEX ix_team_alias_source_id ON team_alias (source_id);
CREATE INDEX ix_team_alias_source_raw_key ON team_alias (source_raw_key);
CREATE INDEX ix_team_alias_updated_by_run_id ON team_alias (updated_by_run_id);
CREATE INDEX ix_team_alias_raw_name ON team_alias (raw_name);