screen

9 rows where building = 100453820

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014874 10014874 in 100453820 10014874 100453820    
900004056 900004056 in 100453820 900004056 100453820    
900004057 900004057 in 100453820 900004057 100453820    
900004058 900004058 in 100453820 900004058 100453820    
900004059 900004059 in 100453820 900004059 100453820    
900004060 900004060 in 100453820 900004060 100453820    
900004061 900004061 in 100453820 900004061 100453820    
900004062 900004062 in 100453820 900004062 100453820    
900004063 900004063 in 100453820 900004063 100453820    

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