synthetic-data-crafter 1.1.5
Generate hyper-realistic synthetic data at scale — 750+ field types, real-world distributions, relational schemas, and one-click export to CSV, JSON, Parquet, SQL, Excel, Avro, and more.
Requires Python: >=3.8

# SyntheticDataCrafter by Iki

> **Hyper-realistic synthetic data generator** — 750+ field types, real-world distributions, relational schemas, and instant export to 10+ formats.

## ✨ Why SyntheticDataCrafter wins

| Feature                       | What you get                                                                               |
| ----------------------------- | ------------------------------------------------------------------------------------------ |
| 750+ realistic fields         | Names, addresses, phones, emails, credit cards, IBAN, SWIFT, ICD-10, stock tickers, UUIDs… |
| 20+ categories                | Personal, Finance, Commerce, Health, IT, Travel, Science, Crypto, Automotive, etc.         |
| Country-specific realism      | Localized phones, addresses, postal codes, national IDs for 100+ countries                 |
| Statistical distributions     | Normal, Poisson, Exponential, Binomial, Zipf, custom weights                               |
| Relational & conditional data | One-to-many, foreign keys, field dependencies, realistic correlations                      |
| 10+ export formats            | CSV, JSON, Parquet, SQL, Excel, XML, DuckDB, Firebase, CQL, Avro, DBUnit, TSV              |
| Zero bloat                    | No external dependencies for core exports                                                  |
| Fluent, chainable API         | Readable, fast, scales to millions of rows                                                 |

## ⚡ Installation

Install the latest version from PyPI:

```bash
pip install synthetic-data-crafter
```

## 🚀 Quick Start

```python
from synthetic_data_crafter import SyntheticDataCrafter

schema = [
    {
        "label": "id",
        "key_label": "row_number",
        "group": 'basic',
        "options": {"blank_percentage": 0}
    },
    {
        "label": "First Name",
        "key_label": "first_name",
        "group": 'personal',
        "options": {"blank_percentage": 0}
    },
    {
        "label": "Last Name",
        "key_label": "last_name",
        "group": 'personal',
        "options": {"blank_percentage": 0}
    },
    {
        "label": "gender",
        "key_label": "gender_binary",
        "group": 'personal',
        "options": {"blank_percentage": 0}
    },

    {
        "label": "email",
        "key_label": "email_address",
        "group": 'basic',
        "options": {"blank_percentage": 0}
    },

]

# Generate 100 records and export to all formats
SyntheticDataCrafter(schema).many(100).export(
    table_name="users",
    output_dir="output",
    formats=['csv'] # Can be multiple "csv" ,"json", "sql","cql", "firebase",  "excel",  "xml","dbunit", "parquet", "duckdb",
)
```

## 📚 Schema Structure

Each field in your schema requires:

| Property    | Description                                 | Required |
| ----------- | ------------------------------------------- | -------- |
| `label`     | Column name in output                       | ✅       |
| `key_label` | Data type identifier (see categories below) | ✅       |
| `group`     | Category group                              | ✅       |
| `options`   | Field-specific parameters                   | ✅       |

### Common Options

- `blank_percentage`: Probability of null values (0-100)
- Format-specific options vary by `key_label` (see below)

## 🎨 Data Categories & Examples

### 🔹 Basic

