# 3 Most Interesting Analytical Questions This Dataset Could Answer Based on the evidence gathered, this boxing championship dataset contains **144 championship records spanning 140+ years (1885-present)** with **47 unique champions** across **131 unique organization/recognition combinations**. Despite data quality challenges (column mislabeling and mixed data types), three compelling analytical questions emerge: ## 1. **How did boxing evolve from unified to fragmented championship governance?** **Why this is interesting:** The dataset captures boxing's institutional transformation from a single "World" champion era to the modern multi-organization landscape. Early records show champions like John L. Sullivan (1885) and James J. Corbett (1892) holding unified "World" titles, while later records reveal fragmentation across NBA, NYSAC, IBU, WBA, WBC, IBF, and WBO. **Data support:** - Early champions (1885-1920s) predominantly show "World" recognition - Later records show combinations like "NBA, NYSAC, and IBU" (1930s) and modern multi-belt scenarios - The dataset documents **131 unique organization/recognition combinations** across just 144 records, indicating significant fragmentation This question reveals how boxing's legitimacy and authority became distributed across competing sanctioning bodies—a unique phenomenon in professional sports. ## 2. **Which champions achieved the longest dominance, and how does reign length compare across eras?** **Why this is interesting:** The dataset contains reign duration data (Days column) ranging from **4,270 days (Joe Louis)** down to **209 days (Max Schmeling)** and shorter. This enables comparison of fighter dominance across the unified era versus the fragmented multi-organization era. **Data support:** - Joe Louis: 4,270 days (1937-1949) with 2 defenses recorded - John L. Sullivan: 2,566 days (1885-1892) with 25 defenses - Jack Johnson: 2,291 days (1908-1915) with 7 defenses - Average reign: **7.3 days** (though this appears to be a data quality issue from step-4) - **22 of 144 records** have parseable duration data This question addresses whether championship longevity declined as the sport fragmented, potentially making titles easier to win but harder to defend across multiple organizations. ## 3. **How common is multi-belt consolidation, and has the "undisputed champion" become rarer over time?** **Why this is interesting:** Modern boxing fans debate the legitimacy of champions who hold only one organization's belt versus "undisputed" champions holding multiple. The Additional_recognition column captures this phenomenon. **Data support:** - **70 of 144 reigns (48.6%)** have additional belt recognition - Early unified era shows single "World" recognition - Mid-era shows combinations like "NBA, NYSAC, and IBU" (1930s) - The dataset spans from unified champions to the modern 4-belt era (WBA/WBC/IBF/WBO) This question quantifies whether belt consolidation has become more difficult over time, directly addressing the sport's ongoing legitimacy crisis. --- ## Data Limitations to Note - **Column mislabeling**: Actual data structure differs from column names (champion names are in "No" column, organizations in "Champion" column, etc.) - **Mixed data types**: Temporal and numeric fields contain text values like "def.", "–", "present" preventing clean parsing - **Incomplete defenses data**: Only **35 of 144 records** have title defense information - **Date parsing challenges**: Begin/end dates are VARCHAR with inconsistent formats Despite these limitations, the dataset's **140-year temporal span** and documentation of **boxing's institutional fragmentation** make it uniquely suited to answer questions about the sport's governance evolution and championship legitimacy—questions that cannot be answered with fight-by-fight data alone.