screen

10 rows where building = 100456308

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014942 10014942 in 100456308 10014942 100456308    
10014943 10014943 in 100456308 10014943 100456308    
900004296 900004296 in 100456308 900004296 100456308    
900004297 900004297 in 100456308 900004297 100456308    
900004298 900004298 in 100456308 900004298 100456308    
900004299 900004299 in 100456308 900004299 100456308    
900004300 900004300 in 100456308 900004300 100456308    
900004301 900004301 in 100456308 900004301 100456308    
900004302 900004302 in 100456308 900004302 100456308    
900004303 900004303 in 100456308 900004303 100456308    

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