screen

9 rows where building = 100461306

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014897 10014897 in 100461306 10014897 100461306    
900004544 900004544 in 100461306 900004544 100461306    
900004545 900004545 in 100461306 900004545 100461306    
900004546 900004546 in 100461306 900004546 100461306    
900004547 900004547 in 100461306 900004547 100461306    
900004548 900004548 in 100461306 900004548 100461306    
900004549 900004549 in 100461306 900004549 100461306    
900004550 900004550 in 100461306 900004550 100461306    
900004551 900004551 in 100461306 900004551 100461306    

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