🔗 Cross-source JOIN: CERN's people ⋈ its ROR org card

SELECT ?person ?name ?role ?orgName ?city ?country WHERE {
  ?a orc:affiliationWith <https://ror.org/01ggx4157> ;
     orc:affiliationOf ?person ;
     orc:roleTitle ?role .
  ?person rdfs:label ?name .
  <https://ror.org/01ggx4157> ror:name ?orgName ;

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → 50 rows · 62.7 s · no server, no download — the query runs in your browser.

The query

PREFIX orc: <https://w3id.org/rete/orcid#> PREFIX ror: <https://w3id.org/rete/ror#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?person ?name ?role ?orgName ?city ?country WHERE { ?a orc:affiliationWith <https://ror.org/01ggx4157> ; orc:affiliationOf ?person ; orc:roleTitle ?role . ?person rdfs:label ?name . <https://ror.org/01ggx4157> ror:name ?orgName ; ror:locationName ?city ; ror:countryName ?country . } LIMIT 50

rete playground · documentation · github.com/caviri/rete