Linking OrgReg or CIB data with RPD

Context

  • The OrgReg (Register of Public-Sector Organizations) is a central facility within the EU-FP Research Infrastructure for Research and Innovation Studies project (RISIS) providing tools for the harmonization of actors in the public research system. Complementarily, RISIS is currently developing the prototype of a parallel register for firms (FirmReg). -> website.

  • The CIB (Corporate Invention Board) dataset is a database characterising the patent portfolios of the largest industrial firms worldwide. The CIB combines information extracted from the Industrial R&D Investment Scoreboard (EU Commission), the ORBIS financial database and the RISIS Patent database ( enriched version of the Patstat EPO database). -> Gitlab repo.

Steps

  1. Login into https://rcf.risis.io.
  2. Create a project.
  3. Import the scenario ‘Linking OrgReg or CIB data with RPD’ into the project.
  4. Configure the project filling the inputs: linking-orgreg-cib-rpd-scenario.png
    • RISIS dataset: CIB or ORGREG depending on the data file you will select. For this example we choose ORGREG.
    • Dataset: Select one dataset from the ones available in the list (the datasets already imported into the project). For this example, we select the dataset 'Test'.
    • File: Select one tsv file from the previously selected dataset, which contains the ORGREG (or CIB) entities data. For this example, we select the file 'orgreg-entities-result-1.tsv'.
    • Fieldname containing entity id: Write the column name of the selected file that contains the entity id to link with RPD.
    • Commonly for OrgReg it will be entities.BAS.ENTITYID.v and for CIB firmreg_id, but you can modify them to match with your customized file.
  5. When all the required fields are filled, you can click the button in the top right ‘Run this scenario’.
  6. After the scenario execution is finished, check in the Outputs of the project for the new file produced: Patent Actors Extraction Result, containing all the legal patent applicants linked to the entity id values of your source file.