spricht

10 rows where personID = 161

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

Link sprechrolleID personID pseudonymID position
620,161 620 620 Kerstin Draeger 161   1
761,161 761 761 Kerstin Draeger 161   1
816,161 816 816 Kerstin Draeger 161   1
829,161 829 829 Kerstin Draeger 161   1
1034,161 1034 1034 Kerstin Draeger 161   1
2331,161 2331 2331 Kerstin Draeger 161   1
2918,161 2918 2918 Kerstin Draeger 161   1
2964,161 2964 2964 Kerstin Draeger 161   12
3322,161 3322 3322 Kerstin Draeger 161   1
3421,161 3421 3421 Kerstin Draeger 161   1

Advanced export

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

CSV options: 

CREATE TABLE "spricht"(
  "sprechrolleID" INTEGER NOT NULL REFERENCES "sprechrolle"("sprechrolleID") ON DELETE CASCADE ON UPDATE CASCADE,
  "personID" INTEGER NOT NULL REFERENCES "person"("personID") ON DELETE CASCADE ON UPDATE CASCADE,
  "pseudonymID" INTEGER REFERENCES "pseudonym"("pseudonymID") ON DELETE SET NULL ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  PRIMARY KEY("sprechrolleID", "personID"),
  UNIQUE("sprechrolleID", "position")
);