screen

9 rows where building = 100455892

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014761 10014761 in 100455892 10014761 100455892    
900004248 900004248 in 100455892 900004248 100455892    
900004249 900004249 in 100455892 900004249 100455892    
900004250 900004250 in 100455892 900004250 100455892    
900004251 900004251 in 100455892 900004251 100455892    
900004252 900004252 in 100455892 900004252 100455892    
900004253 900004253 in 100455892 900004253 100455892    
900004254 900004254 in 100455892 900004254 100455892    
900004255 900004255 in 100455892 900004255 100455892    

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