spotset

9 rows where publisher = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: extern

id ▼ name publisher extern
2 CITTADINO GmbH CITTADINO GmbH 2 1
3 CITTADINO GmbH (1) CITTADINO GmbH 2 1
4 CITTADINO GmbH (2) CITTADINO GmbH 2 1
5 CITTADINO GmbH (3) CITTADINO GmbH 2 1
6 CITTADINO GmbH (4) CITTADINO GmbH 2 1
35 CITTADINO GmbH (5) CITTADINO GmbH 2 0
36 CITTADINO GmbH (6) CITTADINO GmbH 2 0
37 CITTADINO GmbH (7) CITTADINO GmbH 2 0
38 CITTADINO GmbH (8) CITTADINO GmbH 2 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE spotset (
	id INTEGER NOT NULL, 
	name VARCHAR(250), 
	publisher INTEGER, 
	extern BOOLEAN, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE UNIQUE INDEX ix_spotset_name ON spotset (name);
CREATE INDEX ix_spotset_publisher ON spotset (publisher);
CREATE INDEX ix_spotset_extern ON spotset (extern);