Initial Public Release v1.0.0

master_column_clusters.v1.0.0.json

Initial Public Release - v1.0.0

🎉 Overview

We're excited to announce the first public release of the Master Column Clusters dataset! This authoritative, canonical dataset solves the universal problem of inconsistent column naming across systems by providing a comprehensive "translation dictionary" for column names across multiple business domains.

🚀 What's New

• Initial release of the canonical column name variations database
• 5 business domains covered with comprehensive mappings
• 56 canonical clusters representing core data concepts
• 309 column name variations mapped to their canonical equivalents
• Structured JSON format for easy integration into any system

📊 Dataset Statistics

Metric	Count
Business Domains	5
Canonical Clusters	56
Column Name Variations	309
Total Mappings	309

🏗️ Domains Covered

1. 🛒 E-commerce (14 concepts) - Product data, inventory, pricing
2. 👥 CRM (11 concepts) - Customer management, contact information
3. 💰 Financial (8 concepts) - Transactions, accounts, balances
4. 🚚 Logistics (10 concepts) - Shipping, tracking, delivery
5. 🏥 Healthcare (13 concepts) - Patient records, medical data

🎯 Key Features

• Real-World Data: Mappings derived from millions of production records across global platforms
• Canonical Structure: Authoritative naming that serves as a single source of truth
• Machine-Readable: Clean JSON format with hierarchical domain organization
• Version Controlled: Follows semantic versioning with backward compatibility guarantees
• Open License: CC BY 4.0 for both commercial and non-commercial use

🛠️ Quick Start

1. Download the master_column_clusters.v1.0.0.json file
2. Load in your preferred language (Python example below)
3. Start mapping column names to their canonical equivalents

import json

# Load the dataset
with open('master_column_clusters.v1.0.0.json', 'r') as f:
    column_clusters = json.load(f)

# Find all variations for 'product_id'
variations = column_clusters["ecommerce"]["product_id"]
print(f"All names that mean 'product_id': {variations}")

🔗 Resources
Documentation: Project Landing Page

Source Code: GitHub Repository

License: CC BY 4.0

📄 License
This dataset is licensed under the Creative Commons Attribution 4.0 International (CC BY 4.0) license. You are free to share and adapt the material for any purpose, even commercially, with appropriate attribution.

Copyright (c) 2026 Jason "Soo Ji" Dano | Peper Cruz

🙏 Acknowledgments
Special thanks to the thousands of real-world systems and data sources that informed these mappings, and to the data professionals who will use this resource to solve integration challenges.

Dataset Status: ✅ Production Ready • 🔄 Version Controlled • 📜 CC BY 4.0 Licensed