screen

18 rows where building = 100306027

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10009102 10009102 in 100306027 10009102 100306027    
10009103 10009103 in 100306027 10009103 100306027    
10009104 10009104 in 100306027 10009104 100306027    
10009105 10009105 in 100306027 10009105 100306027    
10009106 10009106 in 100306027 10009106 100306027    
10009107 10009107 in 100306027 10009107 100306027    
10009108 10009108 in 100306027 10009108 100306027    
10009109 10009109 in 100306027 10009109 100306027    
10010487 10010487 in 100306027 10010487 100306027    
10010608 10010608 in 100306027 10010608 100306027    
900000136 900000136 in 100306027 900000136 100306027    
900000137 900000137 in 100306027 900000137 100306027    
900000138 900000138 in 100306027 900000138 100306027    
900000139 900000139 in 100306027 900000139 100306027    
900000140 900000140 in 100306027 900000140 100306027    
900000141 900000141 in 100306027 900000141 100306027    
900000142 900000142 in 100306027 900000142 100306027    
900000143 900000143 in 100306027 900000143 100306027    

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