screen

9 rows where building = 100454540

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014754 10014754 in 100454540 10014754 100454540    
900004160 900004160 in 100454540 900004160 100454540    
900004161 900004161 in 100454540 900004161 100454540    
900004162 900004162 in 100454540 900004162 100454540    
900004163 900004163 in 100454540 900004163 100454540    
900004164 900004164 in 100454540 900004164 100454540    
900004165 900004165 in 100454540 900004165 100454540    
900004166 900004166 in 100454540 900004166 100454540    
900004167 900004167 in 100454540 900004167 100454540    

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