| Label                    | Key Label                  | Description                                                                                | Examples                                    |
| ------------------------ | -------------------------- | ------------------------------------------------------------------------------------------ | ------------------------------------------- |
| Exponential Distribution | `exponential_distribution` | Generates numbers based on an exponential distribution with a specific λ rate              | `0.5`, `2.3`, `5.7`                         |
| ULID                     | `ulid`                     | Universally Unique Lexicographically-sortable Identifier                                   | `01ARZ3NDEKTSV4RRFFQ69G5FAV`                |
| Time                     | `time`                     | Random time values                                                                         | `3:30 PM`, `15:30`, `08:45:30`              |
| Short Hex Color          | `short_hex_color`          | 3-character hex color codes                                                                | `#14b`, `#a32`, `#926`                      |
| Sequence                 | `sequence`                 | Generates a sequence of numbers with adjustable step and repeat options                    | `1`, `2`, `3`, `4`                          |
| Sentences                | `sentences`                | Chosen randomly from lorem ipsum                                                           | `Lorem ipsum dolor sit amet.`               |
| Row Number               | `row_number`               | Sequential row numbers                                                                     | `1`, `2`, `3`                               |
| Poisson Distribution     | `poisson_distribution`     | Generates numbers based on a Poisson distribution with a specific mean value               | `3`, `5`, `7`                               |
| Password Hash            | `password_hash`            | The bcrypt hash of a randomly generated password                                           | `$2b$10$N9qo8uLOickgx2ZMRZoMy...`           |
| Password                 | `password`                 | Generate passwords with customizable requirements                                          | `P@ssw0rd123`, `Secure#Pass99`              |
| Paragraphs               | `paragraphs`               | Chosen randomly from lorem ipsum                                                           | `Lorem ipsum dolor sit amet...`             |
| Number                   | `number`                   | Random numerical values                                                                    | `0.25`, `5.2`, `1000`                       |
| Normal Distribution      | `normal_distribution`      | Generates random numbers in a normal distribution using the Box-Muller algorithm           | `170.5`, `165.2`, `180.3`                   |
| Frequency                | `frequency`                | Frequency values                                                                           | `Daily`, `Weekly`, `Monthly`, `Yearly`      |
| Nato Phonetic            | `nato_phonetic`            | NATO phonetic alphabet                                                                     | `Whiskey`, `Alpha`, `Bravo`                 |
| ISBN                     | `isbn`                     | International Standard Book Number                                                         | `574398570-7`, `938492119-X`, `758622794-2` |
| Hex Color                | `hex_color`                | 6-character hex color codes                                                                | `#142a0b`, `#F0F0F0`, `#0066FF`             |
| Address Line 2           | `address_line_2`           | Room, Apt, Floor, Suite, or PO box number                                                  | `Apt 5B`, `Suite 200`, `Floor 3`            |
| Binomial Distribution    | `binomial_distribution`    | Generates numbers based on a binomial distribution with a specific probability of success  | `5`, `7`, `3`                               |
| Blank                    | `blank`                    | Always generates a null value                                                              | `null`, `NULL`, ``                          |
| Boolean                  | `boolean`                  | True or false values                                                                       | `true`, `false`                             |
| Color                    | `color`                    | Color names                                                                                | `Red`, `Blue`, `Black`                      |
| Custom List              | `custom_list`              | Picks items randomly or sequentially from a custom list of values                          | User-defined values                         |
| Datetime                 | `datetime`                 | Date and time values                                                                       | `07/04/2013`, `4.7.2013`, `04-Jul-2013`     |
| Geometric Distribution   | `geometric_distribution`   | Generates numbers based on a geometric distribution with a specific probability of success | `2`, `5`, `8`                               |
| Encrypt                  | `encrypt`                  | Simulates encrypted text                                                                   | `U2FsdGVkX1...`, `aGVsbG8gd29ybGQ=`         |
| MongoDB ObjectID         | `mongodb_objectid`         | Globally unique identifiers for MongoDB objects                                            | `507f1f77bcf86cd799439011`                  |
| Dice Roll                | `dice_roll`                | Random dice roll results (1-6)                                                             | `1`, `6`, `4`                               |
| Words                    | `words`                    | Chosen randomly from lorem ipsum                                                           | `Lorem`, `ipsum`, `dolor`                   |
| Sentiment                | `sentiment`                | Sentiment analysis categories                                                              | `Positive`, `Negative`, `Neutral`           |
| Month                    | `month`                    | Months of the year                                                                         | `January`, `June`, `December`               |
| Metric Prefix            | `metric_prefix`            | Metric system prefixes                                                                     | `kilo`, `mega`, `giga`, `milli`             |
| Duration                 | `duration`                 | Time duration formats                                                                      | `2h 30m`, `45 seconds`, `3 days`            |
| Dimension                | `dimension`                | Physical dimensions                                                                        | `1920x1080`, `8.5x11`, `50x30x20`           |
| Day of Week              | `day_of_week`              | Days of the week                                                                           | `Monday`, `Friday`, `Sunday`                |
| Weight                   | `weight`                   | Weight measurements with units                                                             | `150 lbs`, `68 kg`, `12 oz`                 |
| Height                   | `height`                   | Height measurements with units                                                             | `5'10"`, `170 cm`, `6 feet`                 |
| Weather Condition        | `weather_condition`        | Weather descriptions                                                                       | `Sunny`, `Rainy`, `Cloudy`                  |
| Temperature              | `temperature`              | Temperature values with units                                                              | `72°F`, `22°C`, `-5°C`                      |
| Paper Size               | `paper_size`               | Paper sizes                                                                                | `A4`, `Letter`, `Legal`                     |
| Season                   | `season`                   | Four seasons of the year                                                                   | `Spring`, `Summer`, `Fall`, `Winter`        |
| Punctuation              | `punctuation`              | Punctuation marks                                                                          | `Period`, `Comma`, `Exclamation`            |
| Emoji                    | `emoji`                    | Random emoji characters                                                                    | `😀`, `🎉`, `❤️`                            |
| Priority Level           | `priority_level`           | Priority classifications                                                                   | `Low`, `Medium`, `High`, `Critical`         |
| Rating                   | `rating`                   | Numerical ratings (0-5 stars)                                                              | `4.5`, `3.8`, `5.0`                         |

