screen

9 rows where building = 100412559

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014747 10014747 in 100412559 10014747 100412559    
900003968 900003968 in 100412559 900003968 100412559    
900003969 900003969 in 100412559 900003969 100412559    
900003970 900003970 in 100412559 900003970 100412559    
900003971 900003971 in 100412559 900003971 100412559    
900003972 900003972 in 100412559 900003972 100412559    
900003973 900003973 in 100412559 900003973 100412559    
900003974 900003974 in 100412559 900003974 100412559    
900003975 900003975 in 100412559 900003975 100412559    

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