screen

10 rows where building = 100460386

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014541 10014541 in 100460386 10014541 100460386    
10014542 10014542 in 100460386 10014542 100460386    
900000400 900000400 in 100460386 900000400 100460386    
900000401 900000401 in 100460386 900000401 100460386    
900000402 900000402 in 100460386 900000402 100460386    
900000403 900000403 in 100460386 900000403 100460386    
900000404 900000404 in 100460386 900000404 100460386    
900000405 900000405 in 100460386 900000405 100460386    
900000406 900000406 in 100460386 900000406 100460386    
900000407 900000407 in 100460386 900000407 100460386    

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