**Options Examples:**

```python
# Datetime with range and format
{
    "label": "created_at",
    "key_label": "datetime",
    "group": "basic",
    "options": {
        "from_date": "2023-01-01",
        "to_date": "2024-12-31",
        "format": "m/d/yyyy"  # or "d.m.yyyy", "dd-MMM-yyyy", etc.
    }
}

# Time with format options
{
    "label": "shift_start",
    "key_label": "time",
    "group": "basic",
    "options": {
        "from": "08:00",
        "to": "17:00",
        "format": "24 Hour"  # "24 Hour w/seconds", "12 Hour", "12 Hour w/millis", etc.
    }
}

# Password with requirements
{
    "label": "password",
    "key_label": "password",
    "group": "basic",
    "options": {
        "min_length": 12,
        "upper": True,
        "lower": True,
        "numbers": True,
        "symbols": True
    }
}

# Password Hash
{
    "label": "hashed_password",
    "key_label": "password_hash",
    "group": "basic",
    "options": {
        "min_length": 8,
        "max_length": 20
    }
}

# Sequence with advanced options
{
    "label": "seq_id",
    "key_label": "sequence",
    "group": "basic",
    "options": {
        "start_at": 1000,
        "step": 10,
        "repeat": 2,
        "restart_at": 5000
    }
}

# Words with range
{
    "label": "keywords",
    "key_label": "words",
    "group": "basic",
    "options": {
        "at_least": 3,
        "but_no_more_than": 7
    }
}

# Custom List
{
    "label": "status",
    "key_label": "custom_list",
    "group": "basic",
    "options": {
        "format": ["active", "pending", "suspended", "archived"]
    }
}

# Dimension
{
    "label": "screen_size",
    "key_label": "dimension",
    "group": "basic",
    "options": {
        "type": "screen"  # or "paper", "product", etc.
    }
}
```

### 📈 Statistical Distributions

**Key Labels:** `normal_distribution`, `binomial_distribution`, `poisson_distribution`, `exponential_distribution`, `geometric_distribution`

```python
# Normal Distribution
{
    "label": "height_cm",
    "key_label": "normal_distribution",
    "group": "basic",
    "options": {
        "mean": 170,
        "standard_deviation": 10,
        "decimals": 1
    }
}

# Binomial Distribution
{
    "label": "success_count",
    "key_label": "binomial_distribution",
    "group": "basic",
    "options": {
        "success_probability": 0.7  # Decimal between 0 and 1
    }
}

# Poisson Distribution
{
    "label": "events_per_hour",
    "key_label": "poisson_distribution",
    "group": "basic",
    "options": {
        "mean": 5
    }
}

# Exponential Distribution
{
    "label": "wait_time",
    "key_label": "exponential_distribution",
    "group": "basic",
    "options": {
        "lambda": 0.5
    }
}

# Geometric Distribution
{
    "label": "attempts_until_success",
    "key_label": "geometric_distribution",
    "group": "basic",
    "options": {
        "success_probability": 0.3  # Decimal between 0 and 1
    }
}
```

### 🚀 Advanced

