screen

9 rows where building = 100454383

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014753 10014753 in 100454383 10014753 100454383    
900004136 900004136 in 100454383 900004136 100454383    
900004137 900004137 in 100454383 900004137 100454383    
900004138 900004138 in 100454383 900004138 100454383    
900004139 900004139 in 100454383 900004139 100454383    
900004140 900004140 in 100454383 900004140 100454383    
900004141 900004141 in 100454383 900004141 100454383    
900004142 900004142 in 100454383 900004142 100454383    
900004143 900004143 in 100454383 900004143 100454383    

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