screen

9 rows where building = 100466678

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014926 10014926 in 100466678 10014926 100466678    
900004648 900004648 in 100466678 900004648 100466678    
900004649 900004649 in 100466678 900004649 100466678    
900004650 900004650 in 100466678 900004650 100466678    
900004651 900004651 in 100466678 900004651 100466678    
900004652 900004652 in 100466678 900004652 100466678    
900004653 900004653 in 100466678 900004653 100466678    
900004654 900004654 in 100466678 900004654 100466678    
900004655 900004655 in 100466678 900004655 100466678    

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