Documentation · Bulk data

Custom data exports

Some systems need the data in a particular shape: one row per name, a fixed set of columns, or only some registers. This page explains what you can produce yourself today and how to ask us for an export built to your specification.

The bulk files are free to download, with no account. Non-commercial use is covered by our data licence; commercial use needs a licence. To check names one at a time instead, use the screening API.

Exports we offer

We do not yet publish ready-made custom exports (for example, a PEP file with one row per position, or a wide file with numbered columns).

To be provided: which custom exports we will offer, their layouts, who may use them, and their price, if any.

Single registers

Each register cleared for download can be exported on its own, as CSV or JSON lines, from its page in the source register or from the API:

GET /api/export?source=<register name>&format=csv|jsonl

# example
curl "https://api.crownintelligence.net/api/export?source=OFAC%20SDN&format=csv"

Columns: id, name, alt_names, list_type, entity_type, program, dob, nationality, entity_id, first_seen, loaded_at, source. See Downloads and the endpoint reference.

Building your own layout

The bulk files carry everything needed to derive most layouts. Two examples with jq:

# one row per name (primary and aliases) with id, type and register
jq -r '. as $e | ($e.properties.name + ($e.properties.alias // []))[]
       | [$e.id, $e.schema, ., $e.datasets[0]] | @csv' targets.nested.json > names-by-record.csv

# PEP records with their role text, one row per listing
jq -r 'select(.properties.topics | index("role.pep")) | . as $e | $e.properties.sanctions[]
       | [$e.id, $e.caption, ($e.properties.birthDate // [""])[0], (.properties.program // [""])[0], .properties.authority[0]]
       | @csv' targets.nested.json > peps-roles.csv

Or load statements.csv into a database and pivot it: every value is a row there, with its record, property and register.

Asking for an export

Tell us the layout, the registers or topics, the format and how often you need it. Write to [email protected] or use Talk to sales.

To be provided: how custom exports are authenticated and delivered (address, token, index file), once they exist. See also Data delivery service.

Last updated 2026-10-03