screen

9 rows where building = 100411080

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014876 10014876 in 100411080 10014876 100411080    
900003960 900003960 in 100411080 900003960 100411080    
900003961 900003961 in 100411080 900003961 100411080    
900003962 900003962 in 100411080 900003962 100411080    
900003963 900003963 in 100411080 900003963 100411080    
900003964 900003964 in 100411080 900003964 100411080    
900003965 900003965 in 100411080 900003965 100411080    
900003966 900003966 in 100411080 900003966 100411080    
900003967 900003967 in 100411080 900003967 100411080    

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