screen

12 rows where building = 100460384

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014537 10014537 in 100460384 10014537 100460384    
10014538 10014538 in 100460384 10014538 100460384    
10014539 10014539 in 100460384 10014539 100460384    
10014540 10014540 in 100460384 10014540 100460384    
900000392 900000392 in 100460384 900000392 100460384    
900000393 900000393 in 100460384 900000393 100460384    
900000394 900000394 in 100460384 900000394 100460384    
900000395 900000395 in 100460384 900000395 100460384    
900000396 900000396 in 100460384 900000396 100460384    
900000397 900000397 in 100460384 900000397 100460384    
900000398 900000398 in 100460384 900000398 100460384    
900000399 900000399 in 100460384 900000399 100460384    

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