screen

9 rows where building = 100454566

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014885 10014885 in 100454566 10014885 100454566    
900004200 900004200 in 100454566 900004200 100454566    
900004201 900004201 in 100454566 900004201 100454566    
900004202 900004202 in 100454566 900004202 100454566    
900004203 900004203 in 100454566 900004203 100454566    
900004204 900004204 in 100454566 900004204 100454566    
900004205 900004205 in 100454566 900004205 100454566    
900004206 900004206 in 100454566 900004206 100454566    
900004207 900004207 in 100454566 900004207 100454566    

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