Enhancing with Data from Other Sources

• Vocabulary reconciliation is a process where automated systems use terms from unstandardized metadata to search controlled vocabularies and return URIs.
• OpenRefine has built in tools to reconcile data with Wikidata
• Other data services can be added

OpenRefine’s Wikidata Service

• Reconciling the university names
  • Reconcile > Start reconciling...
  • choose Wikidata Reconciliation for OpenRefine (en)
  • choose universities and Auto-match candidates with high confidence
  • matches some automatically, but often requires some manual review
• Extract the Wikidata id
  • Edit column > Add column based on this column...
  • name column: wikidata_id
  • cell.recon.match.id

Adding more data based on extracted dataset

• OpenRefine 2.8 added querying and extracting tools
  • Select matched from the judgement facet
  • Edit column > Add columns from reconciled values
  • Add located at street address, student count, country, official website, inception, mascot, Carnegie Classification of Institutions of Higher Education (etc.)
• Geographic Coordinates for places
  • place of birth > Edit column > Add columns from reconciled values
  • Add coordinate location

Other data services

• Users can set up their own data services or use other existing data services.
• Some sample services are available at the OpenRefine Wiki - Reconcilable Data Sources and at http://refine.codefork.com/.
• Reconciliation can be taxing on host servers and data sources. Documentation for hosting your own service are available at and on the conciliator GitHub.