Get a single entity:

match (n{ID_RSSD: 802866}) return n;

Get a single entity and its immediate children:

match (n{ID_RSSD: 802866})-[:RELATIONSHIP]->(m) return n, m;

Get all active, domestic entities:

match (n:Active) where n.DOMESTIC_IND = "Y" return n limit 10;

Get the descendants of an entity, including mappings to LEI data about them:

MATCH (n{ID_RSSD: 802866})
CALL apoc.path.subgraphAll(n, {relationshipFilter: "RESOLVED_FROM|RELATIONSHIP>|TRANSFORMATION<|IS_DIRECTLY_CONSOLIDATED_BY<|IS_ULTIMATELY_CONSOLIDATED_BY<"})
YIELD nodes, relationships
RETURN nodes, relationships;

Get the descendants and ancestors of an entity, including mappings to LEI data about them:

MATCH (n{ID_RSSD: 802866}) CALL apoc.path.subgraphAll(n, {relationshipFilter: "RESOLVED_FROM|RELATIONSHIP>|TRANSFORMATION<|IS_DIRECTLY_CONSOLIDATED_BY<|IS_ULTIMATELY_CONSOLIDATED_BY<"}) YIELD nodes, relationships
WITH nodes as nodes1, relationships as relationships1
MATCH (n{ID_RSSD: 802866}) CALL apoc.path.subgraphAll(n, {relationshipFilter: "RESOLVED_FROM|RELATIONSHIP<|TRANSFORMATION>|IS_DIRECTLY_CONSOLIDATED_BY>|IS_ULTIMATELY_CONSOLIDATED_BY>"}) YIELD nodes, relationships
RETURN nodes1, relationships1, nodes, relationships;