screen

9 rows where building = 100454384

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014883 10014883 in 100454384 10014883 100454384    
900004144 900004144 in 100454384 900004144 100454384    
900004145 900004145 in 100454384 900004145 100454384    
900004146 900004146 in 100454384 900004146 100454384    
900004147 900004147 in 100454384 900004147 100454384    
900004148 900004148 in 100454384 900004148 100454384    
900004149 900004149 in 100454384 900004149 100454384    
900004150 900004150 in 100454384 900004150 100454384    
900004151 900004151 in 100454384 900004151 100454384    

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