screen

9 rows where building = 100461297

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014896 10014896 in 100461297 10014896 100461297    
900004496 900004496 in 100461297 900004496 100461297    
900004497 900004497 in 100461297 900004497 100461297    
900004498 900004498 in 100461297 900004498 100461297    
900004499 900004499 in 100461297 900004499 100461297    
900004500 900004500 in 100461297 900004500 100461297    
900004501 900004501 in 100461297 900004501 100461297    
900004502 900004502 in 100461297 900004502 100461297    
900004503 900004503 in 100461297 900004503 100461297    

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