screen

9 rows where building = 100460536

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014774 10014774 in 100460536 10014774 100460536    
900004432 900004432 in 100460536 900004432 100460536    
900004433 900004433 in 100460536 900004433 100460536    
900004434 900004434 in 100460536 900004434 100460536    
900004435 900004435 in 100460536 900004435 100460536    
900004436 900004436 in 100460536 900004436 100460536    
900004437 900004437 in 100460536 900004437 100460536    
900004438 900004438 in 100460536 900004438 100460536    
900004439 900004439 in 100460536 900004439 100460536    

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