screen

9 rows where building = 100466672

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014912 10014912 in 100466672 10014912 100466672    
900004640 900004640 in 100466672 900004640 100466672    
900004641 900004641 in 100466672 900004641 100466672    
900004642 900004642 in 100466672 900004642 100466672    
900004643 900004643 in 100466672 900004643 100466672    
900004644 900004644 in 100466672 900004644 100466672    
900004645 900004645 in 100466672 900004645 100466672    
900004646 900004646 in 100466672 900004646 100466672    
900004647 900004647 in 100466672 900004647 100466672    

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