screen

9 rows where building = 100466548

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014828 10014828 in 100466548 10014828 100466548    
900004584 900004584 in 100466548 900004584 100466548    
900004585 900004585 in 100466548 900004585 100466548    
900004586 900004586 in 100466548 900004586 100466548    
900004587 900004587 in 100466548 900004587 100466548    
900004588 900004588 in 100466548 900004588 100466548    
900004589 900004589 in 100466548 900004589 100466548    
900004590 900004590 in 100466548 900004590 100466548    
900004591 900004591 in 100466548 900004591 100466548    

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