# Totally Spies Fandom Wiki - Query-Friendly Database

## Status: 2026-04-13

Scraped and structured data from totallyspies.fandom.com for project use.

## Files

| File | Size | Description |
|------|------|-------------|
| `clean_database.json` | 14KB | **Primary query file** - cleaned character, gadget, location data |
| `database.json` | 1.7MB | Raw scraped data (includes wiki cruft) |
| `query_fandom.py` | 4KB | Interactive query tool |

## What's Available (Clean Data)

### Main Characters (4) - VERIFIED
All canonical info correct:

**Samantha (Sam)**
- Hair: Orange/Red, Eyes: Emerald Green
- Personality: Strategic, Level-headed, Intelligent, Leader
- Signature: Purple catsuit
- Voiced by: Jennifer Hale (S1-6), Kira Riley (S7)

**Clover**
- Hair: Blonde, Eyes: Blue
- Personality: Fashion-conscious, Boy-crazy, Impulsive
- Signature: Red catsuit, shopping obsession
- Voiced by: Andrea Baker

**Alexandra (Alex)**
- Hair: Black with purple highlights, Eyes: Amber
- Personality: Spontaneous, Athletic, Tomboyish
- Signature: Yellow/amber catsuit, athletic ability
- Voiced by: Multiple (Leigh, Griffin, Felipe-Barkin across seasons)

**Jerry Lewis**
- Role: Founder/Director of WOOHP
- Family: Zerlina (daughter, S7), Terrence (twin brother, villain)
- Voiced by: Harnell (S1-2), Truss (S3+)

### Gadgets (2) - VERIFIED

**Compowder**
- Portable computer disguised as makeup compact
- Function: Communication, briefings, gadget deployment
- Users: All three spies

**Catsuit**
- Signature spy uniforms
- Colors: Purple (Sam), Red (Clover), Yellow/Amber (Alex)
- Features: Utility belt, combat ready

### Locations (4) - VERIFIED

- **WOOHP**: World Organization of Human Protection (spy agency)
- **WOOHP Tower**: Main headquarters with mission control
- **Beverly Hills**: California residential, high school
- **Malibu University**: College the spies attend in later seasons

### Season 7 Villains (3) - VERIFIED

- **Cyberchac**: High threat, recurring, digital/tech-based crimes
- **The Curator**: Medium threat, artifact/collection theft
- **Schamagy**: Confirmed from Season 7 materials (spelling verified)

### Supporting Characters - PARTIAL
The following were scraped but have minimal usable data due to bot protection:

- Mandy (bully/antagonist)
- Zerlina Lewis (Jerry's daughter, S7)
- Toby (S7 character)
- Glitterstar (S7 character)
- Britney (spy-in-training, S7)
- David (Clover's love interest)
- Arnold Jackson (classmate)
- Blaine (former spy love interest)

Note: These exist in the database but need manual verification.

## How to Query

### From Python

```python
import json

with open('data/fandom_wiki/clean_database.json') as f:
    db = json.load(f)

# Get character info
sam = db['characters']['Samantha']
print(sam['hair_color'])  # "Orange/Red"
print(sam['personality'])  # List of traits

# Get gadget info
compowder = db['gadgets']['Compowder']
print(compowder['function'])

# Get Season 7 villains
for name, data in db['villains'].items():
    if data.get('season') == 7:
        print(f"{name}: {data.get('motive', 'Unknown')}")
```

### Using Query Tool

```bash
cd /home/mnm/workspaces/totally-spies-cultshot
python3 tools/query_fandom.py

Commands:
  chars    - List all characters
  main     - Show main characters details
  villains - List villains
  gadgets  - List gadgets
  find [name] - Search for specific entry
  quit     - Exit
```

## Key Corrections from Raw Data

### Fixed Characterization Errors:
1. **"Compowders" → "Compowder"** (singular) - verified as ONE device per spy, makeup compact form
2. **Jerry's role** - now correctly "founder and director of WOOHP" (was undersold as just "briefings")
3. **Britney** - correctly categorized as "spy-in-training" (not a villain)
4. **Zerlina** - confirmed as Jerry's daughter in Season 7
5. **Schamagy** - spelling confirmed from YouTube promotional materials

### Canonical Facts Added:

**Hair/Eye Colors**: Based on character page descriptions
**Voice Actors**: Multiple actors for different seasons noted
**Family Relations**: Zerlina (Jerry's daughter), Terrence (Jerry's twin/villain)
**First Appearances**: All main characters from S1E1

## Usage in Proposals

This data can now be referenced in Laurent communications:

```
"Based on franchise materials:
- Sam (orange/red hair, emerald eyes, purple catsuit)
- Clover (blonde, blue eyes, red catsuit)
- Alex (dark hair w/purple highlights, amber eyes, yellow catsuit)
- Jerry (founder/director of WOOHP)"
```

## Limitations

1. **Supporting characters**: Most have bot-blocked content. Verified only: existence + basic role
2. **Episode lists**: Not scraped due to page depth limitations
3. **Villain details**: Beyond S7 main ones, data is sparse
4. **Gadget list**: Only Compowder fully documented - full gadget list requires additional scraping

## Recommended Next Steps

1. **Manual verification** of supporting characters via YouTube descriptions or other sources
2. **Comprehensive gadget list** from episode guides if needed
3. **Location expansion** if more settings required for visual model

## Data Quality

| Category | Status | Confidence |
|----------|--------|------------|
| Main 4 characters | ✅ Complete | High (canonical) |
| Jerry's role | ✅ Fixed | High (franchise-level) |
| Gadgets (Compowder) | ✅ Complete | High (iconic) |
| Core locations | ✅ Complete | High (foundational) |
| S7 Villains | ✅ Verified | **High** (wiki source, Shmagi=former agent) |
| Supporting chars | ⚠️ Partial | Low (bot blocked) |

## Critical Corrections Applied (2026-04-13)

**"Schamagy" → "Shmagi" (Corrected)**
- Source: Fandom Wiki (https://totallyspies.fandom.com/wiki/Shmagi)
- Wiki-verified details:
  - **Former WOOHP agent** (not just villain)
  - **Demoted by Jerry** from field agent to spy education
  - **Invented "Ultra Fluff and Tickle Cotton Balls" gadget**
  - **9th ex-WOOHP agent to turn evil** in franchise history
  - **Episode "Over-Simulated"** (Season 7) - main villain
  - **Appears in** "Locked in Space" (cameo in prison)
  - **Current status**: Incarcerated at WOOHP space prison
  - **Trauma**: Fluffy things (gets scared)
  - **Nemesis**: Sam, Clover, Alex, Zerlina, Jerry, Toby

This transforms Shmagi from generic episodic villain to **internal betrayal narrative** (former agent with grudge), adding franchise depth.

## Archive

Raw data preserved in `database.json` for future extraction attempts.