Customer Due Diligence (CDD) Records
This dataset provides comprehensive Customer Due Diligence records for regulatory compliance, including customer identity verification, beneficial ownership details, risk ratings, supporting documentation, and periodic review tracking. It is designed to support robust KYC processes, risk management, and audit trails for financial institutions and regulated entities.
Sample rows
preview · 8 of 500 rows · all 28 columns| cdd_record_idstring | review_statusstring | beneficial_owner_countrystring | customer_idstring | customer_typestring | customer_full_namestring | date_of_birthdate | national_id_numberstring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | contact_emailstring | contact_phonestring | identity_verifiedboolean | identity_verification_methodstring | beneficial_owner_namestring | beneficial_owner_national_idstring | risk_ratingstring | documentation_typestring | documentation_referencestring | documentation_expiry_datedate | cdd_completion_datedate | next_review_datedate | reviewed_bystring | risk_rating_reasonstring | review_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CDD0000001 | completed | blank | CUST1001 | individual | Jessica Turner | 1992-06-17 | A192837465 | 328 Oakridge Avenue | New York | NY | 10016 | USA | jessica.turner@ | +1-917-555-2110 | true | passport | blank | blank | low | passport | USA-PAS-2022-001 | 2032-06-17 | 2023-04-10 | 2024-04-10 | COFF101 | blank | Standard onboarding, no issues identified. |
| CDD0000002 | pending | blank | CUST1002 | individual | Michael O'Connor | 1968-11-23 | A129384756 | 42 Red Maple Drive | Boston | MA | 02118 | USA | michael.oconnor@ | +1-617-555-2980 | true | national_id | blank | blank | medium | national_id | USA-NID-2023-002 | 2029-11-23 | 2023-06-15 | 2024-06-15 | COFF102 | Customer is a senior PEP; expedited review required. | Expedited review due to PEP status and high transaction volume. |
| CDD0000003 | completed | blank | CUST1003 | individual | Priya Nair | 1987-04-02 | IN87364529 | 12 MG Road | Mumbai | MH | 400001 | India | priya.nair@ | +91-98201-12345 | true | driver_license | blank | blank | low | driver_license | IND-DL-2019-003 | 2029-04-02 | 2023-08-20 | 2024-08-20 | COFF103 | blank | Routine onboarding, verified with local DL. |
| CDD0000004 | pending | blank | CUST1004 | individual | Alice Johnson | 1974-02-15 | blank | 88 Queen Street | London | Greater London | SW1A 1AA | UK | alice.johnson@ | +44-20-7946-0123 | true | passport | blank | blank | medium | passport | UK-PAS-2018-004 | 2028-02-15 | 2023-05-11 | 2024-05-11 | COFF104 | Customer flagged for unusual transaction patterns. | Further review required for flagged activity. |
| CDD0000005 | completed | blank | CUST1005 | individual | Juan Carlos Rivera | 1981-09-09 | MX90785123 | Av. Insurgentes Sur 3379 | Mexico City | CDMX | 03100 | Mexico | juan.rivera@ | +52-55-5342-1190 | true | passport | blank | blank | low | passport | MEX-PAS-2021-005 | 2031-09-09 | 2023-07-03 | 2024-07-03 | COFF105 | blank | Verified identity with Mexican passport. |
| CDD0000006 | completed | blank | CUST1006 | individual | Chen Wei | 1990-01-29 | CN24819736 | No. 18 Nanjing Rd | Shanghai | Shanghai | 200001 | China | chen.wei@ | +86-21-5555-1234 | true | national_id | blank | blank | low | national_id | CHN-NID-2022-006 | 2030-01-29 | 2023-03-29 | 2024-03-29 | COFF106 | blank | Routine onboarding, Chinese national ID checked. |
| CDD0000007 | completed | blank | CUST1007 | individual | Sandra Müller | 1989-08-12 | DE98765432 | Königsallee 45 | Düsseldorf | NRW | 40212 | Germany | sandra.mueller@ | +49-211-345678 | true | driver_license | blank | blank | low | driver_license | DEU-DL-2021-007 | 2031-08-12 | 2023-09-01 | 2024-09-01 | COFF107 | blank | Standard onboarding, all docs verified. |
| CDD0000008 | pending | blank | CUST1008 | individual | Ahmed Al-Sayed | 1971-03-28 | SA12345678 | King Fahd Road 99 | Riyadh | Riyadh | 11564 | Saudi Arabia | ahmed.alsayed@ | +966-11-555-9876 | true | national_id | blank | blank | medium | national_id | SAU-NID-2022-008 | 2028-03-28 | 2023-11-22 | 2024-11-22 | COFF108 | Customer exposed to high-risk sector. | Review flagged due to sector exposure. |
| CDD0000009 | completed | blank | CUST1009 | individual | Emily Rose | 1985-05-30 | blank | 18 Elm Street | Toronto | Ontario | M5G 1G7 | Canada | emily.rose@ | +1-416-555-7890 | true | passport | blank | blank | low | passport | CAN-PAS-2018-009 | 2028-05-30 | 2023-02-17 | 2024-02-17 | COFF109 | blank | Routine onboarding, verified with Canadian passport. |
| CDD0000010 | pending | blank | CUST1010 | individual | Olga Kuznetsova | 1957-12-10 | RU12398765 | Lenina Ave 23 | Moscow | Moscow | 101000 | Russia | olga.kuznetsova@ | +7-495-1234567 | true | passport | blank | blank | medium | passport | RUS-PAS-2016-010 | 2026-12-10 | 2023-04-03 | 2024-04-03 | COFF110 | Customer flagged for age and transaction volume. | Expedited review for older customer. |
| CDD0000011 | completed | blank | CUST1011 | individual | Fatima Hassan | 1997-07-24 | AE98765412 | Al Maktoum St 120 | Dubai | Dubai | 00000 | UAE | fatima.hassan@ | +971-4-555-3210 | true | passport | blank | blank | low | passport | UAE-PAS-2020-011 | 2030-07-24 | 2023-01-14 | 2024-01-14 | COFF111 | blank | Standard onboarding, UAE passport verified. |
| CDD0000012 | completed | blank | CUST1012 | individual | Lucas Silva | 1983-05-13 | BR87654321 | Av. Paulista 500 | São Paulo | SP | 01310-000 | Brazil | lucas.silva@ | +55-11-5555-1010 | true | driver_license | blank | blank | low | driver_license | BRA-DL-2020-012 | 2030-05-13 | 2022-12-05 | 2023-12-05 | COFF112 | blank | Brazilian DL verified, routine onboarding. |
| CDD0000013 | completed | USA | CUST1013 | corporate | Delta Innovations LLC | 2008-03-16 | US-DELTA-08 | 200 Wall Street | New York | NY | 10005 | USA | corp@ | +1-212-555-2000 | true | corporate_docs | Robert K. Simmons | A55512345 | medium | corporate_docs | USA-CORP-2008-013 | blank | 2023-04-20 | 2024-04-20 | COFF113 | Entity flagged for international transfers. | Routine review, sanctions screening completed. |
| CDD0000014 | completed | Switzerland | CUST1014 | corporate | Sunrise Holdings AG | 1997-07-11 | CH-SUNRISE-97 | Bahnhofstrasse 100 | Zurich | Zurich | 8001 | Switzerland | info@ | +41-44-555-2211 | true | corporate_docs | Helena Roth | CH98765432 | low | corporate_docs | CHE-CORP-1997-014 | blank | 2023-05-18 | 2024-05-18 | COFF114 | blank | Routine review, Swiss entity, no issues. |
| CDD0000015 | completed | India | CUST1015 | corporate | Sapphire Technologies Ltd | 2016-09-22 | UK-SAPPHIRE-16 | 45 Canary Wharf | London | Greater London | E14 5AB | UK | admin@ | +44-20-7123-4567 | true | corporate_docs | Anita Kapoor | IN78945612 | medium | corporate_docs | GBR-CORP-2016-015 | blank | 2023-03-30 | 2024-03-30 | COFF115 | Beneficial owner is a foreign national. | Sanctions screening completed, further KYC for foreign owner. |
| CDD0000016 | completed | Australia | CUST1016 | corporate | Blue Skies Pty Ltd | 2004-12-16 | AU-BLUESKIES-04 | 88 Collins Street | Melbourne | VIC | 3000 | Australia | contact@ | +61-3-5555-3000 | true | corporate_docs | Matthew Reed | AU12345678 | low | corporate_docs | AUS-CORP-2004-016 | blank | 2023-07-22 | 2024-07-22 | COFF116 | blank | Australian entity, routine review. |
| CDD0000017 | completed | USA | CUST1017 | corporate | Global Shipping Inc. | 1994-05-21 | US-GSI-94 | 600 Market Street | San Francisco | CA | 94105 | USA | info@ | +1-415-555-6000 | true | corporate_docs | Sophia Martinez | A98765432 | medium | corporate_docs | USA-CORP-1994-017 | blank | 2023-09-05 | 2024-09-05 | COFF117 | International cargo flagged for sanctions screening. | Sanctions screening completed for international cargo. |
| CDD0000018 | pending | USA | CUST1018 | trust | Greenfield Family Trust | 2012-05-25 | US-GFT-12 | 1200 Pine Street | Seattle | WA | 98101 | USA | trustadmin@ | +1-206-555-1200 | true | utility_bill | Linda Greenfield | A32165498 | high | utility_bill | USA-UTIL-2023-018 | 2024-11-30 | 2023-11-01 | 2024-05-01 | COFF118 | Complex trust structure, flagged for further AML. | Monitor for AML compliance, further documentation requested. |
| CDD0000019 | pending | UK | CUST1019 | trust | Silver Oak Trust | 2018-09-14 | UK-SOT-18 | 200 Regent Street | London | Greater London | W1B 5TD | UK | admin@ | +44-20-7122-2000 | true | utility_bill | Henry Turner | UK1234567 | high | utility_bill | GBR-UTIL-2023-019 | 2024-09-30 | 2023-09-18 | 2024-03-18 | COFF119 | Trust flagged for VASP exposure. | Further documents required due to flagged VASP exposure. |
| CDD0000020 | pending | Singapore | CUST1020 | trust | Pacific Wealth Trust | 2021-02-08 | SG-PWT-21 | 10 Marina Boulevard | Singapore | Central | 018983 | Singapore | trust@ | +65-6305-1000 | true | other | Wei Ling Tan | SG8765432 | high | other | SGP-OTH-2021-020 | blank | 2023-10-15 | 2024-04-15 | COFF120 | Offshore trust structure flagged for enhanced due diligence. | Enhanced due diligence required for offshore structure. |
What the 500 rows show
from the 500-row sample- 3risk ratings
- 5customer types
- 6identity verification methods
- 6documentation types
- 52address countries
- 104address states
- string 23
- date 4
- boolean 1
Columns
28 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 23 columns | |||
cdd_record_id | string | Unique identifier for the Customer Due Diligence recordunique | CDD0000001 |
customer_id | string | Unique identifier for the customer | CUST1001 |
customer_type | string | Type of customer (individual, corporate, trust, etc.)individual · corporate · trust · partnership · other | individual |
customer_full_name | string | Full legal name of the customer | Jessica Turner |
national_id_number | string | National identification number or registration numberoptional | A192837465 |
address_street | string | Street address of the customer | 328 Oakridge Avenue |
address_city | string | City of the customer's address | New York |
address_state | string | State or province of the customer's addressoptional | NY |
address_postal_code | string | Postal code of the customer's address | 10016 |
address_country | string | Country of the customer's address | USA |
contact_email | string | Primary contact email addressoptional | juan.rivera@ |
contact_phone | string | Primary contact phone numberoptional | +1-917-555-2110 |
identity_verification_method | string | Method used for identity verification (passport, driver_license, utility_bill, etc.)6 values · optional | passport |
beneficial_owner_name | string | Full name of the beneficial owner (if applicable)optional | Robert K. Simmons |
beneficial_owner_national_id | string | National ID or registration number of beneficial owneroptional | A55512345 |
beneficial_owner_country | string | Country of residence or registration of beneficial owneroptional | USA |
risk_rating | string | Assigned risk rating for the customerlow · medium · high | low |
risk_rating_reason | string | Explanation or notes supporting the risk ratingoptional | Customer is a senior PEP;… |
documentation_type | string | Type of documentation collected for CDD5 values | passport |
documentation_reference | string | Reference number or identifier for the documentationoptional | USA-PAS-2022-001 |
review_status | string | Status of the periodic review (pending, completed, overdue)pending · completed · overdue | completed |
reviewed_by | string | Name or identifier of the compliance officer who performed the reviewoptional | COFF101 |
review_notes | string | Additional notes or comments from the revieweroptional | Onboarding completed. |
| Dates and times 4 columns | |||
date_of_birth | date | Date of birth (for individuals) or date of incorporation (for entities)optional | 1992-06-17 |
documentation_expiry_date | date | Expiry date of the documentation (if applicable)optional | 2032-06-17 |
cdd_completion_date | date | Date when CDD was completed | 2023-04-10 |
next_review_date | date | Scheduled date for the next periodic review | 2024-04-10 |
| True or false 1 column | |||
identity_verified | boolean | Indicates if the customer's identity has been verified | true |
Use it for
A finance dashboard
A breakdown of beneficial_
owner_ country. Excel, Power BI or Tableau. What pattern can you find in 500 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 500 rows.
- Cdd records500CDD0000001completedCDD0000002pendingCDD0000003completed
A software demo
Believable cdd records with customer_
id, customer_ type and customer_ full_ name to fill a screen in front of a buyer.
blueprint · customer-due-diligence-cdd-records
Behind this dataset
Same schema. As many rows as you need.
These 500 rows came out of a blueprint — 28 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Customer unique identifier required
- Identity documents verified: passport, driver license, national ID
- Risk rating: low, medium, high, enhanced
- Beneficial ownership disclosed for entities
- Politically Exposed Person (PEP) screening completed
- Source of funds documented
- CDD review date based on risk rating
- Enhanced due diligence for high-risk customers
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- customer-due-diligence-cdd-records