screen

9 rows where building = 100466535

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014898 10014898 in 100466535 10014898 100466535    
900004560 900004560 in 100466535 900004560 100466535    
900004561 900004561 in 100466535 900004561 100466535    
900004562 900004562 in 100466535 900004562 100466535    
900004563 900004563 in 100466535 900004563 100466535    
900004564 900004564 in 100466535 900004564 100466535    
900004565 900004565 in 100466535 900004565 100466535    
900004566 900004566 in 100466535 900004566 100466535    
900004567 900004567 in 100466535 900004567 100466535    

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