ATTR_OF

Return an attribute value of an entity 'match'.

Parameter Type Description
match_column
anyuri
Column containing the matched entity
predicate
anyuri, string
URI of the predicate which should be retrieved from the graph
Returns: any

Example

query:

SELECT ATTR_OF(us_state_or_territory, 'https://ontology.data.world/v0#fipsAbbreviation') AS abbreviation
  FROM just_states
 LIMIT 10

results:

abbreviation
VA
TX
OK
VA
SC
CA
AL
ME
NH
MA

This function represents advanced functionality for pulling in linked data attributes from the graph that backs the data behind data.world’s matching ontology. Each entity type has it’s own set of available predicates that can be pulled back. See available predicates by type

Note that https://ontology.data.world/v0#fipsAbbreviation could actually be shortened to just fipsAbbreviation. ATTR_OF will assume that non-uri values should be prefixed with https://ontology.data.world/v0#.