screen

9 rows where building = 100460413

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014773 10014773 in 100460413 10014773 100460413    
900004408 900004408 in 100460413 900004408 100460413    
900004409 900004409 in 100460413 900004409 100460413    
900004410 900004410 in 100460413 900004410 100460413    
900004411 900004411 in 100460413 900004411 100460413    
900004412 900004412 in 100460413 900004412 100460413    
900004413 900004413 in 100460413 900004413 100460413    
900004414 900004414 in 100460413 900004414 100460413    
900004415 900004415 in 100460413 900004415 100460413    

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