screen

9 rows where building = 100466681

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014791 10014791 in 100466681 10014791 100466681    
900004664 900004664 in 100466681 900004664 100466681    
900004665 900004665 in 100466681 900004665 100466681    
900004666 900004666 in 100466681 900004666 100466681    
900004667 900004667 in 100466681 900004667 100466681    
900004668 900004668 in 100466681 900004668 100466681    
900004669 900004669 in 100466681 900004669 100466681    
900004670 900004670 in 100466681 900004670 100466681    
900004671 900004671 in 100466681 900004671 100466681    

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