screen

9 rows where building = 100454083

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014879 10014879 in 100454083 10014879 100454083    
900004104 900004104 in 100454083 900004104 100454083    
900004105 900004105 in 100454083 900004105 100454083    
900004106 900004106 in 100454083 900004106 100454083    
900004107 900004107 in 100454083 900004107 100454083    
900004108 900004108 in 100454083 900004108 100454083    
900004109 900004109 in 100454083 900004109 100454083    
900004110 900004110 in 100454083 900004110 100454083    
900004111 900004111 in 100454083 900004111 100454083    

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