Databases > AdventureWorks2019 > Views > Sales.vIndividualCustomer

AdventureWorks2019

Sales.vIndividualCustomer

//
Individual customers (names and addresses) that purchase Adventure Works Cycles products online.

Created: Modified:

Columns

Definition

Sample Data

BusinessEntityID
Title
FirstName
MiddleName
LastName
Suffix
PhoneNumber
PhoneNumberType
EmailAddress
EmailPromotion
AddressType
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName
Demographics
13531
NULL
Jon
V
Yang
NULL
1 (11) 500 555-0162
Home
jon24@adventure-works.com
1
Home
3761 N. 14th St
NULL
Rockhampton
Queensland
4700
Australia
[xml]
5454
NULL
Eugene
L
Huang
NULL
1 (11) 500 555-0110
Cell
eugene10@adventure-works.com
NULL
Home
2243 W St.
NULL
Seaford
Victoria
3198
Australia
[xml]
11269
NULL
Ruben
NULL
Torres
NULL
1 (11) 500 555-0184
Home
ruben35@adventure-works.com
2
Home
5844 Linden Land
NULL
Hobart
Tasmania
7001
Australia
[xml]
11358
NULL
Christy
NULL
Zhu
NULL
1 (11) 500 555-0162
Cell
christy12@adventure-works.com
NULL
Home
1825 Village Pl.
NULL
North Ryde
New South Wales
2113
Australia
[xml]
11901
NULL
Elizabeth
NULL
Johnson
NULL
1 (11) 500 555-0131
Home
elizabeth5@adventure-works.com
1
Home
7553 Harness Circle
NULL
Wollongong
New South Wales
2500
Australia
[xml]
6990
NULL
Julio
NULL
Ruiz
NULL
1 (11) 500 555-0151
Cell
julio1@adventure-works.com
NULL
Home
7305 Humphrey Drive
NULL
East Brisbane
Queensland
4169
Australia
[xml]
6229
NULL
Janet
G
Alvarez
NULL
1 (11) 500 555-0184
Cell
janet9@adventure-works.com
NULL
Home
2612 Berry Dr
NULL
Matraville
New South Wales
2036
Australia
[xml]
3878
NULL
Marco
NULL
Mehta
NULL
1 (11) 500 555-0126
Cell
marco14@adventure-works.com
NULL
Home
942 Brook Street
NULL
Warrnambool
Victoria
3280
Australia
[xml]
14673
NULL
Rob
NULL
Verhoff
NULL
1 (11) 500 555-0164
Cell
rob4@adventure-works.com
NULL
Home
624 Peabody Road
NULL
Bendigo
Victoria
3550
Australia
[xml]
20229
NULL
Shannon
C
Carlson
NULL
1 (11) 500 555-0110
Cell
shannon38@adventure-works.com
1
Home
3839 Northgate Road
NULL
Hervey Bay
Queensland
4655
Australia
[xml]
6377
NULL
Jacquelyn
C
Suarez
NULL
1 (11) 500 555-0169
Home
jacquelyn20@adventure-works.com
NULL
Home
7800 Corrinne Court
NULL
East Brisbane
Queensland
4169
Australia
[xml]
18258
NULL
Curtis
NULL
Lu
NULL
1 (11) 500 555-0117
Home
curtis9@adventure-works.com
NULL
Home
1224 Shoenic
NULL
East Brisbane
Queensland
4169
Australia
[xml]
11663
NULL
Lauren
M
Walker
NULL
717-555-0164
Home
lauren41@adventure-works.com
2
Home
4785 Scott Street
NULL
Bremerton
Washington
98312
United States
[xml]
13873
NULL
Ian
M
Jenkins
NULL
817-555-0185
Cell
ian47@adventure-works.com
1
Home
7902 Hudson Ave.
NULL
Lebanon
Oregon
97355
United States
[xml]
2868
NULL
Sydney
NULL
Bennett
NULL
431-555-0156
Cell
sydney23@adventure-works.com
NULL
Home
9011 Tank Drive
NULL
Redmond
Washington
98052
United States
[xml]
10963
NULL
Chloe
NULL
Young
NULL
208-555-0142
Home
chloe23@adventure-works.com
1
Home
244 Willow Pass Road
NULL
Burbank
California
91502
United States
[xml]
3800
NULL
Wyatt
L
Hill
NULL
135-555-0171
Home
wyatt32@adventure-works.com
1
Home
9666 Northridge Ct.
NULL
Imperial Beach
California
91932
United States
[xml]
2521
NULL
Shannon
NULL
Wang
NULL
1 (11) 500 555-0195
Home
shannon1@adventure-works.com
2
Home
7330 Saddlehill Lane
NULL
Sunbury
Victoria
3429
Australia
[xml]
7394
NULL
Clarence
D
Rai
NULL
1 (11) 500 555-0137
Home
clarence32@adventure-works.com
NULL
Home
244 Rivewview
NULL
Bendigo
Victoria
3550
Australia
[xml]
5132
NULL
Luke
L
Lal
NULL
262-555-0112
Home
luke18@adventure-works.com
NULL
Home
7832 Landing Dr
NULL
Langley
British Columbia
V3A 4R2
Canada
[xml]
17128
NULL
Jordan
C
King
NULL
550-555-0163
Home
jordan73@adventure-works.com
NULL
Home
7156 Rose Dr.
NULL
Metchosin
British Columbia
V9
Canada
[xml]
11489
NULL
Destiny
NULL
Wilson
NULL
622-555-0158
Home
destiny7@adventure-works.com
NULL
Home
8148 W. Lake Dr.
NULL
Beaverton
Oregon
97005
United States
[xml]
6522
NULL
Ethan
G
Zhang
NULL
589-555-0185
Home
ethan20@adventure-works.com
1
Home
1769 Nicholas Drive
NULL
Bellingham
Washington
98225
United States
[xml]
4373
NULL
Seth
M
Edwards
NULL
452-555-0188
Cell
seth46@adventure-works.com
1
Home
4499 Valley Crest
NULL
Bellflower
California
90706
United States
[xml]
12565
NULL
Alejandro
NULL
Beck
NULL
1 (11) 500 555-0178
Home
alejandro45@adventure-works.com
NULL
Home
2596 Franklin Canyon Road
NULL
Hawthorne
Queensland
4171
Australia
[xml]