screen

9 rows where building = 100453819

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014873 10014873 in 100453819 10014873 100453819    
900004048 900004048 in 100453819 900004048 100453819    
900004049 900004049 in 100453819 900004049 100453819    
900004050 900004050 in 100453819 900004050 100453819    
900004051 900004051 in 100453819 900004051 100453819    
900004052 900004052 in 100453819 900004052 100453819    
900004053 900004053 in 100453819 900004053 100453819    
900004054 900004054 in 100453819 900004054 100453819    
900004055 900004055 in 100453819 900004055 100453819    

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