screen

9 rows where building = 100466687

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014843 10014843 in 100466687 10014843 100466687    
900004672 900004672 in 100466687 900004672 100466687    
900004673 900004673 in 100466687 900004673 100466687    
900004674 900004674 in 100466687 900004674 100466687    
900004675 900004675 in 100466687 900004675 100466687    
900004676 900004676 in 100466687 900004676 100466687    
900004677 900004677 in 100466687 900004677 100466687    
900004678 900004678 in 100466687 900004678 100466687    
900004679 900004679 in 100466687 900004679 100466687    

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