screen

9 rows where building = 100461295

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014778 10014778 in 100461295 10014778 100461295    
900004488 900004488 in 100461295 900004488 100461295    
900004489 900004489 in 100461295 900004489 100461295    
900004490 900004490 in 100461295 900004490 100461295    
900004491 900004491 in 100461295 900004491 100461295    
900004492 900004492 in 100461295 900004492 100461295    
900004493 900004493 in 100461295 900004493 100461295    
900004494 900004494 in 100461295 900004494 100461295    
900004495 900004495 in 100461295 900004495 100461295    

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