screen

9 rows where building = 100466680

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014827 10014827 in 100466680 10014827 100466680    
900004656 900004656 in 100466680 900004656 100466680    
900004657 900004657 in 100466680 900004657 100466680    
900004658 900004658 in 100466680 900004658 100466680    
900004659 900004659 in 100466680 900004659 100466680    
900004660 900004660 in 100466680 900004660 100466680    
900004661 900004661 in 100466680 900004661 100466680    
900004662 900004662 in 100466680 900004662 100466680    
900004663 900004663 in 100466680 900004663 100466680    

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