ATTR_OF

Parameter	Type	Description
`match_column`	string, anyuri	Column containing the matched entity
`predicate`	string, anyuri	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

shad/simple-state-example Run query Copy code

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#.