screen

24 rows where network = 61

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ title name_publisher building network
10014045 10014045 - hilightScreen hilightScreen ISM-10 61
10014046 10014046 - hilightScreen hilightScreen ISM-19 61
10014047 10014047 - hilightScreen hilightScreen ISM-21 61
10014048 10014048 - hilightScreen hilightScreen ISM-22 61
10014049 10014049 - hilightScreen hilightScreen ISM-25 61
10014050 10014050 - hilightScreen hilightScreen ISM-33 61
10014051 10014051 - hilightScreen hilightScreen ISM-35 61
10014052 10014052 - hilightScreen hilightScreen ISM-40 61
10014053 10014053 - hilightScreen hilightScreen ISM-41 61
10014054 10014054 - hilightScreen hilightScreen ISM-42 61
10014055 10014055 - hilightScreen hilightScreen ISM-338 61
10014056 10014056 - hilightScreen hilightScreen ISM-807 61
10014057 10014057 - hilightScreen hilightScreen ISM-1108 61
10014058 10014058 - hilightScreen hilightScreen ISM-1179 61
10014059 10014059 - hilightScreen hilightScreen ISM-2204 61
10014060 10014060 - hilightScreen hilightScreen ISM-2311 61
10014061 10014061 - hilightScreen hilightScreen ISM-2321 61
10014062 10014062 - hilightScreen hilightScreen ISM-2365 61
10014063 10014063 - hilightScreen hilightScreen ISM-6725 61
10014064 10014064 - hilightScreen hilightScreen ISM-6726 61
10014065 10014065 - hilightScreen hilightScreen ISM-6740 61
10014066 10014066 - hilightScreen hilightScreen ISM-6801 61
10014067 10014067 - hilightScreen hilightScreen ISM-7961 61
10014068 10014068 - hilightScreen hilightScreen ISM-7967 61

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, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network) REFERENCES network (id)
);
CREATE INDEX ix_screen_network ON screen (network);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);
CREATE INDEX ix_screen_building ON screen (building);