screen

9 rows where building = 100456228

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014888 10014888 in 100456228 10014888 100456228    
900004272 900004272 in 100456228 900004272 100456228    
900004273 900004273 in 100456228 900004273 100456228    
900004274 900004274 in 100456228 900004274 100456228    
900004275 900004275 in 100456228 900004275 100456228    
900004276 900004276 in 100456228 900004276 100456228    
900004277 900004277 in 100456228 900004277 100456228    
900004278 900004278 in 100456228 900004278 100456228    
900004279 900004279 in 100456228 900004279 100456228    

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