screen

9 rows where building = 100453818

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014749 10014749 in 100453818 10014749 100453818    
900004040 900004040 in 100453818 900004040 100453818    
900004041 900004041 in 100453818 900004041 100453818    
900004042 900004042 in 100453818 900004042 100453818    
900004043 900004043 in 100453818 900004043 100453818    
900004044 900004044 in 100453818 900004044 100453818    
900004045 900004045 in 100453818 900004045 100453818    
900004046 900004046 in 100453818 900004046 100453818    
900004047 900004047 in 100453818 900004047 100453818    

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