screen

9 rows where building = 100454855

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014886 10014886 in 100454855 10014886 100454855    
900004224 900004224 in 100454855 900004224 100454855    
900004225 900004225 in 100454855 900004225 100454855    
900004226 900004226 in 100454855 900004226 100454855    
900004227 900004227 in 100454855 900004227 100454855    
900004228 900004228 in 100454855 900004228 100454855    
900004229 900004229 in 100454855 900004229 100454855    
900004230 900004230 in 100454855 900004230 100454855    
900004231 900004231 in 100454855 900004231 100454855    

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