screen

9 rows where building = 100454082

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014751 10014751 in 100454082 10014751 100454082    
900004096 900004096 in 100454082 900004096 100454082    
900004097 900004097 in 100454082 900004097 100454082    
900004098 900004098 in 100454082 900004098 100454082    
900004099 900004099 in 100454082 900004099 100454082    
900004100 900004100 in 100454082 900004100 100454082    
900004101 900004101 in 100454082 900004101 100454082    
900004102 900004102 in 100454082 900004102 100454082    
900004103 900004103 in 100454082 900004103 100454082    

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