LEGO Database

The LEGO Parts/Sets/Colors and Inventories of every official LEGO set

@kaggle.rtatman_lego_database

Inventory Parts

@kaggle.rtatman_lego_database.inventory_parts

inventory_id Inventory Id	part_num Part Num	color_id Color Id	quantity Quantity	is_spare Is Spare
1	48379c01	72	1	f
1	48395	7	1	f
1	mcsport6	25	1	f
1	paddle		1	f
3	11816pr0005	78	1	f
3	2343	47	1	f
3	3003	29	1	f
3	30176	2	1	f
3	3020	15	1	f
3	3022	15	2	f


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