| Label              | Key Label            | Description                                                                          | Examples                                      |
| ------------------ | -------------------- | ------------------------------------------------------------------------------------ | --------------------------------------------- |
| Digit Sequence     | `digit_sequence`     | Create simple sequences of characters, digits, and symbols                           | `12345`, `99999`, `00001`                     |
| JSON Array         | `json_array`         | Generates an array of objects in JSON format                                         | `[{"id": 1}, {"id": 2}]`                      |
| Naughty String     | `naughty_string`     | Strings which have a high probability of causing issues when used as user-input data | `<script>alert()</script>`, `', DROP TABLE--` |
| Regular Expression | `regular_expression` | Generate random data based on a regular expression                                   | `[A-Z]{3}-[0-9]{4}` matches `ABC-1234`        |
| Character Sequence | `character_sequence` | Create simple sequences of characters, digits, and symbols                           | `ABCDE`, `AAA-111`, `XYZ123`                  |
| Lambda             | `lambda`             | Generates values using a custom lambda function.                                     | `lambda row: row["First Name"] + "X"`         |

```python
# JSON Array
{
    "label": "tags",
    "key_label": "json_array",
    "group": "advanced",
    "options": {
        "min_elements": 2,
        "max_elements": 5
    }
}

# Regular Expression
{
    "label": "serial_number",
    "key_label": "regular_expression",
    "group": "advanced",
    "options": {
        "format": "[A-Z]{3}-[0-9]{4}"
    }
}

# Character Sequence
{
    "label": "code_seq",
    "key_label": "character_sequence",
    "group": "advanced",
    "options": {
        "format": "ABC-###-XYZ"  # # for digits, A for letters
    }
}
```

### 👤 Personal

