screen

9 rows where building = 100453935

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014875 10014875 in 100453935 10014875 100453935    
900004064 900004064 in 100453935 900004064 100453935    
900004065 900004065 in 100453935 900004065 100453935    
900004066 900004066 in 100453935 900004066 100453935    
900004067 900004067 in 100453935 900004067 100453935    
900004068 900004068 in 100453935 900004068 100453935    
900004069 900004069 in 100453935 900004069 100453935    
900004070 900004070 in 100453935 900004070 100453935    
900004071 900004071 in 100453935 900004071 100453935    

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