screen

9 rows where building = 100454565

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014884 10014884 in 100454565 10014884 100454565    
900004192 900004192 in 100454565 900004192 100454565    
900004193 900004193 in 100454565 900004193 100454565    
900004194 900004194 in 100454565 900004194 100454565    
900004195 900004195 in 100454565 900004195 100454565    
900004196 900004196 in 100454565 900004196 100454565    
900004197 900004197 in 100454565 900004197 100454565    
900004198 900004198 in 100454565 900004198 100454565    
900004199 900004199 in 100454565 900004199 100454565    

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);