screen

12 rows where building = 100454388

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10013920 10013920 in 100454388 10013920 100454388    
10013921 10013921 in 100454388 10013921 100454388    
10013922 10013922 in 100454388 10013922 100454388    
10013923 10013923 in 100454388 10013923 100454388    
900000176 900000176 in 100454388 900000176 100454388    
900000177 900000177 in 100454388 900000177 100454388    
900000178 900000178 in 100454388 900000178 100454388    
900000179 900000179 in 100454388 900000179 100454388    
900000180 900000180 in 100454388 900000180 100454388    
900000181 900000181 in 100454388 900000181 100454388    
900000182 900000182 in 100454388 900000182 100454388    
900000183 900000183 in 100454388 900000183 100454388    

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