screen

9 rows where building = 100456480

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014765 10014765 in 100456480 10014765 100456480    
900004328 900004328 in 100456480 900004328 100456480    
900004329 900004329 in 100456480 900004329 100456480    
900004330 900004330 in 100456480 900004330 100456480    
900004331 900004331 in 100456480 900004331 100456480    
900004332 900004332 in 100456480 900004332 100456480    
900004333 900004333 in 100456480 900004333 100456480    
900004334 900004334 in 100456480 900004334 100456480    
900004335 900004335 in 100456480 900004335 100456480    

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