screen

9 rows where building = 100454696

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014758 10014758 in 100454696 10014758 100454696    
900004208 900004208 in 100454696 900004208 100454696    
900004209 900004209 in 100454696 900004209 100454696    
900004210 900004210 in 100454696 900004210 100454696    
900004211 900004211 in 100454696 900004211 100454696    
900004212 900004212 in 100454696 900004212 100454696    
900004213 900004213 in 100454696 900004213 100454696    
900004214 900004214 in 100454696 900004214 100454696    
900004215 900004215 in 100454696 900004215 100454696    

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