screen

10 rows where building = 100456749

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014767 10014767 in 100456749 10014767 100456749    
10014768 10014768 in 100456749 10014768 100456749    
900004344 900004344 in 100456749 900004344 100456749    
900004345 900004345 in 100456749 900004345 100456749    
900004346 900004346 in 100456749 900004346 100456749    
900004347 900004347 in 100456749 900004347 100456749    
900004348 900004348 in 100456749 900004348 100456749    
900004349 900004349 in 100456749 900004349 100456749    
900004350 900004350 in 100456749 900004350 100456749    
900004351 900004351 in 100456749 900004351 100456749    

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