screen

9 rows where building = 100456944

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014769 10014769 in 100456944 10014769 100456944    
900004352 900004352 in 100456944 900004352 100456944    
900004353 900004353 in 100456944 900004353 100456944    
900004354 900004354 in 100456944 900004354 100456944    
900004355 900004355 in 100456944 900004355 100456944    
900004356 900004356 in 100456944 900004356 100456944    
900004357 900004357 in 100456944 900004357 100456944    
900004358 900004358 in 100456944 900004358 100456944    
900004359 900004359 in 100456944 900004359 100456944    

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