screen

9 rows where building = 100455603

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014824 10014824 in 100455603 10014824 100455603    
900004240 900004240 in 100455603 900004240 100455603    
900004241 900004241 in 100455603 900004241 100455603    
900004242 900004242 in 100455603 900004242 100455603    
900004243 900004243 in 100455603 900004243 100455603    
900004244 900004244 in 100455603 900004244 100455603    
900004245 900004245 in 100455603 900004245 100455603    
900004246 900004246 in 100455603 900004246 100455603    
900004247 900004247 in 100455603 900004247 100455603    

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