screen

9 rows where building = 100460674

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014894 10014894 in 100460674 10014894 100460674    
900004440 900004440 in 100460674 900004440 100460674    
900004441 900004441 in 100460674 900004441 100460674    
900004442 900004442 in 100460674 900004442 100460674    
900004443 900004443 in 100460674 900004443 100460674    
900004444 900004444 in 100460674 900004444 100460674    
900004445 900004445 in 100460674 900004445 100460674    
900004446 900004446 in 100460674 900004446 100460674    
900004447 900004447 in 100460674 900004447 100460674    

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