Collecting relationships from multiple sources

match (r:Resolved)-[:RESOLVED_FROM]->(n) where (r)-[:RESOLVED_FROM]->()-[:IS_DIRECTLY_CONSOLIDATED_BY]->() and not ()-[:RELATIONSHIP]->(n) and n.NM_LGL is not null return r, n;

One result is

  • LEI: 5493004M1U54OO4KKE09
  • RSSD: 4437800

The LEI database has a parent, 549300C20KZIWPASBC15, and both nodes are in the NIC database, but there is no relationship in the NIC database.

LEI child is

  • https://search.gleif.org/#/record/5493004M1U54OO4KKE09
  • https://www.ffiec.gov/npw/Institution/Profile/4437800

LEI parent is

  • https://search.gleif.org/#/record/549300C20KZIWPASBC15
  • https://www.ffiec.gov/npw/Institution/Profile/3845855

This query enforces the requirement that there is an LEI entry for the NIC node:

match (r:Resolved)-[:RESOLVED_FROM]->(n) where (r)-[:RESOLVED_FROM]->()-[:IS_DIRECTLY_CONSOLIDATED_BY]->() and not ()-[:RELATIONSHIP]->(n) and n.NM_LGL is not null and n.ID_LEI <> "0" return r, n;

One result is

  • LEI: 5493001CNV0XACHGM520
  • RSSD: 4932864

LEI child is

  • https://search.gleif.org/#/record/5493001CNV0XACHGM520
  • https://www.ffiec.gov/npw/Institution/Profile/4932864

LEI parent is

  • https://search.gleif.org/#/record/5493000PAN0KGGJFC352
  • https://www.ffiec.gov/npw/Institution/Profile/4927909

Citigroup Busa Holdings

This query returns the resolved corporate subgroup for Citigroup Busa Holdings Inc. of the larger group, Citigroup.

MATCH (RESOLVED_BUSA:Resolved {LEI: "5493007GPNQIXPK19U57"})-[:RESOLVED_FROM]->(LEI_BUSA:LEI)<-[
:IS_DIRECTLY_CONSOLIDATED_BY|IS_ULTIMATELY_CONSOLIDATED_BY*..]-(LEI_CHILDREN:LEI)
MATCH(LEI_CHILDREN:LEI)<-[:RESOLVED_FROM]-(RESOLVED_CHILDREN:Resolved)

MATCH (RESOLVED_BUSA:Resolved {LEI: "5493007GPNQIXPK19U57"})-[:RESOLVED_FROM]->(NIC_BUSA:NIC)-[
:RELATIONSHIP|TRANSFORMATION*1..2]->(NIC_CHILDREN:NIC)
MATCH (NIC_CHILDREN:NIC)<-[:RESOLVED_FROM]-(RESOLVED_CHILDREN:Resolved)

RETURN RESOLVED_BUSA, LEI_BUSA, LEI_CHILDREN, NIC_BUSA, NIC_CHILDREN, RESOLVED_CHILDREN

Citigroup Busa Holdings LEI and NIC

  • https://search.gleif.org/#/record/5493007GPNQIXPK19U57
  • https://www.ffiec.gov/npw/Institution/Profile/3375352?dt=20170701

Mismatched edges

LEI-only

This query finds edges that are in the LEI database but not in the NIC database:

match (r:Resolved)-[:RESOLVED_FROM]->(n) where (r)-[:RESOLVED_FROM]->()-[:IS_DIRECTLY_CONSOLIDATED_BY]->() and not ()-[:RELATIONSHIP]->(n) and n.NM_LGL is not null and n.ID_LEI <> "0" return r, n;

This is an example from the above query of an edge found in LEI but not NIC between the same entities recorded in both datasets:

match (n{ID_RSSD: 4932864})<-[:RESOLVED_FROM]-(nr)-[:RESOLVED_FROM]->(nl{LEI: "5493001CNV0XACHGM520"})-[:IS_DIRECTLY_CONSOLIDATED_BY]->(ml{LEI: "5493000PAN0KGGJFC352"})<-[:RESOLVED_FROM]-(mr)-[:RESOLVED_FROM]->(m{ID_RSSD: 4927909}) where not (n)-[]-(m) return n, nr, nl, m, mr, ml;

This example can be confirmed in the original databases (as of 04/30/2023)

  • LEI: 5493001CNV0XACHGM520
  • RSSD: 4932864

The LEI child is

The LEI parent is

NIC-only

This query finds edges that are in the NIC database but not in the LEI database:

match (r:Resolved)-[:RESOLVED_FROM]->(n) where (r)-[:RESOLVED_FROM]->()-[:RELATIONSHIP]->() and not ()-[:IS_DIRECTLY_CONSOLIDATED_BY]->(n) and n.NM_LGL is not null and n.ID_LEI <> "0" return r, n;

This is an example from the above query of an edge found in NIC but not LEI between the same entities recorded in both datasets:

match (nl{LEI: "213800BVEFNZ8UYPKL03"})<-[:RESOLVED_FROM]-(nr)-[:RESOLVED_FROM]->(n{ID_RSSD: 4212584})<-[:RELATIONSHIP]-(m{ID_RSSD: 4738897})<-[:RESOLVED_FROM]-(mr)-[:RESOLVED_FROM]->(ml{LEI: "213800DKZ4WHI3JFWW71"}) where not (nl)-[]-(ml) return n, nr, nl, m, mr, ml;

This example can be confirmed in the original databases (as of 05/26/2023)

  • LEI: 213800BVEFNZ8UYPKL03
  • RSSD: 4212584

The LEI child is

The LEI parent is

Differing hierachies

This query returns the Amex Global Holdings C.V. company and its resolved LEI children. However, the hierarches differ in that the company is listed not to have children in the NIC database.

MATCH (n:Entity {LEI: "549300EHSDLRL5JI5C91"})<-[:RESOLVED_FROM]-(nr:Resolved)-[:RESOLVED_FROM]->(nl) WHERE NOT (nl)-[        
:RELATIONSHIP]->()
MATCH (n)<-[:IS_DIRECTLY_CONSOLIDATED_BY]-(m)<-[:RESOLVED_FROM]-(mr:Resolved)-[:RESOLVED_FROM]->(ml)
RETURN n, nr, nl, m, mr, ml

Amex Global Holdings LEI and NIC:

  • https://search.gleif.org/#/record/549300EHSDLRL5JI5C91
  • https://www.ffiec.gov/npw/Institution/Profile/4207991