screen

9 rows where building = 100444805

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014871 10014871 in 100444805 10014871 100444805    
900003984 900003984 in 100444805 900003984 100444805    
900003985 900003985 in 100444805 900003985 100444805    
900003986 900003986 in 100444805 900003986 100444805    
900003987 900003987 in 100444805 900003987 100444805    
900003988 900003988 in 100444805 900003988 100444805    
900003989 900003989 in 100444805 900003989 100444805    
900003990 900003990 in 100444805 900003990 100444805    
900003991 900003991 in 100444805 900003991 100444805    

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