Shopping at LEGO or Amazon?
Please use our links: LEGO.comAmazon
As an Amazon Associate we earn from qualifying purchases.

Parts browsing

HuwHuw Administrator Posts: 7,087
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 Member Posts: 20,526
    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 Member Posts: 617
    @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 Member Posts: 20,526
    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 Administrator Posts: 7,087
    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 Member Posts: 20,526
    ^ 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 Administrator Posts: 7,087
    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 Member Posts: 3,037
    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 Administrator Posts: 7,087
    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.

Shopping at or Amazon?

Please use our links: Amazon

Recent discussions Categories Privacy Policy

Howdy, Stranger!

It looks like you're new here. Sign in or register to get started. is a participant in the Amazon Services LLC Associates Program, the, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.

As an Amazon Associate we earn from qualifying purchases.