Names and other identifying information

The following generators produce names and other identifying values for an individual.

Fabricate automatically correlates name and gender columns within a table.

For more information about these generators and how they are configured in the application, go to Names and other identifying information in the generator reference.

First Name

Produces a given name, such as John or Mary.

Uses the General column configuration.

Full Name

Produces a full name (given name and family name), such as John Smith and Mary Jones.

Uses the General column configuration.

Last Name

Produces a family name, such as Smith or Jones.

Uses the General column configuration.

Middle Name

Produces a middle name. Uses the same set of names as the First Name generator. The middle name is always different from the first name.

Uses the General column configuration.

Nickname

Produces a common nickname for the person, such as Bobby or Lefty.

Uses the General column configuration.

Passport Number (Global)

Produces a random passport number that matches the country name or code that is in another column of the table.

Uses the General column configuration.

Passport Number (US)

Produces a random United States passport number.

Uses the General column configuration.

Person Name Suffix

Produces a name suffix. The possible suffixes are Jr., Sr., and III.

The suffix is applied to 2% of male names.

Uses the General column configuration.

Person Name Title

Produces a name title. The possible titles are Mr., Mrs., Ms., and Dr..

The Dr. prefix is applied to 1% of all records.

The remaining titles are distributed evenly among the records, and correspond to the gender of the name columns.

Uses the General column configuration.

Sex

Populates a column with either Male or Female.

Uses the General column configuration.

SSN

Populates a column with valid United States Social Security numbers (SSNs).

{ 
  "name": string,
  "data_type": string,
  "generator": "Phone Number",
  // Generator-specific fields
  "include_dash": boolean, // Whether to include dashes
  // End generator-specific fields
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Username

Populates a column with a username. For example, johndoe.

Uses the General column configuration.

Last updated