screen

16 rows where building = 100306331

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10009038 10009038 in 100306331 10009038 100306331    
10009039 10009039 in 100306331 10009039 100306331    
10009040 10009040 in 100306331 10009040 100306331    
10009041 10009041 in 100306331 10009041 100306331    
10009042 10009042 in 100306331 10009042 100306331    
10009043 10009043 in 100306331 10009043 100306331    
10010490 10010490 in 100306331 10010490 100306331    
10010548 10010548 in 100306331 10010548 100306331    
900000152 900000152 in 100306331 900000152 100306331    
900000153 900000153 in 100306331 900000153 100306331    
900000154 900000154 in 100306331 900000154 100306331    
900000155 900000155 in 100306331 900000155 100306331    
900000156 900000156 in 100306331 900000156 100306331    
900000157 900000157 in 100306331 900000157 100306331    
900000158 900000158 in 100306331 900000158 100306331    
900000159 900000159 in 100306331 900000159 100306331    

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