LEGO Repairability Dataset — BrickMissing
==========================================

Two CSV files quantifying how replaceable LEGO parts are, underlying the
study "Half of All LEGO Part + Color Combinations Exist in Only One Set":
https://www.brickmissing.com/blog/lego-repairability-study

Files
-----

1. lego-part-color-frequency.csv (~91,500 rows)
   Every part+color combination LEGO has ever put in a set, with the number
   of distinct sets it appears in across the entire catalog (1949-2026).

   Columns:
   - part_num      Catalog part number (Rebrickable numbering)
   - part_name     Part name from the catalog
   - color_id      Rebrickable color id
   - color_name    Color name
   - sets_count    Number of distinct sets this part+color appears in,
                   spare parts excluded

2. lego-repairability-sets.csv (~11,900 rows)
   A per-set repairability score for every real building set that meets the
   statistical threshold (30+ parts and 15+ distinct part+color combinations).

   Columns:
   - set_num                  Set number incl. variant (e.g. "10316-1")
   - name                     Set name
   - year                     Release year
   - theme                    Theme name
   - num_parts                Part count
   - part_color_combos        Distinct part+color combinations in the set
   - hard_to_replace_combos   Combinations appearing in <= 3 sets in all of
                              LEGO history ("hard to replace")
   - hard_to_replace_pct      hard_to_replace_combos / part_color_combos * 100

Methodology
-----------

A part+color combination counts as "hard to replace" when it appears in
three or fewer sets in the entire catalog: with that few donor sets,
second-hand sourcing is practically impossible. Spare parts are excluded
throughout. Minifigures are separate entities in the data model (following
Rebrickable), so minifig component parts are largely absent (<1% of rows).
Sets from the last ~2 years have had less time for their parts to reappear
in future sets, which slightly inflates their scores.

Full methodology, caveats and findings:
https://www.brickmissing.com/blog/lego-repairability-study

Source and freshness
--------------------

Built from the BrickMissing catalog database, which is based on Rebrickable
catalog data (https://rebrickable.com) plus our own curation, and is updated
daily as new sets are released. This export is a snapshot (July 2026);
counts may drift slightly from the June 2026 snapshot used in the published
study as the catalog grows.

Citation
--------

Archived on Zenodo with a DOI, so it can be cited:

  BrickMissing (2026). LEGO Repairability Dataset: part+colour scarcity across
  the official catalog, 1949-2026. https://doi.org/10.5281/zenodo.21610502

That DOI always resolves to the newest snapshot. To cite this exact July 2026
snapshot, use https://doi.org/10.5281/zenodo.21610503 instead.

License
-------

Creative Commons Attribution 4.0 (CC BY 4.0).
Please credit "BrickMissing (brickmissing.com), built on Rebrickable catalog
data" and link to the study above.

Contact: robertvandijk314@gmail.com