screen

9 rows where building = 100451948

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014872 10014872 in 100451948 10014872 100451948    
900004024 900004024 in 100451948 900004024 100451948    
900004025 900004025 in 100451948 900004025 100451948    
900004026 900004026 in 100451948 900004026 100451948    
900004027 900004027 in 100451948 900004027 100451948    
900004028 900004028 in 100451948 900004028 100451948    
900004029 900004029 in 100451948 900004029 100451948    
900004030 900004030 in 100451948 900004030 100451948    
900004031 900004031 in 100451948 900004031 100451948    

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