Custom data exports

Currently, we maintain the following custom data exports:

• peps_repeat_v1: A CSV export of PEPs and their relatives and close associates (RCAs).

  Multiple values for some properties of a person are rendered as multiple rows in the CSV. For example, a person for which the given names "John" and "Johnathan" and the family name "Smith" are listed in the database, will render as two rows: one John,Smith,... and another Johnathan, Smith, ....

• peps_wide_v1: Identical in scope to peps_repeat_v1, but fields with multiple values are split into numbered columns (e.g. name_1, name_2, ...)

Authentication #

To access the data delivery service, a data delivery token is required. You'll receive this token from us as part of the customer onboarding process. Alternatively, if you have an email address on file with us, you can find the token in our customer portal. Please treat this token as a secret credential.

To authenticate, include your delivery token in the Authorization header: Authorization: Token yourSecretToken. Alternatively, you can provide the token in the api_key GET parameter.

Accessing the latest export #

The latest export is always available at https://delivery.opensanctions.com/customexports/[custom export name]/latest.csv (be sure to enable redirects in your HTTP client).

Index files #

The index file (available at https://delivery.opensanctions.com/customexports/[custom export name]/index.json) contains a listing of past exports. The versions are ordered by export time, in descending order, so that the latest export is always first. Each entry has the following properties:

• scope, version, data_export_time: The dataset/collection and version that this export was generated from. version and data_export_time correspond to version and last_export in the dataset metadata.
• customexport_time: The creation time of this custom data export.
• filename: The file name of the generated file.
• url: The URL to download this export.

And index file might look like this:

{
  "entries": [
    {
      "scope": "default",
      "mapping": "peps_wide_v1",
      "version": "20251010065417-jsd",
      "filename": "peps_wide_v1-default-20251010065417-jsd.csv",
      "data_export_time": "2025-10-10T06:54:17",
      "customexport_time": "2025-10-10T10:08:26",
      "url": "https://data.opensanctions.org/customexports/peps_wide_v1/peps_wide_v1-default-20251010065417-jsd.csv?token=69G0uMguYoAYOA2svAkBSgWBaUZJA8qukaWFO2tCSYs&expires=1760180463"
    }
  ]
}