Table 'Person.Address', Street address information for customers, employees, and vendors.

Table 'Person.Address', Street address information for customers, employees, and vendors.

Property NameProperty Value
Records19614
Fields8
Record size (bytes) w/o BLOBs370

Field statistics for 'AddressID' int identity

Field propertyProperty Value
Minimum value1
Maximum value32521
Average value19516.281227694504
Values variance48465217.081157856
Unique values19614

Field statistics for 'AddressLine1' nvarchar(60)

Field propertyProperty Value
Minimum value#500-75 O'Connor Street
Maximum valueZur Lindung 787
Unique values13567

Field statistics for 'AddressLine2' nvarchar(60)

Field propertyProperty Value
Minimum value# 1
Maximum valueVerkaufsabteilung
Unique values195

Field statistics for 'City' nvarchar(30)

Field propertyProperty Value
Minimum valueAbingdon
Maximum valueZeeland
Unique values575

Field statistics for 'StateProvinceID' int

Field propertyProperty Value
Minimum value1
Maximum value181
Average value49.284643621902724
Values variance2126.0051922020557
Unique values74

Field statistics for 'PostalCode' nvarchar(15)

Field propertyProperty Value
Minimum value01071
Maximum valueYO15
Unique values661

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values19614

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value1996-07-24 00:00:00.000
Maximum value2004-07-31 00:00:00.000
Unique values1285