Collection and Analysing Set of LEGO-Data for Private Purposes

facko

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 LEGO.com from up to (Germany; UK; United States); Instruction Available (Yes
or No);

Bricklink:
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!

Regards,
Facko

Huw

You can use the API to retrieve the data we share: https://brickset.com/article/52666/brickset-web-services

Istokg

For someone who has spent 15 years researching LEGO sets (and produced a collectors guide), you have no idea how long this will take you to complete!!  Good luck!  ;-)