screen

9 rows where building = 100466666

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014919 10014919 in 100466666 10014919 100466666    
900004624 900004624 in 100466666 900004624 100466666    
900004625 900004625 in 100466666 900004625 100466666    
900004626 900004626 in 100466666 900004626 100466666    
900004627 900004627 in 100466666 900004627 100466666    
900004628 900004628 in 100466666 900004628 100466666    
900004629 900004629 in 100466666 900004629 100466666    
900004630 900004630 in 100466666 900004630 100466666    
900004631 900004631 in 100466666 900004631 100466666    

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