screen

9 rows where building = 100461298

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014832 10014832 in 100461298 10014832 100461298    
900004504 900004504 in 100461298 900004504 100461298    
900004505 900004505 in 100461298 900004505 100461298    
900004506 900004506 in 100461298 900004506 100461298    
900004507 900004507 in 100461298 900004507 100461298    
900004508 900004508 in 100461298 900004508 100461298    
900004509 900004509 in 100461298 900004509 100461298    
900004510 900004510 in 100461298 900004510 100461298    
900004511 900004511 in 100461298 900004511 100461298    

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