Name: LEGO Database
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

LEGO Database

Context:

LEGO is a popular brand of toy building bricks. They are often sold in sets with in order to build a specific object. Each set contains a number of parts in different shapes, sizes and colors. This database contains information on which parts are included in different LEGO sets. It was originally compiled to help people who owned some LEGO sets already figure out what other sets they could build with the pieces they had.

Content:

This dataset contains the LEGO Parts/Sets/Colors and Inventories of every official LEGO set in the Rebrickable database. These files are current as of July 2017. If you need it to be more recent data, you can use Rebrickable’s API which provides up to date data, and additional features.

Acknowledgements:

This dataset was compiled by Rebrickable, which is a website to help identify what LEGO sets can be built given bricks and pieces from other LEGO sets. You can use these files for any purpose.

Inspiration:

This is a very rich dataset that offers lots of rooms for exploration, especially since the “sets” file includes the year in which a set was first released.

How have the size of sets changed over time?
What colors are associated with witch themes? Could you predict which theme a set is from just by the bricks it contains?
What sets have the most-used pieces in them? What sets have the rarest pieces in them?
Have the colors of LEGOs included in sets changed over time?

Tables

Colors

@kaggle.rtatman_lego_database.colors

6.04 KB
135 rows
4 columns


CREATE TABLE colors (
  "id" BIGINT,
  "name" VARCHAR,
  "rgb" VARCHAR,
  "is_trans" VARCHAR
);

Inventories

@kaggle.rtatman_lego_database.inventories

157.84 KB
11681 rows
3 columns


CREATE TABLE inventories (
  "id" BIGINT,
  "version" BIGINT,
  "set_num" VARCHAR
);

Inventory Parts

@kaggle.rtatman_lego_database.inventory_parts

2.08 MB
580251 rows
5 columns


CREATE TABLE inventory_parts (
  "inventory_id" BIGINT,
  "part_num" VARCHAR,
  "color_id" BIGINT,
  "quantity" BIGINT,
  "is_spare" VARCHAR
);

Inventory Sets

@kaggle.rtatman_lego_database.inventory_sets

22.74 KB
2846 rows
3 columns


CREATE TABLE inventory_sets (
  "inventory_id" BIGINT,
  "set_num" VARCHAR,
  "quantity" BIGINT
);

Part Categories

@kaggle.rtatman_lego_database.part_categories

3.19 KB
57 rows
2 columns


CREATE TABLE part_categories (
  "id" BIGINT,
  "name" VARCHAR
);

Parts

@kaggle.rtatman_lego_database.parts

794.76 KB
25993 rows
3 columns


CREATE TABLE parts (
  "part_num" VARCHAR,
  "name" VARCHAR,
  "part_cat_id" BIGINT
);

Sets

@kaggle.rtatman_lego_database.sets

280.17 KB
11673 rows
5 columns


CREATE TABLE sets (
  "set_num" VARCHAR,
  "name" VARCHAR,
  "year" BIGINT,
  "theme_id" BIGINT,
  "num_parts" BIGINT
);

Themes

@kaggle.rtatman_lego_database.themes

11.29 KB
614 rows
3 columns


CREATE TABLE themes (
  "id" BIGINT,
  "name" VARCHAR,
  "parent_id" DOUBLE
);