screen

9 rows where building = 100460675

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014775 10014775 in 100460675 10014775 100460675    
900004448 900004448 in 100460675 900004448 100460675    
900004449 900004449 in 100460675 900004449 100460675    
900004450 900004450 in 100460675 900004450 100460675    
900004451 900004451 in 100460675 900004451 100460675    
900004452 900004452 in 100460675 900004452 100460675    
900004453 900004453 in 100460675 900004453 100460675    
900004454 900004454 in 100460675 900004454 100460675    
900004455 900004455 in 100460675 900004455 100460675    

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