screen

9 rows where building = 100466611

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014837 10014837 in 100466611 10014837 100466611    
900004600 900004600 in 100466611 900004600 100466611    
900004601 900004601 in 100466611 900004601 100466611    
900004602 900004602 in 100466611 900004602 100466611    
900004603 900004603 in 100466611 900004603 100466611    
900004604 900004604 in 100466611 900004604 100466611    
900004605 900004605 in 100466611 900004605 100466611    
900004606 900004606 in 100466611 900004606 100466611    
900004607 900004607 in 100466611 900004607 100466611    

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