Cosmin Marginean cosmin-marginean
cosmin-marginean
/ query.sparql
Created
February 17, 2023 13:29
BODS RDF - Control details for other companies
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 ?personName ?companyName ?interestType ?minShares | |
| WHERE { | |
| ?person rdf:type bods:Person . | |
| ?person foaf:name ?personName . | |
| ?person bods:ownsOrControls bods-res:openownership-register-227513236687367494 . |
cosmin-marginean
/ query.sparql
Created
February 17, 2023 13:28
BODS RDF - Other companies controlled by the same individuals
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 ?personName ?companyName | |
| WHERE { | |
| ?person rdf:type bods:Person . | |
| ?person foaf:name ?personName . | |
| ?person bods:ownsOrControls bods-res:openownership-register-227513236687367494 . |
cosmin-marginean
/ query.sparql
Last active
February 10, 2023 13:52
BODS RDF - Complete path between two entities
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 ?parentName ?childName | |
| WHERE { | |
| bods-res:openownership-register-14328799669345784668 bods:ownsOrControls* ?parent . | |
| ?parent bods:ownsOrControls ?child . | |
| ?parent foaf:name ?parentName . |
cosmin-marginean
/ query.sparql
Created
February 10, 2023 13:35
BODS RDF - All the entities connected to a target: entities with control over the target or which the target controls (directly or indirectly)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 . | |
| { |
cosmin-marginean
/ query.sparql
Last active
February 10, 2023 13:24
BODS RDF - People with direct or indirect control over a company, along with the entities that these people control directly.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ query.sparql
Created
February 9, 2023 22:17
BODS RDF - Ownership chain between a UBO and a company with intermediate shares percentage
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ query.sparql
Created
February 9, 2023 21:49
BODS RDF - Person with more than 50% voting rights
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ query.sparql
Created
February 9, 2023 21:41
BODS RDF - Shareholders with at least 20% shares
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ ultimate-parents-ownership-chain.sparql
Created
February 6, 2023 11:58
BODS RDF - Ultimate parents ownership chain
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ find-ultimate-parents.sparql
Created
February 6, 2023 11:56
BODS RDF - Identifying ultimate parents for a target
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 . |