screen

9 rows where building = 100461304

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014783 10014783 in 100461304 10014783 100461304    
900004536 900004536 in 100461304 900004536 100461304    
900004537 900004537 in 100461304 900004537 100461304    
900004538 900004538 in 100461304 900004538 100461304    
900004539 900004539 in 100461304 900004539 100461304    
900004540 900004540 in 100461304 900004540 100461304    
900004541 900004541 in 100461304 900004541 100461304    
900004542 900004542 in 100461304 900004542 100461304    
900004543 900004543 in 100461304 900004543 100461304    

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