screen

9 rows where building = 100461303

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014895 10014895 in 100461303 10014895 100461303    
900004528 900004528 in 100461303 900004528 100461303    
900004529 900004529 in 100461303 900004529 100461303    
900004530 900004530 in 100461303 900004530 100461303    
900004531 900004531 in 100461303 900004531 100461303    
900004532 900004532 in 100461303 900004532 100461303    
900004533 900004533 in 100461303 900004533 100461303    
900004534 900004534 in 100461303 900004534 100461303    
900004535 900004535 in 100461303 900004535 100461303    

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