screen

9 rows where building = 100456436

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014890 10014890 in 100456436 10014890 100456436    
900004312 900004312 in 100456436 900004312 100456436    
900004313 900004313 in 100456436 900004313 100456436    
900004314 900004314 in 100456436 900004314 100456436    
900004315 900004315 in 100456436 900004315 100456436    
900004316 900004316 in 100456436 900004316 100456436    
900004317 900004317 in 100456436 900004317 100456436    
900004318 900004318 in 100456436 900004318 100456436    
900004319 900004319 in 100456436 900004319 100456436    

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