screen

11 rows where building = 100456437

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014881 10014881 in 100456437 10014881 100456437    
10014946 10014946 in 100456437 10014946 100456437    
10014947 10014947 in 100456437 10014947 100456437    
900004320 900004320 in 100456437 900004320 100456437    
900004321 900004321 in 100456437 900004321 100456437    
900004322 900004322 in 100456437 900004322 100456437    
900004323 900004323 in 100456437 900004323 100456437    
900004324 900004324 in 100456437 900004324 100456437    
900004325 900004325 in 100456437 900004325 100456437    
900004326 900004326 in 100456437 900004326 100456437    
900004327 900004327 in 100456437 900004327 100456437    

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