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

Collection and Analysing Set of LEGO-Data for Private Purposes

fackofacko Member Posts: 1
Hi everybody from Germany! 

To kick-start my own personal LEGO project, I am looking to have a full lift
of all Legos between 1949 and 2020. So I have tried to play around on Bricklink,
brickset and rebrickable database. I know that a lot of the data is dynamic not
static and can change within hours. Therefore I would like to set a timeframe
(e.g. today), which will fix the data on that date. For example: “As of 21.02.2021
a total of 245 members own the set and a total of 500 member want it.” Like that
I want to have an yearly overview of the fixed data.

Furthermore I know that not all the data is available for each set, especially
the oldersones. That missing information could be marked as “n/a”. What I am
looking forward is one huge collection of all available data, e.g. in an excel.

The data I am looking forward is as following:

Brickset: Set Number; Set Name; Set Type; Theme Group; Theme; Subtheme; Pieces;
Weight; Minifigs, Amount of Minifigs unique to this set; Designer; RRP (Euro,
USD, GBP); Age Range; Dimensions (x,y,z); Rating (X of 5); Amount of Ratings;
Amount of Reviews; Members own this Set; Members want this Set; Availability
at from up to (Germany; UK; United States); Instruction Available (Yes
or No);

Set Number; Set Name; Amount Lots for Sale; Amount of Sets on Wanted List; Instruction
(Yes or No); Weight of Instruction; Weight of Box; Price Guide Current Items
(New Condition) for Sale Qty Avg Price in USD; Price Guide Last 6 Months Sales
(New Condition) Qty Avg Price in USD; Set Inventory Summary (Lots of Regular
Parts/ Regular Minifigs/Extra Items/Counterparts/Alternative Items AND Totally
Qty of Regular Parts/ Regular Minifigs/Extra Items/Counterparts/Alternative Items);
Part Out Value for Set (Parts and whole Minfigs, New Condition, incl. Instruction,
Box, Extra Parts and Break Sets in Set) in USD;

I want to make clear that this is a private project and the data is not used
for commercial purposes.

I don’t know anything about programming. I know that it is possible to transfer
the data manually (in an Excel). This is of course very complex, which is why
I like to prefer automated solutions. Also with the reason the data again in
e. g. one year to be retrieved. I look forward to your answers and questions!



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.