screen

9 rows where building = 100454403

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014823 10014823 in 100454403 10014823 100454403    
900004152 900004152 in 100454403 900004152 100454403    
900004153 900004153 in 100454403 900004153 100454403    
900004154 900004154 in 100454403 900004154 100454403    
900004155 900004155 in 100454403 900004155 100454403    
900004156 900004156 in 100454403 900004156 100454403    
900004157 900004157 in 100454403 900004157 100454403    
900004158 900004158 in 100454403 900004158 100454403    
900004159 900004159 in 100454403 900004159 100454403    

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