screen

9 rows where building = 100454543

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014755 10014755 in 100454543 10014755 100454543    
900004168 900004168 in 100454543 900004168 100454543    
900004169 900004169 in 100454543 900004169 100454543    
900004170 900004170 in 100454543 900004170 100454543    
900004171 900004171 in 100454543 900004171 100454543    
900004172 900004172 in 100454543 900004172 100454543    
900004173 900004173 in 100454543 900004173 100454543    
900004174 900004174 in 100454543 900004174 100454543    
900004175 900004175 in 100454543 900004175 100454543    

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