screen

10 rows where building = 100461300

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014781 10014781 in 100461300 10014781 100461300    
10014808 10014808 in 100461300 10014808 100461300    
900004520 900004520 in 100461300 900004520 100461300    
900004521 900004521 in 100461300 900004521 100461300    
900004522 900004522 in 100461300 900004522 100461300    
900004523 900004523 in 100461300 900004523 100461300    
900004524 900004524 in 100461300 900004524 100461300    
900004525 900004525 in 100461300 900004525 100461300    
900004526 900004526 in 100461300 900004526 100461300    
900004527 900004527 in 100461300 900004527 100461300    

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