screen

9 rows where building = 100457641

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014891 10014891 in 100457641 10014891 100457641    
900004376 900004376 in 100457641 900004376 100457641    
900004377 900004377 in 100457641 900004377 100457641    
900004378 900004378 in 100457641 900004378 100457641    
900004379 900004379 in 100457641 900004379 100457641    
900004380 900004380 in 100457641 900004380 100457641    
900004381 900004381 in 100457641 900004381 100457641    
900004382 900004382 in 100457641 900004382 100457641    
900004383 900004383 in 100457641 900004383 100457641    

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