screen

9 rows where building = 100456305

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014889 10014889 in 100456305 10014889 100456305    
900004280 900004280 in 100456305 900004280 100456305    
900004281 900004281 in 100456305 900004281 100456305    
900004282 900004282 in 100456305 900004282 100456305    
900004283 900004283 in 100456305 900004283 100456305    
900004284 900004284 in 100456305 900004284 100456305    
900004285 900004285 in 100456305 900004285 100456305    
900004286 900004286 in 100456305 900004286 100456305    
900004287 900004287 in 100456305 900004287 100456305    

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