Link author affiliation with lowest-level research organization

from alexandria3k.processes import link_aa_base_ror

processes.link_aa_base_ror.process(database_path)

Process the specified database creating a table that links Crossref work authors to their corresponding research organization as codified in the Research Orgnization Registry (ROR). The link is made to the lowest identifiable organizational level, e.g. an author’s clinic, school, or institute.

Parameters:

database_path (str) – The path specifying the SQLite database to process and populate. The database shall already contain the ROR dataset and the Crossref author_affiliations table.

Generated schema

CREATE TABLE work_authors_rors(
  ror_id,
  work_author_id
);