screen

9 rows where building = 100457639

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014770 10014770 in 100457639 10014770 100457639    
900004368 900004368 in 100457639 900004368 100457639    
900004369 900004369 in 100457639 900004369 100457639    
900004370 900004370 in 100457639 900004370 100457639    
900004371 900004371 in 100457639 900004371 100457639    
900004372 900004372 in 100457639 900004372 100457639    
900004373 900004373 in 100457639 900004373 100457639    
900004374 900004374 in 100457639 900004374 100457639    
900004375 900004375 in 100457639 900004375 100457639    

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