Skip to content
← Back to Selected Work

Case Study

Sebiche Celeste: From Scattered Football Data to a Trusted Historical Source

I standardized and structured decades of Sporting Cristal match data, turning fragmented records into a reliable system the community can actually use.

Dispersed historical records → clear answers in seconds
Timeline: 90s archive + consolidation through 2026Role: Data curation, standardization, product executionTools: JSON, React, data visualizationContext: Independent initiative with real user value

How might we

How might we help passionate fans reconnect with their club's history so that no significant match, moment, or achievement disappears into scattered and unreliable records?

01 - The Challenge

Sporting Cristal's 90s history mattered, but the information was fragmented: outdated records, mismatched match sheets, old magazines, and no single source of truth to answer simple questions fast.

Primary user

Fans and community members who want trustworthy historical context: what happened on this date, head-to-head performance, seasonal outcomes, and country-level match history.

“There was no unified source of truth. The data existed, but it was disconnected and inconsistent.”

02 - The Approach

An iterative technical pipeline to clean, normalize, classify, and publish static historical data.

Collect sourcesFix inconsistenciesNormalize teams and tournamentsClassify by analytical dimensionsShip practical visual modules
  • Insight 1: Without taxonomy and standards, historical analysis does not scale.
  • Insight 2: Strong data structure directly reduces friction for end users.
  • Insight 3: Date-based and comparative views turn archives into recurring usage.

03 - The Solution

A web product with dedicated historical modules and dual themes (light/dark), allowing users to explore the same data through multiple perspectives.

EFEMERIDES - Day
DASHBOARD - Night
AÑO - Day
RIVALES (Alianza Lima, 2016) - Night
PAISES (Argentina, 1997) - Day
PAISES (Argentina, 1997) - Night

04 - The Impact

Measurable outcomes from turning fragmented archives into a structured, explorable historical product.

1904historical matches structured into a queryable dataset
6exploration modules built around real fan questions
2visual themes (light and dark) for continuous usage
1unified source of truth replacing fragmented records

Community validation

Sporting Cristal's community valued this work because it consolidated scattered historical information into one clear, consistent, and trusted reference point.

  • Data normalization is a product advantage, not just backend housekeeping.
  • In historical products, traceability of criteria matters as much as data volume.
  • Reliable data plus clear storytelling turns archives into active community memory.

This was not a formal company assignment, but it was executed as serious end-to-end product work with measurable user impact.