screen

9 rows where building = 100454381

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014752 10014752 in 100454381 10014752 100454381    
900004120 900004120 in 100454381 900004120 100454381    
900004121 900004121 in 100454381 900004121 100454381    
900004122 900004122 in 100454381 900004122 100454381    
900004123 900004123 in 100454381 900004123 100454381    
900004124 900004124 in 100454381 900004124 100454381    
900004125 900004125 in 100454381 900004125 100454381    
900004126 900004126 in 100454381 900004126 100454381    
900004127 900004127 in 100454381 900004127 100454381    

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