Person CSV columns

Contents

Person CSV columns#

To create SKG-IF person records from SPARQL results, name each result variable after a column in the table below. The table follows the official Agent properties.

Column	Description	Example
`local_identifier`	Primary key; groups all rows for one person	`https://w3id.org/oc/meta/ra/0614010840729`
`name`	Full name	`Peroni Silvio`
`family_name`	Family name	`Peroni`
`given_name`	Given name	`Silvio`
`identifier_scheme`	Identifier scheme for persons: `omid`, `openalex`, `orcid`, `url`, `urn`, `viaf`, `w3id`	`orcid`
`identifier_value`	The external identifier	`0000-0003-0530-4305`

Both identifier_scheme and identifier_value must be non-empty for an identifier to be included; rows where either is empty are skipped.

Affiliations#

RAMOSE groups affiliations by _affiliation_key, while it uses affiliation_local_identifier when that key is empty. Use distinct keys when the same person has more than one work period at an organisation; rows without affiliation_local_identifier do not create an affiliation.

Column	Description	Example
`affiliation_local_identifier`	Local identifier of the affiliated organisation	`https://example.org/organisations/unibo`
`_affiliation_key`	Groups rows that describe one affiliation	`affiliation_0`
`affiliation_name`	Organisation name	`University of Bologna`
`affiliation_short_name`	Short name or acronym	`UNIBO`
`affiliation_country`	ISO 3166-1 alpha-2 country code	`IT`
`affiliation_website`	Website URL	`https://www.unibo.it`
`affiliation_type`	Organisation type: `archive`, `company`, `education`, `facility`, `government`, `healthcare`, `nonprofit`, `funder`, `research`, or `unspecified`	`education`
`affiliation_other_name`	Alternative organisation name	`Alma Mater Studiorum - Università di Bologna`
`affiliation_identifier_scheme`	Organisation identifier scheme	`ror`
`affiliation_identifier_value`	Organisation external identifier	`01111rn36`
`affiliation_role`	Person’s role in the organisation; SKG-IF recommends `affiliate`	`affiliate`
`affiliation_period_start`	Affiliation start date or datetime in ISO 8601 format	`2017-04-13T00:00:00Z`
`affiliation_period_end`	Affiliation end date or datetime in ISO 8601 format	`2019-02-11T23:59:59Z`