screen

10 rows where building = 100306171

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10008893 10008893 in 100306171 10008893 100306171    
10008894 10008894 in 100306171 10008894 100306171    
900000144 900000144 in 100306171 900000144 100306171    
900000145 900000145 in 100306171 900000145 100306171    
900000146 900000146 in 100306171 900000146 100306171    
900000147 900000147 in 100306171 900000147 100306171    
900000148 900000148 in 100306171 900000148 100306171    
900000149 900000149 in 100306171 900000149 100306171    
900000150 900000150 in 100306171 900000150 100306171    
900000151 900000151 in 100306171 900000151 100306171    

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