screen

9 rows where building = 100458426

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014771 10014771 in 100458426 10014771 100458426    
900004384 900004384 in 100458426 900004384 100458426    
900004385 900004385 in 100458426 900004385 100458426    
900004386 900004386 in 100458426 900004386 100458426    
900004387 900004387 in 100458426 900004387 100458426    
900004388 900004388 in 100458426 900004388 100458426    
900004389 900004389 in 100458426 900004389 100458426    
900004390 900004390 in 100458426 900004390 100458426    
900004391 900004391 in 100458426 900004391 100458426    

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