One row per customer. Customers are identified by an internal sequential
customer_id; the canonical natural key is national_id
(Norwegian fødselsnummer). Includes contact details and segment.
| Column | Type | Description |
|---|---|---|
| customer_idPK | BIGINT | Internal surrogate, sequential. |
| national_id | TEXT | 11-digit Norwegian fødselsnummer with MOD-11 check digits. |
| first_name | TEXT | Given name. |
| last_name | TEXT | Family name. |
| TEXT | Email address. Nullable. | |
| phone | TEXT | Mobile or landline. Free-form string. |
| postal_code | TEXT | Norwegian 4-digit postal code. |
| city | TEXT | City of residence. |
| segment | TEXT | One of retail, private_banking, student. |
| onboarded_at | TIMESTAMP | When the customer relationship began. |
| churned_at | TIMESTAMP | When the customer left. NULL if still active. |
| customer_id | national_id | first_name | last_name | phone | postal_code | city | segment | onboarded_at | churned_at | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 14048246173 | Lars | Hansen | lars.hansen@online.no | +47 91234567 | 0150 | Oslo | retail | 2019-04-12 00:00:00 | NULL |
| 2 | 27039914802 | Kari | Olsen | kari.olsen@gmail.com | 92345678 | 5003 | Bergen | private_banking | 2016-09-01 00:00:00 | NULL |
| 3 | 03079853019 | Per | Larsen | NULL | 004793456789 | 7010 | Trondheim | student | 2022-08-22 00:00:00 | NULL |
| 4 | 11128521098 | Anne | Pedersen | anne.pedersen@hotmail.com | +4794567890 | 4006 | Stavanger | retail | 2014-02-19 00:00:00 | 2024-11-30 00:00:00 |
| 5 | 22057740214 | Knut | Karlsen | knut.karlsen@icloud.com | 95678901 | 3015 | Drammen | retail | 2017-06-04 00:00:00 | NULL |