screen

9 rows where building = "TVW-2211102"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10000096 10000096 in TVW-2211102 10000096 TVW-2211102    
900003424 900003424 in TVW-2211102 900003424 TVW-2211102    
900003425 900003425 in TVW-2211102 900003425 TVW-2211102    
900003426 900003426 in TVW-2211102 900003426 TVW-2211102    
900003427 900003427 in TVW-2211102 900003427 TVW-2211102    
900003428 900003428 in TVW-2211102 900003428 TVW-2211102    
900003429 900003429 in TVW-2211102 900003429 TVW-2211102    
900003430 900003430 in TVW-2211102 900003430 TVW-2211102    
900003431 900003431 in TVW-2211102 900003431 TVW-2211102    

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