screen

9 rows where building = 100460411

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014893 10014893 in 100460411 10014893 100460411    
900004392 900004392 in 100460411 900004392 100460411    
900004393 900004393 in 100460411 900004393 100460411    
900004394 900004394 in 100460411 900004394 100460411    
900004395 900004395 in 100460411 900004395 100460411    
900004396 900004396 in 100460411 900004396 100460411    
900004397 900004397 in 100460411 900004397 100460411    
900004398 900004398 in 100460411 900004398 100460411    
900004399 900004399 in 100460411 900004399 100460411    

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