screen

9 rows where building = 100454235

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014880 10014880 in 100454235 10014880 100454235    
900004112 900004112 in 100454235 900004112 100454235    
900004113 900004113 in 100454235 900004113 100454235    
900004114 900004114 in 100454235 900004114 100454235    
900004115 900004115 in 100454235 900004115 100454235    
900004116 900004116 in 100454235 900004116 100454235    
900004117 900004117 in 100454235 900004117 100454235    
900004118 900004118 in 100454235 900004118 100454235    
900004119 900004119 in 100454235 900004119 100454235    

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