screen

10 rows where building = 100460533

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014818 10014818 in 100460533 10014818 100460533    
10014819 10014819 in 100460533 10014819 100460533    
900004416 900004416 in 100460533 900004416 100460533    
900004417 900004417 in 100460533 900004417 100460533    
900004418 900004418 in 100460533 900004418 100460533    
900004419 900004419 in 100460533 900004419 100460533    
900004420 900004420 in 100460533 900004420 100460533    
900004421 900004421 in 100460533 900004421 100460533    
900004422 900004422 in 100460533 900004422 100460533    
900004423 900004423 in 100460533 900004423 100460533    

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