screen

9 rows where building = 100466642

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014840 10014840 in 100466642 10014840 100466642    
900004616 900004616 in 100466642 900004616 100466642    
900004617 900004617 in 100466642 900004617 100466642    
900004618 900004618 in 100466642 900004618 100466642    
900004619 900004619 in 100466642 900004619 100466642    
900004620 900004620 in 100466642 900004620 100466642    
900004621 900004621 in 100466642 900004621 100466642    
900004622 900004622 in 100466642 900004622 100466642    
900004623 900004623 in 100466642 900004623 100466642    

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