screen

9 rows where building = 100454702

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014759 10014759 in 100454702 10014759 100454702    
900004216 900004216 in 100454702 900004216 100454702    
900004217 900004217 in 100454702 900004217 100454702    
900004218 900004218 in 100454702 900004218 100454702    
900004219 900004219 in 100454702 900004219 100454702    
900004220 900004220 in 100454702 900004220 100454702    
900004221 900004221 in 100454702 900004221 100454702    
900004222 900004222 in 100454702 900004222 100454702    
900004223 900004223 in 100454702 900004223 100454702    

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