screen

9 rows where building = 100460412

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014772 10014772 in 100460412 10014772 100460412    
900004400 900004400 in 100460412 900004400 100460412    
900004401 900004401 in 100460412 900004401 100460412    
900004402 900004402 in 100460412 900004402 100460412    
900004403 900004403 in 100460412 900004403 100460412    
900004404 900004404 in 100460412 900004404 100460412    
900004405 900004405 in 100460412 900004405 100460412    
900004406 900004406 in 100460412 900004406 100460412    
900004407 900004407 in 100460412 900004407 100460412    

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