screen

9 rows where building = 100454550

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014756 10014756 in 100454550 10014756 100454550    
900004176 900004176 in 100454550 900004176 100454550    
900004177 900004177 in 100454550 900004177 100454550    
900004178 900004178 in 100454550 900004178 100454550    
900004179 900004179 in 100454550 900004179 100454550    
900004180 900004180 in 100454550 900004180 100454550    
900004181 900004181 in 100454550 900004181 100454550    
900004182 900004182 in 100454550 900004182 100454550    
900004183 900004183 in 100454550 900004183 100454550    

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