screen

9 rows where building = 100466688

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014826 10014826 in 100466688 10014826 100466688    
900004680 900004680 in 100466688 900004680 100466688    
900004681 900004681 in 100466688 900004681 100466688    
900004682 900004682 in 100466688 900004682 100466688    
900004683 900004683 in 100466688 900004683 100466688    
900004684 900004684 in 100466688 900004684 100466688    
900004685 900004685 in 100466688 900004685 100466688    
900004686 900004686 in 100466688 900004686 100466688    
900004687 900004687 in 100466688 900004687 100466688    

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