Answers.Body: <p>There are several places you can go to to download a catalog of LEGO parts. All these catalogs use a different part number scheme than LEGO officially uses (due to the fact that until a few years ago, LEGO part information was a company secret). In no particular order:</p>
  
  <ul>
  <li><p><a href="http://www.bricklink.com/catalogDownload.asp" rel="nofollow noreferrer">Bricklink</a>. This is the most expansive catalog, and has a dedicated page for creating a customized download of its catalog (the link I just pasted).</p></li>
  <li><p><a href="http://ldraw.org/parts/latest-parts.html" rel="nofollow noreferrer">LDraw.org</a>. This focuses more on 3D descriptions of the bricks (which might be useful for your program too) but does contain a basic parts list (part number and name). Again, the link I provided takes you straight to a download page.</p></li>
  <li><p><a href="https://rebrickable.com/downloads" rel="nofollow noreferrer">Rebrickable.com</a>. They have several different parts lists, including <a href="https://rebrickable.com/files/pieces.csv.gz" rel="nofollow noreferrer">a list with all parts (direct csv download)</a>. </p></li>
  </ul>
  
  <p>Also note that <a href="https://bricks.stackexchange.com/questions/1781/is-there-a-freely-downloadable-set-and-part-dataset">a similar question has been asked before</a>, and you might get some more info from looking at that question.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-01T14:18:11.727Z
Answers.LastActivityDate: 2017-01-01T14:18:11.727Z
Answers.LastEditDate: 2017-04-13T12:47:56.390Z
Answers.UserDisplayName: Phil B.
Body: <p>(spoilers) I saw The LEGO Movie and when Lucy looked at a Legeo piece she automatically knew it's part number, name, and other information about it. I thought this was really cool, and knew I could do this with a computer program, but how on Earth am I going to find every single LEGO's part number, and name? I have tried websites such as <a href="http://brickset.com" rel="nofollow noreferrer">http://brickset.com</a>, and <a href="http://bricklink.com" rel="nofollow noreferrer">http://bricklink.com</a>, but they organize by category. What I need is a table of all of the LEGO pieces with their part number, and, name. Can anyone help?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-01-01T13:27:44.967Z
Comments.Text: Welcome. What is the problem with the database that BrickLink maintains? Even if they organize by category, since you are a programmer, flattening the categorized list is a few minutes work. Have you tried?
Comments.UserDisplayName: Phil B.
Tags: <bricks-and-pieces>
Title: I need to know every LEGO's part number, name, and a picture of it
UserDisplayName: user8143
ThreadText: # I need to know every LEGO's part number, name, and a picture of it
  
  (Asked by: username_0 on 2017-01-01)
  
  (spoilers) I saw The LEGO Movie and when Lucy looked at a Legeo piece she automatically knew it's part number, name, and other information about it. I thought this was really cool, and knew I could do this with a computer program, but how on Earth am I going to find every single LEGO's part number, and name? I have tried websites such as <http://brickset.com>, and <http://bricklink.com>, but they organize by category. What I need is a table of all of the LEGO pieces with their part number, and, name. Can anyone help?
  
  **Tags:** bricks-and-pieces
  > **Comments:**
  > **username_1**: Welcome. What is the problem with the database that BrickLink maintains? Even if they organize by category, since you are a programmer, flattening the categorized list is a few minutes work. Have you tried?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-01-01. Score: 2
  
  There are several places you can go to to download a catalog of LEGO parts. All these catalogs use a different part number scheme than LEGO officially uses (due to the fact that until a few years ago, LEGO part information was a company secret). In no particular order:
  
  * [Bricklink](http://www.bricklink.com/catalogDownload.asp). This is the most expansive catalog, and has a dedicated page for creating a customized download of its catalog (the link I just pasted).
  * [LDraw.org](http://ldraw.org/parts/latest-parts.html). This focuses more on 3D descriptions of the bricks (which might be useful for your program too) but does contain a basic parts list (part number and name). Again, the link I provided takes you straight to a download page.
  * [Rebrickable.com](https://rebrickable.com/downloads). They have several different parts lists, including [a list with all parts (direct csv download)](https://rebrickable.com/files/pieces.csv.gz).
  
  Also note that [a similar question has been asked before](https://bricks.stackexchange.com/questions/1781/is-there-a-freely-downloadable-set-and-part-dataset), and you might get some more info from looking at that question.
  
  
  ---
  
  