Takeout

Select the region you want to get data for

(If you do not see the region you want, please prod KittyAshley on discord!)

Select the fields you want to get

Element ID
Part ID
Colour ID
Element Name
Price
Delivery Channel
In Stock
Categories
Maximum Order Quantity
System
Created
Modified
Image URL
Availability

Select the options for the data

Include MIA
Include System LEGO
Include System DUPLO
Include System Technic

What's this about

This allows you to get a copy of the data that LEGO's PAB has, but in a CSV. You can choose any of the columns you'd like, choose a region, and pick some extras. Things to note:

  • All times and dates are UTC, irrespective of which region you've selected
  • MIA will include a set of data that was accidentally uploaded to PAB in late 2024. This includes parts that maybe should'nt've been on PAB
  • The CSV uses a small set of acronyms for the deliveryChannel:
    • PAB: Bestseller
    • BAP: Standard
    • MIA: Removed from PAB
    • blank: Currently out of stock
  • For MIA items, the modified date is when they were last seen on PAB
  • The imageUrl column is not often used, but is a pointer to a specific CDN entry vs using the standard lod5photo/photoreal URLs we know. Every element should have the latter, but the imageUrl will be blank for most items in the data
  • For UK and US data, it's updated every 15 minutes. For AU, CA, & NO, it's updated daily
  • If you wish to automate fetching this data, keep in mind the refresh frequencies noted. Once per day for most usages should be fine, and if you want more up-to-date data, you might want to look into implementing the GraphQL calls that PAB itself makes
©2026 LBS