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
);