screen

9 rows where building = 100466614

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014829 10014829 in 100466614 10014829 100466614    
900004608 900004608 in 100466614 900004608 100466614    
900004609 900004609 in 100466614 900004609 100466614    
900004610 900004610 in 100466614 900004610 100466614    
900004611 900004611 in 100466614 900004611 100466614    
900004612 900004612 in 100466614 900004612 100466614    
900004613 900004613 in 100466614 900004613 100466614    
900004614 900004614 in 100466614 900004614 100466614    
900004615 900004615 in 100466614 900004615 100466614    

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