screen

9 rows where building = 100454080

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014750 10014750 in 100454080 10014750 100454080    
900004088 900004088 in 100454080 900004088 100454080    
900004089 900004089 in 100454080 900004089 100454080    
900004090 900004090 in 100454080 900004090 100454080    
900004091 900004091 in 100454080 900004091 100454080    
900004092 900004092 in 100454080 900004092 100454080    
900004093 900004093 in 100454080 900004093 100454080    
900004094 900004094 in 100454080 900004094 100454080    
900004095 900004095 in 100454080 900004095 100454080    

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