screen

9 rows where building = 100429333

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014892 10014892 in 100429333 10014892 100429333    
900003976 900003976 in 100429333 900003976 100429333    
900003977 900003977 in 100429333 900003977 100429333    
900003978 900003978 in 100429333 900003978 100429333    
900003979 900003979 in 100429333 900003979 100429333    
900003980 900003980 in 100429333 900003980 100429333    
900003981 900003981 in 100429333 900003981 100429333    
900003982 900003982 in 100429333 900003982 100429333    
900003983 900003983 in 100429333 900003983 100429333    

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