screen

9 rows where building = 100461292

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014831 10014831 in 100461292 10014831 100461292    
900004480 900004480 in 100461292 900004480 100461292    
900004481 900004481 in 100461292 900004481 100461292    
900004482 900004482 in 100461292 900004482 100461292    
900004483 900004483 in 100461292 900004483 100461292    
900004484 900004484 in 100461292 900004484 100461292    
900004485 900004485 in 100461292 900004485 100461292    
900004486 900004486 in 100461292 900004486 100461292    
900004487 900004487 in 100461292 900004487 100461292    

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