screen

12 rows where building = 100410481

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10008898 10008898 in 100410481 10008898 100410481    
10008899 10008899 in 100410481 10008899 100410481    
10008900 10008900 in 100410481 10008900 100410481    
10008901 10008901 in 100410481 10008901 100410481    
900000168 900000168 in 100410481 900000168 100410481    
900000169 900000169 in 100410481 900000169 100410481    
900000170 900000170 in 100410481 900000170 100410481    
900000171 900000171 in 100410481 900000171 100410481    
900000172 900000172 in 100410481 900000172 100410481    
900000173 900000173 in 100410481 900000173 100410481    
900000174 900000174 in 100410481 900000174 100410481    
900000175 900000175 in 100410481 900000175 100410481    

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