| Label                  | Key Label              | Description                                        | Examples                                                |
| ---------------------- | ---------------------- | -------------------------------------------------- | ------------------------------------------------------- |
| Conference Name        | `conference_name`      | Conference and event names                         | `TechCrunch Disrupt`, `CES`, `SXSW`                     |
| Catch Phrase           | `catch_phrase`         | Multiple buzzwords strung together                 | `Seamless cloud-native solutions`                       |
| Performance Rating     | `performance_rating`   | Performance ratings                                | `Exceeds Expectations`, `Meets`, `Needs Improvement`    |
| Event Type             | `event_type`           | Event categories                                   | `Wedding`, `Birthday`, `Conference`                     |
| Business Type          | `business_type`        | Legal business entity types                        | `LLC`, `Corporation`, `Sole Proprietorship`             |
| Degree                 | `degree`               | Academic degree names                              | `Bachelor of Science`, `Master of Arts`, `PhD`          |
| Education Level        | `education_level`      | Levels of educational attainment                   | `High School`, `Bachelor's Degree`, `Master's Degree`   |
| Age Group              | `age_group`            | Demographic age ranges                             | `18-24`, `25-34`, `55-64`                               |
| Industry               | `industry`             | Business industry classifications                  | `Healthcare`, `Technology`, `Manufacturing`             |
| Employment Status      | `employment_status`    | Employment status categories                       | `Full-time`, `Part-time`, `Contractor`                  |
| Hair Color             | `hair_color`           | Hair color types                                   | `Blonde`, `Brown`, `Black`, `Red`                       |
| Race                   | `race`                 | Racial categories                                  | `Filipino`, `Venezuelan`, `Asian`                       |
| Contract Type          | `contract_type`        | Employment contract types                          | `Permanent`, `Fixed-term`, `Freelance`                  |
| Company Name           | `company_name`         | Real company names                                 | `Google`, `Home Depot`, `General Electric`              |
| Religion               | `religion`             | Religious affiliations                             | `Christianity`, `Islam`, `Buddhism`                     |
| Hashtag                | `hashtag`              | Social media hashtags                              | `#travel`, `#foodie`, `#fitness`                        |
| Team Name              | `team_name`            | Team name patterns                                 | `Marketing Team`, `Development Squad`                   |
| Salary Range           | `salary_range`         | Salary ranges for job positions                    | `$50000-$75000`, `$100000-$150000`                      |
| Pronoun                | `pronoun`              | Personal pronouns                                  | `he/him`, `she/her`, `they/them`                        |
| LinkedIn Skill         | `linkedin_skill`       | LinkedIn skills                                    | `Algorithms`, `Sports Nutrition`, `Payroll`             |
| Pet Name               | `pet_name`             | Common pet names                                   | `Max`, `Bella`, `Charlie`                               |
| Last Name              | `last_name`            | Last names                                         | `Smith`, `Jones`, `Miller`                              |
| Income Level           | `income_level`         | Income brackets                                    | `Low`, `Middle`, `High`                                 |
| Language Code          | `language_code`        | ISO language codes                                 | `de`, `en`, `es`                                        |
| Nationality            | `nationality`          | National identities                                | `American`, `Japanese`, `Brazilian`                     |
| Job Title              | `job_title`            | Job titles                                         | `Design Engineer`, `General Manager`                    |
| Mood                   | `mood`                 | Emotional states and moods                         | `Happy`, `Anxious`, `Excited`                           |
| Pet Type               | `pet_type`             | Pet categories                                     | `Dog`, `Cat`, `Bird`, `Fish`                            |
| Political Party        | `political_party`      | Political parties                                  | `Democratic`, `Republican`, `Independent`               |
| Department (Corporate) | `department_corporate` | Corporate departments                              | `Human Resources`, `Accounting`, `Engineering`          |
| Military Rank          | `military_rank`        | Military rank titles                               | `Sergeant`, `Captain`, `Colonel`                        |
| Language               | `language`             | Language names                                     | `German`, `English`, `Spanish`                          |
| Buzzword               | `buzzword`             | Business buzzwords                                 | `contextually-based`, `radical`, `proactive`            |
| Interview Stage        | `interview_stage`      | Recruitment stages                                 | `Phone Screen`, `Technical`, `Final Round`              |
| Zodiac Sign            | `zodiac_sign`          | Astrological zodiac signs                          | `Aries`, `Taurus`, `Gemini`                             |
| Dream Job              | `dream_job`            | Aspirational job roles                             | `Astronaut`, `CEO`, `Data Scientist`                    |
| Personality Trait      | `personality_trait`    | Behavioral personality types                       | `Introvert`, `Extrovert`, `Analytical`                  |
| DUNS Number            | `duns_number`          | Randomly generated DUNS numbers                    | `12-345-6789`, `98-765-4321`                            |
| EIN                    | `ein`                  | Randomly generated employer identification numbers | `12-3456789`, `98-7654321`                              |
| Project Status         | `project_status`       | Project statuses                                   | `Not Started`, `In Progress`, `Completed`               |
| Quote                  | `quote`                | Famous quotes                                      | `To be or not to be`, `The only limit is...`            |
| Marital Status         | `marital_status`       | Marital status categories                          | `Single`, `Married`, `Divorced`                         |
| Reaction               | `reaction`             | Social media reactions                             | `Like`, `Love`, `Angry`, `Sad`                          |
| Fake Company Name      | `fake_company_name`    | Fictional company names                            | `Morar Group`, `Stark-Glover`, `Sawayn and Sons`        |
| Relationship Type      | `relationship_type`    | Relationship categories                            | `Friend`, `Colleague`, `Family`                         |
| Role                   | `role`                 | System roles                                       | `Admin`, `User`, `Moderator`                            |
| First Name             | `first_name`           | First names (any gender)                           | `Jim`, `Mark`, `Sasha`                                  |
| First Name (Female)    | `first_name_female`    | Female first names                                 | `Susan`, `Jessica`, `Sasha`                             |
| First Name (Male)      | `first_name_male`      | Male first names                                   | `Mark`, `Bob`, `Tim`                                    |
| Daily Habit            | `daily_habit`          | Regular daily routines                             | `Morning Run`, `Reading`, `Meditation`                  |
| University             | `university`           | University names                                   | `The Johns Hopkins University`, `Pepperdine University` |
| Suffix                 | `suffix`               | Name suffixes                                      | `Jr`, `Sr`, `III`                                       |
| Organization Type      | `organization_type`    | Organization categories                            | `Nonprofit`, `Government`, `Private`                    |
| Occupation             | `occupation`           | Occupations                                        | `Teacher`, `Engineer`, `Nurse`                          |
| Shirt Size             | `shirt_size`           | Shirt sizes                                        | `S`, `M`, `L`                                           |
| Shoe Size              | `shoe_size`            | Shoe sizes                                         | `8`, `10.5`, `42`                                       |
| Gender (Facebook)      | `gender_facebook`      | The Facebook gender list as of 2021                | `Male`, `Female`, `Non-binary`, `Custom`                |
| Title                  | `title`                | Name titles                                        | `Mr`, `Ms`, `Dr`                                        |
| Gender (abbrev)        | `gender_abbrev`        | Abbreviated genders                                | `M`, `F`                                                |
| Gender (Binary)        | `gender_binary`        | Binary gender options                              | `Female`, `Male`                                        |
| Full Name              | `full_name`            | Full names                                         | `Nancy Smith`, `Tim Fisher`, `Al Jones`                 |
| Life Stage             | `life_stage`           | Human life stages                                  | `Infant`, `Teenager`, `Adult`, `Senior`                 |
| Slogan                 | `slogan`               | Randomly generated marketing slogans               | `Just Do It`, `Think Different`                         |
| SSN                    | `ssn`                  | Social Security Numbers                            | `678-59-9455`, `312-20-4597`                            |
| Legal Entity           | `legal_entity`         | Legal entity types                                 | `Individual`, `Partnership`, `Corporation`              |
| Gender                 | `gender`               | Gender options                                     | `Female`, `Male`, `Non-binary`                          |
| Hobby                  | `hobby`                | Common hobbies and interests                       | `Photography`, `Hiking`, `Cooking`                      |

