screen

9 rows where building = 100461290

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014830 10014830 in 100461290 10014830 100461290    
900004472 900004472 in 100461290 900004472 100461290    
900004473 900004473 in 100461290 900004473 100461290    
900004474 900004474 in 100461290 900004474 100461290    
900004475 900004475 in 100461290 900004475 100461290    
900004476 900004476 in 100461290 900004476 100461290    
900004477 900004477 in 100461290 900004477 100461290    
900004478 900004478 in 100461290 900004478 100461290    
900004479 900004479 in 100461290 900004479 100461290    

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