Cross Source Links¶

Dimensions data provides ability to retrieve related entities, such as supporting grants to publications. The list of all available links is provided here:

ID fields provide relations between:

publications ↔ publications via references
publications ↔ grants via supporting_grant_ids
publications ↔ researchers via researchers
patents ↔ patents via reference_ids and cited_by_ids
patents ↔ grants via associated_grant_ids
patents ↔ publications via publication_ids
grants ↔ publications via resulting_publication_ids. Deprecated: use the other direction of this connection: supporting_grant_ids in publications
grants ↔ researchers via researchers
clinical_trials ↔ grants via associated_grant_ids
clinical_trials ↔ publications via publication_ids
policy_documents ↔ publications via publication_ids

Following diagram shows availability of ID fields that can be used to retrieve related source entities.

Entity Relationship Diagram¶

This diagram shows source entities with fields from basics fieldset. For full listing of supported fields, refer to Sources. Purpose of this diagram is to visualize links between various sources.

$'style options skinparam monochrome true hide circle hide empty members entity "Researchers" { * id -- * first_name * id * last_name * orcid_id * research_orgs } entity "Publications" { * id -- * author_affiliations * id * issue * journal * pages * title * type * volume * year } entity "Policy Documents" { * id -- * city * country * grid_id * id * linkout * source_name * state * title * year } entity "Patents" { * id -- * assignee_names * assignees * filed_year * filing_status * granted_year * id * inventor_names * publication_date * times_cited * title } entity "Grants" { * id -- * active_year * end_date * funders * funding_org_name * id * language * original_title * project_num * start_date * start_year * title * title_language } entity "Clinical Trials" { * id -- * active_years * id * investigators * title } Publications }o--o{ Publications: references Publications }o--o{ Grants: supporting_grant_ids Publications }o--o{ Researchers: researchers Patents }o--o{ Patents: reference_ids and cited_by_ids Patents }o--o{ Grants: associated_grant_ids Patents }o--o{ Publications: publication_ids Grants }o--o{ Publications: resulting_publication_ids Grants }o--o{ Researchers: researchers "Clinical Trials" }o--o{ Grants: associated_grant_ids "Clinical Trials" }o--o{ Publications: publication_ids "Policy Documents" }o--o{ Publications: publication_ids$

Usage¶

User can retrieve related entities using two steps. First, retrieve the related IDs, such as for example, retrieving supporting grant IDs for publication:

search publications where id = "pub.1103155411"
return publications[supporting_grant_ids]

Then, make a follow up request, using retrieved supporting_grant_ids, to request the actual grant information:

search grants where id in ["grant.7025938", "grant.2686578", "grant.2683072", "grant.2491045"]
return grants

Similarly, other sources can be linked together, using provided ID fields.

Some entities are only linked in one direction, such as policy documents and publications, so getting publications linked to policy documents is fairly trivial:

search policy_documents where id="policy.88709"
return policy_documents[basics+publication_ids]

However, querying policy documents linked to a publication must also be performed on policy documents entity:

search policy_documents where publication_ids = "pub.1053432045"
return policy_documents[basics+publication_ids]