screen

9 rows where building = 100452970

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014822 10014822 in 100452970 10014822 100452970    
900004032 900004032 in 100452970 900004032 100452970    
900004033 900004033 in 100452970 900004033 100452970    
900004034 900004034 in 100452970 900004034 100452970    
900004035 900004035 in 100452970 900004035 100452970    
900004036 900004036 in 100452970 900004036 100452970    
900004037 900004037 in 100452970 900004037 100452970    
900004038 900004038 in 100452970 900004038 100452970    
900004039 900004039 in 100452970 900004039 100452970    

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