screen

9 rows where building = 100455894

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014762 10014762 in 100455894 10014762 100455894    
900004264 900004264 in 100455894 900004264 100455894    
900004265 900004265 in 100455894 900004265 100455894    
900004266 900004266 in 100455894 900004266 100455894    
900004267 900004267 in 100455894 900004267 100455894    
900004268 900004268 in 100455894 900004268 100455894    
900004269 900004269 in 100455894 900004269 100455894    
900004270 900004270 in 100455894 900004270 100455894    
900004271 900004271 in 100455894 900004271 100455894    

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