screen

9 rows where building = 100454073

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014877 10014877 in 100454073 10014877 100454073    
900004072 900004072 in 100454073 900004072 100454073    
900004073 900004073 in 100454073 900004073 100454073    
900004074 900004074 in 100454073 900004074 100454073    
900004075 900004075 in 100454073 900004075 100454073    
900004076 900004076 in 100454073 900004076 100454073    
900004077 900004077 in 100454073 900004077 100454073    
900004078 900004078 in 100454073 900004078 100454073    
900004079 900004079 in 100454073 900004079 100454073    

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