**Options Examples:**

```python
# Employee ID (EIN)
{
    "label": "employee_id",
    "key_label": "ein",
    "group": "personal",
    "options": {"blank_percentage": 0}
}

# Shoe Size with type
{
    "label": "shoe_size",
    "key_label": "shoe_size",
    "group": "personal",
    "options": {
        "type": "US"  # or "EU"
    }
}

# Tax ID with type
{
    "label": "tax_id",
    "key_label": "tax_id",
    "group": "personal",
    "options": {
        "type": "SSN"  # or "EIN"
    }
}
```

### 🛍️ Commerce

| Label                        | Key Label                      | Description                                    | Examples                                                              |
| ---------------------------- | ------------------------------ | ---------------------------------------------- | --------------------------------------------------------------------- |
| Water Type                   | `water_type`                   | Water types                                    | `Tap`, `Spring`, `Distilled`                                          |
| Postal Service               | `postal_service`               | Shipping carriers                              | `USPS`, `FedEx`, `UPS`, `DHL`                                         |
| Payment Status               | `payment_status`               | Payment statuses                               | `Paid`, `Pending`, `Failed`                                           |
| Membership Level             | `membership_level`             | Membership tiers                               | `Free`, `Basic`, `Premium`                                            |
| Office Supply                | `office_supply`                | Office supplies                                | `Stapler`, `Notebook`, `Pen`                                          |
| Warranty Period              | `warranty_period`              | Warranty durations                             | `1 Year`, `90 Days`, `Lifetime`                                       |
| Sales Channel                | `sales_channel`                | Sales channels                                 | `Online`, `Retail`, `Wholesale`                                       |
| Delivery Time Window         | `delivery_time_window`         | Estimated delivery time windows                | `9AM-12PM`, `1PM-5PM`                                                 |
| IBAN                         | `iban`                         | International Bank Account Number              | `FR73 5960 2948 07N1 L9TC PVYX E17`, `SE85 4302 3680 7231 4238 1624`  |
| BBAN                         | `bban`                         | Basic Bank Account Number                      | `8374920183749201`, `A3F9K8L0Q1R2Z7X5B6C7`, `12345678901234567890123` |
| Department (Retail)          | `department_retail`            | Retail department names                        | `Grocery`, `Books`, `Health & Beauty`                                 |
| Currency Code                | `currency_code`                | ISO currency codes                             | `USD`, `EUR`, `MXN`                                                   |
| Currency                     | `currency`                     | Currency names                                 | `Dollar`, `Euro`, `Peso`                                              |
| Credit Card Type             | `credit_card_type`             | Credit card brand                              | `visa`, `mastercard`, `americanexpress`                               |
| Credit Card #                | `credit_card_number`           | Valid credit card numbers                      | `4017959045824`, `5349690971837932`                                   |
| Meal Type                    | `meal_type`                    | Meal categories                                | `Breakfast`, `Lunch`, `Dinner`                                        |
| Customer Feedback Score      | `customer_feedback_score`      | Feedback or satisfaction scores                | `1`, `5`, `10`                                                        |
| Bundle Type                  | `bundle_type`                  | Product bundle classifications                 | `Buy1Take1`, `Starter Pack`, `Premium Bundle`                         |
| Promo Expiry Date            | `promo_expiry_date`            | Expiration dates for promotions                | `2025-12-31`, `2026-01-15`                                            |
| Return Reason                | `return_reason`                | Reasons for product returns                    | `Damaged`, `Wrong Item`, `Defective`                                  |
| Money                        | `money`                        | Monetary values with currency symbols          | `$3.00`, `£12.94`, `€127,54`                                          |
| Loyalty Tier                 | `loyalty_tier`                 | Customer loyalty levels                        | `Bronze`, `Silver`, `Gold`, `Platinum`                                |
| Recipe Name                  | `recipe_name`                  | Recipe titles                                  | `Chocolate Chip Cookies`, `Spaghetti Carbonara`                       |
| Ingredient                   | `ingredient`                   | Cooking ingredients                            | `Flour`, `Sugar`, `Butter`                                            |
| Stock Symbol                 | `stock_symbol`                 | Stock ticker symbols                           | `MSFT`, `NTAP`, `TBBK`                                                |
| Stock Sector                 | `stock_sector`                 | Stock market sectors                           | `Technology`, `Capital Goods`, `Finance`                              |
| Stock Name                   | `stock_name`                   | Company stock names                            | `Microsoft Corporation`, `NetApp, Inc.`                               |
| Stock Market Cap             | `stock_market_cap`             | Market capitalization                          | `$33.03B`, `$54.29M`, `$41.02M`                                       |
| Stock Market                 | `stock_market`                 | Stock exchange names                           | `NYSE`, `NASDAQ`                                                      |
| Stock Industry               | `stock_industry`               | Industry classifications                       | `Semiconductors`, `Major Banks`                                       |
| Product Subcategory          | `product_subcategory`          | Product subcategory names                      | `Plant-Based Beverages`, `Gourmet Snacks`                             |
| Inventory Status             | `inventory_status`             | Inventory statuses                             | `In Stock`, `Out of Stock`, `Backordered`                             |
| Product Name                 | `product_name`                 | Product names                                  | `Classic Black Trousers`, `Lemon Dill Salmon`                         |
| Product Description          | `product_description`          | Product descriptions                           | `Savory lentil chips with BBQ flavor`                                 |
| Product Category             | `product_category`             | Product categories                             | `Toys`, `Clothing - Outerwear`, `Outdoor`                             |
| Barcode (EAN-13)             | `barcode_ean13`                | 13-digit European Article Number with checksum | `5901234123457`, `4006381333931`                                      |
| Barcode (UPC)                | `barcode_upc`                  | 12-digit Universal Product Code with checksum  | `012345678905`, `614141007349`                                        |
| Coupon Code                  | `coupon_code`                  | Promotional discount codes                     | `SAVE20`, `FREESHIP`, `WELCOME10`                                     |
| Invoice Number               | `invoice_number`               | Invoice identification numbers                 | `INV-2024-001`, `INV-20241031-4523`                                   |
| Product Price                | `product_price`                | The price of a product                         | `$29.99`, `€45.50`, `£12.99`                                          |
| Currency Symbol              | `currency_symbol`              | Currency symbols                               | `$`, `€`, `¥`, `£`                                                    |
| Order Status                 | `order_status`                 | E-commerce order status                        | `Processing`, `Shipped`, `Delivered`                                  |
| Furniture Type               | `furniture_type`               | Furniture categories                           | `Sofa`, `Desk`, `Chair`                                               |
| Fabric Type                  | `fabric_type`                  | Textile fabric types                           | `Cotton`, `Polyester`, `Silk`                                         |
| Discount Percentage          | `discount_percentage`          | Discount amounts                               | `10%`, `25%`, `50%`                                                   |
| Delivery Status              | `delivery_status`              | Package delivery statuses                      | `Out for Delivery`, `In Transit`, `Delivered`                         |
| Coffee Type                  | `coffee_type`                  | Coffee drink types                             | `Espresso`, `Cappuccino`, `Latte`                                     |
| Track Number                 | `tracking_number`              | Shipping tracking numbers                      | `1Z999AA10123456784`                                                  |
| Subscription Plan            | `subscription_plan`            | Subscription tier names                        | `Basic`, `Premium`, `Enterprise`                                      |
| Gem Stone                    | `gem_stone`                    | Precious stones                                | `Diamond`, `Ruby`, `Emerald`                                          |
| Review Text                  | `review_text`                  | Fake product/service review text               | `Great product!`, `Highly recommend`                                  |
| Payment Method               | `payment_method`               | Payment method types                           | `Credit Card`, `