Skip to content

Latest commit

 

History

History

discovery

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
companies-controlled-by-entities-with-risks.csv
companies-controlled-by-entities-with-risks.csv
 
 
companies-controlled-by-entities-with-risks.sparql
companies-controlled-by-entities-with-risks.sparql
 
 
entities-controlling-companies-with-public-contracts.csv.zip
entities-controlling-companies-with-public-contracts.csv.zip
 
 
entities-controlling-companies-with-public-contracts.sparql
entities-controlling-companies-with-public-contracts.sparql
 
 
entities-controlling-companies-with-risks.csv
entities-controlling-companies-with-risks.csv
 
 
entities-controlling-companies-with-risks.sparql
entities-controlling-companies-with-risks.sparql
 
 
non-sanctioned-companies-sharing-address-with-icij-companies.csv
non-sanctioned-companies-sharing-address-with-icij-companies.csv
 
 
non-sanctioned-companies-sharing-address-with-icij-companies.sparql
non-sanctioned-companies-sharing-address-with-icij-companies.sparql
 
 
non-sanctioned-companies-sharing-address-with-sanctioned-companies.csv
non-sanctioned-companies-sharing-address-with-sanctioned-companies.csv
 
 
non-sanctioned-companies-sharing-address-with-sanctioned-companies.sparql
non-sanctioned-companies-sharing-address-with-sanctioned-companies.sparql
 
 
ubo-associates-with-risks.csv
ubo-associates-with-risks.csv
 
 
ubo-associates-with-risks.sparql
ubo-associates-with-risks.sparql
 
 
ubo-relatives-with-risks.csv
ubo-relatives-with-risks.csv
 
 
ubo-relatives-with-risks.sparql
ubo-relatives-with-risks.sparql
 
 

README.md

Discovery queries

These queries have been used to identify targets that match certain use cases and examples we want to showcase as part of this PoC. The file name indicates the objective of the query and what is should return.

Please note that, due the amount of data being scanned for these targets, some of these queries take several minutes to complete, and sometimes half an hour. This is sometimes due to the fact that we tried to include data that would inform the selection of a target for a use case: the type of target (person vs entity), the risks against a UBO relative, etc.

The CSVs contain the complete output of a query run, and they can be used to pick and test targets that match a desired use case. The larger CSVs have been compressed to make them manageable in a Git repo.