screen

9 rows where building = 100455893

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014887 10014887 in 100455893 10014887 100455893    
900004256 900004256 in 100455893 900004256 100455893    
900004257 900004257 in 100455893 900004257 100455893    
900004258 900004258 in 100455893 900004258 100455893    
900004259 900004259 in 100455893 900004259 100455893    
900004260 900004260 in 100455893 900004260 100455893    
900004261 900004261 in 100455893 900004261 100455893    
900004262 900004262 in 100455893 900004262 100455893    
900004263 900004263 in 100455893 900004263 100455893    

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