screen

9 rows where building = 100445665

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014948 10014948 in 100445665 10014948 100445665    
900003992 900003992 in 100445665 900003992 100445665    
900003993 900003993 in 100445665 900003993 100445665    
900003994 900003994 in 100445665 900003994 100445665    
900003995 900003995 in 100445665 900003995 100445665    
900003996 900003996 in 100445665 900003996 100445665    
900003997 900003997 in 100445665 900003997 100445665    
900003998 900003998 in 100445665 900003998 100445665    
900003999 900003999 in 100445665 900003999 100445665    

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