screen

9 rows where building = 100466534

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014834 10014834 in 100466534 10014834 100466534    
900004552 900004552 in 100466534 900004552 100466534    
900004553 900004553 in 100466534 900004553 100466534    
900004554 900004554 in 100466534 900004554 100466534    
900004555 900004555 in 100466534 900004555 100466534    
900004556 900004556 in 100466534 900004556 100466534    
900004557 900004557 in 100466534 900004557 100466534    
900004558 900004558 in 100466534 900004558 100466534    
900004559 900004559 in 100466534 900004559 100466534    

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