screen

9 rows where building = 100461299

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014833 10014833 in 100461299 10014833 100461299    
900004512 900004512 in 100461299 900004512 100461299    
900004513 900004513 in 100461299 900004513 100461299    
900004514 900004514 in 100461299 900004514 100461299    
900004515 900004515 in 100461299 900004515 100461299    
900004516 900004516 in 100461299 900004516 100461299    
900004517 900004517 in 100461299 900004517 100461299    
900004518 900004518 in 100461299 900004518 100461299    
900004519 900004519 in 100461299 900004519 100461299    

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