screen

9 rows where building = 100460677

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014776 10014776 in 100460677 10014776 100460677    
900004456 900004456 in 100460677 900004456 100460677    
900004457 900004457 in 100460677 900004457 100460677    
900004458 900004458 in 100460677 900004458 100460677    
900004459 900004459 in 100460677 900004459 100460677    
900004460 900004460 in 100460677 900004460 100460677    
900004461 900004461 in 100460677 900004461 100460677    
900004462 900004462 in 100460677 900004462 100460677    
900004463 900004463 in 100460677 900004463 100460677    

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