screen

9 rows where building = 100454074

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014878 10014878 in 100454074 10014878 100454074    
900004080 900004080 in 100454074 900004080 100454074    
900004081 900004081 in 100454074 900004081 100454074    
900004082 900004082 in 100454074 900004082 100454074    
900004083 900004083 in 100454074 900004083 100454074    
900004084 900004084 in 100454074 900004084 100454074    
900004085 900004085 in 100454074 900004085 100454074    
900004086 900004086 in 100454074 900004086 100454074    
900004087 900004087 in 100454074 900004087 100454074    

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