screen

9 rows where building = 100460681

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014777 10014777 in 100460681 10014777 100460681    
900004464 900004464 in 100460681 900004464 100460681    
900004465 900004465 in 100460681 900004465 100460681    
900004466 900004466 in 100460681 900004466 100460681    
900004467 900004467 in 100460681 900004467 100460681    
900004468 900004468 in 100460681 900004468 100460681    
900004469 900004469 in 100460681 900004469 100460681    
900004470 900004470 in 100460681 900004470 100460681    
900004471 900004471 in 100460681 900004471 100460681    

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