screen

10 rows where building = 100460387

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network venue_id
10014543 10014543 in 100460387 10014543 100460387    
10014544 10014544 in 100460387 10014544 100460387    
900000408 900000408 in 100460387 900000408 100460387    
900000409 900000409 in 100460387 900000409 100460387    
900000410 900000410 in 100460387 900000410 100460387    
900000411 900000411 in 100460387 900000411 100460387    
900000412 900000412 in 100460387 900000412 100460387    
900000413 900000413 in 100460387 900000413 100460387    
900000414 900000414 in 100460387 900000414 100460387    
900000415 900000415 in 100460387 900000415 100460387    

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