cosmin-marginean

# Most of the Geo names in the Panama Papers are using the right codes but some
# are inconsistent or plain incorrect. The problems are usually:
#   * Mostly ISO-3166 alpha3 for country codes, but some sporadic alpha2 codes as well. We're
#     fixing this by always reverting to the alpha3 code.
#   * Some incorrect codes (STLU, MARSH, WYO).
#   * It's not clear if some codes (DUBAI, LABUA) are actual jurisdictions. We are using the
#     "parent" country for these but you might want to adjust them for your use case.
# This translation table addresses all these issues.

# Countries

cosmin-marginean

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods: <http://bods.openownership.org/vocabulary/>
PREFIX bods-res: <http://bods.openownership.org/resource/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?uboName ?directCtrlCompanyName
WHERE {
    ?ubo rdf:type bods:Person .
    ?ubo foaf:name ?uboName .
    ?ubo bods:ownsOrControls ?directCtrlCompany .

cosmin-marginean

PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods:     <http://bods.openownership.org/vocabulary/>
PREFIX bods-res: <http://bods.openownership.org/resource/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?uboName ?parent ?child
WHERE {
    ?ubo bods:ownsOrControls* ?a .
    ?ubo foaf:name ?uboName .
    ?ubo rdf:type bods:Person .

cosmin-marginean

PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX foaf:     <http://xmlns.com/foaf/0.1/>
PREFIX bods:     <http://bods.openownership.org/vocabulary/>
PREFIX bods-res: <http://bods.openownership.org/resource/>

SELECT ?ultimateParent ?ultimateParentName
WHERE  {
    ?ultimateParent bods:ownsOrControls+ bods-res:openownership-register-12337862642105981237 .
    ?ultimateParent foaf:name ?ultimateParentName .
    ?ultimateParent rdf:type bods:Entity .

cosmin-marginean

PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX foaf:     <http://xmlns.com/foaf/0.1/>
PREFIX bods:     <http://bods.openownership.org/vocabulary/>
PREFIX bods-res: <http://bods.openownership.org/resource/>

SELECT ?parentName ?childName
WHERE {
    ?ultimateParent bods:ownsOrControls* ?parent .
    ?ultimateParent rdf:type bods:Entity .
    ?parent foaf:name ?parentName .

cosmin-marginean

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods: <http://bods.openownership.org/vocabulary/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX bodsr: <http://bods.openownership.org/resource/>

SELECT ?personName ?minShares ?interestType
WHERE {
    ?person rdf:type bods:Person .
    ?person foaf:name ?personName .

cosmin-marginean

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods: <http://bods.openownership.org/vocabulary/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX bodsr: <http://bods.openownership.org/resource/>

SELECT ?personName ?minShares
WHERE {
    ?person rdf:type bods:Person .
    ?person foaf:name ?personName .

cosmin-marginean

PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods:     <http://bods.openownership.org/vocabulary/>
PREFIX bods-res: <http://bods.openownership.org/resource/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?parentName ?minShares ?childName
WHERE {
    ?ctrlStatement bods:hasInterestedParty ?parent .
    ?ctrlStatement bods:hasSubject ?child .
    ?ctrlStatement bods:statesInterest ?interest .

cosmin-marginean

PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods:     <http://bods.openownership.org/vocabulary/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX bods-res: <http://bods.openownership.org/resource/>

SELECT DISTINCT ?personName ?directControl (GROUP_CONCAT(?directControlCompanyName;SEPARATOR="; ") as ?companiesControlledDirectly)
WHERE {
    ?person bods:ownsOrControls+ bods-res:openownership-register-12337862642105981237 .
    ?person rdf:type bods:Person .
    ?person foaf:name ?personName .

cosmin-marginean

PREFIX rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bods:     <http://bods.openownership.org/vocabulary/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX bods-res: <http://bods.openownership.org/resource/>

SELECT ?companyName ?relationship
WHERE {
    ?company rdf:type bods:Entity .
    ?company foaf:name ?companyName .
    {