screen

9 rows where building = 100455436

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014760 10014760 in 100455436 10014760 100455436    
900004232 900004232 in 100455436 900004232 100455436    
900004233 900004233 in 100455436 900004233 100455436    
900004234 900004234 in 100455436 900004234 100455436    
900004235 900004235 in 100455436 900004235 100455436    
900004236 900004236 in 100455436 900004236 100455436    
900004237 900004237 in 100455436 900004237 100455436    
900004238 900004238 in 100455436 900004238 100455436    
900004239 900004239 in 100455436 900004239 100455436    

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