screen

9 rows where building = 100456481

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014766 10014766 in 100456481 10014766 100456481    
900004336 900004336 in 100456481 900004336 100456481    
900004337 900004337 in 100456481 900004337 100456481    
900004338 900004338 in 100456481 900004338 100456481    
900004339 900004339 in 100456481 900004339 100456481    
900004340 900004340 in 100456481 900004340 100456481    
900004341 900004341 in 100456481 900004341 100456481    
900004342 900004342 in 100456481 900004342 100456481    
900004343 900004343 in 100456481 900004343 100456481    

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