NIC Examples Queries
Query: MATCH (n) RETURN n LIMIT 25
Description: Returns 25 nodes
Query: MATCH (n)-[e]->() RETURN n, e LIMIT 25
Description: Returns 25 nodes and/or edges
Query: MATCH (n {ID_RSSD: 5509526}) WITH n MATCH (m) WHERE m.ID_RSSD = n.ID_RSSD_HD_OFF RETURN m
Description: Returns the head office entity of CEDAR PARK BANKING CENTER (ID_RSSD: 5509526)
Query: MATCH (n:Active {ACT_PRIM_CD: "522299", STATE_ABBR_NM: "FL"}) RETURN n
Description: Returns all active entities with NAICS code 522299 (International, Secondary Market, and All Other Nondepository Credit Intermediation) in Florida
Query: MATCH (n:Branch) WHERE n.ENTITY_TYPE = "EBR" RETURN n
Description: Returns all domestic branch edge corporations
Query: MATCH (n) WHERE n.STATE_ABBR_NM = "IA" RETURN n.NM_LGL, n.ID_RSSD, n.ID_LEI, n.ID_CUSIP, n.ID_TAX
Description: Get all the entities in Iowa and return name, RSSD, LEI, CUSIP, and Tax ID. Returns a table like formatting.
Query: MATCH (n) WHERE n.ID_RSSD = 1951350 CALL apoc.path.subgraphNodes(n, {relationshipFilter: "RELATIONSHIP>"}) YIELD node RETURN node
Description: Returns the CITIGROUP INC. (ID_RSSD: 1951350) corporate group subgraph (note: the shown output is limited to 50 nodes)
Query: MATCH (n) WHERE n.ID_RSSD = 1951350 CALL apoc.path.subgraphNodes(n, {relationshipFilter: "RELATIONSHIP>", labelFilter: "Active|Branch"}) YIELD node RETURN node
Description: Returns only active and branch entities of the CITIGROUP INC. (ID_RSSD: 1951350) corporate group subgraph (note: the shown output is limited to 50 nodes)
Query: MATCH (n) WHERE n.ID_RSSD = 1951350 CALL apoc.path.subgraphNodes(n, {relationshipFilter: "RELATIONSHIP>"}) YIELD node WHERE node.D_DT_START < datetime({year:2003}) RETURN node
Description: Returns all entities from before 2003 in the CITIGROUP INC. (ID_RSSD: 1951350) corporate group subgraph (note: the shown output is limited to 50 nodes)
Query: MATCH (n) WHERE n.ID_RSSD = 1951350 CALL apoc.path.subgraphNodes(n, {relationshipFilter: "RELATIONSHIP>"}) YIELD node RETURN COUNT(node)
Description: Returns the count of all entities in the CITIGROUP INC. (ID_RSSD: 1951350) corporate group subgraph
Query: MATCH (n) WHERE n.ID_RSSD = 1951350 CALL apoc.path.subgraphNodes(n, {relationshipFilter: "RELATIONSHIP>"}) YIELD node WHERE node.D_DT_END >= datetime({year:2023}) RETURN COUNT(node)
Description: Returns the count of all entities in the CITIGROUP INC. (ID_RSSD: 1951350) corporate group subgraph that are still open as of 2023