Customer Data from the Contoso Dataset

Source: R/data.R

This dataset contains information about customers from the Contoso dataset, including demographic details, geographical information, contact information, and other personal attributes. It provides insights into customer profiles, including location, age, occupation, and more.

Usage

customer

Details

Each row is one customer. Only customers that placed at least one order are included, so every customer_key here appears in sales.

Format

A data frame with 3,165 rows and 24 columns:

customer_key

double Unique identifier for each customer. A primary key: unique and never missing.

geo_area_key

double Unique identifier for the geographical area the customer resides in.

start_date

Date Date when the customer relationship began.

end_date

Date Date when the customer relationship ended, if applicable.

continent

character The continent where the customer resides.

gender

character The gender of the customer (e.g., ‘Male’, ‘Female’).

title

character The title of the customer (e.g., ‘Mr.’, ‘Ms.’).

given_name

character The given (first) name of the customer.

middle_initial

character The middle initial of the customer, if applicable.

surname

character The surname (last name) of the customer.

street_address

character The street address of the customer.

city

character The city where the customer resides.

state

character The state or province where the customer resides.

state_full

character The full name of the state or province.

zip_code

character The postal (ZIP) code of the customer’s address.

country

character The country where the customer resides, using the country code.

country_full

character The full name of the country where the customer resides.

birthday

Date The date of birth of the customer.

age

double The age of the customer.

occupation

character The customer’s occupation or profession.

company

character The company the customer is associated with, if applicable.

vehicle

character The type or make of vehicle the customer owns or drives.

latitude

double The latitude of the customer’s address.

longitude

double The longitude of the customer’s address.

Changed in 2.2.0

Up to version 2.1.0 this table was built by joining the customer catalogue onto sales, which repeated each customer once per sales line they appeared on: 7,794 rows for 3,165 customers. customer_key was therefore not unique and any join to this table silently multiplied rows. The duplicates have been collapsed. No attribute varied within a customer, so nothing was lost.

Source

https://github.com/sql-bi/Contoso-Data-Generator-V2-Data/releases/tag/ready-to-use-data