screen

10 rows where building = 100457630

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014944 10014944 in 100457630 10014944 100457630    
10014945 10014945 in 100457630 10014945 100457630    
900004360 900004360 in 100457630 900004360 100457630    
900004361 900004361 in 100457630 900004361 100457630    
900004362 900004362 in 100457630 900004362 100457630    
900004363 900004363 in 100457630 900004363 100457630    
900004364 900004364 in 100457630 900004364 100457630    
900004365 900004365 in 100457630 900004365 100457630    
900004366 900004366 in 100457630 900004366 100457630    
900004367 900004367 in 100457630 900004367 100457630    

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