screen

9 rows where building = 100466668

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014841 10014841 in 100466668 10014841 100466668    
900004632 900004632 in 100466668 900004632 100466668    
900004633 900004633 in 100466668 900004633 100466668    
900004634 900004634 in 100466668 900004634 100466668    
900004635 900004635 in 100466668 900004635 100466668    
900004636 900004636 in 100466668 900004636 100466668    
900004637 900004637 in 100466668 900004637 100466668    
900004638 900004638 in 100466668 900004638 100466668    
900004639 900004639 in 100466668 900004639 100466668    

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