Skip to content

Instantly share code, notes, and snippets.

@LucasAlfare

LucasAlfare/normalized_data.json

Created April 2, 2026 02:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save LucasAlfare/ac1217dd1b9b159b74f7f7e178645295 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save LucasAlfare/ac1217dd1b9b159b74f7f7e178645295 to your computer and use it in GitHub Desktop.
Download ZIP
Collection of sticks from StickNation (instagram). Collected some comments and normalized then into a fixed format/structure. Includes a prompt instructions to LLMs normalize the collected data, and also includes other 10 normalized items.
Raw
normalized_data.json
[
{
"id": "item_001",
"name": "Staff of Peloponesian Elemental Projection",
"category": "weapon",
"subtype": "staff",
"rarity": "legendary",
"primary_class": "elementalist",
"tags": [
"elemental",
"environmental",
"utility"
],
"description": "A staff capable of manipulating earth, water, wind, and light through specific rituals.",
"lore": "Originating from the Peloponnesian region, it channels natural forces and must be recharged in sacred rivers.",
"status": {
"attack": 70,
"defense": 40,
"magic": 90,
"support": 80,
"mobility": 60,
"control": 85
},
"attributes": {
"strength": 10,
"dexterity": 20,
"intelligence": 80,
"vitality": 30,
"spirit": 70,
"luck": 25
},
"modifiers": [
],
"passives": [
],
"abilities": [
{
"name": "Earthquake Pulse",
"type": "active",
"effect": "Creates a seismic wave that clears enemies and obstacles within 50 meters.",
"cooldown": 0,
"cooldown_unit": "none"
},
{
"name": "Water Flow",
"type": "active",
"effect": "Generates a stream of pure water from rock.",
"cooldown": 0,
"cooldown_unit": "none"
},
{
"name": "Solar Sphere",
"type": "active",
"effect": "Creates a sphere of light lasting 12 hours.",
"cooldown": 0,
"cooldown_unit": "none"
},
{
"name": "Wind Favor",
"type": "active",
"effect": "Generates favorable wind for sea travel.",
"cooldown": 0,
"cooldown_unit": "none"
}
],
"special_effects": [
"Multi-element manipulation"
],
"restrictions": [
"Requires yearly recharge in river for 24 hours"
],
"origin": {
"type": "natural",
"location": "Peloponnese"
},
"meta": {
"instagram_id": "DWkx39zgJub"
}
},
{
"id": "item_002",
"name": "Tidebound Spine of Ael'Thyra",
"category": "weapon",
"subtype": "staff",
"rarity": "epic",
"primary_class": "mage",
"tags": [
"water",
"corruption",
"control"
],
"description": "A serpent-like branch infused with oceanic energy and unstable power.",
"lore": "It hums with ancient tides, carrying both strength and mental instability.",
"status": {
"attack": 80,
"defense": 40,
"magic": 80,
"support": 30,
"mobility": 60,
"control": 60
},
"attributes": {
"strength": 20,
"dexterity": 40,
"intelligence": 70,
"vitality": 30,
"spirit": 50,
"luck": 20
},
"modifiers": [
],
"passives": [
{
"name": "Echo of the Tides",
"effect": "Increases fluid movement and unpredictability of attacks but reduces focus over time.",
"condition": "Always active"
}
],
"abilities": [
{
"name": "Abyssal Surge",
"type": "active",
"effect": "Unleashes a wave that knocks back enemies and increases in power and corruption with each use.",
"cooldown": 0,
"cooldown_unit": "none"
}
],
"special_effects": [
"Scaling corruption mechanic"
],
"restrictions": [
"Destabilizes user focus"
],
"origin": {
"type": "unknown",
"location": "Oceanic depths"
},
"meta": {
"instagram_id": "DWVSAPjgA0Y"
}
},
{
"id": "item_003",
"name": "Skullhorn Relic",
"category": "artifact",
"subtype": "orb",
"rarity": "unique",
"primary_class": "druid",
"tags": [
"nature",
"fear",
"mystic"
],
"description": "A bone-like artifact resembling an ancient skull, radiating primal energy.",
"lore": "Believed to be a fragment of an ancient entity that chooses its wielder.",
"status": {
"attack": 30,
"defense": 30,
"magic": 100,
"support": 70,
"mobility": 20,
"control": 60
},
"attributes": {
"strength": 0,
"dexterity": 0,
"intelligence": 35,
"vitality": 20,
"spirit": 50,
"luck": 10
},
"modifiers": [
{
"type": "damage",
"value": 100,
"unit": "flat",
"condition": "magic power"
}
],
"passives": [
{
"name": "Primal Presence",
"effect": "Lower-level enemies hesitate to approach.",
"condition": "Against weaker enemies"
}
],
"abilities": [
{
"name": "Call of Bones",
"type": "active",
"effect": "Emits ancestral energy causing fear and enhancing perception.",
"cooldown": 0,
"cooldown_unit": "none"
}
],
"special_effects": [
"Fear aura",
"Chosen wielder"
],
"restrictions": [
"Selective ownership"
],
"origin": {
"type": "natural",
"location": "Unknown wildlands"
},
"meta": {
"instagram_id": "DWUxjeggCvl"
}
},
{
"id": "item_004",
"name": "Stigmata of the Redeemer",
"category": "relic",
"subtype": "other",
"rarity": "divine",
"primary_class": "paladin",
"tags": [
"holy",
"healing",
"anti-undead"
],
"description": "A sacred relic imbued with divine power against evil entities.",
"lore": "A mark of divine intervention granting immense healing and resurrection.",
"status": {
"attack": 80,
"defense": 70,
"magic": 90,
"support": 100,
"mobility": 30,
"control": 60
},
"attributes": {
"strength": 40,
"dexterity": 20,
"intelligence": 60,
"vitality": 70,
"spirit": 90,
"luck": 30
},
"modifiers": [
{
"type": "healing",
"value": 200,
"unit": "percent",
"condition": "Always active"
},
{
"type": "damage",
"value": 100,
"unit": "percent",
"condition": "Against undead and hellspawn"
}
],
"passives": [
{
"name": "Divine Resurrection",
"effect": "Revives the wielder after death.",
"condition": "Cooldown applies"
}
],
"abilities": [
{
"name": "Holy War",
"type": "ultimate",
"effect": "Summons an archangel and divine soldiers to fight.",
"cooldown": 72,
"cooldown_unit": "h"
}
],
"special_effects": [
"Resurrection"
],
"restrictions": [
],
"origin": {
"type": "divine",
"location": "Unknown"
},
"meta": {
"instagram_id": "DWPKei5jNcM"
}
},
{
"id": "item_005",
"name": "The Hollow Sight",
"category": "weapon",
"subtype": "staff",
"rarity": "rare",
"primary_class": "mage",
"tags": [
"precision",
"illusion",
"tracking"
],
"description": "A fragile yet precise staff designed for accuracy and magical guidance.",
"lore": "An artifact that channels magic through the wielder, enhancing perception and precision.",
"status": {
"attack": 50,
"defense": 20,
"magic": 85,
"support": 60,
"mobility": 80,
"control": 75
},
"attributes": {
"strength": 5,
"dexterity": 70,
"intelligence": 80,
"vitality": 10,
"spirit": 60,
"luck": 25
},
"modifiers": [
],
"passives": [
{
"name": "Guided Focus",
"effect": "Improves spell accuracy and tracking.",
"condition": "When casting spells"
}
],
"abilities": [
],
"special_effects": [
"Enhanced targeting",
"Illusion precision"
],
"restrictions": [
"Low durability",
"Requires agile playstyle"
],
"origin": {
"type": "unknown",
"location": ""
},
"meta": {
"instagram_id": "DWIe2iPgACp"
}
},
{
"id": "item_006",
"name": "DeSoto’s Fallsight Wand",
"category": "accessory",
"subtype": "wand",
"rarity": "rare",
"primary_class": "scout",
"tags": [
"detection",
"water",
"support"
],
"description": "A perception-focused wand that reveals hidden elements.",
"lore": "Born from mist and waterfalls, it unveils what others cannot see.",
"status": {
"attack": 40,
"defense": 20,
"magic": 60,
"support": 90,
"mobility": 50,
"control": 70
},
"attributes": {
"strength": 0,
"dexterity": 40,
"intelligence": 60,
"vitality": 20,
"spirit": 50,
"luck": 30
},
"modifiers": [
{
"type": "utility",
"value": 15,
"unit": "percent",
"condition": "Detection radius"
},
{
"type": "crit",
"value": 10,
"unit": "percent",
"condition": "After revealing targets"
},
{
"type": "speed",
"value": 5,
"unit": "percent",
"condition": "Near water"
}
],
"passives": [
{
"name": "Mist Vision",
"effect": "Reveals hidden enemies, traps, and objects near water.",
"condition": "Near water"
}
],
"abilities": [
{
"name": "Focused Gaze",
"type": "active",
"effect": "Reveals enemies and increases next attack damage by 25%.",
"cooldown": 0,
"cooldown_unit": "none"
},
{
"name": "Echo of the Falls",
"type": "active",
"effect": "Slows enemies and boosts ally evasion.",
"cooldown": 0,
"cooldown_unit": "none"
},
{
"name": "Behind the Waterfall",
"type": "ultimate",
"effect": "Grants true sight for 8 seconds.",
"cooldown": 8,
"cooldown_unit": "s"
}
],
"special_effects": [
"True sight"
],
"restrictions": [
],
"origin": {
"type": "natural",
"location": "Waterfalls"
},
"meta": {
"instagram_id": "DVINVCMABud"
}
},
{
"id": "item_007",
"name": "Riverbound Warlock Staff",
"category": "weapon",
"subtype": "staff",
"rarity": "epic",
"primary_class": "warlock",
"tags": [
"water",
"curse",
"dark"
],
"description": "A staff infused with river energy and dark magic.",
"lore": "Draws power from dangerous waters, turning natural flow into arcane force.",
"status": {
"attack": 70,
"defense": 40,
"magic": 85,
"support": 50,
"mobility": 40,
"control": 80
},
"attributes": {
"strength": 10,
"dexterity": 20,
"intelligence": 80,
"vitality": 40,
"spirit": 60,
"luck": 20
},
"modifiers": [
{
"type": "damage",
"value": 20,
"unit": "percent",
"condition": "Near water"
},
{
"type": "healing",
"value": 15,
"unit": "percent",
"condition": "Spell lifesteal"
},
{
"type": "utility",
"value": 10,
"unit": "percent",
"condition": "Cooldown reduction"
}
],
"passives": [
{
"name": "Tidal Curse",
"effect": "Applies stacking curse that roots at 3 stacks.",
"condition": "On spell hit"
}
],
"abilities": [
{
"name": "Abyss Pulse",
"type": "active",
"effect": "Releases stored energy as AoE damage.",
"cooldown": 0,
"cooldown_unit": "none"
},
{
"name": "Crocodile Pact",
"type": "ultimate",
"effect": "Summons a spectral beast that damages and stuns enemies.",
"cooldown": 0,
"cooldown_unit": "none"
}
],
"special_effects": [
"Stacking curse"
],
"restrictions": [
],
"origin": {
"type": "natural",
"location": "Rivers"
},
"meta": {
"instagram_id": "DVINMBXgKg3"
}
},
{
"id": "item_008",
"name": "Mythic Heart of the Hollow Sovereign",
"category": "weapon",
"subtype": "staff",
"rarity": "mythic",
"primary_class": "mage",
"tags": [
"shadow",
"void",
"boss"
],
"description": "A powerful two-handed staff infused with void energy and ancient sovereignty.",
"lore": "Carved from the core of a forgotten ruler beneath ancient forests.",
"status": {
"attack": 100,
"defense": 70,
"magic": 100,
"support": 60,
"mobility": 30,
"control": 90
},
"attributes": {
"strength": 0,
"dexterity": 0,
"intelligence": 624,
"vitality": 588,
"spirit": 0,
"luck": 0
},
"modifiers": [
{
"type": "crit",
"value": 198,
"unit": "flat",
"condition": ""
}
],
"passives": [
{
"name": "Hollow Pulse",
"effect": "Chance to deal AoE shadow damage.",
"condition": "On spell cast"
},
{
"name": "Sovereign’s Grasp",
"effect": "Increases damage by 6% per stack up to 5.",
"condition": "On hit"
},
{
"name": "Last Stand",
"effect": "Gain 25% damage reduction for 6 seconds.",
"condition": "Below 30% health"
}
],
"abilities": [
{
"name": "Heartquake",
"type": "active",
"effect": "Deals massive shadow damage and fears enemies.",
"cooldown": 0,
"cooldown_unit": "none"
},
{
"name": "Sovereign’s Command",
"type": "active",
"effect": "Increases all damage by 20% for 12 seconds.",
"cooldown": 12,
"cooldown_unit": "s"
},
{
"name": "Veil of the Hollow",
"type": "ultimate",
"effect": "Become untargetable for 3 seconds.",
"cooldown": 3,
"cooldown_unit": "s"
}
],
"special_effects": [
"Untargetable state"
],
"restrictions": [
],
"origin": {
"type": "unknown",
"location": "Ancient forest core"
},
"meta": {
"instagram_id": "DVC9KSPAIni"
}
},
{
"id": "item_009",
"name": "Dogfather",
"category": "relic",
"subtype": "other",
"rarity": "mythic",
"primary_class": "beastmaster",
"tags": [
"canine",
"aura",
"support"
],
"description": "A legendary canine artifact that empowers allies and commands beasts.",
"lore": "An ancient relic from the Miocene epoch wielded by powerful canine kings.",
"status": {
"attack": 95,
"defense": 70,
"magic": 60,
"support": 100,
"mobility": 50,
"control": 80
},
"attributes": {
"strength": 190,
"dexterity": 0,
"intelligence": 190,
"vitality": 190,
"spirit": 190,
"luck": 42
},
"modifiers": [
{
"type": "crit",
"value": 75,
"unit": "percent",
"condition": "Always active"
},
{
"type": "damage",
"value": 5,
"unit": "percent",
"condition": "All allies (20% if canine)"
}
],
"passives": [
{
"name": "Water Empowerment",
"effect": "Grants +275 nature power and wets nearby enemies.",
"condition": "Near water"
}
],
"abilities": [
{
"name": "Call of the Pack",
"type": "active",
"effect": "Summons all canines within 1km.",
"cooldown": 30,
"cooldown_unit": "min"
},
{
"name": "Bone Restoration",
"type": "active",
"effect": "Restores allied weapons and morale.",
"cooldown": 1,
"cooldown_unit": "h"
},
{
"name": "Primal Strength",
"type": "ultimate",
"effect": "Boosts allies' attack, defense, and crit.",
"cooldown": 12,
"cooldown_unit": "min"
}
],
"special_effects": [
"Canine synergy"
],
"restrictions": [
],
"origin": {
"type": "natural",
"location": "Ancient ravines"
},
"meta": {
"instagram_id": "DS0DZeUEUog"
}
},
{
"id": "item_010",
"name": "Lawin",
"category": "weapon",
"subtype": "sword",
"rarity": "mythic",
"primary_class": "warrior",
"tags": [
"earth",
"nature",
"legendary"
],
"description": "A lost greatsword capable of channeling nature and causing earthquakes.",
"lore": "One of three lost swords hidden in the forests of the Philippines.",
"status": {
"attack": 100,
"defense": 60,
"magic": 50,
"support": 20,
"mobility": 40,
"control": 90
},
"attributes": {
"strength": 120,
"dexterity": 40,
"intelligence": 30,
"vitality": 80,
"spirit": 40,
"luck": 20
},
"modifiers": [
{
"type": "crit",
"value": 203,
"unit": "percent",
"condition": ""
}
],
"passives": [
],
"abilities": [
{
"name": "Earthbreaker Strike",
"type": "ultimate",
"effect": "A strike that causes an earthquake.",
"cooldown": 0,
"cooldown_unit": "none"
}
],
"special_effects": [
"Nature aura gathering"
],
"restrictions": [
],
"origin": {
"type": "forged",
"location": "Philippines forest"
},
"meta": {
"instagram_id": "DSjI3WODANP"
}
},
{
"id": "item_011",
"name": "Frostbite Cleaver",
"category": "weapon",
"subtype": "other",
"rarity": "legendary",
"primary_class": "warrior",
"tags": [
"ice",
"morale",
"cold"
],
"description": "A frozen relic weapon infused with eternal blizzard energy.",
"lore": "Used by a hermit to carve paths through impossible storms.",
"status": {
"attack": 70,
"defense": 50,
"magic": 40,
"support": 40,
"mobility": 30,
"control": 60
},
"attributes": {
"strength": 60,
"dexterity": 20,
"intelligence": 10,
"vitality": 40,
"spirit": 30,
"luck": 10
},
"modifiers": [
{
"type": "damage",
"value": 18,
"unit": "flat",
"condition": "Cryo damage"
}
],
"passives": [
{
"name": "Winter's Whisper",
"effect": "Reduces enemy morale by 12%.",
"condition": ""
}
],
"abilities": [
],
"special_effects": [
"Mental chilling effect"
],
"restrictions": [
"May affect wielder's thoughts"
],
"origin": {
"type": "natural",
"location": "Sixth Glacier"
},
"meta": {
"instagram_id": "DSJfGV6gM_t"
}
}
]
Raw
prompt.md

