screen

9 rows where building = 100456307

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014763 10014763 in 100456307 10014763 100456307    
900004288 900004288 in 100456307 900004288 100456307    
900004289 900004289 in 100456307 900004289 100456307    
900004290 900004290 in 100456307 900004290 100456307    
900004291 900004291 in 100456307 900004291 100456307    
900004292 900004292 in 100456307 900004292 100456307    
900004293 900004293 in 100456307 900004293 100456307    
900004294 900004294 in 100456307 900004294 100456307    
900004295 900004295 in 100456307 900004295 100456307    

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