screen

9 rows where building = 100466610

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014908 10014908 in 100466610 10014908 100466610    
900004592 900004592 in 100466610 900004592 100466610    
900004593 900004593 in 100466610 900004593 100466610    
900004594 900004594 in 100466610 900004594 100466610    
900004595 900004595 in 100466610 900004595 100466610    
900004596 900004596 in 100466610 900004596 100466610    
900004597 900004597 in 100466610 900004597 100466610    
900004598 900004598 in 100466610 900004598 100466610    
900004599 900004599 in 100466610 900004599 100466610    

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