You will receive unstructured data blocks describing fantasy items (weapons, relics, artifacts, etc). Your task is to normalize ALL data into a strict, consistent JSON format, following the schema below.

📌 GLOBAL RULES

  • Output ONLY valid JSON

  • ALL field names AND values MUST be in ENGLISH

  • Translate any non-English content to English

  • Normalize ALL items to the same structure

  • NEVER omit fields — all fields must exist

  • If data is missing:

    • use 0 for numbers
    • use "" for strings
    • use [] for arrays

  • Interpret narrative descriptions into structured data

  • You may infer reasonable values when needed

  • If new types of data appear, incorporate them without breaking the structure, using:

    • modifiers
    • special_effects
    • tags
    • or semantically expanding existing fields

🧱 REQUIRED SCHEMA

{
  "id": "string",
  "name": "string",

  "category": "weapon | relic | artifact | accessory",
  "subtype": "staff | wand | sword | orb | totem | bow | slingshot | other",

  "rarity": "common | uncommon | rare | epic | legendary | mythic | unique | divine",

  "primary_class": "string",
  "tags": ["string"],

  "description": "string",
  "lore": "string",

  "status": {
    "attack": 0,
    "defense": 0,
    "magic": 0,
    "support": 0,
    "mobility": 0,
    "control": 0
  },

  "attributes": {
    "strength": 0,
    "dexterity": 0,
    "intelligence": 0,
    "vitality": 0,
    "spirit": 0,
    "luck": 0
  },

  "modifiers": [
    {
      "type": "damage | defense | healing | crit | speed | utility",
      "value": 0,
      "unit": "flat | percent",
      "condition": "string"
    }
  ],

  "passives": [
    {
      "name": "string",
      "effect": "string",
      "condition": "string"
    }
  ],

  "abilities": [
    {
      "name": "string",
      "type": "active | ultimate",
      "effect": "string",
      "cooldown": 0,
      "cooldown_unit": "s | min | h | none"
    }
  ],

  "special_effects": ["string"],
  "restrictions": ["string"],

  "origin": {
    "type": "natural | forged | divine | unknown",
    "location": "string"
  },

  "meta": {
    "instagram_id": "string"
  }
}

🔄 NORMALIZATION RULES

  • Star ratings (★★★★★) → numeric values (e.g. 5)

  • Percent values → value + "percent"

  • Direct values → "flat"

  • Convert vague text into:

    • effect
    • condition

  • Cooldowns must be numeric + separate unit

  • Always separate:

    • passives ≠ abilities

  • Convert any bonuses into modifiers whenever possible

🧠 INTERPRETATION RULES

  • Correctly classify:

    • category
    • subtype
    • rarity

  • Extract as much structured data as possible

  • If something is too unique → use special_effects

  • If there are costs, risks, or limitations → use restrictions

📥 INPUT

(paste the raw data blocks here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment