Parts browsing

HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,441
edited November 2012 in The Database
So, thanks to @annchir and Lawrence over at the Daily Brick I've now, er, 'extracted' information for some 20,000 parts from and the result is here

All crowd-sourced and dodgy data from BrickLink has been ditched. This is all 100% official, with the following exceptions:

-Colour names are official LEGO names, but converted to proper case.
-Category names are official LEGO names, but I've created some new ones for Duplo, because for example, the Duplo Bricks and the 'System' Bricks categories are both called 'Bricks' (but with a different category number, which isn't exposed through the LEGO CS site). So if a part has 'Duplo' in its description its category is set to 'Duplo ' + category. This hasn't caught all Duplo parts but has most of them.

The entire list can be exported as a CSV at Double-quotes are changed to single-quotes in the part name field to prevent the CSV getting screwed up.

At the moment it, and all other reports for that matter, only includes parts for which there is an image at


  • CCCCCC UKMember Posts: 17,796
    This could be really useful.

    Is it possible to have all similar parts (same category) together. Under reddish brown, I can see a lot of minifig heads together, quite a few torsos, then another load of torsos, etc. Why is it that not all torsos are together?

    Lots of other categories have just one piece or a few pieces in, but the category is repeated many times. For example, there are loads of lines for plates, shouldn't all plates be together?

    And what is up with Chewbacca?

    Is it snowing again?
  • DadsAFOLDadsAFOL USAMember Posts: 616
    @Huw, this will be really helpful as LUGBULK 2013 ramps up. It makes it really easy to see if a part has been produced in a specific color or not.

    On the parts browser, can you add a mouseover text with the color name? Sometimes I can't tell the difference from the TLG CAD colors.

    If you haven't given up on crowdsourcing yet, can we create linking/mapping/translation to BrickLink or "common" values? First I'd like to see translatoin of the color names. Second would be to translate part descriptions. There are some that appear to be just plain typos on Lego's entry. If we can get the linkage down, you could build the cross-reference hyperlinks. "Buy this part on BrickLink"...
  • CCCCCC UKMember Posts: 17,796
    edited November 2012
    It's not a big deal but I note also that set counts are not correct if a part occurs in the CMF range.

    For example the hat / cap feather ... 64647. Too many sets.

    The spartan helmet ... 92158 ... 0 sets
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,441
    When browsing by colour they should be sorted by category, so I'll fix that later.

    Good idea about the mouse overs.

    Not all sets have been inventoried. I think there's something funny about the CMF inventories at so they probable haven't been added. I'll look into it.
  • CCCCCC UKMember Posts: 17,796
    ^ Concerning CMF parts, many are tabulated to appear in no sets, but some appear in 17 sets (I assume it is the 16 minifigs plus the full set).

    Even if it cannot be corrected for CMF, this is still a very useful resource.
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,441
    I've added parts searching to the main search box. It works, but could probably use some refinement to make it more useful so if you have any suggestions, let me know.

    I suspect some means of filtering the search results by category and maybe colour might be useful.
  • AanchirAanchir United StatesMember Posts: 2,803
    Very useful resource indeed! Certainly a lot easier than plugging sets into one-by-one to look up information on them. This will surely help me deepen my knowledge of LEGO colors and maybe even bring that Bricklink-TLG color chart cross-reference up to (relative) completion... not that it will help people too much given how the Bricklink names that specifically refer to one and only one TLG name are few and far between.

    The only possible improvement I could imagine making would be to list also those parts for which pictures do not appear in the database, but alas, I can see why that might be a challenge, since it would be hard to link those parts to sets' inventories.
  • HuwHuw Brickset Towers, Hampshire, UKAdministrator Posts: 6,441
    Next year I will have a crack at making it possible to verify parts lists and enter any that are missing, armed with the list at the back of the instructions. It won't solve the missing image issue but at least we'll know what they are.

    I suspect that LEGO will get better at providing accurage inventories for current sets so maybe it won't be such an issue going forwards.
  • PhiloPhilo Member Posts: 5
    Congratulations, this ressource is tremendously useful! Thanks a lot for creating it.
Sign In or Register to comment.
Recent discussions Categories Privacy Policy