screen

9 rows where building = 100454552

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014757 10014757 in 100454552 10014757 100454552    
900004184 900004184 in 100454552 900004184 100454552    
900004185 900004185 in 100454552 900004185 100454552    
900004186 900004186 in 100454552 900004186 100454552    
900004187 900004187 in 100454552 900004187 100454552    
900004188 900004188 in 100454552 900004188 100454552    
900004189 900004189 in 100454552 900004189 100454552    
900004190 900004190 in 100454552 900004190 100454552    
900004191 900004191 in 100454552 900004191 100454552    

Advanced export

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

CSV options: 

CREATE TABLE screen (
	id VARCHAR(8) NOT NULL, 
	title VARCHAR(250), 
	name_publisher VARCHAR(250), 
	building VARCHAR, 
	network VARCHAR, 
	venue_id VARCHAR, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network) REFERENCES network (id), 
	FOREIGN KEY(venue_id) REFERENCES venue_taxonomy (id)
);
CREATE INDEX ix_screen_building ON screen (building);
CREATE INDEX ix_screen_network ON screen (network);
CREATE INDEX ix_screen_venue_id ON screen (venue_id);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);