screen

9 rows where building = 100456313

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014764 10014764 in 100456313 10014764 100456313    
900004304 900004304 in 100456313 900004304 100456313    
900004305 900004305 in 100456313 900004305 100456313    
900004306 900004306 in 100456313 900004306 100456313    
900004307 900004307 in 100456313 900004307 100456313    
900004308 900004308 in 100456313 900004308 100456313    
900004309 900004309 in 100456313 900004309 100456313    
900004310 900004310 in 100456313 900004310 100456313    
900004311 900004311 in 100456313 900004311 100456313    

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