screen

9 rows where building = 100460535

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014825 10014825 in 100460535 10014825 100460535    
900004424 900004424 in 100460535 900004424 100460535    
900004425 900004425 in 100460535 900004425 100460535    
900004426 900004426 in 100460535 900004426 100460535    
900004427 900004427 in 100460535 900004427 100460535    
900004428 900004428 in 100460535 900004428 100460535    
900004429 900004429 in 100460535 900004429 100460535    
900004430 900004430 in 100460535 900004430 100460535    
900004431 900004431 in 100460535 900004431 100460535    

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