screen

9 rows where building = 100466541

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014900 10014900 in 100466541 10014900 100466541    
900004576 900004576 in 100466541 900004576 100466541    
900004577 900004577 in 100466541 900004577 100466541    
900004578 900004578 in 100466541 900004578 100466541    
900004579 900004579 in 100466541 900004579 100466541    
900004580 900004580 in 100466541 900004580 100466541    
900004581 900004581 in 100466541 900004581 100466541    
900004582 900004582 in 100466541 900004582 100466541    
900004583 900004583 in 100466541 900004583 100466541    

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