screen

9 rows where building = 100454382

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014882 10014882 in 100454382 10014882 100454382    
900004128 900004128 in 100454382 900004128 100454382    
900004129 900004129 in 100454382 900004129 100454382    
900004130 900004130 in 100454382 900004130 100454382    
900004131 900004131 in 100454382 900004131 100454382    
900004132 900004132 in 100454382 900004132 100454382    
900004133 900004133 in 100454382 900004133 100454382    
900004134 900004134 in 100454382 900004134 100454382    
900004135 900004135 in 100454382 900004135 100454382    

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