screen

9 rows where building = 100466539

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014899 10014899 in 100466539 10014899 100466539    
900004568 900004568 in 100466539 900004568 100466539    
900004569 900004569 in 100466539 900004569 100466539    
900004570 900004570 in 100466539 900004570 100466539    
900004571 900004571 in 100466539 900004571 100466539    
900004572 900004572 in 100466539 900004572 100466539    
900004573 900004573 in 100466539 900004573 100466539    
900004574 900004574 in 100466539 900004574 100466539    
900004575 900004575 in 100466539 900004575 100466539    

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